use master
go

/****** Object:  Database IBuyAdventure    Script Date: 18/01/2002 14:50:23 ******/
IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'IBuyAdventure')
	DROP DATABASE [IBuyAdventure]
GO

CREATE DATABASE IBuyAdventure
GO

exec sp_dboption N'IBuyAdventure', N'autoclose', N'false'
GO

exec sp_dboption N'IBuyAdventure', N'bulkcopy', N'false'
GO

exec sp_dboption N'IBuyAdventure', N'trunc. log', N'false'
GO

exec sp_dboption N'IBuyAdventure', N'torn page detection', N'true'
GO

exec sp_dboption N'IBuyAdventure', N'read only', N'false'
GO

exec sp_dboption N'IBuyAdventure', N'dbo use', N'false'
GO

exec sp_dboption N'IBuyAdventure', N'single', N'false'
GO

exec sp_dboption N'IBuyAdventure', N'autoshrink', N'false'
GO

exec sp_dboption N'IBuyAdventure', N'ANSI null default', N'false'
GO

exec sp_dboption N'IBuyAdventure', N'recursive triggers', N'false'
GO

exec sp_dboption N'IBuyAdventure', N'ANSI nulls', N'false'
GO

exec sp_dboption N'IBuyAdventure', N'concat null yields null', N'false'
GO

exec sp_dboption N'IBuyAdventure', N'cursor close on commit', N'false'
GO

exec sp_dboption N'IBuyAdventure', N'default to local cursor', N'false'
GO

exec sp_dboption N'IBuyAdventure', N'quoted identifier', N'false'
GO

exec sp_dboption N'IBuyAdventure', N'ANSI warnings', N'false'
GO

exec sp_dboption N'IBuyAdventure', N'auto create statistics', N'true'
GO

exec sp_dboption N'IBuyAdventure', N'auto update statistics', N'true'
GO

use [IBuyAdventure]
GO

/****** Object:  Table [dbo].[Accounts]    Script Date: 18/01/2002 14:50:25 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Accounts]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Accounts]
GO

/****** Object:  Table [dbo].[Orders]    Script Date: 18/01/2002 14:50:25 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Orders]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Orders]
GO

/****** Object:  Table [dbo].[Products]    Script Date: 18/01/2002 14:50:25 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Products]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Products]
GO

/****** Object:  Table [dbo].[Shipping_Methods]    Script Date: 18/01/2002 14:50:25 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Shipping_Methods]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Shipping_Methods]
GO

/****** Object:  Table [dbo].[ShoppingCarts]    Script Date: 18/01/2002 14:50:25 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ShoppingCarts]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ShoppingCarts]
GO

/****** Object:  Login anon    Script Date: 18/01/2002 14:50:23 ******/
if not exists (select * from master.dbo.syslogins where loginname = N'anon')
BEGIN
	declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'ADCD', @loginlang = N'us_english'
	if @logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb)
		select @logindb = N'master'
	if @loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')
		select @loginlang = @@language
	exec sp_addlogin N'anon', null, @logindb, @loginlang
END
GO

/****** Object:  Login SqlUser    Script Date: 18/01/2002 14:50:23 ******/
if not exists (select * from master.dbo.syslogins where loginname = N'SqlUser')
BEGIN
	declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'IBuyAdventure', @loginlang = N'us_english'
	if @logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb)
		select @logindb = N'master'
	if @loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')
		select @loginlang = @@language
	exec sp_addlogin N'SqlUser', null, @logindb, @loginlang
END
GO

/****** Object:  User dbo    Script Date: 18/01/2002 14:50:23 ******/
/****** Object:  User SqlUser    Script Date: 18/01/2002 14:50:23 ******/
if not exists (select * from dbo.sysusers where name = N'SqlUser' and uid < 16382)
	EXEC sp_grantdbaccess N'SqlUser', N'SqlUser'
GO

/****** Object:  User SqlUser    Script Date: 18/01/2002 14:50:23 ******/
exec sp_addrolemember N'db_datareader', N'SqlUser'
GO

/****** Object:  User SqlUser    Script Date: 18/01/2002 14:50:23 ******/
exec sp_addrolemember N'db_datawriter', N'SqlUser'
GO

/****** Object:  Table [dbo].[Accounts]    Script Date: 18/01/2002 14:50:26 ******/
CREATE TABLE [dbo].[Accounts] (
	[CustomerName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[Password] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Orders]    Script Date: 18/01/2002 14:50:27 ******/
CREATE TABLE [dbo].[Orders] (
	[CustomerName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[Ordered] [datetime] NULL ,
	[TotalValue] [float] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Products]    Script Date: 18/01/2002 14:50:27 ******/
CREATE TABLE [dbo].[Products] (
	[ProductID] [int] NOT NULL ,
	[ProductCode] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[ProductType] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[ProductIntroductionDate] [smalldatetime] NULL ,
	[ProductName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[ProductDescription] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[ProductSize] [nvarchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[ProductImageURL] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[UnitPrice] [float] NULL ,
	[OnSale] [int] NOT NULL ,
	[Rating] [float] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Shipping_Methods]    Script Date: 18/01/2002 14:50:27 ******/
CREATE TABLE [dbo].[Shipping_Methods] (
	[ShippingMethodID] [int] IDENTITY (1, 1) NOT NULL ,
	[ShippingMethod] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[ShoppingCarts]    Script Date: 18/01/2002 14:50:28 ******/
CREATE TABLE [dbo].[ShoppingCarts] (
	[ShoppingCartID] [int] IDENTITY (1, 1) NOT NULL ,
	[ProductCode] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[ProductName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[Description] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[UnitPrice] [float] NULL ,
	[Quantity] [int] NULL ,
	[CustomerName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[Orders] WITH NOCHECK ADD 
	CONSTRAINT [PK_Orders] PRIMARY KEY  CLUSTERED 
	(
		[CustomerName]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Products] WITH NOCHECK ADD 
	CONSTRAINT [PK_Products] PRIMARY KEY  CLUSTERED 
	(
		[ProductID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Shipping_Methods] WITH NOCHECK ADD 
	CONSTRAINT [IX_Shipping_Methods] UNIQUE  CLUSTERED 
	(
		[ShippingMethodID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[ShoppingCarts] WITH NOCHECK ADD 
	CONSTRAINT [PK_ShoppingCarts] PRIMARY KEY  CLUSTERED 
	(
		[ShoppingCartID]
	)  ON [PRIMARY] 
GO

 CREATE  INDEX [IX_Products] ON [dbo].[Products]([ProductCode]) ON [PRIMARY]
GO

 CREATE  INDEX [IX_Products_1] ON [dbo].[Products]([ProductType]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[Shipping_Methods] WITH NOCHECK ADD 
	CONSTRAINT [PK_Shipping_Methods] PRIMARY KEY  NONCLUSTERED 
	(
		[ShippingMethodID]
	)  ON [PRIMARY] 
GO

 CREATE  INDEX [IX_ShoppingCarts] ON [dbo].[ShoppingCarts]([ProductCode]) ON [PRIMARY]
GO

 CREATE  INDEX [IX_ShoppingCarts_1] ON [dbo].[ShoppingCarts]([CustomerName]) ON [PRIMARY]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[Accounts]  TO [SqlUser]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[Orders]  TO [SqlUser]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[Products]  TO [SqlUser]
GO

GRANT  REFERENCES ,  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[ShoppingCarts]  TO [SqlUser]
GO



/***************************** data ****************************/
-- Products
INSERT INTO Products (ProductID, ProductCode, ProductType, ProductIntroductionDate, ProductName, ProductDescription, ProductSize, ProductImageURL, UnitPrice, OnSale, Rating) VALUES (1, 'AW390-12', 'SleepingBags', '1996-05-01 00:00:00', 'North Face Sunspot', 'windproof, water-resistant, even heat distribution, storage sack included, red (re)', '', 'Dsleepingbags25.gif', 390, 0, 5)
INSERT INTO Products (ProductID, ProductCode, ProductType, ProductIntroductionDate, ProductName, ProductDescription, ProductSize, ProductImageURL, UnitPrice, OnSale, Rating) VALUES (2, 'AW310-12', 'SleepingBags', '1996-01-16 00:00:00', 'Polar Star', 'ultralight goose-down insulated alpinist''s bag, contour closure with locking zipper, storage sack included, green (gn)', '', 'Dsleepingbags26.gif', 310, 1, 5)
INSERT INTO Products (ProductID, ProductCode, ProductType, ProductIntroductionDate, ProductName, ProductDescription, ProductSize, ProductImageURL, UnitPrice, OnSale, Rating) VALUES (3, 'AW200-12', 'SleepingBags', '1996-03-03 00:00:00', 'Big Sur', 'generously cut sleeping bag, goose down with polyester taffeta, cotton storage sack included, blue (bl)', '', 'Dsleepingbags28.gif', 200, 0, 5)
INSERT INTO Products (ProductID, ProductCode, ProductType, ProductIntroductionDate, ProductName, ProductDescription, ProductSize, ProductImageURL, UnitPrice, OnSale, Rating) VALUES (4, 'AW210-12', 'SleepingBags', '1996-04-23 00:00:00', 'Cascade', 'backpacking sleeping bag, goose down with nylon shell, locking zipper, storage sack included, choice of zipper location, blue (bl)', '', 'Dsleepingbags27.gif', 210, 0, 5)
INSERT INTO Products (ProductID, ProductCode, ProductType, ProductIntroductionDate, ProductName, ProductDescription, ProductSize, ProductImageURL, UnitPrice, OnSale, Rating) VALUES (5, 'AW098-04', 'Boots', '1996-05-20 00:00:00', 'Everglades', 'medium-weight, waterproof leather boots, good traction, brown (br)', '4-12', 'dboots05.gif', 98, 0, 4.5)
INSERT INTO Products (ProductID, ProductCode, ProductType, ProductIntroductionDate, ProductName, ProductDescription, ProductSize, ProductImageURL, UnitPrice, OnSale, Rating) VALUES (7, 'AW078-04', 'Boots', '1996-05-16 00:00:00', 'Rockies', 'lightweight Nubuck leather/nylon, water-resistant boots, polyurethane soles, green/gray (gg) or green/brown (gbn)', '4-12', 'dboots07.gif', 78, 0, 5)
INSERT INTO Products (ProductID, ProductCode, ProductType, ProductIntroductionDate, ProductName, ProductDescription, ProductSize, ProductImageURL, UnitPrice, OnSale, Rating) VALUES (9, 'AW087-04', 'Boots', '1996-04-27 00:00:00', 'Sierras', 'Nubuck, water-resistant leather boots, rubber soles, dark brown (db)', '4-12', 'dboots08.gif', 87, 1, 5)
INSERT INTO Products (ProductID, ProductCode, ProductType, ProductIntroductionDate, ProductName, ProductDescription, ProductSize, ProductImageURL, UnitPrice, OnSale, Rating) VALUES (11, 'AW074-04', 'Boots', '1996-04-16 00:00:00', 'Dunes', 'lightweight nylon/suede hiking boots, light green (lg)', '4-12', 'dboots06.gif', 98, 1, 5)
INSERT INTO Products (ProductID, ProductCode, ProductType, ProductIntroductionDate, ProductName, ProductDescription, ProductSize, ProductImageURL, UnitPrice, OnSale, Rating) VALUES (13, 'AW425-11', 'Tents', '1996-05-28 00:00:00', 'Starlight', '4-person dome tent, roomy, vaulted pole sleeves, black/gray (bg)', '', 'dtents17.gif', 425, 0, 5)
INSERT INTO Products (ProductID, ProductCode, ProductType, ProductIntroductionDate, ProductName, ProductDescription, ProductSize, ProductImageURL, UnitPrice, OnSale, Rating) VALUES (14, 'AW535-11', 'Tents', '1996-05-29 00:00:00', 'Galaxy', 'durable 3-person all-purpose tent, maximum headroom, no-leak floor, beige/purple (bp)', '', 'dtents19.gif', 535, 0, 5)
INSERT INTO Products (ProductID, ProductCode, ProductType, ProductIntroductionDate, ProductName, ProductDescription, ProductSize, ProductImageURL, UnitPrice, OnSale, Rating) VALUES (15, 'AW335-11', 'Tents', '1996-03-28 00:00:00', 'Aptos', 'lightweight 2-person backpacking tent, adjustable vents, canopy loops, green/black (gbk)', '', 'dtents18.gif', 335, 1, 5)
INSERT INTO Products (ProductID, ProductCode, ProductType, ProductIntroductionDate, ProductName, ProductDescription, ProductSize, ProductImageURL, UnitPrice, OnSale, Rating) VALUES (16, 'AW190-11', 'Tents', '1996-05-20 00:00:00', 'Scirocco', 'warm-climate 2-person tent, compact, lightweight, bug protection, black/gray/purple (bgp)', '', 'dtents20.gif', 190, 1, 5)
INSERT INTO Products (ProductID, ProductCode, ProductType, ProductIntroductionDate, ProductName, ProductDescription, ProductSize, ProductImageURL, UnitPrice, OnSale, Rating) VALUES (17, 'AW188-06', 'Parkas', '1996-06-01 00:00:00', 'Alpine', 'durable, breathable, ripstop nylon parka, guaranteed to keep you dry, red (re), blue (bl), or black (bk)', 'S-XXL', 'dparkas01.gif', 188, 0, 5)
INSERT INTO Products (ProductID, ProductCode, ProductType, ProductIntroductionDate, ProductName, ProductDescription, ProductSize, ProductImageURL, UnitPrice, OnSale, Rating) VALUES (18, 'AW250-06', 'Parkas', '1996-03-23 00:00:00', 'Campos', 'reinforced, waterproof, 2-layer nylon parka, interior/exterior pockets, blue (bl)', 'S-XXL', 'dparkas02.gif', 250, 1, 5)
INSERT INTO Products (ProductID, ProductCode, ProductType, ProductIntroductionDate, ProductName, ProductDescription, ProductSize, ProductImageURL, UnitPrice, OnSale, Rating) VALUES (19, 'AW114-06', 'Parkas', '1996-05-03 00:00:00', 'Sahara', 'outer-shell drawstring parka with zippered pockets, green (gn) or blue (bl)', 'S-XXL', 'dparkas03.gif', 114, 1, 5)
INSERT INTO Products (ProductID, ProductCode, ProductType, ProductIntroductionDate, ProductName, ProductDescription, ProductSize, ProductImageURL, UnitPrice, OnSale, Rating) VALUES (20, 'AW125-06', 'Parkas', '1996-04-30 00:00:00', 'Crystal', 'lightweight, traditional parka with nylon lining, hooded, purple (pu) or blue (bl)', 'S-XXL', 'dparkas04.gif', 125, 1, 5)
INSERT INTO Products (ProductID, ProductCode, ProductType, ProductIntroductionDate, ProductName, ProductDescription, ProductSize, ProductImageURL, UnitPrice, OnSale, Rating) VALUES (21, 'AW032-01', 'Pants', '1996-05-28 00:00:00', 'Women''s 4-pocket pants', 'medium-weight cotton, pre-washed, green (gn) or beige (sa)', '2-16', 'dpants13.gif', 32, 0, 5)
INSERT INTO Products (ProductID, ProductCode, ProductType, ProductIntroductionDate, ProductName, ProductDescription, ProductSize, ProductImageURL, UnitPrice, OnSale, Rating) VALUES (22, 'AW046-01', 'Pants', '1996-05-28 00:00:00', 'Men''s 8-pocket conversion pants', '100% cotton canvas, 34 inch  inseam, gray (gr) or brown (br)', '28-46', 'dpants14.gif', 46, 0, 5)
INSERT INTO Products (ProductID, ProductCode, ProductType, ProductIntroductionDate, ProductName, ProductDescription, ProductSize, ProductImageURL, UnitPrice, OnSale, Rating) VALUES (23, 'AW048-01', 'Pants', '1996-04-30 00:00:00', 'Unisex drawstring pants', 'lined, lightweight nylon, green (gn) or brown (br)', 'S-XXL', 'dpants15.gif', 48, 1, 5)
INSERT INTO Products (ProductID, ProductCode, ProductType, ProductIntroductionDate, ProductName, ProductDescription, ProductSize, ProductImageURL, UnitPrice, OnSale, Rating) VALUES (24, 'AW055-01', 'Pants', '1996-04-23 00:00:00', 'Unisex hiking pants', 'heavy-duty, water-resistant nylon, lightweight, green (gn) or beige (sa)', 'S-XXL', 'dpants16.gif', 55, 0, 5)
INSERT INTO Products (ProductID, ProductCode, ProductType, ProductIntroductionDate, ProductName, ProductDescription, ProductSize, ProductImageURL, UnitPrice, OnSale, Rating) VALUES (26, 'AW029-10', 'Harnesses', '1996-04-23 00:00:00', 'Black Diamond Alpine Bod', 'lightweight, adjustable, droppable leg loops, black (bk)', 'XS-XL', 'dharness42.gif', 29, 1, 5)
INSERT INTO Products (ProductID, ProductCode, ProductType, ProductIntroductionDate, ProductName, ProductDescription, ProductSize, ProductImageURL, UnitPrice, OnSale, Rating) VALUES (27, 'AW053-10', 'Harnesses', '1996-05-26 00:00:00', 'El Capitan', 'comfort harness, generous padding, full-strength haul loop', 'XS-XL', 'dharness43.gif', 52, 1, 5)
INSERT INTO Products (ProductID, ProductCode, ProductType, ProductIntroductionDate, ProductName, ProductDescription, ProductSize, ProductImageURL, UnitPrice, OnSale, Rating) VALUES (28, 'AW072-10', 'Harnesses', '1996-02-12 00:00:00', 'Petzl Mercury', 'padded waist and leg loops, self-locking buckle, pre-threaded, gear racking, assorted colors', 'XS-XL', 'dharness44.gif', 72, 1, 5)
INSERT INTO Products (ProductID, ProductCode, ProductType, ProductIntroductionDate, ProductName, ProductDescription, ProductSize, ProductImageURL, UnitPrice, OnSale, Rating) VALUES (29, 'AW099-15', 'Crampons', '1996-07-23 00:00:00', 'Venus', 'hinged crampons for snow and moderate ice, step-in bindings, one size fits mens 4-12', '', 'dcrampon37.gif', 99, 0, 5)
INSERT INTO Products (ProductID, ProductCode, ProductType, ProductIntroductionDate, ProductName, ProductDescription, ProductSize, ProductImageURL, UnitPrice, OnSale, Rating) VALUES (33, 'AW013-08', 'Carabiners', '1996-07-23 00:00:00', 'Petzl Spirit', 'Locking pear shaped', '', 'dcarabiners01.gif', 13, 1, 5)
INSERT INTO Products (ProductID, ProductCode, ProductType, ProductIntroductionDate, ProductName, ProductDescription, ProductSize, ProductImageURL, UnitPrice, OnSale, Rating) VALUES (34, 'AW014-08', 'Carabiners', '1996-06-13 00:00:00', 'Basic Black', 'Oval', '', 'dcarabiners02.gif', 14, 1, 5)
INSERT INTO Products (ProductID, ProductCode, ProductType, ProductIntroductionDate, ProductName, ProductDescription, ProductSize, ProductImageURL, UnitPrice, OnSale, Rating) VALUES (36, 'AW009-08', 'Carabiners', '1996-08-14 00:00:00', 'Black Diamond Quicksilver II', 'straight', '', 'dcarabiners04.gif', 9, 0, 5)
INSERT INTO Products (ProductID, ProductCode, ProductType, ProductIntroductionDate, ProductName, ProductDescription, ProductSize, ProductImageURL, UnitPrice, OnSale, Rating) VALUES (25, 'AW032-10', 'Harnesses', '1996-05-29 00:00:00', 'Black Diamond Bod', 'multipurpose, padded waist, adjustable droppable leg loops, gear racking
padded waist, adjustable droppable leg loops, gear racking, black', 'XS-XL', 'dharness41.gif', 32, 0, 5)
INSERT INTO Products (ProductID, ProductCode, ProductType, ProductIntroductionDate, ProductName, ProductDescription, ProductSize, ProductImageURL, UnitPrice, OnSale, Rating) VALUES (30, 'AW109-15', 'Crampons', '1996-11-30 00:00:00', 'Wafflestomper', 'hiking/trekking nontechnical crampons, hinged frame, straps included, one size fits mens 5-12', '', 'dcrampon39.gif', 109, 1, 5)
INSERT INTO Products (ProductID, ProductCode, ProductType, ProductIntroductionDate, ProductName, ProductDescription, ProductSize, ProductImageURL, UnitPrice, OnSale, Rating) VALUES (31, 'AW145-15', 'Crampons', '1996-08-22 00:00:00', 'Edgehugger', 'classic technical ice-climbing crampons, rigid, mono points available, one size fits mens 5-14', '', 'dcrampon40.gif', 145, 1, 5)
INSERT INTO Products (ProductID, ProductCode, ProductType, ProductIntroductionDate, ProductName, ProductDescription, ProductSize, ProductImageURL, UnitPrice, OnSale, Rating) VALUES (32, 'AW149-15', 'Crampons', '1996-07-31 00:00:00', 'Glory Grip', 'mixed ice and waterfall-climbing crampons, step-in bindings, rigid, vertically oriented front points', 'M,L', 'dcrampons38.gif', 149, 1, 5)
INSERT INTO Products (ProductID, ProductCode, ProductType, ProductIntroductionDate, ProductName, ProductDescription, ProductSize, ProductImageURL, UnitPrice, OnSale, Rating) VALUES (35, 'AW007-08', 'Carabiners', '1996-05-14 00:00:00', 'Gold-Series Locking D', 'Strong yet lightweight', '', 'dcarabiners03.gif', 7, 1, 5)
INSERT INTO Products (ProductID, ProductCode, ProductType, ProductIntroductionDate, ProductName, ProductDescription, ProductSize, ProductImageURL, UnitPrice, OnSale, Rating) VALUES (37, 'AW150-05', 'RockShoes', '1996-09-14 00:00:00', 'Gibraltar', 'high-performance endurance shoes', '4-12', 'drockshoes45.gif', 150, 1, 5)
INSERT INTO Products (ProductID, ProductCode, ProductType, ProductIntroductionDate, ProductName, ProductDescription, ProductSize, ProductImageURL, UnitPrice, OnSale, Rating) VALUES (39, 'AW125-05', 'RockShoes', '1996-07-16 00:00:00', 'Plymouth', 'semi-flexed shoes, basic comfort', '4-12', 'drockshoes46.gif', 125, 1, 5)
INSERT INTO Products (ProductID, ProductCode, ProductType, ProductIntroductionDate, ProductName, ProductDescription, ProductSize, ProductImageURL, UnitPrice, OnSale, Rating) VALUES (41, 'AW084-05', 'RockShoes', '1996-06-03 00:00:00', 'Morro', 'all-around, durable shoes with Stealth soles', '4-12', 'drockshoes47.gif', 84, 1, 5)
INSERT INTO Products (ProductID, ProductCode, ProductType, ProductIntroductionDate, ProductName, ProductDescription, ProductSize, ProductImageURL, UnitPrice, OnSale, Rating) VALUES (43, 'AW086-06', 'RockShoes', '1996-07-13 00:00:00', 'Tuscany', 'all-around shoes with slipper/shoe design', '4-12', 'drockshoes48.gif', 124, 0, 5)
INSERT INTO Products (ProductID, ProductCode, ProductType, ProductIntroductionDate, ProductName, ProductDescription, ProductSize, ProductImageURL, UnitPrice, OnSale, Rating) VALUES (45, 'AW325-13', 'Backpacks', '1996-05-14 00:00:00', 'Aces', 'women''s cut, adjustable waistbelt and stays, floating hipbelt, top-loading, side pockets, blue/black (bb)', '', 'dbackpacks21.gif', 325, 1, 5)
INSERT INTO Products (ProductID, ProductCode, ProductType, ProductIntroductionDate, ProductName, ProductDescription, ProductSize, ProductImageURL, UnitPrice, OnSale, Rating) VALUES (46, 'AW140-13', 'Backpacks', '1996-03-15 00:00:00', 'University', 'multipurpose, with padded backpad and hipbelt, side pockets, bound seams, blue (bl)', '', 'dbackpacks22.gif', 140, 1, 5)
INSERT INTO Products (ProductID, ProductCode, ProductType, ProductIntroductionDate, ProductName, ProductDescription, ProductSize, ProductImageURL, UnitPrice, OnSale, Rating) VALUES (47, 'AW151-13', 'Backpacks', '1996-09-19 00:00:00', 'Pacific', 'weekender, adjustable hipbelt, side pockets, easy-access wraparound zipper, blue (bl)', '', 'dbackpacks23.gif', 151, 0, 5)
INSERT INTO Products (ProductID, ProductCode, ProductType, ProductIntroductionDate, ProductName, ProductDescription, ProductSize, ProductImageURL, UnitPrice, OnSale, Rating) VALUES (48, 'AW175-13', 'Backpacks', '1996-10-01 00:00:00', 'Conestoga', 'anti-sway, shoulder-yoke pack for long trips, aluminum frame, front fanny-pack conversion, lower sleeping bag compartment, heavy duty nylon, red (re)', '', 'dbackpacks24.gif', 175, 0, 5)
INSERT INTO Products (ProductID, ProductCode, ProductType, ProductIntroductionDate, ProductName, ProductDescription, ProductSize, ProductImageURL, UnitPrice, OnSale, Rating) VALUES (49, 'AW029-03', 'Shirts', '1996-06-19 00:00:00', 'Women''s woven tee', 'short-sleeve, breathable henley, 100% cotton knit, blue (bl), beige (sa), or green (gn)', 'S-XL', 'dshirts12.gif', 29, 1, 5)
INSERT INTO Products (ProductID, ProductCode, ProductType, ProductIntroductionDate, ProductName, ProductDescription, ProductSize, ProductImageURL, UnitPrice, OnSale, Rating) VALUES (50, 'AW045-03', 'Shirts', '1996-08-13 00:00:00', 'Men''s loose-weave polo', '100% breathable cotton, blue (bl), white (wh), red (re), or beige (sa)', 'S-XXL', 'dshirts10.gif', 45, 1, 5)
INSERT INTO Products (ProductID, ProductCode, ProductType, ProductIntroductionDate, ProductName, ProductDescription, ProductSize, ProductImageURL, UnitPrice, OnSale, Rating) VALUES (51, 'AW042-03', 'Shirts', '1996-09-13 00:00:00', 'Men''s button-down', 'short-sleeve, durable, 100% cotton, button-flap pockets, blue (bl), red (re), or beige (sa)', 'S-L', 'dshirts11.gif', 42, 0, 5)
INSERT INTO Products (ProductID, ProductCode, ProductType, ProductIntroductionDate, ProductName, ProductDescription, ProductSize, ProductImageURL, UnitPrice, OnSale, Rating) VALUES (52, 'AW075-03', 'Shirts', '1996-09-12 00:00:00', 'Unisex long-sleeve button-down', 'parachute-style, cotton/nylon blend, multiple pockets, green (gn) or beige (sa)', 'S-XXL', 'dshirts09.gif', 75, 0, 5)
INSERT INTO Products (ProductID, ProductCode, ProductType, ProductIntroductionDate, ProductName, ProductDescription, ProductSize, ProductImageURL, UnitPrice, OnSale, Rating) VALUES (53, 'AW051-14', 'Supplies', '1996-04-25 00:00:00', 'Wolfgang', 'multifuel cook stove, white gas or unleaded', '', 'dstoves29.gif', 59, 1, 5)
INSERT INTO Products (ProductID, ProductCode, ProductType, ProductIntroductionDate, ProductName, ProductDescription, ProductSize, ProductImageURL, UnitPrice, OnSale, Rating) VALUES (54, 'AW425-14', 'Supplies', '1996-05-30 00:00:00', 'Surelite', 'cold-starter, 80/20 butane/propane cartridges', '', 'dstoves30.gif', 4, 1, 5)
INSERT INTO Products (ProductID, ProductCode, ProductType, ProductIntroductionDate, ProductName, ProductDescription, ProductSize, ProductImageURL, UnitPrice, OnSale, Rating) VALUES (55, 'AW031-14', 'Supplies', '1996-04-22 00:00:00', 'Daytrip First Aid Kit', 'nylon pouch, comprehensive kit for day or weekend trips', '', 'dfirstaidkit31.gif', 31, 1, 5)
INSERT INTO Products (ProductID, ProductCode, ProductType, ProductIntroductionDate, ProductName, ProductDescription, ProductSize, ProductImageURL, UnitPrice, OnSale, Rating) VALUES (56, 'AW475-14', 'Supplies', '1996-08-31 00:00:00', 'Scoutpride', 'all-purpose cook set, stainless-steel nesting pots of 1, 2, and 3 liters, includes lids and fry pans', '', 'ddinningwear32.gif', 44.75, 0, 5)
go


-- Shipping_Methods
SET IDENTITY_INSERT Shipping_Methods ON
INSERT INTO Shipping_Methods (ShippingMethodID, ShippingMethod) VALUES (1, 'Speedy Express')
INSERT INTO Shipping_Methods (ShippingMethodID, ShippingMethod) VALUES (2, 'Federal Shipping')
INSERT INTO Shipping_Methods (ShippingMethodID, ShippingMethod) VALUES (3, 'Mail Company')
INSERT INTO Shipping_Methods (ShippingMethodID, ShippingMethod) VALUES (4, 'Slow Shipping')
go
 



update statistics products
update statistics Shipping_Methods
go
