17 lines
950 B
SQL
17 lines
950 B
SQL
-- Reset order rows with status 'sent' to 'print', so they can be scanned and delivered
|
|
|
|
UPDATE order_rows SET status = 'print' WHERE id in (
|
|
2380666,2380728,2380730,2380773,2380896,2380939,2381307,2381308,2381309,2381506,2381586,2381598
|
|
);
|
|
|
|
-- From the following orders:
|
|
-- https://www.photowall.com/admin/order?orderId=821737 | {packed,sent}
|
|
-- https://www.photowall.com/admin/order?orderId=821777 | {packed,sent,sent}
|
|
-- https://www.photowall.com/admin/order?orderId=821804 | {packed,sent,packed}
|
|
-- https://www.photowall.com/admin/order?orderId=821874 | {sent,packed}
|
|
-- https://www.photowall.com/admin/order?orderId=821899 | {packed,sent}
|
|
-- https://www.photowall.com/admin/order?orderId=822090 | {sent,packed,sent,sent,packed}
|
|
-- https://www.photowall.com/admin/order?orderId=822194 | {sent,packed}
|
|
-- https://www.photowall.com/admin/order?orderId=822239 | {packed,sent}
|
|
-- https://www.photowall.com/admin/order?orderId=822248 | {packed,sent}
|