resources/sql/autopatches/20141017.almanac.binding.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 / 20141017.almanac.binding.sql

at recaptime-dev/main 14 lines 561 B view raw

wrap content

epriestley Add AlmanacBinding, to bind a service to an interface 11y ago

d5b70e2c

 1CREATE TABLE {$NAMESPACE}_almanac.almanac_binding (
 2  id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
 3  phid VARBINARY(64) NOT NULL,
 4  servicePHID VARBINARY(64) NOT NULL,
 5  devicePHID VARBINARY(64) NOT NULL,
 6  interfacePHID VARBINARY(64) NOT NULL,
 7  mailKey BINARY(20) NOT NULL,
 8  dateCreated INT UNSIGNED NOT NULL,
 9  dateModified INT UNSIGNED NOT NULL,
10  UNIQUE KEY `key_phid` (phid),
11  UNIQUE KEY `key_service` (servicePHID, interfacePHID),
12  KEY `key_device` (devicePHID),
13  KEY `key_interface` (interfacePHID)
14) ENGINE=InnoDB, COLLATE utf8_general_ci;