1118.sql 1.9 KB

123456789101112131415161718192021
  1. -- 新增药店拜访任务类型
  2. INSERT INTO `wm_task_type`(`id`, `task_type_name`, `task_type_level`, `task_score_start`, `task_score_end`, `score`,
  3. `task_ent_id`, `durgent_id`, `level1_id`, `dept_id`, `del_flag`, `enable_flag`, `tenant_id`,
  4. `create_time`, `create_user`, `update_time`, `update_user`, `status`, `base_id`, `real_flag`,
  5. `rule_id`, `parent_id`)
  6. VALUES ('33', '药店拜访', '1', '0', '500', '300', NULL, NULL, NULL, NULL, '0', '0', '1', '2021-11-18 15:26:21', NULL, NULL,
  7. NULL, '0', '药店拜访', NULL, '1', 'p-2');
  8. -- 新增药店拜访任务内容字段配置
  9. INSERT INTO `wm_task_content_config`(`base_type_id`, `task_type_id`, `task_filed_key`, `task_filed_value`, `seq`,
  10. `task_filed_type`, `task_filed_minsize`, `task_filed_maxsize`, `task_filed_alert`,
  11. `dict_url`, `dict_group_name`, `is_mustfill`, `dept_id`, `del_flag`, `enable_flag`,
  12. `tenant_id`, `create_time`, `create_user`, `update_time`, `update_user`)
  13. VALUES ('2', '33', 'temp1', '横坐标', NULL, 'zuobiao', '1', '20', '', '', '', '1', NULL, '0', '0', '1',
  14. '2021-11-18 22:35:24', NULL, NULL, NULL);
  15. INSERT INTO `wm_task_content_config`(`base_type_id`, `task_type_id`, `task_filed_key`, `task_filed_value`, `seq`,
  16. `task_filed_type`, `task_filed_minsize`, `task_filed_maxsize`, `task_filed_alert`,
  17. `dict_url`, `dict_group_name`, `is_mustfill`, `dept_id`, `del_flag`, `enable_flag`,
  18. `tenant_id`, `create_time`, `create_user`, `update_time`, `update_user`)
  19. VALUES ('2', '33', 'temp2', '纵坐标', NULL, 'zuobiao', '5', '20', '', '', '', '1', NULL, '0', '0', '1',
  20. '2021-11-18 22:35:27', NULL, NULL, NULL);