/*******************************************************************************
* Author:		Frank Bazan
* Created:		8 May 2007
* Description:	Holds replication meta data for publisher/publication
*
* Change History:
* ==============================================================================
* Author      Version      Change Date      Description
* ------------------------------------------------------------------------------
* F.Bazan		1.0			8 May 2007      Initial Create Script
* ==============================================================================
*/

IF EXISTS ( SELECT 1 FROM SYS.FOREIGN_KEYS WHERE [object_id] = OBJECT_ID('FK_Subscription_Publication') )
ALTER TABLE dbo.Subscription DROP CONSTRAINT FK_Subscription_Publication

IF EXISTS ( SELECT 1 FROM SYS.FOREIGN_KEYS WHERE [object_id] = OBJECT_ID('FK_Article_Publication') )
ALTER TABLE dbo.Article DROP CONSTRAINT FK_Article_Publication


IF EXISTS (	SELECT 1 
			FROM SYS.OBJECTS 
			WHERE OBJECT_ID = OBJECT_ID('dbo.Publication')
			AND type in (N'U'))
BEGIN
	DROP TABLE [dbo].[Publication]
END

CREATE TABLE [dbo].[Publication](
	[PublicationId] INT IDENTITY NOT NULL,
	[DataUserDesc] [nvarchar](256) NULL,
	[DataUserCode] [nvarchar] (3) NOT NULL,
	[PublisherServerName] [nvarchar](128) NOT NULL,
	[PublisherSecurityMode] INT NOT NULL,
	[PublisherLogin] [nvarchar](128) NULL,				-- login for connection to publisher
	[PublisherPwd] [nvarchar](128) NULL,				-- pwd for publisher login
	[DistributorAgentLogin] [nvarchar](128) NULL,		-- login for agent to connect to distributor
	[DistributorAgentPwd] [nvarchar](128) NULL,			-- pwd for distributor login
	[PublicationDatabase] [nvarchar](128) NOT NULL,
	[PublicationName] [nvarchar](128) NOT NULL
) ON [PRIMARY]

ALTER TABLE [dbo].[Publication] 
ADD CONSTRAINT PK_Publication PRIMARY KEY (PublicationId)
GO