-- ===================================================================== -- Backfills real photos, logos, case-study artwork and gallery images -- from the live prudas.com site, mapped item-by-item to the content -- already seeded in V2 (V1/V2 are never edited after release — Flyway -- checksums them, so any change here always ships as a new migration). -- -- These URLs point directly at the existing WordPress media library on -- prudas.com rather than at copies bundled with this project — pulling -- the actual files into this project wasn't possible from the tooling -- available when this migration was written. Before retiring the old -- WordPress hosting, re-upload each of these through the new admin -- panel (Settings → the relevant section) so the new site no longer -- depends on the old one being online. The one process-step icon set -- (/icons/*.svg) is left as-is — the originals were unattributed stock -- art, not site-specific content worth carrying over. -- ===================================================================== -- --------------------------------------------------------------------- -- Team photos (About Us page) -- --------------------------------------------------------------------- UPDATE team_members SET photo_url = 'https://prudas.com/wp-content/uploads/2023/10/Picture11.png' WHERE name = 'Gopesh Raghuvanshi'; UPDATE team_members SET photo_url = 'https://prudas.com/wp-content/uploads/2023/10/Picture2-1.png' WHERE name = 'Dr. Rudra Pratap Singh'; UPDATE team_members SET photo_url = 'https://prudas.com/wp-content/uploads/2023/10/Picture3.png' WHERE name = 'Dr. Puneet K. Jha'; UPDATE team_members SET photo_url = 'https://prudas.com/wp-content/uploads/2023/11/Picture9.png' WHERE name = 'Dr. Sangeet Gaur'; UPDATE team_members SET photo_url = 'https://prudas.com/wp-content/uploads/2023/10/Picture5.png' WHERE name = 'Deeksha Tripathi'; UPDATE team_members SET photo_url = 'https://prudas.com/wp-content/uploads/2023/10/Picture6.jpg' WHERE name = 'Vivek Kapoor'; UPDATE team_members SET photo_url = 'https://prudas.com/wp-content/uploads/2023/10/Picture7.png' WHERE name = 'Karmveer Singh'; -- --------------------------------------------------------------------- -- Case studies (homepage "Our Products"). Spirals Health is presented -- on the live site as a whiteboard-style explainer video rather than a -- static photo, so its image_url is cleared instead of pointing at -- something that doesn't exist. -- --------------------------------------------------------------------- UPDATE case_studies SET image_url = NULL, video_url = 'https://prudas.com/wp-content/uploads/2023/10/Benefits-of-Doctors-Appointment-Scheduling-App-_-%E0%A4%98%E0%A4%B0-%E0%A4%AC%E0%A5%88%E0%A4%A0%E0%A5%87-%E0%A4%A1%E0%A5%89%E0%A4%95%E0%A5%8D%E0%A4%9F%E0%A4%B0-%E0%A4%B8%E0%A5%87-%E0%A4%91%E0%A4%A8%E0%A4%B2%E0%A4%BE%E0%A4%87%E0%A4%A8-%E0%A4%A1%E0%A5%89%E0%A4%95%E0%A5%8D%E0%A4%9F%E0%A4%B0-%E0%A4%85%E0%A4%AA%E0%A5%89%E0%A4%87%E0%A4%82%E0%A4%9F%E0%A4%AE%E0%A5%87%E0%A4%82%E0%A4%9F-%E0%A4%AC%E0%A5%81%E0%A4%95-%E0%A4%95%E0%A4%B0%E0%A5%87%E0%A4%82-1.mp4' WHERE title LIKE 'Connecting All to benefit All%'; UPDATE case_studies SET image_url = 'https://prudas.com/wp-content/uploads/2023/10/Untitled-design.png' WHERE title = 'Sales CRM'; UPDATE case_studies SET image_url = 'https://prudas.com/wp-content/uploads/2023/11/case-studyimage-800x533-1.jpg' WHERE title = 'Dream Sarkar'; -- --------------------------------------------------------------------- -- Blog cover images (matched by slug) -- --------------------------------------------------------------------- UPDATE blog_posts SET cover_image_url = 'https://prudas.com/wp-content/uploads/2023/10/WhatsApp-Image-2023-10-15-at-2.43.33-AM-600x490.jpeg' WHERE slug = '5-reasons-why-you-should-build-your-website-on-wordpress'; UPDATE blog_posts SET cover_image_url = 'https://prudas.com/wp-content/uploads/2023/10/WhatsApp-Image-2023-10-15-at-2.47.49-AM-600x490.jpeg' WHERE slug = 'tips-to-consider-while-choosing-a-digital-marketing-agency'; UPDATE blog_posts SET cover_image_url = 'https://prudas.com/wp-content/uploads/2023/10/WhatsApp-Image-2023-10-15-at-4.55.57-AM-600x490.jpeg' WHERE slug = 'how-to-create-lead-magnets-that-convert'; -- --------------------------------------------------------------------- -- Service hero images — only set for the 4 nav services, which are the -- ones with a confirmed live page to check against. The 6 homepage-card -- services didn't have distinct, confidently-matched hero photography -- to carry over, so they're left as-is. -- --------------------------------------------------------------------- UPDATE services SET hero_image_url = 'https://prudas.com/wp-content/uploads/2023/10/Untitled-design-7.png' WHERE slug = 'affiliate-marketing-services'; UPDATE services SET hero_image_url = 'https://prudas.com/wp-content/uploads/2023/10/WhatsApp-Image-2023-10-15-at-1.15.27-AM.jpeg' WHERE slug = 'chatbot-services'; UPDATE services SET hero_image_url = 'https://prudas.com/wp-content/uploads/2023/10/WhatsApp-Image-2023-10-14-at-11.45.04-PM.jpeg' WHERE slug = 'email-marketing-services'; UPDATE services SET hero_image_url = 'https://prudas.com/wp-content/uploads/2023/11/video-marketing1.png' WHERE slug = 'video-marketing-service'; -- --------------------------------------------------------------------- -- Tie-up partners: the live site currently carousels 6 real partner -- logos, not 12 — replacing the 12 generic "Partner N" placeholders -- with those 6. Names below are inferred from the logo file names -- (two — EFRA Management and Espion Infotech — are confirmed by name -- in the testimonials already on this page); double-check and correct -- them via the admin panel if any aren't quite right. -- --------------------------------------------------------------------- DELETE FROM tie_up_partners; INSERT INTO tie_up_partners (name, logo_url, display_order) VALUES ('Espion Infotech', 'https://prudas.com/wp-content/uploads/2023/10/espion.png', 1), ('CropC', 'https://prudas.com/wp-content/uploads/2023/10/cropc.png', 2), ('ABDM', 'https://prudas.com/wp-content/uploads/2023/10/ABDM.jpeg', 3), ('EFRA Management', 'https://prudas.com/wp-content/uploads/2023/10/efra1.png', 4), ('India Health Link', 'https://prudas.com/wp-content/uploads/2023/10/India-health-link.png', 5), ('Healthopia', 'https://prudas.com/wp-content/uploads/2023/10/healthopia.jpg', 6); -- --------------------------------------------------------------------- -- Gallery — previously empty; these are real event/office photos from -- the live site's Gallery page. -- --------------------------------------------------------------------- INSERT INTO gallery_images (image_url, caption, display_order) VALUES ('https://prudas.com/wp-content/uploads/2023/10/WhatsApp-Image-2023-10-16-at-7.49.19-PM.jpeg', NULL, 1), ('https://prudas.com/wp-content/uploads/2023/10/WhatsApp-Image-2023-10-16-at-7.49.21-PM-1-800x600.jpeg', NULL, 2), ('https://prudas.com/wp-content/uploads/2023/10/WhatsApp-Image-2023-10-16-at-7.49.21-PM-800x600.jpeg', NULL, 3), ('https://prudas.com/wp-content/uploads/2023/10/WhatsApp-Image-2023-10-16-at-7.49.22-PM-1-800x602.jpeg', NULL, 4), ('https://prudas.com/wp-content/uploads/2023/10/WhatsApp-Image-2023-10-16-at-7.49.22-PM-2-800x602.jpeg', NULL, 5), ('https://prudas.com/wp-content/uploads/2023/10/WhatsApp-Image-2023-10-16-at-7.49.22-PM-3-800x361.jpeg', NULL, 6), ('https://prudas.com/wp-content/uploads/2023/10/WhatsApp-Image-2023-10-16-at-7.49.23-PM-800x360.jpeg', NULL, 7), ('https://prudas.com/wp-content/uploads/2023/10/WhatsApp-Image-2023-10-16-at-7.49.24-PM-800x360.jpeg', NULL, 8), ('https://prudas.com/wp-content/uploads/2023/10/WhatsApp-Image-2023-10-16-at-7.49.25-PM-800x361.jpeg', NULL, 9), ('https://prudas.com/wp-content/uploads/2023/10/WhatsApp-Image-2023-10-16-at-7.49.25-PM-1-800x360.jpeg', NULL, 10), ('https://prudas.com/wp-content/uploads/2023/10/WhatsApp-Image-2023-10-16-at-7.49.25-PM-2-800x360.jpeg', NULL, 11), ('https://prudas.com/wp-content/uploads/2023/10/WhatsApp-Image-2023-10-16-at-7.49.26-PM-800x360.jpeg', NULL, 12), ('https://prudas.com/wp-content/uploads/2023/10/WhatsApp-Image-2023-10-16-at-7.49.26-PM-1-800x360.jpeg', NULL, 13);