field are not created in order

I am using mysql with sqlachemy python-mysqldb_1.2.2-7_i386.deb python-sqlalchemy_0.4.6-1_all.deb

fields define in the model are not created in the same order. it does not cause any problem but i just like seeing my fields in some logical order. I doubt I'm the only one.

so a table definition like this one.

class Action(Base): tablename = 'action' id = Column(Integer, primary_key=True) command = Column(UnicodeText) return_code = Column(Integer) output = Column(UnicodeText)

will create the following table

CREATE TABLE action ( return_code INTEGER, command TEXT, output TEXT, id INTEGER NOT NULL AUTO_INCREMENT, PRIMARY KEY (id) )

thanks

Comments (1)