Fixed a few missing renames
Fixed a problem where the primary key wasn't properly defined, meaning that the ID column
existed but was not populated, despite returning the correct last inserted row id
Explicitly define INTEGER column types to remove the need for resolving affinity