Chris@1464: class AddQueriesVisibility < ActiveRecord::Migration
Chris@1464:   def up
Chris@1464:     add_column :queries, :visibility, :integer, :default => 0
Chris@1464:     Query.where(:is_public => true).update_all(:visibility => 2)
Chris@1464:     remove_column :queries, :is_public
Chris@1464:   end
Chris@1464: 
Chris@1464:   def down
Chris@1464:     add_column :queries, :is_public, :boolean, :default => true, :null => false
Chris@1464:     Query.where('visibility <> ?', 2).update_all(:is_public => false)
Chris@1464:     remove_column :queries, :visibility
Chris@1464:   end
Chris@1464: end