X-Git-Url: https://git.rvb.name/weathermon.git/blobdiff_plain/e4e1557426f8e5ca10ca616140528939d86426cd..a637d5d6e0c145b2a38a482829ba1ef0a4264c90:/mysql/meteo_units.sql?ds=sidebyside diff --git a/mysql/meteo_units.sql b/mysql/meteo_units.sql index 110b39d..76d81aa 100644 --- a/mysql/meteo_units.sql +++ b/mysql/meteo_units.sql @@ -27,6 +27,7 @@ CREATE TABLE `units` ( `name` varchar(32) CHARACTER SET utf8 NOT NULL, `name_short` varchar(8) CHARACTER SET utf8 NOT NULL, `unit_group` int(11) NOT NULL, + `prec` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `fk_units_group_idx` (`unit_group`), CONSTRAINT `fk_units_group` FOREIGN KEY (`unit_group`) REFERENCES `unit_groups` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION