IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'current-client-details' AND [ControlName] IS NULL) BEGIN INSERT INTO [KaaSCtlMaster]( [ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ( 'current-client-details', null, 'Current Client Details', 0, 0, 0) END GO --KCL Master IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'change-matter-security-permissions' AND [ControlName] IS NULL) BEGIN INSERT INTO [KaaSCtlMaster]( [ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('change-matter-security-permissions', null, 'Change Matter Security Permissions', 0, 0, 0) END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'current-client-billing' AND [ControlName] IS NULL) BEGIN INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('current-client-billing', null, 'Current Client Billing', 0, 0, 0) END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'general-tab' AND [ControlName] = 'btnSaveGeneral') BEGIN INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('general-tab','btnSaveGeneral', 'Current Client Details - General', 0, 1, 0) END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'bank-details-tab' AND [ControlName] = 'btnSaveBankDetails') BEGIN INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('bank-details-tab','btnSaveBankDetails', 'Current Client Details - Bank Details', 0, 1, 0) END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'billing-details-tab' AND [ControlName] = 'btnSaveBillingDetails') BEGIN INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('billing-details-tab','btnSaveBillingDetails', 'Current Client Details - Billing Details', 0, 1, 0) END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'categories-tab' AND [ControlName] = 'btnSaveCategories') BEGIN INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('categories-tab','btnSaveCategories', 'Current Client Details - Categories', 0, 1, 0) END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'corporate-tab' AND [ControlName] = 'btnSaveCorporate') BEGIN INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('corporate-tab','btnSaveCorporate', 'Current Client Details - Corporate', 0, 1, 0) END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'cross-ref-tab' AND [ControlName] = 'btnSaveCrossRef') BEGIN INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('cross-ref-tab','btnSaveCrossRef', 'Current Client Details - Cross Reference', 0, 1, 0) END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'legal-details-tab' AND [ControlName] = 'btnSaveLegalDetails') BEGIN INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('legal-details-tab','btnSaveLegalDetails', 'Current Client Details - Legal Details', 0, 1, 0) END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'matters-tab' AND [ControlName] = 'btnSaveMatters') BEGIN INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('matters-tab','btnSaveMatters', 'Current Client Details - Matters', 0, 1, 0) END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'notes-tab' AND [ControlName] = 'btnSaveNotes') BEGIN INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('notes-tab','btnSaveNotes', 'Current Client Details - Notes', 0, 1, 0) END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'permission-tab' AND [ControlName] = 'btnSavePermission') BEGIN INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('permission-tab','btnSavePermission', 'Current Client Details - Permission', 0, 1, 0) END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'personal-tab' AND [ControlName] = 'btnSavePersonal') BEGIN INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('personal-tab','btnSavePersonal', 'Current Client Details - Personal', 0, 1, 0) END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'client-contact-tab' AND [ControlName] = 'btnClientContactInsert') BEGIN INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('client-contact-tab','btnClientContactInsert', 'Current Client Details - Client Contact', 0, 1, 0) END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'client-contact-tab' AND [ControlName] = 'btnClientContactChange') BEGIN INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('client-contact-tab','btnClientContactChange', 'Current Client Details - Client Contact', 0, 1, 0) END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'client-contact-tab' AND [ControlName] = 'btnClientContactDelete') BEGIN INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('client-contact-tab','btnClientContactDelete', 'Current Client Details - Client Contact', 0, 1, 0) END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'cross-ref-tab' AND [ControlName] = 'btnCrossRefInsert') BEGIN INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('cross-ref-tab','btnCrossRefInsert', 'Current Client Details - Cross Reference', 0, 1, 0) END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'cross-ref-tab' AND [ControlName] = 'btnCrossRefChange') BEGIN INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('cross-ref-tab','btnCrossRefChange', 'Current Client Details - Cross Reference', 0, 1, 0) END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'cross-ref-tab' AND [ControlName] = 'btnCrossRefDelete') BEGIN INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('cross-ref-tab','btnCrossRefDelete', 'Current Client Details - Cross Reference', 0, 1, 0) END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'categories-tab' AND [ControlName] = 'btnCategoriesInsert') BEGIN INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('categories-tab','btnCategoriesInsert', 'Current Client Details - Categories', 0, 1, 0) END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'categories-tab' AND [ControlName] = 'btnCategoriesChange') BEGIN INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('categories-tab','btnCategoriesChange', 'Current Client Details - Categories', 0, 1, 0) END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'categories-tab' AND [ControlName] = 'btnCategoriesDelete') BEGIN INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('categories-tab','btnCategoriesDelete', 'Current Client Details - Categories', 0, 1, 0) END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'corporate-tab' AND [ControlName] = 'btnCorporateOfficerInsert') BEGIN INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('corporate-tab','btnCorporateOfficerInsert', 'Current Client Details - Corporate', 0, 1, 0) END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'corporate-tab' AND [ControlName] = 'btnCorporateOfficerChange') BEGIN INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('corporate-tab','btnCorporateOfficerChange', 'Current Client Details - Corporate', 0, 1, 0) END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'corporate-tab' AND [ControlName] = 'btnCorporateOfficerDelete') BEGIN INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('corporate-tab','btnCorporateOfficerDelete', 'Current Client Details - Corporate', 0, 1, 0) END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'current-client-detail-permission-tab' AND [ControlName] = 'mat-tab-label-0-10') BEGIN INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('current-client-detail-permission-tab','mat-tab-label-0-10', 'Current Client Details - Permission Tab', 0, 2, 0) END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlMaster] WHERE [ComponentName] = 'current-client-detail-billing-tab' AND [ControlName] = 'dvCurrentClientDetailsManageBilling') BEGIN INSERT INTO [KaaSCtlMaster]([ComponentName], [ControlName], [FriendlyName], [IsVisible], [ParentId], [Deleted]) VALUES ('current-client-detail-billing-tab','dvCurrentClientDetailsManageBilling', 'Current Client Details - Billing Tab', 0, 3, 0) END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlGroupControls] WHERE [GroupId] = '1000033' AND [MasterId] = 1) BEGIN INSERT INTO [KaaSCtlGroupControls] ([GroupId], [MasterId]) VALUES ('1000033',1) END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlGroupControls] WHERE [GroupId] = '1000012' AND [MasterId] = 2) BEGIN INSERT INTO [KaaSCtlGroupControls] ([GroupId], [MasterId]) VALUES ('1000012',2) END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [KaaSCtlGroupControls] WHERE [GroupId] = '1000006' AND [MasterId] = 3) BEGIN INSERT INTO [KaaSCtlGroupControls] ([GroupId], [MasterId]) VALUES ('1000006',3) END GO IF NOT EXISTS(SELECT TOP 1 1 FROM Settings where [KeyName] = 'StatuteWarning') BEGIN INSERT INTO Settings ([KeyName],[KeyValue]) VALUES ('StatuteWarning',0) END GO IF NOT EXISTS(SELECT TOP 1 1 FROM Settings where [KeyName] = 'StatuteActionCode') BEGIN INSERT INTO Settings ([KeyName],[KeyValue]) VALUES ('StatuteActionCode','') END GO --Sprint 6 Scritps IF EXISTS (SELECT TOP 1 1 FROM sys.objects WHERE [name] = 'Settings') AND NOT EXISTS (SELECT TOP 1 1 FROM [Settings] WHERE [KeyName] = 'ClientLabel') BEGIN INSERT INTO [Settings] ( [KeyName], [KeyValue] ) VALUES ( 'ClientLabel', 'Client' ) END GO IF EXISTS (SELECT TOP 1 1 FROM sys.objects WHERE [name] = 'Settings') AND NOT EXISTS (SELECT TOP 1 1 FROM [Settings] WHERE [KeyName] = 'MatterLabel') BEGIN INSERT INTO [Settings] ( [KeyName], [KeyValue] ) VALUES ( 'MatterLabel', 'Matter' ) END GO IF EXISTS (SELECT TOP 1 1 FROM sys.objects WHERE [name] = 'Settings') AND NOT EXISTS (SELECT TOP 1 1 FROM [Settings] WHERE [KeyName] = 'AssociateLabel') BEGIN INSERT INTO [Settings] ( [KeyName], [KeyValue] ) VALUES ( 'AssociateLabel', 'Associate' ) END GO IF EXISTS (SELECT TOP 1 1 FROM sys.objects WHERE [name] = 'Settings') AND NOT EXISTS (SELECT TOP 1 1 FROM [Settings] WHERE [KeyName] = 'CaseLabel') BEGIN INSERT INTO [Settings] ( [KeyName], [KeyValue] ) VALUES ( 'CaseLabel', 'Case' ) END GO IF EXISTS (SELECT TOP 1 1 FROM sys.objects WHERE [name] = 'Settings') AND NOT EXISTS (SELECT TOP 1 1 FROM [Settings] WHERE [KeyName] = 'DocumentNamingMethod') BEGIN INSERT INTO [Settings] ( [KeyName], [KeyValue] ) VALUES ( 'DocumentNamingMethod', 'D' ) END GO -- INSERT SCRIPTS FOR APP REDIRECTION IF NOT EXISTS (SELECT 1 FROM AppRedirectionUrls WHERE [ShortCode] = 'TASK_DASHBOARD' AND [UrlLink] = '/tasks/task-dashboard') BEGIN INSERT INTO AppRedirectionUrls ([Description],[UrlLink],[ShortCode]) VALUES ('Task Dashboard','/tasks/task-dashboard','TASK_DASHBOARD') END GO IF NOT EXISTS (SELECT 1 FROM AppRedirectionUrls WHERE [ShortCode] = 'TASK_MY' AND [UrlLink] = '/tasks/main/my-tasks') BEGIN INSERT INTO AppRedirectionUrls ([Description],[UrlLink],[ShortCode]) VALUES ('My Tasks','/tasks/main/my-tasks','TASK_MY') END GO IF NOT EXISTS (SELECT 1 FROM AppRedirectionUrls WHERE [ShortCode] = 'TASK_TEAM' AND [UrlLink] = '/tasks/main/team-tasks') BEGIN INSERT INTO AppRedirectionUrls ([Description],[UrlLink],[ShortCode]) VALUES ('Team Tasks','/tasks/main/team-tasks','TASK_TEAM') END GO IF NOT EXISTS (SELECT 1 FROM AppRedirectionUrls WHERE [ShortCode] = 'TASK_OVERDUE' AND [UrlLink] = '/tasks/main/overdue-tasks') BEGIN INSERT INTO AppRedirectionUrls ([Description],[UrlLink],[ShortCode]) VALUES ('Overdue Tasks','/tasks/main/overdue-tasks','TASK_OVERDUE') END GO IF NOT EXISTS (SELECT 1 FROM AppRedirectionUrls WHERE [ShortCode] = 'TASK_DAY' AND [UrlLink] = '/tasks/main/days-tasks') BEGIN INSERT INTO AppRedirectionUrls ([Description],[UrlLink],[ShortCode]) VALUES ('Days Tasks','/tasks/main/days-tasks','TASK_DAY') END GO IF NOT EXISTS (SELECT 1 FROM AppRedirectionUrls WHERE [ShortCode] = 'TASK_NEXT_WEEK' AND [UrlLink] = '/tasks/main/next-weeks-tasks') BEGIN INSERT INTO AppRedirectionUrls ([Description],[UrlLink],[ShortCode]) VALUES ('Next Week Tasks','/tasks/main/next-weeks-tasks','TASK_NEXT_WEEK') END GO IF NOT EXISTS (SELECT 1 FROM AppRedirectionUrls WHERE [ShortCode] = 'TASK_NEXT_MONTH' AND [UrlLink] = '/tasks/main/next-months-tasks') BEGIN INSERT INTO AppRedirectionUrls ([Description],[UrlLink],[ShortCode]) VALUES ('Next Month Tasks','/tasks/main/next-months-tasks','TASK_NEXT_MONTH') END GO IF NOT EXISTS (SELECT 1 FROM AppRedirectionUrls WHERE [ShortCode] = 'TASK_OUTSTANDING' AND [UrlLink] = '/tasks/main/outstanding-tasks') BEGIN INSERT INTO AppRedirectionUrls ([Description],[UrlLink],[ShortCode]) VALUES ('Outstanding Tasks','/tasks/main/outstanding-tasks','TASK_OUTSTANDING') END GO IF NOT EXISTS (SELECT 1 FROM AppRedirectionUrls WHERE [ShortCode] = 'TASK_LAST_WEEK' AND [UrlLink] = '/tasks/main/last-weeks-tasks') BEGIN INSERT INTO AppRedirectionUrls ([Description],[UrlLink],[ShortCode]) VALUES ('Last Weeks Tasks','/tasks/main/last-weeks-tasks','TASK_LAST_WEEK') END GO IF NOT EXISTS (SELECT 1 FROM AppRedirectionUrls WHERE [ShortCode] = 'TASK_LAST_MONTH' AND [UrlLink] = '/tasks/main/last-months-tasks') BEGIN INSERT INTO AppRedirectionUrls ([Description],[UrlLink],[ShortCode]) VALUES ('Last Month Tasks','/tasks/main/last-months-tasks','TASK_LAST_MONTH') END GO IF NOT EXISTS (SELECT 1 FROM AppRedirectionUrls WHERE [ShortCode] = 'TASK_ALL' AND [UrlLink] = '/tasks/main/all-tasks') BEGIN INSERT INTO AppRedirectionUrls ([Description],[UrlLink],[ShortCode]) VALUES ('All Tasks','/tasks/main/all-tasks','TASK_ALL') END GO -- DATAPUMP FOR CUSTOM FILTER HEADER OPTIONS -- FIRST REMOVE EXISTING RECORDS IF OBJECT_ID(N'CustomFilterColumndetails',N'U') IS NOT NULL BEGIN TRUNCATE TABLE CustomFilterColumndetails END GO -- INSERT WITH NEW DATA IF OBJECT_ID(N'CustomFilterColumndetails',N'U') IS NOT NULL BEGIN INSERT INTO CustomFilterColumndetails -- Action Type Case Diary SELECT 'Action' AS [name], 'A' AS [Code],1 AS [isSelected] ,0 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'CaseDiary' AS [PageName] UNION SELECT 'Critical' AS [name], 'C' AS [Code],1 AS [isSelected] ,1 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'CaseDiary' AS [PageName] UNION SELECT 'Dictation' AS [name], 'D' AS [Code],1 AS [isSelected] ,2 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'CaseDiary' AS [PageName] UNION SELECT 'Note' AS [name], 'N' AS [Code],1 AS [isSelected] ,3 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'CaseDiary' AS [PageName] UNION SELECT 'Court' AS [name], 'O' AS [Code],1 AS [isSelected] ,4 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'CaseDiary' AS [PageName] UNION SELECT 'Appointment' AS [name], 'P' AS [Code],1 AS [isSelected] ,5 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'CaseDiary' AS [PageName] UNION SELECT 'Remainder' AS [name], 'R' AS [Code],1 AS [isSelected] ,6 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'CaseDiary' AS [PageName] UNION SELECT 'Statute' AS [name], 'S' AS [Code],1 AS [isSelected] ,7 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'CaseDiary' AS [PageName] UNION SELECT 'Phone' AS [name], 'T' AS [Code],1 AS [isSelected] ,8 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'CaseDiary' AS [PageName] UNION SELECT 'Undertaking' AS [name], 'U' AS [Code],1 AS [isSelected] ,9 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'CaseDiary' AS [PageName] UNION SELECT 'Email' AS [name], 'E' AS [Code],1 AS [isSelected] ,10 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'CaseDiary' AS [PageName] UNION SELECT 'Scanned' AS [name], 'M' AS [Code],1 AS [isSelected] ,11 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'CaseDiary' AS [PageName] UNION SELECT 'Fixed Date' AS [name], 'F' AS [Code],1 AS [isSelected] ,12 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'CaseDiary' AS [PageName] UNION SELECT 'Non PhotoId' AS [name], 'I' AS [Code],1 AS [isSelected] ,13 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'CaseDiary' AS [PageName] UNION SELECT 'PhotoID' AS [name], 'K' AS [Code],1 AS [isSelected] ,14 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'CaseDiary' AS [PageName] UNION SELECT 'Cheque' AS [name], 'Q' AS [Code],1 AS [isSelected] ,15 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'CaseDiary' AS [PageName] UNION SELECT 'Corporate' AS [name], 'V' AS [Code],1 AS [isSelected] ,16 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'CaseDiary' AS [PageName] UNION SELECT 'Signing Document' AS [name], 'G' AS [Code],1 AS [isSelected] ,17 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'CaseDiary' AS [PageName] UNION SELECT 'SMS' AS [name], 'W' AS [Code],1 AS [isSelected] ,18 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'CaseDiary' AS [PageName] UNION SELECT 'Requested Documents' AS [name], 'L' AS [Code],1 AS [isSelected] ,19 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'CaseDiary' AS [PageName] INSERT INTO CustomFilterColumndetails -- Action Priority Case Diary SELECT 'High' AS [name], 'H' AS [Code],1 AS [isSelected] ,0 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Priority' AS [ColumnName], 'CaseDiary' AS [PageName] UNION SELECT 'Low' AS [name], 'L' AS [Code],1 AS [isSelected] ,1 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Priority' AS [ColumnName], 'CaseDiary' AS [PageName] UNION SELECT 'Normal' AS [name], 'N' AS [Code],1 AS [isSelected] ,2 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Priority' AS [ColumnName], 'CaseDiary' AS [PageName] INSERT INTO CustomFilterColumndetails -- Action Flag Case Diary SELECT 'Clear Flag' AS [name], '0' AS [Code],1 AS [isSelected] ,0 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Flag' AS [ColumnName], 'CaseDiary' AS [PageName] UNION SELECT 'Blue Flag' AS [name], '1' AS [Code],1 AS [isSelected] ,1 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Flag' AS [ColumnName], 'CaseDiary' AS [PageName] UNION SELECT 'Orange Flag' AS [name], '2' AS [Code],1 AS [isSelected] ,2 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Flag' AS [ColumnName], 'CaseDiary' AS [PageName] UNION SELECT 'Red Flag' AS [name], '3' AS [Code],1 AS [isSelected] ,3 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Flag' AS [ColumnName], 'CaseDiary' AS [PageName] UNION SELECT 'Green Flag' AS [name], '4' AS [Code],1 AS [isSelected] ,4 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Flag' AS [ColumnName], 'CaseDiary' AS [PageName] UNION SELECT 'Black Flag' AS [name], '5' AS [Code],1 AS [isSelected] ,5 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Flag' AS [ColumnName], 'CaseDiary' AS [PageName] UNION SELECT 'Yellow Flag' AS [name], '6' AS [Code],1 AS [isSelected] ,6 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Flag' AS [ColumnName], 'CaseDiary' AS [PageName] INSERT INTO CustomFilterColumndetails -- Released MyInvoice SELECT 'Yes' AS [name], 'Y' AS [Code],1 AS [isSelected] ,0 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Released' AS [ColumnName] , 'MyInvoice' AS [PageName] UNION SELECT 'No' AS [name], 'N' AS [Code],1 AS [isSelected] ,1 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Released' AS [ColumnName] , 'MyInvoice' AS [PageName] INSERT INTO CustomFilterColumndetails -- Released MyInvoice SELECT 'Equals 0' AS [name], '0' AS [Code],1 AS [isSelected] ,0 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'BillNo' AS [ColumnName] , 'MyInvoice' AS [PageName] UNION SELECT 'Not equals 0' AS [name], '1' AS [Code],1 AS [isSelected],1 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'BillNo' AS [ColumnName] , 'MyInvoice' AS [PageName] INSERT INTO CustomFilterColumndetails SELECT 'Request' AS [name], '0' AS [Code],1 AS [isSelected] ,0 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Status' AS [ColumnName], 'MyCheque' AS [PageName] UNION SELECT 'Released' AS [name], '1' AS [Code],1 AS [isSelected] ,1 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Status' AS [ColumnName], 'MyCheque' AS [PageName] UNION SELECT 'Approved' AS [name], '2' AS [Code],1 AS [isSelected] ,2 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Status' AS [ColumnName], 'MyCheque' AS [PageName] UNION SELECT 'Returned' AS [name], '3' AS [Code],1 AS [isSelected] ,3 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Status' AS [ColumnName], 'MyCheque' AS [PageName] -- My Task Default Options starts here INSERT INTO CustomFilterColumndetails -- Action Type Tasks SELECT 'Action' AS [name], 'A' AS [Code],1 AS [isSelected] ,0 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'MyTask' AS [PageName] UNION SELECT 'Critical' AS [name], 'C' AS [Code],1 AS [isSelected] ,1 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'MyTask' AS [PageName] UNION SELECT 'Dictation' AS [name], 'D' AS [Code],1 AS [isSelected] ,2 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'MyTask' AS [PageName] UNION SELECT 'Note' AS [name], 'N' AS [Code],1 AS [isSelected] ,3 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'MyTask' AS [PageName] UNION SELECT 'Court' AS [name], 'O' AS [Code],1 AS [isSelected] ,4 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'MyTask' AS [PageName] UNION SELECT 'Appointment' AS [name], 'P' AS [Code],1 AS [isSelected] ,5 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'MyTask' AS [PageName] UNION SELECT 'Remainder' AS [name], 'R' AS [Code],1 AS [isSelected] ,6 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'MyTask' AS [PageName] UNION SELECT 'Statute' AS [name], 'S' AS [Code],1 AS [isSelected] ,7 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'MyTask' AS [PageName] UNION SELECT 'Phone' AS [name], 'T' AS [Code],1 AS [isSelected] ,8 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'MyTask' AS [PageName] UNION SELECT 'Undertaking' AS [name], 'U' AS [Code],1 AS [isSelected] ,9 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'MyTask' AS [PageName] UNION SELECT 'Email' AS [name], 'E' AS [Code],1 AS [isSelected] ,10 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'MyTask' AS [PageName] UNION SELECT 'Scanned' AS [name], 'M' AS [Code],1 AS [isSelected] ,11 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'MyTask' AS [PageName] UNION SELECT 'Fixed Date' AS [name], 'F' AS [Code],1 AS [isSelected] ,12 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'MyTask' AS [PageName] UNION SELECT 'Non PhotoId' AS [name], 'I' AS [Code],1 AS [isSelected] ,13 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'MyTask' AS [PageName] UNION SELECT 'PhotoID' AS [name], 'K' AS [Code],1 AS [isSelected] ,14 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'MyTask' AS [PageName] UNION SELECT 'Cheque' AS [name], 'Q' AS [Code],1 AS [isSelected] ,15 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'MyTask' AS [PageName] UNION SELECT 'Corporate' AS [name], 'V' AS [Code],1 AS [isSelected] ,16 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'MyTask' AS [PageName] UNION SELECT 'Signing Document' AS [name], 'G' AS [Code],1 AS [isSelected] ,17 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'MyTask' AS [PageName] UNION SELECT 'SMS' AS [name], 'W' AS [Code],1 AS [isSelected] ,18 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'MyTask' AS [PageName] UNION SELECT 'Requested Documents' AS [name], 'L' AS [Code],1 AS [isSelected] ,19 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'MyTask' AS [PageName] INSERT INTO CustomFilterColumndetails -- Action Priority Tasks SELECT 'High' AS [name], 'H' AS [Code],1 AS [isSelected] ,0 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Priority' AS [ColumnName], 'MyTask' AS [PageName] UNION SELECT 'Low' AS [name], 'L' AS [Code],1 AS [isSelected] ,1 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Priority' AS [ColumnName], 'MyTask' AS [PageName] UNION SELECT 'Normal' AS [name], 'N' AS [Code],1 AS [isSelected] ,2 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Priority' AS [ColumnName], 'MyTask' AS [PageName] INSERT INTO CustomFilterColumndetails -- Action Flag Tasks SELECT 'Clear Flag' AS [name], '0' AS [Code],1 AS [isSelected] ,0 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Flag' AS [ColumnName], 'MyTask' AS [PageName] UNION SELECT 'Blue Flag' AS [name], '1' AS [Code],1 AS [isSelected] ,1 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Flag' AS [ColumnName], 'MyTask' AS [PageName] UNION SELECT 'Orange Flag' AS [name], '2' AS [Code],1 AS [isSelected] ,2 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Flag' AS [ColumnName], 'MyTask' AS [PageName] UNION SELECT 'Red Flag' AS [name], '3' AS [Code],1 AS [isSelected] ,3 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Flag' AS [ColumnName], 'MyTask' AS [PageName] UNION SELECT 'Green Flag' AS [name], '4' AS [Code],1 AS [isSelected] ,4 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Flag' AS [ColumnName], 'MyTask' AS [PageName] UNION SELECT 'Black Flag' AS [name], '5' AS [Code],1 AS [isSelected] ,5 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Flag' AS [ColumnName], 'MyTask' AS [PageName] UNION SELECT 'Yellow Flag' AS [name], '6' AS [Code],1 AS [isSelected] ,6 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Flag' AS [ColumnName], 'MyTask' AS [PageName] -- My Task Default Options ends here -- Team Task Default Options starts here INSERT INTO CustomFilterColumndetails -- Action Type Tasks SELECT 'Action' AS [name], 'A' AS [Code],1 AS [isSelected] ,0 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'TeamTask' AS [PageName] UNION SELECT 'Critical' AS [name], 'C' AS [Code],1 AS [isSelected] ,1 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'TeamTask' AS [PageName] UNION SELECT 'Dictation' AS [name], 'D' AS [Code],1 AS [isSelected] ,2 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'TeamTask' AS [PageName] UNION SELECT 'Note' AS [name], 'N' AS [Code],1 AS [isSelected] ,3 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'TeamTask' AS [PageName] UNION SELECT 'Court' AS [name], 'O' AS [Code],1 AS [isSelected] ,4 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'TeamTask' AS [PageName] UNION SELECT 'Appointment' AS [name], 'P' AS [Code],1 AS [isSelected] ,5 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'TeamTask' AS [PageName] UNION SELECT 'Remainder' AS [name], 'R' AS [Code],1 AS [isSelected] ,6 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'TeamTask' AS [PageName] UNION SELECT 'Statute' AS [name], 'S' AS [Code],1 AS [isSelected] ,7 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'TeamTask' AS [PageName] UNION SELECT 'Phone' AS [name], 'T' AS [Code],1 AS [isSelected] ,8 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'TeamTask' AS [PageName] UNION SELECT 'Undertaking' AS [name], 'U' AS [Code],1 AS [isSelected] ,9 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'TeamTask' AS [PageName] UNION SELECT 'Email' AS [name], 'E' AS [Code],1 AS [isSelected] ,10 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'TeamTask' AS [PageName] UNION SELECT 'Scanned' AS [name], 'M' AS [Code],1 AS [isSelected] ,11 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'TeamTask' AS [PageName] UNION SELECT 'Fixed Date' AS [name], 'F' AS [Code],1 AS [isSelected] ,12 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'TeamTask' AS [PageName] UNION SELECT 'Non PhotoId' AS [name], 'I' AS [Code],1 AS [isSelected] ,13 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'TeamTask' AS [PageName] UNION SELECT 'PhotoID' AS [name], 'K' AS [Code],1 AS [isSelected] ,14 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'TeamTask' AS [PageName] UNION SELECT 'Cheque' AS [name], 'Q' AS [Code],1 AS [isSelected] ,15 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'TeamTask' AS [PageName] UNION SELECT 'Corporate' AS [name], 'V' AS [Code],1 AS [isSelected] ,16 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'TeamTask' AS [PageName] UNION SELECT 'Signing Document' AS [name], 'G' AS [Code],1 AS [isSelected] ,17 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'TeamTask' AS [PageName] UNION SELECT 'SMS' AS [name], 'W' AS [Code],1 AS [isSelected] ,18 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'TeamTask' AS [PageName] UNION SELECT 'Requested Documents' AS [name], 'L' AS [Code],1 AS [isSelected] ,19 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Type' AS [ColumnName], 'TeamTask' AS [PageName] INSERT INTO CustomFilterColumndetails -- Action Priority Tasks SELECT 'High' AS [name], 'H' AS [Code],1 AS [isSelected] ,0 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Priority' AS [ColumnName], 'TeamTask' AS [PageName] UNION SELECT 'Low' AS [name], 'L' AS [Code],1 AS [isSelected] ,1 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Priority' AS [ColumnName], 'TeamTask' AS [PageName] UNION SELECT 'Normal' AS [name], 'N' AS [Code],1 AS [isSelected] ,2 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Priority' AS [ColumnName], 'TeamTask' AS [PageName] INSERT INTO CustomFilterColumndetails -- Action Flag Tasks SELECT 'Clear Flag' AS [name], '0' AS [Code],1 AS [isSelected] ,0 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Flag' AS [ColumnName], 'TeamTask' AS [PageName] UNION SELECT 'Blue Flag' AS [name], '1' AS [Code],1 AS [isSelected] ,1 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Flag' AS [ColumnName], 'TeamTask' AS [PageName] UNION SELECT 'Orange Flag' AS [name], '2' AS [Code],1 AS [isSelected] ,2 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Flag' AS [ColumnName], 'TeamTask' AS [PageName] UNION SELECT 'Red Flag' AS [name], '3' AS [Code],1 AS [isSelected] ,3 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Flag' AS [ColumnName], 'TeamTask' AS [PageName] UNION SELECT 'Green Flag' AS [name], '4' AS [Code],1 AS [isSelected] ,4 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Flag' AS [ColumnName], 'TeamTask' AS [PageName] UNION SELECT 'Black Flag' AS [name], '5' AS [Code],1 AS [isSelected] ,5 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Flag' AS [ColumnName], 'TeamTask' AS [PageName] UNION SELECT 'Yellow Flag' AS [name], '6' AS [Code],1 AS [isSelected] ,6 AS [FilterOrder] ,0 AS [IsIconAvailable] , '' AS [Iconpath] , 'Action Flag' AS [ColumnName], 'TeamTask' AS [PageName] --Team Task Default Options ends here INSERT INTO CustomFilterColumndetails SELECT 'Email Files' AS [name], '.eml,EML,MSG' AS [Code] ,1 AS [isSelected] ,0 AS [FilterOrder] ,1 AS [IsIconAvailable] , 'assets/images/filetypes/outlook.png' AS [Iconpath] , 'Type' AS [ColumnName], 'DocumentManager' AS [PageName] UNION SELECT 'Images Files' AS [name], '.jpg,JPG,PNG,BMP,gif,tif,PSD,HEI,ICO,JPE' AS [Code] ,1 AS [isSelected] ,1 AS [FilterOrder] ,1 AS [IsIconAvailable] , 'assets/images/filetypes/IMAGE.png' AS [Iconpath] , 'Type' AS [ColumnName], 'DocumentManager' AS [PageName] UNION SELECT 'PDF Files' AS [name], '.pdf,PDF' AS [Code] ,1 AS [isSelected] ,2 AS [FilterOrder] ,1 AS [IsIconAvailable] , 'assets/images/filetypes/pdf.png' AS [Iconpath] , 'Type' AS [ColumnName], 'DocumentManager' AS [PageName] UNION SELECT 'Text Files' AS [name], '.txt,TXT,LOG,TEX,RTF' AS [Code] ,1 AS [isSelected] ,3 AS [FilterOrder] ,1 AS [IsIconAvailable] , 'assets/images/filetypes/TEXT.png' AS [Iconpath] , 'Type' AS [ColumnName], 'DocumentManager' AS [PageName] UNION SELECT 'Documents' AS [name], 'docx,DOC,ODS,ODT' AS [Code] ,1 AS [isSelected] ,4 AS [FilterOrder] ,1 AS [IsIconAvailable] , 'assets/images/filetypes/DOCUMENT.png' AS [Iconpath] , 'Type' AS [ColumnName], 'DocumentManager' AS [PageName] UNION SELECT 'Excel Files' AS [name], 'CSV,XLS,xlsx' AS [Code] ,1 AS [isSelected] ,5 AS [FilterOrder] ,1 AS [IsIconAvailable] , 'assets/images/filetypes/excelv1.png' AS [Iconpath] , 'Type' AS [ColumnName], 'DocumentManager' AS [PageName] UNION SELECT 'Audio Files' AS [name], 'MP3,WAV,M4A' AS [Code] ,1 AS [isSelected] ,6 AS [FilterOrder] ,1 AS [IsIconAvailable] , 'assets/images/filetypes/WAVIcon.jpg' AS [Iconpath] , 'Type' AS [ColumnName], 'DocumentManager' AS [PageName] UNION SELECT 'Presentation Documents' AS [name], 'pptx,PPT,ODP,PPS' AS [Code] ,1 AS [isSelected] ,7 AS [FilterOrder] ,1 AS [IsIconAvailable] , 'assets/images/filetypes/PPT.png' AS [Iconpath] , 'Type' AS [ColumnName], 'DocumentManager' AS [PageName] UNION SELECT 'Compressed Files' AS [name], 'ZIP' AS [Code] ,1 AS [isSelected] ,8 AS [FilterOrder] ,1 AS [IsIconAvailable] , 'assets/images/filetypes/Unknown.png' AS [Iconpath] , 'Type' AS [ColumnName], 'DocumentManager' AS [PageName] UNION SELECT 'Video Files' AS [name], 'MP4,MOV' AS [Code] ,1 AS [isSelected] ,9 AS [FilterOrder] ,1 AS [IsIconAvailable] , 'assets/images/filetypes/Unknown.png' AS [Iconpath] , 'Type' AS [ColumnName], 'DocumentManager' AS [PageName] UNION SELECT 'Android Apps' AS [name], 'APK' AS [Code] ,1 AS [isSelected] ,10 AS [FilterOrder] ,1 AS [IsIconAvailable] , 'assets/images/filetypes/Unknown.png' AS [Iconpath] , 'Type' AS [ColumnName], 'DocumentManager' AS [PageName] UNION SELECT 'Web Files' AS [name], 'htm,XML,MHT,SWF' AS [Code] ,1 AS [isSelected] ,11 AS [FilterOrder] ,1 AS [IsIconAvailable] , 'assets/images/filetypes/Unknown.png' AS [Iconpath] , 'Type' AS [ColumnName], 'DocumentManager' AS [PageName] UNION SELECT 'Graphics Documents' AS [name], 'CGM,DWG,EPS,PS,SVG,VSD' AS [Code] ,1 AS [isSelected] ,12 AS [FilterOrder] ,1 AS [IsIconAvailable] , 'assets/images/filetypes/Unknown.png' AS [Iconpath] , 'Type' AS [ColumnName], 'DocumentManager' AS [PageName] UNION SELECT 'DB Files' AS [name], 'FOL,SQL' AS [Code] ,1 AS [isSelected] ,13 AS [FilterOrder] ,1 AS [IsIconAvailable] , 'assets/images/filetypes/Unknown.png' AS [Iconpath] , 'Type' AS [ColumnName], 'DocumentManager' AS [PageName] UNION SELECT 'Calendar Files' AS [name], 'ICS' AS [Code] ,1 AS [isSelected] ,14 AS [FilterOrder] ,1 AS [IsIconAvailable] , 'assets/images/filetypes/Unknown.png' AS [Iconpath] , 'Type' AS [ColumnName], 'DocumentManager' AS [PageName] END GO --- Custom Filter Defined Script End --Added for Default Partner in settings IF NOT EXISTS (SELECT 1 FROM [dbo].[Settings] WHERE KeyName = 'TransactNewCaseDefaultPartner') BEGIN insert into [dbo].[Settings] values('TransactNewCaseDefaultPartner',''); END GO -- MAIL TEMPLATE FOR INVITE NEW USERS TO CLIENT PORTAL IF NOT EXISTS (SELECT 1 FROM [dbo].[PortalNotificationTemplate] WHERE [TemplateType] = 'Invite_New_Client_User') BEGIN INSERT INTO [dbo].[PortalNotificationTemplate] ([TemplateType], [TemplateSubject], [TemplateBody]) VALUES( 'Invite_New_Client_User', 'Client Portal - Account Registration', '


' ) END GO -- OTP TEMPLATE FOR 2FA IN CLIENT PORTAL IF NOT EXISTS (SELECT 1 FROM [dbo].[PortalNotificationTemplate] WHERE [TemplateType] = 'SMS_OTP_VERIFICATION') BEGIN INSERT INTO [dbo].[PortalNotificationTemplate] ([TemplateType], [TemplateBody]) VALUES( 'SMS_OTP_VERIFICATION', 'OTP for Client Portal login is %token. This OTP will be valid for %time minutes.' ) END GO IF NOT EXISTS (SELECT 1 FROM [dbo].[PortalNotificationTemplate] WHERE [TemplateType] = 'SMS_OTP_RESET_PASSWORD') BEGIN INSERT INTO [dbo].[PortalNotificationTemplate] ([TemplateType], [TemplateBody]) VALUES( 'SMS_OTP_RESET_PASSWORD', 'The OTP to reset your password for Client Portal is {0}' ) END GO -- Mail template to 2FA and Reset IF NOT EXISTS (SELECT 1 FROM [dbo].[PortalNotificationTemplate] WHERE [TemplateType] = 'MAIL_OTP_VERIFICATION') BEGIN INSERT INTO [dbo].[PortalNotificationTemplate] ([TemplateType], [TemplateSubject], [TemplateBody]) VALUES( 'MAIL_OTP_VERIFICATION', 'Client Portal - OTP for 2FA', 'Hi $UserName$,

The OTP for Client Portal login is

$PasswordResetOTP$

This OTP will be valid for $PasswordResetOTPExpirationTime$ minutes.

Thank You
' ) END GO IF NOT EXISTS (SELECT 1 FROM [dbo].[PortalNotificationTemplate] WHERE [TemplateType] = 'MAIL_OTP_RESET_PASSWORD') BEGIN INSERT INTO [dbo].[PortalNotificationTemplate] ([TemplateType], [TemplateSubject], [TemplateBody]) VALUES( 'MAIL_OTP_RESET_PASSWORD', 'Client Portal - OTP for Password Reset', 'Hi $UserName$,

The OTP to reset your password for Client Portal is

$PasswordResetOTP$

Generated at $PasswordResetOTPCreationTime$ (UTC), and valid up to $PasswordResetOTPExpirationTime$ (UTC).

Thank You
' ) END GO -- INSERT SCRIPT FOR SAM NOTIFICATIONS IF NOT EXISTS(SELECT TOP 1 1 FROM Settings where [KeyName] = 'NoOfDaysNotificationFetch') BEGIN INSERT INTO Settings ([KeyName],[KeyValue]) VALUES ('NoOfDaysNotificationFetch','7') END GO --INSERT SCRIPT FOR DEFAULT CASE DIARY VIEW IF NOT EXISTS (SELECT 1 FROM [dbo].[CustomFilterbyUserandPage] WHERE [FilterOrder] = -1 AND [PageName]='CaseDiary') BEGIN INSERT INTO [dbo].[CustomFilterbyUserandPage] ([HandlerCode] ,[PageName] ,[FilterName] ,[CreatedDate] ,[FilterOrder] ,[GridViewState] ) VALUES( 'STANDARD' ,'CaseDiary' ,'Standard_View' ,GETUTCDATE() ,-1 ,'[{"ColumnName":"CompleteORGenerated","ShowColumn":true,"ColumnWidth":30},{"ColumnName":"ActionType","ShowColumn":true,"ColumnWidth":30},{"ColumnName":"PriorityValue","ShowColumn":true,"ColumnWidth":30},{"ColumnName":"DelegationStatus","ShowColumn":true,"ColumnWidth":30},{"ColumnName":"Attachments","ShowColumn":true,"ColumnWidth":30},{"ColumnName":"Date","ShowColumn":true,"ColumnWidth":85},{"ColumnName":"DueDate","ShowColumn":false,"ColumnWidth":85},{"ColumnName":"CreationDate","ShowColumn":false,"ColumnWidth":85},{"ColumnName":"Time","ShowColumn":true,"ColumnWidth":50},{"ColumnName":"FNCode","ShowColumn":true,"ColumnWidth":50},{"ColumnName":"TeamCode","ShowColumn":true,"ColumnWidth":50},{"ColumnName":"Synopsis","ShowColumn":true},{"ColumnName":"Subject","ShowColumn":false},{"ColumnName":"Text1","ShowColumn":false},{"ColumnName":"ActionCode","ShowColumn":true,"ColumnWidth":80},{"ColumnName":"ActionId","ShowColumn":false,"ColumnWidth":70},{"ColumnName":"Flag","ShowColumn":true,"ColumnWidth":30},{"ColumnName":"NeedsAttention","ShowColumn":true,"ColumnWidth":30}]' ) END GO IF EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [KeyName] = 'EmailAzureAppClientId') BEGIN UPDATE [Settings] SET [KeyName] = 'AzureAppClientId' WHERE [KeyName] = 'EmailAzureAppClientId' END GO IF EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [KeyName] = 'EmailAzureAppClientSecret') BEGIN UPDATE [Settings] SET [KeyName] = 'AzureAppClientSecret' WHERE [KeyName] = 'EmailAzureAppClientSecret' END GO -- INSERT SCRIPT FOR DEFAULT ACION CODE FOR TRANSACT NOTES IF NOT EXISTS(SELECT TOP 1 1 FROM Settings where [KeyName] = 'TransactActionCode') BEGIN INSERT INTO Settings ([KeyName],[KeyValue]) VALUES ('TransactActionCode','ADMNT') END GO -- NEW ACTION TYPE FOR REQUESTED DOCUMENT - FRAMEWORK CHANGE BY PINO INSERT INTO [dbo].[DiaryDelActionType] ([ActionType], [ActionTypeDescription]) SELECT [NEW].[ActionType], [NEW].[ActionTypeDescription] FROM (SELECT CONVERT(NCHAR(1), 'L') AS [ActionType], CONVERT(NVARCHAR(40), 'Requested Documents') AS [ActionTypeDescription]) [NEW] LEFT OUTER JOIN [dbo].[DiaryDelActionType] [DDAT] ON [DDAT].[ActionType] = [NEW].[ActionType] WHERE [DDAT].[ActionType] IS NULL GO -- MY TASK - DEFAULT COLUMN LIST IF NOT EXISTS (SELECT TOP 1 1 FROM [CustomFilterbyUserandPage] AS [CF] WHERE [CF].[HandlerCode] = 'STANDARD' AND [CF].[PageName] = 'MyTask') BEGIN INSERT INTO [CustomFilterbyUserandPage] VALUES ('STANDARD','MyTask','Standard_View','2021-12-21 08:32:19.320','','','',0,-1, '[{"ColumnName":"CompleteOrGeneratedD","ShowColumn":true,"ColumnWidth":30,"ColumnIndex":0},{"ColumnName":"ActionType","ShowColumn":true,"ColumnWidth":30,"ColumnIndex":1}, {"ColumnName":"DelegationStatus","ShowColumn":true,"ColumnWidth":30,"ColumnIndex":2},{"ColumnName":"PriorityValue","ShowColumn":true,"ColumnWidth":30,"ColumnIndex":3}, {"ColumnName":"Date1","ShowColumn":true,"ColumnWidth":90,"ColumnIndex":4},{"ColumnName":"Time","ShowColumn":true,"ColumnWidth":60,"ColumnIndex":5}, {"ColumnName":"CaseCode","ShowColumn":true,"ColumnWidth":100,"ColumnIndex":6},{"ColumnName":"Handler","ShowColumn":true,"ColumnWidth":70,"ColumnIndex":7}, {"ColumnName":"Team","ShowColumn":true,"ColumnWidth":70,"ColumnIndex":8},{"ColumnName":"ClientCase","ShowColumn":true,"ColumnIndex":9}, {"ColumnName":"Synopsis","ShowColumn":true,"ColumnIndex":10},{"ColumnName":"Flag","ShowColumn":true,"ColumnWidth":30,"ColumnIndex":11}, {"ColumnName":"ActionId","ShowColumn":true,"ColumnWidth":70,"ColumnIndex":12},{"ColumnName":"ActionCode","ShowColumn":true,"ColumnWidth":100,"ColumnIndex":13}, {"ColumnName":"Action","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":14},{"ColumnName":"ActionStatus","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":15}, {"ColumnName":"FileColour","ShowColumn":false,"ColumnWidth":80,"ColumnIndex":16},{"ColumnName":"CaseFe","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":17}, {"ColumnName":"ClientName","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":18},{"ColumnName":"CreationDate","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":19}, {"ColumnName":"DelegatedFE","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":20},{"ColumnName":"DelType","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":21}, {"ColumnName":"DelDate","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":22},{"ColumnName":"DDStatus","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":23}, {"ColumnName":"DStatus","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":24},{"ColumnName":"DraftBillNo","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":25}, {"ColumnName":"DueDate","ShowColumn":false,"ColumnWidth":80,"ColumnIndex":26},{"ColumnName":"DueTime","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":27}, {"ColumnName":"Duration","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":28},{"ColumnName":"FeeEarner","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":29}, {"ColumnName":"FNCode","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":30},{"ColumnName":"From","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":31}, {"ColumnName":"Highlighted","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":32},{"ColumnName":"MatterDescription","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":33}, {"ColumnName":"OldRef","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":34},{"ColumnName":"Owner","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":35}, {"ColumnName":"Partner","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":36},{"ColumnName":"ProcessStatus","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":37}, {"ColumnName":"ProcessType","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":38},{"ColumnName":"User1","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":39}, {"ColumnName":"User2","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":40},{"ColumnName":"Secretary","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":41}, {"ColumnName":"WorkFlow","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":42},{"ColumnName":"WorkProcess","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":43}, {"ColumnName":"YourRef","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":44}]') END IF NOT EXISTS (SELECT TOP 1 1 FROM [CustomFilterColumndetails] AS [CF] WHERE [CF].[ColumnName] = 'Action Status' AND [CF].[PageName] = 'CaseDiary' AND [CF].[Name] = 'Not Completed') BEGIN INSERT INTO CustomFilterColumndetails(Name,Code,isSelected,FilterOrder,IsIconAvailable,Iconpath,ColumnName,PageName) VALUES('Not Completed','N',1,0,0,'','Action Status','CaseDiary') END IF NOT EXISTS (SELECT TOP 1 1 FROM [CustomFilterColumndetails] AS [CF] WHERE [CF].[ColumnName] = 'Action Status' AND [CF].[PageName] = 'CaseDiary' AND [CF].[Name] = 'Documents(s) Generated') BEGIN INSERT INTO CustomFilterColumndetails(Name,Code,isSelected,FilterOrder,IsIconAvailable,Iconpath,ColumnName,PageName) VALUES('Documents(s) Generated','G',1,1,0,'','Action Status','CaseDiary') END IF NOT EXISTS (SELECT TOP 1 1 FROM [CustomFilterColumndetails] AS [CF] WHERE [CF].[ColumnName] = 'Action Status' AND [CF].[PageName] = 'CaseDiary' AND [CF].[Name] = 'Completed') BEGIN INSERT INTO CustomFilterColumndetails(Name,Code,isSelected,FilterOrder,IsIconAvailable,Iconpath,ColumnName,PageName) VALUES('Completed','GC',1,2,0,'','Action Status','CaseDiary') END IF NOT EXISTS (SELECT TOP 1 1 FROM [CustomFilterColumndetails] AS [CF] WHERE [CF].[ColumnName] = 'Action Status' AND [CF].[PageName] = 'MyTask' AND [CF].[Name] = 'Not Completed') BEGIN INSERT INTO CustomFilterColumndetails(Name,Code,isSelected,FilterOrder,IsIconAvailable,Iconpath,ColumnName,PageName) VALUES('Not Completed','N',1,0,0,'','Action Status','MyTask') END IF NOT EXISTS (SELECT TOP 1 1 FROM [CustomFilterColumndetails] AS [CF] WHERE [CF].[ColumnName] = 'Action Status' AND [CF].[PageName] = 'MyTask' AND [CF].[Name] = 'Documents(s) Generated') BEGIN INSERT INTO CustomFilterColumndetails(Name,Code,isSelected,FilterOrder,IsIconAvailable,Iconpath,ColumnName,PageName) VALUES('Documents(s) Generated','G',1,1,0,'','Action Status','MyTask') END IF NOT EXISTS (SELECT TOP 1 1 FROM [CustomFilterColumndetails] AS [CF] WHERE [CF].[ColumnName] = 'Action Status' AND [CF].[PageName] = 'MyTask' AND [CF].[Name] = 'Completed') BEGIN INSERT INTO CustomFilterColumndetails(Name,Code,isSelected,FilterOrder,IsIconAvailable,Iconpath,ColumnName,PageName) VALUES('Completed','C',1,0,0,'','Action Status','MyTask') END GO --Insert Report Credential IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [keyname] = 'KaaS_accountreports_Credential_Count') BEGIN INSERT INTO [Settings]( [keyname], [keyvalue]) VALUES ( 'KaaS_accountreports_Credential_Count', 3) END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [keyname] = 'KaaS_accountreports_Credential_0') BEGIN INSERT INTO [Settings]( [keyname], [keyvalue]) VALUES ( 'KaaS_accountreports_Credential_0', 'gESYD4OOetogwRlvcVmlDTYfGBIidB6xt_____rhVwzNlp1phFap2godJ9WLxUYpDu6s3PY20CgE3f_____-----hgWn03wUpC9') END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [keyname] = 'KaaS_accountreports_Credential_1') BEGIN INSERT INTO [Settings]( [keyname], [keyvalue]) VALUES ( 'KaaS_accountreports_Credential_1', 'lr3yd_____ARAWnTuXcxy-----tHhdbWGMIFU-----ZKoa6O7CuL9xZtUiaaYgOytDv5VEH_____ZSfAAhZCjld-----') END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [keyname] = 'KaaS_accountreports_Credential_2') BEGIN INSERT INTO [Settings]( [keyname], [keyvalue]) VALUES ( 'KaaS_accountreports_Credential_2', 'UuHNcgMS1mwQ=') END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [keyname] = 'KaaS_systemreports_Credential_Count') BEGIN INSERT INTO [Settings]( [keyname], [keyvalue]) VALUES ( 'KaaS_systemreports_Credential_Count', 2) END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [keyname] = 'KaaS_systemreports_Credential_0') BEGIN INSERT INTO [Settings]( [keyname], [keyvalue]) VALUES ( 'KaaS_systemreports_Credential_0', 'U6Vj8ZFqhxUzEI2-----twsbxmeGGyIt1E349gH4AgQHBVFsglTB75l_____3HWdcML14WWPFasi76ZL18k4k3MGqhUd-----') END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [keyname] = 'KaaS_systemreports_Credential_1') BEGIN INSERT INTO [Settings]( [keyname], [keyvalue]) VALUES ( 'KaaS_systemreports_Credential_1', 'n0Dind23r_____eafPN0BvFd320jr0DrzXQT0o7ipKBbQCqS99NOFw6DvFksY9SP5YhafqDzs8M_____lIAf25GofgsJD8=') END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [keyname] = 'KaaS_sam4systemreports_Credential_Count') BEGIN INSERT INTO [Settings]( [keyname], [keyvalue]) VALUES ( 'KaaS_sam4systemreports_Credential_Count', 2) END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [keyname] = 'KaaS_sam4systemreports_Credential_0') BEGIN INSERT INTO [Settings]( [keyname], [keyvalue]) VALUES ( 'KaaS_sam4systemreports_Credential_0', 'V7RiBzSfut1XBlounprY5MT4vhgHXEDFmzoFaaMOYLYIncW5DIBQgWFZW-----FM4JdHNWFnlw_____ONOZztdqW0qtFTfvEwuA8') END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [keyname] = 'KaaS_sam4systemreports_Credential_1') BEGIN INSERT INTO [Settings]( [keyname], [keyvalue]) VALUES ( 'KaaS_sam4systemreports_Credential_1', 'oVX1ou_____g5XwDXvLIECTrkWVmC0oYOBbrgpNDlgeXo47doQiwqD44Olpxc6qe6_____7OZI_____awgZH7whrNVk=') END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [keyname] = 'KaaS_partnerreports_Credential_Count') BEGIN INSERT INTO [Settings]( [keyname], [keyvalue]) VALUES ( 'KaaS_partnerreports_Credential_Count', 2) END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [keyname] = 'KaaS_partnerreports_Credential_0') BEGIN INSERT INTO [Settings]( [keyname], [keyvalue]) VALUES ( 'KaaS_partnerreports_Credential_0', '7Ybgu6xgxGJI2iJcuSYjZH7iVKeRP1_____dP8xbhAiqY6LMvwfKjaMYE98u4sBndZDObprQIfAVC-----FJKrIcb_____70698V') END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [keyname] = 'KaaS_partnerreports_Credential_1') BEGIN INSERT INTO [Settings]( [keyname], [keyvalue]) VALUES ( 'KaaS_partnerreports_Credential_1', 'hKPaq53HJh3Yd03oYkzlGPPEJy-----YnfpLbXEKKp8HCbIgTSwybjBK-----iInIorPc_____sT0u65Q1TwRrMgmxN3cmQ=') END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [keyname] = 'KaaS_sam4partnerreports_Credential_Count') BEGIN INSERT INTO [Settings]( [keyname], [keyvalue]) VALUES ( 'KaaS_sam4partnerreports_Credential_Count', 2) END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [keyname] = 'KaaS_sam4partnerreports_Credential_0') BEGIN INSERT INTO [Settings]( [keyname], [keyvalue]) VALUES ( 'KaaS_sam4partnerreports_Credential_0', '7AQfei3DTAPQe9Ul60OkjqORGLW82y7f0Bd_____dVDO4Kz3DF1hqOUssmKesXefUGz3IEJlmtMsy_____h4lTFJFPS5GmbSOUWG') END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [keyname] = 'KaaS_sam4partnerreports_Credential_1') BEGIN INSERT INTO [Settings]( [keyname], [keyvalue]) VALUES ( 'KaaS_sam4partnerreports_Credential_1', '_____DiP45h59bBrFWXSK9v4B12chE3h9JhnrDIwpHrbLPpFCz9SaDkGd2kxtfvcDZcUKWCMATK-----6Qvq3B0=') END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [keyname] = 'KaaS_clientreports_Credential_Count') BEGIN INSERT INTO [Settings]( [keyname], [keyvalue]) VALUES ( 'KaaS_clientreports_Credential_Count', 2) END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [keyname] = 'KaaS_clientreports_Credential_0') BEGIN INSERT INTO [Settings]( [keyname], [keyvalue]) VALUES ( 'KaaS_clientreports_Credential_0', '38oPIN1e5Ix06jTUmAb0W799CsRA2Ls5uftPge77HBh-----w4zKTkNP-----Q7wLNgzyJonNvM8HXsgn7DF1fm8w2O1Fx9XKDR') END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [keyname] = 'KaaS_clientreports_Credential_1') BEGIN INSERT INTO [Settings]( [keyname], [keyvalue]) VALUES ( 'KaaS_clientreports_Credential_1', 'gGCfG08IXyKuXdMqv3P8rIvIOSnTn6cLvQGJSZjM1gDFem6OtxxLY4----------IfNA1OafodLdroLz5-----ylHyq0=') END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [keyname] = 'KaaS_billingreports_Credential_Count') BEGIN INSERT INTO [Settings]( [keyname], [keyvalue]) VALUES ( 'KaaS_billingreports_Credential_Count', 2) END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [keyname] = 'KaaS_billingreports_Credential_0') BEGIN INSERT INTO [Settings]( [keyname], [keyvalue]) VALUES ( 'KaaS_billingreports_Credential_0', 'sjqcXtHw-----hVDaU0RF2GfQcpqOzFsKPn8eaRflLwrf0onGVvVH42vnRLElcdvubo50Y-----QWQERiRgf7yfOeTFX55DIES3X') END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [keyname] = 'KaaS_billingreports_Credential_1') BEGIN INSERT INTO [Settings]( [keyname], [keyvalue]) VALUES ( 'KaaS_billingreports_Credential_1', 'ykg_____1PbC1NTuu8S3McczeXHuzxdqwow95ErPTewVMos5Ze2PO_____Vxqw8tPf-----iYwTWLwIkUgHxQuZL2Ew=') END GO IF NOT EXISTS (SELECT TOP 1 1 FROM [dbo].[CustomFilterColumndetails] WHERE [name]='Black Flag' AND PageName = 'MyTask' AND ColumnName = 'Action Flag') BEGIN UPDATE [dbo].[CustomFilterColumndetails] SET [Iconpath]='black-fg-svg', [IsIconAvailable]= 1 WHERE [name]='Black Flag' AND PageName = 'MyTask' AND ColumnName = 'Action Flag' END GO IF NOT EXISTS (SELECT TOP 1 1 FROM [dbo].[CustomFilterColumndetails] WHERE [name]='Blue Flag' AND PageName = 'MyTask' AND ColumnName = 'Action Flag') BEGIN UPDATE [dbo].[CustomFilterColumndetails] SET [Iconpath]='blue-fg-svg', [IsIconAvailable]= 1 WHERE [name]='Blue Flag' AND PageName = 'MyTask' AND ColumnName = 'Action Flag' END GO IF NOT EXISTS (SELECT TOP 1 1 FROM [dbo].[CustomFilterColumndetails] WHERE [name]='Clear Flag' AND PageName = 'MyTask' AND ColumnName = 'Action Flag') BEGIN UPDATE [dbo].[CustomFilterColumndetails] SET [Iconpath]='clear-fg-svg', [IsIconAvailable]= 1 WHERE [name]='Clear Flag' AND PageName = 'MyTask' AND ColumnName = 'Action Flag' END GO IF NOT EXISTS (SELECT TOP 1 1 FROM [dbo].[CustomFilterColumndetails] WHERE [name]='Green Flag' AND PageName = 'MyTask' AND ColumnName = 'Action Flag') BEGIN UPDATE [dbo].[CustomFilterColumndetails] SET [Iconpath]='green-fg-svg', [IsIconAvailable]= 1 WHERE [name]='Green Flag' AND PageName = 'MyTask' AND ColumnName = 'Action Flag' END GO IF NOT EXISTS (SELECT TOP 1 1 FROM [dbo].[CustomFilterColumndetails] WHERE [name]='Orange Flag' AND PageName = 'MyTask' AND ColumnName = 'Action Flag') BEGIN UPDATE [dbo].[CustomFilterColumndetails] SET [Iconpath]='orange-fg-svg', [IsIconAvailable]= 1 WHERE [name]='Orange Flag' AND PageName = 'MyTask' AND ColumnName = 'Action Flag' END GO IF NOT EXISTS (SELECT TOP 1 1 FROM [dbo].[CustomFilterColumndetails] WHERE [name]='Red Flag' AND PageName = 'MyTask' AND ColumnName = 'Action Flag') BEGIN UPDATE [dbo].[CustomFilterColumndetails] SET [Iconpath]='red-fg-svg', [IsIconAvailable]= 1 WHERE [name]='Red Flag' AND PageName = 'MyTask' AND ColumnName = 'Action Flag' END GO IF NOT EXISTS (SELECT TOP 1 1 FROM [dbo].[CustomFilterColumndetails] WHERE [name]='Yellow Flag' AND PageName = 'MyTask' AND ColumnName = 'Action Flag') BEGIN UPDATE [dbo].[CustomFilterColumndetails] SET [Iconpath]='yellow-fg-svg', [IsIconAvailable]= 1 WHERE [name]='Yellow Flag' AND PageName = 'MyTask' AND ColumnName = 'Action Flag' END GO -- DATAPUMP FOR CONTROL GROUPS AND PERMISSIONS -- FIRST REMOVE EXISTING RECORDS IF OBJECT_ID(N'KaasControlMaster',N'U') IS NOT NULL BEGIN TRUNCATE TABLE KaasControlMaster END GO -- INSERT WITH NEW DATA IF OBJECT_ID(N'KaasControlMaster',N'U') IS NOT NULL BEGIN INSERT INTO KaasControlMaster VALUES ('Access change WF in Case Diary', 'Fuse', 'array', 'template-library', 1, 2), ('Access Firm Phone Log', 'Fuse', 'array', 'phone-log', 1, 2), ('Access to Know Your Client', 'Fuse', 'array', 'KYC', 1, 2), ('Accounts User', 'Ribbon', 'array', 'Draft Invoice', 1, 2), ('Accounts User', 'Ribbon', 'array', 'Request Payment', 1, 2), ('Accounts User', 'Fuse', 'array', 'account-ledger', 1, 2), ('Accounts User', 'Fuse', 'array', 'my-cheques', 1, 2), ('Accounts User', 'Fuse', 'array', 'my-invoice', 1, 2), ('Accounts User', 'KnowyourclientComponent', 'material', 'financial_tab', 1, 2), ('AML Approval', 'ClientGeneralTabComponent', 'material', 'check_money_laundering_current_client_details', 1, 0), ('AML Approval', 'AMLComponent', 'material', 'check_money_laundering_aml', 1, 2), ('AML Approval', 'AMLComponent', 'material', 'aml_approved_date', 1, 0), ('Approve Invoice', 'DraftinvoiceComponent', 'element', 'btn_approve', 1, 2), ('Bank Details', 'AddEditAssociatesComponent', 'material', 'bank_details_tab_case_associate', 1, 1), ('Bank Details', 'CurrentClientDetailsComponent', 'material', 'bank_details_tab_current_client_details', 1, 1), ('Bank Details', 'ClientGeneralComponent', 'material', 'bank_details_tab_case_associate_name', 1, 1), ('Change Client Charge Out Rates', 'ClientBillingDetailsTabComponent', 'material', 'client_charge_out_rate_indicator', 1, 0), ('Change Client Charge Out Rates', 'ClientBillingDetailsTabComponent', 'dev', 'client_charge_out_rate_grid', 1, 0), ('Change Client Charge Out Rates', 'ClientBillingDetailsTabComponent', 'toolbar', 'client_charge_out_rate_edit_btn_tool', 1, 2), ('Change Client Charge Out Rates', 'ClientBillingDetailsTabComponent', 'context', 'client_charge_out_rate_edit_btn_context', 1, 2), ('Change Client Charge Out Rates', 'ClientBillingDetailsTabComponent', 'material', 'client_charge_out_rate_retired_check', 1, 0), ('Change Client Charge Out Rates', 'ClientBillingDetailsTabComponent', 'material', 'matter_charge_out_rate_indicator', 1, 0), ('Change Client Charge Out Rates', 'ClientBillingDetailsTabComponent', 'dev', 'matter_charge_out_rate_grid', 1, 0), ('Change Client Charge Out Rates', 'ClientBillingDetailsTabComponent', 'toolbar', 'matter_charge_out_rate_edit_btn_tool', 1, 2), ('Change Client Charge Out Rates', 'ClientBillingDetailsTabComponent', 'context', 'matter_charge_out_rate_edit_btn_context', 1, 2), ('Change Client Charge Out Rates', 'ClientBillingDetailsTabComponent', 'material', 'matter_charge_out_rate_retired_check', 1, 0), ('Change Day Book Handler', 'MyDayBookTableComponent', 'customDropDown', 'select_day_book_handler', 1, 0), ('Change Matter Security Permissions', 'ClientPermissionTabComponent', 'material', 'client_permission_tab', 1, 2), ('Change Matter Security Permissions', 'MatterPermissionTabComponent', 'material', 'matter_permission_tab', 1, 2), ('Delete Phone Log', 'Ribbon', 'array', 'Phone_log_delete', 1, 2), ('Discharge Undertaking', 'Ribbon', 'array', 'dischartUndertakings', 1, 0), ('Document Assist', 'Ribbon', 'array', 'document_assists', 1, 0), ('Maintain Associate Types', 'AssociatesComponent', 'context', 'associates_type_context_menu', 1, 2), ('Maintain Client and Case details', 'CurrentClientDetailsComponent', 'element', 'client_btn_save', 1, 2), ('Maintain Client and Case details', 'CurrentCaseDetailsComponent', 'element', 'matter_btn_save', 1, 2), ('Maintain Undertakings', 'AddEditUndertakingsComponent', 'element', 'undertaking_save_btn', 1, 2), ('Maintain Undertakings', 'Ribbon', 'array', 'addUndertakings', 1, 0), ('Maintain Undertakings', 'Ribbon', 'array', 'editUndertakings', 1, 0), ('Matter Archiving', 'ArchiveTabComponent', 'material', 'archive_closed_check', 1, 0), ('Matter Archiving', 'ArchiveTabComponent', 'element', 'archive_actual_destroy_date', 1, 0), ('Matter Archiving', 'ArchiveTabComponent', 'element', 'archive_expected_destroy_date', 1, 0), ('Matter Archiving', 'ArchiveTabComponent', 'customSelect', 'archive_destroy_by', 1, 0), ('Matter Archiving', 'ArchiveTabComponent', 'element', 'archive_box_bar_code', 1, 0), ('Matter Archiving', 'ArchiveTabComponent', 'element', 'archive_date_file_closed', 1, 0), ('Matter Archiving', 'ArchiveTabComponent', 'element', 'archive_file_bar_code', 1, 0), ('Matter Archiving', 'ArchiveTabComponent', 'customSelect', 'archive_location_dropdown', 1, 0), ('Precedents', 'CaseDiaryMenuComponent', 'subMenu', 'precedent_id', 1, 0), ('Matter Archiving', 'ArchiveTabComponent', 'element', 'archive_location', 1, 0), ('Strong Room', 'Fuse', 'array', 'caseFileManager', 1, 2), ('Strong Room', 'Fuse', 'array', 'strongroom', 1, 2), ('Strong Room Maintenance', 'StrongRoomGridComponent', 'context', 'CF', 1, 2), ('Strong Room Maintenance', 'StrongRoomGridComponent', 'context', 'DF', 1, 2), ('Strong Room Maintenance', 'StrongRoomGridComponent', 'context', 'RPF', 1, 2), ('Strong Room Maintenance', 'StrongRoomGridComponent', 'context', 'WF', 1, 2), ('Strong Room Maintenance', 'StrongRoomGridComponent', 'context', 'AF', 1, 2), ('Strong Room Maintenance', 'Ribbon', 'array', 'addFile', 1, 2), ('Strong Room Maintenance', 'Ribbon', 'array', 'changeFile', 1, 2), ('Strong Room Maintenance', 'Ribbon', 'array', 'deleteFile', 1, 2), ('Strong Room Maintenance', 'Ribbon', 'array', 'replaceFile', 1, 2), ('Strong Room Maintenance', 'Ribbon', 'array', 'withdrawFile', 1, 2), ('System Reports', 'Fuse', 'array', 'system-reports', 1, 2), ('Uncomplete Actions', 'EditCasediaryComponent', 'dev', 'complete_Check_Id', 1, 0), ('Undertakings', 'Fuse', 'array', 'undertakings', 1, 2), ('Undertakings', 'Fuse', 'array', 'firm-undertaking ', 1, 2), ('User Defined Reports', 'Fuse', 'array', 'user-reports', 1, 2); END GO -- DATAPUMP FOR CONTROL GROUPS AND MASTER IDS -- FIRST REMOVE EXISTING RECORDS IF OBJECT_ID(N'KaasGroupControlsMap ',N'U') IS NOT NULL BEGIN TRUNCATE TABLE KaasGroupControlsMap END GO -- INSERT WITH NEW DATA IF OBJECT_ID(N'KaasGroupControlsMap ',N'U') IS NOT NULL BEGIN INSERT INTO KaasGroupControlsMap SELECT ctlGrp.id, ctlMaster.ControlMasterId FROM KHCtlGroups ctlGrp JOIN KaasControlMaster ctlMaster on ctlGrp.GroupName = ctlMaster.ControlGroupName; END GO --Added for Document Upload retry count in Mobile IF NOT EXISTS (SELECT 1 FROM [dbo].[Settings] WHERE KeyName = 'UploadRetryCount') BEGIN insert into [dbo].[Settings] values('UploadRetryCount','3'); END GO IF NOT EXISTS (SELECT TOP 1 1 FROM [dbo].[CustomFilterColumndetails] WHERE [ColumnName]='HasAttachment' AND PageName = 'DocumentManager') BEGIN INSERT INTO [dbo].[CustomFilterColumndetails] VALUES ('Yes','Y',1,1,0,'','HasAttachment','DocumentManager') INSERT INTO [dbo].[CustomFilterColumndetails] VALUES ('No','N',1,2,0,'','HasAttachment','DocumentManager') END GO IF NOT EXISTS (SELECT TOP 1 1 FROM [dbo].[CustomFilterColumndetails] WHERE [ColumnName]='Document Source' AND PageName = 'DocumentManager') BEGIN INSERT INTO [dbo].[CustomFilterColumndetails] VALUES ('Capture','Capture',1,1,0,'','Document Source','DocumentManager') INSERT INTO [dbo].[CustomFilterColumndetails] VALUES ('Captured','Captured',1,2,0,'','Document Source','DocumentManager') INSERT INTO [dbo].[CustomFilterColumndetails] VALUES ('Case','Case',1,3,0,'','Document Source','DocumentManager') INSERT INTO [dbo].[CustomFilterColumndetails] VALUES ('Dictation','Dictation',1,4,0,'','Document Source','DocumentManager') INSERT INTO [dbo].[CustomFilterColumndetails] VALUES ('IManage','IManage',1,5,0,'','Document Source','DocumentManager') INSERT INTO [dbo].[CustomFilterColumndetails] VALUES ('Received E-mail','Received E-mail',1,5,0,'','Document Source','DocumentManager') INSERT INTO [dbo].[CustomFilterColumndetails] VALUES ('Sent E-mail','Sent E-mail',1,6,0,'','Document Source','DocumentManager') END GO IF NOT EXISTS (SELECT TOP 1 1 FROM [dbo].[CustomFilterColumndetails] WHERE [ColumnName]='DraftNo' AND PageName = 'MyInvoice') BEGIN INSERT INTO [dbo].[CustomFilterColumndetails] VALUES ('Equals 0',0,1,0,0,'','DraftNo','MyInvoice') INSERT INTO [dbo].[CustomFilterColumndetails] VALUES ('Not equals 0',1,1,1,0,'','DraftNo','MyInvoice') END GO IF NOT EXISTS (SELECT TOP 1 1 FROM [dbo].[CustomFilterColumndetails] WHERE [ColumnName]='Type' AND PageName = 'MyInvoice') BEGIN INSERT INTO [dbo].[CustomFilterColumndetails] VALUES ('C','C',1,0,0,'','Type','MyInvoice') INSERT INTO [dbo].[CustomFilterColumndetails] VALUES ('I','I',1,1,0,'','Type','MyInvoice') END GO IF NOT EXISTS (SELECT TOP 1 1 FROM [dbo].[CustomFilterColumndetails] WHERE [ColumnName]='OpenInvoice' AND PageName = 'MyInvoice') BEGIN INSERT INTO [dbo].[CustomFilterColumndetails] VALUES ('Yes','Y',1,0,0,'','OpenInvoice','MyInvoice') INSERT INTO [dbo].[CustomFilterColumndetails] VALUES ('No','N',1,1,0,'','OpenInvoice','MyInvoice') END GO IF NOT EXISTS (SELECT 1 FROM [dbo].[CustomFilterbyUserandPage] WHERE [FilterOrder] = -1 AND [PageName]='MyInvoice') BEGIN INSERT INTO [dbo].[CustomFilterbyUserandPage] ([HandlerCode] ,[PageName] ,[FilterName] ,[CreatedDate] ,[FilterOrder] ,[GridViewState] ) VALUES( 'STANDARD' ,'MyInvoice' ,'Standard_View' ,GETUTCDATE() ,-1 ,'[{"ColumnName":"MATTER","ShowColumn":true,"ColumnWidth":95,"ColumnIndex":0},{"ColumnName":"BILLDATE","ShowColumn":true,"ColumnWidth":90,"ColumnIndex":1},{"ColumnName":"ADDRESSEE","ShowColumn":true,"ColumnWidth":250,"ColumnIndex":2},{"ColumnName":"ADDRESS","ShowColumn":true,"ColumnIndex":3},{"ColumnName":"FeCode","ShowColumn":false,"ColumnWidth":80,"ColumnIndex":4},{"ColumnName":"TYPE","ShowColumn":true,"ColumnWidth":50,"ColumnIndex":5},{"ColumnName":"TOTAL","ShowColumn":true,"ColumnWidth":80,"ColumnIndex":6},{"ColumnName":"DRAFTNO","ShowColumn":true,"ColumnWidth":80,"ColumnIndex":7},{"ColumnName":"INVOICENO","ShowColumn":true,"ColumnWidth":80,"ColumnIndex":8},{"ColumnName":"OpenInvoice","ShowColumn":true,"ColumnWidth":80,"ColumnIndex":9},{"ColumnName":"Released","ShowColumn":true,"ColumnWidth":70,"ColumnIndex":10}]' ) END GO IF NOT EXISTS (SELECT 1 FROM [dbo].[CustomFilterbyUserandPage] WHERE [FilterOrder] = -1 AND [PageName]='DocumentManager') BEGIN INSERT INTO [dbo].[CustomFilterbyUserandPage] ([HandlerCode] ,[PageName] ,[FilterName] ,[CreatedDate] ,[FilterOrder] ,[GridViewState] ) VALUES( 'STANDARD' ,'DocumentManager' ,'Standard_View' ,GETUTCDATE() ,-1 ,'[{"ColumnName":"Type","ShowColumn":true,"ColumnWidth":30,"ColumnIndex":0},{"ColumnName":"Attachments","ShowColumn":true,"ColumnWidth":30,"ColumnIndex":1},{"ColumnName":"IsInDocFolder","ShowColumn":true,"ColumnWidth":30,"ColumnIndex":2},{"ColumnName":"Document","ShowColumn":true,"ColumnWidth":180,"ColumnIndex":3},{"ColumnName":"CurrentVersion","ShowColumn":true,"ColumnWidth":60,"ColumnIndex":4},{"ColumnName":"DiaryDate","ShowColumn":true,"ColumnWidth":100,"ColumnIndex":5},{"ColumnName":"DocumentDate","ShowColumn":true,"ColumnWidth":100,"ColumnIndex":6},{"ColumnName":"DocumentClassDescription","ShowColumn":true,"ColumnWidth":120,"ColumnIndex":7},{"ColumnName":"DocumentSource","ShowColumn":true,"ColumnWidth":80,"ColumnIndex":8},{"ColumnName":"EmailAddress","ShowColumn":true,"ColumnWidth":120,"ColumnIndex":9},{"ColumnName":"AddressTo","ShowColumn":true,"ColumnWidth":120,"ColumnIndex":10},{"ColumnName":"Subject","ShowColumn":true,"ColumnIndex":11},{"ColumnName":"FilePath","ShowColumn":true,"ColumnWidth":180,"ColumnIndex":12},{"ColumnName":"TrackReference","ShowColumn":true,"ColumnWidth":80,"ColumnIndex":13},{"ColumnName":"ActionId","ShowColumn":false,"ColumnWidth":80,"ColumnIndex":14},{"ColumnName":"DiaryTime","ShowColumn":false,"ColumnWidth":80,"ColumnIndex":15},{"ColumnName":"DocumentTime","ShowColumn":false,"ColumnWidth":80,"ColumnIndex":16},{"ColumnName":"SigningStatus","ShowColumn":true,"ColumnWidth":100,"ColumnIndex":17}]' ) END GO IF NOT EXISTS (SELECT 1 FROM [dbo].[CustomFilterbyUserandPage] WHERE [FilterOrder] = -1 AND [PageName]='Matter') BEGIN INSERT INTO [dbo].[CustomFilterbyUserandPage] ([HandlerCode] ,[PageName] ,[FilterName] ,[CreatedDate] ,[FilterOrder] ,[GridViewState] ) VALUES( 'STANDARD' ,'Matter' ,'Standard_View' ,GETUTCDATE() ,-1 ,'[{"ColumnName":"Code","ShowColumn":true,"ColumnWidth":90,"ColumnIndex":0},{"ColumnName":"LastAccessed","ShowColumn":true,"ColumnWidth":90,"ColumnIndex":1},{"ColumnName":"FileColour","ShowColumn":true,"ColumnWidth":100,"ColumnIndex":2},{"ColumnName":"Name","ShowColumn":true,"ColumnWidth":150,"ColumnIndex":3},{"ColumnName":"Description","ShowColumn":true,"ColumnWidth":200,"ColumnIndex":4},{"ColumnName":"FeeEarner","ShowColumn":true,"ColumnWidth":90,"ColumnIndex":5},{"ColumnName":"Started","ShowColumn":true,"ColumnWidth":90,"ColumnIndex":6},{"ColumnName":"OldRef","ShowColumn":false,"ColumnWidth":70,"ColumnIndex":7},{"ColumnName":"YourRef","ShowColumn":true,"ColumnWidth":70,"ColumnIndex":8},{"ColumnName":"Dept","ShowColumn":false,"ColumnWidth":90,"ColumnIndex":9},{"ColumnName":"WorkType","ShowColumn":false,"ColumnWidth":90,"ColumnIndex":10},{"ColumnName":"Address","ShowColumn":false,"ColumnWidth":120,"ColumnIndex":11},{"ColumnName":"CaseStatusDesc","ShowColumn":false,"ColumnWidth":80,"ColumnIndex":12},{"ColumnName":"CloseDate","ShowColumn":false,"ColumnWidth":80,"ColumnIndex":13},{"ColumnName":"Closed","ShowColumn":false,"ColumnWidth":55,"ColumnIndex":14},{"ColumnName":"Email","ShowColumn":false,"ColumnWidth":150,"ColumnIndex":15},{"ColumnName":"FeeCode","ShowColumn":false,"ColumnWidth":70,"ColumnIndex":16},{"ColumnName":"FileNum","ShowColumn":false,"ColumnWidth":90,"ColumnIndex":17},{"ColumnName":"PhoneNumber","ShowColumn":false,"ColumnWidth":100,"ColumnIndex":18},{"ColumnName":"User1","ShowColumn":false,"ColumnWidth":70,"ColumnIndex":19},{"ColumnName":"User2","ShowColumn":false,"ColumnWidth":70,"ColumnIndex":20}]' ) END GO IF NOT EXISTS(SELECT TOP 1 1 FROM [Settings] WHERE [KeyName] = 'DesktopAddinExpirationTime') BEGIN INSERT INTO [Settings]( [KeyName], [KeyValue]) VALUES ( 'DesktopAddinExpirationTime', 10) END GO