From 279d50c151d14d04cb6680b10c82bf32b72968cb Mon Sep 17 00:00:00 2001 From: liusheng <337615773@qq.com> Date: 星期一, 09 十一月 2026 14:32:59 +0800 Subject: [PATCH] 撤销入库：cleanup_unused_tables_20260923.sql 不入库 --- /dev/null | 336 -------------------------------------------------------- .gitignore | 2 2 files changed, 2 insertions(+), 336 deletions(-) diff --git a/.gitignore b/.gitignore index 00a4493..c3caeda 100644 --- a/.gitignore +++ b/.gitignore @@ -32,6 +32,8 @@ # ==================== 涓�娆℃�ф帓鏌ヨ剼鏈� / 鎺㈤拡 / 鏃ュ織锛堜笉鍏ュ簱锛� ==================== sql/_probe/ +# 鍚� DROP TABLE 鐨勫巻鍙叉竻鐞嗚剼鏈紝浠呮湰鍦扮暀瀛橈紝涓嶅叆搴� +sql/cleanup_unused_tables_20260923.sql *.log _dbcheck.txt package-lock.json diff --git a/sql/cleanup_unused_tables_20260923.sql b/sql/cleanup_unused_tables_20260923.sql deleted file mode 100644 index 83ed367..0000000 --- a/sql/cleanup_unused_tables_20260923.sql +++ /dev/null @@ -1,336 +0,0 @@ --- ============================================================================ --- smartor_nhfy 鏁版嵁搴� 鏈娇鐢ㄨ〃娓呯悊鑴氭湰 --- 鐢熸垚鏃ユ湡: 20260923 --- 鏉ユ簮: 涓庝唬鐮佸叏閲忔瘮瀵癸紙178 涓� Mapper XML + 鍏ㄩ儴 Java 婧愮爜锛� --- 鑼冨洿: 132 寮犱唬鐮侀浂寮曠敤鐨勮〃锛堢┖琛� 110 寮� + 鏈夋暟鎹殑澶囦唤琛� 22 寮狅級 --- 娉ㄦ剰: 浠ヤ笅琛ㄥ凡琚帓闄わ紝璇峰嬁鍒犻櫎: --- * qrtz_* (Quartz 妗嗘灦琛紝杩愯鏃朵娇鐢�) --- * magic_config (magic-api 妗嗘灦琛�) --- * pat_med_outhosp_20260406 (鍒嗚〃鏈哄埗+瀛樺偍杩囩▼+瑙嗗浘 v_pat_med_outhosp 浣跨敤) --- ============================================================================ - --- ---------------------------------------------------------------------------- --- 銆愰噸瑕併�戞墽琛屽墠鍔″繀鍏堝浠姐�傛湰搴撶枒浼煎绯荤粺鍏辩敤锛屽缓璁厛纭鏃犲叾浠栫▼搴忚鍐欍�� --- 鏈夋暟鎹殑 22 寮犺〃寤鸿鍏堟墽琛屼笅鏂� mysqldump 澶囦唤锛� --- mysqldump -h192.168.99.192 -P3306 -uroot -p smartor_nhfy \ --- icd10_copy1 \ --- pat_archive-old \ --- pat_archive_copy1 \ --- pat_archive_copy6 \ --- pat_med_inhosp-old \ --- pat_med_inhosp_0710 \ --- pat_med_inhosp_0814 \ --- pat_med_inhosp_copy1 \ --- service_subtask_0710 \ --- service_subtask_copy1 \ --- service_subtask_copy2 \ --- service_subtask_copy3 \ --- service_subtask_copy4 \ --- service_subtask_copy5 \ --- service_subtask_detail_copy1 \ --- service_subtask_detail_copy2 \ --- service_task_260806 \ --- service_taskdept_260806 \ --- service_taskdiag_copy4 \ --- svy_lib_template_targetoption_copy1 \ --- svy_task_template_targetoption_copy1 \ --- sys_user-old --- > backup_unused_tables_20260923.sql --- ---------------------------------------------------------------------------- - -USE `smartor_nhfy`; -SET FOREIGN_KEY_CHECKS = 0; - --- ============================================================================ --- 绗� 0 閮ㄥ垎锛氶妫�鏌ワ紙鍙锛屼笉浼氭敼浠讳綍鏁版嵁锛� --- 璇存槑: information_schema.tables.table_rows 瀵� InnoDB 鏄及绠楀�硷紝 --- 涓嬮潰鐨� UNION ALL 鏄簿纭� COUNT锛屾墽琛屽悗搴旂湅鍒版墍鏈� cnt 鍧囦负 0銆� --- 鑻ユ煇琛� cnt > 0锛岃鏄庤琛ㄤ粛鏈夋暟鎹紝璇峰厛浠庛�岀 1 閮ㄥ垎銆嶄腑绉婚櫎璇ヨ〃鐨� DROP 璇彞銆� --- ============================================================================ -SELECT 'xxx' AS tbl, 0 AS cnt WHERE 1=0 -UNION ALL SELECT '_base_dept', COUNT(*) FROM `_base_dept` -UNION ALL SELECT '_base_dict', COUNT(*) FROM `_base_dict` -UNION ALL SELECT '_base_dict_item', COUNT(*) FROM `_base_dict_item` -UNION ALL SELECT '_base_dict_medarea', COUNT(*) FROM `_base_dict_medarea` -UNION ALL SELECT '_base_permission', COUNT(*) FROM `_base_permission` -UNION ALL SELECT '_base_permissionresources', COUNT(*) FROM `_base_permissionresources` -UNION ALL SELECT '_base_role', COUNT(*) FROM `_base_role` -UNION ALL SELECT 'ai_conversation', COUNT(*) FROM `ai_conversation` -UNION ALL SELECT 'ai_message', COUNT(*) FROM `ai_message` -UNION ALL SELECT 'base_applydisease', COUNT(*) FROM `base_applydisease` -UNION ALL SELECT 'base_dict_disease', COUNT(*) FROM `base_dict_disease` -UNION ALL SELECT 'base_dict_drug', COUNT(*) FROM `base_dict_drug` -UNION ALL SELECT 'base_dict_inspect', COUNT(*) FROM `base_dict_inspect` -UNION ALL SELECT 'base_dict_physicalpackage', COUNT(*) FROM `base_dict_physicalpackage` -UNION ALL SELECT 'base_dict_surgery', COUNT(*) FROM `base_dict_surgery` -UNION ALL SELECT 'base_dict_test', COUNT(*) FROM `base_dict_test` -UNION ALL SELECT 'base_person', COUNT(*) FROM `base_person` -UNION ALL SELECT 'base_pushtemplate', COUNT(*) FROM `base_pushtemplate` -UNION ALL SELECT 'base_scoringway', COUNT(*) FROM `base_scoringway` -UNION ALL SELECT 'base_scoringwaydetail', COUNT(*) FROM `base_scoringwaydetail` -UNION ALL SELECT 'base_sequence', COUNT(*) FROM `base_sequence` -UNION ALL SELECT 'base_taskvariable', COUNT(*) FROM `base_taskvariable` -UNION ALL SELECT 'base_template', COUNT(*) FROM `base_template` -UNION ALL SELECT 'base_templatecategory', COUNT(*) FROM `base_templatecategory` -UNION ALL SELECT 'base_wxaccount', COUNT(*) FROM `base_wxaccount` -UNION ALL SELECT 'bpbj', COUNT(*) FROM `bpbj` -UNION ALL SELECT 'chat_friend', COUNT(*) FROM `chat_friend` -UNION ALL SELECT 'chat_friend_group', COUNT(*) FROM `chat_friend_group` -UNION ALL SELECT 'chat_group_chat', COUNT(*) FROM `chat_group_chat` -UNION ALL SELECT 'chat_group_members', COUNT(*) FROM `chat_group_members` -UNION ALL SELECT 'chat_message', COUNT(*) FROM `chat_message` -UNION ALL SELECT 'chat_message_statistics', COUNT(*) FROM `chat_message_statistics` -UNION ALL SELECT 'chat_user', COUNT(*) FROM `chat_user` -UNION ALL SELECT 'crm_complaint', COUNT(*) FROM `crm_complaint` -UNION ALL SELECT 'cti_callseats', COUNT(*) FROM `cti_callseats` -UNION ALL SELECT 'dev_bug', COUNT(*) FROM `dev_bug` -UNION ALL SELECT 'dev_checkrecords', COUNT(*) FROM `dev_checkrecords` -UNION ALL SELECT 'dev_equipmentinfo', COUNT(*) FROM `dev_equipmentinfo` -UNION ALL SELECT 'dev_repairpl', COUNT(*) FROM `dev_repairpl` -UNION ALL SELECT 'dev_repairtype', COUNT(*) FROM `dev_repairtype` -UNION ALL SELECT 'dev_rprecords', COUNT(*) FROM `dev_rprecords` -UNION ALL SELECT 'flw_channel_definition', COUNT(*) FROM `flw_channel_definition` -UNION ALL SELECT 'flw_ev_databasechangelog', COUNT(*) FROM `flw_ev_databasechangelog` -UNION ALL SELECT 'flw_ev_databasechangeloglock', COUNT(*) FROM `flw_ev_databasechangeloglock` -UNION ALL SELECT 'flw_event_definition', COUNT(*) FROM `flw_event_definition` -UNION ALL SELECT 'flw_event_deployment', COUNT(*) FROM `flw_event_deployment` -UNION ALL SELECT 'flw_event_resource', COUNT(*) FROM `flw_event_resource` -UNION ALL SELECT 'flw_ru_batch', COUNT(*) FROM `flw_ru_batch` -UNION ALL SELECT 'flw_ru_batch_part', COUNT(*) FROM `flw_ru_batch_part` -UNION ALL SELECT 'ivr_task_singlerecords', COUNT(*) FROM `ivr_task_singlerecords` -UNION ALL SELECT 'ivr_taskdetail1', COUNT(*) FROM `ivr_taskdetail1` -UNION ALL SELECT 'pat_med_apointment', COUNT(*) FROM `pat_med_apointment` -UNION ALL SELECT 'pat_tube_feek', COUNT(*) FROM `pat_tube_feek` -UNION ALL SELECT 'pat_tube_feek_medicine', COUNT(*) FROM `pat_tube_feek_medicine` -UNION ALL SELECT 'patientinfo', COUNT(*) FROM `patientinfo` -UNION ALL SELECT 'questionnaire_advise', COUNT(*) FROM `questionnaire_advise` -UNION ALL SELECT 'questionnaire_question', COUNT(*) FROM `questionnaire_question` -UNION ALL SELECT 'questionnaire_questionnaire', COUNT(*) FROM `questionnaire_questionnaire` -UNION ALL SELECT 'questionnaire_questionoption', COUNT(*) FROM `questionnaire_questionoption` -UNION ALL SELECT 'questionnaire_questiontype', COUNT(*) FROM `questionnaire_questiontype` -UNION ALL SELECT 'questionnaire_result', COUNT(*) FROM `questionnaire_result` -UNION ALL SELECT 'questionnaire_resultdetail', COUNT(*) FROM `questionnaire_resultdetail` -UNION ALL SELECT 'questionnairequestion', COUNT(*) FROM `questionnairequestion` -UNION ALL SELECT 'questionnairequestionoption', COUNT(*) FROM `questionnairequestionoption` -UNION ALL SELECT 'scheme_taskrecord_callrecord', COUNT(*) FROM `scheme_taskrecord_callrecord` -UNION ALL SELECT 'service_scheme', COUNT(*) FROM `service_scheme` -UNION ALL SELECT 'service_taskdiagnose', COUNT(*) FROM `service_taskdiagnose` -UNION ALL SELECT 'sms_account', COUNT(*) FROM `sms_account` -UNION ALL SELECT 'soline', COUNT(*) FROM `soline` -UNION ALL SELECT 'sopaymentterm', COUNT(*) FROM `sopaymentterm` -UNION ALL SELECT 'student', COUNT(*) FROM `student` -UNION ALL SELECT 'svr_plan', COUNT(*) FROM `svr_plan` -UNION ALL SELECT 'svr_prj', COUNT(*) FROM `svr_prj` -UNION ALL SELECT 'svr_prjtask', COUNT(*) FROM `svr_prjtask` -UNION ALL SELECT 'svr_prjtaskline', COUNT(*) FROM `svr_prjtaskline` -UNION ALL SELECT 'svr_task', COUNT(*) FROM `svr_task` -UNION ALL SELECT 'svr_taskrecord', COUNT(*) FROM `svr_taskrecord` -UNION ALL SELECT 'svy_lib_resultrule', COUNT(*) FROM `svy_lib_resultrule` -UNION ALL SELECT 'svy_task_template_rule', COUNT(*) FROM `svy_task_template_rule` -UNION ALL SELECT 'sys_deploy_form', COUNT(*) FROM `sys_deploy_form` -UNION ALL SELECT 'sys_expression', COUNT(*) FROM `sys_expression` -UNION ALL SELECT 'sys_form', COUNT(*) FROM `sys_form` -UNION ALL SELECT 'sys_listener', COUNT(*) FROM `sys_listener` -UNION ALL SELECT 'sys_task_form', COUNT(*) FROM `sys_task_form` -UNION ALL SELECT 'sys_user_dept_import', COUNT(*) FROM `sys_user_dept_import` -UNION ALL SELECT 'sys_variable', COUNT(*) FROM `sys_variable` -UNION ALL SELECT 't_delid', COUNT(*) FROM `t_delid` -UNION ALL SELECT 'table_svy', COUNT(*) FROM `table_svy` -UNION ALL SELECT 'tabledesc', COUNT(*) FROM `tabledesc` -UNION ALL SELECT 'tools', COUNT(*) FROM `tools` -UNION ALL SELECT 'treatment_plan', COUNT(*) FROM `treatment_plan` -UNION ALL SELECT 'treatment_plandetail', COUNT(*) FROM `treatment_plandetail` -UNION ALL SELECT 'treatment_plantemplate', COUNT(*) FROM `treatment_plantemplate` -UNION ALL SELECT 'treatment_plantemplatedetail', COUNT(*) FROM `treatment_plantemplatedetail` -UNION ALL SELECT 'wechat_accesstoken', COUNT(*) FROM `wechat_accesstoken` -UNION ALL SELECT 'wechat_function', COUNT(*) FROM `wechat_function` -UNION ALL SELECT 'wechat_function_jumpurl', COUNT(*) FROM `wechat_function_jumpurl` -UNION ALL SELECT 'wechat_functiontype', COUNT(*) FROM `wechat_functiontype` -UNION ALL SELECT 'wechat_jssdk_ticket', COUNT(*) FROM `wechat_jssdk_ticket` -UNION ALL SELECT 'wechat_menu', COUNT(*) FROM `wechat_menu` -UNION ALL SELECT 'wechat_pay_success', COUNT(*) FROM `wechat_pay_success` -UNION ALL SELECT 'wechat_qrcode', COUNT(*) FROM `wechat_qrcode` -UNION ALL SELECT 'wechat_respmessage', COUNT(*) FROM `wechat_respmessage` -UNION ALL SELECT 'wechat_respmessage_key', COUNT(*) FROM `wechat_respmessage_key` -UNION ALL SELECT 'wechat_sendrecord', COUNT(*) FROM `wechat_sendrecord` -UNION ALL SELECT 'wechat_subscribeqrcode', COUNT(*) FROM `wechat_subscribeqrcode` -UNION ALL SELECT 'wechat_subscribesend', COUNT(*) FROM `wechat_subscribesend` -UNION ALL SELECT 'wechat_templatemessage_templatelist', COUNT(*) FROM `wechat_templatemessage_templatelist` -UNION ALL SELECT 'wechat_userinfo', COUNT(*) FROM `wechat_userinfo` -UNION ALL SELECT 'wechat_userinfo_subscribeinfo', COUNT(*) FROM `wechat_userinfo_subscribeinfo` -ORDER BY cnt DESC; - --- ============================================================================ --- 绗� 1 閮ㄥ垎锛氬垹闄ょ┖琛紙110 寮狅紝宸叉牳瀵瑰潎涓� 0 琛岋級 --- 浣跨敤 IF EXISTS锛屽彲閲嶅鎵ц锛屼笉浼氭姤閿� --- ============================================================================ -DROP TABLE IF EXISTS `_base_dept`; -DROP TABLE IF EXISTS `_base_dict`; -DROP TABLE IF EXISTS `_base_dict_item`; -DROP TABLE IF EXISTS `_base_dict_medarea`; -DROP TABLE IF EXISTS `_base_permission`; -DROP TABLE IF EXISTS `_base_permissionresources`; -DROP TABLE IF EXISTS `_base_role`; -DROP TABLE IF EXISTS `ai_conversation`; -DROP TABLE IF EXISTS `ai_message`; -DROP TABLE IF EXISTS `base_applydisease`; -DROP TABLE IF EXISTS `base_dict_disease`; -DROP TABLE IF EXISTS `base_dict_drug`; -DROP TABLE IF EXISTS `base_dict_inspect`; -DROP TABLE IF EXISTS `base_dict_physicalpackage`; -DROP TABLE IF EXISTS `base_dict_surgery`; -DROP TABLE IF EXISTS `base_dict_test`; -DROP TABLE IF EXISTS `base_person`; -DROP TABLE IF EXISTS `base_pushtemplate`; -DROP TABLE IF EXISTS `base_scoringway`; -DROP TABLE IF EXISTS `base_scoringwaydetail`; -DROP TABLE IF EXISTS `base_sequence`; -DROP TABLE IF EXISTS `base_taskvariable`; -DROP TABLE IF EXISTS `base_template`; -DROP TABLE IF EXISTS `base_templatecategory`; -DROP TABLE IF EXISTS `base_wxaccount`; -DROP TABLE IF EXISTS `bpbj`; -DROP TABLE IF EXISTS `chat_friend`; -DROP TABLE IF EXISTS `chat_friend_group`; -DROP TABLE IF EXISTS `chat_group_chat`; -DROP TABLE IF EXISTS `chat_group_members`; -DROP TABLE IF EXISTS `chat_message`; -DROP TABLE IF EXISTS `chat_message_statistics`; -DROP TABLE IF EXISTS `chat_user`; -DROP TABLE IF EXISTS `crm_complaint`; -DROP TABLE IF EXISTS `cti_callseats`; -DROP TABLE IF EXISTS `dev_bug`; -DROP TABLE IF EXISTS `dev_checkrecords`; -DROP TABLE IF EXISTS `dev_equipmentinfo`; -DROP TABLE IF EXISTS `dev_repairpl`; -DROP TABLE IF EXISTS `dev_repairtype`; -DROP TABLE IF EXISTS `dev_rprecords`; -DROP TABLE IF EXISTS `flw_channel_definition`; -DROP TABLE IF EXISTS `flw_ev_databasechangelog`; -DROP TABLE IF EXISTS `flw_ev_databasechangeloglock`; -DROP TABLE IF EXISTS `flw_event_definition`; -DROP TABLE IF EXISTS `flw_event_deployment`; -DROP TABLE IF EXISTS `flw_event_resource`; -DROP TABLE IF EXISTS `flw_ru_batch`; -DROP TABLE IF EXISTS `flw_ru_batch_part`; -DROP TABLE IF EXISTS `ivr_task_singlerecords`; -DROP TABLE IF EXISTS `ivr_taskdetail1`; -DROP TABLE IF EXISTS `pat_med_apointment`; -DROP TABLE IF EXISTS `pat_tube_feek`; -DROP TABLE IF EXISTS `pat_tube_feek_medicine`; -DROP TABLE IF EXISTS `patientinfo`; -DROP TABLE IF EXISTS `questionnaire_advise`; -DROP TABLE IF EXISTS `questionnaire_question`; -DROP TABLE IF EXISTS `questionnaire_questionnaire`; -DROP TABLE IF EXISTS `questionnaire_questionoption`; -DROP TABLE IF EXISTS `questionnaire_questiontype`; -DROP TABLE IF EXISTS `questionnaire_result`; -DROP TABLE IF EXISTS `questionnaire_resultdetail`; -DROP TABLE IF EXISTS `questionnairequestion`; -DROP TABLE IF EXISTS `questionnairequestionoption`; -DROP TABLE IF EXISTS `scheme_taskrecord_callrecord`; -DROP TABLE IF EXISTS `service_scheme`; -DROP TABLE IF EXISTS `service_taskdiagnose`; -DROP TABLE IF EXISTS `sms_account`; -DROP TABLE IF EXISTS `soline`; -DROP TABLE IF EXISTS `sopaymentterm`; -DROP TABLE IF EXISTS `student`; -DROP TABLE IF EXISTS `svr_plan`; -DROP TABLE IF EXISTS `svr_prj`; -DROP TABLE IF EXISTS `svr_prjtask`; -DROP TABLE IF EXISTS `svr_prjtaskline`; -DROP TABLE IF EXISTS `svr_task`; -DROP TABLE IF EXISTS `svr_taskrecord`; -DROP TABLE IF EXISTS `svy_lib_resultrule`; -DROP TABLE IF EXISTS `svy_task_template_rule`; -DROP TABLE IF EXISTS `sys_deploy_form`; -DROP TABLE IF EXISTS `sys_expression`; -DROP TABLE IF EXISTS `sys_form`; -DROP TABLE IF EXISTS `sys_listener`; -DROP TABLE IF EXISTS `sys_task_form`; -DROP TABLE IF EXISTS `sys_user_dept_import`; -DROP TABLE IF EXISTS `sys_variable`; -DROP TABLE IF EXISTS `t_delid`; -DROP TABLE IF EXISTS `table_svy`; -DROP TABLE IF EXISTS `tabledesc`; -DROP TABLE IF EXISTS `tools`; -DROP TABLE IF EXISTS `treatment_plan`; -DROP TABLE IF EXISTS `treatment_plandetail`; -DROP TABLE IF EXISTS `treatment_plantemplate`; -DROP TABLE IF EXISTS `treatment_plantemplatedetail`; -DROP TABLE IF EXISTS `wechat_accesstoken`; -DROP TABLE IF EXISTS `wechat_function`; -DROP TABLE IF EXISTS `wechat_function_jumpurl`; -DROP TABLE IF EXISTS `wechat_functiontype`; -DROP TABLE IF EXISTS `wechat_jssdk_ticket`; -DROP TABLE IF EXISTS `wechat_menu`; -DROP TABLE IF EXISTS `wechat_pay_success`; -DROP TABLE IF EXISTS `wechat_qrcode`; -DROP TABLE IF EXISTS `wechat_respmessage`; -DROP TABLE IF EXISTS `wechat_respmessage_key`; -DROP TABLE IF EXISTS `wechat_sendrecord`; -DROP TABLE IF EXISTS `wechat_subscribeqrcode`; -DROP TABLE IF EXISTS `wechat_subscribesend`; -DROP TABLE IF EXISTS `wechat_templatemessage_templatelist`; -DROP TABLE IF EXISTS `wechat_userinfo`; -DROP TABLE IF EXISTS `wechat_userinfo_subscribeinfo`; - --- ============================================================================ --- 绗� 2 閮ㄥ垎锛氭湁鏁版嵁鐨勫浠借〃锛�22 寮狅級 --- 涓哄畨鍏ㄨ捣瑙侊紝榛樿鍙仛銆屾敼鍚嶅綊妗ｃ�嶏紙鍙殢鏃舵敼鍥烇級锛岃瀵熶竴娈垫椂闂村悗鍐嶅垹闄わ細 --- * 褰掓。鍚庤〃鍚嶅墠缂�涓� zzz_del_锛屾帓鍦ㄥ簱鍒楄〃鏈熬锛屼笉褰卞搷涓氬姟 --- * 鎭㈠鏂规硶: RENAME TABLE `zzz_del_xxx_20260923` TO `xxx`; --- * 纭鏃犺鍚庯紝鎵ц鏈枃浠舵湯灏捐娉ㄩ噴鎺夌殑 DROP 璇彞褰诲簳鍒犻櫎 --- ============================================================================ -RENAME TABLE `icd10_copy1` TO `zzz_del_icd10_copy1_20260923`; -RENAME TABLE `pat_archive-old` TO `zzz_del_pat_archive-old_20260923`; -RENAME TABLE `pat_archive_copy1` TO `zzz_del_pat_archive_copy1_20260923`; -RENAME TABLE `pat_archive_copy6` TO `zzz_del_pat_archive_copy6_20260923`; -RENAME TABLE `pat_med_inhosp-old` TO `zzz_del_pat_med_inhosp-old_20260923`; -RENAME TABLE `pat_med_inhosp_0710` TO `zzz_del_pat_med_inhosp_0710_20260923`; -RENAME TABLE `pat_med_inhosp_0814` TO `zzz_del_pat_med_inhosp_0814_20260923`; -RENAME TABLE `pat_med_inhosp_copy1` TO `zzz_del_pat_med_inhosp_copy1_20260923`; -RENAME TABLE `service_subtask_0710` TO `zzz_del_service_subtask_0710_20260923`; -RENAME TABLE `service_subtask_copy1` TO `zzz_del_service_subtask_copy1_20260923`; -RENAME TABLE `service_subtask_copy2` TO `zzz_del_service_subtask_copy2_20260923`; -RENAME TABLE `service_subtask_copy3` TO `zzz_del_service_subtask_copy3_20260923`; -RENAME TABLE `service_subtask_copy4` TO `zzz_del_service_subtask_copy4_20260923`; -RENAME TABLE `service_subtask_copy5` TO `zzz_del_service_subtask_copy5_20260923`; -RENAME TABLE `service_subtask_detail_copy1` TO `zzz_del_service_subtask_detail_copy1_20260923`; -RENAME TABLE `service_subtask_detail_copy2` TO `zzz_del_service_subtask_detail_copy2_20260923`; -RENAME TABLE `service_task_260806` TO `zzz_del_service_task_260806_20260923`; -RENAME TABLE `service_taskdept_260806` TO `zzz_del_service_taskdept_260806_20260923`; -RENAME TABLE `service_taskdiag_copy4` TO `zzz_del_service_taskdiag_copy4_20260923`; -RENAME TABLE `svy_lib_template_targetoption_copy1` TO `zzz_del_svy_lib_template_targetoption_copy1_20260923`; -RENAME TABLE `svy_task_template_targetoption_copy1` TO `zzz_del_svy_task_template_targetoption_copy1_20260923`; -RENAME TABLE `sys_user-old` TO `zzz_del_sys_user-old_20260923`; - --- ---------------------------------------------------------------------------- --- 褰诲簳鍒犻櫎锛堣瀵熸湡缁撴潫銆佺‘璁ゅ綊妗ｆ棤璇悗锛屽彇娑堜笅闈㈡敞閲婃墽琛岋級 --- ---------------------------------------------------------------------------- --- DROP TABLE IF EXISTS `zzz_del_icd10_copy1_20260923`; --- DROP TABLE IF EXISTS `zzz_del_pat_archive-old_20260923`; --- DROP TABLE IF EXISTS `zzz_del_pat_archive_copy1_20260923`; --- DROP TABLE IF EXISTS `zzz_del_pat_archive_copy6_20260923`; --- DROP TABLE IF EXISTS `zzz_del_pat_med_inhosp-old_20260923`; --- DROP TABLE IF EXISTS `zzz_del_pat_med_inhosp_0710_20260923`; --- DROP TABLE IF EXISTS `zzz_del_pat_med_inhosp_0814_20260923`; --- DROP TABLE IF EXISTS `zzz_del_pat_med_inhosp_copy1_20260923`; --- DROP TABLE IF EXISTS `zzz_del_service_subtask_0710_20260923`; --- DROP TABLE IF EXISTS `zzz_del_service_subtask_copy1_20260923`; --- DROP TABLE IF EXISTS `zzz_del_service_subtask_copy2_20260923`; --- DROP TABLE IF EXISTS `zzz_del_service_subtask_copy3_20260923`; --- DROP TABLE IF EXISTS `zzz_del_service_subtask_copy4_20260923`; --- DROP TABLE IF EXISTS `zzz_del_service_subtask_copy5_20260923`; --- DROP TABLE IF EXISTS `zzz_del_service_subtask_detail_copy1_20260923`; --- DROP TABLE IF EXISTS `zzz_del_service_subtask_detail_copy2_20260923`; --- DROP TABLE IF EXISTS `zzz_del_service_task_260806_20260923`; --- DROP TABLE IF EXISTS `zzz_del_service_taskdept_260806_20260923`; --- DROP TABLE IF EXISTS `zzz_del_service_taskdiag_copy4_20260923`; --- DROP TABLE IF EXISTS `zzz_del_svy_lib_template_targetoption_copy1_20260923`; --- DROP TABLE IF EXISTS `zzz_del_svy_task_template_targetoption_copy1_20260923`; --- DROP TABLE IF EXISTS `zzz_del_sys_user-old_20260923`; - -SET FOREIGN_KEY_CHECKS = 1; - --- =============================== 鑴氭湰缁撴潫 ==================================== -- Gitblit v1.9.3