-- 为任务操作日志表添加GPS和位置信息字段
|
-- ----------------------------
|
|
USE ruoyi-vue;
|
|
-- 添加GPS和位置信息相关字段
|
ALTER TABLE sys_task_log
|
ADD COLUMN latitude DECIMAL(10, 6) COMMENT '纬度' AFTER ip_address,
|
ADD COLUMN longitude DECIMAL(10, 6) COMMENT '经度' AFTER latitude,
|
ADD COLUMN location_address VARCHAR(500) COMMENT '位置地址' AFTER longitude,
|
ADD COLUMN location_province VARCHAR(50) COMMENT '省份' AFTER location_address,
|
ADD COLUMN location_city VARCHAR(50) COMMENT '城市' AFTER location_province,
|
ADD COLUMN location_district VARCHAR(50) COMMENT '区县' AFTER location_city,
|
ADD COLUMN gps_accuracy DECIMAL(10, 2) COMMENT 'GPS精度（米）' AFTER location_district,
|
ADD COLUMN altitude DECIMAL(10, 2) COMMENT '海拔高度（米）' AFTER gps_accuracy,
|
ADD COLUMN speed DECIMAL(10, 2) COMMENT '速度（米/秒）' AFTER altitude,
|
ADD COLUMN heading DECIMAL(10, 2) COMMENT '方向角度（0-360）' AFTER speed;
|
|
-- 添加索引
|
ALTER TABLE sys_task_log
|
ADD INDEX idx_location (latitude, longitude),
|
ADD INDEX idx_operation_time_location (operation_time, latitude, longitude);
|
|
-- 添加注释
|
ALTER TABLE sys_task_log COMMENT='任务操作日志表（含GPS定位信息）';
|
