-- ============================================================
-- Site-wide CMS Pages + Main Navigation Menu (Migration 005)
-- Generated from WEBSITE_INFORMATION.docx (Sahel Academic Publishing)
-- Run after 001-004. Safe to re-run (uses INSERT IGNORE / ON DUPLICATE).
-- ============================================================

CREATE TABLE IF NOT EXISTS pages (
    id INT AUTO_INCREMENT PRIMARY KEY,
    slug VARCHAR(150) NOT NULL,
    title VARCHAR(255) NOT NULL,
    body LONGTEXT NULL,
    status ENUM('Active','Draft') NOT NULL DEFAULT 'Active',
    meta_description VARCHAR(300) NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    UNIQUE KEY uniq_page_slug (slug)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE IF NOT EXISTS site_menu_items (
    id INT AUTO_INCREMENT PRIMARY KEY,
    parent_id INT NULL,
    label VARCHAR(100) NOT NULL,
    link_type ENUM('page','url') NOT NULL DEFAULT 'page',
    page_slug VARCHAR(150) NULL,
    external_url VARCHAR(255) NULL,
    display_order INT NOT NULL DEFAULT 0,
    status ENUM('Active','Inactive') NOT NULL DEFAULT 'Active',
    FOREIGN KEY (parent_id) REFERENCES site_menu_items(id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ---------------- Seed pages ----------------
INSERT INTO pages (slug, title, body, status) VALUES ('about-us', 'About Us', '<p>This page is under construction. Content about &ldquo;About Us&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('about-sahel-academic-publishing', 'About Sahel Academic Publishing', '<p>This page is under construction. Content about &ldquo;About Sahel Academic Publishing&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('vision-mission-core-values', 'Vision, Mission & Core Values', '<p>This page is under construction. Content about &ldquo;Vision, Mission & Core Values&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('our-objectives', 'Our Objectives', '<p>This page is under construction. Content about &ldquo;Our Objectives&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('governance-management', 'Governance & Management', '<p>This page is under construction. Content about &ldquo;Governance & Management&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('editorial-advisory-council', 'Editorial Advisory Council', '<p>This page is under construction. Content about &ldquo;Editorial Advisory Council&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('why-publish-with-sap', 'Why Publish with SAP?', '<p>This page is under construction. Content about &ldquo;Why Publish with SAP?&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('partners-collaborations', 'Partners & Collaborations', '<p>This page is under construction. Content about &ldquo;Partners & Collaborations&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('contact-us', 'Contact Us', '<p>This page is under construction. Content about &ldquo;Contact Us&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('journals', 'Journals', '<p>This page is under construction. Content about &ldquo;Journals&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('browse-by-discipline', 'Browse by Discipline', '<p>This page is under construction. Content about &ldquo;Browse by Discipline&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('current-issues', 'Current Issues', '<p>This page is under construction. Content about &ldquo;Current Issues&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('journal-archives', 'Journal Archives', '<p>This page is under construction. Content about &ldquo;Journal Archives&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('call-for-papers', 'Call for Papers', '<p>This page is under construction. Content about &ldquo;Call for Papers&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('forthcoming-journals', 'Forthcoming Journals', '<p>This page is under construction. Content about &ldquo;Forthcoming Journals&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('book-publications', 'Book Publications', '<p>This page is under construction. Content about &ldquo;Book Publications&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('academic-books', 'Academic Books', '<p>This page is under construction. Content about &ldquo;Academic Books&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('textbooks', 'Textbooks', '<p>This page is under construction. Content about &ldquo;Textbooks&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('monographs', 'Monographs', '<p>This page is under construction. Content about &ldquo;Monographs&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('edited-volumes', 'Edited Volumes', '<p>This page is under construction. Content about &ldquo;Edited Volumes&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('conference-proceedings', 'Conference Proceedings', '<p>This page is under construction. Content about &ldquo;Conference Proceedings&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('research-reports', 'Research Reports', '<p>This page is under construction. Content about &ldquo;Research Reports&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('policy-briefs', 'Policy Briefs', '<p>This page is under construction. Content about &ldquo;Policy Briefs&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('forthcoming-titles', 'Forthcoming Titles', '<p>This page is under construction. Content about &ldquo;Forthcoming Titles&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('publish-a-book-with-sap', 'Publish a Book with SAP', '<p>This page is under construction. Content about &ldquo;Publish a Book with SAP&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('authors', 'Authors', '<p>This page is under construction. Content about &ldquo;Authors&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('author-guidelines', 'Author Guidelines', '<p>This page is under construction. Content about &ldquo;Author Guidelines&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('manuscript-preparation', 'Manuscript Preparation', '<p>This page is under construction. Content about &ldquo;Manuscript Preparation&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('how-to-submit', 'How to Submit', '<p>This page is under construction. Content about &ldquo;How to Submit&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('publication-process', 'Publication Process', '<div class="pg-flow">
  <div class="pg-flow-step"><span class="pg-flow-num">1</span><span>Submission</span></div>
  <div class="pg-flow-arrow">&rarr;</div>
  <div class="pg-flow-step"><span class="pg-flow-num">2</span><span>Initial Screening</span></div>
  <div class="pg-flow-arrow">&rarr;</div>
  <div class="pg-flow-step"><span class="pg-flow-num">3</span><span>Peer Review</span></div>
  <div class="pg-flow-arrow">&rarr;</div>
  <div class="pg-flow-step"><span class="pg-flow-num">4</span><span>Revision</span></div>
  <div class="pg-flow-arrow">&rarr;</div>
  <div class="pg-flow-step"><span class="pg-flow-num">5</span><span>Acceptance</span></div>
  <div class="pg-flow-arrow">&rarr;</div>
  <div class="pg-flow-step"><span class="pg-flow-num">6</span><span>Copy-editing &amp; Production</span></div>
  <div class="pg-flow-arrow">&rarr;</div>
  <div class="pg-flow-step"><span class="pg-flow-num">7</span><span>Online Publication</span></div>
</div>
<p>Every manuscript submitted to our journals passes through these stages. Authors can track exactly where their submission stands at any time from their dashboard.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('peer-review-process', 'Peer Review Process', '<p>This page is under construction. Content about &ldquo;Peer Review Process&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('article-processing-charges-apcs', 'Article Processing Charges (APCs)', '<p>This page is under construction. Content about &ldquo;Article Processing Charges (APCs)&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('copyright-licensing', 'Copyright & Licensing', '<p>This page is under construction. Content about &ldquo;Copyright & Licensing&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('open-access-policy', 'Open Access Policy', '<p>This page is under construction. Content about &ldquo;Open Access Policy&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('author-faqs', 'Author FAQs', '<p>This page is under construction. Content about &ldquo;Author FAQs&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('editors-reviewers', 'Editors & Reviewers', '<p>This page is under construction. Content about &ldquo;Editors & Reviewers&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('for-editors', 'For Editors', '<p>This page is under construction. Content about &ldquo;For Editors&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('for-reviewers', 'For Reviewers', '<p>This page is under construction. Content about &ldquo;For Reviewers&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('reviewer-guidelines', 'Reviewer Guidelines', '<p>This page is under construction. Content about &ldquo;Reviewer Guidelines&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('peer-review-policy', 'Peer Review Policy', '<p>This page is under construction. Content about &ldquo;Peer Review Policy&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('editorial-responsibilities', 'Editorial Responsibilities', '<p>This page is under construction. Content about &ldquo;Editorial Responsibilities&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('reviewer-responsibilities', 'Reviewer Responsibilities', '<p>This page is under construction. Content about &ldquo;Reviewer Responsibilities&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('become-a-reviewer', 'Become a Reviewer', '<p>This page is under construction. Content about &ldquo;Become a Reviewer&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('join-an-editorial-board', 'Join an Editorial Board', '<p>This page is under construction. Content about &ldquo;Join an Editorial Board&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('publication-ethics', 'Publication Ethics', '<p>This page is under construction. Content about &ldquo;Publication Ethics&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('publication-ethics-statement', 'Publication Ethics Statement', '<p>This page is under construction. Content about &ldquo;Publication Ethics Statement&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('research-integrity', 'Research Integrity', '<p>This page is under construction. Content about &ldquo;Research Integrity&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('authorship-contributorship', 'Authorship & Contributorship', '<p>This page is under construction. Content about &ldquo;Authorship & Contributorship&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('plagiarism-policy', 'Plagiarism Policy', '<p>This page is under construction. Content about &ldquo;Plagiarism Policy&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('generative-ai-policy', 'Generative AI Policy', '<p>This page is under construction. Content about &ldquo;Generative AI Policy&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('conflicts-of-interest', 'Conflicts of Interest', '<p>This page is under construction. Content about &ldquo;Conflicts of Interest&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('research-ethics-informed-consent', 'Research Ethics & Informed Consent', '<p>This page is under construction. Content about &ldquo;Research Ethics & Informed Consent&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('corrections-retractions', 'Corrections & Retractions', '<p>This page is under construction. Content about &ldquo;Corrections & Retractions&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('complaints-appeals', 'Complaints & Appeals', '<p>This page is under construction. Content about &ldquo;Complaints & Appeals&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('misconduct-investigations', 'Misconduct & Investigations', '<p>This page is under construction. Content about &ldquo;Misconduct & Investigations&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('data-reproducibility-policy', 'Data & Reproducibility Policy', '<p>This page is under construction. Content about &ldquo;Data & Reproducibility Policy&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);
INSERT INTO pages (slug, title, body, status) VALUES ('copyright-licensing-policy', 'Copyright & Licensing Policy', '<p>This page is under construction. Content about &ldquo;Copyright & Licensing Policy&rdquo; will be published here soon.</p>', 'Active') ON DUPLICATE KEY UPDATE title = VALUES(title);

-- ---------------- Seed main menu structure ----------------
INSERT INTO site_menu_items (parent_id, label, link_type, external_url, display_order) VALUES (NULL, 'Home', 'url', '../public/home.php', 10);
SET @top1 = LAST_INSERT_ID();

INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (NULL, 'About Us', 'page', 'about-us', 20);
SET @top2 = LAST_INSERT_ID();
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top2, 'About Sahel Academic Publishing', 'page', 'about-sahel-academic-publishing', 10);
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top2, 'Vision, Mission & Core Values', 'page', 'vision-mission-core-values', 20);
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top2, 'Our Objectives', 'page', 'our-objectives', 30);
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top2, 'Governance & Management', 'page', 'governance-management', 40);
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top2, 'Editorial Advisory Council', 'page', 'editorial-advisory-council', 50);
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top2, 'Why Publish with SAP?', 'page', 'why-publish-with-sap', 60);
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top2, 'Partners & Collaborations', 'page', 'partners-collaborations', 70);
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top2, 'Contact Us', 'page', 'contact-us', 80);

INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (NULL, 'Journals', 'page', 'journals', 30);
SET @top3 = LAST_INSERT_ID();
INSERT INTO site_menu_items (parent_id, label, link_type, external_url, display_order) VALUES (@top3, 'Browse All Journals', 'url', '../public/home.php', 10);
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top3, 'Browse by Discipline', 'page', 'browse-by-discipline', 20);
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top3, 'Current Issues', 'page', 'current-issues', 30);
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top3, 'Journal Archives', 'page', 'journal-archives', 40);
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top3, 'Call for Papers', 'page', 'call-for-papers', 50);
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top3, 'Forthcoming Journals', 'page', 'forthcoming-journals', 60);

INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (NULL, 'Book Publications', 'page', 'book-publications', 40);
SET @top4 = LAST_INSERT_ID();
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top4, 'Academic Books', 'page', 'academic-books', 10);
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top4, 'Textbooks', 'page', 'textbooks', 20);
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top4, 'Monographs', 'page', 'monographs', 30);
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top4, 'Edited Volumes', 'page', 'edited-volumes', 40);
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top4, 'Conference Proceedings', 'page', 'conference-proceedings', 50);
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top4, 'Research Reports', 'page', 'research-reports', 60);
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top4, 'Policy Briefs', 'page', 'policy-briefs', 70);
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top4, 'Forthcoming Titles', 'page', 'forthcoming-titles', 80);
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top4, 'Publish a Book with SAP', 'page', 'publish-a-book-with-sap', 90);

INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (NULL, 'Authors', 'page', 'authors', 50);
SET @top5 = LAST_INSERT_ID();
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top5, 'Author Guidelines', 'page', 'author-guidelines', 10);
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top5, 'Manuscript Preparation', 'page', 'manuscript-preparation', 20);
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top5, 'How to Submit', 'page', 'how-to-submit', 30);
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top5, 'Publication Process', 'page', 'publication-process', 40);
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top5, 'Peer Review Process', 'page', 'peer-review-process', 50);
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top5, 'Article Processing Charges (APCs)', 'page', 'article-processing-charges-apcs', 60);
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top5, 'Copyright & Licensing', 'page', 'copyright-licensing', 70);
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top5, 'Open Access Policy', 'page', 'open-access-policy', 80);
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top5, 'Author FAQs', 'page', 'author-faqs', 90);

INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (NULL, 'Editors & Reviewers', 'page', 'editors-reviewers', 60);
SET @top6 = LAST_INSERT_ID();
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top6, 'For Editors', 'page', 'for-editors', 10);
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top6, 'For Reviewers', 'page', 'for-reviewers', 20);
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top6, 'Reviewer Guidelines', 'page', 'reviewer-guidelines', 30);
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top6, 'Peer Review Policy', 'page', 'peer-review-policy', 40);
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top6, 'Editorial Responsibilities', 'page', 'editorial-responsibilities', 50);
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top6, 'Reviewer Responsibilities', 'page', 'reviewer-responsibilities', 60);
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top6, 'Become a Reviewer', 'page', 'become-a-reviewer', 70);
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top6, 'Join an Editorial Board', 'page', 'join-an-editorial-board', 80);

INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (NULL, 'Publication Ethics', 'page', 'publication-ethics', 70);
SET @top7 = LAST_INSERT_ID();
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top7, 'Publication Ethics Statement', 'page', 'publication-ethics-statement', 10);
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top7, 'Research Integrity', 'page', 'research-integrity', 20);
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top7, 'Authorship & Contributorship', 'page', 'authorship-contributorship', 30);
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top7, 'Plagiarism Policy', 'page', 'plagiarism-policy', 40);
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top7, 'Generative AI Policy', 'page', 'generative-ai-policy', 50);
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top7, 'Conflicts of Interest', 'page', 'conflicts-of-interest', 60);
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top7, 'Research Ethics & Informed Consent', 'page', 'research-ethics-informed-consent', 70);
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top7, 'Corrections & Retractions', 'page', 'corrections-retractions', 80);
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top7, 'Complaints & Appeals', 'page', 'complaints-appeals', 90);
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top7, 'Misconduct & Investigations', 'page', 'misconduct-investigations', 100);
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top7, 'Data & Reproducibility Policy', 'page', 'data-reproducibility-policy', 110);
INSERT INTO site_menu_items (parent_id, label, link_type, page_slug, display_order) VALUES (@top7, 'Copyright & Licensing Policy', 'page', 'copyright-licensing-policy', 120);

INSERT INTO site_menu_items (parent_id, label, link_type, external_url, display_order) VALUES (NULL, 'Submit Manuscript', 'url', '../public/submit.php', 80);
SET @top8 = LAST_INSERT_ID();