summaryrefslogtreecommitdiff
path: root/SQL
diff options
context:
space:
mode:
Diffstat (limited to 'SQL')
-rw-r--r--SQL/initial.sql93
1 files changed, 93 insertions, 0 deletions
diff --git a/SQL/initial.sql b/SQL/initial.sql
new file mode 100644
index 000000000..64d650867
--- /dev/null
+++ b/SQL/initial.sql
@@ -0,0 +1,93 @@
+-- RoundCube Webmail initial database structure
+-- Version 0.1a
+--
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `cache`
+--
+
+CREATE TABLE `cache` (
+ `cache_id` int(10) unsigned NOT NULL auto_increment,
+ `user_id` int(10) unsigned NOT NULL default '0',
+ `session_id` varchar(32) default NULL,
+ `cache_key` varchar(128) NOT NULL default '',
+ `created` datetime NOT NULL default '0000-00-00 00:00:00',
+ `data` longtext NOT NULL,
+ PRIMARY KEY (`cache_id`),
+ KEY `user_id` (`user_id`),
+ KEY `cache_key` (`cache_key`),
+ KEY `session_id` (`session_id`)
+) TYPE=MyISAM;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `contacts`
+--
+
+CREATE TABLE `contacts` (
+ `contact_id` int(10) unsigned NOT NULL auto_increment,
+ `user_id` int(10) unsigned NOT NULL default '0',
+ `del` enum('0','1') NOT NULL default '0',
+ `name` varchar(128) NOT NULL default '',
+ `email` varchar(128) NOT NULL default '',
+ `firstname` varchar(128) NOT NULL default '',
+ `surname` varchar(128) NOT NULL default '',
+ `vcard` text NOT NULL,
+ PRIMARY KEY (`contact_id`),
+ KEY `user_id` (`user_id`)
+) TYPE=MyISAM;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `identities`
+--
+
+CREATE TABLE `identities` (
+ `identity_id` int(10) unsigned NOT NULL auto_increment,
+ `user_id` int(10) unsigned NOT NULL default '0',
+ `del` enum('0','1') NOT NULL default '0',
+ `default` enum('0','1') NOT NULL default '0',
+ `name` varchar(128) NOT NULL default '',
+ `organization` varchar(128) NOT NULL default '',
+ `email` varchar(128) NOT NULL default '',
+ `reply-to` varchar(128) NOT NULL default '',
+ `bcc` varchar(128) NOT NULL default '',
+ `signature` text NOT NULL,
+ PRIMARY KEY (`identity_id`),
+ KEY `user_id` (`user_id`)
+) TYPE=MyISAM;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `session`
+--
+
+CREATE TABLE `session` (
+ `sess_id` varchar(32) NOT NULL default '',
+ `created` datetime NOT NULL default '0000-00-00 00:00:00',
+ `changed` datetime NOT NULL default '0000-00-00 00:00:00',
+ `vars` text NOT NULL,
+ PRIMARY KEY (`sess_id`)
+) TYPE=MyISAM;
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `users`
+--
+
+CREATE TABLE `users` (
+ `user_id` int(10) unsigned NOT NULL auto_increment,
+ `username` varchar(128) NOT NULL default '',
+ `mail_host` varchar(255) NOT NULL default '',
+ `created` datetime NOT NULL default '0000-00-00 00:00:00',
+ `last_login` datetime NOT NULL default '0000-00-00 00:00:00',
+ `language` varchar(5) NOT NULL default 'en',
+ `preferences` text NOT NULL,
+ PRIMARY KEY (`user_id`)
+) TYPE=MyISAM;