- fix this test for MySQL, needs InnoDB

1 files changed, 7 insertions, 3 deletions

diff --git a/test/ext/test_automap.py b/test/ext/test_automap.py
index 78985f134..f24164cb7 100644
--- a/test/ext/test_automap.py
+++ b/test/ext/test_automap.py
@@ -4,8 +4,9 @@ from sqlalchemy.ext.automap import automap_base
 from sqlalchemy.orm import relationship, interfaces, backref
 from sqlalchemy.ext.automap import generate_relationship
 from sqlalchemy.testing.mock import Mock, call
-from sqlalchemy import Column, String, Table, Integer, ForeignKey
+from sqlalchemy import String, Integer, ForeignKey
 from sqlalchemy import testing
+from sqlalchemy.testing.schema import Table, Column
 
 class AutomapTest(fixtures.MappedTest):
     @classmethod
@@ -153,16 +154,19 @@ class AutomapInhTest(fixtures.MappedTest):
     def define_tables(cls, metadata):
         Table('single', metadata,
                 Column('id', Integer, primary_key=True),
-                Column('type', String(10))
+                Column('type', String(10)),
+                test_needs_fk=True
             )
 
         Table('joined_base', metadata,
                 Column('id', Integer, primary_key=True),
-                Column('type', String(10))
+                Column('type', String(10)),
+                test_needs_fk=True
             )
 
         Table('joined_inh', metadata,
                 Column('id', Integer, ForeignKey('joined_base.id'), primary_key=True),
+                test_needs_fk=True
             )
 
         FixtureTest.define_tables(metadata)