mk6i-open-oscar-server/state/migrations/0005_user_settings.down.sql

CREATE TABLE users_backup
(
    identScreenName   VARCHAR(16) PRIMARY KEY,
    displayScreenName TEXT,
    authKey           TEXT,
    strongMD5Pass     TEXT,
    weakMD5Pass       TEXT
);

INSERT INTO users_backup (identScreenName, displayScreenName, authKey, strongMD5Pass, weakMD5Pass)
SELECT identScreenName, displayScreenName, authKey, strongMD5Pass, weakMD5Pass
FROM users;

DROP TABLE users;

ALTER TABLE users_backup
    RENAME TO users;