From c1abe4430684512709976f66634903a4dc147d03 Mon Sep 17 00:00:00 2001 From: Michael Koziarski Date: Sun, 2 Mar 2008 04:42:10 +0000 Subject: Make the mysql schema dumper roundtrip the limits of text/blob columns. Closes #7424 [will.bryant] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@8969 5ecf4fe2-1ee6-0310-87b1-e25e094e27de --- .../active_record/connection_adapters/mysql_adapter.rb | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) (limited to 'activerecord/lib') diff --git a/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb b/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb index c37bfd3e81..6432c3cfee 100755 --- a/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb +++ b/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb @@ -112,6 +112,23 @@ module ActiveRecord super end + def extract_limit(sql_type) + if sql_type =~ /blob|text/i + case sql_type + when /tiny/i + 255 + when /medium/i + 16777215 + when /long/i + 2147483647 # mysql only allows 2^31-1, not 2^32-1, somewhat inconsistently with the tiny/medium/normal cases + else + super # we could return 65535 here, but we leave it undecorated by default + end + else + super + end + end + # MySQL misreports NOT NULL column default when none is given. # We can't detect this for columns which may have a legitimate '' # default (string) but we can for others (integer, datetime, boolean, -- cgit v1.2.3