Rikard BartholfandGitHub
9dee3d1f3c
* Delete redundant discount data from order_rows * Bump revision prior release
12 lines
268 B
SQL
12 lines
268 B
SQL
UPDATE order_rows
|
|
SET data = data
|
|
- 'discount_amount'
|
|
- 'discountType'
|
|
- 'discountValue'
|
|
WHERE id IN (
|
|
SELECT id
|
|
FROM order_rows
|
|
WHERE NOT data->>'reprinted_order_row_id' IS NULL
|
|
AND NOT data->>'discount_amount' IS NULL
|
|
);
|