
TRUNCATE `agile_sprint`;
TRUNCATE `agile_sprint_issue_report`;
TRUNCATE `hornet_cache_key`;
TRUNCATE `hornet_user`;
TRUNCATE `issue_assistant`;
TRUNCATE `issue_effect_version`;
TRUNCATE `issue_file_attachment`;
TRUNCATE `issue_filter`;
TRUNCATE `issue_fix_version`;
TRUNCATE `issue_follow`;
TRUNCATE `issue_label_data`;
TRUNCATE `issue_main`;
TRUNCATE `issue_moved_issue_key`;
TRUNCATE `issue_recycle`;
TRUNCATE `log_base`;
TRUNCATE `log_operating`;
TRUNCATE `log_runtime_error`;
TRUNCATE `main_action`;
TRUNCATE `main_activity`;
TRUNCATE `main_cache_key`;
TRUNCATE `main_mail_queue`;
TRUNCATE `main_timeline`;
TRUNCATE `project_category`;
TRUNCATE `project_flag`;
TRUNCATE `project_issue_report`;
TRUNCATE `project_issue_type_scheme_data`;
TRUNCATE `project_key`;
TRUNCATE `project_label`;
TRUNCATE `project_list_count`;
TRUNCATE `project_main`;
TRUNCATE `project_main_extra`;
TRUNCATE `project_module`;
TRUNCATE `project_role`;
TRUNCATE `project_role_relation`;
TRUNCATE `project_user_role`;
TRUNCATE `project_version`;
TRUNCATE `project_workflows`;
TRUNCATE `project_workflow_status`;
TRUNCATE `report_project_issue`;
TRUNCATE `report_sprint_issue`;
TRUNCATE `user_attributes`;
TRUNCATE `user_email_active`;
TRUNCATE `user_email_find_password`;
TRUNCATE `user_email_token`;
TRUNCATE `user_group`;
TRUNCATE `user_ip_login_times`;
TRUNCATE `user_login_log`;
TRUNCATE `user_message`;
TRUNCATE `user_password`;
TRUNCATE `user_posted_flag`;
TRUNCATE `user_refresh_token`;
TRUNCATE `user_token`;
TRUNCATE `issue_holiday`;
TRUNCATE `main_webhook_log`;


DELETE FROM `agile_board` WHERE id>2;
DELETE FROM `agile_board_column` WHERE board_id >2;
DELETE FROM `main_org` WHERE `id` >1;
DELETE FROM `user_group` WHERE uid!=1;
DELETE FROM `user_main` WHERE uid!=1;
DELETE FROM `user_setting` WHERE `user_id`!=1;
DELETE FROM `user_widget` WHERE `user_id` >1;
UPDATE main_setting SET `_value`='send_mailer@xxx.com' WHERE `_key`='send_mailer';
UPDATE main_setting SET `_value`='send_mailer@xxx.com' WHERE `_key`='mail_account';
UPDATE main_setting SET `_value`='xxxx' WHERE `_key`='mail_password';