[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_maniphest.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}_maniphest.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;
  16  
  17  
  18  
  19  CREATE TABLE {$NAMESPACE}_repository.edge (
  20    src VARCHAR(64) NOT NULL COLLATE utf8_bin,
  21    type VARCHAR(64) NOT NULL COLLATE utf8_bin,
  22    dst VARCHAR(64) NOT NULL COLLATE utf8_bin,
  23    dateCreated INT UNSIGNED NOT NULL,
  24    seq INT UNSIGNED NOT NULL,
  25    dataID INT UNSIGNED,
  26    PRIMARY KEY (src, type, dst),
  27    KEY (src, type, dateCreated, seq)
  28  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
  29  
  30  CREATE TABLE {$NAMESPACE}_repository.edgedata (
  31    id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
  32    data LONGTEXT NOT NULL COLLATE utf8_bin
  33  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
  34  
  35  
  36  
  37  CREATE TABLE {$NAMESPACE}_differential.edge (
  38    src VARCHAR(64) NOT NULL COLLATE utf8_bin,
  39    type VARCHAR(64) NOT NULL COLLATE utf8_bin,
  40    dst VARCHAR(64) NOT NULL COLLATE utf8_bin,
  41    dateCreated INT UNSIGNED NOT NULL,
  42    seq INT UNSIGNED NOT NULL,
  43    dataID INT UNSIGNED,
  44    PRIMARY KEY (src, type, dst),
  45    KEY (src, type, dateCreated, seq)
  46  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
  47  
  48  CREATE TABLE {$NAMESPACE}_differential.edgedata (
  49    id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
  50    data LONGTEXT NOT NULL COLLATE utf8_bin
  51  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
  52  
  53  
  54  
  55  CREATE TABLE {$NAMESPACE}_file.edge (
  56    src VARCHAR(64) NOT NULL COLLATE utf8_bin,
  57    type VARCHAR(64) NOT NULL COLLATE utf8_bin,
  58    dst VARCHAR(64) NOT NULL COLLATE utf8_bin,
  59    dateCreated INT UNSIGNED NOT NULL,
  60    seq INT UNSIGNED NOT NULL,
  61    dataID INT UNSIGNED,
  62    PRIMARY KEY (src, type, dst),
  63    KEY (src, type, dateCreated, seq)
  64  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
  65  
  66  CREATE TABLE {$NAMESPACE}_file.edgedata (
  67    id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
  68    data LONGTEXT NOT NULL COLLATE utf8_bin
  69  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
  70  
  71  
  72  
  73  CREATE TABLE {$NAMESPACE}_user.edge (
  74    src VARCHAR(64) NOT NULL COLLATE utf8_bin,
  75    type VARCHAR(64) NOT NULL COLLATE utf8_bin,
  76    dst VARCHAR(64) NOT NULL COLLATE utf8_bin,
  77    dateCreated INT UNSIGNED NOT NULL,
  78    seq INT UNSIGNED NOT NULL,
  79    dataID INT UNSIGNED,
  80    PRIMARY KEY (src, type, dst),
  81    KEY (src, type, dateCreated, seq)
  82  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
  83  
  84  CREATE TABLE {$NAMESPACE}_user.edgedata (
  85    id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
  86    data LONGTEXT NOT NULL COLLATE utf8_bin
  87  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
  88  
  89  
  90  
  91  CREATE TABLE {$NAMESPACE}_project.edge (
  92    src VARCHAR(64) NOT NULL COLLATE utf8_bin,
  93    type VARCHAR(64) NOT NULL COLLATE utf8_bin,
  94    dst VARCHAR(64) NOT NULL COLLATE utf8_bin,
  95    dateCreated INT UNSIGNED NOT NULL,
  96    seq INT UNSIGNED NOT NULL,
  97    dataID INT UNSIGNED,
  98    PRIMARY KEY (src, type, dst),
  99    KEY (src, type, dateCreated, seq)
 100  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
 101  
 102  CREATE TABLE {$NAMESPACE}_project.edgedata (
 103    id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
 104    data LONGTEXT NOT NULL COLLATE utf8_bin
 105  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
 106  
 107  
 108  
 109  CREATE TABLE {$NAMESPACE}_metamta.edge (
 110    src VARCHAR(64) NOT NULL COLLATE utf8_bin,
 111    type VARCHAR(64) NOT NULL COLLATE utf8_bin,
 112    dst VARCHAR(64) NOT NULL COLLATE utf8_bin,
 113    dateCreated INT UNSIGNED NOT NULL,
 114    seq INT UNSIGNED NOT NULL,
 115    dataID INT UNSIGNED,
 116    PRIMARY KEY (src, type, dst),
 117    KEY (src, type, dateCreated, seq)
 118  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
 119  
 120  CREATE TABLE {$NAMESPACE}_metamta.edgedata (
 121    id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
 122    data LONGTEXT NOT NULL COLLATE utf8_bin
 123  ) ENGINE=InnoDB, COLLATE utf8_general_ci;