Here is the correct mysql coding to use...I figured it out by carefully going through it.

I'm posting the fix with and without the zen_ prefix (my database has the zen prefix and this one is tricky with the prefix)

Hope this helps! =0)

********************REGULAR

ALTER TABLE `customers` ADD `customers_whole` VARCHAR( 4 ) DEFAULT '0' NOT NULL;
ALTER TABLE `products` ADD `products_price_w` VARCHAR( 150 ) DEFAULT '0' AFTER `products_price`;
ALTER TABLE `products_attributes` ADD `options_values_price_w` VARCHAR( 150 ) DEFAULT '0' AFTER `options_values_price`;
ALTER TABLE `products_discount_quantity` ADD `discount_price_w` VARCHAR( 150 ) DEFAULT '0' AFTER `discount_price`;
ALTER TABLE `customers` ADD `customers_wholesale` VARCHAR( 4 ) DEFAULT '0' NOT NULL AFTER `customers_whole`;


*********************WITH THE ZEN_ PREFIX

ALTER TABLE `zen_customers` ADD `customers_whole` VARCHAR( 4 ) DEFAULT '0' NOT NULL;
ALTER TABLE `zen_products` ADD `products_price_w` VARCHAR( 150 ) DEFAULT '0' AFTER `products_price`;
ALTER TABLE `zen_products_attributes` ADD `options_values_price_w` VARCHAR( 150 ) DEFAULT '0' AFTER `options_values_price`;
ALTER TABLE `zen_products_discount_quantity` ADD `discount_price_w` VARCHAR( 150 ) DEFAULT '0' AFTER `discount_price`;
ALTER TABLE `zen_customers` ADD `customers_wholesale` VARCHAR( 4 ) DEFAULT '0' NOT NULL AFTER `customers_whole`;