Recipes

schema.js 2 lines

Files · 8

emits.js175 lines
index.jsx403 lines
listens.js77 lines
manifest.json365 lines
model.js116 lines
schema.js2 lines
schema.sql16 lines
style.css57 lines

12// Exact fixture DDL, bundled so installation needs no additional assets.
export default "CREATE TABLE recipes (\n  id INTEGER PRIMARY KEY AUTOINCREMENT,\n  name TEXT NOT NULL,\n  description TEXT,\n  url TEXT,\n  author TEXT,\n  date_published TEXT,\n  prep_time TEXT,\n  cook_time TEXT,\n  total_time TEXT,\n  recipe_yield TEXT,\n  recipe_category TEXT,\n  recipe_cuisine TEXT,\n  recipe_ingredient TEXT NOT NULL DEFAULT '[]' CHECK (json_valid(recipe_ingredient) AND json_type(recipe_ingredient) = 'array'),\n  recipe_instructions TEXT\n);\n";