class AddConstraintsToAssets < ActiveRecord::Migration
  def self.up
    execute "alter table #{Asset.table_name}
              add constraint assets_check_kind
              check (kind in (#{ Asset::KINDS.collect{|a| "'#{a}'"}.join(',')  }));".to_line
  end

  def self.down
    execute "alter table #{Asset.table_name}
             drop constraint assets_check_kind;".to_line
  end
end