diff options
| -rw-r--r-- | SQL/mysql.update.sql | 7 | ||||
| -rwxr-xr-x | SQL/postgres.initial.sql | 103 | ||||
| -rw-r--r-- | 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 08ce92019..e140a94a3 100644 --- a/SQL/mysql.update.sql +++ b/SQL/mysql.update.sql @@ -48,3 +48,10 @@ CREATE TABLE `messages` ( 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 b251755ad..771df74bc 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 @@ -48,20 +9,6 @@ CREATE SEQUENCE user_ids 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" -- Name: users; Type: TABLE; Schema: public; Owner: postgres @@ -79,7 +26,7 @@ CREATE TABLE users ( ); - + -- -- Table "session" -- Name: session; Type: TABLE; Schema: public; Owner: postgres @@ -96,6 +43,18 @@ CREATE TABLE "session" ( -- +-- 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" -- Name: identities; Type: TABLE; Schema: public; Owner: postgres -- @@ -114,6 +73,19 @@ CREATE TABLE identities ( ); + +-- +-- 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" -- Name: contacts; Type: TABLE; Schema: public; Owner: postgres @@ -134,6 +106,17 @@ CREATE TABLE contacts ( -- +-- 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 @@ CREATE TABLE "cache" ( -- +-- 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 @@ CREATE TABLE "messages" ( 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 19ca6a578..147df7243 100644 --- a/SQL/sqlite.initial.sql +++ b/SQL/sqlite.initial.sql @@ -108,6 +108,7 @@ CREATE TABLE messages ( 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 '', |