From bbf12fc441ca36c423e865107d34df178e3d26de Mon Sep 17 00:00:00 2001
From: Peter Stone <thepeterstone@gmail.com>
Date: Mon, 26 Jan 2026 17:00:30 -1000
Subject: 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>
---
 migrations/009_shopping_item_checks.sql | 8 ++++++++
 1 file changed, 8 insertions(+)
 create mode 100644 migrations/009_shopping_item_checks.sql

(limited to 'migrations/009_shopping_item_checks.sql')

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)
+);
-- 
cgit v1.2.3

