File Manager

X7ROOT File Manager

Current Path: /home/u126090504/domains/shreeganeshacademy.in/public_html

home / u126090504 / domains / shreeganeshacademy.in / public_html /

📁 ..
📄 Antiraging-Cell.php(2.73 KB)
📄 B.Ed.&B.P.Ed.php(4.44 KB)
📄 about-us.php(8.82 KB)
📄 academic-head-message.php(5.84 KB)
📄 achievers.php(3.07 KB)
📁 admin
📄 admission.php(4.56 KB)
📄 admission_submit.php(1.96 KB)
📄 album.php(890 B)
📄 computer-courses.php(20.66 KB)
📄 config.php(1.17 KB)
📄 contact-us.php(14.66 KB)
📄 contactdb.php(796 B)
📁 css
📄 director's-message.php(5.17 KB)
📄 downloads.php(3.14 KB)
📄 error.log(14.6 KB)
📄 facilities.php(5.62 KB)
📄 faculty.php(4.96 KB)
📁 fonts
📄 footer.php(32.51 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(13.48 KB)
📁 images
📄 index.php(71.3 KB)
📁 js
📁 lib
📄 our-recruiters.php(2.77 KB)
📄 payment.php(8.1 KB)
📄 payment_submit.php(10.97 KB)
📄 payment_verify.php(2.31 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)
📄 shreeganesh.zip(66.92 MB)
📄 submit-grievance.php(3.88 KB)
📄 thank-you.php(1.28 KB)
📄 tutorial.php(4.8 KB)
📄 u126090504_shreeg.sql(36.69 KB)
📁 uploads
📄 videos.php(4.38 KB)

Editing: u126090504_shreeg.sql

-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Apr 04, 2026 at 07:08 AM
-- Server version: 11.8.6-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_shreeg`
--

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

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

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

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

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

--
-- 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, 'SHREE GANESH ACADEMY', '', '2026-02-09 12:25:20');

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

--
-- 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, '1765798940_893ed6c009.png', '2025-12-15 11:42:20', 2),
(46, '1770639496_d5901ed716.jpeg', '2026-02-09 12:18:16', 2),
(47, '1770639533_ba3e4bef93.jpeg', '2026-02-09 12:18:53', 3),
(48, '1773061172_85d1c01dbd.jpg', '2026-03-09 12:59:32', 0);

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

--
-- 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'),
(11, 'STD-2');

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

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

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

--
-- 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, 'Brouchers', '1770639720_db562a687b.pdf', '2026-02-09 12:22:00');

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

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

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

INSERT INTO `fboard` (`id`, `fname`, `des`, `exp`, `marks_pct`, `qual`, `fimg`, `created_at`, `status`) VALUES
(35, 'Prayash Bindu Poi', '+2 Science', '2024-25', NULL, '548', '1770639802_S2.jpeg', '2026-02-09 12:23:23', 'active'),
(36, 'Pankaj', 'STD-III', '2025-26', NULL, '1st', '1771352729_1765799234_987938b452.jpg', '2026-02-17 18:25:29', 'active'),
(37, 'Pankaj', 'STD-III', '2025-26', NULL, 'test', '1771353201_1765799234_987938b452.jpg', '2026-02-17 18:33:21', 'active'),
(38, 'Pankaj', 'STD-III', '2025-26', NULL, 'test', '1771353210_1765799234_987938b452.jpg', '2026-02-17 18:33:30', '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');

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

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

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

--
-- 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),
(9, 11, 19, 21, 'TEST', 'UBUBUYBUYBUBUBUBUBUB', '2025-11-11', '2025-11-12', 'uploads/homework/hw_1762845563_d60c5d65.jpg', 'SIMA', 'active', NULL, '2025-11-11 07:19:23', 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;

--
-- 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, 'Under the visionary leadership of Director Mr. Biswajit Pattanayak, the school is committed to providing a balanced education that blends academic rigor, moral values, and co-curricular excellence.', '', '2025-11-11', '2025-11-22', 1, '2025-11-11 12:58:39', '/uploads/notices/492569651_1202223025247946_2948961063212056880_n_a0614b26.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');

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

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

INSERT INTO `photos` (`id`, `album_id`, `title`, `filename`, `uploaded_at`) VALUES
(285, 33, NULL, '1770639936_S2.jpeg', '2026-02-09 12:25:36'),
(286, 33, NULL, '1770639944_S1.jpeg', '2026-02-09 12:25:44');

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

--
-- 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, '1765799234_987938b452.jpg', 'https://shreeganeshacademy.in/contact-us.php', NULL, NULL, 1, '2025-12-15 11:47:14');

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

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

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

--
-- 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', 'info@shreeganeshacademy.in', '$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
(18, 'A', 10),
(19, 'A', 11);

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

--
-- 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', '8249405440@YBL'),
(13, 'min_admission_amount', '1000'),
(14, 'min_installment_amount', '500'),
(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),
(21, 'ENG', 11);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- 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=7;
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_shreeg.sql

Upload File

Create Folder