summaryrefslogtreecommitdiff
path: root/migrations/013_source_config.sql
diff options
context:
space:
mode:
authorPeter Stone <thepeterstone@gmail.com>2026-01-31 20:16:12 -1000
committerPeter Stone <thepeterstone@gmail.com>2026-01-31 20:16:12 -1000
commitcbb0b53de1d06918c142171fd084f14f03798bc1 (patch)
treebeb642057178bce8f50e3ad67f5a62671e3e6dda /migrations/013_source_config.sql
parentd39220eac03fbc5b714bde989665ed1c92dd24a5 (diff)
Add feature toggles system with settings UI (#74)
- Add feature_toggles table (migration 012) - Add source_config table for future source selection (migration 013) - Create settings page at /settings with: - Feature toggle management (enable/disable/create/delete) - Data source configuration (sync and toggle boards/calendars) - Add store methods for feature toggles and source config - Add GetCalendarList and GetTaskLists to Google API clients - Document feature toggle workflow in DESIGN.md Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
Diffstat (limited to 'migrations/013_source_config.sql')
-rw-r--r--migrations/013_source_config.sql13
1 files changed, 13 insertions, 0 deletions
diff --git a/migrations/013_source_config.sql b/migrations/013_source_config.sql
new file mode 100644
index 0000000..7083d33
--- /dev/null
+++ b/migrations/013_source_config.sql
@@ -0,0 +1,13 @@
+-- Source configuration for selecting which items to fetch
+CREATE TABLE IF NOT EXISTS source_config (
+ id INTEGER PRIMARY KEY AUTOINCREMENT,
+ source TEXT NOT NULL, -- 'trello', 'todoist', 'gcal', 'gtasks'
+ item_type TEXT NOT NULL, -- 'board', 'project', 'calendar', 'tasklist'
+ item_id TEXT NOT NULL, -- ID from the source
+ item_name TEXT NOT NULL, -- Display name
+ enabled INTEGER NOT NULL DEFAULT 1,
+ updated_at TEXT NOT NULL DEFAULT (datetime('now', 'localtime')),
+ UNIQUE(source, item_type, item_id)
+);
+
+CREATE INDEX IF NOT EXISTS idx_source_config_source ON source_config(source, enabled);