RuleSoft Support Portal

/****** Object:  Table [dbo].[Core_Nodes]    Script Date: 2020-12-29 8:45:21 PM ******/
SET ANSI_NULLS ON
GO


SET QUOTED_IDENTIFIER ON
GO


CREATE TABLE [dbo].[Core_Nodes](
    [NodeSID] [bigint] NOT NULL,
    [ParentNodeSID] [bigint] NULL,
    [Sequence] [float] NULL,
    [TypeName] [nvarchar](100) NULL,
    [Name] [nvarchar](100) NULL,
    [DeletedFlag] [tinyint] NOT NULL,
    [ModifiedUserSID] [bigint] NULL,
    [ModifiedDateTime] [datetimeoffset](7) NULL,
 CONSTRAINT [PK_Core_Nodes] PRIMARY KEY CLUSTERED 
(
    [NodeSID] 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].[Core_Nodes_History]    Script Date: 2020-12-29 8:45:21 PM ******/
SET ANSI_NULLS ON
GO


SET QUOTED_IDENTIFIER ON
GO


CREATE TABLE [dbo].[Core_Nodes_History](
    [ChangeDT] [datetimeoffset](7) NOT NULL,
    [ByUserSID] [bigint] NOT NULL,
    [NodeSID] [bigint] NOT NULL,
    [ParentNodeSID] [bigint] NULL,
    [Sequence] [float] NULL,
    [TypeName] [nvarchar](100) NULL,
    [Name] [nvarchar](100) NULL,
    [DeletedFlag] [tinyint] NOT NULL,
    [ModifiedUserSID] [bigint] NULL,
    [ModifiedDateTime] [datetimeoffset](7) NULL,
 CONSTRAINT [PK_Core_Nodes_History] PRIMARY KEY CLUSTERED 
(
    [ChangeDT] ASC,
    [ByUserSID] ASC,
    [NodeSID] 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].[Core_Props]    Script Date: 2020-12-29 8:45:21 PM ******/
SET ANSI_NULLS ON
GO


SET QUOTED_IDENTIFIER ON
GO


CREATE TABLE [dbo].[Core_Props](
    [PropertySID] [bigint] NOT NULL,
    [NodeSID] [bigint] NULL,
    [Sequence] [float] NULL,
    [Name] [nvarchar](100) NOT NULL,
    [RefValueSID] [bigint] NULL,
    [DateTimeValue] [datetimeoffset](7) NULL,
    [NumericValue] [decimal](28, 9) NULL,
    [StringValue] [nvarchar](max) NULL,
    [ValueType] [nvarchar](100) NULL,
    [DeletedFlag] [tinyint] NOT NULL,
    [ModifiedUserSID] [bigint] NULL,
    [ModifiedDateTime] [datetimeoffset](7) NULL,
 CONSTRAINT [PK_Core_Props] PRIMARY KEY CLUSTERED 
(
    [PropertySID] 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].[Core_Props_History]    Script Date: 2020-12-29 8:45:21 PM ******/
SET ANSI_NULLS ON
GO


SET QUOTED_IDENTIFIER ON
GO


CREATE TABLE [dbo].[Core_Props_History](
    [ChangeDT] [datetimeoffset](7) NOT NULL,
    [ByUserSID] [bigint] NOT NULL,
    [PropertySID] [bigint] NOT NULL,
    [NodeSID] [bigint] NULL,
    [Sequence] [float] NULL,
    [Name] [nvarchar](100) NOT NULL,
    [RefValueSID] [bigint] NULL,
    [DateTimeValue] [datetimeoffset](7) NULL,
    [NumericValue] [decimal](28, 9) NULL,
    [StringValue] [nvarchar](max) NULL,
    [ValueType] [nvarchar](100) NULL,
    [DeletedFlag] [tinyint] NOT NULL,
    [ModifiedUserSID] [bigint] NULL,
    [ModifiedDateTime] [datetimeoffset](7) NULL,
 CONSTRAINT [PK_Core_Props_History] PRIMARY KEY CLUSTERED 
(
    [ChangeDT] ASC,
    [ByUserSID] ASC,
    [PropertySID] 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].[Image_Nodes]    Script Date: 2020-12-29 8:45:21 PM ******/
SET ANSI_NULLS ON
GO


SET QUOTED_IDENTIFIER ON
GO


CREATE TABLE [dbo].[Image_Nodes](
    [NodeSID] [bigint] NOT NULL,
    [ParentNodeSID] [bigint] NULL,
    [Sequence] [float] NULL,
    [TypeName] [nvarchar](100) NULL,
    [Name] [nvarchar](100) NULL,
    [DeletedFlag] [tinyint] NOT NULL CONSTRAINT [DF_Image_Nodes_DeletedFlag]  DEFAULT ((0)),
    [ModifiedUserSID] [bigint] NULL,
    [ModifiedDateTime] [datetimeoffset](7) NULL,
 CONSTRAINT [PK_Image_Nodes] PRIMARY KEY CLUSTERED 
(
    [NodeSID] 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].[Image_Nodes_History]    Script Date: 2020-12-29 8:45:21 PM ******/
SET ANSI_NULLS ON
GO


SET QUOTED_IDENTIFIER ON
GO


CREATE TABLE [dbo].[Image_Nodes_History](
    [ChangeDT] [datetimeoffset](7) NOT NULL,
    [ByUserSID] [bigint] NOT NULL,
    [NodeSID] [bigint] NOT NULL,
    [ParentNodeSID] [bigint] NULL,
    [Sequence] [float] NULL,
    [TypeName] [nvarchar](100) NULL,
    [Name] [nvarchar](100) NULL,
    [DeletedFlag] [tinyint] NOT NULL,
    [ModifiedUserSID] [bigint] NULL,
    [ModifiedDateTime] [datetimeoffset](7) NULL,
 CONSTRAINT [PK_Image_Nodes_History] PRIMARY KEY CLUSTERED 
(
    [ChangeDT] ASC,
    [ByUserSID] ASC,
    [NodeSID] 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].[Image_Props]    Script Date: 2020-12-29 8:45:21 PM ******/
SET ANSI_NULLS ON
GO


SET QUOTED_IDENTIFIER ON
GO


CREATE TABLE [dbo].[Image_Props](
    [PropertySID] [bigint] NOT NULL,
    [NodeSID] [bigint] NULL,
    [Sequence] [float] NULL,
    [Name] [nvarchar](100) NOT NULL,
    [RefValueSID] [bigint] NULL,
    [DateTimeValue] [datetimeoffset](7) NULL,
    [NumericValue] [decimal](28, 9) NULL,
    [StringValue] [nvarchar](max) NULL,
    [ValueType] [nvarchar](100) NULL,
    [DeletedFlag] [tinyint] NOT NULL CONSTRAINT [DF_Image_Props_DeletedFlag]  DEFAULT ((0)),
    [ModifiedUserSID] [bigint] NULL,
    [ModifiedDateTime] [datetimeoffset](7) NULL,
 CONSTRAINT [PK_Image_Props] PRIMARY KEY CLUSTERED 
(
    [PropertySID] 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].[Image_Props_History]    Script Date: 2020-12-29 8:45:21 PM ******/
SET ANSI_NULLS ON
GO


SET QUOTED_IDENTIFIER ON
GO


CREATE TABLE [dbo].[Image_Props_History](
    [ChangeDT] [datetimeoffset](7) NOT NULL,
    [ByUserSID] [bigint] NOT NULL,
    [PropertySID] [bigint] NOT NULL,
    [NodeSID] [bigint] NULL,
    [Sequence] [float] NULL,
    [Name] [nvarchar](100) NOT NULL,
    [RefValueSID] [bigint] NULL,
    [DateTimeValue] [datetimeoffset](7) NULL,
    [NumericValue] [decimal](28, 9) NULL,
    [StringValue] [nvarchar](max) NULL,
    [ValueType] [nvarchar](100) NULL,
    [DeletedFlag] [tinyint] NOT NULL CONSTRAINT [DF_Image_Props_History_DeletedFlag]  DEFAULT ((0)),
    [ModifiedUserSID] [bigint] NULL,
    [ModifiedDateTime] [datetimeoffset](7) NULL,
 CONSTRAINT [PK_Image_Props_History] PRIMARY KEY CLUSTERED 
(
    [ChangeDT] ASC,
    [ByUserSID] ASC,
    [PropertySID] 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].[Import_Nodes]    Script Date: 2020-12-29 8:45:21 PM ******/
SET ANSI_NULLS ON
GO


SET QUOTED_IDENTIFIER ON
GO


CREATE TABLE [dbo].[Import_Nodes](
    [NodeSID] [bigint] NOT NULL,
    [ParentNodeSID] [bigint] NULL,
    [Sequence] [float] NULL,
    [TypeName] [nvarchar](100) NULL,
    [Name] [nvarchar](100) NULL,
    [DeletedFlag] [tinyint] NOT NULL CONSTRAINT [DF_Import_Nodes_DeletedFlag]  DEFAULT ((0)),
    [ModifiedUserSID] [bigint] NULL,
    [ModifiedDateTime] [datetimeoffset](7) NULL,
 CONSTRAINT [PK_Import_Nodes] PRIMARY KEY CLUSTERED 
(
    [NodeSID] 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].[Import_Nodes_History]    Script Date: 2020-12-29 8:45:21 PM ******/
SET ANSI_NULLS ON
GO


SET QUOTED_IDENTIFIER ON
GO


CREATE TABLE [dbo].[Import_Nodes_History](
    [ChangeDT] [datetimeoffset](7) NOT NULL,
    [ByUserSID] [bigint] NOT NULL,
    [NodeSID] [bigint] NOT NULL,
    [ParentNodeSID] [bigint] NULL,
    [Sequence] [float] NULL,
    [TypeName] [nvarchar](100) NULL,
    [Name] [nvarchar](100) NULL,
    [DeletedFlag] [tinyint] NOT NULL,
    [ModifiedUserSID] [bigint] NULL,
    [ModifiedDateTime] [datetimeoffset](7) NULL,
 CONSTRAINT [PK_Import_Nodes_History] PRIMARY KEY CLUSTERED 
(
    [ChangeDT] ASC,
    [ByUserSID] ASC,
    [NodeSID] 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].[Import_Props]    Script Date: 2020-12-29 8:45:21 PM ******/
SET ANSI_NULLS ON
GO


SET QUOTED_IDENTIFIER ON
GO


CREATE TABLE [dbo].[Import_Props](
    [PropertySID] [bigint] NOT NULL,
    [NodeSID] [bigint] NULL,
    [Sequence] [float] NULL,
    [Name] [nvarchar](100) NOT NULL,
    [RefValueSID] [bigint] NULL,
    [DateTimeValue] [datetimeoffset](7) NULL,
    [NumericValue] [decimal](28, 9) NULL,
    [StringValue] [nvarchar](max) NULL,
    [ValueType] [nvarchar](100) NULL,
    [DeletedFlag] [tinyint] NOT NULL CONSTRAINT [DF_Import_Props_DeletedFlag]  DEFAULT ((0)),
    [ModifiedUserSID] [bigint] NULL,
    [ModifiedDateTime] [datetimeoffset](7) NULL,
 CONSTRAINT [PK_Import_Props] PRIMARY KEY CLUSTERED 
(
    [PropertySID] 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].[Import_Props_History]    Script Date: 2020-12-29 8:45:21 PM ******/
SET ANSI_NULLS ON
GO


SET QUOTED_IDENTIFIER ON
GO


CREATE TABLE [dbo].[Import_Props_History](
    [ChangeDT] [datetimeoffset](7) NOT NULL,
    [ByUserSID] [bigint] NOT NULL,
    [PropertySID] [bigint] NOT NULL,
    [NodeSID] [bigint] NULL,
    [Sequence] [float] NULL,
    [Name] [nvarchar](100) NOT NULL,
    [RefValueSID] [bigint] NULL,
    [DateTimeValue] [datetimeoffset](7) NULL,
    [NumericValue] [decimal](28, 9) NULL,
    [StringValue] [nvarchar](max) NULL,
    [ValueType] [nvarchar](100) NULL,
    [DeletedFlag] [tinyint] NOT NULL,
    [ModifiedUserSID] [bigint] NULL,
    [ModifiedDateTime] [datetimeoffset](7) NULL,
 CONSTRAINT [PK_Import_Props_History] PRIMARY KEY CLUSTERED 
(
    [ChangeDT] ASC,
    [ByUserSID] ASC,
    [PropertySID] 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].[Product_Nodes]    Script Date: 2020-12-29 8:45:21 PM ******/
SET ANSI_NULLS ON
GO


SET QUOTED_IDENTIFIER ON
GO


CREATE TABLE [dbo].[Product_Nodes](
    [NodeSID] [bigint] NOT NULL,
    [ParentNodeSID] [bigint] NULL,
    [Sequence] [float] NULL,
    [TypeName] [nvarchar](100) NULL,
    [Name] [nvarchar](100) NULL,
    [DeletedFlag] [tinyint] NOT NULL CONSTRAINT [DF_Product_Nodes_DeletedFlag]  DEFAULT ((0)),
    [ModifiedUserSID] [bigint] NULL,
    [ModifiedDateTime] [datetimeoffset](7) NULL,
 CONSTRAINT [PK_Product_Nodes] PRIMARY KEY CLUSTERED 
(
    [NodeSID] 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].[Product_Nodes_History]    Script Date: 2020-12-29 8:45:21 PM ******/
SET ANSI_NULLS ON
GO


SET QUOTED_IDENTIFIER ON
GO


CREATE TABLE [dbo].[Product_Nodes_History](
    [ChangeDT] [datetimeoffset](7) NOT NULL,
    [ByUserSID] [bigint] NOT NULL,
    [NodeSID] [bigint] NOT NULL,
    [ParentNodeSID] [bigint] NULL,
    [Sequence] [float] NULL,
    [TypeName] [nvarchar](100) NULL,
    [Name] [nvarchar](100) NULL,
    [DeletedFlag] [tinyint] NOT NULL CONSTRAINT [DF_Product_Nodes_History_DeletedFlag]  DEFAULT ((0)),
    [ModifiedUserSID] [bigint] NULL,
    [ModifiedDateTime] [datetimeoffset](7) NULL,
 CONSTRAINT [PK_Product_Nodes_History] PRIMARY KEY CLUSTERED 
(
    [ChangeDT] ASC,
    [ByUserSID] ASC,
    [NodeSID] 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].[Product_Props]    Script Date: 2020-12-29 8:45:21 PM ******/
SET ANSI_NULLS ON
GO


SET QUOTED_IDENTIFIER ON
GO


CREATE TABLE [dbo].[Product_Props](
    [PropertySID] [bigint] NOT NULL,
    [NodeSID] [bigint] NULL,
    [Sequence] [float] NULL,
    [Name] [nvarchar](100) NOT NULL,
    [RefValueSID] [bigint] NULL,
    [DateTimeValue] [datetimeoffset](7) NULL,
    [NumericValue] [decimal](28, 9) NULL,
    [StringValue] [nvarchar](max) NULL,
    [ValueType] [nvarchar](100) NULL,
    [DeletedFlag] [tinyint] NOT NULL CONSTRAINT [DF_Product_Props_DeletedFlag]  DEFAULT ((0)),
    [ModifiedUserSID] [bigint] NULL,
    [ModifiedDateTime] [datetimeoffset](7) NULL,
 CONSTRAINT [PK_Product_Props] PRIMARY KEY CLUSTERED 
(
    [PropertySID] 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].[Product_Props_History]    Script Date: 2020-12-29 8:45:21 PM ******/
SET ANSI_NULLS ON
GO


SET QUOTED_IDENTIFIER ON
GO


CREATE TABLE [dbo].[Product_Props_History](
    [ChangeDT] [datetimeoffset](7) NOT NULL,
    [ByUserSID] [bigint] NOT NULL,
    [PropertySID] [bigint] NOT NULL,
    [NodeSID] [bigint] NULL,
    [Sequence] [float] NULL,
    [Name] [nvarchar](100) NOT NULL,
    [RefValueSID] [bigint] NULL,
    [DateTimeValue] [datetimeoffset](7) NULL,
    [NumericValue] [decimal](28, 9) NULL,
    [StringValue] [nvarchar](max) NULL,
    [ValueType] [nvarchar](100) NULL,
    [DeletedFlag] [tinyint] NOT NULL CONSTRAINT [DF_Product_Props_History_DeletedFlag]  DEFAULT ((0)),
    [ModifiedUserSID] [bigint] NULL,
    [ModifiedDateTime] [datetimeoffset](7) NULL,
 CONSTRAINT [PK_Product_Props_History] PRIMARY KEY CLUSTERED 
(
    [ChangeDT] ASC,
    [ByUserSID] ASC,
    [PropertySID] 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].[Query_Contact]    Script Date: 2020-12-29 8:45:21 PM ******/
SET ANSI_NULLS ON
GO


SET QUOTED_IDENTIFIER ON
GO


CREATE TABLE [dbo].[Query_Contact](
    [NodeSID] [bigint] NOT NULL,
    [ParentNodeSID] [bigint] NULL,
    [TypeName] [nvarchar](100) NULL,
    [Name] [nvarchar](100) NULL,
    [DataSyncTimeStamp] [datetimeoffset](7) NULL,
    [ContactTitle] [nvarchar](max) NULL,
 CONSTRAINT [PK_Query_Contacts] PRIMARY KEY CLUSTERED 
(
    [NodeSID] 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].[Result_Nodes]    Script Date: 2020-12-29 8:45:21 PM ******/
SET ANSI_NULLS ON
GO


SET QUOTED_IDENTIFIER ON
GO


CREATE TABLE [dbo].[Result_Nodes](
    [NodeSID] [bigint] NOT NULL,
    [ParentNodeSID] [bigint] NULL,
    [Sequence] [float] NULL,
    [TypeName] [nvarchar](100) NULL,
    [Name] [nvarchar](100) NULL,
    [DeletedFlag] [tinyint] NOT NULL CONSTRAINT [DF_Result_Nodes_DeletedFlag]  DEFAULT ((0)),
    [ModifiedUserSID] [bigint] NULL,
    [ModifiedDateTime] [datetimeoffset](7) NULL,
 CONSTRAINT [PK_Result_Nodes] PRIMARY KEY CLUSTERED 
(
    [NodeSID] 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].[Result_Nodes_History]    Script Date: 2020-12-29 8:45:21 PM ******/
SET ANSI_NULLS ON
GO


SET QUOTED_IDENTIFIER ON
GO


CREATE TABLE [dbo].[Result_Nodes_History](
    [ChangeDT] [datetimeoffset](7) NOT NULL,
    [ByUserSID] [bigint] NOT NULL,
    [NodeSID] [bigint] NOT NULL,
    [ParentNodeSID] [bigint] NULL,
    [Sequence] [float] NULL,
    [TypeName] [nvarchar](100) NULL,
    [Name] [nvarchar](100) NULL,
    [DeletedFlag] [tinyint] NOT NULL,
    [ModifiedUserSID] [bigint] NULL,
    [ModifiedDateTime] [datetimeoffset](7) NULL,
 CONSTRAINT [PK_Result_Nodes_History] PRIMARY KEY CLUSTERED 
(
    [ChangeDT] ASC,
    [ByUserSID] ASC,
    [NodeSID] 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].[Result_Props]    Script Date: 2020-12-29 8:45:21 PM ******/
SET ANSI_NULLS ON
GO


SET QUOTED_IDENTIFIER ON
GO


CREATE TABLE [dbo].[Result_Props](
    [PropertySID] [bigint] NOT NULL,
    [NodeSID] [bigint] NULL,
    [Sequence] [float] NULL,
    [Name] [nvarchar](100) NOT NULL,
    [RefValueSID] [bigint] NULL,
    [DateTimeValue] [datetimeoffset](7) NULL,
    [NumericValue] [decimal](28, 9) NULL,
    [StringValue] [nvarchar](max) NULL,
    [ValueType] [nvarchar](100) NULL,
    [DeletedFlag] [tinyint] NOT NULL CONSTRAINT [DF_Result_Props_DeletedFlag]  DEFAULT ((0)),
    [ModifiedUserSID] [bigint] NULL,
    [ModifiedDateTime] [datetimeoffset](7) NULL,
 CONSTRAINT [PK_Result_Props] PRIMARY KEY CLUSTERED 
(
    [PropertySID] 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].[Result_Props_History]    Script Date: 2020-12-29 8:45:21 PM ******/
SET ANSI_NULLS ON
GO


SET QUOTED_IDENTIFIER ON
GO


CREATE TABLE [dbo].[Result_Props_History](
    [ChangeDT] [datetimeoffset](7) NOT NULL,
    [ByUserSID] [bigint] NOT NULL,
    [PropertySID] [bigint] NOT NULL,
    [NodeSID] [bigint] NULL,
    [Sequence] [float] NULL,
    [Name] [nvarchar](100) NOT NULL,
    [RefValueSID] [bigint] NULL,
    [DateTimeValue] [datetimeoffset](7) NULL,
    [NumericValue] [decimal](28, 9) NULL,
    [StringValue] [nvarchar](max) NULL,
    [ValueType] [nvarchar](100) NULL,
    [DeletedFlag] [tinyint] NOT NULL CONSTRAINT [DF_Result_Props_History_DeletedFlag]  DEFAULT ((0)),
    [ModifiedUserSID] [bigint] NULL,
    [ModifiedDateTime] [datetimeoffset](7) NULL,
 CONSTRAINT [PK_Result_Props_History] PRIMARY KEY CLUSTERED 
(
    [ChangeDT] ASC,
    [ByUserSID] ASC,
    [PropertySID] 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].[System_Nodes]    Script Date: 2020-12-29 8:45:21 PM ******/
SET ANSI_NULLS ON
GO


SET QUOTED_IDENTIFIER ON
GO


CREATE TABLE [dbo].[System_Nodes](
    [NodeSID] [bigint] NOT NULL,
    [ParentNodeSID] [bigint] NULL,
    [Sequence] [float] NULL,
    [TypeName] [nvarchar](100) NULL,
    [Name] [nvarchar](100) NULL,
    [DeletedFlag] [tinyint] NOT NULL CONSTRAINT [DF_System_Nodes_DeletedFlag]  DEFAULT ((0)),
    [ModifiedUserSID] [bigint] NULL,
    [ModifiedDateTime] [datetimeoffset](7) NULL,
 CONSTRAINT [PK_System_Nodes] PRIMARY KEY CLUSTERED 
(
    [NodeSID] 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].[System_Nodes_History]    Script Date: 2020-12-29 8:45:21 PM ******/
SET ANSI_NULLS ON
GO


SET QUOTED_IDENTIFIER ON
GO


CREATE TABLE [dbo].[System_Nodes_History](
    [ChangeDT] [datetimeoffset](7) NOT NULL,
    [ByUserSID] [bigint] NOT NULL,
    [NodeSID] [bigint] NOT NULL,
    [ParentNodeSID] [bigint] NULL,
    [Sequence] [float] NULL,
    [TypeName] [nvarchar](100) NULL,
    [Name] [nvarchar](100) NULL,
    [DeletedFlag] [tinyint] NOT NULL,
    [ModifiedUserSID] [bigint] NULL,
    [ModifiedDateTime] [datetimeoffset](7) NULL,
 CONSTRAINT [PK_System_Nodes_History] PRIMARY KEY CLUSTERED 
(
    [ChangeDT] ASC,
    [ByUserSID] ASC,
    [NodeSID] 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].[System_Props]    Script Date: 2020-12-29 8:45:21 PM ******/
SET ANSI_NULLS ON
GO


SET QUOTED_IDENTIFIER ON
GO


CREATE TABLE [dbo].[System_Props](
    [PropertySID] [bigint] NOT NULL,
    [NodeSID] [bigint] NULL,
    [Sequence] [float] NULL,
    [Name] [nvarchar](100) NOT NULL,
    [RefValueSID] [bigint] NULL,
    [DateTimeValue] [datetimeoffset](7) NULL,
    [NumericValue] [decimal](28, 9) NULL,
    [StringValue] [nvarchar](max) NULL,
    [ValueType] [nvarchar](100) NULL,
    [DeletedFlag] [tinyint] NOT NULL CONSTRAINT [DF_System_Props_DeletedFlag]  DEFAULT ((0)),
    [ModifiedUserSID] [bigint] NULL,
    [ModifiedDateTime] [datetimeoffset](7) NULL,
 CONSTRAINT [PK_System_Props] PRIMARY KEY CLUSTERED 
(
    [PropertySID] 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].[System_Props_History]    Script Date: 2020-12-29 8:45:21 PM ******/
SET ANSI_NULLS ON
GO


SET QUOTED_IDENTIFIER ON
GO


CREATE TABLE [dbo].[System_Props_History](
    [ChangeDT] [datetimeoffset](7) NOT NULL,
    [ByUserSID] [bigint] NOT NULL,
    [PropertySID] [bigint] NOT NULL,
    [NodeSID] [bigint] NULL,
    [Sequence] [float] NULL,
    [Name] [nvarchar](100) NOT NULL,
    [RefValueSID] [bigint] NULL,
    [DateTimeValue] [datetimeoffset](7) NULL,
    [NumericValue] [decimal](28, 9) NULL,
    [StringValue] [nvarchar](max) NULL,
    [ValueType] [nvarchar](100) NULL,
    [DeletedFlag] [tinyint] NOT NULL,
    [ModifiedUserSID] [bigint] NULL,
    [ModifiedDateTime] [datetimeoffset](7) NULL,
 CONSTRAINT [PK_System_Props_History] PRIMARY KEY CLUSTERED 
(
    [ChangeDT] ASC,
    [ByUserSID] ASC,
    [PropertySID] 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].[User_Nodes]    Script Date: 2020-12-29 8:45:21 PM ******/
SET ANSI_NULLS ON
GO


SET QUOTED_IDENTIFIER ON
GO


CREATE TABLE [dbo].[User_Nodes](
    [NodeSID] [bigint] NOT NULL,
    [ParentNodeSID] [bigint] NULL,
    [Sequence] [float] NULL,
    [TypeName] [nvarchar](100) NULL,
    [Name] [nvarchar](100) NULL,
    [DeletedFlag] [tinyint] NOT NULL CONSTRAINT [DF_User_Nodes_DeletedFlag]  DEFAULT ((0)),
    [ModifiedUserSID] [bigint] NULL,
    [ModifiedDateTime] [datetimeoffset](7) NULL,
 CONSTRAINT [PK_User_Nodes] PRIMARY KEY CLUSTERED 
(
    [NodeSID] 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].[User_Nodes_History]    Script Date: 2020-12-29 8:45:21 PM ******/
SET ANSI_NULLS ON
GO


SET QUOTED_IDENTIFIER ON
GO


CREATE TABLE [dbo].[User_Nodes_History](
    [ChangeDT] [datetimeoffset](7) NOT NULL,
    [ByUserSID] [bigint] NOT NULL,
    [NodeSID] [bigint] NOT NULL,
    [ParentNodeSID] [bigint] NULL,
    [Sequence] [float] NULL,
    [TypeName] [nvarchar](100) NULL,
    [Name] [nvarchar](100) NULL,
    [DeletedFlag] [tinyint] NOT NULL,
    [ModifiedUserSID] [bigint] NULL,
    [ModifiedDateTime] [datetimeoffset](7) NULL,
 CONSTRAINT [PK_User_Nodes_History] PRIMARY KEY CLUSTERED 
(
    [ChangeDT] ASC,
    [ByUserSID] ASC,
    [NodeSID] 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].[User_Props]    Script Date: 2020-12-29 8:45:21 PM ******/
SET ANSI_NULLS ON
GO


SET QUOTED_IDENTIFIER ON
GO


CREATE TABLE [dbo].[User_Props](
    [PropertySID] [bigint] NOT NULL,
    [NodeSID] [bigint] NULL,
    [Sequence] [float] NULL,
    [Name] [nvarchar](100) NOT NULL,
    [RefValueSID] [bigint] NULL,
    [DateTimeValue] [datetimeoffset](7) NULL,
    [NumericValue] [decimal](28, 9) NULL,
    [StringValue] [nvarchar](max) NULL,
    [ValueType] [nvarchar](100) NULL,
    [DeletedFlag] [tinyint] NOT NULL CONSTRAINT [DF_User_Props_DeletedFlag]  DEFAULT ((0)),
    [ModifiedUserSID] [bigint] NULL,
    [ModifiedDateTime] [datetimeoffset](7) NULL,
 CONSTRAINT [PK_User_Props] PRIMARY KEY CLUSTERED 
(
    [PropertySID] 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].[User_Props_History]    Script Date: 2020-12-29 8:45:21 PM ******/
SET ANSI_NULLS ON
GO


SET QUOTED_IDENTIFIER ON
GO


CREATE TABLE [dbo].[User_Props_History](
    [ChangeDT] [datetimeoffset](7) NOT NULL,
    [ByUserSID] [bigint] NOT NULL,
    [PropertySID] [bigint] NOT NULL,
    [NodeSID] [bigint] NULL,
    [Sequence] [float] NULL,
    [Name] [nvarchar](100) NOT NULL,
    [RefValueSID] [bigint] NULL,
    [DateTimeValue] [datetimeoffset](7) NULL,
    [NumericValue] [decimal](28, 9) NULL,
    [StringValue] [nvarchar](max) NULL,
    [ValueType] [nvarchar](100) NULL,
    [DeletedFlag] [tinyint] NOT NULL CONSTRAINT [DF_User_Props_History_DeletedFlag]  DEFAULT ((0)),
    [ModifiedUserSID] [bigint] NULL,
    [ModifiedDateTime] [datetimeoffset](7) NULL,
 CONSTRAINT [PK_User_Props_History] PRIMARY KEY CLUSTERED 
(
    [ChangeDT] ASC,
    [ByUserSID] ASC,
    [PropertySID] 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:  Index [IX_Core_Nodes_ModifiedUserSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Core_Nodes_ModifiedUserSID] ON [dbo].[Core_Nodes]
(
    [ModifiedUserSID] 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_Core_Nodes_ParentNodeSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Core_Nodes_ParentNodeSID] ON [dbo].[Core_Nodes]
(
    [ParentNodeSID] 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_Core_Nodes_Sequence]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Core_Nodes_Sequence] ON [dbo].[Core_Nodes]
(
    [Sequence] 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_Core_Nodes_History_ByUserSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Core_Nodes_History_ByUserSID] ON [dbo].[Core_Nodes_History]
(
    [ByUserSID] 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_Core_Nodes_History_ModifiedUserSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Core_Nodes_History_ModifiedUserSID] ON [dbo].[Core_Nodes_History]
(
    [ModifiedUserSID] 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_Core_Nodes_History_ParentNodeSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Core_Nodes_History_ParentNodeSID] ON [dbo].[Core_Nodes_History]
(
    [ParentNodeSID] 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_Core_Props_ModifiedUserSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Core_Props_ModifiedUserSID] ON [dbo].[Core_Props]
(
    [ModifiedUserSID] 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_Core_Props_NodeSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Core_Props_NodeSID] ON [dbo].[Core_Props]
(
    [NodeSID] 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_Core_Props_NodeSID_Sequence_Name_Unique]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE UNIQUE NONCLUSTERED INDEX [IX_Core_Props_NodeSID_Sequence_Name_Unique] ON [dbo].[Core_Props]
(
    [NodeSID] ASC,
    [Sequence] ASC,
    [Name] 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_Core_Props_RefValueSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Core_Props_RefValueSID] ON [dbo].[Core_Props]
(
    [RefValueSID] 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_Core_Props_Sequence]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Core_Props_Sequence] ON [dbo].[Core_Props]
(
    [Sequence] 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_Core_Props_History_ByUserSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Core_Props_History_ByUserSID] ON [dbo].[Core_Props_History]
(
    [ByUserSID] 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_Core_Props_History_ModifiedUserSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Core_Props_History_ModifiedUserSID] ON [dbo].[Core_Props_History]
(
    [ModifiedUserSID] 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_Core_Props_History_NodeSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Core_Props_History_NodeSID] ON [dbo].[Core_Props_History]
(
    [NodeSID] 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_Core_Props_History_RefValueSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Core_Props_History_RefValueSID] ON [dbo].[Core_Props_History]
(
    [RefValueSID] 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_Image_Nodes_ModifiedUserSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Image_Nodes_ModifiedUserSID] ON [dbo].[Image_Nodes]
(
    [ModifiedUserSID] 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_Image_Nodes_ParentNodeSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Image_Nodes_ParentNodeSID] ON [dbo].[Image_Nodes]
(
    [ParentNodeSID] 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_Image_Nodes_Sequence]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Image_Nodes_Sequence] ON [dbo].[Image_Nodes]
(
    [Sequence] 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_Image_Nodes_History_ByUserSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Image_Nodes_History_ByUserSID] ON [dbo].[Image_Nodes_History]
(
    [ByUserSID] 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_Image_Nodes_History_ModifiedUserSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Image_Nodes_History_ModifiedUserSID] ON [dbo].[Image_Nodes_History]
(
    [ModifiedUserSID] 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_Image_Nodes_History_ParentNodeSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Image_Nodes_History_ParentNodeSID] ON [dbo].[Image_Nodes_History]
(
    [ParentNodeSID] 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_Image_Props_ModifiedUserSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Image_Props_ModifiedUserSID] ON [dbo].[Image_Props]
(
    [ModifiedUserSID] 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_Image_Props_NodeSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Image_Props_NodeSID] ON [dbo].[Image_Props]
(
    [NodeSID] 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_Image_Props_NodeSID_Sequence_Name_Unique]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE UNIQUE NONCLUSTERED INDEX [IX_Image_Props_NodeSID_Sequence_Name_Unique] ON [dbo].[Image_Props]
(
    [NodeSID] ASC,
    [Sequence] ASC,
    [Name] 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_Image_Props_RefValueSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Image_Props_RefValueSID] ON [dbo].[Image_Props]
(
    [RefValueSID] 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_Image_Props_Sequence]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Image_Props_Sequence] ON [dbo].[Image_Props]
(
    [Sequence] 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_Image_Props_History_ByUserSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Image_Props_History_ByUserSID] ON [dbo].[Image_Props_History]
(
    [ByUserSID] 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_Image_Props_History_ModifiedUserSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Image_Props_History_ModifiedUserSID] ON [dbo].[Image_Props_History]
(
    [ModifiedUserSID] 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_Image_Props_History_NodeSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Image_Props_History_NodeSID] ON [dbo].[Image_Props_History]
(
    [NodeSID] 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_Image_Props_History_RefValueSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Image_Props_History_RefValueSID] ON [dbo].[Image_Props_History]
(
    [RefValueSID] 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_Import_Nodes_ModifiedUserSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Import_Nodes_ModifiedUserSID] ON [dbo].[Import_Nodes]
(
    [ModifiedUserSID] 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_Import_Nodes_ParentNodeSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Import_Nodes_ParentNodeSID] ON [dbo].[Import_Nodes]
(
    [ParentNodeSID] 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_Import_Nodes_Sequence]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Import_Nodes_Sequence] ON [dbo].[Import_Nodes]
(
    [Sequence] 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_Import_Nodes_History_ByUserSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Import_Nodes_History_ByUserSID] ON [dbo].[Import_Nodes_History]
(
    [ByUserSID] 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_Import_Nodes_History_ModifiedUserSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Import_Nodes_History_ModifiedUserSID] ON [dbo].[Import_Nodes_History]
(
    [ModifiedUserSID] 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_Import_Nodes_History_ParentNodeSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Import_Nodes_History_ParentNodeSID] ON [dbo].[Import_Nodes_History]
(
    [ParentNodeSID] 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_Import_Props_ModifiedUserSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Import_Props_ModifiedUserSID] ON [dbo].[Import_Props]
(
    [ModifiedUserSID] 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_Import_Props_NodeSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Import_Props_NodeSID] ON [dbo].[Import_Props]
(
    [NodeSID] 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_Import_Props_NodeSID_Sequence_Name_Unique]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE UNIQUE NONCLUSTERED INDEX [IX_Import_Props_NodeSID_Sequence_Name_Unique] ON [dbo].[Import_Props]
(
    [NodeSID] ASC,
    [Sequence] ASC,
    [Name] 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_Import_Props_RefValueSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Import_Props_RefValueSID] ON [dbo].[Import_Props]
(
    [RefValueSID] 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_Import_Props_Sequence]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Import_Props_Sequence] ON [dbo].[Import_Props]
(
    [Sequence] 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_Import_Props_History_ByUserSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Import_Props_History_ByUserSID] ON [dbo].[Import_Props_History]
(
    [ByUserSID] 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_Import_Props_History_ModifiedUserSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Import_Props_History_ModifiedUserSID] ON [dbo].[Import_Props_History]
(
    [ModifiedUserSID] 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_Import_Props_History_NodeSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Import_Props_History_NodeSID] ON [dbo].[Import_Props_History]
(
    [NodeSID] 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_Import_Props_History_RefValueSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Import_Props_History_RefValueSID] ON [dbo].[Import_Props_History]
(
    [RefValueSID] 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_Product_Nodes_ModifiedUserSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Product_Nodes_ModifiedUserSID] ON [dbo].[Product_Nodes]
(
    [ModifiedUserSID] 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_Product_Nodes_ParentNodeSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Product_Nodes_ParentNodeSID] ON [dbo].[Product_Nodes]
(
    [ParentNodeSID] 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_Product_Nodes_Sequence]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Product_Nodes_Sequence] ON [dbo].[Product_Nodes]
(
    [Sequence] 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_Product_Nodes_History_ByUserSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Product_Nodes_History_ByUserSID] ON [dbo].[Product_Nodes_History]
(
    [ByUserSID] 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_Product_Nodes_History_ModifiedUserSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Product_Nodes_History_ModifiedUserSID] ON [dbo].[Product_Nodes_History]
(
    [ModifiedUserSID] 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_Product_Nodes_History_ParentNodeSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Product_Nodes_History_ParentNodeSID] ON [dbo].[Product_Nodes_History]
(
    [ParentNodeSID] 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_Product_Props_ModifiedUserSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Product_Props_ModifiedUserSID] ON [dbo].[Product_Props]
(
    [ModifiedUserSID] 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_Product_Props_NodeSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Product_Props_NodeSID] ON [dbo].[Product_Props]
(
    [NodeSID] 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_Product_Props_NodeSID_Sequence_Name_Unique]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE UNIQUE NONCLUSTERED INDEX [IX_Product_Props_NodeSID_Sequence_Name_Unique] ON [dbo].[Product_Props]
(
    [NodeSID] ASC,
    [Sequence] ASC,
    [Name] 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_Product_Props_RefValueSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Product_Props_RefValueSID] ON [dbo].[Product_Props]
(
    [RefValueSID] 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_Product_Props_Sequence]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Product_Props_Sequence] ON [dbo].[Product_Props]
(
    [Sequence] 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_Product_Props_History_ByUserSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Product_Props_History_ByUserSID] ON [dbo].[Product_Props_History]
(
    [ByUserSID] 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_Product_Props_History_ModifiedUserSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Product_Props_History_ModifiedUserSID] ON [dbo].[Product_Props_History]
(
    [ModifiedUserSID] 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_Product_Props_History_NodeSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Product_Props_History_NodeSID] ON [dbo].[Product_Props_History]
(
    [NodeSID] 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_Product_Props_History_RefValueSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Product_Props_History_RefValueSID] ON [dbo].[Product_Props_History]
(
    [RefValueSID] 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_Result_Nodes_ModifiedUserSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Result_Nodes_ModifiedUserSID] ON [dbo].[Result_Nodes]
(
    [ModifiedUserSID] 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_Result_Nodes_ParentNodeSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Result_Nodes_ParentNodeSID] ON [dbo].[Result_Nodes]
(
    [ParentNodeSID] 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_Result_Nodes_Sequence]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Result_Nodes_Sequence] ON [dbo].[Result_Nodes]
(
    [Sequence] 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_Result_Nodes_History_ByUserSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Result_Nodes_History_ByUserSID] ON [dbo].[Result_Nodes_History]
(
    [ByUserSID] 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_Result_Nodes_History_ModifiedUserSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Result_Nodes_History_ModifiedUserSID] ON [dbo].[Result_Nodes_History]
(
    [ModifiedUserSID] 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_Result_Nodes_History_ParentNodeSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Result_Nodes_History_ParentNodeSID] ON [dbo].[Result_Nodes_History]
(
    [ParentNodeSID] 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_Result_Props_ModifiedUserSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Result_Props_ModifiedUserSID] ON [dbo].[Result_Props]
(
    [ModifiedUserSID] 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_Result_Props_NodeSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Result_Props_NodeSID] ON [dbo].[Result_Props]
(
    [NodeSID] 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_Result_Props_NodeSID_Sequence_Name_Unique]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE UNIQUE NONCLUSTERED INDEX [IX_Result_Props_NodeSID_Sequence_Name_Unique] ON [dbo].[Result_Props]
(
    [NodeSID] ASC,
    [Sequence] ASC,
    [Name] 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_Result_Props_RefValueSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Result_Props_RefValueSID] ON [dbo].[Result_Props]
(
    [RefValueSID] 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_Result_Props_Sequence]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Result_Props_Sequence] ON [dbo].[Result_Props]
(
    [Sequence] 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_Result_Props_History_ByUserSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Result_Props_History_ByUserSID] ON [dbo].[Result_Props_History]
(
    [ByUserSID] 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_Result_Props_History_ModifiedUserSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Result_Props_History_ModifiedUserSID] ON [dbo].[Result_Props_History]
(
    [ModifiedUserSID] 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_Result_Props_History_NodeSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Result_Props_History_NodeSID] ON [dbo].[Result_Props_History]
(
    [NodeSID] 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_Result_Props_History_RefValueSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_Result_Props_History_RefValueSID] ON [dbo].[Result_Props_History]
(
    [RefValueSID] 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_System_Nodes_ModifiedUserSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_System_Nodes_ModifiedUserSID] ON [dbo].[System_Nodes]
(
    [ModifiedUserSID] 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_System_Nodes_ParentNodeSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_System_Nodes_ParentNodeSID] ON [dbo].[System_Nodes]
(
    [ParentNodeSID] 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_System_Nodes_Sequence]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_System_Nodes_Sequence] ON [dbo].[System_Nodes]
(
    [Sequence] 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_System_Nodes_History_ByUserSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_System_Nodes_History_ByUserSID] ON [dbo].[System_Nodes_History]
(
    [ByUserSID] 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_System_Nodes_History_ModifiedUserSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_System_Nodes_History_ModifiedUserSID] ON [dbo].[System_Nodes_History]
(
    [ModifiedUserSID] 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_System_Nodes_History_ParentNodeSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_System_Nodes_History_ParentNodeSID] ON [dbo].[System_Nodes_History]
(
    [ParentNodeSID] 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_System_Props_ModifiedUserSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_System_Props_ModifiedUserSID] ON [dbo].[System_Props]
(
    [ModifiedUserSID] 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_System_Props_NodeSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_System_Props_NodeSID] ON [dbo].[System_Props]
(
    [NodeSID] 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_System_Props_NodeSID_Sequence_Name_Unique]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE UNIQUE NONCLUSTERED INDEX [IX_System_Props_NodeSID_Sequence_Name_Unique] ON [dbo].[System_Props]
(
    [NodeSID] ASC,
    [Sequence] ASC,
    [Name] 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_System_Props_RefValueSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_System_Props_RefValueSID] ON [dbo].[System_Props]
(
    [RefValueSID] 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_System_Props_Sequence]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_System_Props_Sequence] ON [dbo].[System_Props]
(
    [Sequence] 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_System_Props_History_ByUserSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_System_Props_History_ByUserSID] ON [dbo].[System_Props_History]
(
    [ByUserSID] 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_System_Props_History_ModifiedUserSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_System_Props_History_ModifiedUserSID] ON [dbo].[System_Props_History]
(
    [ModifiedUserSID] 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_System_Props_History_NodeSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_System_Props_History_NodeSID] ON [dbo].[System_Props_History]
(
    [NodeSID] 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_System_Props_History_RefValueSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_System_Props_History_RefValueSID] ON [dbo].[System_Props_History]
(
    [RefValueSID] 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_User_Nodes_ModifiedUserSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_User_Nodes_ModifiedUserSID] ON [dbo].[User_Nodes]
(
    [ModifiedUserSID] 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_User_Nodes_ParentNodeSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_User_Nodes_ParentNodeSID] ON [dbo].[User_Nodes]
(
    [ParentNodeSID] 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_User_Nodes_Sequence]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_User_Nodes_Sequence] ON [dbo].[User_Nodes]
(
    [Sequence] 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_User_Nodes_History_ByUserSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_User_Nodes_History_ByUserSID] ON [dbo].[User_Nodes_History]
(
    [ByUserSID] 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_User_Nodes_History_ModifiedUserSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_User_Nodes_History_ModifiedUserSID] ON [dbo].[User_Nodes_History]
(
    [ModifiedUserSID] 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_User_Nodes_History_ParentNodeSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_User_Nodes_History_ParentNodeSID] ON [dbo].[User_Nodes_History]
(
    [ParentNodeSID] 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_User_Props_ModifiedUserSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_User_Props_ModifiedUserSID] ON [dbo].[User_Props]
(
    [ModifiedUserSID] 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_User_Props_NodeSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_User_Props_NodeSID] ON [dbo].[User_Props]
(
    [NodeSID] 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_User_Props_NodeSID_Sequence_Name_Unique]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE UNIQUE NONCLUSTERED INDEX [IX_User_Props_NodeSID_Sequence_Name_Unique] ON [dbo].[User_Props]
(
    [NodeSID] ASC,
    [Sequence] ASC,
    [Name] 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_User_Props_RefValueSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_User_Props_RefValueSID] ON [dbo].[User_Props]
(
    [RefValueSID] 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_User_Props_Sequence]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_User_Props_Sequence] ON [dbo].[User_Props]
(
    [Sequence] 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_User_Props_History_ByUserSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_User_Props_History_ByUserSID] ON [dbo].[User_Props_History]
(
    [ByUserSID] 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_User_Props_History_ModifiedUserSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_User_Props_History_ModifiedUserSID] ON [dbo].[User_Props_History]
(
    [ModifiedUserSID] 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_User_Props_History_NodeSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_User_Props_History_NodeSID] ON [dbo].[User_Props_History]
(
    [NodeSID] 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_User_Props_History_RefValueSID]    Script Date: 2020-12-29 8:45:21 PM ******/
CREATE NONCLUSTERED INDEX [IX_User_Props_History_RefValueSID] ON [dbo].[User_Props_History]
(
    [RefValueSID] 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


ALTER TABLE [dbo].[Core_Nodes] ADD  CONSTRAINT [DF_Core_Nodes_DeletedFlag]  DEFAULT ((0)) FOR [DeletedFlag]
GO


ALTER TABLE [dbo].[Core_Nodes_History] ADD  CONSTRAINT [DF_Core_Nodes_History_DeletedFlag]  DEFAULT ((0)) FOR [DeletedFlag]
GO


ALTER TABLE [dbo].[Core_Props] ADD  CONSTRAINT [DF_Core_Props_DeletedFlag]  DEFAULT ((0)) FOR [DeletedFlag]
GO


ALTER TABLE [dbo].[Core_Props_History] ADD  CONSTRAINT [DF_Core_Props_History_DeletedFlag]  DEFAULT ((0)) FOR [DeletedFlag]
GO


ALTER TABLE [dbo].[Image_Nodes_History] ADD  CONSTRAINT [DF_Image_Nodes_History_DeletedFlag]  DEFAULT ((0)) FOR [DeletedFlag]
GO


ALTER TABLE [dbo].[Import_Nodes_History] ADD  CONSTRAINT [DF_Import_Nodes_History_DeletedFlag]  DEFAULT ((0)) FOR [DeletedFlag]
GO


ALTER TABLE [dbo].[Import_Props_History] ADD  CONSTRAINT [DF_Import_Props_History_DeletedFlag]  DEFAULT ((0)) FOR [DeletedFlag]
GO


ALTER TABLE [dbo].[Result_Nodes_History] ADD  CONSTRAINT [DF_Result_Nodes_History_DeletedFlag]  DEFAULT ((0)) FOR [DeletedFlag]
GO


ALTER TABLE [dbo].[System_Nodes_History] ADD  CONSTRAINT [DF_System_Nodes_History_DeletedFlag]  DEFAULT ((0)) FOR [DeletedFlag]
GO


ALTER TABLE [dbo].[System_Props_History] ADD  CONSTRAINT [DF_System_Props_History_DeletedFlag]  DEFAULT ((0)) FOR [DeletedFlag]
GO


ALTER TABLE [dbo].[User_Nodes_History] ADD  CONSTRAINT [DF_User_Nodes_History_DeletedFlag]  DEFAULT ((0)) FOR [DeletedFlag]
GO