Mercurial > hg > rc2

comparison SQL/oracle/2016112200.sql @ 8:bf99236cc5cd

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
try to recover from upgrade fail
author Charlie Root
date Sat, 29 Dec 2018 07:07:34 -0500
parents
children
comparison
equal deleted inserted replaced
7:65fd7d441cf1 8:bf99236cc5cd
1 DROP TABLE "cache";
2 DROP TABLE "cache_shared";
3
4 CREATE TABLE "cache" (
5 "user_id" integer NOT NULL
6 REFERENCES "users" ("user_id") ON DELETE CASCADE,
7 "cache_key" varchar(128) NOT NULL,
8 "expires" timestamp with time zone DEFAULT NULL,
9 "data" long NOT NULL,
10 PRIMARY KEY ("user_id", "cache_key")
11 );
12
13 CREATE INDEX "cache_expires_idx" ON "cache" ("expires");
14
15
16 CREATE TABLE "cache_shared" (
17 "cache_key" varchar(255) NOT NULL,
18 "expires" timestamp with time zone DEFAULT NULL,
19 "data" long NOT NULL,
20 PRIMARY KEY ("cache_key")
21 );
22
23 CREATE INDEX "cache_shared_expires_idx" ON "cache_shared" ("expires");