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.5
/
v1.2.5.sql

v1.2.5.sql 4.0 KB
History Raw

1234567891011121314151617 
  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` = 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;
    6. 

  6. 

  7. 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\":\"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;
    8. 

  8. 

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

  10. 

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

  12. 

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

  14. 

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

  16. 

  17. SET FOREIGN_KEY_CHECKS = 1;
    18.