sources/wiki/cache.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

--
--  Taginfo source: Wiki
--
--  cache.sql
--

.bail ON

CREATE TABLE cache_pages (
    title     TEXT,
    timestamp TEXT,
    body      TEXT
);

CREATE INDEX cache_pages_title_timestamp_idx ON cache_pages (title, timestamp);