[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_doorkeeper.doorkeeper_externalobject (
   2    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
   3    phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
   4    objectKey CHAR(12) NOT NULL COLLATE utf8_bin,
   5    applicationType VARCHAR(32) NOT NULL COLLATE utf8_bin,
   6    applicationDomain VARCHAR(32) NOT NULL COLLATE utf8_bin,
   7    objectType VARCHAR(32) NOT NULL COLLATE utf8_bin,
   8    objectID VARCHAR(64) NOT NULL COLLATE utf8_bin,
   9    objectURI VARCHAR(128) COLLATE utf8_bin,
  10    importerPHID VARCHAR(64) COLLATE utf8_bin,
  11    properties LONGTEXT NOT NULL COLLATE utf8_bin,
  12    viewPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
  13    dateCreated INT UNSIGNED NOT NULL,
  14    dateModified INT UNSIGNED NOT NULL,
  15    UNIQUE KEY `key_phid` (phid),
  16    UNIQUE KEY `key_object` (objectKey),
  17    KEY `key_full` (applicationType, applicationDomain, objectType, objectID)
  18  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
  19  
  20  CREATE TABLE {$NAMESPACE}_doorkeeper.edge (
  21    src VARCHAR(64) NOT NULL COLLATE utf8_bin,
  22    type INT UNSIGNED NOT NULL COLLATE utf8_bin,
  23    dst VARCHAR(64) NOT NULL COLLATE utf8_bin,
  24    dateCreated INT UNSIGNED NOT NULL,
  25    seq INT UNSIGNED NOT NULL,
  26    dataID INT UNSIGNED,
  27    PRIMARY KEY (src, type, dst),
  28    KEY (src, type, dateCreated, seq)
  29  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
  30  
  31  CREATE TABLE {$NAMESPACE}_doorkeeper.edgedata (
  32    id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
  33    data LONGTEXT NOT NULL COLLATE utf8_bin
  34  ) ENGINE=InnoDB, COLLATE utf8_general_ci;