summaryrefslogtreecommitdiff
path: root/migrations
diff options
context:
space:
mode:
authorPeter Stone <thepeterstone@gmail.com>2026-01-26 17:00:30 -1000
committerPeter Stone <thepeterstone@gmail.com>2026-01-26 17:00:30 -1000
commitbbf12fc441ca36c423e865107d34df178e3d26de (patch)
tree44525ff1c846c1b4099f4c08c6ce88f6028ea5d2 /migrations
parentfd2524eacd51f523998734f869b3343441e55b93 (diff)
Fix multiple UI issues and shopping completion bug
- #54: Fix shopping item completion - now works for all sources (trello, plantoeat, user) with state stored in local DB - #48: Hide 12:00am times in timeline (all-day items) - #49: Remove "Task" type label from timeline items for cleaner UI - #51: Combine multiple PlanToEat meals for same date+mealType - #52: Change Conditions tab to standard link to standalone page Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
Diffstat (limited to 'migrations')
-rw-r--r--migrations/009_shopping_item_checks.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/migrations/009_shopping_item_checks.sql b/migrations/009_shopping_item_checks.sql
new file mode 100644
index 0000000..f4cb0b0
--- /dev/null
+++ b/migrations/009_shopping_item_checks.sql
@@ -0,0 +1,8 @@
+-- Track checked state for shopping items from external sources (trello, plantoeat)
+CREATE TABLE IF NOT EXISTS shopping_item_checks (
+ source TEXT NOT NULL,
+ item_id TEXT NOT NULL,
+ checked INTEGER NOT NULL DEFAULT 0,
+ updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,
+ PRIMARY KEY (source, item_id)
+);