 INSERT INTO referencedata.rights (id, name, type) VALUES ('e101d2b8-6a0f-4af6-a5de-a9576b4ebc50', 'REQUISITION_VIEW', 'SUPERVISION');
 INSERT INTO referencedata.rights (id, name, type) VALUES ('7958129d-c4c0-4294-a40c-c2b07cb8e515', 'REQUISITION_CONVERT_TO_ORDER', 'ORDER_FULFILLMENT');
 INSERT INTO referencedata.rights (id, name, type) VALUES ('65626c3d-513f-4255-93fd-808709860594', 'FULFILLMENT_TRANSFER_ORDER', 'ORDER_FULFILLMENT');
+INSERT INTO referencedata.rights (id, name, type) VALUES ('24df2715-850c-4336-b650-90eb78c544bf', 'PODS_MANAGE', 'ORDER_FULFILLMENT');
 INSERT INTO referencedata.geographic_levels (SELECT * FROM json_populate_recordset(NULL::referencedata.geographic_levels, '[{"id":"6b78e6c6-292e-4733-bb9c-3d802ad61206","code":"Country","levelnumber":1},{"id":"9b497d87-cdd9-400e-bb04-fae0bf6a9491","code":"Region","levelnumber":2},{"id":"93c05138-4550-4461-9e8a-79d5f050c223","code":"District","levelnumber":3},{"id":"90e35999-a64f-4312-ba8f-bc13a1311c75","code":"City","levelnumber":4}]'));
 INSERT INTO referencedata.geographic_zones (SELECT * FROM json_populate_recordset(NULL::referencedata.geographic_zones, '[{"id":"4e471242-da63-436c-8157-ade3e615c848","code":"Mal","name":"Malawi","levelid":"6b78e6c6-292e-4733-bb9c-3d802ad61206"},{"id":"0bbd69c1-e20f-48f5-aae4-26dcd8aa7602","code":"Mal-So","name":"Southern Region","levelid":"9b497d87-cdd9-400e-bb04-fae0bf6a9491"},{"id":"50293982-602a-4046-ac29-d7f83a8a13e9","code":"M-So-Bal","name":"Balaka District","levelid":"93c05138-4550-4461-9e8a-79d5f050c223"},{"id":"bf2b810b-cdbf-48b2-b569-149b3cf42387","code":"M-So-Bal-Bal","name":"Balaka","levelid":"90e35999-a64f-4312-ba8f-bc13a1311c75","latitude":-14.99,"longitude":34.92}]'));
 INSERT INTO referencedata.facility_operators (SELECT * FROM json_populate_recordset(NULL::referencedata.facility_operators, '[{"id":"9456c3e9-c4a6-4a28-9e08-47ceb16a4121","code":"moh","name":"Ministry of Health","displayorder":1},{"id":"1074353d-7364-4618-a127-708d7303a231","code":"dwb","name":"Doctors without Borders","displayorder":2}]'));

INSERT INTO referencedata.users (id, username, firstName, lastName, email, timezone) VALUES ('35316636-6264-6331-2d34-3933322d3462', 'admin', 'Admin', 'User', 'example@mail.com', 'UTC');
INSERT INTO referencedata.rights (id, name, type) VALUES ('e96017ff-af8c-4313-a070-caa70465c949', 'FACILITIES_MANAGE', 'GENERAL_ADMIN');
INSERT INTO referencedata.rights (id, name, type) VALUES ('4e731cf7-854f-4af7-9ea4-bd5d8ed7bb22', 'GEOGRAPHIC_ZONE_MANAGE', 'GENERAL_ADMIN');
INSERT INTO referencedata.rights (id, name, type) VALUES ('5c4b3b9b-713e-4b9a-8c58-7efcd2954512', 'SUPERVISORY_NODE_MANAGE', 'GENERAL_ADMIN');
INSERT INTO referencedata.rights (id, name, type) VALUES ('fb6a0053-6254-4b41-8028-bf91421f90dd', 'PRODUCT_MANAGE', 'GENERAL_ADMIN');
INSERT INTO referencedata.rights (id, name, type) VALUES ('8816edba-b8a9-11e6-80f5-76304dec7eb7', 'REQUISITION_TEMPLATES_MANAGE', 'GENERAL_ADMIN');
INSERT INTO referencedata.rights (id, name, type) VALUES ('4bed4f40-36b5-42a7-94c9-0fd3d4252374', 'STOCK_CARD_TEMPLATES_MANAGE', 'GENERAL_ADMIN');
INSERT INTO referencedata.rights (id, name, type) VALUES ('9ade922b-3523-4582-bef4-a47701f7df14', 'REQUISITION_CREATE', 'SUPERVISION');
INSERT INTO referencedata.rights (id, name, type) VALUES ('bffa2de2-dc2a-47dd-b126-6501748ac3fc', 'REQUISITION_APPROVE', 'SUPERVISION');
INSERT INTO referencedata.rights (id, name, type) VALUES ('feb4c0b8-f6d2-4289-b29d-811c1d0b2863', 'REQUISITION_AUTHORIZE', 'SUPERVISION');

INSERT INTO referencedata.requisition_group_program_schedules (SELECT * FROM json_populate_recordset(NULL::referencedata.requisition_group_program_schedules, '[{"id":"e7aab4ca-4586-4ef2-8923-dc3940bb3104","programid":"dce17f2e-af3e-40ad-8e00-3496adef44c3","processingscheduleid":"9c15bd6e-3f6b-4b91-b53a-36c199d35eac","directdelivery":"true","dropofffacilityid":"e6799d64-d10d-4011-b8c2-0e4d4a3f65ce","requisitiongroupid":"1642bfd8-94e1-4fcf-80e7-254b29ca8e05"},{"id":"56b50f88-13e2-4dd1-8210-fead7025b106","programid":"10845cb9-d365-4aaa-badd-b4fa39c6a26a","processingscheduleid":"057921bd-1841-4748-8523-dbe5ebb58368","directdelivery":"false","dropofffacilityid":"e6799d64-d10d-4011-b8c2-0e4d4a3f65ce","requisitiongroupid":"84b33e28-f537-4a76-8895-9d4d564a623a"},{"id":"298da8ae-bff9-4f1c-99f5-49e02b2b3b91","programid":"66032ea8-b69b-4102-a1eb-844e57143187","processingscheduleid":"083775ab-b9af-41a3-b845-0fbf4fe1583d","directdelivery":"false","dropofffacilityid":"19121381-9f3d-4e77-b9e5-d3f59fc1639e","requisitiongroupid":"e90da490-a371-4c2f-83c3-7c1dc9748d48"}]'));
INSERT INTO referencedata.supported_programs (SELECT * FROM json_populate_recordset(NULL::referencedata.supported_programs, '[{"id":"29172001-809d-45bd-bbae-3a53b544709a","active":true,"facilityid":"e6799d64-d10d-4011-b8c2-0e4d4a3f65ce","programid":"dce17f2e-af3e-40ad-8e00-3496adef44c3"},{"id":"a3da399c-547e-4dbe-9b94-8361f626b334","active":true,"facilityid":"e6799d64-d10d-4011-b8c2-0e4d4a3f65ce","programid":"10845cb9-d365-4aaa-badd-b4fa39c6a26a"},{"id":"56615552-9f08-4b2c-8553-562774fd4c94","active":true,"facilityid":"13037147-1769-4735-90a7-b9b310d128b8","programid":"dce17f2e-af3e-40ad-8e00-3496adef44c3"},{"id":"0f19e23e-207b-41f2-8519-200585197bb9","active":true,"facilityid":"13037147-1769-4735-90a7-b9b310d128b8","programid":"10845cb9-d365-4aaa-badd-b4fa39c6a26a"},{"id":"ceced192-fb51-41ee-94e3-b9369d849d28","active":true,"facilityid":"19121381-9f3d-4e77-b9e5-d3f59fc1639e","programid":"66032ea8-b69b-4102-a1eb-844e57143187"}]'));
INSERT INTO referencedata.requisition_group_members (SELECT * FROM json_populate_recordset(NULL::referencedata.requisition_group_members, '[{"requisitiongroupid":"1642bfd8-94e1-4fcf-80e7-254b29ca8e05","facilityid":"e6799d64-d10d-4011-b8c2-0e4d4a3f65ce"},{"requisitiongroupid":"1642bfd8-94e1-4fcf-80e7-254b29ca8e05","facilityid":"13037147-1769-4735-90a7-b9b310d128b8"},{"requisitiongroupid":"1642bfd8-94e1-4fcf-80e7-254b29ca8e05","facilityid":"ab95f1cf-ae8d-4888-ba9d-05141d3f50de"},{"requisitiongroupid":"1642bfd8-94e1-4fcf-80e7-254b29ca8e05","facilityid":"44a29ccb-ed55-4c26-9eca-7e5759269b25"},{"requisitiongroupid":"1642bfd8-94e1-4fcf-80e7-254b29ca8e05","facilityid":"19121381-9f3d-4e77-b9e5-d3f59fc1639e"},{"requisitiongroupid":"84b33e28-f537-4a76-8895-9d4d564a623a","facilityid":"e6799d64-d10d-4011-b8c2-0e4d4a3f65ce"},{"requisitiongroupid":"84b33e28-f537-4a76-8895-9d4d564a623a","facilityid":"13037147-1769-4735-90a7-b9b310d128b8"},{"requisitiongroupid":"84b33e28-f537-4a76-8895-9d4d564a623a","facilityid":"ab95f1cf-ae8d-4888-ba9d-05141d3f50de"},{"requisitiongroupid":"84b33e28-f537-4a76-8895-9d4d564a623a","facilityid":"44a29ccb-ed55-4c26-9eca-7e5759269b25"},{"requisitiongroupid":"84b33e28-f537-4a76-8895-9d4d564a623a","facilityid":"19121381-9f3d-4e77-b9e5-d3f59fc1639e"},{"requisitiongroupid":"e90da490-a371-4c2f-83c3-7c1dc9748d48","facilityid":"e6799d64-d10d-4011-b8c2-0e4d4a3f65ce"},{"requisitiongroupid":"e90da490-a371-4c2f-83c3-7c1dc9748d48","facilityid":"13037147-1769-4735-90a7-b9b310d128b8"},{"requisitiongroupid":"e90da490-a371-4c2f-83c3-7c1dc9748d48","facilityid":"ab95f1cf-ae8d-4888-ba9d-05141d3f50de"},{"requisitiongroupid":"e90da490-a371-4c2f-83c3-7c1dc9748d48","facilityid":"44a29ccb-ed55-4c26-9eca-7e5759269b25"},{"requisitiongroupid":"e90da490-a371-4c2f-83c3-7c1dc9748d48","facilityid":"19121381-9f3d-4e77-b9e5-d3f59fc1639e"}]'));
INSERT INTO referencedata.role_rights (SELECT * FROM json_populate_recordset(NULL::referencedata.role_rights, '[{"roleid":"d30a2fbb-51d9-49ad-90fe-fb405470a439","rightid":"9ade922b-3523-4582-bef4-a47701f7df14"},{"roleid":"d30a2fbb-51d9-49ad-90fe-fb405470a439","rightid":"42791f7a-84a1-470b-bc3c-4160bc99f13c"},{"roleid":"d30a2fbb-51d9-49ad-90fe-fb405470a439","rightid":"bffa2de2-dc2a-47dd-b126-6501748ac3fc"},{"roleid":"d30a2fbb-51d9-49ad-90fe-fb405470a439","rightid":"feb4c0b8-f6d2-4289-b29d-811c1d0b2863"},{"roleid":"d30a2fbb-51d9-49ad-90fe-fb405470a439","rightid":"c3eb5df0-c3ac-4e70-a978-02827462f60e"},{"roleid":"d30a2fbb-51d9-49ad-90fe-fb405470a439","rightid":"e101d2b8-6a0f-4af6-a5de-a9576b4ebc50"},{"roleid":"185db8f7-ee35-44d0-8b40-6de12489ae77","rightid":"7958129d-c4c0-4294-a40c-c2b07cb8e515"},{"roleid":"185db8f7-ee35-44d0-8b40-6de12489ae77","rightid":"65626c3d-513f-4255-93fd-808709860594"},{"roleid":"a439c5de-b8aa-11e6-80f5-76304dec7eb7","rightid":"e96017ff-af8c-4313-a070-caa70465c949"},{"roleid":"a439c5de-b8aa-11e6-80f5-76304dec7eb7","rightid":"42791f7a-84a1-470b-bc3c-4160bc99f13c"},{"roleid":"a439c5de-b8aa-11e6-80f5-76304dec7eb7","rightid":"ebad51c3-f7c3-4fab-97e1-839973b045d4"},{"roleid":"a439c5de-b8aa-11e6-80f5-76304dec7eb7","rightid":"8816edba-b8a9-11e6-80f5-76304dec7eb7"},{"roleid":"a439c5de-b8aa-11e6-80f5-76304dec7eb7","rightid":"4bed4f40-36b5-42a7-94c9-0fd3d4252374"},{"roleid":"2a2eaeba-bb9a-11e6-a4a6-cec0c932ce01","rightid":"e101d2b8-6a0f-4af6-a5de-a9576b4ebc50"},{"roleid":"e16d802b-8eb1-43f7-adf8-ef123227cb88","rightid":"e101d2b8-6a0f-4af6-a5de-a9576b4ebc50"}]'));
INSERT INTO referencedata.facility_type_approved_products (SELECT * FROM json_populate_recordset(NULL::referencedata.facility_type_approved_products, '[{"id":"c5d4427b-7427-4209-ae35-1d5bd92ef3b8","facilitytypeid":"ac1d268b-ce10-455f-bf87-9c667da8f060","programproductid":"9e25fd93-d8a0-4d1d-8188-55dd3c408d24","maxmonthsofstock":"5.5","minmonthsofstock":"3.3","emergencyorderpoint":"6"},{"id":"f691c323-e152-459a-ba64-15c23e34dedd","facilitytypeid":"663b1d34-cc17-4d60-9619-e553e45aa441","programproductid":"9e25fd93-d8a0-4d1d-8188-55dd3c408d24","maxmonthsofstock":"12","minmonthsofstock":"8.5","emergencyorderpoint":"15"},{"id":"43f407db-29b8-4525-baaa-e1cd6844093f","facilitytypeid":"663b1d34-cc17-4d60-9619-e553e45aa441","programproductid":"267321d1-447c-4fac-9430-907ae38d1854","maxmonthsofstock":"18","minmonthsofstock":"12","emergencyorderpoint":"24"},{"id":"1125d62f-f9f3-40b8-8327-5204b64315ed","facilitytypeid":"ac1d268b-ce10-455f-bf87-9c667da8f060","programproductid":"1af3b535-fe6a-41ce-b4c6-7d0aa4381cdb","maxmonthsofstock":"18","minmonthsofstock":"12","emergencyorderpoint":"24"},{"id":"b2ebdcbc-662c-4467-846a-af5f0068d1ca","facilitytypeid":"ac1d268b-ce10-455f-bf87-9c667da8f060","programproductid":"10d447ea-0a86-4267-8048-0b331d509601","maxmonthsofstock":"1000","minmonthsofstock":"100","emergencyorderpoint":"75"},{"id":"7e407f1c-5681-4b80-8600-f97beec69a29","facilitytypeid":"ac1d268b-ce10-455f-bf87-9c667da8f060","programproductid":"2e9cf7eb-ae09-431b-a3da-aa51a7f4aca0","maxmonthsofstock":"1000","minmonthsofstock":"100","emergencyorderpoint":"75"},{"id":"7be8822f-b87c-40b8-a2b3-4d0620e3cfe8","facilitytypeid":"ac1d268b-ce10-455f-bf87-9c667da8f060","programproductid":"366fdbed-c1ba-4bd0-b387-b1c75df9da48","maxmonthsofstock":"500","minmonthsofstock":"50","emergencyorderpoint":"25"},{"id":"a7ef2398-052a-4e31-9a53-a5fbe702e39d","facilitytypeid":"ac1d268b-ce10-455f-bf87-9c667da8f060","programproductid":"e119197f-2326-47b1-9a7f-00f020d9e2b9","maxmonthsofstock":"500","minmonthsofstock":"50","emergencyorderpoint":"25"},{"id":"34d820a9-37b9-44aa-90df-c736f8481f77","facilitytypeid":"ac1d268b-ce10-455f-bf87-9c667da8f060","programproductid":"ceaa00b6-e2bb-4908-ab82-4e2265c39404","maxmonthsofstock":"500","minmonthsofstock":"50","emergencyorderpoint":"25"},{"id":"3c3ef7ad-2447-4643-b1bd-de9c0c159da6","facilitytypeid":"ac1d268b-ce10-455f-bf87-9c667da8f060","programproductid":"79159377-dc1c-4eaa-b4e9-8dad221a1a97","maxmonthsofstock":"500","minmonthsofstock":"50","emergencyorderpoint":"25"},{"id":"ab0d91d4-0251-483e-ac98-ed7d1369dd27","facilitytypeid":"ac1d268b-ce10-455f-bf87-9c667da8f060","programproductid":"99b2a62a-f96d-45ad-ba91-7dcc6cda7ce3","maxmonthsofstock":"500","minmonthsofstock":"50","emergencyorderpoint":"25"}]'));