Forgot autoincrement for primary keys and they needed to be INTEGER. Added some test data.