DP44/DataPRO/Modules/Database/DatabaseMigrationScripts/MigrationScripts/Version80/dbo.Update_UIItems_78.sql

INSERT INTO [UIItems] ([NAME]) VALUES ('Prepare_AdditionalDetails_Page_ChannelCodeDetails');
INSERT INTO [UIItems] ([NAME]) VALUES ('Prepare_AdditionalDetails_Page_TestEngineerDetails');
INSERT INTO [UIItems] ([NAME]) VALUES ('Prepare_AdditionalDetails_Page_LabDetails');
INSERT INTO [UIItems] ([NAME]) VALUES ('Prepare_AdditionalDetails_Page_CustomerDetails');
INSERT INTO [UIItems] ([NAME]) VALUES ('Prepare_AdditionalDetails_Page');

UPDATE [UIItemSettings] SET [UIItemID]=(SELECT [ID] FROM [UIItems] WHERE [NAME]='Prepare_AdditionalDetails_Page_ChannelCodeDetails') WHERE [UIItemID]=(SELECT [ID] FROM [UIItems] WHERE [NAME]='Prepare_CustomChannels_Page');
UPDATE [UIItemSettings] SET [UIItemID]=(SELECT [ID] FROM [UIItems] WHERE [NAME]='Prepare_AdditionalDetails_Page_TestEngineerDetails') WHERE [UIItemID]=(SELECT [ID] FROM [UIItems] WHERE [NAME]='Prepare_TestEngineerDetails_Page');
UPDATE [UIItemSettings] SET [UIItemID]=(SELECT [ID] FROM [UIItems] WHERE [NAME]='Prepare_AdditionalDetails_Page_LabDetails') WHERE [UIItemID]=(SELECT [ID] FROM [UIItems] WHERE [NAME]='Prepare_LabDetails_Page');
UPDATE [UIItemSettings] SET [UIItemID]=(SELECT [ID] FROM [UIItems] WHERE [NAME]='Prepare_AdditionalDetails_Page_CustomerDetails') WHERE [UIItemID]=(SELECT [ID] FROM [UIItems] WHERE [NAME]='Prepare_CustomerDetails_Page');