Hi guys, I'm new to web2py, and got a question here. I want to design a database with sqlite for my app, but I prefer to design it on a visualiable tool e.g. GEA, which is recommended in web2py admin panel. But after some trials, I can't get the generated script work in web2py, especially for tables with foreign keys.
My question is, do you have the same issue here? Or can you please tell me the normal workaround to design a sqlite database in web2py without writing the define_table script directly? Thanks, David --