mautrix-whatsapp/database/upgrades/42-backfillqueue-type-order.sql
2022-05-26 11:23:15 +03:00

10 lines
201 B
SQL

-- v42: Update backfill queue tables to be sortable by priority
UPDATE backfill_queue
SET type=CASE
WHEN type = 1 THEN 200
WHEN type = 2 THEN 300
ELSE type
END
WHERE type = 1 OR type = 2;