From 2f9f18b80a9e2134f674f345e48a5f21de5efadd Mon Sep 17 00:00:00 2001
From: FxQnLr <felixquinn03@gmail.com>
Date: Sun, 18 Feb 2024 21:16:46 +0100
Subject: Refactor stuff. Use Postgres Types

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

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

diff --git a/migrations/20231009123228_devices.sql b/migrations/20231009123228_devices.sql
index d36946c..6983ada 100644
--- a/migrations/20231009123228_devices.sql
+++ b/migrations/20231009123228_devices.sql
@@ -2,8 +2,8 @@
 CREATE TABLE IF NOT EXISTS "devices"
 (
     "id"                VARCHAR(255) PRIMARY KEY NOT NULL,
-    "mac"               VARCHAR(17) NOT NULL,
+    "mac"               MACADDR NOT NULL,
     "broadcast_addr"    VARCHAR(39) NOT NULL,
-    "ip"                VARCHAR(39) NOT NULL,
+    "ip"                INET NOT NULL,
     "times"             BIGINT[]
 )
-- 
cgit v1.2.3

