kohjhjhصثقص5572hjkhk7872ثقصثقgdfgdg
Ele57885fddfg872782782782 hjkhj782dfgfghgقفغفغفقhfg555434536
/
home4
/
kisgavwq
/
divinegurukulam.in
/
Upload FileeE
HOME
-- phpMyAdmin SQL Dump -- version 4.9.4 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Dec 31, 2020 at 06:26 AM -- Server version: 5.6.41-84.1 -- PHP Version: 7.3.6 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; 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: `adityaho_gurukul` -- -- -------------------------------------------------------- -- -- Table structure for table `events` -- CREATE TABLE `events` ( `id` int(11) NOT NULL, `event_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `hosted_by` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `price` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `description` text COLLATE utf8_unicode_ci NOT NULL, `event_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `contact_info` text COLLATE utf8_unicode_ci NOT NULL, `image` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `from_date` datetime NOT NULL, `to_date` datetime NOT NULL, `repeat_mode` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `color_code` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `address` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `status` tinyint(2) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `events` -- INSERT INTO `events` (`id`, `event_title`, `hosted_by`, `price`, `email`, `description`, `event_type`, `contact_info`, `image`, `from_date`, `to_date`, `repeat_mode`, `color_code`, `address`, `status`) VALUES (29, 'Janmashtami', '', '', '', 'Janmashtami', 'Holiday', '', '', '2018-09-02 10:00:00', '2018-09-02 16:00:00', '', '#FF0000', '', 1); -- -------------------------------------------------------- -- -- Table structure for table `ihm_admin` -- CREATE TABLE `ihm_admin` ( `admin_id` int(11) NOT NULL, `admin_user` varchar(100) NOT NULL, `admin_pass` varchar(100) NOT NULL, `admin_name` varchar(100) NOT NULL, `admin_email` varchar(100) NOT NULL, `admin_phone` varchar(100) NOT NULL, `admin_type` int(1) NOT NULL DEFAULT '0', `admin_status` char(1) NOT NULL DEFAULT '0', `admin_regdate` varchar(20) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `ihm_admin` -- INSERT INTO `ihm_admin` (`admin_id`, `admin_user`, `admin_pass`, `admin_name`, `admin_email`, `admin_phone`, `admin_type`, `admin_status`, `admin_regdate`) VALUES (1, 'admin', '21232f297a57a5a743894a0e4a801fc3', 'Website Superadmin', 'adhsupport@gmail.com', ' +91 674 6024365', 1, '1', '2012-07-09'), (10, 'sangram', '0f375ea4fa2e71aeff57ab7c926b2e9c', 'Sangram Sahoo', 'adhsupport@gmail.com', '9437504220', 2, '1', '26-07-2013'); -- -------------------------------------------------------- -- -- Table structure for table `ihm_admin_logs` -- CREATE TABLE `ihm_admin_logs` ( `login_id` int(11) NOT NULL, `login_uid` varchar(100) NOT NULL, `login_date_time` varchar(100) NOT NULL, `login_ip` varchar(100) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `ihm_admin_logs` -- INSERT INTO `ihm_admin_logs` (`login_id`, `login_uid`, `login_date_time`, `login_ip`) VALUES (1, '1', '05-11-2015 05:41', '::1'), (2, '1', '10-11-2015 03:47', '::1'), (3, '1', '10-11-2015 11:52', '::1'), (4, '1', '10-11-2015 05:39', '180.87.255.91'), (5, '1', '10-11-2015 07:00', '180.87.255.91'), (6, '1', '10-11-2015 07:52', '117.197.250.173'), (7, '1', '13-11-2015 02:17', '180.87.255.91'), (8, '1', '13-11-2015 03:04', '180.87.255.91'), (9, '1', '14-11-2015 12:25', '180.87.255.91'), (10, '1', '14-11-2015 01:36', '180.87.255.91'), (11, '1', '14-11-2015 03:57', '180.87.255.91'), (12, '1', '14-11-2015 04:47', '14.96.115.204'), (13, '1', '14-11-2015 06:07', '180.87.255.91'), (14, '1', '15-11-2015 08:22', '115.254.65.214'), (15, '1', '15-11-2015 11:02', '117.205.191.208'), (16, '1', '16-11-2015 01:21', '117.214.90.70'), (17, '1', '16-11-2015 03:28', '180.87.255.151'), (18, '1', '16-11-2015 05:15', '14.99.99.124'), (19, '1', '16-11-2015 08:56', '14.99.184.146'), (20, '1', '16-11-2015 08:18', '59.145.201.234'), (21, '1', '16-11-2015 09:46', '59.145.201.234'), (22, '1', '16-11-2015 10:24', '117.205.176.217'), (23, '1', '17-11-2015 01:12', '180.87.255.151'), (24, '1', '17-11-2015 01:17', '59.145.201.234'), (25, '1', '23-11-2015 08:21', '59.145.201.234'), (26, '1', '23-11-2015 09:48', '59.145.201.234'), (27, '1', '30-11-2015 05:12', '14.99.104.244'), (28, '1', '30-11-2015 09:12', '59.145.201.234'), (29, '1', '01-12-2015 03:33', '180.87.201.137'), (30, '1', '01-12-2015 04:33', '180.87.201.137'), (31, '1', '01-12-2015 07:18', '14.99.67.113'), (32, '1', '01-12-2015 10:42', '14.96.6.22'), (33, '1', '02-12-2015 04:16', '180.87.201.137'), (34, '1', '04-12-2015 02:26', '115.254.65.214'), (35, '1', '05-12-2015 04:48', '180.87.201.137'), (36, '1', '06-12-2015 09:36', '115.254.65.214'), (37, '1', '06-12-2015 09:36', '115.254.65.214'), (38, '1', '06-12-2015 09:37', '115.254.65.214'), (39, '1', '06-12-2015 09:39', '115.254.65.214'), (40, '1', '06-12-2015 10:09', '117.205.186.177'), (41, '1', '06-12-2015 10:53', '180.87.201.137'), (42, '1', '17-05-2016 07:13', '180.87.255.95'), (43, '1', '18-05-2016 02:42', '180.87.255.95'), (44, '1', '20-05-2016 05:50', '180.87.255.95'), (45, '1', '21-05-2016 05:05', '180.87.255.95'), (46, '1', '21-05-2016 05:30', '180.87.255.95'), (47, '1', '23-05-2016 12:36', '180.87.230.223'), (48, '1', '24-05-2016 04:43', '180.87.230.223'), (49, '1', '04-06-2016 12:28', '180.87.230.183'), (50, '1', '04-06-2016 01:49', '180.87.230.183'), (51, '1', '04-06-2016 02:09', '180.87.230.183'), (52, '1', '04-06-2016 11:59', '168.187.210.250'), (53, '1', '05-06-2016 08:38', '117.205.181.101'), (54, '1', '05-06-2016 11:54', '180.87.230.183'), (55, '1', '06-06-2016 12:27', '117.201.154.117'), (56, '1', '06-06-2016 02:31', '117.205.189.147'), (57, '1', '06-06-2016 02:31', '117.201.154.54'), (58, '1', '06-06-2016 02:45', '117.205.189.147'), (59, '1', '06-06-2016 03:31', '117.205.189.147'), (60, '1', '06-06-2016 03:46', '117.201.154.54'), (61, '1', '06-06-2016 03:56', '117.205.189.147'), (62, '1', '06-06-2016 08:14', '117.205.189.147'), (63, '1', '06-06-2016 08:37', '180.87.230.183'), (64, '1', '06-06-2016 09:08', '180.87.230.183'), (65, '1', '06-06-2016 11:43', '180.87.230.183'), (66, '1', '07-06-2016 06:24', '188.71.230.189'), (67, '1', '07-06-2016 07:44', '117.205.179.90'), (68, '1', '07-06-2016 08:32', '117.214.89.235'), (69, '1', '07-06-2016 11:53', '180.87.230.183'), (70, '1', '07-06-2016 11:58', '180.87.230.183'), (71, '1', '09-06-2016 07:53', '117.197.250.37'), (72, '1', '10-06-2016 07:16', '117.200.229.152'), (73, '1', '10-06-2016 07:18', '117.200.229.152'), (74, '1', '11-06-2016 12:14', '180.87.230.183'), (75, '1', '11-06-2016 01:37', '180.87.230.183'), (76, '1', '14-06-2016 05:43', '180.87.230.183'), (77, '1', '14-06-2016 05:49', '117.214.111.34'), (78, '1', '14-06-2016 06:35', '180.87.230.183'), (79, '1', '14-06-2016 01:28', '188.71.229.241'), (80, '1', '18-06-2016 01:35', '180.87.230.183'), (81, '1', '19-06-2016 05:59', '117.200.234.167'), (82, '1', '19-06-2016 07:30', '117.200.234.167'), (83, '1', '19-06-2016 11:34', '180.87.230.183'), (84, '1', '19-06-2016 11:43', '180.87.230.183'), (85, '1', '21-06-2016 09:41', '117.200.226.8'), (86, '1', '25-06-2016 12:18', '180.87.255.126'), (87, '1', '25-06-2016 03:39', '117.200.237.0'), (88, '1', '25-06-2016 08:44', '117.205.189.54'), (89, '1', '27-06-2016 12:46', '117.205.187.168'), (90, '1', '29-06-2016 02:49', '59.92.73.152'), (91, '1', '29-06-2016 06:24', '117.205.189.251'), (92, '1', '29-06-2016 08:52', '180.87.255.126'), (93, '1', '30-06-2016 12:11', '168.187.210.250'), (94, '1', '08-07-2016 12:29', '180.87.255.209'), (95, '1', '16-07-2016 12:26', '27.49.136.214'), (96, '1', '20-07-2016 10:33', '117.205.184.171'), (97, '1', '01-08-2016 01:06', '117.200.227.6'), (98, '1', '01-08-2016 01:06', '117.200.227.6'), (99, '1', '10-08-2016 02:04', '117.205.176.241'), (100, '1', '10-08-2016 11:49', '188.70.15.91'), (101, '1', '15-08-2016 01:19', '117.197.232.35'), (102, '1', '07-09-2016 01:22', '180.87.230.164'), (103, '1', '08-09-2016 10:58', '27.49.131.218'), (104, '1', '08-09-2016 11:30', '27.49.131.218'), (105, '1', '05-10-2016 04:43', '180.87.254.236'), (106, '1', '15-10-2016 09:31', '223.231.0.85'), (107, '1', '15-10-2016 09:54', '223.231.7.25'), (108, '1', '10-11-2016 08:02', '182.66.6.75'), (109, '1', '10-11-2016 08:26', '182.66.6.75'), (110, '1', '14-11-2016 06:42', '117.201.162.119'), (111, '1', '27-12-2016 06:28', '117.200.231.43'), (112, '1', '12-01-2017 05:48', '117.205.191.50'), (113, '1', '12-01-2017 09:23', '117.205.191.50'), (114, '1', '20-01-2017 07:45', '117.214.93.60'), (115, '1', '03-02-2017 02:01', '117.205.189.119'), (116, '1', '04-02-2017 02:21', '59.93.145.3'), (117, '1', '25-02-2017 01:49', '47.11.129.129'), (118, '1', '25-02-2017 01:59', '47.11.129.129'), (119, '1', '25-02-2017 07:53', '47.11.132.178'), (120, '1', '04-04-2017 07:49', '47.11.213.255'), (121, '1', '06-04-2017 04:50', '47.11.130.166'), (122, '10', '12-04-2017 12:32', '45.114.49.83'), (123, '1', '12-05-2017 11:35', '47.11.133.69'), (124, '1', '13-05-2017 03:48', '47.11.133.69'), (125, '10', '15-05-2017 04:47', '45.114.49.177'), (126, '1', '17-05-2017 04:37', '106.67.25.254'), (127, '10', '17-05-2017 05:13', '45.114.51.14'), (128, '10', '17-05-2017 06:03', '45.114.51.14'), (129, '1', '17-05-2017 07:07', '106.67.25.254'), (130, '1', '18-05-2017 06:06', '47.11.251.104'), (131, '10', '19-05-2017 02:22', '45.114.49.113'), (132, '1', '19-05-2017 09:05', '47.11.253.98'), (133, '1', '20-05-2017 06:58', '47.11.231.217'), (134, '10', '23-05-2017 01:23', '103.39.243.240'), (135, '1', '23-05-2017 06:25', '47.11.128.12'), (136, '1', '24-05-2017 02:28', '188.71.255.83'), (137, '1', '26-05-2017 05:48', '47.11.253.211'), (138, '1', '26-05-2017 06:42', '188.70.24.20'), (139, '1', '27-05-2017 08:24', '47.11.231.224'), (140, '1', '01-06-2017 09:50', '47.11.205.11'), (141, '1', '04-06-2017 06:30', '47.11.197.121'), (142, '1', '31-07-2017 11:13', '117.205.181.125'), (143, '1', '02-08-2017 08:05', '117.200.233.171'), (144, '1', '02-08-2017 08:07', '117.200.233.171'), (145, '1', '12-08-2017 11:36', '47.11.222.241'), (146, '1', '13-08-2017 05:34', '47.11.218.23'), (147, '1', '27-09-2017 05:03', '47.11.254.91'), (148, '10', '31-10-2017 01:58', '::1'), (149, '10', '01-11-2017 06:33', '::1'), (150, '10', '01-11-2017 12:12', '::1'), (151, '1', '01-11-2017 01:09', '::1'), (152, '10', '03-11-2017 09:35', '::1'), (153, '1', '09-11-2017 09:09', '::1'), (154, '1', '09-11-2017 01:55', '::1'), (155, '1', '10-11-2017 06:20', '::1'), (156, '1', '10-11-2017 02:03', '::1'), (157, '1', '11-11-2017 06:17', '::1'), (158, '1', '11-11-2017 07:43', '::1'), (159, '1', '11-11-2017 08:10', '::1'), (160, '1', '13-11-2017 10:50', '::1'), (161, '1', '16-11-2017 07:16', '::1'), (162, '1', '16-11-2017 07:20', '::1'), (163, '1', '16-11-2017 07:31', '::1'), (164, '1', '16-11-2017 11:14', '::1'), (165, '1', '06-02-2018 06:24', '::1'), (166, '1', '06-02-2018 06:29', '::1'), (167, '1', '06-02-2018 06:31', '::1'), (168, '1', '29-08-2018 11:54', '::1'), (169, '1', '30-08-2018 07:46', '::1'), (170, '1', '31-08-2018 08:48', '::1'), (171, '1', '31-08-2018 08:55', '::1'), (172, '1', '31-08-2018 09:10', '::1'), (173, '1', '03-09-2018 09:24', '::1'), (174, '1', '04-09-2018 12:11', '::1'), (175, '1', '04-09-2018 12:20', '::1'), (176, '1', '05-09-2018 11:52', '::1'), (177, '1', '15-10-2018 12:40', '::1'), (178, '1', '15-01-2020 01:12', '::1'), (179, '1', '16-01-2020 10:05', '::1'), (180, '1', '21-01-2020 08:27', '::1'), (181, '1', '29-12-2020 08:23', '::1'), (182, '1', '29-12-2020 11:52', '49.37.0.34'), (183, '1', '30-12-2020 01:59', '49.37.0.34'), (184, '1', '30-12-2020 02:58', '49.37.0.34'), (185, '1', '30-12-2020 04:03', '122.170.117.223'), (186, '1', '30-12-2020 05:52', '49.37.0.34'), (187, '1', '30-12-2020 07:17', '49.37.0.34'), (188, '1', '31-12-2020 01:27', '49.37.0.34'), (189, '1', '31-12-2020 01:49', '112.110.74.125'); -- -------------------------------------------------------- -- -- Table structure for table `ihm_announcement` -- CREATE TABLE `ihm_announcement` ( `id` int(11) NOT NULL, `type` int(11) DEFAULT '0', `title` text, `url` varchar(50) DEFAULT NULL, `publish_date` varchar(50) DEFAULT NULL, `file_name` varchar(100) DEFAULT NULL, `link` varchar(100) DEFAULT NULL, `description` text, `status` int(11) DEFAULT '1', `new` int(10) DEFAULT '0', `sort_order` int(10) DEFAULT '0' ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `ihm_announcement` -- INSERT INTO `ihm_announcement` (`id`, `type`, `title`, `url`, `publish_date`, `file_name`, `link`, `description`, `status`, `new`, `sort_order`) VALUES (68, 1, 'Currently No Announcement', 'currently-no-announcement', '8/30/2018', 'announcement_1535936471.png', '', 'Currently No Announcement', 1, 1, 1); -- -------------------------------------------------------- -- -- Table structure for table `ihm_events` -- CREATE TABLE `ihm_events` ( `id` int(11) NOT NULL, `type` int(11) DEFAULT '0', `title` text, `url` varchar(50) DEFAULT NULL, `publish_date` varchar(50) DEFAULT NULL, `file_name` varchar(100) DEFAULT NULL, `link` varchar(100) DEFAULT NULL, `description` text, `status` int(11) DEFAULT '1', `new` int(10) DEFAULT '0', `sort_order` int(10) DEFAULT '0' ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `ihm_events` -- INSERT INTO `ihm_events` (`id`, `type`, `title`, `url`, `publish_date`, `file_name`, `link`, `description`, `status`, `new`, `sort_order`) VALUES (22, 0, 'Upcoming Event 1', 'Upcoming Event 1', '1/4/2013', '', 'http://www.ignou.ac.in/', 'Upcoming Event 1', 1, 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `ihm_faculties` -- CREATE TABLE `ihm_faculties` ( `faculty_id` int(11) NOT NULL, `faculty_type` varchar(50) NOT NULL, `faculty_salutation` varchar(10) NOT NULL, `faculty_name` varchar(100) NOT NULL, `faculty_url` varchar(100) DEFAULT NULL, `faculty_designation` varchar(100) NOT NULL, `faculty_email` varchar(100) NOT NULL, `faculty_photo` varchar(100) NOT NULL, `faculty_qualification` text, `faculty_experience` text, `faculty_membership` text, `faculty_specialization` text, `faculty_awards` text, `faculty_status` char(1) NOT NULL, `faculty_order` int(11) DEFAULT '0' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `ihm_faculties` -- INSERT INTO `ihm_faculties` (`faculty_id`, `faculty_type`, `faculty_salutation`, `faculty_name`, `faculty_url`, `faculty_designation`, `faculty_email`, `faculty_photo`, `faculty_qualification`, `faculty_experience`, `faculty_membership`, `faculty_specialization`, `faculty_awards`, `faculty_status`, `faculty_order`) VALUES (72, 'administrative', 'Mr.', 'test', 'test', 'fhgh', 'ff@f.com', 'test.jpg', '<div>ghgfh</div>', '<div>fgh</div>', '<div>gfh</div>', '<div>hfghf</div>', '<div>dgd</div>', '1', 0), (73, 'academic', 'Mr.', 'aa', 'aa', 'aaa', 'a@a.com', 'aa.jpg', '<div>a1</div>', '<div>a2</div>', '<div>a3</div>', '<div>a4</div>', '<div>a5</div>', '1', 1); -- -------------------------------------------------------- -- -- Table structure for table `ihm_menus` -- CREATE TABLE `ihm_menus` ( `menu_id` int(11) NOT NULL, `menu_pid` int(11) DEFAULT NULL, `menu_name` varchar(100) DEFAULT NULL, `menu_position` int(11) DEFAULT '0', `icon` varchar(250) DEFAULT NULL, `menu_page` varchar(200) DEFAULT NULL, `menu_target` varchar(20) DEFAULT NULL, `menu_status` char(2) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `ihm_menus` -- INSERT INTO `ihm_menus` (`menu_id`, `menu_pid`, `menu_name`, `menu_position`, `icon`, `menu_page`, `menu_target`, `menu_status`) VALUES (1, 0, 'Home', 1, '10562_home.png', 'index.php', '', '1'), (2, 0, 'About Us', 2, '1265_college-graduation.png', '1', '', '1'), (3, 0, 'Curriculum', 3, '23891_book.png', '62', '', '1'), (64, 62, 'Group B', 2, '', '36', '', '1'), (5, 0, 'CBSE', 4, '264120414_19654_cbse-section.png', '0', '', '1'), (76, 2, 'Vision & Mission', 1, '', '0', '', '1'), (7, 0, 'Academics', 5, '20553_books (1).png', '0', '', '1'), (8, 0, 'Facilities', 6, '7502_books (1).png', '0', '', '1'), (17, 4, 'Computer Education', 1, '', '7', '', '1'), (18, 4, 'Yoga Education', 2, '', '8', '', '1'), (19, 4, 'Art & Craft', 3, '', '9', '', '1'), (20, 4, 'Games & Sports', 4, '', '10', '', '1'), (21, 4, 'Song & Dance', 5, '', '11', '', '1'), (22, 4, 'Debate & Competition', 6, '', '12', '', '1'), (63, 62, 'Group A', 1, '', '37', '', '1'), (70, 0, 'Contact', 8, '28271_books (1).png', '0', '', '1'), (68, 45, 'Parent\'s Corner', 1, '', 'http://dvmrajgangpur.edu.in/parentcorner.php', '', '1'), (69, 45, 'Contact Us', 2, '', '3', '', '1'), (51, 16, 'CBSE Acheivers', 1, '', '52', '', '1'), (52, 16, 'Games & Sports', 2, '', '31', '', '1'), (53, 16, 'Cultural', 3, '', '46', '', '1'), (65, 62, 'Group C', 3, '', '35', '', '1'), (66, 62, 'Group D', 4, '', '34', '', '1'), (67, 62, 'Group E', 5, '', '33', '', '1'), (77, 0, 'Admissions', 7, '1916_books (1).png', '0', '', '1'), (78, 5, 'Transfer Certificate', 1, '', 'transfer-certificates.php', '', '1'); -- -------------------------------------------------------- -- -- Table structure for table `ihm_news` -- CREATE TABLE `ihm_news` ( `id` int(11) NOT NULL, `type` int(11) DEFAULT '0', `title` text, `url` varchar(50) DEFAULT NULL, `publish_date` varchar(50) DEFAULT NULL, `file_name` varchar(100) DEFAULT NULL, `link` varchar(100) DEFAULT NULL, `description` text, `status` int(11) DEFAULT '1', `new` int(10) DEFAULT '0', `sort_order` int(10) DEFAULT '0' ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `ihm_news` -- INSERT INTO `ihm_news` (`id`, `type`, `title`, `url`, `publish_date`, `file_name`, `link`, `description`, `status`, `new`, `sort_order`) VALUES (80, 0, 'Currently No News', 'currently-no-news', '12/29/2020', '', '', 'Currently No News', 1, 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `ihm_notices` -- CREATE TABLE `ihm_notices` ( `id` int(11) NOT NULL, `type` int(11) DEFAULT '0', `title` text, `url` varchar(50) DEFAULT NULL, `publish_date` varchar(50) DEFAULT NULL, `file_name` varchar(100) DEFAULT NULL, `link` varchar(100) DEFAULT NULL, `description` text, `status` int(11) DEFAULT '1', `new` int(10) DEFAULT '0', `sort_order` int(10) DEFAULT '0' ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `ihm_notices` -- INSERT INTO `ihm_notices` (`id`, `type`, `title`, `url`, `publish_date`, `file_name`, `link`, `description`, `status`, `new`, `sort_order`) VALUES (52, 1, 'Download Admission Form', '', '12/18/2014', 'notification_1418928221.pdf', '', 'Download Admission Form', 1, 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `ihm_pages` -- CREATE TABLE `ihm_pages` ( `page_id` int(11) NOT NULL, `page_name` varchar(100) NOT NULL, `page_url` varchar(100) NOT NULL, `page_type` varchar(50) DEFAULT NULL, `page_updated` varchar(40) NOT NULL, `editable` int(11) NOT NULL DEFAULT '1' ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `ihm_pages` -- INSERT INTO `ihm_pages` (`page_id`, `page_name`, `page_url`, `page_type`, `page_updated`, `editable`) VALUES (1, 'About Us', 'about-us', 'static', '2020-12-29 13:26', 1); -- -------------------------------------------------------- -- -- Table structure for table `ihm_page_contents` -- CREATE TABLE `ihm_page_contents` ( `page_cid` int(11) NOT NULL, `page_id` int(11) NOT NULL, `page_title` varchar(150) DEFAULT NULL, `page_metakeywords` text, `page_metadesc` text, `page_contents` text ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `ihm_page_contents` -- INSERT INTO `ihm_page_contents` (`page_cid`, `page_id`, `page_title`, `page_metakeywords`, `page_metadesc`, `page_contents`) VALUES (1, 1, 'About Us', 'About Us', 'About Us', '<div style=\"text-align: justify;\"><img src=\"https://static.toiimg.com/thumb/imgsize-22788,msid-78195305,width-400,resizemode-4/78195305.jpg\" align=\"left\" vspace=\"5\" hspace=\"15\" alt=\"\" /> Divine Gurukulam is the top choice of the students looking for the best boarding schools in Gujarat due to its excellent academic infrastructure. It was established in 2009 by the Divine Education Society which runs at Ahmedabad.Divine Gurukulam is the top choice of the students looking for the best boarding schools in Gujarat due to its excellent academic infrastructure. It was established in 2009 by the Divine Education Society which runs at Ahmedabad.Divine Gurukulam is the top choice of the students looking for the best boarding schools in Gujarat due to its excellent academic infrastructure. It was established in 2009 by the Divine Education Society which runs at Ahmedabad.</div>\r\n<div style=\"text-align: justify;\"> </div>\r\n<div style=\"text-align: justify;\">Divine Gurukulam is the top choice of the students looking for the best boarding schools in Gujarat due to its excellent academic infrastructure. It was established in 2009 by the Divine Education Society which runs at Ahmedabad.Divine Gurukulam is the top choice of the students looking for the best boarding schools in Gujarat due to its excellent academic infrastructure. It was established in 2009 by the Divine Education Society which runs at Ahmedabad.Divine Gurukulam is the top choice of the students looking for the best boarding schools in Gujarat due to its excellent academic infrastructure. It was established in 2009 by the Divine Education Society which runs at Ahmedabad.</div>\r\n<div> </div>\r\n<div> </div>'); -- -------------------------------------------------------- -- -- Table structure for table `ihm_photo_category` -- CREATE TABLE `ihm_photo_category` ( `category_id` int(10) NOT NULL, `category_name` varchar(255) NOT NULL, `category_url` varchar(150) DEFAULT NULL, `category_status` int(11) DEFAULT '1' ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `ihm_photo_category` -- INSERT INTO `ihm_photo_category` (`category_id`, `category_name`, `category_url`, `category_status`) VALUES (10, 'Independence Day 2018', 'independence-day-2018', 1), (17, 'Annual Funtion', 'annual-funtion', 1), (13, 'Jolly Phonics', 'jolly-phonics', 1), (14, 'CBSE Training 2018', 'cbse-training-2018', 1); -- -------------------------------------------------------- -- -- Table structure for table `ihm_photo_gallery` -- CREATE TABLE `ihm_photo_gallery` ( `photo_id` int(11) NOT NULL, `photo_caption` varchar(255) NOT NULL, `photo_file` varchar(255) NOT NULL, `photo_date` varchar(255) NOT NULL, `photo_category` varchar(250) NOT NULL, `photo_status` int(11) DEFAULT '1' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `ihm_photo_gallery` -- INSERT INTO `ihm_photo_gallery` (`photo_id`, `photo_caption`, `photo_file`, `photo_date`, `photo_category`, `photo_status`) VALUES (97, 'EVENTS', 'nluo_1609419211.jpg', '30-Dec-2020', '13', 1), (100, 'EVENT', 'nluo_1609419176.jpg', '30-Dec-2020', '17', 1), (94, 'EVENTS', 'nluo_1609419230.jpg', '30-Dec-2020', '10', 1), (98, 'EVENT', 'nluo_1609419194.jpg', '30-Dec-2020', '14', 1); -- -------------------------------------------------------- -- -- Table structure for table `tbl1_testimonial` -- CREATE TABLE `tbl1_testimonial` ( `id` int(11) NOT NULL, `title` varchar(200) NOT NULL, `contents` text NOT NULL, `Name` varchar(200) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl1_testimonial` -- INSERT INTO `tbl1_testimonial` (`id`, `title`, `contents`, `Name`) VALUES (22, '', 'Every child is like a seed which has the potential to grow if it is nourished with love and care under the right guidance.', ''); -- -------------------------------------------------------- -- -- Table structure for table `tbl_banner` -- CREATE TABLE `tbl_banner` ( `id` int(11) NOT NULL, `banner_name` varchar(255) DEFAULT NULL, `banner_image` varchar(255) DEFAULT NULL, `banner_desc` varchar(255) DEFAULT NULL, `banner_sequence` int(5) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_banner` -- INSERT INTO `tbl_banner` (`id`, `banner_name`, `banner_image`, `banner_desc`, `banner_sequence`) VALUES (7, 'slider', '17289_slider.jpg', '', 1); -- -------------------------------------------------------- -- -- Table structure for table `tbl_certificate` -- CREATE TABLE `tbl_certificate` ( `id` int(11) NOT NULL, `course_nme` varchar(255) NOT NULL, `roll_no` varchar(200) NOT NULL, `regd_id` varchar(100) NOT NULL, `stu_nme` varchar(200) NOT NULL, `dob` varchar(100) NOT NULL, `fath_nme` varchar(200) NOT NULL, `year_pass` varchar(200) NOT NULL, `division` varchar(200) NOT NULL, `tot_mark` varchar(200) NOT NULL, `obt_mark` varchar(200) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_certificate` -- INSERT INTO `tbl_certificate` (`id`, `course_nme`, `roll_no`, `regd_id`, `stu_nme`, `dob`, `fath_nme`, `year_pass`, `division`, `tot_mark`, `obt_mark`) VALUES (1, 'ADVANCE DIPLOMA IN INTERNATIONAL FIRE AND INDUSTRIAL SAFETY ENGINEERING', '125113IAO503', 'IAO/PDIMT/506/2014-15', 'ASHISH KUMAR NAYAK', '02-Mar-2017', 'SARAT KU. NAYAK', '2015', 'First', '800', '315'), (2, 'ADVANCE DIPLOMA IN INTERNATIONAL FIRE AND INDUSTRIAL SAFETY ENGINEERING', '1234567898', '1234567898', 'Akash', '21-09-2017', 'Awqwwa', '2017', 'A', '1000', '999'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_certificate_request` -- CREATE TABLE `tbl_certificate_request` ( `id` int(11) NOT NULL, `certificate_no` varchar(200) NOT NULL, `std_name` varchar(200) NOT NULL, `regd_no` varchar(200) NOT NULL, `course` varchar(200) NOT NULL, `duration` varchar(200) NOT NULL, `from_period` varchar(200) NOT NULL, `to_period` varchar(200) NOT NULL, `performance` varchar(200) NOT NULL, `seal` varchar(200) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `tbl_client` -- CREATE TABLE `tbl_client` ( `id` int(11) NOT NULL, `client_name` varchar(100) NOT NULL, `details` varchar(1000) NOT NULL, `logo` varchar(100) NOT NULL, `client_desc` varchar(500) NOT NULL, `created_date` date NOT NULL, `update_date` date NOT NULL, `more_link` varchar(200) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_client` -- INSERT INTO `tbl_client` (`id`, `client_name`, `details`, `logo`, `client_desc`, `created_date`, `update_date`, `more_link`) VALUES (1, 'Maths-Science-Innovation Lab', 'Divine Gurukulam is the top choice of the students looking for the best boarding schools in Gujarat due to its excellent academic infrastructure. ', '16474_canteen.jpg', '', '2018-01-31', '2020-12-29', ''), (2, 'Library', 'Divine Gurukulam is the top choice of the students looking for the best boarding schools in Gujarat due to its excellent academic infrastructure. ', '13231_canteen.jpg', '', '2018-01-31', '2020-12-29', ''), (3, 'Counselling for Students', 'Divine Gurukulam is the top choice of the students looking for the best boarding schools in Gujarat due to its excellent academic infrastructure. ', '20224_canteen.jpg', '', '2018-01-31', '2020-12-29', ''), (4, 'Computer Lab', 'Divine Gurukulam is the top choice of the students looking for the best boarding schools in Gujarat due to its excellent academic infrastructure. ', '6264_canteen.jpg', '', '2018-01-31', '2020-12-29', ''), (5, 'Cafeteria Food', 'Divine Gurukulam is the top choice of the students looking for the best boarding schools in Gujarat due to its excellent academic infrastructure. ', '10245_canteen.jpg', '', '2018-01-31', '2020-12-29', ''), (6, 'Activities2', 'Divine Gurukulam is the top choice of the students looking for the best boarding schools in Gujarat due to its excellent academic infrastructure. ', '12174_canteen.jpg', '', '2018-01-31', '2020-12-29', ''); -- -------------------------------------------------------- -- -- Table structure for table `tbl_course` -- CREATE TABLE `tbl_course` ( `id` int(10) NOT NULL, `cosname` varchar(50) NOT NULL, `status` int(10) NOT NULL, `created_dt` date NOT NULL, `update_dt` date NOT NULL, `sort_order` int(10) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_course` -- INSERT INTO `tbl_course` (`id`, `cosname`, `status`, `created_dt`, `update_dt`, `sort_order`) VALUES (3, '7th', 1, '2020-12-30', '2020-12-30', 0), (4, '8th', 1, '2020-12-31', '2020-12-31', 0); -- -------------------------------------------------------- -- -- Table structure for table `tbl_features` -- CREATE TABLE `tbl_features` ( `id` int(11) NOT NULL, `feature_name` varchar(100) NOT NULL, `details` varchar(1000) NOT NULL, `logo` varchar(100) NOT NULL, `feature_desc` varchar(500) NOT NULL, `more_link` varchar(250) NOT NULL, `created_date` date NOT NULL, `update_date` date NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_features` -- INSERT INTO `tbl_features` (`id`, `feature_name`, `details`, `logo`, `feature_desc`, `more_link`, `created_date`, `update_date`) VALUES (1, 'Video Gallery', '', '16281_brainstorm.svg', '', 'videogallery.php', '2019-02-09', '2020-12-30'), (2, 'Upcoming Events', '', '3031_graduate.svg', '', '', '2019-02-09', '2020-12-29'), (3, 'Photo Gallery', '', '31961_picture.svg', '', 'photogallery.php', '2019-02-09', '2020-12-29'), (4, 'Contact Us', '', '15556_studying.svg', 'hello this is a demo text', 'contact-us.php', '2019-02-09', '2020-12-31'), (5, 'Exam Schedule', '', '12259_logo.png', '', '0', '2020-12-29', '2020-12-29'), (6, 'Admission Enquiry', '', '15840_logo.png', '', 'apply-online.php', '2020-12-29', '2020-12-31'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_glance` -- CREATE TABLE `tbl_glance` ( `id` int(11) NOT NULL, `title` varchar(100) NOT NULL, `details` varchar(1000) NOT NULL, `image` varchar(100) NOT NULL, `more_link` varchar(250) NOT NULL, `created_date` date NOT NULL, `update_date` date NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_glance` -- INSERT INTO `tbl_glance` (`id`, `title`, `details`, `image`, `more_link`, `created_date`, `update_date`) VALUES (1, 'PARENTS CONNECT', 'Divine Gurukulam is the top choice of the students looking for the best boarding schools in Gujarat due to its excellent academic infrastructure. It was established in 2009 by the Divine Education Society which runs at Ahmedabad.', '81637584_student.jpg', '', '2019-02-09', '2020-12-30'), (2, 'TRAINING OF THE TEACHERS', 'Divine Gurukulam is the top choice of the students looking for the best boarding schools in Gujarat due to its excellent academic infrastructure. It was established in 2009 by the Divine Education Society which runs at Ahmedabad.', '43955008_student.jpg', '', '2019-02-09', '2020-12-30'), (3, 'GLOBAL PLATFORM', 'Divine Gurukulam is the top choice of the students looking for the best boarding schools in Gujarat due to its excellent academic infrastructure. It was established in 2009 by the Divine Education Society which runs at Ahmedabad.', '1434883238_student.jpg', '', '2019-02-09', '2020-12-30'), (4, 'TEACHING STAFF', 'Divine Gurukulam is the top choice of the students looking for the best boarding schools in Gujarat due to its excellent academic infrastructure. It was established in 2009 by the Divine Education Society which runs at Ahmedabad.', '524182248_student.jpg', '', '2019-02-09', '2020-12-30'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_homecontent` -- CREATE TABLE `tbl_homecontent` ( `id` int(11) NOT NULL, `phone` varchar(100) NOT NULL, `emailid` varchar(100) NOT NULL, `timing` varchar(100) NOT NULL, `office_add` text NOT NULL, `quick_link` varchar(100) NOT NULL, `facebook_likeurl` text NOT NULL, `map_url` text NOT NULL, `facebook_link` varchar(100) NOT NULL, `twitter_link` varchar(100) NOT NULL, `youtube_link` varchar(100) NOT NULL, `linkedin_link` varchar(100) NOT NULL, `site_logo` varchar(250) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_homecontent` -- INSERT INTO `tbl_homecontent` (`id`, `phone`, `emailid`, `timing`, `office_add`, `quick_link`, `facebook_likeurl`, `map_url`, `facebook_link`, `twitter_link`, `youtube_link`, `linkedin_link`, `site_logo`) VALUES (1, '+91-6354696360, 8460064821', 'info@divinegurukulam.com', 'Timings : 8:30 AM to 4:30 PM', '<div>Divine Gurukulam The Traditional school</div>\r\n<div>Beside Nayara petrol pump,</div>\r\n<div>near Viva party plot, Ahmedabad, Gujarat 380008</div>\r\n<div> </div>', 'sdad', ' https://www.facebook.com/plugins/page.php?href=https%3A%2F%2Fwww.facebook.com%2Ffacebook&tabs=timeline&width=340&height=500&small_header=false&adapt_container_width=true&hide_cover=false&show_facepile=true&appId', ' https://www.google.com/maps/embed?pb=!1m14!1m8!1m3!1d14695.638993532057!2d72.6542175!3d22.9535507!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x0%3A0x63ddfd6e82eb2a31!2sDivine%20Gurukulam%20The%20Traditional%20school!5e0!3m2!1sen!2sin!4v1609307745799!5m2!1sen!2sin', '', '', '', '', '30171_logo.png'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_popupcontent` -- CREATE TABLE `tbl_popupcontent` ( `id` int(10) NOT NULL, `image` varchar(200) NOT NULL, `content` varchar(200) NOT NULL, `status` int(10) NOT NULL, `update_dt` date NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_popupcontent` -- INSERT INTO `tbl_popupcontent` (`id`, `image`, `content`, `status`, `update_dt`) VALUES (1, '932853808_admission.jpg', '', 1, '2020-12-31'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_quicklink` -- CREATE TABLE `tbl_quicklink` ( `id` int(11) NOT NULL, `link_name` varchar(100) NOT NULL, `link_url` varchar(250) NOT NULL, `created_date` date NOT NULL, `update_date` date NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_quicklink` -- INSERT INTO `tbl_quicklink` (`id`, `link_name`, `link_url`, `created_date`, `update_date`) VALUES (1, 'Vision and Mission', '#', '2019-02-09', '2019-04-22'), (2, 'Timings', '64', '2019-02-09', '2019-02-09'), (3, 'School Uniform', '0', '2019-02-09', '2019-02-09'), (4, 'Management', '0', '2019-02-09', '2019-02-09'), (5, 'Faculties', '1', '2019-02-09', '2019-02-11'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_registration` -- CREATE TABLE `tbl_registration` ( `id` int(11) NOT NULL, `rollno` varchar(200) NOT NULL, `name` varchar(200) NOT NULL, `fname` varchar(200) NOT NULL, `email` varchar(200) NOT NULL, `phone` varchar(200) NOT NULL, `studyingin` varchar(200) NOT NULL, `city` varchar(200) NOT NULL, `message` varchar(500) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_registration` -- INSERT INTO `tbl_registration` (`id`, `rollno`, `name`, `fname`, `email`, `phone`, `studyingin`, `city`, `message`) VALUES (1, '20180001', 'Swadhin Kumar Barik', '', 'swadhin.b@adityahosting.com', '9438336318', '', 'Bhubaneswar', 'Testing Message'), (2, '20200002', 'Bhavesh Rajai', '', 'jalaramsoftwebsolutions@gmail.com', '9016799596', '8th', 'Ahmedabad', 'Test'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_tc` -- CREATE TABLE `tbl_tc` ( `sr_no` int(11) NOT NULL, `name` varchar(300) NOT NULL, `grade` varchar(300) NOT NULL, `admission_no` varchar(300) NOT NULL, `view` varchar(300) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_tc` -- INSERT INTO `tbl_tc` (`sr_no`, `name`, `grade`, `admission_no`, `view`) VALUES (2, 'swadhin kumar barik', '1', '119', 'SWADHIN KUMAR BARIK11919151018487.jpg'), (3, 'SUBHENDRA SWAIN', '7TH', '14879/2020', 'SUBHENDRA SWAIN14879/202020301220333.jpg'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_video` -- CREATE TABLE `tbl_video` ( `id` int(11) NOT NULL, `video_title` varchar(255) DEFAULT NULL, `video_link` varchar(255) DEFAULT NULL, `created_date` date NOT NULL, `updated_date` date NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_video` -- INSERT INTO `tbl_video` (`id`, `video_title`, `video_link`, `created_date`, `updated_date`) VALUES (1, 'Divine ', 'https://youtu.be/BHvQ0LWZZ5U', '2020-12-30', '0000-00-00'); -- -- Indexes for dumped tables -- -- -- Indexes for table `events` -- ALTER TABLE `events` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ihm_admin` -- ALTER TABLE `ihm_admin` ADD PRIMARY KEY (`admin_id`); -- -- Indexes for table `ihm_admin_logs` -- ALTER TABLE `ihm_admin_logs` ADD PRIMARY KEY (`login_id`); -- -- Indexes for table `ihm_announcement` -- ALTER TABLE `ihm_announcement` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ihm_events` -- ALTER TABLE `ihm_events` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ihm_faculties` -- ALTER TABLE `ihm_faculties` ADD PRIMARY KEY (`faculty_id`), ADD KEY `name` (`faculty_name`), ADD KEY `title` (`faculty_designation`); -- -- Indexes for table `ihm_menus` -- ALTER TABLE `ihm_menus` ADD PRIMARY KEY (`menu_id`); -- -- Indexes for table `ihm_news` -- ALTER TABLE `ihm_news` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ihm_notices` -- ALTER TABLE `ihm_notices` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ihm_pages` -- ALTER TABLE `ihm_pages` ADD PRIMARY KEY (`page_id`); -- -- Indexes for table `ihm_page_contents` -- ALTER TABLE `ihm_page_contents` ADD PRIMARY KEY (`page_cid`); -- -- Indexes for table `ihm_photo_category` -- ALTER TABLE `ihm_photo_category` ADD PRIMARY KEY (`category_id`); -- -- Indexes for table `ihm_photo_gallery` -- ALTER TABLE `ihm_photo_gallery` ADD PRIMARY KEY (`photo_id`); -- -- Indexes for table `tbl1_testimonial` -- ALTER TABLE `tbl1_testimonial` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_banner` -- ALTER TABLE `tbl_banner` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_certificate` -- ALTER TABLE `tbl_certificate` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_certificate_request` -- ALTER TABLE `tbl_certificate_request` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_client` -- ALTER TABLE `tbl_client` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_course` -- ALTER TABLE `tbl_course` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_features` -- ALTER TABLE `tbl_features` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_glance` -- ALTER TABLE `tbl_glance` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_homecontent` -- ALTER TABLE `tbl_homecontent` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_popupcontent` -- ALTER TABLE `tbl_popupcontent` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_quicklink` -- ALTER TABLE `tbl_quicklink` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_registration` -- ALTER TABLE `tbl_registration` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_tc` -- ALTER TABLE `tbl_tc` ADD PRIMARY KEY (`sr_no`); -- -- Indexes for table `tbl_video` -- ALTER TABLE `tbl_video` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `events` -- ALTER TABLE `events` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30; -- -- AUTO_INCREMENT for table `ihm_admin` -- ALTER TABLE `ihm_admin` MODIFY `admin_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `ihm_admin_logs` -- ALTER TABLE `ihm_admin_logs` MODIFY `login_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=190; -- -- AUTO_INCREMENT for table `ihm_announcement` -- ALTER TABLE `ihm_announcement` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=71; -- -- AUTO_INCREMENT for table `ihm_events` -- ALTER TABLE `ihm_events` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23; -- -- AUTO_INCREMENT for table `ihm_faculties` -- ALTER TABLE `ihm_faculties` MODIFY `faculty_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=74; -- -- AUTO_INCREMENT for table `ihm_menus` -- ALTER TABLE `ihm_menus` MODIFY `menu_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=83; -- -- AUTO_INCREMENT for table `ihm_news` -- ALTER TABLE `ihm_news` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=81; -- -- AUTO_INCREMENT for table `ihm_notices` -- ALTER TABLE `ihm_notices` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=53; -- -- AUTO_INCREMENT for table `ihm_pages` -- ALTER TABLE `ihm_pages` MODIFY `page_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=65; -- -- AUTO_INCREMENT for table `ihm_page_contents` -- ALTER TABLE `ihm_page_contents` MODIFY `page_cid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=65; -- -- AUTO_INCREMENT for table `ihm_photo_category` -- ALTER TABLE `ihm_photo_category` MODIFY `category_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18; -- -- AUTO_INCREMENT for table `ihm_photo_gallery` -- ALTER TABLE `ihm_photo_gallery` MODIFY `photo_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=101; -- -- AUTO_INCREMENT for table `tbl1_testimonial` -- ALTER TABLE `tbl1_testimonial` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23; -- -- AUTO_INCREMENT for table `tbl_banner` -- ALTER TABLE `tbl_banner` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `tbl_certificate` -- ALTER TABLE `tbl_certificate` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `tbl_certificate_request` -- ALTER TABLE `tbl_certificate_request` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tbl_client` -- ALTER TABLE `tbl_client` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `tbl_course` -- ALTER TABLE `tbl_course` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `tbl_features` -- ALTER TABLE `tbl_features` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `tbl_glance` -- ALTER TABLE `tbl_glance` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `tbl_homecontent` -- ALTER TABLE `tbl_homecontent` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `tbl_popupcontent` -- ALTER TABLE `tbl_popupcontent` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `tbl_quicklink` -- ALTER TABLE `tbl_quicklink` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `tbl_registration` -- ALTER TABLE `tbl_registration` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `tbl_tc` -- ALTER TABLE `tbl_tc` MODIFY `sr_no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `tbl_video` -- ALTER TABLE `tbl_video` 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 */;