CodeEffectsLinqTestDatabase.sql

USE [master]
GO

CREATE DATABASE [CodeEffectsLinqTest]
 CONTAINMENT = NONE
 ON  PRIMARY 
( NAME = N'CodeEffectsLinqTest', FILENAME = N'{Path}\CodeEffectsLinqTest.mdf' , SIZE = 8192KB , FILEGROWTH = 65536KB )
 LOG ON 
( NAME = N'CodeEffectsLinqTest_log', FILENAME = N'{Path}\CodeEffectsLinqTest_log.ldf' , SIZE = 8192KB , FILEGROWTH = 65536KB )
GO
ALTER DATABASE [CodeEffectsLinqTest] SET COMPATIBILITY_LEVEL = 100
GO
ALTER DATABASE [CodeEffectsLinqTest] SET ANSI_NULL_DEFAULT OFF 
GO
ALTER DATABASE [CodeEffectsLinqTest] SET ANSI_NULLS OFF 
GO
ALTER DATABASE [CodeEffectsLinqTest] SET ANSI_PADDING OFF 
GO
ALTER DATABASE [CodeEffectsLinqTest] SET ANSI_WARNINGS OFF 
GO
ALTER DATABASE [CodeEffectsLinqTest] SET ARITHABORT OFF 
GO
ALTER DATABASE [CodeEffectsLinqTest] SET AUTO_CLOSE OFF 
GO
ALTER DATABASE [CodeEffectsLinqTest] SET AUTO_SHRINK OFF 
GO
ALTER DATABASE [CodeEffectsLinqTest] SET AUTO_CREATE_STATISTICS ON(INCREMENTAL = OFF)
GO
ALTER DATABASE [CodeEffectsLinqTest] SET AUTO_UPDATE_STATISTICS ON 
GO
ALTER DATABASE [CodeEffectsLinqTest] SET CURSOR_CLOSE_ON_COMMIT OFF 
GO
ALTER DATABASE [CodeEffectsLinqTest] SET CURSOR_DEFAULT  GLOBAL 
GO
ALTER DATABASE [CodeEffectsLinqTest] SET CONCAT_NULL_YIELDS_NULL OFF 
GO
ALTER DATABASE [CodeEffectsLinqTest] SET NUMERIC_ROUNDABORT OFF 
GO
ALTER DATABASE [CodeEffectsLinqTest] SET QUOTED_IDENTIFIER OFF 
GO
ALTER DATABASE [CodeEffectsLinqTest] SET RECURSIVE_TRIGGERS OFF 
GO
ALTER DATABASE [CodeEffectsLinqTest] SET  DISABLE_BROKER 
GO
ALTER DATABASE [CodeEffectsLinqTest] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
GO
ALTER DATABASE [CodeEffectsLinqTest] SET DATE_CORRELATION_OPTIMIZATION OFF 
GO
ALTER DATABASE [CodeEffectsLinqTest] SET PARAMETERIZATION SIMPLE 
GO
ALTER DATABASE [CodeEffectsLinqTest] SET READ_COMMITTED_SNAPSHOT OFF 
GO
ALTER DATABASE [CodeEffectsLinqTest] SET  READ_WRITE 
GO
ALTER DATABASE [CodeEffectsLinqTest] SET RECOVERY SIMPLE 
GO
ALTER DATABASE [CodeEffectsLinqTest] SET  MULTI_USER 
GO
ALTER DATABASE [CodeEffectsLinqTest] SET PAGE_VERIFY CHECKSUM  
GO
ALTER DATABASE [CodeEffectsLinqTest] SET TARGET_RECOVERY_TIME = 60 SECONDS 
GO
ALTER DATABASE [CodeEffectsLinqTest] SET DELAYED_DURABILITY = DISABLED 
GO
USE [CodeEffectsLinqTest]
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 MAXDOP = 0;
GO
ALTER DATABASE SCOPED CONFIGURATION FOR SECONDARY SET MAXDOP = PRIMARY;
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
USE [CodeEffectsLinqTest]
GO
IF NOT EXISTS (SELECT name FROM sys.filegroups WHERE is_default=1 AND name = N'PRIMARY') ALTER DATABASE [CodeEffectsLinqTest] MODIFY FILEGROUP [PRIMARY] DEFAULT
GO
USE [CodeEffectsLinqTest]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Address](
	[AddressID] [int] IDENTITY(1,1) NOT NULL,
	[CountryID] [int] NOT NULL,
	[Street] [nvarchar](50) NOT NULL,
	[Street2] [nvarchar](50) NULL,
	[City] [nvarchar](50) NULL,
	[State] [nvarchar](30) NULL,
	[PostalCode] [nvarchar](30) NOT NULL,
	[Phone] [varchar](20) NULL,
 CONSTRAINT [PK_Address] 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]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Color](
	[ColorID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](20) NOT NULL,
 CONSTRAINT [PK_Color] PRIMARY KEY CLUSTERED 
(
	[ColorID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Country](
	[CountryID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_Country] PRIMARY KEY CLUSTERED 
(
	[CountryID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Customer](
	[CustomerID] [int] IDENTITY(1,1) NOT NULL,
	[BillingAddressID] [int] NOT NULL,
	[ShippingAddressID] [int] NOT NULL,
	[FirstName] [nvarchar](50) NOT NULL,
	[LastName] [nvarchar](50) NOT NULL,
	[CompanyName] [nvarchar](50) NULL,
	[Email] [varchar](150) NULL,
	[CellPhone] [varchar](20) NULL,
 CONSTRAINT [PK_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) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Manufacturer](
	[ManufacturerID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](50) NOT NULL,
	[Description] [nvarchar](100) NULL,
 CONSTRAINT [PK_Manufacturer] PRIMARY KEY CLUSTERED 
(
	[ManufacturerID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Order](
	[OrderID] [int] IDENTITY(1,1) NOT NULL,
	[CustomerID] [int] NOT NULL,
	[Sub] [money] NOT NULL,
	[Tax] [money] NULL,
	[Freight] [money] NOT NULL,
	[Placed] [datetime] NOT NULL,
	[Paid] [datetime] NULL,
	[Shipped] [datetime] NULL,
 CONSTRAINT [PK_Order] PRIMARY KEY CLUSTERED 
(
	[OrderID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[OrderProduct](
	[OrderID] [int] NOT NULL,
	[ProductID] [int] NOT NULL,
 CONSTRAINT [PK_OrderProduct] PRIMARY KEY CLUSTERED 
(
	[OrderID] ASC,
	[ProductID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Product](
	[ProductID] [int] IDENTITY(1,1) NOT NULL,
	[ManufacturerID] [int] NOT NULL,
	[ProductTypeID] [int] NOT NULL,
	[ColorID] [int] NOT NULL,
	[SizeID] [int] NOT NULL,
	[SKU] [varchar](50) NOT NULL,
	[Description] [nvarchar](100) NULL,
	[Weight] [decimal](8, 2) NULL,
	[Cost] [money] NOT NULL,
	[Manufactured] [date] NOT NULL,
 CONSTRAINT [PK_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) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ProductType](
	[ProductTypeID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](20) NOT NULL,
 CONSTRAINT [PK_ProductType] PRIMARY KEY CLUSTERED 
(
	[ProductTypeID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Size](
	[SizeID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [varchar](10) NOT NULL,
 CONSTRAINT [PK_Size] PRIMARY KEY CLUSTERED 
(
	[SizeID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Address] ON 
GO
INSERT [dbo].[Address] ([AddressID], [CountryID], [Street], [Street2], [City], [State], [PostalCode], [Phone]) VALUES (1, 1, N'574 Main Street', NULL, N'Smileville', N'GA', N'30050', N'770 205 1234')
GO
INSERT [dbo].[Address] ([AddressID], [CountryID], [Street], [Street2], [City], [State], [PostalCode], [Phone]) VALUES (2, 1, N'8374 Easton Str N', N'Suite 200', N'North City', N'PA', N'19036', N'674 378 2736')
GO
INSERT [dbo].[Address] ([AddressID], [CountryID], [Street], [Street2], [City], [State], [PostalCode], [Phone]) VALUES (3, 1, N'625 W Jackson Blvd', N'Unit 2099', N'Chicago', N'IL', N'60610', N'847 284 3244')
GO
INSERT [dbo].[Address] ([AddressID], [CountryID], [Street], [Street2], [City], [State], [PostalCode], [Phone]) VALUES (4, 1, N'6030 Robinson Road', NULL, N'Jefferson', N'MS', N'65101', N'134 546 5423')
GO
INSERT [dbo].[Address] ([AddressID], [CountryID], [Street], [Street2], [City], [State], [PostalCode], [Phone]) VALUES (5, 1, N'99828 Routh Street', N'Suite 459', N'Dallas', N'TX', N'75201', N'713 264 3242')
GO
INSERT [dbo].[Address] ([AddressID], [CountryID], [Street], [Street2], [City], [State], [PostalCode], [Phone]) VALUES (6, 1, N'25500 Old Spanish Trail', NULL, N'Houston', N'TX', N'77003', N'745 835 2009')
GO
INSERT [dbo].[Address] ([AddressID], [CountryID], [Street], [Street2], [City], [State], [PostalCode], [Phone]) VALUES (7, 1, N'One Dancing, Rr No. 25', NULL, N'Round Rock', N'TX', N'78664', N'462 758 4355')
GO
INSERT [dbo].[Address] ([AddressID], [CountryID], [Street], [Street2], [City], [State], [PostalCode], [Phone]) VALUES (8, 1, N'999 Central Entrance', NULL, N'Duluth', N'MN', N'55802', N'118 462 0093')
GO
INSERT [dbo].[Address] ([AddressID], [CountryID], [Street], [Street2], [City], [State], [PostalCode], [Phone]) VALUES (9, 1, N'660 Lindbergh', NULL, N'Saint Louis', N'MO', N'63103', N'894 789 2231')
GO
INSERT [dbo].[Address] ([AddressID], [CountryID], [Street], [Street2], [City], [State], [PostalCode], [Phone]) VALUES (10, 1, N'72540 Blanco Rd', N'Apt. 12A', N'San Antonio', N'TX', N'78204', N'713 253 9988')
GO
INSERT [dbo].[Address] ([AddressID], [CountryID], [Street], [Street2], [City], [State], [PostalCode], [Phone]) VALUES (11, 1, N'25095 W. Florissant', NULL, N'Ferguson', N'MO', N'63135', N'894 287 4021')
GO
INSERT [dbo].[Address] ([AddressID], [CountryID], [Street], [Street2], [City], [State], [PostalCode], [Phone]) VALUES (12, 1, N'7760 N. Pan Am Expwy', NULL, N'San Antonio', N'TX', N'78204', N'713 288 2290')
GO
INSERT [dbo].[Address] ([AddressID], [CountryID], [Street], [Street2], [City], [State], [PostalCode], [Phone]) VALUES (13, 1, N'99433 S. Greenbay Rd.', NULL, N'Racine', N'WI', N'53182', N'280 580 4838')
GO
INSERT [dbo].[Address] ([AddressID], [CountryID], [Street], [Street2], [City], [State], [PostalCode], [Phone]) VALUES (14, 1, N'44025 W. Empire', N'Unit 56', N'Denby', N'SD', N'57716', N'473 288 6100')
GO
INSERT [dbo].[Address] ([AddressID], [CountryID], [Street], [Street2], [City], [State], [PostalCode], [Phone]) VALUES (15, 1, N'23025 S.W. Military Rd', NULL, N'San Antonio', N'TX', N'78204', N'713 819 5778')
GO
INSERT [dbo].[Address] ([AddressID], [CountryID], [Street], [Street2], [City], [State], [PostalCode], [Phone]) VALUES (16, 1, N'855 East Main Av.', NULL, N'Zeeland', N'MI', N'49464', N'289 338 0229')
GO
INSERT [dbo].[Address] ([AddressID], [CountryID], [Street], [Street2], [City], [State], [PostalCode], [Phone]) VALUES (17, 1, N'3700 John R. Rd.', NULL, N'Madison', N'MI', N'48071', N'183 235 4359')
GO
INSERT [dbo].[Address] ([AddressID], [CountryID], [Street], [Street2], [City], [State], [PostalCode], [Phone]) VALUES (18, 1, N'2533 Eureka Rd.', N'Apt.4F', N'Southgate', N'MI', N'48195', N'447 322 4213')
GO
INSERT [dbo].[Address] ([AddressID], [CountryID], [Street], [Street2], [City], [State], [PostalCode], [Phone]) VALUES (19, 1, N'2251 Elliot Avenue', NULL, N'Seattle', N'WA', N'98104', N'778 471 1112')
GO
INSERT [dbo].[Address] ([AddressID], [CountryID], [Street], [Street2], [City], [State], [PostalCode], [Phone]) VALUES (20, 1, N'755 NW Grandstand', NULL, N'Issaquah', N'WA', N'98027', N'748 892 4512')
GO
INSERT [dbo].[Address] ([AddressID], [CountryID], [Street], [Street2], [City], [State], [PostalCode], [Phone]) VALUES (21, 2, N'26910 Indela Road', NULL, N'Montreal', N'Quebec', N'H1Y 2H5', N'238 583 4455')
GO
INSERT [dbo].[Address] ([AddressID], [CountryID], [Street], [Street2], [City], [State], [PostalCode], [Phone]) VALUES (22, 2, N'22580 Free Street', NULL, N'Toronto', N'Ontario', N'M4B 1V7', N'243 574 5679')
GO
INSERT [dbo].[Address] ([AddressID], [CountryID], [Street], [Street2], [City], [State], [PostalCode], [Phone]) VALUES (23, 2, N'2575 Bloor Street East', NULL, N'Toronto', N'Ontario', N'M4B 1V6', N'144 682 4756')
GO
INSERT [dbo].[Address] ([AddressID], [CountryID], [Street], [Street2], [City], [State], [PostalCode], [Phone]) VALUES (24, 2, N'6333 Cote Vertu', NULL, N'Montreal', N'Quebec', N'H1Y 2H7', N'372 584 3111')
GO
INSERT [dbo].[Address] ([AddressID], [CountryID], [Street], [Street2], [City], [State], [PostalCode], [Phone]) VALUES (25, 2, N'600 Slater Street', NULL, N'Ottawa', N'Ontario', N'K4B 1S2', N'483 756 2334')
GO
INSERT [dbo].[Address] ([AddressID], [CountryID], [Street], [Street2], [City], [State], [PostalCode], [Phone]) VALUES (26, 2, N'2560 Bay Street', NULL, N'Toronto', N'Ontario', N'M4B 1V7', N'847 311 0809')
GO
SET IDENTITY_INSERT [dbo].[Address] OFF
GO
SET IDENTITY_INSERT [dbo].[Color] ON 
GO
INSERT [dbo].[Color] ([ColorID], [Name]) VALUES (1, N'White')
GO
INSERT [dbo].[Color] ([ColorID], [Name]) VALUES (2, N'Yellow')
GO
INSERT [dbo].[Color] ([ColorID], [Name]) VALUES (3, N'Pink')
GO
INSERT [dbo].[Color] ([ColorID], [Name]) VALUES (4, N'Red')
GO
INSERT [dbo].[Color] ([ColorID], [Name]) VALUES (5, N'Green')
GO
INSERT [dbo].[Color] ([ColorID], [Name]) VALUES (6, N'Blue')
GO
INSERT [dbo].[Color] ([ColorID], [Name]) VALUES (7, N'Brown')
GO
INSERT [dbo].[Color] ([ColorID], [Name]) VALUES (8, N'Black')
GO
INSERT [dbo].[Color] ([ColorID], [Name]) VALUES (9, N'Orange')
GO
INSERT [dbo].[Color] ([ColorID], [Name]) VALUES (10, N'Purple')
GO
SET IDENTITY_INSERT [dbo].[Color] OFF
GO
SET IDENTITY_INSERT [dbo].[Country] ON 
GO
INSERT [dbo].[Country] ([CountryID], [Name]) VALUES (1, N'United States')
GO
INSERT [dbo].[Country] ([CountryID], [Name]) VALUES (2, N'Canada')
GO
SET IDENTITY_INSERT [dbo].[Country] OFF
GO
SET IDENTITY_INSERT [dbo].[Customer] ON 
GO
INSERT [dbo].[Customer] ([CustomerID], [BillingAddressID], [ShippingAddressID], [FirstName], [LastName], [CompanyName], [Email], [CellPhone]) VALUES (1, 2, 1, N'John', N'Taylor', N'General Techs', N'taylor@gentech.com', N'678 384 2345')
GO
INSERT [dbo].[Customer] ([CustomerID], [BillingAddressID], [ShippingAddressID], [FirstName], [LastName], [CompanyName], [Email], [CellPhone]) VALUES (2, 3, 3, N'Barbara', N'Smith', NULL, N'bsmith@gmail.com', N'793 461 0093')
GO
INSERT [dbo].[Customer] ([CustomerID], [BillingAddressID], [ShippingAddressID], [FirstName], [LastName], [CompanyName], [Email], [CellPhone]) VALUES (3, 4, 5, N'Diemen', N'Brovski', N'Antey Tech', N'd.brovski@antey.url', N'993 442 1887')
GO
INSERT [dbo].[Customer] ([CustomerID], [BillingAddressID], [ShippingAddressID], [FirstName], [LastName], [CompanyName], [Email], [CellPhone]) VALUES (4, 6, 6, N'James', N'Wolson', NULL, N'james@wilsoninc.com', N'894 372 6573')
GO
INSERT [dbo].[Customer] ([CustomerID], [BillingAddressID], [ShippingAddressID], [FirstName], [LastName], [CompanyName], [Email], [CellPhone]) VALUES (5, 7, 7, N'Mary', N'Johnson', N'Bunara Inc.', N'mary@bunara.com', N'574 592 1138')
GO
INSERT [dbo].[Customer] ([CustomerID], [BillingAddressID], [ShippingAddressID], [FirstName], [LastName], [CompanyName], [Email], [CellPhone]) VALUES (6, 8, 8, N'Mak', N'Miller', NULL, N'mark_miller@yahoo.com', N'937 492 1090')
GO
INSERT [dbo].[Customer] ([CustomerID], [BillingAddressID], [ShippingAddressID], [FirstName], [LastName], [CompanyName], [Email], [CellPhone]) VALUES (7, 9, 10, N'Charles', N'Harper', N'Jingles Inc.', N'charlie@jingles.url', N'893 472 4488')
GO
INSERT [dbo].[Customer] ([CustomerID], [BillingAddressID], [ShippingAddressID], [FirstName], [LastName], [CompanyName], [Email], [CellPhone]) VALUES (8, 11, 11, N'Allan', N'Moore', NULL, N'moore38@hotmail.com', N'137 229 5004')
GO
INSERT [dbo].[Customer] ([CustomerID], [BillingAddressID], [ShippingAddressID], [FirstName], [LastName], [CompanyName], [Email], [CellPhone]) VALUES (9, 12, 12, N'Jennifer', N'White', NULL, N'jen.white@att.com', N'849 320 1837')
GO
INSERT [dbo].[Customer] ([CustomerID], [BillingAddressID], [ShippingAddressID], [FirstName], [LastName], [CompanyName], [Email], [CellPhone]) VALUES (10, 13, 13, N'Linda', N'Loebh', NULL, N'linda@monmart.co.uk', N'834 548 2944')
GO
INSERT [dbo].[Customer] ([CustomerID], [BillingAddressID], [ShippingAddressID], [FirstName], [LastName], [CompanyName], [Email], [CellPhone]) VALUES (11, 14, 14, N'Samuel', N'Litovski', N'SamDay, Inc', N'litovski@samday.com', N'787 392 5674')
GO
INSERT [dbo].[Customer] ([CustomerID], [BillingAddressID], [ShippingAddressID], [FirstName], [LastName], [CompanyName], [Email], [CellPhone]) VALUES (12, 15, 16, N'Stephen', N'Brown', NULL, N'sbrown84@gmail.com', N'771 627 1810')
GO
INSERT [dbo].[Customer] ([CustomerID], [BillingAddressID], [ShippingAddressID], [FirstName], [LastName], [CompanyName], [Email], [CellPhone]) VALUES (13, 17, 17, N'Antony', N'Harris', NULL, N'antony85@hotmail.com', N'338 299 8154')
GO
INSERT [dbo].[Customer] ([CustomerID], [BillingAddressID], [ShippingAddressID], [FirstName], [LastName], [CompanyName], [Email], [CellPhone]) VALUES (14, 18, 18, N'Ian', N'Paice', N'Purple, LLC', N'i.paice@purple.co.uk', N'483 758 1948')
GO
INSERT [dbo].[Customer] ([CustomerID], [BillingAddressID], [ShippingAddressID], [FirstName], [LastName], [CompanyName], [Email], [CellPhone]) VALUES (15, 19, 19, N'David', N'Liberman', NULL, N'l.david@hotmail.com', N'849 281 0895')
GO
INSERT [dbo].[Customer] ([CustomerID], [BillingAddressID], [ShippingAddressID], [FirstName], [LastName], [CompanyName], [Email], [CellPhone]) VALUES (16, 21, 21, N'Gregory', N'Brown', N'OnTime, Inc', N'grbrown@yahoo.com', N'284 883 5772')
GO
INSERT [dbo].[Customer] ([CustomerID], [BillingAddressID], [ShippingAddressID], [FirstName], [LastName], [CompanyName], [Email], [CellPhone]) VALUES (17, 22, 22, N'Michael', N'Holton', NULL, N'm.h@hotmail.com', N'738 227 4862')
GO
INSERT [dbo].[Customer] ([CustomerID], [BillingAddressID], [ShippingAddressID], [FirstName], [LastName], [CompanyName], [Email], [CellPhone]) VALUES (18, 23, 23, N'Deborah', N'Nellson', NULL, N'debora@nellson.me', N'448 299 0843')
GO
INSERT [dbo].[Customer] ([CustomerID], [BillingAddressID], [ShippingAddressID], [FirstName], [LastName], [CompanyName], [Email], [CellPhone]) VALUES (19, 24, 25, N'Jeffrey', N'McKenzey', N'MK Design', N'Jeff@mckenzey.com', N'483 199 0755')
GO
INSERT [dbo].[Customer] ([CustomerID], [BillingAddressID], [ShippingAddressID], [FirstName], [LastName], [CompanyName], [Email], [CellPhone]) VALUES (20, 26, 26, N'Hopeton', N'Palm', NULL, N'h_palm@gmail.com', N'477 285 1956')
GO
INSERT [dbo].[Customer] ([CustomerID], [BillingAddressID], [ShippingAddressID], [FirstName], [LastName], [CompanyName], [Email], [CellPhone]) VALUES (21, 20, 20, N'Lessley', N'Davidson', NULL, N'dav_56@gmail.com', N'200 894 2947')
GO
SET IDENTITY_INSERT [dbo].[Customer] OFF
GO
SET IDENTITY_INSERT [dbo].[Manufacturer] ON 
GO
INSERT [dbo].[Manufacturer] ([ManufacturerID], [Name], [Description]) VALUES (1, N'123 Jeans', N'Jeans manufacturer')
GO
INSERT [dbo].[Manufacturer] ([ManufacturerID], [Name], [Description]) VALUES (2, N'Stella Factory', NULL)
GO
INSERT [dbo].[Manufacturer] ([ManufacturerID], [Name], [Description]) VALUES (3, N'ABC Motion', N'General clothing')
GO
INSERT [dbo].[Manufacturer] ([ManufacturerID], [Name], [Description]) VALUES (4, N'Linear', NULL)
GO
INSERT [dbo].[Manufacturer] ([ManufacturerID], [Name], [Description]) VALUES (5, N'Blue Dreams', N'General clothing')
GO
INSERT [dbo].[Manufacturer] ([ManufacturerID], [Name], [Description]) VALUES (6, N'Uniformative', N'Uniform manufacturer')
GO
INSERT [dbo].[Manufacturer] ([ManufacturerID], [Name], [Description]) VALUES (7, N'Bell Cloud', NULL)
GO
INSERT [dbo].[Manufacturer] ([ManufacturerID], [Name], [Description]) VALUES (8, N'Automated Pants', N'Fabrics, supplies')
GO
INSERT [dbo].[Manufacturer] ([ManufacturerID], [Name], [Description]) VALUES (9, N'HJJH', N'General clothing')
GO
INSERT [dbo].[Manufacturer] ([ManufacturerID], [Name], [Description]) VALUES (10, N'White Bird', N'Jeans, t-shirts')
GO
SET IDENTITY_INSERT [dbo].[Manufacturer] OFF
GO
SET IDENTITY_INSERT [dbo].[Order] ON 
GO
INSERT [dbo].[Order] ([OrderID], [CustomerID], [Sub], [Tax], [Freight], [Placed], [Paid], [Shipped]) VALUES (1, 1, 221.9000, 15.5400, 15.9500, CAST(N'2012-09-12T00:00:00.000' AS DateTime), CAST(N'2012-09-12T00:00:00.000' AS DateTime), CAST(N'2012-09-13T00:00:00.000' AS DateTime))
GO
INSERT [dbo].[Order] ([OrderID], [CustomerID], [Sub], [Tax], [Freight], [Placed], [Paid], [Shipped]) VALUES (2, 2, 110.9000, 0.0000, 20.9900, CAST(N'2012-08-30T00:00:00.000' AS DateTime), NULL, NULL)
GO
INSERT [dbo].[Order] ([OrderID], [CustomerID], [Sub], [Tax], [Freight], [Placed], [Paid], [Shipped]) VALUES (3, 3, 99.9500, 0.0000, 9.8900, CAST(N'2012-08-30T00:00:00.000' AS DateTime), CAST(N'2012-08-30T00:00:00.000' AS DateTime), CAST(N'2012-09-02T00:00:00.000' AS DateTime))
GO
INSERT [dbo].[Order] ([OrderID], [CustomerID], [Sub], [Tax], [Freight], [Placed], [Paid], [Shipped]) VALUES (5, 4, 39.3400, 0.0000, 9.9900, CAST(N'2012-09-01T00:00:00.000' AS DateTime), CAST(N'2012-09-01T00:00:00.000' AS DateTime), CAST(N'2012-09-02T00:00:00.000' AS DateTime))
GO
INSERT [dbo].[Order] ([OrderID], [CustomerID], [Sub], [Tax], [Freight], [Placed], [Paid], [Shipped]) VALUES (6, 5, 124.3800, 8.7100, 16.7700, CAST(N'2012-09-02T00:00:00.000' AS DateTime), CAST(N'2012-09-03T00:00:00.000' AS DateTime), CAST(N'2012-09-05T00:00:00.000' AS DateTime))
GO
INSERT [dbo].[Order] ([OrderID], [CustomerID], [Sub], [Tax], [Freight], [Placed], [Paid], [Shipped]) VALUES (7, 6, 67.9000, 0.0000, 8.9900, CAST(N'2012-09-03T00:00:00.000' AS DateTime), CAST(N'2012-09-03T00:00:00.000' AS DateTime), CAST(N'2012-09-04T00:00:00.000' AS DateTime))
GO
INSERT [dbo].[Order] ([OrderID], [CustomerID], [Sub], [Tax], [Freight], [Placed], [Paid], [Shipped]) VALUES (8, 7, 34.6000, 0.0000, 2.9900, CAST(N'2012-09-03T00:00:00.000' AS DateTime), CAST(N'2012-09-03T00:00:00.000' AS DateTime), CAST(N'2012-09-04T00:00:00.000' AS DateTime))
GO
INSERT [dbo].[Order] ([OrderID], [CustomerID], [Sub], [Tax], [Freight], [Placed], [Paid], [Shipped]) VALUES (9, 8, 198.9400, 13.9300, 20.7000, CAST(N'2012-09-03T00:00:00.000' AS DateTime), CAST(N'2012-09-03T00:00:00.000' AS DateTime), CAST(N'2012-09-04T00:00:00.000' AS DateTime))
GO
INSERT [dbo].[Order] ([OrderID], [CustomerID], [Sub], [Tax], [Freight], [Placed], [Paid], [Shipped]) VALUES (10, 9, 78.5200, 0.0000, 4.9000, CAST(N'2012-09-03T00:00:00.000' AS DateTime), CAST(N'2012-09-03T00:00:00.000' AS DateTime), CAST(N'2012-09-05T00:00:00.000' AS DateTime))
GO
INSERT [dbo].[Order] ([OrderID], [CustomerID], [Sub], [Tax], [Freight], [Placed], [Paid], [Shipped]) VALUES (11, 10, 109.5100, 0.0000, 9.9900, CAST(N'2012-09-04T00:00:00.000' AS DateTime), NULL, NULL)
GO
INSERT [dbo].[Order] ([OrderID], [CustomerID], [Sub], [Tax], [Freight], [Placed], [Paid], [Shipped]) VALUES (12, 11, 375.0000, 0.0000, 16.7800, CAST(N'2012-09-04T00:00:00.000' AS DateTime), CAST(N'2012-09-05T00:00:00.000' AS DateTime), CAST(N'2012-09-07T00:00:00.000' AS DateTime))
GO
INSERT [dbo].[Order] ([OrderID], [CustomerID], [Sub], [Tax], [Freight], [Placed], [Paid], [Shipped]) VALUES (13, 12, 46.8000, 0.0000, 7.5600, CAST(N'2012-09-04T00:00:00.000' AS DateTime), CAST(N'2012-09-04T00:00:00.000' AS DateTime), CAST(N'2012-09-06T00:00:00.000' AS DateTime))
GO
INSERT [dbo].[Order] ([OrderID], [CustomerID], [Sub], [Tax], [Freight], [Placed], [Paid], [Shipped]) VALUES (14, 13, 187.3500, 13.1100, 9.9900, CAST(N'2012-09-04T00:00:00.000' AS DateTime), CAST(N'2012-09-04T00:00:00.000' AS DateTime), CAST(N'2012-09-05T00:00:00.000' AS DateTime))
GO
INSERT [dbo].[Order] ([OrderID], [CustomerID], [Sub], [Tax], [Freight], [Placed], [Paid], [Shipped]) VALUES (15, 14, 87.8800, 0.0000, 9.9900, CAST(N'2012-09-05T00:00:00.000' AS DateTime), CAST(N'2012-09-05T00:00:00.000' AS DateTime), CAST(N'2012-09-06T00:00:00.000' AS DateTime))
GO
INSERT [dbo].[Order] ([OrderID], [CustomerID], [Sub], [Tax], [Freight], [Placed], [Paid], [Shipped]) VALUES (16, 15, 298.0000, 0.0000, 23.8000, CAST(N'2012-09-05T00:00:00.000' AS DateTime), CAST(N'2012-09-05T00:00:00.000' AS DateTime), CAST(N'2012-09-07T00:00:00.000' AS DateTime))
GO
INSERT [dbo].[Order] ([OrderID], [CustomerID], [Sub], [Tax], [Freight], [Placed], [Paid], [Shipped]) VALUES (17, 16, 34.5600, 0.0000, 9.9900, CAST(N'2012-09-05T00:00:00.000' AS DateTime), CAST(N'2012-09-05T00:00:00.000' AS DateTime), CAST(N'2012-09-06T00:00:00.000' AS DateTime))
GO
INSERT [dbo].[Order] ([OrderID], [CustomerID], [Sub], [Tax], [Freight], [Placed], [Paid], [Shipped]) VALUES (18, 4, 46.0900, 0.0000, 9.9900, CAST(N'2012-09-05T00:00:00.000' AS DateTime), CAST(N'2012-09-05T00:00:00.000' AS DateTime), CAST(N'2012-09-06T00:00:00.000' AS DateTime))
GO
INSERT [dbo].[Order] ([OrderID], [CustomerID], [Sub], [Tax], [Freight], [Placed], [Paid], [Shipped]) VALUES (19, 17, 185.0000, 0.0000, 16.9700, CAST(N'2012-09-05T00:00:00.000' AS DateTime), NULL, NULL)
GO
INSERT [dbo].[Order] ([OrderID], [CustomerID], [Sub], [Tax], [Freight], [Placed], [Paid], [Shipped]) VALUES (20, 18, 28.0500, 0.0000, 9.9900, CAST(N'2012-09-05T00:00:00.000' AS DateTime), CAST(N'2012-09-05T00:00:00.000' AS DateTime), CAST(N'2012-09-06T00:00:00.000' AS DateTime))
GO
INSERT [dbo].[Order] ([OrderID], [CustomerID], [Sub], [Tax], [Freight], [Placed], [Paid], [Shipped]) VALUES (21, 19, 57.3000, 0.0000, 9.9900, CAST(N'2012-09-05T00:00:00.000' AS DateTime), CAST(N'2012-09-05T00:00:00.000' AS DateTime), CAST(N'2012-09-07T00:00:00.000' AS DateTime))
GO
INSERT [dbo].[Order] ([OrderID], [CustomerID], [Sub], [Tax], [Freight], [Placed], [Paid], [Shipped]) VALUES (22, 20, 178.3400, 12.4800, 17.9900, CAST(N'2012-09-06T00:00:00.000' AS DateTime), CAST(N'2012-09-06T00:00:00.000' AS DateTime), CAST(N'2012-09-07T00:00:00.000' AS DateTime))
GO
INSERT [dbo].[Order] ([OrderID], [CustomerID], [Sub], [Tax], [Freight], [Placed], [Paid], [Shipped]) VALUES (23, 21, 39.8900, 0.0000, 9.9900, CAST(N'2012-09-06T00:00:00.000' AS DateTime), CAST(N'2012-09-06T00:00:00.000' AS DateTime), CAST(N'2012-09-07T00:00:00.000' AS DateTime))
GO
INSERT [dbo].[Order] ([OrderID], [CustomerID], [Sub], [Tax], [Freight], [Placed], [Paid], [Shipped]) VALUES (25, 8, 98.0400, 0.0000, 19.9900, CAST(N'2012-09-06T00:00:00.000' AS DateTime), CAST(N'2012-09-06T00:00:00.000' AS DateTime), CAST(N'2012-09-07T00:00:00.000' AS DateTime))
GO
INSERT [dbo].[Order] ([OrderID], [CustomerID], [Sub], [Tax], [Freight], [Placed], [Paid], [Shipped]) VALUES (26, 2, 8.9900, 0.0000, 9.9900, CAST(N'2012-09-06T00:00:00.000' AS DateTime), CAST(N'2012-09-06T00:00:00.000' AS DateTime), CAST(N'2012-09-08T00:00:00.000' AS DateTime))
GO
INSERT [dbo].[Order] ([OrderID], [CustomerID], [Sub], [Tax], [Freight], [Placed], [Paid], [Shipped]) VALUES (27, 12, 74.0800, 0.0000, 9.9900, CAST(N'2012-09-06T00:00:00.000' AS DateTime), CAST(N'2012-09-06T00:00:00.000' AS DateTime), CAST(N'2012-09-07T00:00:00.000' AS DateTime))
GO
INSERT [dbo].[Order] ([OrderID], [CustomerID], [Sub], [Tax], [Freight], [Placed], [Paid], [Shipped]) VALUES (28, 5, 77.3000, 0.0000, 9.9900, CAST(N'2012-09-06T00:00:00.000' AS DateTime), CAST(N'2012-09-06T00:00:00.000' AS DateTime), CAST(N'2012-09-08T00:00:00.000' AS DateTime))
GO
SET IDENTITY_INSERT [dbo].[Order] OFF
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (1, 1)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (1, 3)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (2, 19)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (2, 25)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (2, 36)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (3, 15)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (5, 1)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (5, 5)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (6, 14)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (6, 23)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (6, 31)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (6, 35)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (7, 8)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (7, 27)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (8, 12)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (8, 23)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (8, 24)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (9, 3)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (9, 16)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (9, 19)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (10, 14)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (11, 15)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (11, 28)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (12, 1)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (12, 11)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (12, 15)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (12, 33)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (13, 27)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (14, 19)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (14, 28)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (14, 35)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (15, 19)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (15, 23)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (16, 13)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (16, 19)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (16, 21)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (16, 22)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (16, 28)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (16, 31)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (17, 35)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (18, 8)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (18, 24)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (18, 31)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (19, 11)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (20, 17)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (21, 21)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (21, 22)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (21, 35)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (22, 3)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (22, 5)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (22, 13)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (23, 17)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (23, 24)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (23, 30)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (25, 16)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (25, 18)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (25, 27)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (26, 32)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (27, 12)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (27, 26)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (28, 8)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (28, 26)
GO
INSERT [dbo].[OrderProduct] ([OrderID], [ProductID]) VALUES (28, 29)
GO
SET IDENTITY_INSERT [dbo].[Product] ON 
GO
INSERT [dbo].[Product] ([ProductID], [ManufacturerID], [ProductTypeID], [ColorID], [SizeID], [SKU], [Description], [Weight], [Cost], [Manufactured]) VALUES (1, 1, 2, 2, 4, N'123ABC456XYZ', N'Blue jeans', CAST(1.30 AS Decimal(8, 2)), 19.9900, CAST(N'2010-05-17' AS Date))
GO
INSERT [dbo].[Product] ([ProductID], [ManufacturerID], [ProductTypeID], [ColorID], [SizeID], [SKU], [Description], [Weight], [Cost], [Manufactured]) VALUES (3, 3, 1, 6, 2, N'QWERTY123456', N'All-season coat', CAST(2.60 AS Decimal(8, 2)), 89.9500, CAST(N'2011-02-12' AS Date))
GO
INSERT [dbo].[Product] ([ProductID], [ManufacturerID], [ProductTypeID], [ColorID], [SizeID], [SKU], [Description], [Weight], [Cost], [Manufactured]) VALUES (5, 2, 7, 5, 3, N'JKIUTYUHG78GH', N'Man''s Pants', CAST(1.80 AS Decimal(8, 2)), 14.9500, CAST(N'2011-09-01' AS Date))
GO
INSERT [dbo].[Product] ([ProductID], [ManufacturerID], [ProductTypeID], [ColorID], [SizeID], [SKU], [Description], [Weight], [Cost], [Manufactured]) VALUES (8, 2, 7, 1, 4, N'JNHUYGBHGYB78', N'Man''s Pants', CAST(1.80 AS Decimal(8, 2)), 14.9500, CAST(N'2011-09-01' AS Date))
GO
INSERT [dbo].[Product] ([ProductID], [ManufacturerID], [ProductTypeID], [ColorID], [SizeID], [SKU], [Description], [Weight], [Cost], [Manufactured]) VALUES (10, 4, 3, 3, 2, N'KHBJHGVCHGVJ', N'Cotton T-Shirt', CAST(0.20 AS Decimal(8, 2)), 3.9500, CAST(N'2011-08-13' AS Date))
GO
INSERT [dbo].[Product] ([ProductID], [ManufacturerID], [ProductTypeID], [ColorID], [SizeID], [SKU], [Description], [Weight], [Cost], [Manufactured]) VALUES (11, 7, 6, 8, 3, N'CUYTVBUBVYTVG', N'Leather Jacket', CAST(2.80 AS Decimal(8, 2)), 134.7900, CAST(N'2011-03-24' AS Date))
GO
INSERT [dbo].[Product] ([ProductID], [ManufacturerID], [ProductTypeID], [ColorID], [SizeID], [SKU], [Description], [Weight], [Cost], [Manufactured]) VALUES (12, 10, 9, 7, 2, N'75UVGV76HVHJB', N'Long Skirt', CAST(1.00 AS Decimal(8, 2)), 12.6500, CAST(N'2011-04-08' AS Date))
GO
INSERT [dbo].[Product] ([ProductID], [ManufacturerID], [ProductTypeID], [ColorID], [SizeID], [SKU], [Description], [Weight], [Cost], [Manufactured]) VALUES (13, 9, 6, 10, 4, N'NIUBYVUVUYBGV', N'Wool Jacket', CAST(2.10 AS Decimal(8, 2)), 67.4500, CAST(N'2011-09-02' AS Date))
GO
INSERT [dbo].[Product] ([ProductID], [ManufacturerID], [ProductTypeID], [ColorID], [SizeID], [SKU], [Description], [Weight], [Cost], [Manufactured]) VALUES (14, 9, 6, 10, 3, N'NIUVFCVJHGVHG', N'Wool Jacket', CAST(2.10 AS Decimal(8, 2)), 67.4500, CAST(N'2011-09-01' AS Date))
GO
INSERT [dbo].[Product] ([ProductID], [ManufacturerID], [ProductTypeID], [ColorID], [SizeID], [SKU], [Description], [Weight], [Cost], [Manufactured]) VALUES (15, 9, 6, 4, 3, N'NIUYGYRYUBTYV', N'Wool Jacket', CAST(2.10 AS Decimal(8, 2)), 67.4500, CAST(N'2010-09-01' AS Date))
GO
INSERT [dbo].[Product] ([ProductID], [ManufacturerID], [ProductTypeID], [ColorID], [SizeID], [SKU], [Description], [Weight], [Cost], [Manufactured]) VALUES (16, 2, 2, 6, 1, N'RCYTVYV76HGVH', N'Jeans', CAST(1.20 AS Decimal(8, 2)), 17.9800, CAST(N'2011-05-17' AS Date))
GO
INSERT [dbo].[Product] ([ProductID], [ManufacturerID], [ProductTypeID], [ColorID], [SizeID], [SKU], [Description], [Weight], [Cost], [Manufactured]) VALUES (17, 2, 2, 6, 2, N'RTYBUYBJHBKJHB', N'Jeans', CAST(1.20 AS Decimal(8, 2)), 17.9800, CAST(N'2011-05-17' AS Date))
GO
INSERT [dbo].[Product] ([ProductID], [ManufacturerID], [ProductTypeID], [ColorID], [SizeID], [SKU], [Description], [Weight], [Cost], [Manufactured]) VALUES (18, 2, 2, 6, 3, N'BYTVIUHBUBUBU', N'Jeans', CAST(1.20 AS Decimal(8, 2)), 17.9800, CAST(N'2011-05-17' AS Date))
GO
INSERT [dbo].[Product] ([ProductID], [ManufacturerID], [ProductTypeID], [ColorID], [SizeID], [SKU], [Description], [Weight], [Cost], [Manufactured]) VALUES (19, 6, 4, 3, 2, N'VYTRCVUYTUBUY', N'Cotton Sweater', CAST(2.00 AS Decimal(8, 2)), 56.9900, CAST(N'2011-03-04' AS Date))
GO
INSERT [dbo].[Product] ([ProductID], [ManufacturerID], [ProductTypeID], [ColorID], [SizeID], [SKU], [Description], [Weight], [Cost], [Manufactured]) VALUES (20, 6, 10, 1, 2, N'B76765YGVYUGV', N'Cotton Socks', CAST(0.20 AS Decimal(8, 2)), 2.9900, CAST(N'2010-12-20' AS Date))
GO
INSERT [dbo].[Product] ([ProductID], [ManufacturerID], [ProductTypeID], [ColorID], [SizeID], [SKU], [Description], [Weight], [Cost], [Manufactured]) VALUES (21, 6, 10, 8, 3, N'YUBUYBUBYUUYB', N'Cotton Socks', CAST(0.20 AS Decimal(8, 2)), 2.9900, CAST(N'2010-12-20' AS Date))
GO
INSERT [dbo].[Product] ([ProductID], [ManufacturerID], [ProductTypeID], [ColorID], [SizeID], [SKU], [Description], [Weight], [Cost], [Manufactured]) VALUES (22, 6, 10, 1, 4, N'KHBJKBKJHBUUBB', N'Cotton Socks', CAST(0.20 AS Decimal(8, 2)), 2.9900, CAST(N'2010-12-20' AS Date))
GO
INSERT [dbo].[Product] ([ProductID], [ManufacturerID], [ProductTypeID], [ColorID], [SizeID], [SKU], [Description], [Weight], [Cost], [Manufactured]) VALUES (23, 6, 10, 1, 1, N'UYVEXRETEDTRYT', N'Cotton Socks', CAST(0.20 AS Decimal(8, 2)), 2.9900, CAST(N'2010-12-20' AS Date))
GO
INSERT [dbo].[Product] ([ProductID], [ManufacturerID], [ProductTypeID], [ColorID], [SizeID], [SKU], [Description], [Weight], [Cost], [Manufactured]) VALUES (24, 6, 10, 8, 1, N'UHBYVYUBUBYUUJ', N'Cotton Socks', CAST(0.20 AS Decimal(8, 2)), 2.9900, CAST(N'2010-12-20' AS Date))
GO
INSERT [dbo].[Product] ([ProductID], [ManufacturerID], [ProductTypeID], [ColorID], [SizeID], [SKU], [Description], [Weight], [Cost], [Manufactured]) VALUES (25, 6, 10, 8, 2, N'GVY654HBJFCJHB', N'Cotton Socks', CAST(0.20 AS Decimal(8, 2)), 2.9900, CAST(N'2010-12-20' AS Date))
GO
INSERT [dbo].[Product] ([ProductID], [ManufacturerID], [ProductTypeID], [ColorID], [SizeID], [SKU], [Description], [Weight], [Cost], [Manufactured]) VALUES (26, 4, 5, 8, 2, N'TYUBBJHNVGBHJ8', N'Man''s Pullover', CAST(1.00 AS Decimal(8, 2)), 45.4900, CAST(N'2011-04-09' AS Date))
GO
INSERT [dbo].[Product] ([ProductID], [ManufacturerID], [ProductTypeID], [ColorID], [SizeID], [SKU], [Description], [Weight], [Cost], [Manufactured]) VALUES (27, 4, 5, 5, 3, N'WERTGHBNIUBNM', N'Man''s Pullover', CAST(1.00 AS Decimal(8, 2)), 45.4900, CAST(N'2011-04-09' AS Date))
GO
INSERT [dbo].[Product] ([ProductID], [ManufacturerID], [ProductTypeID], [ColorID], [SizeID], [SKU], [Description], [Weight], [Cost], [Manufactured]) VALUES (28, 4, 5, 5, 4, N'OINBUYGVTC6787', N'Man''s Pullover', CAST(1.00 AS Decimal(8, 2)), 45.4900, CAST(N'2011-04-09' AS Date))
GO
INSERT [dbo].[Product] ([ProductID], [ManufacturerID], [ProductTypeID], [ColorID], [SizeID], [SKU], [Description], [Weight], [Cost], [Manufactured]) VALUES (29, 5, 8, 3, 1, N'UBUYBIBUYUBUIU', N'Shirt', CAST(0.20 AS Decimal(8, 2)), 3.8900, CAST(N'2011-06-02' AS Date))
GO
INSERT [dbo].[Product] ([ProductID], [ManufacturerID], [ProductTypeID], [ColorID], [SizeID], [SKU], [Description], [Weight], [Cost], [Manufactured]) VALUES (30, 5, 8, 7, 2, N'YUBUYTGIUYGUYB', N'Shirt', CAST(0.20 AS Decimal(8, 2)), 3.8900, CAST(N'2011-06-02' AS Date))
GO
INSERT [dbo].[Product] ([ProductID], [ManufacturerID], [ProductTypeID], [ColorID], [SizeID], [SKU], [Description], [Weight], [Cost], [Manufactured]) VALUES (31, 5, 8, 5, 3, N'YTVYUTBUYBBKUJ', N'Shirt', CAST(0.20 AS Decimal(8, 2)), 3.8900, CAST(N'2011-06-02' AS Date))
GO
INSERT [dbo].[Product] ([ProductID], [ManufacturerID], [ProductTypeID], [ColorID], [SizeID], [SKU], [Description], [Weight], [Cost], [Manufactured]) VALUES (32, 5, 8, 4, 4, N'YUVUTBUYBBHNLJ', N'Shirt', CAST(0.20 AS Decimal(8, 2)), 3.8900, CAST(N'2011-06-02' AS Date))
GO
INSERT [dbo].[Product] ([ProductID], [ManufacturerID], [ProductTypeID], [ColorID], [SizeID], [SKU], [Description], [Weight], [Cost], [Manufactured]) VALUES (33, 5, 2, 8, 2, N'CUYVYVYUVUYBBU', N'Black Jeans', CAST(1.20 AS Decimal(8, 2)), 21.9900, CAST(N'2011-05-09' AS Date))
GO
INSERT [dbo].[Product] ([ProductID], [ManufacturerID], [ProductTypeID], [ColorID], [SizeID], [SKU], [Description], [Weight], [Cost], [Manufactured]) VALUES (34, 5, 2, 8, 3, N'UYBTYVUYBVIUVIV', N'Black Jeans', CAST(1.20 AS Decimal(8, 2)), 21.9900, CAST(N'2011-05-09' AS Date))
GO
INSERT [dbo].[Product] ([ProductID], [ManufacturerID], [ProductTypeID], [ColorID], [SizeID], [SKU], [Description], [Weight], [Cost], [Manufactured]) VALUES (35, 5, 2, 6, 2, N'YTVIUYBIUTVUUH7', N'Blue Jeans', CAST(1.20 AS Decimal(8, 2)), 21.9900, CAST(N'2011-05-09' AS Date))
GO
INSERT [dbo].[Product] ([ProductID], [ManufacturerID], [ProductTypeID], [ColorID], [SizeID], [SKU], [Description], [Weight], [Cost], [Manufactured]) VALUES (36, 5, 2, 6, 3, N'RTCTVYBUINBVHJ3', N'Blue Jeans', CAST(1.20 AS Decimal(8, 2)), 21.9900, CAST(N'2011-05-09' AS Date))
GO
SET IDENTITY_INSERT [dbo].[Product] OFF
GO
SET IDENTITY_INSERT [dbo].[ProductType] ON 
GO
INSERT [dbo].[ProductType] ([ProductTypeID], [Name]) VALUES (1, N'Coat')
GO
INSERT [dbo].[ProductType] ([ProductTypeID], [Name]) VALUES (2, N'Jeans')
GO
INSERT [dbo].[ProductType] ([ProductTypeID], [Name]) VALUES (3, N'T-Shirt')
GO
INSERT [dbo].[ProductType] ([ProductTypeID], [Name]) VALUES (4, N'Sweater')
GO
INSERT [dbo].[ProductType] ([ProductTypeID], [Name]) VALUES (5, N'Pullover')
GO
INSERT [dbo].[ProductType] ([ProductTypeID], [Name]) VALUES (6, N'Jacket')
GO
INSERT [dbo].[ProductType] ([ProductTypeID], [Name]) VALUES (7, N'Pants')
GO
INSERT [dbo].[ProductType] ([ProductTypeID], [Name]) VALUES (8, N'Shirt')
GO
INSERT [dbo].[ProductType] ([ProductTypeID], [Name]) VALUES (9, N'Skirt')
GO
INSERT [dbo].[ProductType] ([ProductTypeID], [Name]) VALUES (10, N'Socks')
GO
SET IDENTITY_INSERT [dbo].[ProductType] OFF
GO
SET IDENTITY_INSERT [dbo].[Size] ON 
GO
INSERT [dbo].[Size] ([SizeID], [Name]) VALUES (1, N'Small')
GO
INSERT [dbo].[Size] ([SizeID], [Name]) VALUES (2, N'Medium')
GO
INSERT [dbo].[Size] ([SizeID], [Name]) VALUES (3, N'Large')
GO
INSERT [dbo].[Size] ([SizeID], [Name]) VALUES (4, N'XLarge')
GO
SET IDENTITY_INSERT [dbo].[Size] OFF
GO
ALTER TABLE [dbo].[Address]  WITH CHECK ADD  CONSTRAINT [FK_Address_Country] FOREIGN KEY([CountryID])
REFERENCES [dbo].[Country] ([CountryID])
GO
ALTER TABLE [dbo].[Address] CHECK CONSTRAINT [FK_Address_Country]
GO
ALTER TABLE [dbo].[Customer]  WITH CHECK ADD  CONSTRAINT [FK_Customer_BillingAddress] FOREIGN KEY([BillingAddressID])
REFERENCES [dbo].[Address] ([AddressID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Customer] CHECK CONSTRAINT [FK_Customer_BillingAddress]
GO
ALTER TABLE [dbo].[Customer]  WITH CHECK ADD  CONSTRAINT [FK_Customer_ShippingAddress] FOREIGN KEY([ShippingAddressID])
REFERENCES [dbo].[Address] ([AddressID])
GO
ALTER TABLE [dbo].[Customer] CHECK CONSTRAINT [FK_Customer_ShippingAddress]
GO
ALTER TABLE [dbo].[Order]  WITH CHECK ADD  CONSTRAINT [FK_Order_Customer] FOREIGN KEY([CustomerID])
REFERENCES [dbo].[Customer] ([CustomerID])
GO
ALTER TABLE [dbo].[Order] CHECK CONSTRAINT [FK_Order_Customer]
GO
ALTER TABLE [dbo].[OrderProduct]  WITH CHECK ADD  CONSTRAINT [FK_OrderProduct_Order] FOREIGN KEY([OrderID])
REFERENCES [dbo].[Order] ([OrderID])
GO
ALTER TABLE [dbo].[OrderProduct] CHECK CONSTRAINT [FK_OrderProduct_Order]
GO
ALTER TABLE [dbo].[OrderProduct]  WITH CHECK ADD  CONSTRAINT [FK_OrderProduct_Product] FOREIGN KEY([ProductID])
REFERENCES [dbo].[Product] ([ProductID])
GO
ALTER TABLE [dbo].[OrderProduct] CHECK CONSTRAINT [FK_OrderProduct_Product]
GO
ALTER TABLE [dbo].[Product]  WITH CHECK ADD  CONSTRAINT [FK_Product_Color] FOREIGN KEY([ColorID])
REFERENCES [dbo].[Color] ([ColorID])
GO
ALTER TABLE [dbo].[Product] CHECK CONSTRAINT [FK_Product_Color]
GO
ALTER TABLE [dbo].[Product]  WITH CHECK ADD  CONSTRAINT [FK_Product_Manufacturer] FOREIGN KEY([ManufacturerID])
REFERENCES [dbo].[Manufacturer] ([ManufacturerID])
GO
ALTER TABLE [dbo].[Product] CHECK CONSTRAINT [FK_Product_Manufacturer]
GO
ALTER TABLE [dbo].[Product]  WITH CHECK ADD  CONSTRAINT [FK_Product_ProductType] FOREIGN KEY([ProductTypeID])
REFERENCES [dbo].[ProductType] ([ProductTypeID])
GO
ALTER TABLE [dbo].[Product] CHECK CONSTRAINT [FK_Product_ProductType]
GO
ALTER TABLE [dbo].[Product]  WITH CHECK ADD  CONSTRAINT [FK_Product_Size] FOREIGN KEY([SizeID])
REFERENCES [dbo].[Size] ([SizeID])
GO
ALTER TABLE [dbo].[Product] CHECK CONSTRAINT [FK_Product_Size]
GO