[web2py] Re: mysql create table syntax for default tables

[DenesL]

web2py will create the tables for you
if in models/db.py you set db=DAL('mysql://...')
it will call auth.define_tables() which is defined in gluon/tool.py

or you can call it from another model.

Have a look in tools.py to see how the tables are defined.



On Feb 22, 3:52 pm, stargate <kyoukh...@gmail.com> wrote:
> Has anybody done this.  Basically I want export the basic table
> structure from sqllite to mySql
>
> On Feb 22, 7:44 am, stargate <kyoukh...@gmail.com> wrote:
>
> > I was wondering if anybody has the create table syntax for mySQL for
> > the following tables that come with web2py
>
> > db.auth_user
> > db.auth_group
> > db.auth_membership
> > db.auth_permission
> > db.auth_event
>
>