diff options
| author | raylu <raylu@gridium.com> | 2013-10-22 19:09:51 -0700 |
|---|---|---|
| committer | raylu <raylu@gridium.com> | 2013-10-22 19:09:51 -0700 |
| commit | 1b81975f1fb3d1341cad30061dc195581e2264b6 (patch) | |
| tree | d60317c056391c100c1bffd09e0db5ce98909460 /db/schema.sql | |
| parent | c7056a2e0d0a61b65199d8d0b5e7b79fb51c3de7 (diff) | |
| download | ykill-1b81975f1fb3d1341cad30061dc195581e2264b6.tar.xz | |
search for alliance and characters too
Diffstat (limited to 'db/schema.sql')
| -rw-r--r-- | db/schema.sql | 8 |
1 files changed, 7 insertions, 1 deletions
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` ( |