-- Restores the page/menu/submenu identifiers that the site links depend on.
-- Run this in phpMyAdmin (SQL tab, database prr_college) if pages.slug, pages.type, menu.menu_type or submenu.slug/route were regenerated from titles.
-- Only touches those columns. Page content, titles and everything else are left alone. Safe to run more than once.
-- Why it matters: a submenu link is built from the submenu slug + the page type, and must equal pages.slug + pages.type;
-- menu.menu_type decides which pages a menu lists (and special values such as student-support are read by the site code).

START TRANSACTION;

-- pages (id, slug, type)
UPDATE pages SET slug='history', type='about' WHERE id=1;
UPDATE pages SET slug='principal-s-message', type='about' WHERE id=2;
UPDATE pages SET slug='vision-and-mission', type='about' WHERE id=3;
UPDATE pages SET slug='list-of-principals', type='about' WHERE id=4;
UPDATE pages SET slug='nirf-rank-details', type='about' WHERE id=5;
UPDATE pages SET slug='aishe-certificate', type='about' WHERE id=6;
UPDATE pages SET slug='iso-certificate', type='about' WHERE id=7;
UPDATE pages SET slug='university-affiliation-certificate', type='about' WHERE id=9;
UPDATE pages SET slug='ugc-2-f-12-b', type='about' WHERE id=10;
UPDATE pages SET slug='cpe-and-autonomy-certificates', type='other' WHERE id=11;
UPDATE pages SET slug='building-layout', type='about' WHERE id=12;
UPDATE pages SET slug='staff-council', type='administration' WHERE id=13;
UPDATE pages SET slug='cpdc', type='administration' WHERE id=14;
UPDATE pages SET slug='college-committees', type='administration' WHERE id=15;
UPDATE pages SET slug='monthly-news-letter', type='administration' WHERE id=16;
UPDATE pages SET slug='alumni-meeting-reports', type='alumni' WHERE id=17;
UPDATE pages SET slug='alumni-activities-reports', type='alumni' WHERE id=18;
UPDATE pages SET slug='teaching-staff', type='administration' WHERE id=19;
UPDATE pages SET slug='nonteaching-staff', type='administration' WHERE id=20;
UPDATE pages SET slug='cadre-strength', type='administration' WHERE id=28;
UPDATE pages SET slug='organogram', type='administration' WHERE id=29;
UPDATE pages SET slug='academic-council', type='academics' WHERE id=31;
UPDATE pages SET slug='rti', type='rti' WHERE id=33;
UPDATE pages SET slug='finance', type='administration' WHERE id=34;
UPDATE pages SET slug='admin-council', type='administration' WHERE id=35;
UPDATE pages SET slug='academic-calendar', type='academics' WHERE id=36;
UPDATE pages SET slug='exam-calendars', type='academics' WHERE id=37;
UPDATE pages SET slug='academic-audit-reports', type='academics' WHERE id=38;
UPDATE pages SET slug='ug-programmes', type='academics' WHERE id=39;
UPDATE pages SET slug='pg-programmes', type='other' WHERE id=40;
UPDATE pages SET slug='certificate-courses', type='academics' WHERE id=41;
UPDATE pages SET slug='admissions-category-wise', type='academics' WHERE id=42;
UPDATE pages SET slug='master-timetable', type='academics' WHERE id=43;
UPDATE pages SET slug='program-wise-timetable', type='academics' WHERE id=44;
UPDATE pages SET slug='lecturer-wise-timetable', type='academics' WHERE id=45;
UPDATE pages SET slug='pos', type='academics' WHERE id=46;
UPDATE pages SET slug='cos', type='academics' WHERE id=47;
UPDATE pages SET slug='attainment-cos', type='academics' WHERE id=48;
UPDATE pages SET slug='lms-by-staff', type='academics' WHERE id=49;
UPDATE pages SET slug='collaborations', type='research' WHERE id=50;
UPDATE pages SET slug='research-publications', type='research' WHERE id=53;
UPDATE pages SET slug='MOUs-Linkages', type='research' WHERE id=54;
UPDATE pages SET slug='field-trips-Study', type='research' WHERE id=55;
UPDATE pages SET slug='csp-internship', type='research' WHERE id=56;
UPDATE pages SET slug='about-iqac', type='iqac' WHERE id=59;
UPDATE pages SET slug='iqac-structure', type='iqac' WHERE id=60;
UPDATE pages SET slug='iqac-vision-mission', type='iqac' WHERE id=61;
UPDATE pages SET slug='aqars', type='iqac' WHERE id=62;
UPDATE pages SET slug='accreditation-details', type='iqac' WHERE id=63;
UPDATE pages SET slug='iqac-meetings', type='iqac' WHERE id=64;
UPDATE pages SET slug='gender-sensitivity', type='best-practices' WHERE id=65;
UPDATE pages SET slug='waste-management', type='best-practices' WHERE id=66;
UPDATE pages SET slug='rain-water', type='best-practices' WHERE id=67;
UPDATE pages SET slug='green-practices', type='best-practices' WHERE id=68;
UPDATE pages SET slug='differently-abled', type='best-practices' WHERE id=69;
UPDATE pages SET slug='institution-NAAC', type='best-practices' WHERE id=71;
UPDATE pages SET slug='national-symbols', type='best-practices' WHERE id=72;
UPDATE pages SET slug='fundamental-right', type='other' WHERE id=73;
UPDATE pages SET slug='other-practices', type='best-practices' WHERE id=75;
UPDATE pages SET slug='about-examination-cell', type='examinations' WHERE id=76;
UPDATE pages SET slug='programmes-offered', type='examinations' WHERE id=77;
UPDATE pages SET slug='notifications', type='examinations' WHERE id=78;
UPDATE pages SET slug='examinations-time-tables', type='examinations' WHERE id=79;
UPDATE pages SET slug='previous-question-papers', type='examinations' WHERE id=80;
UPDATE pages SET slug='circulars', type='examinations' WHERE id=83;
UPDATE pages SET slug='contact', type='contact' WHERE id=85;
UPDATE pages SET slug='bharat-padhe-online', type='other' WHERE id=86;
UPDATE pages SET slug='ugc-guidelines-on-cbcs', type='other' WHERE id=87;
UPDATE pages SET slug='cbcs-pattern', type='other' WHERE id=88;
UPDATE pages SET slug='credit-and-grading-system', type='other' WHERE id=89;
UPDATE pages SET slug='smp-guidelines', type='other' WHERE id=90;
UPDATE pages SET slug='library-staff', type='other' WHERE id=91;
UPDATE pages SET slug='newsletters', type='other' WHERE id=92;
UPDATE pages SET slug='incubation-center-activities', type='other' WHERE id=93;
UPDATE pages SET slug='academic-audit-reports', type='academics' WHERE id=94;
UPDATE pages SET slug='psos', type='academics' WHERE id=95;
UPDATE pages SET slug='community-service-project', type='community' WHERE id=96;
UPDATE pages SET slug='nirf', type='nirf' WHERE id=97;
UPDATE pages SET slug='naac', type='naac' WHERE id=98;
UPDATE pages SET slug='central-library', type='central-library' WHERE id=99;
UPDATE pages SET slug='e-resources', type='central-library' WHERE id=100;
UPDATE pages SET slug='e-materials', type='central-library' WHERE id=101;
UPDATE pages SET slug='physical-education', type='physical-education' WHERE id=102;
UPDATE pages SET slug='ssr', type='naac' WHERE id=103;
UPDATE pages SET slug='criterion-6', type='naac' WHERE id=109;
UPDATE pages SET slug='criterion-7', type='naac' WHERE id=110;
UPDATE pages SET slug='miscellaneous', type='naac' WHERE id=111;
UPDATE pages SET slug='criterion-1', type='naac' WHERE id=112;
UPDATE pages SET slug='criterion-2', type='naac' WHERE id=113;
UPDATE pages SET slug='criterion-3', type='naac' WHERE id=114;
UPDATE pages SET slug='criterion-4', type='naac' WHERE id=115;
UPDATE pages SET slug='criterion-5', type='naac' WHERE id=116;
UPDATE pages SET slug='publications', type='central-library' WHERE id=117;
UPDATE pages SET slug='librarian-profile', type='central-library' WHERE id=118;
UPDATE pages SET slug='institutional-plans', type='iqac' WHERE id=119;
UPDATE pages SET slug='annual-reports', type='iqac' WHERE id=120;
UPDATE pages SET slug='strategic-plan-document', type='iqac' WHERE id=121;
UPDATE pages SET slug='asar-aadpi', type='iqac' WHERE id=122;
UPDATE pages SET slug='feedback', type='feedback' WHERE id=123;
UPDATE pages SET slug='naac-ssr', type='naac-ssr' WHERE id=124;
UPDATE pages SET slug='aqars-2024-25', type='iqac' WHERE id=125;
UPDATE pages SET slug='aqars-2023-24', type='iqac' WHERE id=126;
UPDATE pages SET slug='aqars-2022-23', type='iqac' WHERE id=127;

-- menu (menu_type)
UPDATE menu SET menu_type='home' WHERE id=1;
UPDATE menu SET menu_type='about' WHERE id=2;
UPDATE menu SET menu_type='academics' WHERE id=3;
UPDATE menu SET menu_type='administration' WHERE id=4;
UPDATE menu SET menu_type='departments' WHERE id=5;
UPDATE menu SET menu_type='infrastructure' WHERE id=6;
UPDATE menu SET menu_type='research' WHERE id=7;
UPDATE menu SET menu_type='student-support' WHERE id=8;
UPDATE menu SET menu_type='iqac' WHERE id=9;
UPDATE menu SET menu_type='naac' WHERE id=10;
UPDATE menu SET menu_type='examinations' WHERE id=11;
UPDATE menu SET menu_type='best-practices' WHERE id=12;
UPDATE menu SET menu_type='gallery' WHERE id=13;
UPDATE menu SET menu_type='rti' WHERE id=14;
UPDATE menu SET menu_type='alumni' WHERE id=15;
UPDATE menu SET menu_type='contact' WHERE id=16;
UPDATE menu SET menu_type='naac-ssr' WHERE id=17;

-- submenu (slug, route)
UPDATE submenu SET slug='history', route='' WHERE id=1;
UPDATE submenu SET slug='vision-and-mission', route='' WHERE id=2;
UPDATE submenu SET slug='principal-s-message', route='' WHERE id=3;
UPDATE submenu SET slug='list-of-principals', route='' WHERE id=4;
UPDATE submenu SET slug='aishe-certificate', route='' WHERE id=5;
UPDATE submenu SET slug='iso-certificate', route='' WHERE id=6;
UPDATE submenu SET slug='nirf-rank-details', route='' WHERE id=7;
UPDATE submenu SET slug='university-affiliation-certificate', route='' WHERE id=8;
UPDATE submenu SET slug='ugc-2-f-12-b', route='' WHERE id=9;
UPDATE submenu SET slug=NULL, route='' WHERE id=10;
UPDATE submenu SET slug='building-layout', route='' WHERE id=11;
UPDATE submenu SET slug='academic-council', route='' WHERE id=12;
UPDATE submenu SET slug='academic-calendar', route='' WHERE id=13;
UPDATE submenu SET slug='exam-calendars', route='' WHERE id=14;
UPDATE submenu SET slug='academic-audit-reports', route='' WHERE id=15;
UPDATE submenu SET slug=NULL, route='' WHERE id=16;
UPDATE submenu SET slug='ug-programmes', route='' WHERE id=17;
UPDATE submenu SET slug='certificate-courses', route='' WHERE id=18;
UPDATE submenu SET slug='admissions-category-wise', route='' WHERE id=19;
UPDATE submenu SET slug=NULL, route='' WHERE id=20;
UPDATE submenu SET slug='master-timetable', route='' WHERE id=21;
UPDATE submenu SET slug='program-wise-timetable', route='' WHERE id=22;
UPDATE submenu SET slug='lecturer-wise-timetable', route='' WHERE id=23;
UPDATE submenu SET slug=NULL, route='' WHERE id=24;
UPDATE submenu SET slug='cos', route='' WHERE id=25;
UPDATE submenu SET slug='pos', route='' WHERE id=26;
UPDATE submenu SET slug='psos', route='' WHERE id=27;
UPDATE submenu SET slug='attainment-cos', route='' WHERE id=28;
UPDATE submenu SET slug='lms-by-staff', route='' WHERE id=29;
UPDATE submenu SET slug=NULL, route='' WHERE id=30;
UPDATE submenu SET slug='teaching-staff', route='' WHERE id=31;
UPDATE submenu SET slug='nonteaching-staff', route='' WHERE id=32;
UPDATE submenu SET slug='cadre-strength', route='' WHERE id=33;
UPDATE submenu SET slug=NULL, route='' WHERE id=34;
UPDATE submenu SET slug='organogram', route='' WHERE id=35;
UPDATE submenu SET slug='admin-council', route='' WHERE id=36;
UPDATE submenu SET slug='finance', route='' WHERE id=37;
UPDATE submenu SET slug='staff-council', route='' WHERE id=38;
UPDATE submenu SET slug='cpdc', route='' WHERE id=39;
UPDATE submenu SET slug='college-committees', route='' WHERE id=40;
UPDATE submenu SET slug='monthly-news-letter', route='' WHERE id=41;
UPDATE submenu SET slug='collaborations', route='' WHERE id=42;
UPDATE submenu SET slug='research-publications', route='' WHERE id=43;
UPDATE submenu SET slug='MOUs-Linkages', route='' WHERE id=44;
UPDATE submenu SET slug='field-trips-Study', route='' WHERE id=45;
UPDATE submenu SET slug='csp-internship', route='' WHERE id=46;
UPDATE submenu SET slug='about-iqac', route='' WHERE id=47;
UPDATE submenu SET slug='iqac-structure', route='' WHERE id=48;
UPDATE submenu SET slug='iqac-vision-mission', route='' WHERE id=49;
UPDATE submenu SET slug=NULL, route='' WHERE id=50;
UPDATE submenu SET slug='aqars', route='' WHERE id=51;
UPDATE submenu SET slug='aqars-2022-23', route='' WHERE id=52;
UPDATE submenu SET slug='aqars-2023-24', route='' WHERE id=53;
UPDATE submenu SET slug='aqars-2024-25', route='' WHERE id=54;
UPDATE submenu SET slug='accreditation-details', route='' WHERE id=55;
UPDATE submenu SET slug='institutional-plans', route='' WHERE id=56;
UPDATE submenu SET slug='annual-reports', route='' WHERE id=57;
UPDATE submenu SET slug='strategic-plan-document', route='' WHERE id=58;
UPDATE submenu SET slug='asar-aadpi', route='' WHERE id=59;
UPDATE submenu SET slug='iqac-meetings', route='' WHERE id=60;
UPDATE submenu SET slug='naac', route='' WHERE id=61;
UPDATE submenu SET slug='ssr', route='' WHERE id=62;
UPDATE submenu SET slug=NULL, route='' WHERE id=63;
UPDATE submenu SET slug='criterion-1', route='' WHERE id=64;
UPDATE submenu SET slug='criterion-2', route='' WHERE id=65;
UPDATE submenu SET slug='criterion-3', route='' WHERE id=66;
UPDATE submenu SET slug='criterion-4', route='' WHERE id=67;
UPDATE submenu SET slug='criterion-5', route='' WHERE id=68;
UPDATE submenu SET slug='criterion-6', route='' WHERE id=69;
UPDATE submenu SET slug='criterion-7', route='' WHERE id=70;
UPDATE submenu SET slug='miscellaneous', route='' WHERE id=71;
UPDATE submenu SET slug='about-examination-cell', route='' WHERE id=72;
UPDATE submenu SET slug='programmes-offered', route='' WHERE id=73;
UPDATE submenu SET slug='notifications', route='' WHERE id=74;
UPDATE submenu SET slug='examinations-time-tables', route='' WHERE id=75;
UPDATE submenu SET slug='previous-question-papers', route='' WHERE id=76;
UPDATE submenu SET slug='circulars', route='' WHERE id=77;
UPDATE submenu SET slug='gender-sensitivity', route='' WHERE id=78;
UPDATE submenu SET slug='rain-water', route='' WHERE id=79;
UPDATE submenu SET slug='green-practices', route='' WHERE id=80;
UPDATE submenu SET slug='differently-abled', route='' WHERE id=81;
UPDATE submenu SET slug='institution-NAAC', route='' WHERE id=82;
UPDATE submenu SET slug='national-symbols', route='' WHERE id=83;
UPDATE submenu SET slug='other-practices', route='' WHERE id=84;
UPDATE submenu SET slug='press-clippings', route='press' WHERE id=85;
UPDATE submenu SET slug='photo-gallery', route='gallery' WHERE id=86;
UPDATE submenu SET slug='videos', route='video' WHERE id=87;
UPDATE submenu SET slug='alumni-meeting-reports', route='' WHERE id=88;
UPDATE submenu SET slug='alumni-activities-reports', route='' WHERE id=89;

COMMIT;