Re: Index DDL not emitted

2014-06-02 Thread Michael Bayer
given: from sqlalchemy import * from sqlalchemy.ext.declarative import declarative_base Base = declarative_base() class Dummy(Base): __tablename__ = "dummy" id = Column(Integer, primary_key=True) f1 = Column(Integer, index=True) e = create_engine("mysql://scott:tiger@localhost/test"

Index DDL not emitted

2014-06-02 Thread YKdvd
class Dummy(AlchemyBase): __tablename__ = "dummy" id = Column(Integer, primary_key=True) f1 = Column(Integer, index=True) When I create using the above on MySQL, the DDL is: CREATE TABLE dummy ( id INTEGER NOT NULL AUTO_INCREMENT, f1 INTEGER, PRIMARY KEY (id) ) Shouldn't there be an INDEX clau