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(+)

(limited to 'db_structure.sql')

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

