/* Add new columns for T_Review */
ALTER TABLE T_Review ADD IsPublic BIT NOT NULL DEFAULT 0;
ALTER TABLE T_Review ADD CreateDate DATETIME NULL;

/* Adding new index for T_Comment to improve performance */
CREATE INDEX IX_Comment4 ON T_Comment ([DocumentId],[ParentCommentId],[ThreadCommentId]) INCLUDE ([ParagraphId],[UpdateDate]);

/* Schema Versioning */
UPDATE T_SchemaInfo SET SchemaVersion = '6.5.0';
GO