[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_diviner.diviner_livebook (
   2    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
   3    phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
   4    name VARCHAR(64) NOT NULL COLLATE utf8_bin,
   5    viewPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
   6    dateCreated INT UNSIGNED NOT NULL,
   7    dateModified INT UNSIGNED NOT NULL,
   8    UNIQUE KEY (name),
   9    UNIQUE KEY (phid)
  10  ) ENGINE=InnoDB, DEFAULT CHARSET = utf8;
  11  
  12  
  13  CREATE TABLE {$NAMESPACE}_diviner.diviner_livesymbol (
  14    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
  15    phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
  16    bookPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
  17    context VARCHAR(255) COLLATE utf8_bin,
  18    type VARCHAR (32) NOT NULL COLLATE utf8_bin,
  19    name VARCHAR (255) NOT NULL COLLATE utf8_bin,
  20    atomIndex INT UNSIGNED NOT NULL,
  21    identityHash VARCHAR(12) NOT NULL COLLATE utf8_bin,
  22    graphHash VARCHAR(33) COLLATE utf8_bin,
  23    KEY (bookPHID, type, name(64), context(64), atomIndex),
  24    KEY (name),
  25    UNIQUE KEY (graphHash),
  26    UNIQUE KEY (identityHash),
  27    UNIQUE KEY (phid)
  28  ) ENGINE=InnoDB, DEFAULT CHARSET = utf8;
  29  
  30  CREATE TABLE {$NAMESPACE}_diviner.diviner_liveatom (
  31    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
  32    symbolPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
  33    content LONGTEXT NOT NULL COLLATE utf8_bin,
  34    atomData LONGTEXT NOT NULL COLLATE utf8_bin,
  35    UNIQUE KEY (symbolPHID)
  36  ) ENGINE=InnoDB, DEFAULT CHARSET = utf8;