diff options
author | thomascube <thomas@roundcube.net> | 2006-01-25 18:05:40 +0000 |
---|---|---|
committer | thomascube <thomas@roundcube.net> | 2006-01-25 18:05:40 +0000 |
commit | b59474133a308182c69b2fd158b4f51aeffc87e4 (patch) | |
tree | c31c3b00732c7ad0053e228fc8d21eae33b8dfda /SQL/postgres.initial.sql | |
parent | c6e808e90c67f08a821907053a83013a9213a021 (diff) |
Add created date to message cache
Diffstat (limited to 'SQL/postgres.initial.sql')
-rwxr-xr-x | SQL/postgres.initial.sql | 103 |
1 files changed, 49 insertions, 54 deletions
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, |