[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_differential.differential_auxiliaryfield (
   2    id INT UNSIGNED NOT NULL auto_increment PRIMARY KEY,
   3    revisionPHID varchar(64) BINARY NOT NULL,
   4    name VARCHAR(32) BINARY NOT NULL,
   5    value LONGBLOB NOT NULL,
   6    UNIQUE KEY (revisionPHID, name),
   7    KEY (name, value(64)),
   8    dateCreated INT UNSIGNED NOT NULL,
   9    dateModified INT UNSIGNED NOT NULL
  10  ) ENGINE = InnoDB;