fix bug related to manufacturer primary key