Home Explore Help
Sign In
cnbg
/
cnbg-be
4
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: a5d6d54b61
Branches Tags
cnbg-be
/
db
/
v2.0
/
221116.sql

221116.sql 9.5 KB
History Raw

1234567891011121314151617181920212223 
  1. -- 45-物流信息收集任务类型 字段配置
    2. 

  2. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('45', '45', 'temp32', '关联积分包', 1, 'domain', 1, 200, '', '', 'package_list', '1', null, '0', '0', 1, '2022-11-15 09:49:30', null, '2022-11-15 09:49:30', null);
    3. 

  3. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('45', '45', 'temp2', '配送客户名称  ', 2, 'text', 4, 50, '', '', '', '1', null, '0', '0', 1, '2022-11-15 09:49:30', null, '2022-11-15 09:49:30', null);
    4. 

  4. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('45', '45', 'temp26', '配送物名称  ', 3, 'text', 4, 50, '', '', '', '1', null, '0', '0', 1, '2022-11-15 09:49:30', null, '2022-11-15 09:49:30', null);
    5. 

  5. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('45', '45', 'temp3', '配送数量', 4, 'number', 2, 20, '', '', '', '1', null, '0', '0', 1, '2022-11-15 09:49:30', null, '2022-11-15 09:49:30', null);
    6. 

  6. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('45', '45', 'temp4', '配送时间', 5, 'datetime', 1, 200, '', '', '', '1', null, '0', '0', 1, '2022-11-15 09:49:30', null, '2022-11-15 09:49:30', null);
    7. 

  7. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('45', '45', 'temp5', '所属地区', 6, 'area', 1, 200, '', '', '', '1', null, '0', '0', 1, '2022-11-15 09:49:30', null, '2022-11-15 09:49:30', null);
    8. 

  8. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('45', '45', 'temp31', '位置打卡', 7, 'map', 1, 200, '', '', '', '0', null, '0', '0', 1, '2022-11-15 09:49:30', null, '2022-11-15 09:49:30', null);
    9. 

  9. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('45', '45', 'temp6', '出库单/物流单（至少上传1张）', 8, 'img', 1, 5, '', '', '', '1', null, '0', '0', 1, '2022-11-15 09:49:30', null, '2022-11-15 09:49:30', null);
    10. 

  10. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('45', '45', 'temp7', '现场照片（至少上传2张，需包含配送物、配送条件）', 9, 'img', 2, 5, '', '', '', '1', null, '0', '0', 1, '2022-11-15 09:49:30', null, '2022-11-15 09:49:30', null);
    11. 

  11. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('45', '45', 'temp8', '签收单（至少上传1张）', 10, 'img', 1, 5, '', '', '', '1', null, '0', '0', 1, '2022-11-15 09:49:30', null, '2022-11-15 09:49:30', null);
    12. 

  12. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('45', '45', 'temp10', '总结', 11, 'longtext', 5, 100, '', '', '', '0', null, '0', '0', 1, '2022-11-15 09:49:30', null, '2022-11-15 09:49:30', null);
    13. 

  13. 

  14. -- 46-设备保养任务类型 字段配置
    15. 

  15. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('46', '46', 'temp32', '关联积分包', 1, 'domain', 1, 200, '', '', 'package_list', '1', null, '0', '0', 1, '2022-11-15 09:49:30', null, '2022-11-15 09:49:30', null);
    16. 

  16. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('46', '46', 'temp2', '设备名称', 2, 'text', 4, 50, '', '', '', '1', null, '0', '0', 1, '2022-11-15 09:49:30', null, '2022-11-15 09:49:30', null);
    17. 

  17. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('46', '46', 'temp26', '保养科目', 3, 'text', 4, 50, '', '', '', '1', null, '0', '0', 1, '2022-11-15 09:49:30', null, '2022-11-15 09:49:30', null);
    18. 

  18. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('46', '46', 'temp4', '保养时间', 5, 'datetime', 1, 200, '', '', '', '1', null, '0', '0', 1, '2022-11-15 09:49:30', null, '2022-11-15 09:49:30', null);
    19. 

  19. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('46', '46', 'temp31', '位置打卡', 7, 'map', 1, 200, '', '', '', '0', null, '0', '0', 1, '2022-11-15 09:49:30', null, '2022-11-15 09:49:30', null);
    20. 

  20. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('46', '46', 'temp6', '消耗品（至少上传1张）', 8, 'img', 1, 5, '', '', '', '1', null, '0', '0', 1, '2022-11-15 09:49:30', null, '2022-11-15 09:49:30', null);
    21. 

  21. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('46', '46', 'temp7', '现场照片（至少上传1张）', 9, 'img', 1, 5, '', '', '', '1', null, '0', '0', 1, '2022-11-15 09:49:30', null, '2022-11-15 09:49:30', null);
    22. 

  22. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('46', '46', 'temp8', '维修单（至少上传1张）', 10, 'img', 1, 5, '', '', '', '0', null, '0', '0', 1, '2022-11-15 09:49:30', null, '2022-11-15 09:49:30', null);
    23. 

  23. INSERT INTO wm_task_content_config (base_type_id, task_type_id, task_filed_key, task_filed_value, seq, task_filed_type, task_filed_minsize, task_filed_maxsize, task_filed_alert, dict_url, dict_group_name, is_mustfill, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user, update_time, update_user) VALUES ('46', '46', 'temp10', '工作总结', 11, 'longtext', 5, 100, '', '', '', '0', null, '0', '0', 1, '2022-11-15 09:49:30', null, '2022-11-15 09:49:30', null);
    24.