1CREATE TABLE entries (
2    pid PRIMARY KEY,
3    page,
4    title,
5    blog,
6    image,
7    created INTEGER,
8    lastmod INTEGER,
9    author,
10    login,
11    email
12);
13CREATE UNIQUE INDEX idx_entries_pid ON entries(pid);
14CREATE INDEX idx_entries_title ON entries(title);
15CREATE INDEX idx_entries_created ON entries(created);
16CREATE INDEX idx_entries_blog ON entries(blog);
17
18CREATE TABLE comments (
19    cid INTEGER PRIMARY KEY,
20    pid,
21    source,
22    name,
23    mail,
24    web,
25    avatar,
26    created INTEGER,
27    text,
28    status
29);
30CREATE INDEX idx_comments_created ON comments(created);
31CREATE INDEX idx_comments_pid ON comments(pid);
32CREATE INDEX idx_comments_status ON comments(status);
33
34CREATE TABLE tags (
35    pid,
36    tag,
37    PRIMARY KEY (pid, tag)
38);
39CREATE INDEX idx_tags_pid ON tags(pid);
40CREATE INDEX idx_tags_tag ON tags(tag);
41