From 589a297dccc0212b1172560fad1a3af98a75ec89 Mon Sep 17 00:00:00 2001 From: Jonathan Bauer Date: Fri, 29 Apr 2022 14:26:32 +0200 Subject: add 'basesystem' db table --- db_structure.sql | 8 ++++++++ 1 file changed, 8 insertions(+) diff --git a/db_structure.sql b/db_structure.sql index 7d513ca..62c89ae 100644 --- a/db_structure.sql +++ b/db_structure.sql @@ -99,6 +99,14 @@ CREATE VIEW reports_newest AS ON (((r.ip = rm.ip) and (r.date = rm.date))) ); +CREATE TABLE `basesystem` ( + `report` bigint(20) NOT NULL, + `days` bigint(20) NOT NULL, + `system` varchar(50) COLLATE utf8mb3_bin NOT NULL, + `count` bigint(20) NOT NULL, + PRIMARY KEY (`report`,`days`,`system`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin + ALTER TABLE dozmod ADD PRIMARY KEY (report,days); -- cgit v1.2.3-55-g7522