[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_differential.differential_difftransaction (
   2    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
   3    phid VARBINARY(64) NOT NULL,
   4    authorPHID VARBINARY(64) NOT NULL,
   5    objectPHID VARBINARY(64) NOT NULL,
   6    viewPolicy VARBINARY(64) NOT NULL,
   7    editPolicy VARBINARY(64) NOT NULL,
   8    commentPHID VARBINARY(64),
   9    commentVersion INT UNSIGNED NOT NULL,
  10    transactionType VARCHAR(32) COLLATE {$COLLATE_TEXT} NOT NULL,
  11    oldValue LONGTEXT COLLATE {$COLLATE_TEXT} NOT NULL,
  12    newValue LONGTEXT COLLATE {$COLLATE_TEXT} NOT NULL,
  13    contentSource LONGTEXT COLLATE {$COLLATE_TEXT} NOT NULL,
  14    metadata LONGTEXT COLLATE {$COLLATE_TEXT} NOT NULL,
  15    dateCreated INT UNSIGNED NOT NULL,
  16    dateModified INT UNSIGNED NOT NULL,
  17    UNIQUE KEY `key_phid` (`phid`),
  18    KEY `key_object` (`objectPHID`)
  19  ) ENGINE=InnoDB, COLLATE {$COLLATE_TEXT};