Query

mealie.db — webhook_urls

SQL

CREATE TABLE "webhook_urls"  (
  created_at DATETIME,
  update_at DATETIME,
  id CHAR(32) NOT NULL,
  group_id CHAR(32),
  enabled BOOLEAN,
  name VARCHAR,
  url VARCHAR,
  time VARCHAR,
  webhook_type VARCHAR,
  scheduled_time TIME,
  household_id CHAR(32),
  PRIMARY KEY (id),
  CONSTRAINT fk_webhook_urls_household_id FOREIGN KEY(household_id) REFERENCES households (id),
  FOREIGN KEY(group_id) REFERENCES groups (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
group_id CHAR(32) ✓ Rename | Drop
enabled BOOLEAN ✓ Rename | Drop
name VARCHAR ✓ Rename | Drop
url VARCHAR ✓ Rename | Drop
time VARCHAR ✓ Rename | Drop
webhook_type VARCHAR ✓ Rename | Drop
scheduled_time TIME ✓ Rename | Drop
household_id CHAR(32) ✓ Rename | Drop

Foreign Keys

Column Destination
group_id groups.id
household_id households.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
ix_webhook_urls_created_at created_at SQL 
CREATE INDEX ix_webhook_urls_created_at
ON webhook_urls (created_at)
Drop
ix_webhook_urls_group_id group_id SQL 
CREATE INDEX ix_webhook_urls_group_id
ON webhook_urls (group_id)
Drop
ix_webhook_urls_household_id household_id SQL 
CREATE INDEX ix_webhook_urls_household_id
ON webhook_urls (household_id)
Drop
sqlite_autoindex_webhook_urls_1 id ✓ SQL
-- no sql found --
 Drop