/****** Object:  Database Mailing List Database    Script Date: 1/3/2003 9:54:12 PM ******/
IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'Mailing List Database')
	DROP DATABASE [Mailing List Database]
GO

CREATE DATABASE [Mailing List Database]  ON (NAME = N'Mailing List Database_Data', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL\Data\Mailing List Database_Data.MDF' , SIZE = 1, FILEGROWTH = 10%) LOG ON (NAME = N'Mailing List Database_Log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL\Data\Mailing List Database_Log.LDF' , SIZE = 1, FILEGROWTH = 10%)
 COLLATE SQL_Latin1_General_CP1_CI_AS
GO

exec sp_dboption N'Mailing List Database', N'autoclose', N'true'
GO

exec sp_dboption N'Mailing List Database', N'bulkcopy', N'false'
GO

exec sp_dboption N'Mailing List Database', N'trunc. log', N'true'
GO

exec sp_dboption N'Mailing List Database', N'torn page detection', N'true'
GO

exec sp_dboption N'Mailing List Database', N'read only', N'false'
GO

exec sp_dboption N'Mailing List Database', N'dbo use', N'false'
GO

exec sp_dboption N'Mailing List Database', N'single', N'false'
GO

exec sp_dboption N'Mailing List Database', N'autoshrink', N'true'
GO

exec sp_dboption N'Mailing List Database', N'ANSI null default', N'false'
GO

exec sp_dboption N'Mailing List Database', N'recursive triggers', N'false'
GO

exec sp_dboption N'Mailing List Database', N'ANSI nulls', N'false'
GO

exec sp_dboption N'Mailing List Database', N'concat null yields null', N'false'
GO

exec sp_dboption N'Mailing List Database', N'cursor close on commit', N'false'
GO

exec sp_dboption N'Mailing List Database', N'default to local cursor', N'false'
GO

exec sp_dboption N'Mailing List Database', N'quoted identifier', N'false'
GO

exec sp_dboption N'Mailing List Database', N'ANSI warnings', N'false'
GO

exec sp_dboption N'Mailing List Database', N'auto create statistics', N'true'
GO

exec sp_dboption N'Mailing List Database', N'auto update statistics', N'true'
GO

use [Mailing List Database]
GO

/****** Object:  Table [dbo].[Subscriptions]    Script Date: 1/3/2003 9:54:15 PM ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Subscriptions]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Subscriptions]
GO

/****** Object:  Login Test    Script Date: 1/3/2003 9:54:12 PM ******/
if not exists (select * from master.dbo.syslogins where loginname = N'Test')
BEGIN
	declare @logindb nvarchar(132), @loginlang nvarchar(132) select @logindb = N'Mailing List Database', @loginlang = N'us_english'
	if @logindb is null or not exists (select * from master.dbo.sysdatabases where name = @logindb)
		select @logindb = N'master'
	if @loginlang is null or (not exists (select * from master.dbo.syslanguages where name = @loginlang) and @loginlang <> N'us_english')
		select @loginlang = @@language
	exec sp_addlogin N'Test', null, @logindb, @loginlang
END
GO

/****** Object:  Login Test    Script Date: 1/3/2003 9:54:12 PM ******/
exec sp_addsrvrolemember N'Test', sysadmin
GO

/****** Object:  Table [dbo].[Subscriptions]    Script Date: 1/3/2003 9:54:17 PM ******/
CREATE TABLE [dbo].[Subscriptions] (
	[Record_ID] [uniqueidentifier] NOT NULL ,
	[subFirstName] [char] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[subLastName] [char] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[subEmail] [char] (45) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[Subscriptions] WITH NOCHECK ADD 
	CONSTRAINT [PK_Subscriptions] PRIMARY KEY  CLUSTERED 
	(
		[Record_ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Subscriptions] WITH NOCHECK ADD 
	CONSTRAINT [DF_Subscriptions_Record_ID] DEFAULT (newid()) FOR [Record_ID]
GO


exec sp_addextendedproperty N'MS_Description', N'Record Identification and Primary Key', N'user', N'dbo', N'table', N'Subscriptions', N'column', N'Record_ID'
GO
exec sp_addextendedproperty N'MS_Description', N'Subscribers First Name', N'user', N'dbo', N'table', N'Subscriptions', N'column', N'subFirstName'
GO
exec sp_addextendedproperty N'MS_Description', N'Subscribers Last Name', N'user', N'dbo', N'table', N'Subscriptions', N'column', N'subLastName'
GO
exec sp_addextendedproperty N'MS_Description', N'Subscribers Email Address', N'user', N'dbo', N'table', N'Subscriptions', N'column', N'subEmail'


GO