20141007.phortunepayment.sql
No OneTemporary
Actions

Size

535 B

Referenced Files

None

Subscribers

None

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);