[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_audit.audit_transaction_comment (
   2    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
   3    phid VARCHAR(64) COLLATE utf8_bin NOT NULL,
   4    transactionPHID VARCHAR(64) COLLATE utf8_bin,
   5    authorPHID VARCHAR(64) COLLATE utf8_bin NOT NULL,
   6    viewPolicy VARCHAR(64) COLLATE utf8_bin NOT NULL,
   7    editPolicy VARCHAR(64) COLLATE utf8_bin NOT NULL,
   8    commentVersion INT UNSIGNED NOT NULL,
   9    content longtext COLLATE utf8_bin NOT NULL,
  10    contentSource longtext COLLATE utf8_bin NOT NULL,
  11    isDeleted BOOL NOT NULL,
  12    dateCreated INT UNSIGNED NOT NULL,
  13    dateModified INT UNSIGNED NOT NULL,
  14    commitPHID VARCHAR(64) COLLATE utf8_bin,
  15    pathID INT UNSIGNED,
  16    isNewFile BOOL NOT NULL,
  17    lineNumber INT UNSIGNED NOT NULL,
  18    lineLength INT UNSIGNED NOT NULL,
  19    fixedState VARCHAR(12) COLLATE utf8_bin,
  20    hasReplies BOOL NOT NULL,
  21    replyToCommentPHID VARCHAR(64) COLLATE utf8_bin,
  22    legacyCommentID INT UNSIGNED,
  23    UNIQUE KEY `key_phid` (phid),
  24    UNIQUE KEY `key_version` (transactionPHID, commentVersion),
  25    KEY `key_path` (pathID),
  26    KEY `key_draft` (authorPHID, transactionPHID),
  27    KEY `key_commit` (commitPHID),
  28    KEY `key_legacy` (legacyCommentID)
  29  ) ENGINE=InnoDB, COLLATE utf8_general_ci;