x8jzgcay

1-- <UMCS-263_38b2aa68d50440d69eb84037b2e42bef> sam
2
3CREATE TABLE IF NOT EXISTS "__EFMigrationsHistory" (
4    "MigrationId" varchar(150) NOT NULL,
5    "ProductVersion" varchar(32) NOT NULL,
6    CONSTRAINT "PK___EFMigrationsHistory" PRIMARY KEY ("MigrationId")
7);
8
9
10DO $$
11BEGIN
12    IF NOT EXISTS(SELECT 1 FROM "__EFMigrationsHistory" WHERE "MigrationId" = '20180222124611_UMCS_263_38b2aa68d50440d69eb84037b2e42bef') THEN
13    INSERT INTO "__EFMigrationsHistory" ("MigrationId", "ProductVersion")
14    VALUES ('20180222124611_UMCS_263_38b2aa68d50440d69eb84037b2e42bef', '2.0.0-rtm-26452');
15    END IF;
16END $$;
17
18-- </UMCS-263_38b2aa68d50440d69eb84037b2e42bef>
19
20
21-- <UMCS-263_5d8ea5a45f7b4384b469caba2626f3a8> sam
22
23CREATE TABLE IF NOT EXISTS "__EFMigrationsHistory" (
24    "MigrationId" varchar(150) NOT NULL,
25    "ProductVersion" varchar(32) NOT NULL,
26    CONSTRAINT "PK___EFMigrationsHistory" PRIMARY KEY ("MigrationId")
27);
28
29
30DO $$
31BEGIN
32    IF NOT EXISTS(SELECT 1 FROM "__EFMigrationsHistory" WHERE "MigrationId" = '20180222124634_UMCS_263_5d8ea5a45f7b4384b469caba2626f3a8') THEN
33    INSERT INTO "__EFMigrationsHistory" ("MigrationId", "ProductVersion")
34    VALUES ('20180222124634_UMCS_263_5d8ea5a45f7b4384b469caba2626f3a8', '2.0.0-rtm-26452');
35    END IF;
36END $$;
37
38-- </UMCS-263_5d8ea5a45f7b4384b469caba2626f3a8>
39
40
41-- <UMCS-263_34276d8bffa14d6eacce5478914d3f4a> sam
42
43CREATE TABLE IF NOT EXISTS "__EFMigrationsHistory" (
44    "MigrationId" varchar(150) NOT NULL,
45    "ProductVersion" varchar(32) NOT NULL,
46    CONSTRAINT "PK___EFMigrationsHistory" PRIMARY KEY ("MigrationId")
47);
48
49
50DO $$
51BEGIN
52    IF NOT EXISTS(SELECT 1 FROM "__EFMigrationsHistory" WHERE "MigrationId" = '20180222124659_UMCS_263_34276d8bffa14d6eacce5478914d3f4a') THEN
53    INSERT INTO "__EFMigrationsHistory" ("MigrationId", "ProductVersion")
54    VALUES ('20180222124659_UMCS_263_34276d8bffa14d6eacce5478914d3f4a', '2.0.0-rtm-26452');
55    END IF;
56END $$;
57
58-- </UMCS-263_34276d8bffa14d6eacce5478914d3f4a>
59
60
61-- <UMCS-263_73ebe48a7ea045deb49aefa35bdd0a4e> sam
62
63CREATE TABLE IF NOT EXISTS "__EFMigrationsHistory" (
64    "MigrationId" varchar(150) NOT NULL,
65    "ProductVersion" varchar(32) NOT NULL,
66    CONSTRAINT "PK___EFMigrationsHistory" PRIMARY KEY ("MigrationId")
67);
68
69
70DO $$
71BEGIN
72    IF NOT EXISTS(SELECT 1 FROM "__EFMigrationsHistory" WHERE "MigrationId" = '20180222124722_UMCS_263_73ebe48a7ea045deb49aefa35bdd0a4e') THEN
73    ALTER TABLE "emission"."card_state" DROP CONSTRAINT "fk_card_state_card_state_operator_id";
74    END IF;
75END $$;
76
77DO $$
78BEGIN
79    IF NOT EXISTS(SELECT 1 FROM "__EFMigrationsHistory" WHERE "MigrationId" = '20180222124722_UMCS_263_73ebe48a7ea045deb49aefa35bdd0a4e') THEN
80    DROP INDEX "emission"."ix_card_state_operator_id";
81    END IF;
82END $$;
83
84DO $$
85BEGIN
86    IF NOT EXISTS(SELECT 1 FROM "__EFMigrationsHistory" WHERE "MigrationId" = '20180222124722_UMCS_263_73ebe48a7ea045deb49aefa35bdd0a4e') THEN
87    ALTER TABLE "emission"."card_state" DROP COLUMN "action_execution_utc_ticks";
88    END IF;
89END $$;
90
91DO $$
92BEGIN
93    IF NOT EXISTS(SELECT 1 FROM "__EFMigrationsHistory" WHERE "MigrationId" = '20180222124722_UMCS_263_73ebe48a7ea045deb49aefa35bdd0a4e') THEN
94    ALTER TABLE "emission"."card_state" DROP COLUMN "comment";
95    END IF;
96END $$;
97
98DO $$
99BEGIN
100    IF NOT EXISTS(SELECT 1 FROM "__EFMigrationsHistory" WHERE "MigrationId" = '20180222124722_UMCS_263_73ebe48a7ea045deb49aefa35bdd0a4e') THEN
101    ALTER TABLE "emission"."card_state" DROP COLUMN "operator_id";
102    END IF;
103END $$;
104
105DO $$
106BEGIN
107    IF NOT EXISTS(SELECT 1 FROM "__EFMigrationsHistory" WHERE "MigrationId" = '20180222124722_UMCS_263_73ebe48a7ea045deb49aefa35bdd0a4e') THEN
108    ALTER TABLE "emission"."card_state" DROP COLUMN "transition_initiator";
109    END IF;
110END $$;
111
112DO $$
113BEGIN
114    IF NOT EXISTS(SELECT 1 FROM "__EFMigrationsHistory" WHERE "MigrationId" = '20180222124722_UMCS_263_73ebe48a7ea045deb49aefa35bdd0a4e') THEN
115    ALTER TABLE "emission"."card_state" DROP COLUMN "user_id";
116    END IF;
117END $$;
118
119DO $$
120BEGIN
121    IF NOT EXISTS(SELECT 1 FROM "__EFMigrationsHistory" WHERE "MigrationId" = '20180222124722_UMCS_263_73ebe48a7ea045deb49aefa35bdd0a4e') THEN
122    INSERT INTO "__EFMigrationsHistory" ("MigrationId", "ProductVersion")
123    VALUES ('20180222124722_UMCS_263_73ebe48a7ea045deb49aefa35bdd0a4e', '2.0.0-rtm-26452');
124    END IF;
125END $$;
126
127-- </UMCS-263_73ebe48a7ea045deb49aefa35bdd0a4e>
128
129
130-- <UMCS-263_bcb893f5d5474e4aa6dea9b35ab72eb8> sam
131
132CREATE TABLE IF NOT EXISTS "__EFMigrationsHistory" (
133    "MigrationId" varchar(150) NOT NULL,
134    "ProductVersion" varchar(32) NOT NULL,
135    CONSTRAINT "PK___EFMigrationsHistory" PRIMARY KEY ("MigrationId")
136);
137
138
139DO $$
140BEGIN
141    IF NOT EXISTS(SELECT 1 FROM "__EFMigrationsHistory" WHERE "MigrationId" = '20180222124746_UMCS_263_bcb893f5d5474e4aa6dea9b35ab72eb8') THEN
142    INSERT INTO "__EFMigrationsHistory" ("MigrationId", "ProductVersion")
143    VALUES ('20180222124746_UMCS_263_bcb893f5d5474e4aa6dea9b35ab72eb8', '2.0.0-rtm-26452');
144    END IF;
145END $$;
146
147-- </UMCS-263_bcb893f5d5474e4aa6dea9b35ab72eb8>