[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_differential.differential_hunk_modern (
   2    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
   3    changesetID INT UNSIGNED NOT NULL,
   4    oldOffset INT UNSIGNED NOT NULL,
   5    oldLen INT UNSIGNED NOT NULL,
   6    newOffset INT UNSIGNED NOT NULL,
   7    newLen INT UNSIGNED NOT NULL,
   8    dataType CHAR(4) NOT NULL COLLATE latin1_bin,
   9    dataEncoding VARCHAR(16) COLLATE latin1_bin,
  10    dataFormat CHAR(4) NOT NULL COLLATE latin1_bin,
  11    data LONGBLOB NOT NULL,
  12    dateCreated INT UNSIGNED NOT NULL,
  13    dateModified INT UNSIGNED NOT NULL,
  14  
  15    KEY `key_changeset` (changesetID),
  16    KEY `key_created` (dateCreated)
  17  
  18  ) ENGINE=InnoDB, COLLATE utf8_general_ci;