[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_phortune.phortune_charge (
   2    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
   3    phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
   4    accountPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
   5    authorPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
   6    cartPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
   7    paymentMethodPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
   8    amountInCents INT NOT NULL,
   9    status VARCHAR(32) NOT NULL COLLATE utf8_bin,
  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_cart` (cartPHID),
  15    KEY `key_account` (accountPHID)
  16  ) ENGINE=InnoDB, COLLATE utf8_general_ci;