-- 车队管理数据备份 --
-- ag_device_info 表
CREATE TABLE ag_device_info_20230601 LIKE ag_device_info;
INSERT INTO ag_device_info_20230601 SELECT * FROM ag_device_info;
-- ag_device_info_gps 表
CREATE TABLE ag_device_info_gps_20230601 LIKE ag_device_info_gps;
INSERT INTO ag_device_info_gps_20230601 SELECT * FROM ag_device_info_gps;
-- ag_device_info_log 表
CREATE TABLE ag_device_info_log_20230601 LIKE ag_device_info_log;
INSERT INTO ag_device_info_log_20230601 SELECT * FROM ag_device_info_log;
-- ag_survey_car 表
CREATE TABLE ag_survey_car_20230601 LIKE ag_survey_car;
INSERT INTO ag_survey_car_20230601 SELECT * FROM ag_survey_car;
-- ag_survey_car_asset 表
CREATE TABLE ag_survey_car_asset_20230601 LIKE ag_survey_car_asset;
INSERT INTO ag_survey_car_asset_20230601 SELECT * FROM ag_survey_car_asset;
-- ag_survey_logger 表
CREATE TABLE ag_survey_logger_20230601 LIKE ag_survey_logger;
INSERT INTO ag_survey_logger_20230601 SELECT * FROM ag_survey_logger;
-- ag_user_info 表
CREATE TABLE ag_user_info_20230601 LIKE ag_user_info;
INSERT INTO ag_user_info_20230601 SELECT * FROM ag_user_info;
-- vfms_alarm_config 表
CREATE TABLE vfms_alarm_config_20230601 LIKE vfms_alarm_config;
INSERT INTO vfms_alarm_config_20230601 SELECT * FROM vfms_alarm_config;
-- vfms_alarm_fault 表
CREATE TABLE vfms_alarm_fault_20230601 LIKE vfms_alarm_fault;
INSERT INTO vfms_alarm_fault_20230601 SELECT * FROM vfms_alarm_fault;
-- vfms_alarm_monitor 表
CREATE TABLE vfms_alarm_monitor_20230601 LIKE vfms_alarm_monitor;
INSERT INTO vfms_alarm_monitor_20230601 SELECT * FROM vfms_alarm_monitor;
-- vfms_alarm_statistics 表 
CREATE TABLE vfms_alarm_statistics_20230601 LIKE vfms_alarm_statistics;
INSERT INTO vfms_alarm_statistics_20230601 SELECT * FROM vfms_alarm_statistics;
-- vfms_record_upkeep_apply 表
CREATE TABLE vfms_record_upkeep_apply_20230601 LIKE vfms_record_upkeep_apply;
INSERT INTO vfms_record_upkeep_apply_20230601 SELECT * FROM vfms_record_upkeep_apply;
-- vfms_record_vehicle_refuel 表
CREATE TABLE vfms_record_vehicle_refuel_20230601 LIKE vfms_record_vehicle_refuel;
INSERT INTO vfms_record_vehicle_refuel_20230601 SELECT * FROM vfms_record_vehicle_refuel;
-- vfms_record_vehicle_statistics 表
CREATE TABLE vfms_record_vehicle_statistics_20230601 LIKE vfms_record_vehicle_statistics;
INSERT INTO vfms_record_vehicle_statistics_20230601 SELECT * FROM vfms_record_vehicle_statistics;
-- vfms_record_vehicle_trajectory 表
CREATE TABLE vfms_record_vehicle_trajectory_20230601 LIKE vfms_record_vehicle_trajectory;
INSERT INTO vfms_record_vehicle_trajectory_20230601 SELECT * FROM vfms_record_vehicle_trajectory;
-- vfms_survey_user 表
CREATE TABLE vfms_survey_user_20230601 LIKE vfms_survey_user;
INSERT INTO vfms_survey_user_20230601 SELECT * FROM vfms_survey_user;
-- vfms_survey_user_gps 表
CREATE TABLE vfms_survey_user_gps_20230601 LIKE vfms_survey_user_gps;
INSERT INTO vfms_survey_user_gps_20230601 SELECT * FROM vfms_survey_user_gps;
-- vfms_survey_user_sign 表
CREATE TABLE vfms_survey_user_sign_20230601 LIKE vfms_survey_user_sign;
INSERT INTO vfms_survey_user_sign_20230601 SELECT * FROM vfms_survey_user_sign;
-- vfms_task 表
CREATE TABLE vfms_task_20230601 LIKE vfms_task;
INSERT INTO vfms_task_20230601 SELECT * FROM vfms_task;
-- vfms_upkeep_apply_image 表
CREATE TABLE vfms_upkeep_apply_image_20230601 LIKE vfms_upkeep_apply_image;
INSERT INTO vfms_upkeep_apply_image_20230601 SELECT * FROM vfms_upkeep_apply_image;
-- vfms_vehicle 表
CREATE TABLE vfms_vehicle_20230601 LIKE vfms_vehicle;
INSERT INTO vfms_vehicle_20230601 SELECT * FROM vfms_vehicle;