summaryrefslogtreecommitdiff
path: root/SQL/postgres.initial.sql
diff options
context:
space:
mode:
authorAleksander Machniak <alec@alec.pl>2012-08-06 10:32:37 +0200
committerAleksander Machniak <alec@alec.pl>2012-08-06 10:32:37 +0200
commit83121ece3348bfe09bb1026eace79a74a5ccf2c9 (patch)
tree9f64f143b8a859db3930a649a404cdcc46434660 /SQL/postgres.initial.sql
parenta025cddbc5643d1e8c9d2bf733a101417213d91b (diff)
- Removed redundant cache.cache_id column (#1488528)
Diffstat (limited to 'SQL/postgres.initial.sql')
-rw-r--r--SQL/postgres.initial.sql12
1 files changed, 0 insertions, 12 deletions
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
@@ -160,23 +160,11 @@ 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,