| commit | author | age | ||
| b7e7c8 | 1 | -- Updates from version 0.1-stable to 0.1.1 |
| AM | 2 | |
| 3 | DROP TABLE messages; | |
| 4 | ||
| 5 | CREATE TABLE messages ( | |
| 6 | message_id integer NOT NULL PRIMARY KEY, | |
| 7 | user_id integer NOT NULL default '0', | |
| 8 | del tinyint NOT NULL default '0', | |
| 9 | cache_key varchar(128) NOT NULL default '', | |
| 10 | created datetime NOT NULL default '0000-00-00 00:00:00', | |
| 11 | idx integer NOT NULL default '0', | |
| 12 | uid integer NOT NULL default '0', | |
| 13 | subject varchar(255) NOT NULL default '', | |
| 14 | "from" varchar(255) NOT NULL default '', | |
| 15 | "to" varchar(255) NOT NULL default '', | |
| 16 | "cc" varchar(255) NOT NULL default '', | |
| 17 | "date" datetime NOT NULL default '0000-00-00 00:00:00', | |
| 18 | size integer NOT NULL default '0', | |
| 19 | headers text NOT NULL, | |
| 20 | structure text | |
| 21 | ); | |
| 22 | ||
| 23 | CREATE INDEX ix_messages_user_cache_uid ON messages(user_id,cache_key,uid); | |
| 24 | CREATE INDEX ix_users_username ON users(username); | |
| 25 | CREATE INDEX ix_users_alias ON users(alias); | |
