Back

なんかいっぱいmigration

-- remove_column(:users, :current_sign_in_ip, :inet)
-- remove_column(:users, :last_sign_in_ip, :inet)
-- create_view(:user_ips)
-- add_column(:reports, :category, :int, {:default=>nil})
-- change_column_default(:reports, :category, 0)
-- exec_query("SELECT reltuples FROM pg_class WHERE relname = 'reports'")
-- exec_query("SELECT \"reports\".\"id\" FROM \"reports\" ORDER BY \"reports\".\"id\" ASC LIMIT 1")
-- change_column_null(:reports, :category, false)
-- add_column(:reports, :action_taken_at, :datetime)
-- add_column(:reports, :rule_ids, :bigint, {:array=>true})
-- execute("UPDATE reports SET action_taken_at = updated_at WHERE action_taken = TRUE")
-- remove_column(:reports, :action_taken, :boolean, {:default=>false, :null=>false})
-- add_reference(:account_warnings, :report, {:foreign_key=>{:on_delete=>:cascade}, :index=>false})
-- add_column(:account_warnings, :status_ids, :string, {:array=>true})
-- execute("UPDATE account_warnings SET action = 1000 WHERE action = 1")

-- execute("UPDATE account_warnings SET action = 2000 WHERE action = 2")
-- execute("UPDATE account_warnings SET action = 3000 WHERE action = 3")
-- execute("UPDATE account_warnings SET action = 4000 WHERE action = 4")
-- add_index(:statuses, :deleted_at, {:where=>"deleted_at IS NOT NULL", :algorithm=>:concurrently})