| | |
| | | ); |
| | | |
| | | CREATE INDEX ix_identities_user_id ON identities(user_id, del); |
| | | CREATE INDEX ix_identities_email ON identities(email, del); |
| | | |
| | | |
| | | -- -------------------------------------------------------- |
| | |
| | | user_id integer NOT NULL PRIMARY KEY, |
| | | username varchar(128) NOT NULL default '', |
| | | mail_host varchar(128) NOT NULL default '', |
| | | alias varchar(128) NOT NULL default '', |
| | | created datetime NOT NULL default '0000-00-00 00:00:00', |
| | | last_login datetime DEFAULT NULL, |
| | | language varchar(5), |
| | |
| | | ); |
| | | |
| | | CREATE UNIQUE INDEX ix_users_username ON users(username, mail_host); |
| | | CREATE INDEX ix_users_alias ON users(alias); |
| | | |
| | | -- -------------------------------------------------------- |
| | | |
| | |
| | | ); |
| | | |
| | | CREATE INDEX ix_cache_messages_changed ON cache_messages (changed); |
| | | |
| | | -- -------------------------------------------------------- |
| | | |
| | | -- |
| | | -- Table structure for table system |
| | | -- |
| | | |
| | | CREATE TABLE system ( |
| | | name varchar(64) NOT NULL PRIMARY KEY, |
| | | value text NOT NULL |
| | | ); |
| | | |
| | | INSERT INTO system (name, value) VALUES ('roundcube-version', '2013011700.sql'); |