| | |
| | | -- RoundCube Webmail initial database structure |
| | | -- Roundcube Webmail initial database structure |
| | | |
| | | -- |
| | | -- Table structure for table `cache` |
| | |
| | | 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 '', |
| | | email varchar(255) NOT NULL default '', |
| | | firstname varchar(128) NOT NULL default '', |
| | | surname varchar(128) NOT NULL default '', |
| | | vcard text NOT NULL default '' |
| | | vcard text NOT NULL default '', |
| | | words text NOT NULL default '' |
| | | ); |
| | | |
| | | CREATE INDEX ix_contacts_user_id ON contacts(user_id, email); |
| | |
| | | created datetime NOT NULL default '0000-00-00 00:00:00', |
| | | PRIMARY KEY (contactgroup_id, contact_id) |
| | | ); |
| | | |
| | | CREATE INDEX ix_contactgroupmembers_contact_id ON contactgroupmembers (contact_id); |
| | | |
| | | |
| | | -- -------------------------------------------------------- |
| | |
| | | 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 NOT NULL default '0000-00-00 00:00:00', |
| | | last_login datetime DEFAULT NULL, |
| | | language varchar(5), |
| | | preferences text NOT NULL default '' |
| | | ); |
| | | |
| | | CREATE INDEX ix_users_username ON users(username); |
| | | CREATE UNIQUE INDEX ix_users_username ON users(username, mail_host); |
| | | CREATE INDEX ix_users_alias ON users(alias); |
| | | |
| | | -- -------------------------------------------------------- |