Миграция с OpenWeatherMap на OpenMeteo в связи с отключением бесплатного API с 26...

[weathermon.git] / mysql / meteo_units.sql

diff --git a/mysql/meteo_units.sql b/mysql/meteo_units.sql
index 110b39d0de86224f09da057571b034e6e23db3ab..76d81aa6add48d768899d6738b5271d253411cb0 100644 (file)
--- 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,
   `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
   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