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)
)