SET NAMES utf8;

SET FOREIGN_KEY_CHECKS = 0;

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

UPDATE `t_affair_system_column` SET `column_pid` = 0, `group_id` = 3, `column_order` = 1, `column_title` = '销售价格', `column_name` = 'sale_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` = 12;

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

UPDATE `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\":\"m/kg\",\"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 `t_affair_system_column` SET `column_pid` = 0, `group_id` = 3, `column_order` = 10, `column_title` = '采购数量', `column_name` = 'purchase_quantity', `column_unit` = '[{\"key\":\"yard\",\"value\":\"码\"},{\"key\":\"kg\",\"value\":\"公斤\"},{\"key\":\"one\",\"value\":\"条\"},{\"key\":\"m\",\"value\":\"米\"}]', `column_type` = '{\"key\":\"double\",\"value\":\"2\"}', `column_control` = 0, `column_rule` = '{\"regex\":\"/^[0-9]+(.[0-9]{0,2})?$/\",\"tips\":\"只能为数字和2位小数点\"}', `column_is_virtual` = 0, `column_unit_symbiosis` = 'PriceQuantity', `column_detachable` = 1, `status` = NULL WHERE `column_id` = 28;

UPDATE `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\":\"m/kg\",\"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 `t_affair_system_column` SET `column_pid` = 0, `group_id` = 4, `column_order` = 4, `column_title` = '加工数量', `column_name` = 'machining_quantity', `column_unit` = '[{\"key\":\"yard\",\"value\":\"码\"},{\"key\":\"kg\",\"value\":\"公斤\"},{\"key\":\"one\",\"value\":\"条\"},{\"key\":\"m\",\"value\":\"米\"}]', `column_type` = '{\"key\":\"double\",\"value\":\"2\"}', `column_control` = 0, `column_rule` = '{\"regex\":\"/^[0-9]+(.[0-9]{0,2})?$/\",\"tips\":\"只能为数字和2位小数点\"}', `column_is_virtual` = 0, `column_unit_symbiosis` = 'PriceQuantity', `column_detachable` = 1, `status` = NULL WHERE `column_id` = 42;

UPDATE `t_affair_system_column` SET `column_pid` = 0, `group_id` = 6, `column_order` = 2, `column_title` = '入库数量', `column_name` = 'in_warehouse_quantity', `column_unit` = '[{\"key\":\"kg\",\"value\":\"公斤\"},{\"key\":\"yard\",\"value\":\"码\"},{\"key\":\"kg/yard\",\"value\":\"公斤/码\"},{\"key\":\"one\",\"value\":\"条\"},{\"key\":\"m\",\"value\":\"米\"}]', `column_type` = '', `column_control` = 13, `column_rule` = '{\"regex\":\"\",\"tips\":\"[公斤/码]时应如5.11/6.22\"}', `column_is_virtual` = 0, `column_unit_symbiosis` = '', `column_detachable` = 1, `status` = NULL WHERE `column_id` = 146;

UPDATE `t_affair_system_column` SET `column_pid` = 0, `group_id` = 6, `column_order` = 5, `column_title` = '出库数量', `column_name` = 'out_warehouse_quantity', `column_unit` = '[{\"key\":\"kg\",\"value\":\"公斤\"},{\"key\":\"yard\",\"value\":\"码\"},{\"key\":\"kg/yard\",\"value\":\"公斤/码\"},{\"key\":\"one\",\"value\":\"条\"},{\"key\":\"m\",\"value\":\"米\"}]', `column_type` = '', `column_control` = 13, `column_rule` = '{\"regex\":\"\",\"tips\":\"[公斤/码]时应如5.11/6.22\"}', `column_is_virtual` = 0, `column_unit_symbiosis` = '', `column_detachable` = 1, `status` = NULL WHERE `column_id` = 147;

UPDATE `t_affair_system_column` SET `column_pid` = 0, `group_id` = 6, `column_order` = 6, `column_title` = '库存数量', `column_name` = 'inventory_quantity', `column_unit` = '[{\"key\":\"kg\",\"value\":\"公斤\"},{\"key\":\"yard\",\"value\":\"码\"},{\"key\":\"kg/yard\",\"value\":\"公斤/码\"},{\"key\":\"one\",\"value\":\"条\"},{\"key\":\"m\",\"value\":\"米\"}]', `column_type` = '', `column_control` = 13, `column_rule` = '{\"regex\":\"\",\"tips\":\"\"}', `column_is_virtual` = 0, `column_unit_symbiosis` = '', `column_detachable` = 1, `status` = NULL WHERE `column_id` = 148;

UPDATE `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\":\"m/kg\",\"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 `t_affair_system_column` SET `column_pid` = 0, `group_id` = 3, `column_order` = 4, `column_title` = '退货数量', `column_name` = 'sale_refund_quantity', `column_unit` = '[{\"key\":\"yard\",\"value\":\"码\"},{\"key\":\"kg\",\"value\":\"公斤\"},{\"key\":\"one\",\"value\":\"条\"},{\"key\":\"m\",\"value\":\"米\"}]', `column_type` = '{\"key\":\"double\",\"value\":\"2\"}', `column_control` = 0, `column_rule` = '{\"regex\":\"/^[0-9]+(.[0-9]{0,2})?$/\",\"tips\":\"只能为数字和2位小数点\"}', `column_is_virtual` = 0, `column_unit_symbiosis` = 'PriceQuantity', `column_detachable` = 0, `status` = NULL WHERE `column_id` = 159;

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

UPDATE `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\":\"m/kg\",\"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 `t_affair_system_column` SET `column_pid` = 0, `group_id` = 6, `column_order` = 3, `column_title` = '要求入库数量', `column_name` = 'requirement_in_warehouse_quantity', `column_unit` = '[{\"key\":\"kg\",\"value\":\"公斤\"},{\"key\":\"yard\",\"value\":\"码\"},{\"key\":\"kg/yard\",\"value\":\"公斤/码\"},{\"key\":\"one\",\"value\":\"条\"},{\"key\":\"m\",\"value\":\"米\"}]', `column_type` = '', `column_control` = 13, `column_rule` = '{\"regex\":\"\",\"tips\":\"[公斤/码]时应如5.11/6.22\"}', `column_is_virtual` = 0, `column_unit_symbiosis` = '', `column_detachable` = 1, `status` = NULL WHERE `column_id` = 231;

UPDATE `t_affair_system_column` SET `column_pid` = 0, `group_id` = 6, `column_order` = 4, `column_title` = '实际入库数量', `column_name` = 'actual_in_warehouse_quantity', `column_unit` = '[{\"key\":\"kg\",\"value\":\"公斤\"},{\"key\":\"yard\",\"value\":\"码\"},{\"key\":\"kg/yard\",\"value\":\"公斤/码\"},{\"key\":\"one\",\"value\":\"条\"},{\"key\":\"m\",\"value\":\"米\"}]', `column_type` = '', `column_control` = 13, `column_rule` = '{\"regex\":\"\",\"tips\":\"[公斤/码]时应如5.11/6.22\"}', `column_is_virtual` = 0, `column_unit_symbiosis` = '', `column_detachable` = 1, `status` = NULL WHERE `column_id` = 232;

UPDATE `t_affair_system_column` SET `column_pid` = 0, `group_id` = 6, `column_order` = 7, `column_title` = '要求出库数量', `column_name` = 'requirement_out_warehouse_quantity', `column_unit` = '[{\"key\":\"kg\",\"value\":\"公斤\"},{\"key\":\"yard\",\"value\":\"码\"},{\"key\":\"kg/yard\",\"value\":\"公斤/码\"},{\"key\":\"one\",\"value\":\"条\"},{\"key\":\"m\",\"value\":\"米\"}]', `column_type` = '', `column_control` = 13, `column_rule` = '{\"regex\":\"\",\"tips\":\"[公斤/码]时应如5.11/6.22\"}', `column_is_virtual` = 0, `column_unit_symbiosis` = '', `column_detachable` = 1, `status` = NULL WHERE `column_id` = 233;

UPDATE `t_affair_system_column` SET `column_pid` = 0, `group_id` = 6, `column_order` = 8, `column_title` = '实际出库数量', `column_name` = 'actual_out_warehouse_quantity', `column_unit` = '[{\"key\":\"kg\",\"value\":\"公斤\"},{\"key\":\"yard\",\"value\":\"码\"},{\"key\":\"kg/yard\",\"value\":\"公斤/码\"},{\"key\":\"one\",\"value\":\"条\"},{\"key\":\"m\",\"value\":\"米\"}]', `column_type` = '', `column_control` = 13, `column_rule` = '{\"regex\":\"\",\"tips\":\"[公斤/码]时应如5.11/6.22\"}', `column_is_virtual` = 0, `column_unit_symbiosis` = '', `column_detachable` = 1, `status` = NULL WHERE `column_id` = 234;

UPDATE `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\":\"m/kg\",\"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 `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/kg\",\"value\":\"元/公斤\"},{\"key\":\"yuan/yard\",\"value\":\"元/码\"},{\"key\":\"yuan/one\",\"value\":\"元/条\"},{\"key\":\"m/kg\",\"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;

UPDATE `t_affair_system_column` SET `column_pid` = 0, `group_id` = 4, `column_order` = 5, `column_title` = '要求进仓数量', `column_name` = 'requirement_in_storehouse_quantity', `column_unit` = '[{\"key\":\"kg\",\"value\":\"公斤\"},{\"key\":\"yard\",\"value\":\"码\"},{\"key\":\"one\",\"value\":\"条\"},{\"key\":\"m\",\"value\":\"米\"}]', `column_type` = '{\"key\":\"double\",\"value\":\"2\"}', `column_control` = 0, `column_rule` = '{\"regex\":\"/^[0-9]+(.[0-9]{0,2})?$/\",\"tips\":\"只能为数字和2位小数点\"}', `column_is_virtual` = 0, `column_unit_symbiosis` = '', `column_detachable` = 1, `status` = NULL WHERE `column_id` = 258;

UPDATE `t_affair_system_column` SET `column_pid` = 0, `group_id` = 4, `column_order` = 6, `column_title` = '实际进仓数量', `column_name` = 'actual_in_storehouse_quantity', `column_unit` = '[{\"key\":\"kg\",\"value\":\"公斤\"},{\"key\":\"yard\",\"value\":\"码\"},{\"key\":\"one\",\"value\":\"条\"},{\"key\":\"m\",\"value\":\"米\"}]', `column_type` = '{\"key\":\"double\",\"value\":\"2\"}', `column_control` = 0, `column_rule` = '{\"regex\":\"/^[0-9]+(.[0-9]{0,2})?$/\",\"tips\":\"只能为数字和2位小数点\"}', `column_is_virtual` = 0, `column_unit_symbiosis` = '', `column_detachable` = 1, `status` = NULL WHERE `column_id` = 259;

UPDATE `t_affair_system_column` SET `column_pid` = 0, `group_id` = 4, `column_order` = 7, `column_title` = '出仓数量', `column_name` = 'out_storehouse_quantity', `column_unit` = '[{\"key\":\"yard\",\"value\":\"码\"},{\"key\":\"kg\",\"value\":\"公斤\"},{\"key\":\"one\",\"value\":\"条\"},{\"key\":\"m\",\"value\":\"米\"}]', `column_type` = '{\"key\":\"double\",\"value\":\"2\"}', `column_control` = 0, `column_rule` = '{\"regex\":\"/^[0-9]+(.[0-9]{0,2})?$/\",\"tips\":\"只能为数字和2位小数点\"}', `column_is_virtual` = 0, `column_unit_symbiosis` = '', `column_detachable` = 1, `status` = NULL WHERE `column_id` = 260;

SET FOREIGN_KEY_CHECKS = 1;