I like singular table names but it's a bit of a religious war. Plural seems better when doing SQL queries but singular feels better with DAL queries.
I'm not sure Web2py's migrations can change a table name while preserving the data. You might need to make the change manually and then update your model. Make sure to backup!!
