[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_phortune.phortune_paymentproviderconfig (
   2    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
   3    phid VARCHAR(64) NOT NULL COLLATE utf8_bin,
   4    merchantPHID VARCHAR(64) NOT NULL COLLATE utf8_bin,
   5    providerClassKey BINARY(12) NOT NULL,
   6    providerClass VARCHAR(128) NOT NULL COLLATE utf8_bin,
   7    metadata LONGTEXT NOT NULL COLLATE utf8_bin,
   8    dateCreated INT UNSIGNED NOT NULL,
   9    dateModified INT UNSIGNED NOT NULL,
  10    UNIQUE KEY `key_phid` (phid),
  11    UNIQUE KEY `key_merchant` (merchantPHID, providerClassKey)
  12  ) ENGINE=InnoDB, COLLATE=utf8_bin;