Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • M N 125 posts 212 karma points
    Aug 15, 2018 @ 17:41
    M N
    0

    Upgrade from 7.11 to 7.12 Fails

    Hey all, anyone encountered the following screen? I have been upgrading a project all along the way since 7.4 or so with no issues.. This is the first time I have received a blocking failure on the upgrade process.

    enter image description here

  • M N 125 posts 212 karma points
    Aug 15, 2018 @ 18:05
    M N
    0

    Alright, well I was able to circumvent this by removing the constraint, but seems a little sketchy to me :)

    If anyone sees any cause for concern let me know. I assume this has something to do with the 8.0 Variant stuff but I'm not 100% sure, only read about it in passing.

    ALTER TABLE [umbracoLanguage] 
        DROP CONSTRAINT [IX_umbracoLanguage_languageISOCode]
    GO
    

    Did some basic regression testing and everything seems to be working fine, no mysterious errors in the log files.

  • M N 125 posts 212 karma points
    Aug 15, 2018 @ 18:39
    M N
    0

    Spoke too soon, looks like the audit trail is broken now, as well as some styles on the Nested Content display appear to be broken now. Rolling back to 7.11, but if anyone has seen these issues I would be most curious on how best to handle.

    Cheers.

    enter image description here

  • Sebastiaan Janssen 5060 posts 15522 karma points MVP admin hq
    Aug 15, 2018 @ 19:03
    Sebastiaan Janssen
    0

    The Nested Content bug is a known issue with a temporary workaround: https://our.umbraco.com/forum/using-umbraco-and-getting-started/93251-nested-content-broken-in-backoffice-css-in-712#comment-294940

    The audit trail looks like you don't have all the files copied in or didn't bump the ClientDependency.config.

    Would you be able to create a dump of your database schema before you upgraded? You seem to have some constraint there that (to the best of my knowledge) was not put in there by Umbraco.

    enter image description here

    You only need to generate the schema here.

    Do you know what the oldest version was that you've ever upgraded this install from?

  • M N 125 posts 212 karma points
    Aug 15, 2018 @ 20:50
    M N
    1

    Hi Sebastiaan,

    Thanks for the reply! Very good question, but if I were to guess I'd say maybe as far back as 7.0 or 7.1 .. We almost always clone our sites by first cloninig the database, then the repo. So it wouldn't surprise me if it went back this far as we started using Umbraco right around the time version 7 was released.

    Either way, here is the database schema of our current 7.11.. I think the only notable plugins here are SEO Checker and CMS Import.

    /****** Object:  Table [dbo].[cmsContent]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[cmsContent](
        [pk] [int] IDENTITY(52375,1) NOT NULL,
        [nodeId] [int] NOT NULL,
        [contentType] [int] NOT NULL,
     CONSTRAINT [PK_cmsContent] PRIMARY KEY CLUSTERED 
    (
        [pk] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
     CONSTRAINT [IX_cmsContent] UNIQUE NONCLUSTERED 
    (
        [nodeId] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[cmsContentType]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[cmsContentType](
        [pk] [int] IDENTITY(694,1) NOT NULL,
        [nodeId] [int] NOT NULL,
        [alias] [nvarchar](255) NULL,
        [icon] [nvarchar](255) NULL,
        [thumbnail] [nvarchar](255) NOT NULL,
        [description] [nvarchar](1500) NULL,
        [isContainer] [bit] NOT NULL,
        [allowAtRoot] [bit] NOT NULL,
     CONSTRAINT [PK_cmsContentType] PRIMARY KEY CLUSTERED 
    (
        [pk] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
     CONSTRAINT [IX_cmsContentType] UNIQUE NONCLUSTERED 
    (
        [nodeId] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[cmsContentType2ContentType]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[cmsContentType2ContentType](
        [parentContentTypeId] [int] NOT NULL,
        [childContentTypeId] [int] NOT NULL,
     CONSTRAINT [PK_cmsContentType2ContentType] PRIMARY KEY CLUSTERED 
    (
        [parentContentTypeId] ASC,
        [childContentTypeId] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[cmsContentTypeAllowedContentType]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[cmsContentTypeAllowedContentType](
        [Id] [int] NOT NULL,
        [AllowedId] [int] NOT NULL,
        [SortOrder] [int] NOT NULL,
     CONSTRAINT [PK_cmsContentTypeAllowedContentType] PRIMARY KEY CLUSTERED 
    (
        [Id] ASC,
        [AllowedId] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[cmsContentVersion]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[cmsContentVersion](
        [id] [int] IDENTITY(237178,1) NOT NULL,
        [ContentId] [int] NOT NULL,
        [VersionId] [uniqueidentifier] NOT NULL,
        [VersionDate] [datetime] NOT NULL,
     CONSTRAINT [PK_cmsContentVersion] PRIMARY KEY CLUSTERED 
    (
        [id] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
     CONSTRAINT [IX_cmsContentVersion_VersionId] UNIQUE NONCLUSTERED 
    (
        [VersionId] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[cmsContentXml]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[cmsContentXml](
        [nodeId] [int] NOT NULL,
        [xml] [ntext] NOT NULL,
     CONSTRAINT [PK_cmsContentXml] PRIMARY KEY CLUSTERED 
    (
        [nodeId] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[cmsDataType]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[cmsDataType](
        [pk] [int] IDENTITY(116,1) NOT NULL,
        [nodeId] [int] NOT NULL,
        [propertyEditorAlias] [nvarchar](255) NOT NULL,
        [dbType] [nvarchar](50) NOT NULL,
     CONSTRAINT [PK_cmsDataType] PRIMARY KEY CLUSTERED 
    (
        [pk] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
     CONSTRAINT [IX_cmsDataType_nodeId] UNIQUE NONCLUSTERED 
    (
        [nodeId] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[cmsDataTypePreValues]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[cmsDataTypePreValues](
        [id] [int] IDENTITY(723,1) NOT NULL,
        [datatypeNodeId] [int] NOT NULL,
        [value] [ntext] NULL,
        [sortorder] [int] NOT NULL,
        [alias] [nvarchar](50) NULL,
     CONSTRAINT [PK_cmsDataTypePreValues] PRIMARY KEY CLUSTERED 
    (
        [id] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[cmsDictionary]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[cmsDictionary](
        [pk] [int] IDENTITY(3,1) NOT NULL,
        [id] [uniqueidentifier] NOT NULL,
        [parent] [uniqueidentifier] NULL,
        [key] [nvarchar](1000) NOT NULL,
     CONSTRAINT [PK_cmsDictionary] PRIMARY KEY CLUSTERED 
    (
        [pk] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
     CONSTRAINT [IX_cmsDictionary_id] UNIQUE NONCLUSTERED 
    (
        [id] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[cmsDocument]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[cmsDocument](
        [nodeId] [int] NOT NULL,
        [published] [bit] NOT NULL,
        [documentUser] [int] NOT NULL,
        [versionId] [uniqueidentifier] NOT NULL,
        [text] [nvarchar](255) NOT NULL,
        [releaseDate] [datetime] NULL,
        [expireDate] [datetime] NULL,
        [updateDate] [datetime] NOT NULL,
        [templateId] [int] NULL,
        [newest] [bit] NOT NULL,
     CONSTRAINT [PK_cmsDocument] PRIMARY KEY CLUSTERED 
    (
        [versionId] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
     CONSTRAINT [IX_cmsDocument] UNIQUE NONCLUSTERED 
    (
        [nodeId] ASC,
        [versionId] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[cmsDocumentType]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[cmsDocumentType](
        [contentTypeNodeId] [int] NOT NULL,
        [templateNodeId] [int] NOT NULL,
        [IsDefault] [bit] NOT NULL,
     CONSTRAINT [PK_cmsDocumentType] PRIMARY KEY CLUSTERED 
    (
        [contentTypeNodeId] ASC,
        [templateNodeId] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[CMSImportMediaRelation]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[CMSImportMediaRelation](
        [Id] [int] IDENTITY(3,1) NOT NULL,
        [UmbracoMediaId] [int] NOT NULL,
        [SourceUrl] [nvarchar](500) NOT NULL,
        [ByteSize] [int] NULL,
     CONSTRAINT [PK_CMSImportMediaRelation] PRIMARY KEY CLUSTERED 
    (
        [Id] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[CMSImportRelation]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[CMSImportRelation](
        [Id] [int] IDENTITY(43910,1) NOT NULL,
        [UmbracoID] [int] NOT NULL,
        [DataSourceKey] [nvarchar](250) NOT NULL,
        [ImportProvider] [nvarchar](250) NULL,
        [Updated] [datetime] NULL,
        [CustomId] [nvarchar](255) NULL,
     CONSTRAINT [PK_CMSImportRelation] PRIMARY KEY CLUSTERED 
    (
        [Id] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[CMSImportScheduledItems]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[CMSImportScheduledItems](
        [ScheduledItemId] [int] IDENTITY(3,1) NOT NULL,
        [ScheduleldTaskId] [int] NOT NULL,
        [ScheduledOn] [datetime] NOT NULL,
        [ExecutedOn] [datetime] NULL,
        [InProgress] [bit] NULL,
     CONSTRAINT [PK_CMSImportScheduledItems] PRIMARY KEY CLUSTERED 
    (
        [ScheduledItemId] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[CMSImportScheduledTask]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[CMSImportScheduledTask](
        [ScheduleId] [int] IDENTITY(3,1) NOT NULL,
        [ScheduleGUID] [uniqueidentifier] NOT NULL,
        [ImportStateGUID] [uniqueidentifier] NOT NULL,
        [ScheduledTaskName] [nvarchar](50) NOT NULL,
        [NotifyEmailAddress] [nvarchar](250) NOT NULL,
        [ExecuteEvery] [nvarchar](50) NOT NULL,
        [ExecuteDays] [nvarchar](50) NOT NULL,
        [ExecuteHour] [int] NOT NULL,
        [ExecuteMinute] [int] NOT NULL,
        [ImportAsUser] [int] NULL,
     CONSTRAINT [PK_CMSImportScheduledTask] PRIMARY KEY CLUSTERED 
    (
        [ScheduleId] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[CMSImportState]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[CMSImportState](
        [Id] [int] IDENTITY(4,1) NOT NULL,
        [UniqueIdentifier] [uniqueidentifier] NOT NULL,
        [Name] [nvarchar](250) NOT NULL,
        [ImportState] [ntext] NOT NULL,
        [Parent] [uniqueidentifier] NULL,
        [ImportProvider] [nvarchar](250) NULL,
     CONSTRAINT [PK_CMSImportState] PRIMARY KEY CLUSTERED 
    (
        [Id] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[cmsLanguageText]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[cmsLanguageText](
        [pk] [int] IDENTITY(3,1) NOT NULL,
        [languageId] [int] NOT NULL,
        [UniqueId] [uniqueidentifier] NOT NULL,
        [value] [nvarchar](1000) NOT NULL,
     CONSTRAINT [PK_cmsLanguageText] PRIMARY KEY CLUSTERED 
    (
        [pk] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[cmsMacro]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[cmsMacro](
        [id] [int] IDENTITY(15,1) NOT NULL,
        [macroUseInEditor] [bit] NOT NULL,
        [macroRefreshRate] [int] NOT NULL,
        [macroAlias] [nvarchar](255) NOT NULL,
        [macroName] [nvarchar](255) NULL,
        [macroScriptType] [nvarchar](255) NULL,
        [macroScriptAssembly] [nvarchar](255) NULL,
        [macroXSLT] [nvarchar](255) NULL,
        [macroCacheByPage] [bit] NOT NULL,
        [macroCachePersonalized] [bit] NOT NULL,
        [macroDontRender] [bit] NOT NULL,
        [macroPython] [nvarchar](255) NULL,
        [uniqueId] [uniqueidentifier] NOT NULL,
     CONSTRAINT [PK_cmsMacro] PRIMARY KEY CLUSTERED 
    (
        [id] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
     CONSTRAINT [IX_cmsMacroPropertyAlias] UNIQUE NONCLUSTERED 
    (
        [macroAlias] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[cmsMacroProperty]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[cmsMacroProperty](
        [id] [int] IDENTITY(50,1) NOT NULL,
        [editorAlias] [nvarchar](255) NOT NULL,
        [macro] [int] NOT NULL,
        [macroPropertySortOrder] [int] NOT NULL,
        [macroPropertyAlias] [nvarchar](50) NOT NULL,
        [macroPropertyName] [nvarchar](255) NOT NULL,
        [uniquePropertyId] [uniqueidentifier] NOT NULL,
     CONSTRAINT [PK_cmsMacroProperty] PRIMARY KEY CLUSTERED 
    (
        [id] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
     CONSTRAINT [IX_cmsMacroProperty_Alias] UNIQUE NONCLUSTERED 
    (
        [macro] ASC,
        [macroPropertyAlias] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[cmsMedia]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[cmsMedia](
        [nodeId] [int] NOT NULL,
        [versionId] [uniqueidentifier] NOT NULL,
        [mediaPath] [nvarchar](255) NULL,
     CONSTRAINT [PK_cmsMedia] PRIMARY KEY CLUSTERED 
    (
        [versionId] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[cmsMember]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[cmsMember](
        [nodeId] [int] NOT NULL,
        [Email] [nvarchar](1000) NOT NULL,
        [LoginName] [nvarchar](1000) NOT NULL,
        [Password] [nvarchar](1000) NOT NULL,
     CONSTRAINT [PK_cmsMember] PRIMARY KEY CLUSTERED 
    (
        [nodeId] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[cmsMember2MemberGroup]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[cmsMember2MemberGroup](
        [Member] [int] NOT NULL,
        [MemberGroup] [int] NOT NULL,
     CONSTRAINT [PK_cmsMember2MemberGroup] PRIMARY KEY CLUSTERED 
    (
        [Member] ASC,
        [MemberGroup] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[cmsMemberType]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[cmsMemberType](
        [pk] [int] IDENTITY(13,1) NOT NULL,
        [NodeId] [int] NOT NULL,
        [propertytypeId] [int] NOT NULL,
        [memberCanEdit] [bit] NOT NULL,
        [viewOnProfile] [bit] NOT NULL,
        [isSensitive] [bit] NOT NULL,
     CONSTRAINT [PK_cmsMemberType] PRIMARY KEY CLUSTERED 
    (
        [pk] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[cmsPreviewXml]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[cmsPreviewXml](
        [nodeId] [int] NOT NULL,
        [versionId] [uniqueidentifier] NOT NULL,
        [timestamp] [datetime] NOT NULL,
        [xml] [ntext] NOT NULL,
     CONSTRAINT [PK_cmsContentPreviewXml] PRIMARY KEY CLUSTERED 
    (
        [nodeId] ASC,
        [versionId] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[cmsPropertyData]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[cmsPropertyData](
        [id] [int] IDENTITY(2814502,1) NOT NULL,
        [contentNodeId] [int] NOT NULL,
        [versionId] [uniqueidentifier] NULL,
        [propertytypeid] [int] NOT NULL,
        [dataInt] [int] NULL,
        [dataDate] [datetime] NULL,
        [dataNvarchar] [nvarchar](500) NULL,
        [dataNtext] [ntext] NULL,
        [dataDecimal] [numeric](20, 9) NULL,
     CONSTRAINT [PK_cmsPropertyData] PRIMARY KEY CLUSTERED 
    (
        [id] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
     CONSTRAINT [IX_cmsPropertyData_1] UNIQUE NONCLUSTERED 
    (
        [contentNodeId] ASC,
        [versionId] ASC,
        [propertytypeid] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[cmsPropertyType]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[cmsPropertyType](
        [id] [int] IDENTITY(914,1) NOT NULL,
        [dataTypeId] [int] NOT NULL,
        [contentTypeId] [int] NOT NULL,
        [propertyTypeGroupId] [int] NULL,
        [Alias] [nvarchar](255) NOT NULL,
        [Name] [nvarchar](255) NULL,
        [sortOrder] [int] NOT NULL,
        [mandatory] [bit] NOT NULL,
        [validationRegExp] [nvarchar](255) NULL,
        [Description] [nvarchar](2000) NULL,
        [uniqueID] [uniqueidentifier] NOT NULL,
     CONSTRAINT [PK_cmsPropertyType] PRIMARY KEY CLUSTERED 
    (
        [id] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
     CONSTRAINT [IX_cmsPropertyTypeUniqueID] UNIQUE NONCLUSTERED 
    (
        [uniqueID] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[cmsPropertyTypeGroup]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[cmsPropertyTypeGroup](
        [id] [int] IDENTITY(212,1) NOT NULL,
        [contenttypeNodeId] [int] NOT NULL,
        [text] [nvarchar](255) NOT NULL,
        [sortorder] [int] NOT NULL,
        [uniqueID] [uniqueidentifier] NOT NULL,
     CONSTRAINT [PK_cmsPropertyTypeGroup] PRIMARY KEY CLUSTERED 
    (
        [id] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
     CONSTRAINT [IX_cmsPropertyTypeGroupUniqueID] UNIQUE NONCLUSTERED 
    (
        [uniqueID] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[cmsTagRelationship]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[cmsTagRelationship](
        [nodeId] [int] NOT NULL,
        [tagId] [int] NOT NULL,
        [propertyTypeId] [int] NOT NULL,
     CONSTRAINT [PK_cmsTagRelationship] PRIMARY KEY CLUSTERED 
    (
        [nodeId] ASC,
        [propertyTypeId] ASC,
        [tagId] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[cmsTags]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[cmsTags](
        [id] [int] IDENTITY(22,1) NOT NULL,
        [tag] [nvarchar](200) NULL,
        [ParentId] [int] NULL,
        [group] [nvarchar](100) NULL,
     CONSTRAINT [PK_cmsTags] PRIMARY KEY CLUSTERED 
    (
        [id] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[cmsTask]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[cmsTask](
        [closed] [bit] NOT NULL,
        [id] [int] IDENTITY(3,1) NOT NULL,
        [taskTypeId] [int] NOT NULL,
        [nodeId] [int] NOT NULL,
        [parentUserId] [int] NOT NULL,
        [userId] [int] NOT NULL,
        [DateTime] [datetime] NOT NULL,
        [Comment] [nvarchar](500) NULL,
     CONSTRAINT [PK_cmsTask] PRIMARY KEY CLUSTERED 
    (
        [id] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[cmsTaskType]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[cmsTaskType](
        [id] [int] IDENTITY(3,1) NOT NULL,
        [alias] [nvarchar](255) NOT NULL,
     CONSTRAINT [PK_cmsTaskType] PRIMARY KEY CLUSTERED 
    (
        [id] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[cmsTemplate]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[cmsTemplate](
        [pk] [int] IDENTITY(1083,1) NOT NULL,
        [nodeId] [int] NOT NULL,
        [alias] [nvarchar](100) NULL,
        [design] [ntext] NOT NULL,
     CONSTRAINT [PK_cmsTemplate] PRIMARY KEY CLUSTERED 
    (
        [pk] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
     CONSTRAINT [IX_cmsTemplate_nodeId] UNIQUE NONCLUSTERED 
    (
        [nodeId] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[SEOChecker_ConfigurationIssues]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[SEOChecker_ConfigurationIssues](
        [IssueId] [int] IDENTITY(3,1) NOT NULL,
        [ErrorCode] [nvarchar](50) NOT NULL,
        [ValidatorAlias] [nvarchar](50) NOT NULL,
        [ErrorDescription] [nvarchar](1000) NULL,
        [Error] [nvarchar](250) NULL,
        [ErrorType] [nvarchar](20) NOT NULL,
        [Category] [nvarchar](50) NOT NULL,
        [CrawlDate] [datetime] NOT NULL,
        [ResolvedDate] [datetime] NULL,
        [Ignore] [bit] NOT NULL,
     CONSTRAINT [PK_[SEOChecker_ConfigurationIssues] PRIMARY KEY CLUSTERED 
    (
        [IssueId] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[SEOChecker_Notifications]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[SEOChecker_Notifications](
        [Id] [int] IDENTITY(3,1) NOT NULL,
        [NotificationUser] [nvarchar](250) NOT NULL,
        [ExecuteEvery] [nvarchar](50) NOT NULL,
        [ExecuteDays] [nvarchar](50) NULL,
        [ExecuteHour] [int] NOT NULL,
        [ExecuteMinute] [int] NOT NULL,
        [NextRun] [datetime] NOT NULL,
     CONSTRAINT [PK_SEOChecker_Notifications] PRIMARY KEY CLUSTERED 
    (
        [Id] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[SEOChecker_PageNotFound]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[SEOChecker_PageNotFound](
        [NotFoundId] [int] IDENTITY(455,1) NOT NULL,
        [Url] [nvarchar](500) NOT NULL,
        [DocumentID] [int] NULL,
        [Ignore] [bit] NOT NULL,
        [TimesAccessed] [int] NULL,
        [LastTimeAccessed] [datetime] NULL,
        [RedirectUrl] [nvarchar](500) NULL,
        [Referer] [nvarchar](500) NULL,
        [ContentType] [nvarchar](50) NULL,
        [Domain] [nvarchar](250) NULL,
        [QueryString] [nvarchar](250) NULL,
        [WildCard] [bit] NULL,
     CONSTRAINT [PK_SEOChecker_PageNotFound] PRIMARY KEY CLUSTERED 
    (
        [NotFoundId] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[SEOChecker_Queue]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[SEOChecker_Queue](
        [DocumentID] [int] NOT NULL,
        [QueuedDateTime] [datetime] NOT NULL,
        [Priority] [int] NOT NULL,
     CONSTRAINT [PK_SEOChecker_Queue] PRIMARY KEY CLUSTERED 
    (
        [DocumentID] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[SEOChecker_Robots]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[SEOChecker_Robots](
        [NodeId] [int] NOT NULL,
        [UserAgent] [nvarchar](100) NOT NULL,
        [RequestDateTime] [datetime] NOT NULL
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[SEOChecker_ScheduledValidation]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[SEOChecker_ScheduledValidation](
        [Id] [int] IDENTITY(3,1) NOT NULL,
        [TaskName] [nvarchar](250) NOT NULL,
        [NotificationEmailAddress] [nvarchar](250) NOT NULL,
        [ExecuteEvery] [nvarchar](50) NOT NULL,
        [ExecuteDays] [nvarchar](50) NULL,
        [ExecuteHour] [int] NOT NULL,
        [ExecuteMinute] [int] NOT NULL,
        [ValidationRoot] [int] NOT NULL,
        [IncludeChildren] [bit] NOT NULL,
        [NextRun] [datetime] NOT NULL,
        [LastTimeExecuted] [datetime] NULL,
     CONSTRAINT [PK_SEOChecker_ScheduledValidation] PRIMARY KEY CLUSTERED 
    (
        [Id] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[SEOChecker_URLHistory]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[SEOChecker_URLHistory](
        [UrlHistoryId] [int] IDENTITY(81,1) NOT NULL,
        [NodeId] [int] NOT NULL,
        [ParentId] [int] NOT NULL,
        [UrlPart] [nvarchar](100) NOT NULL,
     CONSTRAINT [PK_SEOChecker_URLHistory] PRIMARY KEY CLUSTERED 
    (
        [UrlHistoryId] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[SEOChecker_ValidationIssues]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[SEOChecker_ValidationIssues](
        [IssueId] [int] IDENTITY(3409,1) NOT NULL,
        [DocumentID] [int] NULL,
        [ErrorCode] [nvarchar](50) NOT NULL,
        [ValidatorAlias] [nvarchar](50) NOT NULL,
        [ErrorDescription] [nvarchar](1000) NULL,
        [Error] [nvarchar](500) NULL,
        [Template] [nvarchar](50) NULL,
        [Category] [nvarchar](50) NOT NULL,
        [ValidationType] [nvarchar](50) NOT NULL,
        [ErrorType] [nvarchar](20) NOT NULL,
        [PropertyAlias] [nvarchar](150) NULL,
        [DataTypeId] [uniqueidentifier] NULL,
        [CrawlDate] [datetime] NOT NULL,
        [ResolvedDate] [datetime] NULL,
        [Ignore] [bit] NOT NULL,
     CONSTRAINT [PK_SEOChecker_ValidationIssues] PRIMARY KEY CLUSTERED 
    (
        [IssueId] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[UFRecordDataBit]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[UFRecordDataBit](
        [Id] [int] IDENTITY(5,1) NOT NULL,
        [Key] [uniqueidentifier] NOT NULL,
        [Value] [bit] NULL,
     CONSTRAINT [PK_UFRecordDataBit] PRIMARY KEY CLUSTERED 
    (
        [Id] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[UFRecordDataDateTime]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[UFRecordDataDateTime](
        [Id] [int] IDENTITY(3,1) NOT NULL,
        [Key] [uniqueidentifier] NOT NULL,
        [Value] [datetime] NULL,
     CONSTRAINT [PK_UFRecordDataDateTime] PRIMARY KEY CLUSTERED 
    (
        [Id] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[UFRecordDataInteger]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[UFRecordDataInteger](
        [Id] [int] IDENTITY(2,1) NOT NULL,
        [Key] [uniqueidentifier] NOT NULL,
        [Value] [int] NULL,
     CONSTRAINT [PK_UFRecordDataInteger] PRIMARY KEY CLUSTERED 
    (
        [Id] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[UFRecordDataLongString]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[UFRecordDataLongString](
        [Id] [int] IDENTITY(19,1) NOT NULL,
        [Key] [uniqueidentifier] NOT NULL,
        [Value] [ntext] NULL,
     CONSTRAINT [PK_UFRecordDataLongString] PRIMARY KEY CLUSTERED 
    (
        [Id] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[UFRecordDataString]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[UFRecordDataString](
        [Id] [int] IDENTITY(417,1) NOT NULL,
        [Key] [uniqueidentifier] NOT NULL,
        [Value] [nvarchar](255) NOT NULL,
     CONSTRAINT [PK_UFRecordDataString] PRIMARY KEY CLUSTERED 
    (
        [Id] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[UFRecordFields]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[UFRecordFields](
        [Key] [uniqueidentifier] NOT NULL,
        [FieldId] [uniqueidentifier] NOT NULL,
        [Record] [int] NOT NULL,
        [Alias] [nvarchar](255) NOT NULL,
        [DataType] [nvarchar](255) NOT NULL,
     CONSTRAINT [PK_UFRecordFields] PRIMARY KEY CLUSTERED 
    (
        [Key] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[UFRecords]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[UFRecords](
        [Id] [int] IDENTITY(51,1) NOT NULL,
        [Form] [uniqueidentifier] NOT NULL,
        [Created] [datetime] NOT NULL,
        [Updated] [datetime] NOT NULL,
        [CurrentPage] [uniqueidentifier] NULL,
        [UmbracoPageId] [int] NULL,
        [IP] [nvarchar](255) NULL,
        [MemberKey] [nvarchar](255) NULL,
        [UniqueId] [uniqueidentifier] NOT NULL,
        [State] [nvarchar](50) NULL,
        [RecordData] [ntext] NOT NULL,
     CONSTRAINT [PK_UFRecords] PRIMARY KEY CLUSTERED 
    (
        [Id] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[UFUserFormSecurity]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[UFUserFormSecurity](
        [Id] [int] IDENTITY(36,1) NOT NULL,
        [User] [nvarchar](50) NOT NULL,
        [Form] [uniqueidentifier] NOT NULL,
        [HasAccess] [bit] NOT NULL,
        [AllowInEditor] [bit] NOT NULL,
        [SecurityType] [int] NOT NULL,
     CONSTRAINT [Id] PRIMARY KEY CLUSTERED 
    (
        [Id] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[UFUserSecurity]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[UFUserSecurity](
        [User] [nvarchar](50) NOT NULL,
        [ManageDataSources] [bit] NOT NULL,
        [ManagePreValueSources] [bit] NOT NULL,
        [ManageWorkflows] [bit] NOT NULL,
        [ManageForms] [bit] NOT NULL
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[umbracoAccess]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[umbracoAccess](
        [id] [uniqueidentifier] NOT NULL,
        [nodeId] [int] NOT NULL,
        [loginNodeId] [int] NOT NULL,
        [noAccessNodeId] [int] NOT NULL,
        [createDate] [datetime] NOT NULL,
        [updateDate] [datetime] NOT NULL,
     CONSTRAINT [PK_umbracoAccess] PRIMARY KEY CLUSTERED 
    (
        [id] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
     CONSTRAINT [IX_umbracoAccess_nodeId] UNIQUE NONCLUSTERED 
    (
        [nodeId] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[umbracoAccessRule]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[umbracoAccessRule](
        [id] [uniqueidentifier] NOT NULL,
        [accessId] [uniqueidentifier] NOT NULL,
        [ruleValue] [nvarchar](255) NOT NULL,
        [ruleType] [nvarchar](255) NOT NULL,
        [createDate] [datetime] NOT NULL,
        [updateDate] [datetime] NOT NULL,
     CONSTRAINT [PK_umbracoAccessRule] PRIMARY KEY CLUSTERED 
    (
        [id] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
     CONSTRAINT [IX_umbracoAccessRule] UNIQUE NONCLUSTERED 
    (
        [accessId] ASC,
        [ruleValue] ASC,
        [ruleType] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[umbracoAudit]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[umbracoAudit](
        [id] [int] IDENTITY(1,1) NOT NULL,
        [performingUserId] [int] NOT NULL,
        [performingDetails] [nvarchar](1024) NULL,
        [performingIp] [nvarchar](64) NULL,
        [eventDateUtc] [datetime] NOT NULL,
        [affectedUserId] [int] NOT NULL,
        [affectedDetails] [nvarchar](1024) NULL,
        [eventType] [nvarchar](256) NOT NULL,
        [eventDetails] [nvarchar](1024) NULL,
     CONSTRAINT [PK_umbracoAudit] PRIMARY KEY CLUSTERED 
    (
        [id] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[umbracoCacheInstruction]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[umbracoCacheInstruction](
        [id] [int] IDENTITY(14541,1) NOT NULL,
        [utcStamp] [datetime] NOT NULL,
        [jsonInstruction] [ntext] NOT NULL,
        [originated] [nvarchar](500) NOT NULL,
        [instructionCount] [int] NOT NULL,
     CONSTRAINT [PK_umbracoCacheInstruction] PRIMARY KEY CLUSTERED 
    (
        [id] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[umbracoConsent]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[umbracoConsent](
        [id] [int] IDENTITY(1,1) NOT NULL,
        [current] [bit] NOT NULL,
        [source] [nvarchar](512) NOT NULL,
        [context] [nvarchar](128) NOT NULL,
        [action] [nvarchar](512) NOT NULL,
        [createDate] [datetime] NOT NULL,
        [state] [int] NOT NULL,
        [comment] [nvarchar](255) NOT NULL,
     CONSTRAINT [PK_umbracoConsent] PRIMARY KEY CLUSTERED 
    (
        [id] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[umbracoDomains]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[umbracoDomains](
        [id] [int] IDENTITY(3,1) NOT NULL,
        [domainDefaultLanguage] [int] NULL,
        [domainRootStructureID] [int] NULL,
        [domainName] [nvarchar](255) NOT NULL,
     CONSTRAINT [PK_umbracoDomains] PRIMARY KEY CLUSTERED 
    (
        [id] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[umbracoExternalLogin]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[umbracoExternalLogin](
        [id] [int] IDENTITY(3,1) NOT NULL,
        [userId] [int] NOT NULL,
        [loginProvider] [nvarchar](4000) NOT NULL,
        [providerKey] [nvarchar](4000) NOT NULL,
        [createDate] [datetime] NOT NULL,
     CONSTRAINT [PK_umbracoExternalLogin] PRIMARY KEY CLUSTERED 
    (
        [id] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[umbracoLanguage]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[umbracoLanguage](
        [id] [int] IDENTITY(3,1) NOT NULL,
        [languageISOCode] [nvarchar](10) NULL,
        [languageCultureName] [nvarchar](100) NULL,
     CONSTRAINT [PK_umbracoLanguage] PRIMARY KEY CLUSTERED 
    (
        [id] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
     CONSTRAINT [IX_umbracoLanguage_languageISOCode] UNIQUE NONCLUSTERED 
    (
        [languageISOCode] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[umbracoLock]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[umbracoLock](
        [id] [int] NOT NULL,
        [value] [int] NOT NULL,
        [name] [nvarchar](64) NOT NULL,
     CONSTRAINT [PK_umbracoLock] PRIMARY KEY CLUSTERED 
    (
        [id] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[umbracoLog]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[umbracoLog](
        [id] [int] IDENTITY(290964,1) NOT NULL,
        [userId] [int] NOT NULL,
        [NodeId] [int] NOT NULL,
        [Datestamp] [datetime] NOT NULL,
        [logHeader] [nvarchar](50) NOT NULL,
        [logComment] [nvarchar](4000) NULL,
     CONSTRAINT [PK_umbracoLog] PRIMARY KEY CLUSTERED 
    (
        [id] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[umbracoMigration]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[umbracoMigration](
        [id] [int] IDENTITY(8,1) NOT NULL,
        [name] [nvarchar](255) NOT NULL,
        [version] [nvarchar](50) NOT NULL,
        [createDate] [datetime] NOT NULL,
     CONSTRAINT [PK_umbracoMigrations] PRIMARY KEY CLUSTERED 
    (
        [id] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
     CONSTRAINT [IX_umbracoMigration] UNIQUE NONCLUSTERED 
    (
        [name] ASC,
        [version] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[umbracoNode]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[umbracoNode](
        [id] [int] IDENTITY(53779,1) NOT NULL,
        [trashed] [bit] NOT NULL,
        [parentID] [int] NOT NULL,
        [nodeUser] [int] NULL,
        [level] [int] NOT NULL,
        [path] [nvarchar](150) NOT NULL,
        [sortOrder] [int] NOT NULL,
        [uniqueID] [uniqueidentifier] NULL,
        [text] [nvarchar](255) NULL,
        [nodeObjectType] [uniqueidentifier] NULL,
        [createDate] [datetime] NOT NULL,
     CONSTRAINT [PK_structure] PRIMARY KEY CLUSTERED 
    (
        [id] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
     CONSTRAINT [IX_umbracoNode_uniqueID] UNIQUE NONCLUSTERED 
    (
        [uniqueID] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[umbracoRedirectUrl]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[umbracoRedirectUrl](
        [id] [uniqueidentifier] NOT NULL,
        [createDateUtc] [datetime] NOT NULL,
        [url] [nvarchar](2048) NOT NULL,
        [contentKey] [uniqueidentifier] NOT NULL,
        [urlHash] [nvarchar](40) NOT NULL,
     CONSTRAINT [PK_umbracoRedirectUrl] PRIMARY KEY CLUSTERED 
    (
        [id] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[umbracoRelation]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[umbracoRelation](
        [id] [int] IDENTITY(44613,1) NOT NULL,
        [parentId] [int] NOT NULL,
        [childId] [int] NOT NULL,
        [relType] [int] NOT NULL,
        [datetime] [datetime] NOT NULL,
        [comment] [nvarchar](1000) NOT NULL,
     CONSTRAINT [PK_umbracoRelation] PRIMARY KEY CLUSTERED 
    (
        [id] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[umbracoRelationType]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[umbracoRelationType](
        [id] [int] IDENTITY(5,1) NOT NULL,
        [dual] [bit] NOT NULL,
        [parentObjectType] [uniqueidentifier] NOT NULL,
        [childObjectType] [uniqueidentifier] NOT NULL,
        [name] [nvarchar](255) NOT NULL,
        [alias] [nvarchar](100) NULL,
        [typeUniqueId] [uniqueidentifier] NOT NULL,
     CONSTRAINT [PK_umbracoRelationType] PRIMARY KEY CLUSTERED 
    (
        [id] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[umbracoServer]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[umbracoServer](
        [id] [int] IDENTITY(1018,1) NOT NULL,
        [address] [nvarchar](500) NOT NULL,
        [computerName] [nvarchar](255) NOT NULL,
        [registeredDate] [datetime] NOT NULL,
        [lastNotifiedDate] [datetime] NOT NULL,
        [isActive] [bit] NOT NULL,
        [isMaster] [bit] NOT NULL,
     CONSTRAINT [PK_umbracoServer] PRIMARY KEY CLUSTERED 
    (
        [id] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
     CONSTRAINT [IX_computerName] UNIQUE NONCLUSTERED 
    (
        [computerName] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[umbracoUser]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[umbracoUser](
        [id] [int] IDENTITY(5,1) NOT NULL,
        [userDisabled] [bit] NOT NULL,
        [userNoConsole] [bit] NOT NULL,
        [userName] [nvarchar](255) NOT NULL,
        [userLogin] [nvarchar](125) NOT NULL,
        [userPassword] [nvarchar](500) NOT NULL,
        [userEmail] [nvarchar](255) NOT NULL,
        [userLanguage] [nvarchar](10) NULL,
        [securityStampToken] [nvarchar](255) NULL,
        [failedLoginAttempts] [int] NULL,
        [lastLockoutDate] [datetime] NULL,
        [lastPasswordChangeDate] [datetime] NULL,
        [lastLoginDate] [datetime] NULL,
        [createDate] [datetime] NOT NULL,
        [updateDate] [datetime] NOT NULL,
        [emailConfirmedDate] [datetime] NULL,
        [invitedDate] [datetime] NULL,
        [avatar] [nvarchar](500) NULL,
        [passwordConfig] [nvarchar](500) NULL,
        [tourData] [ntext] NULL,
     CONSTRAINT [PK_user] PRIMARY KEY CLUSTERED 
    (
        [id] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[umbracoUser2NodeNotify]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[umbracoUser2NodeNotify](
        [userId] [int] NOT NULL,
        [nodeId] [int] NOT NULL,
        [action] [nchar](1) NOT NULL,
     CONSTRAINT [PK_umbracoUser2NodeNotify] PRIMARY KEY CLUSTERED 
    (
        [userId] ASC,
        [nodeId] ASC,
        [action] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[umbracoUser2UserGroup]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[umbracoUser2UserGroup](
        [userId] [int] NOT NULL,
        [userGroupId] [int] NOT NULL,
     CONSTRAINT [PK_user2userGroup] PRIMARY KEY CLUSTERED 
    (
        [userId] ASC,
        [userGroupId] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[umbracoUserGroup]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[umbracoUserGroup](
        [id] [int] IDENTITY(1,1) NOT NULL,
        [userGroupAlias] [nvarchar](200) NOT NULL,
        [userGroupName] [nvarchar](200) NOT NULL,
        [userGroupDefaultPermissions] [nvarchar](50) NULL,
        [createDate] [datetime] NOT NULL,
        [updateDate] [datetime] NOT NULL,
        [icon] [nvarchar](255) NULL,
        [startContentId] [int] NULL,
        [startMediaId] [int] NULL,
     CONSTRAINT [PK_umbracoUserGroup] PRIMARY KEY CLUSTERED 
    (
        [id] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[umbracoUserGroup2App]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[umbracoUserGroup2App](
        [userGroupId] [int] NOT NULL,
        [app] [nvarchar](50) NOT NULL,
     CONSTRAINT [PK_userGroup2App] PRIMARY KEY CLUSTERED 
    (
        [userGroupId] ASC,
        [app] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[umbracoUserGroup2NodePermission]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[umbracoUserGroup2NodePermission](
        [userGroupId] [int] NOT NULL,
        [nodeId] [int] NOT NULL,
        [permission] [nvarchar](255) NOT NULL,
     CONSTRAINT [PK_umbracoUserGroup2NodePermission] PRIMARY KEY CLUSTERED 
    (
        [userGroupId] ASC,
        [nodeId] ASC,
        [permission] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[umbracoUserLogin]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[umbracoUserLogin](
        [sessionId] [uniqueidentifier] NOT NULL,
        [userId] [int] NOT NULL,
        [loggedInUtc] [datetime] NOT NULL,
        [lastValidatedUtc] [datetime] NOT NULL,
        [loggedOutUtc] [datetime] NULL,
        [ipAddress] [nvarchar](255) NULL,
     CONSTRAINT [PK_umbracoUserLogin] PRIMARY KEY CLUSTERED 
    (
        [sessionId] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    /****** Object:  Table [dbo].[umbracoUserStartNode]    Script Date: 8/15/2018 4:43:06 PM ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[umbracoUserStartNode](
        [id] [int] IDENTITY(1,1) NOT NULL,
        [userId] [int] NOT NULL,
        [startNode] [int] NOT NULL,
        [startNodeType] [int] NOT NULL,
     CONSTRAINT [PK_userStartNode] PRIMARY KEY CLUSTERED 
    (
        [id] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
    
    GO
    SET ANSI_PADDING ON
    
    GO
    /****** Object:  Index [IX_cmsContentType_icon]    Script Date: 8/15/2018 4:43:06 PM ******/
    CREATE NONCLUSTERED INDEX [IX_cmsContentType_icon] ON [dbo].[cmsContentType]
    (
        [icon] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    GO
    /****** Object:  Index [IX_cmsContentVersion_ContentId]    Script Date: 8/15/2018 4:43:06 PM ******/
    CREATE NONCLUSTERED INDEX [IX_cmsContentVersion_ContentId] ON [dbo].[cmsContentVersion]
    (
        [ContentId] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    GO
    SET ANSI_PADDING ON
    
    GO
    /****** Object:  Index [IX_cmsDictionary_key]    Script Date: 8/15/2018 4:43:06 PM ******/
    CREATE NONCLUSTERED INDEX [IX_cmsDictionary_key] ON [dbo].[cmsDictionary]
    (
        [key] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    GO
    /****** Object:  Index [IX_cmsDocument_newest]    Script Date: 8/15/2018 4:43:06 PM ******/
    CREATE NONCLUSTERED INDEX [IX_cmsDocument_newest] ON [dbo].[cmsDocument]
    (
        [newest] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    GO
    /****** Object:  Index [IX_cmsDocument_published]    Script Date: 8/15/2018 4:43:06 PM ******/
    CREATE NONCLUSTERED INDEX [IX_cmsDocument_published] ON [dbo].[cmsDocument]
    (
        [published] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    GO
    /****** Object:  Index [IX_cmsMacro_UniqueId]    Script Date: 8/15/2018 4:43:06 PM ******/
    CREATE UNIQUE NONCLUSTERED INDEX [IX_cmsMacro_UniqueId] ON [dbo].[cmsMacro]
    (
        [uniqueId] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    GO
    /****** Object:  Index [IX_cmsMacroProperty_UniquePropertyId]    Script Date: 8/15/2018 4:43:06 PM ******/
    CREATE UNIQUE NONCLUSTERED INDEX [IX_cmsMacroProperty_UniquePropertyId] ON [dbo].[cmsMacroProperty]
    (
        [uniquePropertyId] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    GO
    SET ANSI_PADDING ON
    
    GO
    /****** Object:  Index [IX_cmsMedia]    Script Date: 8/15/2018 4:43:06 PM ******/
    CREATE UNIQUE NONCLUSTERED INDEX [IX_cmsMedia] ON [dbo].[cmsMedia]
    (
        [nodeId] ASC,
        [versionId] ASC,
        [mediaPath] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    GO
    SET ANSI_PADDING ON
    
    GO
    /****** Object:  Index [IX_cmsMember_LoginName]    Script Date: 8/15/2018 4:43:06 PM ******/
    CREATE NONCLUSTERED INDEX [IX_cmsMember_LoginName] ON [dbo].[cmsMember]
    (
        [LoginName] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    GO
    /****** Object:  Index [IX_cmsPropertyData_2]    Script Date: 8/15/2018 4:43:06 PM ******/
    CREATE NONCLUSTERED INDEX [IX_cmsPropertyData_2] ON [dbo].[cmsPropertyData]
    (
        [versionId] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    GO
    /****** Object:  Index [IX_cmsPropertyData_3]    Script Date: 8/15/2018 4:43:06 PM ******/
    CREATE NONCLUSTERED INDEX [IX_cmsPropertyData_3] ON [dbo].[cmsPropertyData]
    (
        [propertytypeid] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    GO
    SET ANSI_PADDING ON
    
    GO
    /****** Object:  Index [IX_cmsPropertyTypeAlias]    Script Date: 8/15/2018 4:43:06 PM ******/
    CREATE NONCLUSTERED INDEX [IX_cmsPropertyTypeAlias] ON [dbo].[cmsPropertyType]
    (
        [Alias] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    GO
    SET ANSI_PADDING ON
    
    GO
    /****** Object:  Index [IX_cmsTags]    Script Date: 8/15/2018 4:43:06 PM ******/
    CREATE NONCLUSTERED INDEX [IX_cmsTags] ON [dbo].[cmsTags]
    (
        [tag] ASC,
        [group] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    GO
    SET ANSI_PADDING ON
    
    GO
    /****** Object:  Index [IX_cmsTaskType_alias]    Script Date: 8/15/2018 4:43:06 PM ******/
    CREATE NONCLUSTERED INDEX [IX_cmsTaskType_alias] ON [dbo].[cmsTaskType]
    (
        [alias] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    GO
    /****** Object:  Index [IX_databit_recordfield]    Script Date: 8/15/2018 4:43:06 PM ******/
    CREATE NONCLUSTERED INDEX [IX_databit_recordfield] ON [dbo].[UFRecordDataBit]
    (
        [Key] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    GO
    /****** Object:  Index [IX_datadatetime_recordfield]    Script Date: 8/15/2018 4:43:06 PM ******/
    CREATE NONCLUSTERED INDEX [IX_datadatetime_recordfield] ON [dbo].[UFRecordDataDateTime]
    (
        [Key] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    GO
    /****** Object:  Index [IX_datainteger_recordfield]    Script Date: 8/15/2018 4:43:06 PM ******/
    CREATE NONCLUSTERED INDEX [IX_datainteger_recordfield] ON [dbo].[UFRecordDataInteger]
    (
        [Key] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    GO
    /****** Object:  Index [IX_datalongstring_recordfield]    Script Date: 8/15/2018 4:43:06 PM ******/
    CREATE NONCLUSTERED INDEX [IX_datalongstring_recordfield] ON [dbo].[UFRecordDataLongString]
    (
        [Key] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    GO
    /****** Object:  Index [IX_datastring_recordfield]    Script Date: 8/15/2018 4:43:06 PM ******/
    CREATE NONCLUSTERED INDEX [IX_datastring_recordfield] ON [dbo].[UFRecordDataString]
    (
        [Key] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    GO
    /****** Object:  Index [IX_umbracoLog]    Script Date: 8/15/2018 4:43:06 PM ******/
    CREATE NONCLUSTERED INDEX [IX_umbracoLog] ON [dbo].[umbracoLog]
    (
        [NodeId] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    GO
    /****** Object:  Index [IX_umbracoNodeObjectType]    Script Date: 8/15/2018 4:43:06 PM ******/
    CREATE NONCLUSTERED INDEX [IX_umbracoNodeObjectType] ON [dbo].[umbracoNode]
    (
        [nodeObjectType] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    GO
    /****** Object:  Index [IX_umbracoNodeParentId]    Script Date: 8/15/2018 4:43:06 PM ******/
    CREATE NONCLUSTERED INDEX [IX_umbracoNodeParentId] ON [dbo].[umbracoNode]
    (
        [parentID] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    GO
    SET ANSI_PADDING ON
    
    GO
    /****** Object:  Index [IX_umbracoNodePath]    Script Date: 8/15/2018 4:43:06 PM ******/
    CREATE NONCLUSTERED INDEX [IX_umbracoNodePath] ON [dbo].[umbracoNode]
    (
        [path] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    GO
    /****** Object:  Index [IX_umbracoNodeTrashed]    Script Date: 8/15/2018 4:43:06 PM ******/
    CREATE NONCLUSTERED INDEX [IX_umbracoNodeTrashed] ON [dbo].[umbracoNode]
    (
        [trashed] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    GO
    SET ANSI_PADDING ON
    
    GO
    /****** Object:  Index [IX_umbracoRedirectUrl]    Script Date: 8/15/2018 4:43:06 PM ******/
    CREATE NONCLUSTERED INDEX [IX_umbracoRedirectUrl] ON [dbo].[umbracoRedirectUrl]
    (
        [urlHash] ASC,
        [contentKey] ASC,
        [createDateUtc] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    GO
    /****** Object:  Index [IX_umbracoRelation_parentChildType]    Script Date: 8/15/2018 4:43:06 PM ******/
    CREATE UNIQUE NONCLUSTERED INDEX [IX_umbracoRelation_parentChildType] ON [dbo].[umbracoRelation]
    (
        [parentId] ASC,
        [childId] ASC,
        [relType] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    GO
    SET ANSI_PADDING ON
    
    GO
    /****** Object:  Index [IX_umbracoRelationType_alias]    Script Date: 8/15/2018 4:43:06 PM ******/
    CREATE NONCLUSTERED INDEX [IX_umbracoRelationType_alias] ON [dbo].[umbracoRelationType]
    (
        [alias] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    GO
    SET ANSI_PADDING ON
    
    GO
    /****** Object:  Index [IX_umbracoRelationType_name]    Script Date: 8/15/2018 4:43:06 PM ******/
    CREATE NONCLUSTERED INDEX [IX_umbracoRelationType_name] ON [dbo].[umbracoRelationType]
    (
        [name] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    GO
    /****** Object:  Index [IX_umbracoRelationType_UniqueId]    Script Date: 8/15/2018 4:43:06 PM ******/
    CREATE UNIQUE NONCLUSTERED INDEX [IX_umbracoRelationType_UniqueId] ON [dbo].[umbracoRelationType]
    (
        [typeUniqueId] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    GO
    /****** Object:  Index [IX_umbracoServer_isActive]    Script Date: 8/15/2018 4:43:06 PM ******/
    CREATE NONCLUSTERED INDEX [IX_umbracoServer_isActive] ON [dbo].[umbracoServer]
    (
        [isActive] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    GO
    SET ANSI_PADDING ON
    
    GO
    /****** Object:  Index [IX_umbracoUser_userLogin]    Script Date: 8/15/2018 4:43:06 PM ******/
    CREATE NONCLUSTERED INDEX [IX_umbracoUser_userLogin] ON [dbo].[umbracoUser]
    (
        [userLogin] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    GO
    SET ANSI_PADDING ON
    
    GO
    /****** Object:  Index [IX_umbracoUserGroup_userGroupAlias]    Script Date: 8/15/2018 4:43:06 PM ******/
    CREATE UNIQUE NONCLUSTERED INDEX [IX_umbracoUserGroup_userGroupAlias] ON [dbo].[umbracoUserGroup]
    (
        [userGroupAlias] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    GO
    SET ANSI_PADDING ON
    
    GO
    /****** Object:  Index [IX_umbracoUserGroup_userGroupName]    Script Date: 8/15/2018 4:43:06 PM ******/
    CREATE UNIQUE NONCLUSTERED INDEX [IX_umbracoUserGroup_userGroupName] ON [dbo].[umbracoUserGroup]
    (
        [userGroupName] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    GO
    /****** Object:  Index [IX_umbracoUser2NodePermission_nodeId]    Script Date: 8/15/2018 4:43:06 PM ******/
    CREATE NONCLUSTERED INDEX [IX_umbracoUser2NodePermission_nodeId] ON [dbo].[umbracoUserGroup2NodePermission]
    (
        [nodeId] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    GO
    /****** Object:  Index [IX_umbracoUserStartNode_startNodeType]    Script Date: 8/15/2018 4:43:06 PM ******/
    CREATE UNIQUE NONCLUSTERED INDEX [IX_umbracoUserStartNode_startNodeType] ON [dbo].[umbracoUserStartNode]
    (
        [startNodeType] ASC,
        [startNode] ASC,
        [userId] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    GO
    ALTER TABLE [dbo].[cmsContentType] ADD  DEFAULT ('folder.png') FOR [thumbnail]
    GO
    ALTER TABLE [dbo].[cmsContentType] ADD  DEFAULT ('0') FOR [isContainer]
    GO
    ALTER TABLE [dbo].[cmsContentType] ADD  DEFAULT ('0') FOR [allowAtRoot]
    GO
    ALTER TABLE [dbo].[cmsContentTypeAllowedContentType] ADD  DEFAULT ('0') FOR [SortOrder]
    GO
    ALTER TABLE [dbo].[cmsContentVersion] ADD  DEFAULT (getdate()) FOR [VersionDate]
    GO
    ALTER TABLE [dbo].[cmsDocument] ADD  DEFAULT (getdate()) FOR [updateDate]
    GO
    ALTER TABLE [dbo].[cmsDocument] ADD  DEFAULT ('0') FOR [newest]
    GO
    ALTER TABLE [dbo].[cmsDocumentType] ADD  DEFAULT ('0') FOR [IsDefault]
    GO
    ALTER TABLE [dbo].[cmsMacro] ADD  DEFAULT ('0') FOR [macroUseInEditor]
    GO
    ALTER TABLE [dbo].[cmsMacro] ADD  DEFAULT ('0') FOR [macroRefreshRate]
    GO
    ALTER TABLE [dbo].[cmsMacro] ADD  DEFAULT ('1') FOR [macroCacheByPage]
    GO
    ALTER TABLE [dbo].[cmsMacro] ADD  DEFAULT ('0') FOR [macroCachePersonalized]
    GO
    ALTER TABLE [dbo].[cmsMacro] ADD  DEFAULT ('0') FOR [macroDontRender]
    GO
    ALTER TABLE [dbo].[cmsMacroProperty] ADD  DEFAULT ('0') FOR [macroPropertySortOrder]
    GO
    ALTER TABLE [dbo].[cmsMember] ADD  DEFAULT ('''') FOR [Email]
    GO
    ALTER TABLE [dbo].[cmsMember] ADD  DEFAULT ('''') FOR [LoginName]
    GO
    ALTER TABLE [dbo].[cmsMember] ADD  DEFAULT ('''') FOR [Password]
    GO
    ALTER TABLE [dbo].[cmsMemberType] ADD  DEFAULT ('0') FOR [memberCanEdit]
    GO
    ALTER TABLE [dbo].[cmsMemberType] ADD  DEFAULT ('0') FOR [viewOnProfile]
    GO
    ALTER TABLE [dbo].[cmsMemberType] ADD  CONSTRAINT [DF_cmsMemberType_isSensitive]  DEFAULT ('0') FOR [isSensitive]
    GO
    ALTER TABLE [dbo].[cmsPropertyType] ADD  DEFAULT ('0') FOR [sortOrder]
    GO
    ALTER TABLE [dbo].[cmsPropertyType] ADD  DEFAULT ('0') FOR [mandatory]
    GO
    ALTER TABLE [dbo].[cmsPropertyType] ADD  DEFAULT (newid()) FOR [uniqueID]
    GO
    ALTER TABLE [dbo].[cmsPropertyTypeGroup] ADD  DEFAULT (newid()) FOR [uniqueID]
    GO
    ALTER TABLE [dbo].[cmsTask] ADD  DEFAULT ('0') FOR [closed]
    GO
    ALTER TABLE [dbo].[cmsTask] ADD  DEFAULT (getdate()) FOR [DateTime]
    GO
    ALTER TABLE [dbo].[umbracoAccess] ADD  DEFAULT (getdate()) FOR [createDate]
    GO
    ALTER TABLE [dbo].[umbracoAccess] ADD  DEFAULT (getdate()) FOR [updateDate]
    GO
    ALTER TABLE [dbo].[umbracoAccessRule] ADD  DEFAULT (getdate()) FOR [createDate]
    GO
    ALTER TABLE [dbo].[umbracoAccessRule] ADD  DEFAULT (getdate()) FOR [updateDate]
    GO
    ALTER TABLE [dbo].[umbracoAudit] ADD  CONSTRAINT [DF_umbracoAudit_eventDateUtc]  DEFAULT (getdate()) FOR [eventDateUtc]
    GO
    ALTER TABLE [dbo].[umbracoCacheInstruction] ADD  CONSTRAINT [DF_umbracoCacheInstruction_instructionCount]  DEFAULT ('1') FOR [instructionCount]
    GO
    ALTER TABLE [dbo].[umbracoConsent] ADD  CONSTRAINT [DF_umbracoConsent_createDate]  DEFAULT (getdate()) FOR [createDate]
    GO
    ALTER TABLE [dbo].[umbracoExternalLogin] ADD  DEFAULT (getdate()) FOR [createDate]
    GO
    ALTER TABLE [dbo].[umbracoLog] ADD  DEFAULT (getdate()) FOR [Datestamp]
    GO
    ALTER TABLE [dbo].[umbracoMigration] ADD  DEFAULT (getdate()) FOR [createDate]
    GO
    ALTER TABLE [dbo].[umbracoNode] ADD  DEFAULT ('0') FOR [trashed]
    GO
    ALTER TABLE [dbo].[umbracoNode] ADD  DEFAULT (getdate()) FOR [createDate]
    GO
    ALTER TABLE [dbo].[umbracoRelation] ADD  DEFAULT (getdate()) FOR [datetime]
    GO
    ALTER TABLE [dbo].[umbracoServer] ADD  DEFAULT (getdate()) FOR [registeredDate]
    GO
    ALTER TABLE [dbo].[umbracoServer] ADD  DEFAULT ('0') FOR [isMaster]
    GO
    ALTER TABLE [dbo].[umbracoUser] ADD  DEFAULT ('0') FOR [userDisabled]
    GO
    ALTER TABLE [dbo].[umbracoUser] ADD  DEFAULT ('0') FOR [userNoConsole]
    GO
    ALTER TABLE [dbo].[umbracoUser] ADD  CONSTRAINT [DF_umbracoUser_createDate]  DEFAULT (getdate()) FOR [createDate]
    GO
    ALTER TABLE [dbo].[umbracoUser] ADD  CONSTRAINT [DF_umbracoUser_updateDate]  DEFAULT (getdate()) FOR [updateDate]
    GO
    ALTER TABLE [dbo].[umbracoUserGroup] ADD  CONSTRAINT [DF_umbracoUserGroup_createDate]  DEFAULT (getdate()) FOR [createDate]
    GO
    ALTER TABLE [dbo].[umbracoUserGroup] ADD  CONSTRAINT [DF_umbracoUserGroup_updateDate]  DEFAULT (getdate()) FOR [updateDate]
    GO
    ALTER TABLE [dbo].[cmsContent]  WITH CHECK ADD  CONSTRAINT [FK_cmsContent_cmsContentType_nodeId] FOREIGN KEY([contentType])
    REFERENCES [dbo].[cmsContentType] ([nodeId])
    GO
    ALTER TABLE [dbo].[cmsContent] CHECK CONSTRAINT [FK_cmsContent_cmsContentType_nodeId]
    GO
    ALTER TABLE [dbo].[cmsContent]  WITH CHECK ADD  CONSTRAINT [FK_cmsContent_umbracoNode_id] FOREIGN KEY([nodeId])
    REFERENCES [dbo].[umbracoNode] ([id])
    GO
    ALTER TABLE [dbo].[cmsContent] CHECK CONSTRAINT [FK_cmsContent_umbracoNode_id]
    GO
    ALTER TABLE [dbo].[cmsContentType]  WITH CHECK ADD  CONSTRAINT [FK_cmsContentType_umbracoNode_id] FOREIGN KEY([nodeId])
    REFERENCES [dbo].[umbracoNode] ([id])
    GO
    ALTER TABLE [dbo].[cmsContentType] CHECK CONSTRAINT [FK_cmsContentType_umbracoNode_id]
    GO
    ALTER TABLE [dbo].[cmsContentType2ContentType]  WITH CHECK ADD  CONSTRAINT [FK_cmsContentType2ContentType_umbracoNode_child] FOREIGN KEY([childContentTypeId])
    REFERENCES [dbo].[umbracoNode] ([id])
    GO
    ALTER TABLE [dbo].[cmsContentType2ContentType] CHECK CONSTRAINT [FK_cmsContentType2ContentType_umbracoNode_child]
    GO
    ALTER TABLE [dbo].[cmsContentType2ContentType]  WITH CHECK ADD  CONSTRAINT [FK_cmsContentType2ContentType_umbracoNode_parent] FOREIGN KEY([parentContentTypeId])
    REFERENCES [dbo].[umbracoNode] ([id])
    GO
    ALTER TABLE [dbo].[cmsContentType2ContentType] CHECK CONSTRAINT [FK_cmsContentType2ContentType_umbracoNode_parent]
    GO
    ALTER TABLE [dbo].[cmsContentTypeAllowedContentType]  WITH CHECK ADD  CONSTRAINT [FK_cmsContentTypeAllowedContentType_cmsContentType] FOREIGN KEY([Id])
    REFERENCES [dbo].[cmsContentType] ([nodeId])
    GO
    ALTER TABLE [dbo].[cmsContentTypeAllowedContentType] CHECK CONSTRAINT [FK_cmsContentTypeAllowedContentType_cmsContentType]
    GO
    ALTER TABLE [dbo].[cmsContentTypeAllowedContentType]  WITH CHECK ADD  CONSTRAINT [FK_cmsContentTypeAllowedContentType_cmsContentType1] FOREIGN KEY([AllowedId])
    REFERENCES [dbo].[cmsContentType] ([nodeId])
    GO
    ALTER TABLE [dbo].[cmsContentTypeAllowedContentType] CHECK CONSTRAINT [FK_cmsContentTypeAllowedContentType_cmsContentType1]
    GO
    ALTER TABLE [dbo].[cmsContentVersion]  WITH CHECK ADD  CONSTRAINT [FK_cmsContentVersion_cmsContent_nodeId] FOREIGN KEY([ContentId])
    REFERENCES [dbo].[cmsContent] ([nodeId])
    GO
    ALTER TABLE [dbo].[cmsContentVersion] CHECK CONSTRAINT [FK_cmsContentVersion_cmsContent_nodeId]
    GO
    ALTER TABLE [dbo].[cmsContentXml]  WITH CHECK ADD  CONSTRAINT [FK_cmsContentXml_cmsContent_nodeId] FOREIGN KEY([nodeId])
    REFERENCES [dbo].[cmsContent] ([nodeId])
    GO
    ALTER TABLE [dbo].[cmsContentXml] CHECK CONSTRAINT [FK_cmsContentXml_cmsContent_nodeId]
    GO
    ALTER TABLE [dbo].[cmsDataType]  WITH CHECK ADD  CONSTRAINT [FK_cmsDataType_umbracoNode_id] FOREIGN KEY([nodeId])
    REFERENCES [dbo].[umbracoNode] ([id])
    GO
    ALTER TABLE [dbo].[cmsDataType] CHECK CONSTRAINT [FK_cmsDataType_umbracoNode_id]
    GO
    ALTER TABLE [dbo].[cmsDataTypePreValues]  WITH CHECK ADD  CONSTRAINT [FK_cmsDataTypePreValues_cmsDataType_nodeId] FOREIGN KEY([datatypeNodeId])
    REFERENCES [dbo].[cmsDataType] ([nodeId])
    GO
    ALTER TABLE [dbo].[cmsDataTypePreValues] CHECK CONSTRAINT [FK_cmsDataTypePreValues_cmsDataType_nodeId]
    GO
    ALTER TABLE [dbo].[cmsDictionary]  WITH CHECK ADD  CONSTRAINT [FK_cmsDictionary_cmsDictionary_id] FOREIGN KEY([parent])
    REFERENCES [dbo].[cmsDictionary] ([id])
    GO
    ALTER TABLE [dbo].[cmsDictionary] CHECK CONSTRAINT [FK_cmsDictionary_cmsDictionary_id]
    GO
    ALTER TABLE [dbo].[cmsDocument]  WITH CHECK ADD  CONSTRAINT [FK_cmsDocument_cmsContent_nodeId] FOREIGN KEY([nodeId])
    REFERENCES [dbo].[cmsContent] ([nodeId])
    GO
    ALTER TABLE [dbo].[cmsDocument] CHECK CONSTRAINT [FK_cmsDocument_cmsContent_nodeId]
    GO
    ALTER TABLE [dbo].[cmsDocument]  WITH CHECK ADD  CONSTRAINT [FK_cmsDocument_cmsTemplate_nodeId] FOREIGN KEY([templateId])
    REFERENCES [dbo].[cmsTemplate] ([nodeId])
    GO
    ALTER TABLE [dbo].[cmsDocument] CHECK CONSTRAINT [FK_cmsDocument_cmsTemplate_nodeId]
    GO
    ALTER TABLE [dbo].[cmsDocument]  WITH CHECK ADD  CONSTRAINT [FK_cmsDocument_umbracoNode_id] FOREIGN KEY([nodeId])
    REFERENCES [dbo].[umbracoNode] ([id])
    GO
    ALTER TABLE [dbo].[cmsDocument] CHECK CONSTRAINT [FK_cmsDocument_umbracoNode_id]
    GO
    ALTER TABLE [dbo].[cmsDocumentType]  WITH CHECK ADD  CONSTRAINT [FK_cmsDocumentType_cmsContentType_nodeId] FOREIGN KEY([contentTypeNodeId])
    REFERENCES [dbo].[cmsContentType] ([nodeId])
    GO
    ALTER TABLE [dbo].[cmsDocumentType] CHECK CONSTRAINT [FK_cmsDocumentType_cmsContentType_nodeId]
    GO
    ALTER TABLE [dbo].[cmsDocumentType]  WITH CHECK ADD  CONSTRAINT [FK_cmsDocumentType_cmsTemplate_nodeId] FOREIGN KEY([templateNodeId])
    REFERENCES [dbo].[cmsTemplate] ([nodeId])
    GO
    ALTER TABLE [dbo].[cmsDocumentType] CHECK CONSTRAINT [FK_cmsDocumentType_cmsTemplate_nodeId]
    GO
    ALTER TABLE [dbo].[cmsDocumentType]  WITH CHECK ADD  CONSTRAINT [FK_cmsDocumentType_umbracoNode_id] FOREIGN KEY([contentTypeNodeId])
    REFERENCES [dbo].[umbracoNode] ([id])
    GO
    ALTER TABLE [dbo].[cmsDocumentType] CHECK CONSTRAINT [FK_cmsDocumentType_umbracoNode_id]
    GO
    ALTER TABLE [dbo].[cmsLanguageText]  WITH CHECK ADD  CONSTRAINT [FK_cmsLanguageText_cmsDictionary_id] FOREIGN KEY([UniqueId])
    REFERENCES [dbo].[cmsDictionary] ([id])
    GO
    ALTER TABLE [dbo].[cmsLanguageText] CHECK CONSTRAINT [FK_cmsLanguageText_cmsDictionary_id]
    GO
    ALTER TABLE [dbo].[cmsLanguageText]  WITH CHECK ADD  CONSTRAINT [FK_cmsLanguageText_umbracoLanguage_id] FOREIGN KEY([languageId])
    REFERENCES [dbo].[umbracoLanguage] ([id])
    GO
    ALTER TABLE [dbo].[cmsLanguageText] CHECK CONSTRAINT [FK_cmsLanguageText_umbracoLanguage_id]
    GO
    ALTER TABLE [dbo].[cmsMacroProperty]  WITH CHECK ADD  CONSTRAINT [FK_cmsMacroProperty_cmsMacro_id] FOREIGN KEY([macro])
    REFERENCES [dbo].[cmsMacro] ([id])
    GO
    ALTER TABLE [dbo].[cmsMacroProperty] CHECK CONSTRAINT [FK_cmsMacroProperty_cmsMacro_id]
    GO
    ALTER TABLE [dbo].[cmsMedia]  WITH NOCHECK ADD  CONSTRAINT [FK_cmsMedia_cmsContent_nodeId] FOREIGN KEY([nodeId])
    REFERENCES [dbo].[cmsContent] ([nodeId])
    GO
    ALTER TABLE [dbo].[cmsMedia] CHECK CONSTRAINT [FK_cmsMedia_cmsContent_nodeId]
    GO
    ALTER TABLE [dbo].[cmsMedia]  WITH NOCHECK ADD  CONSTRAINT [FK_cmsMedia_umbracoNode_id] FOREIGN KEY([nodeId])
    REFERENCES [dbo].[umbracoNode] ([id])
    GO
    ALTER TABLE [dbo].[cmsMedia] CHECK CONSTRAINT [FK_cmsMedia_umbracoNode_id]
    GO
    ALTER TABLE [dbo].[cmsMember]  WITH CHECK ADD  CONSTRAINT [FK_cmsMember_cmsContent_nodeId] FOREIGN KEY([nodeId])
    REFERENCES [dbo].[cmsContent] ([nodeId])
    GO
    ALTER TABLE [dbo].[cmsMember] CHECK CONSTRAINT [FK_cmsMember_cmsContent_nodeId]
    GO
    ALTER TABLE [dbo].[cmsMember]  WITH CHECK ADD  CONSTRAINT [FK_cmsMember_umbracoNode_id] FOREIGN KEY([nodeId])
    REFERENCES [dbo].[umbracoNode] ([id])
    GO
    ALTER TABLE [dbo].[cmsMember] CHECK CONSTRAINT [FK_cmsMember_umbracoNode_id]
    GO
    ALTER TABLE [dbo].[cmsMember2MemberGroup]  WITH CHECK ADD  CONSTRAINT [FK_cmsMember2MemberGroup_cmsMember_nodeId] FOREIGN KEY([Member])
    REFERENCES [dbo].[cmsMember] ([nodeId])
    GO
    ALTER TABLE [dbo].[cmsMember2MemberGroup] CHECK CONSTRAINT [FK_cmsMember2MemberGroup_cmsMember_nodeId]
    GO
    ALTER TABLE [dbo].[cmsMember2MemberGroup]  WITH CHECK ADD  CONSTRAINT [FK_cmsMember2MemberGroup_umbracoNode_id] FOREIGN KEY([MemberGroup])
    REFERENCES [dbo].[umbracoNode] ([id])
    GO
    ALTER TABLE [dbo].[cmsMember2MemberGroup] CHECK CONSTRAINT [FK_cmsMember2MemberGroup_umbracoNode_id]
    GO
    ALTER TABLE [dbo].[cmsMemberType]  WITH CHECK ADD  CONSTRAINT [FK_cmsMemberType_cmsContentType_nodeId] FOREIGN KEY([NodeId])
    REFERENCES [dbo].[cmsContentType] ([nodeId])
    GO
    ALTER TABLE [dbo].[cmsMemberType] CHECK CONSTRAINT [FK_cmsMemberType_cmsContentType_nodeId]
    GO
    ALTER TABLE [dbo].[cmsMemberType]  WITH CHECK ADD  CONSTRAINT [FK_cmsMemberType_umbracoNode_id] FOREIGN KEY([NodeId])
    REFERENCES [dbo].[umbracoNode] ([id])
    GO
    ALTER TABLE [dbo].[cmsMemberType] CHECK CONSTRAINT [FK_cmsMemberType_umbracoNode_id]
    GO
    ALTER TABLE [dbo].[cmsPreviewXml]  WITH CHECK ADD  CONSTRAINT [FK_cmsPreviewXml_cmsContent_nodeId] FOREIGN KEY([nodeId])
    REFERENCES [dbo].[cmsContent] ([nodeId])
    GO
    ALTER TABLE [dbo].[cmsPreviewXml] CHECK CONSTRAINT [FK_cmsPreviewXml_cmsContent_nodeId]
    GO
    ALTER TABLE [dbo].[cmsPreviewXml]  WITH CHECK ADD  CONSTRAINT [FK_cmsPreviewXml_cmsContentVersion_VersionId] FOREIGN KEY([versionId])
    REFERENCES [dbo].[cmsContentVersion] ([VersionId])
    GO
    ALTER TABLE [dbo].[cmsPreviewXml] CHECK CONSTRAINT [FK_cmsPreviewXml_cmsContentVersion_VersionId]
    GO
    ALTER TABLE [dbo].[cmsPropertyData]  WITH CHECK ADD  CONSTRAINT [FK_cmsPropertyData_cmsPropertyType_id] FOREIGN KEY([propertytypeid])
    REFERENCES [dbo].[cmsPropertyType] ([id])
    GO
    ALTER TABLE [dbo].[cmsPropertyData] CHECK CONSTRAINT [FK_cmsPropertyData_cmsPropertyType_id]
    GO
    ALTER TABLE [dbo].[cmsPropertyData]  WITH CHECK ADD  CONSTRAINT [FK_cmsPropertyData_umbracoNode_id] FOREIGN KEY([contentNodeId])
    REFERENCES [dbo].[umbracoNode] ([id])
    GO
    ALTER TABLE [dbo].[cmsPropertyData] CHECK CONSTRAINT [FK_cmsPropertyData_umbracoNode_id]
    GO
    ALTER TABLE [dbo].[cmsPropertyType]  WITH CHECK ADD  CONSTRAINT [FK_cmsPropertyType_cmsContentType_nodeId] FOREIGN KEY([contentTypeId])
    REFERENCES [dbo].[cmsContentType] ([nodeId])
    GO
    ALTER TABLE [dbo].[cmsPropertyType] CHECK CONSTRAINT [FK_cmsPropertyType_cmsContentType_nodeId]
    GO
    ALTER TABLE [dbo].[cmsPropertyType]  WITH CHECK ADD  CONSTRAINT [FK_cmsPropertyType_cmsDataType_nodeId] FOREIGN KEY([dataTypeId])
    REFERENCES [dbo].[cmsDataType] ([nodeId])
    GO
    ALTER TABLE [dbo].[cmsPropertyType] CHECK CONSTRAINT [FK_cmsPropertyType_cmsDataType_nodeId]
    GO
    ALTER TABLE [dbo].[cmsPropertyType]  WITH CHECK ADD  CONSTRAINT [FK_cmsPropertyType_cmsPropertyTypeGroup_id] FOREIGN KEY([propertyTypeGroupId])
    REFERENCES [dbo].[cmsPropertyTypeGroup] ([id])
    GO
    ALTER TABLE [dbo].[cmsPropertyType] CHECK CONSTRAINT [FK_cmsPropertyType_cmsPropertyTypeGroup_id]
    GO
    ALTER TABLE [dbo].[cmsPropertyTypeGroup]  WITH CHECK ADD  CONSTRAINT [FK_cmsPropertyTypeGroup_cmsContentType_nodeId] FOREIGN KEY([contenttypeNodeId])
    REFERENCES [dbo].[cmsContentType] ([nodeId])
    GO
    ALTER TABLE [dbo].[cmsPropertyTypeGroup] CHECK CONSTRAINT [FK_cmsPropertyTypeGroup_cmsContentType_nodeId]
    GO
    ALTER TABLE [dbo].[cmsTagRelationship]  WITH CHECK ADD  CONSTRAINT [FK_cmsTagRelationship_cmsContent] FOREIGN KEY([nodeId])
    REFERENCES [dbo].[cmsContent] ([nodeId])
    GO
    ALTER TABLE [dbo].[cmsTagRelationship] CHECK CONSTRAINT [FK_cmsTagRelationship_cmsContent]
    GO
    ALTER TABLE [dbo].[cmsTagRelationship]  WITH CHECK ADD  CONSTRAINT [FK_cmsTagRelationship_cmsPropertyType] FOREIGN KEY([propertyTypeId])
    REFERENCES [dbo].[cmsPropertyType] ([id])
    GO
    ALTER TABLE [dbo].[cmsTagRelationship] CHECK CONSTRAINT [FK_cmsTagRelationship_cmsPropertyType]
    GO
    ALTER TABLE [dbo].[cmsTagRelationship]  WITH CHECK ADD  CONSTRAINT [FK_cmsTagRelationship_cmsTags_id] FOREIGN KEY([tagId])
    REFERENCES [dbo].[cmsTags] ([id])
    GO
    ALTER TABLE [dbo].[cmsTagRelationship] CHECK CONSTRAINT [FK_cmsTagRelationship_cmsTags_id]
    GO
    ALTER TABLE [dbo].[cmsTags]  WITH CHECK ADD  CONSTRAINT [FK_cmsTags_cmsTags] FOREIGN KEY([ParentId])
    REFERENCES [dbo].[cmsTags] ([id])
    GO
    ALTER TABLE [dbo].[cmsTags] CHECK CONSTRAINT [FK_cmsTags_cmsTags]
    GO
    ALTER TABLE [dbo].[cmsTask]  WITH CHECK ADD  CONSTRAINT [FK_cmsTask_cmsTaskType_id] FOREIGN KEY([taskTypeId])
    REFERENCES [dbo].[cmsTaskType] ([id])
    GO
    ALTER TABLE [dbo].[cmsTask] CHECK CONSTRAINT [FK_cmsTask_cmsTaskType_id]
    GO
    ALTER TABLE [dbo].[cmsTask]  WITH CHECK ADD  CONSTRAINT [FK_cmsTask_umbracoNode_id] FOREIGN KEY([nodeId])
    REFERENCES [dbo].[umbracoNode] ([id])
    GO
    ALTER TABLE [dbo].[cmsTask] CHECK CONSTRAINT [FK_cmsTask_umbracoNode_id]
    GO
    ALTER TABLE [dbo].[cmsTask]  WITH CHECK ADD  CONSTRAINT [FK_cmsTask_umbracoUser] FOREIGN KEY([parentUserId])
    REFERENCES [dbo].[umbracoUser] ([id])
    GO
    ALTER TABLE [dbo].[cmsTask] CHECK CONSTRAINT [FK_cmsTask_umbracoUser]
    GO
    ALTER TABLE [dbo].[cmsTask]  WITH CHECK ADD  CONSTRAINT [FK_cmsTask_umbracoUser1] FOREIGN KEY([userId])
    REFERENCES [dbo].[umbracoUser] ([id])
    GO
    ALTER TABLE [dbo].[cmsTask] CHECK CONSTRAINT [FK_cmsTask_umbracoUser1]
    GO
    ALTER TABLE [dbo].[cmsTemplate]  WITH CHECK ADD  CONSTRAINT [FK_cmsTemplate_umbracoNode] FOREIGN KEY([nodeId])
    REFERENCES [dbo].[umbracoNode] ([id])
    GO
    ALTER TABLE [dbo].[cmsTemplate] CHECK CONSTRAINT [FK_cmsTemplate_umbracoNode]
    GO
    ALTER TABLE [dbo].[UFRecordDataBit]  WITH CHECK ADD  CONSTRAINT [FK_UFRecordDataBit_UFRecordFields_Key] FOREIGN KEY([Key])
    REFERENCES [dbo].[UFRecordFields] ([Key])
    GO
    ALTER TABLE [dbo].[UFRecordDataBit] CHECK CONSTRAINT [FK_UFRecordDataBit_UFRecordFields_Key]
    GO
    ALTER TABLE [dbo].[UFRecordDataDateTime]  WITH CHECK ADD  CONSTRAINT [FK_UFRecordDataDateTime_UFRecordFields_Key] FOREIGN KEY([Key])
    REFERENCES [dbo].[UFRecordFields] ([Key])
    GO
    ALTER TABLE [dbo].[UFRecordDataDateTime] CHECK CONSTRAINT [FK_UFRecordDataDateTime_UFRecordFields_Key]
    GO
    ALTER TABLE [dbo].[UFRecordDataInteger]  WITH CHECK ADD  CONSTRAINT [FK_UFRecordDataInteger_UFRecordFields_Key] FOREIGN KEY([Key])
    REFERENCES [dbo].[UFRecordFields] ([Key])
    GO
    ALTER TABLE [dbo].[UFRecordDataInteger] CHECK CONSTRAINT [FK_UFRecordDataInteger_UFRecordFields_Key]
    GO
    ALTER TABLE [dbo].[UFRecordDataLongString]  WITH CHECK ADD  CONSTRAINT [FK_UFRecordDataLongString_UFRecordFields_Key] FOREIGN KEY([Key])
    REFERENCES [dbo].[UFRecordFields] ([Key])
    GO
    ALTER TABLE [dbo].[UFRecordDataLongString] CHECK CONSTRAINT [FK_UFRecordDataLongString_UFRecordFields_Key]
    GO
    ALTER TABLE [dbo].[UFRecordDataString]  WITH CHECK ADD  CONSTRAINT [FK_UFRecordDataString_UFRecordFields_Key] FOREIGN KEY([Key])
    REFERENCES [dbo].[UFRecordFields] ([Key])
    GO
    ALTER TABLE [dbo].[UFRecordDataString] CHECK CONSTRAINT [FK_UFRecordDataString_UFRecordFields_Key]
    GO
    ALTER TABLE [dbo].[umbracoAccess]  WITH CHECK ADD  CONSTRAINT [FK_umbracoAccess_umbracoNode_id] FOREIGN KEY([nodeId])
    REFERENCES [dbo].[umbracoNode] ([id])
    GO
    ALTER TABLE [dbo].[umbracoAccess] CHECK CONSTRAINT [FK_umbracoAccess_umbracoNode_id]
    GO
    ALTER TABLE [dbo].[umbracoAccess]  WITH CHECK ADD  CONSTRAINT [FK_umbracoAccess_umbracoNode_id1] FOREIGN KEY([loginNodeId])
    REFERENCES [dbo].[umbracoNode] ([id])
    GO
    ALTER TABLE [dbo].[umbracoAccess] CHECK CONSTRAINT [FK_umbracoAccess_umbracoNode_id1]
    GO
    ALTER TABLE [dbo].[umbracoAccess]  WITH CHECK ADD  CONSTRAINT [FK_umbracoAccess_umbracoNode_id2] FOREIGN KEY([noAccessNodeId])
    REFERENCES [dbo].[umbracoNode] ([id])
    GO
    ALTER TABLE [dbo].[umbracoAccess] CHECK CONSTRAINT [FK_umbracoAccess_umbracoNode_id2]
    GO
    ALTER TABLE [dbo].[umbracoAccessRule]  WITH CHECK ADD  CONSTRAINT [FK_umbracoAccessRule_umbracoAccess_id] FOREIGN KEY([accessId])
    REFERENCES [dbo].[umbracoAccess] ([id])
    GO
    ALTER TABLE [dbo].[umbracoAccessRule] CHECK CONSTRAINT [FK_umbracoAccessRule_umbracoAccess_id]
    GO
    ALTER TABLE [dbo].[umbracoDomains]  WITH CHECK ADD  CONSTRAINT [FK_umbracoDomains_umbracoNode_id] FOREIGN KEY([domainRootStructureID])
    REFERENCES [dbo].[umbracoNode] ([id])
    GO
    ALTER TABLE [dbo].[umbracoDomains] CHECK CONSTRAINT [FK_umbracoDomains_umbracoNode_id]
    GO
    ALTER TABLE [dbo].[umbracoExternalLogin]  WITH CHECK ADD  CONSTRAINT [FK_umbracoExternalLogin_umbracoUser_id] FOREIGN KEY([userId])
    REFERENCES [dbo].[umbracoUser] ([id])
    GO
    ALTER TABLE [dbo].[umbracoExternalLogin] CHECK CONSTRAINT [FK_umbracoExternalLogin_umbracoUser_id]
    GO
    ALTER TABLE [dbo].[umbracoNode]  WITH CHECK ADD  CONSTRAINT [FK_umbracoNode_umbracoNode_id] FOREIGN KEY([parentID])
    REFERENCES [dbo].[umbracoNode] ([id])
    GO
    ALTER TABLE [dbo].[umbracoNode] CHECK CONSTRAINT [FK_umbracoNode_umbracoNode_id]
    GO
    ALTER TABLE [dbo].[umbracoRedirectUrl]  WITH CHECK ADD  CONSTRAINT [FK_umbracoRedirectUrl] FOREIGN KEY([contentKey])
    REFERENCES [dbo].[umbracoNode] ([uniqueID])
    GO
    ALTER TABLE [dbo].[umbracoRedirectUrl] CHECK CONSTRAINT [FK_umbracoRedirectUrl]
    GO
    ALTER TABLE [dbo].[umbracoRelation]  WITH CHECK ADD  CONSTRAINT [FK_umbracoRelation_umbracoNode] FOREIGN KEY([parentId])
    REFERENCES [dbo].[umbracoNode] ([id])
    GO
    ALTER TABLE [dbo].[umbracoRelation] CHECK CONSTRAINT [FK_umbracoRelation_umbracoNode]
    GO
    ALTER TABLE [dbo].[umbracoRelation]  WITH CHECK ADD  CONSTRAINT [FK_umbracoRelation_umbracoNode1] FOREIGN KEY([childId])
    REFERENCES [dbo].[umbracoNode] ([id])
    GO
    ALTER TABLE [dbo].[umbracoRelation] CHECK CONSTRAINT [FK_umbracoRelation_umbracoNode1]
    GO
    ALTER TABLE [dbo].[umbracoRelation]  WITH CHECK ADD  CONSTRAINT [FK_umbracoRelation_umbracoRelationType_id] FOREIGN KEY([relType])
    REFERENCES [dbo].[umbracoRelationType] ([id])
    GO
    ALTER TABLE [dbo].[umbracoRelation] CHECK CONSTRAINT [FK_umbracoRelation_umbracoRelationType_id]
    GO
    ALTER TABLE [dbo].[umbracoUser2NodeNotify]  WITH CHECK ADD  CONSTRAINT [FK_umbracoUser2NodeNotify_umbracoNode_id] FOREIGN KEY([nodeId])
    REFERENCES [dbo].[umbracoNode] ([id])
    GO
    ALTER TABLE [dbo].[umbracoUser2NodeNotify] CHECK CONSTRAINT [FK_umbracoUser2NodeNotify_umbracoNode_id]
    GO
    ALTER TABLE [dbo].[umbracoUser2NodeNotify]  WITH CHECK ADD  CONSTRAINT [FK_umbracoUser2NodeNotify_umbracoUser_id] FOREIGN KEY([userId])
    REFERENCES [dbo].[umbracoUser] ([id])
    GO
    ALTER TABLE [dbo].[umbracoUser2NodeNotify] CHECK CONSTRAINT [FK_umbracoUser2NodeNotify_umbracoUser_id]
    GO
    ALTER TABLE [dbo].[umbracoUser2UserGroup]  WITH CHECK ADD  CONSTRAINT [FK_umbracoUser2UserGroup_umbracoUser_id] FOREIGN KEY([userId])
    REFERENCES [dbo].[umbracoUser] ([id])
    GO
    ALTER TABLE [dbo].[umbracoUser2UserGroup] CHECK CONSTRAINT [FK_umbracoUser2UserGroup_umbracoUser_id]
    GO
    ALTER TABLE [dbo].[umbracoUser2UserGroup]  WITH CHECK ADD  CONSTRAINT [FK_umbracoUser2UserGroup_umbracoUserGroup_id] FOREIGN KEY([userGroupId])
    REFERENCES [dbo].[umbracoUserGroup] ([id])
    GO
    ALTER TABLE [dbo].[umbracoUser2UserGroup] CHECK CONSTRAINT [FK_umbracoUser2UserGroup_umbracoUserGroup_id]
    GO
    ALTER TABLE [dbo].[umbracoUserGroup]  WITH CHECK ADD  CONSTRAINT [FK_startContentId_umbracoNode_id] FOREIGN KEY([startContentId])
    REFERENCES [dbo].[umbracoNode] ([id])
    GO
    ALTER TABLE [dbo].[umbracoUserGroup] CHECK CONSTRAINT [FK_startContentId_umbracoNode_id]
    GO
    ALTER TABLE [dbo].[umbracoUserGroup]  WITH CHECK ADD  CONSTRAINT [FK_startMediaId_umbracoNode_id] FOREIGN KEY([startMediaId])
    REFERENCES [dbo].[umbracoNode] ([id])
    GO
    ALTER TABLE [dbo].[umbracoUserGroup] CHECK CONSTRAINT [FK_startMediaId_umbracoNode_id]
    GO
    ALTER TABLE [dbo].[umbracoUserGroup2App]  WITH CHECK ADD  CONSTRAINT [FK_umbracoUserGroup2App_umbracoUserGroup_id] FOREIGN KEY([userGroupId])
    REFERENCES [dbo].[umbracoUserGroup] ([id])
    GO
    ALTER TABLE [dbo].[umbracoUserGroup2App] CHECK CONSTRAINT [FK_umbracoUserGroup2App_umbracoUserGroup_id]
    GO
    ALTER TABLE [dbo].[umbracoUserGroup2NodePermission]  WITH CHECK ADD  CONSTRAINT [FK_umbracoUserGroup2NodePermission_umbracoNode_id] FOREIGN KEY([nodeId])
    REFERENCES [dbo].[umbracoNode] ([id])
    GO
    ALTER TABLE [dbo].[umbracoUserGroup2NodePermission] CHECK CONSTRAINT [FK_umbracoUserGroup2NodePermission_umbracoNode_id]
    GO
    ALTER TABLE [dbo].[umbracoUserGroup2NodePermission]  WITH CHECK ADD  CONSTRAINT [FK_umbracoUserGroup2NodePermission_umbracoUserGroup_id] FOREIGN KEY([userGroupId])
    REFERENCES [dbo].[umbracoUserGroup] ([id])
    GO
    ALTER TABLE [dbo].[umbracoUserGroup2NodePermission] CHECK CONSTRAINT [FK_umbracoUserGroup2NodePermission_umbracoUserGroup_id]
    GO
    ALTER TABLE [dbo].[umbracoUserLogin]  WITH CHECK ADD  CONSTRAINT [FK_umbracoUserLogin_umbracoUser_id] FOREIGN KEY([userId])
    REFERENCES [dbo].[umbracoUser] ([id])
    GO
    ALTER TABLE [dbo].[umbracoUserLogin] CHECK CONSTRAINT [FK_umbracoUserLogin_umbracoUser_id]
    GO
    ALTER TABLE [dbo].[umbracoUserStartNode]  WITH CHECK ADD  CONSTRAINT [FK_umbracoUserStartNode_umbracoNode_id] FOREIGN KEY([startNode])
    REFERENCES [dbo].[umbracoNode] ([id])
    GO
    ALTER TABLE [dbo].[umbracoUserStartNode] CHECK CONSTRAINT [FK_umbracoUserStartNode_umbracoNode_id]
    GO
    ALTER TABLE [dbo].[umbracoUserStartNode]  WITH CHECK ADD  CONSTRAINT [FK_umbracoUserStartNode_umbracoUser_id] FOREIGN KEY([userId])
    REFERENCES [dbo].[umbracoUser] ([id])
    GO
    ALTER TABLE [dbo].[umbracoUserStartNode] CHECK CONSTRAINT [FK_umbracoUserStartNode_umbracoUser_id]
    GO
    USE [master]
    GO
    
  • Andreas 7 posts 77 karma points
    Aug 16, 2018 @ 10:14
    Andreas
    0

    Hi,

    Just wanted to confirm that I have the exact same problem, I upgraded from 7.4 initially.

    Was able to upgrade all the way to 7.11 without any problems. but with 7.12 I got the same constraint problem.

    Best regards Andreas

  • Sebastiaan Janssen 5060 posts 15522 karma points MVP admin hq
    Aug 16, 2018 @ 10:18
    Sebastiaan Janssen
    100

    Cheers guys! We've found a fix but we're not sure yet what the cause is, it shouldn't have been a constraint but "just" an index. Maybe 7.4 did something differently, I can test that out later. Anyway, the fix is in review now:

    https://github.com/umbraco/Umbraco-CMS/pull/2857

    We're planning to release 7.12.1 next week to solve this problem.

  • M N 125 posts 212 karma points
    Aug 16, 2018 @ 15:21
    M N
    0

    Wow, you made quick work of this one. Thanks Sebastiaan, we'll watch for the minor release and will confirm it's working.

    Thanks again!

  • Sebastiaan Janssen 5060 posts 15522 karma points MVP admin hq
    Aug 17, 2018 @ 06:31
    Sebastiaan Janssen
    0

    No worries!

    Just want to report back that this strange problem has uncovered bugs that have been in the codebase for 6 years, so thanks very much for the help in discovering them 💪 and I'm happy to report this is now all fixed! 👍

  • M N 125 posts 212 karma points
    Aug 17, 2018 @ 17:20
    M N
    0

    Oh man, brutal. Glad I could help introduce some headaches into your life lol.

    Really nice work hunting that down, Sebastiaan.

    Cheers! 🍻

  • Andreas 7 posts 77 karma points
    Aug 22, 2018 @ 19:59
    Andreas
    0

    Hi again

    I just updated to 7.12.1 and now the update went through as expected.

    But when I run the integrity check in the back office I now see 22 problems (22 problems were detected with your database schema (Check the log for details)) :

    How do I resolve those errors and fix the database schema?

    Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Some errors were detected while validating the database schema against the current version of Umbraco. 2018-08-22 21:53:22,508 [P3760/D11/T194] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKumbracoRedirectUrl 2018-08-22 21:53:22,510 [P3760/D11/T194] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsContentcmsContentTypenodeId 2018-08-22 21:53:22,511 [P3760/D11/T194] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsContentVersioncmsContentnodeId 2018-08-22 21:53:22,515 [P3760/D11/T194] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsDocumentcmsContentnodeId 2018-08-22 21:53:22,516 [P3760/D11/T194] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsDocumentcmsTemplatenodeId 2018-08-22 21:53:22,517 [P3760/D11/T194] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsDocumentTypecmsContentTypenodeId 2018-08-22 21:53:22,518 [P3760/D11/T194] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsDocumentTypecmsTemplatenodeId 2018-08-22 21:53:22,519 [P3760/D11/T194] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsDataTypePreValuescmsDataTypenodeId 2018-08-22 21:53:22,519 [P3760/D11/T194] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsDictionarycmsDictionaryid 2018-08-22 21:53:22,520 [P3760/D11/T194] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsLanguageTextcmsDictionaryid 2018-08-22 21:53:22,520 [P3760/D11/T194] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsMemberTypecmsContentTypenodeId 2018-08-22 21:53:22,521 [P3760/D11/T194] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsMembercmsContentnodeId 2018-08-22 21:53:22,521 [P3760/D11/T194] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsContentXmlcmsContentnodeId 2018-08-22 21:53:22,522 [P3760/D11/T194] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsPreviewXmlcmsContentnodeId 2018-08-22 21:53:22,522 [P3760/D11/T194] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsPreviewXmlcmsContentVersionVersionId 2018-08-22 21:53:22,523 [P3760/D11/T194] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsPropertyTypeGroupcmsContentTypenodeId 2018-08-22 21:53:22,524 [P3760/D11/T194] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsPropertyTypecmsDataTypenodeId 2018-08-22 21:53:22,524 [P3760/D11/T194] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsPropertyTypecmsContentTypenodeId 2018-08-22 21:53:22,524 [P3760/D11/T194] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsTagRelationshipcmsContent 2018-08-22 21:53:22,525 [P3760/D11/T194] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsContentTypeAllowedContentTypecmsContentType 2018-08-22 21:53:22,525 [P3760/D11/T194] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsContentTypeAllowedContentTypecmsContentType1 2018-08-22 21:53:22,526 [P3760/D11/T194] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKumbracoRedirectUrlumbracoNodeuniqueID 2018-08-22 21:53:26,228 [P3760/D11/T96] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Some errors were detected while validating the database schema against the current version of Umbraco. 2018-08-22 21:53:26,229 [P3760/D11/T96] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKumbracoRedirectUrl 2018-08-22 21:53:26,229 [P3760/D11/T96] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsContentcmsContentTypenodeId 2018-08-22 21:53:26,230 [P3760/D11/T96] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsContentVersioncmsContentnodeId 2018-08-22 21:53:26,230 [P3760/D11/T96] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsDocumentcmsContentnodeId 2018-08-22 21:53:26,230 [P3760/D11/T96] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsDocumentcmsTemplatenodeId 2018-08-22 21:53:26,231 [P3760/D11/T96] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsDocumentTypecmsContentTypenodeId 2018-08-22 21:53:26,231 [P3760/D11/T96] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsDocumentTypecmsTemplatenodeId 2018-08-22 21:53:26,232 [P3760/D11/T96] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsDataTypePreValuescmsDataTypenodeId 2018-08-22 21:53:26,232 [P3760/D11/T96] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsDictionarycmsDictionaryid 2018-08-22 21:53:26,233 [P3760/D11/T96] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsLanguageTextcmsDictionaryid 2018-08-22 21:53:26,233 [P3760/D11/T96] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsMemberTypecmsContentTypenodeId 2018-08-22 21:53:26,234 [P3760/D11/T96] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsMembercmsContentnodeId 2018-08-22 21:53:26,234 [P3760/D11/T96] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsContentXmlcmsContentnodeId 2018-08-22 21:53:26,234 [P3760/D11/T96] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsPreviewXmlcmsContentnodeId 2018-08-22 21:53:26,235 [P3760/D11/T96] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsPreviewXmlcmsContentVersionVersionId 2018-08-22 21:53:26,235 [P3760/D11/T96] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsPropertyTypeGroupcmsContentTypenodeId 2018-08-22 21:53:26,235 [P3760/D11/T96] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsPropertyTypecmsDataTypenodeId 2018-08-22 21:53:26,236 [P3760/D11/T96] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsPropertyTypecmsContentTypenodeId 2018-08-22 21:53:26,236 [P3760/D11/T96] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsTagRelationshipcmsContent 2018-08-22 21:53:26,236 [P3760/D11/T96] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsContentTypeAllowedContentTypecmsContentType 2018-08-22 21:53:26,237 [P3760/D11/T96] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKcmsContentTypeAllowedContentTypecmsContentType1 2018-08-22 21:53:26,237 [P3760/D11/T96] WARN Umbraco.Web.HealthCheck.Checks.DataIntegrity.DatabaseSchemaValidationHealthCheck - Constraint: FKumbracoRedirectUrlumbracoNodeuniqueID

  • M N 125 posts 212 karma points
    Aug 24, 2018 @ 23:49
    M N
    0

    I just upgraded to 7.12.1 and everything looks good. Saw the fix fly by in the logs during upgrade process

     2018-08-24 19:38:10,095 [P37340/D3/T10] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 4: ALTER TABLE [umbracoLanguage] DROP CONSTRAINT [IX_umbracoLanguage_languageISOCode]
    
     2018-08-24 19:38:10,228 [P37340/D3/T10] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 6: ALTER TABLE [umbracoLanguage] ALTER COLUMN [languageISOCode] NVARCHAR(14) NULL
    
     2018-08-24 19:38:10,280 [P37340/D3/T10] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - Executing sql statement 7: CREATE UNIQUE NONCLUSTERED INDEX [IX_umbracoLanguage_languageISOCode] ON [umbracoLanguage] ([languageISOCode])
    

    Andreas - not experiencing those particular schema issues, but I do actually see a schema error now on 7.12.1. I checked on 7.11 and this error is new to me as of 7.12.1

    enter image description here

  • M N 125 posts 212 karma points
    Aug 24, 2018 @ 23:57
    M N
    0

    PS are you seeing this on your audit trails in the info tab? Bumped the dependency config and the usual clearing of caches and examine but this still doesn't render properly

    enter image description here

  • Marc Goodson 2155 posts 14408 karma points MVP 9x c-trib
    Aug 25, 2018 @ 09:37
    Marc Goodson
    0

    Hi M N

    When you get the square brackets like this in the backoffice, it means Umbraco is trying to read the text stored with that key from the language files.

    The language files are situated in /umbraco/config/Lang

    and an xml file exists for each language, (depending on the culture of your User account, depends on which file will be used to translate the backoffice for you)

    After an upgrade, if you have square brackets for language items, check that you have the latest version of the lang files for the version you have upgraded to... and that these language file 'key' exist in those files.

    enter image description here

  • M N 125 posts 212 karma points
    Aug 27, 2018 @ 20:33
    M N
    0

    Hi Marc,

    Thanks for your reply. If only :)

    I should have mentioned that was the first thing I did, among many other fix attempts, along with client dependency bump after any attempt. Grabbed the files directly from the 7.12.1 zip.

    I have encountered this before, and it's usually as easy as you describe.. However, this version nothing works for United States. I have tried

    1. Overwriting Umbraco folders (including Lang of course)
    2. Diffed en.xml and en_us.xml PS - <key alias="assignDomain">Manage hostnames</key> only exists in UK line 346? extraneous?
    3. Delete entire /temp , cleared cache, rebuild indexes I even tried this https://our.umbraco.com/forum/using-umbraco-and-getting-started/89808-umbraco-backoffice-not-showing-correct-language
    4. Create new IIS Express app on a new port
    5. Clear cookies

    If I change my user to UK - it does work.. Naturally I blasted the en_us with en.xml but this did nothing.

    Nothing works. US English does not work for certain labels, including Audit, the new Anchor selector in RTE's, and of all things a random string on the login screen enter image description here- beyond baffeling considering these all worked fine prior to the upgrade.

    Going to roll back to 7.11. I've tried to do my diligence on this issue, but out of ideas. Just thought I would share in case it helps someone. Plus the schema issue above is a bit disconcerting.

    -Marc

    The new anchor functionality - not 100% sure how this was supposed to work. Is it just a text field? enter image description here

  • Sebastiaan Janssen 5060 posts 15522 karma points MVP admin hq
    Aug 28, 2018 @ 05:52
    Sebastiaan Janssen
    0

    In your web.config, do you have targetFramework="4.5" in the httpruntime section? If it's set higher than 4.5.2 we've seen odd translation behavior before.

    Naturally I blasted the en_us with en.xml but this did nothing.

    It wouldn't, since we look for the correct language from the culture attribute in this node of each file:

    <language alias="en_us" intName="English (US)" localName="English (US)" lcid="" culture="en-US">
    

    When changing language files, I believe either a bump of the web.config or ClientDependency.config is necessary to see changes.

  • M N 125 posts 212 karma points
    Nov 29, 2018 @ 21:27
    M N
    0

    Hi Sebastiaan,

    Thank you for your reply, very sorry for late reply. This has continued to happen on all our sites I've upgraded to 7.12+ except one site that was 7.5.11 and I went directly to 7.12.4 (which was exciting to see it finally work).

    Either way, runtime is set to 4.5

    Someone also just posted this same issue here https://our.umbraco.com/forum/using-umbraco-and-getting-started/94800-missing-translations

    Thought it might be easier to move this conversation there.. but I as I mentioned there, I've just kind of lived with this for the time being.

Please Sign in or register to post replies

Write your reply to:

Draft