Home Explore Help
Sign In
centrenda
/
lacemi
2
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: fa82c0648c
Branches Tags
lacemi
/
data
/
upgrade
/
v1.2.3
/
v1.2.3.sql

v1.2.3.sql 15 KB
History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051 
  1. SET NAMES utf8;
    2. 

  2. 

  3. SET FOREIGN_KEY_CHECKS = 0;
    4. 

  4. 

  5. 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;
    6. 

  6. 

  7. 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;
    8. 

  8. 

  9. 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;
    10. 

  10. 

  11. 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;
    12. 

  12. 

  13. 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;
    14. 

  14. 

  15. 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;
    16. 

  16. 

  17. 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;
    18. 

  18. 

  19. 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;
    20. 

  20. 

  21. 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;
    22. 

  22. 

  23. 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;
    24. 

  24. 

  25. 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;
    26. 

  26. 

  27. 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;
    28. 

  28. 

  29. 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;
    30. 

  30. 

  31. 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;
    32. 

  32. 

  33. 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;
    34. 

  34. 

  35. 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;
    36. 

  36. 

  37. 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;
    38. 

  38. 

  39. 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;
    40. 

  40. 

  41. 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;
    42. 

  42. 

  43. 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;
    44. 

  44. 

  45. 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;
    46. 

  46. 

  47. 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;
    48. 

  48. 

  49. 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;
    50. 

  50. 

  51. SET FOREIGN_KEY_CHECKS = 1;
    52.