Drop the database and create it. Remove all files in /databases
That way web2py loses the old state of the database and recreates all tables.
If you only want to reset a table, drop that table and remove responding file under databases
Kenneth
Hi all I am learning the ropes so to speak and am using a remote mysql as a db I have sorted out the tables from legacy db to be generated by web2py along with the auth tables I need to know what the quick way is to reset the db - as i learn and make mistakes in previous times I would just drop a table and I had assumed from what I read web2p would find it missing and reinstall / generate This is not the case and when i make changes they do not seem to update the tables I cannot pack and reinstall because it remembers DB state So I end up creating a new simple app and dropping in the files i used before db.py, default.py and any views etc I have altered then the system resets and lets me move on there must be a better way? Thank you in advance for your time newbie apologies