SUqUDWKq

1CREATE TABLE [Topology].[LineGroupPurpose] (
2    [LineGroupPurposeId] bigint NOT NULL IDENTITY,
3    [Name] nvarchar(max) NULL,
4    CONSTRAINT [PK_Demarso.LineGroupPurpose] PRIMARY KEY ([LineGroupPurposeId])
5);
6
7GO
8
9IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'LineGroupPurposeId', N'Name') AND [object_id] = OBJECT_ID(N'[Topology].[LineGroupPurpose]'))
10    SET IDENTITY_INSERT [Topology].[LineGroupPurpose] ON;
11INSERT INTO [Topology].[LineGroupPurpose] ([LineGroupPurposeId], [Name])
12VALUES (CAST(1 AS bigint), N'Testing validity of products'),
13(CAST(2 AS bigint), N'Statistics reason'),
14(CAST(3 AS bigint), N'Time table edition'),
15(CAST(4 AS bigint), N'Display'),
16(CAST(5 AS bigint), N'Initial fee selection'),
17(CAST(6 AS bigint), N'Price adjustment');
18IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'LineGroupPurposeId', N'Name') AND [object_id] = OBJECT_ID(N'[Topology].[LineGroupPurpose]'))
19    SET IDENTITY_INSERT [Topology].[LineGroupPurpose] OFF;
20
21GO
22
23CREATE INDEX [IX_LineGroup_LineGroupPurposeId] ON [Topology].[LineGroup] ([LineGroupPurposeId]);
24
25GO
26
27ALTER TABLE [Topology].[LineGroup] ADD CONSTRAINT [FK_LineGroup_LineGroupPurpose_LineGroupPurposeId] FOREIGN KEY ([LineGroupPurposeId]) REFERENCES [Topology].[LineGroupPurpose] ([LineGroupPurposeId]) ON DELETE NO ACTION;
28
29GO
30
31INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
32VALUES (N'20200422170559_ConfiguredLineGroupPurpose', N'3.1.3');
33
34GO
35
36DECLARE @var0 sysname;
37SELECT @var0 = [d].[name]
38FROM [sys].[default_constraints] [d]
39INNER JOIN [sys].[columns] [c] ON [d].[parent_column_id] = [c].[column_id] AND [d].[parent_object_id] = [c].[object_id]
40WHERE ([d].[parent_object_id] = OBJECT_ID(N'[Topology].[LineGroup]') AND [c].[name] = N'Name');
41IF @var0 IS NOT NULL EXEC(N'ALTER TABLE [Topology].[LineGroup] DROP CONSTRAINT [' + @var0 + '];');
42ALTER TABLE [Topology].[LineGroup] ALTER COLUMN [Name] nvarchar(max) NOT NULL;
43
44GO
45
46INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
47VALUES (N'20200422171835_LineGroupNameRequired', N'3.1.3');
48
49GO
50
51ALTER TABLE [Topology].[LineGroup] ADD [ContractInitialFeeCategoryId] tinyint NULL;
52
53GO
54
55CREATE TABLE [Topology].[ContractInitialFeeCategory] (
56    [ContractInitialFeeCategoryId] tinyint NOT NULL,
57    [Name] nvarchar(max) NULL,
58    CONSTRAINT [PK_ContractInitialFeeCategory] PRIMARY KEY ([ContractInitialFeeCategoryId])
59);
60
61GO
62
63IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ContractInitialFeeCategoryId', N'Name') AND [object_id] = OBJECT_ID(N'[Topology].[ContractInitialFeeCategory]'))
64    SET IDENTITY_INSERT [Topology].[ContractInitialFeeCategory] ON;
65INSERT INTO [Topology].[ContractInitialFeeCategory] ([ContractInitialFeeCategoryId], [Name])
66VALUES (CAST(0 AS tinyint), N'No Line Group Association'),
67(CAST(1 AS tinyint), N'Category 1'),
68(CAST(2 AS tinyint), N'Category 2'),
69(CAST(3 AS tinyint), N'Category 3'),
70(CAST(4 AS tinyint), N'Category 4'),
71(CAST(5 AS tinyint), N'Category 5'),
72(CAST(6 AS tinyint), N'Category 6'),
73(CAST(7 AS tinyint), N'Category 7');
74IF EXISTS (SELECT * FROM [sys].[identity_columns] WHERE [name] IN (N'ContractInitialFeeCategoryId', N'Name') AND [object_id] = OBJECT_ID(N'[Topology].[ContractInitialFeeCategory]'))
75    SET IDENTITY_INSERT [Topology].[ContractInitialFeeCategory] OFF;
76
77GO
78
79CREATE INDEX [IX_LineGroup_ContractInitialFeeCategoryId] ON [Topology].[LineGroup] ([ContractInitialFeeCategoryId]);
80
81GO
82
83ALTER TABLE [Topology].[LineGroup] ADD CONSTRAINT [FK_LineGroup_ContractInitialFeeCategory_ContractInitialFeeCategoryId] FOREIGN KEY ([ContractInitialFeeCategoryId]) REFERENCES [Topology].[ContractInitialFeeCategory] ([ContractInitialFeeCategoryId]) ON DELETE NO ACTION;
84
85GO
86
87INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
88VALUES (N'20200423105603_AddedInitialFeeCategory', N'3.1.3');
89
90GO
91
92ALTER TABLE [Topology].[LineGroup] ADD [IsDeleted] bit NOT NULL DEFAULT CAST(0 AS bit);
93
94GO
95
96ALTER TABLE [Topology].[LineGroup] ADD [TenantId] uniqueidentifier NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000';
97
98GO
99
100ALTER TABLE [Topology].[LineGroup] ADD [CreateDate] datetimeoffset NULL;
101
102GO
103
104ALTER TABLE [Topology].[LineGroup] ADD [CreatedBy] uniqueidentifier NULL;
105
106GO
107
108ALTER TABLE [Topology].[LineGroup] ADD [DeleteDate] datetimeoffset NULL;
109
110GO
111
112ALTER TABLE [Topology].[LineGroup] ADD [DeletedBy] uniqueidentifier NULL;
113
114GO
115
116ALTER TABLE [Topology].[LineGroup] ADD [UpdateDate] datetimeoffset NULL;
117
118GO
119
120ALTER TABLE [Topology].[LineGroup] ADD [UpdatedBy] uniqueidentifier NULL;
121
122GO
123
124INSERT INTO [__EFMigrationsHistory] ([MigrationId], [ProductVersion])
125VALUES (N'20200424074839_UpdatedLineGroupDefinition', N'3.1.3');
126
127GO