migrations/009_shopping_item_checks.sql


1
2
3
4
5
6
7
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)
);