From dd303dc41e4d500e48760f79351720cc2c1c9ffe Mon Sep 17 00:00:00 2001
From: FxQnLr <felixquinn03@gmail.com>
Date: Sun, 29 Oct 2023 21:09:46 +0100
Subject: add ip to database and use for ping, remove arc from pingmap

---
 migrations/20231009123228_devices.sql | 7 ++++---
 1 file changed, 4 insertions(+), 3 deletions(-)

(limited to 'migrations/20231009123228_devices.sql')

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

