Query

mealie.db — recipe_ingredient_ref_link

SQL

CREATE TABLE recipe_ingredient_ref_link  (
  id INTEGER NOT NULL,
  created_at DATETIME,
  update_at DATETIME,
  instruction_id CHAR(32),
  reference_id CHAR(32),
  PRIMARY KEY (id),
  FOREIGN KEY(instruction_id) REFERENCES recipe_instructions (id)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
created_at DATETIME ✓ Rename | Drop
update_at DATETIME ✓ Rename | Drop
instruction_id CHAR(32) ✓ Rename | Drop
reference_id CHAR(32) ✓ Rename | Drop

Foreign Keys

Column Destination
instruction_id recipe_instructions.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
ix_recipe_ingredient_ref_link_created_at created_at SQL 
CREATE INDEX ix_recipe_ingredient_ref_link_created_at
ON recipe_ingredient_ref_link (created_at)
Drop
ix_recipe_ingredient_ref_link_instruction_id instruction_id SQL 
CREATE INDEX ix_recipe_ingredient_ref_link_instruction_id
ON recipe_ingredient_ref_link (instruction_id)
Drop
ix_recipe_ingredient_ref_link_reference_id reference_id SQL 
CREATE INDEX ix_recipe_ingredient_ref_link_reference_id
ON recipe_ingredient_ref_link (reference_id)
Drop