ÿþ

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

* Author:		Frank Bazan

* Created:		08 May 2007

* Description:	Create table to hold Articles for replication

*

* Change History:

* ==============================================================================

* Author      Version      Change Date      Description

* ------------------------------------------------------------------------------

* F.Bazan		1.0        8 May 2007      Initial Create Script

* F.Bazan		1.1		  14 May 2007		Added constraint for referential integrity

* ==============================================================================

*/





-- Article

IF EXISTS (	SELECT 1 

			FROM SYS.FOREIGN_KEYS 

			WHERE OBJECT_ID = OBJECT_ID(N'[dbo].[FK_Article_Publication]') 

			AND parent_object_id = OBJECT_ID(N'[dbo].[Article]') )

BEGIN

	ALTER TABLE [dbo].[Article] DROP CONSTRAINT [FK_Article_Publication]

END



IF EXISTS (	SELECT 1 

			FROM SYS.OBJECTS 

			WHERE OBJECT_ID = OBJECT_ID('dbo.Article')

			AND type in (N'U'))

BEGIN

	DROP TABLE [dbo].[Article]

END



CREATE TABLE [dbo].[Article](

	[ArticleId] INT IDENTITY NOT NULL,

	[PublicationId] INT NOT NULL,

	[ArticleName] [nvarchar] (128) NOT NULL,

	[SourceSchema] NVARCHAR (128) NULL,

	[DestinationSchema] NVARCHAR (128) NULL

) ON [PRIMARY]





ALTER TABLE [dbo].[Article] 

ADD CONSTRAINT PK_Article PRIMARY KEY (ArticleId)



ALTER TABLE [dbo].[Article]

ADD CONSTRAINT [FK_Article_Publication] FOREIGN KEY([PublicationId])

REFERENCES [dbo].[Publication] ([PublicationId])