wlyy2.0/src/main/resources/sql/truncate.sql

TRUNCATE TABLE `dm_disease`;
TRUNCATE TABLE `dm_hospital_dept`;
TRUNCATE TABLE `dm_intervene_item_type`;
TRUNCATE TABLE `dm_job`;
TRUNCATE TABLE `dm_medicines`;
TRUNCATE TABLE `dm_relationship`;
TRUNCATE TABLE `dm_rsa`;
TRUNCATE TABLE `dm_sequence`;
TRUNCATE TABLE `dm_service`;
TRUNCATE TABLE `dm_sports`;
TRUNCATE TABLE `dm_sports_type`;
TRUNCATE TABLE `wlyy_advert`;
TRUNCATE TABLE `wlyy_chat_log`;
TRUNCATE TABLE `wlyy_complaint_doctor`;
TRUNCATE TABLE `wlyy_consult`;
TRUNCATE TABLE `wlyy_consult_communication`;
TRUNCATE TABLE `wlyy_consult_communication_reply`;
TRUNCATE TABLE `wlyy_consult_movi`;
TRUNCATE TABLE `wlyy_consult_movi_referral`;
TRUNCATE TABLE `wlyy_consult_public`;
TRUNCATE TABLE `wlyy_consult_public_reply`;
TRUNCATE TABLE `wlyy_consult_team`;
TRUNCATE TABLE `wlyy_consult_team_doctor`;
TRUNCATE TABLE `wlyy_consult_team_log`;
TRUNCATE TABLE `wlyy_doctor`;
TRUNCATE TABLE `wlyy_doctor_address`;
TRUNCATE TABLE `wlyy_doctor_comment`;
TRUNCATE TABLE `wlyy_doctor_medical_records_part`;
TRUNCATE TABLE `wlyy_doctor_medical_records_part_item`;
TRUNCATE TABLE `wlyy_doctor_patient_group_info`;
TRUNCATE TABLE `wlyy_doctor_scheduling`;
TRUNCATE TABLE `wlyy_doctor_scheduling_times`;
TRUNCATE TABLE `wlyy_doctor_service`;
TRUNCATE TABLE `wlyy_doctor_statistics_comment`;
TRUNCATE TABLE `wlyy_doctor_statistics_consult`;
TRUNCATE TABLE `wlyy_doctor_team`;
TRUNCATE TABLE `wlyy_doctor_team_info`;
TRUNCATE TABLE `wlyy_followup_item_record`;
TRUNCATE TABLE `wlyy_followup_item_record_answer`;
TRUNCATE TABLE `wlyy_followup_item_record_question`;
TRUNCATE TABLE `wlyy_followup_item_record_question_option`;
TRUNCATE TABLE `wlyy_followup_plan`;
TRUNCATE TABLE `wlyy_followup_plan_doctor`;
TRUNCATE TABLE `wlyy_followup_plan_stage`;
TRUNCATE TABLE `wlyy_followup_plan_stage_item`;
TRUNCATE TABLE `wlyy_followup_plan_stage_item_question`;
TRUNCATE TABLE `wlyy_followup_plan_stage_item_question_option`;
TRUNCATE TABLE `wlyy_followup_plan_stage_target`;
TRUNCATE TABLE `wlyy_followup_question`;
TRUNCATE TABLE `wlyy_followup_question_option`;
TRUNCATE TABLE `wlyy_followup_summary`;
TRUNCATE TABLE `wlyy_followup_tc`;
TRUNCATE TABLE `wlyy_followup_tc_option`;
TRUNCATE TABLE `wlyy_followup_template`;
TRUNCATE TABLE `wlyy_followup_template_plan`;
TRUNCATE TABLE `wlyy_followup_template_question`;
TRUNCATE TABLE `wlyy_followup_template_question_option`;
TRUNCATE TABLE `wlyy_friends_log`;
TRUNCATE TABLE `wlyy_group_chat_log`;
TRUNCATE TABLE `wlyy_health_edu_article`;
TRUNCATE TABLE `wlyy_health_edu_article_patient`;
TRUNCATE TABLE `wlyy_health_news`;
TRUNCATE TABLE `wlyy_inspect`;
TRUNCATE TABLE `wlyy_inspect_info`;
TRUNCATE TABLE `wlyy_intervene`;
TRUNCATE TABLE `wlyy_medical_edu_article`;
TRUNCATE TABLE `wlyy_medical_edu_article_read`;
TRUNCATE TABLE `wlyy_medical_edu_category`;
TRUNCATE TABLE `wlyy_medical_edu_setting`;
TRUNCATE TABLE `wlyy_message`;
TRUNCATE TABLE `wlyy_message_family_contract`;
TRUNCATE TABLE `wlyy_message_health_index`;
TRUNCATE TABLE `wlyy_orders`;
TRUNCATE TABLE `wlyy_orders_detail`;
TRUNCATE TABLE `wlyy_patient`;
TRUNCATE TABLE `wlyy_patient_course`;
TRUNCATE TABLE `wlyy_patient_device`;
TRUNCATE TABLE `wlyy_patient_family`;
TRUNCATE TABLE `wlyy_patient_friend`;
TRUNCATE TABLE `wlyy_patient_gift`;
TRUNCATE TABLE `wlyy_patient_group`;
TRUNCATE TABLE `wlyy_patient_group_info`;
TRUNCATE TABLE `wlyy_patient_health_guidance`;
TRUNCATE TABLE `wlyy_patient_health_index`;
TRUNCATE TABLE `wlyy_patient_health_record_diet`;
TRUNCATE TABLE `wlyy_patient_health_record_medication`;
TRUNCATE TABLE `wlyy_patient_health_record_sports`;
TRUNCATE TABLE `wlyy_patient_health_standard`;
TRUNCATE TABLE `wlyy_patient_inspection_suggest`;
TRUNCATE TABLE `wlyy_patient_medical_records`;
TRUNCATE TABLE `wlyy_patient_medical_records_item`;
TRUNCATE TABLE `wlyy_patient_orders`;
TRUNCATE TABLE `wlyy_patient_remind`;
TRUNCATE TABLE `wlyy_patient_reservation`;
TRUNCATE TABLE `wlyy_patient_reservation_doctors`;
TRUNCATE TABLE `wlyy_patient_self_inspection`;
TRUNCATE TABLE `wlyy_patient_self_inspection_item`;
TRUNCATE TABLE `wlyy_patient_treatment`;
TRUNCATE TABLE `wlyy_pharmacist`;
TRUNCATE TABLE `wlyy_pharmacist_checked`;
TRUNCATE TABLE `wlyy_points_gift`;
TRUNCATE TABLE `wlyy_points_record`;
TRUNCATE TABLE `wlyy_prescription`;
TRUNCATE TABLE `wlyy_prescription_continue`;
TRUNCATE TABLE `wlyy_prescription_info`;
TRUNCATE TABLE `wlyy_prescription_template`;
TRUNCATE TABLE `wlyy_prescription_template_info`;
TRUNCATE TABLE `wlyy_referral`;
TRUNCATE TABLE `wlyy_sign_contract`;
TRUNCATE TABLE `wlyy_sign_family`;
TRUNCATE TABLE `wlyy_sign_web`;
TRUNCATE TABLE `wlyy_sms`;
TRUNCATE TABLE `wlyy_token`;
TRUNCATE TABLE `wlyy_wx_patient`;
TRUNCATE TABLE `wx_access_token`;
TRUNCATE TABLE `wx_jsapi_ticket`;
TRUNCATE TABLE `wx_menu`;