From 1b81975f1fb3d1341cad30061dc195581e2264b6 Mon Sep 17 00:00:00 2001
From: raylu <raylu@gridium.com>
Date: Tue, 22 Oct 2013 19:09:51 -0700
Subject: search for alliance and characters too

---
 db/schema.sql | 8 +++++++-
 1 file changed, 7 insertions(+), 1 deletion(-)

(limited to 'db/schema.sql')

diff --git a/db/schema.sql b/db/schema.sql
index 3c632a9..af21bf5 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -30,7 +30,13 @@ CREATE TABLE `characters` (
 	`security_status` float DEFAULT NULL,
 	`weapon_type_id` int DEFAULT NULL,
 	PRIMARY KEY (`id`),
-	CONSTRAINT `fk_char_km` FOREIGN KEY (`kill_id`) REFERENCES `kills` (`kill_id`)
+	CONSTRAINT `fk_char_km` FOREIGN KEY (`kill_id`) REFERENCES `kills` (`kill_id`),
+	INDEX `character_id` (`character_id`),
+	INDEX `character_name` (`character_name`),
+	INDEX `alliance_id` (`alliance_id`),
+	INDEX `alliance_name` (`alliance_name`),
+	INDEX `corporation_id` (`corporation_id`),
+	INDEX `corporation_name` (`corporation_name`),
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
 
 CREATE TABLE `items` (
-- 
cgit v1.2.3

