add ip to database and use for ping, remove arc from pingmap

1 files changed, 4 insertions, 3 deletions

diff --git a/migrations/20231009123228_devices.sql b/migrations/20231009123228_devices.sql
index 9d0c7ca..b911b19 100644
--- a/migrations/20231009123228_devices.sql
+++ b/migrations/20231009123228_devices.sql
@@ -1,7 +1,8 @@
 -- Add migration script here
 CREATE TABLE IF NOT EXISTS "devices"
 (
-    "id"                TEXT PRIMARY KEY NOT NULL,
-    "mac"               TEXT NOT NULL,
-    "broadcast_addr"    TEXT NOT NULL
+    "id"                VARCHAR(255) PRIMARY KEY NOT NULL,
+    "mac"               VARCHAR(17) NOT NULL,
+    "broadcast_addr"    VARCHAR(39) NOT NULL,
+    "ip"                VARCHAR(39) NOT NULL
 )