From 56d9b8a4cebbf13c0f7fb593bc80e1513ed2118b Mon Sep 17 00:00:00 2001
From: Andy Allan <git@gravitystorm.co.uk>
Date: Wed, 20 Nov 2019 15:07:42 +0100
Subject: [PATCH] Remove the users.nearby column

Refs #2417 and #2432
---
 db/migrate/20191120140058_remove_nearby_from_users.rb | 6 ++++++
 db/structure.sql                                      | 2 +-
 2 files changed, 7 insertions(+), 1 deletion(-)
 create mode 100644 db/migrate/20191120140058_remove_nearby_from_users.rb

diff --git a/db/migrate/20191120140058_remove_nearby_from_users.rb b/db/migrate/20191120140058_remove_nearby_from_users.rb
new file mode 100644
index 000000000..7d9383dc6
--- /dev/null
+++ b/db/migrate/20191120140058_remove_nearby_from_users.rb
@@ -0,0 +1,6 @@
+class RemoveNearbyFromUsers < ActiveRecord::Migration[5.2]
+  def change
+    # We've already ignored this column in the model, so it is safe to remove
+    safety_assured { remove_column :users, :nearby, :integer, :default => 50 }
+  end
+end
diff --git a/db/structure.sql b/db/structure.sql
index 6370eb95a..78e58d4be 100644
--- a/db/structure.sql
+++ b/db/structure.sql
@@ -1394,7 +1394,6 @@ CREATE TABLE public.users (
     home_lat double precision,
     home_lon double precision,
     home_zoom smallint DEFAULT 3,
-    nearby integer DEFAULT 50,
     pass_salt character varying,
     email_valid boolean DEFAULT false NOT NULL,
     new_email character varying,
@@ -3137,6 +3136,7 @@ INSERT INTO "schema_migrations" (version) VALUES
 ('20190623093642'),
 ('20190702193519'),
 ('20190716173946'),
+('20191120140058'),
 ('21'),
 ('22'),
 ('23'),
-- 
2.43.2