SET NAMES utf8mb4;

INSERT INTO quantityvalue_units (`id`,`group`,`abbreviation`,`longname`,`baseunit`,`factor`,`conversionOffset`,`reference`,`converter`) VALUES ('1',NULL,'m','Meter',NULL,NULL,NULL,NULL,'');
INSERT INTO quantityvalue_units (`id`,`group`,`abbreviation`,`longname`,`baseunit`,`factor`,`conversionOffset`,`reference`,`converter`) VALUES ('2',NULL,'mm','Millimeter','1',NULL,NULL,NULL,'');
INSERT INTO quantityvalue_units (`id`,`group`,`abbreviation`,`longname`,`baseunit`,`factor`,`conversionOffset`,`reference`,`converter`) VALUES ('3',NULL,'kg','Kilogram',NULL,NULL,NULL,NULL,'');
INSERT INTO quantityvalue_units (`id`,`group`,`abbreviation`,`longname`,`baseunit`,`factor`,`conversionOffset`,`reference`,`converter`) VALUES ('4',NULL,'l','Liter',NULL,NULL,NULL,NULL,'');
INSERT INTO quantityvalue_units (`id`,`group`,`abbreviation`,`longname`,`baseunit`,`factor`,`conversionOffset`,`reference`,`converter`) VALUES ('5',NULL,'m³','Cubic Meter',NULL,NULL,NULL,NULL,'');
INSERT INTO quantityvalue_units (`id`,`group`,`abbreviation`,`longname`,`baseunit`,`factor`,`conversionOffset`,`reference`,`converter`) VALUES ('6',NULL,'kw','Kilowatt',NULL,NULL,NULL,NULL,'');
INSERT INTO quantityvalue_units (`id`,`group`,`abbreviation`,`longname`,`baseunit`,`factor`,`conversionOffset`,`reference`,`converter`) VALUES ('7',NULL,'km','Kilometer',NULL,NULL,NULL,NULL,'');
INSERT INTO quantityvalue_units (`id`,`group`,`abbreviation`,`longname`,`baseunit`,`factor`,`conversionOffset`,`reference`,`converter`) VALUES ('8',NULL,'mi','Mile',NULL,NULL,NULL,NULL,'');