1 CREATE TABLE IF NOT EXISTS nodes (
2 id INTEGER PRIMARY KEY,
4 type VARCHAR(1) NOT NULL,
5 norder INTEGER NOT NULL
8 CREATE TABLE IF NOT EXISTS categories (
13 CREATE TABLE IF NOT EXISTS feeds (
16 location VARCHAR(255) NOT NULL,
21 generator VARCHAR(255),
22 category VARCHAR(255),
24 webmaster VARCHAR(255)
27 CREATE TABLE IF NOT EXISTS items (
28 id INTEGER PRIMARY KEY,
30 feed_id INTEGER NOT NULL,
31 is_read INTEGER NOT NULL DEFAULT 0,
33 pub_date DATETIME NOT NULL,
34 description TEXT NOT NULL
37 CREATE INDEX idx_nodes_id ON nodes (id)
39 CREATE INDEX idx_feeds_id ON feeds (id)
41 CREATE INDEX idx_categories_id ON categories (id)
43 CREATE INDEX idx_items_feed_id ON items (feed_id)
45 INSERT INTO nodes (id, parent_id, type, norder) VALUES (1, NULL, 'C', 0);
47 INSERT INTO categories (id, name) VALUES (1, 'root');