JezK
Edit File: mysql_specific_schema.rb
ActiveRecord::Schema.define do create_table :binary_fields, :force => true, :options => 'CHARACTER SET latin1' do |t| t.binary :tiny_blob, :limit => 255 t.binary :normal_blob, :limit => 65535 t.binary :medium_blob, :limit => 16777215 t.binary :long_blob, :limit => 2147483647 t.text :tiny_text, :limit => 255 t.text :normal_text, :limit => 65535 t.text :medium_text, :limit => 16777215 t.text :long_text, :limit => 2147483647 end ActiveRecord::Base.connection.execute <<-SQL DROP PROCEDURE IF EXISTS ten; SQL ActiveRecord::Base.connection.execute <<-SQL CREATE PROCEDURE ten() SQL SECURITY INVOKER BEGIN select 10; END SQL ActiveRecord::Base.connection.execute <<-SQL CREATE PROCEDURE topics() SQL SECURITY INVOKER BEGIN select * from topics limit 1; END SQL end