-- ===================================================================== -- Seed data mirrors the real content published on prudas.com at the time -- of migration (Aug 2026), so the new site launches as a faithful replica. -- Replace image URLs with assets uploaded to your own storage before going -- live — the placeholders here point at /uploads/... paths served by the -- frontend's static asset pipeline, not at the old WordPress media library. -- ===================================================================== -- Default admin account. Username/password are ONLY for first login in a -- freshly provisioned environment — change the password immediately via -- POST /api/admin/auth/change-password, or via ADMIN_BOOTSTRAP_PASSWORD. -- Password for this hash: "ChangeMe!2026Admin" (BCrypt, cost 12) INSERT INTO admin_users (username, email, password_hash, role, enabled) VALUES ('admin', 'admin@prudas.com', '$2b$12$qGE7i3jPgSkOtaeZvfU7seCRIdki4E5WJhHI8LVAvIQv5YJXXWD..', 'ADMIN', TRUE); -- --------------------------------------------------------------------- -- Services: the 4 items from the "Service" nav dropdown, each with its -- own page and development-process steps (matching the WordPress site). -- --------------------------------------------------------------------- INSERT INTO services (slug, title, tagline, summary, content, contact_email, display_order, published, show_in_nav, show_on_home) VALUES ('affiliate-marketing-services', 'Affiliate Marketing Service', 'Turn partners into a growth channel', 'We design and manage affiliate programs that turn partners and influencers into a reliable, performance-based growth channel for your brand.', 'We build end-to-end affiliate marketing programs — from partner recruitment and commission structuring to tracking, attribution and payouts — so you only pay for results.', 'info@prudas.com', 1, TRUE, TRUE, FALSE), ('chatbot-services', 'Chatbot Service', 'Bots with a personality that convert', 'On a daily basis we interact with a lot of chatbots. Every business organisation uses them to answer queries, generate leads and support customers around the clock.', 'We create chatbots that help you increase and expand your business. Every bot we build is designed with a personality that fits your brand, is trained on your business context, and gets smarter over time.', 'info@prudas.com', 2, TRUE, TRUE, FALSE), ('email-marketing-services', 'Email Marketing Services', 'Inbox campaigns that convert', 'We craft targeted, automated email campaigns — from welcome sequences to re-engagement flows — that nurture leads and keep customers coming back.', 'Our email marketing service covers strategy, copywriting, design, automation and deliverability — so every campaign lands in the inbox and drives measurable revenue.', 'info@prudas.com', 3, TRUE, TRUE, FALSE), ('video-marketing-service', 'Video Marketing Service', 'Stories that move your audience', 'From explainer videos to social ads, we produce video content engineered to hold attention and drive action across every platform your audience uses.', 'We handle scripting, production, editing and platform-specific optimisation so your video marketing performs everywhere from YouTube to Instagram Reels.', 'info@prudas.com', 4, TRUE, TRUE, FALSE); -- --------------------------------------------------------------------- -- Homepage "Our Services" capability cards (Full Stack Development, -- Application Development, CMS Development, SEO, Digital Marketing, -- Social Media Marketing). Each also gets its own page, an improvement -- over the WordPress original where these were homepage-only cards. -- --------------------------------------------------------------------- INSERT INTO services (slug, title, tagline, summary, content, contact_email, display_order, published, show_in_nav, show_on_home) VALUES ('full-stack-development', 'Full Stack Development', 'End-to-end delivery, start to finish', 'Get complete end to end development solutions with our efficient full stack development services.', 'From database design to pixel-perfect UI, our full stack team ships production-grade web applications using modern, secure frameworks across the entire stack.', 'info@prudas.com', 5, TRUE, FALSE, TRUE), ('application-development', 'Application Development', 'Next-gen mobile, built for growth', 'We help you build a next gen mobile application to turn your business vision into reality with our expert app development team.', 'We design and build native and cross-platform mobile applications, from prototype through app-store launch and ongoing maintenance.', 'info@prudas.com', 6, TRUE, FALSE, TRUE), ('cms-development', 'CMS Development', 'Hassle-free content, any industry', 'We provide customised CMS development services across industry verticals to enable hassle-free content management.', 'Whether you need a headless CMS or a fully custom admin panel, we build content platforms your team can manage without touching code.', 'info@prudas.com', 7, TRUE, FALSE, TRUE), ('search-engine-optimization', 'Search Engine Optimization', 'Get found on page one', 'Get ranked on the first page of Google, Bing, or Safari search results with our efficient SEO services.', 'Our SEO service covers technical audits, on-page optimisation, content strategy and link building to grow your organic visibility sustainably.', 'info@prudas.com', 8, TRUE, FALSE, TRUE), ('digital-marketing', 'Digital Marketing', 'Traffic that turns into customers', 'We help you create unique digital marketing solutions that convert your website traffic into paying customers.', 'From paid search to conversion rate optimisation, our digital marketing team builds full-funnel strategies tailored to your goals.', 'info@prudas.com', 9, TRUE, FALSE, TRUE), ('social-media-marketing', 'Social Media Marketing', 'Followers, leads, conversions', 'From increasing followers to generating leads and driving conversions, our social media marketing services cover every major platform.', 'We plan, create and manage social campaigns across Instagram, LinkedIn, Facebook and X, backed by analytics that show real ROI.', 'info@prudas.com', 10, TRUE, FALSE, TRUE); -- Development-process steps for the 4 primary nav services (same 6-stage -- process used across the original WordPress service pages). INSERT INTO service_process_steps (service_id, step_order, title, description, icon_url) SELECT s.id, steps.step_order, steps.title, steps.description, steps.icon_url FROM services s JOIN (VALUES (1, 'Requirement Analysis', 'When a query comes to us our team analyses the purpose, the reason, target segment and business objective before proposing an approach.', '/icons/requirement-analysis.svg'), (2, 'Flow Design', 'At this stage our design team maps out how the solution will behave, its structure and the end-to-end experience.', '/icons/flow-design.svg'), (3, 'Integration', 'We decide which systems the solution needs to integrate with and build streamlined, secure connections between them.', '/icons/integration.svg'), (4, 'Training and Testing', 'After development and integration, the solution is tested for errors and validated against real-world scenarios.', '/icons/training-testing.svg'), (5, 'Deployment', 'At this step the solution is released for production usage.', '/icons/deployment.svg'), (6, 'Optimisation', 'After deployment, performance is monitored continuously and optimised whenever something can work better.', '/icons/optimisation.svg') ) AS steps(step_order, title, description, icon_url) ON TRUE WHERE s.slug IN ('affiliate-marketing-services', 'chatbot-services', 'email-marketing-services', 'video-marketing-service'); -- --------------------------------------------------------------------- -- Homepage case studies / flagship products -- --------------------------------------------------------------------- INSERT INTO case_studies (title, summary, image_url, video_url, display_order) VALUES ('Connecting All to benefit All – Spirals Health', 'Spirals Health is the flagship product of Prudas that aims to connect patients with doctors. Through Spirals Health we aim to revolutionise the patient treatment process, by enabling an all-inclusive digital platform that connects patients, doctors, labs, chemists and insurance companies.', '/images/case-studies/spirals-health.jpg', '/videos/spirals-health-intro.mp4', 1), ('Sales CRM', 'We believe in helping our clients through efficient and robust technologies. We developed a customised Sales CRM that streamlines lead management, pipeline tracking and reporting for growing sales teams.', '/images/case-studies/sales-crm.jpg', NULL, 2), ('Dream Sarkar', 'You got an idea, we got the solutions. One of our clients came to us with a requirement of a quiz application with real-time leaderboards, and we delivered Dream Sarkar end to end.', '/images/case-studies/dream-sarkar.jpg', NULL, 3); -- --------------------------------------------------------------------- -- Testimonials -- --------------------------------------------------------------------- INSERT INTO testimonials (quote, author_name, author_title, display_order) VALUES ('I recently had the pleasure of working with Prudas to bring my app idea to life, and I could not be more satisfied with the outcome. Their team combined technical depth with genuine care for the product.', 'Premchand Yadav', 'Director, EFRA Management Pvt. Ltd', 1), ('I can confidently say Prudas exceeded expectations in every aspect. We are thrilled to become their long-term partner and recommend them without hesitation.', 'Praveen', 'Founder, Espion Infotech Private Limited', 2), ('The team at Prudas consistently adhered to the project timeline and budget. They provided clear and proactive communication throughout the engagement.', 'Nirmal Raghuvanshi', 'Founder, BlueJay Consulting', 3); -- --------------------------------------------------------------------- -- Team (About Us page) -- --------------------------------------------------------------------- INSERT INTO team_members (name, title, photo_url, linkedin_url, display_order) VALUES ('Gopesh Raghuvanshi', 'Chief Executive Officer (CEO)', '/images/team/gopesh-raghuvanshi.jpg', 'https://www.linkedin.com/in/gopesh-raghuvanshi-389bbb11/', 1), ('Dr. Rudra Pratap Singh', 'Director and Advisor', '/images/team/rudra-pratap-singh.jpg', NULL, 2), ('Dr. Puneet K. Jha', 'Director – Marketing & Sales Advisor', '/images/team/puneet-k-jha.jpg', NULL, 3), ('Dr. Sangeet Gaur', 'Director and Hospital Operations Advisor', '/images/team/sangeet-gaur.jpg', NULL, 4), ('Deeksha Tripathi', 'Business Head', '/images/team/deeksha-tripathi.jpg', 'https://www.linkedin.com/in/digitaldeeksha/', 5), ('Vivek Kapoor', 'Head of Software Development', '/images/team/vivek-kapoor.jpg', NULL, 6), ('Karmveer Singh', 'Legal Advisor', '/images/team/karmveer-singh.jpg', NULL, 7); -- --------------------------------------------------------------------- -- Core values (About Us page) -- --------------------------------------------------------------------- INSERT INTO core_values (title, description, display_order) VALUES ('Leadership', 'We have the courage to lead the world in the web and mobility solutions space and change the way people experience technology.', 1), ('Customers first', 'Whatever we create, our customers are at the centre of it. The solutions and services we build are shaped around their needs.', 2), ('Passion', 'We are committed to our vision and mission with heart as well as mind. Our passion for our work shows in everything we deliver.', 3), ('Acta Non Verba', 'We do not just say, we do. We always stand by our words when it comes to delivering quality projects on time.', 4), ('Quality', 'We never compromise on quality. We are committed to designing, devising and delivering high-quality services and products.', 5), ('Transparency', 'We maintain transparency with our employees as well as our clients, in everything related to our work and our business.', 6), ('Respect', 'As Confucius said, "Respect yourself and others will respect you." By this core value we mean everyone we work with.', 7); -- --------------------------------------------------------------------- -- Blog posts -- --------------------------------------------------------------------- INSERT INTO blog_posts (slug, title, excerpt, content, cover_image_url, author_name, published, published_at) VALUES ('5-reasons-why-you-should-build-your-website-on-wordpress', '5 reasons why you should build your website on WordPress', 'In the digital age, having a robust online presence is a non-negotiable for businesses, entrepreneurs and creators alike. Here is why WordPress remains a strong starting point.', E'In the digital age, having a robust online presence is a non-negotiable for businesses, entrepreneurs and creators alike. Here are five reasons WordPress remains a popular choice for getting a site off the ground quickly: an enormous plugin and theme ecosystem, strong SEO fundamentals out of the box, a gentle learning curve for content editors, a large community for support, and cost-effective hosting options. That said, as a business scales, a custom stack — like the React, Java and PostgreSQL platform this site itself now runs on — offers more control over performance, security and long-term extensibility.', '/images/blog/wordpress-website.jpg', 'Prudas Technologies', TRUE, '2023-10-15T02:43:33Z'), ('tips-to-consider-while-choosing-a-digital-marketing-agency', 'Tips to consider while choosing a digital marketing agency', 'Finding and finalising a digital marketing agency for your goals is really a tough task. It becomes even harder with so many agencies making the same promises.', E'Finding and finalising a digital marketing agency for your goals is really a tough task. It becomes even harder with so many agencies making the same promises. Before you sign a contract, look for a proven track record with measurable case studies, transparent reporting cadence, a team that understands your industry, clear ownership of deliverables, and pricing that ties to outcomes rather than vague "brand awareness" promises. A good agency will also be upfront about what will not work for your business, not just what will.', '/images/blog/digital-marketing-agency.jpg', 'Prudas Technologies', TRUE, '2023-10-15T02:47:49Z'), ('how-to-create-lead-magnets-that-convert', 'How to create lead magnets that convert?', 'There is no value in getting a huge amount of traffic if that does not convert. You might have put up great content, but without the right lead magnet, visitors leave and never come back.', E'There is no value in getting a huge amount of traffic if that does not convert. You might have put up great content, but without the right lead magnet, visitors leave and never come back. The best-performing lead magnets solve one specific, immediate problem for a clearly defined audience, are consumable in minutes, and set up a natural next step toward your paid offering — think checklists, calculators, templates or short assessments rather than generic long-form ebooks.', '/images/blog/lead-magnets.jpg', 'Prudas Technologies', TRUE, '2023-10-15T04:55:57Z'); -- --------------------------------------------------------------------- -- Tie-up partners (homepage logo carousel) — generic placeholders; -- replace with real partner logos and names before launch. -- --------------------------------------------------------------------- INSERT INTO tie_up_partners (name, logo_url, display_order) SELECT 'Partner ' || n, '/images/partners/partner-' || n || '.png', n FROM generate_series(1, 12) AS n; -- --------------------------------------------------------------------- -- Careers -- --------------------------------------------------------------------- INSERT INTO job_postings (title, department, location, employment_type, description, apply_email, published, posted_at) VALUES ('Full Stack Developer (React / Java)', 'Engineering', 'Noida, India (Hybrid)', 'Full-time', 'We are looking for a full stack developer comfortable across React, Spring Boot and PostgreSQL to help build and maintain client products.', 'careers@prudas.com', TRUE, now()), ('Digital Marketing Executive', 'Marketing', 'Noida, India', 'Full-time', 'Own SEO, paid campaigns and social media execution for Prudas and client accounts.', 'careers@prudas.com', TRUE, now()); -- --------------------------------------------------------------------- -- Office locations & contact details (Contact Us page) -- --------------------------------------------------------------------- INSERT INTO office_locations (label, address, phone, display_order) VALUES ('India', 'H-1 A/20, Block-H, Sector-63, Noida, Gautam Buddha Nagar, Uttar Pradesh, 201301', '+91-7669666994', 1), ('USA', '195 Montague St, 14th Floor, Brooklyn, NY 11201, USA', '+91-7669666995', 2); -- --------------------------------------------------------------------- -- Social links (footer) -- --------------------------------------------------------------------- INSERT INTO social_links (platform, url, display_order) VALUES ('facebook', 'https://www.facebook.com/spiralshealth/', 1), ('twitter', 'https://twitter.com/Spiralshealth', 2), ('youtube', 'https://youtube.com/@spiralshealth1466', 3), ('instagram', 'https://www.instagram.com/spiralshealth/', 4), ('linkedin', 'https://www.linkedin.com/company/28696822/', 5), ('whatsapp', 'https://wa.me/+918377870707', 6);