changed assignment.assignmentID to an autoincrement.