From bcd7c81a462ec6972dc5353f799998209427dc58 Mon Sep 17 00:00:00 2001
From: Jason Kirtland <jek@discorporate.us>
Date: Sat, 27 Sep 2008 18:26:53 +0000
Subject: Fixed mysql TEMPORARY table reflection.

---
 lib/sqlalchemy/databases/mysql.py | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'lib/sqlalchemy/databases/mysql.py')

diff --git a/lib/sqlalchemy/databases/mysql.py b/lib/sqlalchemy/databases/mysql.py
index 9058df926..f1187b8ac 100644
--- a/lib/sqlalchemy/databases/mysql.py
+++ b/lib/sqlalchemy/databases/mysql.py
@@ -2406,7 +2406,7 @@ class MySQLSchemaReflector(object):
                             self.preparer._escape_identifier(_final))]))
 
         self._pr_name = _pr_compile(
-            r'^CREATE TABLE +'
+            r'^CREATE (?:\w+ +)?TABLE +'
             r'%(iq)s(?P<name>(?:%(esc_fq)s|[^%(fq)s])+)%(fq)s +\($' % quotes,
             self.preparer._unescape_identifier)
 
-- 
cgit v1.2.1