-- DPM Database Data Backup
-- Generated on 2026-08-13 21:05:34

-- Data for table `project_ledger`
INSERT INTO `project_ledger` VALUES('5','11a','2026-06-29','budget','1000.00','2.0',NULL,NULL,'0','0','0','7','0');
INSERT INTO `project_ledger` VALUES('6','11a','2026-06-29','budget','5000.00','2.0',NULL,NULL,'0','0','0','9','0');
INSERT INTO `project_ledger` VALUES('7','11a','2026-06-29','budget','9000.00','2.0',NULL,NULL,'0','0','0','7','0');
INSERT INTO `project_ledger` VALUES('8','11a','2026-07-08','invoice','10000.00','[MultiZone Climate Engineering Upload] eytjeyhj','0','0','1','1','0','7','1');
INSERT INTO `project_ledger` VALUES('9','11a','2026-07-22','invoice','1234.00','2.0',NULL,NULL,'0','1','1',NULL,'0');
INSERT INTO `project_ledger` VALUES('12','11a','2026-07-22','addition','4000.00','New scope','2026','0','1','0','1','7','0');
INSERT INTO `project_ledger` VALUES('13','156a','2026-07-08','invoice','0.06','2.0','0','0','1','0','0',NULL,'0');
INSERT INTO `project_ledger` VALUES('14','156a','2026-06-29','budget','5000.00','2.0',NULL,NULL,'1','0','0','7','0');
INSERT INTO `project_ledger` VALUES('15','11a','2026-07-09','invoice','2345.00','[MultiZone Climate Engineering Upload] eytjeyhj','0','0','1','1','1','7','1');
INSERT INTO `project_ledger` VALUES('16','11a','2026-07-17','invoice','0.06','Completed Work','Inv2205 SCL.jpeg','uploads/doc_1782944662_Inv2205_SCL.jpeg','0','1','1',NULL,'0');
INSERT INTO `project_ledger` VALUES('17','47','2026-07-02','budget','7000.00','Project management','IMG_0040.jpeg','https://www.domesticprojectmanagement.co.uk//uploads/47_1783003162_IMG_0040.jpeg','1','0','0','11','0');
INSERT INTO `project_ledger` VALUES('18','47','2026-07-02','budget','8000.00','Ac','IMG_0034.jpeg','https://www.domesticprojectmanagement.co.uk//uploads/47_1783003339_IMG_0034.jpeg','1','0','0','7','0');
INSERT INTO `project_ledger` VALUES('19','47','2026-07-02','budget','4500.00','Timber','IMG_0016.png','https://www.domesticprojectmanagement.co.uk//uploads/47_1783003395_IMG_0016.png','1','0','0','1','0');
INSERT INTO `project_ledger` VALUES('20','47','2026-07-02','budget','1200.00','Plastering','IMG_0028.jpeg','https://www.domesticprojectmanagement.co.uk//uploads/47_1783003428_IMG_0028.jpeg','1','0','0','3','0');
INSERT INTO `project_ledger` VALUES('21','47','2026-07-16','invoice','700.00','[DPM project management Upload] Ybunuhun','IMG_0043.png','https://www.domesticprojectmanagement.co.uk//uploads/47_1783003725_IMG_0043.png','1','0','0','11','1');
INSERT INTO `project_ledger` VALUES('22','47','2026-07-16','invoice','700.00','[DPM project management Upload] Ybunuhun','IMG_0043.png','https://www.domesticprojectmanagement.co.uk//uploads/47_1783003736_IMG_0043.png','1','0','0','11','1');
INSERT INTO `project_ledger` VALUES('23','156a','2026-06-29','budget','6787.00','Rth','IMG_0040.jpeg','https://www.domesticprojectmanagement.co.uk//uploads/156a_1783008875_IMG_0040.jpeg','1','0','0','11','0');
INSERT INTO `project_ledger` VALUES('25','156a','2026-07-10','invoice','9000.00','[DPM777 Upload] eytjeyhj','Screenshot 2026-07-03 at 17.50.40.jpeg','https://www.domesticprojectmanagement.co.uk//uploads/156a_1783098557_Screenshot_2026_07_03_at_17.50.40.jpeg','1','0','0','11','0');
INSERT INTO `project_ledger` VALUES('26','47','2026-07-29','invoice','5000.00','','IMG_0039.jpeg','https://domesticprojectmanagement.co.uk//uploads/47_1783280134_IMG_0039.jpeg','1','0','0','11','0');


-- Data for table `projects`
INSERT INTO `projects` VALUES('11a','11a','4','1111',NULL);
INSERT INTO `projects` VALUES('156a','156a','1','0000',NULL);
INSERT INTO `projects` VALUES('47','47','2','0000',NULL);
INSERT INTO `projects` VALUES('58p','58p','0','0000',NULL);


-- Data for table `site_portfolio`
INSERT INTO `site_portfolio` VALUES('1','https://images.unsplash.com/photo-1513694203232-719a280e022f?w=800','1');
INSERT INTO `site_portfolio` VALUES('2','https://images.unsplash.com/photo-1581094288338-2314dddb7ece?w=800','4');
INSERT INTO `site_portfolio` VALUES('3','https://images.unsplash.com/photo-1504307651254-35680f356dfd?w=800','5');
INSERT INTO `site_portfolio` VALUES('4','https://images.unsplash.com/photo-1541888946425-d81bb19240f5?w=800','10');
INSERT INTO `site_portfolio` VALUES('5','https://images.unsplash.com/photo-1590381105924-c72589b9ef3f?w=800','11');
INSERT INTO `site_portfolio` VALUES('8','https://images.unsplash.com/photo-1600585154340-be6161a56a0c?w=800','12');
INSERT INTO `site_portfolio` VALUES('9','https://images.unsplash.com/photo-1600607687939-ce8a6c25118c?w=800','14');
INSERT INTO `site_portfolio` VALUES('10','https://images.unsplash.com/photo-1600566753376-12c8ab7fb75b?w=800','3');
INSERT INTO `site_portfolio` VALUES('12','https://www.domesticprojectmanagement.co.uk//uploads/portfolio_1783005157_IMG_0039.jpeg','8');
INSERT INTO `site_portfolio` VALUES('14','https://www.domesticprojectmanagement.co.uk//uploads/portfolio_1783005222_IMG_0043.png','15');
INSERT INTO `site_portfolio` VALUES('15','https://www.domesticprojectmanagement.co.uk//uploads/portfolio_1783005223_IMG_0040.jpeg','17');
INSERT INTO `site_portfolio` VALUES('17','https://www.domesticprojectmanagement.co.uk//uploads/portfolio_1783005238_IMG_0028.jpeg','2');


-- Data for table `supplier_allocations`
INSERT INTO `supplier_allocations` VALUES('1','1','11a','5000.00');
INSERT INTO `supplier_allocations` VALUES('2','1','156a','3200.00');
INSERT INTO `supplier_allocations` VALUES('3','2','11a','7500.00');
INSERT INTO `supplier_allocations` VALUES('4','2','47','4200.00');
INSERT INTO `supplier_allocations` VALUES('5','7','11a','14000.00');
INSERT INTO `supplier_allocations` VALUES('6','9','11a','5000.00');
INSERT INTO `supplier_allocations` VALUES('7','7','156a','5000.00');
INSERT INTO `supplier_allocations` VALUES('8','11','47','7000.00');
INSERT INTO `supplier_allocations` VALUES('9','7','47','8000.00');
INSERT INTO `supplier_allocations` VALUES('10','1','47','4500.00');
INSERT INTO `supplier_allocations` VALUES('11','3','47','1200.00');
INSERT INTO `supplier_allocations` VALUES('12','11','156a','6787.00');


-- Data for table `suppliers`
INSERT INTO `suppliers` VALUES('1','plumber_dpm',NULL,'Precision Plumb Solutions','','','1234','Plumber','Specialist in heating installations, underfloor water loops, and high-end bathroom retrofits.',NULL,NULL,NULL,NULL,NULL,NULL,'0161 555 1001','plumber.supplier@dpm.co.uk',NULL,NULL,NULL,NULL,'0');
INSERT INTO `suppliers` VALUES('2','electric_dpm',NULL,'VoltMaster Contracting','','','2345','Electrician','Certified electrical safety testing, dynamic home automation mapping loops, and phase distributions.',NULL,NULL,NULL,NULL,NULL,NULL,'0161 555 1002','electrician.supplier@dpm.co.uk',NULL,NULL,NULL,NULL,'0');
INSERT INTO `suppliers` VALUES('3','plaster_dpm',NULL,'MirrorFinish Plastering','','','3456','Plasterer','Premium quality skimming, drylining setups, and high-precision plaster installations.',NULL,NULL,NULL,NULL,NULL,NULL,'0161 555 1003','plasterer.supplier@dpm.co.uk',NULL,NULL,NULL,NULL,'0');
INSERT INTO `suppliers` VALUES('4','decor_dpm',NULL,'Airless Surface Decor','','','4567','Decorator','Meticulous micro-surface paint sprays and luxury wallcovering completions.',NULL,NULL,NULL,NULL,NULL,NULL,'0161 555 1004','decorator.supplier@dpm.co.uk',NULL,NULL,NULL,NULL,'0');
INSERT INTO `suppliers` VALUES('5','labour_dpm',NULL,'SiteForce Logistics','','','5678','Labourer','Site clearance logistics, excavation assists, and structural structural preps.',NULL,NULL,NULL,NULL,NULL,NULL,'0161 555 1005','labourer.supplier@dpm.co.uk',NULL,NULL,NULL,NULL,'0');
INSERT INTO `suppliers` VALUES('6','floor_dpm',NULL,'Chevron Oak Flooring','','','6789','Flooring','High-end herringbone wood overlays, solid wood matching, and subfloor smoothing controls.',NULL,NULL,NULL,NULL,NULL,NULL,'0161 555 1006','flooring.supplier@dpm.co.uk',NULL,NULL,NULL,NULL,'0');
INSERT INTO `suppliers` VALUES('7','ac_dpm','MultiZone Climate Mangineering','MultiZone Climate Mangineering','','','0000','AC Engineer','Multi-zone split air condition matrix installations and modern ventilation setups.',NULL,'https://www.domesticprojectmanagement.co.uk//uploads/sup_7_work_image_1.jpeg',NULL,NULL,NULL,NULL,'0161 555 1999','777.supplier@dpm.co.uk','Bob Holness','BHSolutions','123 the ridings, london',NULL,'0');
INSERT INTO `suppliers` VALUES('8','gas_dpm','GasSafe Certified Hydraulic Plant222','GasSafe Certified Hydraulic Plant222','','','8901','Gas Engineer111','Smart system combi boiler installations and advanced pipeline integration setups.',NULL,NULL,NULL,NULL,NULL,NULL,'0161 555 1008','gasengine.supplier@dpm.co.uk',NULL,NULL,NULL,NULL,'0');
INSERT INTO `suppliers` VALUES('9','build_dpm',NULL,'Apex Structural Building','','','9012','Builder','Steel RSJ installations, brick masonry matching, extensions, and foundations controls.',NULL,NULL,NULL,NULL,NULL,NULL,'0161 555 1009','builder.supplier@dpm.co.uk',NULL,NULL,NULL,NULL,'0');
INSERT INTO `suppliers` VALUES('10','interior_dpm',NULL,'Joinery Blueprint Spatial Design','','','0123','Interior Designer','Bespoke cabinet planning, architectural lighting configurations, and spatial coordination loops.',NULL,NULL,NULL,NULL,NULL,NULL,'0161 555 1010','interiordesigner.supplier@dpm.co.uk',NULL,NULL,NULL,NULL,'0');
INSERT INTO `suppliers` VALUES('11','DPM','DPM777','DPM777','','','7777','Project management','Description of DPM project managementDescription of DPM project managementDescription of DPM project managementDescription of DPM project managementDescription of DPM project ','https://domesticprojectmanagement.co.uk//uploads/sup_11_profile_image_1783101611.jpeg','https://www.domesticprojectmanagement.co.uk//uploads/sup_11_work_image_1_1783098200.jpeg','https://www.domesticprojectmanagement.co.uk//uploads/sup_11_work_image_2_1783098200.jpeg','https://www.domesticprojectmanagement.co.uk//uploads/sup_11_work_image_3_1783098200.jpeg','https://www.domesticprojectmanagement.co.uk//uploads/sup_11_work_image_4_1783098200.jpeg','https://www.domesticprojectmanagement.co.uk//uploads/sup_11_work_image_5_1783098200.jpeg','(07904) 131985','Chris.Worklife@gmail.com','Chris Eade','','',NULL,'0');
INSERT INTO `suppliers` VALUES('12','qqq111838','qqq111','qqq111','','','1234','TESTTRADETAG',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'123445667','dergr@hyjtj.nr','Jamie Tart','','',NULL,'0');