| commit | author | age | ||
| 4e17e6 | 1 | -- RoundCube Webmail initial database structure |
| ac26b9 | 2 | -- Version 0.1 |
| 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`), | |
| ac26b9 | 19 | INDEX `user_cache_index` (`user_id`,`cache_key`) |
| 535da2 | 20 | ); |
| 4e17e6 | 21 | |
| T | 22 | -- -------------------------------------------------------- |
| 23 | ||
| 24 | -- | |
| 25 | -- Table structure for table `contacts` | |
| 26 | -- | |
| 27 | ||
| 28 | CREATE TABLE `contacts` ( | |
| 29 | `contact_id` int(10) unsigned NOT NULL auto_increment, | |
| 30 | `user_id` int(10) unsigned NOT NULL default '0', | |
| e447cb | 31 | `changed` datetime NOT NULL default '0000-00-00 00:00:00', |
| 1cded8 | 32 | `del` tinyint(1) NOT NULL default '0', |
| 4e17e6 | 33 | `name` varchar(128) NOT NULL default '', |
| T | 34 | `email` varchar(128) NOT NULL default '', |
| 64009e | 35 | `firstname` varchar(128) NOT NULL default '', |
| T | 36 | `surname` varchar(128) NOT NULL default '', |
| 4e17e6 | 37 | `vcard` text NOT NULL, |
| T | 38 | PRIMARY KEY (`contact_id`), |
| 39 | KEY `user_id` (`user_id`) | |
| 535da2 | 40 | ); |
| 4e17e6 | 41 | |
| T | 42 | -- -------------------------------------------------------- |
| 43 | ||
| 44 | -- | |
| 45 | -- Table structure for table `identities` | |
| 46 | -- | |
| 47 | ||
| 48 | CREATE TABLE `identities` ( | |
| 49 | `identity_id` int(10) unsigned NOT NULL auto_increment, | |
| 50 | `user_id` int(10) unsigned NOT NULL default '0', | |
| 1cded8 | 51 | `del` tinyint(1) NOT NULL default '0', |
| T | 52 | `standard` tinyint(1) NOT NULL default '0', |
| 4e17e6 | 53 | `name` varchar(128) NOT NULL default '', |
| T | 54 | `organization` varchar(128) NOT NULL default '', |
| 55 | `email` varchar(128) NOT NULL default '', | |
| 56 | `reply-to` varchar(128) NOT NULL default '', | |
| 57 | `bcc` varchar(128) NOT NULL default '', | |
| 58 | `signature` text NOT NULL, | |
| a0109c | 59 | `html_signature` tinyint(1) NOT NULL default '0', |
| 4e17e6 | 60 | PRIMARY KEY (`identity_id`), |
| T | 61 | KEY `user_id` (`user_id`) |
| 535da2 | 62 | ); |
| 4e17e6 | 63 | |
| T | 64 | -- -------------------------------------------------------- |
| 65 | ||
| 66 | -- | |
| 67 | -- Table structure for table `session` | |
| 68 | -- | |
| 69 | ||
| 70 | CREATE TABLE `session` ( | |
| e0ddd4 | 71 | `sess_id` varchar(40) NOT NULL default '', |
| 4e17e6 | 72 | `created` datetime NOT NULL default '0000-00-00 00:00:00', |
| T | 73 | `changed` datetime NOT NULL default '0000-00-00 00:00:00', |
| 84d06e | 74 | `ip` VARCHAR(40) NOT NULL default '', |
| 4e17e6 | 75 | `vars` text NOT NULL, |
| T | 76 | PRIMARY KEY (`sess_id`) |
| 535da2 | 77 | ); |
| 4e17e6 | 78 | |
| T | 79 | -- -------------------------------------------------------- |
| 80 | ||
| 81 | -- | |
| 82 | -- Table structure for table `users` | |
| 83 | -- | |
| 84 | ||
| 85 | CREATE TABLE `users` ( | |
| 86 | `user_id` int(10) unsigned NOT NULL auto_increment, | |
| 87 | `username` varchar(128) NOT NULL default '', | |
| 42b113 | 88 | `mail_host` varchar(128) NOT NULL default '', |
| T | 89 | `alias` varchar(128) NOT NULL default '', |
| 4e17e6 | 90 | `created` datetime NOT NULL default '0000-00-00 00:00:00', |
| T | 91 | `last_login` datetime NOT NULL default '0000-00-00 00:00:00', |
| 92 | `language` varchar(5) NOT NULL default 'en', | |
| 112bff | 93 | `preferences` text, |
| 6cb778 | 94 | PRIMARY KEY (`user_id`), |
| A | 95 | INDEX `username_index` (`username`), |
| 96 | INDEX `alias_index` (`alias`) | |
| 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, |
| ac26b9 | 121 | PRIMARY KEY (`message_id`), |
| 43a42d | 122 | UNIQUE `uniqueness` (`user_id`, `cache_key`, `uid`) |
| 535da2 | 123 | ); |
| 1cded8 | 124 | |
| T | 125 | |
