Fix failing tests by changing primary key constraint to 'cascade'.
intermediate commit.
Changes to allow the application to run in a subdirectory.
Changes to allow the application to run in a subdirectory.