• Create database

> mysql -u root -p

mysql> create database myproject_development;
mysql> create database myproject_test;
mysql> create database myproject_production;
mysql> grant all on myproject_development.* to 'railsdev'@'localhost';
mysql> grant all on myproject_test.* to 'railsdev'@'localhost';
mysql> grant all on myproject_production.* to 'prod'@'localhost' identified by 'username';
exit

• Edit config/database.yml to match

• Generate initial migration script

> ruby script/generate migration initial

This creates db/migrate/001_initial.rb

• Edit db/migrate/001_initial.rb

class Initial < ActiveRecord::Migration
    def self.up
      create_table :users do |table|
        table.column :name, :string
        table.column :login,  :string
        table.column :password, :string, :limit => 32
        table.column :email, :string
      end
    end

    def self.down
      drop_table :users
    end
end

• Run the migration

> rake migrate

See also

• [http://weblog.jamisbuck.org/2005/9/27/getting-started-with-activerecord-migrations Getting started with Migrations]

• [http://garrettsnider.backpackit.com/pub/367902 Garrett Snider's cheat sheet]

CategoryCheatSheet