summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorJonathan Bauer2022-04-29 14:34:20 +0200
committerJonathan Bauer2022-04-29 14:34:20 +0200
commit6f41256233b61d2db19a579108cca118a96ceb01 (patch)
tree59af8146a726a46ad932ed0ecae489ea97471987
parentadd 'basesystem' db table (diff)
downloadbwlp-statistics-6f41256233b61d2db19a579108cca118a96ceb01.tar.gz
bwlp-statistics-6f41256233b61d2db19a579108cca118a96ceb01.tar.xz
bwlp-statistics-6f41256233b61d2db19a579108cca118a96ceb01.zip
huch
-rw-r--r--db_structure.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/db_structure.sql b/db_structure.sql
index 62c89ae..2e1d253 100644
--- a/db_structure.sql
+++ b/db_structure.sql
@@ -105,7 +105,7 @@ CREATE TABLE `basesystem` (
`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
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin;
ALTER TABLE dozmod
ADD PRIMARY KEY (report,days);