Query

mealie.db — recipes

SQL

CREATE TABLE "recipes"  (
  created_at DATETIME,
  update_at DATETIME,
  id CHAR(32) NOT NULL,
  slug VARCHAR,
  group_id CHAR(32) NOT NULL,
  user_id CHAR(32),
  name VARCHAR NOT NULL,
  description VARCHAR,
  image VARCHAR,
  total_time VARCHAR,
  prep_time VARCHAR,
  perform_time VARCHAR,
  cook_time VARCHAR,
  recipe_yield VARCHAR,
  "recipeCuisine" VARCHAR,
  rating FLOAT,
  org_url VARCHAR,
  date_added DATE,
  date_updated DATETIME,
  is_ocr_recipe BOOLEAN,
  last_made DATETIME,
  name_normalized VARCHAR NOT NULL,
  description_normalized VARCHAR,
  recipe_yield_quantity FLOAT DEFAULT '0' NOT NULL,
  recipe_servings FLOAT DEFAULT '0' NOT NULL,
  PRIMARY KEY (id),
  CONSTRAINT recipe_slug_group_id_key UNIQUE (slug, group_id),
  FOREIGN KEY(group_id) REFERENCES groups (id),
  FOREIGN KEY(user_id) REFERENCES users (id)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
created_at DATETIME ✓ Rename | Drop
update_at DATETIME ✓ Rename | Drop
id CHAR(32) ✓ Rename | Drop
slug VARCHAR ✓ Rename | Drop
group_id CHAR(32) Rename | Drop
user_id CHAR(32) ✓ Rename | Drop
name VARCHAR Rename | Drop
description VARCHAR ✓ Rename | Drop
image VARCHAR ✓ Rename | Drop
total_time VARCHAR ✓ Rename | Drop
prep_time VARCHAR ✓ Rename | Drop
perform_time VARCHAR ✓ Rename | Drop
cook_time VARCHAR ✓ Rename | Drop
recipe_yield VARCHAR ✓ Rename | Drop
recipeCuisine VARCHAR ✓ Rename | Drop
rating FLOAT ✓ Rename | Drop
org_url VARCHAR ✓ Rename | Drop
date_added DATE ✓ Rename | Drop
date_updated DATETIME ✓ Rename | Drop
is_ocr_recipe BOOLEAN ✓ Rename | Drop
last_made DATETIME ✓ Rename | Drop
name_normalized VARCHAR Rename | Drop
description_normalized VARCHAR ✓ Rename | Drop
recipe_yield_quantity FLOAT Rename | Drop
recipe_servings FLOAT Rename | Drop

Foreign Keys

Column Destination
user_id users.id
group_id groups.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
ix_recipes_created_at created_at SQL 
CREATE INDEX ix_recipes_created_at
ON recipes (created_at)
Drop
ix_recipes_description_normalized description_normalized SQL 
CREATE INDEX ix_recipes_description_normalized
ON recipes (description_normalized)
Drop
ix_recipes_group_id group_id SQL 
CREATE INDEX ix_recipes_group_id
ON recipes (group_id)
Drop
ix_recipes_name_normalized name_normalized SQL 
CREATE INDEX ix_recipes_name_normalized
ON recipes (name_normalized)
Drop
ix_recipes_rating rating SQL 
CREATE INDEX ix_recipes_rating
ON recipes (rating)
Drop
ix_recipes_recipe_servings recipe_servings SQL 
CREATE INDEX ix_recipes_recipe_servings
ON recipes (recipe_servings)
Drop
ix_recipes_recipe_yield_quantity recipe_yield_quantity SQL 
CREATE INDEX ix_recipes_recipe_yield_quantity
ON recipes (recipe_yield_quantity)
Drop
ix_recipes_slug slug SQL 
CREATE INDEX ix_recipes_slug
ON recipes (slug)
Drop
ix_recipes_user_id user_id SQL 
CREATE INDEX ix_recipes_user_id
ON recipes (user_id)
Drop
sqlite_autoindex_recipes_1 id ✓ SQL
-- no sql found --
 Drop
sqlite_autoindex_recipes_2
  • slug
  • group_id
 ✓ SQL
-- no sql found --
 Drop