summaryrefslogtreecommitdiffstats
path: root/db_structure.sql
diff options
context:
space:
mode:
authorLukas Metzger2020-07-24 17:20:01 +0200
committerLukas Metzger2020-07-24 17:20:01 +0200
commit64e7452fffe15248633b8b719b91a7fea9231c64 (patch)
tree7580fcd6b9444d488896a258d4b6d110b03b7736 /db_structure.sql
parentUse range from chart for total aggregation (diff)
downloadbwlp-statistics-64e7452fffe15248633b8b719b91a7fea9231c64.tar.gz
bwlp-statistics-64e7452fffe15248633b8b719b91a7fea9231c64.tar.xz
bwlp-statistics-64e7452fffe15248633b8b719b91a7fea9231c64.zip
Ignore testservers on import
Diffstat (limited to 'db_structure.sql')
-rw-r--r--db_structure.sql3
1 files changed, 2 insertions, 1 deletions
diff --git a/db_structure.sql b/db_structure.sql
index a47b5c1..e655fc8 100644
--- a/db_structure.sql
+++ b/db_structure.sql
@@ -51,7 +51,8 @@ CREATE TABLE reports (
CREATE TABLE names (
ip varchar(20) COLLATE utf8_bin NOT NULL,
- name varchar(200) COLLATE utf8_bin NOT NULL
+ name varchar(200) COLLATE utf8_bin NOT NULL,
+ testserver tinyint NOT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
CREATE TABLE server (