Database cannot be installed from scratch

[dleehr]

Part of issues identified in #13, database migrations are incomplete and the skel database does not load:

    $ mysql -u root -p FossilCalibration < FossilCalibration_skel.sql 
    Enter password: 
    ERROR 1146 (42S02) at line 4010: Table 'FossilCalibration.Link_CalibrationPair' doesn't exist

[dleehr]

Just an issue to track this separately from #13 - should be possible to bring up a functional instance from publicly available data.

[jimallman]

@dleehr, please try again with the modified test file FossilCalibration_skel_FOLDED.sql. (See my Aug 3 email for download instructions.)

This shuffles the order of commands to add a series of empty tables (incl. FossilCalibration.Link_CalibrationPair) before they're referenced, instead of at the end.

  $ mysql --user=root --password  < FossilCalibration_skel_FOLDED.sql

This worked for me in a VMware test instance (debian lenny, mysql-server 5.1).

[dleehr]

That installed successfully. Thanks!