Differential D8344 Diff 19854 resources/sql/patches/088.audit.sql

Changeset View

Standalone View



	ALTER TABLE {$NAMESPACE}_owners.owners_packagecommitrelationship			ALTER TABLE {$NAMESPACE}_owners.owners_packagecommitrelationship
	ADD COLUMN `auditStatus` varchar(64) NOT NULL,			ADD COLUMN `auditStatus` varchar(64) NOT NULL,
	ADD COLUMN `auditReasons` longtext NOT NULL,			ADD COLUMN `auditReasons` longtext NOT NULL,
	DROP KEY `packagePHID`,			DROP KEY `packagePHID`,
	ADD KEY `packagePHID` (`packagePHID`, `auditStatus`, `id`);			ADD KEY `packagePHID` (`packagePHID`, `auditStatus`, `id`);

	CREATE TABLE IF NOT EXISTs {$NAMESPACE}_audit.audit_comment (			CREATE TABLE IF NOT EXISTs {$NAMESPACE}_audit.audit_comment (
	`id` int(10) unsigned NOT NULL AUTO_INCREMENT,			`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
	Show All 13 Lines