resources/sql/autopatches/20140218.differentialdraft.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 / autopatches / 20140218.differentialdraft.sql

at recaptime-dev/main 9 lines 446 B view raw

wrap content

Bob Trahan Differential - add DifferentialDraft to track whether revisions have draft feedback or not 12y ago

dcd7a316

1CREATE TABLE {$NAMESPACE}_differential.differential_draft(
2  id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
3  objectPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
4  authorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
5  draftKey VARCHAR(64) NOT NULL COLLATE utf8_bin,
6  dateCreated INT UNSIGNED NOT NULL,
7  dateModified INT UNSIGNED NOT NULL,
8  UNIQUE KEY `key_unique` (objectPHID, authorPHID, draftKey)
9) ENGINE=InnoDB, COLLATE utf8_general_ci;