001_create_users.rb

class CreateUsers < ActiveRecord::Migration
  def self.up
    create_table :users do |t|
      t.string :login, :password, :email, :null => false

      t.timestamps
    end
    
  end

  def self.down
    drop_table :users
  end
end

002_create_profiles.rb

class CreateProfiles < ActiveRecord::Migration
  def self.up
    create_table :profiles do |t|
      t.string :name, :realm, :null => false
      t.integer :race_id, :user_id, :null => false
      t.integer :main_hand, :off_hand, :head, :neck, :shoulders, :back, :chest,
                :wrist, :hands, :waist, :legs, :feet, :ring_one, :ring_two,
                :trinket_one, :trinket_two, :ranged_weapon, :quiver, :ammo
      t.timestamps
    end
  end

  def self.down
    drop_table :profiles
  end
end

007_add_description_to_profile.rb

class AddDescriptionToProfile < ActiveRecord::Migration
  def self.up
    add_column :profiles, :description, :string
  end

  def self.down
    remove_column :profiles, :description
  end
end