|
0
|
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);
|
