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