X-Git-Url: https://git.rvb.name/weathermon.git/blobdiff_plain/42bd3e809b0fa95d3a463462e242caf40d98bf79..22ca64ec047957beb57e5ca4024d14ed996ffbac:/mysql/meteo_units.sql?ds=inline 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