[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_releeph.`releeph_project` (
   2    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   3    `dateCreated` int(10) unsigned NOT NULL,
   4    `dateModified` int(10) unsigned NOT NULL,
   5    `phid` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
   6    `name` varchar(255) NOT NULL,
   7    `trunkBranch` varchar(255) NOT NULL,
   8    `repositoryID` int(10) unsigned NOT NULL,
   9    `repositoryPHID` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  10    `arcanistProjectID` int(10) unsigned NOT NULL,
  11    `createdByUserPHID` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  12    `isActive` tinyint(1) NOT NULL DEFAULT '1',
  13    `projectID` int(10) unsigned DEFAULT NULL,
  14    `details` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  15    PRIMARY KEY (`id`),
  16    UNIQUE KEY `projectName` (`name`)
  17  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  18  
  19  CREATE TABLE {$NAMESPACE}_releeph.`releeph_branch` (
  20    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  21    `dateCreated` int(10) unsigned NOT NULL,
  22    `dateModified` int(10) unsigned NOT NULL,
  23    `basename` varchar(64) NOT NULL,
  24    `releephProjectID` int(10) unsigned NOT NULL,
  25    `createdByUserPHID` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  26    `cutPointCommitIdentifier`
  27      varchar(40) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  28    `cutPointCommitPHID`
  29      varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  30    `isActive` tinyint(1) NOT NULL DEFAULT '1',
  31    `symbolicName` varchar(64) DEFAULT NULL,
  32    `details` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  33    `phid` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  34    `name` varchar(128) NOT NULL,
  35    PRIMARY KEY (`id`),
  36    UNIQUE KEY `releephProjectID_2` (`releephProjectID`,`basename`),
  37    UNIQUE KEY `releephProjectID_name` (`releephProjectID`,`name`),
  38    UNIQUE KEY `releephProjectID` (`releephProjectID`,`symbolicName`)
  39  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  40  
  41  CREATE TABLE {$NAMESPACE}_releeph.`releeph_request` (
  42    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  43    `dateCreated` int(10) unsigned NOT NULL,
  44    `dateModified` int(10) unsigned NOT NULL,
  45    `phid` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  46    `branchID` int(10) unsigned NOT NULL,
  47    `summary` longtext CHARACTER SET utf8 COLLATE utf8_bin,
  48    `requestUserPHID` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  49    `requestCommitIdentifier`
  50      varchar(40) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  51    `requestCommitPHID`
  52      varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  53    `requestCommitOrdinal` int(10) unsigned NOT NULL,
  54    `commitIdentifier`
  55      varchar(40) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  56    `committedByUserPHID`
  57      varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  58    `commitPHID` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  59    `status` tinyint(4) DEFAULT NULL,
  60    `pickStatus` tinyint(4) DEFAULT NULL,
  61    `details` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  62    `userIntents` longtext CHARACTER SET utf8 COLLATE utf8_bin,
  63    `inBranch` tinyint(1) NOT NULL DEFAULT '0',
  64    PRIMARY KEY (`id`),
  65    UNIQUE KEY `phid` (`phid`),
  66    UNIQUE KEY `requestIdentifierBranch` (`requestCommitIdentifier`,`branchID`),
  67    KEY `branchID` (`branchID`,`requestCommitOrdinal`)
  68  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  69  
  70  CREATE TABLE {$NAMESPACE}_releeph.`releeph_requestevent` (
  71    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  72    `dateCreated` int(10) unsigned NOT NULL,
  73    `dateModified` int(10) unsigned NOT NULL,
  74    `releephRequestID` int(10) unsigned NOT NULL,
  75    `actorPHID` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  76    `details` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  77    `type` varchar(32) NOT NULL,
  78    PRIMARY KEY (`id`)
  79  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  80  
  81  CREATE TABLE {$NAMESPACE}_releeph.`releeph_event` (
  82    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  83    `dateCreated` int(10) unsigned NOT NULL,
  84    `dateModified` int(10) unsigned NOT NULL,
  85    `releephProjectID` int(10) unsigned NOT NULL,
  86    `releephBranchID` int(10) unsigned DEFAULT NULL,
  87    `type` varchar(32) NOT NULL,
  88    `epoch` int(10) unsigned DEFAULT NULL,
  89    `actorPHID` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  90    `details` longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  91    PRIMARY KEY (`id`)
  92  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;