/****** Object:  Table [dbo].[AspNetRoles]    Script Date: 5/27/2019 6:39:59 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AspNetRoles](
	[Id] [nvarchar](128) NOT NULL,
	[Name] [nvarchar](256) NOT NULL,
 CONSTRAINT [PK_dbo.AspNetRoles] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[AspNetUserClaims]    Script Date: 5/27/2019 6:39:59 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AspNetUserClaims](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[UserId] [nvarchar](128) NOT NULL,
	[ClaimType] [nvarchar](max) NULL,
	[ClaimValue] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.AspNetUserClaims] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[AspNetUserLogins]    Script Date: 5/27/2019 6:39:59 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AspNetUserLogins](
	[LoginProvider] [nvarchar](128) NOT NULL,
	[ProviderKey] [nvarchar](128) NOT NULL,
	[UserId] [nvarchar](128) NOT NULL,
 CONSTRAINT [PK_dbo.AspNetUserLogins] PRIMARY KEY CLUSTERED 
(
	[LoginProvider] ASC,
	[ProviderKey] ASC,
	[UserId] 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].[AspNetUserRoles]    Script Date: 5/27/2019 6:39:59 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AspNetUserRoles](
	[UserId] [nvarchar](128) NOT NULL,
	[RoleId] [nvarchar](128) NOT NULL,
 CONSTRAINT [PK_dbo.AspNetUserRoles] PRIMARY KEY CLUSTERED 
(
	[UserId] ASC,
	[RoleId] 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].[AspNetUsers]    Script Date: 5/27/2019 6:39:59 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AspNetUsers](
	[Id] [nvarchar](128) NOT NULL,
	[Name] [nvarchar](max) NULL,
	[Email] [nvarchar](256) NULL,
	[EmailConfirmed] [bit] NOT NULL,
	[PasswordHash] [nvarchar](max) NULL,
	[SecurityStamp] [nvarchar](max) NULL,
	[PhoneNumber] [nvarchar](max) NULL,
	[PhoneNumberConfirmed] [bit] NOT NULL,
	[TwoFactorEnabled] [bit] NOT NULL,
	[LockoutEndDateUtc] [datetime] NULL,
	[LockoutEnabled] [bit] NOT NULL,
	[AccessFailedCount] [int] NOT NULL,
	[UserName] [nvarchar](256) NOT NULL,
 CONSTRAINT [PK_dbo.AspNetUsers] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[CartItems]    Script Date: 5/27/2019 6:39:59 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CartItems](
	[CartItemId] [int] IDENTITY(1,1) NOT NULL,
	[CartId] [nvarchar](max) NOT NULL,
	[ProductId] [int] NOT NULL,
	[Count] [int] NOT NULL,
	[DateCreated] [datetime] NOT NULL,
 CONSTRAINT [PK_dbo.CartItems] PRIMARY KEY CLUSTERED 
(
	[CartItemId] 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].[Categories]    Script Date: 5/27/2019 6:40:00 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Categories](
	[CategoryId] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](max) NOT NULL,
	[Description] [nvarchar](max) NULL,
	[ImageUrl] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.Categories] PRIMARY KEY CLUSTERED 
(
	[CategoryId] 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].[OrderDetails]    Script Date: 5/27/2019 6:40:00 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[OrderDetails](
	[OrderDetailId] [int] IDENTITY(1,1) NOT NULL,
	[OrderId] [int] NOT NULL,
	[ProductId] [int] NOT NULL,
	[Count] [int] NOT NULL,
	[UnitPrice] [decimal](18, 2) NOT NULL,
 CONSTRAINT [PK_dbo.OrderDetails] PRIMARY KEY CLUSTERED 
(
	[OrderDetailId] 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].[Orders]    Script Date: 5/27/2019 6:40:00 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Orders](
	[OrderId] [int] IDENTITY(1,1) NOT NULL,
	[OrderDate] [datetime] NOT NULL,
	[Username] [nvarchar](max) NOT NULL,
	[Name] [nvarchar](160) NOT NULL,
	[Address] [nvarchar](70) NOT NULL,
	[City] [nvarchar](40) NOT NULL,
	[State] [nvarchar](40) NOT NULL,
	[PostalCode] [nvarchar](10) NOT NULL,
	[Country] [nvarchar](40) NOT NULL,
	[Phone] [nvarchar](24) NOT NULL,
	[Email] [nvarchar](max) NOT NULL,
	[Total] [decimal](18, 2) NOT NULL,
 CONSTRAINT [PK_dbo.Orders] 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] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Products]    Script Date: 5/27/2019 6:40:00 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Products](
	[ProductId] [int] IDENTITY(1,1) NOT NULL,
	[SkuNumber] [nvarchar](max) NOT NULL,
	[CategoryId] [int] NOT NULL,
	[RecommendationId] [int] NOT NULL,
	[Title] [nvarchar](160) NOT NULL,
	[Price] [decimal](18, 2) NOT NULL,
	[SalePrice] [decimal](18, 2) NOT NULL,
	[ProductArtUrl] [nvarchar](1024) NULL,
	[Description] [nvarchar](max) NOT NULL,
	[Created] [datetime] NOT NULL,
	[ProductDetails] [nvarchar](max) NOT NULL,
	[Inventory] [int] NOT NULL,
	[LeadTime] [int] NOT NULL,
 CONSTRAINT [PK_dbo.Products] 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] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Rainchecks]    Script Date: 5/27/2019 6:40:00 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Rainchecks](
	[RaincheckId] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](max) NULL,
	[ProductId] [int] NOT NULL,
	[Count] [int] NOT NULL,
	[SalePrice] [float] NOT NULL,
	[StoreId] [int] NOT NULL,
 CONSTRAINT [PK_dbo.Rainchecks] PRIMARY KEY CLUSTERED 
(
	[RaincheckId] 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].[Stores]    Script Date: 5/27/2019 6:40:00 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Stores](
	[StoreId] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.Stores] PRIMARY KEY CLUSTERED 
(
	[StoreId] 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
INSERT [dbo].[AspNetRoles] ([Id], [Name]) VALUES (N'273a6d89-8b61-4742-8253-8f733a661dc6', N'Administrator')
SET IDENTITY_INSERT [dbo].[AspNetUserClaims] ON 

INSERT [dbo].[AspNetUserClaims] ([Id], [UserId], [ClaimType], [ClaimValue]) VALUES (1, N'94136f05-9f75-4fa1-8669-184803b2c1c0', N'ManageStore', N'Allowed')
SET IDENTITY_INSERT [dbo].[AspNetUserClaims] OFF
INSERT [dbo].[AspNetUserRoles] ([UserId], [RoleId]) VALUES (N'94136f05-9f75-4fa1-8669-184803b2c1c0', N'273a6d89-8b61-4742-8253-8f733a661dc6')
INSERT [dbo].[AspNetUsers] ([Id], [Name], [Email], [EmailConfirmed], [PasswordHash], [SecurityStamp], [PhoneNumber], [PhoneNumberConfirmed], [TwoFactorEnabled], [LockoutEndDateUtc], [LockoutEnabled], [AccessFailedCount], [UserName]) VALUES (N'94136f05-9f75-4fa1-8669-184803b2c1c0', NULL, N'Administrator@test.com', 0, N'ACDDc/Jja9r8iEoMlEatUf093/n9mUWrGc4OQh97m7UsNHjITfmVatx9gxnBLxVuXw==', N'556f8948-8fd7-4642-8f38-46b119d4c11e', NULL, 0, 0, NULL, 1, 0, N'Administrator@test.com')
SET IDENTITY_INSERT [dbo].[Categories] ON 

INSERT [dbo].[Categories] ([CategoryId], [Name], [Description], [ImageUrl]) VALUES (1, N'Brakes', N'Brakes description', N'product_brakes_disc.jpg')
INSERT [dbo].[Categories] ([CategoryId], [Name], [Description], [ImageUrl]) VALUES (2, N'Lighting', N'Lighting description', N'product_lighting_headlight.jpg')
INSERT [dbo].[Categories] ([CategoryId], [Name], [Description], [ImageUrl]) VALUES (3, N'Wheels & Tires', N'Wheels & Tires description', N'product_wheel_rim.jpg')
INSERT [dbo].[Categories] ([CategoryId], [Name], [Description], [ImageUrl]) VALUES (4, N'Batteries', N'Batteries description', N'product_batteries_basic-battery.jpg')
INSERT [dbo].[Categories] ([CategoryId], [Name], [Description], [ImageUrl]) VALUES (5, N'Oil', N'Oil description', N'product_oil_premium-oil.jpg')
SET IDENTITY_INSERT [dbo].[Categories] OFF
SET IDENTITY_INSERT [dbo].[Products] ON 

INSERT [dbo].[Products] ([ProductId], [SkuNumber], [CategoryId], [RecommendationId], [Title], [Price], [SalePrice], [ProductArtUrl], [Description], [Created], [ProductDetails], [Inventory], [LeadTime]) VALUES (1, N'LIG-0001', 2, 1, N'Halogen Headlights (2 Pack)', CAST(38.99 AS Decimal(18, 2)), CAST(38.99 AS Decimal(18, 2)), N'product_lighting_headlight.jpg', N'Our Halogen Headlights are made to fit majority of vehicles with our  universal fitting mold. Product requires some assembly and includes light bulbs.', CAST(N'2019-05-27T06:24:51.967' AS DateTime), N'{ "Light Source" : "Halogen", "Assembly Required": "Yes", "Color" : "Clear", "Interior" : "Chrome", "Beam": "low and high", "Wiring harness included" : "Yes", "Bulbs Included" : "No",  "Includes Parking Signal" : "Yes"}', 10, 0)
INSERT [dbo].[Products] ([ProductId], [SkuNumber], [CategoryId], [RecommendationId], [Title], [Price], [SalePrice], [ProductArtUrl], [Description], [Created], [ProductDetails], [Inventory], [LeadTime]) VALUES (2, N'LIG-0002', 2, 2, N'Bugeye Headlights (2 Pack)', CAST(48.99 AS Decimal(18, 2)), CAST(48.99 AS Decimal(18, 2)), N'product_lighting_bugeye-headlight.jpg', N'Our Bugeye Headlights use Halogen light bulbs are made to fit into a standard Bugeye slot. Product requires some assembly and includes light bulbs.', CAST(N'2019-05-27T06:24:51.967' AS DateTime), N'{ "Light Source" : "Halogen", "Assembly Required": "Yes", "Color" : "Clear", "Interior" : "Chrome", "Beam": "low and high", "Wiring harness included" : "No", "Bulbs Included" : "Yes",  "Includes Parking Signal" : "Yes"}', 7, 0)
INSERT [dbo].[Products] ([ProductId], [SkuNumber], [CategoryId], [RecommendationId], [Title], [Price], [SalePrice], [ProductArtUrl], [Description], [Created], [ProductDetails], [Inventory], [LeadTime]) VALUES (3, N'LIG-0003', 2, 3, N'Turn Signal Light Bulb', CAST(6.49 AS Decimal(18, 2)), CAST(6.49 AS Decimal(18, 2)), N'product_lighting_lightbulb.jpg', N' Clear bulb that with a universal fitting for all headlights/taillights.  Simple Installation, low wattage and a clear light for optimal visibility and efficiency.', CAST(N'2019-05-27T06:24:51.967' AS DateTime), N'{ "Color" : "Clear", "Fit" : "Universal", "Wattage" : "30 Watts", "Includes Socket" : "Yes"}', 18, 0)
INSERT [dbo].[Products] ([ProductId], [SkuNumber], [CategoryId], [RecommendationId], [Title], [Price], [SalePrice], [ProductArtUrl], [Description], [Created], [ProductDetails], [Inventory], [LeadTime]) VALUES (4, N'WHE-0001', 3, 4, N'Matte Finish Rim', CAST(75.99 AS Decimal(18, 2)), CAST(75.99 AS Decimal(18, 2)), N'product_wheel_rim.jpg', N'A Parts Unlimited favorite, the Matte Finish Rim is affordable low profile style. Fits all low profile tires.', CAST(N'2019-05-27T06:24:51.967' AS DateTime), N'{ "Material" : "Aluminum alloy",  "Design" : "Spoke", "Spokes" : "9",  "Number of Lugs" : "4", "Wheel Diameter" : "17 in.", "Color" : "Black", "Finish" : "Matte" } ', 4, 0)
INSERT [dbo].[Products] ([ProductId], [SkuNumber], [CategoryId], [RecommendationId], [Title], [Price], [SalePrice], [ProductArtUrl], [Description], [Created], [ProductDetails], [Inventory], [LeadTime]) VALUES (5, N'WHE-0002', 3, 5, N'Blue Performance Alloy Rim', CAST(88.99 AS Decimal(18, 2)), CAST(88.99 AS Decimal(18, 2)), N'product_wheel_rim-blue.jpg', N'Stand out from the crowd with a set of aftermarket blue rims to make you vehicle turn heads and at a price that will do the same.', CAST(N'2019-05-27T06:24:51.967' AS DateTime), N'{ "Material" : "Aluminum alloy",  "Design" : "Spoke", "Spokes" : "5",  "Number of Lugs" : "4", "Wheel Diameter" : "18 in.", "Color" : "Blue", "Finish" : "Glossy" } ', 8, 0)
INSERT [dbo].[Products] ([ProductId], [SkuNumber], [CategoryId], [RecommendationId], [Title], [Price], [SalePrice], [ProductArtUrl], [Description], [Created], [ProductDetails], [Inventory], [LeadTime]) VALUES (6, N'WHE-0003', 3, 6, N'High Performance Rim', CAST(99.99 AS Decimal(18, 2)), CAST(99.49 AS Decimal(18, 2)), N'product_wheel_rim-red.jpg', N'Light Weight Rims with a twin cross spoke design for stability and reliable performance.', CAST(N'2019-05-27T06:24:51.967' AS DateTime), N'{ "Material" : "Aluminum alloy",  "Design" : "Spoke", "Spokes" : "12",  "Number of Lugs" : "5", "Wheel Diameter" : "18 in.", "Color" : "Red", "Finish" : "Matte" } ', 3, 0)
INSERT [dbo].[Products] ([ProductId], [SkuNumber], [CategoryId], [RecommendationId], [Title], [Price], [SalePrice], [ProductArtUrl], [Description], [Created], [ProductDetails], [Inventory], [LeadTime]) VALUES (7, N'WHE-0004', 3, 7, N'Wheel Tire Combo', CAST(72.49 AS Decimal(18, 2)), CAST(72.49 AS Decimal(18, 2)), N'product_wheel_tyre-wheel-combo.jpg', N'For the endurance driver, take advantage of our best wearing tire yet. Composite rubber and a heavy duty steel rim.', CAST(N'2019-05-27T06:24:51.967' AS DateTime), N'{ "Material" : "Steel",  "Design" : "Spoke", "Spokes" : "8",  "Number of Lugs" : "4", "Wheel Diameter" : "19 in.", "Color" : "Gray", "Finish" : "Standard", "Pre-Assembled" : "Yes" } ', 0, 4)
INSERT [dbo].[Products] ([ProductId], [SkuNumber], [CategoryId], [RecommendationId], [Title], [Price], [SalePrice], [ProductArtUrl], [Description], [Created], [ProductDetails], [Inventory], [LeadTime]) VALUES (8, N'WHE-0005', 3, 8, N'Chrome Rim Tire Combo', CAST(129.99 AS Decimal(18, 2)), CAST(129.99 AS Decimal(18, 2)), N'product_wheel_tyre-rim-chrome-combo.jpg', N'Save time and money with our ever popular wheel and tire combo. Pre-assembled and ready to go.', CAST(N'2019-05-27T06:24:51.967' AS DateTime), N'{ "Material" : "Aluminum alloy",  "Design" : "Spoke", "Spokes" : "10",  "Number of Lugs" : "5", "Wheel Diameter" : "17 in.", "Color" : "Silver", "Finish" : "Chrome", "Pre-Assembled" : "Yes" } ', 1, 0)
INSERT [dbo].[Products] ([ProductId], [SkuNumber], [CategoryId], [RecommendationId], [Title], [Price], [SalePrice], [ProductArtUrl], [Description], [Created], [ProductDetails], [Inventory], [LeadTime]) VALUES (9, N'WHE-0006', 3, 9, N'Wheel Tire Combo (4 Pack)', CAST(219.99 AS Decimal(18, 2)), CAST(219.99 AS Decimal(18, 2)), N'product_wheel_tyre-wheel-combo-pack.jpg', N'Having trouble in the wet? Then try our special patent tire on a heavy duty steel rim. These wheels perform excellent in all conditions but were designed specifically for wet weather.', CAST(N'2019-05-27T06:24:51.967' AS DateTime), N'{ "Material" : "Steel",  "Design" : "Spoke", "Spokes" : "8",  "Number of Lugs" : "5", "Wheel Diameter" : "19 in.", "Color" : "Gray", "Finish" : "Standard", "Pre-Assembled" : "Yes" } ', 3, 0)
INSERT [dbo].[Products] ([ProductId], [SkuNumber], [CategoryId], [RecommendationId], [Title], [Price], [SalePrice], [ProductArtUrl], [Description], [Created], [ProductDetails], [Inventory], [LeadTime]) VALUES (10, N'BRA-0001', 1, 10, N'Disk and Pad Combo', CAST(25.99 AS Decimal(18, 2)), CAST(25.99 AS Decimal(18, 2)), N'product_brakes_disk-pad-combo.jpg', N'Our brake disks and pads perform the best together. Better stopping distances without locking up, reduced rust and dusk.', CAST(N'2019-05-27T06:24:51.967' AS DateTime), N'{ "Disk Design" : "Cross Drill Slotted", " Pad Material" : "Ceramic", "Construction" : "Vented Rotor", "Diameter" : "10.3 in.", "Finish" : "Silver Zinc Plated", "Hat Finish" : "Silver Zinc Plated", "Material" : "Cast Iron" }', 0, 6)
INSERT [dbo].[Products] ([ProductId], [SkuNumber], [CategoryId], [RecommendationId], [Title], [Price], [SalePrice], [ProductArtUrl], [Description], [Created], [ProductDetails], [Inventory], [LeadTime]) VALUES (11, N'BRA-0002', 1, 11, N'Brake Rotor', CAST(18.99 AS Decimal(18, 2)), CAST(18.99 AS Decimal(18, 2)), N'product_brakes_disc.jpg', N'Our Brake Rotor Performs well in wet conditions with a smooth responsive feel. Machined to a high tolerance to ensure all of our Brake Rotors are safe and reliable.', CAST(N'2019-05-27T06:24:51.967' AS DateTime), N'{ "Disk Design" : "Cross Drill Slotted",  "Construction" : "Vented Rotor", "Diameter" : "10.3 in.", "Finish" : "Silver Zinc Plated", "Hat Finish" : "Black E-coating",  "Material" : "Cast Iron" }', 4, 0)
INSERT [dbo].[Products] ([ProductId], [SkuNumber], [CategoryId], [RecommendationId], [Title], [Price], [SalePrice], [ProductArtUrl], [Description], [Created], [ProductDetails], [Inventory], [LeadTime]) VALUES (12, N'BRA-0003', 1, 12, N'Brake Disk and Calipers', CAST(43.99 AS Decimal(18, 2)), CAST(43.99 AS Decimal(18, 2)), N'product_brakes_disc-calipers-red.jpg', N'Upgrading your brakes can increase stopping power, reduce dust and noise. Our Disk Calipers exceed factory specification for the best performance.', CAST(N'2019-05-27T06:24:51.967' AS DateTime), N'{"Disk Design" : "Cross Drill Slotted", " Pad Material" : "Carbon Ceramic",  "Construction" : "Vented Rotor", "Diameter" : "11.3 in.", "Bolt Pattern": "6 x 5.31 in.", "Finish" : "Silver Zinc Plated",  "Material" : "Carbon Alloy", "Includes Brake Pads" : "Yes" }', 2, 0)
INSERT [dbo].[Products] ([ProductId], [SkuNumber], [CategoryId], [RecommendationId], [Title], [Price], [SalePrice], [ProductArtUrl], [Description], [Created], [ProductDetails], [Inventory], [LeadTime]) VALUES (13, N'BAT-0001', 4, 13, N'12-Volt Calcium Battery', CAST(129.99 AS Decimal(18, 2)), CAST(129.99 AS Decimal(18, 2)), N'product_batteries_basic-battery.jpg', N'Calcium is the most common battery type. It is durable and has a long shelf and service life. They also provide high cold cranking amps.', CAST(N'2019-05-27T06:24:51.967' AS DateTime), N'{ "Type": "Calcium", "Volts" : "12", "Weight" : "22.9 lbs", "Size" :  "7.7x5x8.6", "Cold Cranking Amps" : "510" }', 9, 0)
INSERT [dbo].[Products] ([ProductId], [SkuNumber], [CategoryId], [RecommendationId], [Title], [Price], [SalePrice], [ProductArtUrl], [Description], [Created], [ProductDetails], [Inventory], [LeadTime]) VALUES (14, N'BAT-0002', 4, 14, N'Spiral Coil Battery', CAST(154.99 AS Decimal(18, 2)), CAST(154.99 AS Decimal(18, 2)), N'product_batteries_premium-battery.jpg', N'Spiral Coil batteries are the preferred option for high performance Vehicles where extra toque is need for starting. They are more resistant to heat and higher charge rates than conventional batteries.', CAST(N'2019-05-27T06:24:51.967' AS DateTime), N'{ "Type": "Spiral Coil", "Volts" : "12", "Weight" : "20.3 lbs", "Size" :  "7.4x5.1x8.5", "Cold Cranking Amps" : "460" }', 3, 0)
INSERT [dbo].[Products] ([ProductId], [SkuNumber], [CategoryId], [RecommendationId], [Title], [Price], [SalePrice], [ProductArtUrl], [Description], [Created], [ProductDetails], [Inventory], [LeadTime]) VALUES (15, N'BAT-0003', 4, 15, N'Jumper Leads', CAST(16.99 AS Decimal(18, 2)), CAST(16.99 AS Decimal(18, 2)), N'product_batteries_jumper-leads.jpg', N'Battery Jumper Leads have a built in surge protector and a includes a plastic carry case to keep them safe from corrosion.', CAST(N'2019-05-27T06:24:51.967' AS DateTime), N'{ "length" : "6ft.", "Connection Type" : "Alligator Clips", "Fit" : "Universal", "Max Amp''s" : "750" }', 6, 0)
INSERT [dbo].[Products] ([ProductId], [SkuNumber], [CategoryId], [RecommendationId], [Title], [Price], [SalePrice], [ProductArtUrl], [Description], [Created], [ProductDetails], [Inventory], [LeadTime]) VALUES (16, N'OIL-0001', 5, 16, N'Filter Set', CAST(28.99 AS Decimal(18, 2)), CAST(28.99 AS Decimal(18, 2)), N'product_oil_filters.jpg', N'Ensure that your vehicle''s engine has a longer life with our new filter set. Trapping more dirt to ensure old freely circulates through your engine.', CAST(N'2019-05-27T06:24:51.967' AS DateTime), N'{ "Filter Type" : "Canister and Cartridge", "Thread Size" : "0.75-16 in.", "Anti-Drainback Valve" : "Yes"}', 3, 0)
INSERT [dbo].[Products] ([ProductId], [SkuNumber], [CategoryId], [RecommendationId], [Title], [Price], [SalePrice], [ProductArtUrl], [Description], [Created], [ProductDetails], [Inventory], [LeadTime]) VALUES (17, N'OIL-0002', 5, 17, N'Oil and Filter Combo', CAST(34.49 AS Decimal(18, 2)), CAST(34.49 AS Decimal(18, 2)), N'product_oil_oil-filter-combo.jpg', N'This Oil and Oil Filter combo is suitable for all types of passenger and light commercial vehicles. Providing affordable performance through excellent lubrication and breakdown resistance.', CAST(N'2019-05-27T06:24:51.967' AS DateTime), N'{ "Filter Type" : "Canister", "Thread Size" : "0.75-16 in.", "Anti-Drainback Valve" : "Yes", "Size" : "1.1 gal.", "Synthetic" : "No" }', 5, 0)
INSERT [dbo].[Products] ([ProductId], [SkuNumber], [CategoryId], [RecommendationId], [Title], [Price], [SalePrice], [ProductArtUrl], [Description], [Created], [ProductDetails], [Inventory], [LeadTime]) VALUES (18, N'OIL-0003', 5, 18, N'Synthetic Engine Oil', CAST(36.49 AS Decimal(18, 2)), CAST(36.49 AS Decimal(18, 2)), N'product_oil_premium-oil.jpg', N'This Oil is designed to reduce sludge deposits and metal friction throughout your cars engine. Provides performance no matter the condition or temperature.', CAST(N'2019-05-27T06:24:51.967' AS DateTime), N'{ "Size" :  "1.1 Gal." , "Synthetic " : "Yes"}', 11, 0)
SET IDENTITY_INSERT [dbo].[Products] OFF
SET IDENTITY_INSERT [dbo].[Rainchecks] ON 

INSERT [dbo].[Rainchecks] ([RaincheckId], [Name], [ProductId], [Count], [SalePrice], [StoreId]) VALUES (1, N'John Smith1923929452', 18, 3, 33.94, 1)
INSERT [dbo].[Rainchecks] ([RaincheckId], [Name], [ProductId], [Count], [SalePrice], [StoreId]) VALUES (2, N'John Smith1735149371', 12, 5, 31.26, 1)
INSERT [dbo].[Rainchecks] ([RaincheckId], [Name], [ProductId], [Count], [SalePrice], [StoreId]) VALUES (3, N'John Smith2034237595', 14, 5, 68.92, 2)
INSERT [dbo].[Rainchecks] ([RaincheckId], [Name], [ProductId], [Count], [SalePrice], [StoreId]) VALUES (4, N'John Smith160023322', 3, 1, 77.92, 2)
INSERT [dbo].[Rainchecks] ([RaincheckId], [Name], [ProductId], [Count], [SalePrice], [StoreId]) VALUES (5, N'John Smith1168413542', 12, 2, 21.41, 2)
INSERT [dbo].[Rainchecks] ([RaincheckId], [Name], [ProductId], [Count], [SalePrice], [StoreId]) VALUES (6, N'John Smith609547231', 17, 4, 75.25, 2)
INSERT [dbo].[Rainchecks] ([RaincheckId], [Name], [ProductId], [Count], [SalePrice], [StoreId]) VALUES (7, N'John Smith1987910979', 5, 5, 21.34, 3)
INSERT [dbo].[Rainchecks] ([RaincheckId], [Name], [ProductId], [Count], [SalePrice], [StoreId]) VALUES (8, N'John Smith1434513699', 16, 6, 55.06, 3)
INSERT [dbo].[Rainchecks] ([RaincheckId], [Name], [ProductId], [Count], [SalePrice], [StoreId]) VALUES (9, N'John Smith1108733577', 4, 5, 78.89, 4)
INSERT [dbo].[Rainchecks] ([RaincheckId], [Name], [ProductId], [Count], [SalePrice], [StoreId]) VALUES (10, N'John Smith683584065', 16, 7, 43.86, 4)
INSERT [dbo].[Rainchecks] ([RaincheckId], [Name], [ProductId], [Count], [SalePrice], [StoreId]) VALUES (11, N'John Smith597682527', 7, 8, 19.38, 4)
INSERT [dbo].[Rainchecks] ([RaincheckId], [Name], [ProductId], [Count], [SalePrice], [StoreId]) VALUES (12, N'John Smith139144628', 3, 5, 74.91, 5)
INSERT [dbo].[Rainchecks] ([RaincheckId], [Name], [ProductId], [Count], [SalePrice], [StoreId]) VALUES (13, N'John Smith1975753867', 1, 4, 93.54, 5)
INSERT [dbo].[Rainchecks] ([RaincheckId], [Name], [ProductId], [Count], [SalePrice], [StoreId]) VALUES (14, N'John Smith1021589995', 8, 3, 45.56, 5)
INSERT [dbo].[Rainchecks] ([RaincheckId], [Name], [ProductId], [Count], [SalePrice], [StoreId]) VALUES (15, N'John Smith956817177', 11, 6, 13.45, 6)
INSERT [dbo].[Rainchecks] ([RaincheckId], [Name], [ProductId], [Count], [SalePrice], [StoreId]) VALUES (16, N'John Smith1251940683', 3, 1, 86.94, 7)
INSERT [dbo].[Rainchecks] ([RaincheckId], [Name], [ProductId], [Count], [SalePrice], [StoreId]) VALUES (17, N'John Smith1390228452', 17, 7, 1.97, 8)
INSERT [dbo].[Rainchecks] ([RaincheckId], [Name], [ProductId], [Count], [SalePrice], [StoreId]) VALUES (18, N'John Smith1206155420', 8, 3, 39.89, 9)
INSERT [dbo].[Rainchecks] ([RaincheckId], [Name], [ProductId], [Count], [SalePrice], [StoreId]) VALUES (19, N'John Smith1280463357', 3, 2, 85.35, 9)
INSERT [dbo].[Rainchecks] ([RaincheckId], [Name], [ProductId], [Count], [SalePrice], [StoreId]) VALUES (20, N'John Smith1160703904', 18, 5, 60.35, 10)
INSERT [dbo].[Rainchecks] ([RaincheckId], [Name], [ProductId], [Count], [SalePrice], [StoreId]) VALUES (21, N'John Smith1558123818', 4, 6, 8.15, 11)
INSERT [dbo].[Rainchecks] ([RaincheckId], [Name], [ProductId], [Count], [SalePrice], [StoreId]) VALUES (22, N'John Smith2021145104', 12, 1, 69.07, 11)
INSERT [dbo].[Rainchecks] ([RaincheckId], [Name], [ProductId], [Count], [SalePrice], [StoreId]) VALUES (23, N'John Smith1545382100', 4, 4, 61.51, 11)
INSERT [dbo].[Rainchecks] ([RaincheckId], [Name], [ProductId], [Count], [SalePrice], [StoreId]) VALUES (24, N'John Smith1855079360', 18, 9, 80.51, 12)
INSERT [dbo].[Rainchecks] ([RaincheckId], [Name], [ProductId], [Count], [SalePrice], [StoreId]) VALUES (25, N'John Smith27667678', 17, 9, 24.15, 13)
INSERT [dbo].[Rainchecks] ([RaincheckId], [Name], [ProductId], [Count], [SalePrice], [StoreId]) VALUES (26, N'John Smith499784169', 8, 6, 7.57, 13)
INSERT [dbo].[Rainchecks] ([RaincheckId], [Name], [ProductId], [Count], [SalePrice], [StoreId]) VALUES (27, N'John Smith780788206', 8, 2, 86.96, 14)
INSERT [dbo].[Rainchecks] ([RaincheckId], [Name], [ProductId], [Count], [SalePrice], [StoreId]) VALUES (28, N'John Smith1271152617', 7, 4, 76.92, 14)
INSERT [dbo].[Rainchecks] ([RaincheckId], [Name], [ProductId], [Count], [SalePrice], [StoreId]) VALUES (29, N'John Smith1578304330', 14, 4, 64.17, 14)
INSERT [dbo].[Rainchecks] ([RaincheckId], [Name], [ProductId], [Count], [SalePrice], [StoreId]) VALUES (30, N'John Smith748137689', 2, 6, 63.78, 15)
INSERT [dbo].[Rainchecks] ([RaincheckId], [Name], [ProductId], [Count], [SalePrice], [StoreId]) VALUES (31, N'John Smith981461372', 4, 6, 18.64, 16)
INSERT [dbo].[Rainchecks] ([RaincheckId], [Name], [ProductId], [Count], [SalePrice], [StoreId]) VALUES (32, N'John Smith1189047758', 1, 8, 29.79, 16)
INSERT [dbo].[Rainchecks] ([RaincheckId], [Name], [ProductId], [Count], [SalePrice], [StoreId]) VALUES (33, N'John Smith1485935190', 16, 7, 45.04, 16)
INSERT [dbo].[Rainchecks] ([RaincheckId], [Name], [ProductId], [Count], [SalePrice], [StoreId]) VALUES (34, N'John Smith864669318', 11, 3, 43.33, 17)
INSERT [dbo].[Rainchecks] ([RaincheckId], [Name], [ProductId], [Count], [SalePrice], [StoreId]) VALUES (35, N'John Smith1291782048', 10, 3, 12.06, 17)
INSERT [dbo].[Rainchecks] ([RaincheckId], [Name], [ProductId], [Count], [SalePrice], [StoreId]) VALUES (36, N'John Smith1733162298', 5, 8, 78.01, 17)
INSERT [dbo].[Rainchecks] ([RaincheckId], [Name], [ProductId], [Count], [SalePrice], [StoreId]) VALUES (37, N'John Smith837323578', 1, 4, 70.77, 17)
INSERT [dbo].[Rainchecks] ([RaincheckId], [Name], [ProductId], [Count], [SalePrice], [StoreId]) VALUES (38, N'John Smith590189227', 15, 8, 55.28, 18)
INSERT [dbo].[Rainchecks] ([RaincheckId], [Name], [ProductId], [Count], [SalePrice], [StoreId]) VALUES (39, N'John Smith792567871', 14, 9, 99.79, 18)
INSERT [dbo].[Rainchecks] ([RaincheckId], [Name], [ProductId], [Count], [SalePrice], [StoreId]) VALUES (40, N'John Smith279208804', 1, 4, 21.01, 18)
INSERT [dbo].[Rainchecks] ([RaincheckId], [Name], [ProductId], [Count], [SalePrice], [StoreId]) VALUES (41, N'John Smith104511004', 1, 8, 85.55, 18)
INSERT [dbo].[Rainchecks] ([RaincheckId], [Name], [ProductId], [Count], [SalePrice], [StoreId]) VALUES (42, N'John Smith141234231', 14, 2, 97.28, 19)
INSERT [dbo].[Rainchecks] ([RaincheckId], [Name], [ProductId], [Count], [SalePrice], [StoreId]) VALUES (43, N'John Smith1112085928', 6, 8, 42.37, 19)
INSERT [dbo].[Rainchecks] ([RaincheckId], [Name], [ProductId], [Count], [SalePrice], [StoreId]) VALUES (44, N'John Smith1594972865', 12, 2, 12.78, 19)
INSERT [dbo].[Rainchecks] ([RaincheckId], [Name], [ProductId], [Count], [SalePrice], [StoreId]) VALUES (45, N'John Smith1890942189', 5, 6, 32.86, 20)
INSERT [dbo].[Rainchecks] ([RaincheckId], [Name], [ProductId], [Count], [SalePrice], [StoreId]) VALUES (46, N'John Smith263404988', 13, 8, 48.06, 20)
SET IDENTITY_INSERT [dbo].[Rainchecks] OFF
SET IDENTITY_INSERT [dbo].[Stores] ON 

INSERT [dbo].[Stores] ([StoreId], [Name]) VALUES (1, N'Store1')
INSERT [dbo].[Stores] ([StoreId], [Name]) VALUES (2, N'Store2')
INSERT [dbo].[Stores] ([StoreId], [Name]) VALUES (3, N'Store3')
INSERT [dbo].[Stores] ([StoreId], [Name]) VALUES (4, N'Store4')
INSERT [dbo].[Stores] ([StoreId], [Name]) VALUES (5, N'Store5')
INSERT [dbo].[Stores] ([StoreId], [Name]) VALUES (6, N'Store6')
INSERT [dbo].[Stores] ([StoreId], [Name]) VALUES (7, N'Store7')
INSERT [dbo].[Stores] ([StoreId], [Name]) VALUES (8, N'Store8')
INSERT [dbo].[Stores] ([StoreId], [Name]) VALUES (9, N'Store9')
INSERT [dbo].[Stores] ([StoreId], [Name]) VALUES (10, N'Store10')
INSERT [dbo].[Stores] ([StoreId], [Name]) VALUES (11, N'Store11')
INSERT [dbo].[Stores] ([StoreId], [Name]) VALUES (12, N'Store12')
INSERT [dbo].[Stores] ([StoreId], [Name]) VALUES (13, N'Store13')
INSERT [dbo].[Stores] ([StoreId], [Name]) VALUES (14, N'Store14')
INSERT [dbo].[Stores] ([StoreId], [Name]) VALUES (15, N'Store15')
INSERT [dbo].[Stores] ([StoreId], [Name]) VALUES (16, N'Store16')
INSERT [dbo].[Stores] ([StoreId], [Name]) VALUES (17, N'Store17')
INSERT [dbo].[Stores] ([StoreId], [Name]) VALUES (18, N'Store18')
INSERT [dbo].[Stores] ([StoreId], [Name]) VALUES (19, N'Store19')
INSERT [dbo].[Stores] ([StoreId], [Name]) VALUES (20, N'Store20')
SET IDENTITY_INSERT [dbo].[Stores] OFF
ALTER TABLE [dbo].[AspNetUserClaims]  WITH CHECK ADD  CONSTRAINT [FK_dbo.AspNetUserClaims_dbo.AspNetUsers_UserId] FOREIGN KEY([UserId])
REFERENCES [dbo].[AspNetUsers] ([Id])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[AspNetUserClaims] CHECK CONSTRAINT [FK_dbo.AspNetUserClaims_dbo.AspNetUsers_UserId]
GO
ALTER TABLE [dbo].[AspNetUserLogins]  WITH CHECK ADD  CONSTRAINT [FK_dbo.AspNetUserLogins_dbo.AspNetUsers_UserId] FOREIGN KEY([UserId])
REFERENCES [dbo].[AspNetUsers] ([Id])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[AspNetUserLogins] CHECK CONSTRAINT [FK_dbo.AspNetUserLogins_dbo.AspNetUsers_UserId]
GO
ALTER TABLE [dbo].[AspNetUserRoles]  WITH CHECK ADD  CONSTRAINT [FK_dbo.AspNetUserRoles_dbo.AspNetRoles_RoleId] FOREIGN KEY([RoleId])
REFERENCES [dbo].[AspNetRoles] ([Id])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[AspNetUserRoles] CHECK CONSTRAINT [FK_dbo.AspNetUserRoles_dbo.AspNetRoles_RoleId]
GO
ALTER TABLE [dbo].[AspNetUserRoles]  WITH CHECK ADD  CONSTRAINT [FK_dbo.AspNetUserRoles_dbo.AspNetUsers_UserId] FOREIGN KEY([UserId])
REFERENCES [dbo].[AspNetUsers] ([Id])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[AspNetUserRoles] CHECK CONSTRAINT [FK_dbo.AspNetUserRoles_dbo.AspNetUsers_UserId]
GO
ALTER TABLE [dbo].[CartItems]  WITH CHECK ADD  CONSTRAINT [FK_dbo.CartItems_dbo.Products_ProductId] FOREIGN KEY([ProductId])
REFERENCES [dbo].[Products] ([ProductId])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[CartItems] CHECK CONSTRAINT [FK_dbo.CartItems_dbo.Products_ProductId]
GO
ALTER TABLE [dbo].[OrderDetails]  WITH CHECK ADD  CONSTRAINT [FK_dbo.OrderDetails_dbo.Orders_OrderId] FOREIGN KEY([OrderId])
REFERENCES [dbo].[Orders] ([OrderId])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[OrderDetails] CHECK CONSTRAINT [FK_dbo.OrderDetails_dbo.Orders_OrderId]
GO
ALTER TABLE [dbo].[OrderDetails]  WITH CHECK ADD  CONSTRAINT [FK_dbo.OrderDetails_dbo.Products_ProductId] FOREIGN KEY([ProductId])
REFERENCES [dbo].[Products] ([ProductId])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[OrderDetails] CHECK CONSTRAINT [FK_dbo.OrderDetails_dbo.Products_ProductId]
GO
ALTER TABLE [dbo].[Products]  WITH CHECK ADD  CONSTRAINT [FK_dbo.Products_dbo.Categories_CategoryId] FOREIGN KEY([CategoryId])
REFERENCES [dbo].[Categories] ([CategoryId])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Products] CHECK CONSTRAINT [FK_dbo.Products_dbo.Categories_CategoryId]
GO
ALTER TABLE [dbo].[Rainchecks]  WITH CHECK ADD  CONSTRAINT [FK_dbo.Rainchecks_dbo.Products_ProductId] FOREIGN KEY([ProductId])
REFERENCES [dbo].[Products] ([ProductId])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Rainchecks] CHECK CONSTRAINT [FK_dbo.Rainchecks_dbo.Products_ProductId]
GO
ALTER TABLE [dbo].[Rainchecks]  WITH CHECK ADD  CONSTRAINT [FK_dbo.Rainchecks_dbo.Stores_StoreId] FOREIGN KEY([StoreId])
REFERENCES [dbo].[Stores] ([StoreId])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Rainchecks] CHECK CONSTRAINT [FK_dbo.Rainchecks_dbo.Stores_StoreId]
GO