Página inicial Explorar Ajuda
Entrar
cnbg
/
cnbg-be
4
0
Fork 0
Arquivos Issues 0 Pull Requests 0 Wiki
Tree: a5d6d54b61
Branches Tags
cnbg-be
/
db
/
v2.0
/
220531.sql

220531.sql 18 KB
Histórico Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354 
  1. -- 新增三种任务类型
    2. 

  2. INSERT INTO wm_task_type (id, task_type_name, task_type_level, task_score_start, task_score_end, score, task_ent_id,
    3. 

  3.                           durgent_id, level1_id, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user,
    4. 

  4.                           update_time, update_user, status, base_id, real_flag, rule_id, parent_id)
    5. 

  5. VALUES (34, '医院患者教育培训', '1', 0, 2000, 2000, null, null, null, null, 0, '0', 1, '2022-05-31 14:56:55', null, null, null,
    6. 

  6.         0, '会议举办', null, '1', 'p-1');
    7. 

  7. INSERT INTO wm_task_type (id, task_type_name, task_type_level, task_score_start, task_score_end, score, task_ent_id,
    8. 

  8.                           durgent_id, level1_id, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user,
    9. 

  9.                           update_time, update_user, status, base_id, real_flag, rule_id, parent_id)
    10. 

  10. VALUES (35, '药店药师培训', '1', 0, 2000, 2000, null, null, null, null, 0, '0', 1, '2022-05-31 14:56:58', null, null, null, 0,
    11. 

  11.         '会议举办', null, '1', 'p-1');
    12. 

  12. INSERT INTO wm_task_type (id, task_type_name, task_type_level, task_score_start, task_score_end, score, task_ent_id,
    13. 

  13.                           durgent_id, level1_id, dept_id, del_flag, enable_flag, tenant_id, create_time, create_user,
    14. 

  14.                           update_time, update_user, status, base_id, real_flag, rule_id, parent_id)
    15. 

  15. VALUES (36, '商业公司培训', '1', 0, 2000, 2000, null, null, null, null, 0, '0', 1, '2022-05-31 14:56:59', null, null, null, 0,
    16. 

  16.         '会议举办', null, '1', 'p-1');
    17. 

  17. 

  18. -- 任务类型培训-小程序页面字段配置
    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 ('1', '36', 'temp32', '关联积分包', 2, 'domain', 1, 200, null, null, 'package_list', '1', null, '0', '0', 1, '2021-01-17 10:54:59', null, null, 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 ('1', '36', 'temp2', '培训主题', 3, 'text', 2, 20, null, '', '', '1', null, '0', '0', 1, '2020-07-20 22:34:28', null, null, 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 ('1', '36', 'temp3', '培训类型', 1, 'select', 1, 200, null, '', 'training_type', '1', null, '0', '0', 1, '2020-07-22 00:42:12', null, null, 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 ('1', '36', 'temp4', '培训时间', 4, 'datetime', 1, 200, null, '', '', '1', null, '0', '0', 1, '2020-07-20 22:34:30', null, null, 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 ('1', '36', 'temp5', '培训议程', 7, 'img', 1, 20, null, '', '', '1', null, '0', '0', 1, '2020-07-20 22:34:31', null, null, null);
    24. 

  24. 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 ('1', '36', 'temp6', '培训签到表', 8, 'img', 1, 5, null, '', '', '1', null, '0', '0', 1, '2020-07-20 22:34:32', null, null, null);
    25. 

  25. 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 ('1', '36', 'temp7', '现场照片', 9, 'img', 1, 5, null, '', '', '1', null, '0', '0', 1, '2020-07-20 22:34:33', null, null, null);
    26. 

  26. 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 ('1', '36', 'temp8', '外采费用', 12, 'money', 1, 200, null, '', '', '0', null, '0', '0', 1, '2020-07-20 22:34:35', null, null, null);
    27. 

  27. 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 ('1', '36', 'temp9', '培训总结', 13, 'longtext', 3, 100, null, '', '', '1', null, '0', '0', 1, '2020-07-20 22:34:34', null, null, null);
    28. 

  28. 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 ('1', '36', 'temp31', '位置打卡', 6, 'map', 1, 200, null, null, null, '0', null, '0', '0', 1, '2021-01-10 21:54:36', null, null, null);
    29. 

  29. 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 ('1', '36', 'temp10', '培训内容', 10, 'img', 2, 20, null, '', '', '1', null, '0', '0', 1, '2020-07-20 22:34:31', null, null, null);
    30. 

  30. 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 ('1', '36', 'temp13', '主讲人', 5, 'text', 2, 20, null, '', '', '1', null, '0', '0', 1, '2020-07-22 00:42:12', null, null, null);
    31. 

  31. 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 ('1', '35', 'temp32', '关联积分包', 2, 'domain', 1, 200, null, null, 'package_list', '1', null, '0', '0', 1, '2021-01-17 10:54:59', null, null, null);
    32. 

  32. 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 ('1', '35', 'temp2', '培训主题', 3, 'text', 2, 20, null, '', '', '1', null, '0', '0', 1, '2020-07-20 22:34:28', null, null, null);
    33. 

  33. 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 ('1', '35', 'temp3', '培训类型', 1, 'select', 1, 200, null, '', 'training_type', '1', null, '0', '0', 1, '2020-07-22 00:42:12', null, null, null);
    34. 

  34. 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 ('1', '35', 'temp4', '培训时间', 4, 'datetime', 1, 200, null, '', '', '1', null, '0', '0', 1, '2020-07-20 22:34:30', null, null, null);
    35. 

  35. 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 ('1', '35', 'temp5', '培训议程', 7, 'img', 1, 20, null, '', '', '1', null, '0', '0', 1, '2020-07-20 22:34:31', null, null, null);
    36. 

  36. 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 ('1', '35', 'temp6', '培训签到表', 8, 'img', 1, 5, null, '', '', '1', null, '0', '0', 1, '2020-07-20 22:34:32', null, null, null);
    37. 

  37. 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 ('1', '35', 'temp7', '现场照片', 9, 'img', 1, 5, null, '', '', '1', null, '0', '0', 1, '2020-07-20 22:34:33', null, null, null);
    38. 

  38. 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 ('1', '35', 'temp8', '外采费用', 12, 'money', 1, 200, null, '', '', '0', null, '0', '0', 1, '2020-07-20 22:34:35', null, null, null);
    39. 

  39. 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 ('1', '35', 'temp9', '培训总结', 13, 'longtext', 3, 100, null, '', '', '1', null, '0', '0', 1, '2020-07-20 22:34:34', null, null, null);
    40. 

  40. 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 ('1', '35', 'temp31', '位置打卡', 6, 'map', 1, 200, null, null, null, '0', null, '0', '0', 1, '2021-01-10 21:54:36', null, null, null);
    41. 

  41. 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 ('1', '35', 'temp10', '培训内容', 10, 'img', 2, 20, null, '', '', '1', null, '0', '0', 1, '2020-07-20 22:34:31', null, null, null);
    42. 

  42. 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 ('1', '35', 'temp13', '主讲人', 5, 'text', 2, 20, null, '', '', '1', null, '0', '0', 1, '2020-07-22 00:42:12', null, null, null);
    43. 

  43. 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 ('1', '34', 'temp13', '主讲人', 5, 'text', 2, 20, null, '', '', '1', null, '0', '0', 1, '2020-07-22 00:42:12', null, null, null);
    44. 

  44. 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 ('1', '34', 'temp10', '培训内容', 10, 'img', 2, 20, null, '', '', '1', null, '0', '0', 1, '2020-07-20 22:34:31', null, null, null);
    45. 

  45. 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 ('1', '34', 'temp31', '位置打卡', 6, 'map', 1, 200, null, null, null, '0', null, '0', '0', 1, '2021-01-10 21:54:36', null, null, null);
    46. 

  46. 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 ('1', '34', 'temp9', '培训总结', 13, 'longtext', 3, 100, null, '', '', '1', null, '0', '0', 1, '2020-07-20 22:34:34', null, null, null);
    47. 

  47. 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 ('1', '34', 'temp8', '外采费用', 12, 'money', 1, 200, null, '', '', '0', null, '0', '0', 1, '2020-07-20 22:34:35', null, null, null);
    48. 

  48. 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 ('1', '34', 'temp7', '现场照片', 9, 'img', 1, 5, null, '', '', '1', null, '0', '0', 1, '2020-07-20 22:34:33', null, null, null);
    49. 

  49. 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 ('1', '34', 'temp6', '培训签到表', 8, 'img', 1, 5, null, '', '', '1', null, '0', '0', 1, '2020-07-20 22:34:32', null, null, null);
    50. 

  50. 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 ('1', '34', 'temp5', '培训议程', 7, 'img', 1, 20, null, '', '', '1', null, '0', '0', 1, '2020-07-20 22:34:31', null, null, null);
    51. 

  51. 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 ('1', '34', 'temp4', '培训时间', 4, 'datetime', 1, 200, null, '', '', '1', null, '0', '0', 1, '2020-07-20 22:34:30', null, null, null);
    52. 

  52. 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 ('1', '34', 'temp3', '培训类型', 1, 'select', 1, 200, null, '', 'training_type', '1', null, '0', '0', 1, '2020-07-22 00:42:12', null, null, null);
    53. 

  53. 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 ('1', '34', 'temp2', '培训主题', 3, 'text', 2, 20, null, '', '', '1', null, '0', '0', 1, '2020-07-20 22:34:28', null, null, null);
    54. 

  54. 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 ('1', '34', 'temp32', '关联积分包', 2, 'domain', 1, 200, null, null, 'package_list', '1', null, '0', '0', 1, '2021-01-17 10:54:59', null, null, null);
    55.