[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_audit.audit_inlinecomment (
   2    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
   3    authorPHID varchar(64) COLLATE utf8_bin NOT NULL,
   4    commitPHID varchar(64) COLLATE utf8_bin NOT NULL,
   5    pathID INT UNSIGNED NOT NULL,
   6    auditCommentID INT UNSIGNED,
   7    isNewFile BOOL NOT NULL,
   8    lineNumber INT UNSIGNED NOT NULL,
   9    lineLength INT UNSIGNED NOT NULL,
  10    content LONGTEXT COLLATE utf8_bin,
  11    cache LONGTEXT COLLATE utf8_bin,
  12    dateCreated INT UNSIGNED NOT NULL,
  13    dateModified INT UNSIGNED NOT NULL,
  14    KEY (commitPHID, pathID),
  15    KEY (authorPHID, commitPHID, auditCommentID)
  16  ) ENGINE=InnoDB, COLLATE utf8_general_ci;