examples/storefront Public
-- Products: the catalog. Prices are whole cents in the shop's one currency (src/money.ts).CREATE TABLE products ( id TEXT PRIMARY KEY, name TEXT NOT NULL, description TEXT NOT NULL DEFAULT '', price_cents INTEGER NOT NULL CHECK (price_cents > 0), stock INTEGER NOT NULL DEFAULT 0 CHECK (stock >= 0), image_key TEXT, active INTEGER NOT NULL DEFAULT 1, created_at INTEGER NOT NULL, updated_at INTEGER NOT NULL);CREATE INDEX products_by_name ON products (active, name, id);