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 PRIMARY KEY (`identity_id`),
62 KEY `user_id` (`user_id`)
65 -- --------------------------------------------------------
68 -- Table structure for table `session`
71 CREATE TABLE `session` (
72 `sess_id` varchar(40) NOT NULL default '',
73 `created` datetime NOT NULL default '0000-00-00 00:00:00',
74 `changed` datetime NOT NULL default '0000-00-00 00:00:00',
75 `ip` VARCHAR(15) NOT NULL default '',
77 PRIMARY KEY (`sess_id`)
80 -- --------------------------------------------------------
83 -- Table structure for table `users`
86 CREATE TABLE `users` (
87 `user_id` int(10) unsigned NOT NULL auto_increment,
88 `username` varchar(128) NOT NULL default '',
89 `mail_host` varchar(128) NOT NULL default '',
90 `alias` varchar(128) NOT NULL default '',
91 `created` datetime NOT NULL default '0000-00-00 00:00:00',
92 `last_login` datetime NOT NULL default '0000-00-00 00:00:00',
93 `language` varchar(5) NOT NULL default 'en',
94 `preferences` text NOT NULL default '',
95 PRIMARY KEY (`user_id`)
98 -- --------------------------------------------------------
101 -- Table structure for table `messages`
104 CREATE TABLE `messages` (
105 `message_id` int(11) unsigned NOT NULL auto_increment,
106 `user_id` int(11) unsigned NOT NULL default '0',
107 `del` tinyint(1) NOT NULL default '0',
108 `cache_key` varchar(128) NOT NULL default '',
109 `created` datetime NOT NULL default '0000-00-00 00:00:00',
110 `idx` int(11) unsigned NOT NULL default '0',
111 `uid` int(11) unsigned NOT NULL default '0',
112 `subject` varchar(255) NOT NULL default '',
113 `from` varchar(255) NOT NULL default '',
114 `to` varchar(255) NOT NULL default '',
115 `cc` varchar(255) NOT NULL default '',
116 `date` datetime NOT NULL default '0000-00-00 00:00:00',
117 `size` int(11) unsigned NOT NULL default '0',
118 `headers` text NOT NULL,
120 PRIMARY KEY (`message_id`),
121 KEY `user_id` (`user_id`),
122 KEY `cache_key` (`cache_key`),