[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_harbormaster.harbormaster_buildable (
   2    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
   3    phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
   4    buildablePHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
   5    containerPHID VARCHAR(64) COLLATE utf8_bin,
   6    buildStatus VARCHAR(32) NOT NULL COLLATE utf8_bin,
   7    buildableStatus VARCHAR(32) NOT NULL COLLATE utf8_bin,
   8    dateCreated INT UNSIGNED NOT NULL,
   9    dateModified INT UNSIGNED NOT NULL,
  10    KEY `key_buildable` (buildablePHID),
  11    KEY `key_container` (containerPHID),
  12    UNIQUE KEY `key_phid` (phid)
  13  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
  14  
  15  CREATE TABLE {$NAMESPACE}_harbormaster.harbormaster_buildartifact (
  16    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
  17    buildablePHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
  18    artifactType VARCHAR(32) NOT NULL COLLATE utf8_bin,
  19    artifactIndex VARCHAR(12) NOT NULL COLLATE utf8_bin,
  20    artifactKey VARCHAR(255) NOT NULL COLLATE utf8_bin,
  21    artifactData LONGTEXT NOT NULL COLLATE utf8_bin,
  22    dateCreated INT UNSIGNED NOT NULL,
  23    dateModified INT UNSIGNED NOT NULL,
  24    UNIQUE KEY `key_artifact` (buildablePHID, artifactType, artifactIndex),
  25    UNIQUE KEY `key_artifact_type` (artifactType, artifactIndex),
  26    KEY `key_garbagecollect` (artifactType, dateCreated)
  27  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
  28  
  29  CREATE TABLE {$NAMESPACE}_harbormaster.harbormaster_buildplan (
  30    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
  31    phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
  32    name VARCHAR(255) NOT NULL,
  33    planStatus VARCHAR(32) NOT NULL COLLATE utf8_bin,
  34    dateCreated INT UNSIGNED NOT NULL,
  35    dateModified INT UNSIGNED NOT NULL,
  36    UNIQUE KEY `key_phid` (phid),
  37    KEY `key_status` (planStatus)
  38  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
  39  
  40  CREATE TABLE {$NAMESPACE}_harbormaster.harbormaster_buildplantransaction (
  41    id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
  42    phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
  43    authorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
  44    objectPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
  45    viewPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
  46    editPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
  47    commentPHID VARCHAR(64) COLLATE utf8_bin,
  48    commentVersion INT UNSIGNED NOT NULL,
  49    transactionType VARCHAR(32) NOT NULL COLLATE utf8_bin,
  50    oldValue LONGTEXT NOT NULL COLLATE utf8_bin,
  51    newValue LONGTEXT NOT NULL COLLATE utf8_bin,
  52    contentSource LONGTEXT NOT NULL COLLATE utf8_bin,
  53    metadata LONGTEXT NOT NULL COLLATE utf8_bin,
  54    dateCreated INT UNSIGNED NOT NULL,
  55    dateModified INT UNSIGNED NOT NULL,
  56  
  57    UNIQUE KEY `key_phid` (phid),
  58    KEY `key_object` (objectPHID)
  59  
  60  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
  61  
  62  CREATE TABLE {$NAMESPACE}_harbormaster.harbormaster_build (
  63    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
  64    phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
  65    buildablePHID varchar(64) NOT NULL COLLATE utf8_bin,
  66    buildPlanPHID varchar(64) NOT NULL COLLATE utf8_bin,
  67    buildStatus VARCHAR(32) NOT NULL COLLATE utf8_bin,
  68    dateCreated INT UNSIGNED NOT NULL,
  69    dateModified INT UNSIGNED NOT NULL,
  70    UNIQUE KEY `key_phid` (phid),
  71    KEY `key_buildable` (buildablePHID),
  72    KEY `key_plan` (buildPlanPHID),
  73    KEY `key_status` (buildStatus)
  74  ) ENGINE=InnoDB, COLLATE utf8_general_ci;