]> git.evergreen-ils.org Git - Evergreen.git/blob - Open-ILS/tests/datasets/sql/concerto_enhanced/acq.purchase_order.sql
Stamping upgrade scripts and refifying baseline schema
[Evergreen.git] / Open-ILS / tests / datasets / sql / concerto_enhanced / acq.purchase_order.sql
1 COPY acq.purchase_order (id, owner, creator, editor, ordering_agency, create_time, edit_time, provider, state, order_date, name, cancel_reason, prepayment_required) FROM stdin;
2 1       1       1       1       4       2020-10-27 09:26:51.426709-05   2020-10-27 09:26:51.426709-05   1       pending \N      1       \N      0
3 2       1       1       1       4       2020-10-27 09:26:51.426709-05   2020-10-27 09:26:51.426709-05   2       on-order        2020-10-27 09:26:51.426709-05   2       \N      0
4 3       1       1       1       107     2022-06-17 10:28:17.626762-05   2022-06-17 10:28:17.626762-05   2       pending \N      3       \N      0
5 4       1       1       1       107     2022-06-17 10:33:21-05  2022-06-17 10:45:56.816962-05   1       on-order        2022-06-17 10:45:56.816962-05   April order     \N      0
6 5       1       1       1       105     2022-06-17 10:59:55-05  2022-06-17 11:00:28.935231-05   5       on-order        2022-06-17 11:00:28.935231-05   5       \N      0
7 \.
8
9 \echo sequence update column: id
10 SELECT SETVAL('acq.purchase_order_id_seq', (SELECT MAX(id) FROM acq.purchase_order));