ESbv2irB

1do
2$$
3BEGIN
4
5CREATE TABLE if not exists dbo.LD3FlexibleRuntimeStageStatus (
6  "ID" INTEGER NOT NULL,
7  "Name" varchar(128) NOT NULL,
8  "DisplayName"  varchar(256) NOT NULL,
9  CONSTRAINT PK_LD3FLEXIBLERUNTIMESTAGESTATUS PRIMARY KEY ("ID")
10);
11
12IF NOT EXISTS (SELECT 1 FROM dbo.LD3FlexibleRuntimeStageStatus rss WHERE rss."ID" = 1) THEN
13	INSERT INTO dbo.LD3FlexibleRuntimeStageStatus ("ID", "Name", "DisplayName")
14	VALUES
15		(1, 'Project', 'Проект');
16END IF;
17
18IF NOT EXISTS (SELECT 1 FROM dbo.LD3FlexibleRuntimeStageStatus rss WHERE rss."ID" = 2) THEN
19	INSERT INTO dbo.LD3FlexibleRuntimeStageStatus ("ID", "Name", "DisplayName")
20	VALUES
21		(2, 'InWork', 'Ожидается отчёт');
22END IF;
23
24IF NOT EXISTS (SELECT 1 FROM dbo.LD3FlexibleRuntimeStageStatus rss WHERE rss."ID" = 3) THEN
25	INSERT INTO dbo.LD3FlexibleRuntimeStageStatus ("ID", "Name", "DisplayName")
26	VALUES
27		(3, 'Refused', 'Отчёт пришёл, отказано');
28END IF;
29
30IF NOT EXISTS (SELECT 1 FROM dbo.LD3FlexibleRuntimeStageStatus rss WHERE rss."ID" = 4) THEN
31	INSERT INTO dbo.LD3FlexibleRuntimeStageStatus ("ID", "Name", "DisplayName")
32	VALUES
33		(4, 'Accepted', 'Отчёт пришёл, принято');
34END IF;
35
36IF NOT EXISTS (SELECT 1 FROM dbo.LD3FlexibleRuntimeStageStatus rss WHERE rss."ID" = 5) THEN
37	INSERT INTO dbo.LD3FlexibleRuntimeStageStatus ("ID", "Name", "DisplayName")
38	VALUES
39		(5, 'Cancelled', 'Задание отозвано');
40END IF;
41
42IF NOT EXISTS (SELECT 1 FROM dbo.LD3FlexibleRuntimeStageStatus rss WHERE rss."ID" = 6) THEN
43	INSERT INTO dbo.LD3FlexibleRuntimeStageStatus ("ID", "Name", "DisplayName")
44	VALUES
45		(6, 'Deleted', 'Задание удалено');
46END IF;
47
48IF NOT EXISTS (SELECT 1 FROM dbo.LD3FlexibleRuntimeStageStatus rss WHERE rss."ID" = 7) THEN
49	INSERT INTO dbo.LD3FlexibleRuntimeStageStatus ("ID", "Name", "DisplayName")
50	VALUES
51		(7, 'Repeat', 'Повтор задания');
52END IF;
53
54ALTER TABLE dbo.LD3FlexibleRuntimeStage ADD COLUMN IF NOT EXISTS "StateID" INTEGER
55CONSTRAINT FK_LD3LEXIBLERUNTIMESTAGE_STATE REFERENCES dbo.LD3FlexibleRuntimeStageStatus ("ID");
56
57end;
58$$