tmrgo1/update.sql

ALTER TABLE `tmrwatch3`.`tmr` 
ADD COLUMN `gps` varchar(50) NULL AFTER `lastinorout`;



ALTER TABLE `tmrwatch3`.`tmr` 
ADD INDEX(`pastureid`, `gps`);




ALTER TABLE `tmrwatch2`.`downloadedplan` 
ADD COLUMN `driverId` bigint NOT NULL DEFAULT 0 COMMENT '驾驶员' ;