X-Git-Url: https://git.rvb.name/weathermon.git/blobdiff_plain/3fd934fc66956e08777aaa10bd2ee27c1bc62758..888e7fac57439dbb42864d77122a4cf551889477:/mysql/tmp_sensor_values.sql?ds=inline diff --git a/mysql/tmp_sensor_values.sql b/mysql/tmp_sensor_values.sql new file mode 100644 index 0000000..696c073 --- /dev/null +++ b/mysql/tmp_sensor_values.sql @@ -0,0 +1,8 @@ +CREATE TABLE `tmp_sensor_values` ( + `id` int(11) NOT NULL DEFAULT '0', + `sensor_id` int(11) NOT NULL, + `timestamp` datetime NOT NULL, + `value` float NOT NULL, + `parameter_id` int(11) NOT NULL, + `reduced` int(11) DEFAULT '0' +) ENGINE=InnoDB DEFAULT CHARSET=utf8;