Mercurial > hg > rc1

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