[Summary view] [Print] [Text view]

   1  ALTER 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  
   7  CREATE 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  
  20  ALTER TABLE {$NAMESPACE}_owners.owners_package
  21    ADD COLUMN `auditingEnabled` tinyint(1) NOT NULL DEFAULT 0;