-- <UMCS-263_38b2aa68d50440d69eb84037b2e42bef> sam

CREATE TABLE IF NOT EXISTS "__EFMigrationsHistory" (
    "MigrationId" varchar(150) NOT NULL,
    "ProductVersion" varchar(32) NOT NULL,
    CONSTRAINT "PK___EFMigrationsHistory" PRIMARY KEY ("MigrationId")
);


DO $$
BEGIN
    IF NOT EXISTS(SELECT 1 FROM "__EFMigrationsHistory" WHERE "MigrationId" = '20180222124611_UMCS_263_38b2aa68d50440d69eb84037b2e42bef') THEN
    INSERT INTO "__EFMigrationsHistory" ("MigrationId", "ProductVersion")
    VALUES ('20180222124611_UMCS_263_38b2aa68d50440d69eb84037b2e42bef', '2.0.0-rtm-26452');
    END IF;
END $$;

-- </UMCS-263_38b2aa68d50440d69eb84037b2e42bef>


-- <UMCS-263_5d8ea5a45f7b4384b469caba2626f3a8> sam

CREATE TABLE IF NOT EXISTS "__EFMigrationsHistory" (
    "MigrationId" varchar(150) NOT NULL,
    "ProductVersion" varchar(32) NOT NULL,
    CONSTRAINT "PK___EFMigrationsHistory" PRIMARY KEY ("MigrationId")
);


DO $$
BEGIN
    IF NOT EXISTS(SELECT 1 FROM "__EFMigrationsHistory" WHERE "MigrationId" = '20180222124634_UMCS_263_5d8ea5a45f7b4384b469caba2626f3a8') THEN
    INSERT INTO "__EFMigrationsHistory" ("MigrationId", "ProductVersion")
    VALUES ('20180222124634_UMCS_263_5d8ea5a45f7b4384b469caba2626f3a8', '2.0.0-rtm-26452');
    END IF;
END $$;

-- </UMCS-263_5d8ea5a45f7b4384b469caba2626f3a8>


-- <UMCS-263_34276d8bffa14d6eacce5478914d3f4a> sam

CREATE TABLE IF NOT EXISTS "__EFMigrationsHistory" (
    "MigrationId" varchar(150) NOT NULL,
    "ProductVersion" varchar(32) NOT NULL,
    CONSTRAINT "PK___EFMigrationsHistory" PRIMARY KEY ("MigrationId")
);


DO $$
BEGIN
    IF NOT EXISTS(SELECT 1 FROM "__EFMigrationsHistory" WHERE "MigrationId" = '20180222124659_UMCS_263_34276d8bffa14d6eacce5478914d3f4a') THEN
    INSERT INTO "__EFMigrationsHistory" ("MigrationId", "ProductVersion")
    VALUES ('20180222124659_UMCS_263_34276d8bffa14d6eacce5478914d3f4a', '2.0.0-rtm-26452');
    END IF;
END $$;

-- </UMCS-263_34276d8bffa14d6eacce5478914d3f4a>


-- <UMCS-263_73ebe48a7ea045deb49aefa35bdd0a4e> sam

CREATE TABLE IF NOT EXISTS "__EFMigrationsHistory" (
    "MigrationId" varchar(150) NOT NULL,
    "ProductVersion" varchar(32) NOT NULL,
    CONSTRAINT "PK___EFMigrationsHistory" PRIMARY KEY ("MigrationId")
);


DO $$
BEGIN
    IF NOT EXISTS(SELECT 1 FROM "__EFMigrationsHistory" WHERE "MigrationId" = '20180222124722_UMCS_263_73ebe48a7ea045deb49aefa35bdd0a4e') THEN
    ALTER TABLE "emission"."card_state" DROP CONSTRAINT "fk_card_state_card_state_operator_id";
    END IF;
END $$;

DO $$
BEGIN
    IF NOT EXISTS(SELECT 1 FROM "__EFMigrationsHistory" WHERE "MigrationId" = '20180222124722_UMCS_263_73ebe48a7ea045deb49aefa35bdd0a4e') THEN
    DROP INDEX "emission"."ix_card_state_operator_id";
    END IF;
END $$;

DO $$
BEGIN
    IF NOT EXISTS(SELECT 1 FROM "__EFMigrationsHistory" WHERE "MigrationId" = '20180222124722_UMCS_263_73ebe48a7ea045deb49aefa35bdd0a4e') THEN
    ALTER TABLE "emission"."card_state" DROP COLUMN "action_execution_utc_ticks";
    END IF;
END $$;

DO $$
BEGIN
    IF NOT EXISTS(SELECT 1 FROM "__EFMigrationsHistory" WHERE "MigrationId" = '20180222124722_UMCS_263_73ebe48a7ea045deb49aefa35bdd0a4e') THEN
    ALTER TABLE "emission"."card_state" DROP COLUMN "comment";
    END IF;
END $$;

DO $$
BEGIN
    IF NOT EXISTS(SELECT 1 FROM "__EFMigrationsHistory" WHERE "MigrationId" = '20180222124722_UMCS_263_73ebe48a7ea045deb49aefa35bdd0a4e') THEN
    ALTER TABLE "emission"."card_state" DROP COLUMN "operator_id";
    END IF;
END $$;

DO $$
BEGIN
    IF NOT EXISTS(SELECT 1 FROM "__EFMigrationsHistory" WHERE "MigrationId" = '20180222124722_UMCS_263_73ebe48a7ea045deb49aefa35bdd0a4e') THEN
    ALTER TABLE "emission"."card_state" DROP COLUMN "transition_initiator";
    END IF;
END $$;

DO $$
BEGIN
    IF NOT EXISTS(SELECT 1 FROM "__EFMigrationsHistory" WHERE "MigrationId" = '20180222124722_UMCS_263_73ebe48a7ea045deb49aefa35bdd0a4e') THEN
    ALTER TABLE "emission"."card_state" DROP COLUMN "user_id";
    END IF;
END $$;

DO $$
BEGIN
    IF NOT EXISTS(SELECT 1 FROM "__EFMigrationsHistory" WHERE "MigrationId" = '20180222124722_UMCS_263_73ebe48a7ea045deb49aefa35bdd0a4e') THEN
    INSERT INTO "__EFMigrationsHistory" ("MigrationId", "ProductVersion")
    VALUES ('20180222124722_UMCS_263_73ebe48a7ea045deb49aefa35bdd0a4e', '2.0.0-rtm-26452');
    END IF;
END $$;

-- </UMCS-263_73ebe48a7ea045deb49aefa35bdd0a4e>


-- <UMCS-263_bcb893f5d5474e4aa6dea9b35ab72eb8> sam

CREATE TABLE IF NOT EXISTS "__EFMigrationsHistory" (
    "MigrationId" varchar(150) NOT NULL,
    "ProductVersion" varchar(32) NOT NULL,
    CONSTRAINT "PK___EFMigrationsHistory" PRIMARY KEY ("MigrationId")
);


DO $$
BEGIN
    IF NOT EXISTS(SELECT 1 FROM "__EFMigrationsHistory" WHERE "MigrationId" = '20180222124746_UMCS_263_bcb893f5d5474e4aa6dea9b35ab72eb8') THEN
    INSERT INTO "__EFMigrationsHistory" ("MigrationId", "ProductVersion")
    VALUES ('20180222124746_UMCS_263_bcb893f5d5474e4aa6dea9b35ab72eb8', '2.0.0-rtm-26452');
    END IF;
END $$;

-- </UMCS-263_bcb893f5d5474e4aa6dea9b35ab72eb8>