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.
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.
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.
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.
You only need to generate the schema here.
Do you know what the oldest version was that you've ever upgraded this install from?
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
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:
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! 👍
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?
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
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
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.
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
Overwriting Umbraco folders (including Lang of course)
Diffed
en.xml and en_us.xml PS - <key alias="assignDomain">Manage
hostnames</key> only exists in UK line 346? extraneous?
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 - 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?
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:
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).
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.
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.
Did some basic regression testing and everything seems to be working fine, no mysterious errors in the log files.
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.
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.
You only need to generate the schema here.
Do you know what the oldest version was that you've ever upgraded this install from?
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.
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
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.
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!
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! 👍
Oh man, brutal. Glad I could help introduce some headaches into your life lol.
Really nice work hunting that down, Sebastiaan.
Cheers! 🍻
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
I just upgraded to 7.12.1 and everything looks good. Saw the fix fly by in the logs during upgrade process
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
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
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.
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
en.xmlanden_us.xmlPS -<key alias="assignDomain">Manage hostnames</key>only exists in UK line 346? extraneous?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
- 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?
In your web.config, do you have
targetFramework="4.5"in thehttpruntimesection? If it's set higher than 4.5.2 we've seen odd translation behavior before.It wouldn't, since we look for the correct language from the culture attribute in this node of each file:
When changing language files, I believe either a bump of the web.config or ClientDependency.config is necessary to see changes.
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.
is working on a reply...