]> wagnertech.de Git - mfinanz.git/blob - sql/Pg-upgrade2/shop_order_items_discount.sql
Merge branch 'master' of http://wagnertech.de/git/mfinanz
[mfinanz.git] / sql / Pg-upgrade2 / shop_order_items_discount.sql
1 -- @tag: shop_order_items_discount
2 -- @description: shop_order_items haben einen identifier und referenzieren prozentualen rabatt
3 -- @depends: shop_orders_update_4
4
5 -- @ignore: 0
6
7 ALTER TABLE shop_order_items ADD COLUMN discount      REAL;
8 ALTER TABLE shop_order_items ADD COLUMN discount_code TEXT;
9 ALTER TABLE shop_order_items ADD COLUMN identifier    TEXT;