[web2py] How to make SQLFORM generate INPUT type as 'date' instead 'text'

My field is defined in db.py as Field('mydate', type='date', requires=IS_DATE(format=T('%Y-%m-%d'))), Using a custom FORM() I only need to do this: INPUT(_type='date', _name='mydate') To generate a great YMD INPUT with pop-up calendar and selectable date parts: ... ... Now I want to use SQLF

[web2py] Re: MySQL - OperationalError: Error on rename (errno: 150)

I realize this is an ancient topic, but I'm having the very same error migrating a MySQL table where I'm only removing a self reference field. It seems like an index was created to guard the (self) foreign-key constraint and DAL doesn't remove it when deleting the field. There are no manually-cr