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.12.11	db/upgrade_migrations/07_upgrade_to_1_6_0.rb
comfortable_mexican_sofa-1.12.10	db/upgrade_migrations/07_upgrade_to_1_6_0.rb
comfortable_mexican_sofa-1.12.9	db/upgrade_migrations/07_upgrade_to_1_6_0.rb
comfortable_mexican_sofa-1.12.8	db/upgrade_migrations/07_upgrade_to_1_6_0.rb
comfortable_mexican_sofa-1.12.7	db/upgrade_migrations/07_upgrade_to_1_6_0.rb
comfortable_mexican_sofa-1.12.6	db/upgrade_migrations/07_upgrade_to_1_6_0.rb
comfortable_mexican_sofa-1.12.5	db/upgrade_migrations/07_upgrade_to_1_6_0.rb
comfortable_mexican_sofa-1.12.4	db/upgrade_migrations/07_upgrade_to_1_6_0.rb
comfortable_mexican_sofa-1.12.3	db/upgrade_migrations/07_upgrade_to_1_6_0.rb
comfortable_mexican_sofa-1.6.31	db/upgrade_migrations/07_upgrade_to_1_6_0.rb
comfortable_mexican_sofa-1.12.2	db/upgrade_migrations/07_upgrade_to_1_6_0.rb
comfortable_mexican_sofa-1.12.1	db/upgrade_migrations/07_upgrade_to_1_6_0.rb
comfortable_mexican_sofa-1.12.0	db/upgrade_migrations/07_upgrade_to_1_6_0.rb
comfortable_mexican_sofa-1.11.2	db/upgrade_migrations/07_upgrade_to_1_6_0.rb
comfortable_mexican_sofa-1.11.1	db/upgrade_migrations/07_upgrade_to_1_6_0.rb
comfortable_mexican_sofa-1.11.0	db/upgrade_migrations/07_upgrade_to_1_6_0.rb
comfortable_mexican_sofa-1.10.3	db/upgrade_migrations/07_upgrade_to_1_6_0.rb
comfortable_mexican_sofa-1.10.2	db/upgrade_migrations/07_upgrade_to_1_6_0.rb
comfortable_mexican_sofa-1.10.1	db/upgrade_migrations/07_upgrade_to_1_6_0.rb
comfortable_mexican_sofa-1.10.0	db/upgrade_migrations/07_upgrade_to_1_6_0.rb