diff options
Diffstat (limited to 'migrations')
| -rw-r--r-- | migrations/008_user_shopping_items.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/migrations/008_user_shopping_items.sql b/migrations/008_user_shopping_items.sql new file mode 100644 index 0000000..686ccb6 --- /dev/null +++ b/migrations/008_user_shopping_items.sql @@ -0,0 +1,11 @@ +-- User-added shopping items (quick-add feature) +CREATE TABLE IF NOT EXISTS user_shopping_items ( + id INTEGER PRIMARY KEY AUTOINCREMENT, + name TEXT NOT NULL, + store TEXT NOT NULL, + checked BOOLEAN DEFAULT FALSE, + created_at DATETIME DEFAULT CURRENT_TIMESTAMP +); + +CREATE INDEX IF NOT EXISTS idx_user_shopping_store ON user_shopping_items(store); +CREATE INDEX IF NOT EXISTS idx_user_shopping_checked ON user_shopping_items(checked); |