From d5f1976e62cb0a32b8bafdb71d7d082d16413256 Mon Sep 17 00:00:00 2001
From: Freya Murphy <freya@freyacat.org>
Date: Wed, 11 Dec 2024 19:57:12 -0500
Subject: make ip nullable, refactor get_ip and get_req_route in router

---
 src/db/migrations/0002.sql | 12 ++++++++++++
 1 file changed, 12 insertions(+)
 create mode 100644 src/db/migrations/0002.sql

(limited to 'src/db/migrations/0002.sql')

diff --git a/src/db/migrations/0002.sql b/src/db/migrations/0002.sql
new file mode 100644
index 0000000..99f1494
--- /dev/null
+++ b/src/db/migrations/0002.sql
@@ -0,0 +1,12 @@
+BEGIN TRANSACTION;
+SET search_path = public;
+
+-- Migration Start
+ALTER TABLE admin.comment
+	ALTER COLUMN ip DROP NOT NULL;
+-- Migration End;
+
+-- Set Current Revision
+UPDATE sys.database_info SET curr_revision = 3 WHERE name = current_database();
+
+COMMIT TRANSACTION;
-- 
cgit v1.2.3-freya

