[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_nuance.nuance_item (
   2    id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
   3    phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
   4    ownerPHID VARCHAR(64) COLLATE utf8_bin,
   5    requestorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
   6    sourcePHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
   7    sourceLabel VARCHAR(255),
   8    status INT UNSIGNED NOT NULL,
   9    data longtext NOT NULL COLLATE utf8_bin,
  10    mailKey VARCHAR(20) NOT NULL COLLATE utf8_bin,
  11    dateCreated INT UNSIGNED NOT NULL,
  12    dateModified INT UNSIGNED NOT NULL,
  13    dateNuanced INT UNSIGNED NOT NULL,
  14    UNIQUE KEY `key_phid` (phid),
  15    KEY `key_source` (sourcePHID, status, dateNuanced, id),
  16    KEY `key_owner` (ownerPHID, status, dateNuanced, id),
  17    KEY `key_contacter` (requestorPHID, status, dateNuanced, id)
  18  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
  19  
  20  CREATE TABLE {$NAMESPACE}_nuance.nuance_itemtransaction (
  21    id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
  22    phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
  23    authorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
  24    objectPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
  25    viewPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
  26    editPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
  27    commentPHID VARCHAR(64) COLLATE utf8_bin,
  28    commentVersion INT UNSIGNED NOT NULL,
  29    transactionType VARCHAR(32) NOT NULL COLLATE utf8_bin,
  30    oldValue LONGTEXT NOT NULL COLLATE utf8_bin,
  31    newValue LONGTEXT NOT NULL COLLATE utf8_bin,
  32    contentSource LONGTEXT NOT NULL COLLATE utf8_bin,
  33    metadata LONGTEXT NOT NULL COLLATE utf8_bin,
  34    dateCreated INT UNSIGNED NOT NULL,
  35    dateModified INT UNSIGNED NOT NULL,
  36  
  37    UNIQUE KEY `key_phid` (phid),
  38    KEY `key_object` (objectPHID)
  39  
  40  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
  41  
  42  CREATE TABLE {$NAMESPACE}_nuance.nuance_itemtransaction_comment (
  43    id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
  44    phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
  45    transactionPHID VARCHAR(64) COLLATE utf8_bin,
  46    authorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
  47    viewPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
  48    editPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
  49    commentVersion INT UNSIGNED NOT NULL,
  50    content LONGTEXT NOT NULL COLLATE utf8_bin,
  51    contentSource LONGTEXT NOT NULL COLLATE utf8_bin,
  52    isDeleted BOOL NOT NULL,
  53    dateCreated INT UNSIGNED NOT NULL,
  54    dateModified INT UNSIGNED NOT NULL,
  55  
  56    UNIQUE KEY `key_phid` (phid),
  57    UNIQUE KEY `key_version` (transactionPHID, commentVersion)
  58  
  59  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
  60  
  61  CREATE TABLE {$NAMESPACE}_nuance.nuance_source (
  62    id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
  63    phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
  64    name VARCHAR(255),
  65    type INT UNSIGNED NOT NULL,
  66    data longtext NOT NULL COLLATE utf8_bin,
  67    mailKey VARCHAR(20) NOT NULL COLLATE utf8_bin,
  68    viewPolicy VARCHAR(64) NOT NULL,
  69    editPolicy VARCHAR(64) NOT NULL,
  70    dateCreated INT UNSIGNED NOT NULL,
  71    dateModified INT UNSIGNED NOT NULL,
  72    UNIQUE KEY `key_phid` (phid),
  73    KEY `key_type` (type, dateModified)
  74  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
  75  
  76  CREATE TABLE {$NAMESPACE}_nuance.nuance_sourcetransaction (
  77    id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
  78    phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
  79    authorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
  80    objectPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
  81    viewPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
  82    editPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
  83    commentPHID VARCHAR(64) COLLATE utf8_bin,
  84    commentVersion INT UNSIGNED NOT NULL,
  85    transactionType VARCHAR(32) NOT NULL COLLATE utf8_bin,
  86    oldValue LONGTEXT NOT NULL COLLATE utf8_bin,
  87    newValue LONGTEXT NOT NULL COLLATE utf8_bin,
  88    contentSource LONGTEXT NOT NULL COLLATE utf8_bin,
  89    metadata LONGTEXT NOT NULL COLLATE utf8_bin,
  90    dateCreated INT UNSIGNED NOT NULL,
  91    dateModified INT UNSIGNED NOT NULL,
  92  
  93    UNIQUE KEY `key_phid` (phid),
  94    KEY `key_object` (objectPHID)
  95  
  96  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
  97  
  98  CREATE TABLE {$NAMESPACE}_nuance.nuance_sourcetransaction_comment (
  99    id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
 100    phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
 101    transactionPHID VARCHAR(64) COLLATE utf8_bin,
 102    authorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
 103    viewPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
 104    editPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
 105    commentVersion INT UNSIGNED NOT NULL,
 106    content LONGTEXT NOT NULL COLLATE utf8_bin,
 107    contentSource LONGTEXT NOT NULL COLLATE utf8_bin,
 108    isDeleted BOOL NOT NULL,
 109    dateCreated INT UNSIGNED NOT NULL,
 110    dateModified INT UNSIGNED NOT NULL,
 111  
 112    UNIQUE KEY `key_phid` (phid),
 113    UNIQUE KEY `key_version` (transactionPHID, commentVersion)
 114  
 115  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
 116  
 117  CREATE TABLE {$NAMESPACE}_nuance.nuance_queue (
 118    id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
 119    phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
 120    name VARCHAR(255),
 121    mailKey VARCHAR(20) NOT NULL COLLATE utf8_bin,
 122    viewPolicy VARCHAR(64) NOT NULL,
 123    editPolicy VARCHAR(64) NOT NULL,
 124    dateCreated INT UNSIGNED NOT NULL,
 125    dateModified INT UNSIGNED NOT NULL,
 126    UNIQUE KEY `key_phid` (phid)
 127  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
 128  
 129  CREATE TABLE {$NAMESPACE}_nuance.nuance_queuetransaction (
 130    id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
 131    phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
 132    authorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
 133    objectPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
 134    viewPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
 135    editPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
 136    commentPHID VARCHAR(64) COLLATE utf8_bin,
 137    commentVersion INT UNSIGNED NOT NULL,
 138    transactionType VARCHAR(32) NOT NULL COLLATE utf8_bin,
 139    oldValue LONGTEXT NOT NULL COLLATE utf8_bin,
 140    newValue LONGTEXT NOT NULL COLLATE utf8_bin,
 141    contentSource LONGTEXT NOT NULL COLLATE utf8_bin,
 142    metadata LONGTEXT NOT NULL COLLATE utf8_bin,
 143    dateCreated INT UNSIGNED NOT NULL,
 144    dateModified INT UNSIGNED NOT NULL,
 145  
 146    UNIQUE KEY `key_phid` (phid),
 147    KEY `key_object` (objectPHID)
 148  
 149  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
 150  
 151  CREATE TABLE {$NAMESPACE}_nuance.nuance_queuetransaction_comment (
 152    id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
 153    phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
 154    transactionPHID VARCHAR(64) COLLATE utf8_bin,
 155    authorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
 156    viewPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
 157    editPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
 158    commentVersion INT UNSIGNED NOT NULL,
 159    content LONGTEXT NOT NULL COLLATE utf8_bin,
 160    contentSource LONGTEXT NOT NULL COLLATE utf8_bin,
 161    isDeleted BOOL NOT NULL,
 162    dateCreated INT UNSIGNED NOT NULL,
 163    dateModified INT UNSIGNED NOT NULL,
 164  
 165    UNIQUE KEY `key_phid` (phid),
 166    UNIQUE KEY `key_version` (transactionPHID, commentVersion)
 167  
 168  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
 169  
 170  CREATE TABLE {$NAMESPACE}_nuance.nuance_queueitem (
 171    id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
 172    queuePHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
 173    itemPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
 174    itemStatus INT UNSIGNED NOT NULL,
 175    itemDateNuanced INT UNSIGNED NOT NULL,
 176    dateCreated INT UNSIGNED NOT NULL,
 177    dateModified INT UNSIGNED NOT NULL,
 178    UNIQUE KEY `key_one_per_queue` (itemPHID, queuePHID),
 179    KEY `key_queue` (queuePHID, itemStatus, itemDateNuanced, id)
 180  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
 181  
 182  CREATE TABLE {$NAMESPACE}_nuance.nuance_requestor (
 183    id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
 184    phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
 185    data longtext NOT NULL COLLATE utf8_bin,
 186    dateCreated INT UNSIGNED NOT NULL,
 187    dateModified INT UNSIGNED NOT NULL,
 188    UNIQUE KEY `key_phid` (phid)
 189  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
 190  
 191  CREATE TABLE {$NAMESPACE}_nuance.nuance_requestortransaction (
 192    id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
 193    phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
 194    authorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
 195    objectPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
 196    viewPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
 197    editPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
 198    commentPHID VARCHAR(64) COLLATE utf8_bin,
 199    commentVersion INT UNSIGNED NOT NULL,
 200    transactionType VARCHAR(32) NOT NULL COLLATE utf8_bin,
 201    oldValue LONGTEXT NOT NULL COLLATE utf8_bin,
 202    newValue LONGTEXT NOT NULL COLLATE utf8_bin,
 203    contentSource LONGTEXT NOT NULL COLLATE utf8_bin,
 204    metadata LONGTEXT NOT NULL COLLATE utf8_bin,
 205    dateCreated INT UNSIGNED NOT NULL,
 206    dateModified INT UNSIGNED NOT NULL,
 207  
 208    UNIQUE KEY `key_phid` (phid),
 209    KEY `key_object` (objectPHID)
 210  
 211  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
 212  
 213  CREATE TABLE {$NAMESPACE}_nuance.nuance_requestortransaction_comment (
 214    id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
 215    phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
 216    transactionPHID VARCHAR(64) COLLATE utf8_bin,
 217    authorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
 218    viewPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
 219    editPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
 220    commentVersion INT UNSIGNED NOT NULL,
 221    content LONGTEXT NOT NULL COLLATE utf8_bin,
 222    contentSource LONGTEXT NOT NULL COLLATE utf8_bin,
 223    isDeleted BOOL NOT NULL,
 224    dateCreated INT UNSIGNED NOT NULL,
 225    dateModified INT UNSIGNED NOT NULL,
 226  
 227    UNIQUE KEY `key_phid` (phid),
 228    UNIQUE KEY `key_version` (transactionPHID, commentVersion)
 229  
 230  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
 231  
 232  CREATE TABLE {$NAMESPACE}_nuance.nuance_requestorsource (
 233    id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
 234    requestorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
 235    sourcePHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
 236    sourceKey VARCHAR(128) NOT NULL COLLATE utf8_bin,
 237    data LONGTEXT NOT NULL COLLATE utf8_bin,
 238    dateCreated INT UNSIGNED NOT NULL,
 239    dateModified INT UNSIGNED NOT NULL,
 240    KEY `key_requestor` (requestorPHID, id),
 241    KEY `key_source` (sourcePHID, id),
 242    UNIQUE KEY `key_source_key` (sourcePHID, sourceKey)
 243  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
 244  
 245  CREATE TABLE {$NAMESPACE}_nuance.edge (
 246    src VARCHAR(64) NOT NULL COLLATE utf8_bin,
 247    type VARCHAR(64) NOT NULL COLLATE utf8_bin,
 248    dst VARCHAR(64) NOT NULL COLLATE utf8_bin,
 249    dateCreated INT UNSIGNED NOT NULL,
 250    seq INT UNSIGNED NOT NULL,
 251    dataID INT UNSIGNED,
 252    PRIMARY KEY (src, type, dst),
 253    KEY (src, type, dateCreated, seq)
 254  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
 255  
 256  CREATE TABLE {$NAMESPACE}_nuance.edgedata (
 257    id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
 258    data LONGTEXT NOT NULL COLLATE utf8_bin
 259  ) ENGINE=InnoDB, COLLATE utf8_general_ci;