[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_conpherence.conpherence_thread (
   2    id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
   3    phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
   4    title VARCHAR(255),
   5    imagePHID VARCHAR(64) COLLATE utf8_bin,
   6    mailKey VARCHAR(20) NOT NULL COLLATE utf8_bin,
   7    dateCreated INT UNSIGNED NOT NULL,
   8    dateModified INT UNSIGNED NOT NULL,
   9    UNIQUE KEY(phid)
  10  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
  11  
  12  CREATE TABLE {$NAMESPACE}_conpherence.conpherence_participant (
  13    id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
  14    participantPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
  15    conpherencePHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
  16    participationStatus INT UNSIGNED NOT NULL DEFAULT 0,
  17    dateTouched INT UNSIGNED NOT NULL,
  18    behindTransactionPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
  19    dateCreated INT UNSIGNED NOT NULL,
  20    dateModified INT UNSIGNED NOT NULL,
  21    UNIQUE KEY(conpherencePHID, participantPHID),
  22    KEY(participantPHID, participationStatus, dateTouched)
  23  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
  24  
  25  CREATE TABLE {$NAMESPACE}_conpherence.edge (
  26    src varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  27    type varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  28    dst varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  29    dateCreated int(10) unsigned NOT NULL,
  30    seq int(10) unsigned NOT NULL,
  31    dataID int(10) unsigned DEFAULT NULL,
  32    PRIMARY KEY (src, type, dst),
  33    KEY src (src, type, dateCreated, seq)
  34  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  35  
  36  CREATE TABLE {$NAMESPACE}_conpherence.edgedata (
  37    id int(10) unsigned NOT NULL AUTO_INCREMENT,
  38    data longtext CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  39    PRIMARY KEY (id)
  40  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  41  
  42  CREATE TABLE {$NAMESPACE}_conpherence.conpherence_transaction (
  43    id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
  44    phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
  45    authorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
  46    objectPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
  47    viewPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
  48    editPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
  49    commentPHID VARCHAR(64) COLLATE utf8_bin,
  50    commentVersion INT UNSIGNED NOT NULL,
  51    transactionType VARCHAR(32) NOT NULL COLLATE utf8_bin,
  52    oldValue LONGTEXT NOT NULL COLLATE utf8_bin,
  53    newValue LONGTEXT NOT NULL COLLATE utf8_bin,
  54    contentSource LONGTEXT NOT NULL COLLATE utf8_bin,
  55    dateCreated INT UNSIGNED NOT NULL,
  56    dateModified INT UNSIGNED NOT NULL,
  57    UNIQUE KEY `key_phid` (phid),
  58    KEY `key_object` (objectPHID)
  59  ) ENGINE=InnoDB, COLLATE utf8_general_ci;
  60  
  61  CREATE TABLE {$NAMESPACE}_conpherence.conpherence_transaction_comment (
  62    id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
  63    phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
  64    transactionPHID VARCHAR(64) COLLATE utf8_bin,
  65    authorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
  66    viewPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
  67    editPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
  68    commentVersion INT UNSIGNED NOT NULL,
  69    content LONGTEXT NOT NULL COLLATE utf8_bin,
  70    contentSource LONGTEXT NOT NULL COLLATE utf8_bin,
  71    isDeleted BOOL NOT NULL,
  72    dateCreated INT UNSIGNED NOT NULL,
  73    dateModified INT UNSIGNED NOT NULL,
  74  
  75    conpherencePHID VARCHAR(64) COLLATE utf8_bin,
  76  
  77    UNIQUE KEY `key_phid` (phid),
  78    UNIQUE KEY `key_version` (transactionPHID, commentVersion),
  79    UNIQUE KEY `key_draft` (authorPHID, conpherencePHID, transactionPHID)
  80  
  81  ) ENGINE=InnoDB, COLLATE utf8_general_ci;