20141007.phortunepayment.sql
6fe2377cc2c5master

20141007.phortunepayment.sql
View Options

			TRUNCATE TABLE {$NAMESPACE}_phortune.phortune_paymentmethod;

			ALTER TABLE {$NAMESPACE}_phortune.phortune_paymentmethod
			DROP providerType;

			ALTER TABLE {$NAMESPACE}_phortune.phortune_paymentmethod
			DROP providerDomain;

			ALTER TABLE {$NAMESPACE}_phortune.phortune_paymentmethod
			ADD merchantPHID VARBINARY(64) NOT NULL;

			ALTER TABLE {$NAMESPACE}_phortune.phortune_paymentmethod
			ADD providerPHID VARBINARY(64) NOT NULL;

			ALTER TABLE {$NAMESPACE}_phortune.phortune_paymentmethod
			ADD KEY `key_merchant` (merchantPHID, accountPHID);