summaryrefslogtreecommitdiff
path: root/src/db/migrations
diff options
context:
space:
mode:
Diffstat (limited to 'src/db/migrations')
-rw-r--r--src/db/migrations/0002.sql12
1 files changed, 12 insertions, 0 deletions
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;