Pantry

schema.js 2 lines

// Exact fixture DDL, bundled so installation needs no additional assets.
export default "CREATE TABLE quantity_units (\n  id INTEGER PRIMARY KEY AUTOINCREMENT,\n  name TEXT NOT NULL,\n  name_plural TEXT,\n  description TEXT\n);\nCREATE TABLE products (\n  id INTEGER PRIMARY KEY AUTOINCREMENT,\n  name TEXT NOT NULL,\n  description TEXT,\n  location_id INTEGER,\n  qu_id_purchase INTEGER REFERENCES quantity_units(id),\n  qu_id_stock INTEGER REFERENCES quantity_units(id),\n  min_stock_amount REAL NOT NULL DEFAULT 0 CHECK (min_stock_amount >= 0),\n  default_best_before_days INTEGER NOT NULL DEFAULT 0 CHECK (default_best_before_days >= 0),\n  default_best_before_days_after_open INTEGER NOT NULL DEFAULT 0 CHECK (default_best_before_days_after_open >= 0),\n  product_group_id INTEGER\n);\nCREATE TABLE stock_entries (\n  id INTEGER PRIMARY KEY AUTOINCREMENT,\n  product_id INTEGER NOT NULL REFERENCES products(id),\n  location_id INTEGER,\n  amount REAL NOT NULL CHECK (amount > 0),\n  best_before_date TEXT,\n  purchased_date TEXT,\n  stock_id TEXT NOT NULL UNIQUE DEFAULT ('local-' || lower(hex(randomblob(8)))),\n  price REAL,\n  open INTEGER NOT NULL DEFAULT 0 CHECK (open IN (0, 1)),\n  opened_date TEXT,\n  note TEXT\n);\n";