File Manager

X7ROOT File Manager

Current Path: /home/u126090504/domains/saiadarshainternationalschool.org.in/public_html

home / u126090504 / domains / saiadarshainternationalschool.org.in / public_html /

📁 ..
📄 .htaccess(0 B)
📄 Antiraging-Cell.php(2.73 KB)
📄 SVM-INT (1) (1).zip(117.51 MB)
📄 about-us.php(5.86 KB)
📄 academic-calendar.php(2.73 KB)
📄 achievements.php(9.56 KB)
📄 achievers.php(15.19 KB)
📁 admin
📄 admission-process.php(6.85 KB)
📄 admission.php(12.93 KB)
📄 admission_submit.php(3.38 KB)
📄 album.php(890 B)
📄 assessment-policy.php(6.8 KB)
📄 cbse-curriculum-summary.php(5.99 KB)
📄 computer-courses.php(22.83 KB)
📄 config.php(1.27 KB)
📄 contact-us.php(14.63 KB)
📄 contactdb.php(796 B)
📄 courses.php(10.44 KB)
📁 css
📄 director's-message.php(6.54 KB)
📄 downloads.php(2.9 KB)
📄 error.log(14.6 KB)
📄 facilities.php(6.04 KB)
📄 faculty.php(10.27 KB)
📄 fee-structure.php(7.97 KB)
📁 fonts
📄 footer.php(23.95 KB)
📄 franchise.php(2.09 KB)
📄 gallery.php(3.05 KB)
📄 google929b505e9f42f894.html(53 B)
📄 grievance-form.php(16.52 KB)
📄 header.php(19.69 KB)
📄 homework.php(9.64 KB)
📁 images
📄 index.php(39.38 KB)
📄 infrastructure-details.php(5.39 KB)
📁 js
📁 lib
📄 managing-committee.php(3.34 KB)
📄 media-corner.php(2.48 KB)
📄 non-academic-achievers.php(14.65 KB)
📄 payment.php(21.85 KB)
📄 payment_submit.php(15.1 KB)
📄 payment_verify.php(2.31 KB)
📄 placement.php(8.33 KB)
📄 principal's-message.php(6.65 KB)
📄 public-disclosure.php(3.38 KB)
📁 qrcodes
📁 revolution
📁 sai
📄 scope.php(14.14 KB)
📄 search_videos.php(1.76 KB)
📄 sitemap.xml(4.69 KB)
📄 subjects-offered.php(6 KB)
📄 submit-grievance.php(3.88 KB)
📁 svm
📄 thank-you.php(1.28 KB)
📄 u126090504_svmint.sql(40.87 KB)
📁 uploads
📄 videos.php(6.87 KB)

Editing: u126090504_svmint.sql

-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Jan 17, 2026 at 11:57 AM
-- Server version: 11.8.3-MariaDB-log
-- PHP Version: 7.2.34

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `u126090504_svmint`
--

-- --------------------------------------------------------

--
-- Table structure for table `academic_calendars`
--

CREATE TABLE `academic_calendars` (
  `id` int(10) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `academic_year` varchar(32) NOT NULL,
  `file_path` varchar(500) NOT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

-- --------------------------------------------------------

--
-- Table structure for table `achievements`
--

CREATE TABLE `achievements` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `category` enum('award','competition','alumni') NOT NULL,
  `sub_title` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `event_date` date DEFAULT NULL,
  `image_path` varchar(255) DEFAULT NULL,
  `external_link` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `display_order` int(11) NOT NULL DEFAULT 0,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `category_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

-- --------------------------------------------------------

--
-- Table structure for table `achievement_categories`
--

CREATE TABLE `achievement_categories` (
  `id` int(11) NOT NULL,
  `name` varchar(120) NOT NULL,
  `slug` varchar(140) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `display_order` int(11) NOT NULL DEFAULT 0,
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

--
-- Dumping data for table `achievement_categories`
--

INSERT INTO `achievement_categories` (`id`, `name`, `slug`, `is_active`, `display_order`, `created_at`) VALUES
(6, 'SPORTS', 'KABADDI', 1, 0, '2025-11-10 06:48:21');

-- --------------------------------------------------------

--
-- Table structure for table `admissions`
--

CREATE TABLE `admissions` (
  `id` int(10) UNSIGNED NOT NULL,
  `student_name` varchar(150) DEFAULT NULL,
  `father_name` varchar(150) DEFAULT NULL,
  `mother_name` varchar(150) DEFAULT NULL,
  `class` varchar(50) DEFAULT NULL,
  `sex` varchar(10) DEFAULT NULL,
  `caste` varchar(20) DEFAULT NULL,
  `blood_group` varchar(5) DEFAULT NULL,
  `aadhaar` varchar(12) DEFAULT NULL,
  `mobile` varchar(10) DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `age_years` varchar(10) DEFAULT NULL,
  `photo_path` varchar(255) DEFAULT NULL,
  `consent` tinyint(1) DEFAULT 0,
  `school_name` varchar(200) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `created_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `admissions`
--

INSERT INTO `admissions` (`id`, `student_name`, `father_name`, `mother_name`, `class`, `sex`, `caste`, `blood_group`, `aadhaar`, `mobile`, `dob`, `age_years`, `photo_path`, `consent`, `school_name`, `notes`, `created_at`) VALUES
(16, 'SUBRAT', 'SK', 'Hemalata', 'STD-VIII', 'Male', 'GENERAL', 'A+', '216413161882', '8658880550', '2005-07-07', '20 years', 'uploads/students/2025/11/subrat-063740-83796e.png', 1, 'MPS', 'Urgent Admissions', '2025-11-10 06:37:40'),
(17, 'Pankaj Sahoo', 'khkhkjh', 'RUNU', 'STD-VI', 'Female', 'SC', 'A-', '121212121212', '9861845796', '2024-01-09', '2 years', 'uploads/students/2026/01/pankaj-sahoo-124315-c7388b.png', 1, 'Fulbani', 'bbjkbkbkb', '2026-01-09 12:43:15'),
(18, 'Ayushman Asutosh Nayak', 'Hemanta Nayak', 'Kumudini Nayak', 'Integrated Coaching – XI', 'Male', 'ST', 'O+', '881265840763', '9170085587', '2009-05-27', '16 years', 'uploads/students/2026/01/ayushman-asutosh-nayak-080000-f26233.jpg', 1, 'St Mary\'s school Barbil', '', '2026-01-17 08:00:00');

-- --------------------------------------------------------

--
-- Table structure for table `albums`
--

CREATE TABLE `albums` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `albums`
--

INSERT INTO `albums` (`id`, `name`, `description`, `created_at`) VALUES
(33, 'Campus Activity', '', '2026-01-09 14:50:34'),
(34, 'CLASS ROOM', '', '2026-01-13 07:07:51'),
(35, 'GANESH PUJA', '', '2026-01-13 07:08:03');

-- --------------------------------------------------------

--
-- Table structure for table `bannertab`
--

CREATE TABLE `bannertab` (
  `id` int(11) NOT NULL,
  `imgfile` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `position` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `bannertab`
--

INSERT INTO `bannertab` (`id`, `imgfile`, `created_at`, `position`) VALUES
(44, '1767854444_62bb263d.jpg', '2026-01-08 06:40:44', 1),
(45, '1767854457_74f01296.jpg', '2026-01-08 06:40:57', 2),
(46, '1767854830_ee649a69.jpg', '2026-01-08 06:47:10', 3),
(47, '1767860021_4d8b38e9.jpg', '2026-01-08 08:13:41', 4);

-- --------------------------------------------------------

--
-- Table structure for table `classes`
--

CREATE TABLE `classes` (
  `id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `classes`
--

INSERT INTO `classes` (`id`, `name`) VALUES
(12, 'Class - 1');

-- --------------------------------------------------------

--
-- Table structure for table `class_result_files`
--

CREATE TABLE `class_result_files` (
  `id` int(11) NOT NULL,
  `exam_id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `section_id` int(11) DEFAULT NULL,
  `file_path` varchar(255) NOT NULL,
  `uploaded_at` timestamp NULL DEFAULT current_timestamp(),
  `section_key` int(11) GENERATED ALWAYS AS (ifnull(`section_id`,0)) STORED
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

--
-- Triggers `class_result_files`
--
DELIMITER $$
CREATE TRIGGER `trg_crf_bi` BEFORE INSERT ON `class_result_files` FOR EACH ROW BEGIN
  SET NEW.section_key = IFNULL(NEW.section_id,0);
END
$$
DELIMITER ;
DELIMITER $$
CREATE TRIGGER `trg_crf_bu` BEFORE UPDATE ON `class_result_files` FOR EACH ROW BEGIN
  SET NEW.section_key = IFNULL(NEW.section_id,0);
END
$$
DELIMITER ;

-- --------------------------------------------------------

--
-- Table structure for table `contacttab`
--

CREATE TABLE `contacttab` (
  `id` int(11) NOT NULL,
  `coname` varchar(150) NOT NULL,
  `coemail` varchar(150) NOT NULL,
  `cosub` varchar(255) NOT NULL,
  `cophone` varchar(50) DEFAULT NULL,
  `comes` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `contacttab`
--

INSERT INTO `contacttab` (`id`, `coname`, `coemail`, `cosub`, `cophone`, `comes`, `created_at`) VALUES
(12, 'ram charam murmu', 'gopimurmu123@gmail.com', 'admission', '9777270312', 'contact to admission', '2026-01-13 07:13:49');

-- --------------------------------------------------------

--
-- Table structure for table `downloads`
--

CREATE TABLE `downloads` (
  `id` int(11) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `uploaded_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `downloads`
--

INSERT INTO `downloads` (`id`, `subject`, `file_name`, `uploaded_at`) VALUES
(26, 'sylabussy', '1768289196_7d16c11b98.pdf', '2026-01-13 07:26:36');

-- --------------------------------------------------------

--
-- Table structure for table `faculty`
--

CREATE TABLE `faculty` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `designation` varchar(150) NOT NULL,
  `qualification` varchar(150) NOT NULL,
  `specialization` varchar(255) DEFAULT NULL,
  `experience` varchar(100) NOT NULL,
  `photo` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `position` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `fboard`
--

CREATE TABLE `fboard` (
  `id` int(11) NOT NULL,
  `fname` varchar(150) NOT NULL,
  `des` varchar(150) NOT NULL,
  `exp` varchar(150) DEFAULT NULL,
  `marks_pct` decimal(5,2) DEFAULT NULL,
  `qual` varchar(150) DEFAULT NULL,
  `fimg` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `status` enum('active','inactive') NOT NULL DEFAULT 'active'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `fee_documents`
--

CREATE TABLE `fee_documents` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `file_path` varchar(255) NOT NULL,
  `file_type` enum('pdf','image') NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `display_order` int(11) NOT NULL DEFAULT 0,
  `uploaded_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

-- --------------------------------------------------------

--
-- Table structure for table `franchise`
--

CREATE TABLE `franchise` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `address` text NOT NULL,
  `center` varchar(255) NOT NULL,
  `mob` varchar(50) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `governing_body_members`
--

CREATE TABLE `governing_body_members` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(150) NOT NULL,
  `designation` varchar(150) NOT NULL,
  `role_responsibility` text NOT NULL,
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

-- --------------------------------------------------------

--
-- Table structure for table `grievances`
--

CREATE TABLE `grievances` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tracking_id` varchar(32) NOT NULL,
  `name` varchar(120) NOT NULL,
  `student_id` varchar(60) DEFAULT NULL,
  `department` varchar(120) DEFAULT NULL,
  `course` varchar(50) DEFAULT NULL,
  `year_of_study` tinyint(3) UNSIGNED DEFAULT NULL,
  `contact` varchar(20) DEFAULT NULL,
  `email` varchar(160) NOT NULL,
  `hostel_resident` enum('Yes','No') DEFAULT 'No',
  `preferred_response` enum('Email','Phone','In-person') DEFAULT 'Email',
  `category` varchar(40) NOT NULL,
  `sub_category` varchar(60) DEFAULT NULL,
  `date_incident` date DEFAULT NULL,
  `time_incident` time DEFAULT NULL,
  `location` varchar(160) DEFAULT NULL,
  `persons_involved` varchar(255) DEFAULT NULL,
  `is_confidential` tinyint(1) DEFAULT 0,
  `impact_level` enum('Low','Medium','High') DEFAULT 'Low',
  `expected_resolution` enum('1 week','2 weeks','1 month') DEFAULT '2 weeks',
  `description` text NOT NULL,
  `previous_attempts` text DEFAULT NULL,
  `desired_outcome` text DEFAULT NULL,
  `meet_committee` enum('Yes','No') DEFAULT 'No',
  `files_json` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`files_json`)),
  `status` enum('Pending','Under Review','Action Taken','Resolved') DEFAULT 'Pending',
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `grievances`
--

INSERT INTO `grievances` (`id`, `tracking_id`, `name`, `student_id`, `department`, `course`, `year_of_study`, `contact`, `email`, `hostel_resident`, `preferred_response`, `category`, `sub_category`, `date_incident`, `time_incident`, `location`, `persons_involved`, `is_confidential`, `impact_level`, `expected_resolution`, `description`, `previous_attempts`, `desired_outcome`, `meet_committee`, `files_json`, `status`, `created_at`, `updated_at`) VALUES
(5, 'GRV-696105de2a950', 'Pankaj Sahoo', 'CST123', '', 'LKG', 0, '1234567898', 'contact.pankaj37@gmail.com', 'No', '', 'Academic', 'Syllabus', '2026-01-09', '19:12:00', 'Classroom', 'Teacher', 1, 'High', '1 week', 'sasasasasas', 'aasssas', 'asasasasasasasasas', 'Yes', '[\"GRV-696105de2a950_696105de2aadc.jpg\"]', '', '2026-01-09 13:42:54', '2026-01-09 13:44:08'),
(6, 'GRV-6965f18fb48b5', 'JYOTI PRAKHASH MADHUAL', '151', '', 'STD-II', 0, '9777270312', 'madhusmitasahu2017@gmail.com', 'No', '', 'Teacher Behaviour', 'Rude Behaviour', '2026-01-12', '12:46:00', 'Classroom', 'teacher', 1, 'High', '1 week', 'dhdhdhdghdghdhgdghdghdhgdhgd', '', 'fhhjfhjfjfjh', 'Yes', '[\"GRV-6965f18fb48b5_6965f18fb490c.jpeg\"]', '', '2026-01-13 07:17:35', '2026-01-13 07:18:18');

-- --------------------------------------------------------

--
-- Table structure for table `homework`
--

CREATE TABLE `homework` (
  `id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `section_id` int(11) DEFAULT NULL,
  `subject_id` int(11) NOT NULL,
  `title` varchar(120) NOT NULL,
  `description` text NOT NULL,
  `assign_date` date NOT NULL,
  `due_date` date DEFAULT NULL,
  `file_path` varchar(255) DEFAULT NULL,
  `teacher_name` varchar(80) DEFAULT NULL,
  `status` enum('active','archived','deleted') DEFAULT 'active',
  `created_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `homework`
--

INSERT INTO `homework` (`id`, `class_id`, `section_id`, `subject_id`, `title`, `description`, `assign_date`, `due_date`, `file_path`, `teacher_name`, `status`, `created_by`, `created_at`, `updated_at`) VALUES
(8, 10, 18, 20, 'Number System', 'pk', '2025-11-10', '2025-11-12', 'uploads/homework/hw_1762756057_45eb9c6d.pdf', 'Sk Ratha', 'deleted', NULL, '2025-11-10 06:27:37', '2026-01-09 14:33:20'),
(9, 11, 19, 21, 'pk', 'UBUBUYBUYBUBUBUBUBUB', '2025-11-11', '2025-11-12', 'uploads/homework/hw_1762845563_d60c5d65.jpg', 'SIMA', 'deleted', NULL, '2025-11-11 07:19:23', '2026-01-09 14:33:40'),
(10, 12, 20, 22, 'my school', 'jfjhjfhjfjhfjfjfjf', '2026-01-13', '2026-01-14', 'uploads/homework/hw_1768287426_39088907.pdf', 'Ram', 'active', NULL, '2026-01-13 06:57:06', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `media_corner`
--

CREATE TABLE `media_corner` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `nboard`
--

CREATE TABLE `nboard` (
  `id` int(11) NOT NULL,
  `date` date NOT NULL,
  `ntext` varchar(255) NOT NULL,
  `nurl` varchar(255) DEFAULT NULL,
  `nurl1` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `nboard`
--

INSERT INTO `nboard` (`id`, `date`, `ntext`, `nurl`, `nurl1`, `is_active`, `created_at`) VALUES
(32, '2026-01-08', 'Sai Vidya Mandir International School of CBSE', '1767858008_468a089ebe.jpg', '', 1, '2026-01-08 07:40:08'),
(33, '2026-01-08', 'Admission Open For 2026 Session', '1767858050_af2c6c4eb4.jpg', '', 1, '2026-01-08 07:40:50'),
(34, '2026-01-13', 'Admission Open For 2026-2027 Session', '', 'https://svminternationalschool.in/admission.php', 1, '2026-01-13 07:19:15');

--
-- Triggers `nboard`
--
DELIMITER $$
CREATE TRIGGER `trg_nboard_ai` AFTER INSERT ON `nboard` FOR EACH ROW BEGIN
  INSERT IGNORE INTO push_outbox(source,record_id,title,body,url)
  VALUES(
    'nboard', NEW.id,
    'New Update',
    COALESCE(NULLIF(NEW.ntext,''),'A new update has been posted'),
    CASE
      WHEN NEW.nurl IS NOT NULL AND NEW.nurl <> '' THEN NEW.nurl
      WHEN NEW.nurl1 IS NOT NULL AND NEW.nurl1 <> '' THEN NEW.nurl1
      ELSE '/'
    END
  );
END
$$
DELIMITER ;

-- --------------------------------------------------------

--
-- Table structure for table `notices`
--

CREATE TABLE `notices` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `url` varchar(500) DEFAULT NULL,
  `starts_on` date DEFAULT NULL,
  `ends_on` date DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `file_path` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

--
-- Dumping data for table `notices`
--

INSERT INTO `notices` (`id`, `title`, `url`, `starts_on`, `ends_on`, `is_active`, `created_at`, `file_path`) VALUES
(32, 'Admission Open 2026', '', '2026-01-08', '2026-01-10', 1, '2026-01-08 07:41:58', '/uploads/notices/bnr1_1016d1cb.jpg');

-- --------------------------------------------------------

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` int(10) UNSIGNED NOT NULL,
  `title` varchar(150) NOT NULL,
  `body` varchar(300) NOT NULL,
  `click_url` varchar(500) DEFAULT NULL,
  `image_url` varchar(500) DEFAULT NULL,
  `sent_count` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

-- --------------------------------------------------------

--
-- Table structure for table `n_achievers`
--

CREATE TABLE `n_achievers` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(150) NOT NULL,
  `activity` varchar(150) NOT NULL,
  `achievement` varchar(150) NOT NULL,
  `session_year` varchar(30) NOT NULL,
  `org` varchar(200) DEFAULT NULL,
  `photo` varchar(200) DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

-- --------------------------------------------------------

--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `id` int(11) NOT NULL,
  `student_name` varchar(100) NOT NULL,
  `father_name` varchar(100) DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `age` varchar(20) DEFAULT NULL,
  `school` varchar(150) DEFAULT NULL,
  `course` varchar(100) DEFAULT NULL,
  `mobile` varchar(15) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `rollno` varchar(50) DEFAULT NULL,
  `payment_type` enum('Admission Fee','Tuition Fee') NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `status` enum('Pending','Paid','Failed','Cancelled') NOT NULL DEFAULT 'Pending',
  `transaction_id` varchar(100) DEFAULT NULL,
  `payment_mode` varchar(50) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `mother_name` varchar(100) DEFAULT NULL,
  `sex` enum('Male','Female','Other') DEFAULT NULL,
  `caste` enum('SC','ST','OBC','GENERAL') DEFAULT NULL,
  `blood_group` enum('A+','A-','B+','B-','AB+','AB-','O+','O-','Unknown') DEFAULT NULL,
  `aadhaar` varchar(20) DEFAULT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `class` varchar(50) DEFAULT NULL,
  `tuition_class` varchar(50) DEFAULT NULL,
  `tuition_section` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `payments`
--

INSERT INTO `payments` (`id`, `student_name`, `father_name`, `dob`, `age`, `school`, `course`, `mobile`, `address`, `rollno`, `payment_type`, `amount`, `status`, `transaction_id`, `payment_mode`, `created_at`, `mother_name`, `sex`, `caste`, `blood_group`, `aadhaar`, `photo`, `class`, `tuition_class`, `tuition_section`) VALUES
(113, 'SUBRAT', '', '0000-00-00', '', '', '', '', '', '4560', 'Tuition Fee', 55.00, 'Paid', '67789809000000000000', 'PhonePe', '2025-11-10 06:29:24', '', '', '', '', '', NULL, '', 'STD-I', 'A'),
(114, 'Pankaj', '', '0000-00-00', '', '', '', '', '', 'lhlihkllkhl', 'Tuition Fee', 52.00, 'Paid', NULL, 'tuition', '2025-11-11 07:12:25', '', '', '', '', '', NULL, '', 'PLAY GROUP', 'A'),
(115, 'Pankaj', 'Monaj', '2021-02-02', '4 years', 'assas', '', '2122121212', 'IUUIBUBUBBUB', '', 'Admission Fee', 101.00, 'Paid', 'DDFDFD', 'PhonePe', '2025-11-11 07:22:09', 'DFSDF', 'Male', 'SC', 'A+', '123123123123', 'uploads/students/stu_20251111_072209_5d681fc3.jpg', 'Montessori-III', '', ''),
(116, 'Pankaj', '', '0000-00-00', '', '', '', '', '', 'Xav124', 'Tuition Fee', 6.00, 'Pending', NULL, 'tuition', '2025-11-11 07:29:37', '', '', '', '', '', NULL, '', 'Montessori-I', 'A'),
(117, 'Pk', '', '0000-00-00', '', '', '', '', '', 'Rrcc', 'Tuition Fee', 5.00, 'Paid', NULL, 'tuition', '2025-11-11 07:35:38', '', '', '', '', '', NULL, '', 'Montessori-II', 'A'),
(118, 'Dibyasha Pattanayak', '', '0000-00-00', '', '', '', '', '', '4', 'Tuition Fee', 1000.00, 'Pending', NULL, 'tuition', '2025-11-11 17:19:38', '', '', '', '', '', NULL, '', 'STD-VII', 'A'),
(119, 'jay', '', '0000-00-00', '', '', '', '', '', '15', 'Tuition Fee', 500.00, 'Pending', NULL, 'tuition', '2025-12-03 12:23:14', '', '', '', '', '', NULL, '', 'Montessori-II', 'A'),
(120, 'Pankaj Sahoo', 'MOnaj', '2025-01-09', '1 years', 'jjkg', '', '9861845796', 'asasasas', '', 'Admission Fee', 1201.00, 'Paid', NULL, 'new', '2026-01-09 13:10:33', 'RUNU', 'Male', 'SC', 'AB+', '121212121212', 'uploads/students/stu_20260109_131033_1cd14049.png', 'Integrated Coaching – IX', '', ''),
(121, 'Pankaj Sahoo', '', '0000-00-00', '', '', '', '', '', 'hghh', 'Tuition Fee', 51.00, 'Paid', NULL, 'tuition', '2026-01-09 13:20:39', '', '', '', '', '', NULL, '', 'STD-I', 'A'),
(122, 'JYOTI PRAKHASH MADHUAL', 'Bhajanlal mohanta', '2000-06-15', '25 years', 'NEW ADMISSION', '', '9777270312', 'AT/PO/PS-RAIRANGPUR', '', 'Admission Fee', 101.00, 'Paid', NULL, 'new', '2026-01-13 07:03:08', 'Minati mohanta', 'Male', 'GENERAL', 'AB+', '775012518592', 'uploads/students/stu_20260113_070308_77fd5bc9.jpg', 'Integrated Coaching – XII', '', '');

--
-- Triggers `payments`
--
DELIMITER $$
CREATE TRIGGER `payments_force_pending` BEFORE INSERT ON `payments` FOR EACH ROW BEGIN
  SET NEW.status = 'Pending';
  -- Aadhaar: keep only digits and trim to 12
  IF NEW.aadhaar IS NOT NULL THEN
    SET NEW.aadhaar = REGEXP_REPLACE(NEW.aadhaar, '[^0-9]', '');
    IF CHAR_LENGTH(NEW.aadhaar) > 12 THEN
      SET NEW.aadhaar = LEFT(NEW.aadhaar, 12);
    END IF;
  END IF;
END
$$
DELIMITER ;
DELIMITER $$
CREATE TRIGGER `payments_sanitize_update` BEFORE UPDATE ON `payments` FOR EACH ROW BEGIN
  -- Aadhaar sanitize on update as well
  IF NEW.aadhaar IS NOT NULL THEN
    SET NEW.aadhaar = REGEXP_REPLACE(NEW.aadhaar, '[^0-9]', '');
    IF CHAR_LENGTH(NEW.aadhaar) > 12 THEN
      SET NEW.aadhaar = LEFT(NEW.aadhaar, 12);
    END IF;
  END IF;
END
$$
DELIMITER ;

-- --------------------------------------------------------

--
-- Table structure for table `photos`
--

CREATE TABLE `photos` (
  `id` int(11) NOT NULL,
  `album_id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `filename` varchar(255) NOT NULL,
  `uploaded_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `popup_banner`
--

CREATE TABLE `popup_banner` (
  `id` int(11) NOT NULL,
  `image` varchar(255) NOT NULL,
  `link` varchar(255) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `status` tinyint(1) DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `popup_banner`
--

INSERT INTO `popup_banner` (`id`, `image`, `link`, `start_date`, `end_date`, `status`, `created_at`) VALUES
(11, '1768027285_903aae02b5.jpg', 'https://svminternationalschool.in/admission.php', '2026-01-10', '2026-01-24', 1, '2026-01-10 06:35:26');

-- --------------------------------------------------------

--
-- Table structure for table `public_disclosures`
--

CREATE TABLE `public_disclosures` (
  `id` int(10) UNSIGNED NOT NULL,
  `subject` varchar(255) NOT NULL,
  `file_path` varchar(500) NOT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `push_outbox`
--

CREATE TABLE `push_outbox` (
  `id` int(11) NOT NULL,
  `source` varchar(50) NOT NULL,
  `record_id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `body` text DEFAULT NULL,
  `url` varchar(500) DEFAULT NULL,
  `status` enum('pending','sent','failed') NOT NULL DEFAULT 'pending',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

--
-- Dumping data for table `push_outbox`
--

INSERT INTO `push_outbox` (`id`, `source`, `record_id`, `title`, `body`, `url`, `status`, `created_at`) VALUES
(14, 'nboard', 32, 'New Update', 'Sai Vidya Mandir International School of CBSE', '1767858008_468a089ebe.jpg', 'pending', '2026-01-08 07:40:08'),
(15, 'nboard', 33, 'New Update', 'Admission Open For 2026 Session', '1767858050_af2c6c4eb4.jpg', 'pending', '2026-01-08 07:40:50'),
(16, 'nboard', 34, 'New Update', 'Admission Open For 2026-2027 Session', 'https://svminternationalschool.in/admission.php', 'pending', '2026-01-13 07:19:15');

-- --------------------------------------------------------

--
-- Table structure for table `register`
--

CREATE TABLE `register` (
  `id` int(11) NOT NULL,
  `username` varchar(100) NOT NULL,
  `email` varchar(150) NOT NULL,
  `password` varchar(255) NOT NULL,
  `usertype` enum('admin') DEFAULT 'admin',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `reset_token` varchar(255) DEFAULT NULL,
  `reset_expires` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `register`
--

INSERT INTO `register` (`id`, `username`, `email`, `password`, `usertype`, `created_at`, `reset_token`, `reset_expires`) VALUES
(3, 'Super Admin', 'saividyamandir4you@gmail.com', '$2y$10$GPxD2B334jREcF1UG5qYSeU3LnQFDvPOprsd5eqwuSSedo0ywjh4.', 'admin', '2025-08-31 06:07:38', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `sections`
--

CREATE TABLE `sections` (
  `id` int(11) NOT NULL,
  `name` varchar(10) NOT NULL,
  `class_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sections`
--

INSERT INTO `sections` (`id`, `name`, `class_id`) VALUES
(20, 'A', 12);

-- --------------------------------------------------------

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(11) NOT NULL,
  `field` varchar(50) NOT NULL,
  `value` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `field`, `value`) VALUES
(11, 'institute_name', 'SVM International School'),
(12, 'upi_id', 'gopimurmu123@ybl'),
(13, 'min_admission_amount', '100'),
(14, 'min_installment_amount', '50'),
(62, 'logo_path', 'uploads/logo/logo_20251031_090243_421fd26e.jpg');

-- --------------------------------------------------------

--
-- Table structure for table `site_settings`
--

CREATE TABLE `site_settings` (
  `id` int(11) NOT NULL,
  `upi_id` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `students`
--

CREATE TABLE `students` (
  `id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `section_id` int(11) NOT NULL,
  `roll_no` varchar(20) NOT NULL,
  `name` varchar(150) NOT NULL,
  `photo_url` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

-- --------------------------------------------------------

--
-- Table structure for table `subjects`
--

CREATE TABLE `subjects` (
  `id` int(11) NOT NULL,
  `name` varchar(60) NOT NULL,
  `class_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subjects`
--

INSERT INTO `subjects` (`id`, `name`, `class_id`) VALUES
(22, 'english', 12);

-- --------------------------------------------------------

--
-- Table structure for table `testimonials`
--

CREATE TABLE `testimonials` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `role` varchar(150) DEFAULT NULL,
  `message` text NOT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `rating` int(11) DEFAULT 5,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `testimonials`
--

INSERT INTO `testimonials` (`id`, `name`, `role`, `message`, `photo`, `rating`, `created_at`) VALUES
(19, 'Mrs. Pooja Mishra', '(Parent of UKG Student)', 'As a parent, safety and care were my top priorities. I am completely satisfied with the school’s secure campus, caring teachers, and nurturing environment. My child enjoys coming to school every day.', '1761747157_b2a76ba605.png', 5, '2025-10-29 14:12:37'),
(20, 'Mr. Anil Patra', '(Parent of Class VI Student)', 'The teaching methodology at Sai Vidya Mandir International School is modern and student-friendly. Along with academics, the school also focuses on values, discipline, and overall personality development.', '1761747196_fc9814d89f.png', 5, '2025-10-29 14:13:16'),
(21, 'Mrs. Sunita Das', '(Parent of Class II Student)', 'We are very happy with the individual attention given to each student. The school maintains good communication with parents and regularly updates us about our child’s progress. It is truly one of the best CBSE schools in the region.', '1761747241_e44463e2a8.png', 5, '2025-10-29 14:14:01'),
(22, 'Mr. Rakesh Kumar', '(Parent of Class IV Student)', 'Sai Vidya Mandir International School has provided an excellent learning environment for my child. The teachers are very supportive and focus on concept clarity as well as discipline. I can clearly see improvement in my child’s confidence and academic performance.', '1761747278_6328389bfe.png', 5, '2025-10-29 14:14:38');

-- --------------------------------------------------------

--
-- Table structure for table `videos`
--

CREATE TABLE `videos` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `video_url` text NOT NULL,
  `category` varchar(100) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci;

--
-- Dumping data for table `videos`
--

INSERT INTO `videos` (`id`, `title`, `video_url`, `category`, `created_at`) VALUES
(7, 'Result', 'https://youtu.be/l7txsr0yxUo?si=9rreaukUKr4GEzvC', '', '2026-01-09 14:53:54');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `academic_calendars`
--
ALTER TABLE `academic_calendars`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `achievements`
--
ALTER TABLE `achievements`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `achievement_categories`
--
ALTER TABLE `achievement_categories`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `admissions`
--
ALTER TABLE `admissions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `albums`
--
ALTER TABLE `albums`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `bannertab`
--
ALTER TABLE `bannertab`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `classes`
--
ALTER TABLE `classes`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indexes for table `class_result_files`
--
ALTER TABLE `class_result_files`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uniq_pdf` (`exam_id`,`class_id`,`section_key`),
  ADD KEY `idx_pdf` (`exam_id`,`class_id`,`section_id`);

--
-- Indexes for table `contacttab`
--
ALTER TABLE `contacttab`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `downloads`
--
ALTER TABLE `downloads`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `faculty`
--
ALTER TABLE `faculty`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `fboard`
--
ALTER TABLE `fboard`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `fee_documents`
--
ALTER TABLE `fee_documents`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `franchise`
--
ALTER TABLE `franchise`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `governing_body_members`
--
ALTER TABLE `governing_body_members`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `grievances`
--
ALTER TABLE `grievances`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `tracking_id` (`tracking_id`);

--
-- Indexes for table `homework`
--
ALTER TABLE `homework`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_class_date` (`class_id`,`assign_date`),
  ADD KEY `idx_section` (`section_id`),
  ADD KEY `idx_subject` (`subject_id`);

--
-- Indexes for table `media_corner`
--
ALTER TABLE `media_corner`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `nboard`
--
ALTER TABLE `nboard`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `notices`
--
ALTER TABLE `notices`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `n_achievers`
--
ALTER TABLE `n_achievers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_status` (`status`),
  ADD KEY `idx_session` (`session_year`);

--
-- Indexes for table `payments`
--
ALTER TABLE `payments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_payment_type` (`payment_type`),
  ADD KEY `idx_status` (`status`),
  ADD KEY `idx_created_at` (`created_at`),
  ADD KEY `idx_student` (`student_name`),
  ADD KEY `idx_rollno` (`rollno`),
  ADD KEY `idx_class` (`class`),
  ADD KEY `idx_tuition_class` (`tuition_class`),
  ADD KEY `idx_mobile` (`mobile`);

--
-- Indexes for table `photos`
--
ALTER TABLE `photos`
  ADD PRIMARY KEY (`id`),
  ADD KEY `album_id` (`album_id`);

--
-- Indexes for table `popup_banner`
--
ALTER TABLE `popup_banner`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `public_disclosures`
--
ALTER TABLE `public_disclosures`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `push_outbox`
--
ALTER TABLE `push_outbox`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_source_record` (`source`,`record_id`);

--
-- Indexes for table `register`
--
ALTER TABLE `register`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `email` (`email`);

--
-- Indexes for table `sections`
--
ALTER TABLE `sections`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `class_id` (`class_id`,`name`);

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `field` (`field`);

--
-- Indexes for table `site_settings`
--
ALTER TABLE `site_settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `students`
--
ALTER TABLE `students`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uniq_class_section_roll` (`class_id`,`section_id`,`roll_no`),
  ADD KEY `fk_students_section` (`section_id`);

--
-- Indexes for table `subjects`
--
ALTER TABLE `subjects`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `class_id` (`class_id`,`name`);

--
-- Indexes for table `testimonials`
--
ALTER TABLE `testimonials`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `videos`
--
ALTER TABLE `videos`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `academic_calendars`
--
ALTER TABLE `academic_calendars`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `achievements`
--
ALTER TABLE `achievements`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `achievement_categories`
--
ALTER TABLE `achievement_categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `admissions`
--
ALTER TABLE `admissions`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `albums`
--
ALTER TABLE `albums`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;

--
-- AUTO_INCREMENT for table `bannertab`
--
ALTER TABLE `bannertab`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=48;

--
-- AUTO_INCREMENT for table `classes`
--
ALTER TABLE `classes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `class_result_files`
--
ALTER TABLE `class_result_files`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `contacttab`
--
ALTER TABLE `contacttab`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `downloads`
--
ALTER TABLE `downloads`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `faculty`
--
ALTER TABLE `faculty`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT for table `fboard`
--
ALTER TABLE `fboard`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;

--
-- AUTO_INCREMENT for table `fee_documents`
--
ALTER TABLE `fee_documents`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `franchise`
--
ALTER TABLE `franchise`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `governing_body_members`
--
ALTER TABLE `governing_body_members`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `grievances`
--
ALTER TABLE `grievances`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `homework`
--
ALTER TABLE `homework`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `media_corner`
--
ALTER TABLE `media_corner`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `nboard`
--
ALTER TABLE `nboard`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;

--
-- AUTO_INCREMENT for table `notices`
--
ALTER TABLE `notices`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;

--
-- AUTO_INCREMENT for table `notifications`
--
ALTER TABLE `notifications`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `n_achievers`
--
ALTER TABLE `n_achievers`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `payments`
--
ALTER TABLE `payments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=123;

--
-- AUTO_INCREMENT for table `photos`
--
ALTER TABLE `photos`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=289;

--
-- AUTO_INCREMENT for table `popup_banner`
--
ALTER TABLE `popup_banner`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `public_disclosures`
--
ALTER TABLE `public_disclosures`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `push_outbox`
--
ALTER TABLE `push_outbox`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `register`
--
ALTER TABLE `register`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `sections`
--
ALTER TABLE `sections`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=107;

--
-- AUTO_INCREMENT for table `site_settings`
--
ALTER TABLE `site_settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `students`
--
ALTER TABLE `students`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `subjects`
--
ALTER TABLE `subjects`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `testimonials`
--
ALTER TABLE `testimonials`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- AUTO_INCREMENT for table `videos`
--
ALTER TABLE `videos`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

X7ROOT File Manager

Editing: u126090504_svmint.sql

Upload File

Create Folder