From 17609e1523369c5b29cfc34e2bf8a82fc5b6bd23 Mon Sep 17 00:00:00 2001
From: Lukas Metzger
Date: Thu, 2 Jul 2020 13:18:33 +0200
Subject: Added names for sattelites

---
 db_structure.sql | 8 ++++++++
 1 file changed, 8 insertions(+)

(limited to 'db_structure.sql')

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);
 
-- 
cgit v1.2.3-55-g7522

