Clarkson/flyway/sql/V1.1__Insert_Base_Units.sql
2018-02-10 17:53:54 +00:00

21 lines
1.4 KiB
SQL

INSERT INTO `FuelUnits` (`id`, `unit`, `unitName`) VALUES (1, "l", "Litres");
INSERT INTO `FuelUnits` (`id`, `unit`, `unitName`) VALUES (2, "gal", "Gallon");
INSERT INTO `FuelUnits` (`id`, `unit`, `unitName`) VALUES (3, "gal (US)", "US Gallon");
INSERT INTO `FuelTypes` (`id`, `type`) VALUES (1, "Petrol");
INSERT INTO `FuelTypes` (`id`, `type`) VALUES (2, "Diesel");
INSERT INTO `FuelTypes` (`id`, `type`) VALUES (3, "Ethanol");
INSERT INTO `FuelTypes` (`id`, `type`) VALUES (4, "LPG");
INSERT INTO `DistanceUnits` (`id`, `unit`, `unitName`) VALUES (1, "mi", "Miles");
INSERT INTO `DistanceUnits` (`id`, `unit`, `unitName`) VALUES (2, "km", "Kilometres");
INSERT INTO `CurrencyUnits` (`id`, `unit`, `unitName`, `symbol`) VALUES (1, "GBP", "Pound Sterling", "£");
INSERT INTO `CurrencyUnits` (`id`, `unit`, `unitName`, `symbol`) VALUES (2, "USD", "United States Dollar", "$");
INSERT INTO `CurrencyUnits` (`id`, `unit`, `unitName`, `symbol`) VALUES (3, "EUR", "Euro", "€");
INSERT INTO `CurrencyUnits` (`id`, `unit`, `unitName`, `symbol`) VALUES (4, "AUD", "Australian Dollar", "AU$");
INSERT INTO `CurrencyUnits` (`id`, `unit`, `unitName`, `symbol`) VALUES (5, "CAD", "Canadian Dollar", "CA$");
INSERT INTO `FuelConsumptionUnits` (`id`, `unit`, `unitName`) VALUES (1, "mpg", "Miles per Gallon");
INSERT INTO `FuelConsumptionUnits` (`id`, `unit`, `unitName`) VALUES (2, "l/100km", "Litres per 100 Kilometers");