Hey, I can give you an example of the type of tables creating me problems
db.define_table('competition',
Field('name', length=256, requires=[IS_NOT_EMPTY(), IS_LOWER()]),
Field('active_season', 'reference season'),
format='%(name)s',
migrate='competition.table'
)
db.define_table('season',
Field('start', 'date', requires=IS_EMPTY_OR(IS_DATE())),
Field('end', 'date', requires=IS_EMPTY_OR(IS_DATE())),
Field('competition', 'reference competition', requires=IS_IN_DB(db,
db.competition.id, '%(name)s', zero=T('choose one'))),
format='%(start)s - %(end)s',
migrate='season.table'
)
--
