move user variables to `users` relation

2 files changed, 10 insertions, 0 deletions

diff --git a/db/migrate/20190531082330_add_vars_to_users.rb b/db/migrate/20190531082330_add_vars_to_users.rb
new file mode 100644
index 000000000..c3937a350
--- /dev/null
+++ b/db/migrate/20190531082330_add_vars_to_users.rb
@@ -0,0 +1,5 @@
+class AddVarsToUsers < ActiveRecord::Migration[5.2]
+  def change
+    safety_assured { add_column :users, :vars, :jsonb, null:false, default: {} }
+  end
+end
diff --git a/db/migrate/20190531082452_move_account_vars_to_users.rb b/db/migrate/20190531082452_move_account_vars_to_users.rb
new file mode 100644
index 000000000..fea150b78
--- /dev/null
+++ b/db/migrate/20190531082452_move_account_vars_to_users.rb
@@ -0,0 +1,5 @@
+class MoveAccountVarsToUsers < ActiveRecord::Migration[5.2]
+  def up
+    Account.local.find_each { |a| a.user.vars = a.vars; a.user.save }
+  end
+end