From 79fe17fb5a43786ccd407926d51fdfe4fe22f55f Mon Sep 17 00:00:00 2001
From: thomascube <thomas@roundcube.net>
Date: Fri, 07 Oct 2005 10:20:11 -0400
Subject: [PATCH] Added SQLite supprt and MySQL update script

---
 SQL/mysql.update.sql   |    6 +++
 SQL/sqlite.initial.sql |   80 ++++++++++++++++++++++++++++++++++++++++
 2 files changed, 86 insertions(+), 0 deletions(-)

diff --git a/SQL/mysql.update.sql b/SQL/mysql.update.sql
new file mode 100644
index 0000000..8cd8c5c
--- /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 0000000..01f51d6
--- /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 ''
+);

--
Gitblit v1.9.1