resources/sql/patches/114.auditrequest.sql at recaptime-dev/main

@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

fork atom

phorge / resources / sql / patches / 114.auditrequest.sql

at recaptime-dev/main 16 lines 650 B view raw

wrap content

epriestley SQL Patch Management: SQL Changes 14y ago

68b597ff

 1CREATE TABLE {$NAMESPACE}_repository.repository_auditrequest (
 2  id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
 3  auditorPHID varchar(64) BINARY NOT NULL,
 4  commitPHID varchar(64) BINARY NOT NULL,
 5  auditStatus varchar(64) NOT NULL,
 6  auditReasons LONGBLOB NOT NULL,
 7  KEY (commitPHID),
 8  KEY (auditorPHID, auditStatus)
 9) ENGINE=InnoDB;
10
11INSERT INTO {$NAMESPACE}_repository.repository_auditrequest
12    (auditorPHID, commitPHID, auditStatus, auditReasons)
13  SELECT packagePHID, commitPHID, auditStatus, auditReasons
14    FROM {$NAMESPACE}_owners.owners_packagecommitrelationship;
15
16DROP TABLE {$NAMESPACE}_owners.owners_packagecommitrelationship;