Contents

class UpgradeTo160 < ActiveRecord::Migration
  def self.up
    add_column :cms_sites, :identifier, :string
    add_index :cms_sites, :identifier
    
    rename_column :cms_layouts, :slug, :identifier
    rename_column :cms_blocks, :label, :identifier
    rename_column :cms_snippets, :slug, :identifier
    
    add_column :cms_categories, :site_id, :integer, :null => :false
    add_index :cms_categories, [:site_id, :categorized_type, :label], :unique => true
  end
  
  def self.down
    remove_index :cms_categories, [:site_id, :categorized_type, :label], :unique => true
    remove_column :cms_categories, :site_id
    
    rename_column :cms_snippets, :identifier, :slug
    rename_column :cms_blocks, :identifier, :label
    rename_column :cms_layouts, :identifier, :slug
    
    remove_index :cms_sites, :identifier
    remove_column :cms_sites, :identifier
  end
end

Version data entries

60 entries across 60 versions & 2 rubygems

Version	Path
comfortable_mexican_sofa-1.6.22	db/upgrade_migrations/07_upgrade_to_1_6_0.rb
comfortable_mexican_sofa-1.6.21	db/upgrade_migrations/07_upgrade_to_1_6_0.rb
comfortable_mexican_sofa-1.6.20	db/upgrade_migrations/07_upgrade_to_1_6_0.rb
comfortable_mexican_sofa-1.6.19	db/upgrade_migrations/07_upgrade_to_1_6_0.rb
comfortable_mexican_sofa-1.6.18	db/upgrade_migrations/07_upgrade_to_1_6_0.rb
comfortable_mexican_sofa-1.6.17	db/upgrade_migrations/07_upgrade_to_1_6_0.rb
comfortable_mexican_sofa-1.6.16	db/upgrade_migrations/07_upgrade_to_1_6_0.rb
comfortable_mexican_sofa-1.6.15	db/upgrade_migrations/07_upgrade_to_1_6_0.rb
comfortable_mexican_sofa-1.6.14	db/upgrade_migrations/07_upgrade_to_1_6_0.rb
comfortable_mexican_sofa-1.6.13	db/upgrade_migrations/07_upgrade_to_1_6_0.rb
comfortable_mexican_sofa-1.6.12	db/upgrade_migrations/07_upgrade_to_1_6_0.rb
comfortable_mexican_sofa-1.6.11	db/upgrade_migrations/07_upgrade_to_1_6_0.rb
comfortable_mexican_sofa-1.6.10	db/upgrade_migrations/07_upgrade_to_1_6_0.rb
comfortable_mexican_sofa-1.6.9	db/upgrade_migrations/07_upgrade_to_1_6_0.rb
comfortable_mexican_sofa-1.6.8	db/upgrade_migrations/07_upgrade_to_1_6_0.rb
comfortable_mexican_sofa-1.6.7	db/upgrade_migrations/07_upgrade_to_1_6_0.rb
comfortable_mexican_sofa-1.6.6	db/upgrade_migrations/07_upgrade_to_1_6_0.rb
comfortable_mexican_sofa-1.6.5	db/upgrade_migrations/07_upgrade_to_1_6_0.rb
comfortable_mexican_sofa-1.6.4	db/upgrade_migrations/07_upgrade_to_1_6_0.rb
comfortable_mexican_sofa-1.6.3	db/upgrade_migrations/07_upgrade_to_1_6_0.rb