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