updated to use .sql file with no joint primary keys and introduced integer primary keys where necessary