From 9dab1bd0600cf86834530d4c7268538ede8c33ff Mon Sep 17 00:00:00 2001
From: roundcube <roundcube@208e9e7b-5314-0410-a742-e7e81cd9613c>
Date: Fri, 7 Oct 2005 14:20:11 +0000
Subject: Added SQLite supprt and MySQL update script

git-svn-id: https://svn.roundcube.net/trunk@22 208e9e7b-5314-0410-a742-e7e81cd9613c
---
 roundcubemail/SQL/sqlite.initial.sql | 80 ++++++++++++++++++++++++++++++++++++
 1 file changed, 80 insertions(+)
 create mode 100644 roundcubemail/SQL/sqlite.initial.sql

(limited to 'roundcubemail/SQL/sqlite.initial.sql')

diff --git a/roundcubemail/SQL/sqlite.initial.sql b/roundcubemail/SQL/sqlite.initial.sql
new file mode 100644
index 000000000..01f51d6a8
--- /dev/null
+++ b/roundcubemail/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 ''
+);
-- 
cgit v1.2.3

