[Summary view] [Print] [Text view]

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