File Manager

X7ROOT File Manager

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

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

📁 ..
📄 .htaccess(1.12 KB)
📄 Antiraging-Cell.php(2.73 KB)
📄 B.Ed.&B.P.Ed.php(4.4 KB)
📄 about-us.php(9.01 KB)
📄 academic-head-message.php(5.84 KB)
📄 achievers.php(3.07 KB)
📁 admin
📄 admission.php(5.17 KB)
📄 admission_submit.php(1.96 KB)
📄 album.php(890 B)
📄 computer-courses.php(20.66 KB)
📄 config.php(1.16 KB)
📄 contact-us.php(14.68 KB)
📄 contactdb.php(796 B)
📁 css
📄 director's-message.php(5.46 KB)
📄 downloads.php(3.14 KB)
📄 error.log(14.6 KB)
📄 facilities.php(7.19 KB)
📄 faculty.php(4.96 KB)
📁 fonts
📄 footer.php(22.79 KB)
📄 franchise.php(2.09 KB)
📄 gallery.php(3.21 KB)
📄 governing-body.php(3.58 KB)
📄 grievance-form.php(13.71 KB)
📄 header.php(15 KB)
📁 images
📄 index.php(63.18 KB)
📁 js
📁 lib
📁 ocabdk
📄 ocabdk.zip(63.02 MB)
📄 our-recruiters.php(2.77 KB)
📄 payment.php(8.1 KB)
📄 payment_submit.php(10.97 KB)
📄 payment_verify.php(2.31 KB)
📄 peret.php(266.87 KB)
📄 placement.php(8.33 KB)
📄 principal's-message.php(6.02 KB)
📁 qrcodes
📁 revolution
📄 scope.php(14.14 KB)
📄 search_videos.php(1.76 KB)
📄 submit-grievance.php(3.88 KB)
📄 thank-you.php(1.28 KB)
📄 tutorial.php(4.81 KB)
📄 u126090504_mmabpd.sql(44.65 KB)
📁 uploads
📄 videos.php(4.38 KB)

Editing: u126090504_mmabpd.sql

-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Dec 03, 2025 at 01:34 PM
-- 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_mmabpd`
--

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

--
-- 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;

--
-- Dumping data for table `academic_calendars`
--

INSERT INTO `academic_calendars` (`id`, `title`, `academic_year`, `file_path`, `status`, `sort_order`, `created_at`) VALUES
(4, 'test6', '2025-2026', 'uploads/academic_calendar/1761919328_eb770da3_White_Blue_Modern_School_Admission_Banner__5_.jpg', 'active', 1, '2025-10-31 14:02:08'),
(5, 'test', '2024-25', 'uploads/academic_calendar/1762847453_52de7c47_492569651_1202223025247946_2948961063212056880_n.jpg', 'active', 2, '2025-11-11 07:50:53');

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

--
-- 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;

--
-- Dumping data for table `achievements`
--

INSERT INTO `achievements` (`id`, `title`, `category`, `sub_title`, `description`, `event_date`, `image_path`, `external_link`, `is_active`, `display_order`, `created_at`, `category_id`) VALUES
(5, 'hjbhjhjb', 'award', 'hvhjvhjvj', 'hj hjjh hj', '2025-11-11', 'uploads/achievements/achv_20251111_080302_7ebe5948.jpg', '', 1, 0, '2025-11-11 08:03:02', 6);

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

--
-- 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');

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

--
-- 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
(32, 'puja', '', '2025-11-11 07:52:55'),
(33, 'annual', '', '2025-11-11 07:53:34');

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

--
-- 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
(41, '1764397945_2ec8e095e7.jpg', '2025-11-29 06:32:25', 2),
(42, '1764397966_99200d7a07.jpg', '2025-11-29 06:32:46', 3),
(43, '1764398069_2ad297d669.png', '2025-11-29 06:34:29', 1);

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

--
-- 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
(10, 'STD-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
(10, 'Eduweb Software Solutions', 'esshosting@gmail.com', 'jhfj', '07381426778', 'n  n nm n n', '2025-11-11 08:04:50');

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

--
-- 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, 'Urgent: Plesk & VPS Node Details for Migration – High Priority', '1762848506_91f422e3b5.jpg', '2025-11-11 08:08:26');

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

--
-- 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;

--
-- Dumping data for table `faculty`
--

INSERT INTO `faculty` (`id`, `name`, `designation`, `qualification`, `specialization`, `experience`, `photo`, `created_at`, `position`) VALUES
(27, 'Eduweb Software Solutions', 'dddfdf', 'dfdfdf', 'ffdfdf', '5', '1762848062_3d3a7798d6.jpg', '2025-11-11 08:01:02', 1);

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

--
-- 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;

--
-- Dumping data for table `fboard`
--

INSERT INTO `fboard` (`id`, `fname`, `des`, `exp`, `marks_pct`, `qual`, `fimg`, `created_at`, `status`) VALUES
(35, 'Saroj Behera', 'hvhvv', '24-25', 90.00, '1st', '1762847206_492569651_1202223025247946_2948961063212056880_n.jpg', '2025-11-11 07:46:46', 'active');

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

--
-- 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;

--
-- Dumping data for table `fee_documents`
--

INSERT INTO `fee_documents` (`id`, `title`, `file_path`, `file_type`, `is_active`, `display_order`, `uploaded_at`) VALUES
(6, '2024-25 FEE STRUCTURE', 'uploads/fees/fee_20251110_063938_eb22223d.pdf', 'pdf', 1, 0, '2025-11-10 06:39:38'),
(7, 'guyguygugu', 'uploads/fees/fee_20251111_080002_46273344.pdf', 'pdf', 1, 0, '2025-11-11 08:00:02');

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

--
-- 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;

--
-- Dumping data for table `governing_body_members`
--

INSERT INTO `governing_body_members` (`id`, `name`, `designation`, `role_responsibility`, `sort_order`, `status`, `created_at`, `updated_at`) VALUES
(8, 'hvuyvhjvjh', 'hj hh hj jh', 'j j jk j  j j j', 1, 'active', '2025-11-11 08:01:48', '2025-11-11 08:01:48');

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

--
-- 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-6912eec5eeed7', 'Eduweb Software Solutions', 'kkjkj', '', 'PLAY GROUP', 0, '7381426778', 'esshosting@gmail.com', 'No', '', 'Transport/Bus', 'Driver Behaviour', '2025-11-11', '13:36:00', 'Playground', 'teacher', 1, 'High', '1 week', 'hhj hj h j j jhj hj j bbbb', 'uvuvuyvuy', 'jbjbjbjkbkjb', 'No', '[\"GRV-6912eec5eeed7_6912eec5eef0d.jpg\"]', 'Pending', '2025-11-11 08:07:33', '2025-11-11 08:07:33');

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

--
-- 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', 'kjkjkdwdwe12e12e2', '2025-11-10', '2025-11-12', 'uploads/homework/hw_1762756057_45eb9c6d.pdf', 'Sk Ratha', 'active', NULL, '2025-11-10 06:27:37', 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;

--
-- Dumping data for table `media_corner`
--

INSERT INTO `media_corner` (`id`, `title`, `image`, `created_at`) VALUES
(23, 'hvhgvhgvh', '1762847660_1---10-.jpg', '2025-11-11 07:54:20');

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

--
-- 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, '2025-11-11', 'ubububub', '1762847958_4ba6aa0e96.jpg', '', 1, '2025-11-11 07:59:18');

--
-- 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
(31, 'Admission', '', '2025-11-11', '2025-11-14', 1, '2025-11-11 07:57:22', '/uploads/notices/492569651_1202223025247946_2948961063212056880_n_21acd6ac.jpg'),
(32, 'yftyfyffufuyf', 'https://eduwebsoft.co.in/', '2025-06-10', '2025-11-13', 1, '2025-11-11 07:58:21', '');

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

--
-- 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');

--
-- 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 ;

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

--
-- Stand-in structure for view `payments_frontend_view`
-- (See below for the actual view)
--
CREATE TABLE `payments_frontend_view` (
`id` int(11)
,`student_name` varchar(100)
,`father_name` varchar(100)
,`mother_name` varchar(100)
,`sex` enum('Male','Female','Other')
,`caste` enum('SC','ST','OBC','GENERAL')
,`blood_group` enum('A+','A-','B+','B-','AB+','AB-','O+','O-','Unknown')
,`aadhaar_masked` varchar(14)
,`photo` varchar(255)
,`dob` date
,`age` varchar(20)
,`school` varchar(150)
,`display_class` varchar(50)
,`display_section` varchar(20)
,`rollno` varchar(50)
,`payment_type` enum('Admission Fee','Tuition Fee')
,`amount` decimal(10,2)
,`status` enum('Pending','Paid','Failed','Cancelled')
,`transaction_id` varchar(100)
,`payment_mode` varchar(50)
,`created_at` timestamp
);

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

--
-- 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;

--
-- Dumping data for table `photos`
--

INSERT INTO `photos` (`id`, `album_id`, `title`, `filename`, `uploaded_at`) VALUES
(285, 32, NULL, '1762847589_492569651_1202223025247946_2948961063212056880_n.jpg', '2025-11-11 07:53:09'),
(286, 32, NULL, '1762847629_1- (7).jpg', '2025-11-11 07:53:49');

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

--
-- 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, '1762847133_b355e2d6ed.jpg', 'https://esserp.in/admission.php', '2025-11-11', '2025-11-15', 1, '2025-11-11 07:45:33');

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

--
-- 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', 'ubububub', '1762847958_4ba6aa0e96.jpg', 'pending', '2025-11-11 07:59:18');

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

--
-- 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', 'sahoopankaj37@gmail.com', '$2y$10$tfbNiAWeA.75haQ0ZwOAZuW3vZ53Oa3PpQKOzliFKg2YSA3XhteQ2', '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
(18, 'A', 10);

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

--
-- 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', 'St. Xavier\'s International School'),
(12, 'upi_id', '8658880550@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
(20, 'Mathematics', 10);

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

--
-- 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
(27, 'Suman Pradhan', 'DCA Student', 'OCA Bhadrak gave me the perfect start in computer education. The classes are practical, easy to understand, and the teachers are very supportive. The DCA course helped me gain confidence and improve my skills.', '1764596517_944d2aae01.png', 5, '2025-12-01 13:41:57'),
(28, 'Rakesh Behera', 'PGDCA Student', 'The faculty here explain every topic with real examples, which makes learning very comfortable. The computer lab is well maintained, and the practical sessions are very helpful. I truly recommend OCA for quality training.', '1764596588_cb4ed1cbb5.png', 5, '2025-12-01 13:43:08'),
(29, 'Lipsa Das', 'Tally + GST Student', 'I joined OCA to learn Tally, and the training was excellent. The GST modules, billing practice, and hands-on assignments helped me get a job in an accounting firm. Thanks to the entire OCA team for proper guidance.', '1764596814_b2d42b4753.png', 5, '2025-12-01 13:46:54'),
(30, 'Ankit Kumar', 'Web Designing Student', 'The best part about OCA is the practical approach. I created my own website during the course with proper guidance from the trainer. The institute provides everything a student needs to succeed in the IT field.', '1764596861_0e3c8301cd.png', 5, '2025-12-01 13:47:41'),
(31, 'Priyanka Sahu', '+2 Tutorial Student (CV Raman Tutorial)', 'CV Raman Tutorial at OCA helped me improve my marks significantly. Regular tests, doubt-clearing classes, and friendly teachers made learning enjoyable. I am very thankful for their support.', '1764596951_e8564a174d.png', 5, '2025-12-01 13:49:11');

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

--
-- 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
(1, 'Orientation Day 2025', 'https://www.youtube.com/watch?v=aqz-KE-bpKQ', 'Events', '2025-11-03 07:41:07'),
(2, 'Annual Sports Meet Highlights', 'https://youtu.be/9bZkp7q19f0', 'Sports', '2025-11-03 07:41:07'),
(3, 'Workshop on Robotics', 'https://drive.google.com/file/d/1h2S3g4H5i6j7K8l9/view?usp=sharing', 'Workshop', '2025-11-03 07:41:07'),
(4, 'Cultural Fest Performance', 'https://www.youtube.com/watch?v=ktvTqknDobU', 'Culture', '2025-11-03 07:41:07'),
(6, 'test', 'https://youtu.be/G-yAbCIOBIU?si=mdmiG-9L7fEGFAKK', 'education', '2025-11-03 07:54:28'),
(7, 'eng', 'https://youtu.be/tVhG4fs5dqs?si=nzWtLuR4Rk2Ndp-m', 'eng', '2025-11-11 07:55:47');

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

--
-- Table structure for table `v_exam_toppers`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`u126090504_mmabpd`@`127.0.0.1` SQL SECURITY DEFINER VIEW `v_exam_toppers`  AS SELECT `er`.`exam_id` AS `exam_id`, `s`.`id` AS `student_id`, `s`.`name` AS `name`, `s`.`roll_no` AS `roll_no`, `s`.`photo_url` AS `photo_url`, `er`.`marks_obtained` AS `marks_obtained`, `er`.`total_marks` AS `total_marks`, `er`.`percentage` AS `percentage`, rank() over ( partition by `er`.`exam_id` order by `er`.`percentage` desc,`er`.`marks_obtained` desc) AS `rank_no` FROM (`exam_results` `er` join `students` `s` on(`s`.`id` = `er`.`student_id`)) ;
-- Error reading data for table u126090504_mmabpd.v_exam_toppers: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FROM `u126090504_mmabpd`.`v_exam_toppers`' at line 1

--
-- 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=6;

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

--
-- 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=17;

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

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

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

--
-- 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=11;

--
-- 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=9;

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

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

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

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

--
-- 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=114;

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

--
-- 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=15;

--
-- 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=19;

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

--
-- 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=21;

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

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

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

--
-- Structure for view `payments_frontend_view`
--
DROP TABLE IF EXISTS `payments_frontend_view`;

CREATE ALGORITHM=UNDEFINED DEFINER=`u126090504_mmabpd`@`127.0.0.1` SQL SECURITY DEFINER VIEW `payments_frontend_view`  AS SELECT `payments`.`id` AS `id`, `payments`.`student_name` AS `student_name`, `payments`.`father_name` AS `father_name`, `payments`.`mother_name` AS `mother_name`, `payments`.`sex` AS `sex`, `payments`.`caste` AS `caste`, `payments`.`blood_group` AS `blood_group`, CASE WHEN `payments`.`aadhaar` is null OR `payments`.`aadhaar` = '' OR char_length(`payments`.`aadhaar`) < 4 THEN '' ELSE concat('XXXX-XXXX-',right(`payments`.`aadhaar`,4)) END AS `aadhaar_masked`, `payments`.`photo` AS `photo`, `payments`.`dob` AS `dob`, `payments`.`age` AS `age`, `payments`.`school` AS `school`, coalesce(`payments`.`tuition_class`,`payments`.`class`) AS `display_class`, `payments`.`tuition_section` AS `display_section`, `payments`.`rollno` AS `rollno`, `payments`.`payment_type` AS `payment_type`, `payments`.`amount` AS `amount`, `payments`.`status` AS `status`, `payments`.`transaction_id` AS `transaction_id`, `payments`.`payment_mode` AS `payment_mode`, `payments`.`created_at` AS `created_at` FROM `payments` ;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `homework`
--
ALTER TABLE `homework`
  ADD CONSTRAINT `homework_ibfk_1` FOREIGN KEY (`class_id`) REFERENCES `classes` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `homework_ibfk_2` FOREIGN KEY (`section_id`) REFERENCES `sections` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `homework_ibfk_3` FOREIGN KEY (`subject_id`) REFERENCES `subjects` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `photos`
--
ALTER TABLE `photos`
  ADD CONSTRAINT `photos_ibfk_1` FOREIGN KEY (`album_id`) REFERENCES `albums` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `sections`
--
ALTER TABLE `sections`
  ADD CONSTRAINT `sections_ibfk_1` FOREIGN KEY (`class_id`) REFERENCES `classes` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `students`
--
ALTER TABLE `students`
  ADD CONSTRAINT `fk_students_class` FOREIGN KEY (`class_id`) REFERENCES `classes` (`id`),
  ADD CONSTRAINT `fk_students_section` FOREIGN KEY (`section_id`) REFERENCES `sections` (`id`);

--
-- Constraints for table `subjects`
--
ALTER TABLE `subjects`
  ADD CONSTRAINT `subjects_ibfk_1` FOREIGN KEY (`class_id`) REFERENCES `classes` (`id`) ON DELETE CASCADE;
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_mmabpd.sql

Upload File

Create Folder