diff options
author | Lukas Metzger | 2020-07-02 13:18:33 +0200 |
---|---|---|
committer | Lukas Metzger | 2020-07-02 13:18:33 +0200 |
commit | 17609e1523369c5b29cfc34e2bf8a82fc5b6bd23 (patch) | |
tree | ff58aa48e0691acde15176616734dd4374ed7324 /db_structure.sql | |
parent | Added additional prettytime (diff) | |
download | bwlp-statistics-17609e1523369c5b29cfc34e2bf8a82fc5b6bd23.tar.gz bwlp-statistics-17609e1523369c5b29cfc34e2bf8a82fc5b6bd23.tar.xz bwlp-statistics-17609e1523369c5b29cfc34e2bf8a82fc5b6bd23.zip |
Added names for sattelites
Diffstat (limited to 'db_structure.sql')
-rw-r--r-- | db_structure.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/db_structure.sql b/db_structure.sql index 7ad3d87..a47b5c1 100644 --- a/db_structure.sql +++ b/db_structure.sql @@ -49,6 +49,11 @@ CREATE TABLE reports ( version varchar(200) COLLATE utf8_bin NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; +CREATE TABLE names ( + ip varchar(20) COLLATE utf8_bin NOT NULL, + name varchar(200) COLLATE utf8_bin NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; + CREATE TABLE server ( report bigint(20) NOT NULL, cpuCount bigint(20) NOT NULL, @@ -112,6 +117,9 @@ ALTER TABLE reports ALTER TABLE server ADD PRIMARY KEY (report); +ALTER TABLE names + ADD PRIMARY KEY (ip); + ALTER TABLE timeframe ADD PRIMARY KEY (report,days); |