You are right Christophe! Thank you very much.
I am using declarative sintax so I added:
__table_args__ = {'mysql_engine':'InnoDB'}
to my class definition.
Regards
On 26 sep, 13:10, Christophe de Vienne <[email protected]> wrote:
> Hi
>
> IIRC, the default mysql engine is MyISAM, which has no support for
> foreign keys.
> Try adding "mysql_engine = 'InnoDB'" to your Table parameters :
>
> t = Table(name, meta,
> Column(...)
> ...
>
> mysql_engine="InnoDB")
>
> Christophe
>
> On 25 sep, 18:36, Juan Antonio Ibáñez <[email protected]> wrote:
>
>
>
> > Hello!
>
> > How could I get foreign keys from my model get reflected into DB
> > DDL? I am using MySQL as DB engine. I can define:
>
> > bank=Column(Integer, ForeignKey('banks.id'))
>
> > as one of my columns but when I use setup script to initialize DB no
> > foreign keys are created into DB.
>
> > Regards
--
You received this message because you are subscribed to the Google Groups
"TurboGears" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/turbogears?hl=en.
