summaryrefslogtreecommitdiff
path: root/SQL
diff options
context:
space:
mode:
authorthomascube <thomas@roundcube.net>2005-10-07 14:20:11 +0000
committerthomascube <thomas@roundcube.net>2005-10-07 14:20:11 +0000
commit79fe17fb5a43786ccd407926d51fdfe4fe22f55f (patch)
treec86ed7861d129964c8cc78d5b1b717339aaa6c1b /SQL
parent42b11351497ce67e96a0465c76694632cdfb3ecb (diff)
Added SQLite supprt and MySQL update script
Diffstat (limited to 'SQL')
-rw-r--r--SQL/mysql.update.sql6
-rw-r--r--SQL/sqlite.initial.sql80
2 files changed, 86 insertions, 0 deletions
diff --git a/SQL/mysql.update.sql b/SQL/mysql.update.sql
new file mode 100644
index 000000000..8cd8c5c02
--- /dev/null
+++ b/SQL/mysql.update.sql
@@ -0,0 +1,6 @@
+-- RoundCube Webmail update script for MySQL databases
+-- Version 0.1-20051007
+
+
+ALTER TABLE session ADD ip VARCHAR(15) NOT NULL AFTER changed;
+ALTER TABLE users ADD alias VARCHAR(128) NOT NULL AFTER mail_host;
diff --git a/SQL/sqlite.initial.sql b/SQL/sqlite.initial.sql
new file mode 100644
index 000000000..01f51d6a8
--- /dev/null
+++ b/SQL/sqlite.initial.sql
@@ -0,0 +1,80 @@
+-- RoundCube Webmail initial database structure
+-- Version 0.1a
+--
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table `cache`
+--
+
+CREATE TABLE cache (
+ cache_id integer NOT NULL PRIMARY KEY,
+ user_id integer 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
+);
+
+CREATE INDEX ix_cache_user_id ON cache(user_id);
+CREATE INDEX ix_cache_cache_key ON cache(cache_key);
+CREATE INDEX ix_cache_session_id ON cache(session_id);
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table contacts
+--
+
+CREATE TABLE contacts (
+ contact_id integer NOT NULL PRIMARY KEY,
+ user_id integer NOT NULL default '0',
+ del integer 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 default ''
+);
+
+CREATE INDEX ix_contacts_user_id ON contacts(user_id);
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table identities
+--
+
+CREATE TABLE identities (
+ identity_id integer NOT NULL PRIMARY KEY,
+ user_id integer NOT NULL default '0',
+ del integer NOT NULL default '0',
+ "default" integer 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 default ''
+);
+
+CREATE INDEX ix_identities_user_id ON identities(user_id);
+
+
+-- --------------------------------------------------------
+
+--
+-- Table structure for table users
+--
+
+CREATE TABLE users (
+ user_id integer NOT NULL PRIMARY KEY,
+ username varchar(128) NOT NULL default '',
+ mail_host varchar(128) NOT NULL default '',
+ alias varchar(128) 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 default ''
+);