-require 'lib/migrate'
+require "migrate"
class AddMoreControlsToGpxFiles < ActiveRecord::Migration
def self.up
- create_enumeration :gpx_visibility_enum, ["private", "public", "trackable", "identifiable"]
+ create_enumeration :gpx_visibility_enum, %w(private public trackable identifiable)
add_column :gpx_files, :visibility, :gpx_visibility_enum, :default => "public", :null => false
- Trace.update_all("visibility = 'private'", { :public => false })
+ Trace.where(:public => false).update_all(:visibility => "private")
add_index :gpx_files, [:visible, :visibility], :name => "gpx_files_visible_visibility_idx"
remove_index :gpx_files, :name => "gpx_files_visible_public_idx"
remove_column :gpx_files, :public
def self.down
add_column :gpx_files, :public, :boolean, :default => true, :null => false
- Trace.update_all("public = false", { :visibility => "private" })
+ Trace.where(:visibility => "private").update_all(:public => false)
add_index :gpx_files, [:visible, :public], :name => "gpx_files_visible_public_idx"
remove_index :gpx_files, :name => "gpx_files_visible_visibility_idx"
remove_column :gpx_files, :visibility