Query

mealie.db — plan_rules_to_tags

SQL

CREATE TABLE "plan_rules_to_tags"  (
  plan_rule_id CHAR(32),
  tag_id CHAR(32),
  CONSTRAINT plan_rule_id_tag_id_key UNIQUE (plan_rule_id, tag_id),
  FOREIGN KEY(plan_rule_id) REFERENCES group_meal_plan_rules (id),
  FOREIGN KEY(tag_id) REFERENCES tags (id)
)

+ Add column

Columns

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

Foreign Keys

Column Destination
tag_id tags.id
plan_rule_id group_meal_plan_rules.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
ix_plan_rules_to_tags_plan_rule_id plan_rule_id SQL 
CREATE INDEX ix_plan_rules_to_tags_plan_rule_id
ON plan_rules_to_tags (plan_rule_id)
Drop
ix_plan_rules_to_tags_tag_id tag_id SQL 
CREATE INDEX ix_plan_rules_to_tags_tag_id
ON plan_rules_to_tags (tag_id)
Drop
sqlite_autoindex_plan_rules_to_tags_1
  • plan_rule_id
  • tag_id
 ✓ SQL
-- no sql found --
 Drop