Mercurial > hg > rc2

comparison SQL/sqlite/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 default 0,
6 cache_key varchar(128) NOT NULL default '',
7 expires datetime DEFAULT NULL,
8 data text NOT NULL,
9 PRIMARY KEY (user_id, cache_key)
10 );
11
12 CREATE INDEX ix_cache_expires ON cache(expires);
13
14 CREATE TABLE cache_shared (
15 cache_key varchar(255) NOT NULL,
16 expires datetime DEFAULT NULL,
17 data text NOT NULL,
18 PRIMARY KEY (cache_key)
19 );
20
21 CREATE INDEX ix_cache_shared_expires ON cache_shared(expires);