Mercurial > hg > rc2

comparison SQL/postgres/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 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);