diff options
Diffstat (limited to 'migrations')
| -rw-r--r-- | migrations/009_shopping_item_checks.sql | 8 |
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) +); |