Wattrouter daily stats to database

MySQL

mysql  Ver 15.1 Distrib 10.3.28-MariaDB, for Linux (x86_64) using readline 5.1

##DB sturcture it will create table "wattrouter_stat_day" with UTF8_Czech colation

CREATE TABLE `wattrouter_stat_day` (
  `id` bigint(20) NOT NULL,
  `datum` date NOT NULL,
  `cas` time NOT NULL,
  `sds1` decimal(10,2) NOT NULL,
  `sdh1` decimal(10,2) NOT NULL,
  `sdl1` decimal(10,2) NOT NULL,
  `sdp1` decimal(10,2) NOT NULL,
  `sds2` decimal(10,2) NOT NULL,
  `sdh2` decimal(10,2) NOT NULL,
  `sdl2` decimal(10,2) NOT NULL,
  `sdp2` decimal(10,2) NOT NULL,
  `sds3` decimal(10,2) NOT NULL,
  `sdh3` decimal(10,2) NOT NULL,
  `sdl3` decimal(10,2) NOT NULL,
  `sdp3` decimal(10,2) NOT NULL,
  `sds4` decimal(10,2) NOT NULL,
  `sdh4` decimal(10,2) NOT NULL,
  `sdl4` decimal(10,2) NOT NULL,
  `sdp4` decimal(10,2) NOT NULL,
  `sdo1` decimal(10,2) NOT NULL,
  `sdo2` decimal(10,2) NOT NULL,
  `sdo3` decimal(10,2) NOT NULL,
  `sdo4` decimal(10,2) NOT NULL,
  `sdo5` decimal(10,2) NOT NULL,
  `sdo6` decimal(10,2) NOT NULL,
  `sdo7` decimal(10,2) NOT NULL,
  `sdo8` decimal(10,2) NOT NULL,
  `sdo9` decimal(10,2) NOT NULL,
  `sdo10` decimal(10,2) NOT NULL,
  `sdo11` decimal(10,2) NOT NULL,
  `sdo12` decimal(10,2) NOT NULL,
  `sdo13` decimal(10,2) NOT NULL,
  `sdo14` decimal(10,2) NOT NULL,
  `sdi1` decimal(10,2) NOT NULL,
  `sdi2` decimal(10,2) NOT NULL,
  `sdi3` decimal(10,2) NOT NULL,
  `sdi4` decimal(10,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

whole DB dump is in file: example-mysql-dump.sql

CRONTAB

add line below to the "/etc/crontab" file. It will

59 23 * * *     root    php /PATH_TO_THE_FILE/cron-fve-insert-to-mysql.php

musil/Wattrouter-daily-stats-to-database

Wattrouter daily stats to database

MySQL

CRONTAB