summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorJonathan Bauer2022-04-29 14:26:32 +0200
committerJonathan Bauer2022-04-29 14:26:32 +0200
commit589a297dccc0212b1172560fad1a3af98a75ec89 (patch)
tree17f7b824485445d19439de2c9b19aca02dc6b008
parentset versions requirements.txt as min versions (diff)
downloadbwlp-statistics-589a297dccc0212b1172560fad1a3af98a75ec89.tar.gz
bwlp-statistics-589a297dccc0212b1172560fad1a3af98a75ec89.tar.xz
bwlp-statistics-589a297dccc0212b1172560fad1a3af98a75ec89.zip
add 'basesystem' db table
-rw-r--r--db_structure.sql8
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);