Mercurial > hg > rc1

comparison SQL/postgres/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 ON UPDATE CASCADE,
7 cache_key varchar(128) DEFAULT '' NOT NULL,
8 expires timestamp with time zone DEFAULT NULL,
9 data text NOT NULL,
10 PRIMARY KEY (user_id, cache_key)
11 );
12
13 CREATE INDEX cache_expires_idx ON "cache" (expires);
14
15 CREATE TABLE "cache_shared" (
16 cache_key varchar(255) NOT NULL PRIMARY KEY,
17 expires timestamp with time zone DEFAULT NULL,
18 data text NOT NULL
19 );
20
21 CREATE INDEX cache_shared_expires_idx ON "cache_shared" (expires);