diff options
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); |