Migrating from RelStorage version 1.1 to version 1.1.1

Before following these directions, first upgrade to the schema of RelStorage version 1.1 by following the directions in Migrating from RelStorage version 1.0 or 1.0.1 to version 1.1.

PostgreSQL:

DROP TABLE pack_object;
CREATE TABLE pack_object (
    zoid        BIGINT NOT NULL PRIMARY KEY,
    keep        BOOLEAN NOT NULL,
    keep_tid    BIGINT NOT NULL,
    visited     BOOLEAN NOT NULL DEFAULT FALSE
);
CREATE INDEX pack_object_keep_false ON pack_object (zoid)
    WHERE keep = false;
CREATE INDEX pack_object_keep_true ON pack_object (visited)
    WHERE keep = true;

MySQL:

DROP TABLE pack_object;
CREATE TABLE pack_object (
    zoid        BIGINT NOT NULL PRIMARY KEY,
    keep        BOOLEAN NOT NULL,
    keep_tid    BIGINT NOT NULL,
    visited     BOOLEAN NOT NULL DEFAULT FALSE
) ENGINE = MyISAM;
CREATE INDEX pack_object_keep_zoid ON pack_object (keep, zoid);

Oracle:

DROP TABLE pack_object;
CREATE TABLE pack_object (
    zoid        NUMBER(20) NOT NULL PRIMARY KEY,
    keep        CHAR NOT NULL CHECK (keep IN ('N', 'Y')),
    keep_tid    NUMBER(20) NOT NULL,
    visited     CHAR DEFAULT 'N' NOT NULL CHECK (visited IN ('N', 'Y'))
);
CREATE INDEX pack_object_keep_zoid ON pack_object (keep, zoid);