-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `kvsc_college`
--

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

--
-- Table structure for table `about_us`
--

CREATE TABLE `about_us` (
  `a_id` int(11) NOT NULL,
  `p_msg` text NOT NULL,
  `added_on` datetime NOT NULL,
  `pic` varchar(300) NOT NULL,
  `flag` varchar(26) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `about_us`
--

INSERT INTO `about_us` (`a_id`, `p_msg`, `added_on`, `pic`, `flag`) VALUES
(1, '<p>Hello</p>', '2022-01-05 10:28:44', '', 'pp');

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

--
-- Table structure for table `aqar`
--

CREATE TABLE `aqar` (
  `aqar_id` int(11) NOT NULL,
  `aqar_file` varchar(255) NOT NULL,
  `added_on` datetime NOT NULL,
  `aqar_session` varchar(500) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `aqar`
--

INSERT INTO `aqar` (`aqar_id`, `aqar_file`, `added_on`, `aqar_session`) VALUES
(1, '89b3f7a867a918cf73d44f34196b6f92.pdf', '2022-08-10 16:50:19', 'Session 2021-2022'),
(3, '9229fe1c1c7cddfb2b5c51572efb65e2.pdf', '2022-09-16 09:09:40', 'Session 2019-2020 updated');

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

--
-- Table structure for table `fee_str`
--

CREATE TABLE `fee_str` (
  `fee_str_id` int(11) NOT NULL,
  `fee_str_file` varchar(255) NOT NULL,
  `added_on` datetime NOT NULL,
  `session` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fee_str`
--

INSERT INTO `fee_str` (`fee_str_id`, `fee_str_file`, `added_on`, `session`) VALUES
(2, '39b8144aaf8dbca5d0170e1256cda15d.pdf', '2022-09-16 08:58:41', 'Session 2019-2020 update');

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

--
-- Table structure for table `ssr`
--

CREATE TABLE `ssr` (
  `ssr_id` int(11) NOT NULL,
  `ssr_file` varchar(255) NOT NULL,
  `added_on` datetime NOT NULL,
  `session` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ssr`
--

INSERT INTO `ssr` (`ssr_id`, `ssr_file`, `added_on`, `session`) VALUES
(1, 'a756e71c719a9bbbaadcc53ebc4c3aef.pdf', '2022-08-10 17:29:01', 'Session 2021-2022 updated');

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

--
-- Table structure for table `tbl_acal`
--

CREATE TABLE `tbl_acal` (
  `acal_id` int(11) NOT NULL,
  `acal_file` varchar(255) NOT NULL,
  `added_on` datetime NOT NULL,
  `session` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_acal`
--

INSERT INTO `tbl_acal` (`acal_id`, `acal_file`, `added_on`, `session`) VALUES
(4, 'eeaf079637d18f1d6422bc6b3fb574cb.pdf', '2022-09-16 11:47:42', 'Session 2019-2020 updated');

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

--
-- Table structure for table `tbl_commitee`
--

CREATE TABLE `tbl_commitee` (
  `cc_id` int(11) NOT NULL,
  `committee_name` varchar(100) NOT NULL,
  `created_at` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `tbl_commitee`
--

INSERT INTO `tbl_commitee` (`cc_id`, `committee_name`, `created_at`) VALUES
(1, 'Placement/Career Counselling Cell', '2022-01-20 16:20:57'),
(2, 'College Developement Committee', '2022-01-20 16:21:11'),
(3, 'Disciplinary/Admission Committee', '2022-01-20 16:21:19'),
(4, 'Grievance/Redressal/Anti Ragging Cell', '2022-01-20 16:21:26'),
(5, 'Internal Quality Assurance Cell', '2022-01-20 16:21:34'),
(6, 'Advisory Committee for Central Library', '2022-01-20 16:21:39'),
(7, 'Women Cell/Anti Sexual Harassment Cell', '2022-01-20 16:21:49'),
(8, 'Steering Committee for NAAC', '2022-01-20 16:23:49'),
(9, 'new commitee', '2022-08-10 17:54:03');

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

--
-- Table structure for table `tbl_commitee_member`
--

CREATE TABLE `tbl_commitee_member` (
  `mem_id` int(11) NOT NULL,
  `mem_name` varchar(100) NOT NULL,
  `mem_deg` varchar(100) NOT NULL,
  `cc_id` int(11) NOT NULL,
  `dept_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `tbl_commitee_member`
--

INSERT INTO `tbl_commitee_member` (`mem_id`, `mem_name`, `mem_deg`, `cc_id`, `dept_id`) VALUES
(1, ' Sample of Placement/Career Counselling Cell', 'N/A', 1, 1),
(2, 'Sample of College Developement Committee', 'N/A Updated', 2, 1),
(3, 'Sample of Disciplinary/Admission Committee', 'N/A', 7, 1),
(4, ' Sample of Grievance/Redressal/Anti Ragging Cell', 'N/A', 4, 1),
(5, ' Sample of Internal Quality Assurance Cell', 'N/A', 5, 1),
(6, ' Sample of  Advisory Committee for Central Library', 'N/A', 6, 1),
(7, ' Sample of Women Cell/Anti Sexual Harassment Cell', 'N/A', 7, 1),
(8, 'Sample of Steering Committee for NAAC', 'N/A', 8, 1);

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

--
-- Table structure for table `tbl_contact`
--

CREATE TABLE `tbl_contact` (
  `con_id` int(11) NOT NULL,
  `fname` varchar(100) NOT NULL,
  `lname` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `mobile` varchar(10) NOT NULL,
  `message` varchar(200) NOT NULL,
  `date` varchar(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_department`
--

CREATE TABLE `tbl_department` (
  `dept_id` int(11) NOT NULL,
  `dept_name` varchar(50) NOT NULL,
  `date` varchar(30) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_department`
--

INSERT INTO `tbl_department` (`dept_id`, `dept_name`, `date`) VALUES
(1, 'N/A', '2022-01-20'),
(2, 'department updated', '2022-08-01'),
(3, 'department 1', '2022-08-01'),
(4, 'department 2', '2022-08-01');

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

--
-- Table structure for table `tbl_gallery`
--

CREATE TABLE `tbl_gallery` (
  `gal_id` int(11) NOT NULL,
  `text1` varchar(100) NOT NULL,
  `text2` varchar(100) NOT NULL,
  `pic` varchar(100) NOT NULL,
  `date` varchar(30) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_nonteacher`
--

CREATE TABLE `tbl_nonteacher` (
  `non_id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `fname` varchar(100) NOT NULL,
  `designation` varchar(100) NOT NULL,
  `mobile` varchar(10) NOT NULL,
  `gender` varchar(6) NOT NULL,
  `qualification` varchar(30) NOT NULL,
  `address` varchar(200) NOT NULL,
  `pic` varchar(100) NOT NULL,
  `dor` varchar(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_nonteacher`
--

INSERT INTO `tbl_nonteacher` (`non_id`, `name`, `fname`, `designation`, `mobile`, `gender`, `qualification`, `address`, `pic`, `dor`) VALUES
(3, 'demo staff updated', 'demo father', 'demo designation', '1111111111', 'female', 'B. Tech', 'ghar', '8c69aaf01f315dd0265559100e7bc1c1.jpg', '2022-09-20 07:54:50');

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

--
-- Table structure for table `tbl_notice`
--

CREATE TABLE `tbl_notice` (
  `file_id` int(11) NOT NULL,
  `notice` varchar(200) NOT NULL,
  `file_name` varchar(200) NOT NULL,
  `date` varchar(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_notice`
--

INSERT INTO `tbl_notice` (`file_id`, `notice`, `file_name`, `date`) VALUES
(6, 'this is dummy title', '7a2df2dcf732bfa542d7f18deaa69563.pdf', '2022-09-16 07:44:02'),
(7, 'this is new notification', '10c8a9623f239f13884fbf88031444d4.pdf', '2022-09-16 07:51:01'),
(8, 'this is new notification with file updated', 'debc7d3b954f72cc4a3b4072c62a23ce.pdf', '2022-09-16 07:53:40'),
(9, 'this is new dummy notice', 'f6bfebedca5497423b5f49956defe381.pdf', '2022-09-16 07:55:07'),
(10, 'dummy notice without file', '', '2022-09-21 08:27:22');

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

--
-- Table structure for table `tbl_pp`
--

CREATE TABLE `tbl_pp` (
  `pp_id` int(11) NOT NULL,
  `pp_name` varchar(60) DEFAULT NULL,
  `pp_tenure` varchar(60) DEFAULT NULL,
  `added_on` varchar(60) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_pp`
--

INSERT INTO `tbl_pp` (`pp_id`, `pp_name`, `pp_tenure`, `added_on`) VALUES
(1, 'Principal 1', '2018-19 updated', '2022-02-09 01:00:52'),
(2, 'Principal 2', '2019-20', '2022-02-15 12:27:54'),
(5, 'principal 3', '2020-2025', '2022-08-09 10:37:15');

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

--
-- Table structure for table `tbl_press`
--

CREATE TABLE `tbl_press` (
  `press_id` int(11) NOT NULL,
  `text1` varchar(100) NOT NULL,
  `text2` varchar(100) NOT NULL,
  `pic` varchar(100) NOT NULL,
  `date` varchar(30) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_slider`
--

CREATE TABLE `tbl_slider` (
  `slider_id` int(11) NOT NULL,
  `text1` varchar(100) NOT NULL,
  `text2` varchar(100) NOT NULL,
  `pic` varchar(100) NOT NULL,
  `date` varchar(30) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_slider`
--

INSERT INTO `tbl_slider` (`slider_id`, `text1`, `text2`, `pic`, `date`) VALUES
(6, 'Sldier 1', 'Slider 1', '72cfde7dc3bdbf59764a24bf2ddba3c0.jpg', '2022-09-26 11:29:40'),
(7, 'Sldier 2', 'Slider 2', 'c6aa3e2167ca309c93cb7b92e750f807.jpg', '2022-09-26 11:30:02'),
(8, 'Sldier 3', 'Slider 3', '5047262ea3b51c56740862a86fb8d3b8.jpg', '2022-09-26 11:30:14');

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

--
-- Table structure for table `tbl_teacher`
--

CREATE TABLE `tbl_teacher` (
  `tech_id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `dob` varchar(10) NOT NULL,
  `fname` varchar(100) NOT NULL,
  `gender` varchar(6) NOT NULL,
  `mobile` varchar(10) NOT NULL,
  `email` varchar(30) NOT NULL,
  `dept_id` int(11) NOT NULL,
  `designation` varchar(50) NOT NULL,
  `qualification` varchar(50) NOT NULL,
  `address` varchar(200) NOT NULL,
  `pic` varchar(100) NOT NULL,
  `dor` varchar(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_teacher`
--

INSERT INTO `tbl_teacher` (`tech_id`, `name`, `dob`, `fname`, `gender`, `mobile`, `email`, `dept_id`, `designation`, `qualification`, `address`, `pic`, `dor`) VALUES
(2, 'ravi gupta', '2022-09-21', 'shiva kant', 'male', '1244534383', 'rama@gmail.com', 5, 'teacher', 'B. Sc.', 'nirmal nagar', '', '2022-09-13 21:39:54'),
(3, 'Rama Kant', '2022-09-21', 'Shiva kant', 'male', '1111111111', 'shiva@gmail.com', 3, 'teacher', 'B. Ed.', 'Address', 'f2fcbef8575416fdd757ed218c77fd12.jpg', '2022-09-20 07:54:29'),
(4, 'Ganesh Kant', '2022-09-21', 'Shiva kant', 'male', '934739', 'ganesh@gmail.com', 3, 'lecture', '12th pass', 'Naya Ghar', '', '2022-09-13 21:43:32');

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

--
-- Table structure for table `time_table`
--

CREATE TABLE `time_table` (
  `t_id` int(11) NOT NULL,
  `time_table_file` varchar(255) NOT NULL,
  `added_on` datetime NOT NULL,
  `session` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `time_table`
--

INSERT INTO `time_table` (`t_id`, `time_table_file`, `added_on`, `session`) VALUES
(2, '2ff0f543d6e9664d22ef8040b693f4b7.pdf', '2022-09-16 08:56:48', 'session 2019-2020 updated');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `about_us`
--
ALTER TABLE `about_us`
  ADD PRIMARY KEY (`a_id`);

--
-- Indexes for table `aqar`
--
ALTER TABLE `aqar`
  ADD PRIMARY KEY (`aqar_id`);

--
-- Indexes for table `fee_str`
--
ALTER TABLE `fee_str`
  ADD PRIMARY KEY (`fee_str_id`);

--
-- Indexes for table `ssr`
--
ALTER TABLE `ssr`
  ADD PRIMARY KEY (`ssr_id`);

--
-- Indexes for table `tbl_acal`
--
ALTER TABLE `tbl_acal`
  ADD PRIMARY KEY (`acal_id`);

--
-- Indexes for table `tbl_commitee`
--
ALTER TABLE `tbl_commitee`
  ADD PRIMARY KEY (`cc_id`);

--
-- Indexes for table `tbl_commitee_member`
--
ALTER TABLE `tbl_commitee_member`
  ADD PRIMARY KEY (`mem_id`);

--
-- Indexes for table `tbl_contact`
--
ALTER TABLE `tbl_contact`
  ADD PRIMARY KEY (`con_id`);

--
-- Indexes for table `tbl_department`
--
ALTER TABLE `tbl_department`
  ADD PRIMARY KEY (`dept_id`);

--
-- Indexes for table `tbl_gallery`
--
ALTER TABLE `tbl_gallery`
  ADD PRIMARY KEY (`gal_id`);

--
-- Indexes for table `tbl_nonteacher`
--
ALTER TABLE `tbl_nonteacher`
  ADD PRIMARY KEY (`non_id`);

--
-- Indexes for table `tbl_notice`
--
ALTER TABLE `tbl_notice`
  ADD PRIMARY KEY (`file_id`);

--
-- Indexes for table `tbl_pp`
--
ALTER TABLE `tbl_pp`
  ADD PRIMARY KEY (`pp_id`);

--
-- Indexes for table `tbl_press`
--
ALTER TABLE `tbl_press`
  ADD PRIMARY KEY (`press_id`);

--
-- Indexes for table `tbl_slider`
--
ALTER TABLE `tbl_slider`
  ADD PRIMARY KEY (`slider_id`);

--
-- Indexes for table `tbl_teacher`
--
ALTER TABLE `tbl_teacher`
  ADD PRIMARY KEY (`tech_id`);

--
-- Indexes for table `time_table`
--
ALTER TABLE `time_table`
  ADD PRIMARY KEY (`t_id`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

--
-- AUTO_INCREMENT for table `fee_str`
--
ALTER TABLE `fee_str`
  MODIFY `fee_str_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `ssr`
--
ALTER TABLE `ssr`
  MODIFY `ssr_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

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

--
-- AUTO_INCREMENT for table `tbl_commitee`
--
ALTER TABLE `tbl_commitee`
  MODIFY `cc_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `time_table`
--
ALTER TABLE `time_table`
  MODIFY `t_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
COMMIT;

