recaptime.dev
@recaptime-dev's working patches + fork for Phorge, a community fork of Phabricator. (Upstream dev and stable branches are at upstream/main and upstream/stable respectively.)
hq.recaptime.dev/wiki/Phorge
phorge
phabricator
1ALTER TABLE {$NAMESPACE}_owners.owners_packagecommitrelationship
2 ADD COLUMN `auditStatus` varchar(64) NOT NULL,
3 ADD COLUMN `auditReasons` longtext NOT NULL,
4 DROP KEY `packagePHID`,
5 ADD KEY `packagePHID` (`packagePHID`, `auditStatus`, `id`);
6
7CREATE TABLE IF NOT EXISTs {$NAMESPACE}_audit.audit_comment (
8 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
9 `phid` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
10 `targetPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
11 `actorPHID` varchar(64) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
12 `dateCreated` int(10) unsigned NOT NULL,
13 `dateModified` int(10) unsigned NOT NULL,
14 `action` varchar(64) NOT NULL,
15 `content` longtext NOT NULL,
16 PRIMARY KEY `id` (`id`),
17 KEY `targetPHID` (`targetPHID`, `actorPHID`, `id`)
18) ENGINE=InnoDB DEFAULT CHARSET=latin1;
19
20ALTER TABLE {$NAMESPACE}_owners.owners_package
21 ADD COLUMN `auditingEnabled` tinyint(1) NOT NULL DEFAULT 0;