SET NAMES utf8;

SET FOREIGN_KEY_CHECKS = 0;

UPDATE `lacew_mi_prod`.`t_affair_system_column` SET `column_pid` = 0, `group_id` = 3, `column_order` = 8, `column_title` = '采购价格', `column_name` = 'purchase_price', `column_unit` = '[{\"key\":\"yuan/yard\",\"value\":\"元/码\"},{\"key\":\"yuan/kg\",\"value\":\"元/公斤\"},{\"key\":\"yuan/one\",\"value\":\"元/条\"},{\"key\":\"yuan/m\",\"value\":\"元/米\"}]', `column_type` = '{\"key\":\"double\",\"value\":\"3\"}', `column_control` = 0, `column_rule` = '{\"regex\":\"/^[0-9]+(.[0-9]{0,3})?$/\",\"tips\":\"只能为数字和3位小数点\"}', `column_is_virtual` = 0, `column_unit_symbiosis` = 'PriceQuantity', `column_detachable` = 0, `status` = NULL WHERE `column_id` = 26;

UPDATE `lacew_mi_prod`.`t_affair_system_column` SET `column_pid` = 0, `group_id` = 4, `column_order` = 2, `column_title` = '加工价格', `column_name` = 'machining_price', `column_unit` = '[{\"key\":\"yuan/yard\",\"value\":\"元/码\"},{\"key\":\"yuan/kg\",\"value\":\"元/公斤\"},{\"key\":\"yuan/one\",\"value\":\"元/条\"},{\"key\":\"yuan/m\",\"value\":\"元/米\"}]', `column_type` = '{\"key\":\"double\",\"value\":\"3\"}', `column_control` = 0, `column_rule` = '{\"regex\":\"/^[0-9]+(.[0-9]{0,3})?$/\",\"tips\":\"只能为数字和3位小数点\"}', `column_is_virtual` = 0, `column_unit_symbiosis` = 'PriceQuantity', `column_detachable` = 0, `status` = NULL WHERE `column_id` = 40;

UPDATE `lacew_mi_prod`.`t_affair_system_column` SET `column_pid` = 0, `group_id` = 3, `column_order` = 5, `column_title` = '退货价格', `column_name` = 'sale_refund_price', `column_unit` = '[{\"key\":\"yuan/yard\",\"value\":\"元/码\"},{\"key\":\"yuan/kg\",\"value\":\"元/公斤\"},{\"key\":\"yuan/one\",\"value\":\"元/条\"},{\"key\":\"yuan/m\",\"value\":\"元/米\"}]', `column_type` = '{\"key\":\"double\",\"value\":\"3\"}', `column_control` = 0, `column_rule` = '{\"regex\":\"/^[0-9]+(.[0-9]{0,3})?$/\",\"tips\":\"只能为数字和3位小数点\"}', `column_is_virtual` = 0, `column_unit_symbiosis` = 'PriceQuantity', `column_detachable` = 0, `status` = NULL WHERE `column_id` = 157;

UPDATE `lacew_mi_prod`.`t_affair_system_column` SET `column_pid` = 0, `group_id` = 9, `column_order` = 5, `column_title` = '价格', `column_name` = 'public_price', `column_unit` = '[{\"key\":\"yuan/yard\",\"value\":\"元/码\"},{\"key\":\"yuan/kg\",\"value\":\"元/公斤\"},{\"key\":\"yuan/one\",\"value\":\"元/条\"},{\"key\":\"yuan/m\",\"value\":\"元/米\"}]', `column_type` = '{\"key\":\"double\",\"value\":\"3\"}', `column_control` = 0, `column_rule` = '{\"regex\":\"/^[0-9]+(.[0-9]{0,3})?$/\",\"tips\":\"只能为数字和3位小数点\"}', `column_is_virtual` = 0, `column_unit_symbiosis` = 'PriceQuantity', `column_detachable` = 0, `status` = NULL WHERE `column_id` = 217;

UPDATE `lacew_mi_prod`.`t_affair_system_column` SET `column_pid` = 0, `group_id` = 9, `column_order` = 7, `column_title` = '成品价格', `column_name` = 'public_finished_price', `column_unit` = '[{\"key\":\"yuan/yard\",\"value\":\"元/码\"},{\"key\":\"yuan/kg\",\"value\":\"元/公斤\"},{\"key\":\"yuan/one\",\"value\":\"元/条\"},{\"key\":\"yuan/m\",\"value\":\"元/米\"}]', `column_type` = '{\"key\":\"double\",\"value\":\"3\"}', `column_control` = 0, `column_rule` = '{\"regex\":\"/^[0-9]+(.[0-9]{0,3})?$/\",\"tips\":\"只能为数字和3位小数点\"}', `column_is_virtual` = 0, `column_unit_symbiosis` = '', `column_detachable` = 0, `status` = NULL WHERE `column_id` = 237;

UPDATE `lacew_mi_prod`.`t_affair_system_column` SET `column_pid` = 0, `group_id` = 9, `column_order` = 9, `column_title` = '胚布价格', `column_name` = 'public_embryo_price', `column_unit` = '[{\"key\":\"yuan/yard\",\"value\":\"元/码\"},{\"key\":\"yuan/kg\",\"value\":\"元/公斤\"},{\"key\":\"yuan/one\",\"value\":\"元/条\"},{\"key\":\"yuan/m\",\"value\":\"元/米\"}]', `column_type` = '{\"key\":\"double\",\"value\":\"3\"}', `column_control` = 0, `column_rule` = '{\"regex\":\"/^[0-9]+(.[0-9]{0,3})?$/\",\"tips\":\"只能为数字和3位小数点\"}', `column_is_virtual` = 0, `column_unit_symbiosis` = '', `column_detachable` = 0, `status` = NULL WHERE `column_id` = 238;

SET FOREIGN_KEY_CHECKS = 1;