1 -- @tag: shop_order_items_discount
2 -- @description: shop_order_items haben einen identifier und referenzieren prozentualen rabatt
3 -- @depends: shop_orders_update_4
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;