Skip to content

Instantly share code, notes, and snippets.

@unlocomqx

unlocomqx/upgrade.sql

Created April 9, 2016 14:27
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 unlocomqx/9ff1f75532813f8514bfa9f34fbe31a7 to your computer and use it in GitHub Desktop.
Save unlocomqx/9ff1f75532813f8514bfa9f34fbe31a7 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
upgrade.sql
ALTER TABLE `ps_cart_product` ADD `id_customization` INT(10) NOT NULL DEFAULT '0' AFTER `id_product_attribute`;
ALTER TABLE `ps_cart_product` DROP PRIMARY KEY, ADD PRIMARY KEY (`id_cart`, `id_product`, `id_product_attribute`, `id_customization`, `id_address_delivery`);
ALTER TABLE `ps_order_detail` ADD `id_customization` INT(10) NULL DEFAULT '0' AFTER `product_attribute_id`;
ALTER TABLE `ps_customized_data` ADD `price` DECIMAL(20,6) NOT NULL DEFAULT '0' , ADD `weight` DECIMAL(20,6) NOT NULL DEFAULT '0' ;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment