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 KEY `user_id` (`user_id`),
20 KEY `cache_key` (`cache_key`),
21 KEY `session_id` (`session_id`)
24 -- --------------------------------------------------------
27 -- Table structure for table `contacts`
30 CREATE TABLE `contacts` (
31 `contact_id` int(10) unsigned NOT NULL auto_increment,
32 `user_id` int(10) unsigned NOT NULL default '0',
33 `changed` datetime NOT NULL default '0000-00-00 00:00:00',
34 `del` tinyint(1) NOT NULL default '0',
35 `name` varchar(128) NOT NULL default '',
36 `email` varchar(128) NOT NULL default '',
37 `firstname` varchar(128) NOT NULL default '',
38 `surname` varchar(128) NOT NULL default '',
39 `vcard` text NOT NULL,
40 PRIMARY KEY (`contact_id`),
41 KEY `user_id` (`user_id`)
44 -- --------------------------------------------------------
47 -- Table structure for table `identities`
50 CREATE TABLE `identities` (
51 `identity_id` int(10) unsigned NOT NULL auto_increment,
52 `user_id` int(10) unsigned NOT NULL default '0',
53 `del` tinyint(1) NOT NULL default '0',
54 `standard` tinyint(1) NOT NULL default '0',
55 `name` varchar(128) NOT NULL default '',
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,
61 `html_signature` tinyint(1) NOT NULL default '0',
62 PRIMARY KEY (`identity_id`),
63 KEY `user_id` (`user_id`)
66 -- --------------------------------------------------------
69 -- Table structure for table `session`
72 CREATE TABLE `session` (
73 `sess_id` varchar(40) NOT NULL default '',
74 `created` datetime NOT NULL default '0000-00-00 00:00:00',
75 `changed` datetime NOT NULL default '0000-00-00 00:00:00',
76 `ip` VARCHAR(40) NOT NULL default '',
78 PRIMARY KEY (`sess_id`)
81 -- --------------------------------------------------------
84 -- Table structure for table `users`
87 CREATE TABLE `users` (
88 `user_id` int(10) unsigned NOT NULL auto_increment,
89 `username` varchar(128) NOT NULL default '',
90 `mail_host` varchar(128) NOT NULL default '',
91 `alias` varchar(128) NOT NULL default '',
92 `created` datetime NOT NULL default '0000-00-00 00:00:00',
93 `last_login` datetime NOT NULL default '0000-00-00 00:00:00',
94 `language` varchar(5) NOT NULL default 'en',
96 PRIMARY KEY (`user_id`)
99 -- --------------------------------------------------------
102 -- Table structure for table `messages`
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 '',
110 `created` datetime NOT NULL default '0000-00-00 00:00:00',
111 `idx` int(11) unsigned NOT NULL default '0',
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,
121 PRIMARY KEY (`message_id`),
122 KEY `user_id` (`user_id`),
125 UNIQUE `uniqueness` (`user_id`, `cache_key`, `uid`)