diff options
| author | Brian Lopez <seniorlopez@gmail.com> | 2010-08-02 01:37:57 -0700 |
|---|---|---|
| committer | Brian Lopez <seniorlopez@gmail.com> | 2010-08-02 01:37:57 -0700 |
| commit | 21e81da33570ba9453831cfc59c4f42ff9cdc1b2 (patch) | |
| tree | 80146b258842d120e3362119971971911ca6a0ef /activerecord/test/schema/mysql2_specific_schema.rb | |
| parent | fb0bd8c1092db51888ec4bb72af6c595e13c31fa (diff) | |
| download | rails-21e81da33570ba9453831cfc59c4f42ff9cdc1b2.tar.gz rails-21e81da33570ba9453831cfc59c4f42ff9cdc1b2.tar.bz2 rails-21e81da33570ba9453831cfc59c4f42ff9cdc1b2.zip | |
update tests for mysql2 support
Diffstat (limited to 'activerecord/test/schema/mysql2_specific_schema.rb')
| -rw-r--r-- | activerecord/test/schema/mysql2_specific_schema.rb | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/activerecord/test/schema/mysql2_specific_schema.rb b/activerecord/test/schema/mysql2_specific_schema.rb new file mode 100644 index 0000000000..c78d99f4af --- /dev/null +++ b/activerecord/test/schema/mysql2_specific_schema.rb @@ -0,0 +1,24 @@ +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 + +end |