I am attempting to install the IBuyAdventure application. I discovered that products.sql is blank. Product.txt has the data to import but could you provide the SQL script to create the products table?

Thanks in advance.

well , buddy I've written it today 06 Sept 2005.. Its a bit late for you but others do get some help...

Here is that : for SQL Server 2005 .... Generated Scripts.

************************************************** ************************************************** ****

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Accounts]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Accounts]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Orders]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Orders]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Products]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Products]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ShoppingCarts]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ShoppingCarts]
GO

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

CREATE TABLE [dbo].[Orders] (
    [CustomerName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [Ordered] [datetime] NULL ,
    [TotalValue] [float] NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Products] (
    [ProductID] [int] IDENTITY (1, 1) 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] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [ProductImageURL] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [UnitPrice] [float] NULL ,
    [OnSale] [int] NULL ,
    [Rating] [float] NULL
) ON [PRIMARY]
GO

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

************************************************** **************************************************


Roomee Panhwar