|
1
|
|
|
2
|
CREATE TABLE cache_data (
|
|
3
|
id TEXT NOT NULL,
|
|
4
|
items SMALLINT NOT NULL DEFAULT 0,
|
|
5
|
data BLOB NOT NULL,
|
|
6
|
mtime INTEGER UNSIGNED NOT NULL
|
|
7
|
);
|
|
8
|
CREATE UNIQUE INDEX id ON cache_data(id);
|
|
9
|
|
|
10
|
CREATE TABLE items (
|
|
11
|
feed_id TEXT NOT NULL,
|
|
12
|
id TEXT NOT NULL,
|
|
13
|
data TEXT NOT NULL,
|
|
14
|
posted INTEGER UNSIGNED NOT NULL
|
|
15
|
);
|
|
16
|
CREATE INDEX feed_id ON items(feed_id);
|
|
17
|
|
|
18
|
|
|
19
|
|
|
20
|
CREATE TABLE `cache_data` (
|
|
21
|
`id` TEXT CHARACTER SET utf8 NOT NULL,
|
|
22
|
`items` SMALLINT NOT NULL DEFAULT 0,
|
|
23
|
`data` BLOB NOT NULL,
|
|
24
|
`mtime` INT UNSIGNED NOT NULL,
|
|
25
|
UNIQUE (
|
|
26
|
`id`(125)
|
|
27
|
)
|
|
28
|
);
|
|
29
|
|
|
30
|
CREATE TABLE `items` (
|
|
31
|
`feed_id` TEXT CHARACTER SET utf8 NOT NULL,
|
|
32
|
`id` TEXT CHARACTER SET utf8 NOT NULL,
|
|
33
|
`data` TEXT CHARACTER SET utf8 NOT NULL,
|
|
34
|
`posted` INT UNSIGNED NOT NULL,
|
|
35
|
INDEX `feed_id` (
|
|
36
|
`feed_id`(125)
|
|
37
|
)
|
|
38
|
);
|
