1 -- RoundCube Webmail initial database structure
5 -- --------------------------------------------------------
8 -- Table structure for table `cache`
11 CREATE TABLE `cache` (
12 `cache_id` int(10) unsigned NOT NULL auto_increment,
13 `user_id` int(10) unsigned NOT NULL default '0',
14 `session_id` varchar(40) default NULL,
15 `cache_key` varchar(128) NOT NULL default '',
16 `created` datetime NOT NULL default '0000-00-00 00:00:00',
17 `data` longtext NOT NULL,
18 PRIMARY KEY (`cache_id`),
19 INDEX `user_cache_index` (`user_id`,`cache_key`)
22 -- --------------------------------------------------------
25 -- Table structure for table `contacts`
28 CREATE TABLE `contacts` (
29 `contact_id` int(10) unsigned NOT NULL auto_increment,
30 `user_id` int(10) unsigned NOT NULL default '0',
31 `changed` datetime NOT NULL default '0000-00-00 00:00:00',
32 `del` tinyint(1) NOT NULL default '0',
33 `name` varchar(128) NOT NULL default '',
34 `email` varchar(128) NOT NULL default '',
35 `firstname` varchar(128) NOT NULL default '',
36 `surname` varchar(128) NOT NULL default '',
37 `vcard` text NOT NULL,
38 PRIMARY KEY (`contact_id`),
39 KEY `user_id` (`user_id`)
42 -- --------------------------------------------------------
45 -- Table structure for table `identities`
48 CREATE TABLE `identities` (
49 `identity_id` int(10) unsigned NOT NULL auto_increment,
50 `user_id` int(10) unsigned NOT NULL default '0',
51 `del` tinyint(1) NOT NULL default '0',
52 `standard` tinyint(1) NOT NULL default '0',
53 `name` varchar(128) NOT NULL default '',
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,
59 `html_signature` tinyint(1) NOT NULL default '0',
60 PRIMARY KEY (`identity_id`),
61 KEY `user_id` (`user_id`)
64 -- --------------------------------------------------------
67 -- Table structure for table `session`
70 CREATE TABLE `session` (
71 `sess_id` varchar(40) NOT NULL default '',
72 `created` datetime NOT NULL default '0000-00-00 00:00:00',
73 `changed` datetime NOT NULL default '0000-00-00 00:00:00',
74 `ip` VARCHAR(40) NOT NULL default '',
76 PRIMARY KEY (`sess_id`)
79 -- --------------------------------------------------------
82 -- Table structure for table `users`
85 CREATE TABLE `users` (
86 `user_id` int(10) unsigned NOT NULL auto_increment,
87 `username` varchar(128) NOT NULL default '',
88 `mail_host` varchar(128) NOT NULL default '',
89 `alias` varchar(128) NOT NULL default '',
90 `created` datetime NOT NULL default '0000-00-00 00:00:00',
91 `last_login` datetime NOT NULL default '0000-00-00 00:00:00',
92 `language` varchar(5) NOT NULL default 'en',
94 PRIMARY KEY (`user_id`)
97 -- --------------------------------------------------------
100 -- Table structure for table `messages`
103 CREATE TABLE `messages` (
104 `message_id` int(11) unsigned NOT NULL auto_increment,
105 `user_id` int(11) unsigned NOT NULL default '0',
106 `del` tinyint(1) NOT NULL default '0',
107 `cache_key` varchar(128) NOT NULL default '',
108 `created` datetime NOT NULL default '0000-00-00 00:00:00',
109 `idx` int(11) unsigned NOT NULL default '0',
110 `uid` int(11) unsigned NOT NULL default '0',
111 `subject` varchar(255) NOT NULL default '',
112 `from` varchar(255) NOT NULL default '',
113 `to` varchar(255) NOT NULL default '',
114 `cc` varchar(255) NOT NULL default '',
115 `date` datetime NOT NULL default '0000-00-00 00:00:00',
116 `size` int(11) unsigned NOT NULL default '0',
117 `headers` text NOT NULL,
119 PRIMARY KEY (`message_id`),
120 UNIQUE `uniqueness` (`user_id`, `cache_key`, `uid`)