[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_phortune.phortune_account (
   2    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
   3    phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
   4    name VARCHAR(255) NOT NULL,
   5    balanceInCents BIGINT NOT NULL,
   6    dateCreated INT UNSIGNED NOT NULL,
   7    dateModified INT UNSIGNED NOT NULL,
   8    UNIQUE KEY `key_phid` (phid)
   9  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  10  
  11  CREATE TABLE {$NAMESPACE}_phortune.phortune_accounttransaction (
  12    id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
  13    phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
  14    authorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
  15    objectPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
  16    viewPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
  17    editPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
  18    commentPHID VARCHAR(64) COLLATE utf8_bin,
  19    commentVersion INT UNSIGNED NOT NULL,
  20    transactionType VARCHAR(32) NOT NULL COLLATE utf8_bin,
  21    oldValue LONGTEXT NOT NULL COLLATE utf8_bin,
  22    newValue LONGTEXT NOT NULL COLLATE utf8_bin,
  23    contentSource LONGTEXT NOT NULL COLLATE utf8_bin,
  24    metadata LONGTEXT NOT NULL COLLATE utf8_bin,
  25    dateCreated INT UNSIGNED NOT NULL,
  26    dateModified INT UNSIGNED NOT NULL,
  27    UNIQUE KEY `key_phid` (phid),
  28    KEY `key_object` (objectPHID)
  29  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  30  
  31  CREATE TABLE {$NAMESPACE}_phortune.edge (
  32    src VARCHAR(64) NOT NULL COLLATE utf8_bin,
  33    type INT UNSIGNED NOT NULL COLLATE utf8_bin,
  34    dst VARCHAR(64) NOT NULL COLLATE utf8_bin,
  35    dateCreated INT UNSIGNED NOT NULL,
  36    seq INT UNSIGNED NOT NULL,
  37    dataID INT UNSIGNED,
  38    PRIMARY KEY (src, type, dst),
  39    KEY (src, type, dateCreated, seq)
  40  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  41  
  42  CREATE TABLE {$NAMESPACE}_phortune.edgedata (
  43    id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
  44    data LONGTEXT NOT NULL COLLATE utf8_bin
  45  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;