0217.sql 2.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445
  1. ALTER TABLE `sys_user` ADD `province_code` varchar(11) DEFAULT NULL COMMENT '省份编码';
  2. ALTER TABLE `sys_user` ADD `city_code` varchar(11) DEFAULT NULL COMMENT '城市编码';
  3. ALTER TABLE `wm_da_agent` ADD `pgqx` varchar(11) DEFAULT NULL COMMENT '派工权限';
  4. ALTER TABLE `wm_da_agent` ADD `qylx` varchar(11) DEFAULT NULL COMMENT '企业类型';
  5. update wm_da_agent set pgqx = 1;
  6. update wm_da_agent set qylx = 0;
  7. ALTER TABLE `wm_task_content` ADD `temp31` varchar(255) DEFAULT NULL COMMENT 'temp31';
  8. ALTER TABLE `wm_task_content` ADD `temp32` varchar(255) DEFAULT NULL COMMENT 'temp32';
  9. ALTER TABLE `wm_task` ADD `task_from` varchar(2) DEFAULT '1' COMMENT '来源';
  10. ALTER TABLE `wm_score_package_settle_note` ADD `remark` varchar(256) DEFAULT NULL COMMENT '结算描述';
  11. update wm_task set task_from = '1';
  12. update wm_score_package set package_user_scope = '1'
  13. update wm_score_package set package_type2 = '1';
  14. update wm_score_package set package_type1 = '1';
  15. update wm_score_package set task_add_flag = '0' where package_finish_status = '1';
  16. update wm_score_package_status s set s.task_add_flag = (
  17. select task_add_flag from wm_score_package p where p.id = s.package_id );
  18. update wm_score_package set related_service = send_package_dept_id where typeid = 1
  19. update wm_score_package set accept_sug = drug_ent_id where typeid = 1 and send_package_dept_id = dept_id
  20. update wm_score_package set accept_sug = level1_id where typeid = 1 and send_package_dept_id != dept_id
  21. update wm_score_package set typeid = 0 where typeid = 1 and send_package_dept_id = dept_id
  22. INSERT into wm_score_package_status (user_id,package_id ,status,dept_id,create_time)
  23. select xxdb_id , id ,2,dept_id ,create_time from wm_score_package where typeid = 3
  24. -- 更新药品生产企业
  25. ALTER TABLE `wm_da_drug_ent_drugtable` ADD `drug_ent_name` varchar(255) DEFAULT NULL COMMENT '所属药企名称';
  26. ALTER TABLE `wm_da_drug_ent_drugtable` ADD `drug_ent_num` int(11) DEFAULT NULL COMMENT '分配统计';
  27. UPDATE wm_da_drug_ent_drugtable e set drug_ent_name = (select entname from wm_da_drug_ent t where e.drug_ent_id = t.id)