Change {batch}.id column from serial to regular int.
function system_update_7050() {
db_change_field('batch', 'bid', 'bid', array(
'description' => 'Primary Key: Unique batch ID.',
'type' => 'int',
'unsigned' => TRUE,
'not null' => TRUE,
));
}