Comment 1 for bug 493799

Ideally the nec. sql calls to create tables and such should not be hard coded but rather, should be driven by a script file that is saved as a project resource. The script file should be the one that is produced by running "mysqldump -d -h HOSTNAME -u USERNAME -pPASSWORD DBNAME" against a working copy of the database. That command will produce all the commands nec to recreate the db but the -d option will suppress all the insert statements, so we get a script to build the db tables but not the data - exactly what we want.

The other (maybe obvious) advantage of doing it this way is that we're always guaranteed to be building exactly the db that the code is currently expecting.