|
Server IP : 2a02:4780:3:1378:0:3736:a38e:10 / Your IP : 3.137.214.24 Web Server : LiteSpeed System : Linux sg-nme-web1278.main-hosting.eu 4.18.0-513.11.1.lve.el8.x86_64 #1 SMP Thu Jan 18 16:21:02 UTC 2024 x86_64 User : u926327694 ( 926327694) PHP Version : 7.4.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF Directory (0755) : /home/u926327694/domains/vidyaniketanschoolmudalgi.org/../svschool.in/public_html/db/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
-- phpMyAdmin SQL Dump -- version 5.2.0 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Feb 20, 2023 at 04:55 PM -- Server version: 5.7.24 -- PHP Version: 8.1.8 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: `ins` -- -- -------------------------------------------------------- -- -- 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 (11, 'TEST SERIES FOR II PU STUDENTS ', '2023-01-02', 'Notice', '', 'STARTS FROM 2 JAN 2023', 1, '2022-12-31 07:03:26', '2022-12-31 07:04:18'), (14, 'SANKRANTHI', '2023-01-15', 'Announcements', 'uploads/news_documents/news_documents_1673754014.jpg', 'HAPPY SANKRANTHI TO ALL <br>', 1, '2023-01-15 03:40:14', '2023-01-15 03:40:14'), (15, 'SAYABANNA TEGGINAMANI SCHOLRSHIP EXAM', '2024-04-16', 'Notice', '', 'WILL BE HELD ON APRIL 16 2023', 1, '2023-01-15 03:42:36', '2023-01-15 03:43:33'); -- -------------------------------------------------------- -- -- 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 (6, 'CULTURAL CLUB', 'MUKTUM BHAGAVAN ', 'LECTURE', 'CULTURAL CLUB', 1, 1, '2022-12-12 17:11:27', '2022-12-12 17:30:12'), (7, 'SPORTS CLUB ', 'MOUNESH ', 'MENTOR ', 'SPORTS CLUB', 2, 1, '2022-12-12 17:12:52', '2022-12-12 17:12:52'), (8, 'ART CLUB ', 'DURGAPPA', 'LECTURE', 'ART CLUB ', 3, 1, '2022-12-12 17:13:55', '2022-12-12 17:13:55'), (9, 'EXAMINATION CLUB ', 'VEERESH B H ', 'LECTURE', 'EXAMINATION CLUB ', 4, 1, '2022-12-12 17:14:39', '2022-12-12 17:14:39'), (10, 'THEORY CLUB ', 'MALLIKESH', 'LECTURE', 'THEORY CLUB ', 5, 1, '2022-12-12 17:15:36', '2022-12-12 17:15:36'), (11, 'NEET CLUB ', 'DR MOUNESH ', 'LECTURE', 'NEET CLUB ', 6, 1, '2022-12-12 17:16:07', '2022-12-12 17:16:07'), (12, 'HEALTH CLUB ', 'DR MOUNESH', 'LECTURE', 'HEALTH CLUB ', 7, 1, '2022-12-12 17:16:37', '2022-12-12 17:16:37'), (13, 'TRANSPORT CLUB ', 'SALIM PASHA', 'DRIVER', 'TRANSPORT CLUB ', 8, 1, '2022-12-12 17:17:13', '2022-12-12 17:17:13'), (14, 'ASSEMBLY CLUB', 'YOGISH ', 'LECTURE', 'ASSEMBLY CLUB', 9, 1, '2022-12-12 17:17:58', '2022-12-12 17:17:58'), (15, 'COUNSELLING CLUB ', 'RAMESH TEGGINAMANI', 'PRINCIPAL', 'COUNSELLING CLUB', 10, 1, '2022-12-12 17:18:35', '2022-12-12 17:18:35'), (16, 'RESULT CLUB ', 'SIMRANSRIVATSAV', 'LECTURE', 'RESULT CLUB ', 11, 1, '2022-12-12 17:19:33', '2022-12-12 17:19:33'), (17, 'JEE CLUB ', 'M MAZURUDDIN ', 'LECTURE', 'JEE CLUB ', 12, 1, '2022-12-12 17:20:34', '2022-12-12 17:20:34'), (18, 'HOSTEL MANAGEMENT CLUB ', 'NINGARAJ ', 'ADMINISTRATOR', 'HOSTEL MANAGEMENT CLUB ', 13, 1, '2022-12-12 17:21:11', '2022-12-12 17:21:11'), (19, 'ADMISSION CLUB ', 'DR MOUNESH', 'LECTURE', 'ADMISSION CLUB ', 14, 1, '2022-12-12 17:21:47', '2022-12-12 17:21:47'), (20, 'PUNISHMENT CLUB ', 'RAMESH TEGGINAMANI', 'PRINCIPAL', 'PUNISHMENT CLUB ', 15, 1, '2022-12-12 17:22:44', '2022-12-12 17:22:44'), (21, 'INFORMATIVE CLUB ', 'AMARANATH', 'LECTURE', 'INFORMATIVE CLUB ', 16, 1, '2022-12-12 17:23:50', '2022-12-12 17:23:50'), (22, 'SECURITY CLUB ', 'VERESH K ', 'WARDEN', 'SECURITY CLUB ', 17, 1, '2022-12-12 17:24:39', '2022-12-12 17:24:39'), (23, 'EVALUATION CLUB ', 'HEMALATHA', 'LECTURE', 'EVALUATION CLUB ', 18, 1, '2022-12-12 17:25:47', '2022-12-12 17:29:26'), (24, 'MAINTANANCE CLUB ', 'NINGARAJ', 'ADMINISTRATOR', 'MAINTANANCE CLUB ', 19, 1, '2022-12-12 17:26:23', '2022-12-12 17:27:41'), (25, 'CET , CUCET CLUB ', 'MOUNESH ', 'ADMINISTRATOR', 'CET , CUCET CLUB ', 20, 1, '2022-12-12 17:27:20', '2022-12-12 17:27:48'), (26, 'ETHICAL CLUB ', 'RAMESH TEGGINAMANI', 'PRINCIPAL', 'ETHICAL CLUB ', 21, 1, '2022-12-12 17:36:14', '2022-12-12 17:36:14'), (27, 'MOVIE CLUB ', 'YOGISH ', 'LECTURE', 'MOVIE CLUB ', 22, 1, '2022-12-12 17:37:05', '2022-12-12 17:37:05'), (28, 'FOOD CLUB ', 'SHANTA', 'WARDEN', 'FOOD CLUB ', 23, 1, '2022-12-12 17:37:49', '2022-12-12 17:37:49'), (29, 'EMERGENCY RESPONSE TEAM ', 'MOUNESH', 'ADMINISTRATOR', 'EMERGENCY RESPONSE TEAM ', 24, 1, '2022-12-12 17:39:14', '2022-12-12 17:39:14'), (30, 'ANTI DRUG COMMITTEE ', 'ANTI DRUG COMMITTE ', 'PRINCIPAL', 'PRINCIPAL', 22, 1, '2022-12-31 07:35:26', '2022-12-31 07:35:26'); -- -------------------------------------------------------- -- -- 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 (8, 'EXAM DATES AND IMPORTANAT INSTRUCTION ', 'NOTICE ', 'uploads/documents/documents_1672470697.pdf', ' ', 0, '2023-01-10 12:50:03', '2023-01-10 12:50:03'), (9, 'ANTI DRUG COMMITTE', 'ANTI DRUG COMMITTE ', 'uploads/documents/documents_1672472327.pdf', ' ', 1, '2022-12-31 07:38:47', '2022-12-31 07:38:47'), (10, 'ANTI DRUG COMMITTE', 'asdasd', 'uploads/documents/documents_1673354716.php', 'asdasd', 1, '2023-01-10 12:45:16', '2023-01-10 12:45:16'); -- -------------------------------------------------------- -- -- 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; -- -------------------------------------------------------- -- -- 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 (6, 'Independance day', 'photo 2', 'uploads/gallery/gallery_1661608975.jpeg', 'Gallery', 1, '2022-08-27 14:02:55', '2022-08-27 14:02:55'), (20, 'FESTIVAL ', 'CHILDRENS DAY ', 'uploads/gallery/gallery_1670931342.JPG', 'Gallery', 1, '2022-12-13 11:35:42', '2022-12-13 11:35:42'), (21, 'FESTIVAL ', 'CHILDRENS DAY', 'uploads/gallery/gallery_1670931396.JPG', 'Gallery', 1, '2022-12-13 11:36:36', '2022-12-13 11:36:36'), (22, 'GENIOUS STUDENT AWARD', 'AWARD', 'uploads/gallery/gallery_1670995440.JPG', 'Gallery', 1, '2022-12-14 05:24:00', '2022-12-14 05:24:00'), (24, 'GENIOUS STUDENT AWARD', 'AWARD', 'uploads/gallery/gallery_1670995600.JPG', 'Gallery', 1, '2022-12-14 05:26:40', '2022-12-14 05:26:40'), (25, 'FAREWELL ', 'AWARD', 'uploads/gallery/gallery_1670995628.JPG', 'Gallery', 1, '2022-12-14 05:27:08', '2022-12-14 05:27:08'), (26, 'FAREWELL ', 'AWARD', 'uploads/gallery/gallery_1670995654.JPG', 'Gallery', 1, '2022-12-14 05:27:34', '2022-12-14 05:27:34'), (27, 'FAREWELL ', 'DANCE', 'uploads/gallery/gallery_1670995830.JPG', 'Gallery', 1, '2022-12-14 05:30:30', '2022-12-14 05:30:30'), (28, 'FAREWELL ', 'DANCE', 'uploads/gallery/gallery_1670995882.JPG', 'Gallery', 1, '2022-12-14 05:31:22', '2022-12-14 05:31:22'), (29, 'GANESH FESTIVAL', 'FESTIVAL ', 'uploads/gallery/gallery_1670996254.JPG', 'Gallery', 1, '2022-12-14 05:37:34', '2022-12-14 05:37:34'), (30, 'GANESH FESTIVAL', 'FESTIVAL', 'uploads/gallery/gallery_1670996310.JPG', 'Gallery', 1, '2022-12-14 05:38:30', '2022-12-14 05:38:30'), (31, 'GANESH FESTIVAL', 'FESTIVAL', 'uploads/gallery/gallery_1670996503.JPG', 'Gallery', 1, '2022-12-14 05:41:43', '2022-12-14 05:41:43'), (32, 'ACHIEVERS ', 'NEET AND FARM SCIENCE ACHIEVERS ', 'uploads/gallery/gallery_1671102648.jpeg', 'Gallery', 1, '2022-12-15 11:10:48', '2022-12-15 11:10:48'), (33, 'NEET ACHIEVERS ', 'EXAM', 'uploads/gallery/gallery_1671102886.jpeg', 'Gallery', 1, '2022-12-15 11:14:46', '2022-12-15 11:14:46'), (36, 'EXAM', 'SAYABANNA TEGGINAMANI SCHOLRSHIP EXAM ', 'uploads/gallery/gallery_1671816258.JPG', 'Gallery', 1, '2022-12-23 17:24:18', '2022-12-23 17:24:18'), (37, 'sayonara', 'farewelll', 'uploads/gallery/gallery_1671932508.JPG', 'Gallery', 1, '2022-12-25 01:41:48', '2022-12-25 01:41:48'), (38, 'sayonara', 'sayonara', 'uploads/gallery/gallery_1671932536.JPG', 'Gallery', 1, '2022-12-25 01:42:16', '2022-12-25 01:42:16'), (39, 'sayonara', 'sayonara', 'uploads/gallery/gallery_1671932568.JPG', 'Gallery', 1, '2022-12-25 01:42:48', '2022-12-25 01:42:48'), (40, 'sayonara', 'sayonara', 'uploads/gallery/gallery_1671932595.JPG', 'Gallery', 1, '2022-12-25 01:43:15', '2022-12-25 01:43:15'), (41, 'sayonara', 'sayonara', 'uploads/gallery/gallery_1671932623.JPG', 'Gallery', 1, '2022-12-25 01:43:43', '2022-12-25 01:43:43'), (42, 'sayonara', 'sayonara', 'uploads/gallery/gallery_1671932718.JPG', 'Gallery', 1, '2022-12-25 01:45:18', '2022-12-25 01:45:18'), (43, 'childrens dat', 'CHILDRENS DAY', 'uploads/gallery/gallery_1671932796.JPG', 'Gallery', 1, '2022-12-25 01:46:36', '2022-12-25 01:46:36'), (44, 'childrens day', 'CHILDRENS DAY', 'uploads/gallery/gallery_1671932886.JPG', 'Gallery', 1, '2022-12-25 01:48:06', '2022-12-25 01:48:06'), (45, 'childrens day', 'CHILDRENS DAY', 'uploads/gallery/gallery_1671932935.JPG', 'Gallery', 1, '2022-12-25 01:48:55', '2022-12-25 01:48:55'), (46, 'childrens day', 'CHILDRENS DAY', 'uploads/gallery/gallery_1671932999.JPG', 'Gallery', 1, '2022-12-25 01:49:59', '2022-12-25 01:49:59'), (47, 'childrens day', 'CHILDRENS DAY', 'uploads/gallery/gallery_1671933040.JPG', 'Gallery', 1, '2022-12-25 01:50:40', '2022-12-25 01:50:40'), (48, 'childrens day', 'CHILDRENS DAY', 'uploads/gallery/gallery_1671933104.JPG', 'Gallery', 1, '2022-12-25 01:51:44', '2022-12-25 01:51:44'), (49, 'childrens day', 'CHILDRENS DAY', 'uploads/gallery/gallery_1671933183.JPG', 'Gallery', 1, '2022-12-25 01:53:03', '2022-12-25 01:53:03'), (50, 'childrens day', 'CHILDRENS DAY', 'uploads/gallery/gallery_1671933205.JPG', 'Gallery', 1, '2022-12-25 01:53:25', '2022-12-25 01:53:25'), (51, 'FUN GAMES ', 'FUN GAMES ', 'uploads/gallery/gallery_1672469869.JPG', 'Gallery', 1, '2022-12-31 06:57:49', '2022-12-31 06:57:49'), (52, 'SAYONARA 22 ', 'BY INSOMNIAC', 'uploads/gallery/gallery_1672469973.JPG', 'Gallery', 1, '2022-12-31 06:59:33', '2022-12-31 06:59:33'), (53, 'SAYONARA 22 ', 'BY INSOMNIAC 21', 'uploads/gallery/gallery_1672470030.JPG', 'Gallery', 1, '2022-12-31 07:00:30', '2022-12-31 07:00:30'), (54, 'SCOUT AND GUIDES ', 'RANGERS ', 'uploads/gallery/gallery_1672473206.jpeg', 'Gallery', 1, '2022-12-31 07:53:26', '2022-12-31 07:53:26'), (55, 'FUN GAMES ', 'asdasd', 'uploads/gallery/gallery_1673354791.php', 'Gallery', 1, '2023-01-10 12:46:31', '2023-01-10 12:46:31'), (56, 'SAYONARA 22 ', 'asdsd', 'uploads/gallery/gallery_1673355130.PhP', 'Gallery', 1, '2023-01-10 12:52:10', '2023-01-10 12:52:10'), (57, 'FESTIVAL ', 'Test', 'uploads/gallery/gallery_1676652103.jpg', 'Gallery', 1, '2023-02-17 16:41:43', '2023-02-17 16:41:43'), (58, 'FESTIVAL ', 'Test', 'uploads/gallery/gallery_1676652108.jpg', 'Gallery', 1, '2023-02-17 16:41:48', '2023-02-17 16:41:48'), (59, 'FESTIVAL ', 'Test', 'uploads/gallery/gallery_1676652111.jpg', 'Gallery', 1, '2023-02-17 16:41:51', '2023-02-17 16:41:51'); -- -------------------------------------------------------- -- -- Table structure for table `slider` -- CREATE TABLE `slider` ( `id` int(11) NOT NULL, `img` varchar(250) NOT NULL, `title` varchar(200) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `slider` -- INSERT INTO `slider` (`id`, `img`, `title`) VALUES (1, 'uploads/slider/alumini_1676565564.jpg', 'Education is the most powerful Weapon'), (2, 'uploads/slider/alumini_1676565577.jpg', 'Education is the most powerful Weapon 123'); -- -------------------------------------------------------- -- -- 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 (8, 'RAMESH TEGGINAMANI', 'PHYSICS', 'FOUNDER PRESIDENT ', '9611919028', 'SMVPUSC@GMAIL.COM', 'Msc Bed PHD', 'Management', 'uploads/staff_management/staff_1670863836.JPG', ' Our sense of purpose is to empower our students to make a positive impact on their world <br> ', 1, '2022-12-12 16:50:36', '2022-12-13 10:48:38'), (9, 'BASAMMA S TEGGINAMANI ', 'ADMINISTRATION ', 'PRESIDENT ', '9880106033', 'SMVPUSC@GMAIL.COM', 'BA', 'Management', 'uploads/staff_management/staff_1670997823.JPG', ' MAIN AIM OF THE INSTITUTE IS TO PROVIDE QUALITY EDUCATION IN AFFORDABLE WAY <br> ', 1, '2022-12-12 16:56:51', '2022-12-14 06:03:43'), (10, 'MOUNESH ', 'ADMINISTRATION', 'ADMINISTRATOR', '8660414339', 'mouneshsmali@gmail.com', 'BE 9CIVIL)', 'Administrator', 'uploads/staff_management/staff_1670998625.jpeg', ' ', 1, '2022-12-12 17:03:47', '2022-12-14 06:17:05'), (11, 'Mr.Mulagani Yogeswara rao', 'MATHEMATICS', 'LECTURE', '8801381381', 'SMVPUSC@GMAIL.COM', 'Msc Bed', 'Staff', 'uploads/staff_management/staff_1670927534.JPG', ' ', 1, '2022-12-13 10:32:14', '2022-12-13 10:32:14'), (12, 'Simransrivastav', 'BIOLOGY', 'HOD ', '7899689959', 'SMVPUSC@GMAIL.COM', 'Msc Bed', 'Staff', 'uploads/staff_management/staff_1670927718.JPG', ' ', 1, '2022-12-13 10:35:18', '2022-12-13 10:35:18'), (13, 'Beerappa', 'KANNADA', 'LECTURE', '9740721235', 'SMVPUSC@GMAIL.COM', 'MA Bed', 'Staff', 'uploads/staff_management/staff_1670927826.JPG', ' ', 1, '2022-12-13 10:37:06', '2022-12-13 10:37:06'), (14, 'Muktum sab', 'HINDI', 'LECTURE', '9481548068', 'SMVPUSC@GMAIL.COM', 'MA Bed', 'Staff', 'uploads/staff_management/staff_1670928026.JPG', ' ', 1, '2022-12-13 10:40:26', '2022-12-13 10:40:26'), (15, 'Mr.VEERESH BASAPPA HULIKERI', 'MATHEMATICS', 'HOD', '7829819999', 'SMVPUSC@GMAIL.COM', 'Msc Bed', 'Staff', 'uploads/staff_management/staff_1670928150.JPG', ' ', 1, '2022-12-13 10:42:30', '2022-12-13 10:42:30'), (16, 'Mallikesh', 'BIOLOGY', 'LECTURE', '8971903509', 'SMVPUSC@GMAIL.COM', 'Msc Bed', 'Staff', 'uploads/staff_management/staff_1670928362.JPG', ' ', 1, '2022-12-13 10:46:02', '2022-12-13 10:46:02'), (17, 'Mr.Mohamed Mazharuddin', 'PHYSICS', 'HOD', '9611516400', 'SMVPUSC@GMAIL.COM', 'Msc Bed PHD', 'Staff', 'uploads/staff_management/staff_1670928614.JPG', ' ', 1, '2022-12-13 10:50:14', '2022-12-13 10:50:14'), (18, 'Mr.Durgappa', 'HISTORY', 'LECTURE', '9663684543', 'SMVPUSC@GMAIL.COM', 'MA Bed', 'Staff', 'uploads/staff_management/staff_1670928762.JPG', ' ', 1, '2022-12-13 10:52:42', '2022-12-13 10:52:42'), (19, 'Amaranath', 'ACCOUNTANCY ', 'LECTURE', '8050990001', 'SMVPUSC@GMAIL.COM', 'Mcom Bed', 'Staff', 'uploads/staff_management/staff_1670929120.JPG', ' ', 1, '2022-12-13 10:58:40', '2022-12-13 10:58:40'), (20, 'Rajashekhar', 'ENGLISH', 'LECTURE', '8951633963', 'SMVPUSC@GMAIL.COM', 'MA Bed', 'Staff', 'uploads/staff_management/staff_1670929305.JPG', ' ', 1, '2022-12-13 11:01:45', '2022-12-13 11:01:45'), (21, ' B hemalatha', 'CHEMISTRY', 'LECTURE', '9380591022', 'SMVPUSC@GMAIL.COM', 'Msc Bed', 'Staff', 'uploads/staff_management/staff_1670930434.JPG', ' ', 1, '2022-12-13 11:20:34', '2022-12-13 11:20:34'), (22, 'PAGIDIMARRI AJAYAKUMAR ', 'CHEMISTRY', 'HOD', '9966989417', 'SMVPUSC@GMAIL.COM', 'Msc Bed', 'Staff', 'uploads/staff_management/staff_1670930631.JPG', ' ', 1, '2022-12-13 11:23:51', '2022-12-13 11:23:51'), (23, 'NAGAMMA AIHOLE ', 'ECONOMICS ', 'LECTURE', '9611507993', 'SMVPUSC@GMAIL.COM', 'MA Bed', 'Staff', 'uploads/staff_management/staff_1670930910.JPG', ' ', 1, '2022-12-13 11:28:30', '2022-12-13 11:28:30'), (24, 'GANGA', 'SOCIOLOGY', 'LECTURE', '8951633963', 'SMVPUSC@GMAIL.COM', 'MA Bed', 'Staff', 'uploads/staff_management/staff_1670930988.JPG', ' ', 1, '2022-12-13 11:29:48', '2022-12-13 11:29:48'), (25, 'DR MOUNESH', 'BIOLOGY', 'LECTURE', '8951633963', 'SMVPUSC@GMAIL.COM', 'BAMS', 'Staff', 'uploads/staff_management/staff_1670931187.JPG', ' ', 1, '2022-12-13 11:33:07', '2022-12-13 11:33:07'), (26, 'Viresh', 'HOSTEL', 'WARDEN', '895128873', 'SMVPUSC@GMAIL.COM', 'BA', 'Non-Teaching', 'uploads/staff_management/staff_1670931704.JPG', ' ', 1, '2022-12-13 11:41:44', '2022-12-13 11:41:44'), (27, 'SWATHI', 'COMPUTER', 'COMPUTER OPERATOR', '7338349640', 'SMVPUSC@GMAIL.COM', 'BA', 'Non-Teaching', 'uploads/staff_management/staff_1670931821.JPG', ' ', 1, '2022-12-13 11:43:41', '2022-12-13 11:43:41'), (28, 'saleem pasha', 'TRANSPORT', 'DRIVER', '9741651458', 'SMVPUSC@GMAIL.COM', 'PUC', 'Non-Teaching', 'uploads/staff_management/staff_1670931933.JPG', ' ', 1, '2022-12-13 11:45:33', '2022-12-13 11:45:33'), (29, 'JAFER', 'TRANSPORT', 'DRIVER', '9741651458', 'SMVPUSC@GMAIL.COM', 'PUC', 'Non-Teaching', 'uploads/staff_management/staff_1670932003.JPG', ' ', 1, '2022-12-13 11:46:43', '2022-12-13 11:46:43'), (30, 'SUSHMITHA', 'PHYSICS', 'LECTURE', '8951633963', 'SMVPUSC@GMAIL.COM', 'Msc Bed', 'Staff', 'uploads/staff_management/staff_1670932116.JPG', ' ', 1, '2022-12-13 11:48:36', '2022-12-13 11:48:36'), (31, 'AMARAPPA', 'SECURITY', 'SECURITY', '8951633963', 'SMVPUSC@GMAIL.COM', 'SSLC', 'Non-Teaching', 'uploads/staff_management/staff_1670932204.JPG', ' ', 1, '2022-12-13 11:50:04', '2022-12-13 11:50:04'), (32, 'NINGARAJ', 'ADMINISTRATION', 'ADMINISTRATOR', '8951633963', 'SMVPUSC@GMAIL.COM', 'BA', 'Administrator', 'uploads/staff_management/staff_1670997102.JPG', ' ', 1, '2022-12-14 05:51:42', '2022-12-14 05:51:42'), (33, 'MOUNESH', 'MATHEMATICS', 'LECTURE', '8951633963', 'mouneshsmali@gmail.com', 'BE ', 'Staff', 'uploads/staff_management/staff_1670997202.JPG', ' ', 1, '2022-12-14 05:53:22', '2022-12-14 05:53:22'); -- -------------------------------------------------------- -- -- 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, `website_name` varchar(200) NOT NULL, `email` varchar(70) NOT NULL, `mobile_number` varchar(50) NOT NULL, `about_us` longtext NOT NULL, `about_us_img` varchar(250) 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`, `website_name`, `email`, `mobile_number`, `about_us`, `about_us_img`, `vision`, `mission`, `moto`, `objective`, `contact_details`) VALUES (1, 'SMVPU', 'info@smvpu.com', '9898244359', ' <h6 class=\"\"></h6><h3 style=\"margin-bottom:0cm;line-height:normal\" class=\"\"><b style=\"font-size: 1rem;\">SMV\r\nCollege</b><span style=\"font-size: 1rem;\"> stands for the development and upliftment of society. Thus, our main\r\nintent is to present responsible individuals who can lend support and help in\r\nthe progress of not only their families or community but the country as a\r\nwhole. We are the best in our field and we can proudly say that we offer one of\r\nthe virtuous educational environments in the Raichur district. We ensure that\r\nour students get to learn from the eminent faculties of the state. Though, our sole aim is to not just achieving academic excellence, but also to teach moral and\r\nethical values inside the minds of our students. We see our students as amateur\r\nearthen pot who needs heat to become solid and firm. That heat for our students\r\nis the heat moral of values that will allow them to take decisions not by\r\nmeanings and morals. When teaching and preaching go along, the result comes out\r\nas a responsible and good human being, and this is what we strive to\r\nfollow. </span></h3> ', 'uploads/alumini_1676651004.jpg', ' <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);\"=\"\"><h5 style=\"margin-bottom:0cm;line-height:normal\" class=\"\"><span style=\"font-family: Cambria, serif;\"><font color=\"#000000\">Our\r\nmain vision is to present ourselves as a “</font><font color=\"#0000ff\" style=\"\">Premier Educational Institute of\r\nExcellence</font><font color=\"#000000\">” in the field of science. We work for the betterment of the\r\nstudents, society, and the country as a whole. We wish to establish a firm\r\nfoundation of knowledge, morals, and ethics in our students that will help them\r\nto build themselves as great leaders, entrepreneurs, scholars, and scientists.\r\nThe future lies in the hands of the present generation. Therefore, we stand as\r\nthe pillars of support for the present generation and help them in their\r\njourney of bringing a better future for the world. </font></span></h5></h2> ', ' <h5 style=\"font-family: \" class=\"\"><span style=\"font-size:11.0pt;line-height:107%;\r\nfont-family:"Cambria",serif;mso-fareast-font-family:"Times New Roman";\r\nmso-bidi-font-family:"Times New Roman";color:black;mso-ansi-language:EN-IN;\r\nmso-fareast-language:EN-IN;mso-bidi-language:AR-SA\">Our <b>mission </b>is to provide\r\neducation that is affordable, enlightening, and rightful. We work in the field\r\nof sciences to help students realize real-world problems and make them\r\ncompetent enough to tackle those problems. We, with our excellent faculty and\r\nadaptive educational environment, guide students to build their personalities,\r\ndevelop their brains for the good of society, and work not just for themselves\r\nbut for the overall betterment of the nation.<b> Our aim is to nurture the minds\r\nof students with advanced scientific knowledge</b>, and traditional Indian values,\r\nand make them aware of the pious Indian culture and ethics. </span></h5> ', ' <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: \"></h2><h5 style=\"margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 5px 0px; border: 0px; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 17px; color: rgb(68, 68, 68);\" class=\"\"><h5 style=\"margin-bottom:0cm;line-height:normal\" class=\"\"><span style=\"font-family:"Cambria",serif;mso-fareast-font-family:"Times New Roman";\r\nmso-bidi-font-family:"Times New Roman";color:black;mso-fareast-language:EN-IN\">We\r\nfollow a simple motto of<b> “Live with Principles”</b>. <br></span><span style=\"font-size:12.0pt;font-family:"Times New Roman",serif;mso-fareast-font-family:\r\n"Times New Roman";mso-fareast-language:EN-IN\"> <br></span><span style=\"font-family:"Cambria",serif;mso-fareast-font-family:"Times New Roman";\r\nmso-bidi-font-family:"Times New Roman";color:black;mso-fareast-language:EN-IN\">We\r\nrun our institution on our principles and teach our students as well to not let\r\ngo of their traditional values and ethics from their individual selves. In the\r\npresent world, where people are losing their morality in the name of\r\nmodernization. We try our best to inculcate good learning in our students. So\r\nthat they can become adaptive to the changing pace of society but not lose\r\ntheir principles along the way. </span></h5>\r\n\r\n\r\n\r\n</h5> ', ' <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=\"\"><h6 style=\"margin-bottom:0cm;line-height:normal\" class=\"\"><span style=\"font-family:"Cambria",serif;mso-fareast-font-family:"Times New Roman";\r\nmso-bidi-font-family:"Times New Roman";color:black;mso-fareast-language:EN-IN\">We\r\nhave our motto and objectives clear from the beginning, since we established\r\nthis institution back in the year 2013-2014. Our primary goals are -</span><span style=\"font-size:12.0pt;font-family:"Times New Roman",serif;mso-fareast-font-family:\r\n"Times New Roman";mso-fareast-language:EN-IN\"><br></span><ul style=\"margin-top:0cm\" type=\"disc\"><li class=\"MsoNormal\" style=\"color:black;margin-bottom:0cm;line-height:normal;\r\n mso-list:l1 level1 lfo1;tab-stops:list 36.0pt;vertical-align:baseline\"><span style=\"font-family:"Cambria",serif;mso-fareast-font-family:"Times New Roman";\r\n mso-bidi-font-family:"Times New Roman";mso-fareast-language:EN-IN\">To<b>\r\n thrust upon the self-development</b> of students in terms of knowledge, skill,\r\n competence, attitude, and professional growth. </span></li></ul><ul style=\"margin-top:0cm\" type=\"disc\"><li class=\"MsoNormal\" style=\"color:black;margin-bottom:0cm;line-height:normal;\r\n mso-list:l2 level1 lfo2;tab-stops:list 36.0pt;vertical-align:baseline\"><span style=\"font-family:"Cambria",serif;mso-fareast-font-family:"Times New Roman";\r\n mso-bidi-font-family:"Times New Roman";mso-fareast-language:EN-IN\">To make\r\n each and every student realize<b> their true potential</b> and to push them to\r\n give their best in their respective fields.</span></li></ul><ul style=\"margin-top:0cm\" type=\"disc\"><li class=\"MsoNormal\" style=\"color:black;margin-bottom:0cm;line-height:normal;\r\n mso-list:l3 level1 lfo3;tab-stops:list 36.0pt;vertical-align:baseline\"><span style=\"font-family:"Cambria",serif;mso-fareast-font-family:"Times New Roman";\r\n mso-bidi-font-family:"Times New Roman";mso-fareast-language:EN-IN\">To guide\r\n our students on each and every small step in order to make them <b>achieve\r\n their goals successfully.</b></span></li></ul><ul style=\"margin-top:0cm\" type=\"disc\"><li class=\"MsoNormal\" style=\"color:black;margin-bottom:0cm;line-height:normal;\r\n mso-list:l0 level1 lfo4;tab-stops:list 36.0pt;vertical-align:baseline\"><span style=\"font-family:"Cambria",serif;mso-fareast-font-family:"Times New Roman";\r\n mso-bidi-font-family:"Times New Roman";mso-fareast-language:EN-IN\">To\r\n teach our students the goodness of <b>positivity and to help them adopt</b> the\r\n way of simple living and positive thinking.</span></li></ul><ul style=\"margin-top:0cm\" type=\"disc\"><li class=\"MsoNormal\" style=\"color:black;margin-bottom:0cm;line-height:normal;\r\n mso-list:l4 level1 lfo5;tab-stops:list 36.0pt;vertical-align:baseline\"><span style=\"font-family:"Cambria",serif;mso-fareast-font-family:"Times New Roman";\r\n mso-bidi-font-family:"Times New Roman";mso-fareast-language:EN-IN\">To make\r\n our students <b>aware of the real-world troubles </b>and to help them to have a\r\n broad vision towards tackling those problems without fearing or backing\r\n out. </span></li></ul></h6>\r\n\r\n<p class=\"MsoNormal\" style=\"margin-bottom:0cm;line-height:normal\"><span style=\"font-size:12.0pt;font-family:"Times New Roman",serif;mso-fareast-font-family:\r\n"Times New Roman";mso-fareast-language:EN-IN\">\r\n<!--[if !supportLineBreakNewLine]-->\r\n<!--[endif]--><o:p></o:p></span></p>\r\n\r\n\r\n\r\n<p class=\"MsoNormal\" style=\"margin-bottom:0cm;line-height:normal\"><span style=\"font-size:12.0pt;font-family:"Times New Roman",serif;mso-fareast-font-family:\r\n"Times New Roman";mso-fareast-language:EN-IN\">\r\n<!--[if !supportLineBreakNewLine]-->\r\n<!--[endif]--><o:p></o:p></span></p>\r\n\r\n\r\n\r\n<p class=\"MsoNormal\" style=\"margin-bottom:0cm;line-height:normal\"><span style=\"font-size:12.0pt;font-family:"Times New Roman",serif;mso-fareast-font-family:\r\n"Times New Roman";mso-fareast-language:EN-IN\">\r\n<!--[if !supportLineBreakNewLine]-->\r\n<!--[endif]--><o:p></o:p></span></p>\r\n\r\n\r\n\r\n<p class=\"MsoNormal\" style=\"margin-bottom:0cm;line-height:normal\"><span style=\"font-size:12.0pt;font-family:"Times New Roman",serif;mso-fareast-font-family:\r\n"Times New Roman";mso-fareast-language:EN-IN\">\r\n<!--[if !supportLineBreakNewLine]-->\r\n<!--[endif]--><o:p></o:p></span></p>\r\n\r\n\r\n\r\n<p class=\"MsoNormal\" style=\"margin-bottom:0cm;line-height:normal\"><span style=\"font-size:12.0pt;font-family:"Times New Roman",serif;mso-fareast-font-family:\r\n"Times New Roman";mso-fareast-language:EN-IN\">\r\n<!--[if !supportLineBreakNewLine]-->\r\n<!--[endif]--><o:p></o:p></span></p>\r\n\r\n</h2> ', ' <p>SIR M VISVESWARAYYA PU ARTS COMMERCE SCIENCE COLLEGE LINGASUGURU</p><p>KHAZI COMPLEX RAICHURU BYPASS ROAD LINGASUGURU 584122</p><p>RAICHURU DISTRICT KARNATAKA INDIA.</p> <p></p> <p></p> '); -- -- Indexes for dumped tables -- -- -- 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 `gallery` -- ALTER TABLE `gallery` ADD PRIMARY KEY (`id`); -- -- Indexes for table `slider` -- ALTER TABLE `slider` ADD PRIMARY KEY (`id`); -- -- Indexes for table `staff_management` -- ALTER TABLE `staff_management` 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 `announcements_news` -- ALTER TABLE `announcements_news` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16; -- -- AUTO_INCREMENT for table `committee` -- ALTER TABLE `committee` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31; -- -- AUTO_INCREMENT for table `documents` -- ALTER TABLE `documents` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `enquiry` -- ALTER TABLE `enquiry` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `gallery` -- ALTER TABLE `gallery` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=60; -- -- AUTO_INCREMENT for table `slider` -- ALTER TABLE `slider` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `staff_management` -- ALTER TABLE `staff_management` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34; -- -- 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 */;