[Summary view] [Print] [Text view]

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