Rails Migrations, MySQL, unsigned integers, primary keys, and a lot of fun times

April 7, 2009

By default Rails uses int(11) as the standard for primary key (id) columns. MySQL prefers unsigned numeric types. Plugin mysql_migration_optimize supports unsigned integers, column display width and complete control over the primary key. Also explained is how to use different numeric types such as tinyint and bigint with Rails Migrations.