resources/sql/patches/070.differentialaux.sql at recaptime-dev/main

@recaptime-dev's working patches + fork for Phorge, a community fork of Phabricator. (Upstream dev and stable branches are at upstream/main and upstream/stable respectively.) hq.recaptime.dev/wiki/Phorge

phorge phabricator

fork atom

phorge / resources / sql / patches / 070.differentialaux.sql

at recaptime-dev/main 10 lines 384 B view raw

wrap content

epriestley SQL Patch Management: SQL Changes 14y ago

68b597ff

 1CREATE 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;