清理表结构

mysql -h 10.32.0.53 -uwinit_confluence -pconfluence*winit -N -s information_schema -e "SELECT CONCAT('DROP TABLE ',TABLE_NAME,';') FROM TABLES WHERE TABLE_SCHEMA='confluence2'"

USE confluence2;
SET FOREIGN_KEY_CHECKS=0;
DROP TABLE AO_187CCC_SIDEBAR_LINK;
DROP TABLE AO_21D670_WHITELIST_RULES;
DROP TABLE AO_26DB7F_ENTITIES_TO_ROOMS;
DROP TABLE AO_38321B_CUSTOM_CONTENT_LINK;
DROP TABLE AO_42E351_HEALTH_CHECK_ENTITY;
DROP TABLE AO_54C900_CONTENT_BLUEPRINT_AO;
DROP TABLE AO_54C900_C_TEMPLATE_REF;
DROP TABLE AO_54C900_SPACE_BLUEPRINT_AO;
DROP TABLE AO_5F3884_FEATURE_DISCOVERY;
DROP TABLE AO_5FB9D7_AOHIP_CHAT_LINK;
DROP TABLE AO_5FB9D7_AOHIP_CHAT_USER;
DROP TABLE AO_6384AB_DISCOVERED;
DROP TABLE AO_6384AB_FEATURE_METADATA_AO;
DROP TABLE AO_7CDE43_EVENT;
DROP TABLE AO_7CDE43_FILTER_PARAM;
DROP TABLE AO_7CDE43_NOTIFICATION;
DROP TABLE AO_7CDE43_NOTIFICATION_SCHEME;
DROP TABLE AO_7CDE43_RECIPIENT;
DROP TABLE AO_7CDE43_SERVER_CONFIG;
DROP TABLE AO_7CDE43_SERVER_PARAM;
DROP TABLE AO_92296B_AORECENTLY_VIEWED;
DROP TABLE AO_9412A1_AONOTIFICATION;
DROP TABLE AO_9412A1_AOREGISTRATION;
DROP TABLE AO_9412A1_AOTASK;
DROP TABLE AO_9412A1_AOUSER;
DROP TABLE AO_9412A1_USER_APP_LINK;
DROP TABLE AO_A0B856_WEB_HOOK_LISTENER_AO;
DROP TABLE AO_BAF3AA_AOINLINE_TASK;
DROP TABLE AO_DC98AE_AOHELP_TIP;
DROP TABLE ATTACHMENTDATA;
DROP TABLE BANDANA;
DROP TABLE BODYCONTENT;
DROP TABLE CLUSTERSAFETY;
DROP TABLE CONFANCESTORS;
DROP TABLE CONFVERSION;
DROP TABLE CONTENT;
DROP TABLE CONTENTPROPERTIES;
DROP TABLE CONTENT_LABEL;
DROP TABLE CONTENT_PERM;
DROP TABLE CONTENT_PERM_SET;
DROP TABLE DECORATOR;
DROP TABLE EXTRNLNKS;
DROP TABLE FOLLOW_CONNECTIONS;
DROP TABLE IMAGEDETAILS;
DROP TABLE INDEXQUEUEENTRIES;
DROP TABLE KEYSTORE;
DROP TABLE LABEL;
DROP TABLE LIKES;
DROP TABLE LINKS;
DROP TABLE NOTIFICATIONS;
DROP TABLE OS_PROPERTYENTRY;
DROP TABLE PAGETEMPLATES;
DROP TABLE PLUGINDATA;
DROP TABLE SPACEGROUPPERMISSIONS;
DROP TABLE SPACEGROUPS;
DROP TABLE SPACEPERMISSIONS;
DROP TABLE SPACES;
DROP TABLE TRACKBACKLINKS;
DROP TABLE TRUSTEDAPP;
DROP TABLE TRUSTEDAPPRESTRICTION;
DROP TABLE cwd_app_dir_group_mapping;
DROP TABLE cwd_app_dir_mapping;
DROP TABLE cwd_app_dir_operation;
DROP TABLE cwd_application;
DROP TABLE cwd_application_address;
DROP TABLE cwd_application_attribute;
DROP TABLE cwd_directory;
DROP TABLE cwd_directory_attribute;
DROP TABLE cwd_directory_operation;
DROP TABLE cwd_group;
DROP TABLE cwd_group_attribute;
DROP TABLE cwd_membership;
DROP TABLE cwd_user;
DROP TABLE cwd_user_attribute;
DROP TABLE cwd_user_credential_record;
DROP TABLE external_entities;
DROP TABLE external_members;
DROP TABLE groups;
DROP TABLE hibernate_unique_key;
DROP TABLE journalentry;
DROP TABLE local_members;
DROP TABLE logininfo;
DROP TABLE os_group;
DROP TABLE os_user;
DROP TABLE os_user_group;
DROP TABLE remembermetoken;
DROP TABLE user_mapping;
DROP TABLE users;