CREATE TABLE T_ReviewMetrics(
	ObjectId		INT				NOT NULL,
	WorkgroupId		INT				NOT NULL,
	Sequence		INT				NOT NULL,
	Name			NVARCHAR2(128)	NOT NULL,
	Description		NVARCHAR2(500)	NULL,
	IsMandatory		INT				NOT NULL,
	Type			INT				NOT NULL,
	Definition		NCLOB			NOT NULL
);
CREATE UNIQUE INDEX IX_ReviewMetrics ON T_ReviewMetrics (ObjectId);
COMMIT;

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			NVARCHAR2(128)	NOT NULL,
	Description		NVARCHAR2(500)	NULL,
	IsMandatory		INT				NOT NULL,
	Type			INT				NOT NULL,
	Definition		NCLOB			NOT NULL,
	MetricsValue	NCLOB			NULL
);
CREATE UNIQUE INDEX IX_ReviewMetricsValue ON T_ReviewMetricsValue (ObjectId);
COMMIT;

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

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