1 TRUNCATE {$NAMESPACE}_phortune.phortune_purchase;
3 ALTER TABLE {$NAMESPACE}_phortune.phortune_purchase
4 DROP totalPriceInCents;
6 ALTER TABLE {$NAMESPACE}_phortune.phortune_purchase
7 CHANGE basePriceInCents basePriceAsCurrency VARCHAR(64)
8 NOT NULL collate utf8_bin;