Loading

Additional GTS columns

  1. ALTER TABLE `gts_hectare`.`device`
  2. ADD COLUMN `equipmentStatus` VARCHAR(24) NULL AFTER `creationTime`,
  3. ADD COLUMN `licenseExpire` INT(10) UNSIGNED NULL AFTER `equipmentStatus`,
  4. ADD COLUMN `insuranceExpire` INT(10) UNSIGNED NULL AFTER `licenseExpire`,
  5. ADD COLUMN `fuelRatePerHour` DOUBLE NULL AFTER `insuranceExpire`,
  6. ADD COLUMN `fuelCostPerLiter` DOUBLE NULL AFTER `fuelRatePerHour`,
  7. ADD COLUMN `dcsConfigString` VARCHAR(80) NULL AFTER `fuelCostPerLiter`,
  8. ADD COLUMN `lastValidSpeedKPH` DOUBLE UNSIGNED NULL AFTER `dcsConfigString`,
  9. ADD COLUMN `lastEngineOnHours` DOUBLE NULL AFTER `lastValidSpeedKPH`,
  10. ADD COLUMN `lastEngineOnTime` INT(10) UNSIGNED NULL AFTER `lastEngineOnHours`,
  11. ADD COLUMN `lastEngineOffTime` INT(10) UNSIGNED NULL AFTER `lastEngineOnTime`,
  12. ADD COLUMN `lastIgnitionOnHours` DOUBLE NULL AFTER `lastEngineOffTime`;

Comments