If you do end up needing to manually define some auth tables at some point (in order to customize them), the book explains how: http://web2py.com/book/default/chapter/08#Customizing-Auth
On Tuesday, February 22, 2011 9:28:29 PM UTC-5, stargate wrote: > 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 <[email protected]> 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 <[email protected]> wrote: > > > > > Has anybody done this. Basically I want export the basic table > > > structure from sqllite to mySql > > > > > On Feb 22, 7:44 am, stargate <[email protected]> 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 > > > >
