class AddVersioned < ActiveRecord::Migration
  def self.up
    add_column :resources, :version, :integer, :default => 1
    Resource.create_versioned_table

    begin
      rs = Resource.find(:all)
    rescue
      puts "\n\n*** No resources found ***\n\n"
      rs = nil
    end

    if rs
      puts "\n\n*** Setting initial version to 1 ***\n\n"
      rs.each do |r|
        r.version = 1
        r.save
      end      
    end
  end

  def self.down
    Resource.drop_versioned_table
    remove_column :resources, :version
  end
end