20130423.phortunepaymentrevised.sql
7a5f62282017master

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;