-- ═══════════════════════════════════════════════════════════════════════
--  Add certificate verification page to the website
--  Import this in cPanel → phpMyAdmin after schema.sql
-- ═══════════════════════════════════════════════════════════════════════

-- Add the verify-certificate page if it doesn't exist
INSERT IGNORE INTO pages (slug, title, nav_label, menu_parent, hero_heading, hero_subtext, hero_show, meta_title, meta_description, robots, status, sort) VALUES
('verify-certificate', 'Verify Certificate', NULL, NULL, 'Verify Your Certificate', 'Enter your certificate ID to verify your ExpertAims internship certificate.', 1, 'Verify Certificate | ExpertAims', 'Verify your ExpertAims internship or course certificate using the certificate ID.', 'index,follow', 'published', 999);

-- Add a section with a search form
-- This will need to be customized in the admin panel, but we can seed with basic structure
INSERT IGNORE INTO sections (page_id, type, sort, visible, heading, body)
SELECT id, 'richtext', 0, 1, 'How to Verify',
       '<p>Enter the certificate ID from your certificate below to verify its authenticity and view the details.</p><p>The certificate ID is shown at the top-right corner of your certificate (e.g., EA-DEMO-2026-0001).</p>'
FROM pages WHERE slug = 'verify-certificate' LIMIT 1;
