Sha256: a7880fc72ce5f42fb74757651263f9c0c76b3dedd8f5ffb8496be341ffe376a8

Contents?: true

Size: 675 Bytes

Versions: 16

Compression:

Stored size: 675 Bytes

Contents

class ChangeAlchemyPagesLockedToLockedAt < ActiveRecord::Migration
  def up
    add_column :alchemy_pages, :locked_at, :datetime
    update <<-SQL.strip_heredoc
      UPDATE alchemy_pages
      SET locked_at = updated_at
      WHERE locked=#{ActiveRecord::Base.connection.quoted_true}
    SQL
    remove_column :alchemy_pages, :locked
    add_index :alchemy_pages, [:locked_at, :locked_by]
  end

  def down
    add_column :alchemy_pages, :locked, :boolean
    update <<-SQL.strip_heredoc
      UPDATE alchemy_pages
      SET locked=#{ActiveRecord::Base.connection.quoted_true}
      WHERE locked_at IS NOT NULL
    SQL
    remove_column :alchemy_pages, :locked_at
  end
end

Version data entries

16 entries across 16 versions & 1 rubygems

Version Path
alchemy_cms-3.6.7 db/migrate/20160617224938_change_alchemy_pages_locked_to_locked_at.rb
alchemy_cms-3.6.6 db/migrate/20160617224938_change_alchemy_pages_locked_to_locked_at.rb
alchemy_cms-3.6.5 db/migrate/20160617224938_change_alchemy_pages_locked_to_locked_at.rb
alchemy_cms-3.6.4 db/migrate/20160617224938_change_alchemy_pages_locked_to_locked_at.rb
alchemy_cms-3.6.3 db/migrate/20160617224938_change_alchemy_pages_locked_to_locked_at.rb
alchemy_cms-3.6.2 db/migrate/20160617224938_change_alchemy_pages_locked_to_locked_at.rb
alchemy_cms-3.6.1 db/migrate/20160617224938_change_alchemy_pages_locked_to_locked_at.rb
alchemy_cms-4.0.0.beta db/migrate/20160617224938_change_alchemy_pages_locked_to_locked_at.rb
alchemy_cms-3.6.0 db/migrate/20160617224938_change_alchemy_pages_locked_to_locked_at.rb
alchemy_cms-3.5.0 db/migrate/20160617224938_change_alchemy_pages_locked_to_locked_at.rb
alchemy_cms-3.4.2 db/migrate/20160617224938_change_alchemy_pages_locked_to_locked_at.rb
alchemy_cms-3.5.0.rc2 db/migrate/20160617224938_change_alchemy_pages_locked_to_locked_at.rb
alchemy_cms-3.5.0.rc1 db/migrate/20160617224938_change_alchemy_pages_locked_to_locked_at.rb
alchemy_cms-3.4.1 db/migrate/20160617224938_change_alchemy_pages_locked_to_locked_at.rb
alchemy_cms-3.4.0 db/migrate/20160617224938_change_alchemy_pages_locked_to_locked_at.rb
alchemy_cms-3.4.0.rc1 db/migrate/20160617224938_change_alchemy_pages_locked_to_locked_at.rb