A test of whether the ActiveRecord ruby schema format supports bigints

migration.rb

# Create a table in a migration, testing both :integer with a limit of 8, and a :bigint

create_table :people, :force => true do |t|
  t.column :col_1, :integer, :limit => 8
  t.column :col_2, :bigint
  t.column :col_3, :integer
end

schema.rb

# This is the table represented by the ruby schema format.

create_table "people", :force => true do |t|
  t.integer  "col_1", :limit => 8
  t.integer  "col_2", :limit => 8
  t.integer  "col_3"
end

schema.sql

# This is the table represented in the sql format.  You can see that both col_1 and col_2 have been created as bigints.

CREATE TABLE `people` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `col_1` bigint(20) DEFAULT NULL,
  `col_2` bigint(20) DEFAULT NULL,
  `col_3` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;