Contents

class CreateRegions < ActiveRecord::Migration
  def self.up
    create_table :regions do |t|
      t.column :country_id, :integer, :null => false
      t.column :name, :string, :null => false, :limit => 50
      t.column :abbreviation, :string, :null => false, :limit => 5
    end
    add_index :regions, [:name, :country_id], :unique => true
    add_index :regions, [:abbreviation, :country_id], :unique => true
  end
  
  def self.down
    drop_table :regions
  end
end

Version data entries

2 entries across 2 versions & 1 rubygems

Version	Path
has_addresses-0.0.1	db/migrate/002_create_regions.rb
has_addresses-0.0.2	db/migrate/002_create_regions.rb