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



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