From 28650d4dfb307b8928c97253018c4c39f3b96842 Mon Sep 17 00:00:00 2001
From: Tom Hughes <tom@compton.nu>
Date: Fri, 13 Sep 2024 18:23:50 +0100
Subject: [PATCH] Drop creation_ip column

---
 db/migrate/20240913171951_drop_user_creation_ip.rb | 5 +++++
 db/structure.sql                                   | 2 +-
 2 files changed, 6 insertions(+), 1 deletion(-)
 create mode 100644 db/migrate/20240913171951_drop_user_creation_ip.rb

diff --git a/db/migrate/20240913171951_drop_user_creation_ip.rb b/db/migrate/20240913171951_drop_user_creation_ip.rb
new file mode 100644
index 000000000..7915f6ec7
--- /dev/null
+++ b/db/migrate/20240913171951_drop_user_creation_ip.rb
@@ -0,0 +1,5 @@
+class DropUserCreationIp < ActiveRecord::Migration[7.1]
+  def change
+    safety_assured { remove_column :users, :creation_ip, :string }
+  end
+end
diff --git a/db/structure.sql b/db/structure.sql
index 60164558c..25b2f173f 100644
--- a/db/structure.sql
+++ b/db/structure.sql
@@ -1482,7 +1482,6 @@ CREATE TABLE public.users (
     pass_salt character varying,
     email_valid boolean DEFAULT false NOT NULL,
     new_email character varying,
-    creation_ip character varying,
     languages character varying,
     status public.user_status_enum DEFAULT 'pending'::public.user_status_enum NOT NULL,
     terms_agreed timestamp without time zone,
@@ -3357,6 +3356,7 @@ INSERT INTO "schema_migrations" (version) VALUES
 ('23'),
 ('22'),
 ('21'),
+('20240913171951'),
 ('20240912181413'),
 ('20240910175616'),
 ('20240822121603'),
-- 
2.39.5