-- Update ID's to hard-coded ID's in order to let the export/import work better
update CSEasyScriptSupportedPages set ID = '5AECC9A0-6EEA-4B1C-86FD-2AA8D425AFB2' where ASPXPage = 'CRMAccountCard.aspx'
update CSEasyScriptSupportedPages set ID = '103389CA-9B6E-4666-8849-512C15982F71' where ASPXPage = 'CRMAccountMaint.aspx'
update CSEasyScriptSupportedPages set ID = '2C5C3FB0-4D19-43F8-875E-D2E6BB1BE7EE' where ASPXPage = 'CRMContactCard.aspx'
update CSEasyScriptSupportedPages set ID = 'CB2A8AA6-97AA-4265-AAAD-3D69E2AB1239' where ASPXPage = 'CRMContactMaint.aspx'
update CSEasyScriptSupportedPages set ID = '879B397C-CC1D-4AAD-A779-3101E629DAB3' where ASPXPage = 'CRMOpportunityCard.aspx'
update CSEasyScriptSupportedPages set ID = '16E523A8-4D05-4A9C-BD13-56DA95416AE7' where ASPXPage = 'CRMOpportunityMaint.aspx'
update CSEasyScriptSupportedPages set ID = 'E73CF31B-9DDC-44DB-B85B-4B320140E3F9' where ASPXPage = 'CRMPersonAccountCard.aspx'
update CSEasyScriptSupportedPages set ID = '2310BCCD-82B2-4D32-AA32-C044F31E08BF' where ASPXPage = 'CRMPersonAccountMaint.aspx'
update CSEasyScriptSupportedPages set ID = 'FE56BE00-C428-4433-AF3A-AA1CB1CDEAE8' where ASPXPage = 'HRMResource.aspx'
update CSEasyScriptSupportedPages set ID = 'A5E06782-4675-4636-BFE1-176705D09E6B' where ASPXPage = 'HRMResourceCard.aspx'
update CSEasyScriptSupportedPages set ID = '1D6BF3AF-E69D-49BF-A693-06D4731C9D6D' where ASPXPage = 'LogItem.aspx'
update CSEasyScriptSupportedPages set ID = 'EB4CA425-89CA-4A17-A7DC-6D177F88E16F' where ASPXPage = 'LogItemCard.aspx'
update CSEasyScriptSupportedPages set ID = '70515BA5-9217-4C9D-821C-B32B84579E4D' where ASPXPage = 'LogItemNumber.aspx'
update CSEasyScriptSupportedPages set ID = '4AAA0FC3-CB81-4781-9F60-CD2496555A55' where ASPXPage = 'ProCard.aspx'
update CSEasyScriptSupportedPages set ID = 'E3B99C2B-ED7F-4444-8B8B-977E9B5D41F1' where ASPXPage = 'ProEdit.aspx'
go


if not exists(select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = 'CSEasyScriptSections' and COLUMN_NAME = 'CaptionXML')
begin
	alter table [dbo].[CSEasyScriptSections]
		add [CaptionXML] [nvarchar](max) NULL
end
go
