CREATE TABLE [dbo].[Posts](
	[Id] [bigint] IDENTITY(4500100100,1) NOT FOR REPLICATION NOT NULL,
	[BlogId] [int] NOT NULL,
	[PersonId] [int] NOT NULL,
	 [nvarchar](4000) NOT NULL,
	[Title] [nvarchar](4000) NOT NULL,
	[PublishDate] [datetime] NULL,
	[Timestamp] [datetime] NULL,
	[cs_Url]  AS (checksum()),
	[UpdateDate] [datetime] NULL,
	[PostContentId] [bigint] NULL,
	[WatchComments] [bit] NULL,
	[CommentsLastUpdated] [datetime] NULL,
	[PlagiarismId] [int] NULL,
	[DuplicateOfId] [int] NULL,
	[repl] [bit] NOT NULL,
	[PostProcessingState_Id] [int] NULL,
	[IsComment] [bit] NOT NULL,
	[cs_Title]  AS (checksum([Title])),
	[CreateDate] [datetime] NULL,
	[IsSpam] [bit] NULL,
	L400]  AS (left(,(400))),
	[MessageType] [int] NULL,
	[LanguageId] [int] NULL,
	[BlogHostId] [int] NULL,
	[BlogHostType] [tinyint] NULL,
	[ParentUrl] [nvarchar](4000) NULL,
	[IsAd] [bit] NULL,
	[CountryId] [int] NULL,
	[RegionId] [int] NULL,
	[AreaId] [int] NULL,
	[CityId] [int] NULL,
	[BlogFollowersNum] [int] NULL,
	[AuthorBlogId] [int] NULL,
	[VisibilityIndex] [float] NULL,
	[BlogInfluenceRate] [int] NULL,
PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [SSD_FG]
) ON [SSD_FG]
GO

ALTER TABLE [dbo].[Posts] ADD  DEFAULT ((0)) FOR [IsComment]
GO

ALTER TABLE [dbo].[Posts] ADD  DEFAULT (getutcdate()) FOR [CreateDate]
GO

ALTER TABLE [dbo].[Posts] ADD  DEFAULT ((0)) FOR [IsSpam]
GO