add 'basesystem' db table

1 files changed, 8 insertions, 0 deletions

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);