[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_repository.repository_pushlog (
   2    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
   3    epoch INT UNSIGNED NOT NULL,
   4    repositoryPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
   5    pusherPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
   6    remoteAddress INT UNSIGNED,
   7    remoteProtocol VARCHAR(32),
   8    transactionKey CHAR(12) NOT NULL COLLATE latin1_bin,
   9    refType VARCHAR(12) NOT NULL COLLATE utf8_bin,
  10    refNameHash VARCHAR(12) COLLATE latin1_bin,
  11    refNameRaw LONGTEXT COLLATE latin1_bin,
  12    refNameEncoding VARCHAR(16) COLLATE utf8_bin,
  13    refOld VARCHAR(40) COLLATE latin1_bin,
  14    refNew VARCHAR(40) NOT NULL COLLATE latin1_bin,
  15    mergeBase VARCHAR(40) COLLATE latin1_bin,
  16    changeFlags INT UNSIGNED NOT NULL,
  17    rejectCode INT UNSIGNED NOT NULL,
  18    rejectDetails VARCHAR(64) COLLATE utf8_bin,
  19  
  20    KEY `key_repository` (repositoryPHID),
  21    KEY `key_ref` (repositoryPHID, refNew),
  22    KEY `key_pusher` (pusherPHID),
  23    KEY `key_name` (repositoryPHID, refNameHash)
  24  
  25  ) ENGINE=InnoDB, COLLATE=utf8_general_ci;