[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_almanac.almanac_devicetransaction (
   2    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
   3    phid VARCHAR(64) COLLATE utf8_bin NOT NULL,
   4    authorPHID VARCHAR(64) COLLATE utf8_bin NOT NULL,
   5    objectPHID 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    commentPHID VARCHAR(64) COLLATE utf8_bin DEFAULT NULL,
   9    commentVersion INT UNSIGNED NOT NULL,
  10    transactionType VARCHAR(32) COLLATE utf8_bin NOT NULL,
  11    oldValue LONGTEXT COLLATE utf8_bin NOT NULL,
  12    newValue LONGTEXT COLLATE utf8_bin NOT NULL,
  13    contentSource LONGTEXT COLLATE utf8_bin NOT NULL,
  14    metadata LONGTEXT COLLATE utf8_bin 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 utf8_general_ci;