snikket-ios/Shared/db-schema-7.sql

13 lines
350 B
PL/PgSQL

BEGIN;
UPDATE chat_history SET state = 11 WHERE state = 5;
UPDATE chat_history SET state = 5 WHERE state = 9;
UPDATE chat_history SET state = 9 WHERE state = 4;
UPDATE chat_history SET state = 4 WHERE state = 7;
UPDATE chat_history SET state = 7 WHERE state = 6;
UPDATE chat_history SET state = 6 WHERE state = 8;
COMMIT;
PRAGMA user_version = 7;