1 -- @tag: master_rights_positions_fix
2 -- @description: Position in Rechtetabelle korrigieren (falls zutreffend)
3 -- @depends: release_3_5_4 purchase_letter_rights all_drafts_edit right_purchase_all_edit rights_sales_purchase_edit_prices
5 UPDATE auth.master_rights SET position = position/100
7 AND name IN ('purchase_letter_edit', 'purchase_letter_report', 'all_drafts_edit');
9 UPDATE auth.master_rights SET position = (SELECT position + 10 FROM auth.master_rights WHERE name = 'purchase_letter_edit')
10 WHERE position > 10000
11 AND name LIKE 'purchase_all_edit';
13 UPDATE auth.master_rights SET position =(SELECT position + 10 FROM auth.master_rights WHERE name = 'purchase_all_edit')
14 WHERE position > 10000
15 AND name LIKE 'purchase_edit_prices';