/* Add new columns for T_Review */
ALTER TABLE T_Review ADD IsPublic INT DEFAULT 0 NOT NULL;
ALTER TABLE T_Review ADD CreateDate TIMESTAMP(3) NULL;

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

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