Query

mealie.db — ingredient_foods_aliases

SQL

CREATE TABLE ingredient_foods_aliases  (
  id CHAR(32) NOT NULL,
  food_id CHAR(32) NOT NULL,
  name VARCHAR NOT NULL,
  name_normalized VARCHAR,
  created_at DATETIME,
  update_at DATETIME,
  PRIMARY KEY (id, food_id),
  FOREIGN KEY(food_id) REFERENCES ingredient_foods (id)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id CHAR(32) ✓ Rename | Drop
food_id CHAR(32) ✓ Rename | Drop
name VARCHAR Rename | Drop
name_normalized VARCHAR ✓ Rename | Drop
created_at DATETIME ✓ Rename | Drop
update_at DATETIME ✓ Rename | Drop

Foreign Keys

Column Destination
food_id ingredient_foods.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
ix_ingredient_foods_aliases_created_at created_at SQL 
CREATE INDEX ix_ingredient_foods_aliases_created_at
ON ingredient_foods_aliases (created_at)
Drop
ix_ingredient_foods_aliases_name_normalized name_normalized SQL 
CREATE INDEX ix_ingredient_foods_aliases_name_normalized
ON ingredient_foods_aliases (name_normalized)
Drop
sqlite_autoindex_ingredient_foods_aliases_1
  • id
  • food_id
 ✓ SQL
-- no sql found --
 Drop