orders-activity-modifications

ALTER TABLE `orders_activity` CHANGE `totalAdjustments` `pc_total` FLOAT;
ALTER TABLE `orders_activity` CHANGE `totalAdjustments_transactionFee` `pc_total_transaction_fee` FLOAT  NULL;
ALTER TABLE `orders_activity` CHANGE `totalAdjustments_costOfItems` `pc_total_items` FLOAT  NOT NULL;
ALTER TABLE `orders_activity` CHANGE `totalAdjustments_fulfillmentFee` `pc_total_fulfillment` FLOAT  NULL;
ALTER TABLE `orders_activity` CHANGE `totalAdjustments_miscTotal` `pc_total_misc` FLOAT  NULL;
ALTER TABLE `orders_activity` CHANGE `totalAdjustments_miscDetails` `pc_misc_with_description` TEXT  NULL;

ALTER TABLE `orders_activity` MODIFY COLUMN `pc_total` FLOAT DEFAULT NULL AFTER `transactionId`;
ALTER TABLE `orders_activity` MODIFY COLUMN `pc_total_transaction_fee` FLOAT DEFAULT NULL AFTER `pc_total`;
ALTER TABLE `orders_activity` MODIFY COLUMN `pc_total_items` FLOAT DEFAULT NULL AFTER `pc_total_transaction_fee`;
ALTER TABLE `orders_activity` MODIFY COLUMN `pc_total_fulfillment` FLOAT DEFAULT NULL AFTER `pc_total_items`;
ALTER TABLE `orders_activity` MODIFY COLUMN `pc_total_misc` FLOAT DEFAULT NULL AFTER `pc_total_fulfillment`;

ALTER TABLE `orders_activity` ADD `modified` INT  NULL  DEFAULT NULL  AFTER `id`;
ALTER TABLE `orders_activity` ADD `pc_transaction_amount` FLOAT  NULL  DEFAULT NULL  AFTER `pc_total_misc`;
ALTER TABLE `orders_activity` ADD `pc_transaction_type` ENUM('refund','void','sale','capture','credit')  NULL  DEFAULT NULL  AFTER `pc_transaction_amount`;
ALTER TABLE `orders_activity` ADD `pc_transaction_payment_method` ENUM('visa','mastercard','discover','amex','paypal','paypal_int','google')  NULL  DEFAULT NULL  AFTER `pc_transaction_type`;
ALTER TABLE `orders_activity` ADD `pc_items` TEXT  NULL  AFTER `pc_transaction_payment_method`;
ALTER TABLE `orders_activity` ADD `pc_fulfillment_new_shipment` FLOAT  NULL  DEFAULT NULL  AFTER `pc_items`;
ALTER TABLE `orders_activity` ADD `pc_fulfillment_per_sku` FLOAT  NULL  DEFAULT NULL  AFTER `pc_fulfillment_new_shipment`;
ALTER TABLE `orders_activity` ADD `pc_fulfillment_freebie` FLOAT  NULL  DEFAULT NULL  AFTER `pc_fulfillment_per_sku`;
ALTER TABLE `orders_activity` ADD `pc_fulfillment_international` TEXT  NULL  AFTER `pc_fulfillment_freebie`;
ALTER TABLE `orders_activity` ADD `pc_fulfillment_domestic_first_class` TEXT  NULL  AFTER `pc_fulfillment_international`;
ALTER TABLE `orders_activity` MODIFY COLUMN `pc_misc_with_description` TEXT NOT NULL DEFAULT '' AFTER `pc_fulfillment_international`;
ALTER TABLE `orders_activity` CHANGE `pc_misc_with_description` `pc_misc_with_description` TEXT  NULL;
ALTER TABLE `orders_activity` ADD `pc_misc_calculation` TEXT  NULL  AFTER `pc_misc_with_description`;