[Summary view] [Print] [Text view]

   1  DROP TABLE {$NAMESPACE}_pholio.pholio_transaction;
   2  DROP TABLE {$NAMESPACE}_pholio.pholio_pixelcomment;
   3  
   4  CREATE TABLE {$NAMESPACE}_pholio.pholio_transaction (
   5    id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
   6    phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
   7    authorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
   8    objectPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
   9    viewPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
  10    editPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
  11    commentPHID VARCHAR(64) COLLATE utf8_bin,
  12    commentVersion INT UNSIGNED NOT NULL,
  13    transactionType VARCHAR(32) NOT NULL COLLATE utf8_bin,
  14    oldValue LONGTEXT NOT NULL COLLATE utf8_bin,
  15    newValue LONGTEXT NOT NULL COLLATE utf8_bin,
  16    contentSource LONGTEXT NOT NULL COLLATE utf8_bin,
  17    dateCreated INT UNSIGNED NOT NULL,
  18    dateModified INT UNSIGNED NOT NULL,
  19  
  20    UNIQUE KEY `key_phid` (phid),
  21    KEY `key_object` (objectPHID)
  22  
  23  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
  24  
  25  CREATE TABLE {$NAMESPACE}_pholio.pholio_transaction_comment (
  26    id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
  27    phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
  28    transactionPHID VARCHAR(64) COLLATE utf8_bin,
  29    authorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
  30    viewPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
  31    editPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
  32    commentVersion INT UNSIGNED NOT NULL,
  33    content LONGTEXT NOT NULL COLLATE utf8_bin,
  34    contentSource LONGTEXT NOT NULL COLLATE utf8_bin,
  35    isDeleted BOOL NOT NULL,
  36    dateCreated INT UNSIGNED NOT NULL,
  37    dateModified INT UNSIGNED NOT NULL,
  38  
  39    mockID INT UNSIGNED,
  40    imageID INT UNSIGNED,
  41    x INT UNSIGNED,
  42    y INT UNSIGNED,
  43    width INT UNSIGNED,
  44    height INT UNSIGNED,
  45  
  46    UNIQUE KEY `key_phid` (phid),
  47    UNIQUE KEY `key_version` (transactionPHID, commentVersion),
  48    UNIQUE KEY `key_draft` (authorPHID, mockID, transactionPHID)
  49  
  50  ) ENGINE=InnoDB, COLLATE utf8_general_ci;