/asp/freeapps/prodmentor/sqlserver.txt
if exists (select * from sysobjects where id = object_id(N'[dbo].[proddemo_brand]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[proddemo_brand]
GO
if exists (select * from sysobjects where id = object_id(N'[dbo].[proddemo_category]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[proddemo_category]
GO
if exists (select * from sysobjects where id = object_id(N'[dbo].[proddemo_model]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[proddemo_model]
GO
CREATE TABLE [dbo].[proddemo_brand] (
[fldAuto] [int] IDENTITY (1, 1) NOT NULL ,
[category_fldAuto] [int] NULL ,
[name] [nvarchar] (50) NULL ,
[orderingfield] [nvarchar] (10) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[proddemo_category] (
[fldAuto] [int] IDENTITY (1, 1) NOT NULL ,
[name] [nvarchar] (50) NULL ,
[descr] [nvarchar] (255) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[proddemo_model] (
[fldAuto] [int] IDENTITY (1, 1) NOT NULL ,
[brand_fldAuto] [int] NULL ,
[model] [nvarchar] (255) NULL ,
[descr] [ntext] NULL ,
[imgurl] [nvarchar] (50) NULL ,
[orderingfield] [nvarchar] (10) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO