1 COPY actor.workstation (id, name, owning_lib) FROM stdin;
11 10 WAKA-MAIN-lfloyd 108
17 16 HHPL-HHPL-sitka 106
18 17 RPLS-WEPL-tiffany 4
19 18 HHPL-HHPL-rfrasur 106
20 19 HHPL-HHPL-skiddoo 106
21 20 WAKA-MAIN-cwmars - jamundson 108
22 21 SMALL-SMALL-cwmars-jamundson 114
24 23 HHPL-HHPL-terran 106
25 24 SMALL-SMALL-terran 114
28 \echo sequence update column: id
29 SELECT SETVAL('actor.workstation_id_seq', (SELECT MAX(id) FROM actor.workstation));
31 -- a case where the deleted workstation had payments
32 INSERT INTO actor.workstation(id,name,owning_lib)
33 SELECT missingworkstation.id, aou.shortname||FLOOR(RANDOM() * 100 + 1)::INT, 1
37 DISTINCT mbdp.cash_drawer AS id
39 money.bnm_desk_payment mbdp
40 LEFT JOIN actor.workstation aw ON (mbdp.cash_drawer = aw.id)
44 JOIN actor.org_unit aou ON (aou.id=1);
46 -- anonymize workstation names
49 SET name=aou.shortname||'-'||aw.id
50 FROM actor.org_unit aou