HSDataPlatform/ClearData.sql

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;