Query

mealie.db — cookbooks_to_tools

SQL

CREATE TABLE "cookbooks_to_tools"  (
  cookbook_id CHAR(32),
  tool_id CHAR(32),
  CONSTRAINT cookbook_id_tool_id_key UNIQUE (cookbook_id, tool_id),
  FOREIGN KEY(tool_id) REFERENCES tools (id),
  FOREIGN KEY(cookbook_id) REFERENCES cookbooks (id)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
cookbook_id CHAR(32) ✓ Rename | Drop
tool_id CHAR(32) ✓ Rename | Drop

Foreign Keys

Column Destination
cookbook_id cookbooks.id
tool_id tools.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
ix_cookbooks_to_tools_cookbook_id cookbook_id SQL 
CREATE INDEX ix_cookbooks_to_tools_cookbook_id
ON cookbooks_to_tools (cookbook_id)
Drop
ix_cookbooks_to_tools_tool_id tool_id SQL 
CREATE INDEX ix_cookbooks_to_tools_tool_id
ON cookbooks_to_tools (tool_id)
Drop
sqlite_autoindex_cookbooks_to_tools_1
  • cookbook_id
  • tool_id
 ✓ SQL
-- no sql found --
 Drop