Skip to content

Instantly share code, notes, and snippets.

@titanjer
Created June 26, 2013 04:35
Show Gist options
  • Save titanjer/5864812 to your computer and use it in GitHub Desktop.
Save titanjer/5864812 to your computer and use it in GitHub Desktop.
add NO_SALE_PRICE delete SCRAPY_ID change SHIPMENT_COST to float
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