From b59474133a308182c69b2fd158b4f51aeffc87e4 Mon Sep 17 00:00:00 2001
From: thomascube <thomas@roundcube.net>
Date: Wed, 25 Jan 2006 13:05:40 -0500
Subject: [PATCH] Add created date to message cache

---
 SQL/mysql.update.sql     |    7 +++
 SQL/postgres.initial.sql |  103 ++++++++++++++++++++++++---------------------------
 SQL/sqlite.initial.sql   |    1 
 3 files changed, 57 insertions(+), 54 deletions(-)

diff --git a/SQL/mysql.update.sql b/SQL/mysql.update.sql
index 08ce920..e140a94 100644
--- a/SQL/mysql.update.sql
+++ b/SQL/mysql.update.sql
@@ -48,3 +48,10 @@
   KEY `idx` (`idx`),
   KEY `uid` (`uid`)
 ) TYPE=MyISAM;
+
+
+
+-- RoundCube Webmail update script for MySQL databases
+-- Version 0.1-20051216
+
+ALTER TABLE `messages` ADD `created` DATETIME NOT NULL AFTER `cache_key` ;
diff --git a/SQL/postgres.initial.sql b/SQL/postgres.initial.sql
index b251755..771df74 100755
--- a/SQL/postgres.initial.sql
+++ b/SQL/postgres.initial.sql
@@ -1,42 +1,3 @@
-
---
--- Sequence "cache_ids"
--- Name: cache_ids; Type: SEQUENCE; Schema: public; Owner: postgres
---
-
-CREATE SEQUENCE cache_ids
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-
---
--- Sequence "contact_ids"
--- Name: contact_ids; Type: SEQUENCE; Schema: public; Owner: postgres
---
-
-CREATE SEQUENCE contact_ids
-    START WITH 1
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-
---
--- Sequence "identity_ids"
--- Name: identity_ids; Type: SEQUENCE; Schema: public; Owner: postgres
---
-
-CREATE SEQUENCE identity_ids
-    START WITH 1
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-
 --
 -- Sequence "user_ids"
 -- Name: user_ids; Type: SEQUENCE; Schema: public; Owner: postgres
@@ -47,20 +8,6 @@
     NO MAXVALUE
     NO MINVALUE
     CACHE 1;
-
-
---
--- Sequence "message_ids"
--- Name: message_ids; Type: SEQUENCE; Schema: public; Owner: postgres
---
-
-CREATE SEQUENCE message_ids
-    INCREMENT BY 1
-    NO MAXVALUE
-    NO MINVALUE
-    CACHE 1;
-
-
 
 --
 -- Table "users"
@@ -79,7 +26,7 @@
 );
 
 
-
+  
 --
 -- Table "session"
 -- Name: session; Type: TABLE; Schema: public; Owner: postgres
@@ -94,6 +41,18 @@
 );
 
 
+
+--
+-- Sequence "identity_ids"
+-- Name: identity_ids; Type: SEQUENCE; Schema: public; Owner: postgres
+--
+
+CREATE SEQUENCE identity_ids
+    START WITH 1
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
 
 --
 -- Table "identities"
@@ -113,6 +72,19 @@
     signature text
 );
 
+
+
+--
+-- Sequence "contact_ids"
+-- Name: contact_ids; Type: SEQUENCE; Schema: public; Owner: postgres
+--
+
+CREATE SEQUENCE contact_ids
+    START WITH 1
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
 
 --
 -- Table "contacts"
@@ -134,6 +106,17 @@
 
 
 --
+-- Sequence "cache_ids"
+-- Name: cache_ids; Type: SEQUENCE; Schema: public; Owner: postgres
+--
+
+CREATE SEQUENCE cache_ids
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+--
 -- Table "cache"
 -- Name: cache; Type: TABLE; Schema: public; Owner: postgres
 --
@@ -150,6 +133,17 @@
 
 
 --
+-- Sequence "message_ids"
+-- Name: message_ids; Type: SEQUENCE; Schema: public; Owner: postgres
+--
+
+CREATE SEQUENCE message_ids
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+--
 -- Table "messages"
 -- Name: messages; Type: TABLE; Schema: public; Owner: postgres
 --
@@ -159,6 +153,7 @@
     user_id integer NOT NULL REFERENCES users (user_id),
     del integer DEFAULT 0 NOT NULL,
     cache_key character varying(128) DEFAULT ''::character varying NOT NULL,
+    created timestamp with time zone DEFAULT now() NOT NULL,
     idx integer DEFAULT 0 NOT NULL,
     uid integer DEFAULT 0 NOT NULL,
     subject character varying(128) DEFAULT ''::character varying NOT NULL,
diff --git a/SQL/sqlite.initial.sql b/SQL/sqlite.initial.sql
index 19ca6a5..147df72 100644
--- a/SQL/sqlite.initial.sql
+++ b/SQL/sqlite.initial.sql
@@ -108,6 +108,7 @@
   user_id integer NOT NULL default '0',
   del tinyint NOT NULL default '0',
   cache_key varchar(128) NOT NULL default '',
+  created datetime NOT NULL default '0000-00-00 00:00:00',
   idx integer NOT NULL default '0',
   uid integer NOT NULL default '0',
   subject varchar(255) NOT NULL default '',

--
Gitblit v1.9.1