Created
June 26, 2013 04:35
-
-
Save titanjer/5864812 to your computer and use it in GitHub Desktop.
add NO_SALE_PRICE
delete SCRAPY_ID
change SHIPMENT_COST to float
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
ALTER TABLE cpi_product_log ADD NO_SALE_PRICE smallint(5) unsigned AFTER SALE_PRICE; | |
UPDATE cpi_product_log SET NO_SALE_PRICE = 0; | |
ALTER TABLE cpi_product_log DROP SCRAPY_ID; | |
ALTER TABLE cpi_product_log ADD SHIPMENT_COST_T double AFTER SHIPMENT_COST; | |
UPDATE cpi_product_log SET SHIPMENT_COST_T=CAST(SHIPMENT_COST, DOUBLE) | |
ALTER TABLE cpi_product_log DROP SHIPMENT_COST; | |
ALTER TABLE cpi_product_log change SHIPMENT_COST_T SHIPMENT_COST double; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment