[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_fund.edge (
   2    src VARCHAR(64) NOT NULL COLLATE utf8_bin,
   3    type VARCHAR(64) NOT NULL COLLATE utf8_bin,
   4    dst VARCHAR(64) NOT NULL COLLATE utf8_bin,
   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, type, dateCreated, seq)
  10  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
  11  
  12  CREATE TABLE {$NAMESPACE}_fund.edgedata (
  13    id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
  14    data LONGTEXT NOT NULL COLLATE utf8_bin
  15  ) ENGINE=InnoDB, COLLATE utf8_general_ci;