if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[blog_Attachments]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[blog_Attachments]
GO

if not exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[blog_Attachments]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
 BEGIN
CREATE TABLE [dbo].[blog_Attachments] (
	[AttachID] [int] IDENTITY (1, 1) NOT NULL ,
	[PostID] [int] NOT NULL ,
	[SizeInBytes] [int] NOT NULL ,
	[MimeType] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[FileName] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL 
) ON [PRIMARY]
END

GO

ALTER TABLE [dbo].[blog_Attachments] WITH NOCHECK ADD 
	CONSTRAINT [PK_blog_Attachments] PRIMARY KEY  CLUSTERED 
	(
		[AttachID]
	)  ON [PRIMARY] 
GO