Sha256: 07bb7b2ec91478c86832ee45cc9a8493bd3662793ce7fba569482db9eb0e0046

Contents?: true

Size: 446 Bytes

Versions: 34

Compression:

Stored size: 446 Bytes

Contents

class AddQueriesVisibility < ActiveRecord::Migration
  def up
    add_column :queries, :visibility, :integer, :default => 0
    Query.where(:is_public => true).update_all(:visibility => 2)
    remove_column :queries, :is_public
  end

  def down
    add_column :queries, :is_public, :boolean, :default => true, :null => false
    Query.where('visibility <> ?', 2).update_all(:is_public => false)
    remove_column :queries, :visibility
  end
end

Version data entries

34 entries across 34 versions & 1 rubygems

Version Path
redmine_extensions-0.0.39 spec/redmine/db/migrate/20130710182539_add_queries_visibility.rb
redmine_extensions-0.0.38 spec/redmine/db/migrate/20130710182539_add_queries_visibility.rb
redmine_extensions-0.0.37 spec/redmine/db/migrate/20130710182539_add_queries_visibility.rb
redmine_extensions-0.1.11 spec/redmine/db/migrate/20130710182539_add_queries_visibility.rb
redmine_extensions-0.1.10 spec/redmine/db/migrate/20130710182539_add_queries_visibility.rb
redmine_extensions-0.0.36 spec/redmine/db/migrate/20130710182539_add_queries_visibility.rb
redmine_extensions-0.0.34 spec/redmine/db/migrate/20130710182539_add_queries_visibility.rb
redmine_extensions-0.1.09 spec/redmine/db/migrate/20130710182539_add_queries_visibility.rb
redmine_extensions-0.1.07 spec/redmine/db/migrate/20130710182539_add_queries_visibility.rb
redmine_extensions-0.1.06 spec/redmine/db/migrate/20130710182539_add_queries_visibility.rb
redmine_extensions-0.1.05 spec/redmine/db/migrate/20130710182539_add_queries_visibility.rb
redmine_extensions-0.1.04 spec/redmine/db/migrate/20130710182539_add_queries_visibility.rb
redmine_extensions-0.1.03 spec/redmine/db/migrate/20130710182539_add_queries_visibility.rb
redmine_extensions-0.0.33 spec/redmine/db/migrate/20130710182539_add_queries_visibility.rb
redmine_extensions-0.1.02 spec/redmine/db/migrate/20130710182539_add_queries_visibility.rb
redmine_extensions-0.1.01 spec/redmine/db/migrate/20130710182539_add_queries_visibility.rb
redmine_extensions-0.0.29 spec/redmine/db/migrate/20130710182539_add_queries_visibility.rb
redmine_extensions-0.0.28 spec/redmine/db/migrate/20130710182539_add_queries_visibility.rb
redmine_extensions-0.0.27 spec/redmine/db/migrate/20130710182539_add_queries_visibility.rb
redmine_extensions-0.0.24 spec/redmine/db/migrate/20130710182539_add_queries_visibility.rb