[Summary view] [Print] [Text view]

   1  CREATE 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  
  11  INSERT INTO {$NAMESPACE}_repository.repository_auditrequest
  12      (auditorPHID, commitPHID, auditStatus, auditReasons)
  13    SELECT packagePHID, commitPHID, auditStatus, auditReasons
  14      FROM {$NAMESPACE}_owners.owners_packagecommitrelationship;
  15  
  16  DROP TABLE {$NAMESPACE}_owners.owners_packagecommitrelationship;