class MoveAppliedToVersionBack < ActiveRecord::Migration
  def self.up
    execute "DROP VIEW patch_view"

    add_column  :patches, :applied_since_version, :string, :limit => 20
    Patch.find(:all) do |p|
      p.applied_since_version = p.last_version.applied_since_version
      p.save
    end
    remove_column :patch_versions, :applied_since_version

    execute <<EOS
    CREATE VIEW patch_view AS select patches.*, pv.for_upstream_version, pv.version, pv.comment from patch_versions pv join patches on pv.patch_id = patches.id where pv.id = (select id from patch_versions where patch_id = pv.patch_id order by version desc limit 1);
EOS
  end

  def self.down
    execute "DROP VIEW patch_view"

    add_column  :patch_versions, :applied_since_version, :string, :limit => 20
    Patch.find(:all) do |p|
      p.last_version.applied_since_version = p.applied_since_version
      p.last_version.save
    end
    remove_column :patches, :applied_since_version

    execute <<EOS
    CREATE VIEW patch_view AS select patches.*, pv.applied_since_version, pv.for_upstream_version, pv.version, pv.comment from patch_versions pv join patches on pv.patch_id = patches.id where pv.id = (select id from patch_versions where patch_id = pv.patch_id order by version desc limit 1);
EOS
  end
end