max / balanced_breakfast

510 B · 16 lines History Blame Raw

1	-- Feature: Feed storage
2	-- Create feeds table for registered bussers/sources
3	CREATE TABLE IF NOT EXISTS feeds (
4	id TEXT PRIMARY KEY,
5	busser_id TEXT NOT NULL,
6	name TEXT NOT NULL,
7	config TEXT NOT NULL DEFAULT '{}',
8	enabled INTEGER NOT NULL DEFAULT 1,
9	last_fetch TEXT,
10	created_at TEXT NOT NULL DEFAULT (datetime('now')),
11	updated_at TEXT NOT NULL DEFAULT (datetime('now'))
12	);
13
14	CREATE INDEX idx_feeds_busser_id ON feeds(busser_id);
15	CREATE INDEX idx_feeds_enabled ON feeds(enabled);
16