ALTER TABLE  `qs_CartItem` ADD  `applyShipping` ENUM(  'y',  'n' ) NOT NULL DEFAULT  'y' AFTER  `applyTax`;

ALTER TABLE  `qs_Transaction` CHANGE  `shippingFirstName`  `shippingFirstName` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE  `qs_Transaction` CHANGE  `shippingLastName`  `shippingLastName` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE  `qs_Transaction` CHANGE  `shippingAddress`  `shippingAddress` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE  `qs_Transaction` CHANGE  `shippingCity`  `shippingCity` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE  `qs_Transaction` CHANGE  `shippingState`  `shippingState` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE  `qs_Transaction` CHANGE  `shippingZip`  `shippingZip` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE  `qs_Transaction` CHANGE  `shippingAddressType`  `shippingAddressType` ENUM(  'residential',  'commercial' ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT  'residential';
ALTER TABLE  `qs_Transaction` CHANGE  `shippingName`  `shippingName` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE  `qs_Transaction` CHANGE  `shippingServiceCode`  `shippingServiceCode` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
ALTER TABLE  `qs_Transaction` CHANGE  `shippingServiceCodeTitle`  `shippingServiceCodeTitle` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;