GmtAwFPt

1BEGIN tran;
2
3IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[LD3FlexibleRuntimeStageState]') AND type in (N'U'))
4BEGIN
5CREATE TABLE [dbo].[LD3FlexibleRuntimeStageState](
6	[ID] int NOT NULL,
7	[Name] nvarchar(128) NOT NULL,
8	[DisplayName] nvarchar(256) NOT NULL
9 CONSTRAINT [PK_LD3FLEXIBLERUNTIMESTAGESTATE] PRIMARY KEY CLUSTERED 
10(
11	[ID] ASC
12)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
13) ON [PRIMARY]
14END
15
16IF NOT EXISTS (SELECT * FROM [dbo].[LD3FlexibleRuntimeStageState] WHERE ID = 1)
17	INSERT INTO [dbo].[LD3FlexibleRuntimeStageState] (ID, Name, DisplayName)
18	VALUES
19		(1, 'Project', 'Проект')
20
21IF NOT EXISTS (SELECT * FROM [dbo].[LD3FlexibleRuntimeStageState] WHERE ID = 2)
22	INSERT INTO [dbo].[LD3FlexibleRuntimeStageState] (ID, Name, DisplayName)
23	VALUES
24		(2, 'InWork', 'Ожидается отчёт')
25
26IF NOT EXISTS (SELECT * FROM [dbo].[LD3FlexibleRuntimeStageState] WHERE ID = 3)
27	INSERT INTO [dbo].[LD3FlexibleRuntimeStageState] (ID, Name, DisplayName)
28	VALUES
29		(3, 'Refused', 'Отчёт пришёл, отказано')
30
31IF NOT EXISTS (SELECT * FROM [dbo].[LD3FlexibleRuntimeStageState] WHERE ID = 4)
32	INSERT INTO [dbo].[LD3FlexibleRuntimeStageState] (ID, Name, DisplayName)
33	VALUES
34		(4, 'Accepted', 'Отчёт пришёл, принято')
35
36IF NOT EXISTS (SELECT * FROM [dbo].[LD3FlexibleRuntimeStageState] WHERE ID = 5)
37	INSERT INTO [dbo].[LD3FlexibleRuntimeStageState] (ID, Name, DisplayName)
38	VALUES
39		(5, 'Cancelled', 'Задание отозвано')
40
41IF NOT EXISTS (SELECT * FROM [dbo].[LD3FlexibleRuntimeStageState] WHERE ID = 6)
42	INSERT INTO [dbo].[LD3FlexibleRuntimeStageState] (ID, Name, DisplayName)
43	VALUES
44		(6, 'Deleted', 'Задание удалено')
45
46IF NOT EXISTS (SELECT * FROM [dbo].[LD3FlexibleRuntimeStageState] WHERE ID = 7)
47	INSERT INTO [dbo].[LD3FlexibleRuntimeStageState] (ID, Name, DisplayName)
48	VALUES
49		(7, 'Repeat', 'Повтор задания')
50
51IF NOT EXISTS (SELECT * FROM sys.columns WHERE  object_id = OBJECT_ID(N'[dbo].[LD3FlexibleRuntimeStage]') AND name = 'StateID')
52	ALTER TABLE [dbo].[LD3FlexibleRuntimeStage] ADD StateID INT
53
54IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'FK_LD3LEXIBLERUNTIMESTAGE_STATE')
55   AND parent_object_id = OBJECT_ID(N'dbo.LD3FlexibleRuntimeStage')
56)
57	ALTER TABLE [dbo].[LD3FlexibleRuntimeStage] DROP CONSTRAINT [FK_LD3LEXIBLERUNTIMESTAGE_STATE]
58
59ALTER TABLE dbo.[LD3FlexibleRuntimeStage]
60ADD CONSTRAINT [FK_LD3LEXIBLERUNTIMESTAGE_STATE] FOREIGN KEY (StateID)
61    REFERENCES dbo.[LD3FlexibleRuntimeStageState] (ID)
62
63commit;
64