lacemi/data/upgrade/v1.2.0/v1.2.0.sql

SET FOREIGN_KEY_CHECKS=0;

ALTER TABLE `t_collection` ADD COLUMN IF NOT EXISTS `product_id` int(11) NULL DEFAULT NULL AFTER `image_id`;

ALTER TABLE `t_collection` ADD COLUMN IF NOT EXISTS `collection_tag_ids` text CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL AFTER `collection_gram_weight_unit`;

ALTER TABLE `t_collection` ADD COLUMN IF NOT EXISTS `product_cloth_price_unit` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' AFTER `collection_tag_ids`;

ALTER TABLE `t_collection` ADD COLUMN IF NOT EXISTS `product_product_price_unit` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '' AFTER `product_cloth_price_unit`;

ALTER TABLE `t_collection` ADD COLUMN IF NOT EXISTS `product_cloth_price` decimal(13, 2) NULL DEFAULT NULL AFTER `product_product_price_unit`;

ALTER TABLE `t_collection` ADD COLUMN IF NOT EXISTS `product_product_price` decimal(13, 2) NULL DEFAULT NULL AFTER `product_cloth_price`;

ALTER TABLE `t_process_in_calculation` ADD COLUMN IF NOT EXISTS `collection_id` int(11) NOT NULL AFTER `product_id`;

SET FOREIGN_KEY_CHECKS=1;