Thanks for the information it worked. I am very new to web2py coming from PHP but its great so far. I love it.
On Feb 22, 7:07 pm, DenesL <denes1...@yahoo.ca> wrote: > 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 > >