[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_harbormaster.harbormaster_buildcommand (
   2    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
   3    authorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
   4    targetPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
   5    command VARCHAR(128) NOT NULL COLLATE utf8_bin,
   6    dateCreated INT UNSIGNED NOT NULL,
   7    dateModified INT UNSIGNED NOT NULL,
   8    KEY `key_target` (targetPHID)
   9  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
  10  
  11  ALTER TABLE {$NAMESPACE}_harbormaster.harbormaster_build
  12    DROP cancelRequested;
  13  
  14  ALTER TABLE {$NAMESPACE}_harbormaster.harbormaster_buildtarget
  15    ADD targetStatus VARCHAR(64) NOT NULL COLLATE utf8_bin;
  16  
  17  UPDATE {$NAMESPACE}_harbormaster.harbormaster_buildtarget
  18    SET targetStatus = 'target/pending' WHERE targetStatus = '';