/*******
This script recreates the K2 Learning Database which is used for K2 training and tutorials. 
You can modify and execute this script on any SQL 2019 instance if required. 
Note that this script is not supported by K2 and is only provided for cases where it is 
necessary to install the K2Learning database locally for training or testing purposes
You will likely need to edit the script for your specific SQL instance and security requirements


Script Date: 6 October 2022
Script Version: 1.1
********/

/**DATABASE**/
USE [master]
GO
/****** Object:  Database [K2Learning]    Script Date: 10/6/2022 2:04:33 PM ******/
CREATE DATABASE [K2Learning]
GO

USE [K2Learning]
GO

/****** Object:  Schema [Denallix]    Script Date: 10/6/2022 2:04:33 PM ******/
IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'Denallix')
EXEC sys.sp_executesql N'CREATE SCHEMA [Denallix]'

GO
/****** Object:  Schema [Finance]    Script Date: 10/6/2022 2:04:33 PM ******/
IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'Finance')
EXEC sys.sp_executesql N'CREATE SCHEMA [Finance]'

GO
/****** Object:  Schema [HumanResources]    Script Date: 10/6/2022 2:04:33 PM ******/
IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'HumanResources')
EXEC sys.sp_executesql N'CREATE SCHEMA [HumanResources]'

GO
/****** Object:  Schema [Sales]    Script Date: 10/6/2022 2:04:33 PM ******/
IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'Sales')
EXEC sys.sp_executesql N'CREATE SCHEMA [Sales]'

GO

/**TABLES**/
/****** Object:  Table [Finance].[ExpenseCategory]    Script Date: 10/6/2022 2:04:33 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Finance].[ExpenseCategory](
	[ExpenseCategoryId] [int] IDENTITY(1,1) NOT NULL,
	[ExpenseCategoryName] [nvarchar](50) NOT NULL,
	[ExpenseCategoryCode] [nchar](10) NULL,
 CONSTRAINT [PK_Finance.ExpenseCategory] PRIMARY KEY CLUSTERED 
(
	[ExpenseCategoryId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)


/****** Object:  Table [Denallix].[Department]    Script Date: 10/6/2022 2:04:33 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Denallix].[Department]') AND type in (N'U'))
BEGIN
CREATE TABLE [Denallix].[Department](
	[DepartmentId] [int] IDENTITY(1,1) NOT NULL,
	[DepartmentName] [nvarchar](50) NOT NULL,
	[DepartmentManager] [nvarchar](30) NULL,
 CONSTRAINT [PK_Denallix.Department] PRIMARY KEY CLUSTERED 
(
	[DepartmentId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
END
GO
/****** Object:  Table [Denallix].[Region]    Script Date: 10/6/2022 2:04:33 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Denallix].[Region]') AND type in (N'U'))
BEGIN
CREATE TABLE [Denallix].[Region](
	[RegionId] [int] IDENTITY(1,1) NOT NULL,
	[RegionName] [nvarchar](50) NULL,
	[RegionVPLoginName] [nvarchar](50) NULL,
 CONSTRAINT [PK_Denallix.Region] PRIMARY KEY CLUSTERED 
(
	[RegionId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
END
GO

/****** Object:  Table [HumanResources].[LeaveType]    Script Date: 10/6/2022 2:04:33 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[HumanResources].[LeaveType]') AND type in (N'U'))
BEGIN
CREATE TABLE [HumanResources].[LeaveType](
	[LeaveTypeId] [int] IDENTITY(1,1) NOT NULL,
	[LeaveTypeDescription] [nvarchar](20) NOT NULL,
 CONSTRAINT [PK_HumanResources.LeaveType] PRIMARY KEY CLUSTERED 
(
	[LeaveTypeId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
END
GO
/****** Object:  Table [Sales].[Customer]    Script Date: 10/6/2022 2:04:33 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Sales].[Customer]') AND type in (N'U'))
BEGIN
CREATE TABLE [Sales].[Customer](
	[CustomerId] [int] IDENTITY(1,1) NOT NULL,
	[CustomerName] [nvarchar](50) NULL,
	[ContactPerson] [nvarchar](50) NULL,
	[Telephone] [nvarchar](50) NULL,
	[Email] [nvarchar](50) NULL,
	[DiscountRate] [decimal](4, 2) NULL,
	[BillingAddressLine1] [nvarchar](50) NULL,
	[BillingAddressLine2] [nvarchar](50) NULL,
	[BillingAddressCity] [nvarchar](50) NULL,
	[BillingAddressCountry] [int] NULL,
	[BillingAddressPostalCode] [nchar](10) NULL,
	[Rating] [int] NULL,
	[AccountManager] [int] NULL,
	[DenallixRegion] [int] NULL,
 CONSTRAINT [PK_Sales.Customer] PRIMARY KEY CLUSTERED 
(
	[CustomerId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
END
GO
/****** Object:  Table [Sales].[Product]    Script Date: 10/6/2022 2:04:33 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Sales].[Product]') AND type in (N'U'))
BEGIN
CREATE TABLE [Sales].[Product](
	[ProductId] [int] IDENTITY(1,1) NOT NULL,
	[ProductName] [nvarchar](50) NULL,
	[Description] [nvarchar](max) NULL,
	[ProductNumber] [nvarchar](20) NULL,
	[Cost] [money] NULL,
	[ListPrice] [money] NULL,
	[Discontinued] [bit] NULL,
	[AverageRating] [int] NULL,
	[ImageURL] [nvarchar](50) NULL,
 CONSTRAINT [PK_Denallix.Product] PRIMARY KEY CLUSTERED 
(
	[ProductId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
)
END
GO

/**DATA**/
SET IDENTITY_INSERT [Denallix].[Department] ON 
GO
INSERT [Denallix].[Department] ([DepartmentId], [DepartmentName], [DepartmentManager]) VALUES (1, N'Finance', N'denallix\bob')
GO
INSERT [Denallix].[Department] ([DepartmentId], [DepartmentName], [DepartmentManager]) VALUES (2, N'Human Resources', N'denallix\dennis')
GO
INSERT [Denallix].[Department] ([DepartmentId], [DepartmentName], [DepartmentManager]) VALUES (3, N'Legal', N'denallix\chris')
GO
INSERT [Denallix].[Department] ([DepartmentId], [DepartmentName], [DepartmentManager]) VALUES (4, N'Sales', N'denallix\barry')
GO
INSERT [Denallix].[Department] ([DepartmentId], [DepartmentName], [DepartmentManager]) VALUES (5, N'Operations', N'denallix\rob')
GO
INSERT [Denallix].[Department] ([DepartmentId], [DepartmentName], [DepartmentManager]) VALUES (6, N'Headquarters', N'denallix\mark')
GO
SET IDENTITY_INSERT [Denallix].[Department] OFF
GO

SET IDENTITY_INSERT [Denallix].[Region] ON 
GO
INSERT [Denallix].[Region] ([RegionId], [RegionName], [RegionVPLoginName]) VALUES (1, N'Americas', N'denallix\brandon')
GO
INSERT [Denallix].[Region] ([RegionId], [RegionName], [RegionVPLoginName]) VALUES (2, N'EMEA', N'denallix\erica')
GO
INSERT [Denallix].[Region] ([RegionId], [RegionName], [RegionVPLoginName]) VALUES (3, N'AsiaPacific', N'denallix\mark')
GO
SET IDENTITY_INSERT [Denallix].[Region] OFF
GO

SET IDENTITY_INSERT [Finance].[ExpenseCategory] ON 
GO
INSERT [Finance].[ExpenseCategory] ([ExpenseCategoryId], [ExpenseCategoryName], [ExpenseCategoryCode]) VALUES (1, N'Airfare', N'T100      ')
GO
INSERT [Finance].[ExpenseCategory] ([ExpenseCategoryId], [ExpenseCategoryName], [ExpenseCategoryCode]) VALUES (2, N'Car Rental', N'T200      ')
GO
INSERT [Finance].[ExpenseCategory] ([ExpenseCategoryId], [ExpenseCategoryName], [ExpenseCategoryCode]) VALUES (3, N'Other Transportation', N'T900      ')
GO
INSERT [Finance].[ExpenseCategory] ([ExpenseCategoryId], [ExpenseCategoryName], [ExpenseCategoryCode]) VALUES (4, N'Client Entertainment', N'C500      ')
GO
INSERT [Finance].[ExpenseCategory] ([ExpenseCategoryId], [ExpenseCategoryName], [ExpenseCategoryCode]) VALUES (5, N'Business Meeting Meals', N'C400      ')
GO
INSERT [Finance].[ExpenseCategory] ([ExpenseCategoryId], [ExpenseCategoryName], [ExpenseCategoryCode]) VALUES (6, N'Company Meetings', N'C300      ')
GO
INSERT [Finance].[ExpenseCategory] ([ExpenseCategoryId], [ExpenseCategoryName], [ExpenseCategoryCode]) VALUES (7, N'Computer Equipment', N'O400      ')
GO
INSERT [Finance].[ExpenseCategory] ([ExpenseCategoryId], [ExpenseCategoryName], [ExpenseCategoryCode]) VALUES (8, N'Office Equipment', N'O300      ')
GO
INSERT [Finance].[ExpenseCategory] ([ExpenseCategoryId], [ExpenseCategoryName], [ExpenseCategoryCode]) VALUES (9, N'Cell phones', N'O200      ')
GO
INSERT [Finance].[ExpenseCategory] ([ExpenseCategoryId], [ExpenseCategoryName], [ExpenseCategoryCode]) VALUES (10, N'Home Office Expenses', N'O100      ')
GO
INSERT [Finance].[ExpenseCategory] ([ExpenseCategoryId], [ExpenseCategoryName], [ExpenseCategoryCode]) VALUES (11, N'Accomodation', N'T400      ')
GO
INSERT [Finance].[ExpenseCategory] ([ExpenseCategoryId], [ExpenseCategoryName], [ExpenseCategoryCode]) VALUES (12, N'Professional Memberships', N'E400      ')
GO
INSERT [Finance].[ExpenseCategory] ([ExpenseCategoryId], [ExpenseCategoryName], [ExpenseCategoryCode]) VALUES (13, N'Training and Education', N'E200      ')
GO
INSERT [Finance].[ExpenseCategory] ([ExpenseCategoryId], [ExpenseCategoryName], [ExpenseCategoryCode]) VALUES (14, N'Relocation Costs', N'E300      ')
GO
INSERT [Finance].[ExpenseCategory] ([ExpenseCategoryId], [ExpenseCategoryName], [ExpenseCategoryCode]) VALUES (15, N'Employee vehicle use', N'T300      ')
GO
INSERT [Finance].[ExpenseCategory] ([ExpenseCategoryId], [ExpenseCategoryName], [ExpenseCategoryCode]) VALUES (16, N'Other Business Travel', N'T999      ')
GO
INSERT [Finance].[ExpenseCategory] ([ExpenseCategoryId], [ExpenseCategoryName], [ExpenseCategoryCode]) VALUES (17, N'Other Employee Expenses', N'E999      ')
GO
INSERT [Finance].[ExpenseCategory] ([ExpenseCategoryId], [ExpenseCategoryName], [ExpenseCategoryCode]) VALUES (18, N'Conference Vendor Expenses', N'C100      ')
GO
INSERT [Finance].[ExpenseCategory] ([ExpenseCategoryId], [ExpenseCategoryName], [ExpenseCategoryCode]) VALUES (19, N'Conference Attendee Expenses', N'C200      ')
GO
INSERT [Finance].[ExpenseCategory] ([ExpenseCategoryId], [ExpenseCategoryName], [ExpenseCategoryCode]) VALUES (20, N'Other Company Expenses', N'C999      ')
GO
SET IDENTITY_INSERT [Finance].[ExpenseCategory] OFF
GO

SET IDENTITY_INSERT [HumanResources].[LeaveType] ON 
GO
INSERT [HumanResources].[LeaveType] ([LeaveTypeId], [LeaveTypeDescription]) VALUES (1, N'Vacation Leave')
GO
INSERT [HumanResources].[LeaveType] ([LeaveTypeId], [LeaveTypeDescription]) VALUES (2, N'Sick Leave')
GO
INSERT [HumanResources].[LeaveType] ([LeaveTypeId], [LeaveTypeDescription]) VALUES (3, N'Study Leave')
GO
INSERT [HumanResources].[LeaveType] ([LeaveTypeId], [LeaveTypeDescription]) VALUES (4, N'Discretionary Leave')
GO
INSERT [HumanResources].[LeaveType] ([LeaveTypeId], [LeaveTypeDescription]) VALUES (5, N'Unpaid Leave')
GO
SET IDENTITY_INSERT [HumanResources].[LeaveType] OFF
GO

SET IDENTITY_INSERT [Sales].[Customer] ON 
GO
INSERT [Sales].[Customer] ([CustomerId], [CustomerName], [ContactPerson], [Telephone], [Email], [DiscountRate], [BillingAddressLine1], [BillingAddressLine2], [BillingAddressCity], [BillingAddressCountry], [BillingAddressPostalCode], [Rating], [AccountManager], [DenallixRegion]) VALUES (1, N'ACME Rockets', N'Robert C. Trevino', N'267-217-1527', N'RobertCTrevino@acmerockets.com', CAST(1.00 AS Decimal(4, 2)), N'1666 Werninger Street', NULL, N'Houston', 1, N'89506     ', 5, 27, 1)
GO
INSERT [Sales].[Customer] ([CustomerId], [CustomerName], [ContactPerson], [Telephone], [Email], [DiscountRate], [BillingAddressLine1], [BillingAddressLine2], [BillingAddressCity], [BillingAddressCountry], [BillingAddressPostalCode], [Rating], [AccountManager], [DenallixRegion]) VALUES (2, N'Jim''s Bikes', N'Alvina Adelson', N'954-463-7983', N'Alvina@jimsbikes.com', CAST(1.00 AS Decimal(4, 2)), N'3905 Snider Street', NULL, N'Englewood', 1, N'03590     ', 5, 28, 1)
GO
INSERT [Sales].[Customer] ([CustomerId], [CustomerName], [ContactPerson], [Telephone], [Email], [DiscountRate], [BillingAddressLine1], [BillingAddressLine2], [BillingAddressCity], [BillingAddressCountry], [BillingAddressPostalCode], [Rating], [AccountManager], [DenallixRegion]) VALUES (3, N'Booker and Co.', N'Andrew Everett', N'540-742-6015', N'AndrewREverett@booker.biz', CAST(1.00 AS Decimal(4, 2)), N'4594 Atha Drive', N'Suite 204', N'Ontario', 2, N'93534     ', 5, 28, 1)
GO
INSERT [Sales].[Customer] ([CustomerId], [CustomerName], [ContactPerson], [Telephone], [Email], [DiscountRate], [BillingAddressLine1], [BillingAddressLine2], [BillingAddressCity], [BillingAddressCountry], [BillingAddressPostalCode], [Rating], [AccountManager], [DenallixRegion]) VALUES (4, N'Holloway & Son', N'Vicki Oliphant', N'079 0780 4491', N'voli@holloway.co.uk', CAST(1.00 AS Decimal(4, 2)), N'95 Boat Lane', N'Suite 306', N'REYDON', 7, N'NE48 3DR  ', 4, 25, 2)
GO
INSERT [Sales].[Customer] ([CustomerId], [CustomerName], [ContactPerson], [Telephone], [Email], [DiscountRate], [BillingAddressLine1], [BillingAddressLine2], [BillingAddressCity], [BillingAddressCountry], [BillingAddressPostalCode], [Rating], [AccountManager], [DenallixRegion]) VALUES (5, N'Perk Up Products', N'Smilla Lundqvist', N'070-3435139', N'smilla@pup.com', CAST(1.00 AS Decimal(4, 2)), N'Storgatan 98', NULL, N'ORNO', 10, N'244 83    ', 5, 30, 2)
GO
INSERT [Sales].[Customer] ([CustomerId], [CustomerName], [ContactPerson], [Telephone], [Email], [DiscountRate], [BillingAddressLine1], [BillingAddressLine2], [BillingAddressCity], [BillingAddressCountry], [BillingAddressPostalCode], [Rating], [AccountManager], [DenallixRegion]) VALUES (6, N'Flugelbinder', N'Maximilian Friedmann', N'04321 88 65 49', N'max@flugels.net', CAST(1.00 AS Decimal(4, 2)), N'Budapester Strasse 67', NULL, N'Berlin', 9, N'54531     ', 3, 25, 2)
GO
INSERT [Sales].[Customer] ([CustomerId], [CustomerName], [ContactPerson], [Telephone], [Email], [DiscountRate], [BillingAddressLine1], [BillingAddressLine2], [BillingAddressCity], [BillingAddressCountry], [BillingAddressPostalCode], [Rating], [AccountManager], [DenallixRegion]) VALUES (7, N'Metro Inc', N'Geoffrey Bernier', N'03.87.28.74.75', N'GeoffreyBernier@metro.biz', CAST(1.00 AS Decimal(4, 2)), N'1, Chemin Challet', NULL, N'LILLE', 8, N'59800     ', 5, 29, 2)
GO
INSERT [Sales].[Customer] ([CustomerId], [CustomerName], [ContactPerson], [Telephone], [Email], [DiscountRate], [BillingAddressLine1], [BillingAddressLine2], [BillingAddressCity], [BillingAddressCountry], [BillingAddressPostalCode], [Rating], [AccountManager], [DenallixRegion]) VALUES (8, N'Ajay and Son', N'Girisha Debdan Mullur ', N'+(91)-(22)-2545222', N'gdm@ajay.com', CAST(1.00 AS Decimal(4, 2)), N'3A,Abhijit Annexe,11th Cross', NULL, N'Mumbai', 15, N'110092    ', 4, 26, 3)
GO
INSERT [Sales].[Customer] ([CustomerId], [CustomerName], [ContactPerson], [Telephone], [Email], [DiscountRate], [BillingAddressLine1], [BillingAddressLine2], [BillingAddressCity], [BillingAddressCountry], [BillingAddressPostalCode], [Rating], [AccountManager], [DenallixRegion]) VALUES (9, N'LitePak', N'Mahesh Kistna Singh ', N'+(91)-(24)-25452177', N'msingh@litepak.net', CAST(1.00 AS Decimal(4, 2)), N'Windsor IT Park Tower B 7th Floor A1', NULL, N'Bangalore', 15, N'560003    ', 5, 26, 3)
GO
INSERT [Sales].[Customer] ([CustomerId], [CustomerName], [ContactPerson], [Telephone], [Email], [DiscountRate], [BillingAddressLine1], [BillingAddressLine2], [BillingAddressCity], [BillingAddressCountry], [BillingAddressPostalCode], [Rating], [AccountManager], [DenallixRegion]) VALUES (10, N'Sunrise Systems', N'Mariko Nanami Hamasaki ', N'(12)-3-4567-8910', N'sales@sunrise.co.jp', CAST(1.00 AS Decimal(4, 2)), N'236-1 tsunekuni', NULL, N'toyama ken', 18, N'5689411   ', 3, 25, 3)
GO
INSERT [Sales].[Customer] ([CustomerId], [CustomerName], [ContactPerson], [Telephone], [Email], [DiscountRate], [BillingAddressLine1], [BillingAddressLine2], [BillingAddressCity], [BillingAddressCountry], [BillingAddressPostalCode], [Rating], [AccountManager], [DenallixRegion]) VALUES (11, N'Gardner and Co', N'Jasper Wanganeen', N'(02) 6733 8439', N'JasperWanganeen@gardner.com.au', CAST(1.00 AS Decimal(4, 2)), N'36 Balonne Street', NULL, N'WESTERN CREEK', 19, N'4357      ', 4, 25, 3)
GO
INSERT [Sales].[Customer] ([CustomerId], [CustomerName], [ContactPerson], [Telephone], [Email], [DiscountRate], [BillingAddressLine1], [BillingAddressLine2], [BillingAddressCity], [BillingAddressCountry], [BillingAddressPostalCode], [Rating], [AccountManager], [DenallixRegion]) VALUES (12, N'Sakura Heavy Industries', N'Makoto Yui Kagome ', N'(12)-3-5436-6579', N'myk@shi.co.jp', CAST(1.00 AS Decimal(4, 2)), N'2-16-1 Konan Shinagawa', NULL, N'Tokyo', 18, N'108-8282  ', 5, 25, 3)
GO
SET IDENTITY_INSERT [Sales].[Customer] OFF
GO

SET IDENTITY_INSERT [Sales].[Product] ON 
GO
INSERT [Sales].[Product] ([ProductId], [ProductName], [Description], [ProductNumber], [Cost], [ListPrice], [Discontinued], [AverageRating], [ImageURL]) VALUES (1, N'Widget', N'Widget with new design', N'111-22', 100.0000, 150.0000, 0, 4, NULL)
GO
INSERT [Sales].[Product] ([ProductId], [ProductName], [Description], [ProductNumber], [Cost], [ListPrice], [Discontinued], [AverageRating], [ImageURL]) VALUES (2, N'Doofer', N'Doofer in Red', N'234-98', 50.0000, 75.0000, 0, 4, NULL)
GO
INSERT [Sales].[Product] ([ProductId], [ProductName], [Description], [ProductNumber], [Cost], [ListPrice], [Discontinued], [AverageRating], [ImageURL]) VALUES (3, N'Thingamajig', N'Blue Thingamajig', N'453-98', 250.0000, 315.0000, 0, 3, NULL)
GO
INSERT [Sales].[Product] ([ProductId], [ProductName], [Description], [ProductNumber], [Cost], [ListPrice], [Discontinued], [AverageRating], [ImageURL]) VALUES (4, N'Thingamabob', N'Round Thingamabob', N'546-76', 1400.0000, 1800.0000, 0, 5, NULL)
GO
INSERT [Sales].[Product] ([ProductId], [ProductName], [Description], [ProductNumber], [Cost], [ListPrice], [Discontinued], [AverageRating], [ImageURL]) VALUES (5, N'Doohickey', N'Orange Doohickey (Large)', N'325-97', 856.0000, 960.0000, 0, 3, NULL)
GO
INSERT [Sales].[Product] ([ProductId], [ProductName], [Description], [ProductNumber], [Cost], [ListPrice], [Discontinued], [AverageRating], [ImageURL]) VALUES (6, N'Doodad', N'Square Doodad with purple dots', N'324-78', 110.0000, 165.0000, 1, 2, NULL)
GO
INSERT [Sales].[Product] ([ProductId], [ProductName], [Description], [ProductNumber], [Cost], [ListPrice], [Discontinued], [AverageRating], [ImageURL]) VALUES (7, N'Gizmo', N'Upgraded Gizmo with accesories', N'435-97', 375.0000, 450.0000, 0, 3, NULL)
GO
INSERT [Sales].[Product] ([ProductId], [ProductName], [Description], [ProductNumber], [Cost], [ListPrice], [Discontinued], [AverageRating], [ImageURL]) VALUES (8, N'Thingy', N'Solar-powered oval thingy', N'452-57', 425.0000, 570.0000, 0, 5, NULL)
GO
SET IDENTITY_INSERT [Sales].[Product] OFF
GO

USE [master]
GO
ALTER DATABASE [K2Learning] SET  READ_WRITE 
GO