migrations/008_user_shopping_items.sql


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