Revision 601a8eb7
Von Jan Büren vor fast 2 Jahren hinzugefügt
| SL/DB/MetaSetup/ShopOrderItem.pm | ||
|---|---|---|
|
__PACKAGE__->meta->columns(
|
||
|
active_price_source => { type => 'text' },
|
||
|
description => { type => 'text' },
|
||
|
discount => { type => 'float', precision => 4, scale => 4 },
|
||
|
discount_code => { type => 'text' },
|
||
|
id => { type => 'serial', not_null => 1 },
|
||
|
identitfier => { type => 'text' },
|
||
|
partnumber => { type => 'text' },
|
||
|
position => { type => 'integer' },
|
||
|
price => { type => 'numeric', precision => 15, scale => 5 },
|
||
| sql/Pg-upgrade2/shop_order_items_discount.sql | ||
|---|---|---|
|
-- @tag: shop_order_items_discount
|
||
|
-- @description: shop_order_items haben einen identifier und referenzieren prozentualen rabatt
|
||
|
-- @depends: shop_orders_update_4
|
||
|
|
||
|
-- @ignore: 0
|
||
|
|
||
|
ALTER TABLE shop_order_items ADD COLUMN discount REAL;
|
||
|
ALTER TABLE shop_order_items ADD COLUMN discount_code TEXT;
|
||
|
ALTER TABLE shop_order_items ADD COLUMN identitfier TEXT;
|
||
Auch abrufbar als: Unified diff
Shopware6: shop_order_items referenzieren prozentualen rabatt