[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_phortune.phortune_product (
   2    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
   3    phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
   4    productName VARCHAR(255) NOT NULL,
   5    productType VARCHAR(64) NOT NULL COLLATE utf8_bin,
   6    status VARCHAR(64) NOT NULL COLLATE utf8_bin,
   7    priceInCents BIGINT NOT NULL,
   8    billingIntervalInMonths INT UNSIGNED,
   9    trialPeriodInDays INT UNSIGNED,
  10    metadata LONGTEXT NOT NULL COLLATE utf8_bin,
  11    dateCreated INT UNSIGNED NOT NULL,
  12    dateModified INT UNSIGNED NOT NULL,
  13    UNIQUE KEY `key_phid` (phid),
  14    KEY `key_status` (status)
  15  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  16  
  17  CREATE TABLE {$NAMESPACE}_phortune.phortune_producttransaction (
  18    id INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
  19    phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
  20    authorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
  21    objectPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
  22    viewPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
  23    editPolicy VARCHAR(64) NOT NULL COLLATE utf8_bin,
  24    commentPHID VARCHAR(64) COLLATE utf8_bin,
  25    commentVersion INT UNSIGNED NOT NULL,
  26    transactionType VARCHAR(32) NOT NULL COLLATE utf8_bin,
  27    oldValue LONGTEXT NOT NULL COLLATE utf8_bin,
  28    newValue LONGTEXT NOT NULL COLLATE utf8_bin,
  29    contentSource LONGTEXT NOT NULL COLLATE utf8_bin,
  30    metadata LONGTEXT NOT NULL COLLATE utf8_bin,
  31    dateCreated INT UNSIGNED NOT NULL,
  32    dateModified INT UNSIGNED NOT NULL,
  33    UNIQUE KEY `key_phid` (phid),
  34    KEY `key_object` (objectPHID)
  35  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;