Query

mealie.db — cookbooks

SQL

CREATE TABLE "cookbooks"  (
  created_at DATETIME,
  update_at DATETIME,
  id CHAR(32) NOT NULL,
  position INTEGER NOT NULL,
  name VARCHAR NOT NULL,
  slug VARCHAR NOT NULL,
  description VARCHAR,
  group_id CHAR(32),
  public BOOLEAN,
  require_all_categories BOOLEAN,
  require_all_tags BOOLEAN,
  require_all_tools BOOLEAN,
  household_id CHAR(32),
  query_filter_string VARCHAR DEFAULT '' NOT NULL,
  PRIMARY KEY (id),
  CONSTRAINT fk_cookbooks_household_id FOREIGN KEY(household_id) REFERENCES households (id),
  CONSTRAINT cookbook_slug_group_id_key UNIQUE (slug, group_id),
  FOREIGN KEY(group_id) REFERENCES groups (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
position INTEGER Rename | Drop
name VARCHAR Rename | Drop
slug VARCHAR Rename | Drop
description VARCHAR ✓ Rename | Drop
group_id CHAR(32) ✓ Rename | Drop
public BOOLEAN ✓ Rename | Drop
require_all_categories BOOLEAN ✓ Rename | Drop
require_all_tags BOOLEAN ✓ Rename | Drop
require_all_tools BOOLEAN ✓ Rename | Drop
household_id CHAR(32) ✓ Rename | Drop
query_filter_string VARCHAR Rename | Drop

Foreign Keys

Column Destination
group_id groups.id
household_id households.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
ix_cookbooks_created_at created_at SQL 
CREATE INDEX ix_cookbooks_created_at
ON cookbooks (created_at)
Drop
ix_cookbooks_group_id group_id SQL 
CREATE INDEX ix_cookbooks_group_id
ON cookbooks (group_id)
Drop
ix_cookbooks_household_id household_id SQL 
CREATE INDEX ix_cookbooks_household_id
ON cookbooks (household_id)
Drop
ix_cookbooks_slug slug SQL 
CREATE INDEX ix_cookbooks_slug
ON cookbooks (slug)
Drop
sqlite_autoindex_cookbooks_1 id ✓ SQL
-- no sql found --
 Drop
sqlite_autoindex_cookbooks_2
  • slug
  • group_id
 ✓ SQL
-- no sql found --
 Drop