-- PrintFlo backup 2026-04-15 19:06:57
-- Import with: import.php (upload this file)

-- printers
INSERT OR REPLACE INTO "printers" ("id","name","a4_ss_colour","a4_ds_colour","a3_ss_colour","a3_ds_colour","a4_ss_black","a4_ds_black","a3_ss_black","a3_ds_black","created_at") VALUES ('printer-c4080','Colour printer C4080',0.7,1.25,1.25,2.35,0.34,0.53,0.53,0.91,'2026-01-30 10:52:11');
INSERT OR REPLACE INTO "printers" ("id","name","a4_ss_colour","a4_ds_colour","a3_ss_colour","a3_ds_colour","a4_ss_black","a4_ds_black","a3_ss_black","a3_ds_black","created_at") VALUES ('printer-b2100','Black printer B2100',NULL,NULL,NULL,NULL,0.27,0.39,0.39,0.63,'2026-01-30 10:52:11');

-- jobs
INSERT OR REPLACE INTO "jobs" ("id","job_number","date","client_name","job_type","quantity","labor_cost","overhead_cost","job_value","notes","created_at","updated_at","delivery_date","delivery_type","printing_option","printing_cost","materials_cost","total_cost","profit","profit_margin","is_completed","completed_at","is_in_progress","started_at","company_name","contact_person","contact_phone","contact_email","job_size","a3_cost_multiplier","printer_id") VALUES ('18fc2a39-cbee-47ff-a53c-e38836c0b2b5','JOB-001','2026-01-30','test','test',50,314.6,314.6,2936.2666666667,'','2026-01-30 10:54:55','2026-01-30T11:25:48.227Z',NULL,'Collection',NULL,0,0,0,0,0,'',NULL,1,'2026-01-30T11:25:48.227Z','test',NULL,NULL,NULL,'A4',2.5,NULL);
INSERT OR REPLACE INTO "jobs" ("id","job_number","date","client_name","job_type","quantity","labor_cost","overhead_cost","job_value","notes","created_at","updated_at","delivery_date","delivery_type","printing_option","printing_cost","materials_cost","total_cost","profit","profit_margin","is_completed","completed_at","is_in_progress","started_at","company_name","contact_person","contact_phone","contact_email","job_size","a3_cost_multiplier","printer_id") VALUES ('b1fe27f4-5603-41cd-8ce6-593e66ed0537','JOB-002','2026-01-30','Rest','Tesr',80,555.84,555.84,5187.84,'','2026-01-30 11:23:35','2026-01-30T11:23:34.832Z',NULL,'Collection',NULL,0,0,0,0,0,0,NULL,0,NULL,'Rest',NULL,NULL,NULL,'A3',2.5,'printer-c4080');
INSERT OR REPLACE INTO "jobs" ("id","job_number","date","client_name","job_type","quantity","labor_cost","overhead_cost","job_value","notes","created_at","updated_at","delivery_date","delivery_type","printing_option","printing_cost","materials_cost","total_cost","profit","profit_margin","is_completed","completed_at","is_in_progress","started_at","company_name","contact_person","contact_phone","contact_email","job_size","a3_cost_multiplier","printer_id") VALUES ('3fdab930-cb6f-4e96-94ca-ba8ebdc2ec8c','JOB-003','2026-01-30','test','test',60,476.64,476.64,4448.64,'','2026-01-30 11:27:19','2026-01-30T11:27:18.984Z',NULL,'Collection',NULL,0,0,0,0,0,0,NULL,0,NULL,'test',NULL,NULL,NULL,'A4',2.5,'printer-b2100');
INSERT OR REPLACE INTO "jobs" ("id","job_number","date","client_name","job_type","quantity","labor_cost","overhead_cost","job_value","notes","created_at","updated_at","delivery_date","delivery_type","printing_option","printing_cost","materials_cost","total_cost","profit","profit_margin","is_completed","completed_at","is_in_progress","started_at","company_name","contact_person","contact_phone","contact_email","job_size","a3_cost_multiplier","printer_id") VALUES ('209a1f4f-d495-4c43-b8c0-f96295566f80','JOB-004','2026-01-30','ehi','training manual',120,884.16,884.16,8252.16,'','2026-01-30 12:00:47','2026-01-30T12:03:13.225Z','2026-01-30','Delivery',NULL,0,0,0,0,0,1,'2026-01-30T12:03:13.225Z','',NULL,'ehi',NULL,NULL,NULL,'A4',2.5,'printer-b2100');
INSERT OR REPLACE INTO "jobs" ("id","job_number","date","client_name","job_type","quantity","labor_cost","overhead_cost","job_value","notes","created_at","updated_at","delivery_date","delivery_type","printing_option","printing_cost","materials_cost","total_cost","profit","profit_margin","is_completed","completed_at","is_in_progress","started_at","company_name","contact_person","contact_phone","contact_email","job_size","a3_cost_multiplier","printer_id") VALUES ('10e1e63b-aeb2-48fc-b464-cdd223e54423','JOB-005','2026-01-30','SANBS','training manual',250,13966.5,13966.5,130354,'','2026-01-30 12:13:19','2026-01-30T12:14:36.957Z','2026-01-30','Delivery',NULL,0,0,0,0,0,1,'2026-01-30T12:14:36.957Z','',NULL,'SANBS',NULL,NULL,NULL,'A4',2.5,'printer-c4080');
INSERT OR REPLACE INTO "jobs" ("id","job_number","date","client_name","job_type","quantity","labor_cost","overhead_cost","job_value","notes","created_at","updated_at","delivery_date","delivery_type","printing_option","printing_cost","materials_cost","total_cost","profit","profit_margin","is_completed","completed_at","is_in_progress","started_at","company_name","contact_person","contact_phone","contact_email","job_size","a3_cost_multiplier","printer_id") VALUES ('92fcc6fa-b4e2-426c-9f12-182bd3795990','JOB-006','2026-01-30','Mathew Goniwe','training manual',500,15348,15348,143248,'','2026-01-30 12:28:45','2026-01-30T12:31:14.011Z','2026-01-30','Collection',NULL,0,0,0,0,0,1,'2026-01-30T12:31:14.011Z','',NULL,'Mathew Goniwe',NULL,NULL,NULL,'A3',2.5,'printer-c4080');
INSERT OR REPLACE INTO "jobs" ("id","job_number","date","client_name","job_type","quantity","labor_cost","overhead_cost","job_value","notes","created_at","updated_at","delivery_date","delivery_type","printing_option","printing_cost","materials_cost","total_cost","profit","profit_margin","is_completed","completed_at","is_in_progress","started_at","company_name","contact_person","contact_phone","contact_email","job_size","a3_cost_multiplier","printer_id") VALUES ('b0090ea1-f668-460a-bcd0-d400da67d903','JOB-007','2026-01-30','BTBT','BTBT-PDE4 Studay Guide file 1 of 1',3,217.596,217.596,2030.896,'','2026-01-30 12:41:31','2026-01-30T12:41:30.460Z','2026-01-30','Delivery',NULL,0,0,0,0,0,0,NULL,0,NULL,'BTBT',NULL,NULL,NULL,'A4',2.5,'printer-b2100');
INSERT OR REPLACE INTO "jobs" ("id","job_number","date","client_name","job_type","quantity","labor_cost","overhead_cost","job_value","notes","created_at","updated_at","delivery_date","delivery_type","printing_option","printing_cost","materials_cost","total_cost","profit","profit_margin","is_completed","completed_at","is_in_progress","started_at","company_name","contact_person","contact_phone","contact_email","job_size","a3_cost_multiplier","printer_id") VALUES ('5d3f3862-8939-4459-8fad-0e07f6bc52c3','JOB-008','2026-01-30','BTBT','BTBT-PDE4 Studay Guide file 1 of 1',3,216.396,216.396,2019.696,'','2026-01-30 12:54:41','2026-01-30T12:54:40.010Z','2026-01-30','Collection',NULL,0,0,0,0,0,0,NULL,0,NULL,'BTBT',NULL,NULL,NULL,'A4',2.5,NULL);
INSERT OR REPLACE INTO "jobs" ("id","job_number","date","client_name","job_type","quantity","labor_cost","overhead_cost","job_value","notes","created_at","updated_at","delivery_date","delivery_type","printing_option","printing_cost","materials_cost","total_cost","profit","profit_margin","is_completed","completed_at","is_in_progress","started_at","company_name","contact_person","contact_phone","contact_email","job_size","a3_cost_multiplier","printer_id") VALUES ('1f2c4e2f-ca94-40ba-a8e7-9d2c5617e2fc','JOB-009','2026-01-30','BTBT','BTBT-PDE4 Studay Guide file 1 of 1',3,108.768,108.768,1015.168,'','2026-01-30 13:23:12','2026-01-30T13:23:11.544Z','2026-01-30','Delivery',NULL,0,0,0,0,0,0,NULL,0,NULL,'BTBT',NULL,NULL,NULL,'A4',2.5,'printer-b2100');
INSERT OR REPLACE INTO "jobs" ("id","job_number","date","client_name","job_type","quantity","labor_cost","overhead_cost","job_value","notes","created_at","updated_at","delivery_date","delivery_type","printing_option","printing_cost","materials_cost","total_cost","profit","profit_margin","is_completed","completed_at","is_in_progress","started_at","company_name","contact_person","contact_phone","contact_email","job_size","a3_cost_multiplier","printer_id") VALUES ('8ddde70c-7bd0-4231-a89a-8252fac114ac','JOB-010','2026-01-30','IHS','Learner Guide',10,0,0,730.9,'Granwest Module 4 Generating Revenue L/G','2026-01-30 13:47:53','2026-01-30T13:47:52.070Z','2026-01-30','Delivery',NULL,0,0,0,0,0,0,NULL,0,NULL,'IHS',NULL,NULL,NULL,'A4',2.5,'printer-b2100');

-- job_materials
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('126328dd-1289-42fc-8d18-541094f1a085','18fc2a39-cbee-47ff-a53c-e38836c0b2b5','Pages','Black S/S',2500,0.32,800,'2026-01-30 10:54:55');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('660eb7d1-7cf6-4562-8148-15605dad186d','18fc2a39-cbee-47ff-a53c-e38836c0b2b5','Pages','Black D/S',1000,0.42,420,'2026-01-30 10:54:55');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('1927e29f-a3ca-44cd-be48-eda114ca2509','18fc2a39-cbee-47ff-a53c-e38836c0b2b5','Pages','Colour S/S',150,0.52,78,'2026-01-30 10:54:55');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('d8a0b6a9-d3c8-402e-ab62-1a7b9fb98286','18fc2a39-cbee-47ff-a53c-e38836c0b2b5','Pages','Colour D/S',250,0.82,205,'2026-01-30 10:54:55');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('2ba3ccf4-46d6-4f92-b1e9-b7f125905fbd','18fc2a39-cbee-47ff-a53c-e38836c0b2b5','Dividers','Standard',300,0,0,'2026-01-30 10:54:55');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('70621b54-207f-4482-a9d8-f0044fa3a76f','18fc2a39-cbee-47ff-a53c-e38836c0b2b5','Transparencies','Front',50,1.1,55,'2026-01-30 10:54:55');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('fd68967e-ae79-4d5c-a7eb-4c4ebe94f08f','18fc2a39-cbee-47ff-a53c-e38836c0b2b5','Boards','170gsm Matt A4',50,0.3,15,'2026-01-30 10:54:55');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('25564580-307f-46c8-9375-d68c5aeeb564','b1fe27f4-5603-41cd-8ce6-593e66ed0537','Pages','Black S/S',4000,0.53,1280,'2026-01-30 11:23:35');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('b52edd97-7a81-4410-a088-2e635d9459a9','b1fe27f4-5603-41cd-8ce6-593e66ed0537','Pages','Black D/S',1600,0.91,672,'2026-01-30 11:23:35');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('009cc8aa-6a18-4814-92c5-c08617c1dc60','b1fe27f4-5603-41cd-8ce6-593e66ed0537','Pages','Colour S/S',240,1.25,124.8,'2026-01-30 11:23:35');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('696949d9-016a-4daa-a156-94eea8d90d00','b1fe27f4-5603-41cd-8ce6-593e66ed0537','Pages','Colour D/S',400,2.35,328,'2026-01-30 11:23:36');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('5c3c3bbd-8690-4dc8-a6c4-1b4e5465f29a','b1fe27f4-5603-41cd-8ce6-593e66ed0537','Dividers','Standard',480,0,0,'2026-01-30 11:23:36');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('a762dc90-96a7-49df-a7db-1f143194c65c','b1fe27f4-5603-41cd-8ce6-593e66ed0537','Spiral','12mm wire binder 2:1 Pitch white',80,3.28,262.4,'2026-01-30 11:23:36');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('2f164f1f-5b2c-4c17-a01f-e85845bb3d0f','b1fe27f4-5603-41cd-8ce6-593e66ed0537','Transparencies','Front',80,1.1,88,'2026-01-30 11:23:36');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('6ee4b679-1e12-4225-a7c1-2bb71bbdd112','b1fe27f4-5603-41cd-8ce6-593e66ed0537','Boards','170gsm Matt A4',80,0.3,24,'2026-01-30 11:23:36');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('af53860f-1f70-415d-af92-2adf3ecb298f','3fdab930-cb6f-4e96-94ca-ba8ebdc2ec8c','Pages','Black S/S',3600,0.27,1152,'2026-01-30 11:27:20');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('77939834-419c-4250-a373-025fb3a05335','3fdab930-cb6f-4e96-94ca-ba8ebdc2ec8c','Pages','Black D/S',1200,0.39,504,'2026-01-30 11:27:20');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('06e85205-cc4d-4958-b0fb-a9b263b13071','3fdab930-cb6f-4e96-94ca-ba8ebdc2ec8c','Pages','Colour S/S',420,0.52,218.4,'2026-01-30 11:27:20');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('b165c1f7-b2a6-4678-bd5b-54dbe0d7f2b2','3fdab930-cb6f-4e96-94ca-ba8ebdc2ec8c','Pages','Colour D/S',540,0.82,442.8,'2026-01-30 11:27:20');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('ea0a4549-f1f6-4624-ba0e-e6bf9ac88d80','3fdab930-cb6f-4e96-94ca-ba8ebdc2ec8c','Dividers','Standard',60,0,0,'2026-01-30 11:27:20');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('0735b9d9-3b0a-4521-a1df-53e705ebe4a0','3fdab930-cb6f-4e96-94ca-ba8ebdc2ec8c','Transparencies','Front',60,1.1,66,'2026-01-30 11:27:20');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('cf00c406-2d23-4de5-9b6e-43275a235203','209a1f4f-d495-4c43-b8c0-f96295566f80','Pages','Black S/S',6000,0.27,1920,'2026-01-30 12:00:47');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('0281710a-3f82-4f45-92a3-87d76dc32e8f','209a1f4f-d495-4c43-b8c0-f96295566f80','Pages','Black D/S',2400,0.39,1008,'2026-01-30 12:00:47');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('a0d3fc3c-dc1b-4d18-a8ab-1481af0cdf6a','209a1f4f-d495-4c43-b8c0-f96295566f80','Pages','Colour S/S',360,0.52,187.2,'2026-01-30 12:00:47');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('657b039f-7942-48df-9c80-cc5a2cebba05','209a1f4f-d495-4c43-b8c0-f96295566f80','Pages','Colour D/S',600,0.82,492,'2026-01-30 12:00:48');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('a77431a0-0e0a-45d3-807f-00350ac0cbf9','209a1f4f-d495-4c43-b8c0-f96295566f80','Dividers','Standard',720,0.4,288,'2026-01-30 12:00:48');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('d217af59-8641-422e-afd2-1871e7720ef3','209a1f4f-d495-4c43-b8c0-f96295566f80','Spiral','11mm wire binder 2:1 Pitch white',120,2.84,340.8,'2026-01-30 12:00:48');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('788279e8-edd5-4a49-b37d-88b20d7a881e','209a1f4f-d495-4c43-b8c0-f96295566f80','Transparencies','Front',120,1.1,132,'2026-01-30 12:00:48');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('b3d886e8-0ca5-4f81-a427-2352eca1f51d','209a1f4f-d495-4c43-b8c0-f96295566f80','Boards','200gsm Gloss A4',120,0.44,52.8,'2026-01-30 12:00:48');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('989890dc-8f29-482d-b516-248eec1c28e4','10e1e63b-aeb2-48fc-b464-cdd223e54423','Pages','Black S/S',50000,0.34,16000,'2026-01-30 12:13:20');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('0e1818d6-3ed6-41fc-afb8-baaed9e5c27f','10e1e63b-aeb2-48fc-b464-cdd223e54423','Pages','Black D/S',17500,0.53,7350,'2026-01-30 12:13:20');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('aff1a2ba-e362-4107-93b8-704261ebb910','10e1e63b-aeb2-48fc-b464-cdd223e54423','Pages','Colour S/S',5000,0.7,2600,'2026-01-30 12:13:20');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('d3d359a0-123e-4016-a851-3ea7fcc6322b','10e1e63b-aeb2-48fc-b464-cdd223e54423','Pages','Colour D/S',50000,1.25,41000,'2026-01-30 12:13:20');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('095624b3-d7e2-48ca-8c41-0f31e1ec778b','10e1e63b-aeb2-48fc-b464-cdd223e54423','Dividers','Standard',1250,0.4,500,'2026-01-30 12:13:20');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('a557be72-e4d3-42b6-955b-7a12b8627485','10e1e63b-aeb2-48fc-b464-cdd223e54423','Spiral','22mm wire binder 2:1 Pitch white',250,7.99,1997.5,'2026-01-30 12:13:20');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('28456dae-dde9-4c12-8b22-d9cebd75d4f4','10e1e63b-aeb2-48fc-b464-cdd223e54423','Transparencies','Front',250,1.1,275,'2026-01-30 12:13:20');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('b922f1ea-a57d-41fb-9c4a-48ac3b4de4ff','10e1e63b-aeb2-48fc-b464-cdd223e54423','Boards','200gsm Gloss A4',250,0.44,110,'2026-01-30 12:13:20');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('acf434ad-3fab-4304-aa5a-c1f28cc62ba5','92fcc6fa-b4e2-426c-9f12-182bd3795990','Pages','Black S/S',100000,0.53,32000,'2026-01-30 12:28:46');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('74474699-d672-4ee3-a9ef-7d0fb6b46760','92fcc6fa-b4e2-426c-9f12-182bd3795990','Pages','Black D/S',35000,0.91,14700,'2026-01-30 12:28:46');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('682d1dc9-2d4c-41c8-8011-474f7e572656','92fcc6fa-b4e2-426c-9f12-182bd3795990','Pages','Colour S/S',10000,1.25,5200,'2026-01-30 12:28:46');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('7e8fd226-f678-4541-9140-a4e6bf44b137','92fcc6fa-b4e2-426c-9f12-182bd3795990','Pages','Colour D/S',25000,2.35,20500,'2026-01-30 12:28:46');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('eae8cddc-bd70-4557-b068-9c907dad9ea0','92fcc6fa-b4e2-426c-9f12-182bd3795990','Dividers','Standard',5000,0.4,2000,'2026-01-30 12:28:46');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('074ffce5-f6ca-4f53-bcf4-0a70305ac7da','92fcc6fa-b4e2-426c-9f12-182bd3795990','Spiral','12mm wire binder 2:1 Pitch white',500,3.28,1640,'2026-01-30 12:28:46');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('1cfb7a77-0092-4ba3-ac47-40c60c5fd75f','92fcc6fa-b4e2-426c-9f12-182bd3795990','Transparencies','Front',500,1.1,550,'2026-01-30 12:28:46');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('9bb621d9-c9f8-4935-a04a-39fbebb46b7b','92fcc6fa-b4e2-426c-9f12-182bd3795990','Boards','170gsm Matt A4',500,0.3,150,'2026-01-30 12:28:46');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('1e965d40-97a7-4932-8f75-b7b1e9a32d0a','b0090ea1-f668-460a-bcd0-d400da67d903','Pages','Black D/S',2574,0.39,1081.08,'2026-01-30 12:41:32');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('c97c045c-7fc6-480e-a41b-d51eb2b2166e','b0090ea1-f668-460a-bcd0-d400da67d903','Dividers','Standard',15,0.4,6,'2026-01-30 12:41:32');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('c512aae9-9f0a-4001-bbb7-7b375e67cc73','b0090ea1-f668-460a-bcd0-d400da67d903','Boards','170gsm Matt A4',3,0.3,0.9,'2026-01-30 12:41:32');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('986c3f92-6136-48c2-8b95-0887ef40b954','5d3f3862-8939-4459-8fad-0e07f6bc52c3','Pages','Black D/S',2574,0.39,1081.08,'2026-01-30 12:54:42');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('fc4070ed-0a1b-4019-9a6b-30255432fecb','5d3f3862-8939-4459-8fad-0e07f6bc52c3','Boards','170gsm Matt A4',3,0.3,0.9,'2026-01-30 12:54:42');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('cf988681-01d0-442e-ad5b-624e1da43354','1f2c4e2f-ca94-40ba-a8e7-9d2c5617e2fc','Pages','Black D/S',1287,0.39,540.54,'2026-01-30 13:23:13');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('4c29b6b1-d8be-471e-b8bd-eaf96576ea8d','1f2c4e2f-ca94-40ba-a8e7-9d2c5617e2fc','Transparencies','Front',3,1.1,3.3,'2026-01-30 13:23:13');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('5de2ef4e-b0d7-49a5-8ee1-120cdd9699a6','8ddde70c-7bd0-4231-a89a-8252fac114ac','Pages','Black D/S',410,0.39,172.2,'2026-01-30 13:47:53');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('c9f26bb8-f1d7-4a30-aa79-f8baee63db3e','8ddde70c-7bd0-4231-a89a-8252fac114ac','Spiral','12mm wire binder 2:1 Pitch white',10,3.28,32.8,'2026-01-30 13:47:53');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('f60dc71b-9b6e-4980-8bee-b67cd1b70813','8ddde70c-7bd0-4231-a89a-8252fac114ac','Transparencies','Front',10,1.1,11,'2026-01-30 13:47:53');
INSERT OR REPLACE INTO "job_materials" ("id","job_id","material_type","specification","quantity","unit_cost","total_cost","created_at") VALUES ('fb91acd1-d266-4a85-ae2c-51564ff650a3','8ddde70c-7bd0-4231-a89a-8252fac114ac','Boards','170gsm Matt A4',10,0.3,3,'2026-01-30 13:47:53');

-- inventory_items
INSERT OR REPLACE INTO "inventory_items" ("id","item_name","item_type","unit","quantity","min_quantity","unit_cost","notes","created_at","updated_at") VALUES ('19c25d91-aec3-441b-95c1-288dd6695fb0','11mm wire binder 2:1 Pitch white','binding','per wire',450,20,2.84,'11mm wire binder','2026-01-30 10:52:11','2026-01-30 12:00:48');
INSERT OR REPLACE INTO "inventory_items" ("id","item_name","item_type","unit","quantity","min_quantity","unit_cost","notes","created_at","updated_at") VALUES ('75a111fb-ba8e-4dc9-baa8-40626d50205e','12mm wire binder 2:1 Pitch white','binding','per wire',440,20,3.28,'12mm wire binder','2026-01-30 10:52:11','2026-01-30 13:47:53');
INSERT OR REPLACE INTO "inventory_items" ("id","item_name","item_type","unit","quantity","min_quantity","unit_cost","notes","created_at","updated_at") VALUES ('6f053e95-1483-493b-a5c3-7a1fdd4d46d7','14mm wire binder 2:1 Pitch white','binding','per wire',500,20,4.29,'14mm wire binder','2026-01-30 10:52:11','2026-01-30 10:52:11');
INSERT OR REPLACE INTO "inventory_items" ("id","item_name","item_type","unit","quantity","min_quantity","unit_cost","notes","created_at","updated_at") VALUES ('a8f47f40-f75f-45bb-bbb9-27d76e0c4ff8','16mm wire binder 2:1 Pitch white','binding','per wire',400,20,4.72,'16mm wire binder','2026-01-30 10:52:11','2026-01-30 10:52:11');
INSERT OR REPLACE INTO "inventory_items" ("id","item_name","item_type","unit","quantity","min_quantity","unit_cost","notes","created_at","updated_at") VALUES ('59ceaa72-0771-42ba-93b4-cd83cfd380d8','19mm wire binder 2:1 Pitch white','binding','per wire',400,20,5.74,'19mm wire binder','2026-01-30 10:52:11','2026-01-30 10:52:11');
INSERT OR REPLACE INTO "inventory_items" ("id","item_name","item_type","unit","quantity","min_quantity","unit_cost","notes","created_at","updated_at") VALUES ('4488a13c-234a-4d84-9d62-cb8741cc9a11','22mm wire binder 2:1 Pitch white','binding','per wire',200,20,7.99,'22mm wire binder','2026-01-30 10:52:11','2026-01-30 12:13:20');
INSERT OR REPLACE INTO "inventory_items" ("id","item_name","item_type","unit","quantity","min_quantity","unit_cost","notes","created_at","updated_at") VALUES ('3d466f27-7b3e-4bd5-82d9-d5a6b3696186','25mm wire binder 2:1 Pitch white','binding','per wire',220,20,9.54,'25mm wire binder','2026-01-30 10:52:11','2026-01-30 10:52:11');
INSERT OR REPLACE INTO "inventory_items" ("id","item_name","item_type","unit","quantity","min_quantity","unit_cost","notes","created_at","updated_at") VALUES ('2af9f912-25a6-49e6-a8ce-fa1d420e54b7','28mm wire binder 2:1 Pitch white','binding','per wire',280,20,16.27,'28mm wire binder','2026-01-30 10:52:11','2026-01-30 10:52:11');
INSERT OR REPLACE INTO "inventory_items" ("id","item_name","item_type","unit","quantity","min_quantity","unit_cost","notes","created_at","updated_at") VALUES ('7efc8727-fb87-40c1-9ea2-895c2de476f5','170gsm Matt A4','cover','sheets',354,250,0.3,'Cover (Front) - lightweight','2026-01-30 10:52:11','2026-01-30 13:47:53');
INSERT OR REPLACE INTO "inventory_items" ("id","item_name","item_type","unit","quantity","min_quantity","unit_cost","notes","created_at","updated_at") VALUES ('a33c6018-df88-41b1-9c74-f8497f07f503','200gsm Gloss A4','cover','sheets',430,200,0.44,'Cover (Front) - medium weight','2026-01-30 10:52:11','2026-01-30 12:13:20');
INSERT OR REPLACE INTO "inventory_items" ("id","item_name","item_type","unit","quantity","min_quantity","unit_cost","notes","created_at","updated_at") VALUES ('1bf6cacc-c794-4deb-b7ad-3d6d6af278dc','300gsm Matt A4','cover','sheets',1600,150,0.5,'Cover (Front) - heavy weight','2026-01-30 10:52:11','2026-01-30 10:52:11');
INSERT OR REPLACE INTO "inventory_items" ("id","item_name","item_type","unit","quantity","min_quantity","unit_cost","notes","created_at","updated_at") VALUES ('c7908556-9064-4c0a-889b-a5dff15d4de3','A3 Paper','paper','pages',3700,2,0.4,'A3 Paper - Box: 2500 pages @ R1000','2026-01-30 10:52:11','2026-01-30 13:47:53');
INSERT OR REPLACE INTO "inventory_items" ("id","item_name","item_type","unit","quantity","min_quantity","unit_cost","notes","created_at","updated_at") VALUES ('a5a1a416-b9dd-413e-8930-9d27f7309150','A4 Paper','paper','pages',12500,2,0.15,'A4 Paper - Box: 2500 pages @ R325','2026-01-30 10:52:11','2026-01-30 10:52:11');
INSERT OR REPLACE INTO "inventory_items" ("id","item_name","item_type","unit","quantity","min_quantity","unit_cost","notes","created_at","updated_at") VALUES ('8a8d0abc-e3af-4177-94cf-cd623811cf76','A4 Dividers Blue','divider','sheets',1250,50,0.4,'Blue A4 dividers','2026-01-30 10:52:11','2026-01-30 12:41:32');
INSERT OR REPLACE INTO "inventory_items" ("id","item_name","item_type","unit","quantity","min_quantity","unit_cost","notes","created_at","updated_at") VALUES ('79f1a2a2-9380-4e42-be9a-466bd90ec2b1','A4 Dividers Green','divider','sheets',500,50,0.4,'Green A4 dividers','2026-01-30 10:52:11','2026-01-30 10:52:11');
INSERT OR REPLACE INTO "inventory_items" ("id","item_name","item_type","unit","quantity","min_quantity","unit_cost","notes","created_at","updated_at") VALUES ('ea691d83-4e75-43b5-bbd4-8d0e29d409fe','Clear Plastic Covers','transparency','pieces',2807,500,0.05,'Clear front covers','2026-01-30 10:52:11','2026-01-30 13:47:53');
INSERT OR REPLACE INTO "inventory_items" ("id","item_name","item_type","unit","quantity","min_quantity","unit_cost","notes","created_at","updated_at") VALUES ('2ac4dc43-9b5c-4909-9c3e-cc3d389d27a4','Black Plastic Backs','boards','pieces',3750,500,0.04,'Boards (Back)','2026-01-30 10:52:11','2026-01-30 10:52:11');

-- inventory_transactions
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('5057d44d-dc30-4408-a715-5f4bf89e5102','c7908556-9064-4c0a-889b-a5dff15d4de3','usage',-2500,'job','18fc2a39-cbee-47ff-a53c-e38836c0b2b5','Job materials: Black S/S','2026-01-30 10:54:55');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('a9751561-8067-4395-a230-3ef714cc8f9f','c7908556-9064-4c0a-889b-a5dff15d4de3','usage',-1000,'job','18fc2a39-cbee-47ff-a53c-e38836c0b2b5','Job materials: Black D/S','2026-01-30 10:54:55');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('65bbe979-ae19-4e78-8b27-ba26c4f15d42','c7908556-9064-4c0a-889b-a5dff15d4de3','usage',-150,'job','18fc2a39-cbee-47ff-a53c-e38836c0b2b5','Job materials: Colour S/S','2026-01-30 10:54:55');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('77b7ffdc-c8f3-4e89-a6f6-6299101800a0','c7908556-9064-4c0a-889b-a5dff15d4de3','usage',-250,'job','18fc2a39-cbee-47ff-a53c-e38836c0b2b5','Job materials: Colour D/S','2026-01-30 10:54:55');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('53c76d05-dac7-4db6-a6cd-1b102bcafbee','8a8d0abc-e3af-4177-94cf-cd623811cf76','usage',-300,'job','18fc2a39-cbee-47ff-a53c-e38836c0b2b5','Job materials: Standard','2026-01-30 10:54:55');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('93981a4e-973a-45ec-bba8-89baf1747f43','ea691d83-4e75-43b5-bbd4-8d0e29d409fe','usage',-50,'job','18fc2a39-cbee-47ff-a53c-e38836c0b2b5','Job materials: Front','2026-01-30 10:54:55');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('e25b5d80-17a9-4b44-9dc4-a9ab138e9e36','7efc8727-fb87-40c1-9ea2-895c2de476f5','usage',-50,'job','18fc2a39-cbee-47ff-a53c-e38836c0b2b5','Job materials: 170gsm Matt A4','2026-01-30 10:54:55');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('6b14b4ab-1a86-4bb5-87a6-76fcd9449bfe','c7908556-9064-4c0a-889b-a5dff15d4de3','usage',-4000,'job','b1fe27f4-5603-41cd-8ce6-593e66ed0537','Job materials: Black S/S','2026-01-30 11:23:35');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('42a64ad9-639c-4ab3-ba18-7d59b5fe6812','c7908556-9064-4c0a-889b-a5dff15d4de3','usage',-1600,'job','b1fe27f4-5603-41cd-8ce6-593e66ed0537','Job materials: Black D/S','2026-01-30 11:23:35');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('56ae2871-299d-42e8-9ea5-a41ec8144395','c7908556-9064-4c0a-889b-a5dff15d4de3','usage',-240,'job','b1fe27f4-5603-41cd-8ce6-593e66ed0537','Job materials: Colour S/S','2026-01-30 11:23:36');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('95ead8fd-a13f-4658-adc7-10f938704678','c7908556-9064-4c0a-889b-a5dff15d4de3','usage',-400,'job','b1fe27f4-5603-41cd-8ce6-593e66ed0537','Job materials: Colour D/S','2026-01-30 11:23:36');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('e33484e6-df89-42ee-be8b-6ef6cdcb5ac5','8a8d0abc-e3af-4177-94cf-cd623811cf76','usage',-480,'job','b1fe27f4-5603-41cd-8ce6-593e66ed0537','Job materials: Standard','2026-01-30 11:23:36');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('3585bca1-7132-4860-bc4c-768a15de4267','75a111fb-ba8e-4dc9-baa8-40626d50205e','usage',-80,'job','b1fe27f4-5603-41cd-8ce6-593e66ed0537','Job materials: 12mm wire binder 2:1 Pitch white','2026-01-30 11:23:36');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('4ad70015-bc2e-42b9-b978-7bbc42f41c84','ea691d83-4e75-43b5-bbd4-8d0e29d409fe','usage',-80,'job','b1fe27f4-5603-41cd-8ce6-593e66ed0537','Job materials: Front','2026-01-30 11:23:36');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('6d8c3d76-beb3-4566-81ea-08b21c87d064','7efc8727-fb87-40c1-9ea2-895c2de476f5','usage',-80,'job','b1fe27f4-5603-41cd-8ce6-593e66ed0537','Job materials: 170gsm Matt A4','2026-01-30 11:23:36');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('e81697fd-3f68-45e8-8fb7-6619dd050cc9','c7908556-9064-4c0a-889b-a5dff15d4de3','usage',-3600,'job','3fdab930-cb6f-4e96-94ca-ba8ebdc2ec8c','Job materials: Black S/S','2026-01-30 11:27:20');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('0d994c84-529a-40a0-9965-40ff7d356030','c7908556-9064-4c0a-889b-a5dff15d4de3','usage',-1200,'job','3fdab930-cb6f-4e96-94ca-ba8ebdc2ec8c','Job materials: Black D/S','2026-01-30 11:27:20');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('8b8b75b6-ecd7-4722-82c1-63ab8f834502','c7908556-9064-4c0a-889b-a5dff15d4de3','usage',-420,'job','3fdab930-cb6f-4e96-94ca-ba8ebdc2ec8c','Job materials: Colour S/S','2026-01-30 11:27:20');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('b9fe0b1d-f164-478b-bd71-167ca9b52e6d','c7908556-9064-4c0a-889b-a5dff15d4de3','usage',-540,'job','3fdab930-cb6f-4e96-94ca-ba8ebdc2ec8c','Job materials: Colour D/S','2026-01-30 11:27:20');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('96969d9a-044f-4289-a6ad-1aec24ccf39a','8a8d0abc-e3af-4177-94cf-cd623811cf76','usage',-60,'job','3fdab930-cb6f-4e96-94ca-ba8ebdc2ec8c','Job materials: Standard','2026-01-30 11:27:20');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('787cbb79-672e-4001-a053-d3147b155255','ea691d83-4e75-43b5-bbd4-8d0e29d409fe','usage',-60,'job','3fdab930-cb6f-4e96-94ca-ba8ebdc2ec8c','Job materials: Front','2026-01-30 11:27:20');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('5b43c130-7679-4b56-9157-dd10d6520402','c7908556-9064-4c0a-889b-a5dff15d4de3','usage',-6000,'job','209a1f4f-d495-4c43-b8c0-f96295566f80','Job materials: Black S/S','2026-01-30 12:00:47');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('b9a8ad4f-5dcc-4957-a14c-f0c3b4f9663f','c7908556-9064-4c0a-889b-a5dff15d4de3','usage',-2400,'job','209a1f4f-d495-4c43-b8c0-f96295566f80','Job materials: Black D/S','2026-01-30 12:00:47');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('9c4ab5c6-9dac-4456-a7eb-68be286378e4','c7908556-9064-4c0a-889b-a5dff15d4de3','usage',-360,'job','209a1f4f-d495-4c43-b8c0-f96295566f80','Job materials: Colour S/S','2026-01-30 12:00:48');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('e47e0faa-e096-4b88-8914-1373f8e81262','c7908556-9064-4c0a-889b-a5dff15d4de3','usage',-600,'job','209a1f4f-d495-4c43-b8c0-f96295566f80','Job materials: Colour D/S','2026-01-30 12:00:48');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('84267c7b-b717-411a-b391-dcf56b326de3','8a8d0abc-e3af-4177-94cf-cd623811cf76','usage',-720,'job','209a1f4f-d495-4c43-b8c0-f96295566f80','Job materials: Standard','2026-01-30 12:00:48');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('bfffe4d3-b333-489a-bb2f-ab8b3a5a559c','19c25d91-aec3-441b-95c1-288dd6695fb0','usage',-120,'job','209a1f4f-d495-4c43-b8c0-f96295566f80','Job materials: 11mm wire binder 2:1 Pitch white','2026-01-30 12:00:48');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('be5edf88-f2a3-4815-80ec-0b641742f164','ea691d83-4e75-43b5-bbd4-8d0e29d409fe','usage',-120,'job','209a1f4f-d495-4c43-b8c0-f96295566f80','Job materials: Front','2026-01-30 12:00:48');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('f6856bd5-49b2-412a-8aa1-28ef545b2a65','a33c6018-df88-41b1-9c74-f8497f07f503','usage',-120,'job','209a1f4f-d495-4c43-b8c0-f96295566f80','Job materials: 200gsm Gloss A4','2026-01-30 12:00:48');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('bf975283-16e0-4eb3-884d-77e44e6a7c6a','c7908556-9064-4c0a-889b-a5dff15d4de3','usage',-50000,'job','10e1e63b-aeb2-48fc-b464-cdd223e54423','Job materials: Black S/S','2026-01-30 12:13:20');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('12952983-f3b5-4557-8acb-e1166f86b3a5','c7908556-9064-4c0a-889b-a5dff15d4de3','usage',-17500,'job','10e1e63b-aeb2-48fc-b464-cdd223e54423','Job materials: Black D/S','2026-01-30 12:13:20');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('2f13719f-d12d-4816-8609-b156198eb06c','c7908556-9064-4c0a-889b-a5dff15d4de3','usage',-5000,'job','10e1e63b-aeb2-48fc-b464-cdd223e54423','Job materials: Colour S/S','2026-01-30 12:13:20');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('01eca2c8-45b5-4f68-985a-d936155e9edc','c7908556-9064-4c0a-889b-a5dff15d4de3','usage',-50000,'job','10e1e63b-aeb2-48fc-b464-cdd223e54423','Job materials: Colour D/S','2026-01-30 12:13:20');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('31c4768b-509d-4410-b3b8-9f04695a2183','8a8d0abc-e3af-4177-94cf-cd623811cf76','usage',-1250,'job','10e1e63b-aeb2-48fc-b464-cdd223e54423','Job materials: Standard','2026-01-30 12:13:20');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('db8d2301-fa7d-446b-b318-08d5c51e2cfb','4488a13c-234a-4d84-9d62-cb8741cc9a11','usage',-250,'job','10e1e63b-aeb2-48fc-b464-cdd223e54423','Job materials: 22mm wire binder 2:1 Pitch white','2026-01-30 12:13:20');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('721c50e9-c9c3-45fa-ad3b-5458a5b36f56','ea691d83-4e75-43b5-bbd4-8d0e29d409fe','usage',-250,'job','10e1e63b-aeb2-48fc-b464-cdd223e54423','Job materials: Front','2026-01-30 12:13:20');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('93ca61f7-3b2d-49e1-9f1e-b34123800ba5','a33c6018-df88-41b1-9c74-f8497f07f503','usage',-250,'job','10e1e63b-aeb2-48fc-b464-cdd223e54423','Job materials: 200gsm Gloss A4','2026-01-30 12:13:20');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('7543a751-20eb-4476-8da0-829659337f79','c7908556-9064-4c0a-889b-a5dff15d4de3','usage',-100000,'job','92fcc6fa-b4e2-426c-9f12-182bd3795990','Job materials: Black S/S','2026-01-30 12:28:46');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('3f3d96ad-5a9d-4f8e-a0be-45f39c45d587','c7908556-9064-4c0a-889b-a5dff15d4de3','usage',-35000,'job','92fcc6fa-b4e2-426c-9f12-182bd3795990','Job materials: Black D/S','2026-01-30 12:28:46');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('89608c81-e5e0-4e34-8914-0657bf44a8ee','c7908556-9064-4c0a-889b-a5dff15d4de3','usage',-10000,'job','92fcc6fa-b4e2-426c-9f12-182bd3795990','Job materials: Colour S/S','2026-01-30 12:28:46');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('27dea20d-a386-496b-9418-171bd7e8a8d0','c7908556-9064-4c0a-889b-a5dff15d4de3','usage',-25000,'job','92fcc6fa-b4e2-426c-9f12-182bd3795990','Job materials: Colour D/S','2026-01-30 12:28:46');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('6eb50855-3744-4a2d-9725-1ffb4fdb00cc','8a8d0abc-e3af-4177-94cf-cd623811cf76','usage',-5000,'job','92fcc6fa-b4e2-426c-9f12-182bd3795990','Job materials: Standard','2026-01-30 12:28:46');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('7be3d285-aff4-4897-98ef-c6b56c6654a0','75a111fb-ba8e-4dc9-baa8-40626d50205e','usage',-500,'job','92fcc6fa-b4e2-426c-9f12-182bd3795990','Job materials: 12mm wire binder 2:1 Pitch white','2026-01-30 12:28:46');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('979c36c3-0dbc-403c-8fdf-960ca42798e7','ea691d83-4e75-43b5-bbd4-8d0e29d409fe','usage',-500,'job','92fcc6fa-b4e2-426c-9f12-182bd3795990','Job materials: Front','2026-01-30 12:28:46');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('c9321922-d943-4946-8ac6-2cdf3a4df8c1','7efc8727-fb87-40c1-9ea2-895c2de476f5','usage',-500,'job','92fcc6fa-b4e2-426c-9f12-182bd3795990','Job materials: 170gsm Matt A4','2026-01-30 12:28:46');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('bc8bcf03-e1ba-4dac-87d2-e995ebc4d5bd','c7908556-9064-4c0a-889b-a5dff15d4de3','usage',-2574,'job','b0090ea1-f668-460a-bcd0-d400da67d903','Job materials: Black D/S','2026-01-30 12:41:32');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('a679be9a-7b9c-404d-82ff-6b4caca03d78','8a8d0abc-e3af-4177-94cf-cd623811cf76','usage',-15,'job','b0090ea1-f668-460a-bcd0-d400da67d903','Job materials: Standard','2026-01-30 12:41:32');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('e8830231-722d-4e0f-b741-9faf442c8cdb','7efc8727-fb87-40c1-9ea2-895c2de476f5','usage',-3,'job','b0090ea1-f668-460a-bcd0-d400da67d903','Job materials: 170gsm Matt A4','2026-01-30 12:41:32');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('7961c8b0-436a-4b08-b579-39214e445695','19c25d91-aec3-441b-95c1-288dd6695fb0','purchase',50,'manual',NULL,'Quick add from inventory list','2026-01-30 12:50:45');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('049ae13b-abef-4c0a-8b42-49cdeef6f7a5','75a111fb-ba8e-4dc9-baa8-40626d50205e','purchase',50,'manual',NULL,'Quick add from inventory list','2026-01-30 12:51:05');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('656c3a60-1691-4503-8157-7b7f7a4052a3','4488a13c-234a-4d84-9d62-cb8741cc9a11','purchase',50,'manual',NULL,'Quick add from inventory list','2026-01-30 12:51:17');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('b972499a-2e53-48fb-bfa0-0ed46e8367f2','c7908556-9064-4c0a-889b-a5dff15d4de3','purchase',50,'manual',NULL,'Quick add from inventory list','2026-01-30 12:51:25');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('54e98de6-f037-42b7-9ca5-da29509c9847','8a8d0abc-e3af-4177-94cf-cd623811cf76','purchase',50,'manual',NULL,'Quick add from inventory list','2026-01-30 12:51:33');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('137f2936-99b8-4282-be89-05569ea90679','ea691d83-4e75-43b5-bbd4-8d0e29d409fe','purchase',60,'manual',NULL,'Quick add from inventory list','2026-01-30 12:51:43');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('2bc59fa8-66ca-4d58-9ff9-7ddbb0b61128','ea691d83-4e75-43b5-bbd4-8d0e29d409fe','purchase',60,'manual',NULL,'Quick add from inventory list','2026-01-30 12:51:54');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('02a79dc7-0a84-4930-8b4d-8987ec3a0917','ea691d83-4e75-43b5-bbd4-8d0e29d409fe','purchase',200,'manual',NULL,'Quick add from inventory list','2026-01-30 12:52:12');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('e9a5d763-b378-48b5-859d-de97b71d4882','8a8d0abc-e3af-4177-94cf-cd623811cf76','purchase',200,'manual',NULL,'Quick add from inventory list','2026-01-30 12:52:21');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('d5b0e29c-d333-463d-94cf-c0bd4b169149','ea691d83-4e75-43b5-bbd4-8d0e29d409fe','purchase',500,'manual',NULL,'Quick add from inventory list','2026-01-30 12:52:38');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('ff28fcdf-581e-4d75-bd05-a59746e57537','c7908556-9064-4c0a-889b-a5dff15d4de3','usage',-2574,'job','5d3f3862-8939-4459-8fad-0e07f6bc52c3','Job materials: Black D/S','2026-01-30 12:54:42');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('c43a34ee-52dc-456f-8b88-91fc7fc2449a','7efc8727-fb87-40c1-9ea2-895c2de476f5','usage',-3,'job','5d3f3862-8939-4459-8fad-0e07f6bc52c3','Job materials: 170gsm Matt A4','2026-01-30 12:54:42');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('946f2717-c7eb-4bd7-9c48-9f406c2cf610','c7908556-9064-4c0a-889b-a5dff15d4de3','usage',-1287,'job','1f2c4e2f-ca94-40ba-a8e7-9d2c5617e2fc','Job materials: Black D/S','2026-01-30 13:23:13');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('e7cb48dd-c5cb-4a30-aee2-dedcd90ee396','ea691d83-4e75-43b5-bbd4-8d0e29d409fe','usage',-3,'job','1f2c4e2f-ca94-40ba-a8e7-9d2c5617e2fc','Job materials: Front','2026-01-30 13:23:13');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('19282aae-6d05-47e9-9138-0955dd4c19fe','c7908556-9064-4c0a-889b-a5dff15d4de3','usage',-410,'job','8ddde70c-7bd0-4231-a89a-8252fac114ac','Job materials: Black D/S','2026-01-30 13:47:53');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('232b9be6-13f1-45eb-b16c-9ec284b22e02','75a111fb-ba8e-4dc9-baa8-40626d50205e','usage',-10,'job','8ddde70c-7bd0-4231-a89a-8252fac114ac','Job materials: 12mm wire binder 2:1 Pitch white','2026-01-30 13:47:53');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('b3fa03e1-394c-43a9-a965-3570dd1963ae','ea691d83-4e75-43b5-bbd4-8d0e29d409fe','usage',-10,'job','8ddde70c-7bd0-4231-a89a-8252fac114ac','Job materials: Front','2026-01-30 13:47:53');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('f05d5eb0-2396-44d8-97a3-311330e3eadf','7efc8727-fb87-40c1-9ea2-895c2de476f5','usage',-10,'job','8ddde70c-7bd0-4231-a89a-8252fac114ac','Job materials: 170gsm Matt A4','2026-01-30 13:47:53');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('716458b9-bc76-4536-9798-bfa6990b3843','c7908556-9064-4c0a-889b-a5dff15d4de3','purchase',2500,'manual',NULL,'Quick add from inventory list','2026-01-30 13:48:15');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('8fc50daa-d595-4faf-b3f1-5002ee92f1b9','ea691d83-4e75-43b5-bbd4-8d0e29d409fe','purchase',2000,'manual',NULL,'Quick add from inventory list','2026-02-02 12:42:38');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('85d4a476-5492-48ea-8981-d18e7a2beaf1','2ac4dc43-9b5c-4909-9c3e-cc3d389d27a4','purchase',3000,'manual',NULL,'Quick add from inventory list','2026-02-02 12:43:03');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('66d7c241-59d1-420b-b840-1d528aad2dcb','8a8d0abc-e3af-4177-94cf-cd623811cf76','purchase',1000,'manual',NULL,'Quick add from inventory list','2026-02-02 12:44:00');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('3fe54601-7d7a-4241-bbb2-5ed8dbf3a53d','c7908556-9064-4c0a-889b-a5dff15d4de3','purchase',1200,'manual',NULL,'Quick add from inventory list','2026-02-02 12:44:25');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('b372ac6d-3267-4193-acbf-1f77498abba7','19c25d91-aec3-441b-95c1-288dd6695fb0','purchase',400,'manual',NULL,'Quick add from inventory list','2026-02-02 12:57:35');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('ac8db541-124a-4905-974f-e08aac885176','75a111fb-ba8e-4dc9-baa8-40626d50205e','purchase',400,'manual',NULL,'Quick add from inventory list','2026-02-02 12:57:47');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('935a131f-f5e9-4133-9dc4-fe96cbe3dec1','6f053e95-1483-493b-a5c3-7a1fdd4d46d7','purchase',400,'manual',NULL,'Quick add from inventory list','2026-02-02 12:58:01');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('acb70acc-21be-418e-8211-54064f02efc3','a8f47f40-f75f-45bb-bbb9-27d76e0c4ff8','purchase',300,'manual',NULL,'Quick add from inventory list','2026-02-02 12:58:12');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('2800153e-d7d1-41d1-abb1-197c0a7ab206','59ceaa72-0771-42ba-93b4-cd83cfd380d8','purchase',300,'manual',NULL,'Quick add from inventory list','2026-02-02 12:58:35');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('12da59b7-6298-4f52-9adb-b35303ff2359','4488a13c-234a-4d84-9d62-cb8741cc9a11','purchase',150,'manual',NULL,'Quick add from inventory list','2026-02-02 12:58:45');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('c0a228ca-9da4-4c6b-aef5-125e7c582af0','3d466f27-7b3e-4bd5-82d9-d5a6b3696186','purchase',120,'manual',NULL,'Quick add from inventory list','2026-02-02 12:58:57');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('cc420e36-ed91-44eb-a6e4-3784cec92226','2af9f912-25a6-49e6-a8ce-fa1d420e54b7','purchase',180,'manual',NULL,'Quick add from inventory list','2026-02-02 12:59:18');
INSERT OR REPLACE INTO "inventory_transactions" ("id","item_id","transaction_type","quantity","reference_type","reference_id","notes","created_at") VALUES ('0b5139df-12be-40b9-ad4c-30fffbe5608e','1bf6cacc-c794-4deb-b7ad-3d6d6af278dc','purchase',1000,'manual',NULL,'Quick add from inventory list','2026-02-02 12:59:34');

-- job_number_seq
INSERT OR REPLACE INTO "job_number_seq" ("next_val") VALUES (11);

