Wayan Saryada wrote:How many tables you have to create for this program?
~15 tables with ~10 fields each. It's not precise values because as Tony mentioned, the scripts may not cover all the fields.
Tony Docherty wrote:you may be able to get some of the information required to construct some of the tables but you will be hard pressed to get the exact data type/field widths etc for every field in every table.
So the best solution would be to run the app, see what fields are required, modify schema, drop-create table, run again to see if the script run successfully? That's crazy, but the only way I see to solve this problem.