I removed the database.sql as it contained a very old version of the database structure.
This seems to have caused some confusion as this database file was used by some to install pesapi, and subsequently the install script only checked if the database had the correct tables not if it actually had the correct structure.

My appologies for leaving this "old" structure behind.
The "official" way to install Pesapi database structure is to use the supplied install script which will automatically create the database structure if it is not present.