1 -- Create booking resource types
2 INSERT INTO booking.resource_type(id, name, owner, catalog_item, transferable)
3 VALUES (555, 'Meeting room', 1, False, True),
4 (556, 'Phone charger', 3, False, True);
6 -- Create booking resource types from MARC
7 SELECT evergreen.populate_booking_resource_type(6, 'IMPORT BOOKING');
9 -- Create booking resources
10 INSERT INTO booking.resource(owner, type, barcode)
11 VALUES (4, 555, 'ROOM1231'),
13 (4, 555, 'ROOM1233' ),
20 (6, 556, 'IPHONE-CHARGER-01'),
21 (6, 556, 'IPHONE-CHARGER-02'),
22 (7, 556, 'ANDROID-CHARGER-01'),
23 (7, 556, 'IPHONE-CHARGER-03'),
24 (9, 556, 'IPHONE-CHARGER-04'),
25 (9, 556, 'IPHONE-CHARGER-05');
27 -- Create booking resources from item records
28 SELECT evergreen.populate_booking_resource('EQUIP');