Contents

class UpgradeTo150 < ActiveRecord::Migration
  def self.up
    add_column :cms_snippets, :position,  :integer, :null => false, :default => 0
    add_column :cms_files, :position,     :integer, :null => false, :default => 0
    add_column :cms_files, :block_id,     :integer
    
    add_index :cms_snippets, [:site_id, :position]
    add_index :cms_files, [:site_id, :position]
    add_index :cms_files, [:site_id, :block_id]
  end
  
  def self.down
    remove_index :cms_snippets, [:site_id, :position]
    remove_index :cms_files, [:site_id, :position]
    remove_index :cms_files, [:site_id, :block_id]
    
    remove_column :cms_snippets, :position
    remove_column :cms_files, :position
    remove_column :cms_files, :block_id
  end
end

Version data entries

75 entries across 75 versions & 2 rubygems

Version	Path
comfortable_mexican_sofa-1.12.11	db/upgrade_migrations/06_upgrade_to_1_5_0.rb
comfortable_mexican_sofa-1.12.10	db/upgrade_migrations/06_upgrade_to_1_5_0.rb
comfortable_mexican_sofa-1.12.9	db/upgrade_migrations/06_upgrade_to_1_5_0.rb
comfortable_mexican_sofa-1.12.8	db/upgrade_migrations/06_upgrade_to_1_5_0.rb
comfortable_mexican_sofa-1.12.7	db/upgrade_migrations/06_upgrade_to_1_5_0.rb
comfortable_mexican_sofa-1.12.6	db/upgrade_migrations/06_upgrade_to_1_5_0.rb
comfortable_mexican_sofa-1.12.5	db/upgrade_migrations/06_upgrade_to_1_5_0.rb
comfortable_mexican_sofa-1.12.4	db/upgrade_migrations/06_upgrade_to_1_5_0.rb
comfortable_mexican_sofa-1.12.3	db/upgrade_migrations/06_upgrade_to_1_5_0.rb
comfortable_mexican_sofa-1.6.31	db/upgrade_migrations/06_upgrade_to_1_5_0.rb
comfortable_mexican_sofa-1.12.2	db/upgrade_migrations/06_upgrade_to_1_5_0.rb
comfortable_mexican_sofa-1.12.1	db/upgrade_migrations/06_upgrade_to_1_5_0.rb
comfortable_mexican_sofa-1.12.0	db/upgrade_migrations/06_upgrade_to_1_5_0.rb
comfortable_mexican_sofa-1.11.2	db/upgrade_migrations/06_upgrade_to_1_5_0.rb
comfortable_mexican_sofa-1.11.1	db/upgrade_migrations/06_upgrade_to_1_5_0.rb
comfortable_mexican_sofa-1.11.0	db/upgrade_migrations/06_upgrade_to_1_5_0.rb
comfortable_mexican_sofa-1.10.3	db/upgrade_migrations/06_upgrade_to_1_5_0.rb
comfortable_mexican_sofa-1.10.2	db/upgrade_migrations/06_upgrade_to_1_5_0.rb
comfortable_mexican_sofa-1.10.1	db/upgrade_migrations/06_upgrade_to_1_5_0.rb
comfortable_mexican_sofa-1.10.0	db/upgrade_migrations/06_upgrade_to_1_5_0.rb