USE [ReportServer]
GO
/****** Object:  Table [dbo].[database_details] Script Date: 06/22/2008 11:14:25 beakersoft.co.uk ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[database_details](
	[site_id] [int] NOT NULL,
	[site] [varchar](50) COLLATE Latin1_General_CI_AS_KS_WS NOT NULL,
	[server_name] [varchar](100) COLLATE Latin1_General_CI_AS_KS_WS NOT NULL,
	[database_name] [varchar](50) COLLATE Latin1_General_CI_AS_KS_WS NOT NULL,
	[security_group] [varchar](75) COLLATE Latin1_General_CI_AS_KS_WS NULL,
 CONSTRAINT [PK_database_details] PRIMARY KEY CLUSTERED 
(
	[site_id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

/****** Object:  Table [dbo].[user_details]    Script Date: 06/22/2008 11:14:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[user_details](
	[username] [varchar](100) COLLATE Latin1_General_CI_AS_KS_WS NOT NULL,
	[site_id] [int] NOT NULL,
 CONSTRAINT [PK_user_details] PRIMARY KEY CLUSTERED 
(
	[username] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF