Rebasely Beta: data may be purged

examples/storefront Public

SQL · 14 lines · 494 B · at f6403bb

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