Query

mealie.db — group_events_notifier...

SQL

CREATE TABLE "group_events_notifier_options"  (
  created_at DATETIME,
  update_at DATETIME,
  id CHAR(32) NOT NULL,
  event_notifier_id CHAR(32) NOT NULL,
  recipe_created BOOLEAN NOT NULL,
  recipe_updated BOOLEAN NOT NULL,
  recipe_deleted BOOLEAN NOT NULL,
  user_signup BOOLEAN NOT NULL,
  data_migrations BOOLEAN NOT NULL,
  data_export BOOLEAN NOT NULL,
  data_import BOOLEAN NOT NULL,
  mealplan_entry_created BOOLEAN NOT NULL,
  shopping_list_created BOOLEAN NOT NULL,
  shopping_list_updated BOOLEAN NOT NULL,
  shopping_list_deleted BOOLEAN NOT NULL,
  cookbook_created BOOLEAN NOT NULL,
  cookbook_updated BOOLEAN NOT NULL,
  cookbook_deleted BOOLEAN NOT NULL,
  tag_created BOOLEAN NOT NULL,
  tag_updated BOOLEAN NOT NULL,
  tag_deleted BOOLEAN NOT NULL,
  category_created BOOLEAN NOT NULL,
  category_updated BOOLEAN NOT NULL,
  category_deleted BOOLEAN NOT NULL,
  label_created BOOLEAN DEFAULT 0 NOT NULL,
  label_updated BOOLEAN DEFAULT 0 NOT NULL,
  label_deleted BOOLEAN DEFAULT 0 NOT NULL,
  PRIMARY KEY (id),
  FOREIGN KEY(event_notifier_id) REFERENCES group_events_notifiers (id)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
created_at DATETIME ✓ Rename | Drop
update_at DATETIME ✓ Rename | Drop
id CHAR(32) ✓ Rename | Drop
event_notifier_id CHAR(32) Rename | Drop
recipe_created BOOLEAN Rename | Drop
recipe_updated BOOLEAN Rename | Drop
recipe_deleted BOOLEAN Rename | Drop
user_signup BOOLEAN Rename | Drop
data_migrations BOOLEAN Rename | Drop
data_export BOOLEAN Rename | Drop
data_import BOOLEAN Rename | Drop
mealplan_entry_created BOOLEAN Rename | Drop
shopping_list_created BOOLEAN Rename | Drop
shopping_list_updated BOOLEAN Rename | Drop
shopping_list_deleted BOOLEAN Rename | Drop
cookbook_created BOOLEAN Rename | Drop
cookbook_updated BOOLEAN Rename | Drop
cookbook_deleted BOOLEAN Rename | Drop
tag_created BOOLEAN Rename | Drop
tag_updated BOOLEAN Rename | Drop
tag_deleted BOOLEAN Rename | Drop
category_created BOOLEAN Rename | Drop
category_updated BOOLEAN Rename | Drop
category_deleted BOOLEAN Rename | Drop
label_created BOOLEAN Rename | Drop
label_updated BOOLEAN Rename | Drop
label_deleted BOOLEAN Rename | Drop

Foreign Keys

Column Destination
event_notifier_id group_events_notifiers.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
ix_group_events_notifier_options_created_at created_at SQL 
CREATE INDEX ix_group_events_notifier_options_created_at
ON group_events_notifier_options (created_at)
Drop
sqlite_autoindex_group_events_notifier_options_1 id ✓ SQL
-- no sql found --
 Drop