Makeover

Home Solidarrow Ruby on Rails Cheatsheets

Rails Migrations Cheatsheet

Up and down methods, rake tasks, column mapping, loading fixtures, example migration file, all packed onto one A4 page for an easy at-a-glance reference. Updated for Rails 2.1

Table Methods - migration methods for creating and updating tables
Database mapping - how migration column types map to your underlying database
Example migration - What a migration file looks like
Rake tasks - a list of built-in migration-related Rake tasks
Directory Structure - where migration files go
Shortcut methods - various convenience methods
Column Methods - methods that operate on database columns
Index methods - methods for creating indexes
Miscellaneous methods - other methods
script/generate - generate a template migration file
Loading fixtures - load fixtures into your database via a migration

View all on one page

Database Mapping

Rails	db2	mysql	openbase	Oracle
`:binary`	blob(32678)	blob	object	blob
`:boolean`	decimal(1)	tinyint(1)	boolean	number(10)
`:date`	date	date	date	date
`:datetime`	timestamp	datetime	datetime	date
`:decimal`	decimal	decimal	decimal	decimal
`:float`	float	float	float	number
`:integer`	int	int(11)	integer	number(38)
`:string`	varchar(255)	varchar(255)	char(4096)	varchar2(255)
`:text`	clob(32768)	text	text	clob
`:time`	time	time	time	date
`:timestamp`	timestamp	datetime	timestamp	date

Rails	postgresql	sqlite	sqlserver	Sybase
`:binary`	bytea	blob	image	image
`:boolean`	boolean	boolean	bit	bit
`:date`	date	date	datetime	datetime
`:datetime`	timestamp	datetime	datetime	datetime
`:decimal`	decimal	decimal	decimal	decimal
`:float`	float	float	float(8)	float(8)
`:integer`	integer	integer	int	int
`:string`	*	varchar(255)	varchar(255)	varchar(255)
`:text`	text	text	text	text
`:time`	time	datetime	datetime	time
`:timestamp`	timestamp	datetime	datetime	timestamp

RELATED ARTICLE

New in Rails 2.0: Sexy Migrations

A look at the new features and syntax available in migrations on Rails 2.0 More

RELATED ARTICLE

Auto migrations

A brilliant plugin that makes changing your database schema even easier and faster. More