Don't miss out Virtual Happy Hour this Friday (April 26).
Try our conversational search powered by Generative AI!
AI OnAI Off
Episerver CMS 9.12.2.0 - Error After Update
Maybe an database upgrade of the Epi db is missing on azure? Just guessing though mind you. I don't recognize that particular error.
Edited,
Sep 22, 2016 17:09
I think they were inside Framework nuget package or CMS.Core package. You can also set flag in configuration (episerver.framework section) to automatically update database. But I guess - if Db would be guilty, high chances are that you should actually receive different exception..
Sep 22, 2016 23:43
Looks like I see enough reasons to believe that this is indeed my database issue .. Apparently the DACPAC created out of the Episerver.cms.core.sql file by Visual Studio (that i need to automate the deployment process) has now ignored the INSERT statements
-- EPiServer.Cms.Core database script--
--beginvalidatingquery
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_DatabaseVersion]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
select 0, 'The episerver cms core database is already installed'
else
select 1, 'Ok'
--endvalidatingquery
GO
PRINT N'Creating [dbo].[LongParameterTable]...';
GO
PRINT N'Creating [dbo].[editDeletePageInternalTable]...';
GO
PRINT N'Creating [dbo].[BigTableDeleteItemInternalTable]...';
GO
PRINT N'Creating [dbo].[DateTimeConversion_DateTimeOffset]...';
GO
PRINT N'Creating [dbo].[HostDefinitionTable]...';
GO
PRINT N'Creating [dbo].[StringParameterTable]...';
GO
PRINT N'Creating [dbo].[UriPartsTable]...';
GO
PRINT N'Creating [dbo].[ContentReferenceTable]...';
GO
PRINT N'Creating [dbo].[IDTable]...';
GO
PRINT N'Creating [dbo].[ProjectItemTable]...';
GO
PRINT N'Creating [dbo].[ProjectMemberTable]...';
GO
PRINT N'Creating [dbo].[ChangeNotificationStringTable]...';
GO
PRINT N'Creating [dbo].[ChangeNotificationIntTable]...';
GO
PRINT N'Creating [dbo].[ChangeNotificationGuidTable]...';
GO
PRINT N'Creating [dbo].[GuidParameterTable]...';
GO
PRINT N'Creating [dbo].[tblNotificationSubscription]...';
GO
PRINT N'Creating [dbo].[tblNotificationSubscription].[IDX_tblNotificationSubscription_UserName]...';
GO
PRINT N'Creating [dbo].[tblNotificationSubscription].[IDX_tblNotificationSubscription_SubscriptionKey]...';
GO
PRINT N'Creating [dbo].[tblIndexRequestLog]...';
GO
PRINT N'Creating [dbo].[tblIndexRequestLog].[IDX_tblIndexRequestLog_StoreName]...';
GO
PRINT N'Creating [dbo].[tblIndexRequestLog].[IDX_tblIndexRequestLog_Indexed_DateTime01]...';
GO
PRINT N'Creating [dbo].[tblIndexRequestLog].[IDX_tblIndexRequestLog_Indexed_String01]...';
GO
PRINT N'Creating [dbo].[tblNotificationMessage]...';
GO
PRINT N'Creating [dbo].[tblNotificationMessage].[IDX_tblNotificationMessage_SendAt]...';
GO
PRINT N'Creating [dbo].[tblNotificationMessage].[IDX_tblNotificationMessage_Sent]...';
GO
PRINT N'Creating [dbo].[tblNotificationMessage].[IDX_tblNotificationMessage_Read]...';
GO
PRINT N'Creating [dbo].[tblHostDefinition]...';
GO
PRINT N'Creating [dbo].[tblHostDefinition].[IX_tblHostDefinition_fkID]...';
GO
PRINT N'Creating [dbo].[tblSiteDefinition]...';
GO
PRINT N'Creating [dbo].[tblSiteDefinition].[IX_tblSiteDefinition_UniqueId]...';
GO
PRINT N'Creating [dbo].[tblActivityLogComment]...';
GO
PRINT N'Creating [dbo].[tblActivityLogComment].[IDX_tblActivityLogComment_EntryId]...';
GO
PRINT N'Creating [dbo].[tblActivityLogAssociation]...';
GO
PRINT N'Creating [dbo].[tblActivityLogAssociation].[IDX_tblActivityLogAssociation_From]...';
GO
PRINT N'Creating [dbo].[tblActivityLogAssociation].[IDX_tblActivityLogAssociation_To]...';
GO
PRINT N'Creating [dbo].[tblTaskInformation]...';
GO
PRINT N'Creating [dbo].[tblTaskInformation].[IDX_tblTaskInformation_StoreName]...';
GO
PRINT N'Creating [dbo].[tblTaskInformation].[IDX_tblTaskInformation_Indexed_Integer01]...';
GO
PRINT N'Creating [dbo].[tblTaskInformation].[IDX_tblTaskInformation_Indexed_DateTime01]...';
GO
PRINT N'Creating [dbo].[tblTaskInformation].[IDX_tblTaskInformation_Indexed_DateTime02]...';
GO
PRINT N'Creating [dbo].[tblTaskInformation].[IDX_tblTaskInformation_Indexed_Guid01]...';
GO
PRINT N'Creating [dbo].[tblTaskInformation].[IDX_tblTaskInformation_Indexed_String01]...';
GO
PRINT N'Creating [dbo].[tblTaskInformation].[IDX_tblTaskInformation_Indexed_String02]...';
GO
PRINT N'Creating [dbo].[tblMappedIdentity]...';
GO
PRINT N'Creating [dbo].[tblMappedIdentity].[IDX_tblMappedIdentity_ProviderUniqueId]...';
GO
PRINT N'Creating [dbo].[tblMappedIdentity].[IDX_tblMappedIdentity_Provider]...';
GO
PRINT N'Creating [dbo].[tblMappedIdentity].[IDX_tblMappedIdentity_ContentGuid]...';
GO
PRINT N'Creating [dbo].[tblMappedIdentity].[IDX_tblMappedIdentity_ExternalId]...';
GO
PRINT N'Creating [dbo].[tblProjectMember]...';
GO
PRINT N'Creating [dbo].[tblProjectMember].[IX_tblProjectMember_fkProjectID]...';
GO
PRINT N'Creating [dbo].[tblProjectItem]...';
GO
PRINT N'Creating [dbo].[tblProjectItem].[IX_tblProjectItem_ContentLink]...';
GO
PRINT N'Creating [dbo].[tblProjectItem].[IX_tblProjectItem_fkProjectID]...';
GO
PRINT N'Creating [dbo].[tblProject]...';
GO
PRINT N'Creating [dbo].[tblProject].[IX_tblProject_StatusName]...';
GO
PRINT N'Creating [dbo].[tblVisitorGroupStatistic]...';
GO
PRINT N'Creating [dbo].[tblVisitorGroupStatistic].[IDX_tblVisitorGroupStatistic_StoreName]...';
GO
PRINT N'Creating [dbo].[tblVisitorGroupStatistic].[IDX_tblVisitorGroupStatistic_Indexed_Boolean01]...';
GO
PRINT N'Creating [dbo].[tblVisitorGroupStatistic].[IDX_tblVisitorGroupStatistic_Indexed_Integer01]...';
GO
PRINT N'Creating [dbo].[tblVisitorGroupStatistic].[IDX_tblVisitorGroupStatistic_Indexed_Integer02]...';
GO
PRINT N'Creating [dbo].[tblVisitorGroupStatistic].[IDX_tblVisitorGroupStatistic_Indexed_Integer03]...';
GO
PRINT N'Creating [dbo].[tblVisitorGroupStatistic].[IDX_tblVisitorGroupStatistic_Indexed_Long01]...';
GO
PRINT N'Creating [dbo].[tblVisitorGroupStatistic].[IDX_tblVisitorGroupStatistic_Indexed_Long02]...';
GO
PRINT N'Creating [dbo].[tblVisitorGroupStatistic].[IDX_tblVisitorGroupStatistic_Indexed_DateTime01]...';
GO
PRINT N'Creating [dbo].[tblVisitorGroupStatistic].[IDX_tblVisitorGroupStatistic_Indexed_Guid01]...';
GO
PRINT N'Creating [dbo].[tblVisitorGroupStatistic].[IDX_tblVisitorGroupStatistic_Indexed_Float01]...';
GO
PRINT N'Creating [dbo].[tblVisitorGroupStatistic].[IDX_tblVisitorGroupStatistic_Indexed_Float02]...';
GO
PRINT N'Creating [dbo].[tblVisitorGroupStatistic].[IDX_tblVisitorGroupStatistic_Indexed_Float03]...';
GO
PRINT N'Creating [dbo].[tblVisitorGroupStatistic].[IDX_tblVisitorGroupStatistic_Indexed_String01]...';
GO
PRINT N'Creating [dbo].[tblVisitorGroupStatistic].[IDX_tblVisitorGroupStatistic_Indexed_String02]...';
GO
PRINT N'Creating [dbo].[tblVisitorGroupStatistic].[IDX_tblVisitorGroupStatistic_Indexed_String03]...';
GO
PRINT N'Creating [dbo].[tblVisitorGroupStatistic].[IDX_tblVisitorGroupStatistic_Indexed_Binary01]...';
GO
PRINT N'Creating [dbo].[tblSystemBigTable]...';
GO
PRINT N'Creating [dbo].[tblSystemBigTable].[IDX_tblSystemBigTable_StoreName]...';
GO
PRINT N'Creating [dbo].[tblSystemBigTable].[IDX_tblSystemBigTable_Indexed_Boolean01]...';
GO
PRINT N'Creating [dbo].[tblSystemBigTable].[IDX_tblSystemBigTable_Indexed_Integer01]...';
GO
PRINT N'Creating [dbo].[tblSystemBigTable].[IDX_tblSystemBigTable_Indexed_Integer02]...';
GO
PRINT N'Creating [dbo].[tblSystemBigTable].[IDX_tblSystemBigTable_Indexed_Integer03]...';
GO
PRINT N'Creating [dbo].[tblSystemBigTable].[IDX_tblSystemBigTable_Indexed_Long01]...';
GO
PRINT N'Creating [dbo].[tblSystemBigTable].[IDX_tblSystemBigTable_Indexed_Long02]...';
GO
PRINT N'Creating [dbo].[tblSystemBigTable].[IDX_tblSystemBigTable_Indexed_DateTime01]...';
GO
PRINT N'Creating [dbo].[tblSystemBigTable].[IDX_tblSystemBigTable_Indexed_Guid01]...';
GO
PRINT N'Creating [dbo].[tblSystemBigTable].[IDX_tblSystemBigTable_Indexed_Float01]...';
GO
PRINT N'Creating [dbo].[tblSystemBigTable].[IDX_tblSystemBigTable_Indexed_Float02]...';
GO
PRINT N'Creating [dbo].[tblSystemBigTable].[IDX_tblSystemBigTable_Indexed_Float03]...';
GO
PRINT N'Creating [dbo].[tblSystemBigTable].[IDX_tblSystemBigTable_Indexed_Decimal01]...';
GO
PRINT N'Creating [dbo].[tblSystemBigTable].[IDX_tblSystemBigTable_Indexed_String01]...';
GO
PRINT N'Creating [dbo].[tblSystemBigTable].[IDX_tblSystemBigTable_Indexed_String02]...';
GO
PRINT N'Creating [dbo].[tblSystemBigTable].[IDX_tblSystemBigTable_Indexed_String03]...';
GO
PRINT N'Creating [dbo].[tblSystemBigTable].[IDX_tblSystemBigTable_Indexed_Binary01]...';
GO
PRINT N'Creating [dbo].[tblEntityType]...';
GO
PRINT N'Creating [dbo].[tblEntityGuid]...';
GO
PRINT N'Creating [dbo].[tblChangeNotificationQueuedString]...';
GO
PRINT N'Creating [dbo].[tblChangeNotificationQueuedString].[IDX_tblChangeNotificationQueuedString]...';
GO
PRINT N'Creating [dbo].[tblChangeNotificationQueuedInt]...';
GO
PRINT N'Creating [dbo].[tblChangeNotificationQueuedInt].[IDX_tblChangeNotificationQueuedInt]...';
GO
PRINT N'Creating [dbo].[tblChangeNotificationQueuedGuid]...';
GO
PRINT N'Creating [dbo].[tblChangeNotificationQueuedGuid].[IDX_tblChangeNotificationQueuedGuid]...';
GO
PRINT N'Creating [dbo].[tblChangeNotificationProcessor]...';
GO
PRINT N'Creating [dbo].[tblChangeNotificationConnection]...';
GO
PRINT N'Creating [dbo].[tblBigTableStoreInfo]...';
GO
PRINT N'Creating [dbo].[tblBigTableStoreConfig]...';
GO
PRINT N'Creating [dbo].[tblBigTableStoreConfig].[IDX_tblBigTableStoreConfig_StoreName]...';
GO
PRINT N'Creating [dbo].[tblBigTableReference]...';
GO
PRINT N'Creating [dbo].[tblBigTableReference].[IDX_tblBigTableReference_RefIdValue]...';
GO
PRINT N'Creating [dbo].[tblBigTableIdentity]...';
GO
PRINT N'Creating [dbo].[tblBigTableIdentity].[IDX_tblBigTableIdentity_Guid]...';
GO
PRINT N'Creating [dbo].[tblBigTable]...';
GO
PRINT N'Creating [dbo].[tblBigTable].[IDX_tblBigTable_StoreName]...';
GO
PRINT N'Creating [dbo].[tblBigTable].[IDX_tblBigTable_Indexed_Boolean01]...';
GO
PRINT N'Creating [dbo].[tblBigTable].[IDX_tblBigTable_Indexed_Integer01]...';
GO
PRINT N'Creating [dbo].[tblBigTable].[IDX_tblBigTable_Indexed_Integer02]...';
GO
PRINT N'Creating [dbo].[tblBigTable].[IDX_tblBigTable_Indexed_Integer03]...';
GO
PRINT N'Creating [dbo].[tblBigTable].[IDX_tblBigTable_Indexed_Long01]...';
GO
PRINT N'Creating [dbo].[tblBigTable].[IDX_tblBigTable_Indexed_Long02]...';
GO
PRINT N'Creating [dbo].[tblBigTable].[IDX_tblBigTable_Indexed_DateTime01]...';
GO
PRINT N'Creating [dbo].[tblBigTable].[IDX_tblBigTable_Indexed_Guid01]...';
GO
PRINT N'Creating [dbo].[tblBigTable].[IDX_tblBigTable_Indexed_Float01]...';
GO
PRINT N'Creating [dbo].[tblBigTable].[IDX_tblBigTable_Indexed_Float02]...';
GO
PRINT N'Creating [dbo].[tblBigTable].[IDX_tblBigTable_Indexed_Float03]...';
GO
PRINT N'Creating [dbo].[tblBigTable].[IDX_tblBigTable_Indexed_Decimal01]...';
GO
PRINT N'Creating [dbo].[tblBigTable].[IDX_tblBigTable_Indexed_String01]...';
GO
PRINT N'Creating [dbo].[tblBigTable].[IDX_tblBigTable_Indexed_String02]...';
GO
PRINT N'Creating [dbo].[tblBigTable].[IDX_tblBigTable_Indexed_String03]...';
GO
PRINT N'Creating [dbo].[tblBigTable].[IDX_tblBigTable_Indexed_Binary01]...';
GO
PRINT N'Creating [dbo].[tblXFormData]...';
GO
PRINT N'Creating [dbo].[tblXFormData].[IDX_tblXFormData_String01]...';
GO
PRINT N'Creating [dbo].[tblXFormData].[IDX_tblXFormData_String02]...';
GO
PRINT N'Creating [dbo].[tblXFormData].[IDX_tblXFormData_String03]...';
GO
PRINT N'Creating [dbo].[tblActivityLog]...';
GO
PRINT N'Creating [dbo].[tblActivityLog].[IDX_tblActivityLog_ChangeDate]...';
GO
PRINT N'Creating [dbo].[tblActivityLog].[IDX_tblActivityLog_Pkid_ChangeDate]...';
GO
PRINT N'Creating [dbo].[tblActivityLog].[IDX_tblActivityLog_RelatedItem]...';
GO
PRINT N'Creating [dbo].[tblSiteConfig]...';
GO
PRINT N'Creating [dbo].[tblSiteConfig].[IX_tblSiteConfig]...';
GO
PRINT N'Creating [dbo].[tblSynchedUserRelations]...';
GO
PRINT N'Creating [dbo].[tblSynchedUserRole]...';
GO
PRINT N'Creating [dbo].[tblSynchedUserRole].[IX_tblSynchedUserRole_Unique]...';
GO
PRINT N'Creating [dbo].[tblSynchedUser]...';
GO
PRINT N'Creating [dbo].[tblSynchedUser].[IX_tblWindowsUser_Unique]...';
GO
PRINT N'Creating [dbo].[tblSynchedUser].[IX_tblWindowsUser_Email]...';
GO
PRINT N'Creating [dbo].[tblSynchedUser].[IX_tblWindowsUser_LoweredGivenName]...';
GO
PRINT N'Creating [dbo].[tblSynchedUser].[IX_tblWindowsUser_LoweredSurname]...';
GO
PRINT N'Creating [dbo].[tblUniqueSequence]...';
GO
PRINT N'Creating [dbo].[tblLanguageBranch]...';
GO
PRINT N'Creating [dbo].[tblContentLanguageSetting]...';
GO
PRINT N'Creating [dbo].[tblContentLanguage]...';
GO
PRINT N'Creating [dbo].[tblContentLanguage].[IDX_tblContentLanguage_ContentGUID]...';
GO
PRINT N'Creating [dbo].[tblContentLanguage].[IDX_tblContentLanguage_Name]...';
GO
PRINT N'Creating [dbo].[tblContentLanguage].[IDX_tblContentLanguage_ExternalURL]...';
GO
PRINT N'Creating [dbo].[tblContentLanguage].[IDX_tblContentLanguage_URLSegment]...';
GO
PRINT N'Creating [dbo].[tblContentLanguage].[IDX_tblContentLanguage_ContentLinkGUID]...';
GO
PRINT N'Creating [dbo].[tblContentLanguage].[IDX_tblContentLanguage_Version]...';
GO
PRINT N'Creating [dbo].[tblWorkContentProperty]...';
GO
PRINT N'Creating [dbo].[tblWorkContentProperty].[IX_tblWorkContentProperty_fkWorkContentID]...';
GO
PRINT N'Creating [dbo].[tblWorkContentProperty].[IDX_tblWorkContentProperty_ContentLink]...';
GO
PRINT N'Creating [dbo].[tblWorkContentProperty].[IDX_tblWorkContentProperty_ScopeName]...';
GO
PRINT N'Creating [dbo].[tblWorkContentProperty].[IDX_tblWorkContentProperty_ContentTypeID]...';
GO
PRINT N'Creating [dbo].[tblWorkContentProperty].[IDX_tblWorkContentProperty_fkPropertyDefinitionID]...';
GO
PRINT N'Creating [dbo].[tblWorkContentProperty].[IX_tblWorkContentProperty_guid]...';
GO
PRINT N'Creating [dbo].[tblWorkContent]...';
GO
PRINT N'Creating [dbo].[tblWorkContent].[IDX_tblWorkContent_fkContentID]...';
GO
PRINT N'Creating [dbo].[tblWorkContent].[IDX_tblWorkContent_ChangedByName]...';
GO
PRINT N'Creating [dbo].[tblWorkContent].[IDX_tblWorkContent_StatusFields]...';
GO
PRINT N'Creating [dbo].[tblWorkContent].[IDX_tblWorkContent_ArchiveContentGUID]...';
GO
PRINT N'Creating [dbo].[tblWorkContent].[IDX_tblWorkContent_ContentLinkGUID]...';
GO
PRINT N'Creating [dbo].[tblWorkContent].[IDX_tblWorkContent_fkMasterVersionID]...';
GO
PRINT N'Creating [dbo].[tblWorkContentCategory]...';
GO
PRINT N'Creating [dbo].[tblWorkContentCategory].[IDX_tblWorkContentCategory_fkWorkContentID]...';
GO
PRINT N'Creating [dbo].[tblTree]...';
GO
PRINT N'Creating [dbo].[tblTree].[IDX_tblTree_fkChildID]...';
GO
PRINT N'Creating [dbo].[tblTask]...';
GO
PRINT N'Creating [dbo].[tblScheduledItemLog]...';
GO
PRINT N'Creating [dbo].[tblScheduledItem]...';
GO
PRINT N'Creating [dbo].[tblRemoteSite]...';
GO
PRINT N'Creating [dbo].[tblPropertyDefinitionDefault]...';
GO
PRINT N'Creating [dbo].[tblContentProperty]...';
GO
PRINT N'Creating [dbo].[tblContentProperty].[IDX_tblContentProperty_fkContentID]...';
GO
PRINT N'Creating [dbo].[tblContentProperty].[IDX_tblContentProperty_fkPropertyDefinitionID]...';
GO
PRINT N'Creating [dbo].[tblContentProperty].[IDX_tblContentProperty_ScopeName]...';
GO
PRINT N'Creating [dbo].[tblContentProperty].[IDX_tblContentProperty_ContentLink]...';
GO
PRINT N'Creating [dbo].[tblContentProperty].[IDX_tblContentProperty_ContentTypeID]...';
GO
PRINT N'Creating [dbo].[tblContentProperty].[IX_tblContentProperty_guid]...';
GO
PRINT N'Creating [dbo].[tblPlugIn]...';
GO
PRINT N'Creating [dbo].[tblUserPermission]...';
GO
PRINT N'Creating [dbo].[tblUserPermission].[IX_tblUserPermission_Permission_GroupName]...';
GO
PRINT N'Creating [dbo].[tblContentTypeToContentType]...';
GO
PRINT N'Creating [dbo].[tblContentTypeDefault]...';
GO
PRINT N'Creating [dbo].[tblContentType]...';
GO
PRINT N'Creating [dbo].[tblContentType].[IDX_tblContentType_ContentTypeGUID]...';
GO
PRINT N'Creating [dbo].[tblContentType].[IDX_tblContentType_Name]...';
GO
PRINT N'Creating [dbo].[tblContentSoftlink]...';
GO
PRINT N'Creating [dbo].[tblContentSoftlink].[IDX_tblContentSoftlink_fkContentID]...';
GO
PRINT N'Creating [dbo].[tblContentSoftlink].[IDX_tblContentSoftlink_fkReferencedContentGUID]...';
GO
PRINT N'Creating [dbo].[tblPropertyDefinitionType]...';
GO
PRINT N'Creating [dbo].[tblPropertyDefinitionGroup]...';
GO
PRINT N'Creating [dbo].[tblPropertyDefinition]...';
GO
PRINT N'Creating [dbo].[tblPropertyDefinition].[IDX_tblPropertyDefinition_ContentTypeAndName]...';
GO
PRINT N'Creating [dbo].[tblPropertyDefinition].[IDX_tblPropertyDefinition_fkContentTypeID]...';
GO
PRINT N'Creating [dbo].[tblPropertyDefinition].[IDX_tblPropertyDefinition_Name]...';
GO
PRINT N'Creating [dbo].[tblPropertyDefinition].[IDX_tblPropertyDefinition_fkPropertyDefinitionTypeID]...';
GO
PRINT N'Creating [dbo].[tblContent]...';
GO
PRINT N'Creating [dbo].[tblContent].[IDX_tblContent_fkParentID]...';
GO
PRINT N'Creating [dbo].[tblContent].[IDX_tblContent_ContentGUID]...';
GO
PRINT N'Creating [dbo].[tblContent].[IDX_tblContent_ContentType]...';
GO
PRINT N'Creating [dbo].[tblContent].[IDX_tblContent_ArchiveContentGUID]...';
GO
PRINT N'Creating [dbo].[tblContent].[IDX_tblContent_ContentPath]...';
GO
PRINT N'Creating [dbo].[tblContent].[IDX_tblContent_fkContentTypeID]...';
GO
PRINT N'Creating [dbo].[tblFrame]...';
GO
PRINT N'Creating [dbo].[tblContentCategory]...';
GO
PRINT N'Creating [dbo].[tblContentCategory].[IDX_tblContentCategory_fkContentID]...';
GO
PRINT N'Creating [dbo].[tblContentCategory].[IDX_tblContentCategory_fkCategoryID]...';
GO
PRINT N'Creating [dbo].[tblCategory]...';
GO
PRINT N'Creating [dbo].[tblContentAccess]...';
GO
PRINT N'Creating unnamed constraint on [dbo].[tblNotificationSubscription]...';
GO
PRINT N'Creating [dbo].[[tblIndexRequestLog_Row]...';
GO
PRINT N'Creating unnamed constraint on [dbo].[tblHostDefinition]...';
GO
PRINT N'Creating [dbo].[tblTaskInformation_Row]...';
GO
PRINT N'Creating [dbo].[DF_tblMappedIdentity_ContentGuid]...';
GO
PRINT N'Creating [dbo].[tblVisitorGroupStatistic_Row]...';
GO
PRINT N'Creating [dbo].[tblSystemBigTable_Row]...';
GO
PRINT N'Creating unnamed constraint on [dbo].[tblBigTableStoreConfig]...';
GO
PRINT N'Creating [dbo].[tblBigTableReference_Index]...';
GO
PRINT N'Creating [dbo].[DF_tblBigTableIdentity_Guid]...';
GO
PRINT N'Creating [dbo].[DF_tblBigTable_Row]...';
GO
PRINT N'Creating [dbo].[DF_tblXFormData_Row]...';
GO
PRINT N'Creating [dbo].[DF_tblActivityLog_Action]...';
GO
PRINT N'Creating unnamed constraint on [dbo].[tblActivityLog]...';
GO
PRINT N'Creating unnamed constraint on [dbo].[tblSynchedUserRole]...';
GO
PRINT N'Creating [dbo].[DF__tblUniqueSequence__LastValue]...';
GO
PRINT N'Creating [dbo].[DF__tblLanguageBranch__Enabled]...';
GO
PRINT N'Creating [dbo].[DF__tblConten__Activ__51300E55]...';
GO
PRINT N'Creating [dbo].[DF__tblContentLanguage__ContentGUID]...';
GO
PRINT N'Creating [dbo].[DF__tblContentLanguage__Automatic]...';
GO
PRINT N'Creating [dbo].[DF__tblContentLanguage__FetchData]...';
GO
PRINT N'Creating unnamed constraint on [dbo].[tblContentLanguage]...';
GO
PRINT N'Creating [dbo].[DF__tblWorkContentProperty_guid]...';
GO
PRINT N'Creating [dbo].[DF__tblWorkPr__Boole__55209ACA]...';
GO
PRINT N'Creating [dbo].[DF__tblWorkPa__LinkT__48BAC3E5]...';
GO
PRINT N'Creating [dbo].[DF__tblWorkPa__Child__4B973090]...';
GO
PRINT N'Creating [dbo].[DF__tblWorkPa__PeerO__4C8B54C9]...';
GO
PRINT N'Creating [dbo].[DF__tblWorkPa__Chang__4E739D3B]...';
GO
PRINT N'Creating [dbo].[DF__tblWorkPa__fkLan__4258C320]...';
GO
PRINT N'Creating [dbo].[DF_tblWorkContent_CommonDraft]...';
GO
PRINT N'Creating unnamed constraint on [dbo].[tblWorkContent]...';
GO
PRINT N'Creating [dbo].[DF_tblWorkContentCategory_CategoryType]...';
GO
PRINT N'Creating [dbo].[DF_tblTask_Status]...';
GO
PRINT N'Creating [dbo].[DF__tblSchedul__pkID__1A34DF26]...';
GO
PRINT N'Creating [dbo].[DF_tblScheduledItem_Enabled]...';
GO
PRINT N'Creating [dbo].[DF__tblScheduledItem__IsRunnning]...';
GO
PRINT N'Creating [dbo].[DF_tblRemoteSite_IsTrusted]...';
GO
PRINT N'Creating [dbo].[DF_tblRemoteSite_AllowUrlLookup]...';
GO
PRINT N'Creating [dbo].[DF_tblPropertyDefault_Boolean]...';
GO
PRINT N'Creating [dbo].[DF__tblProper__fkLan__29B609E9]...';
GO
PRINT N'Creating [dbo].[DF__tblPropert__guid__43F60EC8]...';
GO
PRINT N'Creating [dbo].[DF__tblProper__Boole__44EA3301]...';
GO
PRINT N'Creating [dbo].[DF_tblPlugIn_Enabled]...';
GO
PRINT N'Creating [dbo].[DF_tblUserPermission_IsRole]...';
GO
PRINT N'Creating [dbo].[DF_tblContentTypeToContentType_Access]...';
GO
PRINT N'Creating [dbo].[DF_tblContentTypeToContentType_Availability]...';
GO
PRINT N'Creating [dbo].[DF_tblContentTypeDefault_VisibleInMenu]...';
GO
PRINT N'Creating [dbo].[DF_tblContentTypeDefault_ChildOrderRule]...';
GO
PRINT N'Creating [dbo].[DF_tblContentTypeDefault_PeerOrder]...';
GO
PRINT N'Creating [dbo].[DF_tblContentType_ContentTypeGUID]...';
GO
PRINT N'Creating [dbo].[DF_tblContentType_MetaDataInherit]...';
GO
PRINT N'Creating [dbo].[DF_tblContentType_MetaDataDefault]...';
GO
PRINT N'Creating [dbo].[DF_tblContentType_ContentType]...';
GO
PRINT N'Creating [dbo].[DF_tblPropertyDefinitionGroup_SystemGroup]...';
GO
PRINT N'Creating [dbo].[DF_tblPropertyDefinitionGroup_Access]...';
GO
PRINT N'Creating [dbo].[DF_tblPropertyDefinitionGroup_DefaultVisible]...';
GO
PRINT N'Creating [dbo].[DF_tblPropertyDefinitionGroup_GroupOrder]...';
GO
PRINT N'Creating [dbo].[DF_tblPropertyDefinition_DefaultValueType]...';
GO
PRINT N'Creating [dbo].[DF_tblPropertyDefinition_LongStringSettings]...';
GO
PRINT N'Creating [dbo].[DF_tblPropertyDefinition_CommonLang]...';
GO
PRINT N'Creating [dbo].[DF_tblPropertyDefinition_ExistsOnModel]...';
GO
PRINT N'Creating [dbo].[DF__tblContent__ContentGUID]...';
GO
PRINT N'Creating [dbo].[DF__tblContent__Visible__2E06CDA9]...';
GO
PRINT N'Creating [dbo].[DF__tblContent__Deleted__2EFAF1E2]...';
GO
PRINT N'Creating [dbo].[DF__tblContent__ChildOr__35A7EF71]...';
GO
PRINT N'Creating [dbo].[DF__tblContent__PeerOrd__369C13AA]...';
GO
PRINT N'Creating [dbo].[DF__tblContent__fkMasterLangaugeBranchID]...';
GO
PRINT N'Creating [dbo].[DF_tblContent_ContentType]...';
GO
PRINT N'Creating [dbo].[DF_tblContent_IsLeafNode]...';
GO
PRINT N'Creating [dbo].[DF_tblFrame_SystemFrame]...';
GO
PRINT N'Creating [dbo].[DF_tblContentCategory_CategoryType]...';
GO
PRINT N'Creating [dbo].[DF_tblContentCategory_LanguageBranchID]...';
GO
PRINT N'Creating [dbo].[DF_tblCategory_CategoryGUID]...';
GO
PRINT N'Creating [dbo].[DF_tblCategory_PeerOrder]...';
GO
PRINT N'Creating [dbo].[DF_tblCategory_Available]...';
GO
PRINT N'Creating [dbo].[DF_tblCategory_Selectable]...';
GO
PRINT N'Creating [dbo].[DF_tblCategory_SuperCategory]...';
GO
PRINT N'Creating [dbo].[DF_tblAccess_IsRole]...';
GO
PRINT N'Creating [dbo].[FK_tblIndexRequestLog_tblBigTableIdentity]...';
GO
PRINT N'Creating [dbo].[FK_tblHostDefinition_tblSiteDefinition]...';
GO
PRINT N'Creating [dbo].[FK_tblActivityLogComment_tblActivityLog]...';
GO
PRINT N'Creating [dbo].[FK_tblActivityLogAssociation_tblActivityLog]...';
GO
PRINT N'Creating [dbo].[FK_tblTaskInformation_tblBigTableIdentity]...';
GO
PRINT N'Creating [dbo].[FK_tblProjectMember_tblProject]...';
GO
PRINT N'Creating [dbo].[FK_tblProjectItem_tblProject]...';
GO
PRINT N'Creating [dbo].[FK_tblVisitorGroupStatistic_tblBigTableIdentity]...';
GO
PRINT N'Creating [dbo].[FK_tblSystemBigTable_tblBigTableIdentity]...';
GO
PRINT N'Creating [dbo].[FK_ChangeNotification_ChangeNotificationString_ChangeNotificationConnection]...';
GO
PRINT N'Creating [dbo].[FK_ChangeNotification_ChangeNotificationString_ChangeNotificationProcessor]...';
GO
PRINT N'Creating [dbo].[FK_ChangeNotification_ChangeNotificationInt_ChangeNotificationConnection]...';
GO
PRINT N'Creating [dbo].[FK_ChangeNotification_ChangeNotificationInt_ChangeNotificationProcessor]...';
GO
PRINT N'Creating [dbo].[FK_ChangeNotification_ChangeNotificationGuid_ChangeNotificationConnection]...';
GO
PRINT N'Creating [dbo].[FK_ChangeNotification_ChangeNotificationGuid_ChangeNotificationProcessor]...';
GO
PRINT N'Creating [dbo].[FK_ChangeNotificationConnection_ChangeNotificationProcessor]...';
GO
PRINT N'Creating [dbo].[FK_tblBigTableStoreInfo_tblBigTableStoreConfig]...';
GO
PRINT N'Creating [dbo].[FK_tblBigTableReference_tblBigTableIdentity]...';
GO
PRINT N'Creating [dbo].[FK_tblBigTableReference_RefId_tblBigTableIdentity]...';
GO
PRINT N'Creating [dbo].[FK_tblBigTable_tblBigTableIdentity]...';
GO
PRINT N'Creating [dbo].[FK_tblXFormData_tblBigTableIdentity]...';
GO
PRINT N'Creating [dbo].[FK_tblSynchedUserRelations_Group]...';
GO
PRINT N'Creating [dbo].[FK_tblSyncheduserRelations_User]...';
GO
PRINT N'Creating [dbo].[FK_tblContentLanguageSetting_tblContent]...';
GO
PRINT N'Creating [dbo].[FK_tblContentLanguageSetting_tblLanguageBranch1]...';
GO
PRINT N'Creating [dbo].[FK_tblContentLanguageSetting_tblLanguageBranch2]...';
GO
PRINT N'Creating [dbo].[FK_tblContentLanguage_tblWorkContent]...';
GO
PRINT N'Creating [dbo].[FK_tblContentLanguage_tblFrame]...';
GO
PRINT N'Creating [dbo].[FK_tblContentLanguage_tblContent2]...';
GO
PRINT N'Creating [dbo].[FK_tblContentLanguage_tblLanguageBranch]...';
GO
PRINT N'Creating [dbo].[FK_tblWorkContentProperty_tblContent]...';
GO
PRINT N'Creating [dbo].[FK_tblWorkContentProperty_tblPropertyDefinition]...';
GO
PRINT N'Creating [dbo].[FK_tblWorkContentProperty_tblContentType]...';
GO
PRINT N'Creating [dbo].[FK_tblWorkContentProperty_tblWorkContent]...';
GO
PRINT N'Creating [dbo].[FK_tblWorkContent_tblFrame]...';
GO
PRINT N'Creating [dbo].[FK_tblWorkContent_tblContent]...';
GO
PRINT N'Creating [dbo].[FK_tblWorkContent_tblWorkContent2]...';
GO
PRINT N'Creating [dbo].[FK_tblWorkContent_tblLanguageBranch]...';
GO
PRINT N'Creating [dbo].[FK_tblWorkContentCategory_tblCategory]...';
GO
PRINT N'Creating [dbo].[FK_tblWorkContentCategory_tblWorkContent]...';
GO
PRINT N'Creating [dbo].[FK_tblTask_tblPlugIn]...';
GO
PRINT N'Creating [dbo].[fk_tblScheduledItemLog_tblScheduledItem]...';
GO
PRINT N'Creating [dbo].[FK_tblContentProperty_tblContent]...';
GO
PRINT N'Creating [dbo].[FK_tblContentProperty_tblContent2]...';
GO
PRINT N'Creating [dbo].[FK_tblContentProperty_tblPropertyDefinition]...';
GO
PRINT N'Creating [dbo].[FK_tblContentProperty_tblLanguageBranch]...';
GO
PRINT N'Creating [dbo].[FK_tblContentTypeToContentType_tblContentType]...';
GO
PRINT N'Creating [dbo].[FK_tblContentTypeToContentType_tblContentType1]...';
GO
PRINT N'Creating [dbo].[FK_tblContentTypeDefault_tblContentType]...';
GO
PRINT N'Creating [dbo].[FK_tblContentSoftlink_tblContent]...';
GO
PRINT N'Creating [dbo].[FK_tblPropertyDefinition_tblContentType]...';
GO
PRINT N'Creating [dbo].[FK_tblContent_tblContent]...';
GO
PRINT N'Creating [dbo].[FK_tblContent_tblContentType]...';
GO
PRINT N'Creating [dbo].[FK_tblContent_tblLanguageBranch]...';
GO
PRINT N'Creating [dbo].[FK_tblContentCategory_tblCategory]...';
GO
PRINT N'Creating [dbo].[FK_tblContentCategory_tblContent]...';
GO
PRINT N'Creating [dbo].[FK_tblCategory_tblCategory]...';
GO
PRINT N'Creating [dbo].[FK_tblContentAccess_tblContent]...';
GO
PRINT N'Creating [dbo].[CH_tblIndexRequestLog]...';
GO
PRINT N'Creating [dbo].[CH_tblTaskInformation]...';
GO
PRINT N'Creating [dbo].[CH_tblVisitorGroupStatistic]...';
GO
PRINT N'Creating [dbo].[CH_tblSystemBigTable]...';
GO
PRINT N'Creating [dbo].[CK_ChangeNotificationProcessor_ChangeNotificationDataType]...';
GO
PRINT N'Creating [dbo].[CK_ChangeNotificationProcessor_ProcessorStatus]...';
GO
PRINT N'Creating [dbo].[CH_tblBigTableReference_Index]...';
GO
PRINT N'Creating [dbo].[CH_tblBigTable]...';
GO
PRINT N'Creating [dbo].[CH_tblXFormData]...';
GO
PRINT N'Creating [dbo].[CK_tblScheduledItem]...';
GO
PRINT N'Creating [dbo].[BigTableDateTimeSubtract]...';
GO
PRINT N'Creating [dbo].[netDateTimeSubtract]...';
GO
PRINT N'Creating [dbo].[ConvertScopeName]...';
GO
PRINT N'Creating [dbo].[GetScopedBlockProperties]...';
GO
PRINT N'Creating [dbo].[GetExistingScopesForDefinition]...';
GO
PRINT N'Creating [dbo].[tblWorkProperty]...';
GO
PRINT N'Creating [dbo].[tblPropertyDefault]...';
GO
PRINT N'Creating [dbo].[tblWorkCategory]...';
GO
PRINT N'Creating [dbo].[tblProperty]...';
GO
PRINT N'Creating [dbo].[tblPageLanguageSetting]...';
GO
PRINT N'Creating [dbo].[tblPageLanguage]...';
GO
PRINT N'Creating [dbo].[tblWorkPage]...';
GO
PRINT N'Creating [dbo].[tblPageTypeToPageType]...';
GO
PRINT N'Creating [dbo].[tblPageTypeDefault]...';
GO
PRINT N'Creating [dbo].[tblPageType]...';
GO
PRINT N'Creating [dbo].[tblPageDefinitionType]...';
GO
PRINT N'Creating [dbo].[tblPageDefinitionGroup]...';
GO
PRINT N'Creating [dbo].[tblPageDefinition]...';
GO
PRINT N'Creating [dbo].[tblPage]...';
GO
PRINT N'Creating [dbo].[tblCategoryPage]...';
GO
PRINT N'Creating [dbo].[netActivityLogCommentListMany]...';
GO
PRINT N'Creating [dbo].[netPlugInLoadByType]...';
GO
PRINT N'Creating [dbo].[netNotificationSubscriptionClearUser]...';
GO
PRINT N'Creating [dbo].[netNotificationSubscriptionClearSubscription]...';
GO
PRINT N'Creating [dbo].[netNotificationSubscriptionListSubscriptions]...';
GO
PRINT N'Creating [dbo].[netNotificationSubscriptionFindSubscribers]...';
GO
PRINT N'Creating [dbo].[netNotificationSubscriptionUnsubscribe]...';
GO
PRINT N'Creating [dbo].[netNotificationSubscriptionSubscribe]...';
GO
PRINT N'Creating [dbo].[DateTimeConversion_Finalize]...';
GO
PRINT N'Creating [dbo].[DateTimeConversion_RunBlocks]...';
GO
PRINT N'Creating [dbo].[DateTimeConversion_InitDateTimeOffsets]...';
GO
PRINT N'Creating [dbo].[DateTimeConversion_MakeTableBlocks]...';
GO
PRINT N'Creating [dbo].[DateTimeConversion_GetFieldNames]...';
GO
PRINT N'Creating [dbo].[sp_GetDateTimeKind]...';
GO
PRINT N'Creating [dbo].[netActivityLogAssociatedList]...';
GO
PRINT N'Creating [dbo].[netActivityLogAssociatedAnyList]...';
GO
PRINT N'Creating [dbo].[netActivityLogAssociatedAllList]...';
GO
PRINT N'Creating [dbo].[netNotificationMessageGet]...';
GO
PRINT N'Creating [dbo].[netNotificationMessagesTruncate]...';
GO
PRINT N'Creating [dbo].[netNotificationMessageGetForRecipients]...';
GO
PRINT N'Creating [dbo].[netNotificationMessageGetRecipients]...';
GO
PRINT N'Creating [dbo].[netNotificationMessagesRead]...';
GO
PRINT N'Creating [dbo].[netSynchedUserGetMetadata]...';
GO
PRINT N'Creating [dbo].[netNotificationMessagesDelete]...';
GO
PRINT N'Creating [dbo].[netNotificationMessagesSent]...';
GO
PRINT N'Creating [dbo].[netNotificationMessageInsert]...';
GO
PRINT N'Creating [dbo].[netNotificationMessageList]...';
GO
PRINT N'Creating [dbo].[netSynchedUserRoleUpdate]...';
GO
PRINT N'Creating [dbo].[netSynchedUserInsertOrUpdate]...';
GO
PRINT N'Creating [dbo].[netSiteDefinitionSave]...';
GO
PRINT N'Creating [dbo].[netSiteDefinitionDelete]...';
GO
PRINT N'Creating [dbo].[netSiteDefinitionList]...';
GO
PRINT N'Creating [dbo].[netMappedIdentityDeleteItems]...';
GO
PRINT N'Creating [dbo].[netActivityLogCommentLoad]...';
GO
PRINT N'Creating [dbo].[netActivityLogAssociatedGetLowest]...';
GO
PRINT N'Creating [dbo].[netActivityLogGetAssociations]...';
GO
PRINT N'Creating [dbo].[netActivityLogAssociationDeleteRelated]...';
GO
PRINT N'Creating [dbo].[netActivityLogTruncate]...';
GO
PRINT N'Creating [dbo].[netActivityLogCommentList]...';
GO
PRINT N'Creating [dbo].[netActivityLogCommentSave]...';
GO
PRINT N'Creating [dbo].[netActivityLogCommentDelete]...';
GO
PRINT N'Creating [dbo].[netActivityLogAssociationDelete]...';
GO
PRINT N'Creating [dbo].[netActivityLogEntryDelete]...';
GO
PRINT N'Creating [dbo].[netActivityLogEntryLoad]...';
GO
PRINT N'Creating [dbo].[netActivityLogAssociationSave]...';
GO
PRINT N'Creating [dbo].[netMappedIdentityMapContent]...';
GO
PRINT N'Creating [dbo].[netMappedIdentityListProviders]...';
GO
PRINT N'Creating [dbo].[netMappedIdentityDelete]...';
GO
PRINT N'Creating [dbo].[netMappedIdentityGetByGuid]...';
GO
PRINT N'Creating [dbo].[netMappedIdentityGetById]...';
GO
PRINT N'Creating [dbo].[netMappedIdentityForProvider]...';
GO
PRINT N'Creating [dbo].[netMappedIdentityGetOrCreate]...';
GO
PRINT N'Creating [dbo].[netSynchedUserRolesListStatuses]...';
GO
PRINT N'Creating [dbo].[netSynchedUserRoleEnableDisable]...';
GO
PRINT N'Creating [dbo].[netProjectItemGetSingle]...';
GO
PRINT N'Creating [dbo].[netProjectItemGetByReferences]...';
GO
PRINT N'Creating [dbo].[netProjectItemGet]...';
GO
PRINT N'Creating [dbo].[netProjectItemDelete]...';
GO
PRINT N'Creating [dbo].[netProjectItemSave]...';
GO
PRINT N'Creating [dbo].[netProjectList]...';
GO
PRINT N'Creating [dbo].[netProjectDelete]...';
GO
PRINT N'Creating [dbo].[netProjectGet]...';
GO
PRINT N'Creating [dbo].[netProjectSave]...';
GO
PRINT N'Creating [dbo].[netContentListVersionsPaged]...';
GO
PRINT N'Creating [dbo].[editSetVersionStatus]...';
GO
PRINT N'Creating [dbo].[sp_FxDatabaseVersion]...';
GO
PRINT N'Creating [dbo].[EntityTypeGetNameByID]...';
GO
PRINT N'Creating [dbo].[EntityTypeGetIDByName]...';
GO
PRINT N'Creating [dbo].[EntitySetEntry]...';
GO
PRINT N'Creating [dbo].[EntityGetIdByGuidFromIdentity]...';
GO
PRINT N'Creating [dbo].[EntityGetIDByGuid]...';
GO
PRINT N'Creating [dbo].[EntityGetGuidByIdFromIdentity]...';
GO
PRINT N'Creating [dbo].[EntityGetGuidByID]...';
GO
PRINT N'Creating [dbo].[ChangeNotificationSetInvalidWorker]...';
GO
PRINT N'Creating [dbo].[ChangeNotificationSetInvalid]...';
GO
PRINT N'Creating [dbo].[ChangeNotificationOpenConnection]...';
GO
PRINT N'Creating [dbo].[ChangeNotificationEnqueueString]...';
GO
PRINT N'Creating [dbo].[ChangeNotificationEnqueueInt]...';
GO
PRINT N'Creating [dbo].[ChangeNotificationEnqueueGuid]...';
GO
PRINT N'Creating [dbo].[ChangeNotificationCloseConnection]...';
GO
PRINT N'Creating [dbo].[ChangeNotificationAccessConnectionWorker]...';
GO
PRINT N'Creating [dbo].[BigTableSaveReference]...';
GO
PRINT N'Creating [dbo].[BigTableDeleteItemInternal]...';
GO
PRINT N'Creating [dbo].[BigTableDeleteItem]...';
GO
PRINT N'Creating [dbo].[BigTableDeleteExcessReferences]...';
GO
PRINT N'Creating [dbo].[BigTableDeleteAll]...';
GO
PRINT N'Creating [dbo].[sp_DatabaseVersion]...';
GO
PRINT N'Creating [dbo].[netSynchedUserMatchRoleList]...';
GO
PRINT N'Creating [dbo].[netSynchedRolesList]...';
GO
PRINT N'Creating [dbo].[netSynchedRoleInsert]...';
GO
PRINT N'Creating [dbo].[netSynchedRoleDelete]...';
GO
PRINT N'Creating [dbo].[netSynchedUserList]...';
GO
PRINT N'Creating [dbo].[netSynchedUserRoleList]...';
GO
PRINT N'Creating [dbo].[netURLSegmentSet]...';
GO
PRINT N'Creating [dbo].[netURLSegmentListPages]...';
GO
PRINT N'Creating [dbo].[netUnmappedPropertyList]...';
GO
PRINT N'Creating [dbo].[netUniqueSequenceNext]...';
GO
PRINT N'Creating [dbo].[netTaskWorkflowList]...';
GO
PRINT N'Creating [dbo].[netTaskSaveActivity]...';
GO
PRINT N'Creating [dbo].[netTaskSave]...';
GO
PRINT N'Creating [dbo].[netTaskLoad]...';
GO
PRINT N'Creating [dbo].[netTaskList]...';
GO
PRINT N'Creating [dbo].[netTaskDelete]...';
GO
PRINT N'Creating [dbo].[netTabListDependencies]...';
GO
PRINT N'Creating [dbo].[netTabInfoUpdate]...';
GO
PRINT N'Creating [dbo].[netTabInfoList]...';
GO
PRINT N'Creating [dbo].[netTabInfoInsert]...';
GO
PRINT N'Creating [dbo].[netTabInfoDelete]...';
GO
PRINT N'Creating [dbo].[netSubscriptionListRoots]...';
GO
PRINT N'Creating [dbo].[netSoftLinksUpdateStatus]...';
GO
PRINT N'Creating [dbo].[netSoftLinksGetUnchecked]...';
GO
PRINT N'Creating [dbo].[netSoftLinksGetBrokenCount]...';
GO
PRINT N'Creating [dbo].[netSoftLinksGetBroken]...';
GO
PRINT N'Creating [dbo].[netSoftLinkByUrl]...';
GO
PRINT N'Creating [dbo].[netSoftLinkList]...';
GO
PRINT N'Creating [dbo].[netSoftLinkInsert]...';
GO
PRINT N'Creating [dbo].[netSoftLinkDelete]...';
GO
PRINT N'Creating [dbo].[netSoftLinkByPageLink]...';
GO
PRINT N'Creating [dbo].[netSoftLinkByExternalLink]...';
GO
PRINT N'Creating [dbo].[netSiteConfigSet]...';
GO
PRINT N'Creating [dbo].[netSiteConfigGet]...';
GO
PRINT N'Creating [dbo].[netSiteConfigDelete]...';
GO
PRINT N'Creating [dbo].[netSchedulerSetRunningState]...';
GO
PRINT N'Creating [dbo].[netSchedulerSetCurrentStatus]...';
GO
PRINT N'Creating [dbo].[netSchedulerSave]...';
GO
PRINT N'Creating [dbo].[netSchedulerReport]...';
GO
PRINT N'Creating [dbo].[netSchedulerRemove]...';
GO
PRINT N'Creating [dbo].[netSchedulerLoadJob]...';
GO
PRINT N'Creating [dbo].[netSchedulerListLog]...';
GO
PRINT N'Creating [dbo].[netSchedulerList]...';
GO
PRINT N'Creating [dbo].[netSchedulerGetNext]...';
GO
PRINT N'Creating [dbo].[netSchedulerExecute]...';
GO
PRINT N'Creating [dbo].[netSchedulerAdd]...';
GO
PRINT N'Creating [dbo].[netReportSimpleAddresses]...';
GO
PRINT N'Creating [dbo].[netReportReadyToPublish]...';
GO
PRINT N'Creating [dbo].[netReportPublishedPages]...';
GO
PRINT N'Creating [dbo].[netReportExpiredPages]...';
GO
PRINT N'Creating [dbo].[netReportChangedPages]...';
GO
PRINT N'Creating [dbo].[netRemoteSiteSave]...';
GO
PRINT N'Creating [dbo].[netRemoteSiteLoad]...';
GO
PRINT N'Creating [dbo].[netRemoteSiteList]...';
GO
PRINT N'Creating [dbo].[netRemoteSiteDelete]...';
GO
PRINT N'Creating [dbo].[netReadyToPublishList]...';
GO
PRINT N'Creating [dbo].[netQuickSearchByPath]...';
GO
PRINT N'Creating [dbo].[netQuickSearchByExternalUrl]...';
GO
PRINT N'Creating [dbo].[netPropertySearchNull]...';
GO
PRINT N'Creating [dbo].[netPropertySearchValueMeta]...';
GO
PRINT N'Creating [dbo].[netPropertySearchValue]...';
GO
PRINT N'Creating [dbo].[netPropertySearchStringMeta]...';
GO
PRINT N'Creating [dbo].[netPropertySearchString]...';
GO
PRINT N'Creating [dbo].[netPropertySearch]...';
GO
PRINT N'Creating [dbo].[netPropertySave]...';
GO
PRINT N'Creating [dbo].[netPropertyDefinitionTypeSave]...';
GO
PRINT N'Creating [dbo].[netPropertyDefinitionGetUsage]...';
GO
PRINT N'Creating [dbo].[netPropertyDefinitionDelete]...';
GO
PRINT N'Creating [dbo].[netPropertyDefinitionCheckUsage]...';
GO
PRINT N'Creating [dbo].[netPlugInSynchronize]...';
GO
PRINT N'Creating [dbo].[netPlugInSaveSettings]...';
GO
PRINT N'Creating [dbo].[netPlugInSave]...';
GO
PRINT N'Creating [dbo].[netPlugInLoad]...';
GO
PRINT N'Creating [dbo].[netPersonalRejectedList]...';
GO
PRINT N'Creating [dbo].[netPersonalNotReadyList]...';
GO
PRINT N'Creating [dbo].[netPersonalActivityList]...';
GO
PRINT N'Creating [dbo].[netPermissionSave]...';
GO
PRINT N'Creating [dbo].[netPermissionRoles]...';
GO
PRINT N'Creating [dbo].[netPermissionDeleteMembership]...';
GO
PRINT N'Creating [dbo].[netPageTypeGetUsage]...';
GO
PRINT N'Creating [dbo].[netPageTypeCheckUsage]...';
GO
PRINT N'Creating [dbo].[netPagesChangedAfter]...';
GO
PRINT N'Creating [dbo].[netPagePath]...';
GO
PRINT N'Creating [dbo].[netContentListPaged]...';
GO
PRINT N'Creating [dbo].[netPageListByLanguage]...';
GO
PRINT N'Creating [dbo].[netPageListAll]...';
GO
PRINT N'Creating [dbo].[netPageLanguageSettingUpdate]...';
GO
PRINT N'Creating [dbo].[netPageLanguageSettingListTree]...';
GO
PRINT N'Creating [dbo].[netPageLanguageSettingList]...';
GO
PRINT N'Creating [dbo].[netPageLanguageSettingDelete]...';
GO
PRINT N'Creating [dbo].[netPageDynamicBlockDelete]...';
GO
PRINT N'Creating [dbo].[netPageDynamicBlockList]...';
GO
PRINT N'Creating [dbo].[netPageDeleteLanguage]...';
GO
PRINT N'Creating [dbo].[netPageDefinitionWithContentType]...';
GO
PRINT N'Creating [dbo].[netPageDefinitionTypeList]...';
GO
PRINT N'Creating [dbo].[netPageDefinitionTypeDelete]...';
GO
PRINT N'Creating [dbo].[netPageDefinitionSave]...';
GO
PRINT N'Creating [dbo].[netPageDefinitionList]...';
GO
PRINT N'Creating [dbo].[netPageDefinitionGet]...';
GO
PRINT N'Creating [dbo].[netPageDefinitionDynamicCheck]...';
GO
PRINT N'Creating [dbo].[netPageDefinitionDefault]...';
GO
PRINT N'Creating [dbo].[netPageDefinitionConvertSave]...';
GO
PRINT N'Creating [dbo].[netPageDefinitionConvertList]...';
GO
PRINT N'Creating [dbo].[netContentDataLoad]...';
GO
PRINT N'Creating [dbo].[netPageCountDescendants]...';
GO
PRINT N'Creating [dbo].[netPageChangeMasterLanguage]...';
GO
PRINT N'Creating [dbo].[netContentListBlobUri]...';
GO
PRINT N'Creating [dbo].[netLanguageBranchUpdate]...';
GO
PRINT N'Creating [dbo].[netLanguageBranchList]...';
GO
PRINT N'Creating [dbo].[netLanguageBranchInsert]...';
GO
PRINT N'Creating [dbo].[netLanguageBranchDelete]...';
GO
PRINT N'Creating [dbo].[netFrameUpdate]...';
GO
PRINT N'Creating [dbo].[netFrameList]...';
GO
PRINT N'Creating [dbo].[netFrameInsert]...';
GO
PRINT N'Creating [dbo].[netFrameDelete]...';
GO
PRINT N'Creating [dbo].[netFindContentCoreDataByID]...';
GO
PRINT N'Creating [dbo].[netFindContentCoreDataByContentGuid]...';
GO
PRINT N'Creating [dbo].[netDynamicPropertyLookup]...';
GO
PRINT N'Creating [dbo].[netDynamicPropertiesLoad]...';
GO
PRINT N'Creating [dbo].[netDelayPublishList]...';
GO
PRINT N'Creating [dbo].[netCreatePath]...';
GO
PRINT N'Creating [dbo].[netConvertPropertyForPageType]...';
GO
PRINT N'Creating [dbo].[netConvertPageType]...';
GO
PRINT N'Creating [dbo].[netContentTypeToContentTypeList]...';
GO
PRINT N'Creating [dbo].[netContentTypeSave]...';
GO
PRINT N'Creating [dbo].[netContentTypeList]...';
GO
PRINT N'Creating [dbo].[netContentTypeDeleteAvailable]...';
GO
PRINT N'Creating [dbo].[netContentTypeDelete]...';
GO
PRINT N'Creating [dbo].[netContentTypeAddAvailable]...';
GO
PRINT N'Creating [dbo].[netContentRootList]...';
GO
PRINT N'Creating [dbo].[netContentMove]...';
GO
PRINT N'Creating [dbo].[netContentMatchSegment]...';
GO
PRINT N'Creating [dbo].[netContentLoadLongString]...';
GO
PRINT N'Creating [dbo].[netContentListOwnedAssetFolders]...';
GO
PRINT N'Creating [dbo].[netContentCreateLanguage]...';
GO
PRINT N'Creating [dbo].[netContentCreate]...';
GO
PRINT N'Creating [dbo].[netContentChildrenReferences]...';
GO
PRINT N'Creating [dbo].[netContentAclSetInherited]...';
GO
PRINT N'Creating [dbo].[netContentAclList]...';
GO
PRINT N'Creating [dbo].[netContentAclDeleteEntity]...';
GO
PRINT N'Creating [dbo].[netContentAclDelete]...';
GO
PRINT N'Creating [dbo].[netContentAclChildDelete]...';
GO
PRINT N'Creating [dbo].[netContentAclChildAdd]...';
GO
PRINT N'Creating [dbo].[netContentAclAdd]...';
GO
PRINT N'Creating [dbo].[netChangeLogTruncBySeqNDate]...';
GO
PRINT N'Creating [dbo].[netChangeLogTruncByRowsNDate]...';
GO
PRINT N'Creating [dbo].[netActivityLogEntrySave]...';
GO
PRINT N'Creating [dbo].[netChangeLogGetRowsForwards]...';
GO
PRINT N'Creating [dbo].[netChangeLogGetRowsBackwards]...';
GO
PRINT N'Creating [dbo].[netChangeLogGetHighestSeqNum]...';
GO
PRINT N'Creating [dbo].[netChangeLogGetCountBackwards]...';
GO
PRINT N'Creating [dbo].[netChangeLogGetCount]...';
GO
PRINT N'Creating [dbo].[netCategoryStringToTable]...';
GO
PRINT N'Creating [dbo].[netCategorySave]...';
GO
PRINT N'Creating [dbo].[netCategoryListAll]...';
GO
PRINT N'Creating [dbo].[netCategoryDelete]...';
GO
PRINT N'Creating [dbo].[netCategoryContentLoad]...';
GO
PRINT N'Creating [dbo].[netBlockTypeGetUsage]...';
GO
PRINT N'Creating [dbo].[netBlockTypeCheckUsage]...';
GO
PRINT N'Creating [dbo].[editSetCommonDraftVersion]...';
GO
PRINT N'Creating [dbo].[editSavePropertyCategory]...';
GO
PRINT N'Creating [dbo].[editSaveContentVersionData]...';
GO
PRINT N'Creating [dbo].[editDeleteProperty]...';
GO
PRINT N'Creating [dbo].[editDeletePageCheck]...';
GO
PRINT N'Creating [dbo].[editDeletePage]...';
GO
PRINT N'Creating [dbo].[editDeleteChildsCheck]...';
GO
PRINT N'Creating [dbo].[editDeleteChilds]...';
GO
PRINT N'Creating [dbo].[editCreateContentVersion]...';
GO
PRINT N'Creating [dbo].[admDatabaseStatistics]...';
GO
PRINT N'Creating [dbo].[editDeletePageVersionInternal]...';
GO
PRINT N'Creating [dbo].[editDeletePageInternal]...';
GO
PRINT N'Creating [dbo].[editDeletePageCheckInternal]...';
GO
PRINT N'Creating [dbo].[DateTimeConversion_InitBlocks]...';
GO
PRINT N'Creating [dbo].[DateTimeConversion_InitFieldNames]...';
GO
PRINT N'Creating [dbo].[ChangeNotificationTrySetValid]...';
GO
PRINT N'Creating [dbo].[ChangeNotificationTrySetRecovering]...';
GO
PRINT N'Creating [dbo].[ChangeNotificationHeartBeat]...';
GO
PRINT N'Creating [dbo].[ChangeNotificationGetStatus]...';
GO
PRINT N'Creating [dbo].[ChangeNotificationDequeueString]...';
GO
PRINT N'Creating [dbo].[ChangeNotificationDequeueInt]...';
GO
PRINT N'Creating [dbo].[ChangeNotificationDequeueGuid]...';
GO
PRINT N'Creating [dbo].[ChangeNotificationCompleteBatchString]...';
GO
PRINT N'Creating [dbo].[ChangeNotificationCompleteBatchInt]...';
GO
PRINT N'Creating [dbo].[ChangeNotificationCompleteBatchGuid]...';
GO
PRINT N'Creating [dbo].[netPropertySearchCategoryMeta]...';
GO
PRINT N'Creating [dbo].[netPropertySearchCategory]...';
GO
PRINT N'Creating [dbo].[netContentLoadVersion]...';
GO
PRINT N'Creating [dbo].[netContentEnsureVersions]...';
GO
PRINT N'Creating [dbo].[editContentVersionList]...';
GO
PRINT N'Creating [dbo].[editDeletePageVersion]...';
GO
PRINT N'Creating [dbo].[netContentTrimVersions]...';
GO
PRINT N'Creating [dbo].[editPublishContentVersion]...';
GO
PRINT N'Update complete.';
GO
SET IDENTITY_INSERT tblLanguageBranch ON
GO
INSERT INTO tblLanguageBranch([pkID], [LanguageID], [Name], [SortIndex], [SystemIconPath], [URLSegment], [Enabled])
VALUES(1, 'en ', NULL, 10, '~/app_themes/default/images/flags/en.gif', NULL, 1)
GO
INSERT INTO tblLanguageBranch([pkID], [LanguageID], [Name], [SortIndex], [SystemIconPath], [URLSegment], [Enabled])
VALUES(2, 'en-GB ', NULL, 20, '~/app_themes/default/images/flags/en-gb.gif', NULL, 0)
GO
INSERT INTO tblLanguageBranch([pkID], [LanguageID], [Name], [SortIndex], [SystemIconPath], [URLSegment], [Enabled])
VALUES(3, 'en-NZ ', NULL, 30, '~/app_themes/Default/Images/flags/en-NZ.gif', NULL, 0)
GO
INSERT INTO tblLanguageBranch([pkID], [LanguageID], [Name], [SortIndex], [SystemIconPath], [URLSegment], [Enabled])
VALUES(4, 'en-ZA ', NULL, 40, '~/app_themes/default/images/flags/en-za.gif', NULL, 0)
GO
INSERT INTO tblLanguageBranch([pkID], [LanguageID], [Name], [SortIndex], [SystemIconPath], [URLSegment], [Enabled])
VALUES(5, 'de ', NULL, 50, '~/app_themes/Default/Images/flags/de.gif', NULL, 0)
GO
INSERT INTO tblLanguageBranch([pkID], [LanguageID], [Name], [SortIndex], [SystemIconPath], [URLSegment], [Enabled])
VALUES(6, 'fr ', NULL, 60, '~/app_themes/default/images/flags/fr.gif', NULL, 0)
GO
INSERT INTO tblLanguageBranch([pkID], [LanguageID], [Name], [SortIndex], [SystemIconPath], [URLSegment], [Enabled])
VALUES(7, 'es ', NULL, 70, '~/app_themes/default/images/flags/es.gif', NULL, 0)
GO
INSERT INTO tblLanguageBranch([pkID], [LanguageID], [Name], [SortIndex], [SystemIconPath], [URLSegment], [Enabled])
VALUES(8, 'sv ', NULL, 80, '~/app_themes/default/images/flags/sv.gif', NULL, 1)
GO
INSERT INTO tblLanguageBranch([pkID], [LanguageID], [Name], [SortIndex], [SystemIconPath], [URLSegment], [Enabled])
VALUES(9, 'no ', NULL, 90, '~/app_themes/default/images/flags/no.gif', NULL, 0)
GO
INSERT INTO tblLanguageBranch([pkID], [LanguageID], [Name], [SortIndex], [SystemIconPath], [URLSegment], [Enabled])
VALUES(10, 'da ', NULL, 100, '~/app_themes/default/images/flags/da.gif', NULL, 0)
GO
INSERT INTO tblLanguageBranch([pkID], [LanguageID], [Name], [SortIndex], [SystemIconPath], [URLSegment], [Enabled])
VALUES(11, 'fi ', NULL, 110, '~/app_themes/default/images/flags/fi.gif', NULL, 0)
GO
INSERT INTO tblLanguageBranch([pkID], [LanguageID], [Name], [SortIndex], [SystemIconPath], [URLSegment], [Enabled])
VALUES(12, 'nl ', NULL, 120, '~/app_themes/default/images/flags/nl.gif', NULL, 0)
GO
INSERT INTO tblLanguageBranch([pkID], [LanguageID], [Name], [SortIndex], [SystemIconPath], [URLSegment], [Enabled])
VALUES(13, 'nl-BE ', NULL, 130, '~/app_themes/default/images/flags/nl-be.gif', NULL, 0)
GO
INSERT INTO tblLanguageBranch([pkID], [LanguageID], [Name], [SortIndex], [SystemIconPath], [URLSegment], [Enabled])
VALUES(14, 'pt-BR ', NULL, 140, '~/app_themes/default/images/flags/pt-br.gif', NULL, 0)
GO
INSERT INTO tblLanguageBranch([pkID], [LanguageID], [Name], [SortIndex], [SystemIconPath], [URLSegment], [Enabled])
VALUES(15, '', NULL, 150, '', NULL, 0)
GO
SET IDENTITY_INSERT tblLanguageBranch OFF
GO
/************************************************************************/
SET IDENTITY_INSERT tblCategory ON
GO
INSERT INTO tblCategory (pkID,fkParentID,CategoryGUID,SortOrder,Available,Selectable,SuperCategory,CategoryName,CategoryDescription) VALUES (
1,
NULL,
'{885BD5B6-9F33-4615-8E85-6390072E824C}',
1,
0,
0,
0,
'Root',
'Starting point')
GO
SET IDENTITY_INSERT tblCategory OFF
GO
/************************************************************************/
SET IDENTITY_INSERT tblFrame ON
GO
INSERT INTO tblFrame (pkID,FrameName,FrameDescription,SystemFrame) VALUES (
1,
'target="_blank"',
'Open the link in a new window',
1)
GO
INSERT INTO tblFrame (pkID,FrameName,FrameDescription,SystemFrame) VALUES (
2,
'target="_top"',
'Open the link in the whole window',
1)
GO
SET IDENTITY_INSERT tblFrame OFF
GO
/************************************************************************/
SET IDENTITY_INSERT tblPropertyDefinitionGroup ON
GO
INSERT INTO tblPropertyDefinitionGroup (pkID,SystemGroup,Access,GroupVisible,GroupOrder,Name) VALUES (
0,
1,
1,
1,
10,
'Information')
GO
INSERT INTO tblPropertyDefinitionGroup (pkID,SystemGroup,Access,GroupVisible,GroupOrder,Name) VALUES (
1,
1,
4,
0,
30,
'Advanced')
GO
INSERT INTO tblPropertyDefinitionGroup (pkID,SystemGroup,Access,GroupVisible,GroupOrder,Name) VALUES (
2,
1,
1,
0,
50,
'Categories')
GO
INSERT INTO tblPropertyDefinitionGroup (pkID,SystemGroup,Access,GroupVisible,GroupOrder,Name) VALUES (
3,
1,
1,
0,
40,
'Shortcut')
GO
INSERT INTO tblPropertyDefinitionGroup (pkID,SystemGroup,Access,GroupVisible,GroupOrder,Name) VALUES (
4,
1,
1,
0,
20,
'Scheduling')
GO
INSERT INTO tblPropertyDefinitionGroup (pkID,SystemGroup,Access,GroupVisible,GroupOrder,Name) VALUES (
5,
1,
1,
0,
60,
'DynamicBlocks')
GO
SET IDENTITY_INSERT tblPropertyDefinitionGroup OFF
GO
/************************************************************************/
INSERT INTO tblPropertyDefinitionType (pkID,Property,Name,TypeName,AssemblyName) VALUES (
0,
0,
'Boolean',
NULL,
NULL)
GO
INSERT INTO tblPropertyDefinitionType (pkID,Property,Name,TypeName,AssemblyName) VALUES (
1,
1,
'Number',
NULL,
NULL)
GO
INSERT INTO tblPropertyDefinitionType (pkID,Property,Name,TypeName,AssemblyName) VALUES (
2,
2,
'FloatNumber',
NULL,
NULL)
GO
INSERT INTO tblPropertyDefinitionType (pkID,Property,Name,TypeName,AssemblyName) VALUES (
3,
3,
'PageType',
NULL,
NULL)
GO
INSERT INTO tblPropertyDefinitionType (pkID,Property,Name,TypeName,AssemblyName) VALUES (
4,
4,
'PageReference',
NULL,
NULL)
GO
INSERT INTO tblPropertyDefinitionType (pkID,Property,Name,TypeName,AssemblyName) VALUES (
5,
5,
'Date',
NULL,
NULL)
GO
INSERT INTO tblPropertyDefinitionType (pkID,Property,Name,TypeName,AssemblyName) VALUES (
6,
6,
'String',
NULL,
NULL)
GO
INSERT INTO tblPropertyDefinitionType (pkID,Property,Name,TypeName,AssemblyName) VALUES (
7,
7,
'LongString',
NULL,
NULL)
GO
INSERT INTO tblPropertyDefinitionType (pkID,Property,Name,TypeName,AssemblyName) VALUES (
8,
8,
'Category',
NULL,
NULL)
GO
INSERT INTO tblPropertyDefinitionType (pkID,Property,Name,TypeName,AssemblyName) VALUES (
11,
11,
'ContentReference',
NULL,
NULL)
GO
/************************************************************************/
SET IDENTITY_INSERT tblContentType ON
GO
INSERT INTO tblContentType (pkID,ContentTypeGUID,Created,Name,Description,IdString,Available,SortOrder,MetaDataInherit,MetaDataDefault,WorkflowEditFields) VALUES (
1,
'{3FA7D9E7-877B-11D3-827C-00A024CACFCB}',
'19990101 00:00',
'SysRoot',
'Used as root/welcome page',
'?id=',
0,
10000,
0,
0,
0)
GO
INSERT INTO tblContentType (pkID,ContentTypeGUID,Created,Name,Description,IdString,Available,SortOrder,MetaDataInherit,MetaDataDefault,WorkflowEditFields) VALUES (
2,
'{4EEA90CD-4210-4115-A399-6D6915554E10}',
'19990101 00:00',
'SysRecycleBin',
'Used as recycle bin for the website',
'?id=',
0,
10010,
0,
0,
0)
GO
INSERT INTO tblContentType (pkID,ContentTypeGUID,Created,ModelType,Name,Description,IdString,Available,SortOrder,MetaDataInherit,MetaDataDefault,WorkflowEditFields,ContentType) VALUES (
3,
'{52F8D1E9-6D87-4DB6-A465-41890289FB78}',
'19990101 00:00',
'EPiServer.Core.ContentFolder,EPiServer',
'SysContentFolder',
'Used as content folder',
'?id=',
0,
10020,
0,
0,
0,
2)
GO
INSERT INTO tblContentType (pkID,ContentTypeGUID,Created,ModelType,Name,Description,IdString,Available,SortOrder,MetaDataInherit,MetaDataDefault,WorkflowEditFields,ContentType) VALUES (
4,
'{E9AB78A3-1BBF-48ef-A8D4-1C1F98E80D91}',
'19990101 00:00',
'EPiServer.Core.ContentAssetFolder,EPiServer',
'SysContentAssetFolder',
'Used as a folder for content assets',
'?id=',
0,
10030,
0,
0,
0,
2)
GO
SET IDENTITY_INSERT tblContentType OFF
GO
/************************************************************************
Dependent data
************************************************************************/
SET IDENTITY_INSERT tblContent ON
GO
--SysRoot
INSERT INTO tblContent (pkID,fkContentTypeID,fkParentID,ArchiveContentGUID,CreatorName,ContentGUID,VisibleInMenu,Deleted,ChildOrderRule,PeerOrder, fkMasterLanguageBranchID,ContentPath, IsLeafNode) VALUES (
1,--pkID
1,--fkContentTypeID
NULL,--fkParentID
NULL,--ArchiveContentGUID
'',--CreatorName
'{43F936C9-9B23-4EA3-97B2-61C538AD07C9}',--ContentGUID
1,--VisibleInMenu
0,--Deleted
4,--ChildOrderRule
100,--PeerOrder
1,--fkMasterLanguageBranchID
'.',--ContentPath
0)--IsLeafNode
GO
--SysWastebasket
INSERT INTO tblContent (pkID,fkContentTypeID,fkParentID,ArchiveContentGUID,CreatorName,ContentGUID,VisibleInMenu,Deleted,ChildOrderRule,PeerOrder,fkMasterLanguageBranchID,ContentPath) VALUES (
2,--pkID
2,--fkContentTypeID
1,--fkParentID
NULL,--ArchiveContentGUID
'',--CreatorName
'{2F40BA47-F4FC-47AE-A244-0B909D4CF988}',--ContentGUID
1,--VisibleInMenu
0,--Deleted
1,--ChildOrderRule
10,--PeerOrder
1,--fkMasterLanguageBranchID
'.1.')--ContentPath
GO
--SysGlobalAssets
INSERT INTO tblContent (pkID,fkContentTypeID,fkParentID,ArchiveContentGUID,CreatorName,ContentGUID,VisibleInMenu,Deleted,ChildOrderRule,PeerOrder,fkMasterLanguageBranchID,ContentPath,ContentType) VALUES (
3,--pkID
3,--fkContentTypeID
1,--fkParentID
NULL,--ArchiveContentGUID
'',--CreatorName
'{E56F85D0-E833-4E02-976A-2D11FE4D598C}',--ContentGUID
1,--VisibleInMenu
0,--Deleted
3,--ChildOrderRule
100,--PeerOrder
15,--fkMasterLanguageBranchID
'.1.',--ContentPath
2)--ContentType
GO
--SysContentAssets
INSERT INTO tblContent (pkID,fkContentTypeID,fkParentID,ArchiveContentGUID,CreatorName,ContentGUID,VisibleInMenu,Deleted,ChildOrderRule,PeerOrder,fkMasterLanguageBranchID,ContentPath,ContentType) VALUES (
4,--pkID
3,--fkContentTypeID
1,--fkParentID
NULL,--ArchiveContentGUID
'',--CreatorName
'{99D57529-61F2-47C0-80C0-F91ECA6AF1AC}',--ContentGUID
1,--VisibleInMenu
0,--Deleted
3,--ChildOrderRule
100,--PeerOrder
15,--fkMasterLanguageBranchID
'.1.',--ContentPath
2)--ContentType
GO
SET IDENTITY_INSERT tblContent OFF
GO
/************************************************************************/
INSERT INTO tblUserPermission (Name, IsRole, GroupName, Permission) VALUES ('Administrators',1,'EPiServerCMS', 'DetailedErrorMessage') /* DetailedErrorMessage */
GO
/************************************************************************/
INSERT INTO tblContentAccess (fkContentID,Name,IsRole,AccessMask) VALUES (1,'Everyone',1,1)
GO
INSERT INTO tblContentAccess (fkContentID,Name,IsRole,AccessMask) VALUES (2,'Everyone',1,1)
GO
INSERT INTO tblContentAccess (fkContentID,Name,IsRole,AccessMask) VALUES (1,'Administrators',1,63)
GO
INSERT INTO tblContentAccess (fkContentID,Name,IsRole,AccessMask) VALUES (2,'Administrators',1,63)
GO
/************************************************************************/
INSERT INTO tblTree (fkParentID,fkChildID,NestingLevel) VALUES (1,2,1)
GO
INSERT INTO tblTree (fkParentID,fkChildID,NestingLevel) VALUES (1,3,1)
GO
INSERT INTO tblTree (fkParentID,fkChildID,NestingLevel) VALUES (1,4,1)
GO
--Root
DECLARE @fkPageId1 INT
INSERT INTO tblWorkContent (fkContentID ,fkMasterVersionID, ContentLinkGUID, fkFrameID, ArchiveContentGUID, ChangedByName, NewStatusByName, Name, URLSegment,LinkURL ,ExternalURL ,VisibleInMenu ,LinkType ,Created ,Saved ,StartPublish ,StopPublish ,ChildOrderRule ,PeerOrder ,ChangedOnPublish ,RejectComment ,fkLanguageBranchID, Status) VALUES (
1, --fkContentID
null, --,fkMasterVersionID
null, --,ContentLinkGUID
null,--,fkFrameID
null,--,ArchiveContentGUID
'', --,ChangedByName
null, --,NewStatusByName
'Root',--Name
null, --,URLSegment
'~/link/43F936C99B234EA397B261C538AD07C9.aspx',--LinkURL
null, --,ExternalURL
1, --,VisibleInMenu
0, --,LinkType
'19990101 00:00', --,Created
'19990101 00:00', --,Saved
'19990101 00:00', --,StartPublish
null, --,StopPublish
4, --,ChildOrderRule
100, --,PeerOrder
0, --,ChangedOnPublish
null,--,RejectComment
1,--,fkLanguageBranchID
4 --status
)
SET @fkPageId1=@@IDENTITY
--RecycleBin
DECLARE @fkPageId2 INT
INSERT INTO tblWorkContent (fkContentID ,fkMasterVersionID, ContentLinkGUID, fkFrameID, ArchiveContentGUID, ChangedByName, NewStatusByName, Name, URLSegment,LinkURL ,ExternalURL ,VisibleInMenu ,LinkType ,Created ,Saved ,StartPublish ,StopPublish ,ChildOrderRule ,PeerOrder ,ChangedOnPublish ,RejectComment ,fkLanguageBranchID, Status) VALUES (
2, --fkContentID
null, --,fkMasterVersionID
null, --,ContentLinkGUID
null,--,fkFrameID
null,--,ArchiveContentGUID
'', --,ChangedByName
null, --,NewStatusByName
'Recycle Bin',--Name
null, --,URLSegment
'~/link/2F40BA47F4FC47AEA2440B909D4CF988.aspx',--LinkURL
null, --,ExternalURL
1, --,VisibleInMenu
0, --,LinkType
'19990101 00:00', --,Created
'19990101 00:00', --,Saved
'19990101 00:00', --,StartPublish
null, --,StopPublish
1, --,ChildOrderRule
10, --,PeerOrder
0, --,ChangedOnPublish
null,--,RejectComment
1,--,fkLanguageBranchID
4 --Status
)
SET @fkPageId2=@@IDENTITY
DECLARE @fkPageId3 INT
INSERT INTO tblWorkContent (fkContentID ,fkMasterVersionID, ContentLinkGUID, fkFrameID, ArchiveContentGUID, ChangedByName, NewStatusByName, Name, URLSegment,LinkURL ,ExternalURL ,VisibleInMenu ,LinkType ,Created ,Saved ,StartPublish ,StopPublish ,ChildOrderRule ,PeerOrder ,ChangedOnPublish ,RejectComment ,fkLanguageBranchID, Status) VALUES (
3, --fkContentID
null, --,fkMasterVersionID
null, --,ContentLinkGUID
null,--,fkFrameID
null,--,ArchiveContentGUID
'', --,ChangedByName
null, --,NewStatusByName
'SysGlobalAssets',--Name
'SysGlobalAssets', --,URLSegment
null,--LinkURL
null, --,ExternalURL
1, --,VisibleInMenu
0, --,LinkType
'19990101 00:00', --,Created
'19990101 00:00', --,Saved
'19990101 00:00', --,StartPublish
null, --,StopPublish
3, --,ChildOrderRule
100, --,PeerOrder
0, --,ChangedOnPublish
null,--,RejectComment
15,--,fkLanguageBranchID
4 -- Status
)
SET @fkPageId3=@@IDENTITY
DECLARE @fkPageId4 INT
INSERT INTO tblWorkContent (fkContentID ,fkMasterVersionID, ContentLinkGUID, fkFrameID, ArchiveContentGUID, ChangedByName, NewStatusByName, Name, URLSegment,LinkURL ,ExternalURL ,VisibleInMenu ,LinkType ,Created ,Saved ,StartPublish ,StopPublish ,ChildOrderRule ,PeerOrder ,ChangedOnPublish ,RejectComment ,fkLanguageBranchID, Status) VALUES (
4, --fkContentID
null, --,fkMasterVersionID
null, --,ContentLinkGUID
null,--,fkFrameID
null,--,ArchiveContentGUID
'', --,ChangedByName
null, --,NewStatusByName
'SysContentAssets',--Name
'SysContentAssets', --,URLSegment
null,--LinkURL
null, --,ExternalURL
1, --,VisibleInMenu
0, --,LinkType
'19990101 00:00', --,Created
'19990101 00:00', --,Saved
'19990101 00:00', --,StartPublish
null, --,StopPublish
3, --,ChildOrderRule
100, --,PeerOrder
0, --,ChangedOnPublish
null,--,RejectComment
15,--,fkLanguageBranchID
4 --Status
)
SET @fkPageId4=@@IDENTITY
INSERT INTO tblContentLanguage (fkContentID,fkLanguageBranchID,ContentLinkGUID,fkFrameID,CreatorName,ChangedByName,ContentGUID,Name,LinkURL,ExternalURL,AutomaticLink,FetchData,Created,Changed,Saved,StartPublish,StopPublish,[Version], Status) VALUES (
1,--fkContentID
1,--fkLanguageBranchID
NULL,--ContentLinkGUID
NULL,--fkFrameID
'',--CreatorName
'',--ChangedByName
'{43F936C9-9B23-4EA3-97B2-61C538AD07C9}',--ContentGUID
'Root',--Name
'~/link/43F936C99B234EA397B261C538AD07C9.aspx',--LinkURL
NULL,--ExternalURL
1,--AutomaticLink
0,--FetchData
'19990101 00:00',--Created
'19990101 00:00',--Changed
'19990101 00:00',--Saved
'19990101 00:00',--StartPublish
NULL,--StopPublish
@fkPageId1,--Version
4 --Status
)
INSERT INTO tblContentLanguage (fkContentID,fkLanguageBranchID,ContentLinkGUID,fkFrameID,CreatorName,ChangedByName,ContentGUID,Name,URLSegment,LinkURL,ExternalURL,AutomaticLink,FetchData,Created,Changed,Saved,StartPublish,StopPublish,[Version], Status) VALUES (
2,--fkContentID
1,--fkLanguageBranchID
NULL,--ContentLinkGUID
NULL,--fkFrameID
'',--CreatorName
'',--ChangedByName
'{2F40BA47-F4FC-47AE-A244-0B909D4CF988}',--ContentGUID
'Recycle Bin',--Name
'Recycle-Bin',--URLSegment
'~/link/2F40BA47F4FC47AEA2440B909D4CF988.aspx',--LinkURL
NULL,--ExternalURL
1,--AutomaticLink
0,--FetchData
'19990101 00:00',--Created
'19990101 00:00',--Changed
'19990101 00:00',--Saved
'19990101 00:00',--StartPublish
NULL,--StopPublish
@fkPageId2,--Version
4 --Status
)
INSERT INTO tblContentLanguage (fkContentID,fkLanguageBranchID,ContentLinkGUID,fkFrameID,CreatorName,ChangedByName,ContentGUID,Name,URLSegment,LinkURL,ExternalURL,AutomaticLink,FetchData,Created,Changed,Saved,StartPublish,StopPublish,[Version], Status) VALUES (
3,--fkContentID
15,--fkLanguageBranchID
NULL,--ContentLinkGUID
NULL,--fkFrameID
'',--CreatorName
'',--ChangedByName
'{E56F85D0-E833-4E02-976A-2D11FE4D598C}',--ContentGUID
'SysGlobalAssets',--Name
'SysGlobalAssets',--URLSegment
null,--LinkURL
NULL,--ExternalURL
1,--AutomaticLink
0,--FetchData
'19990101 00:00',--Created
'19990101 00:00',--Changed
'19990101 00:00',--Saved
'19990101 00:00',--StartPublish
NULL,--StopPublish
@fkPageId3,--Version
4 --Status
)
INSERT INTO tblContentLanguage (fkContentID,fkLanguageBranchID,ContentLinkGUID,fkFrameID,CreatorName,ChangedByName,ContentGUID,Name,URLSegment,LinkURL,ExternalURL,AutomaticLink,FetchData,Created,Changed,Saved,StartPublish,StopPublish,[Version], Status) VALUES (
4,--fkContentID
15,--fkLanguageBranchID
NULL,--ContentLinkGUID
NULL,--fkFrameID
'',--CreatorName
'',--ChangedByName
'{99D57529-61F2-47C0-80C0-F91ECA6AF1AC}',--ContentGUID
'SysContentAssets',--Name
'SysContentAssets',--URLSegment
null,--LinkURL
NULL,--ExternalURL
1,--AutomaticLink
0,--FetchData
'19990101 00:00',--Created
'19990101 00:00',--Changed
'19990101 00:00',--Saved
'19990101 00:00',--StartPublish
NULL,--StopPublish
@fkPageId4,--Version
4 --Status
)
GO
Sep 23, 2016 10:33
Guys,
Upgraded to Episerver CMS 9.12.2.0 and everything appears OK in the local but things get very strange in Azure. stuck with the below Exceptions. Pl suggest if this rings a bell
P.S - All Azure IP's are allowed to SQL Server & Connectionstrings looks good to me