-- Language: sql

// 14095 => 14277 = 182
// 14095 to 14117
// 0p4_good_issue_note

update 0p4_good_issue_note set id=id+182
where id>=14095;

update 0p4_invoice set good_issue_note_id=good_issue_note_id+182
where good_issue_note_id>=14095;


// 0p4_good_issue_note_items
// 279963=>284572  = 4609
update 0p4_good_issue_note_items set id=id+4609
where good_issue_note_id>=14095;

update 0p4_good_issue_note_items set good_issue_note_id=good_issue_note_id+182
where good_issue_note_id>=14095;


// 0p4_good_issue_note_item_detail
// 294393 => 298943 = 4550
update 0p4_good_issue_note_item_detail set id=id+4550
where good_issue_note_item_id>=14095;

update 0p4_good_issue_note_items set good_issue_note_detail_id=good_issue_note_detail_id+4609
where good_issue_note_id>=14095;

update 0p4_good_issue_note_item_detail set good_issue_note_id=good_issue_note_id+182
where good_issue_note_id>=14095;