-- The body a webhook receives (hub spec §12.2): `oxygenhub` (the signed

-- envelope), `discord` or `slack`. Discord and Slack webhooks made before

-- formats existed switch to their format, since they never accepted the envelope.

ALTER TABLE hooks ADD COLUMN format TEXT NOT NULL DEFAULT 'oxygenhub' CHECK (format IN ('oxygenhub', 'discord', 'slack'));

UPDATE hooks SET format = 'discord'

 WHERE url LIKE 'https://discord.com/api/webhooks/%' OR url LIKE 'https://discordapp.com/api/webhooks/%'

    OR url LIKE 'https://canary.discord.com/api/webhooks/%' OR url LIKE 'https://ptb.discord.com/api/webhooks/%';

UPDATE hooks SET format = 'slack' WHERE url LIKE 'https://hooks.slack.com/%';