Revision 71c25621
Von Jan Büren vor mehr als 1 Jahr hinzugefügt
| SL/DB/MetaSetup/ShopOrderItem.pm | ||
|---|---|---|
| 11 | 11 |
__PACKAGE__->meta->columns( |
| 12 | 12 |
active_price_source => { type => 'text' },
|
| 13 | 13 |
description => { type => 'text' },
|
| 14 |
discount => { type => 'float', precision => 4, scale => 4 },
|
|
| 15 |
discount_code => { type => 'text' },
|
|
| 14 | 16 |
id => { type => 'serial', not_null => 1 },
|
| 17 |
identitfier => { type => 'text' },
|
|
| 15 | 18 |
partnumber => { type => 'text' },
|
| 16 | 19 |
position => { type => 'integer' },
|
| 17 | 20 |
price => { type => 'numeric', precision => 15, scale => 5 },
|
| 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 identitfier TEXT; |
|
Auch abrufbar als: Unified diff
Shopware6: shop_order_items referenzieren prozentualen rabatt