CREATE TABLE T_ReviewMetrics(
	ObjectId		INT				NOT NULL,
	WorkgroupId		INT				NOT NULL,
	Sequence		INT				NOT NULL,
	Name			NVARCHAR(128)	NOT NULL,
	Description		NVARCHAR(500)	NULL,
	IsMandatory		BIT				NOT NULL,
	Type			INT				NOT NULL,
	Definition		NTEXT			NOT NULL
);
CREATE UNIQUE CLUSTERED INDEX IX_ReviewMetrics ON T_ReviewMetrics (ObjectId);
GO

CREATE TABLE T_ReviewMetricsValue(
	ObjectId		INT				NOT NULL,
	ReviewId		INT				NOT NULL,
	ReviewMetricsId	INT				NOT NULL,
	WorkgroupId		INT				NOT NULL,
	Sequence		INT				NOT NULL,
	Name			NVARCHAR(128)	NOT NULL,
	Description		NVARCHAR(500)	NULL,
	IsMandatory		BIT				NOT NULL,
	Type			INT				NOT NULL,
	Definition		NTEXT			NOT NULL,
	MetricsValue	NTEXT			NULL
);
CREATE UNIQUE CLUSTERED INDEX IX_ReviewMetricsValue ON T_ReviewMetricsValue (ObjectId);
GO

UPDATE T_Config SET TextParam1 = StringParam1, StringParam1 = '' WHERE EntryName = 'CommentCategory';
GO

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