Modrinth/apps/labrinth/migrations/20221206221021_webhook-sent.sql
2024-10-16 14:11:42 -07:00

9 lines
217 B
SQL

-- Add migration script here
ALTER TABLE mods ADD COLUMN webhook_sent BOOL NOT NULL DEFAULT FALSE;
UPDATE mods
SET webhook_sent = (status = 'approved');
UPDATE mods
SET status = 'withheld'
WHERE status = 'unlisted';