| commit | author | age | ||
| 4e17e6 | 1 | -- RoundCube Webmail initial database structure |
| f7bfec | 2 | -- Version 0.1-beta2 |
| 4e17e6 | 3 | -- |
| T | 4 | |
| 5 | -- -------------------------------------------------------- | |
| 6 | ||
| 7 | -- | |
| 8 | -- Table structure for table `cache` | |
| 9 | -- | |
| 10 | ||
| 11 | CREATE TABLE `cache` ( | |
| 12 | `cache_id` int(10) unsigned NOT NULL auto_increment, | |
| 13 | `user_id` int(10) unsigned NOT NULL default '0', | |
| 1cded8 | 14 | `session_id` varchar(40) default NULL, |
| 4e17e6 | 15 | `cache_key` varchar(128) NOT NULL default '', |
| T | 16 | `created` datetime NOT NULL default '0000-00-00 00:00:00', |
| 17 | `data` longtext NOT NULL, | |
| 18 | PRIMARY KEY (`cache_id`), | |
| 19 | KEY `user_id` (`user_id`), | |
| 20 | KEY `cache_key` (`cache_key`), | |
| 21 | KEY `session_id` (`session_id`) | |
| 535da2 | 22 | ); |
| 4e17e6 | 23 | |
| T | 24 | -- -------------------------------------------------------- |
| 25 | ||
| 26 | -- | |
| 27 | -- Table structure for table `contacts` | |
| 28 | -- | |
| 29 | ||
| 30 | CREATE TABLE `contacts` ( | |
| 31 | `contact_id` int(10) unsigned NOT NULL auto_increment, | |
| 32 | `user_id` int(10) unsigned NOT NULL default '0', | |
| e447cb | 33 | `changed` datetime NOT NULL default '0000-00-00 00:00:00', |
| 1cded8 | 34 | `del` tinyint(1) NOT NULL default '0', |
| 4e17e6 | 35 | `name` varchar(128) NOT NULL default '', |
| T | 36 | `email` varchar(128) NOT NULL default '', |
| 64009e | 37 | `firstname` varchar(128) NOT NULL default '', |
| T | 38 | `surname` varchar(128) NOT NULL default '', |
| 4e17e6 | 39 | `vcard` text NOT NULL, |
| T | 40 | PRIMARY KEY (`contact_id`), |
| 41 | KEY `user_id` (`user_id`) | |
| 535da2 | 42 | ); |
| 4e17e6 | 43 | |
| T | 44 | -- -------------------------------------------------------- |
| 45 | ||
| 46 | -- | |
| 47 | -- Table structure for table `identities` | |
| 48 | -- | |
| 49 | ||
| 50 | CREATE TABLE `identities` ( | |
| 51 | `identity_id` int(10) unsigned NOT NULL auto_increment, | |
| 52 | `user_id` int(10) unsigned NOT NULL default '0', | |
| 1cded8 | 53 | `del` tinyint(1) NOT NULL default '0', |
| T | 54 | `standard` tinyint(1) NOT NULL default '0', |
| 4e17e6 | 55 | `name` varchar(128) NOT NULL default '', |
| T | 56 | `organization` varchar(128) NOT NULL default '', |
| 57 | `email` varchar(128) NOT NULL default '', | |
| 58 | `reply-to` varchar(128) NOT NULL default '', | |
| 59 | `bcc` varchar(128) NOT NULL default '', | |
| 60 | `signature` text NOT NULL, | |
| a0109c | 61 | `html_signature` tinyint(1) NOT NULL default '0', |
| 4e17e6 | 62 | PRIMARY KEY (`identity_id`), |
| T | 63 | KEY `user_id` (`user_id`) |
| 535da2 | 64 | ); |
| 4e17e6 | 65 | |
| T | 66 | -- -------------------------------------------------------- |
| 67 | ||
| 68 | -- | |
| 69 | -- Table structure for table `session` | |
| 70 | -- | |
| 71 | ||
| 72 | CREATE TABLE `session` ( | |
| e0ddd4 | 73 | `sess_id` varchar(40) NOT NULL default '', |
| 4e17e6 | 74 | `created` datetime NOT NULL default '0000-00-00 00:00:00', |
| T | 75 | `changed` datetime NOT NULL default '0000-00-00 00:00:00', |
| 42b113 | 76 | `ip` VARCHAR(15) NOT NULL default '', |
| 4e17e6 | 77 | `vars` text NOT NULL, |
| T | 78 | PRIMARY KEY (`sess_id`) |
| 535da2 | 79 | ); |
| 4e17e6 | 80 | |
| T | 81 | -- -------------------------------------------------------- |
| 82 | ||
| 83 | -- | |
| 84 | -- Table structure for table `users` | |
| 85 | -- | |
| 86 | ||
| 87 | CREATE TABLE `users` ( | |
| 88 | `user_id` int(10) unsigned NOT NULL auto_increment, | |
| 89 | `username` varchar(128) NOT NULL default '', | |
| 42b113 | 90 | `mail_host` varchar(128) NOT NULL default '', |
| T | 91 | `alias` varchar(128) NOT NULL default '', |
| 4e17e6 | 92 | `created` datetime NOT NULL default '0000-00-00 00:00:00', |
| T | 93 | `last_login` datetime NOT NULL default '0000-00-00 00:00:00', |
| 94 | `language` varchar(5) NOT NULL default 'en', | |
| 15a9d1 | 95 | `preferences` text NOT NULL default '', |
| 4e17e6 | 96 | PRIMARY KEY (`user_id`) |
| 535da2 | 97 | ); |
| 1cded8 | 98 | |
| T | 99 | -- -------------------------------------------------------- |
| 100 | ||
| 101 | -- | |
| 102 | -- Table structure for table `messages` | |
| 103 | -- | |
| 104 | ||
| 105 | CREATE TABLE `messages` ( | |
| 106 | `message_id` int(11) unsigned NOT NULL auto_increment, | |
| 107 | `user_id` int(11) unsigned NOT NULL default '0', | |
| 108 | `del` tinyint(1) NOT NULL default '0', | |
| 109 | `cache_key` varchar(128) NOT NULL default '', | |
| c6e808 | 110 | `created` datetime NOT NULL default '0000-00-00 00:00:00', |
| 1cded8 | 111 | `idx` int(11) unsigned NOT NULL default '0', |
| T | 112 | `uid` int(11) unsigned NOT NULL default '0', |
| 113 | `subject` varchar(255) NOT NULL default '', | |
| 114 | `from` varchar(255) NOT NULL default '', | |
| 115 | `to` varchar(255) NOT NULL default '', | |
| 116 | `cc` varchar(255) NOT NULL default '', | |
| 117 | `date` datetime NOT NULL default '0000-00-00 00:00:00', | |
| 118 | `size` int(11) unsigned NOT NULL default '0', | |
| 119 | `headers` text NOT NULL, | |
| f7bfec | 120 | `structure` text, |
| 1cded8 | 121 | PRIMARY KEY (`message_id`), |
| T | 122 | KEY `user_id` (`user_id`), |
| 123 | KEY `idx` (`idx`), | |
| f7bfec | 124 | KEY `uid` (`uid`), |
| 43a42d | 125 | UNIQUE `uniqueness` (`user_id`, `cache_key`, `uid`) |
| 535da2 | 126 | ); |
| 1cded8 | 127 | |
| T | 128 | |
