From 83121ece3348bfe09bb1026eace79a74a5ccf2c9 Mon Sep 17 00:00:00 2001 From: Aleksander Machniak Date: Mon, 6 Aug 2012 10:32:37 +0200 Subject: - Removed redundant cache.cache_id column (#1488528) --- SQL/postgres.initial.sql | 12 ------------ 1 file changed, 12 deletions(-) (limited to 'SQL/postgres.initial.sql') diff --git a/SQL/postgres.initial.sql b/SQL/postgres.initial.sql index e12a9978a..a47bec2ca 100644 --- a/SQL/postgres.initial.sql +++ b/SQL/postgres.initial.sql @@ -159,24 +159,12 @@ CREATE TABLE contactgroupmembers ( CREATE INDEX contactgroupmembers_contact_id_idx ON contactgroupmembers (contact_id); --- --- 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 -- CREATE TABLE "cache" ( - cache_id integer DEFAULT nextval('cache_ids'::text) PRIMARY KEY, user_id integer NOT NULL REFERENCES users (user_id) ON DELETE CASCADE ON UPDATE CASCADE, cache_key varchar(128) DEFAULT '' NOT NULL, -- cgit v1.2.3