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,
20 CREATE TABLE IF NOT EXISTS items (
21 id INTEGER PRIMARY KEY,
23 feed_id INTEGER NOT NULL,
24 is_read INTEGER NOT NULL DEFAULT 0,
26 pub_date TIMESTAMP NOT NULL,
27 description TEXT NOT NULL
30 CREATE INDEX idx_nodes_id ON nodes (id)
32 CREATE INDEX idx_feeds_id ON feeds (id)
34 CREATE INDEX idx_categories_id ON categories (id)
36 CREATE INDEX idx_items_feed_id ON items (feed_id)
38 INSERT INTO nodes (id, parent_id, type, norder) VALUES (1, NULL, 'C', 0);
40 INSERT INTO categories (id, name) VALUES (1, 'root');