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);