1 -- @tag: recorditem_active_price_source
2 -- @description: Preisquelle in Belegpositionen
3 -- @depends: release_3_1_0
5 ALTER TABLE orderitems ADD COLUMN active_price_source TEXT NOT NULL DEFAULT '';
6 ALTER TABLE delivery_order_items ADD COLUMN active_price_source TEXT NOT NULL DEFAULT '';
7 ALTER TABLE invoice ADD COLUMN active_price_source TEXT NOT NULL DEFAULT '';
9 UPDATE orderitems SET active_price_source = 'pricegroup/' || pricegroup_id WHERE pricegroup_id > 0;
10 UPDATE delivery_order_items SET active_price_source = 'pricegroup/' || pricegroup_id WHERE pricegroup_id > 0;
11 UPDATE invoice SET active_price_source = 'pricegroup/' || pricegroup_id WHERE pricegroup_id > 0;