[Summary view] [Print] [Text view]

   1  TRUNCATE TABLE {$NAMESPACE}_phortune.phortune_paymentmethod;
   2  
   3  ALTER TABLE {$NAMESPACE}_phortune.phortune_paymentmethod
   4    DROP providerType;
   5  
   6  ALTER TABLE {$NAMESPACE}_phortune.phortune_paymentmethod
   7    DROP providerDomain;
   8  
   9  ALTER TABLE {$NAMESPACE}_phortune.phortune_paymentmethod
  10    ADD merchantPHID VARBINARY(64) NOT NULL;
  11  
  12  ALTER TABLE {$NAMESPACE}_phortune.phortune_paymentmethod
  13    ADD providerPHID VARBINARY(64) NOT NULL;
  14  
  15  ALTER TABLE {$NAMESPACE}_phortune.phortune_paymentmethod
  16    ADD KEY `key_merchant` (merchantPHID, accountPHID);