Mercurial > hg > rc2

comparison SQL/sqlite/2013061000.sql @ 0:4681f974d28b

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:52:31 -0500
parents
children
comparison
equal deleted inserted replaced
-1:000000000000 0:4681f974d28b
1 DROP TABLE cache_index;
2 DROP TABLE cache_thread;
3 DROP TABLE cache_messages;
4
5 ALTER TABLE cache ADD expires datetime DEFAULT NULL;
6 DROP INDEX ix_cache_created;
7
8 ALTER TABLE cache_shared ADD expires datetime DEFAULT NULL;
9 DROP INDEX ix_cache_shared_created;
10
11 UPDATE cache SET expires = datetime(created, '+604800 seconds');
12 UPDATE cache_shared SET expires = datetime(created, '+604800 seconds');
13
14 CREATE INDEX ix_cache_expires ON cache(expires);
15 CREATE INDEX ix_cache_shared_expires ON cache_shared(expires);
16
17 CREATE TABLE cache_index (
18 user_id integer NOT NULL,
19 mailbox varchar(255) NOT NULL,
20 expires datetime DEFAULT NULL,
21 valid smallint NOT NULL DEFAULT '0',
22 data text NOT NULL,
23 PRIMARY KEY (user_id, mailbox)
24 );
25
26 CREATE INDEX ix_cache_index_expires ON cache_index (expires);
27
28 CREATE TABLE cache_thread (
29 user_id integer NOT NULL,
30 mailbox varchar(255) NOT NULL,
31 expires datetime DEFAULT NULL,
32 data text NOT NULL,
33 PRIMARY KEY (user_id, mailbox)
34 );
35
36 CREATE INDEX ix_cache_thread_expires ON cache_thread (expires);
37
38 CREATE TABLE cache_messages (
39 user_id integer NOT NULL,
40 mailbox varchar(255) NOT NULL,
41 uid integer NOT NULL,
42 expires datetime DEFAULT NULL,
43 data text NOT NULL,
44 flags integer NOT NULL DEFAULT '0',
45 PRIMARY KEY (user_id, mailbox, uid)
46 );
47
48 CREATE INDEX ix_cache_messages_expires ON cache_messages (expires);