| commit | author | age | ||
| e019f2 | 1 | -- Roundcube Webmail initial database structure |
| 79fe17 | 2 | |
| T | 3 | -- |
| 4 | -- Table structure for table `cache` | |
| 5 | -- | |
| 6 | ||
| 7 | CREATE TABLE cache ( | |
| 8 | cache_id integer NOT NULL PRIMARY KEY, | |
| 9 | user_id integer NOT NULL default 0, | |
| 10 | cache_key varchar(128) NOT NULL default '', | |
| 11 | created datetime NOT NULL default '0000-00-00 00:00:00', | |
| 12 | data longtext NOT NULL | |
| 13 | ); | |
| 14 | ||
| ac26b9 | 15 | CREATE INDEX ix_cache_user_cache_key ON cache(user_id, cache_key); |
| e4d9f0 | 16 | CREATE INDEX ix_cache_created ON cache(created); |
| 1cded8 | 17 | |
| 79fe17 | 18 | |
| T | 19 | -- -------------------------------------------------------- |
| 20 | ||
| 21 | -- | |
| a61bbb | 22 | -- Table structure for table contacts and related |
| 79fe17 | 23 | -- |
| T | 24 | |
| 25 | CREATE TABLE contacts ( | |
| 26 | contact_id integer NOT NULL PRIMARY KEY, | |
| 27 | user_id integer NOT NULL default '0', | |
| 58e360 | 28 | changed datetime NOT NULL default '0000-00-00 00:00:00', |
| 1cded8 | 29 | del tinyint NOT NULL default '0', |
| 79fe17 | 30 | name varchar(128) NOT NULL default '', |
| T | 31 | email varchar(128) NOT NULL default '', |
| 32 | firstname varchar(128) NOT NULL default '', | |
| 33 | surname varchar(128) NOT NULL default '', | |
| 34 | vcard text NOT NULL default '' | |
| 35 | ); | |
| 36 | ||
| 23b765 | 37 | CREATE INDEX ix_contacts_user_id ON contacts(user_id, email); |
| 79fe17 | 38 | |
| a61bbb | 39 | |
| T | 40 | CREATE TABLE contactgroups ( |
| 41 | contactgroup_id integer NOT NULL PRIMARY KEY, | |
| 42 | user_id integer NOT NULL default '0', | |
| 43 | changed datetime NOT NULL default '0000-00-00 00:00:00', | |
| 44 | del tinyint NOT NULL default '0', | |
| 45 | name varchar(128) NOT NULL default '' | |
| 46 | ); | |
| 47 | ||
| 48 | CREATE INDEX ix_contactgroups_user_id ON contactgroups(user_id, del); | |
| 49 | ||
| 50 | ||
| 51 | CREATE TABLE contactgroupmembers ( | |
| 52 | contactgroup_id integer NOT NULL, | |
| 53 | contact_id integer NOT NULL default '0', | |
| 54 | created datetime NOT NULL default '0000-00-00 00:00:00', | |
| 55 | PRIMARY KEY (contactgroup_id, contact_id) | |
| 56 | ); | |
| 57 | ||
| 58 | ||
| 79fe17 | 59 | -- -------------------------------------------------------- |
| T | 60 | |
| 61 | -- | |
| 62 | -- Table structure for table identities | |
| 63 | -- | |
| 64 | ||
| 65 | CREATE TABLE identities ( | |
| 66 | identity_id integer NOT NULL PRIMARY KEY, | |
| 67 | user_id integer NOT NULL default '0', | |
| a35062 | 68 | changed datetime NOT NULL default '0000-00-00 00:00:00', |
| 1cded8 | 69 | del tinyint NOT NULL default '0', |
| T | 70 | standard tinyint NOT NULL default '0', |
| 79fe17 | 71 | name varchar(128) NOT NULL default '', |
| 1cded8 | 72 | organization varchar(128) default '', |
| 79fe17 | 73 | email varchar(128) NOT NULL default '', |
| T | 74 | "reply-to" varchar(128) NOT NULL default '', |
| 75 | bcc varchar(128) NOT NULL default '', | |
| a0109c | 76 | signature text NOT NULL default '', |
| S | 77 | html_signature tinyint NOT NULL default '0' |
| 79fe17 | 78 | ); |
| T | 79 | |
| 94fe9c | 80 | CREATE INDEX ix_identities_user_id ON identities(user_id, del); |
| 79fe17 | 81 | |
| T | 82 | |
| 83 | -- -------------------------------------------------------- | |
| 84 | ||
| 85 | -- | |
| 86 | -- Table structure for table users | |
| 87 | -- | |
| 88 | ||
| 89 | CREATE TABLE users ( | |
| 90 | user_id integer NOT NULL PRIMARY KEY, | |
| 91 | username varchar(128) NOT NULL default '', | |
| 92 | mail_host varchar(128) NOT NULL default '', | |
| 93 | alias varchar(128) NOT NULL default '', | |
| 94 | created datetime NOT NULL default '0000-00-00 00:00:00', | |
| e2402e | 95 | last_login datetime DEFAULT NULL, |
| debdda | 96 | language varchar(5), |
| 79fe17 | 97 | preferences text NOT NULL default '' |
| T | 98 | ); |
| 1cded8 | 99 | |
| 6cb778 | 100 | CREATE INDEX ix_users_username ON users(username); |
| A | 101 | CREATE INDEX ix_users_alias ON users(alias); |
| 1cded8 | 102 | |
| T | 103 | -- -------------------------------------------------------- |
| 104 | ||
| 105 | -- | |
| 106 | -- Table structure for table session | |
| 107 | -- | |
| 108 | ||
| 109 | CREATE TABLE session ( | |
| 110 | sess_id varchar(40) NOT NULL PRIMARY KEY, | |
| 111 | created datetime NOT NULL default '0000-00-00 00:00:00', | |
| 112 | changed datetime NOT NULL default '0000-00-00 00:00:00', | |
| 84d06e | 113 | ip varchar(40) NOT NULL default '', |
| 1cded8 | 114 | vars text NOT NULL |
| T | 115 | ); |
| 116 | ||
| 3e48d2 | 117 | CREATE INDEX ix_session_changed ON session (changed); |
| 1cded8 | 118 | |
| T | 119 | -- -------------------------------------------------------- |
| 120 | ||
| 121 | -- | |
| 122 | -- Table structure for table messages | |
| 123 | -- | |
| 124 | ||
| 125 | CREATE TABLE messages ( | |
| 126 | message_id integer NOT NULL PRIMARY KEY, | |
| 127 | user_id integer NOT NULL default '0', | |
| 128 | del tinyint NOT NULL default '0', | |
| 129 | cache_key varchar(128) NOT NULL default '', | |
| b59474 | 130 | created datetime NOT NULL default '0000-00-00 00:00:00', |
| 1cded8 | 131 | idx integer NOT NULL default '0', |
| T | 132 | uid integer NOT NULL default '0', |
| 133 | subject varchar(255) NOT NULL default '', | |
| 134 | "from" varchar(255) NOT NULL default '', | |
| 135 | "to" varchar(255) NOT NULL default '', | |
| ac26b9 | 136 | "cc" varchar(255) NOT NULL default '', |
| T | 137 | "date" datetime NOT NULL default '0000-00-00 00:00:00', |
| 1cded8 | 138 | size integer NOT NULL default '0', |
| T | 139 | headers text NOT NULL, |
| f7bfec | 140 | structure text |
| 1cded8 | 141 | ); |
| T | 142 | |
| 3d601d | 143 | CREATE UNIQUE INDEX ix_messages_user_cache_uid ON messages (user_id,cache_key,uid); |
| A | 144 | CREATE INDEX ix_messages_index ON messages (user_id,cache_key,idx); |
| c98f3b | 145 | CREATE INDEX ix_messages_created ON messages (created); |
