Skip to content

Instantly share code, notes, and snippets.

@doginthehat
Created July 9, 2014 08:09
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save doginthehat/9a46d8d4bd52539c983d to your computer and use it in GitHub Desktop.
Save doginthehat/9a46d8d4bd52539c983d to your computer and use it in GitHub Desktop.
Increase number of decimals in all Lemonstand V1 currency fields to 4
ALTER TABLE `core_metrics` MODIFY `total_amount` DECIMAL( 15, 4 ) ;
ALTER TABLE `shop_bundle_item_products` MODIFY `price_or_discount` DECIMAL( 15, 4 ) ;
ALTER TABLE `shop_extra_options` MODIFY `price` DECIMAL( 15, 4 ) ;
ALTER TABLE `shop_option_matrix_records` MODIFY `base_price` DECIMAL( 15, 4 ) ;
ALTER TABLE `shop_option_matrix_records` MODIFY `cost` DECIMAL( 15, 4 ) ;
ALTER TABLE `shop_orders` MODIFY `shipping_quote` DECIMAL( 15, 4 ) ;
ALTER TABLE `shop_orders` MODIFY `shipping_tax` DECIMAL( 15, 4 ) ;
ALTER TABLE `shop_orders` MODIFY `goods_tax` DECIMAL( 15, 4 ) ;
ALTER TABLE `shop_orders` MODIFY `total` DECIMAL( 15, 4 ) ;
ALTER TABLE `shop_orders` MODIFY `subtotal` DECIMAL( 15, 4 ) ;
ALTER TABLE `shop_orders` MODIFY `discount` DECIMAL( 15, 4 ) ;
ALTER TABLE `shop_orders` MODIFY `tax_discount` DECIMAL( 15, 4 ) ;
ALTER TABLE `shop_orders` MODIFY `shipping_tax_1` DECIMAL( 15, 4 ) ;
ALTER TABLE `shop_orders` MODIFY `shipping_tax_2` DECIMAL( 15, 4 ) ;
ALTER TABLE `shop_orders` MODIFY `total_cost` DECIMAL( 15, 4 ) ;
ALTER TABLE `shop_order_items` MODIFY `tax_discount_1` DECIMAL( 15, 4 ) ;
ALTER TABLE `shop_order_items` MODIFY `tax_discount_2` DECIMAL( 15, 4 ) ;
ALTER TABLE `shop_order_items` MODIFY `cost` DECIMAL( 15, 4 ) ;
ALTER TABLE `shop_products` MODIFY `price` DECIMAL( 15, 4 ) ;
ALTER TABLE `shop_products` MODIFY `cost` DECIMAL( 15, 4 ) ;
ALTER TABLE `shop_product_price_index` MODIFY `price` DECIMAL( 15, 4 ) ;
ALTER TABLE `shop_product_price_index` MODIFY `min_price` DECIMAL( 15, 4 ) ;
ALTER TABLE `shop_product_price_index` MODIFY `max_price` DECIMAL( 15, 4 ) ;
ALTER TABLE `shop_shipping_options` MODIFY `handling_fee` DECIMAL( 15, 4 ) ;
ALTER TABLE `shop_tier_prices` MODIFY `price` DECIMAL( 15, 4 ) ;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment