/*******************************************************************************
* 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])