Here's the CREATE TABLE SQL for the 4 tables...
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[Adverts]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Adverts]
GO
CREATE TABLE [dbo].[Adverts] (
[PK_ID] [int] IDENTITY (1, 1) NOT NULL ,
[FK_AdvertStyles] [int] NOT NULL ,
[FK_Users] [int] NOT NULL ,
[Identifier] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Created] [datetime] NULL ,
[Modified] [datetime] NULL ,
[ThumbnailPreviewPath] [nvarchar] (250) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL ,
[PreviewPath] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Picture_Count] [int] NOT NULL ,
[Production_Notes] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[Checked] [bit] NULL ,
[Production_Ad] [bit] NULL ,
[Motors] [bit] NULL ,
[Before_All] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[After_All] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Before_Heading] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
,
[After_Heading] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
,
[Field_Delimiter] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
,
[Field_Layout] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Motor_Demo_Text] [nvarchar] (4000) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[Auto_Fit] [bit] NULL ,
[Allow_Graphics] [bit] NULL ,
[Edit_Position] [int] NULL ,
[Property_Template] [bit] NULL ,
[Approved] [bit] NULL ,
[Production_File_Path] [nvarchar] (250) COLLATE
SQL_Latin1_General_CP1_CI_AS NULL ,
[Star_Buy_Marker] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
,
[CC_Type] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[CC_Number] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[CC_Expiry] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Motor_Text] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Single_Text_Box] [bit] NULL ,
[End_Of_Heading] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
,
[Motor_List_Before_Items] [bit] NULL ,
[Rate_Per_Insertion] [float] NULL ,
[Total_Cost] [float] NULL ,
[Use_Delimiters_For_All] [bit] NULL ,
[Built_With_AdvertStyle_ID] [int] NULL ,
[Copy_Idea_Category] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[Last_Built_Preview] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[Property_Module] [bit] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[Groups]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Groups]
GO
CREATE TABLE [dbo].[Groups] (
[PK_ID] [int] IDENTITY (1, 1) NOT NULL ,
[Groups] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Administrator] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT
NULL
) ON [PRIMARY]
GO
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[Users_Groups_Link]') and OBJECTPROPERTY(id,
N'IsUserTable') = 1)
drop table [dbo].[Users_Groups_Link]
GO
CREATE TABLE [dbo].[Users_Groups_Link] (
[FK_Users] [int] NOT NULL ,
[FK_Groups] [int] NOT NULL
) ON [PRIMARY]
GO
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[Users]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Users]
GO
CREATE TABLE [dbo].[Users] (
[uID] [int] IDENTITY (1, 1) NOT NULL ,
[username] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[password] [nvarchar] (20) COLLATE Latin1_General_CS_AI NOT NULL ,
[Title] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Forename] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Surname] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[email] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[CompanyName] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
,
[Address] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Telephone] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[fax] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[URL] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[canDeleteAdverts] [bit] NOT NULL ,
[canManageNews] [bit] NOT NULL ,
[DefaultAdvertStyle] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS
NOT NULL ,
[DefaultArtworkCategory] [nvarchar] (30) COLLATE
SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
---
You are currently subscribed to activeserverpages as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
