Hi Ivan, mysql is not one of the supported DBs for keyed tables: only DB2, MSSQL, Ingres, and Informix have been added as per http://groups.google.com/group/web2py/browse_thread/thread/db150376b06d47fc
Adding support for mysql should be fairly easy but the required steps under point (E) in the post above have changed. In step 1 open dal.py instead of sql.py and look for the MySQLAdapter class instead of SQL_DIALECTS. Add appropriate entries for keys 'reference TK' and 'reference TFK' following the entries in one of the adapters that already have support for keyed tables, e.g. MSSQLAdapter. Step 2 seems to be unnecessary with dal.py, but maybe Massimo can clarify. Step 3 is still very important ;) Denes.
