AI OnAI Off

Episerver CMS 9.12.2.0 - Error After Update

Rajkumar Balakrishnan
Rajkumar Balakrishnan
Vote:
 

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

InvalidOperationException: Invalid attempt to read when no data is present.]
   System.Data.SqlClient.SqlDataReader.CheckDataIsReady(Int32 columnIndex, Boolean allowPartiallyReadColumn, Boolean permitAsync, String methodName) +1661221
   System.Data.SqlClient.SqlDataReader.TryReadColumn(Int32 i, Boolean setTimeout, Boolean allowPartiallyReadColumn) +48
   System.Data.SqlClient.SqlDataReader.GetValueInternal(Int32 i) +31
   System.Data.SqlClient.SqlDataReader.GetValue(Int32 i) +73
   System.Data.SqlClient.SqlDataReader.get_Item(String name) +28
   EPiServer.DataAccess.ContentListDB.b__11_0() +111
   EPiServer.Data.Providers.<>c__DisplayClass28_0`1.b__0() +59
   EPiServer.Data.Providers.SqlTransientErrorsRetryPolicy.Execute(Func`1 method) +45
   EPiServer.Data.Providers.SqlDatabaseHandler.Execute(Func`1 action) +202
   EPiServer.DataAccess.ContentListDB.LoadDefaultSystemRoots() +61
   EPiServer.DataAbstraction.DefaultContentRootRepository.EnsureSystemRoots() +126
   EPiServer.DataAbstraction.DefaultContentRootRepository.Load(String rootName) +22
   EPiServer.DataAbstraction.DefaultContentRootService.Get(String rootName) +13
   EPiServer.Web.SystemDefinition.get_Current() +150

[TargetInvocationException: Exception has been thrown by the target of an invocation.]
   System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) +0
   System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) +192
   System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +101
   EPiServer.ServiceLocation.<>c__DisplayClass0_0.b__0(IServiceLocator c) +23
   EPiServer.ServiceLocation.Internal.<>c__DisplayClass6_0.b__1(IServiceLocator s) +10
   lambda_method(Closure , IBuildSession , IContext ) +181

[StructureMapBuildException: Failure while building 'Lambda: Invoke(value(EPiServer.ServiceLocation.Internal.StructureMapConfiguredType+<>c__DisplayClass6_0).p, value(EPiServer.ServiceLocation.Internal.StructureMapConfiguredType)._serviceLocator)', check the inner exception for details
1.) Lambda: Invoke(value(EPiServer.ServiceLocation.Internal.StructureMapConfiguredType+<>c__DisplayClass6_0).p, value(EPiServer.ServiceLocation.Internal.StructureMapConfiguredType)._serviceLocator)
2.) Instance of EPiServer.Web.SystemDefinition (System.Object)
3.) new DependentContentTransfer(*Default of IContentLoader*, *Default of IContentTypeRepository*, *Default of IPermanentLinkMapper*, *Default of SiteDefinitionRepository*, *Default of SystemDefinition*)
4.) EPiServer.Core.Transfer.DependentContentTransfer
5.) Instance of EPiServer.Core.Transfer.IDependentContentTransfer (EPiServer.Core.Transfer.DependentContentTransfer)
6.) new PropertyContentReferenceListTransform(*Default of IPermanentLinkMapper*, *Default of IContentLoader*, *Default of IDependentContentTransfer*)
7.) EPiServer.Core.Transfer.PropertyContentReferenceListTransform
8.) Instance of EPiServer.Core.Transfer.PropertyContentReferenceListTransform
9.) Container.GetInstance(EPiServer.Core.Transfer.PropertyContentReferenceListTransform)
]
   lambda_method(Closure , IBuildSession , IContext ) +764
   StructureMap.Building.BuildPlan.Build(IBuildSession session, IContext context) in c:\BuildAgent\work\a395dbde6b793293\src\StructureMap\Building\BuildPlan.cs:151
   StructureMap.BuildSession.BuildNewInSession(Type pluginType, Instance instance) in c:\BuildAgent\work\a395dbde6b793293\src\StructureMap\BuildSession.cs:114
   StructureMap.Pipeline.NulloTransientCache.Get(Type pluginType, Instance instance, IBuildSession session) in c:\BuildAgent\work\a395dbde6b793293\src\StructureMap\Pipeline\NulloTransientCache.cs:28
   StructureMap.BuildSession.ResolveFromLifecycle(Type pluginType, Instance instance) in c:\BuildAgent\work\a395dbde6b793293\src\StructureMap\BuildSession.cs:103
   StructureMap.SessionCache.GetObject(Type pluginType, Instance instance, ILifecycle lifecycle) in c:\BuildAgent\work\a395dbde6b793293\src\StructureMap\SessionCache.cs:93
   StructureMap.SessionCache.GetDefault(Type pluginType, IPipelineGraph pipelineGraph) in c:\BuildAgent\work\a395dbde6b793293\src\StructureMap\SessionCache.cs:68
   StructureMap.Container.GetInstance(Type pluginType) in c:\BuildAgent\work\a395dbde6b793293\src\StructureMap\Container.cs:337
   EPiServer.ServiceLocation.StructureMapServiceLocator.DoGetInstance(Type serviceType, String key) +40
   EPiServer.ServiceLocation.ServiceLocatorImplBase.GetInstance(Type serviceType, String key) +42

[ActivationException: Activation error occurred while trying to get instance of type PropertyContentReferenceListTransform, key ""]
   EPiServer.ServiceLocation.ServiceLocatorImplBase.GetInstance(Type serviceType, String key) +101
   EPiServer.ServiceLocation.ServiceLocatorImplBase.GetInstance() +60
   EPiServer.Enterprise.EnterpriseInitialization.Initialize(InitializationEngine context) +113
   EPiServer.Framework.Initialization.Internal.<>c__DisplayClass3_0.b__0() +19
   EPiServer.Framework.Initialization.Internal.ModuleNode.Execute(Action a, String key) +52
   EPiServer.Framework.Initialization.Internal.ModuleNode.Initialize(InitializationEngine context) +80
   EPiServer.Framework.Initialization.InitializationEngine.InitializeModules() +245

[InitializationException: Initialize action failed for Initialize on class EPiServer.Enterprise.EnterpriseInitialization, EPiServer.Enterprise, Version=9.12.2.0, Culture=neutral, PublicKeyToken=8fe83dea738b45b7]
   EPiServer.Framework.Initialization.InitializationEngine.InitializeModules() +588
   EPiServer.Framework.Initialization.InitializationEngine.ExecuteTransition(Boolean continueTransitions) +114
   EPiServer.Framework.Initialization.InitializationEngine.Initialize() +32
   EPiServer.Framework.Initialization.<>c.b__7_0(InitializationEngine e) +9
   EPiServer.Framework.Initialization.InitializationModule.EngineExecute(HostType hostType, Action`1 engineAction) +365
   EPiServer.Framework.Initialization.InitializationModule.FrameworkInitialization(HostType hostType) +170
   EPiServer.Global..ctor() +76
   WebApplication.EPiServerApplication..ctor() +42
   ASP.global_asax..ctor() in c:\Users\rajkumarb\AppData\Local\Temp\Temporary ASP.NET Files\root\89cde6bf\d9f496d1\App_global.asax.0.cs:0

[TargetInvocationException: Exception has been thrown by the target of an invocation.]
   System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck) +0
   System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark) +113
   System.RuntimeType.CreateInstanceDefaultCtor(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark) +206
   System.Activator.CreateInstance(Type type, Boolean nonPublic) +83
   System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes, StackCrawlMark& stackMark) +1065
   System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes) +124
   System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture) +20
   System.Web.HttpRuntime.CreateNonPublicInstance(Type type, Object[] args) +60
   System.Web.HttpApplicationFactory.GetSpecialApplicationInstance(IntPtr appContext, HttpContext context) +263
   System.Web.Hosting.PipelineRuntime.InitializeApplication(IntPtr appContext) +296

[HttpException (0x80004005): Exception has been thrown by the target of an invocation.]
   System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +9946132
   System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +90
   System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) +261
#157809
Edited, Sep 22, 2016 14:48
Daniel Ovaska
Daniel Ovaska
Vote:
 

Maybe an database upgrade of the Epi db is missing on azure? Just guessing though mind you. I don't recognize that particular error.

#157817
Edited, Sep 22, 2016 17:09
Rajkumar Balakrishnan
Rajkumar Balakrishnan
Vote:
 
<p>Where do i find the latest DB Scripts ?</p>
#157818
Sep 22, 2016 17:11
valdis
valdis
Vote:
 

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..

#157843
Sep 22, 2016 23:43
Daniel Ovaska
Daniel Ovaska
Vote:
 

Usually complains about version of db yes so it's a long shot :)

#157845
Sep 23, 2016 7:40
Rajkumar Balakrishnan
Rajkumar Balakrishnan
Vote:
 

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

#157857
Sep 23, 2016 10:33
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.