/****** オブジェクト :  テーブル [dbo].[blog_SPAMKey]    スクリプト日付 : 2005/07/03 0:17:40 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[blog_SPAMKey]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[blog_SPAMKey]
GO

/****** オブジェクト :  テーブル [dbo].[blog_SPAMKey]    スクリプト日付 : 2005/07/03 0:17:41 ******/
CREATE TABLE [dbo].[blog_SPAMKey] (
	[Title] [nvarchar] (255) COLLATE Japanese_CI_AS NOT NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[blog_SPAMKey] WITH NOCHECK ADD 
	CONSTRAINT [PK_blog_SPAMKey] PRIMARY KEY  CLUSTERED 
	(
		[Title]
	)  ON [PRIMARY] 
GO



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

CREATE TABLE [dbo].[blog_SPAM] (
	[ID] [int] IDENTITY (145, 1) NOT NULL ,
	[Title] [nvarchar] (255) COLLATE Japanese_CI_AS NOT NULL ,
	[DateAdded] [smalldatetime] NOT NULL ,
	[SourceUrl] [nvarchar] (200) COLLATE Japanese_CI_AS NULL ,
	[PostType] [int] NOT NULL ,
	[Author] [nvarchar] (50) COLLATE Japanese_CI_AS NULL ,
	[Email] [nvarchar] (50) COLLATE Japanese_CI_AS NULL ,
	[SourceName] [nvarchar] (200) COLLATE Japanese_CI_AS NULL ,
	[BlogID] [int] NULL ,
	[Description] [nvarchar] (500) COLLATE Japanese_CI_AS NULL ,
	[DateUpdated] [smalldatetime] NULL ,
	[TitleUrl] [nvarchar] (255) COLLATE Japanese_CI_AS NULL ,
	[Text] [ntext] COLLATE Japanese_CI_AS NULL ,
	[ParentID] [int] NULL ,
	[FeedBackCount] [int] NULL ,
	[PostConfig] [int] NULL ,
	[EntryName] [varchar] (100) COLLATE Japanese_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[blog_SPAM] WITH NOCHECK ADD 
	CONSTRAINT [PK_blog_SPAM] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	) WITH  FILLFACTOR = 90  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[blog_SPAM] ADD 
	CONSTRAINT [DF__blog_SPAM__DateU__075714DC] DEFAULT (getdate()) FOR [DateUpdated],
	CONSTRAINT [DF__blog_SPAM__Paren__0ABD916C] DEFAULT ((-1)) FOR [ParentID],
	CONSTRAINT [DF__blog_SPAM__FeedB__0BB1B5A5] DEFAULT (0) FOR [FeedBackCount],
	CONSTRAINT [DF__blog_SPAM__PostC__24B26D99] DEFAULT (0) FOR [PostConfig]
GO

 CREATE  INDEX [IX_blog_SPAM_EntryName] ON [dbo].[blog_SPAM]([EntryName]) WITH  FILLFACTOR = 90 ON [PRIMARY]
GO

 CREATE  INDEX [IX_blog_SPAM_PostType] ON [dbo].[blog_SPAM]([PostType]) WITH  FILLFACTOR = 90 ON [PRIMARY]
GO

 CREATE  INDEX [IX_blog_SPAM_BlogID] ON [dbo].[blog_SPAM]([BlogID]) WITH  FILLFACTOR = 90 ON [PRIMARY]
GO

 CREATE  INDEX [IX_blog_SPAM_ParentID] ON [dbo].[blog_SPAM]([ParentID]) WITH  FILLFACTOR = 90 ON [PRIMARY]
GO

 CREATE  INDEX [IX_blog_SPAM_DateUpdated] ON [dbo].[blog_SPAM]([DateUpdated] DESC ) WITH  FILLFACTOR = 90 ON [PRIMARY]
GO

 CREATE  INDEX [IX_blog_SPAM_PostConfig] ON [dbo].[blog_SPAM]([PostConfig]) WITH  FILLFACTOR = 90 ON [PRIMARY]
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO







GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO