summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorJonathan Bauer2020-07-29 13:44:31 +0200
committerJonathan Bauer2020-07-29 13:44:31 +0200
commit62fa84ef3ed2b9794ede94bfd2e9cf316083152f (patch)
treeefb6874be2637b8af259da021e36dc2c6816306b
parentfix syntax (diff)
downloadbwlp-statistics-62fa84ef3ed2b9794ede94bfd2e9cf316083152f.tar.gz
bwlp-statistics-62fa84ef3ed2b9794ede94bfd2e9cf316083152f.tar.xz
bwlp-statistics-62fa84ef3ed2b9794ede94bfd2e9cf316083152f.zip
'testserver' -> tinyint(1)
-rw-r--r--db_structure.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/db_structure.sql b/db_structure.sql
index 6384dd6..7d513ca 100644
--- a/db_structure.sql
+++ b/db_structure.sql
@@ -52,7 +52,7 @@ CREATE TABLE reports (
CREATE TABLE names (
ip varchar(20) COLLATE utf8_bin NOT NULL,
name varchar(200) COLLATE utf8_bin NOT NULL,
- testserver tinyint NOT NULL
+ testserver tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
CREATE TABLE server (