From bef9e234de84a1601df4d324feb5c422818a6d3d Mon Sep 17 00:00:00 2001
From: Jason Kirtland <jek@discorporate.us>
Date: Wed, 10 Feb 2010 18:32:56 +0000
Subject: Fix mysql reflection of TINYINT(1) UNSIGNED columns.

---
 lib/sqlalchemy/dialects/mysql/base.py | 5 +++--
 1 file changed, 3 insertions(+), 2 deletions(-)

(limited to 'lib/sqlalchemy')

diff --git a/lib/sqlalchemy/dialects/mysql/base.py b/lib/sqlalchemy/dialects/mysql/base.py
index 77b13c1a7..eb348f1a1 100644
--- a/lib/sqlalchemy/dialects/mysql/base.py
+++ b/lib/sqlalchemy/dialects/mysql/base.py
@@ -1084,7 +1084,7 @@ ischema_names = {
     'binary': BINARY,
     'bit': BIT,
     'blob': BLOB,
-    'boolean':BOOLEAN,
+    'boolean': BOOLEAN,
     'char': CHAR,
     'date': DATE,
     'datetime': DATETIME,
@@ -2154,7 +2154,6 @@ class MySQLTableDefinitionParser(object):
           Any column-bearing line from SHOW CREATE TABLE
         """
 
-        charset = state.charset
         spec = None
         m = self._re_column.match(line)
         if m:
@@ -2178,6 +2177,8 @@ class MySQLTableDefinitionParser(object):
         if type_ == 'tinyint' and args == '1':
             type_ = 'boolean'
             args = None
+            spec['unsigned'] = None
+            spec['zerofill'] = None
 
         try:
             col_type = self.dialect.ischema_names[type_]
-- 
cgit v1.2.1