You can read more about all this here: http://web2py.com/book/default/chapter/06#Migrations
On Friday, May 20, 2011 12:25:03 AM UTC-4, Anthony wrote: > On Thursday, May 19, 2011 11:48:07 PM UTC-4, james c. wrote: >> >> The tables are created by web2py >> with a 31 digit hex number appended to the generic name + user id. > > > The table names in the actual database are simply the names you define in > your db.define_table() definitions. If you want to drop a table, just use > the table name itself (without any 31 digit hex number): > > this_current_view = 'current_view_' + str(auth.user_id) > db[this_current_view].drop() > > > The files with the 31 digit hex prefixes are not the database tables > themselves -- they are web2py migration files that store migration data for > the tables. The hex prefix is a hash of the db connection string. Looking at > the DAL code, you should be able to figure out the prefix using this code: > > > import hashlib > hex_prefix = '%s_%s.table' % (hashlib.md5(db._uri).hexdigest(), tablename) > > > However, the migration file names are simply an automatic default generated > by web2py. As an alternative, you can specify your own migration file name > for each table using the 'migrate' argument to define_table(). For example: > > db.define_table(current_view_db, current_view_template, migrate='%s.table' > % current_view_db) > > > Note, when you drop a table using .drop(), it drops it from the database, > but I don't think it will delete the migration file, so you'll have to add > some code to delete the migration file yourself. > > Anthony > >
