Eye/updates/20210305/db-patch-mysql-fullstat.sql

CREATE TABLE `User_stats_full` (
  `id` int(11) NOT NULL,
  `router_id` int(11) DEFAULT 0,
  `auth_id` int(11) NOT NULL DEFAULT 0,
  `timestamp` datetime NOT NULL DEFAULT current_timestamp(),
  `byte_in` bigint(20) NOT NULL DEFAULT 0,
  `byte_out` bigint(20) NOT NULL DEFAULT 0,
  `pkt_in` int(11) DEFAULT NULL,
  `pkt_out` int(11) DEFAULT NULL,
  `step` int(11) NOT NULL DEFAULT '600'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE `User_stats_full` ADD PRIMARY KEY (`id`), ADD KEY `timestamp` (`timestamp`,`auth_id`,`router_id`);
ALTER TABLE `User_stats_full` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE `Traffic_detail` ADD `pkt` INT NOT NULL DEFAULT '0' AFTER `bytes`;