/asp/freeapps/topsitementor/sqlserver.txt
if exists (select * from sysobjects where id = object_id(N'[dbo].[cat]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[cat]
GO
if exists (select * from sysobjects where id = object_id(N'[dbo].[site]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[site]
GO
if exists (select * from sysobjects where id = object_id(N'[dbo].[sysvar]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[sysvar]
GO
CREATE TABLE [dbo].[cat] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[txt] [nvarchar] (50) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[site] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[url] [nvarchar] (255) NULL ,
[sitename] [nvarchar] (255) NULL ,
[sitedescr] [nvarchar] (255) NULL ,
[catid] [int] NULL ,
[incount] [int] NULL ,
[outcount] [int] NULL ,
[joinedwhen] [datetime] NULL ,
[email] [nvarchar] (255) NULL ,
[password] [nvarchar] (255) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[sysvar] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[startdate] [datetime] NULL
) ON [PRIMARY]
GO