-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Nov 05, 2024 at 06:13 AM
-- Server version: 10.4.32-MariaDB
-- PHP Version: 8.2.12

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: `logmieer_be`
--

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

--
-- Table structure for table `alumni`
--

CREATE TABLE `alumni` (
  `id` int(11) NOT NULL,
  `section` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `image_url` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `year` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `alumni`
--

INSERT INTO `alumni` (`id`, `section`, `type`, `title`, `image_url`, `description`, `year`) VALUES
(1, 'be_computer', 'mock_interview', 'Mock Interview 1', '../../uploads/Placements/download__1_-removebg-preview.png', 'Description for Mock Interview 1', '2023'),
(2, 'be_computer', 'alumni_meet', 'Alumni Meet 2022-23', '../../uploads/Placements/college-front-image.jpeg', 'Description for Alumni Meet 2022-23', '2023'),
(3, 'be_computer', 'distinguished_alumni', 'Dr. Kailas. V. Chandratre', '../../uploads/Placements/principal.jpg', 'SY B.E.', '2023'),
(4, 'be_computer', 'mock_interview', NULL, '../../uploads/Placements/download__2_-removebg-preview.png', NULL, NULL);

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

--
-- Table structure for table `computer_labs_content`
--

CREATE TABLE `computer_labs_content` (
  `id` int(11) NOT NULL,
  `section` varchar(100) DEFAULT NULL,
  `type` varchar(100) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `content` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `computer_labs_content`
--

INSERT INTO `computer_labs_content` (`id`, `section`, `type`, `title`, `link`, `image`, `content`) VALUES
(1, 'be_computer', 'specialized_lab', 'Centre of Excellence in Cyber Security with Softech Data Securities Ltd.', NULL, 'path/to/cyber_security_image.jpg', 'Details about the Centre of Excellence in Cyber Security.'),
(2, 'be_computer', 'specialized_lab', 'Centre of Excellence in Machine Learning with Castalia Research Lab Pvt. Ltd.', NULL, 'path/to/machine_learning_image.jpg', 'Details about the Centre of Excellence in Machine Learning.'),
(3, 'be_computer', 'lab', 'Parallel &amp; Distributed Computing Lab-II', NULL, '../../uploads/Research/about.jpg', 'This lab focuses on parallel computing and distributed systems.'),
(4, 'be_computer', 'lab', 'Big Data Analytics Lab', NULL, '../../uploads/Research/comp.png', 'This lab specializes in big data analytics technologies.'),
(5, 'be_computer', 'lab', 'Virtualization Lab', NULL, '../../uploads/Research/lab4.jpg', 'This lab provides resources for virtualization technologies.');

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

--
-- Table structure for table `contact`
--

CREATE TABLE `contact` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `position` varchar(100) NOT NULL,
  `phone` varchar(15) NOT NULL,
  `email` varchar(100) NOT NULL,
  `section` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `contact`
--

INSERT INTO `contact` (`id`, `name`, `position`, `phone`, `email`, `section`) VALUES
(1, 'John Doe', 'Head of Computer Science', '(123) 456-7890', 'johndoe@example.com', 'be_computer');

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

--
-- Table structure for table `department_coordinators`
--

CREATE TABLE `department_coordinators` (
  `id` int(11) NOT NULL,
  `section` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `qualification` varchar(50) NOT NULL,
  `image_url` varchar(255) NOT NULL,
  `description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `department_coordinators`
--

INSERT INTO `department_coordinators` (`id`, `section`, `name`, `qualification`, `image_url`, `description`) VALUES
(1, 'be_computer', 'Prof. Raess Shaikh', 'M.Tech', '../../uploads/Placements/principal.jpg', 'The department of Computer Engineering at Logimeer is committed to value-added quality technical education in Computer Engineering. The strong pillars of our department for UG and PG programs are the State-of-the-Art Infrastructure, Competent Faculty, and Hardworking Students. In addition to core academics, the students are provided with plenty of opportunities to develop and excel in curricular, co-curricular, and extra-curricular areas such as research, skills development, higher studies, industrial training, and placements. The program aims towards all-round development of the students to make them competent individuals for industry, academia, and research.');

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

--
-- Table structure for table `dynamic_about_content`
--

CREATE TABLE `dynamic_about_content` (
  `id` int(11) NOT NULL,
  `section` varchar(50) DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `content` text DEFAULT NULL,
  `image_url` varchar(255) DEFAULT NULL,
  `establishment_year` varchar(4) DEFAULT NULL,
  `intake` int(11) DEFAULT NULL,
  `dte_code` varchar(10) DEFAULT NULL,
  `affiliation` varchar(255) DEFAULT NULL,
  `vision` text DEFAULT NULL,
  `mission_1` text DEFAULT NULL,
  `mission_2` text DEFAULT NULL,
  `mission_3` text DEFAULT NULL,
  `mission_4` text DEFAULT NULL,
  `qualification` varchar(255) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `dynamic_about_content`
--

INSERT INTO `dynamic_about_content` (`id`, `section`, `type`, `title`, `content`, `image_url`, `establishment_year`, `intake`, `dte_code`, `affiliation`, `vision`, `mission_1`, `mission_2`, `mission_3`, `mission_4`, `qualification`, `name`) VALUES
(1, 'be_computer', 'About Us', 'About Us', 'The department of Computer Engineering at Logimeer is committed to value-added quality technical education in Computer Engineering. The strong pillars of our department for UG and PG programs are the State-of-the-Art Infrastructure, Competent Faculty, and Hardworking Students. In addition to core academics, the students are provided with plenty of opportunities to develop and excel in curricular, co-curricular, and extra-curricular areas such as research, skills development, higher studies, industrial training, and placements. The program aims towards all-round development of the students to make them competent individuals for industry, academia, and research.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4, 'be_computer', 'HOD Message', 'HOD\'s Message', 'The department of Computer Engineering at Logimeer...', '../../uploads/about/principal.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'M.Tech', 'Prof. Raess Shaikh'),
(5, 'be_computer', 'Board Of Studies', 'Board Of Studies', 'Prof. Dr. Sonali Patil, Chairman...', NULL, NULL, 0, NULL, 'Board Of Studies ', 'Prof. Dr. Sonali Patil, Chairman.. 11', NULL, NULL, NULL, NULL, NULL, NULL),
(6, 'be_computer', 'Overview', 'Overview of Department', NULL, NULL, '2011', 60, '6175', 'Savitribai Phule Pune University, Pune.', 'To be a premier Computer Engineering program by achieving excellence in Academics and Research for creating globally competent and ethical professionals.', 'To develop technologically competent and self-sustained professionals through contemporary curriculum.', 'To nurture innovative thinking and collaborative research, making a positive impact on society.', 'To provide state-of-the-art computing environment and learning opportunities through Center of Excellence.', 'To foster leadership skills and ethics with holistic development.', NULL, NULL),
(7, 'be_computer', 'Program Objectives', 'Overview of Department', NULL, '../../uploads/about/aim.png', '', 0, '', '', '', 'To develop technologically competent and self-sustained professionals through contemporary curriculum.', 'To nurture innovative thinking and collaborative research, making a positive impact on society.', 'To provide state-of-the-art computing environment and learning opportunities through Center of Excellence.', 'To foster leadership skills and ethics with holistic development. 111', NULL, NULL),
(8, 'be_computer', 'Board Of Studies', NULL, 'basdnjiajds', NULL, NULL, NULL, NULL, 'esfkejof', 'mklsjfdsjfird', NULL, NULL, NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `dynamic_academics_content`
--

CREATE TABLE `dynamic_academics_content` (
  `id` int(11) NOT NULL,
  `section` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `qualification` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `batch` varchar(255) DEFAULT NULL,
  `syllabus_pdf` varchar(255) DEFAULT NULL,
  `ty_syllabus_pdf` varchar(255) DEFAULT NULL,
  `final_year_syllabus_pdf` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `dynamic_academics_content`
--

INSERT INTO `dynamic_academics_content` (`id`, `section`, `type`, `title`, `name`, `qualification`, `image`, `batch`, `syllabus_pdf`, `ty_syllabus_pdf`, `final_year_syllabus_pdf`) VALUES
(1, 'be_computer', 'coordinator', 'Academic Coordinator', 'Dr. Kailas. V. Chandratre', 'SY B.E.', '../../uploads/academics/fac1.jpg', '', '', '', ''),
(2, 'be_computer', 'syllabus', 'SY B.Tech Syllabus 1', NULL, NULL, NULL, '2020-24', 'assets/pdf/SY-BTech-syllabus.pdf', 'assets/pdf/TYBTech-syllabus-22-23.pdf', 'assets/pdf/B.Tech-Comp-Engineering 2023-24.pdf'),
(3, 'be_computer', 'syllabus', 'SY B.Tech Syllabus', NULL, NULL, NULL, '2021-25', 'assets/pdf/V2-SY B.Tech Syllabus_02_08_22 _22-23.pdf', 'assets/pdf/V2-TY-B.Tech-Computer-Engineering 23-24.pdf', 'assets/pdf/Final-BTech-syllabus-2024-25.pdf'),
(4, 'be_computer', 'syllabus', 'SY B.Tech Syllabus', NULL, NULL, NULL, '2022-26', 'assets/pdf/V3-SY-B.Tech-Computer-Engineering 23-24.pdf', 'assets/pdf/TY-BTech-syllabus-2024-25.pdf', NULL),
(5, 'be_computer', 'syllabus', 'SY B.Tech Syllabus', NULL, NULL, NULL, '2023-27', 'assets/pdf/SY-BTech-Syllabus-2024-25.pdf', NULL, NULL);

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

--
-- Table structure for table `dynamic_home_content`
--

CREATE TABLE `dynamic_home_content` (
  `id` int(11) NOT NULL,
  `section` varchar(50) DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `text` text DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `dynamic_home_content`
--

INSERT INTO `dynamic_home_content` (`id`, `section`, `type`, `title`, `link`, `name`, `image`, `text`, `start_date`, `end_date`) VALUES
(15, 'be_computer', 'spotlight', 'Invitation to Participate in STTP on Emerging Trends in Blockchain Technology', 'assets/pdf/Flyer-STTP-EBCT-2024-Logimeer.pdf', NULL, NULL, 'From 15th July to 20th July 2024 in online mode.', NULL, NULL),
(16, 'be_computer', 'carousel', 'College Front Image', NULL, NULL, 'Assests/images/about.jpg', NULL, NULL, NULL),
(17, 'be_computer', 'carousel', 'Carousel Image 1', NULL, NULL, 'Assests/images/carousel-1.jpg', NULL, NULL, NULL),
(18, 'be_computer', 'news', 'Savitribai Phule Pune University', '', NULL, NULL, NULL, NULL, NULL),
(19, 'be_computer', 'news', 'Pimpri Chinchwad College Of Engineering', '', NULL, NULL, NULL, NULL, NULL),
(20, 'be_computer', 'news', 'All India Council for Technical Education', '', NULL, NULL, NULL, NULL, NULL),
(21, 'be_computer', 'news', 'NBA Documents', '', NULL, NULL, NULL, NULL, NULL),
(22, 'be_computer', 'info_card', 'COMPUTER DEPARTMENT', 'about', NULL, 'Assests/images/about.jpg', 'Computer Engineering at Logimeer is committed to value-added quality technical education.', NULL, NULL),
(23, 'be_computer', 'info_card', 'FROM HOD\'S DESK', 'about', NULL, 'Assests/images/vision.webp', 'Computer Engineering at Logimeer is committed to value-added quality technical education.', NULL, NULL),
(24, 'be_computer', 'info_card', 'VISION AND MISSION', 'about', NULL, 'Assests/images/logo.png', 'Computer Engineering at Logimeer is committed to value-added quality technical education.', NULL, NULL),
(25, 'be_computer', 'testimonial', 'Lorem P. Ipsum', NULL, NULL, 'Assests/images/test1.avif', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit.', NULL, NULL),
(26, 'be_computer', 'testimonial', 'Mr. Lorem Ipsum', NULL, NULL, 'Assests/images/test2.avif', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit.', NULL, NULL),
(27, 'be_computer', 'testimonial', 'Lorem Ipsum', NULL, NULL, 'Assests/images/test3.jpg', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit.', NULL, NULL),
(28, 'be_computer', 'publication', '2023-24', 'Journal Link', 'Conference Name', 'path/to/image1.jpg', 'Some description about the publication', '2023-01-01', '2024-01-01'),
(29, 'be_computer', 'copyright', '2022-23', 'Copyright Filed', 'Author Name', 'path/to/image2.jpg', 'Description about the copyright', '2022-05-01', '2023-05-01'),
(30, 'be_computer', 'patents', '2021-22', 'Patent Filed', 'Inventor Name', 'path/to/image3.jpg', 'Details about the patent', '2021-03-01', '2022-03-01'),
(31, 'be_computer', 'awards', 'Best Student Award', 'http://example.com/award-link', 'John Doe', 'http://example.com/image.jpg', 'Awarded for outstanding academic performance.', '2024-01-01', '2024-01-31'),
(32, 'be_computer', 'opportunities', 'Internship Opportunity', 'http://example.com/internship-link', NULL, 'http://example.com/internship-image.jpg', 'A great opportunity for students to intern at top companies.', '2024-02-01', '2024-03-01'),
(33, 'be_computer', 'student_activities', 'Tech Fest Participation', NULL, NULL, NULL, 'Students are encouraged to participate in the annual tech fest.', '2024-04-10', '2024-04-12'),
(34, 'be_computer', 'upcoming_event', 'Hackathon Event', 'http://example.com/hackathon', NULL, 'images/event_hackathon.jpg', 'Join the upcoming hackathon!', '2024-10-25', '2024-10-26'),
(35, 'be_computer', 'upcoming_event', 'Workshop on AI', 'http://example.com/ai_workshop', NULL, 'images/event_ai_workshop.jpg', 'Workshop on AI and Machine Learning', '2024-11-10', '2024-11-11'),
(36, 'be_computer', 'activity', 'Student Chapter of AI', 'http://example.com/ai_chapter', NULL, 'images/activity_ai.jpg', 'The student chapter focusing on AI research and development.', NULL, NULL),
(37, 'be_computer', 'activity', 'Robotics Club', 'http://example.com/robotics_club', NULL, 'images/activity_robotics.jpg', 'Robotics club for all students interested in automation and robotics.', NULL, NULL),
(38, 'be_computer', 'internship', 'Nike Internship', 'https://www.example.com/internship-guidelines', NULL, 'https://www.zarla.com/images/nike-logo-2400x2400-20220504.png?crop=1:1,smart&width=150&dpr=2', 'Industry Internship', NULL, NULL),
(39, 'be_computer', 'internship', 'Apple Internship', 'https://www.example.com/internship-guidelines', NULL, 'https://www.zarla.com/images/apple-logo-2400x2400-20220512-1.png?crop=1:1,smart&width=150&dpr=2', 'Online Internship', NULL, NULL),
(40, 'be_computer', 'internship', 'Google Internship', 'https://www.example.com/internship-guidelines', NULL, 'https://www.zarla.com/images/disney-logo-2400x2400-20220513-2.png?crop=1:1,smart&width=150&dpr=2', 'Research Internship', NULL, NULL);

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

--
-- Table structure for table `dynamic_people_content`
--

CREATE TABLE `dynamic_people_content` (
  `id` int(11) NOT NULL,
  `section` varchar(100) DEFAULT NULL,
  `type` varchar(100) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `designation` varchar(255) DEFAULT NULL,
  `qualification` varchar(255) DEFAULT NULL,
  `experience` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `contact` varchar(50) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `dynamic_people_content`
--

INSERT INTO `dynamic_people_content` (`id`, `section`, `type`, `name`, `designation`, `qualification`, `experience`, `email`, `contact`, `image`) VALUES
(1, 'be_computer', 'faculty', 'Dr. Kailas V. Chandratre', 'Principal', 'PhD in Computer Science', '15 years', 'kailas@example.com', '1234567890', '../../uploads/people/principal.jpg'),
(2, 'be_computer', 'faculty', 'Prof. Hemant Dhatrak', 'Professor', 'M.Tech in Computer Engineering', '10 years', 'hemant@example.com', '1234567891', '../../uploads/people/tpo.jpg'),
(3, 'be_computer', 'admin_staff', 'Ms. Seema Joshi', 'Administrative Officer', 'MBA', '8 years', 'seema@example.com', '9876543210', '../../uploads/people/pass3.jpg'),
(4, 'be_computer', 'admin_staff', 'Mr. Nitin Deshmukh', 'Assistant Administrator', 'BBA', '5 years', 'nitin@example.com', '9876543211', '../../uploads/people/pass1.jpg'),
(5, 'be_computer', 'faculty', 'Ajit', 'fsdefef', 'Ph.D, M.E (Mechanical Engg.)', '12', 'ajitchourashiya@gmail.com', '12334548995', '../../uploads/people/fac3.png');

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

--
-- Table structure for table `dynamic_research_content`
--

CREATE TABLE `dynamic_research_content` (
  `id` int(11) NOT NULL,
  `section` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `qualification` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `image_url` varchar(255) DEFAULT NULL,
  `role` varchar(255) DEFAULT NULL,
  `convener` varchar(255) DEFAULT NULL,
  `secretary` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `dynamic_research_content`
--

INSERT INTO `dynamic_research_content` (`id`, `section`, `type`, `title`, `name`, `qualification`, `description`, `image_url`, `role`, `convener`, `secretary`) VALUES
(1, 'be_computer', 'coordinator', 'Research and Innovation Coordinator', 'Prof. Raess Shaikh', 'M.Tech', 'The department of Computer Engineering at Logimeer is committed to value-added quality technical education in Computer Engineering. The strong pillars of our department for UG and PG programs are the State-of-the-Art Infrastructure, Competent Faculty, and Hardworking Students.', '../../uploads/Research/pass1.jpg', NULL, NULL, NULL),
(2, 'be_computer', 'team', NULL, 'Dr. Reena Kharat', NULL, NULL, NULL, 'R&D Coordinator', NULL, NULL),
(3, 'be_computer', 'team', NULL, 'Prof. Swati Chandurkar', NULL, NULL, NULL, 'Publication Coordinator', NULL, NULL),
(4, 'be_computer', 'team', NULL, 'Mrs. Smita Khairnar', NULL, NULL, NULL, 'Patents & IPR Coordinator', NULL, NULL),
(5, 'be_computer', 'team', NULL, 'Mrs. Shivani Pandey', NULL, NULL, NULL, 'Funding Proposal Coordinator', NULL, NULL),
(6, 'be_computer', 'team', NULL, 'Mrs. Shivani Pandey', NULL, NULL, NULL, 'Consultancy, Revenue Generation Coordinator', NULL, NULL),
(7, 'be_computer', 'team', NULL, 'Mrs. Sushma Vispute', NULL, NULL, NULL, 'Project Coordinator - UG', NULL, NULL),
(8, 'be_computer', 'team', NULL, 'Dr. Deepali Naik', NULL, NULL, NULL, 'Project Coordinator - PG', NULL, NULL),
(9, 'be_computer', 'team', NULL, 'Dr. Avinash Bhute', NULL, NULL, NULL, 'Ph.D. Coordinator', NULL, NULL),
(10, 'be_computer', 'team', NULL, 'Mrs. B. Mahalaxmi', NULL, NULL, NULL, 'Technical Seminar Coordinator - UG', NULL, NULL),
(11, 'be_computer', 'sig', 'Applied Artificial Intelligence in Visual Computing (AAIVC)', NULL, NULL, NULL, NULL, NULL, 'Prof. Dr. Sudeep D. Thepade', 'Mrs. Harshada Mhaske'),
(12, 'be_computer', 'sig', 'Biomedical Applications and Soft Computing (BASC)', NULL, NULL, NULL, NULL, NULL, 'Dr. Swati V. Shinde', 'Dr. Mubin Tamboli'),
(13, 'be_computer', 'sig', 'Machine Intelligence and Optimization Algorithms (MIOA)', NULL, NULL, NULL, NULL, NULL, 'Dr. Pravin S. Game', 'Prof. Archana Kadam'),
(14, 'be_computer', 'sig', 'Computer Networks and Information Security (CNIS)', NULL, NULL, NULL, NULL, NULL, 'Dr. Rachana Patil', 'Mrs. Rucha Shinde');

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

--
-- Table structure for table `dynamic_research_content_one`
--

CREATE TABLE `dynamic_research_content_one` (
  `id` int(11) NOT NULL,
  `section` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `text` text DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `dynamic_research_content_one`
--

INSERT INTO `dynamic_research_content_one` (`id`, `section`, `type`, `title`, `link`, `name`, `image`, `text`, `start_date`, `end_date`) VALUES
(2, 'be_computer', 'copyright', '2022-23', 'Copyright Filed', 'Author Name', '../../uploads/Research/achive5.jpg', 'Description about the copyright', '2022-05-01', '2023-05-01'),
(3, 'be_computer', 'patents', '2021-22', 'Patent Filed', 'Inventor Name', '../../uploads/Research/activi3.jpg', 'Details about the patent', '2021-03-01', '2022-03-01'),
(6, 'be_computer', 'publication', '2014', 'sdf', 'dsff', '../../uploads/Research/AICTE-logo.png', NULL, NULL, NULL);

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

--
-- Table structure for table `dynamic_student_corner_content`
--

CREATE TABLE `dynamic_student_corner_content` (
  `id` int(11) NOT NULL,
  `section` varchar(100) NOT NULL,
  `type` varchar(100) NOT NULL,
  `title` varchar(255) NOT NULL,
  `link` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `text` text DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `dynamic_student_corner_content`
--

INSERT INTO `dynamic_student_corner_content` (`id`, `section`, `type`, `title`, `link`, `name`, `image`, `text`, `start_date`, `end_date`, `created_at`) VALUES
(1, 'be_computer', 'awards', 'Best Student Award', 'http://example.com/award-link', 'John Doe', '../../uploads/student_corner/download__1_-removebg-preview.png', 'Awarded for outstanding academic performance.', '2024-01-01', '2024-01-31', '2024-10-19 06:10:29'),
(2, 'be_computer', 'opportunities', 'Internship Opportunity', 'http://example.com/internship-link', NULL, '../../uploads/student_corner/achive5.jpg', 'A great opportunity for students to intern at top companies.', '2024-02-01', '2024-03-01', '2024-10-19 06:10:29'),
(3, 'be_computer', 'student_activities', 'Tech Fest Participation', NULL, NULL, NULL, 'Students are encouraged to participate in the annual tech fest.', '2024-04-10', '2024-04-12', '2024-10-19 06:10:29'),
(4, 'be_computer', 'prof_body_stud_chapters', 'Chapter Title', 'https://example.com/link', NULL, '../../uploads/student_corner/collage-stud.jpg', 'This is a description for the professional body student chapter.', '2024-01-01', '2024-12-31', '2024-10-19 07:04:44'),
(6, 'be_computer', 'prof_body_stud_chapters', 'sdcdv', '../../uploads/student_corner/reduc.pdf', NULL, '../../uploads/student_corner/achive2.jpeg', 'dsfdf', NULL, NULL, '2024-10-29 11:18:25'),
(7, 'be_computer', 'awards', '', NULL, NULL, '../../uploads/student_corner/download (2).jfif', 'dfsfdsgvrsaggf wtrgr', NULL, NULL, '2024-10-30 04:48:48');

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

--
-- Table structure for table `internship`
--

CREATE TABLE `internship` (
  `id` int(11) NOT NULL,
  `section` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `logo_url` varchar(255) NOT NULL,
  `guideline_url` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `internship`
--

INSERT INTO `internship` (`id`, `section`, `type`, `description`, `logo_url`, `guideline_url`) VALUES
(8, 'be_computer', 'Industry/Government Organization Internship', 'Internship opportunities with various organizations.', 'https://www.zarla.com/images/nike-logo-2400x2400-20220504.png', 'https://example.com/guidelines1'),
(9, 'be_computer', 'AICTE-EduSkills Virtual Internship', 'Internships available on platforms like Internshala.', 'https://www.zarla.com/images/apple-logo-2400x2400-20220512-1.png', 'https://example.com/guidelines2'),
(10, 'be_computer', 'Online Internship at Amazon', 'Internships offered by top tech companies.', 'https://www.zarla.com/images/disney-logo-2400x2400-20220513-2.png', 'https://example.com/guidelines3'),
(11, 'be_computer', 'EDC & Start-ups', 'Internships for start-ups and in-house product development.', 'https://upload.wikimedia.org/wikipedia/en/thumb/4/4d/Loon_%28company%29_logo.svg/800px-Loon_%28company%29_logo.svg.png', 'https://example.com/guidelines4'),
(12, 'be_computer', 'Research Internship under Professors', 'Opportunities for research internships.', 'https://upload.wikimedia.org/wikipedia/en/thumb/3/37/Jumpman_logo.svg/1200px-Jumpman_logo.svg.png', 'https://example.com/guidelines5'),
(13, 'be_computer', 'NGO’s or Social Internships', 'Internships focused on social work.', 'https://www.svgrepo.com/show/303123/bmw-logo.svg', 'https://example.com/guidelines6'),
(14, 'be_computer', 'Open-source Contribution', 'Participate in open-source projects.', 'https://brandlogos.net/wp-content/uploads/2014/12/starbucks_coffee_company-logo_brandlogos.net_9jqys.png', 'https://example.com/guidelines7'),
(15, 'be_computer', '112e3255yr', '', '../../uploads/Placements/nirf-rank-logo.jpg', '../../uploads/Placements/Untitled design.pdf'),
(16, 'be_computer', '112e3255yr', '', '', NULL),
(17, 'be_computer', 'asdsgghjlkmn cfhkjhg', '', '', NULL),
(18, 'be_computer', 'Balance Sheet', '', '', NULL);

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

--
-- Table structure for table `placements`
--

CREATE TABLE `placements` (
  `id` int(11) NOT NULL,
  `section` varchar(50) DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `student_name` varchar(100) DEFAULT NULL,
  `company_name` varchar(100) DEFAULT NULL,
  `annual_salary` decimal(10,2) DEFAULT NULL,
  `year` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `placements`
--

INSERT INTO `placements` (`id`, `section`, `type`, `student_name`, `company_name`, `annual_salary`, `year`) VALUES
(2, 'be_computer', 'Top Salary Package', 'Jane Smith', 'Microsoft', 110000.00, '2023-24'),
(3, 'be_computer', 'Top Salary Package', 'Michael Brown', 'Amazon', 115000.00, '2023-24'),
(4, 'be_computer', 'Top Salary Package', 'Lisa Wong', 'Facebook', 125000.00, '2023-24'),
(5, 'be_computer', 'Top Salary Package', 'David Johnson', 'Apple', 130000.00, '2023-24'),
(6, 'be_computer', 'Major Recruiters', 'John Doe', 'Google', 120000.00, '2023-24'),
(7, 'be_computer', 'Major Recruiters', 'Jane Smith', 'Microsoft', 110000.00, '2023-24'),
(8, 'be_computer', 'Major Recruiters', 'Michael Brown', 'Amazon', 115000.00, '2023-24'),
(9, 'be_computer', 'Major Recruiters', 'Lisa Wong', 'Facebook', 125000.00, '2023-24'),
(10, 'be_computer', 'Major Recruiters', 'David Johnson', 'Apple', 130000.00, '2023-24');

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

--
-- Table structure for table `research_funding`
--

CREATE TABLE `research_funding` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `pi_coordinator` varchar(255) NOT NULL,
  `fund_granted` decimal(10,2) NOT NULL,
  `academic_year` varchar(10) NOT NULL,
  `funding_agency` varchar(255) NOT NULL,
  `status` varchar(50) NOT NULL,
  `section` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `research_funding`
--

INSERT INTO `research_funding` (`id`, `title`, `pi_coordinator`, `fund_granted`, `academic_year`, `funding_agency`, `status`, `section`) VALUES
(1, 'CerviTester: A Smart and Portable Screening Device for AI-Assisted Automated Diagnosis of Cervical Cancer in Low Resource Settings', 'Dr. Swati Shinde, Ms. Madhura Kalbhor', 3700000.00, '2020-21', 'DST-BDTD R&D Project', 'Ongoing', 'be_computer'),
(2, 'Women mental Health and Well being', 'Dr. Anuradha Thakare, Ms. Santwana Gudadhe', 50000.00, '2020-21', 'NCW, Delhi', 'Completed', 'be_computer'),
(3, 'MODROB – Artificial Intelligence and Robotics', 'Dr. K. Rajeswari, Ms. Pallavi Dhade', 946000.00, '2019-20', 'AICTE', 'About to Complete', 'be_computer'),
(4, 'Advanced Techniques for IT Enabled Healthcare', 'Dr. A. D. Thakare', 332000.00, '2019-20', 'AICTE', 'Completed', 'be_computer'),
(5, 'Grant by Maharastra Mahila Aayog for conducting workshop on “Digital Literacy for Women”', 'Dr. A. D. Thakre, Mrs. Santwana Gudadhe', 55000.00, '2019-20', 'Maharashtra State Commission for Women', 'Completed', 'be_computer'),
(6, 'IEEE Conference- ICCUBEA (2019)', 'Dr. S. V. Shinde', 500000.00, '2019-20', 'AICTE', 'Completed', 'be_computer'),
(7, 'International Seminar on Emotional Intelligence (two days)', 'Dr. J. S. Umale', 300000.00, '2018-19', 'SPPU-BCUD', 'Completed', 'be_computer'),
(8, 'Summer school on programming Languages: Principles and Practice', 'Dr. Sonali Patil', 216000.00, '2018-19', 'ACM', 'Completed', 'be_computer'),
(9, 'State Level FDP Holistic optimization for Databases', 'Dr. A. D. Thakare, Mr. Rahul Patil', 100000.00, '2017-18', 'SPPU-BCUD', 'Completed', 'be_computer'),
(10, 'Video Summarization through Analysis and key frame extraction of surveillance videos', 'Dr. S.D. Thepade', 100000.00, '2017-19', 'SPPU-BCUD', 'Completed', 'be_computer');

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

--
-- Table structure for table `student_achievements`
--

CREATE TABLE `student_achievements` (
  `id` int(11) NOT NULL,
  `academic_year` varchar(20) NOT NULL,
  `type` enum('achievement','research') NOT NULL,
  `content` text DEFAULT NULL,
  `image_url` varchar(255) DEFAULT NULL,
  `patents` varchar(255) DEFAULT NULL,
  `remark` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `student_achievements`
--

INSERT INTO `student_achievements` (`id`, `academic_year`, `type`, `content`, `image_url`, `patents`, `remark`) VALUES
(1, '2022-2023', 'achievement', 'Achieved first place in National Coding Competition.', '../../uploads/achievements/achive1.jpg', NULL, NULL),
(2, '2022-2023', 'achievement', 'Won the Best Project Award in TechFest.', 'https://example.com/images/achievement2.jpg', NULL, NULL),
(3, '2021-2022', 'achievement', 'Secured a scholarship for outstanding performance.', 'https://example.com/images/achievement3.jpg', NULL, NULL),
(4, '2022-2023', 'research', NULL, NULL, 'Patent 1: Innovative Algorithm for Data Processing', 'Successful completion and patent granted.'),
(5, '2021-2022', 'research', NULL, NULL, 'Patent 2: Smart Home Automation Device', 'Under review, expected approval next quarter.');

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

--
-- Table structure for table `student_activities`
--

CREATE TABLE `student_activities` (
  `id` int(11) NOT NULL,
  `section` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `text` text DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `student_activities`
--

INSERT INTO `student_activities` (`id`, `section`, `type`, `title`, `image`, `text`, `link`, `start_date`, `end_date`) VALUES
(1, 'be_computer', 'upcoming_event', 'Hackathon Event', 'images/event_hackathon.jpg', 'Join the upcoming hackathon!', 'http://example.com/hackathon', '2024-10-25', '2024-10-26'),
(2, 'be_computer', 'upcoming_event', 'Workshop on AI', 'images/event_ai_workshop.jpg', 'Workshop on AI and Machine Learning', 'http://example.com/ai_workshop', '2024-11-10', '2024-11-11'),
(3, 'be_computer', 'activity', 'Student Chapter of AI', 'images/activity_ai.jpg', 'The student chapter focusing on AI research and development.', 'http://example.com/ai_chapter', NULL, NULL),
(4, 'be_computer', 'activity', 'Robotics Club', 'images/activity_robotics.jpg', 'Robotics club for all students interested in automation and robotics.', 'http://example.com/robotics_club', NULL, NULL);

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

--
-- Table structure for table `student_satisfaction`
--

CREATE TABLE `student_satisfaction` (
  `id` int(11) NOT NULL,
  `section` varchar(255) NOT NULL,
  `parameter` varchar(255) NOT NULL,
  `overall_percentage` decimal(5,2) NOT NULL,
  `image_url` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `student_satisfaction`
--

INSERT INTO `student_satisfaction` (`id`, `section`, `parameter`, `overall_percentage`, `image_url`) VALUES
(1, 'be_computer', 'Academics', 75.73, '../../uploads/student_satisfaction/graph.png'),
(2, 'be_computer', 'Skill Development, Individual Growth and Overall Personality', 72.13, ''),
(3, 'be_computer', 'Infrastructural Facilities', 76.19, ''),
(4, 'be_computer', 'Scope and Facilities for Innovation, Research and Development', 72.53, ''),
(5, 'be_computer', 'Placement and Higher Studies', 77.60, ''),
(6, 'be_computer', 'Overall Students Satisfaction Set For 2022-23', 75.10, '');

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

--
-- Table structure for table `student_welfare`
--

CREATE TABLE `student_welfare` (
  `id` int(11) NOT NULL,
  `section` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `designation` varchar(255) DEFAULT NULL,
  `content` text DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `objective` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `student_welfare`
--

INSERT INTO `student_welfare` (`id`, `section`, `type`, `title`, `name`, `designation`, `content`, `image`, `objective`) VALUES
(1, 'be_computer', 'sdw', NULL, 'Prof. Raess Shaikh', 'M.Tech', 'The department of Computer Engineering at Logimeer is committed to value-added... 11', '../../uploads/student_corner/fac3.jpg', 'Lorem ipsum 1,Lorem ipsum 2,Lorem ipsum 3'),
(2, 'be_computer', 'aces', NULL, 'Sonali Patil', 'President', NULL, NULL, NULL),
(3, 'be_computer', 'aces', NULL, 'K. Rajeswari', 'Vice-President', NULL, NULL, NULL),
(4, 'be_computer', 'aces', NULL, 'S. D. Thepade', 'Subject Head', NULL, NULL, NULL),
(5, 'be_computer', 'aces', NULL, 'Swati Shinde', 'Subject Head', NULL, NULL, NULL),
(6, 'be_computer', 'aces', NULL, 'Ajit', 'Chairman', NULL, NULL, NULL);

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

--
-- Table structure for table `training`
--

CREATE TABLE `training` (
  `id` int(11) NOT NULL,
  `section` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `image_url` varchar(255) DEFAULT NULL,
  `text` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `training`
--

INSERT INTO `training` (`id`, `section`, `type`, `title`, `description`, `image_url`, `text`) VALUES
(1, 'be_computer', 'recent_visit', 'qsdawdsed', 'dsawd', '../../uploads/Placements/college-front-image.jpeg', 'swad'),
(2, 'be_computer', 'recent_visit', NULL, NULL, '../Assests/images/about.jpg', NULL),
(3, 'be_computer', 'recent_visit', NULL, NULL, '../Assests/images/achive1.jpg', NULL),
(4, 'be_computer', 'recent_visit', NULL, NULL, '../Assests/images/achive1.jpg', NULL),
(5, 'be_computer', 'industrial_visit', 'Industrial Visit 2022-2024 to NEXT IN Soft', '', '../Assests/images/about.jpg', NULL),
(6, 'be_computer', 'industrial_visit', 'Industrial Visit 2022-2024 to NEXT IN Soft', '', '../Assests/images/about.jpg', NULL),
(7, 'be_computer', 'visit_description', NULL, NULL, NULL, 'Industrial visit has its own importance in a career of a student who is pursuing a professional degree. We know, theoretical knowledge is not enough for making a good professional career. With an aim to go beyond academics, we at PCCoE, with the help of industry visits, sensitize students to the practical challenges that organizations face in the business world. Industrial visits also give greater clarity about various management concepts for students as they can practically see how these concepts are put into action.');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `training`
--
ALTER TABLE `training`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
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 */;
