mk6i-open-oscar-server/state/migrations/0044_feedbag_fk.down.sql

ALTER TABLE feedbag
    RENAME TO feedbag_new;

CREATE TABLE feedbag
(
    screenName   VARCHAR(16),
    groupID      INTEGER,
    itemID       INTEGER,
    classID      INTEGER,
    name         TEXT,
    attributes   BLOB,
    lastModified INTEGER,
    pdMode       INT              DEFAULT 0,
    authPending  BOOLEAN NOT NULL DEFAULT FALSE,
    UNIQUE (screenName, groupID, itemID)
);

INSERT INTO feedbag (screenName, groupID, itemID, classID, name, attributes, lastModified, pdMode, authPending)
SELECT screenName, groupID, itemID, classID, name, attributes, lastModified, pdMode, authPending
FROM feedbag_new;

DROP TABLE feedbag_new;