/* Microsoft SQL Server - Scripting			*/
/* Server: 204.238.18.145					*/
/* Database: ASPBook					*/
/* Creation Date 10/2/99 10:54:54 AM 			*/

/****** Object:  Table dbo.ASPCCTypes    Script Date: 10/2/99 10:54:56 AM ******/
if exists (select * from sysobjects where id = object_id('dbo.ASPCCTypes') and sysstat & 0xf = 3)
	drop table dbo.ASPCCTypes
GO

/****** Object:  Table dbo.ASPCategories    Script Date: 10/2/99 10:54:56 AM ******/
if exists (select * from sysobjects where id = object_id('dbo.ASPCategories') and sysstat & 0xf = 3)
	drop table dbo.ASPCategories
GO

/****** Object:  Table dbo.ASPContacts    Script Date: 10/2/99 10:54:56 AM ******/
if exists (select * from sysobjects where id = object_id('dbo.ASPContacts') and sysstat & 0xf = 3)
	drop table dbo.ASPContacts
GO

/****** Object:  Table dbo.ASPCustomer    Script Date: 10/2/99 10:54:56 AM ******/
if exists (select * from sysobjects where id = object_id('dbo.ASPCustomer') and sysstat & 0xf = 3)
	drop table dbo.ASPCustomer
GO

/****** Object:  Table dbo.ASPCustomerWithCategory    Script Date: 10/2/99 10:54:56 AM ******/
if exists (select * from sysobjects where id = object_id('dbo.ASPCustomerWithCategory') and sysstat & 0xf = 3)
	drop table dbo.ASPCustomerWithCategory
GO

/****** Object:  Table dbo.ASPFAQ    Script Date: 10/2/99 10:54:56 AM ******/
if exists (select * from sysobjects where id = object_id('dbo.ASPFAQ') and sysstat & 0xf = 3)
	drop table dbo.ASPFAQ
GO

/****** Object:  Table dbo.ASPHelp    Script Date: 10/2/99 10:54:56 AM ******/
if exists (select * from sysobjects where id = object_id('dbo.ASPHelp') and sysstat & 0xf = 3)
	drop table dbo.ASPHelp
GO

/****** Object:  Table dbo.ASPPageText    Script Date: 10/2/99 10:54:56 AM ******/
if exists (select * from sysobjects where id = object_id('dbo.ASPPageText') and sysstat & 0xf = 3)
	drop table dbo.ASPPageText
GO

/****** Object:  Table dbo.ASPProductCategories    Script Date: 10/2/99 10:54:56 AM ******/
if exists (select * from sysobjects where id = object_id('dbo.ASPProductCategories') and sysstat & 0xf = 3)
	drop table dbo.ASPProductCategories
GO

/****** Object:  Table dbo.ASPProductComments    Script Date: 10/2/99 10:54:56 AM ******/
if exists (select * from sysobjects where id = object_id('dbo.ASPProductComments') and sysstat & 0xf = 3)
	drop table dbo.ASPProductComments
GO

/****** Object:  Table dbo.ASPProductRequests    Script Date: 10/2/99 10:54:56 AM ******/
if exists (select * from sysobjects where id = object_id('dbo.ASPProductRequests') and sysstat & 0xf = 3)
	drop table dbo.ASPProductRequests
GO

/****** Object:  Table dbo.ASPProductSelectLists    Script Date: 10/2/99 10:54:56 AM ******/
if exists (select * from sysobjects where id = object_id('dbo.ASPProductSelectLists') and sysstat & 0xf = 3)
	drop table dbo.ASPProductSelectLists
GO

/****** Object:  Table dbo.ASPProducts    Script Date: 10/2/99 10:54:56 AM ******/
if exists (select * from sysobjects where id = object_id('dbo.ASPProducts') and sysstat & 0xf = 3)
	drop table dbo.ASPProducts
GO

/****** Object:  Table dbo.ASPSelectListItems    Script Date: 10/2/99 10:54:56 AM ******/
if exists (select * from sysobjects where id = object_id('dbo.ASPSelectListItems') and sysstat & 0xf = 3)
	drop table dbo.ASPSelectListItems
GO

/****** Object:  Table dbo.ASPSelectLists    Script Date: 10/2/99 10:54:56 AM ******/
if exists (select * from sysobjects where id = object_id('dbo.ASPSelectLists') and sysstat & 0xf = 3)
	drop table dbo.ASPSelectLists
GO

/****** Object:  Table dbo.ASPSessionItems    Script Date: 10/2/99 10:54:56 AM ******/
if exists (select * from sysobjects where id = object_id('dbo.ASPSessionItems') and sysstat & 0xf = 3)
	drop table dbo.ASPSessionItems
GO

/****** Object:  Table dbo.ASPSessionPages    Script Date: 10/2/99 10:54:56 AM ******/
if exists (select * from sysobjects where id = object_id('dbo.ASPSessionPages') and sysstat & 0xf = 3)
	drop table dbo.ASPSessionPages
GO

/****** Object:  Table dbo.ASPSessions    Script Date: 10/2/99 10:54:56 AM ******/
if exists (select * from sysobjects where id = object_id('dbo.ASPSessions') and sysstat & 0xf = 3)
	drop table dbo.ASPSessions
GO

/****** Object:  Table dbo.ASPShippingCharge    Script Date: 10/2/99 10:54:56 AM ******/
if exists (select * from sysobjects where id = object_id('dbo.ASPShippingCharge') and sysstat & 0xf = 3)
	drop table dbo.ASPShippingCharge
GO

/****** Object:  Table dbo.ASPTaxTable    Script Date: 10/2/99 10:54:56 AM ******/
if exists (select * from sysobjects where id = object_id('dbo.ASPTaxTable') and sysstat & 0xf = 3)
	drop table dbo.ASPTaxTable
GO

/****** Object:  Table dbo.ASPCCTypes    Script Date: 10/2/99 10:54:56 AM ******/
CREATE TABLE dbo.ASPCCTypes (
	CCType varchar (50) NOT NULL 
)
GO

/****** Object:  Table dbo.ASPCategories    Script Date: 10/2/99 10:54:57 AM ******/
CREATE TABLE dbo.ASPCategories (
	CategoryID int IDENTITY (1, 1) NOT NULL ,
	CategoryName varchar (100) NULL ,
	ParentCategory varchar (100) NULL 
)
GO

/****** Object:  Table dbo.ASPContacts    Script Date: 10/2/99 10:54:57 AM ******/
CREATE TABLE dbo.ASPContacts (
	ContactID int IDENTITY (1, 1) NOT NULL ,
	ContactName varchar (100) NULL ,
	ContactEmailAddress varchar (100) NULL ,
	ContactPhone varchar (50) NULL ,
	ContactRole varchar (100) NULL 
)
GO

/****** Object:  Table dbo.ASPCustomer    Script Date: 10/2/99 10:54:57 AM ******/
CREATE TABLE dbo.ASPCustomer (
	CustomerID int IDENTITY (1, 1) NOT NULL ,
	EmailAddress varchar (100) NULL 
)
GO

/****** Object:  Table dbo.ASPCustomerWithCategory    Script Date: 10/2/99 10:54:58 AM ******/
CREATE TABLE dbo.ASPCustomerWithCategory (
	CustomerID int IDENTITY (1, 1) NOT NULL ,
	EmailAddress varchar (100) NULL ,
	Category varchar (100) NULL 
)
GO

/****** Object:  Table dbo.ASPFAQ    Script Date: 10/2/99 10:54:58 AM ******/
CREATE TABLE dbo.ASPFAQ (
	FAQID int IDENTITY (1, 1) NOT NULL ,
	Question varchar (50) NULL ,
	Answer varchar (255) NULL 
)
GO

/****** Object:  Table dbo.ASPHelp    Script Date: 10/2/99 10:54:58 AM ******/
CREATE TABLE dbo.ASPHelp (
	HelpID int IDENTITY (1, 1) NOT NULL ,
	Problem varchar (50) NULL ,
	Solution varchar (255) NULL 
)
GO

/****** Object:  Table dbo.ASPPageText    Script Date: 10/2/99 10:54:58 AM ******/
CREATE TABLE dbo.ASPPageText (
	PageTextID int IDENTITY (1, 1) NOT NULL ,
	PageName varchar (50) NULL ,
	BriefText varchar (100) NULL ,
	ExtendedText text NULL 
)
GO

/****** Object:  Table dbo.ASPProductCategories    Script Date: 10/2/99 10:54:58 AM ******/
CREATE TABLE dbo.ASPProductCategories (
	ProductCategoryID int IDENTITY (1, 1) NOT NULL ,
	CategoryID int NULL ,
	ProductID int NULL 
)
GO

/****** Object:  Table dbo.ASPProductComments    Script Date: 10/2/99 10:54:58 AM ******/
CREATE TABLE dbo.ASPProductComments (
	ProductCommentID int IDENTITY (1, 1) NOT NULL ,
	ProductID int NULL ,
	CommentName varchar (100) NULL ,
	CommentFrom varchar (100) NULL ,
	Comment varchar (255) NULL 
)
GO

/****** Object:  Table dbo.ASPProductRequests    Script Date: 10/2/99 10:54:58 AM ******/
CREATE TABLE dbo.ASPProductRequests (
	ProductRequestID int IDENTITY (1, 1) NOT NULL ,
	ProductName varchar (100) NULL ,
	Description text NULL 
)
GO

/****** Object:  Table dbo.ASPProductSelectLists    Script Date: 10/2/99 10:54:58 AM ******/
CREATE TABLE dbo.ASPProductSelectLists (
	ProductSelectListID int IDENTITY (1, 1) NOT NULL ,
	ProductID int NULL ,
	SelectListID int NULL 
)
GO

/****** Object:  Table dbo.ASPProducts    Script Date: 10/2/99 10:54:58 AM ******/
CREATE TABLE dbo.ASPProducts (
	ProductID int IDENTITY (1, 1) NOT NULL ,
	ProductName varchar (50) NULL ,
	ShortDescription varchar (250) NULL ,
	LongDescription varchar (255) NULL ,
	Path2Icon varchar (150) NULL ,
	Path2Image varchar (150) NULL ,
	Price money NULL ,
	OnClearance int NULL ,
	ClearancePrice money NULL ,
	Weight float NULL 
)
GO

/****** Object:  Table dbo.ASPSelectListItems    Script Date: 10/2/99 10:54:58 AM ******/
CREATE TABLE dbo.ASPSelectListItems (
	SelectListItemID int IDENTITY (1, 1) NOT NULL ,
	SelectListID int NULL ,
	ItemText varchar (50) NULL 
)
GO

/****** Object:  Table dbo.ASPSelectLists    Script Date: 10/2/99 10:54:58 AM ******/
CREATE TABLE dbo.ASPSelectLists (
	SelectListID int IDENTITY (1, 1) NOT NULL ,
	SelectListName varchar (50) NULL 
)
GO

/****** Object:  Table dbo.ASPSessionItems    Script Date: 10/2/99 10:54:58 AM ******/
CREATE TABLE dbo.ASPSessionItems (
	SessionItemID int IDENTITY (1, 1) NOT NULL ,
	SessionID int NULL ,
	ProductID int NULL ,
	Quantity int NULL ,
	SelectText varchar (255) NULL ,
	ItemPrice money NULL 
)
GO

/****** Object:  Table dbo.ASPSessionPages    Script Date: 10/2/99 10:54:58 AM ******/
CREATE TABLE dbo.ASPSessionPages (
	SessionPageID int IDENTITY (1, 1) NOT NULL ,
	SessionID int NULL ,
	PageName varchar (75) NULL 
)
GO

/****** Object:  Table dbo.ASPSessions    Script Date: 10/2/99 10:54:59 AM ******/
CREATE TABLE dbo.ASPSessions (
	SessionID int IDENTITY (1, 1) NOT NULL ,
	SessionStarted datetime NULL ,
	SessionEnded datetime NULL ,
	RefSource varchar (200) NULL ,
	Browser varchar (75) NULL ,
	OS varchar (75) NULL ,
	BillName varchar (50) NULL ,
	EmailAddress varchar (50) NULL ,
	Phone varchar (50) NULL ,
	Phone2 varchar (50) NULL ,
	BillAddress1 varchar (100) NULL ,
	BillAddress2 varchar (100) NULL ,
	BillCSZ varchar (100) NULL ,
	ShipName varchar (50) NULL ,
	ShipAddress1 varchar (100) NULL ,
	ShipAddress2 varchar (100) NULL ,
	ShipCSZ varchar (100) NULL ,
	CCType varchar (50) NULL ,
	CCNumber varchar (50) NULL ,
	CCExpiration varchar (50) NULL ,
	Comments text NULL ,
	ProductTotal money NULL ,
	ShippingTotal money NULL ,
	TaxTotal money NULL ,
	OrderTotal money NULL ,
	Status varchar (255) NULL 
)
GO

/****** Object:  Table dbo.ASPShippingCharge    Script Date: 10/2/99 10:54:59 AM ******/
CREATE TABLE dbo.ASPShippingCharge (
	ShippingChargeID int IDENTITY (1, 1) NOT NULL ,
	Location varchar (50) NULL ,
	MinimumShipping money NULL ,
	PerPoundShipping money NULL ,
	BaseRate money NULL 
)
GO

/****** Object:  Table dbo.ASPTaxTable    Script Date: 10/2/99 10:54:59 AM ******/
CREATE TABLE dbo.ASPTaxTable (
	TaxTableID int IDENTITY (1, 1) NOT NULL ,
	Location varchar (50) NULL ,
	TaxRate float NULL 
)
GO

