20130423.phortunepaymentrevised.sql
No OneTemporary
Actions

Size

627 B

Referenced Files

None

Subscribers

None

20130423.phortunepaymentrevised.sql
View Options

	TRUNCATE TABLE {$NAMESPACE}_phortune.phortune_paymentmethod;

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

	ALTER TABLE {$NAMESPACE}_phortune.phortune_paymentmethod
	ADD expires VARCHAR(16) NOT NULL;

	ALTER TABLE {$NAMESPACE}_phortune.phortune_paymentmethod
	ADD providerType VARCHAR(16) NOT NULL;

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

	ALTER TABLE {$NAMESPACE}_phortune.phortune_paymentmethod
	ADD lastFourDigits VARCHAR(16) NOT NULL;

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