[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_almanac.edge (
   2    src VARBINARY(64) NOT NULL,
   3    type INT UNSIGNED NOT NULL,
   4    dst VARBINARY(64) NOT NULL,
   5    dateCreated INT UNSIGNED NOT NULL,
   6    seq INT UNSIGNED NOT NULL,
   7    dataID INT UNSIGNED,
   8    PRIMARY KEY (src, type, dst),
   9    KEY `src` (src, type, dateCreated, seq),
  10    UNIQUE KEY `key_dst` (dst, type, src)
  11  ) ENGINE=InnoDB, COLLATE {$COLLATE_TEXT};
  12  
  13  CREATE TABLE {$NAMESPACE}_almanac.edgedata (
  14    id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
  15    data LONGTEXT NOT NULL COLLATE {$COLLATE_TEXT}
  16  ) ENGINE=InnoDB, COLLATE {$COLLATE_TEXT};