-- 1. Fix paths for existing services
UPDATE `services` SET `image_url` = 'our servies image/Our Services/Petro-Pump-Retail-Outlet.jpeg' WHERE `title` = 'Development of IOCL Retail Outlet';
UPDATE `services` SET `image_url` = 'our servies image/Our Services/fabrication_wor.jpeg' WHERE `title` = 'Fabrication Works';
UPDATE `services` SET `image_url` = 'our servies image/Our Services/Development_road.jpeg' WHERE `title` = 'Development Of Road';
UPDATE `services` SET `image_url` = 'our servies image/Our Services/interior_work.jpeg' WHERE `title` = 'Interior Work';
UPDATE `services` SET `image_url` = 'our servies image/Our Services/Aluminium_work.jpeg' WHERE `title` = 'Aluminium Work';

-- 2. Add New Services (using INSERT IGNORE to avoid duplicates if title is unique, or just simple insert if no unique constraint on title)
-- Assuming 'title' is not unique key as per schema earlier (only ID is PK), but better to avoid clutter.
-- I'll use a conditional insert workaround since IF NOT EXISTS valid in stored procedure, but here we can just delete if exists then insert, or rely on distinctness.
-- Actually, let's just DELETE them if they exist to start fresh for these specific ones, effectively updating them.
DELETE FROM `services` WHERE `title` IN ('Building Construction', 'BPCL Retail Outlets', 'HPCL Projects');

INSERT INTO `services` (`title`, `description`, `image_url`) VALUES
('Building Construction', 'Comprehensive building construction services ensuring stability and excellence.', 'our servies image/Our Services/Construction_of_Building.jpeg'),
('BPCL Retail Outlets', 'Specialized development and setup for BPCL retail outlets.', 'our servies image/Our Services/BPCL.jpeg'),
('HPCL Projects', 'Execution of HPCL infrastructure and retail projects.', 'our servies image/Our Services/HPCL.jpeg');
