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"
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