ÿþ

/*******************************************************************************

* 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