USE adventureWorks2019

GO

ALTER DATABASE [adventureWorks2019] SET COMPATIBILITY_LEVEL = 110

GO

IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))

begin

EXEC [adventureWorks2019].[dbo].[sp_fulltext_database] @action = 'enable'

end

GO

ALTER DATABASE [adventureWorks2019] SET ANSI_NULL_DEFAULT OFF

GO

ALTER DATABASE [adventureWorks2019] SET ANSI_NULLS ON

GO

ALTER DATABASE [adventureWorks2019] SET ANSI_PADDING ON

GO

ALTER DATABASE [adventureWorks2019] SET ANSI_WARNINGS ON

GO

ALTER DATABASE [adventureWorks2019] SET ARITHABORT ON

GO

ALTER DATABASE [adventureWorks2019] SET AUTO_CLOSE OFF

GO

ALTER DATABASE [adventureWorks2019] SET AUTO_SHRINK OFF

GO

ALTER DATABASE [adventureWorks2019] SET AUTO_UPDATE_STATISTICS ON

GO

ALTER DATABASE [adventureWorks2019] SET CURSOR_CLOSE_ON_COMMIT OFF

GO

ALTER DATABASE [adventureWorks2019] SET CURSOR_DEFAULT GLOBAL

GO

ALTER DATABASE [adventureWorks2019] SET CONCAT_NULL_YIELDS_NULL ON

GO

ALTER DATABASE [adventureWorks2019] SET NUMERIC_ROUNDABORT OFF

GO

ALTER DATABASE [adventureWorks2019] SET QUOTED_IDENTIFIER ON

GO

ALTER DATABASE [adventureWorks2019] SET RECURSIVE_TRIGGERS OFF

GO

ALTER DATABASE [adventureWorks2019] SET DISABLE_BROKER

GO

ALTER DATABASE [adventureWorks2019] SET AUTO_UPDATE_STATISTICS_ASYNC OFF

GO

ALTER DATABASE [adventureWorks2019] SET DATE_CORRELATION_OPTIMIZATION OFF

GO

ALTER DATABASE [adventureWorks2019] SET TRUSTWORTHY OFF

GO

ALTER DATABASE [adventureWorks2019] SET ALLOW_SNAPSHOT_ISOLATION OFF

GO

ALTER DATABASE [adventureWorks2019] SET PARAMETERIZATION SIMPLE

GO

ALTER DATABASE [adventureWorks2019] SET READ_COMMITTED_SNAPSHOT OFF

GO

ALTER DATABASE [adventureWorks2019] SET HONOR_BROKER_PRIORITY OFF

GO

ALTER DATABASE [adventureWorks2019] SET RECOVERY SIMPLE

GO

ALTER DATABASE [adventureWorks2019] SET MULTI_USER

GO

ALTER DATABASE [adventureWorks2019] SET PAGE_VERIFY CHECKSUM

GO

ALTER DATABASE [adventureWorks2019] SET DB_CHAINING OFF

GO

ALTER DATABASE [adventureWorks2019] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF )

GO

ALTER DATABASE [adventureWorks2019] SET TARGET_RECOVERY_TIME = 0 SECONDS

GO

ALTER DATABASE [adventureWorks2019] SET DELAYED_DURABILITY = DISABLED

GO

EXEC sys.sp_db_vardecimal_storage_format N'adventureWorks2019', N'ON'

GO

ALTER DATABASE [adventureWorks2019] SET QUERY_STORE = OFF

GO

USE [adventureWorks2019]

GO

ALTER DATABASE SCOPED CONFIGURATION SET ACCELERATED_PLAN_FORCING = ON;

GO

ALTER DATABASE SCOPED CONFIGURATION SET BATCH_MODE_ADAPTIVE_JOINS = ON;

GO

ALTER DATABASE SCOPED CONFIGURATION SET BATCH_MODE_MEMORY_GRANT_FEEDBACK = ON;

GO

ALTER DATABASE SCOPED CONFIGURATION SET BATCH_MODE_ON_ROWSTORE = ON;

GO

ALTER DATABASE SCOPED CONFIGURATION SET DEFERRED_COMPILATION_TV = ON;

GO

ALTER DATABASE SCOPED CONFIGURATION SET ELEVATE_ONLINE = OFF;

GO

ALTER DATABASE SCOPED CONFIGURATION SET ELEVATE_RESUMABLE = OFF;

GO

ALTER DATABASE SCOPED CONFIGURATION SET GLOBAL_TEMPORARY_TABLE_AUTO_DROP = ON;

GO

ALTER DATABASE SCOPED CONFIGURATION SET IDENTITY_CACHE = ON;

GO

ALTER DATABASE SCOPED CONFIGURATION SET INTERLEAVED_EXECUTION_TVF = ON;

GO

ALTER DATABASE SCOPED CONFIGURATION SET ISOLATE_SECURITY_POLICY_CARDINALITY = OFF;

GO

ALTER DATABASE SCOPED CONFIGURATION SET LAST_QUERY_PLAN_STATS = OFF;

GO

ALTER DATABASE SCOPED CONFIGURATION SET LEGACY_CARDINALITY_ESTIMATION = OFF;

GO

ALTER DATABASE SCOPED CONFIGURATION FOR SECONDARY SET LEGACY_CARDINALITY_ESTIMATION = PRIMARY;

GO

ALTER DATABASE SCOPED CONFIGURATION SET LIGHTWEIGHT_QUERY_PROFILING = ON;

GO

ALTER DATABASE SCOPED CONFIGURATION SET MAXDOP = 0;

GO

ALTER DATABASE SCOPED CONFIGURATION FOR SECONDARY SET MAXDOP = PRIMARY;

GO

ALTER DATABASE SCOPED CONFIGURATION SET OPTIMIZE_FOR_AD_HOC_WORKLOADS = OFF;

GO

ALTER DATABASE SCOPED CONFIGURATION SET PARAMETER_SNIFFING = ON;

GO

ALTER DATABASE SCOPED CONFIGURATION FOR SECONDARY SET PARAMETER_SNIFFING = PRIMARY;

GO

ALTER DATABASE SCOPED CONFIGURATION SET QUERY_OPTIMIZER_HOTFIXES = OFF;

GO

ALTER DATABASE SCOPED CONFIGURATION FOR SECONDARY SET QUERY_OPTIMIZER_HOTFIXES = PRIMARY;

GO

ALTER DATABASE SCOPED CONFIGURATION SET ROW_MODE_MEMORY_GRANT_FEEDBACK = ON;

GO

ALTER DATABASE SCOPED CONFIGURATION SET TSQL_SCALAR_UDF_INLINING = ON;

GO

ALTER DATABASE SCOPED CONFIGURATION SET VERBOSE_TRUNCATION_WARNINGS = ON;

GO

ALTER DATABASE SCOPED CONFIGURATION SET XTP_PROCEDURE_EXECUTION_STATISTICS = OFF;

GO

ALTER DATABASE SCOPED CONFIGURATION SET XTP_QUERY_EXECUTION_STATISTICS = OFF;

GO

USE [adventureWorks2019]

GO

/****** Object: Schema [dbo] Script Date: 9/30/20 11:09:32 AM ******/

CREATE SCHEMA [dbo]

GO

/****** Object: XmlSchemaCollection [dbo].[ProductDescriptionSchemaCollection] Script Date: 9/30/20 11:09:32 AM ******/

CREATE XML SCHEMA COLLECTION [dbo].[ProductDescriptionSchemaCollection] AS N'<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:t="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelWarrAndMain" targetNamespace="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelWarrAndMain" elementFormDefault="qualified"><xsd:element name="Maintenance"><xsd:complexType><xsd:complexContent><xsd:restriction base="xsd:anyType"><xsd:sequence><xsd:element name="NoOfYears" type="xsd:string" /><xsd:element name="Description" type="xsd:string" /></xsd:sequence></xsd:restriction></xsd:complexContent></xsd:complexType></xsd:element><xsd:element name="Warranty"><xsd:complexType><xsd:complexContent><xsd:restriction base="xsd:anyType"><xsd:sequence><xsd:element name="WarrantyPeriod" type="xsd:string" /><xsd:element name="Description" type="xsd:string" /></xsd:sequence></xsd:restriction></xsd:complexContent></xsd:complexType></xsd:element></xsd:schema><xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:ns1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelWarrAndMain" xmlns:t="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription" targetNamespace="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription" elementFormDefault="qualified"><xsd:import namespace="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelWarrAndMain" /><xsd:element name="Code" type="xsd:string" /><xsd:element name="Description" type="xsd:string" /><xsd:element name="ProductDescription" type="t:ProductDescription" /><xsd:element name="Taxonomy" type="xsd:string" /><xsd:complexType name="Category"><xsd:complexContent><xsd:restriction base="xsd:anyType"><xsd:sequence><xsd:element ref="t:Taxonomy" /><xsd:element ref="t:Code" /><xsd:element ref="t:Description" minOccurs="0" /></xsd:sequence></xsd:restriction></xsd:complexContent></xsd:complexType><xsd:complexType name="Features" mixed="true"><xsd:complexContent mixed="true"><xsd:restriction base="xsd:anyType"><xsd:sequence><xsd:element ref="ns1:Warranty" /><xsd:element ref="ns1:Maintenance" /><xsd:any namespace="##other" processContents="skip" minOccurs="0" maxOccurs="unbounded" /></xsd:sequence></xsd:restriction></xsd:complexContent></xsd:complexType><xsd:complexType name="Manufacturer"><xsd:complexContent><xsd:restriction base="xsd:anyType"><xsd:sequence><xsd:element name="Name" type="xsd:string" minOccurs="0" /><xsd:element name="CopyrightURL" type="xsd:string" minOccurs="0" /><xsd:element name="Copyright" type="xsd:string" minOccurs="0" /><xsd:element name="ProductURL" type="xsd:string" minOccurs="0" /></xsd:sequence></xsd:restriction></xsd:complexContent></xsd:complexType><xsd:complexType name="Picture"><xsd:complexContent><xsd:restriction base="xsd:anyType"><xsd:sequence><xsd:element name="Name" type="xsd:string" minOccurs="0" /><xsd:element name="Angle" type="xsd:string" minOccurs="0" /><xsd:element name="Size" type="xsd:string" minOccurs="0" /><xsd:element name="ProductPhotoID" type="xsd:integer" minOccurs="0" /></xsd:sequence></xsd:restriction></xsd:complexContent></xsd:complexType><xsd:complexType name="ProductDescription"><xsd:complexContent><xsd:restriction base="xsd:anyType"><xsd:sequence><xsd:element name="Summary" type="t:Summary" minOccurs="0" /><xsd:element name="Manufacturer" type="t:Manufacturer" minOccurs="0" /><xsd:element name="Features" type="t:Features" minOccurs="0" maxOccurs="unbounded" /><xsd:element name="Picture" type="t:Picture" minOccurs="0" maxOccurs="unbounded" /><xsd:element name="Category" type="t:Category" minOccurs="0" maxOccurs="unbounded" /><xsd:element name="Specifications" type="t:Specifications" minOccurs="0" maxOccurs="unbounded" /></xsd:sequence><xsd:attribute name="ProductModelID" type="xsd:string" /><xsd:attribute name="ProductModelName" type="xsd:string" /></xsd:restriction></xsd:complexContent></xsd:complexType><xsd:complexType name="Specifications" mixed="true"><xsd:complexContent mixed="true"><xsd:restriction base="xsd:anyType"><xsd:sequence><xsd:any processContents="skip" minOccurs="0" maxOccurs="unbounded" /></xsd:sequence></xsd:restriction></xsd:complexContent></xsd:complexType><xsd:complexType name="Summary" mixed="true"><xsd:complexContent mixed="true"><xsd:restriction base="xsd:anyType"><xsd:sequence><xsd:any namespace="http://www.w3.org/1999/xhtml" processContents="skip" minOccurs="0" maxOccurs="unbounded" /></xsd:sequence></xsd:restriction></xsd:complexContent></xsd:complexType></xsd:schema>'

GO

/****** Object: UserDefinedDataType [dbo].[AccountNumber] Script Date: 9/30/20 11:09:32 AM ******/

CREATE TYPE [dbo].[AccountNumber] FROM [nvarchar](15) NULL

GO

/****** Object: UserDefinedDataType [dbo].[Flag] Script Date: 9/30/20 11:09:32 AM ******/

CREATE TYPE [dbo].[Flag] FROM [bit] NOT NULL

GO

/****** Object: UserDefinedDataType [dbo].[Name] Script Date: 9/30/20 11:09:32 AM ******/

CREATE TYPE [dbo].[Name] FROM [nvarchar](50) NULL

GO

/****** Object: UserDefinedDataType [dbo].[NameStyle] Script Date: 9/30/20 11:09:32 AM ******/

CREATE TYPE [dbo].[NameStyle] FROM [bit] NOT NULL

GO

/****** Object: UserDefinedDataType [dbo].[OrderNumber] Script Date: 9/30/20 11:09:32 AM ******/

CREATE TYPE [dbo].[OrderNumber] FROM [nvarchar](25) NULL

GO

/****** Object: UserDefinedDataType [dbo].[Phone] Script Date: 9/30/20 11:09:32 AM ******/

CREATE TYPE [dbo].[Phone] FROM [nvarchar](25) NULL

GO

/****** Object: UserDefinedFunction [dbo].[ufnGetAllCategories] Script Date: 9/30/20 11:09:32 AM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- DROP FUNCTION [dbo].[ufnGetAllCategories]

CREATE FUNCTION [dbo].[ufnGetAllCategories]()

RETURNS @retCategoryInformation TABLE

(

-- Columns returned by the function

[ParentProductCategoryName] [nvarchar](50) NULL,

[ProductCategoryName] [nvarchar](50) NOT NULL,

[ProductCategoryID] [int] NOT NULL

)

AS

-- Returns the CustomerID, first name, and last name for the specified customer.

BEGIN

WITH CategoryCTE([ParentProductCategoryID], [ProductCategoryID], [Name]) AS

(

SELECT [ParentProductCategoryID], [ProductCategoryID], [Name]

FROM dbo.ProductCategory

WHERE ParentProductCategoryID IS NULL

UNION ALL

SELECT C.[ParentProductCategoryID], C.[ProductCategoryID], C.[Name]

FROM dbo.ProductCategory AS C

INNER JOIN CategoryCTE AS BC ON BC.ProductCategoryID = C.ParentProductCategoryID

)

INSERT INTO @retCategoryInformation

SELECT PC.[Name] AS [ParentProductCategoryName], CCTE.[Name] as [ProductCategoryName], CCTE.[ProductCategoryID]

FROM CategoryCTE AS CCTE

JOIN dbo.ProductCategory AS PC

ON PC.[ProductCategoryID] = CCTE.[ParentProductCategoryID];

RETURN;

END;

GO

/****** Object: UserDefinedFunction [dbo].[ufnGetSalesOrderStatusText] Script Date: 9/30/20 11:09:32 AM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE FUNCTION [dbo].[ufnGetSalesOrderStatusText](@Status [tinyint])

RETURNS [nvarchar](15)

AS

-- Returns the sales order status text representation for the status value.

BEGIN

DECLARE @ret [nvarchar](15);

SET @ret =

CASE @Status

WHEN 1 THEN 'In process'

WHEN 2 THEN 'Approved'

WHEN 3 THEN 'Backordered'

WHEN 4 THEN 'Rejected'

WHEN 5 THEN 'Shipped'

WHEN 6 THEN 'Cancelled'

ELSE '** Invalid **'

END;

RETURN @ret

END;

GO

/****** Object: Table [dbo].[Product] Script Date: 9/30/20 11:09:32 AM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Product](

[ProductID] [int] IDENTITY(1,1) NOT NULL,

[Name] [dbo].[Name] NOT NULL,

[ProductNumber] [nvarchar](25) NOT NULL,

[Color] [nvarchar](15) NULL,

[StandardCost] [money] NOT NULL,

[ListPrice] [money] NOT NULL,

[Size] [nvarchar](5) NULL,

[Weight] [decimal](8, 2) NULL,

[ProductCategoryID] [int] NULL,

[ProductModelID] [int] NULL,

[SellStartDate] [datetime] NOT NULL,

[SellEndDate] [datetime] NULL,

[DiscontinuedDate] [datetime] NULL,

[ThumbNailPhoto] [varbinary](max) NULL,

[ThumbnailPhotoFileName] [nvarchar](50) NULL,

[rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL,

[ModifiedDate] [datetime] NOT NULL,

CONSTRAINT [PK_Product_ProductID] PRIMARY KEY CLUSTERED

(

[ProductID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],

CONSTRAINT [AK_Product_Name] UNIQUE NONCLUSTERED

(

[Name] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],

CONSTRAINT [AK_Product_ProductNumber] UNIQUE NONCLUSTERED

(

[ProductNumber] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],

CONSTRAINT [AK_Product_rowguid] UNIQUE NONCLUSTERED

(

[rowguid] 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].[ProductDescription] Script Date: 9/30/20 11:09:33 AM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[ProductDescription](

[ProductDescriptionID] [int] IDENTITY(1,1) NOT NULL,

[Description] [nvarchar](400) NOT NULL,

[rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL,

[ModifiedDate] [datetime] NOT NULL,

CONSTRAINT [PK_ProductDescription_ProductDescriptionID] PRIMARY KEY CLUSTERED

(

[ProductDescriptionID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],

CONSTRAINT [AK_ProductDescription_rowguid] UNIQUE NONCLUSTERED

(

[rowguid] 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].[ProductModel] Script Date: 9/30/20 11:09:33 AM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[ProductModel](

[ProductModelID] [int] IDENTITY(1,1) NOT NULL,

[Name] [dbo].[Name] NOT NULL,

[CatalogDescription] [xml](CONTENT [dbo].[ProductDescriptionSchemaCollection]) NULL,

[rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL,

[ModifiedDate] [datetime] NOT NULL,

CONSTRAINT [PK_ProductModel_ProductModelID] PRIMARY KEY CLUSTERED

(

[ProductModelID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],

CONSTRAINT [AK_ProductModel_Name] UNIQUE NONCLUSTERED

(

[Name] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],

CONSTRAINT [AK_ProductModel_rowguid] UNIQUE NONCLUSTERED

(

[rowguid] 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].[ProductModelProductDescription] Script Date: 9/30/20 11:09:33 AM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[ProductModelProductDescription](

[ProductModelID] [int] NOT NULL,

[ProductDescriptionID] [int] NOT NULL,

[Culture] [nchar](6) NOT NULL,

[rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL,

[ModifiedDate] [datetime] NOT NULL,

CONSTRAINT [PK_ProductModelProductDescription_ProductModelID_ProductDescriptionID_Culture] PRIMARY KEY CLUSTERED

(

[ProductModelID] ASC,

[ProductDescriptionID] ASC,

[Culture] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],

CONSTRAINT [AK_ProductModelProductDescription_rowguid] UNIQUE NONCLUSTERED

(

[rowguid] 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: View [dbo].[vProductAndDescription] Script Date: 9/30/20 11:09:33 AM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE VIEW [dbo].[vProductAndDescription]

WITH SCHEMABINDING

AS

-- View (indexed or standard) to display products and product descriptions by language.

SELECT

p.[ProductID]

,p.[Name]

,pm.[Name] AS [ProductModel]

,pmx.[Culture]

,pd.[Description]

FROM [dbo].[Product] p

INNER JOIN [dbo].[ProductModel] pm

ON p.[ProductModelID] = pm.[ProductModelID]

INNER JOIN [dbo].[ProductModelProductDescription] pmx

ON pm.[ProductModelID] = pmx.[ProductModelID]

INNER JOIN [dbo].[ProductDescription] pd

ON pmx.[ProductDescriptionID] = pd.[ProductDescriptionID];

GO

SET ARITHABORT ON

SET CONCAT_NULL_YIELDS_NULL ON

SET QUOTED_IDENTIFIER ON

SET ANSI_NULLS ON

SET ANSI_PADDING ON

SET ANSI_WARNINGS ON

SET NUMERIC_ROUNDABORT OFF

GO

/****** Object: Index [IX_vProductAndDescription] Script Date: 9/30/20 11:09:33 AM ******/

CREATE UNIQUE CLUSTERED INDEX [IX_vProductAndDescription] ON [dbo].[vProductAndDescription]

(

[Culture] ASC,

[ProductID] 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: View [dbo].[vProductModelCatalogDescription] Script Date: 9/30/20 11:09:33 AM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE VIEW [dbo].[vProductModelCatalogDescription]

AS

SELECT

[ProductModelID]

,[Name]

,[CatalogDescription].value(N'declare namespace p1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription";

declare namespace html="http://www.w3.org/1999/xhtml";

(/p1:ProductDescription/p1:Summary/html:p)[1]', 'nvarchar(max)') AS [Summary]

,[CatalogDescription].value(N'declare namespace p1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription";

(/p1:ProductDescription/p1:Manufacturer/p1:Name)[1]', 'nvarchar(max)') AS [Manufacturer]

,[CatalogDescription].value(N'declare namespace p1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription";

(/p1:ProductDescription/p1:Manufacturer/p1:Copyright)[1]', 'nvarchar(30)') AS [Copyright]

,[CatalogDescription].value(N'declare namespace p1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription";

(/p1:ProductDescription/p1:Manufacturer/p1:ProductURL)[1]', 'nvarchar(256)') AS [ProductURL]

,[CatalogDescription].value(N'declare namespace p1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription";

declare namespace wm="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelWarrAndMain";

(/p1:ProductDescription/p1:Features/wm:Warranty/wm:WarrantyPeriod)[1]', 'nvarchar(256)') AS [WarrantyPeriod]

,[CatalogDescription].value(N'declare namespace p1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription";

declare namespace wm="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelWarrAndMain";

(/p1:ProductDescription/p1:Features/wm:Warranty/wm:Description)[1]', 'nvarchar(256)') AS [WarrantyDescription]

,[CatalogDescription].value(N'declare namespace p1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription";

declare namespace wm="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelWarrAndMain";

(/p1:ProductDescription/p1:Features/wm:Maintenance/wm:NoOfYears)[1]', 'nvarchar(256)') AS [NoOfYears]

,[CatalogDescription].value(N'declare namespace p1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription";

declare namespace wm="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelWarrAndMain";

(/p1:ProductDescription/p1:Features/wm:Maintenance/wm:Description)[1]', 'nvarchar(256)') AS [MaintenanceDescription]

,[CatalogDescription].value(N'declare namespace p1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription";

declare namespace wf="http://www.adventure-works.com/schemas/OtherFeatures";

(/p1:ProductDescription/p1:Features/wf:wheel)[1]', 'nvarchar(256)') AS [Wheel]

,[CatalogDescription].value(N'declare namespace p1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription";

declare namespace wf="http://www.adventure-works.com/schemas/OtherFeatures";

(/p1:ProductDescription/p1:Features/wf:saddle)[1]', 'nvarchar(256)') AS [Saddle]

,[CatalogDescription].value(N'declare namespace p1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription";

declare namespace wf="http://www.adventure-works.com/schemas/OtherFeatures";

(/p1:ProductDescription/p1:Features/wf:pedal)[1]', 'nvarchar(256)') AS [Pedal]

,[CatalogDescription].value(N'declare namespace p1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription";

declare namespace wf="http://www.adventure-works.com/schemas/OtherFeatures";

(/p1:ProductDescription/p1:Features/wf:BikeFrame)[1]', 'nvarchar(max)') AS [BikeFrame]

,[CatalogDescription].value(N'declare namespace p1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription";

declare namespace wf="http://www.adventure-works.com/schemas/OtherFeatures";

(/p1:ProductDescription/p1:Features/wf:crankset)[1]', 'nvarchar(256)') AS [Crankset]

,[CatalogDescription].value(N'declare namespace p1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription";

(/p1:ProductDescription/p1:Picture/p1:Angle)[1]', 'nvarchar(256)') AS [PictureAngle]

,[CatalogDescription].value(N'declare namespace p1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription";

(/p1:ProductDescription/p1:Picture/p1:Size)[1]', 'nvarchar(256)') AS [PictureSize]

,[CatalogDescription].value(N'declare namespace p1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription";

(/p1:ProductDescription/p1:Picture/p1:ProductPhotoID)[1]', 'nvarchar(256)') AS [ProductPhotoID]

,[CatalogDescription].value(N'declare namespace p1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription";

(/p1:ProductDescription/p1:Specifications/Material)[1]', 'nvarchar(256)') AS [Material]

,[CatalogDescription].value(N'declare namespace p1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription";

(/p1:ProductDescription/p1:Specifications/Color)[1]', 'nvarchar(256)') AS [Color]

,[CatalogDescription].value(N'declare namespace p1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription";

(/p1:ProductDescription/p1:Specifications/ProductLine)[1]', 'nvarchar(256)') AS [ProductLine]

,[CatalogDescription].value(N'declare namespace p1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription";

(/p1:ProductDescription/p1:Specifications/Style)[1]', 'nvarchar(256)') AS [Style]

,[CatalogDescription].value(N'declare namespace p1="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/ProductModelDescription";

(/p1:ProductDescription/p1:Specifications/RiderExperience)[1]', 'nvarchar(1024)') AS [RiderExperience]

,[rowguid]

,[ModifiedDate]

FROM [dbo].[ProductModel]

WHERE [CatalogDescription] IS NOT NULL;

GO

/****** Object: Table [dbo].[ProductCategory] Script Date: 9/30/20 11:09:33 AM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[ProductCategory](

[ProductCategoryID] [int] IDENTITY(1,1) NOT NULL,

[ParentProductCategoryID] [int] NULL,

[Name] [dbo].[Name] NOT NULL,

[rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL,

[ModifiedDate] [datetime] NOT NULL,

CONSTRAINT [PK_ProductCategory_ProductCategoryID] PRIMARY KEY CLUSTERED

(

[ProductCategoryID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],

CONSTRAINT [AK_ProductCategory_Name] UNIQUE NONCLUSTERED

(

[Name] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],

CONSTRAINT [AK_ProductCategory_rowguid] UNIQUE NONCLUSTERED

(

[rowguid] 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: View [dbo].[vGetAllCategories] Script Date: 9/30/20 11:09:33 AM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE VIEW [dbo].[vGetAllCategories]

WITH SCHEMABINDING

AS

-- Returns the CustomerID, first name, and last name for the specified customer.

WITH CategoryCTE([ParentProductCategoryID], [ProductCategoryID], [Name]) AS

(

SELECT [ParentProductCategoryID], [ProductCategoryID], [Name]

FROM dbo.ProductCategory

WHERE ParentProductCategoryID IS NULL

UNION ALL

SELECT C.[ParentProductCategoryID], C.[ProductCategoryID], C.[Name]

FROM dbo.ProductCategory AS C

INNER JOIN CategoryCTE AS BC ON BC.ProductCategoryID = C.ParentProductCategoryID

)

SELECT PC.[Name] AS [ParentProductCategoryName], CCTE.[Name] as [ProductCategoryName], CCTE.[ProductCategoryID]

FROM CategoryCTE AS CCTE

JOIN dbo.ProductCategory AS PC

ON PC.[ProductCategoryID] = CCTE.[ParentProductCategoryID]

GO

/****** Object: Table [dbo].[Customer] Script Date: 9/30/20 11:09:33 AM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Customer](

[CustomerID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,

[NameStyle] [dbo].[NameStyle] NOT NULL,

[Title] [nvarchar](8) NULL,

[FirstName] [dbo].[Name] NOT NULL,

[MiddleName] [dbo].[Name] NULL,

[LastName] [dbo].[Name] NOT NULL,

[Suffix] [nvarchar](10) NULL,

[CompanyName] [nvarchar](128) NULL,

[SalesPerson] [nvarchar](256) NULL,

[EmailAddress] [nvarchar](50) NULL,

[Phone] [dbo].[Phone] NULL,

[PasswordHash] [varchar](128) NOT NULL,

[PasswordSalt] [varchar](10) NOT NULL,

[rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL,

[ModifiedDate] [datetime] NOT NULL,

CONSTRAINT [PK_Customer_CustomerID] PRIMARY KEY CLUSTERED

(

[CustomerID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],

CONSTRAINT [AK_Customer_rowguid] UNIQUE NONCLUSTERED

(

[rowguid] 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: UserDefinedFunction [dbo].[ufnGetCustomerInformation] Script Date: 9/30/20 11:09:33 AM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE FUNCTION [dbo].[ufnGetCustomerInformation](@CustomerID int)

RETURNS TABLE

AS

-- Returns the CustomerID, first name, and last name for the specified customer.

RETURN (

SELECT

CustomerID,

FirstName,

LastName

FROM [dbo].[Customer]

WHERE [CustomerID] = @CustomerID

);

GO

/****** Object: Table [dbo].[BuildVersion] Script Date: 9/30/20 11:09:33 AM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[BuildVersion](

[SystemInformationID] [tinyint] IDENTITY(1,1) NOT NULL,

[Database Version] [nvarchar](25) NOT NULL,

[VersionDate] [datetime] NOT NULL,

[ModifiedDate] [datetime] NOT NULL

) ON [PRIMARY]

GO

/****** Object: Table [dbo].[ErrorLog] Script Date: 9/30/20 11:09:33 AM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[ErrorLog](

[ErrorLogID] [int] IDENTITY(1,1) NOT NULL,

[ErrorTime] [datetime] NOT NULL,

[UserName] [sysname] NOT NULL,

[ErrorNumber] [int] NOT NULL,

[ErrorSeverity] [int] NULL,

[ErrorState] [int] NULL,

[ErrorProcedure] [nvarchar](126) NULL,

[ErrorLine] [int] NULL,

[ErrorMessage] [nvarchar](4000) NOT NULL,

CONSTRAINT [PK_ErrorLog_ErrorLogID] PRIMARY KEY CLUSTERED

(

[ErrorLogID] 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].[Address] Script Date: 9/30/20 11:09:33 AM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Address](

[AddressID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,

[AddressLine1] [nvarchar](60) NOT NULL,

[AddressLine2] [nvarchar](60) NULL,

[City] [nvarchar](30) NOT NULL,

[StateProvince] [dbo].[Name] NOT NULL,

[CountryRegion] [dbo].[Name] NOT NULL,

[PostalCode] [nvarchar](15) NOT NULL,

[rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL,

[ModifiedDate] [datetime] NOT NULL,

CONSTRAINT [PK_Address_AddressID] PRIMARY KEY CLUSTERED

(

[AddressID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],

CONSTRAINT [AK_Address_rowguid] UNIQUE NONCLUSTERED

(

[rowguid] 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].[CustomerAddress] Script Date: 9/30/20 11:09:33 AM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[CustomerAddress](

[CustomerID] [int] NOT NULL,

[AddressID] [int] NOT NULL,

[AddressType] [dbo].[Name] NOT NULL,

[rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL,

[ModifiedDate] [datetime] NOT NULL,

CONSTRAINT [PK_CustomerAddress_CustomerID_AddressID] PRIMARY KEY CLUSTERED

(

[CustomerID] ASC,

[AddressID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],

CONSTRAINT [AK_CustomerAddress_rowguid] UNIQUE NONCLUSTERED

(

[rowguid] 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].[SalesOrderDetail] Script Date: 9/30/20 11:09:34 AM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[SalesOrderDetail](

[SalesOrderID] [int] NOT NULL,

[SalesOrderDetailID] [int] IDENTITY(1,1) NOT NULL,

[OrderQty] [smallint] NOT NULL,

[ProductID] [int] NOT NULL,

[UnitPrice] [money] NOT NULL,

[UnitPriceDiscount] [money] NOT NULL,

[LineTotal] AS (isnull(([UnitPrice]*((1.0)-[UnitPriceDiscount]))*[OrderQty],(0.0))),

[rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL,

[ModifiedDate] [datetime] NOT NULL,

CONSTRAINT [PK_SalesOrderDetail_SalesOrderID_SalesOrderDetailID] PRIMARY KEY CLUSTERED

(

[SalesOrderID] ASC,

[SalesOrderDetailID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],

CONSTRAINT [AK_SalesOrderDetail_rowguid] UNIQUE NONCLUSTERED

(

[rowguid] 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].[SalesOrderHeader] Script Date: 9/30/20 11:09:34 AM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ARITHABORT ON

GO

CREATE TABLE [dbo].[SalesOrderHeader](

[SalesOrderID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,

[RevisionNumber] [tinyint] NOT NULL,

[OrderDate] [datetime] NOT NULL,

[DueDate] [datetime] NOT NULL,

[ShipDate] [datetime] NULL,

[Status] [tinyint] NOT NULL,

[OnlineOrderFlag] [dbo].[Flag] NOT NULL,

[SalesOrderNumber] AS (isnull(N'SO'+CONVERT([nvarchar](23),[SalesOrderID]),N'*** ERROR ***')),

[PurchaseOrderNumber] [dbo].[OrderNumber] NULL,

[AccountNumber] [dbo].[AccountNumber] NULL,

[CustomerID] [int] NOT NULL,

[ShipToAddressID] [int] NULL,

[BillToAddressID] [int] NULL,

[ShipMethod] [nvarchar](50) NOT NULL,

[CreditCardApprovalCode] [varchar](15) NULL,

[SubTotal] [money] NOT NULL,

[TaxAmt] [money] NOT NULL,

[Freight] [money] NOT NULL,

[TotalDue] AS (isnull(([SubTotal]+[TaxAmt])+[Freight],(0))),

[Comment] [nvarchar](max) NULL,

[rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL,

[ModifiedDate] [datetime] NOT NULL,

CONSTRAINT [PK_SalesOrderHeader_SalesOrderID] PRIMARY KEY CLUSTERED

(

[SalesOrderID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],

CONSTRAINT [AK_SalesOrderHeader_rowguid] UNIQUE NONCLUSTERED

(

[rowguid] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],

CONSTRAINT [AK_SalesOrderHeader_SalesOrderNumber] UNIQUE NONCLUSTERED

(

[SalesOrderNumber] 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

SET ANSI_PADDING ON

GO

/****** Object: Index [IX_Address_AddressLine1_AddressLine2_City_StateProvince_PostalCode_CountryRegion] Script Date: 9/30/20 11:09:34 AM ******/

CREATE NONCLUSTERED INDEX [IX_Address_AddressLine1_AddressLine2_City_StateProvince_PostalCode_CountryRegion] ON [dbo].[Address]

(

[AddressLine1] ASC,

[AddressLine2] ASC,

[City] ASC,

[StateProvince] ASC,

[PostalCode] ASC,

[CountryRegion] 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_Address_StateProvince] Script Date: 9/30/20 11:09:34 AM ******/

CREATE NONCLUSTERED INDEX [IX_Address_StateProvince] ON [dbo].[Address]

(

[StateProvince] 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_Customer_EmailAddress] Script Date: 9/30/20 11:09:34 AM ******/

CREATE NONCLUSTERED INDEX [IX_Customer_EmailAddress] ON [dbo].[Customer]

(

[EmailAddress] 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_SalesOrderDetail_ProductID] Script Date: 9/30/20 11:09:34 AM ******/

CREATE NONCLUSTERED INDEX [IX_SalesOrderDetail_ProductID] ON [dbo].[SalesOrderDetail]

(

[ProductID] 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_SalesOrderHeader_CustomerID] Script Date: 9/30/20 11:09:34 AM ******/

CREATE NONCLUSTERED INDEX [IX_SalesOrderHeader_CustomerID] ON [dbo].[SalesOrderHeader]

(

[CustomerID] 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 ARITHABORT ON

SET CONCAT_NULL_YIELDS_NULL ON

SET QUOTED_IDENTIFIER ON

SET ANSI_NULLS ON

SET ANSI_PADDING ON

SET ANSI_WARNINGS ON

SET NUMERIC_ROUNDABORT OFF

GO

/****** Object: Index [PXML_ProductModel_CatalogDescription] Script Date: 9/30/20 11:09:34 AM ******/

CREATE PRIMARY XML INDEX [PXML_ProductModel_CatalogDescription] ON [dbo].[ProductModel]

(

[CatalogDescription]

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)

GO

ALTER TABLE [dbo].[BuildVersion] ADD CONSTRAINT [DF_BuildVersion_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]

GO

ALTER TABLE [dbo].[ErrorLog] ADD CONSTRAINT [DF_ErrorLog_ErrorTime] DEFAULT (getdate()) FOR [ErrorTime]

GO

ALTER TABLE [dbo].[Address] ADD CONSTRAINT [DF_Address_rowguid] DEFAULT (newid()) FOR [rowguid]

GO

ALTER TABLE [dbo].[Address] ADD CONSTRAINT [DF_Address_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]

GO

ALTER TABLE [dbo].[Customer] ADD CONSTRAINT [DF_Customer_NameStyle] DEFAULT ((0)) FOR [NameStyle]

GO

ALTER TABLE [dbo].[Customer] ADD CONSTRAINT [DF_Customer_rowguid] DEFAULT (newid()) FOR [rowguid]

GO

ALTER TABLE [dbo].[Customer] ADD CONSTRAINT [DF_Customer_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]

GO

ALTER TABLE [dbo].[CustomerAddress] ADD CONSTRAINT [DF_CustomerAddress_rowguid] DEFAULT (newid()) FOR [rowguid]

GO

ALTER TABLE [dbo].[CustomerAddress] ADD CONSTRAINT [DF_CustomerAddress_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]

GO

ALTER TABLE [dbo].[Product] ADD CONSTRAINT [DF_Product_rowguid] DEFAULT (newid()) FOR [rowguid]

GO

ALTER TABLE [dbo].[Product] ADD CONSTRAINT [DF_Product_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]

GO

ALTER TABLE [dbo].[ProductCategory] ADD CONSTRAINT [DF_ProductCategory_rowguid] DEFAULT (newid()) FOR [rowguid]

GO

ALTER TABLE [dbo].[ProductCategory] ADD CONSTRAINT [DF_ProductCategory_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]

GO

ALTER TABLE [dbo].[ProductDescription] ADD CONSTRAINT [DF_ProductDescription_rowguid] DEFAULT (newid()) FOR [rowguid]

GO

ALTER TABLE [dbo].[ProductDescription] ADD CONSTRAINT [DF_ProductDescription_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]

GO

ALTER TABLE [dbo].[ProductModel] ADD CONSTRAINT [DF_ProductModel_rowguid] DEFAULT (newid()) FOR [rowguid]

GO

ALTER TABLE [dbo].[ProductModel] ADD CONSTRAINT [DF_ProductModel_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]

GO

ALTER TABLE [dbo].[ProductModelProductDescription] ADD CONSTRAINT [DF_ProductModelProductDescription_rowguid] DEFAULT (newid()) FOR [rowguid]

GO

ALTER TABLE [dbo].[ProductModelProductDescription] ADD CONSTRAINT [DF_ProductModelProductDescription_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]

GO

ALTER TABLE [dbo].[SalesOrderDetail] ADD CONSTRAINT [DF_SalesOrderDetail_UnitPriceDiscount] DEFAULT ((0.0)) FOR [UnitPriceDiscount]

GO

ALTER TABLE [dbo].[SalesOrderDetail] ADD CONSTRAINT [DF_SalesOrderDetail_rowguid] DEFAULT (newid()) FOR [rowguid]

GO

ALTER TABLE [dbo].[SalesOrderDetail] ADD CONSTRAINT [DF_SalesOrderDetail_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]

GO

ALTER TABLE [dbo].[SalesOrderHeader] ADD CONSTRAINT [DF_SalesOrderHeader_RevisionNumber] DEFAULT ((0)) FOR [RevisionNumber]

GO

ALTER TABLE [dbo].[SalesOrderHeader] ADD CONSTRAINT [DF_SalesOrderHeader_OrderDate] DEFAULT (getdate()) FOR [OrderDate]

GO

ALTER TABLE [dbo].[SalesOrderHeader] ADD CONSTRAINT [DF_SalesOrderHeader_Status] DEFAULT ((1)) FOR [Status]

GO

ALTER TABLE [dbo].[SalesOrderHeader] ADD CONSTRAINT [DF_SalesOrderHeader_OnlineOrderFlag] DEFAULT ((1)) FOR [OnlineOrderFlag]

GO

ALTER TABLE [dbo].[SalesOrderHeader] ADD CONSTRAINT [DF_SalesOrderHeader_SubTotal] DEFAULT ((0.00)) FOR [SubTotal]

GO

ALTER TABLE [dbo].[SalesOrderHeader] ADD CONSTRAINT [DF_SalesOrderHeader_TaxAmt] DEFAULT ((0.00)) FOR [TaxAmt]

GO

ALTER TABLE [dbo].[SalesOrderHeader] ADD CONSTRAINT [DF_SalesOrderHeader_Freight] DEFAULT ((0.00)) FOR [Freight]

GO

ALTER TABLE [dbo].[SalesOrderHeader] ADD CONSTRAINT [DF_SalesOrderHeader_rowguid] DEFAULT (newid()) FOR [rowguid]

GO

ALTER TABLE [dbo].[SalesOrderHeader] ADD CONSTRAINT [DF_SalesOrderHeader_ModifiedDate] DEFAULT (getdate()) FOR [ModifiedDate]

GO

ALTER TABLE [dbo].[CustomerAddress] WITH CHECK ADD CONSTRAINT [FK_CustomerAddress_Address_AddressID] FOREIGN KEY([AddressID])

REFERENCES [dbo].[Address] ([AddressID])

GO

ALTER TABLE [dbo].[CustomerAddress] CHECK CONSTRAINT [FK_CustomerAddress_Address_AddressID]

GO

ALTER TABLE [dbo].[CustomerAddress] WITH CHECK ADD CONSTRAINT [FK_CustomerAddress_Customer_CustomerID] FOREIGN KEY([CustomerID])

REFERENCES [dbo].[Customer] ([CustomerID])

GO

ALTER TABLE [dbo].[CustomerAddress] CHECK CONSTRAINT [FK_CustomerAddress_Customer_CustomerID]

GO

ALTER TABLE [dbo].[Product] WITH CHECK ADD CONSTRAINT [FK_Product_ProductCategory_ProductCategoryID] FOREIGN KEY([ProductCategoryID])

REFERENCES [dbo].[ProductCategory] ([ProductCategoryID])

GO

ALTER TABLE [dbo].[Product] CHECK CONSTRAINT [FK_Product_ProductCategory_ProductCategoryID]

GO

ALTER TABLE [dbo].[Product] WITH CHECK ADD CONSTRAINT [FK_Product_ProductModel_ProductModelID] FOREIGN KEY([ProductModelID])

REFERENCES [dbo].[ProductModel] ([ProductModelID])

GO

ALTER TABLE [dbo].[Product] CHECK CONSTRAINT [FK_Product_ProductModel_ProductModelID]

GO

ALTER TABLE [dbo].[ProductCategory] WITH CHECK ADD CONSTRAINT [FK_ProductCategory_ProductCategory_ParentProductCategoryID_ProductCategoryID] FOREIGN KEY([ParentProductCategoryID])

REFERENCES [dbo].[ProductCategory] ([ProductCategoryID])

GO

ALTER TABLE [dbo].[ProductCategory] CHECK CONSTRAINT [FK_ProductCategory_ProductCategory_ParentProductCategoryID_ProductCategoryID]

GO

ALTER TABLE [dbo].[ProductModelProductDescription] WITH CHECK ADD CONSTRAINT [FK_ProductModelProductDescription_ProductDescription_ProductDescriptionID] FOREIGN KEY([ProductDescriptionID])

REFERENCES [dbo].[ProductDescription] ([ProductDescriptionID])

GO

ALTER TABLE [dbo].[ProductModelProductDescription] CHECK CONSTRAINT [FK_ProductModelProductDescription_ProductDescription_ProductDescriptionID]

GO

ALTER TABLE [dbo].[ProductModelProductDescription] WITH CHECK ADD CONSTRAINT [FK_ProductModelProductDescription_ProductModel_ProductModelID] FOREIGN KEY([ProductModelID])

REFERENCES [dbo].[ProductModel] ([ProductModelID])

GO

ALTER TABLE [dbo].[ProductModelProductDescription] CHECK CONSTRAINT [FK_ProductModelProductDescription_ProductModel_ProductModelID]

GO

ALTER TABLE [dbo].[SalesOrderDetail] WITH CHECK ADD CONSTRAINT [FK_SalesOrderDetail_Product_ProductID] FOREIGN KEY([ProductID])

REFERENCES [dbo].[Product] ([ProductID])

GO

ALTER TABLE [dbo].[SalesOrderDetail] CHECK CONSTRAINT [FK_SalesOrderDetail_Product_ProductID]

GO

ALTER TABLE [dbo].[SalesOrderDetail] WITH CHECK ADD CONSTRAINT [FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID] FOREIGN KEY([SalesOrderID])

REFERENCES [dbo].[SalesOrderHeader] ([SalesOrderID])

ON DELETE CASCADE

GO

ALTER TABLE [dbo].[SalesOrderDetail] CHECK CONSTRAINT [FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID]

GO

ALTER TABLE [dbo].[SalesOrderHeader] WITH CHECK ADD CONSTRAINT [FK_SalesOrderHeader_Address_BillTo_AddressID] FOREIGN KEY([BillToAddressID])

REFERENCES [dbo].[Address] ([AddressID])

GO

ALTER TABLE [dbo].[SalesOrderHeader] CHECK CONSTRAINT [FK_SalesOrderHeader_Address_BillTo_AddressID]

GO

ALTER TABLE [dbo].[SalesOrderHeader] WITH CHECK ADD CONSTRAINT [FK_SalesOrderHeader_Address_ShipTo_AddressID] FOREIGN KEY([ShipToAddressID])

REFERENCES [dbo].[Address] ([AddressID])

GO

ALTER TABLE [dbo].[SalesOrderHeader] CHECK CONSTRAINT [FK_SalesOrderHeader_Address_ShipTo_AddressID]

GO

ALTER TABLE [dbo].[SalesOrderHeader] WITH CHECK ADD CONSTRAINT [FK_SalesOrderHeader_Customer_CustomerID] FOREIGN KEY([CustomerID])

REFERENCES [dbo].[Customer] ([CustomerID])

GO

ALTER TABLE [dbo].[SalesOrderHeader] CHECK CONSTRAINT [FK_SalesOrderHeader_Customer_CustomerID]

GO

ALTER TABLE [dbo].[Product] WITH NOCHECK ADD CONSTRAINT [CK_Product_ListPrice] CHECK (([ListPrice]>=(0.00)))

GO

ALTER TABLE [dbo].[Product] CHECK CONSTRAINT [CK_Product_ListPrice]

GO

ALTER TABLE [dbo].[Product] WITH NOCHECK ADD CONSTRAINT [CK_Product_SellEndDate] CHECK (([SellEndDate]>=[SellStartDate] OR [SellEndDate] IS NULL))

GO

ALTER TABLE [dbo].[Product] CHECK CONSTRAINT [CK_Product_SellEndDate]

GO

ALTER TABLE [dbo].[Product] WITH NOCHECK ADD CONSTRAINT [CK_Product_StandardCost] CHECK (([StandardCost]>=(0.00)))

GO

ALTER TABLE [dbo].[Product] CHECK CONSTRAINT [CK_Product_StandardCost]

GO

ALTER TABLE [dbo].[Product] WITH NOCHECK ADD CONSTRAINT [CK_Product_Weight] CHECK (([Weight]>(0.00)))

GO

ALTER TABLE [dbo].[Product] CHECK CONSTRAINT [CK_Product_Weight]

GO

ALTER TABLE [dbo].[SalesOrderDetail] WITH NOCHECK ADD CONSTRAINT [CK_SalesOrderDetail_OrderQty] CHECK (([OrderQty]>(0)))

GO

ALTER TABLE [dbo].[SalesOrderDetail] CHECK CONSTRAINT [CK_SalesOrderDetail_OrderQty]

GO

ALTER TABLE [dbo].[SalesOrderDetail] WITH NOCHECK ADD CONSTRAINT [CK_SalesOrderDetail_UnitPrice] CHECK (([UnitPrice]>=(0.00)))

GO

ALTER TABLE [dbo].[SalesOrderDetail] CHECK CONSTRAINT [CK_SalesOrderDetail_UnitPrice]

GO

ALTER TABLE [dbo].[SalesOrderDetail] WITH NOCHECK ADD CONSTRAINT [CK_SalesOrderDetail_UnitPriceDiscount] CHECK (([UnitPriceDiscount]>=(0.00)))

GO

ALTER TABLE [dbo].[SalesOrderDetail] CHECK CONSTRAINT [CK_SalesOrderDetail_UnitPriceDiscount]

GO

ALTER TABLE [dbo].[SalesOrderHeader] WITH NOCHECK ADD CONSTRAINT [CK_SalesOrderHeader_DueDate] CHECK (([DueDate]>=[OrderDate]))

GO

ALTER TABLE [dbo].[SalesOrderHeader] CHECK CONSTRAINT [CK_SalesOrderHeader_DueDate]

GO

ALTER TABLE [dbo].[SalesOrderHeader] WITH NOCHECK ADD CONSTRAINT [CK_SalesOrderHeader_Freight] CHECK (([Freight]>=(0.00)))

GO

ALTER TABLE [dbo].[SalesOrderHeader] CHECK CONSTRAINT [CK_SalesOrderHeader_Freight]

GO

ALTER TABLE [dbo].[SalesOrderHeader] WITH NOCHECK ADD CONSTRAINT [CK_SalesOrderHeader_ShipDate] CHECK (([ShipDate]>=[OrderDate] OR [ShipDate] IS NULL))

GO

ALTER TABLE [dbo].[SalesOrderHeader] CHECK CONSTRAINT [CK_SalesOrderHeader_ShipDate]

GO

ALTER TABLE [dbo].[SalesOrderHeader] WITH NOCHECK ADD CONSTRAINT [CK_SalesOrderHeader_Status] CHECK (([Status]>=(0) AND [Status]<=(8)))

GO

ALTER TABLE [dbo].[SalesOrderHeader] CHECK CONSTRAINT [CK_SalesOrderHeader_Status]

GO

ALTER TABLE [dbo].[SalesOrderHeader] WITH NOCHECK ADD CONSTRAINT [CK_SalesOrderHeader_SubTotal] CHECK (([SubTotal]>=(0.00)))

GO

ALTER TABLE [dbo].[SalesOrderHeader] CHECK CONSTRAINT [CK_SalesOrderHeader_SubTotal]

GO

ALTER TABLE [dbo].[SalesOrderHeader] WITH NOCHECK ADD CONSTRAINT [CK_SalesOrderHeader_TaxAmt] CHECK (([TaxAmt]>=(0.00)))

GO

ALTER TABLE [dbo].[SalesOrderHeader] CHECK CONSTRAINT [CK_SalesOrderHeader_TaxAmt]

GO

/****** Object: StoredProcedure [dbo].[uspLogError] Script Date: 9/30/20 11:09:34 AM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- uspLogError logs error information in the ErrorLog table about the

-- error that caused execution to jump to the CATCH block of a

-- TRY...CATCH construct. This should be executed from within the scope

-- of a CATCH block otherwise it will return without inserting error

-- information.

CREATE PROCEDURE [dbo].[uspLogError]

@ErrorLogID [int] = 0 OUTPUT -- contains the ErrorLogID of the row inserted

AS -- by uspLogError in the ErrorLog table

BEGIN

SET NOCOUNT ON;

-- Output parameter value of 0 indicates that error

-- information was not logged

SET @ErrorLogID = 0;

BEGIN TRY

-- Return if there is no error information to log

IF ERROR_NUMBER() IS NULL

RETURN;

-- Return if inside an uncommittable transaction.

-- Data insertion/modification is not allowed when

-- a transaction is in an uncommittable state.

IF XACT_STATE() = -1

BEGIN

PRINT 'Cannot log error since the current transaction is in an uncommittable state. '

+ 'Rollback the transaction before executing uspLogError in order to successfully log error information.';

RETURN;

END

INSERT [dbo].[ErrorLog]

(

[UserName],

[ErrorNumber],

[ErrorSeverity],

[ErrorState],

[ErrorProcedure],

[ErrorLine],

[ErrorMessage]

)

VALUES

(

CONVERT(sysname, CURRENT_USER),

ERROR_NUMBER(),

ERROR_SEVERITY(),

ERROR_STATE(),

ERROR_PROCEDURE(),

ERROR_LINE(),

ERROR_MESSAGE()

);

-- Pass back the ErrorLogID of the row inserted

SET @ErrorLogID = @@IDENTITY;

END TRY

BEGIN CATCH

PRINT 'An error occurred in stored procedure uspLogError: ';

EXECUTE [dbo].[uspPrintError];

RETURN -1;

END CATCH

END;

GO

/****** Object: StoredProcedure [dbo].[uspPrintError] Script Date: 9/30/20 11:09:34 AM ******/

SET ANSI_NULLS ON

GO