diff options
| author |   William Heimbigner <william.heimbigner@gmail.com> | 2015-12-25 00:24:39 +0400 |
|---|---|---|
| committer | William Heimbigner <william.heimbigner@gmail.com> | 2015-12-25 00:24:39 +0400 |
| commit | 85615043fe4f8e76496f39c366ce40a4bbba92b7 (patch) | |
| tree | b3ebcab9f01abebff1b8ae007a724147914defa4 /DATABASE.SCHEMA | |
| parent | c9f53dedf55b0f8bb6e83525dd0c25cdb7881133 (diff) | |
Add indexes to joins table schema
Diffstat (limited to 'DATABASE.SCHEMA')
| -rw-r--r-- | DATABASE.SCHEMA | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/DATABASE.SCHEMA b/DATABASE.SCHEMA index 806ffdf..401d1a9 100644 --- a/DATABASE.SCHEMA +++ b/DATABASE.SCHEMA @@ -63,7 +63,12 @@ CREATE TABLE `joins` ( `host` varchar(63) NOT NULL, `geco` varchar(255) DEFAULT NULL, `account` varchar(16) DEFAULT NULL, - KEY `index` (`index`) + KEY `index` (`index`), + KEY `nick` (`nick`), + KEY `user` (`user`), + KEY `host` (`host`), + KEY `geco` (`geco`), + KEY `account` (`account`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; CREATE TABLE `kick` ( |