Hi Stargate,
I think what you want is called the DAL or Database Abstraction Layer.
The DAL does all of this for you for all of the databases that Web2py
support. You create your database schema in Web2py and the DAL sets up
whatever database backend you are using.
So for example you create this table and field and insert it in a file
in the models section and when you run the application the Web2py
driver for your database does all the "grunt work". You can use the
same definition for a number of database backends as follows:
db.define_table('mytable', Field('myfield'))
See chapter 6 of the online book for more info:
http://web2py.com/book/default/chapter/06
On Feb 22, 10:23 pm, stargate <[email protected]> wrote:
> I just started using mySQL with web2py now my question is when
> administrating the database from the web interface i added a new table
> in the mySQL database but when i hit refresh in the browser the table
> doesn't show up. Also when adding another user I have to specify the
> userID. How can you change this so in the database you select the
> maxID and add one to the ID. Also when I delete the default users in
> the database the default users come back.
