[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_phame.phame_blog (
   2    `id` INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
   3    `phid` VARCHAR(64) NOT NULL COLLATE utf8_bin,
   4    `name` VARCHAR(64) NOT NULL COLLATE utf8_bin,
   5    `description` LONGTEXT NOT NULL COLLATE utf8_bin,
   6    `configData` LONGTEXT NOT NULL COLLATE utf8_bin,
   7    `creatorPHID` VARCHAR(64) NOT NULL COLLATE utf8_bin,
   8    `dateCreated` INT UNSIGNED NOT NULL,
   9    `dateModified` INT UNSIGNED NOT NULL,
  10    UNIQUE KEY (`phid`)
  11  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
  12  
  13  CREATE TABLE {$NAMESPACE}_phame.edge (
  14    src VARCHAR(64) NOT NULL COLLATE utf8_bin,
  15    type VARCHAR(64) NOT NULL COLLATE utf8_bin,
  16    dst VARCHAR(64) NOT NULL COLLATE utf8_bin,
  17    dateCreated INT UNSIGNED NOT NULL,
  18    seq INT UNSIGNED NOT NULL,
  19    dataID INT UNSIGNED,
  20    PRIMARY KEY (src, type, dst),
  21    KEY (src, type, dateCreated, seq)
  22  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
  23  
  24  CREATE TABLE {$NAMESPACE}_phame.edgedata (
  25    id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
  26    data LONGTEXT NOT NULL COLLATE utf8_bin
  27  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
  28  
  29  ALTER TABLE {$NAMESPACE}_phame.phame_post
  30    ADD KEY `instancePosts` (`visibility`, `datePublished`, `id`);