Query

mealie.db — group_meal_plans

SQL

CREATE TABLE "group_meal_plans"  (
  id INTEGER NOT NULL,
  created_at DATETIME,
  update_at DATETIME,
  date DATE NOT NULL,
  entry_type VARCHAR NOT NULL,
  title VARCHAR NOT NULL,
  text VARCHAR NOT NULL,
  group_id CHAR(32),
  recipe_id CHAR(32),
  user_id CHAR(32),
  PRIMARY KEY (id),
  CONSTRAINT fk_user_mealplans FOREIGN KEY(user_id) REFERENCES users (id),
  FOREIGN KEY(recipe_id) REFERENCES recipes (id),
  FOREIGN KEY(group_id) REFERENCES groups (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
date DATE Rename | Drop
entry_type VARCHAR Rename | Drop
title VARCHAR Rename | Drop
text VARCHAR Rename | Drop
group_id CHAR(32) ✓ Rename | Drop
recipe_id CHAR(32) ✓ Rename | Drop
user_id CHAR(32) ✓ Rename | Drop

Foreign Keys

Column Destination
group_id groups.id
recipe_id recipes.id
user_id users.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
ix_group_meal_plans_created_at created_at SQL 
CREATE INDEX ix_group_meal_plans_created_at
ON group_meal_plans (created_at)
Drop
ix_group_meal_plans_date date SQL 
CREATE INDEX ix_group_meal_plans_date
ON group_meal_plans (date)
Drop
ix_group_meal_plans_entry_type entry_type SQL 
CREATE INDEX ix_group_meal_plans_entry_type
ON group_meal_plans (entry_type)
Drop
ix_group_meal_plans_group_id group_id SQL 
CREATE INDEX ix_group_meal_plans_group_id
ON group_meal_plans (group_id)
Drop
ix_group_meal_plans_recipe_id recipe_id SQL 
CREATE INDEX ix_group_meal_plans_recipe_id
ON group_meal_plans (recipe_id)
Drop
ix_group_meal_plans_title title SQL 
CREATE INDEX ix_group_meal_plans_title
ON group_meal_plans (title)
Drop
ix_group_meal_plans_user_id user_id SQL 
CREATE INDEX ix_group_meal_plans_user_id
ON group_meal_plans (user_id)
Drop