1 CREATE TABLE IF NOT EXISTS feeds (
2 id INTEGER PRIMARY KEY,
8 CREATE TABLE IF NOT EXISTS items (
9 id INTEGER PRIMARY KEY,
11 feed_id INTEGER NOT NULL,
12 is_read INTEGER NOT NULL DEFAULT 0,
14 pub_date TIMESTAMP NOT NULL,
15 description TEXT NOT NULL
18 CREATE TABLE IF NOT EXISTS categories (
19 id INTEGER PRIMARY KEY,
24 CREATE TABLE IF NOT EXISTS treeview_nodes (
25 id INTEGER PRIMARY KEY,
26 obj_id INTEGER NOT NULL,
27 norder INTEGER NOT NULL,
28 type VARCHAR(1) NOT NULL
31 CREATE INDEX idx_items_feed_id ON items(feed_id);
33 INSERT INTO categories (parent_id, title) VALUES (NULL, 'root');