[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_harbormaster.harbormaster_object (
   2    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
   3    phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
   4    name VARCHAR(255) COLLATE utf8_general_ci,
   5    dateCreated INT UNSIGNED NOT NULL,
   6    dateModified INT UNSIGNED NOT NULL
   7  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
   8  
   9  CREATE TABLE {$NAMESPACE}_harbormaster.edge (
  10    src VARCHAR(64) NOT NULL COLLATE utf8_bin,
  11    type VARCHAR(64) NOT NULL COLLATE utf8_bin,
  12    dst VARCHAR(64) NOT NULL COLLATE utf8_bin,
  13    dateCreated INT UNSIGNED NOT NULL,
  14    seq INT UNSIGNED NOT NULL,
  15    dataID INT UNSIGNED,
  16    PRIMARY KEY (src, type, dst),
  17    KEY (src, type, dateCreated, seq)
  18  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
  19  
  20  CREATE TABLE {$NAMESPACE}_harbormaster.edgedata (
  21    id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
  22    data LONGTEXT NOT NULL COLLATE utf8_bin
  23  ) ENGINE=InnoDB, COLLATE utf8_general_ci;