SET FOREIGN_KEY_CHECKS=0; TRUNCATE TABLE activity_enroll; TRUNCATE TABLE activity; TRUNCATE TABLE atlas_relationship; TRUNCATE TABLE atlas_scene; TRUNCATE TABLE atlas_relationship; TRUNCATE TABLE business_monitoring; TRUNCATE TABLE contract_resource; TRUNCATE TABLE contract; TRUNCATE TABLE data_requirement_data; # TRUNCATE TABLE dictionary; # TRUNCATE TABLE dictionary_group; TRUNCATE TABLE invoice; TRUNCATE TABLE key_word; TRUNCATE TABLE leave_message; # TRUNCATE TABLE menu; # TRUNCATE TABLE module_action; TRUNCATE TABLE news_content; TRUNCATE TABLE news; TRUNCATE TABLE notification; TRUNCATE TABLE offline_conference; TRUNCATE TABLE order_payment; TRUNCATE TABLE order_goods; TRUNCATE TABLE orders; TRUNCATE TABLE resource_follow; TRUNCATE TABLE resource_auth; TRUNCATE TABLE publish_setting; TRUNCATE TABLE publish_info; TRUNCATE TABLE requirement_follow; TRUNCATE TABLE requirement_data; TRUNCATE TABLE requirement_api; TRUNCATE TABLE requirement_microapp; TRUNCATE TABLE requirement_receive; TRUNCATE TABLE requirement; TRUNCATE TABLE resource_data; TRUNCATE TABLE resource_api_interface_input; TRUNCATE TABLE resource_api_interface_output; TRUNCATE TABLE resource_api_interface; TRUNCATE TABLE resource_api; TRUNCATE TABLE resource_microapp; TRUNCATE TABLE resource_view_times; TRUNCATE TABLE resource_sort; TRUNCATE TABLE resource; # TRUNCATE TABLE resource_catelog; # TRUNCATE TABLE data_catelog_item; # TRUNCATE TABLE data_catelog; TRUNCATE TABLE roadshow_requirement; TRUNCATE TABLE roadshow; # TRUNCATE TABLE running_monitoring; # TRUNCATE TABLE tag; # TRUNCATE TABLE organization; # TRUNCATE TABLE sector; TRUNCATE TABLE service_provider; # TRUNCATE TABLE user_account_transaction; # TRUNCATE TABLE user_account; # TRUNCATE TABLE user_auth_setting; # TRUNCATE TABLE user_company; # TRUNCATE TABLE user_personal # TRUNCATE TABLE user_security_code; # TRUNCATE TABLE user; SET FOREIGN_KEY_CHECKS=1;