|
Server IP : 2a02:4780:11:1373:0:3017:be17:10 / Your IP : 216.73.216.55 Web Server : LiteSpeed System : Linux in-mum-web1273.main-hosting.eu 4.18.0-553.37.1.lve.el8.x86_64 #1 SMP Mon Feb 10 22:45:17 UTC 2025 x86_64 User : u806862359 ( 806862359) PHP Version : 8.2.27 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF Directory (0755) : /home/u806862359/domains/pbacbse.org/public_html/adminweb/db/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
-- phpMyAdmin SQL Dump -- version 5.1.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Jul 10, 2022 at 03:08 PM -- Server version: 10.4.22-MariaDB -- PHP Version: 8.1.2 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: `admin` -- -- -------------------------------------------------------- -- -- Table structure for table `academic_calender` -- CREATE TABLE `academic_calender` ( `id` int(10) NOT NULL, `event_name` varchar(100) NOT NULL, `event_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `week` varchar(100) NOT NULL, `guests` varchar(100) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `academic_calender` -- INSERT INTO `academic_calender` (`id`, `event_name`, `event_date`, `week`, `guests`, `created_at`, `updated_at`) VALUES (1, 'Test Event', '2020-12-29 18:30:00', '2nd Week', 'test guest', '2022-07-03 10:09:08', '2022-07-03 10:09:08'), (2, 'Test Event 2', '2023-02-02 18:30:00', '2nd Week', 'test guest', '2022-07-03 10:13:00', '2022-07-03 10:13:21'), (4, 'Test Event 5', '2025-02-02 18:30:00', '5nd Week', 'test guest 5', '2022-07-03 10:13:00', '2022-07-03 10:22:24'); -- -------------------------------------------------------- -- -- Table structure for table `achievers` -- CREATE TABLE `achievers` ( `id` int(11) NOT NULL, `name` varchar(200) NOT NULL, `event` varchar(200) NOT NULL, `year` varchar(100) NOT NULL, `place` varchar(255) NOT NULL, `remarks` longtext NOT NULL, `section` varchar(200) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `achievers` -- INSERT INTO `achievers` (`id`, `name`, `event`, `year`, `place`, `remarks`, `section`, `created_at`, `updated_at`) VALUES (2, 'Test Achievers 2', 'Achievers Data 2', '2021-2022', 'Gujarat', ' <p> Test <b><u>Achievers 123</u></b></p><p><b><u><br></u></b></p><p>test data</p> ', 'Sports', '2022-07-09 14:13:17', '2022-07-09 14:22:50'), (3, 'Test Achievers 1', 'Achievers Data', '2021-2022', 'Gujrat', 'Test <b><u>Achievers</u></b>', 'Achievers', '2022-07-09 14:13:28', '2022-07-09 14:13:28'); -- -------------------------------------------------------- -- -- Table structure for table `alumini` -- CREATE TABLE `alumini` ( `id` int(100) NOT NULL, `name` varchar(100) NOT NULL, `passing_year` varchar(100) NOT NULL, `mobile_number` varchar(100) NOT NULL, `email` varchar(100) NOT NULL, `address` varchar(1000) NOT NULL, `otherinfo` longtext NOT NULL, `photo` varchar(100) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `alumini` -- INSERT INTO `alumini` (`id`, `name`, `passing_year`, `mobile_number`, `email`, `address`, `otherinfo`, `photo`, `created_at`, `updated_at`) VALUES (1, 'test', '2019', '9898989898', 'test@gmail.com', 'test', 'test', 'uploads/alumini/ShowLetx_1656835750.jpg', '2022-07-03 06:18:47', '2022-07-03 08:09:10'), (3, 'raghu', '1999', '8050482213', 'afasd@gmail.co', 'asdf asdfadsf s', 'hcl bangalore ', 'uploads/alumini/alumini_1657035005.jpg', '2022-07-05 15:30:05', '2022-07-05 15:30:05'), (4, 'Test With Editor', '2022', '9898244359', 'dk@gmail.com', 'B-402', '', 'uploads/alumini/alumini_1657036329.jpg', '2022-07-05 15:52:09', '2022-07-05 15:52:09'), (5, 'Test With Editor', '2022', '9898244359', 'dk@gmail.com', 'B-402', ' <p> </p><p> </p><p><b><u><br></u></b></p><table class=\"table table-bordered\"><tbody><tr><td>dsf 123</td><td>fdf 123</td></tr><tr><td>sdfsfsfs</td><td>wqeqwe</td></tr></tbody></table><p><b><u>Testing</u></b></p><p><b><u><br></u></b></p> <br><p></p> <p></p> ', 'uploads/alumini/alumini_1657036736.jpg', '2022-07-05 15:58:56', '2022-07-05 16:02:12'); -- -------------------------------------------------------- -- -- Table structure for table `alumni_feedback` -- CREATE TABLE `alumni_feedback` ( `id` int(11) NOT NULL, `name` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `alumni_name` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `passing_year` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, `mobile_email` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL, `libraryandlaboratoryfacilities` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL, `aboutacademicenvironment` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL, `aboutfacultyquality` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL, `receivedanysupportencouragement` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL, `ratingoftheinstitutions` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL, `meeting_attended` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL, `required_improvement` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL, `suggestions` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL, `created_date` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `alumni_feedback` -- INSERT INTO `alumni_feedback` (`id`, `name`, `alumni_name`, `passing_year`, `mobile_email`, `libraryandlaboratoryfacilities`, `aboutacademicenvironment`, `aboutfacultyquality`, `receivedanysupportencouragement`, `ratingoftheinstitutions`, `meeting_attended`, `required_improvement`, `suggestions`, `created_date`) VALUES (8, 'Test data', 'test', '2019', '989824359', 'test', 'test', 'test', 'test', 'test', 'test', 'test', 'test', '2022-07-25 13:54:55'), (9, 'Test data', 'test', '2019', '989824359', 'test', 'test', 'test', 'test', 'test', 'test', 'test', 'test', '2022-07-25 13:54:55'), (13, 'Test data', 'test', '2019', '989824359', 'test', 'test', 'test', 'test', 'test', 'test', 'test', 'test', '2022-07-25 13:54:55'), (14, 'Test data', 'test', '2019', '989824359', 'test', 'test', 'test', 'test', 'test', 'test', 'test', 'test', '2022-07-25 13:54:55'), (15, 'Test data', 'test', '2019', '989824359', 'test', 'test', 'test', 'test', 'test', 'test', 'test', 'test', '2022-07-25 13:54:55'), (16, 'Test data', 'test', '2019', '989824359', 'test', 'test', 'test', 'test', 'test', 'test', 'test', 'test', '2022-07-25 13:54:55'), (17, 'Test data', 'test', '2019', '989824359', 'test', 'test', 'test', 'test', 'test', 'test', 'test', 'test', '2022-07-25 13:54:55'), (18, 'Test data', 'test', '2019', '989824359', 'test', 'test', 'test', 'test', 'test', 'test', 'test', 'test', '2022-07-25 13:54:55'), (19, 'Test data', 'test', '2019', '989824359', 'test', 'test', 'test', 'test', 'test', 'test', 'test', 'test', '2022-07-25 13:54:55'); -- -------------------------------------------------------- -- -- Table structure for table `announcements_news` -- CREATE TABLE `announcements_news` ( `id` int(11) NOT NULL, `title` varchar(200) NOT NULL, `date` date NOT NULL, `section` varchar(100) NOT NULL, `file` varchar(100) NOT NULL, `description` longtext NOT NULL, `is_active` int(11) NOT NULL DEFAULT 1, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `announcements_news` -- INSERT INTO `announcements_news` (`id`, `title`, `date`, `section`, `file`, `description`, `is_active`, `created_at`, `updated_at`) VALUES (1, 'test a', '2020-03-23', 'News', 'uploads/news_documents/news_documents_1657295509.jpg', ' test <u>NEWS</u> ', 1, '2022-07-08 14:46:13', '2022-07-08 15:51:49'), (2, 'Test Announcement', '2020-06-07', 'Announcements', 'uploads/news_documents/news_documents1657291675.jpg', '<h3 class=\"\"><b>Test Announcement </b></h3><h3 class=\"\"><b><br></b>this is testing data</h3>', 1, '2022-07-08 14:47:55', '2022-07-08 14:58:57'); -- -------------------------------------------------------- -- -- Table structure for table `committee` -- CREATE TABLE `committee` ( `id` int(11) NOT NULL, `committee` varchar(255) NOT NULL, `name` varchar(150) NOT NULL, `designation` varchar(100) NOT NULL, `others` varchar(250) NOT NULL, `order_by` int(11) NOT NULL, `is_active` int(11) NOT NULL DEFAULT 1, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `committee` -- INSERT INTO `committee` (`id`, `committee`, `name`, `designation`, `others`, `order_by`, `is_active`, `created_at`, `updated_at`) VALUES (1, 'Test committee', 'Dk Kamaliya', 'Test Designation', 'test other', 5, 1, '2022-07-05 17:51:34', '2022-07-05 17:56:59'), (2, 'Test committee 1', 'test 1', 'Principal 1', 'test other 1', 1, 1, '2022-07-05 17:52:15', '2022-07-05 18:03:18'), (3, 'Test committee', 'Dk Kamaliya', 'Test Designation', 'test other', 5, 1, '2022-07-05 17:51:34', '2022-07-05 17:56:56'), (4, 'Test committee 1', 'test', 'Principal', 'test other', 3, 1, '2022-07-05 17:52:15', '2022-07-05 17:56:51'), (5, 'Test committee 1', 'test 1', 'Principal 1', 'test other 1', 1, 1, '2022-07-05 18:04:46', '2022-07-05 18:05:08'); -- -------------------------------------------------------- -- -- Table structure for table `documents` -- CREATE TABLE `documents` ( `id` int(11) NOT NULL, `category` varchar(250) NOT NULL, `title` varchar(200) NOT NULL, `file` varchar(100) NOT NULL, `description` longtext NOT NULL, `is_active` int(11) NOT NULL DEFAULT 1, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `documents` -- INSERT INTO `documents` (`id`, `category`, `title`, `file`, `description`, `is_active`, `created_at`, `updated_at`) VALUES (1, 'Test Doc', 'Test Doc', 'uploads/documents/documents_1657216765.jpg', '', 1, '2022-07-07 17:59:25', '2022-07-07 17:59:25'), (2, 'Test Doc', 'Test Doc', 'uploads/documents/documents_1657216765.jpg', '', 1, '2022-07-07 17:59:25', '2022-07-07 17:59:25'), (3, 'Test Doc', 'Test Doc', 'uploads/documents/documents_1657216765.jpg', '', 1, '2022-07-07 17:59:25', '2022-07-07 17:59:25'), (4, 'Test Doc', 'Test Doc', 'uploads/documents/documents_1657217618.jpg', ' <p><br></p><table class=\"table table-bordered\"><tbody><tr><td>1</td><td>2</td></tr><tr><td>4</td><td>3</td></tr></tbody></table><p>Test <b><u>Doc</u></b></p><p><b><u><br></u></b></p><p><b><u> </u></b></p> ', 1, '2022-07-07 18:13:52', '2022-07-07 18:13:52'), (7, 'ABC', 'XYZ', 'uploads/documents/documents_1657217734.jpg', '<b>ABC </b><u>XYZ</u>', 1, '2022-07-07 18:15:55', '2022-07-07 18:15:55'); -- -------------------------------------------------------- -- -- Table structure for table `enquiry` -- CREATE TABLE `enquiry` ( `id` int(11) NOT NULL, `name` varchar(200) NOT NULL, `email` varchar(100) NOT NULL, `mobile_number` varchar(50) NOT NULL, `subject` varchar(255) NOT NULL, `message` varchar(500) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `enquiry` -- INSERT INTO `enquiry` (`id`, `name`, `email`, `mobile_number`, `subject`, `message`, `created_at`, `updated_at`) VALUES (1, 'test', 'test@yopmail.com', '9898244359', 'For Test', 'this is test enquiry', '2022-07-09 17:59:52', '2022-07-09 17:59:52'), (2, 'test', 'test@yopmail.com', '9898244359', 'For Test', 'this is test enquiry', '2022-07-09 18:00:03', '2022-07-09 18:00:03'), (4, 'test', 'test@yopmail.com', '9898244359', 'For Test', 'this is test enquiry', '2022-07-09 18:00:03', '2022-07-09 18:00:03'); -- -------------------------------------------------------- -- -- Table structure for table `events` -- CREATE TABLE `events` ( `id` int(10) NOT NULL, `event_name` varchar(100) NOT NULL, `event_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `event_description` longtext NOT NULL, `event_photo` varchar(100) NOT NULL, `is_active` int(11) NOT NULL DEFAULT 1, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `events` -- INSERT INTO `events` (`id`, `event_name`, `event_date`, `event_description`, `event_photo`, `is_active`, `created_at`, `updated_at`) VALUES (1, 'Test Event', '2022-07-05 16:50:08', 'this is testing event', 'uploads/events/(44)_1656839357.jpg', 1, '2022-07-03 09:09:17', '2022-07-05 16:50:08'), (2, 'Test Event 2', '2022-07-05 16:45:09', 'This is test event 2', 'uploads/events/(54)_1656839498.jpg', 1, '2022-07-03 09:11:38', '2022-07-05 16:45:09'), (4, 'Test Event 3', '2022-07-05 16:49:54', 'Test Event', 'uploads/events/event__1656840962.jpg', 1, '2022-07-03 09:36:02', '2022-07-05 16:49:54'), (5, 'Test Event With Editor', '2022-07-05 16:50:03', '<table class=\"table table-bordered\"><tbody><tr><td>1</td><td>2</td><td>3</td></tr><tr><td>4</td><td>5</td><td>6</td></tr><tr><td>7</td><td>8</td><td>9</td></tr></tbody></table> ', 'uploads/events/event__1657037202.jpg', 1, '2022-07-05 16:06:42', '2022-07-05 16:50:03'); -- -------------------------------------------------------- -- -- Table structure for table `facilities` -- CREATE TABLE `facilities` ( `id` int(11) NOT NULL, `name` varchar(200) NOT NULL, `description` longtext NOT NULL, `photo` varchar(100) NOT NULL, `department` varchar(250) NOT NULL, `is_active` int(11) NOT NULL DEFAULT 1, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `facilities` -- INSERT INTO `facilities` (`id`, `name`, `description`, `photo`, `department`, `is_active`, `created_at`, `updated_at`) VALUES (2, 'Test Facilitie', ' test ', 'uploads/facilities/facilities_1657213559.jpg', 'Test Department', 1, '2022-07-07 17:05:59', '2022-07-07 17:28:10'), (3, 'Test Facilitie 11', ' This is <b><u>Test Facilitie 11</u></b> ', 'uploads/facilities/facilities_1657214759.jpg', 'Test Department 11', 1, '2022-07-07 17:12:05', '2022-07-07 17:27:44'); -- -------------------------------------------------------- -- -- Table structure for table `gallery` -- CREATE TABLE `gallery` ( `id` int(10) NOT NULL, `category` varchar(250) NOT NULL, `title` varchar(200) NOT NULL, `photo` varchar(100) NOT NULL, `section` varchar(200) NOT NULL, `is_active` int(11) NOT NULL DEFAULT 1, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `gallery` -- INSERT INTO `gallery` (`id`, `category`, `title`, `photo`, `section`, `is_active`, `created_at`, `updated_at`) VALUES (2, 'Test Category', 'Test Image', 'uploads/gallery/gallery__1657132945.jpg', 'Gallery', 1, '2022-07-06 17:11:42', '2022-07-06 18:43:12'), (3, 'Test Category 555', 'Test Video 555', 'http://stjpc.eviengapp.in/admin', 'Video', 1, '2022-07-06 17:12:02', '2022-07-06 18:41:53'), (4, 'Test Category 1 2', 'Test PDF 2', 'uploads/gallery/gallery__1657132883.jpg', 'PDF', 1, '2022-07-06 18:21:32', '2022-07-06 18:41:23'); -- -------------------------------------------------------- -- -- Table structure for table `staff_management` -- CREATE TABLE `staff_management` ( `id` int(11) NOT NULL, `name` varchar(100) NOT NULL, `department` varchar(100) NOT NULL, `designation` varchar(100) NOT NULL, `mobile_number` varchar(100) NOT NULL, `email` varchar(100) NOT NULL, `qualification` varchar(100) NOT NULL, `staff_type` varchar(100) NOT NULL, `photo` varchar(100) NOT NULL, `description` longtext NOT NULL, `is_active` int(11) NOT NULL DEFAULT 1, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `staff_management` -- INSERT INTO `staff_management` (`id`, `name`, `department`, `designation`, `mobile_number`, `email`, `qualification`, `staff_type`, `photo`, `description`, `is_active`, `created_at`, `updated_at`) VALUES (1, 'Dk Kamaliya', 'BCA', 'Principal', '9898244359', 'dk@gmail.com', 'MSC(IT)', 'Management', 'uploads/staff_management/alumini_1657038863.jpg', '<h3 class=\"\"><b><u>About me</u></b></h3><p>i am principal and this is Test Other details</p>', 1, '2022-07-05 16:34:23', '2022-07-05 16:57:28'), (3, 'Dk Kamaliya', 'BCA', 'Principal', '9898244359', 'dk@gmail.com', 'MSC(IT)', 'Management', 'uploads/staff_management/alumini_1657038863.jpg', '<h3 class=\"\"><b><u>About me</u></b></h3><p>i am principal and this is Test Other details</p>', 1, '2022-07-05 16:34:23', '2022-07-05 16:57:28'), (4, 'Dk Kamaliya', 'BCA', 'Principal', '9898244359', 'dk@gmail.com', 'MSC(IT)', 'Management', 'uploads/staff_management/alumini_1657038863.jpg', '<h3 class=\"\"><b><u>About me</u></b></h3><p>i am principal and this is Test Other details</p>', 1, '2022-07-05 16:34:23', '2022-07-05 16:57:28'), (5, 'Dk Kamaliya 1', 'BCA 1', 'Principal 1', '9898244359 1', 'dk1@gmail.com', 'MSC(IT) 1', 'Administrator', 'uploads/staff_management/staff_1657041562.jpg', ' <h3 class=\"\"><b><u>About me</u></b></h3><p>i am principal and this is Test Other details <b>123</b></p> ', 1, '2022-07-05 16:34:23', '2022-07-05 17:19:22'); -- -------------------------------------------------------- -- -- Table structure for table `students` -- CREATE TABLE `students` ( `id` int(11) NOT NULL, `name` varchar(200) NOT NULL, `roll_number` int(11) NOT NULL, `reg_no` int(11) NOT NULL, `class` varchar(200) NOT NULL, `division` varchar(200) NOT NULL, `username` varchar(200) NOT NULL, `password` varchar(100) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `students` -- INSERT INTO `students` (`id`, `name`, `roll_number`, `reg_no`, `class`, `division`, `username`, `password`, `created_at`, `updated_at`) VALUES (1, 'Test 1', 11, 11, 'PUC I', 'A', 'test11', 'Test@123', '2022-07-09 17:21:12', '2022-07-09 17:21:12'), (3, 'Test 3', 13, 13, 'PUC I', 'C', 'test33', 'Test@123', '2022-07-09 17:21:13', '2022-07-09 17:21:13'), (4, 'Test 4', 14, 14, 'PUC I', 'A', 'test44', 'Test@123', '2022-07-09 17:21:13', '2022-07-09 17:21:13'); -- -------------------------------------------------------- -- -- Table structure for table `students_admission` -- CREATE TABLE `students_admission` ( `id` bigint(20) NOT NULL, `first_name` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL, `last_name` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL, `class` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `dob` date NOT NULL, `parents_firstname` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL, `parents_lastname` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL, `gender` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `caste` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, `religion` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, `category` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, `sslc` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `puc` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `degree` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `master_degree` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `address` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `city` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `country` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `phone` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(70) COLLATE utf8mb4_unicode_ci NOT NULL, `aadhaar_number` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL, `physicalhandicap` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL, `bank_holder_name` varchar(180) COLLATE utf8mb4_unicode_ci NOT NULL, `bank_name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL, `account_number` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `ifsc_code` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `whether_employed` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `other_activities` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL, `comment` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL, `admission_date` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `students_admission` -- INSERT INTO `students_admission` (`id`, `first_name`, `last_name`, `class`, `dob`, `parents_firstname`, `parents_lastname`, `gender`, `caste`, `religion`, `category`, `sslc`, `puc`, `degree`, `master_degree`, `address`, `city`, `country`, `phone`, `email`, `aadhaar_number`, `physicalhandicap`, `bank_holder_name`, `bank_name`, `account_number`, `ifsc_code`, `whether_employed`, `other_activities`, `comment`, `admission_date`) VALUES (5, 'Dk', 'Kamaliya', '3', '0000-00-00', 'Test Parent', 'Test Last Name', 'Male', 'Test Caste', 'Test Religion', 'Test category', 'SSLC', 'PUC', 'Degree', 'Master', 'B-402', 'Bvn', 'Dk', '9898244359', 'dk@gmail.com', '9895245655', '62665531', '5446266465', 'SBI', '5546848646466', 'IFSCCODE556', '', 'Sports,Cultural', 'test form submit', '2022-05-07 16:20:58'), (6, 'rdk', 'rd', '1', '2022-05-07', 'asdf', 'asdf', 'Male', 'Test Caste1', 'Test Religion1', 'Test category1', 'SSLC1', 'PUC1', 'Degree1', 'Master1', 'dasdf', 'asdf', 'rdk', '989824435933', 'dk@gmail.com', '222222', 'no', '5446266465', 'SBI2', '5546848643336466', 'IFSCCODE556', '', 'Sports,Cultural', 'dfasdfasdfasdf', '2022-05-07 16:24:54'), (7, 'Test', 'User', '4', '2022-02-16', 'Test Parents', 'User Parents', 'Male', 'Kshatriyas', 'India', 'SEBC', '50', '60', '70', '80', 'B-401', 'Bhavnagar', 'Test', '12345678901', 'test@gmail.com', '1234567890123456', '987654', 'Test User', 'SBI/Bhavnagar', '9876543210', 'IFSC01254', 'Yes', 'Sports,Cultural,Songs,Debate,NSS', 'test', '2022-02-25 14:51:41'), (8, 'Test', 'User', '4', '0000-00-00', 'Test Parents', 'User Parents', 'Male', 'Kshatriyas', 'India', 'SEBC', '50', '60', '70', '80', 'B-401', 'Bhavnagar', 'Test', '12345678901', 'test@gmail.com', '1234567890123456', '987654', 'Test User', 'SBI/Bhavnagar', '9876543210', 'IFSC01254', 'Yes', 'Sports,Cultural,Songs,Debate,NSS', 'test', '2022-02-25 14:52:15'), (9, 'Dk', 'Kamaliya', '3', '0000-00-00', 'Test Parent', 'Test Last Name', 'Male', 'Test Caste', 'Test Religion', 'Test category', 'SSLC', 'PUC', 'Degree', 'Master', 'B-402', 'Bvn', 'Dk', '9898244359', 'dk@gmail.com', '9895245655', '62665531', '5446266465', 'SBI', '5546848646466', 'IFSCCODE556', '', 'Sports,Cultural', 'test form submit', '2022-05-07 16:20:58'), (10, 'rdk', 'rd', '1', '2022-05-07', 'asdf', 'asdf', 'Male', 'Test Caste1', 'Test Religion1', 'Test category1', 'SSLC1', 'PUC1', 'Degree1', 'Master1', 'dasdf', 'asdf', 'rdk', '989824435933', 'dk@gmail.com', '222222', 'no', '5446266465', 'SBI2', '5546848643336466', 'IFSCCODE556', '', 'Sports,Cultural', 'dfasdfasdfasdf', '2022-05-07 16:24:54'); -- -------------------------------------------------------- -- -- Table structure for table `student_feedback` -- CREATE TABLE `student_feedback` ( `id` bigint(20) NOT NULL, `feedback_name` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `feedback_programme` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `feedback_course` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `feedback_teacher` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL, `feedback_year` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, `syllabus` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL, `backgroundforbenefiting` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL, `difficult` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL, `syllabuscovered` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL, `librarymaterial` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL, `extent` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL, `teacherprepare` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL, `teachersable` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL, `encouragesstudents` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL, `participationmethods` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL, `teacheradvising` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL, `teacherapproach` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL, `internalassessmen` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL, `internalassessment` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL, `teacherprovidefeedback` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL, `assignmentsdiscussed` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL, `coursecontributory` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL, `feedback_comment` varchar(800) COLLATE utf8mb4_unicode_ci NOT NULL, `created_date` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `student_feedback` -- INSERT INTO `student_feedback` (`id`, `feedback_name`, `feedback_programme`, `feedback_course`, `feedback_teacher`, `feedback_year`, `syllabus`, `backgroundforbenefiting`, `difficult`, `syllabuscovered`, `librarymaterial`, `extent`, `teacherprepare`, `teachersable`, `encouragesstudents`, `participationmethods`, `teacheradvising`, `teacherapproach`, `internalassessmen`, `internalassessment`, `teacherprovidefeedback`, `assignmentsdiscussed`, `coursecontributory`, `feedback_comment`, `created_date`) VALUES (2, 'student name', 'student Programme', 'student Course', 'student Teacher', ' 2022', 'Adequate', 'Adequate', 'Manageable', '70 to 85%', 'adequate', 'not available at all', 'indifferently ', 'generally ineffective ', 'Mostly yes', 'Encourage discussions out side class', 'notatall helpful', 'cannot say', 'Always fair', 'discouraging', 'often /late', 'not discussed at all', 'no', 'If you have other comments to offer on the course and suggestions for the teachers you may do so in the space given below or on a separate sheet', '2022-03-13 06:58:59'), (4, 'student name', 'student Programme', 'student Course', 'student Teacher', ' 2022', 'Adequate', 'Adequate', 'Manageable', '70 to 85%', 'adequate', 'not available at all', 'indifferently ', 'generally ineffective ', 'Mostly yes', 'Encourage discussions out side class', 'notatall helpful', 'cannot say', 'Always fair', 'discouraging', 'often /late', 'not discussed at all', 'no', 'If you have other comments to offer on the course and suggestions for the teachers you may do so in the space given below or on a separate sheet', '2022-03-13 06:59:19'), (5, 'student name', 'student Programme', 'student Course', 'student Teacher', ' 2022', 'Adequate', 'Adequate', 'Manageable', '70 to 85%', 'adequate', 'not available at all', 'indifferently ', 'generally ineffective ', 'Mostly yes', 'Encourage discussions out side class', 'notatall helpful', 'cannot say', 'Always fair', 'discouraging', 'often /late', 'not discussed at all', 'no', 'If you have other comments to offer on the course and suggestions for the teachers you may do so in the space given below or on a separate sheet', '2022-03-13 06:59:20'), (6, 'student name', 'student Programme', 'student Course', 'student Teacher', ' 2022', 'Adequate', 'Adequate', 'Manageable', '70 to 85%', 'adequate', 'not available at all', 'indifferently ', 'generally ineffective ', 'Mostly yes', 'Encourage discussions out side class', 'notatall helpful', 'cannot say', 'Always fair', 'discouraging', 'often /late', 'not discussed at all', 'no', 'If you have other comments to offer on the course and suggestions for the teachers you may do so in the space given below or on a separate sheet', '2022-03-13 06:59:20'), (7, 'student name', 'student Programme', 'student Course', 'student Teacher', ' 2022', 'Adequate', 'Adequate', 'Manageable', '70 to 85%', 'adequate', 'not available at all', 'indifferently ', 'generally ineffective ', 'Mostly yes', 'Encourage discussions out side class', 'notatall helpful', 'cannot say', 'Always fair', 'discouraging', 'often /late', 'not discussed at all', 'no', 'If you have other comments to offer on the course and suggestions for the teachers you may do so in the space given below or on a separate sheet', '2022-03-13 06:59:20'), (8, 'student name', 'student Programme', 'student Course', 'student Teacher', ' 2022', 'Adequate', 'Adequate', 'Manageable', '70 to 85%', 'adequate', 'not available at all', 'indifferently ', 'generally ineffective ', 'Mostly yes', 'Encourage discussions out side class', 'notatall helpful', 'cannot say', 'Always fair', 'discouraging', 'often /late', 'not discussed at all', 'no', 'If you have other comments to offer on the course and suggestions for the teachers you may do so in the space given below or on a separate sheet', '2022-03-13 06:59:20'), (9, 'student name', 'student Programme', 'student Course', 'student Teacher', ' 2022', 'Adequate', 'Adequate', 'Manageable', '70 to 85%', 'adequate', 'not available at all', 'indifferently ', 'generally ineffective ', 'Mostly yes', 'Encourage discussions out side class', 'notatall helpful', 'cannot say', 'Always fair', 'discouraging', 'often /late', 'not discussed at all', 'no', 'If you have other comments to offer on the course and suggestions for the teachers you may do so in the space given below or on a separate sheet', '2022-03-13 06:59:21'), (10, 'student name', 'student Programme', 'student Course', 'student Teacher', ' 2022', 'Adequate', 'Adequate', 'Manageable', '70 to 85%', 'adequate', 'not available at all', 'indifferently ', 'generally ineffective ', 'Mostly yes', 'Encourage discussions out side class', 'notatall helpful', 'cannot say', 'Always fair', 'discouraging', 'often /late', 'not discussed at all', 'no', 'If you have other comments to offer on the course and suggestions for the teachers you may do so in the space given below or on a separate sheet', '2022-03-13 06:59:44'); -- -------------------------------------------------------- -- -- Table structure for table `student_result` -- CREATE TABLE `student_result` ( `id` int(11) NOT NULL, `reg_no` int(11) NOT NULL, `subject` varchar(200) NOT NULL, `exam` varchar(250) NOT NULL, `theory_marks` varchar(11) NOT NULL, `practical_marks` varchar(11) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `student_result` -- INSERT INTO `student_result` (`id`, `reg_no`, `subject`, `exam`, `theory_marks`, `practical_marks`, `created_at`, `updated_at`) VALUES (2, 12, 'ABC', 'Test Exam', '20', '25', '2022-07-09 17:12:35', '2022-07-09 17:12:35'), (3, 13, 'ABC', 'Test Exam', '20', '25', '2022-07-09 17:12:35', '2022-07-09 17:12:35'), (4, 14, 'ABC', 'Test Exam', '20', '25', '2022-07-09 17:12:35', '2022-07-09 17:12:35'), (5, 15, 'ABC', 'Test Exam', '20', '25', '2022-07-09 17:12:35', '2022-07-09 17:12:35'), (6, 11, 'ABC 1', 'Test Exam', '20', '25', '2022-07-09 17:12:35', '2022-07-09 17:12:35'), (7, 12, 'ABC 1', 'Test Exam', '20', '25', '2022-07-09 17:12:36', '2022-07-09 17:12:36'), (8, 13, 'ABC 1', 'Test Exam', '20', '25', '2022-07-09 17:12:36', '2022-07-09 17:12:36'), (9, 14, 'ABC 1', 'Test Exam', '20', '25', '2022-07-09 17:12:36', '2022-07-09 17:12:36'), (10, 15, 'ABC 1', 'Test Exam', '20', '25', '2022-07-09 17:12:36', '2022-07-09 17:12:36'); -- -------------------------------------------------------- -- -- Table structure for table `testimonial` -- CREATE TABLE `testimonial` ( `id` int(11) NOT NULL, `name` varchar(200) NOT NULL, `section` varchar(200) NOT NULL, `description` longtext NOT NULL, `photo` varchar(200) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `testimonial` -- INSERT INTO `testimonial` (`id`, `name`, `section`, `description`, `photo`, `created_at`, `updated_at`) VALUES (1, 'Test', 'Student', ' <h2 class=\"\" style=\"font-family: \" source=\"\" sans=\"\" pro\",=\"\" -apple-system,=\"\" blinkmacsystemfont,=\"\" \"segoe=\"\" ui\",=\"\" roboto,=\"\" \"helvetica=\"\" neue\",=\"\" arial,=\"\" sans-serif,=\"\" \"apple=\"\" color=\"\" emoji\",=\"\" ui=\"\" symbol\";=\"\" color:=\"\" rgb(33,=\"\" 37,=\"\" 41);\"=\"\"><span style=\"font-weight: bolder;\"><u>About Me</u></span></h2><h6 class=\"\" style=\"font-family: \" source=\"\" sans=\"\" pro\",=\"\" -apple-system,=\"\" blinkmacsystemfont,=\"\" \"segoe=\"\" ui\",=\"\" roboto,=\"\" \"helvetica=\"\" neue\",=\"\" arial,=\"\" sans-serif,=\"\" \"apple=\"\" color=\"\" emoji\",=\"\" ui=\"\" symbol\";=\"\" color:=\"\" rgb(33,=\"\" 37,=\"\" 41);\"=\"\"><p segoe=\"\" ui\",=\"\" roboto,=\"\" \"helvetica=\"\" neue\",=\"\" arial,=\"\" \"noto=\"\" sans\",=\"\" \"liberation=\"\" sans-serif,=\"\" \"apple=\"\" color=\"\" emoji\",=\"\" \"segoe=\"\" ui=\"\" symbol\",=\"\" emoji\";\"=\"\">Lorem ipsum dolor sit amet. Ut commodi eaque id adipisci odio et repudiandae iure aut consequatur molestiae et quos quod ad quasi dicta et repellat eveniet. Ut odio veniam At nulla deleniti sed repellat temporibus et inventore pariatur.</p><p segoe=\"\" ui\",=\"\" roboto,=\"\" \"helvetica=\"\" neue\",=\"\" arial,=\"\" \"noto=\"\" sans\",=\"\" \"liberation=\"\" sans-serif,=\"\" \"apple=\"\" color=\"\" emoji\",=\"\" \"segoe=\"\" ui=\"\" symbol\",=\"\" emoji\";\"=\"\">Non eius quaerat et libero corrupti nam laboriosam quia. Sit dicta necessitatibus nam galisum optio sed illo laboriosam eum quam totam.</p><p segoe=\"\" ui\",=\"\" roboto,=\"\" \"helvetica=\"\" neue\",=\"\" arial,=\"\" \"noto=\"\" sans\",=\"\" \"liberation=\"\" sans-serif,=\"\" \"apple=\"\" color=\"\" emoji\",=\"\" \"segoe=\"\" ui=\"\" symbol\",=\"\" emoji\";\"=\"\">Est fugiat aperiam qui fugiat animi aut exercitationem voluptas qui necessitatibus voluptates in voluptatem sint. Est internos omnis id voluptas vitae non itaque.</p></h6> ', 'uploads/testimonial/testimonial_1657372696.jpg', '2022-07-09 13:18:16', '2022-07-09 17:53:14'), (3, 'Test Chairman', 'Chairman', 'Test <b><u>Chairman </u></b>', 'uploads/testimonial/testimonial_1657389174.jpg', '2022-07-09 17:52:54', '2022-07-09 17:52:54'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(11) NOT NULL, `username` varchar(100) NOT NULL, `password` varchar(100) NOT NULL, `is_active` int(11) NOT NULL DEFAULT 0, `user_type` int(11) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `username`, `password`, `is_active`, `user_type`, `created_at`, `updated_at`) VALUES (1, 'admin', 'Admin@123', 1, 1, '2022-07-02 05:39:15', '2022-07-03 06:00:54'); -- -------------------------------------------------------- -- -- Table structure for table `web_content` -- CREATE TABLE `web_content` ( `id` int(11) NOT NULL, `about_us` longtext NOT NULL, `vision` longtext NOT NULL, `mission` longtext NOT NULL, `moto` longtext NOT NULL, `objective` longtext NOT NULL, `contact_details` longtext NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `web_content` -- INSERT INTO `web_content` (`id`, `about_us`, `vision`, `mission`, `moto`, `objective`, `contact_details`) VALUES (1, ' <h2 class=\"\"><b><u>About Us</u></b></h2><h6 class=\"\"><p style=\"font-family: system-ui, -apple-system, \" segoe=\"\" ui\",=\"\" roboto,=\"\" \"helvetica=\"\" neue\",=\"\" arial,=\"\" \"noto=\"\" sans\",=\"\" \"liberation=\"\" sans-serif,=\"\" \"apple=\"\" color=\"\" emoji\",=\"\" \"segoe=\"\" ui=\"\" symbol\",=\"\" emoji\";\"=\"\">Lorem ipsum dolor sit amet. Ut commodi eaque id adipisci odio et repudiandae iure aut consequatur molestiae et quos quod ad quasi dicta et repellat eveniet. Ut odio veniam At nulla deleniti sed repellat temporibus et inventore pariatur.</p><p style=\"font-family: system-ui, -apple-system, \" segoe=\"\" ui\",=\"\" roboto,=\"\" \"helvetica=\"\" neue\",=\"\" arial,=\"\" \"noto=\"\" sans\",=\"\" \"liberation=\"\" sans-serif,=\"\" \"apple=\"\" color=\"\" emoji\",=\"\" \"segoe=\"\" ui=\"\" symbol\",=\"\" emoji\";\"=\"\">Non eius quaerat et libero corrupti nam laboriosam quia. Sit dicta necessitatibus nam galisum optio sed illo laboriosam eum quam totam.</p><p style=\"font-family: system-ui, -apple-system, \" segoe=\"\" ui\",=\"\" roboto,=\"\" \"helvetica=\"\" neue\",=\"\" arial,=\"\" \"noto=\"\" sans\",=\"\" \"liberation=\"\" sans-serif,=\"\" \"apple=\"\" color=\"\" emoji\",=\"\" \"segoe=\"\" ui=\"\" symbol\",=\"\" emoji\";\"=\"\">Est fugiat aperiam qui fugiat animi aut exercitationem voluptas qui necessitatibus voluptates in voluptatem sint. Est internos omnis id voluptas vitae non itaque atque qui excepturi repellendus iusto.</p></h6> ', ' <h2 class=\"\" style=\"font-family: \" source=\"\" sans=\"\" pro\",=\"\" -apple-system,=\"\" blinkmacsystemfont,=\"\" \"segoe=\"\" ui\",=\"\" roboto,=\"\" \"helvetica=\"\" neue\",=\"\" arial,=\"\" sans-serif,=\"\" \"apple=\"\" color=\"\" emoji\",=\"\" ui=\"\" symbol\";=\"\" color:=\"\" rgb(33,=\"\" 37,=\"\" 41);\"=\"\"><span style=\"font-weight: bolder;\"><u>Vision</u></span></h2><h6 class=\"\" style=\"font-family: \" source=\"\" sans=\"\" pro\",=\"\" -apple-system,=\"\" blinkmacsystemfont,=\"\" \"segoe=\"\" ui\",=\"\" roboto,=\"\" \"helvetica=\"\" neue\",=\"\" arial,=\"\" sans-serif,=\"\" \"apple=\"\" color=\"\" emoji\",=\"\" ui=\"\" symbol\";=\"\" color:=\"\" rgb(33,=\"\" 37,=\"\" 41);\"=\"\"><p segoe=\"\" ui\",=\"\" roboto,=\"\" \"helvetica=\"\" neue\",=\"\" arial,=\"\" \"noto=\"\" sans\",=\"\" \"liberation=\"\" sans-serif,=\"\" \"apple=\"\" color=\"\" emoji\",=\"\" \"segoe=\"\" ui=\"\" symbol\",=\"\" emoji\";\"=\"\">Lorem ipsum dolor sit amet. Ut commodi eaque id adipisci odio et repudiandae iure aut consequatur molestiae et quos quod ad quasi dicta et repellat eveniet. Ut odio veniam At nulla deleniti sed repellat temporibus et inventore pariatur.</p><p segoe=\"\" ui\",=\"\" roboto,=\"\" \"helvetica=\"\" neue\",=\"\" arial,=\"\" \"noto=\"\" sans\",=\"\" \"liberation=\"\" sans-serif,=\"\" \"apple=\"\" color=\"\" emoji\",=\"\" \"segoe=\"\" ui=\"\" symbol\",=\"\" emoji\";\"=\"\">Non eius quaerat et libero corrupti nam laboriosam quia. Sit dicta necessitatibus nam galisum optio sed illo laboriosam eum quam totam.</p><p segoe=\"\" ui\",=\"\" roboto,=\"\" \"helvetica=\"\" neue\",=\"\" arial,=\"\" \"noto=\"\" sans\",=\"\" \"liberation=\"\" sans-serif,=\"\" \"apple=\"\" color=\"\" emoji\",=\"\" \"segoe=\"\" ui=\"\" symbol\",=\"\" emoji\";\"=\"\">Est fugiat aperiam qui fugiat animi aut exercitationem voluptas qui necessitatibus voluptates in voluptatem sint. Est internos omnis id voluptas vitae non itaque.</p></h6> ', '<h2 class=\"\" source=\"\" sans=\"\" pro\",=\"\" -apple-system,=\"\" blinkmacsystemfont,=\"\" \"segoe=\"\" ui\",=\"\" roboto,=\"\" \"helvetica=\"\" neue\",=\"\" arial,=\"\" sans-serif,=\"\" \"apple=\"\" color=\"\" emoji\",=\"\" ui=\"\" symbol\";=\"\" color:=\"\" rgb(33,=\"\" 37,=\"\" 41);\"=\"\" style=\"font-family: "Source Sans Pro", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, "Helvetica Neue", Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol"; color: rgb(33, 37, 41);\"><span style=\"font-weight: bolder;\"><u>Mission</u></span></h2><h6 class=\"\" source=\"\" sans=\"\" pro\",=\"\" -apple-system,=\"\" blinkmacsystemfont,=\"\" \"segoe=\"\" ui\",=\"\" roboto,=\"\" \"helvetica=\"\" neue\",=\"\" arial,=\"\" sans-serif,=\"\" \"apple=\"\" color=\"\" emoji\",=\"\" ui=\"\" symbol\";=\"\" color:=\"\" rgb(33,=\"\" 37,=\"\" 41);\"=\"\" style=\"font-family: "Source Sans Pro", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, "Helvetica Neue", Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol"; color: rgb(33, 37, 41);\"><p segoe=\"\" ui\",=\"\" roboto,=\"\" \"helvetica=\"\" neue\",=\"\" arial,=\"\" \"noto=\"\" sans\",=\"\" \"liberation=\"\" sans-serif,=\"\" \"apple=\"\" color=\"\" emoji\",=\"\" \"segoe=\"\" ui=\"\" symbol\",=\"\" emoji\";\"=\"\">Lorem ipsum dolor sit amet. Ut commodi eaque id adipisci odio et repudiandae iure aut consequatur molestiae et quos quod ad quasi dicta et repellat eveniet. Ut odio veniam At nulla deleniti sed repellat temporibus et inventore pariatur.</p><p segoe=\"\" ui\",=\"\" roboto,=\"\" \"helvetica=\"\" neue\",=\"\" arial,=\"\" \"noto=\"\" sans\",=\"\" \"liberation=\"\" sans-serif,=\"\" \"apple=\"\" color=\"\" emoji\",=\"\" \"segoe=\"\" ui=\"\" symbol\",=\"\" emoji\";\"=\"\">Non eius quaerat et libero corrupti nam laboriosam quia. Sit dicta necessitatibus nam galisum optio sed illo laboriosam eum quam totam.</p><p segoe=\"\" ui\",=\"\" roboto,=\"\" \"helvetica=\"\" neue\",=\"\" arial,=\"\" \"noto=\"\" sans\",=\"\" \"liberation=\"\" sans-serif,=\"\" \"apple=\"\" color=\"\" emoji\",=\"\" \"segoe=\"\" ui=\"\" symbol\",=\"\" emoji\";\"=\"\">Est fugiat aperiam qui fugiat animi aut exercitationem voluptas qui necessitatibus voluptates in voluptatem sint. Est internos omnis id voluptas vitae non itaque.</p></h6> ', '<h2 class=\"\" source=\"\" sans=\"\" pro\",=\"\" -apple-system,=\"\" blinkmacsystemfont,=\"\" \"segoe=\"\" ui\",=\"\" roboto,=\"\" \"helvetica=\"\" neue\",=\"\" arial,=\"\" sans-serif,=\"\" \"apple=\"\" color=\"\" emoji\",=\"\" ui=\"\" symbol\";=\"\" color:=\"\" rgb(33,=\"\" 37,=\"\" 41);\"=\"\" style=\"font-family: "Source Sans Pro", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, "Helvetica Neue", Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol"; color: rgb(33, 37, 41);\"><span style=\"font-weight: bolder;\"><u>Moto</u></span></h2><h6 class=\"\" source=\"\" sans=\"\" pro\",=\"\" -apple-system,=\"\" blinkmacsystemfont,=\"\" \"segoe=\"\" ui\",=\"\" roboto,=\"\" \"helvetica=\"\" neue\",=\"\" arial,=\"\" sans-serif,=\"\" \"apple=\"\" color=\"\" emoji\",=\"\" ui=\"\" symbol\";=\"\" color:=\"\" rgb(33,=\"\" 37,=\"\" 41);\"=\"\" style=\"font-family: "Source Sans Pro", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, "Helvetica Neue", Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol"; color: rgb(33, 37, 41);\"><p segoe=\"\" ui\",=\"\" roboto,=\"\" \"helvetica=\"\" neue\",=\"\" arial,=\"\" \"noto=\"\" sans\",=\"\" \"liberation=\"\" sans-serif,=\"\" \"apple=\"\" color=\"\" emoji\",=\"\" \"segoe=\"\" ui=\"\" symbol\",=\"\" emoji\";\"=\"\">Lorem ipsum dolor sit amet. Ut commodi eaque id adipisci odio et repudiandae iure aut consequatur molestiae et quos quod ad quasi dicta et repellat eveniet. Ut odio veniam At nulla deleniti sed repellat temporibus et inventore pariatur.</p><p segoe=\"\" ui\",=\"\" roboto,=\"\" \"helvetica=\"\" neue\",=\"\" arial,=\"\" \"noto=\"\" sans\",=\"\" \"liberation=\"\" sans-serif,=\"\" \"apple=\"\" color=\"\" emoji\",=\"\" \"segoe=\"\" ui=\"\" symbol\",=\"\" emoji\";\"=\"\">Non eius quaerat et libero corrupti nam laboriosam quia. Sit dicta necessitatibus nam galisum optio sed illo laboriosam eum quam totam.</p><p segoe=\"\" ui\",=\"\" roboto,=\"\" \"helvetica=\"\" neue\",=\"\" arial,=\"\" \"noto=\"\" sans\",=\"\" \"liberation=\"\" sans-serif,=\"\" \"apple=\"\" color=\"\" emoji\",=\"\" \"segoe=\"\" ui=\"\" symbol\",=\"\" emoji\";\"=\"\">Est fugiat aperiam qui fugiat animi aut exercitationem voluptas qui necessitatibus voluptates in voluptatem sint. Est internos omnis id voluptas vitae non itaque.</p></h6> ', ' <h2 class=\"\" source=\"\" sans=\"\" pro\",=\"\" -apple-system,=\"\" blinkmacsystemfont,=\"\" \"segoe=\"\" ui\",=\"\" roboto,=\"\" \"helvetica=\"\" neue\",=\"\" arial,=\"\" sans-serif,=\"\" \"apple=\"\" color=\"\" emoji\",=\"\" ui=\"\" symbol\";=\"\" color:=\"\" rgb(33,=\"\" 37,=\"\" 41);\"=\"\" style=\"\"><b><u>Objective</u></b><br></h2><h6 class=\"\" source=\"\" sans=\"\" pro\",=\"\" -apple-system,=\"\" blinkmacsystemfont,=\"\" \"segoe=\"\" ui\",=\"\" roboto,=\"\" \"helvetica=\"\" neue\",=\"\" arial,=\"\" sans-serif,=\"\" \"apple=\"\" color=\"\" emoji\",=\"\" ui=\"\" symbol\";=\"\" color:=\"\" rgb(33,=\"\" 37,=\"\" 41);\"=\"\" style=\"font-family: \"><p segoe=\"\" ui\",=\"\" roboto,=\"\" \"helvetica=\"\" neue\",=\"\" arial,=\"\" \"noto=\"\" sans\",=\"\" \"liberation=\"\" sans-serif,=\"\" \"apple=\"\" color=\"\" emoji\",=\"\" \"segoe=\"\" ui=\"\" symbol\",=\"\" emoji\";\"=\"\">Lorem ipsum dolor sit amet. Ut commodi eaque id adipisci odio et repudiandae iure aut consequatur molestiae et quos quod ad quasi dicta et repellat eveniet. Ut odio veniam At nulla deleniti sed repellat temporibus et inventore pariatur.</p><p segoe=\"\" ui\",=\"\" roboto,=\"\" \"helvetica=\"\" neue\",=\"\" arial,=\"\" \"noto=\"\" sans\",=\"\" \"liberation=\"\" sans-serif,=\"\" \"apple=\"\" color=\"\" emoji\",=\"\" \"segoe=\"\" ui=\"\" symbol\",=\"\" emoji\";\"=\"\">Non eius quaerat et libero corrupti nam laboriosam quia. Sit dicta necessitatibus nam galisum optio sed illo laboriosam eum quam totam.</p><p segoe=\"\" ui\",=\"\" roboto,=\"\" \"helvetica=\"\" neue\",=\"\" arial,=\"\" \"noto=\"\" sans\",=\"\" \"liberation=\"\" sans-serif,=\"\" \"apple=\"\" color=\"\" emoji\",=\"\" \"segoe=\"\" ui=\"\" symbol\",=\"\" emoji\";\"=\"\">Est fugiat aperiam qui fugiat animi aut exercitationem voluptas qui necessitatibus voluptates in voluptatem sint. Est internos omnis id voluptas vitae non itaque.</p></h6> ', '<h2 class=\"\" source=\"\" sans=\"\" pro\",=\"\" -apple-system,=\"\" blinkmacsystemfont,=\"\" \"segoe=\"\" ui\",=\"\" roboto,=\"\" \"helvetica=\"\" neue\",=\"\" arial,=\"\" sans-serif,=\"\" \"apple=\"\" color=\"\" emoji\",=\"\" ui=\"\" symbol\";=\"\" color:=\"\" rgb(33,=\"\" 37,=\"\" 41);\"=\"\" style=\"font-family: "Source Sans Pro", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, "Helvetica Neue", Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol"; color: rgb(33, 37, 41);\"><span style=\"font-weight: bolder;\"><u>Contact Details</u></span><br></h2><h6 class=\"\" source=\"\" sans=\"\" pro\",=\"\" -apple-system,=\"\" blinkmacsystemfont,=\"\" \"segoe=\"\" ui\",=\"\" roboto,=\"\" \"helvetica=\"\" neue\",=\"\" arial,=\"\" sans-serif,=\"\" \"apple=\"\" color=\"\" emoji\",=\"\" ui=\"\" symbol\";=\"\" color:=\"\" rgb(33,=\"\" 37,=\"\" 41);\"=\"\" style=\"font-family: "Source Sans Pro", -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, "Helvetica Neue", Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol"; color: rgb(33, 37, 41);\"><p segoe=\"\" ui\",=\"\" roboto,=\"\" \"helvetica=\"\" neue\",=\"\" arial,=\"\" \"noto=\"\" sans\",=\"\" \"liberation=\"\" sans-serif,=\"\" \"apple=\"\" color=\"\" emoji\",=\"\" \"segoe=\"\" ui=\"\" symbol\",=\"\" emoji\";\"=\"\">Lorem ipsum dolor sit amet. Ut commodi eaque id adipisci odio et repudiandae iure aut consequatur molestiae et quos quod ad quasi dicta et repellat eveniet. Ut odio veniam At nulla deleniti sed repellat temporibus et inventore pariatur.</p><p segoe=\"\" ui\",=\"\" roboto,=\"\" \"helvetica=\"\" neue\",=\"\" arial,=\"\" \"noto=\"\" sans\",=\"\" \"liberation=\"\" sans-serif,=\"\" \"apple=\"\" color=\"\" emoji\",=\"\" \"segoe=\"\" ui=\"\" symbol\",=\"\" emoji\";\"=\"\">Non eius quaerat et libero corrupti nam laboriosam quia. Sit dicta necessitatibus nam galisum optio sed illo laboriosam eum quam totam.</p><p segoe=\"\" ui\",=\"\" roboto,=\"\" \"helvetica=\"\" neue\",=\"\" arial,=\"\" \"noto=\"\" sans\",=\"\" \"liberation=\"\" sans-serif,=\"\" \"apple=\"\" color=\"\" emoji\",=\"\" \"segoe=\"\" ui=\"\" symbol\",=\"\" emoji\";\"=\"\">Est fugiat aperiam qui fugiat animi aut exercitationem voluptas qui necessitatibus voluptates in voluptatem sint. Est internos omnis id voluptas vitae non itaque.</p></h6> '); -- -- Indexes for dumped tables -- -- -- Indexes for table `academic_calender` -- ALTER TABLE `academic_calender` ADD PRIMARY KEY (`id`); -- -- Indexes for table `achievers` -- ALTER TABLE `achievers` ADD PRIMARY KEY (`id`); -- -- Indexes for table `alumini` -- ALTER TABLE `alumini` ADD PRIMARY KEY (`id`); -- -- Indexes for table `alumni_feedback` -- ALTER TABLE `alumni_feedback` ADD PRIMARY KEY (`id`); -- -- Indexes for table `announcements_news` -- ALTER TABLE `announcements_news` ADD PRIMARY KEY (`id`); -- -- Indexes for table `committee` -- ALTER TABLE `committee` ADD PRIMARY KEY (`id`); -- -- Indexes for table `documents` -- ALTER TABLE `documents` ADD PRIMARY KEY (`id`); -- -- Indexes for table `enquiry` -- ALTER TABLE `enquiry` ADD PRIMARY KEY (`id`); -- -- Indexes for table `events` -- ALTER TABLE `events` ADD PRIMARY KEY (`id`); -- -- Indexes for table `facilities` -- ALTER TABLE `facilities` ADD PRIMARY KEY (`id`); -- -- Indexes for table `gallery` -- ALTER TABLE `gallery` ADD PRIMARY KEY (`id`); -- -- Indexes for table `staff_management` -- ALTER TABLE `staff_management` ADD PRIMARY KEY (`id`); -- -- Indexes for table `students` -- ALTER TABLE `students` ADD PRIMARY KEY (`id`); -- -- Indexes for table `students_admission` -- ALTER TABLE `students_admission` ADD PRIMARY KEY (`id`); -- -- Indexes for table `student_feedback` -- ALTER TABLE `student_feedback` ADD PRIMARY KEY (`id`); -- -- Indexes for table `student_result` -- ALTER TABLE `student_result` ADD PRIMARY KEY (`id`); -- -- Indexes for table `testimonial` -- ALTER TABLE `testimonial` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`); -- -- Indexes for table `web_content` -- ALTER TABLE `web_content` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `academic_calender` -- ALTER TABLE `academic_calender` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `achievers` -- ALTER TABLE `achievers` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `alumini` -- ALTER TABLE `alumini` MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `alumni_feedback` -- ALTER TABLE `alumni_feedback` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20; -- -- AUTO_INCREMENT for table `announcements_news` -- ALTER TABLE `announcements_news` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `committee` -- ALTER TABLE `committee` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `documents` -- ALTER TABLE `documents` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `enquiry` -- ALTER TABLE `enquiry` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `events` -- ALTER TABLE `events` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `facilities` -- ALTER TABLE `facilities` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `gallery` -- ALTER TABLE `gallery` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `staff_management` -- ALTER TABLE `staff_management` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `students` -- ALTER TABLE `students` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `students_admission` -- ALTER TABLE `students_admission` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `student_feedback` -- ALTER TABLE `student_feedback` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12; -- -- AUTO_INCREMENT for table `student_result` -- ALTER TABLE `student_result` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `testimonial` -- ALTER TABLE `testimonial` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `web_content` -- ALTER TABLE `web_content` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; 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 */;