class FixPatchView < ActiveRecord::Migration
  def self.up
    execute "DROP VIEW patch_view"
    execute <<EOS
    CREATE VIEW patch_view AS select patches.*, pv.id as patch_version_id, 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"
    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
end