From f7c5171a837c0baeb16f43dfe05beac9c6f6b78a Mon Sep 17 00:00:00 2001 From: multiple creatures Date: Fri, 19 Apr 2019 00:25:52 -0500 Subject: DB: Replace `NULL` boolean values with `FALSE` in Monsterpit feature columns; add `vars` column for persistent bangtag variable storage. --- db/migrate/20190419045308_monsterpit_remove_nulls.rb | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) create mode 100644 db/migrate/20190419045308_monsterpit_remove_nulls.rb (limited to 'db/migrate/20190419045308_monsterpit_remove_nulls.rb') diff --git a/db/migrate/20190419045308_monsterpit_remove_nulls.rb b/db/migrate/20190419045308_monsterpit_remove_nulls.rb new file mode 100644 index 000000000..32701d58a --- /dev/null +++ b/db/migrate/20190419045308_monsterpit_remove_nulls.rb @@ -0,0 +1,19 @@ +class MonsterpitRemoveNulls < ActiveRecord::Migration[5.2] + disable_ddl_transaction! + + def change + safety_assured do + change_column_null :statuses, :curated, false, false + change_column_default :statuses, :curated, false + + change_column_null :statuses, :network, false, false + change_column_default :statuses, :network, false + + change_column_null :accounts, :hidden, false, false + change_column_default :accounts, :hidden, false + + change_column_null :accounts, :vars, false, {} + change_column_default :accounts, :vars, {} + end + end +end -- cgit