-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jan 09, 2026 at 11:05 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: `old_content_management`
--

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

--
-- Table structure for table `admin`
--

CREATE TABLE `admin` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `username` varchar(255) NOT NULL,
  `password` varchar(50) NOT NULL,
  `email` varchar(255) NOT NULL,
  `usertype` varchar(50) NOT NULL,
  `subject` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`id`, `name`, `username`, `password`, `email`, `usertype`, `subject`) VALUES
(1, 'Admin', 'admin', 'admin@72', 'admin@gmail.com', 'Admin', 0);

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

--
-- Table structure for table `administration`
--

CREATE TABLE `administration` (
  `sno` int(11) NOT NULL,
  `name` varchar(25) NOT NULL,
  `usrname` varchar(25) NOT NULL,
  `passwd` varchar(25) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

--
-- Table structure for table `announcements`
--

CREATE TABLE `announcements` (
  `id` int(11) NOT NULL,
  `title` varchar(225) NOT NULL,
  `file` varchar(225) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `assignments`
--

CREATE TABLE `assignments` (
  `id` int(11) NOT NULL,
  `subject` int(11) NOT NULL,
  `semester` varchar(100) NOT NULL,
  `type_year` varchar(100) NOT NULL,
  `type_sem` varchar(100) NOT NULL,
  `title` varchar(225) NOT NULL,
  `download` varchar(225) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `course_offered`
--

CREATE TABLE `course_offered` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `content` longtext NOT NULL,
  `subject` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `course_outcomes`
--

CREATE TABLE `course_outcomes` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `content` longtext NOT NULL,
  `subject` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `departments`
--

CREATE TABLE `departments` (
  `id` int(11) NOT NULL,
  `name` varchar(225) NOT NULL,
  `background` varchar(50) NOT NULL,
  `sort_order` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `department_achievements`
--

CREATE TABLE `department_achievements` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `subject` int(11) NOT NULL,
  `file` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `department_admissions`
--

CREATE TABLE `department_admissions` (
  `id` int(11) NOT NULL,
  `profile` text NOT NULL,
  `subject` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `department_bests`
--

CREATE TABLE `department_bests` (
  `id` int(11) NOT NULL,
  `bests` text NOT NULL,
  `subject` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `department_bos`
--

CREATE TABLE `department_bos` (
  `id` int(11) NOT NULL,
  `bos` text NOT NULL,
  `subject` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `department_galleries`
--

CREATE TABLE `department_galleries` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `subject` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `department_guests`
--

CREATE TABLE `department_guests` (
  `id` int(11) NOT NULL,
  `guests` text NOT NULL,
  `subject` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `department_infrastructure`
--

CREATE TABLE `department_infrastructure` (
  `id` int(11) NOT NULL,
  `infrastructure` text NOT NULL,
  `subject` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `department_labs`
--

CREATE TABLE `department_labs` (
  `id` int(11) NOT NULL,
  `labs` text NOT NULL,
  `subject` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `department_other`
--

CREATE TABLE `department_other` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `other` text NOT NULL,
  `subject` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `department_papers`
--

CREATE TABLE `department_papers` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `download` varchar(255) NOT NULL,
  `subject` int(11) NOT NULL,
  `course_type` varchar(255) NOT NULL,
  `semister` varchar(50) NOT NULL,
  `type_year` varchar(100) NOT NULL,
  `type_sem` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `department_practices`
--

CREATE TABLE `department_practices` (
  `id` int(11) NOT NULL,
  `profile` text NOT NULL,
  `subject` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `department_profile`
--

CREATE TABLE `department_profile` (
  `id` int(11) NOT NULL,
  `profile` text NOT NULL,
  `subject` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `department_programmes`
--

CREATE TABLE `department_programmes` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `medium` varchar(100) NOT NULL,
  `course_type` varchar(10) NOT NULL,
  `subject` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `department_projects`
--

CREATE TABLE `department_projects` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `type` varchar(10) NOT NULL,
  `student_group` varchar(255) NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `subject` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `department_publications`
--

CREATE TABLE `department_publications` (
  `id` int(11) NOT NULL,
  `profile` text NOT NULL,
  `subject` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `department_rd`
--

CREATE TABLE `department_rd` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `content` text NOT NULL,
  `subject` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `department_research`
--

CREATE TABLE `department_research` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `research` text NOT NULL,
  `subject` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `department_result`
--

CREATE TABLE `department_result` (
  `id` int(11) NOT NULL,
  `result` text NOT NULL,
  `subject` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `department_skills`
--

CREATE TABLE `department_skills` (
  `id` int(11) NOT NULL,
  `skills` text NOT NULL,
  `subject` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `department_syllabus`
--

CREATE TABLE `department_syllabus` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `download` varchar(255) NOT NULL,
  `subject` int(11) NOT NULL,
  `course_type` varchar(50) NOT NULL,
  `semister` varchar(10) NOT NULL,
  `type_sem` varchar(100) NOT NULL,
  `type_year` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `department_timetable`
--

CREATE TABLE `department_timetable` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `download` varchar(255) NOT NULL,
  `subject` int(11) NOT NULL,
  `course_type` varchar(255) NOT NULL,
  `course_year` varchar(255) NOT NULL,
  `semister` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `department_vision`
--

CREATE TABLE `department_vision` (
  `id` int(11) NOT NULL,
  `vision` text NOT NULL,
  `subject` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `drvsk`
--

CREATE TABLE `drvsk` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `phone` varchar(50) NOT NULL,
  `email` varchar(255) NOT NULL,
  `address` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `event`
--

CREATE TABLE `event` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `file` varchar(255) NOT NULL,
  `event_type` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `events`
--

CREATE TABLE `events` (
  `eventid` int(11) NOT NULL,
  `doe` date NOT NULL,
  `title` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

--
-- Table structure for table `exams`
--

CREATE TABLE `exams` (
  `id` int(11) NOT NULL,
  `title` varchar(225) NOT NULL,
  `file` varchar(225) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `exam_results`
--

CREATE TABLE `exam_results` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `pdf` varchar(250) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `facilities`
--

CREATE TABLE `facilities` (
  `id` int(11) NOT NULL,
  `title` varchar(225) NOT NULL,
  `content` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

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

CREATE TABLE `faculty` (
  `id` int(11) NOT NULL,
  `photo` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `mobile` varchar(50) NOT NULL,
  `designation` varchar(255) NOT NULL,
  `qualification` varchar(255) NOT NULL,
  `experience` varchar(255) NOT NULL,
  `biodata` varchar(255) NOT NULL,
  `subject` int(11) NOT NULL,
  `staff_type` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `gallery`
--

CREATE TABLE `gallery` (
  `id` int(11) NOT NULL,
  `gallery_type` varchar(255) NOT NULL,
  `pid` int(11) NOT NULL,
  `title` varchar(225) NOT NULL,
  `image` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `infrastructure`
--

CREATE TABLE `infrastructure` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `content` longtext NOT NULL,
  `slug` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `instructions`
--

CREATE TABLE `instructions` (
  `id` int(11) NOT NULL,
  `subject` int(11) NOT NULL,
  `semester` varchar(100) NOT NULL,
  `type_year` varchar(100) NOT NULL,
  `type_sem` varchar(100) NOT NULL,
  `title` varchar(225) NOT NULL,
  `content` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `links`
--

CREATE TABLE `links` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `website` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `materials`
--

CREATE TABLE `materials` (
  `id` int(11) NOT NULL,
  `subject` int(11) NOT NULL,
  `semester` varchar(100) NOT NULL,
  `type_year` varchar(100) NOT NULL,
  `type_sem` varchar(100) NOT NULL,
  `title` varchar(225) NOT NULL,
  `download` varchar(225) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `media`
--

CREATE TABLE `media` (
  `id` int(11) NOT NULL,
  `file` varchar(255) NOT NULL,
  `date_created` varchar(200) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `news`
--

CREATE TABLE `news` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `file` varchar(255) NOT NULL,
  `news_type` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` int(11) NOT NULL,
  `title` varchar(225) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `content` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `photo_gallery`
--

CREATE TABLE `photo_gallery` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `press`
--

CREATE TABLE `press` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `program_outcomes`
--

CREATE TABLE `program_outcomes` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `content` longtext NOT NULL,
  `subject` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `questionpapers`
--

CREATE TABLE `questionpapers` (
  `id` int(11) NOT NULL,
  `subject` int(11) NOT NULL,
  `semester` varchar(100) NOT NULL,
  `type_year` varchar(100) NOT NULL,
  `type_sem` varchar(100) NOT NULL,
  `title` varchar(225) NOT NULL,
  `download` varchar(225) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `registered_students`
--

CREATE TABLE `registered_students` (
  `registerid` varchar(225) NOT NULL,
  `name` varchar(225) NOT NULL,
  `designation` varchar(225) NOT NULL,
  `address` varchar(225) NOT NULL,
  `cellno` varchar(225) NOT NULL,
  `emailid` varchar(225) NOT NULL,
  `amountpaid` int(11) NOT NULL,
  `mode` varchar(225) NOT NULL,
  `accomodation` varchar(225) NOT NULL,
  `participant` varchar(225) NOT NULL,
  `tranid` varchar(225) NOT NULL,
  `dot` varchar(225) NOT NULL,
  `notr` varchar(225) NOT NULL,
  `notb` varchar(225) NOT NULL,
  `botb` varchar(225) NOT NULL,
  `amount` int(11) NOT NULL,
  `utrno` varchar(225) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `registration`
--

CREATE TABLE `registration` (
  `regid` int(11) NOT NULL,
  `rno` int(11) NOT NULL,
  `fname` varchar(225) NOT NULL,
  `mname` varchar(225) NOT NULL,
  `lname` varchar(225) NOT NULL,
  `phone` varchar(225) NOT NULL,
  `mail` varchar(225) NOT NULL,
  `dob` varchar(225) NOT NULL,
  `country` varchar(225) NOT NULL,
  `state` varchar(225) NOT NULL,
  `city` varchar(225) NOT NULL,
  `street` varchar(225) NOT NULL,
  `pcode` varchar(225) NOT NULL,
  `scgpa` varchar(225) NOT NULL,
  `scountry` varchar(225) NOT NULL,
  `sstate` varchar(225) NOT NULL,
  `sboard` varchar(225) NOT NULL,
  `sschool` varchar(225) NOT NULL,
  `spassing` varchar(225) NOT NULL,
  `xcgpa` varchar(225) NOT NULL,
  `xcountry` varchar(225) NOT NULL,
  `xstate` varchar(225) NOT NULL,
  `xboard` varchar(225) NOT NULL,
  `xcollege` varchar(225) NOT NULL,
  `xpassing` varchar(225) NOT NULL,
  `gcgpa` varchar(225) NOT NULL,
  `gcountry` varchar(225) NOT NULL,
  `gstate` varchar(225) NOT NULL,
  `gboard` varchar(225) NOT NULL,
  `gcollege` varchar(225) NOT NULL,
  `gpassing` varchar(225) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `registrationn`
--

CREATE TABLE `registrationn` (
  `regid` int(11) NOT NULL,
  `rno` int(11) NOT NULL,
  `fname` varchar(225) NOT NULL,
  `mname` varchar(225) NOT NULL,
  `lname` varchar(225) NOT NULL,
  `phone` varchar(225) NOT NULL,
  `mail` varchar(225) NOT NULL,
  `dob` varchar(225) NOT NULL,
  `country` varchar(225) NOT NULL,
  `state` varchar(225) NOT NULL,
  `city` varchar(225) NOT NULL,
  `street` varchar(225) NOT NULL,
  `pcode` varchar(225) NOT NULL,
  `scgpa` varchar(225) NOT NULL,
  `scountry` varchar(225) NOT NULL,
  `sstate` varchar(225) NOT NULL,
  `sboard` varchar(225) NOT NULL,
  `sschool` varchar(225) NOT NULL,
  `spassing` varchar(225) NOT NULL,
  `xcgpa` varchar(225) NOT NULL,
  `xcountry` varchar(225) NOT NULL,
  `xstate` varchar(225) NOT NULL,
  `xboard` varchar(225) NOT NULL,
  `xcollege` varchar(225) NOT NULL,
  `xpassing` varchar(225) NOT NULL,
  `gcgpa` varchar(225) NOT NULL,
  `gcountry` varchar(225) NOT NULL,
  `gstate` varchar(225) NOT NULL,
  `gboard` varchar(225) NOT NULL,
  `gcollege` varchar(225) NOT NULL,
  `gpassing` varchar(225) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `seminors`
--

CREATE TABLE `seminors` (
  `id` int(11) NOT NULL,
  `seminor` varchar(255) NOT NULL,
  `seminor_type` int(11) NOT NULL,
  `image` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `seminor_types`
--

CREATE TABLE `seminor_types` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `content` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `slides`
--

CREATE TABLE `slides` (
  `id` int(11) NOT NULL,
  `image` varchar(255) NOT NULL,
  `sort_order` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `ss_achievements`
--

CREATE TABLE `ss_achievements` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `download` varchar(255) NOT NULL,
  `services` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `support_services`
--

CREATE TABLE `support_services` (
  `id` int(11) NOT NULL,
  `title` varchar(225) NOT NULL,
  `slug` varchar(225) NOT NULL,
  `content` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `updates`
--

CREATE TABLE `updates` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `updated_on` varchar(255) NOT NULL,
  `file` varchar(255) NOT NULL,
  `update_type` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

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

CREATE TABLE `videos` (
  `id` int(11) NOT NULL,
  `subject` int(11) NOT NULL,
  `semester` varchar(100) NOT NULL,
  `type_year` varchar(100) NOT NULL,
  `type_sem` varchar(100) NOT NULL,
  `title` varchar(225) NOT NULL,
  `video` varchar(225) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `administration`
--
ALTER TABLE `administration`
  ADD PRIMARY KEY (`sno`),
  ADD UNIQUE KEY `usrname` (`usrname`);

--
-- Indexes for table `assignments`
--
ALTER TABLE `assignments`
  ADD PRIMARY KEY (`id`);
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 */;