diff options
Diffstat (limited to 'db/migrate/20191212022653_create_imported_statuses.rb')
-rw-r--r-- | db/migrate/20191212022653_create_imported_statuses.rb | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/db/migrate/20191212022653_create_imported_statuses.rb b/db/migrate/20191212022653_create_imported_statuses.rb new file mode 100644 index 000000000..3d7a9c99d --- /dev/null +++ b/db/migrate/20191212022653_create_imported_statuses.rb @@ -0,0 +1,21 @@ +class CreateImportedStatuses < ActiveRecord::Migration[5.2] + def up + create_table :imported_statuses do |t| + t.references :status, foreign_key: true, index: {unique: true} + t.string :origin, index: {unique: true} + end + + safety_assured { execute 'INSERT INTO imported_statuses (status_id, origin) SELECT id, origin FROM statuses WHERE imported' } + safety_assured do + remove_column :statuses, :imported + remove_column :statuses, :origin + end + end + + def down + add_column :statuses, :imported, :boolean + add_column :statuses, :origin, :string, index: { unique: true } + execute 'UPDATE statuses SET imported = true, origin = s.origin FROM (SELECT status_id, origin FROM imported_statuses) AS s WHERE statuses.id = s.id' + drop_table :imported_statuses + end +end |