[Vince]

Best way is too just create the tables in a GUI such as phpMyAdmin. You only need to create the table once, so it's basically a waste of resources if that query is executed every time the server starts.

If you intend to distribute the script, then use the export function of phpMyAdmin to generate appropriate SQL code. People that do not manage to re-import the code should not be running a server in the first place.