diff options
Diffstat (limited to 'database.sql')
| -rw-r--r-- | database.sql | 12 |
1 files changed, 4 insertions, 8 deletions
diff --git a/database.sql b/database.sql index 010c63bb2..6824dd1bd 100644 --- a/database.sql +++ b/database.sql @@ -782,16 +782,12 @@ INDEX ( `otype` ) CREATE TABLE IF NOT EXISTS `item_id` ( `iid` INT NOT NULL , `uid` INT NOT NULL , -`face` CHAR( 255 ) NOT NULL , -`dspr` CHAR( 255 ) NOT NULL , -`twit` CHAR( 255 ) NOT NULL , -`stat` CHAR( 255 ) NOT NULL , +`sid` CHAR ( 255 ) NOT NULL, +`service` char ( 255 ) NOT NULL, PRIMARY KEY ( `iid` ), INDEX ( `uid` ), -INDEX ( `face` ), -INDEX ( `dspr` ), -INDEX ( `twit` ), -INDEX ( `stat` ) +INDEX ( `sid` ), +INDEX ( `service` ) ) ENGINE = MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `manage` ( |