| | |
| | | CREATE TABLE contacts ( |
| | | contact_id integer NOT NULL PRIMARY KEY, |
| | | user_id integer NOT NULL default '0', |
| | | created datetime NOT NULL default '0000-00-00 00:00:00', |
| | | changed datetime NOT NULL default '0000-00-00 00:00:00', |
| | | del tinyint NOT NULL default '0', |
| | | name varchar(128) NOT NULL default '', |
| | | email varchar(128) NOT NULL default '', |
| | |
| | | user_id integer NOT NULL default '0', |
| | | del tinyint NOT NULL default '0', |
| | | cache_key varchar(128) NOT NULL default '', |
| | | created datetime NOT NULL default '0000-00-00 00:00:00', |
| | | idx integer NOT NULL default '0', |
| | | uid integer NOT NULL default '0', |
| | | subject varchar(255) NOT NULL default '', |
| | |
| | | |
| | | CREATE INDEX ix_messages_user_id ON messages(user_id); |
| | | CREATE INDEX ix_messages_cache_key ON messages(cache_key); |
| | | CREATE INDEX ix_messages_idx ON messages(idx); |
| | | CREATE INDEX ix_messages_uid ON messages(uid); |