Create
Query
mealie.db
—
group_events_notifier...
alembic_version
api_extras
categories
cookbooks
cookbooks_to_categories
cookbooks_to_tags
cookbooks_to_tools
group_data_exports
group_events_notifier...
group_events_notifiers
group_meal_plan_rules
group_meal_plans
group_preferences
group_reports
group_to_categories
groups
household_preferences
households
households_to_ingredi...
households_to_recipes
households_to_tools
ingredient_food_extras
ingredient_foods
ingredient_foods_aliases
ingredient_units
ingredient_units_aliases
invite_tokens
long_live_tokens
multi_purpose_labels
notes
password_reset_tokens
plan_rules_to_categories
plan_rules_to_households
plan_rules_to_tags
recipe_actions
recipe_assets
recipe_comments
recipe_ingredient_ref_link
recipe_instructions
recipe_nutrition
recipe_settings
recipe_share_tokens
recipe_timeline_events
recipes
recipes_ingredients
recipes_to_categories
recipes_to_tags
recipes_to_tools
report_entries
server_tasks
shopping_list_extras
shopping_list_item_extras
shopping_list_item_re...
shopping_list_items
shopping_list_recipe_...
shopping_lists
shopping_lists_multi_...
tags
tools
users
users_to_recipes
webhook_urls
Toggle helper tables
Structure
Content
Query
Insert
Drop
Import
Export
Insert row into group_events_notifier_options
created_at
DATETIME
update_at
DATETIME
id
Primary key.
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 NOT NULL (default 0)
label_updated
BOOLEAN NOT NULL (default 0)
label_deleted
BOOLEAN NOT NULL (default 0)
Insert
Cancel