医院版数据
```sql
# 迁移医生
INSERT INTO `meridian_portable_hospital_public`.`tb_doctor`(`doctor_id`, `name`, `phone`, `sex`, `age`, `num_point`, `area`, `hospital_id`, `hospital_name`, `department`, `sign`, `logo`, `id_card`, `id_card_img`, `type_doctor`, `certificate`, `certificate_img`, `last_time`, `time`, `memo`, `is_stop`, `push_money_per`, `add_money_lv`, `add_money_per`, `type`, `service_fee`, `service_fee_free_day`, `service_fee_free_month`, `service_fee_free`, `is_service_fee_free`, `earnest_money`, `earnest_money_curr`)
select
d.doctor_id AS doctor_id,
d.name AS name,
d.phone AS phone,
da.sex AS sex,
da.age AS age,
d.num_point AS num_point,
d.area AS area,
d.factor_id AS hospital_id,
'医院版专用' AS hospital_name,
null AS department,
da.sign AS sign,
null AS logo,
da.id_card AS id_card,
da.id_card_img AS id_card_img,
null AS type_doctor,
da.certificate AS certificate,
da.certificate_img AS certificate_img,
-- AS udid,
d.last_time AS last_time,
da.time AS time,
da.memo AS memo,
d.is_stop AS is_stop,
d.push_money_per AS push_money_per,
d.add_money_lv AS add_money_lv,
d.add_money_per AS add_money_per,
d.type AS type,
d.service_fee AS service_fee,
d.service_fee_free_day AS service_fee_free_day,
d.service_fee_free_month AS service_fee_free_month,
d.service_fee_free AS service_fee_free,
d.is_service_fee_free AS is_service_fee_free,
d.earnest_money AS earnest_money,
d.earnest_money_curr AS earnest_money_cur
from meridian_portable_public.tb_doctor d
left join meridian_portable_public.tb_doctor_audit da
on d.doctor_id = da.account_id
where doctor_id in (
106202
);
// public
USE meridian_portable_hospital_public;
ALTER TABLE tb_account
ADD is_lock TINYINT(1) DEFAULT 0 COMMENT '是否锁定， 1锁定, 0: 不锁定'
delete from tb_doctor where doctor_id not in (医院版医生id);
delete from tb_device where doctor_id not in (医院版医生id);
delete from tb_account where id not in (医院版医生id，服务商id);
delete from tb_address where account_id not in (医院版医生id); '
// logic
USE meridian_portable_hospital_logic;
delete from tb_doctor_illness where doctor_id not in (医院版医生id);
delete from tb_doctor_medicine_stock where doctor_id not in (医院版医生id);
delete from tb_patient where doctor_id not in (医院版医生id);
delete from tb_prescription_template where did not in (医院版医生id);
delete from tb_push where account_id not in ((select account_id from tb_patient
where doctor_id in (医院版医生id)));
delete from tb_push_plan where account_id not in ((select account_id from tb_patient
where doctor_id in (医院版医生id)));
delete from tb_result where doctor_id not in (医院版医生id);
delete from tb_result_illness where id not in (select id from tb_result where doctor_id in (医院版医生id))
delete from tb_result_habitus where id not in (select id from tb_result where doctor_id in (医院版医生id))
delete from tb_result_pain where id not in (select id from tb_result where doctor_id in (医院版医生id))
delete from tb_doctor_medicine_stock where doctor_id not in (医院版医生id);
```