24 lines
590 B
SQL
24 lines
590 B
SQL
TRUNCATE TABLE bus_agent_info;
|
|
TRUNCATE TABLE bus_ai_info;
|
|
TRUNCATE TABLE bus_ban_operate_info;
|
|
TRUNCATE TABLE bus_fifteen_info;
|
|
TRUNCATE TABLE bus_integral_record;
|
|
TRUNCATE TABLE bus_market_operation_info;
|
|
TRUNCATE TABLE bus_order_info;
|
|
TRUNCATE TABLE bus_return_visit_info;
|
|
TRUNCATE TABLE bus_sale_info;
|
|
TRUNCATE TABLE bus_store_config_info;
|
|
TRUNCATE TABLE bus_store_day_info;
|
|
TRUNCATE TABLE bus_store_day_history_info;
|
|
TRUNCATE TABLE bus_store_info;
|
|
TRUNCATE TABLE sys_job_log;
|
|
TRUNCATE TABLE sys_logininfor;
|
|
TRUNCATE TABLE sys_oper_log;
|
|
|
|
DELETE
|
|
FROM
|
|
sys_user
|
|
WHERE
|
|
user_id != 1;
|
|
|
|
|