-- 使用 TRUNCATE 删除所有数据并重置自增ID
TRUNCATE TABLE order_table;
TRUNCATE TABLE order_de_table;
TRUNCATE TABLE otime_table;
TRUNCATE TABLE yy_order_table;
TRUNCATE TABLE yy_order_de_table;
TRUNCATE TABLE yy_ls_order_table;
TRUNCATE TABLE yy_ls_order_de_table;
TRUNCATE TABLE payment_table;
TRUNCATE TABLE rem_table;
TRUNCATE TABLE usertip_table;
TRUNCATE TABLE gf_log_table;
TRUNCATE TABLE giftcard_table;
TRUNCATE TABLE vip_table;
TRUNCATE TABLE delete_otime_table;
TRUNCATE TABLE delete_yy_order_de_table;
TRUNCATE TABLE delete_yy_order_table;
TRUNCATE TABLE log_table;
TRUNCATE TABLE vip_log_table;
TRUNCATE TABLE yy_yq_order_table;
TRUNCATE TABLE yy_yq_order_de_table;
TRUNCATE TABLE daka_table;
TRUNCATE TABLE package_card_pay;
TRUNCATE TABLE package_card_items_pay;
TRUNCATE TABLE pax_batch_detail_table;
TRUNCATE TABLE pax_cardreader_record_table;
TRUNCATE TABLE service_table;
TRUNCATE TABLE user_project_commission;
TRUNCATE TABLE user_project_commission_mb_table;
TRUNCATE TABLE cust_table;
TRUNCATE TABLE leave_application;
DELETE FROM user_table WHERE userid != 4;
delete from order_status;
-- 重新启用外键检查
SET FOREIGN_KEY_CHECKS = 1;