SET FOREIGN_KEY_CHECKS=0;

ALTER TABLE `lacew_mi_prod`.`t_product` ADD COLUMN  IF NOT EXISTS `product_gram_weight` decimal(18, 0) NULL DEFAULT NULL AFTER `product_beginning_id`;

ALTER TABLE `lacew_mi_prod`.`t_product` ADD COLUMN  IF NOT EXISTS `product_gram_weight_unit` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT 'g/m2' AFTER `product_gram_weight`;

REPLACE INTO `lacew_mi_prod`.`t_affair_system_column`(`column_id`, `column_pid`, `group_id`, `column_order`, `column_title`, `column_name`, `column_unit`, `column_type`, `column_control`, `column_rule`, `column_is_virtual`, `column_unit_symbiosis`, `column_detachable`, `status`) VALUES (301, 0, 1, 24, '供应商型号', 'collection_pname', '[{\"key\":\"collection_id\"}]', '{\"key\":\"collection_id\",\"value\":\"collection_pname\"}', 28, '{\"regex\":\"\",\"tips\":\"选择产品型号\"}', 0, '', 0, NULL);

REPLACE INTO `lacew_mi_prod`.`t_affair_system_column`(`column_id`, `column_pid`, `group_id`, `column_order`, `column_title`, `column_name`, `column_unit`, `column_type`, `column_control`, `column_rule`, `column_is_virtual`, `column_unit_symbiosis`, `column_detachable`, `status`) VALUES (302, 0, 1, 23, '克重', 'product_gram_weight', '[{\"key\":\"g/m2\",\"value\":\"平方米克重\"}]', '{\"key\":\"integer\",\"value\":\"\"}', 0, '{\"regex\":\"/^0|[1-9][0-9]{0,18}$/\",\"tips\":\"请填入1到18位纯数字\"}', 0, '', 0, NULL);

SET FOREIGN_KEY_CHECKS=1;