No OneTemporary
Actions

Size

1 KB

Referenced Files

None

Subscribers

None

View Options

	diff --git a/resources/sql/patches/088.audit.sql b/resources/sql/patches/088.audit.sql
	index a5b23a7cca..a1d90be6d7 100644
	--- a/resources/sql/patches/088.audit.sql
	+++ b/resources/sql/patches/088.audit.sql
	@@ -1,23 +1,23 @@
	+CREATE DATABASE IF NOT EXISTS phabricator_audit;
	+
	ALTER TABLE phabricator_owners.owners_packagecommitrelationship
	ADD COLUMN `auditStatus` varchar(64) NOT NULL,
	ADD COLUMN `auditReasons` longtext NOT NULL,
	DROP KEY `packagePHID`,
	ADD KEY `packagePHID` (`packagePHID`, `auditStatus`, `id`);

	-CREATE DATABASE IF NOT EXISTS phabricator_audit;
	-
	CREATE TABLE IF NOT EXISTs phabricator_audit.audit_comment (
	`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
	`phid` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
	`targetPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
	`actorPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
	`dateCreated` int(10) unsigned NOT NULL,
	`dateModified` int(10) unsigned NOT NULL,
	`action` varchar(64) NOT NULL,
	`content` longtext NOT NULL,
	PRIMARY KEY `id` (`id`),
	KEY `targetPHID` (`targetPHID`, `actorPHID`, `id`)
	) ENGINE=InnoDB DEFAULT CHARSET=latin1;

	ALTER TABLE phabricator_owners.owners_package
	ADD COLUMN `auditingEnabled` tinyint(1) NOT NULL DEFAULT 0;