[Summary view] [Print] [Text view]

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