cli + tui to publish to leaflet (wip) & manage tasks, notes & watch/read lists 馃崈
desertthunder.dev
charm
leaflet
readability
golang
1-- Tasks table
2CREATE TABLE IF NOT EXISTS tasks (
3 id INTEGER PRIMARY KEY AUTOINCREMENT,
4 uuid TEXT UNIQUE NOT NULL,
5 description TEXT NOT NULL,
6 status TEXT DEFAULT 'pending',
7 priority TEXT,
8 project TEXT,
9 tags TEXT, -- JSON array
10 due DATETIME,
11 entry DATETIME DEFAULT CURRENT_TIMESTAMP,
12 modified DATETIME DEFAULT CURRENT_TIMESTAMP,
13 end DATETIME,
14 start DATETIME,
15 annotations TEXT -- JSON array
16);
17
18CREATE INDEX IF NOT EXISTS idx_tasks_status ON tasks(status);
19CREATE INDEX IF NOT EXISTS idx_tasks_project ON tasks(project);
20CREATE INDEX IF NOT EXISTS idx_tasks_due ON tasks(due);
21CREATE INDEX IF NOT EXISTS idx_tasks_uuid ON tasks(uuid);
22
23-- Movies table
24CREATE TABLE IF NOT EXISTS movies (
25 id INTEGER PRIMARY KEY AUTOINCREMENT,
26 title TEXT NOT NULL,
27 year INTEGER,
28 status TEXT DEFAULT 'queued',
29 rating REAL,
30 notes TEXT,
31 added DATETIME DEFAULT CURRENT_TIMESTAMP,
32 watched DATETIME
33);
34
35CREATE INDEX IF NOT EXISTS idx_movies_status ON movies(status);
36CREATE INDEX IF NOT EXISTS idx_movies_title ON movies(title);
37
38-- TV Shows table
39CREATE TABLE IF NOT EXISTS tv_shows (
40 id INTEGER PRIMARY KEY AUTOINCREMENT,
41 title TEXT NOT NULL,
42 season INTEGER,
43 episode INTEGER,
44 status TEXT DEFAULT 'queued',
45 rating REAL,
46 notes TEXT,
47 added DATETIME DEFAULT CURRENT_TIMESTAMP,
48 last_watched DATETIME
49);
50
51CREATE INDEX IF NOT EXISTS idx_tv_shows_status ON tv_shows(status);
52CREATE INDEX IF NOT EXISTS idx_tv_shows_title ON tv_shows(title);
53CREATE INDEX IF NOT EXISTS idx_tv_shows_season_episode ON tv_shows(title, season, episode);
54
55-- Books table
56CREATE TABLE IF NOT EXISTS books (
57 id INTEGER PRIMARY KEY AUTOINCREMENT,
58 title TEXT NOT NULL,
59 author TEXT,
60 status TEXT DEFAULT 'queued',
61 progress INTEGER DEFAULT 0,
62 pages INTEGER,
63 rating REAL,
64 notes TEXT,
65 added DATETIME DEFAULT CURRENT_TIMESTAMP,
66 started DATETIME,
67 finished DATETIME
68);
69
70CREATE INDEX IF NOT EXISTS idx_books_status ON books(status);
71CREATE INDEX IF NOT EXISTS idx_books_author ON books(author);
72CREATE INDEX IF NOT EXISTS idx_books_title ON books(title);