Mercurial > hg > rc1

comparison SQL/oracle/2016112200.sql @ 0:1e000243b222

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
vanilla 1.3.3 distro, I hope
author Charlie Root
date Thu, 04 Jan 2018 15:50:29 -0500
parents
children
comparison
equal deleted inserted replaced
-1:000000000000 0:1e000243b222
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");