[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_harbormaster.harbormaster_buildtarget (
   2    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
   3    phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
   4    buildPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
   5    buildStepPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
   6    className VARCHAR(255) NOT NULL COLLATE utf8_bin,
   7    details LONGTEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
   8    variables LONGTEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
   9    dateCreated INT UNSIGNED NOT NULL,
  10    dateModified INT UNSIGNED NOT NULL,
  11    KEY `key_build` (buildPHID, buildStepPHID),
  12    UNIQUE KEY `key_phid` (phid)
  13  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
  14  
  15  TRUNCATE TABLE {$NAMESPACE}_harbormaster.harbormaster_buildlog;
  16  TRUNCATE TABLE {$NAMESPACE}_harbormaster.harbormaster_buildlogchunk;
  17  TRUNCATE TABLE {$NAMESPACE}_harbormaster.harbormaster_buildartifact;
  18  
  19  ALTER TABLE {$NAMESPACE}_harbormaster.harbormaster_buildlog
  20  DROP COLUMN buildPHID;
  21  
  22  ALTER TABLE {$NAMESPACE}_harbormaster.harbormaster_buildlog
  23  DROP COLUMN buildStepPHID;
  24  
  25  ALTER TABLE {$NAMESPACE}_harbormaster.harbormaster_buildartifact
  26  DROP COLUMN buildablePHID;
  27  
  28  ALTER TABLE {$NAMESPACE}_harbormaster.harbormaster_buildlog
  29  ADD COLUMN buildTargetPHID VARCHAR(64) NOT NULL COLLATE utf8_bin;
  30  
  31  ALTER TABLE {$NAMESPACE}_harbormaster.harbormaster_buildartifact
  32  ADD COLUMN buildTargetPHID VARCHAR(64) NOT NULL COLLATE utf8_bin;