-- ============================================================================ -- ylrz_saas -> ylrz_saas_tenant 租户表迁移脚本 -- 生成时间: auto-generated -- 迁移表数: 398 -- 保留主库: 194 (admin=55, shared=139) -- 同实例跨库迁移，使用 CREATE TABLE ... LIKE + INSERT ... SELECT -- ============================================================================ -- ============================================================================ -- 第一阶段: CREATE TABLE (复制表结构) -- ============================================================================ -- --- ad_domain_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`ad_domain` LIKE `ylrz_saas`.`ad_domain`; -- --- ad_dy_* (2 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`ad_dy_account` LIKE `ylrz_saas`.`ad_dy_account`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`ad_dy_api` LIKE `ylrz_saas`.`ad_dy_api`; -- --- ad_html_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`ad_html_template` LIKE `ylrz_saas`.`ad_html_template`; -- --- ad_iqiyi_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`ad_iqiyi_account` LIKE `ylrz_saas`.`ad_iqiyi_account`; -- --- ad_site_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`ad_site` LIKE `ylrz_saas`.`ad_site`; -- --- ad_upload_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`ad_upload_log` LIKE `ylrz_saas`.`ad_upload_log`; -- --- ad_youku_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`ad_youku_account` LIKE `ylrz_saas`.`ad_youku_account`; -- --- ai_knowledge_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`ai_knowledge_base` LIKE `ylrz_saas`.`ai_knowledge_base`; -- --- bd_api_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`bd_api` LIKE `ylrz_saas`.`bd_api`; -- --- bd_creative_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`bd_creative_statistics` LIKE `ylrz_saas`.`bd_creative_statistics`; -- --- bd_report_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`bd_report_data` LIKE `ylrz_saas`.`bd_report_data`; -- --- chat_dataset_* (2 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`chat_dataset` LIKE `ylrz_saas`.`chat_dataset`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`chat_dataset_file` LIKE `ylrz_saas`.`chat_dataset_file`; -- --- chat_keyword_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`chat_keyword` LIKE `ylrz_saas`.`chat_keyword`; -- --- chat_msg_* (2 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`chat_msg` LIKE `ylrz_saas`.`chat_msg`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`chat_msg_logs` LIKE `ylrz_saas`.`chat_msg_logs`; -- --- chat_role_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`chat_role` LIKE `ylrz_saas`.`chat_role`; -- --- chat_session_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`chat_session` LIKE `ylrz_saas`.`chat_session`; -- --- chat_user_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`chat_user` LIKE `ylrz_saas`.`chat_user`; -- --- cid_ipad_* (2 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`cid_ipad_server` LIKE `ylrz_saas`.`cid_ipad_server`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`cid_ipad_server_user` LIKE `ylrz_saas`.`cid_ipad_server_user`; -- --- company_ai_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`company_ai_workflow_node_type` LIKE `ylrz_saas`.`company_ai_workflow_node_type`; -- --- company_company_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`company_company_fsuser` LIKE `ylrz_saas`.`company_company_fsuser`; -- --- company_deduct_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`company_deduct` LIKE `ylrz_saas`.`company_deduct`; -- --- company_div_* (2 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`company_div_config` LIKE `ylrz_saas`.`company_div_config`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`company_div_item` LIKE `ylrz_saas`.`company_div_item`; -- --- company_logininfor_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`company_logininfor` LIKE `ylrz_saas`.`company_logininfor`; -- --- company_miniapp_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`company_miniapp` LIKE `ylrz_saas`.`company_miniapp`; -- --- company_post_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`company_post` LIKE `ylrz_saas`.`company_post`; -- --- company_profit_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`company_profit_logs` LIKE `ylrz_saas`.`company_profit_logs`; -- --- company_recharge_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`company_recharge` LIKE `ylrz_saas`.`company_recharge`; -- --- company_role_* (2 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`company_role_dept` LIKE `ylrz_saas`.`company_role_dept`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`company_role_menu` LIKE `ylrz_saas`.`company_role_menu`; -- --- company_sop_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`company_sop_role` LIKE `ylrz_saas`.`company_sop_role`; -- --- company_tag_* (2 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`company_tag` LIKE `ylrz_saas`.`company_tag`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`company_tag_user` LIKE `ylrz_saas`.`company_tag_user`; -- --- company_tcm_* (3 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`company_tcm_consume` LIKE `ylrz_saas`.`company_tcm_consume`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`company_tcm_report` LIKE `ylrz_saas`.`company_tcm_report`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`company_tcm_schedule` LIKE `ylrz_saas`.`company_tcm_schedule`; -- --- company_user_* (5 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`company_user_card` LIKE `ylrz_saas`.`company_user_card`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`company_user_change_apply_user` LIKE `ylrz_saas`.`company_user_change_apply_user`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`company_user_delay_time` LIKE `ylrz_saas`.`company_user_delay_time`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`company_user_post` LIKE `ylrz_saas`.`company_user_post`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`company_user_user` LIKE `ylrz_saas`.`company_user_user`; -- --- company_voice_* (7 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`company_voice` LIKE `ylrz_saas`.`company_voice`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`company_voice_config` LIKE `ylrz_saas`.`company_voice_config`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`company_voice_dialog` LIKE `ylrz_saas`.`company_voice_dialog`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`company_voice_mobile` LIKE `ylrz_saas`.`company_voice_mobile`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`company_voice_package` LIKE `ylrz_saas`.`company_voice_package`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`company_voice_robotic_call_log_addwx` LIKE `ylrz_saas`.`company_voice_robotic_call_log_addwx`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`company_voice_robotic_call_log_sendmsg` LIKE `ylrz_saas`.`company_voice_robotic_call_log_sendmsg`; -- --- company_workflow_* (6 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`company_workflow_lobster` LIKE `ylrz_saas`.`company_workflow_lobster`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`company_workflow_lobster_edge` LIKE `ylrz_saas`.`company_workflow_lobster_edge`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`company_workflow_lobster_node` LIKE `ylrz_saas`.`company_workflow_lobster_node`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`company_workflow_lobster_record` LIKE `ylrz_saas`.`company_workflow_lobster_record`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`company_workflow_lobster_task` LIKE `ylrz_saas`.`company_workflow_lobster_task`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`company_workflow_lobster_variable` LIKE `ylrz_saas`.`company_workflow_lobster_variable`; -- --- company_wx_* (2 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`company_wx_chat` LIKE `ylrz_saas`.`company_wx_chat`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`company_wx_user_group` LIKE `ylrz_saas`.`company_wx_user_group`; -- --- crm_customer_* (8 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`crm_customer_analyze` LIKE `ylrz_saas`.`crm_customer_analyze`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`crm_customer_assign` LIKE `ylrz_saas`.`crm_customer_assign`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`crm_customer_contacts` LIKE `ylrz_saas`.`crm_customer_contacts`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`crm_customer_ext` LIKE `ylrz_saas`.`crm_customer_ext`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`crm_customer_his_order` LIKE `ylrz_saas`.`crm_customer_his_order`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`crm_customer_logs` LIKE `ylrz_saas`.`crm_customer_logs`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`crm_customer_third` LIKE `ylrz_saas`.`crm_customer_third`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`crm_customer_user` LIKE `ylrz_saas`.`crm_customer_user`; -- --- crm_event_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`crm_event` LIKE `ylrz_saas`.`crm_event`; -- --- crm_msg_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`crm_msg` LIKE `ylrz_saas`.`crm_msg`; -- --- customer_transfer_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`customer_transfer_approval` LIKE `ylrz_saas`.`customer_transfer_approval`; -- --- fastgpt_chat_* (6 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fastgpt_chat_artificial_words` LIKE `ylrz_saas`.`fastgpt_chat_artificial_words`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fastgpt_chat_keyword` LIKE `ylrz_saas`.`fastgpt_chat_keyword`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fastgpt_chat_msg_logs` LIKE `ylrz_saas`.`fastgpt_chat_msg_logs`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fastgpt_chat_replace_text` LIKE `ylrz_saas`.`fastgpt_chat_replace_text`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fastgpt_chat_replace_words` LIKE `ylrz_saas`.`fastgpt_chat_replace_words`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fastgpt_chat_voice_homo` LIKE `ylrz_saas`.`fastgpt_chat_voice_homo`; -- --- fastgpt_collection_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fastgpt_collection` LIKE `ylrz_saas`.`fastgpt_collection`; -- --- fastgpt_collention_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fastgpt_collention_data` LIKE `ylrz_saas`.`fastgpt_collention_data`; -- --- fastgpt_dataset_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fastgpt_dataset` LIKE `ylrz_saas`.`fastgpt_dataset`; -- --- fastgpt_event_* (2 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fastgpt_event_log` LIKE `ylrz_saas`.`fastgpt_event_log`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fastgpt_event_log_total` LIKE `ylrz_saas`.`fastgpt_event_log_total`; -- --- fastgpt_ext_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fastgpt_ext_user_tag` LIKE `ylrz_saas`.`fastgpt_ext_user_tag`; -- --- fastgpt_keyword_* (3 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fastgpt_keyword` LIKE `ylrz_saas`.`fastgpt_keyword`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fastgpt_keyword_artificial` LIKE `ylrz_saas`.`fastgpt_keyword_artificial`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fastgpt_keyword_send` LIKE `ylrz_saas`.`fastgpt_keyword_send`; -- --- fastgpt_push_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fastgpt_push_token_total` LIKE `ylrz_saas`.`fastgpt_push_token_total`; -- --- fastgpt_role_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fastgpt_role_tag` LIKE `ylrz_saas`.`fastgpt_role_tag`; -- --- fastgpt_tag_* (2 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fastgpt_tag` LIKE `ylrz_saas`.`fastgpt_tag`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fastgpt_tag_group` LIKE `ylrz_saas`.`fastgpt_tag_group`; -- --- fastgpt_user_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fastgpt_user` LIKE `ylrz_saas`.`fastgpt_user`; -- --- fs_adv_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_adv_sem` LIKE `ylrz_saas`.`fs_adv_sem`; -- --- fs_ai_* (2 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_ai_workflow_edge` LIKE `ylrz_saas`.`fs_ai_workflow_edge`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_ai_workflow_node_type` LIKE `ylrz_saas`.`fs_ai_workflow_node_type`; -- --- fs_app_* (2 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_app_contact_way` LIKE `ylrz_saas`.`fs_app_contact_way`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_app_version` LIKE `ylrz_saas`.`fs_app_version`; -- --- fs_article_* (3 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_article` LIKE `ylrz_saas`.`fs_article`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_article_cate` LIKE `ylrz_saas`.`fs_article_cate`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_article_views` LIKE `ylrz_saas`.`fs_article_views`; -- --- fs_chinese_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_chinese_medicine` LIKE `ylrz_saas`.`fs_chinese_medicine`; -- --- fs_city_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_city` LIKE `ylrz_saas`.`fs_city`; -- --- fs_complaint_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_complaint_template` LIKE `ylrz_saas`.`fs_complaint_template`; -- --- fs_coupon_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_coupon` LIKE `ylrz_saas`.`fs_coupon`; -- --- fs_course_* (12 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_course_domain_name` LIKE `ylrz_saas`.`fs_course_domain_name`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_course_finish_temp` LIKE `ylrz_saas`.`fs_course_finish_temp`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_course_finish_temp_parent` LIKE `ylrz_saas`.`fs_course_finish_temp_parent`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_course_link` LIKE `ylrz_saas`.`fs_course_link`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_course_product` LIKE `ylrz_saas`.`fs_course_product`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_course_product_order` LIKE `ylrz_saas`.`fs_course_product_order`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_course_question_bank` LIKE `ylrz_saas`.`fs_course_question_bank`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_course_question_category` LIKE `ylrz_saas`.`fs_course_question_category`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_course_sop` LIKE `ylrz_saas`.`fs_course_sop`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_course_sop_app_link` LIKE `ylrz_saas`.`fs_course_sop_app_link`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_course_sop_logs` LIKE `ylrz_saas`.`fs_course_sop_logs`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_course_watch_comment` LIKE `ylrz_saas`.`fs_course_watch_comment`; -- --- fs_df_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_df_account` LIKE `ylrz_saas`.`fs_df_account`; -- --- fs_disease_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_disease` LIKE `ylrz_saas`.`fs_disease`; -- --- fs_doctor_* (14 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_doctor_ai_chat_log` LIKE `ylrz_saas`.`fs_doctor_ai_chat_log`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_doctor_ai_chat_msg` LIKE `ylrz_saas`.`fs_doctor_ai_chat_msg`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_doctor_ai_chat_session` LIKE `ylrz_saas`.`fs_doctor_ai_chat_session`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_doctor_article` LIKE `ylrz_saas`.`fs_doctor_article`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_doctor_article_cate` LIKE `ylrz_saas`.`fs_doctor_article_cate`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_doctor_bill` LIKE `ylrz_saas`.`fs_doctor_bill`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_doctor_confirm` LIKE `ylrz_saas`.`fs_doctor_confirm`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_doctor_extract` LIKE `ylrz_saas`.`fs_doctor_extract`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_doctor_oper_log` LIKE `ylrz_saas`.`fs_doctor_oper_log`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_doctor_prescribe` LIKE `ylrz_saas`.`fs_doctor_prescribe`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_doctor_prescribe_drug` LIKE `ylrz_saas`.`fs_doctor_prescribe_drug`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_doctor_price` LIKE `ylrz_saas`.`fs_doctor_price`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_doctor_product` LIKE `ylrz_saas`.`fs_doctor_product`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_doctor_words` LIKE `ylrz_saas`.`fs_doctor_words`; -- --- fs_drug_* (2 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_drug_report` LIKE `ylrz_saas`.`fs_drug_report`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_drug_report_count` LIKE `ylrz_saas`.`fs_drug_report_count`; -- --- fs_express_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_express` LIKE `ylrz_saas`.`fs_express`; -- --- fs_famous_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_famous_prescribe` LIKE `ylrz_saas`.`fs_famous_prescribe`; -- --- fs_finish_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_finish_course_statistics_sync` LIKE `ylrz_saas`.`fs_finish_course_statistics_sync`; -- --- fs_first_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_first_diagnosis` LIKE `ylrz_saas`.`fs_first_diagnosis`; -- --- fs_follow_* (3 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_follow` LIKE `ylrz_saas`.`fs_follow`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_follow_report` LIKE `ylrz_saas`.`fs_follow_report`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_follow_temp` LIKE `ylrz_saas`.`fs_follow_temp`; -- --- fs_health_* (5 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_health_data` LIKE `ylrz_saas`.`fs_health_data`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_health_history_temp` LIKE `ylrz_saas`.`fs_health_history_temp`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_health_life` LIKE `ylrz_saas`.`fs_health_life`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_health_record` LIKE `ylrz_saas`.`fs_health_record`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_health_tongue` LIKE `ylrz_saas`.`fs_health_tongue`; -- --- fs_hfpay_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_hfpay_config` LIKE `ylrz_saas`.`fs_hfpay_config`; -- --- fs_icd_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_icd` LIKE `ylrz_saas`.`fs_icd`; -- --- fs_illness_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_illness_library` LIKE `ylrz_saas`.`fs_illness_library`; -- --- fs_im_* (2 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_im_msg_send_detail` LIKE `ylrz_saas`.`fs_im_msg_send_detail`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_im_msg_send_log` LIKE `ylrz_saas`.`fs_im_msg_send_log`; -- --- fs_inquiry_* (7 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_inquiry_disease` LIKE `ylrz_saas`.`fs_inquiry_disease`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_inquiry_order_logs` LIKE `ylrz_saas`.`fs_inquiry_order_logs`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_inquiry_order_media` LIKE `ylrz_saas`.`fs_inquiry_order_media`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_inquiry_order_msg` LIKE `ylrz_saas`.`fs_inquiry_order_msg`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_inquiry_order_ping` LIKE `ylrz_saas`.`fs_inquiry_order_ping`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_inquiry_patient_info` LIKE `ylrz_saas`.`fs_inquiry_patient_info`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_inquiry_temp` LIKE `ylrz_saas`.`fs_inquiry_temp`; -- --- fs_integral_* (3 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_integral_cart` LIKE `ylrz_saas`.`fs_integral_cart`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_integral_order` LIKE `ylrz_saas`.`fs_integral_order`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_integral_order_logs` LIKE `ylrz_saas`.`fs_integral_order_logs`; -- --- fs_interest_* (4 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_interest_ai_msg` LIKE `ylrz_saas`.`fs_interest_ai_msg`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_interest_ai_role` LIKE `ylrz_saas`.`fs_interest_ai_role`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_interest_ai_role_words` LIKE `ylrz_saas`.`fs_interest_ai_role_words`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_interest_ai_session` LIKE `ylrz_saas`.`fs_interest_ai_session`; -- --- fs_material_* (2 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_material` LIKE `ylrz_saas`.`fs_material`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_material_group` LIKE `ylrz_saas`.`fs_material_group`; -- --- fs_medicated_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_medicated_food` LIKE `ylrz_saas`.`fs_medicated_food`; -- --- fs_mess_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_mess_temp` LIKE `ylrz_saas`.`fs_mess_temp`; -- --- fs_package_* (3 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_package_cate` LIKE `ylrz_saas`.`fs_package_cate`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_package_favorite` LIKE `ylrz_saas`.`fs_package_favorite`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_package_solar_term` LIKE `ylrz_saas`.`fs_package_solar_term`; -- --- fs_physical_* (2 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_physical_report_template` LIKE `ylrz_saas`.`fs_physical_report_template`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_physical_report_template_field` LIKE `ylrz_saas`.`fs_physical_report_template_field`; -- --- fs_prescribe_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_prescribe` LIKE `ylrz_saas`.`fs_prescribe`; -- --- fs_promotional_* (2 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_promotional_active` LIKE `ylrz_saas`.`fs_promotional_active`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_promotional_active_log` LIKE `ylrz_saas`.`fs_promotional_active_log`; -- --- fs_question_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_question_and_answer` LIKE `ylrz_saas`.`fs_question_and_answer`; -- --- fs_questions_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_questions` LIKE `ylrz_saas`.`fs_questions`; -- --- fs_statis_* (5 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_statis_qw_temp_param` LIKE `ylrz_saas`.`fs_statis_qw_temp_param`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_statis_qw_watch` LIKE `ylrz_saas`.`fs_statis_qw_watch`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_statis_saler_watch` LIKE `ylrz_saas`.`fs_statis_saler_watch`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_statis_temp_fsuser` LIKE `ylrz_saas`.`fs_statis_temp_fsuser`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_statis_temp_param` LIKE `ylrz_saas`.`fs_statis_temp_param`; -- --- fs_statistics_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_statistics` LIKE `ylrz_saas`.`fs_statistics`; -- --- fs_store_* (40 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_store` LIKE `ylrz_saas`.`fs_store`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_store_activity` LIKE `ylrz_saas`.`fs_store_activity`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_store_activity_scrm` LIKE `ylrz_saas`.`fs_store_activity_scrm`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_store_after_sales` LIKE `ylrz_saas`.`fs_store_after_sales`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_store_after_sales_item` LIKE `ylrz_saas`.`fs_store_after_sales_item`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_store_after_sales_logs` LIKE `ylrz_saas`.`fs_store_after_sales_logs`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_store_after_sales_logs_scrm` LIKE `ylrz_saas`.`fs_store_after_sales_logs_scrm`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_store_bill` LIKE `ylrz_saas`.`fs_store_bill`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_store_bill_scrm` LIKE `ylrz_saas`.`fs_store_bill_scrm`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_store_canvas_scrm` LIKE `ylrz_saas`.`fs_store_canvas_scrm`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_store_cart_scrm` LIKE `ylrz_saas`.`fs_store_cart_scrm`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_store_coupon_issue_scrm` LIKE `ylrz_saas`.`fs_store_coupon_issue_scrm`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_store_coupon_issue_user_scrm` LIKE `ylrz_saas`.`fs_store_coupon_issue_user_scrm`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_store_coupon_scrm` LIKE `ylrz_saas`.`fs_store_coupon_scrm`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_store_coupon_user_scrm` LIKE `ylrz_saas`.`fs_store_coupon_user_scrm`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_store_extract` LIKE `ylrz_saas`.`fs_store_extract`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_store_order_audit_scrm` LIKE `ylrz_saas`.`fs_store_order_audit_scrm`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_store_order_bill_log` LIKE `ylrz_saas`.`fs_store_order_bill_log`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_store_order_logs` LIKE `ylrz_saas`.`fs_store_order_logs`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_store_order_logs_scrm` LIKE `ylrz_saas`.`fs_store_order_logs_scrm`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_store_order_notice_scrm` LIKE `ylrz_saas`.`fs_store_order_notice_scrm`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_store_payment_error` LIKE `ylrz_saas`.`fs_store_payment_error`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_store_product` LIKE `ylrz_saas`.`fs_store_product`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_store_product_attr` LIKE `ylrz_saas`.`fs_store_product_attr`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_store_product_attr_scrm` LIKE `ylrz_saas`.`fs_store_product_attr_scrm`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_store_product_attr_value` LIKE `ylrz_saas`.`fs_store_product_attr_value`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_store_product_category` LIKE `ylrz_saas`.`fs_store_product_category`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_store_product_details_scrm` LIKE `ylrz_saas`.`fs_store_product_details_scrm`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_store_product_group` LIKE `ylrz_saas`.`fs_store_product_group`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_store_product_group_scrm` LIKE `ylrz_saas`.`fs_store_product_group_scrm`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_store_product_package` LIKE `ylrz_saas`.`fs_store_product_package`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_store_product_purchase_limit_scrm` LIKE `ylrz_saas`.`fs_store_product_purchase_limit_scrm`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_store_product_relation_scrm` LIKE `ylrz_saas`.`fs_store_product_relation_scrm`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_store_product_reply_scrm` LIKE `ylrz_saas`.`fs_store_product_reply_scrm`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_store_product_rule_scrm` LIKE `ylrz_saas`.`fs_store_product_rule_scrm`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_store_product_template_scrm` LIKE `ylrz_saas`.`fs_store_product_template_scrm`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_store_recommend_scrm` LIKE `ylrz_saas`.`fs_store_recommend_scrm`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_store_shop_staff_scrm` LIKE `ylrz_saas`.`fs_store_shop_staff_scrm`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_store_sub_order` LIKE `ylrz_saas`.`fs_store_sub_order`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_store_visit_scrm` LIKE `ylrz_saas`.`fs_store_visit_scrm`; -- --- fs_test_* (3 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_test_report` LIKE `ylrz_saas`.`fs_test_report`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_test_temp` LIKE `ylrz_saas`.`fs_test_temp`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_test_temp_item` LIKE `ylrz_saas`.`fs_test_temp_item`; -- --- fs_tongue_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_tongue_info` LIKE `ylrz_saas`.`fs_tongue_info`; -- --- fs_user_* (51 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_address` LIKE `ylrz_saas`.`fs_user_address`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_bill` LIKE `ylrz_saas`.`fs_user_bill`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_company_bind` LIKE `ylrz_saas`.`fs_user_company_bind`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_company_package_scrm` LIKE `ylrz_saas`.`fs_user_company_package_scrm`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_company_user` LIKE `ylrz_saas`.`fs_user_company_user`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_company_user_qw` LIKE `ylrz_saas`.`fs_user_company_user_qw`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_complaint` LIKE `ylrz_saas`.`fs_user_complaint`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_complaint_msg` LIKE `ylrz_saas`.`fs_user_complaint_msg`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_course_comment` LIKE `ylrz_saas`.`fs_user_course_comment`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_course_comment_like` LIKE `ylrz_saas`.`fs_user_course_comment_like`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_course_company_statistics` LIKE `ylrz_saas`.`fs_user_course_company_statistics`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_course_complaint_record` LIKE `ylrz_saas`.`fs_user_course_complaint_record`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_course_complaint_type` LIKE `ylrz_saas`.`fs_user_course_complaint_type`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_course_count` LIKE `ylrz_saas`.`fs_user_course_count`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_course_favorite` LIKE `ylrz_saas`.`fs_user_course_favorite`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_course_follow` LIKE `ylrz_saas`.`fs_user_course_follow`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_course_like` LIKE `ylrz_saas`.`fs_user_course_like`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_course_note` LIKE `ylrz_saas`.`fs_user_course_note`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_course_note_like` LIKE `ylrz_saas`.`fs_user_course_note_like`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_course_note_save` LIKE `ylrz_saas`.`fs_user_course_note_save`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_course_order` LIKE `ylrz_saas`.`fs_user_course_order`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_course_study` LIKE `ylrz_saas`.`fs_user_course_study`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_course_study_log` LIKE `ylrz_saas`.`fs_user_course_study_log`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_course_video_red_package` LIKE `ylrz_saas`.`fs_user_course_video_red_package`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_doctor` LIKE `ylrz_saas`.`fs_user_doctor`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_extract` LIKE `ylrz_saas`.`fs_user_extract`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_information_collection_schedule` LIKE `ylrz_saas`.`fs_user_information_collection_schedule`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_integral_logs` LIKE `ylrz_saas`.`fs_user_integral_logs`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_invited` LIKE `ylrz_saas`.`fs_user_invited`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_login_log` LIKE `ylrz_saas`.`fs_user_login_log`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_new_task` LIKE `ylrz_saas`.`fs_user_new_task`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_online_state` LIKE `ylrz_saas`.`fs_user_online_state`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_operation_log` LIKE `ylrz_saas`.`fs_user_operation_log`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_project_tag` LIKE `ylrz_saas`.`fs_user_project_tag`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_recharge` LIKE `ylrz_saas`.`fs_user_recharge`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_sign` LIKE `ylrz_saas`.`fs_user_sign`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_talent` LIKE `ylrz_saas`.`fs_user_talent`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_talent_follow` LIKE `ylrz_saas`.`fs_user_talent_follow`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_video` LIKE `ylrz_saas`.`fs_user_video`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_video_comment` LIKE `ylrz_saas`.`fs_user_video_comment`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_video_comment_like` LIKE `ylrz_saas`.`fs_user_video_comment_like`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_video_favorite` LIKE `ylrz_saas`.`fs_user_video_favorite`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_video_like` LIKE `ylrz_saas`.`fs_user_video_like`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_video_tags` LIKE `ylrz_saas`.`fs_user_video_tags`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_video_view` LIKE `ylrz_saas`.`fs_user_video_view`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_vip_order` LIKE `ylrz_saas`.`fs_user_vip_order`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_vip_package` LIKE `ylrz_saas`.`fs_user_vip_package`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_watch` LIKE `ylrz_saas`.`fs_user_watch`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_watch_course_statistics` LIKE `ylrz_saas`.`fs_user_watch_course_statistics`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_watch_statistics` LIKE `ylrz_saas`.`fs_user_watch_statistics`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_user_wx` LIKE `ylrz_saas`.`fs_user_wx`; -- --- fs_vessel_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_vessel` LIKE `ylrz_saas`.`fs_vessel`; -- --- fs_video_* (3 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_video_barrage` LIKE `ylrz_saas`.`fs_video_barrage`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_video_course_tag` LIKE `ylrz_saas`.`fs_video_course_tag`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_video_resource` LIKE `ylrz_saas`.`fs_video_resource`; -- --- fs_wechat_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`fs_wechat_template` LIKE `ylrz_saas`.`fs_wechat_template`; -- --- hy_watch_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`hy_watch_log` LIKE `ylrz_saas`.`hy_watch_log`; -- --- hy_work_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`hy_work_task` LIKE `ylrz_saas`.`hy_work_task`; -- --- ipad_allocation_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`ipad_allocation_records` LIKE `ylrz_saas`.`ipad_allocation_records`; -- --- live_after_* (3 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`live_after_sales` LIKE `ylrz_saas`.`live_after_sales`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`live_after_sales_item` LIKE `ylrz_saas`.`live_after_sales_item`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`live_after_sales_logs` LIKE `ylrz_saas`.`live_after_sales_logs`; -- --- live_anchor_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`live_anchor` LIKE `ylrz_saas`.`live_anchor`; -- --- live_auto_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`live_auto_task` LIKE `ylrz_saas`.`live_auto_task`; -- --- live_cart_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`live_cart` LIKE `ylrz_saas`.`live_cart`; -- --- live_completion_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`live_completion_points_record` LIKE `ylrz_saas`.`live_completion_points_record`; -- --- live_coupon_* (5 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`live_coupon` LIKE `ylrz_saas`.`live_coupon`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`live_coupon_issue` LIKE `ylrz_saas`.`live_coupon_issue`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`live_coupon_issue_relation` LIKE `ylrz_saas`.`live_coupon_issue_relation`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`live_coupon_issue_user` LIKE `ylrz_saas`.`live_coupon_issue_user`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`live_coupon_user` LIKE `ylrz_saas`.`live_coupon_user`; -- --- live_data_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`live_data` LIKE `ylrz_saas`.`live_data`; -- --- live_event_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`live_event_conf` LIKE `ylrz_saas`.`live_event_conf`; -- --- live_gift_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`live_gift` LIKE `ylrz_saas`.`live_gift`; -- --- live_goods_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`live_goods` LIKE `ylrz_saas`.`live_goods`; -- --- live_lottery_* (3 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`live_lottery_conf` LIKE `ylrz_saas`.`live_lottery_conf`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`live_lottery_product_conf` LIKE `ylrz_saas`.`live_lottery_product_conf`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`live_lottery_registration` LIKE `ylrz_saas`.`live_lottery_registration`; -- --- live_msg_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`live_msg` LIKE `ylrz_saas`.`live_msg`; -- --- live_order_* (2 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`live_order_logs` LIKE `ylrz_saas`.`live_order_logs`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`live_order_payment_error` LIKE `ylrz_saas`.`live_order_payment_error`; -- --- live_red_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`live_red_conf` LIKE `ylrz_saas`.`live_red_conf`; -- --- live_reward_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`live_reward_record` LIKE `ylrz_saas`.`live_reward_record`; -- --- live_sensitive_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`live_sensitive_words` LIKE `ylrz_saas`.`live_sensitive_words`; -- --- live_tag_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`live_tag_config` LIKE `ylrz_saas`.`live_tag_config`; -- --- live_traffic_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`live_traffic_log` LIKE `ylrz_saas`.`live_traffic_log`; -- --- live_user_* (6 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`live_user_favorite` LIKE `ylrz_saas`.`live_user_favorite`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`live_user_first_entry` LIKE `ylrz_saas`.`live_user_first_entry`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`live_user_follow` LIKE `ylrz_saas`.`live_user_follow`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`live_user_like` LIKE `ylrz_saas`.`live_user_like`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`live_user_lottery_record` LIKE `ylrz_saas`.`live_user_lottery_record`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`live_user_red_record` LIKE `ylrz_saas`.`live_user_red_record`; -- --- live_watch_* (2 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`live_watch_log` LIKE `ylrz_saas`.`live_watch_log`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`live_watch_user` LIKE `ylrz_saas`.`live_watch_user`; -- --- lobster_compliance_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`lobster_compliance_rule` LIKE `ylrz_saas`.`lobster_compliance_rule`; -- --- lobster_conversation_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`lobster_conversation_summary` LIKE `ylrz_saas`.`lobster_conversation_summary`; -- --- lobster_node_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`lobster_node_execution_log` LIKE `ylrz_saas`.`lobster_node_execution_log`; -- --- lobster_workflow_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`lobster_workflow_instance` LIKE `ylrz_saas`.`lobster_workflow_instance`; -- --- lucky_bag_* (2 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`lucky_bag` LIKE `ylrz_saas`.`lucky_bag`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`lucky_bag_collect_record` LIKE `ylrz_saas`.`lucky_bag_collect_record`; -- --- qw_app_* (2 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_app_contact_way` LIKE `ylrz_saas`.`qw_app_contact_way`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_app_contact_way_logs` LIKE `ylrz_saas`.`qw_app_contact_way_logs`; -- --- qw_auto_* (3 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_auto_tags` LIKE `ylrz_saas`.`qw_auto_tags`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_auto_tags_logs` LIKE `ylrz_saas`.`qw_auto_tags_logs`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_auto_tags_rules` LIKE `ylrz_saas`.`qw_auto_tags_rules`; -- --- qw_contact_* (5 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_contact_batch` LIKE `ylrz_saas`.`qw_contact_batch`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_contact_way` LIKE `ylrz_saas`.`qw_contact_way`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_contact_way_group` LIKE `ylrz_saas`.`qw_contact_way_group`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_contact_way_logs` LIKE `ylrz_saas`.`qw_contact_way_logs`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_contact_way_user` LIKE `ylrz_saas`.`qw_contact_way_user`; -- --- qw_course_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_course_finish_remark_rty` LIKE `ylrz_saas`.`qw_course_finish_remark_rty`; -- --- qw_customer_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_customer_property` LIKE `ylrz_saas`.`qw_customer_property`; -- --- qw_drainage_* (2 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_drainage_link` LIKE `ylrz_saas`.`qw_drainage_link`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_drainage_link_logs` LIKE `ylrz_saas`.`qw_drainage_link_logs`; -- --- qw_external_* (7 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_external_ai_analyze` LIKE `ylrz_saas`.`qw_external_ai_analyze`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_external_contact_black_log` LIKE `ylrz_saas`.`qw_external_contact_black_log`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_external_contact_crm` LIKE `ylrz_saas`.`qw_external_contact_crm`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_external_contact_transfer_company_audit` LIKE `ylrz_saas`.`qw_external_contact_transfer_company_audit`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_external_contact_transfer_company_audit_user` LIKE `ylrz_saas`.`qw_external_contact_transfer_company_audit_user`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_external_contact_transfer_log` LIKE `ylrz_saas`.`qw_external_contact_transfer_log`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_external_err_retry` LIKE `ylrz_saas`.`qw_external_err_retry`; -- --- qw_friend_* (6 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_friend_circle` LIKE `ylrz_saas`.`qw_friend_circle`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_friend_circle_task` LIKE `ylrz_saas`.`qw_friend_circle_task`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_friend_comments` LIKE `ylrz_saas`.`qw_friend_comments`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_friend_customer_list` LIKE `ylrz_saas`.`qw_friend_customer_list`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_friend_welcome` LIKE `ylrz_saas`.`qw_friend_welcome`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_friend_welcome_item` LIKE `ylrz_saas`.`qw_friend_welcome_item`; -- --- qw_group_* (5 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_group_chat` LIKE `ylrz_saas`.`qw_group_chat`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_group_chat_transfer_log` LIKE `ylrz_saas`.`qw_group_chat_transfer_log`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_group_msg` LIKE `ylrz_saas`.`qw_group_msg`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_group_msg_item` LIKE `ylrz_saas`.`qw_group_msg_item`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_group_msg_user` LIKE `ylrz_saas`.`qw_group_msg_user`; -- --- qw_groupchat_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_groupchat_statistic` LIKE `ylrz_saas`.`qw_groupchat_statistic`; -- --- qw_information_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_information` LIKE `ylrz_saas`.`qw_information`; -- --- qw_ipad_* (3 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_ipad_server` LIKE `ylrz_saas`.`qw_ipad_server`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_ipad_server_log` LIKE `ylrz_saas`.`qw_ipad_server_log`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_ipad_server_user` LIKE `ylrz_saas`.`qw_ipad_server_user`; -- --- qw_material_* (2 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_material` LIKE `ylrz_saas`.`qw_material`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_material_group` LIKE `ylrz_saas`.`qw_material_group`; -- --- qw_messages_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_messages` LIKE `ylrz_saas`.`qw_messages`; -- --- qw_msg_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_msg` LIKE `ylrz_saas`.`qw_msg`; -- --- qw_push_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_push_count` LIKE `ylrz_saas`.`qw_push_count`; -- --- qw_session_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_session` LIKE `ylrz_saas`.`qw_session`; -- --- qw_sop_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_sop_logs_detalis` LIKE `ylrz_saas`.`qw_sop_logs_detalis`; -- --- qw_tag_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_tag_group` LIKE `ylrz_saas`.`qw_tag_group`; -- --- qw_user_* (3 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_user_complain_record` LIKE `ylrz_saas`.`qw_user_complain_record`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_user_video` LIKE `ylrz_saas`.`qw_user_video`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_user_voice_log` LIKE `ylrz_saas`.`qw_user_voice_log`; -- --- qw_userbehavior_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_userbehavior_data` LIKE `ylrz_saas`.`qw_userbehavior_data`; -- --- qw_welcome_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_welcome` LIKE `ylrz_saas`.`qw_welcome`; -- --- qw_work_* (3 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_work_link` LIKE `ylrz_saas`.`qw_work_link`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_work_link_user` LIKE `ylrz_saas`.`qw_work_link_user`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`qw_work_user` LIKE `ylrz_saas`.`qw_work_user`; -- --- tulin_info_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`tulin_info_sync_log` LIKE `ylrz_saas`.`tulin_info_sync_log`; -- --- uni_push_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`uni_push_log` LIKE `ylrz_saas`.`uni_push_log`; -- --- watch_beginner_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`watch_beginner_guide` LIKE `ylrz_saas`.`watch_beginner_guide`; -- --- watch_device_* (4 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`watch_device_account` LIKE `ylrz_saas`.`watch_device_account`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`watch_device_day` LIKE `ylrz_saas`.`watch_device_day`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`watch_device_info` LIKE `ylrz_saas`.`watch_device_info`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`watch_device_setup` LIKE `ylrz_saas`.`watch_device_setup`; -- --- watch_family_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`watch_family_user` LIKE `ylrz_saas`.`watch_family_user`; -- --- watch_materials_* (2 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`watch_materials` LIKE `ylrz_saas`.`watch_materials`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`watch_materials_type` LIKE `ylrz_saas`.`watch_materials_type`; -- --- watch_medication_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`watch_medication_task` LIKE `ylrz_saas`.`watch_medication_task`; -- --- watch_monitor_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`watch_monitor_data_type` LIKE `ylrz_saas`.`watch_monitor_data_type`; -- --- watch_msg_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`watch_msg_set` LIKE `ylrz_saas`.`watch_msg_set`; -- --- watch_send_* (2 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`watch_send_msg_log` LIKE `ylrz_saas`.`watch_send_msg_log`; CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`watch_send_msg_set` LIKE `ylrz_saas`.`watch_send_msg_set`; -- --- watch_user_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`watch_user` LIKE `ylrz_saas`.`watch_user`; -- --- wx_contact_* (1 tables) --- CREATE TABLE IF NOT EXISTS `ylrz_saas_tenant`.`wx_contact` LIKE `ylrz_saas`.`wx_contact`; -- ============================================================================ -- 第二阶段: INSERT DATA (复制数据) -- ============================================================================ -- --- ad_domain_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`ad_domain` SELECT * FROM `ylrz_saas`.`ad_domain`; -- --- ad_dy_* (2 tables) --- INSERT INTO `ylrz_saas_tenant`.`ad_dy_account` SELECT * FROM `ylrz_saas`.`ad_dy_account`; INSERT INTO `ylrz_saas_tenant`.`ad_dy_api` SELECT * FROM `ylrz_saas`.`ad_dy_api`; -- --- ad_html_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`ad_html_template` SELECT * FROM `ylrz_saas`.`ad_html_template`; -- --- ad_iqiyi_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`ad_iqiyi_account` SELECT * FROM `ylrz_saas`.`ad_iqiyi_account`; -- --- ad_site_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`ad_site` SELECT * FROM `ylrz_saas`.`ad_site`; -- --- ad_upload_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`ad_upload_log` SELECT * FROM `ylrz_saas`.`ad_upload_log`; -- --- ad_youku_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`ad_youku_account` SELECT * FROM `ylrz_saas`.`ad_youku_account`; -- --- ai_knowledge_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`ai_knowledge_base` SELECT * FROM `ylrz_saas`.`ai_knowledge_base`; -- --- bd_api_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`bd_api` SELECT * FROM `ylrz_saas`.`bd_api`; -- --- bd_creative_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`bd_creative_statistics` SELECT * FROM `ylrz_saas`.`bd_creative_statistics`; -- --- bd_report_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`bd_report_data` SELECT * FROM `ylrz_saas`.`bd_report_data`; -- --- chat_dataset_* (2 tables) --- INSERT INTO `ylrz_saas_tenant`.`chat_dataset` SELECT * FROM `ylrz_saas`.`chat_dataset`; INSERT INTO `ylrz_saas_tenant`.`chat_dataset_file` SELECT * FROM `ylrz_saas`.`chat_dataset_file`; -- --- chat_keyword_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`chat_keyword` SELECT * FROM `ylrz_saas`.`chat_keyword`; -- --- chat_msg_* (2 tables) --- INSERT INTO `ylrz_saas_tenant`.`chat_msg` SELECT * FROM `ylrz_saas`.`chat_msg`; INSERT INTO `ylrz_saas_tenant`.`chat_msg_logs` SELECT * FROM `ylrz_saas`.`chat_msg_logs`; -- --- chat_role_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`chat_role` SELECT * FROM `ylrz_saas`.`chat_role`; -- --- chat_session_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`chat_session` SELECT * FROM `ylrz_saas`.`chat_session`; -- --- chat_user_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`chat_user` SELECT * FROM `ylrz_saas`.`chat_user`; -- --- cid_ipad_* (2 tables) --- INSERT INTO `ylrz_saas_tenant`.`cid_ipad_server` SELECT * FROM `ylrz_saas`.`cid_ipad_server`; INSERT INTO `ylrz_saas_tenant`.`cid_ipad_server_user` SELECT * FROM `ylrz_saas`.`cid_ipad_server_user`; -- --- company_ai_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`company_ai_workflow_node_type` SELECT * FROM `ylrz_saas`.`company_ai_workflow_node_type`; -- --- company_company_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`company_company_fsuser` SELECT * FROM `ylrz_saas`.`company_company_fsuser`; -- --- company_deduct_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`company_deduct` SELECT * FROM `ylrz_saas`.`company_deduct`; -- --- company_div_* (2 tables) --- INSERT INTO `ylrz_saas_tenant`.`company_div_config` SELECT * FROM `ylrz_saas`.`company_div_config`; INSERT INTO `ylrz_saas_tenant`.`company_div_item` SELECT * FROM `ylrz_saas`.`company_div_item`; -- --- company_logininfor_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`company_logininfor` SELECT * FROM `ylrz_saas`.`company_logininfor`; -- --- company_miniapp_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`company_miniapp` SELECT * FROM `ylrz_saas`.`company_miniapp`; -- --- company_post_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`company_post` SELECT * FROM `ylrz_saas`.`company_post`; -- --- company_profit_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`company_profit_logs` SELECT * FROM `ylrz_saas`.`company_profit_logs`; -- --- company_recharge_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`company_recharge` SELECT * FROM `ylrz_saas`.`company_recharge`; -- --- company_role_* (2 tables) --- INSERT INTO `ylrz_saas_tenant`.`company_role_dept` SELECT * FROM `ylrz_saas`.`company_role_dept`; INSERT INTO `ylrz_saas_tenant`.`company_role_menu` SELECT * FROM `ylrz_saas`.`company_role_menu`; -- --- company_sop_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`company_sop_role` SELECT * FROM `ylrz_saas`.`company_sop_role`; -- --- company_tag_* (2 tables) --- INSERT INTO `ylrz_saas_tenant`.`company_tag` SELECT * FROM `ylrz_saas`.`company_tag`; INSERT INTO `ylrz_saas_tenant`.`company_tag_user` SELECT * FROM `ylrz_saas`.`company_tag_user`; -- --- company_tcm_* (3 tables) --- INSERT INTO `ylrz_saas_tenant`.`company_tcm_consume` SELECT * FROM `ylrz_saas`.`company_tcm_consume`; INSERT INTO `ylrz_saas_tenant`.`company_tcm_report` SELECT * FROM `ylrz_saas`.`company_tcm_report`; INSERT INTO `ylrz_saas_tenant`.`company_tcm_schedule` SELECT * FROM `ylrz_saas`.`company_tcm_schedule`; -- --- company_user_* (5 tables) --- INSERT INTO `ylrz_saas_tenant`.`company_user_card` SELECT * FROM `ylrz_saas`.`company_user_card`; INSERT INTO `ylrz_saas_tenant`.`company_user_change_apply_user` SELECT * FROM `ylrz_saas`.`company_user_change_apply_user`; INSERT INTO `ylrz_saas_tenant`.`company_user_delay_time` SELECT * FROM `ylrz_saas`.`company_user_delay_time`; INSERT INTO `ylrz_saas_tenant`.`company_user_post` SELECT * FROM `ylrz_saas`.`company_user_post`; INSERT INTO `ylrz_saas_tenant`.`company_user_user` SELECT * FROM `ylrz_saas`.`company_user_user`; -- --- company_voice_* (7 tables) --- INSERT INTO `ylrz_saas_tenant`.`company_voice` SELECT * FROM `ylrz_saas`.`company_voice`; INSERT INTO `ylrz_saas_tenant`.`company_voice_config` SELECT * FROM `ylrz_saas`.`company_voice_config`; INSERT INTO `ylrz_saas_tenant`.`company_voice_dialog` SELECT * FROM `ylrz_saas`.`company_voice_dialog`; INSERT INTO `ylrz_saas_tenant`.`company_voice_mobile` SELECT * FROM `ylrz_saas`.`company_voice_mobile`; INSERT INTO `ylrz_saas_tenant`.`company_voice_package` SELECT * FROM `ylrz_saas`.`company_voice_package`; INSERT INTO `ylrz_saas_tenant`.`company_voice_robotic_call_log_addwx` SELECT * FROM `ylrz_saas`.`company_voice_robotic_call_log_addwx`; INSERT INTO `ylrz_saas_tenant`.`company_voice_robotic_call_log_sendmsg` SELECT * FROM `ylrz_saas`.`company_voice_robotic_call_log_sendmsg`; -- --- company_workflow_* (6 tables) --- INSERT INTO `ylrz_saas_tenant`.`company_workflow_lobster` SELECT * FROM `ylrz_saas`.`company_workflow_lobster`; INSERT INTO `ylrz_saas_tenant`.`company_workflow_lobster_edge` SELECT * FROM `ylrz_saas`.`company_workflow_lobster_edge`; INSERT INTO `ylrz_saas_tenant`.`company_workflow_lobster_node` SELECT * FROM `ylrz_saas`.`company_workflow_lobster_node`; INSERT INTO `ylrz_saas_tenant`.`company_workflow_lobster_record` SELECT * FROM `ylrz_saas`.`company_workflow_lobster_record`; INSERT INTO `ylrz_saas_tenant`.`company_workflow_lobster_task` SELECT * FROM `ylrz_saas`.`company_workflow_lobster_task`; INSERT INTO `ylrz_saas_tenant`.`company_workflow_lobster_variable` SELECT * FROM `ylrz_saas`.`company_workflow_lobster_variable`; -- --- company_wx_* (2 tables) --- INSERT INTO `ylrz_saas_tenant`.`company_wx_chat` SELECT * FROM `ylrz_saas`.`company_wx_chat`; INSERT INTO `ylrz_saas_tenant`.`company_wx_user_group` SELECT * FROM `ylrz_saas`.`company_wx_user_group`; -- --- crm_customer_* (8 tables) --- INSERT INTO `ylrz_saas_tenant`.`crm_customer_analyze` SELECT * FROM `ylrz_saas`.`crm_customer_analyze`; INSERT INTO `ylrz_saas_tenant`.`crm_customer_assign` SELECT * FROM `ylrz_saas`.`crm_customer_assign`; INSERT INTO `ylrz_saas_tenant`.`crm_customer_contacts` SELECT * FROM `ylrz_saas`.`crm_customer_contacts`; INSERT INTO `ylrz_saas_tenant`.`crm_customer_ext` SELECT * FROM `ylrz_saas`.`crm_customer_ext`; INSERT INTO `ylrz_saas_tenant`.`crm_customer_his_order` SELECT * FROM `ylrz_saas`.`crm_customer_his_order`; INSERT INTO `ylrz_saas_tenant`.`crm_customer_logs` SELECT * FROM `ylrz_saas`.`crm_customer_logs`; INSERT INTO `ylrz_saas_tenant`.`crm_customer_third` SELECT * FROM `ylrz_saas`.`crm_customer_third`; INSERT INTO `ylrz_saas_tenant`.`crm_customer_user` SELECT * FROM `ylrz_saas`.`crm_customer_user`; -- --- crm_event_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`crm_event` SELECT * FROM `ylrz_saas`.`crm_event`; -- --- crm_msg_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`crm_msg` SELECT * FROM `ylrz_saas`.`crm_msg`; -- --- customer_transfer_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`customer_transfer_approval` SELECT * FROM `ylrz_saas`.`customer_transfer_approval`; -- --- fastgpt_chat_* (6 tables) --- INSERT INTO `ylrz_saas_tenant`.`fastgpt_chat_artificial_words` SELECT * FROM `ylrz_saas`.`fastgpt_chat_artificial_words`; INSERT INTO `ylrz_saas_tenant`.`fastgpt_chat_keyword` SELECT * FROM `ylrz_saas`.`fastgpt_chat_keyword`; INSERT INTO `ylrz_saas_tenant`.`fastgpt_chat_msg_logs` SELECT * FROM `ylrz_saas`.`fastgpt_chat_msg_logs`; INSERT INTO `ylrz_saas_tenant`.`fastgpt_chat_replace_text` SELECT * FROM `ylrz_saas`.`fastgpt_chat_replace_text`; INSERT INTO `ylrz_saas_tenant`.`fastgpt_chat_replace_words` SELECT * FROM `ylrz_saas`.`fastgpt_chat_replace_words`; INSERT INTO `ylrz_saas_tenant`.`fastgpt_chat_voice_homo` SELECT * FROM `ylrz_saas`.`fastgpt_chat_voice_homo`; -- --- fastgpt_collection_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`fastgpt_collection` SELECT * FROM `ylrz_saas`.`fastgpt_collection`; -- --- fastgpt_collention_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`fastgpt_collention_data` SELECT * FROM `ylrz_saas`.`fastgpt_collention_data`; -- --- fastgpt_dataset_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`fastgpt_dataset` SELECT * FROM `ylrz_saas`.`fastgpt_dataset`; -- --- fastgpt_event_* (2 tables) --- INSERT INTO `ylrz_saas_tenant`.`fastgpt_event_log` SELECT * FROM `ylrz_saas`.`fastgpt_event_log`; INSERT INTO `ylrz_saas_tenant`.`fastgpt_event_log_total` SELECT * FROM `ylrz_saas`.`fastgpt_event_log_total`; -- --- fastgpt_ext_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`fastgpt_ext_user_tag` SELECT * FROM `ylrz_saas`.`fastgpt_ext_user_tag`; -- --- fastgpt_keyword_* (3 tables) --- INSERT INTO `ylrz_saas_tenant`.`fastgpt_keyword` SELECT * FROM `ylrz_saas`.`fastgpt_keyword`; INSERT INTO `ylrz_saas_tenant`.`fastgpt_keyword_artificial` SELECT * FROM `ylrz_saas`.`fastgpt_keyword_artificial`; INSERT INTO `ylrz_saas_tenant`.`fastgpt_keyword_send` SELECT * FROM `ylrz_saas`.`fastgpt_keyword_send`; -- --- fastgpt_push_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`fastgpt_push_token_total` SELECT * FROM `ylrz_saas`.`fastgpt_push_token_total`; -- --- fastgpt_role_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`fastgpt_role_tag` SELECT * FROM `ylrz_saas`.`fastgpt_role_tag`; -- --- fastgpt_tag_* (2 tables) --- INSERT INTO `ylrz_saas_tenant`.`fastgpt_tag` SELECT * FROM `ylrz_saas`.`fastgpt_tag`; INSERT INTO `ylrz_saas_tenant`.`fastgpt_tag_group` SELECT * FROM `ylrz_saas`.`fastgpt_tag_group`; -- --- fastgpt_user_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`fastgpt_user` SELECT * FROM `ylrz_saas`.`fastgpt_user`; -- --- fs_adv_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`fs_adv_sem` SELECT * FROM `ylrz_saas`.`fs_adv_sem`; -- --- fs_ai_* (2 tables) --- INSERT INTO `ylrz_saas_tenant`.`fs_ai_workflow_edge` SELECT * FROM `ylrz_saas`.`fs_ai_workflow_edge`; INSERT INTO `ylrz_saas_tenant`.`fs_ai_workflow_node_type` SELECT * FROM `ylrz_saas`.`fs_ai_workflow_node_type`; -- --- fs_app_* (2 tables) --- INSERT INTO `ylrz_saas_tenant`.`fs_app_contact_way` SELECT * FROM `ylrz_saas`.`fs_app_contact_way`; INSERT INTO `ylrz_saas_tenant`.`fs_app_version` SELECT * FROM `ylrz_saas`.`fs_app_version`; -- --- fs_article_* (3 tables) --- INSERT INTO `ylrz_saas_tenant`.`fs_article` SELECT * FROM `ylrz_saas`.`fs_article`; INSERT INTO `ylrz_saas_tenant`.`fs_article_cate` SELECT * FROM `ylrz_saas`.`fs_article_cate`; INSERT INTO `ylrz_saas_tenant`.`fs_article_views` SELECT * FROM `ylrz_saas`.`fs_article_views`; -- --- fs_chinese_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`fs_chinese_medicine` SELECT * FROM `ylrz_saas`.`fs_chinese_medicine`; -- --- fs_city_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`fs_city` SELECT * FROM `ylrz_saas`.`fs_city`; -- --- fs_complaint_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`fs_complaint_template` SELECT * FROM `ylrz_saas`.`fs_complaint_template`; -- --- fs_coupon_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`fs_coupon` SELECT * FROM `ylrz_saas`.`fs_coupon`; -- --- fs_course_* (12 tables) --- INSERT INTO `ylrz_saas_tenant`.`fs_course_domain_name` SELECT * FROM `ylrz_saas`.`fs_course_domain_name`; INSERT INTO `ylrz_saas_tenant`.`fs_course_finish_temp` SELECT * FROM `ylrz_saas`.`fs_course_finish_temp`; INSERT INTO `ylrz_saas_tenant`.`fs_course_finish_temp_parent` SELECT * FROM `ylrz_saas`.`fs_course_finish_temp_parent`; INSERT INTO `ylrz_saas_tenant`.`fs_course_link` SELECT * FROM `ylrz_saas`.`fs_course_link`; INSERT INTO `ylrz_saas_tenant`.`fs_course_product` SELECT * FROM `ylrz_saas`.`fs_course_product`; INSERT INTO `ylrz_saas_tenant`.`fs_course_product_order` SELECT * FROM `ylrz_saas`.`fs_course_product_order`; INSERT INTO `ylrz_saas_tenant`.`fs_course_question_bank` SELECT * FROM `ylrz_saas`.`fs_course_question_bank`; INSERT INTO `ylrz_saas_tenant`.`fs_course_question_category` SELECT * FROM `ylrz_saas`.`fs_course_question_category`; INSERT INTO `ylrz_saas_tenant`.`fs_course_sop` SELECT * FROM `ylrz_saas`.`fs_course_sop`; INSERT INTO `ylrz_saas_tenant`.`fs_course_sop_app_link` SELECT * FROM `ylrz_saas`.`fs_course_sop_app_link`; INSERT INTO `ylrz_saas_tenant`.`fs_course_sop_logs` SELECT * FROM `ylrz_saas`.`fs_course_sop_logs`; INSERT INTO `ylrz_saas_tenant`.`fs_course_watch_comment` SELECT * FROM `ylrz_saas`.`fs_course_watch_comment`; -- --- fs_df_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`fs_df_account` SELECT * FROM `ylrz_saas`.`fs_df_account`; -- --- fs_disease_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`fs_disease` SELECT * FROM `ylrz_saas`.`fs_disease`; -- --- fs_doctor_* (14 tables) --- INSERT INTO `ylrz_saas_tenant`.`fs_doctor_ai_chat_log` SELECT * FROM `ylrz_saas`.`fs_doctor_ai_chat_log`; INSERT INTO `ylrz_saas_tenant`.`fs_doctor_ai_chat_msg` SELECT * FROM `ylrz_saas`.`fs_doctor_ai_chat_msg`; INSERT INTO `ylrz_saas_tenant`.`fs_doctor_ai_chat_session` SELECT * FROM `ylrz_saas`.`fs_doctor_ai_chat_session`; INSERT INTO `ylrz_saas_tenant`.`fs_doctor_article` SELECT * FROM `ylrz_saas`.`fs_doctor_article`; INSERT INTO `ylrz_saas_tenant`.`fs_doctor_article_cate` SELECT * FROM `ylrz_saas`.`fs_doctor_article_cate`; INSERT INTO `ylrz_saas_tenant`.`fs_doctor_bill` SELECT * FROM `ylrz_saas`.`fs_doctor_bill`; INSERT INTO `ylrz_saas_tenant`.`fs_doctor_confirm` SELECT * FROM `ylrz_saas`.`fs_doctor_confirm`; INSERT INTO `ylrz_saas_tenant`.`fs_doctor_extract` SELECT * FROM `ylrz_saas`.`fs_doctor_extract`; INSERT INTO `ylrz_saas_tenant`.`fs_doctor_oper_log` SELECT * FROM `ylrz_saas`.`fs_doctor_oper_log`; INSERT INTO `ylrz_saas_tenant`.`fs_doctor_prescribe` SELECT * FROM `ylrz_saas`.`fs_doctor_prescribe`; INSERT INTO `ylrz_saas_tenant`.`fs_doctor_prescribe_drug` SELECT * FROM `ylrz_saas`.`fs_doctor_prescribe_drug`; INSERT INTO `ylrz_saas_tenant`.`fs_doctor_price` SELECT * FROM `ylrz_saas`.`fs_doctor_price`; INSERT INTO `ylrz_saas_tenant`.`fs_doctor_product` SELECT * FROM `ylrz_saas`.`fs_doctor_product`; INSERT INTO `ylrz_saas_tenant`.`fs_doctor_words` SELECT * FROM `ylrz_saas`.`fs_doctor_words`; -- --- fs_drug_* (2 tables) --- INSERT INTO `ylrz_saas_tenant`.`fs_drug_report` SELECT * FROM `ylrz_saas`.`fs_drug_report`; INSERT INTO `ylrz_saas_tenant`.`fs_drug_report_count` SELECT * FROM `ylrz_saas`.`fs_drug_report_count`; -- --- fs_express_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`fs_express` SELECT * FROM `ylrz_saas`.`fs_express`; -- --- fs_famous_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`fs_famous_prescribe` SELECT * FROM `ylrz_saas`.`fs_famous_prescribe`; -- --- fs_finish_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`fs_finish_course_statistics_sync` SELECT * FROM `ylrz_saas`.`fs_finish_course_statistics_sync`; -- --- fs_first_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`fs_first_diagnosis` SELECT * FROM `ylrz_saas`.`fs_first_diagnosis`; -- --- fs_follow_* (3 tables) --- INSERT INTO `ylrz_saas_tenant`.`fs_follow` SELECT * FROM `ylrz_saas`.`fs_follow`; INSERT INTO `ylrz_saas_tenant`.`fs_follow_report` SELECT * FROM `ylrz_saas`.`fs_follow_report`; INSERT INTO `ylrz_saas_tenant`.`fs_follow_temp` SELECT * FROM `ylrz_saas`.`fs_follow_temp`; -- --- fs_health_* (5 tables) --- INSERT INTO `ylrz_saas_tenant`.`fs_health_data` SELECT * FROM `ylrz_saas`.`fs_health_data`; INSERT INTO `ylrz_saas_tenant`.`fs_health_history_temp` SELECT * FROM `ylrz_saas`.`fs_health_history_temp`; INSERT INTO `ylrz_saas_tenant`.`fs_health_life` SELECT * FROM `ylrz_saas`.`fs_health_life`; INSERT INTO `ylrz_saas_tenant`.`fs_health_record` SELECT * FROM `ylrz_saas`.`fs_health_record`; INSERT INTO `ylrz_saas_tenant`.`fs_health_tongue` SELECT * FROM `ylrz_saas`.`fs_health_tongue`; -- --- fs_hfpay_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`fs_hfpay_config` SELECT * FROM `ylrz_saas`.`fs_hfpay_config`; -- --- fs_icd_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`fs_icd` SELECT * FROM `ylrz_saas`.`fs_icd`; -- --- fs_illness_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`fs_illness_library` SELECT * FROM `ylrz_saas`.`fs_illness_library`; -- --- fs_im_* (2 tables) --- INSERT INTO `ylrz_saas_tenant`.`fs_im_msg_send_detail` SELECT * FROM `ylrz_saas`.`fs_im_msg_send_detail`; INSERT INTO `ylrz_saas_tenant`.`fs_im_msg_send_log` SELECT * FROM `ylrz_saas`.`fs_im_msg_send_log`; -- --- fs_inquiry_* (7 tables) --- INSERT INTO `ylrz_saas_tenant`.`fs_inquiry_disease` SELECT * FROM `ylrz_saas`.`fs_inquiry_disease`; INSERT INTO `ylrz_saas_tenant`.`fs_inquiry_order_logs` SELECT * FROM `ylrz_saas`.`fs_inquiry_order_logs`; INSERT INTO `ylrz_saas_tenant`.`fs_inquiry_order_media` SELECT * FROM `ylrz_saas`.`fs_inquiry_order_media`; INSERT INTO `ylrz_saas_tenant`.`fs_inquiry_order_msg` SELECT * FROM `ylrz_saas`.`fs_inquiry_order_msg`; INSERT INTO `ylrz_saas_tenant`.`fs_inquiry_order_ping` SELECT * FROM `ylrz_saas`.`fs_inquiry_order_ping`; INSERT INTO `ylrz_saas_tenant`.`fs_inquiry_patient_info` SELECT * FROM `ylrz_saas`.`fs_inquiry_patient_info`; INSERT INTO `ylrz_saas_tenant`.`fs_inquiry_temp` SELECT * FROM `ylrz_saas`.`fs_inquiry_temp`; -- --- fs_integral_* (3 tables) --- INSERT INTO `ylrz_saas_tenant`.`fs_integral_cart` SELECT * FROM `ylrz_saas`.`fs_integral_cart`; INSERT INTO `ylrz_saas_tenant`.`fs_integral_order` SELECT * FROM `ylrz_saas`.`fs_integral_order`; INSERT INTO `ylrz_saas_tenant`.`fs_integral_order_logs` SELECT * FROM `ylrz_saas`.`fs_integral_order_logs`; -- --- fs_interest_* (4 tables) --- INSERT INTO `ylrz_saas_tenant`.`fs_interest_ai_msg` SELECT * FROM `ylrz_saas`.`fs_interest_ai_msg`; INSERT INTO `ylrz_saas_tenant`.`fs_interest_ai_role` SELECT * FROM `ylrz_saas`.`fs_interest_ai_role`; INSERT INTO `ylrz_saas_tenant`.`fs_interest_ai_role_words` SELECT * FROM `ylrz_saas`.`fs_interest_ai_role_words`; INSERT INTO `ylrz_saas_tenant`.`fs_interest_ai_session` SELECT * FROM `ylrz_saas`.`fs_interest_ai_session`; -- --- fs_material_* (2 tables) --- INSERT INTO `ylrz_saas_tenant`.`fs_material` SELECT * FROM `ylrz_saas`.`fs_material`; INSERT INTO `ylrz_saas_tenant`.`fs_material_group` SELECT * FROM `ylrz_saas`.`fs_material_group`; -- --- fs_medicated_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`fs_medicated_food` SELECT * FROM `ylrz_saas`.`fs_medicated_food`; -- --- fs_mess_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`fs_mess_temp` SELECT * FROM `ylrz_saas`.`fs_mess_temp`; -- --- fs_package_* (3 tables) --- INSERT INTO `ylrz_saas_tenant`.`fs_package_cate` SELECT * FROM `ylrz_saas`.`fs_package_cate`; INSERT INTO `ylrz_saas_tenant`.`fs_package_favorite` SELECT * FROM `ylrz_saas`.`fs_package_favorite`; INSERT INTO `ylrz_saas_tenant`.`fs_package_solar_term` SELECT * FROM `ylrz_saas`.`fs_package_solar_term`; -- --- fs_physical_* (2 tables) --- INSERT INTO `ylrz_saas_tenant`.`fs_physical_report_template` SELECT * FROM `ylrz_saas`.`fs_physical_report_template`; INSERT INTO `ylrz_saas_tenant`.`fs_physical_report_template_field` SELECT * FROM `ylrz_saas`.`fs_physical_report_template_field`; -- --- fs_prescribe_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`fs_prescribe` SELECT * FROM `ylrz_saas`.`fs_prescribe`; -- --- fs_promotional_* (2 tables) --- INSERT INTO `ylrz_saas_tenant`.`fs_promotional_active` SELECT * FROM `ylrz_saas`.`fs_promotional_active`; INSERT INTO `ylrz_saas_tenant`.`fs_promotional_active_log` SELECT * FROM `ylrz_saas`.`fs_promotional_active_log`; -- --- fs_question_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`fs_question_and_answer` SELECT * FROM `ylrz_saas`.`fs_question_and_answer`; -- --- fs_questions_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`fs_questions` SELECT * FROM `ylrz_saas`.`fs_questions`; -- --- fs_statis_* (5 tables) --- INSERT INTO `ylrz_saas_tenant`.`fs_statis_qw_temp_param` SELECT * FROM `ylrz_saas`.`fs_statis_qw_temp_param`; INSERT INTO `ylrz_saas_tenant`.`fs_statis_qw_watch` SELECT * FROM `ylrz_saas`.`fs_statis_qw_watch`; INSERT INTO `ylrz_saas_tenant`.`fs_statis_saler_watch` SELECT * FROM `ylrz_saas`.`fs_statis_saler_watch`; INSERT INTO `ylrz_saas_tenant`.`fs_statis_temp_fsuser` SELECT * FROM `ylrz_saas`.`fs_statis_temp_fsuser`; INSERT INTO `ylrz_saas_tenant`.`fs_statis_temp_param` SELECT * FROM `ylrz_saas`.`fs_statis_temp_param`; -- --- fs_statistics_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`fs_statistics` SELECT * FROM `ylrz_saas`.`fs_statistics`; -- --- fs_store_* (40 tables) --- INSERT INTO `ylrz_saas_tenant`.`fs_store` SELECT * FROM `ylrz_saas`.`fs_store`; INSERT INTO `ylrz_saas_tenant`.`fs_store_activity` SELECT * FROM `ylrz_saas`.`fs_store_activity`; INSERT INTO `ylrz_saas_tenant`.`fs_store_activity_scrm` SELECT * FROM `ylrz_saas`.`fs_store_activity_scrm`; INSERT INTO `ylrz_saas_tenant`.`fs_store_after_sales` SELECT * FROM `ylrz_saas`.`fs_store_after_sales`; INSERT INTO `ylrz_saas_tenant`.`fs_store_after_sales_item` SELECT * FROM `ylrz_saas`.`fs_store_after_sales_item`; INSERT INTO `ylrz_saas_tenant`.`fs_store_after_sales_logs` SELECT * FROM `ylrz_saas`.`fs_store_after_sales_logs`; INSERT INTO `ylrz_saas_tenant`.`fs_store_after_sales_logs_scrm` SELECT * FROM `ylrz_saas`.`fs_store_after_sales_logs_scrm`; INSERT INTO `ylrz_saas_tenant`.`fs_store_bill` SELECT * FROM `ylrz_saas`.`fs_store_bill`; INSERT INTO `ylrz_saas_tenant`.`fs_store_bill_scrm` SELECT * FROM `ylrz_saas`.`fs_store_bill_scrm`; INSERT INTO `ylrz_saas_tenant`.`fs_store_canvas_scrm` SELECT * FROM `ylrz_saas`.`fs_store_canvas_scrm`; INSERT INTO `ylrz_saas_tenant`.`fs_store_cart_scrm` SELECT * FROM `ylrz_saas`.`fs_store_cart_scrm`; INSERT INTO `ylrz_saas_tenant`.`fs_store_coupon_issue_scrm` SELECT * FROM `ylrz_saas`.`fs_store_coupon_issue_scrm`; INSERT INTO `ylrz_saas_tenant`.`fs_store_coupon_issue_user_scrm` SELECT * FROM `ylrz_saas`.`fs_store_coupon_issue_user_scrm`; INSERT INTO `ylrz_saas_tenant`.`fs_store_coupon_scrm` SELECT * FROM `ylrz_saas`.`fs_store_coupon_scrm`; INSERT INTO `ylrz_saas_tenant`.`fs_store_coupon_user_scrm` SELECT * FROM `ylrz_saas`.`fs_store_coupon_user_scrm`; INSERT INTO `ylrz_saas_tenant`.`fs_store_extract` SELECT * FROM `ylrz_saas`.`fs_store_extract`; INSERT INTO `ylrz_saas_tenant`.`fs_store_order_audit_scrm` SELECT * FROM `ylrz_saas`.`fs_store_order_audit_scrm`; INSERT INTO `ylrz_saas_tenant`.`fs_store_order_bill_log` SELECT * FROM `ylrz_saas`.`fs_store_order_bill_log`; INSERT INTO `ylrz_saas_tenant`.`fs_store_order_logs` SELECT * FROM `ylrz_saas`.`fs_store_order_logs`; INSERT INTO `ylrz_saas_tenant`.`fs_store_order_logs_scrm` SELECT * FROM `ylrz_saas`.`fs_store_order_logs_scrm`; INSERT INTO `ylrz_saas_tenant`.`fs_store_order_notice_scrm` SELECT * FROM `ylrz_saas`.`fs_store_order_notice_scrm`; INSERT INTO `ylrz_saas_tenant`.`fs_store_payment_error` SELECT * FROM `ylrz_saas`.`fs_store_payment_error`; INSERT INTO `ylrz_saas_tenant`.`fs_store_product` SELECT * FROM `ylrz_saas`.`fs_store_product`; INSERT INTO `ylrz_saas_tenant`.`fs_store_product_attr` SELECT * FROM `ylrz_saas`.`fs_store_product_attr`; INSERT INTO `ylrz_saas_tenant`.`fs_store_product_attr_scrm` SELECT * FROM `ylrz_saas`.`fs_store_product_attr_scrm`; INSERT INTO `ylrz_saas_tenant`.`fs_store_product_attr_value` SELECT * FROM `ylrz_saas`.`fs_store_product_attr_value`; INSERT INTO `ylrz_saas_tenant`.`fs_store_product_category` SELECT * FROM `ylrz_saas`.`fs_store_product_category`; INSERT INTO `ylrz_saas_tenant`.`fs_store_product_details_scrm` SELECT * FROM `ylrz_saas`.`fs_store_product_details_scrm`; INSERT INTO `ylrz_saas_tenant`.`fs_store_product_group` SELECT * FROM `ylrz_saas`.`fs_store_product_group`; INSERT INTO `ylrz_saas_tenant`.`fs_store_product_group_scrm` SELECT * FROM `ylrz_saas`.`fs_store_product_group_scrm`; INSERT INTO `ylrz_saas_tenant`.`fs_store_product_package` SELECT * FROM `ylrz_saas`.`fs_store_product_package`; INSERT INTO `ylrz_saas_tenant`.`fs_store_product_purchase_limit_scrm` SELECT * FROM `ylrz_saas`.`fs_store_product_purchase_limit_scrm`; INSERT INTO `ylrz_saas_tenant`.`fs_store_product_relation_scrm` SELECT * FROM `ylrz_saas`.`fs_store_product_relation_scrm`; INSERT INTO `ylrz_saas_tenant`.`fs_store_product_reply_scrm` SELECT * FROM `ylrz_saas`.`fs_store_product_reply_scrm`; INSERT INTO `ylrz_saas_tenant`.`fs_store_product_rule_scrm` SELECT * FROM `ylrz_saas`.`fs_store_product_rule_scrm`; INSERT INTO `ylrz_saas_tenant`.`fs_store_product_template_scrm` SELECT * FROM `ylrz_saas`.`fs_store_product_template_scrm`; INSERT INTO `ylrz_saas_tenant`.`fs_store_recommend_scrm` SELECT * FROM `ylrz_saas`.`fs_store_recommend_scrm`; INSERT INTO `ylrz_saas_tenant`.`fs_store_shop_staff_scrm` SELECT * FROM `ylrz_saas`.`fs_store_shop_staff_scrm`; INSERT INTO `ylrz_saas_tenant`.`fs_store_sub_order` SELECT * FROM `ylrz_saas`.`fs_store_sub_order`; INSERT INTO `ylrz_saas_tenant`.`fs_store_visit_scrm` SELECT * FROM `ylrz_saas`.`fs_store_visit_scrm`; -- --- fs_test_* (3 tables) --- INSERT INTO `ylrz_saas_tenant`.`fs_test_report` SELECT * FROM `ylrz_saas`.`fs_test_report`; INSERT INTO `ylrz_saas_tenant`.`fs_test_temp` SELECT * FROM `ylrz_saas`.`fs_test_temp`; INSERT INTO `ylrz_saas_tenant`.`fs_test_temp_item` SELECT * FROM `ylrz_saas`.`fs_test_temp_item`; -- --- fs_tongue_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`fs_tongue_info` SELECT * FROM `ylrz_saas`.`fs_tongue_info`; -- --- fs_user_* (51 tables) --- INSERT INTO `ylrz_saas_tenant`.`fs_user_address` SELECT * FROM `ylrz_saas`.`fs_user_address`; INSERT INTO `ylrz_saas_tenant`.`fs_user_bill` SELECT * FROM `ylrz_saas`.`fs_user_bill`; INSERT INTO `ylrz_saas_tenant`.`fs_user_company_bind` SELECT * FROM `ylrz_saas`.`fs_user_company_bind`; INSERT INTO `ylrz_saas_tenant`.`fs_user_company_package_scrm` SELECT * FROM `ylrz_saas`.`fs_user_company_package_scrm`; INSERT INTO `ylrz_saas_tenant`.`fs_user_company_user` SELECT * FROM `ylrz_saas`.`fs_user_company_user`; INSERT INTO `ylrz_saas_tenant`.`fs_user_company_user_qw` SELECT * FROM `ylrz_saas`.`fs_user_company_user_qw`; INSERT INTO `ylrz_saas_tenant`.`fs_user_complaint` SELECT * FROM `ylrz_saas`.`fs_user_complaint`; INSERT INTO `ylrz_saas_tenant`.`fs_user_complaint_msg` SELECT * FROM `ylrz_saas`.`fs_user_complaint_msg`; INSERT INTO `ylrz_saas_tenant`.`fs_user_course_comment` SELECT * FROM `ylrz_saas`.`fs_user_course_comment`; INSERT INTO `ylrz_saas_tenant`.`fs_user_course_comment_like` SELECT * FROM `ylrz_saas`.`fs_user_course_comment_like`; INSERT INTO `ylrz_saas_tenant`.`fs_user_course_company_statistics` SELECT * FROM `ylrz_saas`.`fs_user_course_company_statistics`; INSERT INTO `ylrz_saas_tenant`.`fs_user_course_complaint_record` SELECT * FROM `ylrz_saas`.`fs_user_course_complaint_record`; INSERT INTO `ylrz_saas_tenant`.`fs_user_course_complaint_type` SELECT * FROM `ylrz_saas`.`fs_user_course_complaint_type`; INSERT INTO `ylrz_saas_tenant`.`fs_user_course_count` SELECT * FROM `ylrz_saas`.`fs_user_course_count`; INSERT INTO `ylrz_saas_tenant`.`fs_user_course_favorite` SELECT * FROM `ylrz_saas`.`fs_user_course_favorite`; INSERT INTO `ylrz_saas_tenant`.`fs_user_course_follow` SELECT * FROM `ylrz_saas`.`fs_user_course_follow`; INSERT INTO `ylrz_saas_tenant`.`fs_user_course_like` SELECT * FROM `ylrz_saas`.`fs_user_course_like`; INSERT INTO `ylrz_saas_tenant`.`fs_user_course_note` SELECT * FROM `ylrz_saas`.`fs_user_course_note`; INSERT INTO `ylrz_saas_tenant`.`fs_user_course_note_like` SELECT * FROM `ylrz_saas`.`fs_user_course_note_like`; INSERT INTO `ylrz_saas_tenant`.`fs_user_course_note_save` SELECT * FROM `ylrz_saas`.`fs_user_course_note_save`; INSERT INTO `ylrz_saas_tenant`.`fs_user_course_order` SELECT * FROM `ylrz_saas`.`fs_user_course_order`; INSERT INTO `ylrz_saas_tenant`.`fs_user_course_study` SELECT * FROM `ylrz_saas`.`fs_user_course_study`; INSERT INTO `ylrz_saas_tenant`.`fs_user_course_study_log` SELECT * FROM `ylrz_saas`.`fs_user_course_study_log`; INSERT INTO `ylrz_saas_tenant`.`fs_user_course_video_red_package` SELECT * FROM `ylrz_saas`.`fs_user_course_video_red_package`; INSERT INTO `ylrz_saas_tenant`.`fs_user_doctor` SELECT * FROM `ylrz_saas`.`fs_user_doctor`; INSERT INTO `ylrz_saas_tenant`.`fs_user_extract` SELECT * FROM `ylrz_saas`.`fs_user_extract`; INSERT INTO `ylrz_saas_tenant`.`fs_user_information_collection_schedule` SELECT * FROM `ylrz_saas`.`fs_user_information_collection_schedule`; INSERT INTO `ylrz_saas_tenant`.`fs_user_integral_logs` SELECT * FROM `ylrz_saas`.`fs_user_integral_logs`; INSERT INTO `ylrz_saas_tenant`.`fs_user_invited` SELECT * FROM `ylrz_saas`.`fs_user_invited`; INSERT INTO `ylrz_saas_tenant`.`fs_user_login_log` SELECT * FROM `ylrz_saas`.`fs_user_login_log`; INSERT INTO `ylrz_saas_tenant`.`fs_user_new_task` SELECT * FROM `ylrz_saas`.`fs_user_new_task`; INSERT INTO `ylrz_saas_tenant`.`fs_user_online_state` SELECT * FROM `ylrz_saas`.`fs_user_online_state`; INSERT INTO `ylrz_saas_tenant`.`fs_user_operation_log` SELECT * FROM `ylrz_saas`.`fs_user_operation_log`; INSERT INTO `ylrz_saas_tenant`.`fs_user_project_tag` SELECT * FROM `ylrz_saas`.`fs_user_project_tag`; INSERT INTO `ylrz_saas_tenant`.`fs_user_recharge` SELECT * FROM `ylrz_saas`.`fs_user_recharge`; INSERT INTO `ylrz_saas_tenant`.`fs_user_sign` SELECT * FROM `ylrz_saas`.`fs_user_sign`; INSERT INTO `ylrz_saas_tenant`.`fs_user_talent` SELECT * FROM `ylrz_saas`.`fs_user_talent`; INSERT INTO `ylrz_saas_tenant`.`fs_user_talent_follow` SELECT * FROM `ylrz_saas`.`fs_user_talent_follow`; INSERT INTO `ylrz_saas_tenant`.`fs_user_video` SELECT * FROM `ylrz_saas`.`fs_user_video`; INSERT INTO `ylrz_saas_tenant`.`fs_user_video_comment` SELECT * FROM `ylrz_saas`.`fs_user_video_comment`; INSERT INTO `ylrz_saas_tenant`.`fs_user_video_comment_like` SELECT * FROM `ylrz_saas`.`fs_user_video_comment_like`; INSERT INTO `ylrz_saas_tenant`.`fs_user_video_favorite` SELECT * FROM `ylrz_saas`.`fs_user_video_favorite`; INSERT INTO `ylrz_saas_tenant`.`fs_user_video_like` SELECT * FROM `ylrz_saas`.`fs_user_video_like`; INSERT INTO `ylrz_saas_tenant`.`fs_user_video_tags` SELECT * FROM `ylrz_saas`.`fs_user_video_tags`; INSERT INTO `ylrz_saas_tenant`.`fs_user_video_view` SELECT * FROM `ylrz_saas`.`fs_user_video_view`; INSERT INTO `ylrz_saas_tenant`.`fs_user_vip_order` SELECT * FROM `ylrz_saas`.`fs_user_vip_order`; INSERT INTO `ylrz_saas_tenant`.`fs_user_vip_package` SELECT * FROM `ylrz_saas`.`fs_user_vip_package`; INSERT INTO `ylrz_saas_tenant`.`fs_user_watch` SELECT * FROM `ylrz_saas`.`fs_user_watch`; INSERT INTO `ylrz_saas_tenant`.`fs_user_watch_course_statistics` SELECT * FROM `ylrz_saas`.`fs_user_watch_course_statistics`; INSERT INTO `ylrz_saas_tenant`.`fs_user_watch_statistics` SELECT * FROM `ylrz_saas`.`fs_user_watch_statistics`; INSERT INTO `ylrz_saas_tenant`.`fs_user_wx` SELECT * FROM `ylrz_saas`.`fs_user_wx`; -- --- fs_vessel_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`fs_vessel` SELECT * FROM `ylrz_saas`.`fs_vessel`; -- --- fs_video_* (3 tables) --- INSERT INTO `ylrz_saas_tenant`.`fs_video_barrage` SELECT * FROM `ylrz_saas`.`fs_video_barrage`; INSERT INTO `ylrz_saas_tenant`.`fs_video_course_tag` SELECT * FROM `ylrz_saas`.`fs_video_course_tag`; INSERT INTO `ylrz_saas_tenant`.`fs_video_resource` SELECT * FROM `ylrz_saas`.`fs_video_resource`; -- --- fs_wechat_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`fs_wechat_template` SELECT * FROM `ylrz_saas`.`fs_wechat_template`; -- --- hy_watch_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`hy_watch_log` SELECT * FROM `ylrz_saas`.`hy_watch_log`; -- --- hy_work_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`hy_work_task` SELECT * FROM `ylrz_saas`.`hy_work_task`; -- --- ipad_allocation_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`ipad_allocation_records` SELECT * FROM `ylrz_saas`.`ipad_allocation_records`; -- --- live_after_* (3 tables) --- INSERT INTO `ylrz_saas_tenant`.`live_after_sales` SELECT * FROM `ylrz_saas`.`live_after_sales`; INSERT INTO `ylrz_saas_tenant`.`live_after_sales_item` SELECT * FROM `ylrz_saas`.`live_after_sales_item`; INSERT INTO `ylrz_saas_tenant`.`live_after_sales_logs` SELECT * FROM `ylrz_saas`.`live_after_sales_logs`; -- --- live_anchor_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`live_anchor` SELECT * FROM `ylrz_saas`.`live_anchor`; -- --- live_auto_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`live_auto_task` SELECT * FROM `ylrz_saas`.`live_auto_task`; -- --- live_cart_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`live_cart` SELECT * FROM `ylrz_saas`.`live_cart`; -- --- live_completion_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`live_completion_points_record` SELECT * FROM `ylrz_saas`.`live_completion_points_record`; -- --- live_coupon_* (5 tables) --- INSERT INTO `ylrz_saas_tenant`.`live_coupon` SELECT * FROM `ylrz_saas`.`live_coupon`; INSERT INTO `ylrz_saas_tenant`.`live_coupon_issue` SELECT * FROM `ylrz_saas`.`live_coupon_issue`; INSERT INTO `ylrz_saas_tenant`.`live_coupon_issue_relation` SELECT * FROM `ylrz_saas`.`live_coupon_issue_relation`; INSERT INTO `ylrz_saas_tenant`.`live_coupon_issue_user` SELECT * FROM `ylrz_saas`.`live_coupon_issue_user`; INSERT INTO `ylrz_saas_tenant`.`live_coupon_user` SELECT * FROM `ylrz_saas`.`live_coupon_user`; -- --- live_data_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`live_data` SELECT * FROM `ylrz_saas`.`live_data`; -- --- live_event_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`live_event_conf` SELECT * FROM `ylrz_saas`.`live_event_conf`; -- --- live_gift_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`live_gift` SELECT * FROM `ylrz_saas`.`live_gift`; -- --- live_goods_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`live_goods` SELECT * FROM `ylrz_saas`.`live_goods`; -- --- live_lottery_* (3 tables) --- INSERT INTO `ylrz_saas_tenant`.`live_lottery_conf` SELECT * FROM `ylrz_saas`.`live_lottery_conf`; INSERT INTO `ylrz_saas_tenant`.`live_lottery_product_conf` SELECT * FROM `ylrz_saas`.`live_lottery_product_conf`; INSERT INTO `ylrz_saas_tenant`.`live_lottery_registration` SELECT * FROM `ylrz_saas`.`live_lottery_registration`; -- --- live_msg_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`live_msg` SELECT * FROM `ylrz_saas`.`live_msg`; -- --- live_order_* (2 tables) --- INSERT INTO `ylrz_saas_tenant`.`live_order_logs` SELECT * FROM `ylrz_saas`.`live_order_logs`; INSERT INTO `ylrz_saas_tenant`.`live_order_payment_error` SELECT * FROM `ylrz_saas`.`live_order_payment_error`; -- --- live_red_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`live_red_conf` SELECT * FROM `ylrz_saas`.`live_red_conf`; -- --- live_reward_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`live_reward_record` SELECT * FROM `ylrz_saas`.`live_reward_record`; -- --- live_sensitive_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`live_sensitive_words` SELECT * FROM `ylrz_saas`.`live_sensitive_words`; -- --- live_tag_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`live_tag_config` SELECT * FROM `ylrz_saas`.`live_tag_config`; -- --- live_traffic_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`live_traffic_log` SELECT * FROM `ylrz_saas`.`live_traffic_log`; -- --- live_user_* (6 tables) --- INSERT INTO `ylrz_saas_tenant`.`live_user_favorite` SELECT * FROM `ylrz_saas`.`live_user_favorite`; INSERT INTO `ylrz_saas_tenant`.`live_user_first_entry` SELECT * FROM `ylrz_saas`.`live_user_first_entry`; INSERT INTO `ylrz_saas_tenant`.`live_user_follow` SELECT * FROM `ylrz_saas`.`live_user_follow`; INSERT INTO `ylrz_saas_tenant`.`live_user_like` SELECT * FROM `ylrz_saas`.`live_user_like`; INSERT INTO `ylrz_saas_tenant`.`live_user_lottery_record` SELECT * FROM `ylrz_saas`.`live_user_lottery_record`; INSERT INTO `ylrz_saas_tenant`.`live_user_red_record` SELECT * FROM `ylrz_saas`.`live_user_red_record`; -- --- live_watch_* (2 tables) --- INSERT INTO `ylrz_saas_tenant`.`live_watch_log` SELECT * FROM `ylrz_saas`.`live_watch_log`; INSERT INTO `ylrz_saas_tenant`.`live_watch_user` SELECT * FROM `ylrz_saas`.`live_watch_user`; -- --- lobster_compliance_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`lobster_compliance_rule` SELECT * FROM `ylrz_saas`.`lobster_compliance_rule`; -- --- lobster_conversation_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`lobster_conversation_summary` SELECT * FROM `ylrz_saas`.`lobster_conversation_summary`; -- --- lobster_node_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`lobster_node_execution_log` SELECT * FROM `ylrz_saas`.`lobster_node_execution_log`; -- --- lobster_workflow_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`lobster_workflow_instance` SELECT * FROM `ylrz_saas`.`lobster_workflow_instance`; -- --- lucky_bag_* (2 tables) --- INSERT INTO `ylrz_saas_tenant`.`lucky_bag` SELECT * FROM `ylrz_saas`.`lucky_bag`; INSERT INTO `ylrz_saas_tenant`.`lucky_bag_collect_record` SELECT * FROM `ylrz_saas`.`lucky_bag_collect_record`; -- --- qw_app_* (2 tables) --- INSERT INTO `ylrz_saas_tenant`.`qw_app_contact_way` SELECT * FROM `ylrz_saas`.`qw_app_contact_way`; INSERT INTO `ylrz_saas_tenant`.`qw_app_contact_way_logs` SELECT * FROM `ylrz_saas`.`qw_app_contact_way_logs`; -- --- qw_auto_* (3 tables) --- INSERT INTO `ylrz_saas_tenant`.`qw_auto_tags` SELECT * FROM `ylrz_saas`.`qw_auto_tags`; INSERT INTO `ylrz_saas_tenant`.`qw_auto_tags_logs` SELECT * FROM `ylrz_saas`.`qw_auto_tags_logs`; INSERT INTO `ylrz_saas_tenant`.`qw_auto_tags_rules` SELECT * FROM `ylrz_saas`.`qw_auto_tags_rules`; -- --- qw_contact_* (5 tables) --- INSERT INTO `ylrz_saas_tenant`.`qw_contact_batch` SELECT * FROM `ylrz_saas`.`qw_contact_batch`; INSERT INTO `ylrz_saas_tenant`.`qw_contact_way` SELECT * FROM `ylrz_saas`.`qw_contact_way`; INSERT INTO `ylrz_saas_tenant`.`qw_contact_way_group` SELECT * FROM `ylrz_saas`.`qw_contact_way_group`; INSERT INTO `ylrz_saas_tenant`.`qw_contact_way_logs` SELECT * FROM `ylrz_saas`.`qw_contact_way_logs`; INSERT INTO `ylrz_saas_tenant`.`qw_contact_way_user` SELECT * FROM `ylrz_saas`.`qw_contact_way_user`; -- --- qw_course_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`qw_course_finish_remark_rty` SELECT * FROM `ylrz_saas`.`qw_course_finish_remark_rty`; -- --- qw_customer_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`qw_customer_property` SELECT * FROM `ylrz_saas`.`qw_customer_property`; -- --- qw_drainage_* (2 tables) --- INSERT INTO `ylrz_saas_tenant`.`qw_drainage_link` SELECT * FROM `ylrz_saas`.`qw_drainage_link`; INSERT INTO `ylrz_saas_tenant`.`qw_drainage_link_logs` SELECT * FROM `ylrz_saas`.`qw_drainage_link_logs`; -- --- qw_external_* (7 tables) --- INSERT INTO `ylrz_saas_tenant`.`qw_external_ai_analyze` SELECT * FROM `ylrz_saas`.`qw_external_ai_analyze`; INSERT INTO `ylrz_saas_tenant`.`qw_external_contact_black_log` SELECT * FROM `ylrz_saas`.`qw_external_contact_black_log`; INSERT INTO `ylrz_saas_tenant`.`qw_external_contact_crm` SELECT * FROM `ylrz_saas`.`qw_external_contact_crm`; INSERT INTO `ylrz_saas_tenant`.`qw_external_contact_transfer_company_audit` SELECT * FROM `ylrz_saas`.`qw_external_contact_transfer_company_audit`; INSERT INTO `ylrz_saas_tenant`.`qw_external_contact_transfer_company_audit_user` SELECT * FROM `ylrz_saas`.`qw_external_contact_transfer_company_audit_user`; INSERT INTO `ylrz_saas_tenant`.`qw_external_contact_transfer_log` SELECT * FROM `ylrz_saas`.`qw_external_contact_transfer_log`; INSERT INTO `ylrz_saas_tenant`.`qw_external_err_retry` SELECT * FROM `ylrz_saas`.`qw_external_err_retry`; -- --- qw_friend_* (6 tables) --- INSERT INTO `ylrz_saas_tenant`.`qw_friend_circle` SELECT * FROM `ylrz_saas`.`qw_friend_circle`; INSERT INTO `ylrz_saas_tenant`.`qw_friend_circle_task` SELECT * FROM `ylrz_saas`.`qw_friend_circle_task`; INSERT INTO `ylrz_saas_tenant`.`qw_friend_comments` SELECT * FROM `ylrz_saas`.`qw_friend_comments`; INSERT INTO `ylrz_saas_tenant`.`qw_friend_customer_list` SELECT * FROM `ylrz_saas`.`qw_friend_customer_list`; INSERT INTO `ylrz_saas_tenant`.`qw_friend_welcome` SELECT * FROM `ylrz_saas`.`qw_friend_welcome`; INSERT INTO `ylrz_saas_tenant`.`qw_friend_welcome_item` SELECT * FROM `ylrz_saas`.`qw_friend_welcome_item`; -- --- qw_group_* (5 tables) --- INSERT INTO `ylrz_saas_tenant`.`qw_group_chat` SELECT * FROM `ylrz_saas`.`qw_group_chat`; INSERT INTO `ylrz_saas_tenant`.`qw_group_chat_transfer_log` SELECT * FROM `ylrz_saas`.`qw_group_chat_transfer_log`; INSERT INTO `ylrz_saas_tenant`.`qw_group_msg` SELECT * FROM `ylrz_saas`.`qw_group_msg`; INSERT INTO `ylrz_saas_tenant`.`qw_group_msg_item` SELECT * FROM `ylrz_saas`.`qw_group_msg_item`; INSERT INTO `ylrz_saas_tenant`.`qw_group_msg_user` SELECT * FROM `ylrz_saas`.`qw_group_msg_user`; -- --- qw_groupchat_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`qw_groupchat_statistic` SELECT * FROM `ylrz_saas`.`qw_groupchat_statistic`; -- --- qw_information_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`qw_information` SELECT * FROM `ylrz_saas`.`qw_information`; -- --- qw_ipad_* (3 tables) --- INSERT INTO `ylrz_saas_tenant`.`qw_ipad_server` SELECT * FROM `ylrz_saas`.`qw_ipad_server`; INSERT INTO `ylrz_saas_tenant`.`qw_ipad_server_log` SELECT * FROM `ylrz_saas`.`qw_ipad_server_log`; INSERT INTO `ylrz_saas_tenant`.`qw_ipad_server_user` SELECT * FROM `ylrz_saas`.`qw_ipad_server_user`; -- --- qw_material_* (2 tables) --- INSERT INTO `ylrz_saas_tenant`.`qw_material` SELECT * FROM `ylrz_saas`.`qw_material`; INSERT INTO `ylrz_saas_tenant`.`qw_material_group` SELECT * FROM `ylrz_saas`.`qw_material_group`; -- --- qw_messages_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`qw_messages` SELECT * FROM `ylrz_saas`.`qw_messages`; -- --- qw_msg_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`qw_msg` SELECT * FROM `ylrz_saas`.`qw_msg`; -- --- qw_push_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`qw_push_count` SELECT * FROM `ylrz_saas`.`qw_push_count`; -- --- qw_session_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`qw_session` SELECT * FROM `ylrz_saas`.`qw_session`; -- --- qw_sop_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`qw_sop_logs_detalis` SELECT * FROM `ylrz_saas`.`qw_sop_logs_detalis`; -- --- qw_tag_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`qw_tag_group` SELECT * FROM `ylrz_saas`.`qw_tag_group`; -- --- qw_user_* (3 tables) --- INSERT INTO `ylrz_saas_tenant`.`qw_user_complain_record` SELECT * FROM `ylrz_saas`.`qw_user_complain_record`; INSERT INTO `ylrz_saas_tenant`.`qw_user_video` SELECT * FROM `ylrz_saas`.`qw_user_video`; INSERT INTO `ylrz_saas_tenant`.`qw_user_voice_log` SELECT * FROM `ylrz_saas`.`qw_user_voice_log`; -- --- qw_userbehavior_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`qw_userbehavior_data` SELECT * FROM `ylrz_saas`.`qw_userbehavior_data`; -- --- qw_welcome_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`qw_welcome` SELECT * FROM `ylrz_saas`.`qw_welcome`; -- --- qw_work_* (3 tables) --- INSERT INTO `ylrz_saas_tenant`.`qw_work_link` SELECT * FROM `ylrz_saas`.`qw_work_link`; INSERT INTO `ylrz_saas_tenant`.`qw_work_link_user` SELECT * FROM `ylrz_saas`.`qw_work_link_user`; INSERT INTO `ylrz_saas_tenant`.`qw_work_user` SELECT * FROM `ylrz_saas`.`qw_work_user`; -- --- tulin_info_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`tulin_info_sync_log` SELECT * FROM `ylrz_saas`.`tulin_info_sync_log`; -- --- uni_push_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`uni_push_log` SELECT * FROM `ylrz_saas`.`uni_push_log`; -- --- watch_beginner_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`watch_beginner_guide` SELECT * FROM `ylrz_saas`.`watch_beginner_guide`; -- --- watch_device_* (4 tables) --- INSERT INTO `ylrz_saas_tenant`.`watch_device_account` SELECT * FROM `ylrz_saas`.`watch_device_account`; INSERT INTO `ylrz_saas_tenant`.`watch_device_day` SELECT * FROM `ylrz_saas`.`watch_device_day`; INSERT INTO `ylrz_saas_tenant`.`watch_device_info` SELECT * FROM `ylrz_saas`.`watch_device_info`; INSERT INTO `ylrz_saas_tenant`.`watch_device_setup` SELECT * FROM `ylrz_saas`.`watch_device_setup`; -- --- watch_family_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`watch_family_user` SELECT * FROM `ylrz_saas`.`watch_family_user`; -- --- watch_materials_* (2 tables) --- INSERT INTO `ylrz_saas_tenant`.`watch_materials` SELECT * FROM `ylrz_saas`.`watch_materials`; INSERT INTO `ylrz_saas_tenant`.`watch_materials_type` SELECT * FROM `ylrz_saas`.`watch_materials_type`; -- --- watch_medication_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`watch_medication_task` SELECT * FROM `ylrz_saas`.`watch_medication_task`; -- --- watch_monitor_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`watch_monitor_data_type` SELECT * FROM `ylrz_saas`.`watch_monitor_data_type`; -- --- watch_msg_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`watch_msg_set` SELECT * FROM `ylrz_saas`.`watch_msg_set`; -- --- watch_send_* (2 tables) --- INSERT INTO `ylrz_saas_tenant`.`watch_send_msg_log` SELECT * FROM `ylrz_saas`.`watch_send_msg_log`; INSERT INTO `ylrz_saas_tenant`.`watch_send_msg_set` SELECT * FROM `ylrz_saas`.`watch_send_msg_set`; -- --- watch_user_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`watch_user` SELECT * FROM `ylrz_saas`.`watch_user`; -- --- wx_contact_* (1 tables) --- INSERT INTO `ylrz_saas_tenant`.`wx_contact` SELECT * FROM `ylrz_saas`.`wx_contact`; -- ============================================================================ -- 第三阶段: 验证行数一致性 (执行后检查输出，所有 diff 应该为 0) -- ============================================================================ SELECT 'row_diff_check' AS phase, (SELECT COUNT(*) FROM `ylrz_saas`.`ad_domain`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`ad_domain`) AS `ad_domain`, (SELECT COUNT(*) FROM `ylrz_saas`.`ad_dy_account`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`ad_dy_account`) AS `ad_dy_account`, (SELECT COUNT(*) FROM `ylrz_saas`.`ad_dy_api`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`ad_dy_api`) AS `ad_dy_api`, (SELECT COUNT(*) FROM `ylrz_saas`.`ad_html_template`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`ad_html_template`) AS `ad_html_template`, (SELECT COUNT(*) FROM `ylrz_saas`.`ad_iqiyi_account`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`ad_iqiyi_account`) AS `ad_iqiyi_account`, (SELECT COUNT(*) FROM `ylrz_saas`.`ad_site`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`ad_site`) AS `ad_site`, (SELECT COUNT(*) FROM `ylrz_saas`.`ad_upload_log`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`ad_upload_log`) AS `ad_upload_log`, (SELECT COUNT(*) FROM `ylrz_saas`.`ad_youku_account`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`ad_youku_account`) AS `ad_youku_account`, (SELECT COUNT(*) FROM `ylrz_saas`.`ai_knowledge_base`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`ai_knowledge_base`) AS `ai_knowledge_base`, (SELECT COUNT(*) FROM `ylrz_saas`.`bd_api`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`bd_api`) AS `bd_api`, (SELECT COUNT(*) FROM `ylrz_saas`.`bd_creative_statistics`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`bd_creative_statistics`) AS `bd_creative_statistics`, (SELECT COUNT(*) FROM `ylrz_saas`.`bd_report_data`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`bd_report_data`) AS `bd_report_data`, (SELECT COUNT(*) FROM `ylrz_saas`.`chat_dataset`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`chat_dataset`) AS `chat_dataset`, (SELECT COUNT(*) FROM `ylrz_saas`.`chat_dataset_file`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`chat_dataset_file`) AS `chat_dataset_file`, (SELECT COUNT(*) FROM `ylrz_saas`.`chat_keyword`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`chat_keyword`) AS `chat_keyword`, (SELECT COUNT(*) FROM `ylrz_saas`.`chat_msg`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`chat_msg`) AS `chat_msg`, (SELECT COUNT(*) FROM `ylrz_saas`.`chat_msg_logs`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`chat_msg_logs`) AS `chat_msg_logs`, (SELECT COUNT(*) FROM `ylrz_saas`.`chat_role`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`chat_role`) AS `chat_role`, (SELECT COUNT(*) FROM `ylrz_saas`.`chat_session`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`chat_session`) AS `chat_session`, (SELECT COUNT(*) FROM `ylrz_saas`.`chat_user`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`chat_user`) AS `chat_user`, (SELECT COUNT(*) FROM `ylrz_saas`.`cid_ipad_server`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`cid_ipad_server`) AS `cid_ipad_server`, (SELECT COUNT(*) FROM `ylrz_saas`.`cid_ipad_server_user`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`cid_ipad_server_user`) AS `cid_ipad_server_user`, (SELECT COUNT(*) FROM `ylrz_saas`.`company_ai_workflow_node_type`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`company_ai_workflow_node_type`) AS `company_ai_workflow_node_type`, (SELECT COUNT(*) FROM `ylrz_saas`.`company_company_fsuser`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`company_company_fsuser`) AS `company_company_fsuser`, (SELECT COUNT(*) FROM `ylrz_saas`.`company_deduct`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`company_deduct`) AS `company_deduct`, (SELECT COUNT(*) FROM `ylrz_saas`.`company_div_config`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`company_div_config`) AS `company_div_config`, (SELECT COUNT(*) FROM `ylrz_saas`.`company_div_item`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`company_div_item`) AS `company_div_item`, (SELECT COUNT(*) FROM `ylrz_saas`.`company_logininfor`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`company_logininfor`) AS `company_logininfor`, (SELECT COUNT(*) FROM `ylrz_saas`.`company_miniapp`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`company_miniapp`) AS `company_miniapp`, (SELECT COUNT(*) FROM `ylrz_saas`.`company_post`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`company_post`) AS `company_post`, (SELECT COUNT(*) FROM `ylrz_saas`.`company_profit_logs`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`company_profit_logs`) AS `company_profit_logs`, (SELECT COUNT(*) FROM `ylrz_saas`.`company_recharge`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`company_recharge`) AS `company_recharge`, (SELECT COUNT(*) FROM `ylrz_saas`.`company_role_dept`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`company_role_dept`) AS `company_role_dept`, (SELECT COUNT(*) FROM `ylrz_saas`.`company_role_menu`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`company_role_menu`) AS `company_role_menu`, (SELECT COUNT(*) FROM `ylrz_saas`.`company_sop_role`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`company_sop_role`) AS `company_sop_role`, (SELECT COUNT(*) FROM `ylrz_saas`.`company_tag`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`company_tag`) AS `company_tag`, (SELECT COUNT(*) FROM `ylrz_saas`.`company_tag_user`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`company_tag_user`) AS `company_tag_user`, (SELECT COUNT(*) FROM `ylrz_saas`.`company_tcm_consume`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`company_tcm_consume`) AS `company_tcm_consume`, (SELECT COUNT(*) FROM `ylrz_saas`.`company_tcm_report`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`company_tcm_report`) AS `company_tcm_report`, (SELECT COUNT(*) FROM `ylrz_saas`.`company_tcm_schedule`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`company_tcm_schedule`) AS `company_tcm_schedule`, (SELECT COUNT(*) FROM `ylrz_saas`.`company_user_card`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`company_user_card`) AS `company_user_card`, (SELECT COUNT(*) FROM `ylrz_saas`.`company_user_change_apply_user`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`company_user_change_apply_user`) AS `company_user_change_apply_user`, (SELECT COUNT(*) FROM `ylrz_saas`.`company_user_delay_time`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`company_user_delay_time`) AS `company_user_delay_time`, (SELECT COUNT(*) FROM `ylrz_saas`.`company_user_post`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`company_user_post`) AS `company_user_post`, (SELECT COUNT(*) FROM `ylrz_saas`.`company_user_user`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`company_user_user`) AS `company_user_user`, (SELECT COUNT(*) FROM `ylrz_saas`.`company_voice`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`company_voice`) AS `company_voice`, (SELECT COUNT(*) FROM `ylrz_saas`.`company_voice_config`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`company_voice_config`) AS `company_voice_config`, (SELECT COUNT(*) FROM `ylrz_saas`.`company_voice_dialog`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`company_voice_dialog`) AS `company_voice_dialog`, (SELECT COUNT(*) FROM `ylrz_saas`.`company_voice_mobile`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`company_voice_mobile`) AS `company_voice_mobile`, (SELECT COUNT(*) FROM `ylrz_saas`.`company_voice_package`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`company_voice_package`) AS `company_voice_package`, (SELECT COUNT(*) FROM `ylrz_saas`.`company_voice_robotic_call_log_addwx`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`company_voice_robotic_call_log_addwx`) AS `company_voice_robotic_call_log_addwx`, (SELECT COUNT(*) FROM `ylrz_saas`.`company_voice_robotic_call_log_sendmsg`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`company_voice_robotic_call_log_sendmsg`) AS `company_voice_robotic_call_log_sendmsg`, (SELECT COUNT(*) FROM `ylrz_saas`.`company_workflow_lobster`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`company_workflow_lobster`) AS `company_workflow_lobster`, (SELECT COUNT(*) FROM `ylrz_saas`.`company_workflow_lobster_edge`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`company_workflow_lobster_edge`) AS `company_workflow_lobster_edge`, (SELECT COUNT(*) FROM `ylrz_saas`.`company_workflow_lobster_node`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`company_workflow_lobster_node`) AS `company_workflow_lobster_node`, (SELECT COUNT(*) FROM `ylrz_saas`.`company_workflow_lobster_record`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`company_workflow_lobster_record`) AS `company_workflow_lobster_record`, (SELECT COUNT(*) FROM `ylrz_saas`.`company_workflow_lobster_task`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`company_workflow_lobster_task`) AS `company_workflow_lobster_task`, (SELECT COUNT(*) FROM `ylrz_saas`.`company_workflow_lobster_variable`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`company_workflow_lobster_variable`) AS `company_workflow_lobster_variable`, (SELECT COUNT(*) FROM `ylrz_saas`.`company_wx_chat`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`company_wx_chat`) AS `company_wx_chat`, (SELECT COUNT(*) FROM `ylrz_saas`.`company_wx_user_group`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`company_wx_user_group`) AS `company_wx_user_group`, (SELECT COUNT(*) FROM `ylrz_saas`.`crm_customer_analyze`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`crm_customer_analyze`) AS `crm_customer_analyze`, (SELECT COUNT(*) FROM `ylrz_saas`.`crm_customer_assign`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`crm_customer_assign`) AS `crm_customer_assign`, (SELECT COUNT(*) FROM `ylrz_saas`.`crm_customer_contacts`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`crm_customer_contacts`) AS `crm_customer_contacts`, (SELECT COUNT(*) FROM `ylrz_saas`.`crm_customer_ext`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`crm_customer_ext`) AS `crm_customer_ext`, (SELECT COUNT(*) FROM `ylrz_saas`.`crm_customer_his_order`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`crm_customer_his_order`) AS `crm_customer_his_order`, (SELECT COUNT(*) FROM `ylrz_saas`.`crm_customer_logs`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`crm_customer_logs`) AS `crm_customer_logs`, (SELECT COUNT(*) FROM `ylrz_saas`.`crm_customer_third`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`crm_customer_third`) AS `crm_customer_third`, (SELECT COUNT(*) FROM `ylrz_saas`.`crm_customer_user`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`crm_customer_user`) AS `crm_customer_user`, (SELECT COUNT(*) FROM `ylrz_saas`.`crm_event`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`crm_event`) AS `crm_event`, (SELECT COUNT(*) FROM `ylrz_saas`.`crm_msg`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`crm_msg`) AS `crm_msg`, (SELECT COUNT(*) FROM `ylrz_saas`.`customer_transfer_approval`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`customer_transfer_approval`) AS `customer_transfer_approval`, (SELECT COUNT(*) FROM `ylrz_saas`.`fastgpt_chat_artificial_words`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fastgpt_chat_artificial_words`) AS `fastgpt_chat_artificial_words`, (SELECT COUNT(*) FROM `ylrz_saas`.`fastgpt_chat_keyword`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fastgpt_chat_keyword`) AS `fastgpt_chat_keyword`, (SELECT COUNT(*) FROM `ylrz_saas`.`fastgpt_chat_msg_logs`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fastgpt_chat_msg_logs`) AS `fastgpt_chat_msg_logs`, (SELECT COUNT(*) FROM `ylrz_saas`.`fastgpt_chat_replace_text`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fastgpt_chat_replace_text`) AS `fastgpt_chat_replace_text`, (SELECT COUNT(*) FROM `ylrz_saas`.`fastgpt_chat_replace_words`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fastgpt_chat_replace_words`) AS `fastgpt_chat_replace_words`, (SELECT COUNT(*) FROM `ylrz_saas`.`fastgpt_chat_voice_homo`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fastgpt_chat_voice_homo`) AS `fastgpt_chat_voice_homo`, (SELECT COUNT(*) FROM `ylrz_saas`.`fastgpt_collection`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fastgpt_collection`) AS `fastgpt_collection`, (SELECT COUNT(*) FROM `ylrz_saas`.`fastgpt_collention_data`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fastgpt_collention_data`) AS `fastgpt_collention_data`, (SELECT COUNT(*) FROM `ylrz_saas`.`fastgpt_dataset`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fastgpt_dataset`) AS `fastgpt_dataset`, (SELECT COUNT(*) FROM `ylrz_saas`.`fastgpt_event_log`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fastgpt_event_log`) AS `fastgpt_event_log`, (SELECT COUNT(*) FROM `ylrz_saas`.`fastgpt_event_log_total`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fastgpt_event_log_total`) AS `fastgpt_event_log_total`, (SELECT COUNT(*) FROM `ylrz_saas`.`fastgpt_ext_user_tag`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fastgpt_ext_user_tag`) AS `fastgpt_ext_user_tag`, (SELECT COUNT(*) FROM `ylrz_saas`.`fastgpt_keyword`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fastgpt_keyword`) AS `fastgpt_keyword`, (SELECT COUNT(*) FROM `ylrz_saas`.`fastgpt_keyword_artificial`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fastgpt_keyword_artificial`) AS `fastgpt_keyword_artificial`, (SELECT COUNT(*) FROM `ylrz_saas`.`fastgpt_keyword_send`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fastgpt_keyword_send`) AS `fastgpt_keyword_send`, (SELECT COUNT(*) FROM `ylrz_saas`.`fastgpt_push_token_total`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fastgpt_push_token_total`) AS `fastgpt_push_token_total`, (SELECT COUNT(*) FROM `ylrz_saas`.`fastgpt_role_tag`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fastgpt_role_tag`) AS `fastgpt_role_tag`, (SELECT COUNT(*) FROM `ylrz_saas`.`fastgpt_tag`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fastgpt_tag`) AS `fastgpt_tag`, (SELECT COUNT(*) FROM `ylrz_saas`.`fastgpt_tag_group`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fastgpt_tag_group`) AS `fastgpt_tag_group`, (SELECT COUNT(*) FROM `ylrz_saas`.`fastgpt_user`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fastgpt_user`) AS `fastgpt_user`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_adv_sem`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_adv_sem`) AS `fs_adv_sem`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_ai_workflow_edge`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_ai_workflow_edge`) AS `fs_ai_workflow_edge`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_ai_workflow_node_type`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_ai_workflow_node_type`) AS `fs_ai_workflow_node_type`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_app_contact_way`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_app_contact_way`) AS `fs_app_contact_way`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_app_version`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_app_version`) AS `fs_app_version`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_article`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_article`) AS `fs_article`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_article_cate`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_article_cate`) AS `fs_article_cate`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_article_views`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_article_views`) AS `fs_article_views`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_chinese_medicine`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_chinese_medicine`) AS `fs_chinese_medicine`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_city`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_city`) AS `fs_city`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_complaint_template`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_complaint_template`) AS `fs_complaint_template`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_coupon`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_coupon`) AS `fs_coupon`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_course_domain_name`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_course_domain_name`) AS `fs_course_domain_name`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_course_finish_temp`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_course_finish_temp`) AS `fs_course_finish_temp`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_course_finish_temp_parent`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_course_finish_temp_parent`) AS `fs_course_finish_temp_parent`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_course_link`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_course_link`) AS `fs_course_link`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_course_product`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_course_product`) AS `fs_course_product`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_course_product_order`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_course_product_order`) AS `fs_course_product_order`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_course_question_bank`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_course_question_bank`) AS `fs_course_question_bank`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_course_question_category`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_course_question_category`) AS `fs_course_question_category`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_course_sop`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_course_sop`) AS `fs_course_sop`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_course_sop_app_link`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_course_sop_app_link`) AS `fs_course_sop_app_link`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_course_sop_logs`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_course_sop_logs`) AS `fs_course_sop_logs`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_course_watch_comment`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_course_watch_comment`) AS `fs_course_watch_comment`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_df_account`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_df_account`) AS `fs_df_account`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_disease`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_disease`) AS `fs_disease`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_doctor_ai_chat_log`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_doctor_ai_chat_log`) AS `fs_doctor_ai_chat_log`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_doctor_ai_chat_msg`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_doctor_ai_chat_msg`) AS `fs_doctor_ai_chat_msg`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_doctor_ai_chat_session`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_doctor_ai_chat_session`) AS `fs_doctor_ai_chat_session`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_doctor_article`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_doctor_article`) AS `fs_doctor_article`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_doctor_article_cate`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_doctor_article_cate`) AS `fs_doctor_article_cate`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_doctor_bill`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_doctor_bill`) AS `fs_doctor_bill`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_doctor_confirm`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_doctor_confirm`) AS `fs_doctor_confirm`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_doctor_extract`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_doctor_extract`) AS `fs_doctor_extract`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_doctor_oper_log`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_doctor_oper_log`) AS `fs_doctor_oper_log`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_doctor_prescribe`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_doctor_prescribe`) AS `fs_doctor_prescribe`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_doctor_prescribe_drug`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_doctor_prescribe_drug`) AS `fs_doctor_prescribe_drug`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_doctor_price`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_doctor_price`) AS `fs_doctor_price`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_doctor_product`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_doctor_product`) AS `fs_doctor_product`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_doctor_words`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_doctor_words`) AS `fs_doctor_words`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_drug_report`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_drug_report`) AS `fs_drug_report`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_drug_report_count`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_drug_report_count`) AS `fs_drug_report_count`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_express`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_express`) AS `fs_express`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_famous_prescribe`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_famous_prescribe`) AS `fs_famous_prescribe`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_finish_course_statistics_sync`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_finish_course_statistics_sync`) AS `fs_finish_course_statistics_sync`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_first_diagnosis`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_first_diagnosis`) AS `fs_first_diagnosis`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_follow`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_follow`) AS `fs_follow`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_follow_report`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_follow_report`) AS `fs_follow_report`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_follow_temp`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_follow_temp`) AS `fs_follow_temp`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_health_data`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_health_data`) AS `fs_health_data`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_health_history_temp`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_health_history_temp`) AS `fs_health_history_temp`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_health_life`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_health_life`) AS `fs_health_life`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_health_record`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_health_record`) AS `fs_health_record`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_health_tongue`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_health_tongue`) AS `fs_health_tongue`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_hfpay_config`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_hfpay_config`) AS `fs_hfpay_config`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_icd`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_icd`) AS `fs_icd`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_illness_library`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_illness_library`) AS `fs_illness_library`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_im_msg_send_detail`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_im_msg_send_detail`) AS `fs_im_msg_send_detail`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_im_msg_send_log`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_im_msg_send_log`) AS `fs_im_msg_send_log`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_inquiry_disease`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_inquiry_disease`) AS `fs_inquiry_disease`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_inquiry_order_logs`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_inquiry_order_logs`) AS `fs_inquiry_order_logs`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_inquiry_order_media`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_inquiry_order_media`) AS `fs_inquiry_order_media`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_inquiry_order_msg`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_inquiry_order_msg`) AS `fs_inquiry_order_msg`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_inquiry_order_ping`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_inquiry_order_ping`) AS `fs_inquiry_order_ping`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_inquiry_patient_info`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_inquiry_patient_info`) AS `fs_inquiry_patient_info`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_inquiry_temp`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_inquiry_temp`) AS `fs_inquiry_temp`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_integral_cart`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_integral_cart`) AS `fs_integral_cart`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_integral_order`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_integral_order`) AS `fs_integral_order`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_integral_order_logs`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_integral_order_logs`) AS `fs_integral_order_logs`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_interest_ai_msg`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_interest_ai_msg`) AS `fs_interest_ai_msg`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_interest_ai_role`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_interest_ai_role`) AS `fs_interest_ai_role`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_interest_ai_role_words`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_interest_ai_role_words`) AS `fs_interest_ai_role_words`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_interest_ai_session`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_interest_ai_session`) AS `fs_interest_ai_session`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_material`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_material`) AS `fs_material`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_material_group`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_material_group`) AS `fs_material_group`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_medicated_food`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_medicated_food`) AS `fs_medicated_food`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_mess_temp`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_mess_temp`) AS `fs_mess_temp`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_package_cate`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_package_cate`) AS `fs_package_cate`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_package_favorite`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_package_favorite`) AS `fs_package_favorite`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_package_solar_term`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_package_solar_term`) AS `fs_package_solar_term`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_physical_report_template`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_physical_report_template`) AS `fs_physical_report_template`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_physical_report_template_field`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_physical_report_template_field`) AS `fs_physical_report_template_field`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_prescribe`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_prescribe`) AS `fs_prescribe`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_promotional_active`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_promotional_active`) AS `fs_promotional_active`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_promotional_active_log`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_promotional_active_log`) AS `fs_promotional_active_log`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_question_and_answer`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_question_and_answer`) AS `fs_question_and_answer`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_questions`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_questions`) AS `fs_questions`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_statis_qw_temp_param`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_statis_qw_temp_param`) AS `fs_statis_qw_temp_param`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_statis_qw_watch`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_statis_qw_watch`) AS `fs_statis_qw_watch`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_statis_saler_watch`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_statis_saler_watch`) AS `fs_statis_saler_watch`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_statis_temp_fsuser`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_statis_temp_fsuser`) AS `fs_statis_temp_fsuser`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_statis_temp_param`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_statis_temp_param`) AS `fs_statis_temp_param`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_statistics`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_statistics`) AS `fs_statistics`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_store`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_store`) AS `fs_store`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_store_activity`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_store_activity`) AS `fs_store_activity`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_store_activity_scrm`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_store_activity_scrm`) AS `fs_store_activity_scrm`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_store_after_sales`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_store_after_sales`) AS `fs_store_after_sales`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_store_after_sales_item`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_store_after_sales_item`) AS `fs_store_after_sales_item`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_store_after_sales_logs`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_store_after_sales_logs`) AS `fs_store_after_sales_logs`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_store_after_sales_logs_scrm`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_store_after_sales_logs_scrm`) AS `fs_store_after_sales_logs_scrm`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_store_bill`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_store_bill`) AS `fs_store_bill`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_store_bill_scrm`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_store_bill_scrm`) AS `fs_store_bill_scrm`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_store_canvas_scrm`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_store_canvas_scrm`) AS `fs_store_canvas_scrm`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_store_cart_scrm`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_store_cart_scrm`) AS `fs_store_cart_scrm`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_store_coupon_issue_scrm`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_store_coupon_issue_scrm`) AS `fs_store_coupon_issue_scrm`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_store_coupon_issue_user_scrm`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_store_coupon_issue_user_scrm`) AS `fs_store_coupon_issue_user_scrm`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_store_coupon_scrm`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_store_coupon_scrm`) AS `fs_store_coupon_scrm`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_store_coupon_user_scrm`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_store_coupon_user_scrm`) AS `fs_store_coupon_user_scrm`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_store_extract`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_store_extract`) AS `fs_store_extract`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_store_order_audit_scrm`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_store_order_audit_scrm`) AS `fs_store_order_audit_scrm`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_store_order_bill_log`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_store_order_bill_log`) AS `fs_store_order_bill_log`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_store_order_logs`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_store_order_logs`) AS `fs_store_order_logs`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_store_order_logs_scrm`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_store_order_logs_scrm`) AS `fs_store_order_logs_scrm`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_store_order_notice_scrm`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_store_order_notice_scrm`) AS `fs_store_order_notice_scrm`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_store_payment_error`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_store_payment_error`) AS `fs_store_payment_error`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_store_product`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_store_product`) AS `fs_store_product`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_store_product_attr`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_store_product_attr`) AS `fs_store_product_attr`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_store_product_attr_scrm`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_store_product_attr_scrm`) AS `fs_store_product_attr_scrm`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_store_product_attr_value`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_store_product_attr_value`) AS `fs_store_product_attr_value`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_store_product_category`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_store_product_category`) AS `fs_store_product_category`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_store_product_details_scrm`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_store_product_details_scrm`) AS `fs_store_product_details_scrm`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_store_product_group`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_store_product_group`) AS `fs_store_product_group`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_store_product_group_scrm`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_store_product_group_scrm`) AS `fs_store_product_group_scrm`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_store_product_package`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_store_product_package`) AS `fs_store_product_package`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_store_product_purchase_limit_scrm`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_store_product_purchase_limit_scrm`) AS `fs_store_product_purchase_limit_scrm`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_store_product_relation_scrm`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_store_product_relation_scrm`) AS `fs_store_product_relation_scrm`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_store_product_reply_scrm`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_store_product_reply_scrm`) AS `fs_store_product_reply_scrm`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_store_product_rule_scrm`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_store_product_rule_scrm`) AS `fs_store_product_rule_scrm`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_store_product_template_scrm`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_store_product_template_scrm`) AS `fs_store_product_template_scrm`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_store_recommend_scrm`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_store_recommend_scrm`) AS `fs_store_recommend_scrm`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_store_shop_staff_scrm`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_store_shop_staff_scrm`) AS `fs_store_shop_staff_scrm`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_store_sub_order`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_store_sub_order`) AS `fs_store_sub_order`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_store_visit_scrm`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_store_visit_scrm`) AS `fs_store_visit_scrm`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_test_report`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_test_report`) AS `fs_test_report`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_test_temp`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_test_temp`) AS `fs_test_temp`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_test_temp_item`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_test_temp_item`) AS `fs_test_temp_item`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_tongue_info`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_tongue_info`) AS `fs_tongue_info`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_address`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_address`) AS `fs_user_address`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_bill`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_bill`) AS `fs_user_bill`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_company_bind`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_company_bind`) AS `fs_user_company_bind`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_company_package_scrm`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_company_package_scrm`) AS `fs_user_company_package_scrm`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_company_user`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_company_user`) AS `fs_user_company_user`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_company_user_qw`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_company_user_qw`) AS `fs_user_company_user_qw`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_complaint`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_complaint`) AS `fs_user_complaint`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_complaint_msg`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_complaint_msg`) AS `fs_user_complaint_msg`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_course_comment`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_course_comment`) AS `fs_user_course_comment`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_course_comment_like`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_course_comment_like`) AS `fs_user_course_comment_like`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_course_company_statistics`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_course_company_statistics`) AS `fs_user_course_company_statistics`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_course_complaint_record`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_course_complaint_record`) AS `fs_user_course_complaint_record`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_course_complaint_type`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_course_complaint_type`) AS `fs_user_course_complaint_type`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_course_count`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_course_count`) AS `fs_user_course_count`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_course_favorite`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_course_favorite`) AS `fs_user_course_favorite`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_course_follow`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_course_follow`) AS `fs_user_course_follow`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_course_like`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_course_like`) AS `fs_user_course_like`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_course_note`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_course_note`) AS `fs_user_course_note`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_course_note_like`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_course_note_like`) AS `fs_user_course_note_like`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_course_note_save`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_course_note_save`) AS `fs_user_course_note_save`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_course_order`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_course_order`) AS `fs_user_course_order`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_course_study`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_course_study`) AS `fs_user_course_study`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_course_study_log`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_course_study_log`) AS `fs_user_course_study_log`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_course_video_red_package`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_course_video_red_package`) AS `fs_user_course_video_red_package`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_doctor`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_doctor`) AS `fs_user_doctor`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_extract`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_extract`) AS `fs_user_extract`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_information_collection_schedule`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_information_collection_schedule`) AS `fs_user_information_collection_schedule`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_integral_logs`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_integral_logs`) AS `fs_user_integral_logs`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_invited`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_invited`) AS `fs_user_invited`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_login_log`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_login_log`) AS `fs_user_login_log`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_new_task`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_new_task`) AS `fs_user_new_task`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_online_state`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_online_state`) AS `fs_user_online_state`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_operation_log`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_operation_log`) AS `fs_user_operation_log`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_project_tag`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_project_tag`) AS `fs_user_project_tag`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_recharge`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_recharge`) AS `fs_user_recharge`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_sign`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_sign`) AS `fs_user_sign`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_talent`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_talent`) AS `fs_user_talent`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_talent_follow`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_talent_follow`) AS `fs_user_talent_follow`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_video`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_video`) AS `fs_user_video`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_video_comment`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_video_comment`) AS `fs_user_video_comment`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_video_comment_like`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_video_comment_like`) AS `fs_user_video_comment_like`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_video_favorite`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_video_favorite`) AS `fs_user_video_favorite`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_video_like`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_video_like`) AS `fs_user_video_like`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_video_tags`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_video_tags`) AS `fs_user_video_tags`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_video_view`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_video_view`) AS `fs_user_video_view`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_vip_order`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_vip_order`) AS `fs_user_vip_order`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_vip_package`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_vip_package`) AS `fs_user_vip_package`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_watch`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_watch`) AS `fs_user_watch`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_watch_course_statistics`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_watch_course_statistics`) AS `fs_user_watch_course_statistics`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_watch_statistics`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_watch_statistics`) AS `fs_user_watch_statistics`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_user_wx`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_user_wx`) AS `fs_user_wx`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_vessel`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_vessel`) AS `fs_vessel`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_video_barrage`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_video_barrage`) AS `fs_video_barrage`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_video_course_tag`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_video_course_tag`) AS `fs_video_course_tag`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_video_resource`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_video_resource`) AS `fs_video_resource`, (SELECT COUNT(*) FROM `ylrz_saas`.`fs_wechat_template`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`fs_wechat_template`) AS `fs_wechat_template`, (SELECT COUNT(*) FROM `ylrz_saas`.`hy_watch_log`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`hy_watch_log`) AS `hy_watch_log`, (SELECT COUNT(*) FROM `ylrz_saas`.`hy_work_task`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`hy_work_task`) AS `hy_work_task`, (SELECT COUNT(*) FROM `ylrz_saas`.`ipad_allocation_records`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`ipad_allocation_records`) AS `ipad_allocation_records`, (SELECT COUNT(*) FROM `ylrz_saas`.`live_after_sales`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`live_after_sales`) AS `live_after_sales`, (SELECT COUNT(*) FROM `ylrz_saas`.`live_after_sales_item`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`live_after_sales_item`) AS `live_after_sales_item`, (SELECT COUNT(*) FROM `ylrz_saas`.`live_after_sales_logs`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`live_after_sales_logs`) AS `live_after_sales_logs`, (SELECT COUNT(*) FROM `ylrz_saas`.`live_anchor`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`live_anchor`) AS `live_anchor`, (SELECT COUNT(*) FROM `ylrz_saas`.`live_auto_task`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`live_auto_task`) AS `live_auto_task`, (SELECT COUNT(*) FROM `ylrz_saas`.`live_cart`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`live_cart`) AS `live_cart`, (SELECT COUNT(*) FROM `ylrz_saas`.`live_completion_points_record`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`live_completion_points_record`) AS `live_completion_points_record`, (SELECT COUNT(*) FROM `ylrz_saas`.`live_coupon`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`live_coupon`) AS `live_coupon`, (SELECT COUNT(*) FROM `ylrz_saas`.`live_coupon_issue`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`live_coupon_issue`) AS `live_coupon_issue`, (SELECT COUNT(*) FROM `ylrz_saas`.`live_coupon_issue_relation`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`live_coupon_issue_relation`) AS `live_coupon_issue_relation`, (SELECT COUNT(*) FROM `ylrz_saas`.`live_coupon_issue_user`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`live_coupon_issue_user`) AS `live_coupon_issue_user`, (SELECT COUNT(*) FROM `ylrz_saas`.`live_coupon_user`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`live_coupon_user`) AS `live_coupon_user`, (SELECT COUNT(*) FROM `ylrz_saas`.`live_data`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`live_data`) AS `live_data`, (SELECT COUNT(*) FROM `ylrz_saas`.`live_event_conf`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`live_event_conf`) AS `live_event_conf`, (SELECT COUNT(*) FROM `ylrz_saas`.`live_gift`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`live_gift`) AS `live_gift`, (SELECT COUNT(*) FROM `ylrz_saas`.`live_goods`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`live_goods`) AS `live_goods`, (SELECT COUNT(*) FROM `ylrz_saas`.`live_lottery_conf`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`live_lottery_conf`) AS `live_lottery_conf`, (SELECT COUNT(*) FROM `ylrz_saas`.`live_lottery_product_conf`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`live_lottery_product_conf`) AS `live_lottery_product_conf`, (SELECT COUNT(*) FROM `ylrz_saas`.`live_lottery_registration`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`live_lottery_registration`) AS `live_lottery_registration`, (SELECT COUNT(*) FROM `ylrz_saas`.`live_msg`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`live_msg`) AS `live_msg`, (SELECT COUNT(*) FROM `ylrz_saas`.`live_order_logs`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`live_order_logs`) AS `live_order_logs`, (SELECT COUNT(*) FROM `ylrz_saas`.`live_order_payment_error`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`live_order_payment_error`) AS `live_order_payment_error`, (SELECT COUNT(*) FROM `ylrz_saas`.`live_red_conf`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`live_red_conf`) AS `live_red_conf`, (SELECT COUNT(*) FROM `ylrz_saas`.`live_reward_record`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`live_reward_record`) AS `live_reward_record`, (SELECT COUNT(*) FROM `ylrz_saas`.`live_sensitive_words`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`live_sensitive_words`) AS `live_sensitive_words`, (SELECT COUNT(*) FROM `ylrz_saas`.`live_tag_config`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`live_tag_config`) AS `live_tag_config`, (SELECT COUNT(*) FROM `ylrz_saas`.`live_traffic_log`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`live_traffic_log`) AS `live_traffic_log`, (SELECT COUNT(*) FROM `ylrz_saas`.`live_user_favorite`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`live_user_favorite`) AS `live_user_favorite`, (SELECT COUNT(*) FROM `ylrz_saas`.`live_user_first_entry`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`live_user_first_entry`) AS `live_user_first_entry`, (SELECT COUNT(*) FROM `ylrz_saas`.`live_user_follow`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`live_user_follow`) AS `live_user_follow`, (SELECT COUNT(*) FROM `ylrz_saas`.`live_user_like`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`live_user_like`) AS `live_user_like`, (SELECT COUNT(*) FROM `ylrz_saas`.`live_user_lottery_record`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`live_user_lottery_record`) AS `live_user_lottery_record`, (SELECT COUNT(*) FROM `ylrz_saas`.`live_user_red_record`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`live_user_red_record`) AS `live_user_red_record`, (SELECT COUNT(*) FROM `ylrz_saas`.`live_watch_log`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`live_watch_log`) AS `live_watch_log`, (SELECT COUNT(*) FROM `ylrz_saas`.`live_watch_user`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`live_watch_user`) AS `live_watch_user`, (SELECT COUNT(*) FROM `ylrz_saas`.`lobster_compliance_rule`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`lobster_compliance_rule`) AS `lobster_compliance_rule`, (SELECT COUNT(*) FROM `ylrz_saas`.`lobster_conversation_summary`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`lobster_conversation_summary`) AS `lobster_conversation_summary`, (SELECT COUNT(*) FROM `ylrz_saas`.`lobster_node_execution_log`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`lobster_node_execution_log`) AS `lobster_node_execution_log`, (SELECT COUNT(*) FROM `ylrz_saas`.`lobster_workflow_instance`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`lobster_workflow_instance`) AS `lobster_workflow_instance`, (SELECT COUNT(*) FROM `ylrz_saas`.`lucky_bag`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`lucky_bag`) AS `lucky_bag`, (SELECT COUNT(*) FROM `ylrz_saas`.`lucky_bag_collect_record`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`lucky_bag_collect_record`) AS `lucky_bag_collect_record`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_app_contact_way`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_app_contact_way`) AS `qw_app_contact_way`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_app_contact_way_logs`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_app_contact_way_logs`) AS `qw_app_contact_way_logs`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_auto_tags`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_auto_tags`) AS `qw_auto_tags`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_auto_tags_logs`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_auto_tags_logs`) AS `qw_auto_tags_logs`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_auto_tags_rules`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_auto_tags_rules`) AS `qw_auto_tags_rules`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_contact_batch`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_contact_batch`) AS `qw_contact_batch`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_contact_way`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_contact_way`) AS `qw_contact_way`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_contact_way_group`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_contact_way_group`) AS `qw_contact_way_group`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_contact_way_logs`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_contact_way_logs`) AS `qw_contact_way_logs`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_contact_way_user`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_contact_way_user`) AS `qw_contact_way_user`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_course_finish_remark_rty`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_course_finish_remark_rty`) AS `qw_course_finish_remark_rty`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_customer_property`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_customer_property`) AS `qw_customer_property`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_drainage_link`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_drainage_link`) AS `qw_drainage_link`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_drainage_link_logs`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_drainage_link_logs`) AS `qw_drainage_link_logs`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_external_ai_analyze`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_external_ai_analyze`) AS `qw_external_ai_analyze`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_external_contact_black_log`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_external_contact_black_log`) AS `qw_external_contact_black_log`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_external_contact_crm`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_external_contact_crm`) AS `qw_external_contact_crm`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_external_contact_transfer_company_audit`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_external_contact_transfer_company_audit`) AS `qw_external_contact_transfer_company_audit`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_external_contact_transfer_company_audit_user`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_external_contact_transfer_company_audit_user`) AS `qw_external_contact_transfer_company_audit_user`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_external_contact_transfer_log`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_external_contact_transfer_log`) AS `qw_external_contact_transfer_log`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_external_err_retry`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_external_err_retry`) AS `qw_external_err_retry`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_friend_circle`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_friend_circle`) AS `qw_friend_circle`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_friend_circle_task`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_friend_circle_task`) AS `qw_friend_circle_task`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_friend_comments`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_friend_comments`) AS `qw_friend_comments`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_friend_customer_list`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_friend_customer_list`) AS `qw_friend_customer_list`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_friend_welcome`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_friend_welcome`) AS `qw_friend_welcome`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_friend_welcome_item`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_friend_welcome_item`) AS `qw_friend_welcome_item`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_group_chat`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_group_chat`) AS `qw_group_chat`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_group_chat_transfer_log`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_group_chat_transfer_log`) AS `qw_group_chat_transfer_log`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_group_msg`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_group_msg`) AS `qw_group_msg`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_group_msg_item`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_group_msg_item`) AS `qw_group_msg_item`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_group_msg_user`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_group_msg_user`) AS `qw_group_msg_user`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_groupchat_statistic`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_groupchat_statistic`) AS `qw_groupchat_statistic`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_information`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_information`) AS `qw_information`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_ipad_server`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_ipad_server`) AS `qw_ipad_server`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_ipad_server_log`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_ipad_server_log`) AS `qw_ipad_server_log`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_ipad_server_user`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_ipad_server_user`) AS `qw_ipad_server_user`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_material`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_material`) AS `qw_material`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_material_group`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_material_group`) AS `qw_material_group`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_messages`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_messages`) AS `qw_messages`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_msg`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_msg`) AS `qw_msg`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_push_count`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_push_count`) AS `qw_push_count`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_session`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_session`) AS `qw_session`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_sop_logs_detalis`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_sop_logs_detalis`) AS `qw_sop_logs_detalis`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_tag_group`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_tag_group`) AS `qw_tag_group`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_user_complain_record`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_user_complain_record`) AS `qw_user_complain_record`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_user_video`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_user_video`) AS `qw_user_video`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_user_voice_log`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_user_voice_log`) AS `qw_user_voice_log`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_userbehavior_data`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_userbehavior_data`) AS `qw_userbehavior_data`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_welcome`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_welcome`) AS `qw_welcome`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_work_link`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_work_link`) AS `qw_work_link`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_work_link_user`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_work_link_user`) AS `qw_work_link_user`, (SELECT COUNT(*) FROM `ylrz_saas`.`qw_work_user`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`qw_work_user`) AS `qw_work_user`, (SELECT COUNT(*) FROM `ylrz_saas`.`tulin_info_sync_log`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`tulin_info_sync_log`) AS `tulin_info_sync_log`, (SELECT COUNT(*) FROM `ylrz_saas`.`uni_push_log`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`uni_push_log`) AS `uni_push_log`, (SELECT COUNT(*) FROM `ylrz_saas`.`watch_beginner_guide`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`watch_beginner_guide`) AS `watch_beginner_guide`, (SELECT COUNT(*) FROM `ylrz_saas`.`watch_device_account`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`watch_device_account`) AS `watch_device_account`, (SELECT COUNT(*) FROM `ylrz_saas`.`watch_device_day`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`watch_device_day`) AS `watch_device_day`, (SELECT COUNT(*) FROM `ylrz_saas`.`watch_device_info`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`watch_device_info`) AS `watch_device_info`, (SELECT COUNT(*) FROM `ylrz_saas`.`watch_device_setup`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`watch_device_setup`) AS `watch_device_setup`, (SELECT COUNT(*) FROM `ylrz_saas`.`watch_family_user`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`watch_family_user`) AS `watch_family_user`, (SELECT COUNT(*) FROM `ylrz_saas`.`watch_materials`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`watch_materials`) AS `watch_materials`, (SELECT COUNT(*) FROM `ylrz_saas`.`watch_materials_type`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`watch_materials_type`) AS `watch_materials_type`, (SELECT COUNT(*) FROM `ylrz_saas`.`watch_medication_task`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`watch_medication_task`) AS `watch_medication_task`, (SELECT COUNT(*) FROM `ylrz_saas`.`watch_monitor_data_type`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`watch_monitor_data_type`) AS `watch_monitor_data_type`, (SELECT COUNT(*) FROM `ylrz_saas`.`watch_msg_set`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`watch_msg_set`) AS `watch_msg_set`, (SELECT COUNT(*) FROM `ylrz_saas`.`watch_send_msg_log`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`watch_send_msg_log`) AS `watch_send_msg_log`, (SELECT COUNT(*) FROM `ylrz_saas`.`watch_send_msg_set`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`watch_send_msg_set`) AS `watch_send_msg_set`, (SELECT COUNT(*) FROM `ylrz_saas`.`watch_user`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`watch_user`) AS `watch_user`, (SELECT COUNT(*) FROM `ylrz_saas`.`wx_contact`) - (SELECT COUNT(*) FROM `ylrz_saas_tenant`.`wx_contact`) AS `wx_contact` ; -- ============================================================================ -- 第四阶段: DROP 源表 (确认数据一致后执行) -- ============================================================================ -- 警告: 执行前请确认第三阶段验证全部通过！ -- --- ad_domain_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`ad_domain`; -- --- ad_dy_* (2 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`ad_dy_account`; DROP TABLE IF EXISTS `ylrz_saas`.`ad_dy_api`; -- --- ad_html_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`ad_html_template`; -- --- ad_iqiyi_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`ad_iqiyi_account`; -- --- ad_site_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`ad_site`; -- --- ad_upload_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`ad_upload_log`; -- --- ad_youku_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`ad_youku_account`; -- --- ai_knowledge_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`ai_knowledge_base`; -- --- bd_api_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`bd_api`; -- --- bd_creative_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`bd_creative_statistics`; -- --- bd_report_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`bd_report_data`; -- --- chat_dataset_* (2 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`chat_dataset`; DROP TABLE IF EXISTS `ylrz_saas`.`chat_dataset_file`; -- --- chat_keyword_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`chat_keyword`; -- --- chat_msg_* (2 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`chat_msg`; DROP TABLE IF EXISTS `ylrz_saas`.`chat_msg_logs`; -- --- chat_role_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`chat_role`; -- --- chat_session_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`chat_session`; -- --- chat_user_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`chat_user`; -- --- cid_ipad_* (2 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`cid_ipad_server`; DROP TABLE IF EXISTS `ylrz_saas`.`cid_ipad_server_user`; -- --- company_ai_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`company_ai_workflow_node_type`; -- --- company_company_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`company_company_fsuser`; -- --- company_deduct_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`company_deduct`; -- --- company_div_* (2 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`company_div_config`; DROP TABLE IF EXISTS `ylrz_saas`.`company_div_item`; -- --- company_logininfor_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`company_logininfor`; -- --- company_miniapp_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`company_miniapp`; -- --- company_post_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`company_post`; -- --- company_profit_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`company_profit_logs`; -- --- company_recharge_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`company_recharge`; -- --- company_role_* (2 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`company_role_dept`; DROP TABLE IF EXISTS `ylrz_saas`.`company_role_menu`; -- --- company_sop_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`company_sop_role`; -- --- company_tag_* (2 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`company_tag`; DROP TABLE IF EXISTS `ylrz_saas`.`company_tag_user`; -- --- company_tcm_* (3 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`company_tcm_consume`; DROP TABLE IF EXISTS `ylrz_saas`.`company_tcm_report`; DROP TABLE IF EXISTS `ylrz_saas`.`company_tcm_schedule`; -- --- company_user_* (5 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`company_user_card`; DROP TABLE IF EXISTS `ylrz_saas`.`company_user_change_apply_user`; DROP TABLE IF EXISTS `ylrz_saas`.`company_user_delay_time`; DROP TABLE IF EXISTS `ylrz_saas`.`company_user_post`; DROP TABLE IF EXISTS `ylrz_saas`.`company_user_user`; -- --- company_voice_* (7 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`company_voice`; DROP TABLE IF EXISTS `ylrz_saas`.`company_voice_config`; DROP TABLE IF EXISTS `ylrz_saas`.`company_voice_dialog`; DROP TABLE IF EXISTS `ylrz_saas`.`company_voice_mobile`; DROP TABLE IF EXISTS `ylrz_saas`.`company_voice_package`; DROP TABLE IF EXISTS `ylrz_saas`.`company_voice_robotic_call_log_addwx`; DROP TABLE IF EXISTS `ylrz_saas`.`company_voice_robotic_call_log_sendmsg`; -- --- company_workflow_* (6 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`company_workflow_lobster`; DROP TABLE IF EXISTS `ylrz_saas`.`company_workflow_lobster_edge`; DROP TABLE IF EXISTS `ylrz_saas`.`company_workflow_lobster_node`; DROP TABLE IF EXISTS `ylrz_saas`.`company_workflow_lobster_record`; DROP TABLE IF EXISTS `ylrz_saas`.`company_workflow_lobster_task`; DROP TABLE IF EXISTS `ylrz_saas`.`company_workflow_lobster_variable`; -- --- company_wx_* (2 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`company_wx_chat`; DROP TABLE IF EXISTS `ylrz_saas`.`company_wx_user_group`; -- --- crm_customer_* (8 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`crm_customer_analyze`; DROP TABLE IF EXISTS `ylrz_saas`.`crm_customer_assign`; DROP TABLE IF EXISTS `ylrz_saas`.`crm_customer_contacts`; DROP TABLE IF EXISTS `ylrz_saas`.`crm_customer_ext`; DROP TABLE IF EXISTS `ylrz_saas`.`crm_customer_his_order`; DROP TABLE IF EXISTS `ylrz_saas`.`crm_customer_logs`; DROP TABLE IF EXISTS `ylrz_saas`.`crm_customer_third`; DROP TABLE IF EXISTS `ylrz_saas`.`crm_customer_user`; -- --- crm_event_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`crm_event`; -- --- crm_msg_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`crm_msg`; -- --- customer_transfer_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`customer_transfer_approval`; -- --- fastgpt_chat_* (6 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fastgpt_chat_artificial_words`; DROP TABLE IF EXISTS `ylrz_saas`.`fastgpt_chat_keyword`; DROP TABLE IF EXISTS `ylrz_saas`.`fastgpt_chat_msg_logs`; DROP TABLE IF EXISTS `ylrz_saas`.`fastgpt_chat_replace_text`; DROP TABLE IF EXISTS `ylrz_saas`.`fastgpt_chat_replace_words`; DROP TABLE IF EXISTS `ylrz_saas`.`fastgpt_chat_voice_homo`; -- --- fastgpt_collection_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fastgpt_collection`; -- --- fastgpt_collention_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fastgpt_collention_data`; -- --- fastgpt_dataset_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fastgpt_dataset`; -- --- fastgpt_event_* (2 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fastgpt_event_log`; DROP TABLE IF EXISTS `ylrz_saas`.`fastgpt_event_log_total`; -- --- fastgpt_ext_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fastgpt_ext_user_tag`; -- --- fastgpt_keyword_* (3 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fastgpt_keyword`; DROP TABLE IF EXISTS `ylrz_saas`.`fastgpt_keyword_artificial`; DROP TABLE IF EXISTS `ylrz_saas`.`fastgpt_keyword_send`; -- --- fastgpt_push_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fastgpt_push_token_total`; -- --- fastgpt_role_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fastgpt_role_tag`; -- --- fastgpt_tag_* (2 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fastgpt_tag`; DROP TABLE IF EXISTS `ylrz_saas`.`fastgpt_tag_group`; -- --- fastgpt_user_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fastgpt_user`; -- --- fs_adv_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fs_adv_sem`; -- --- fs_ai_* (2 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fs_ai_workflow_edge`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_ai_workflow_node_type`; -- --- fs_app_* (2 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fs_app_contact_way`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_app_version`; -- --- fs_article_* (3 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fs_article`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_article_cate`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_article_views`; -- --- fs_chinese_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fs_chinese_medicine`; -- --- fs_city_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fs_city`; -- --- fs_complaint_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fs_complaint_template`; -- --- fs_coupon_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fs_coupon`; -- --- fs_course_* (12 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fs_course_domain_name`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_course_finish_temp`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_course_finish_temp_parent`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_course_link`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_course_product`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_course_product_order`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_course_question_bank`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_course_question_category`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_course_sop`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_course_sop_app_link`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_course_sop_logs`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_course_watch_comment`; -- --- fs_df_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fs_df_account`; -- --- fs_disease_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fs_disease`; -- --- fs_doctor_* (14 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fs_doctor_ai_chat_log`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_doctor_ai_chat_msg`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_doctor_ai_chat_session`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_doctor_article`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_doctor_article_cate`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_doctor_bill`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_doctor_confirm`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_doctor_extract`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_doctor_oper_log`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_doctor_prescribe`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_doctor_prescribe_drug`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_doctor_price`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_doctor_product`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_doctor_words`; -- --- fs_drug_* (2 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fs_drug_report`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_drug_report_count`; -- --- fs_express_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fs_express`; -- --- fs_famous_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fs_famous_prescribe`; -- --- fs_finish_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fs_finish_course_statistics_sync`; -- --- fs_first_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fs_first_diagnosis`; -- --- fs_follow_* (3 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fs_follow`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_follow_report`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_follow_temp`; -- --- fs_health_* (5 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fs_health_data`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_health_history_temp`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_health_life`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_health_record`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_health_tongue`; -- --- fs_hfpay_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fs_hfpay_config`; -- --- fs_icd_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fs_icd`; -- --- fs_illness_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fs_illness_library`; -- --- fs_im_* (2 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fs_im_msg_send_detail`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_im_msg_send_log`; -- --- fs_inquiry_* (7 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fs_inquiry_disease`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_inquiry_order_logs`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_inquiry_order_media`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_inquiry_order_msg`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_inquiry_order_ping`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_inquiry_patient_info`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_inquiry_temp`; -- --- fs_integral_* (3 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fs_integral_cart`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_integral_order`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_integral_order_logs`; -- --- fs_interest_* (4 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fs_interest_ai_msg`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_interest_ai_role`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_interest_ai_role_words`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_interest_ai_session`; -- --- fs_material_* (2 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fs_material`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_material_group`; -- --- fs_medicated_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fs_medicated_food`; -- --- fs_mess_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fs_mess_temp`; -- --- fs_package_* (3 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fs_package_cate`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_package_favorite`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_package_solar_term`; -- --- fs_physical_* (2 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fs_physical_report_template`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_physical_report_template_field`; -- --- fs_prescribe_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fs_prescribe`; -- --- fs_promotional_* (2 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fs_promotional_active`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_promotional_active_log`; -- --- fs_question_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fs_question_and_answer`; -- --- fs_questions_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fs_questions`; -- --- fs_statis_* (5 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fs_statis_qw_temp_param`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_statis_qw_watch`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_statis_saler_watch`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_statis_temp_fsuser`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_statis_temp_param`; -- --- fs_statistics_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fs_statistics`; -- --- fs_store_* (40 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fs_store`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_store_activity`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_store_activity_scrm`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_store_after_sales`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_store_after_sales_item`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_store_after_sales_logs`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_store_after_sales_logs_scrm`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_store_bill`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_store_bill_scrm`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_store_canvas_scrm`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_store_cart_scrm`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_store_coupon_issue_scrm`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_store_coupon_issue_user_scrm`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_store_coupon_scrm`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_store_coupon_user_scrm`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_store_extract`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_store_order_audit_scrm`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_store_order_bill_log`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_store_order_logs`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_store_order_logs_scrm`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_store_order_notice_scrm`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_store_payment_error`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_store_product`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_store_product_attr`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_store_product_attr_scrm`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_store_product_attr_value`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_store_product_category`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_store_product_details_scrm`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_store_product_group`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_store_product_group_scrm`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_store_product_package`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_store_product_purchase_limit_scrm`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_store_product_relation_scrm`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_store_product_reply_scrm`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_store_product_rule_scrm`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_store_product_template_scrm`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_store_recommend_scrm`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_store_shop_staff_scrm`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_store_sub_order`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_store_visit_scrm`; -- --- fs_test_* (3 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fs_test_report`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_test_temp`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_test_temp_item`; -- --- fs_tongue_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fs_tongue_info`; -- --- fs_user_* (51 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_address`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_bill`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_company_bind`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_company_package_scrm`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_company_user`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_company_user_qw`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_complaint`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_complaint_msg`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_course_comment`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_course_comment_like`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_course_company_statistics`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_course_complaint_record`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_course_complaint_type`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_course_count`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_course_favorite`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_course_follow`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_course_like`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_course_note`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_course_note_like`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_course_note_save`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_course_order`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_course_study`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_course_study_log`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_course_video_red_package`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_doctor`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_extract`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_information_collection_schedule`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_integral_logs`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_invited`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_login_log`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_new_task`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_online_state`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_operation_log`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_project_tag`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_recharge`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_sign`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_talent`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_talent_follow`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_video`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_video_comment`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_video_comment_like`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_video_favorite`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_video_like`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_video_tags`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_video_view`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_vip_order`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_vip_package`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_watch`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_watch_course_statistics`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_watch_statistics`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_user_wx`; -- --- fs_vessel_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fs_vessel`; -- --- fs_video_* (3 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fs_video_barrage`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_video_course_tag`; DROP TABLE IF EXISTS `ylrz_saas`.`fs_video_resource`; -- --- fs_wechat_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`fs_wechat_template`; -- --- hy_watch_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`hy_watch_log`; -- --- hy_work_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`hy_work_task`; -- --- ipad_allocation_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`ipad_allocation_records`; -- --- live_after_* (3 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`live_after_sales`; DROP TABLE IF EXISTS `ylrz_saas`.`live_after_sales_item`; DROP TABLE IF EXISTS `ylrz_saas`.`live_after_sales_logs`; -- --- live_anchor_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`live_anchor`; -- --- live_auto_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`live_auto_task`; -- --- live_cart_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`live_cart`; -- --- live_completion_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`live_completion_points_record`; -- --- live_coupon_* (5 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`live_coupon`; DROP TABLE IF EXISTS `ylrz_saas`.`live_coupon_issue`; DROP TABLE IF EXISTS `ylrz_saas`.`live_coupon_issue_relation`; DROP TABLE IF EXISTS `ylrz_saas`.`live_coupon_issue_user`; DROP TABLE IF EXISTS `ylrz_saas`.`live_coupon_user`; -- --- live_data_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`live_data`; -- --- live_event_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`live_event_conf`; -- --- live_gift_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`live_gift`; -- --- live_goods_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`live_goods`; -- --- live_lottery_* (3 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`live_lottery_conf`; DROP TABLE IF EXISTS `ylrz_saas`.`live_lottery_product_conf`; DROP TABLE IF EXISTS `ylrz_saas`.`live_lottery_registration`; -- --- live_msg_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`live_msg`; -- --- live_order_* (2 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`live_order_logs`; DROP TABLE IF EXISTS `ylrz_saas`.`live_order_payment_error`; -- --- live_red_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`live_red_conf`; -- --- live_reward_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`live_reward_record`; -- --- live_sensitive_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`live_sensitive_words`; -- --- live_tag_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`live_tag_config`; -- --- live_traffic_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`live_traffic_log`; -- --- live_user_* (6 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`live_user_favorite`; DROP TABLE IF EXISTS `ylrz_saas`.`live_user_first_entry`; DROP TABLE IF EXISTS `ylrz_saas`.`live_user_follow`; DROP TABLE IF EXISTS `ylrz_saas`.`live_user_like`; DROP TABLE IF EXISTS `ylrz_saas`.`live_user_lottery_record`; DROP TABLE IF EXISTS `ylrz_saas`.`live_user_red_record`; -- --- live_watch_* (2 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`live_watch_log`; DROP TABLE IF EXISTS `ylrz_saas`.`live_watch_user`; -- --- lobster_compliance_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`lobster_compliance_rule`; -- --- lobster_conversation_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`lobster_conversation_summary`; -- --- lobster_node_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`lobster_node_execution_log`; -- --- lobster_workflow_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`lobster_workflow_instance`; -- --- lucky_bag_* (2 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`lucky_bag`; DROP TABLE IF EXISTS `ylrz_saas`.`lucky_bag_collect_record`; -- --- qw_app_* (2 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`qw_app_contact_way`; DROP TABLE IF EXISTS `ylrz_saas`.`qw_app_contact_way_logs`; -- --- qw_auto_* (3 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`qw_auto_tags`; DROP TABLE IF EXISTS `ylrz_saas`.`qw_auto_tags_logs`; DROP TABLE IF EXISTS `ylrz_saas`.`qw_auto_tags_rules`; -- --- qw_contact_* (5 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`qw_contact_batch`; DROP TABLE IF EXISTS `ylrz_saas`.`qw_contact_way`; DROP TABLE IF EXISTS `ylrz_saas`.`qw_contact_way_group`; DROP TABLE IF EXISTS `ylrz_saas`.`qw_contact_way_logs`; DROP TABLE IF EXISTS `ylrz_saas`.`qw_contact_way_user`; -- --- qw_course_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`qw_course_finish_remark_rty`; -- --- qw_customer_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`qw_customer_property`; -- --- qw_drainage_* (2 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`qw_drainage_link`; DROP TABLE IF EXISTS `ylrz_saas`.`qw_drainage_link_logs`; -- --- qw_external_* (7 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`qw_external_ai_analyze`; DROP TABLE IF EXISTS `ylrz_saas`.`qw_external_contact_black_log`; DROP TABLE IF EXISTS `ylrz_saas`.`qw_external_contact_crm`; DROP TABLE IF EXISTS `ylrz_saas`.`qw_external_contact_transfer_company_audit`; DROP TABLE IF EXISTS `ylrz_saas`.`qw_external_contact_transfer_company_audit_user`; DROP TABLE IF EXISTS `ylrz_saas`.`qw_external_contact_transfer_log`; DROP TABLE IF EXISTS `ylrz_saas`.`qw_external_err_retry`; -- --- qw_friend_* (6 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`qw_friend_circle`; DROP TABLE IF EXISTS `ylrz_saas`.`qw_friend_circle_task`; DROP TABLE IF EXISTS `ylrz_saas`.`qw_friend_comments`; DROP TABLE IF EXISTS `ylrz_saas`.`qw_friend_customer_list`; DROP TABLE IF EXISTS `ylrz_saas`.`qw_friend_welcome`; DROP TABLE IF EXISTS `ylrz_saas`.`qw_friend_welcome_item`; -- --- qw_group_* (5 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`qw_group_chat`; DROP TABLE IF EXISTS `ylrz_saas`.`qw_group_chat_transfer_log`; DROP TABLE IF EXISTS `ylrz_saas`.`qw_group_msg`; DROP TABLE IF EXISTS `ylrz_saas`.`qw_group_msg_item`; DROP TABLE IF EXISTS `ylrz_saas`.`qw_group_msg_user`; -- --- qw_groupchat_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`qw_groupchat_statistic`; -- --- qw_information_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`qw_information`; -- --- qw_ipad_* (3 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`qw_ipad_server`; DROP TABLE IF EXISTS `ylrz_saas`.`qw_ipad_server_log`; DROP TABLE IF EXISTS `ylrz_saas`.`qw_ipad_server_user`; -- --- qw_material_* (2 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`qw_material`; DROP TABLE IF EXISTS `ylrz_saas`.`qw_material_group`; -- --- qw_messages_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`qw_messages`; -- --- qw_msg_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`qw_msg`; -- --- qw_push_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`qw_push_count`; -- --- qw_session_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`qw_session`; -- --- qw_sop_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`qw_sop_logs_detalis`; -- --- qw_tag_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`qw_tag_group`; -- --- qw_user_* (3 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`qw_user_complain_record`; DROP TABLE IF EXISTS `ylrz_saas`.`qw_user_video`; DROP TABLE IF EXISTS `ylrz_saas`.`qw_user_voice_log`; -- --- qw_userbehavior_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`qw_userbehavior_data`; -- --- qw_welcome_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`qw_welcome`; -- --- qw_work_* (3 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`qw_work_link`; DROP TABLE IF EXISTS `ylrz_saas`.`qw_work_link_user`; DROP TABLE IF EXISTS `ylrz_saas`.`qw_work_user`; -- --- tulin_info_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`tulin_info_sync_log`; -- --- uni_push_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`uni_push_log`; -- --- watch_beginner_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`watch_beginner_guide`; -- --- watch_device_* (4 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`watch_device_account`; DROP TABLE IF EXISTS `ylrz_saas`.`watch_device_day`; DROP TABLE IF EXISTS `ylrz_saas`.`watch_device_info`; DROP TABLE IF EXISTS `ylrz_saas`.`watch_device_setup`; -- --- watch_family_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`watch_family_user`; -- --- watch_materials_* (2 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`watch_materials`; DROP TABLE IF EXISTS `ylrz_saas`.`watch_materials_type`; -- --- watch_medication_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`watch_medication_task`; -- --- watch_monitor_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`watch_monitor_data_type`; -- --- watch_msg_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`watch_msg_set`; -- --- watch_send_* (2 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`watch_send_msg_log`; DROP TABLE IF EXISTS `ylrz_saas`.`watch_send_msg_set`; -- --- watch_user_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`watch_user`; -- --- wx_contact_* (1 tables) --- DROP TABLE IF EXISTS `ylrz_saas`.`wx_contact`; -- ============================================================================ -- 迁移完成统计 -- ============================================================================ -- SELECT COUNT(*) AS remaining FROM information_schema.tables WHERE table_schema='ylrz_saas' AND table_type='BASE TABLE'; -- Expected: 194