From bbf12fc441ca36c423e865107d34df178e3d26de Mon Sep 17 00:00:00 2001 From: Peter Stone 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 --- migrations/009_shopping_item_checks.sql | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 migrations/009_shopping_item_checks.sql (limited to 'migrations') 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