kohjhjhصثقص5572hjkhk7872ثقصثقgdfgdg
Ele57885fddfg872782782782 hjkhj782dfgfghgقفغفغفقhfg555434536
/
home4
/
kisgavwq
/
sisnikol.com
/
Upload FileeE
HOME
-- phpMyAdmin SQL Dump -- version 4.9.4 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Jan 14, 2021 at 12:52 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_sankalp` -- -- -------------------------------------------------------- -- -- 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, 'New Year', '', '', '', 'New Year', 'Celebration', '', '', '2021-01-01 10:00:00', '2021-01-01 16:00:00', '', '#A3D073', '', 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', '30-12-2020 07:00', '::1'), (183, '1', '31-12-2020 07:16', '::1'), (184, '1', '08-01-2021 08:54', '::1'), (185, '1', '09-01-2021 05:49', '::1'), (186, '1', '11-01-2021 05:49', '::1'), (187, '1', '11-01-2021 07:06', '::1'), (188, '1', '11-01-2021 06:32', '49.37.2.125'), (189, '1', '12-01-2021 05:29', '122.170.117.223'), (190, '1', '13-01-2021 06:12', '49.37.6.63'); -- -------------------------------------------------------- -- -- 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_hunar` -- CREATE TABLE `ihm_hunar` ( `id` int(11) NOT NULL, `h_type` varchar(20) DEFAULT NULL, `h_title` varchar(200) DEFAULT NULL, `h_file` varchar(100) DEFAULT NULL, `h_updated` varchar(50) DEFAULT NULL, `h_status` int(2) NOT NULL DEFAULT '1', `new` int(2) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- 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, '3664_academic.png', '0', '', '1'), (76, 2, 'Vision & Mission', 1, '', '0', '', '1'), (7, 0, 'Academics', 5, '10313_academic.png', '0', '', '1'), (8, 0, 'Facilities', 6, '26875_academic.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, '23832_academic.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, '9073_academic.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', '2021-01-09 07:59', 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=\"\" />Sankalp International School 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 Sankalp education Society which runs at AhmedabadSankalp International School 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 Sankalp International School Education Society which runs at Ahmedabad Sankalp International School 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 Sankalp International School Education Society which runs at Ahmedabad.</div>\r\n<div style=\"text-align: justify;\"> </div>\r\n<div style=\"text-align: justify;\">Sankalp International School 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 Sankalp International School Education Society which runs at Ahmedabad.Sankalp International School 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 Sankalp Education Society which runs at Ahmedabad.Sankalp International School 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 ', 'independence-day-', 1), (17, 'Annual Funtion', 'annual-funtion', 1), (13, 'Jolly Phonics', 'jolly-phonics', 1), (14, 'Training', 'training', 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 (112, 'Sankalp International School', 'photo_0901210711110.jpg', '09-Jan-2021', '13', 1), (101, 'Sankalp International School', 'photo_0901210650040.jpg', '09-Jan-2021', '17', 1), (94, '1243', 'nluo_1535689328.jpg', '30-Aug-2018', '10', 1), (106, 'Sankalp International School', 'photo_0901210703140.jpg', '09-Jan-2021', '14', 1), (102, 'Sankalp International School', 'photo_0901210650041.jpg', '09-Jan-2021', '17', 1), (103, 'Sankalp International School', 'photo_0901210650042.jpg', '09-Jan-2021', '17', 1), (104, 'Sankalp International School', 'photo_0901210650043.jpg', '09-Jan-2021', '17', 1), (105, 'Sankalp International School', 'photo_0901210650044.jpg', '09-Jan-2021', '17', 1), (107, 'Sankalp International School', 'photo_0901210703141.jpg', '09-Jan-2021', '14', 1), (108, 'Sankalp International School', 'photo_0901210703142.jpg', '09-Jan-2021', '14', 1), (109, 'Sankalp International School', 'photo_0901210703143.jpg', '09-Jan-2021', '14', 1), (110, 'Sankalp International School', 'photo_0901210703144.jpg', '09-Jan-2021', '14', 1), (111, 'Sankalp International School', 'photo_0901210703145.jpg', '09-Jan-2021', '14', 1), (113, 'Sankalp International School', 'photo_0901210711111.jpg', '09-Jan-2021', '13', 1), (114, 'Sankalp International School', 'photo_0901210711112.jpg', '09-Jan-2021', '13', 1), (115, 'Sankalp International School', 'photo_0901210711113.jpg', '09-Jan-2021', '13', 1), (116, 'Sankalp International School', 'photo_0901210711114.jpg', '09-Jan-2021', '13', 1), (117, 'Sankalp International School', 'photo_0901210718190.jpg', '09-Jan-2021', '10', 1), (118, 'Sankalp International School', 'photo_0901210718191.jpg', '09-Jan-2021', '10', 1), (119, 'Sankalp International School', 'photo_0901210718192.jpg', '09-Jan-2021', '10', 1), (120, 'Sankalp International School', 'photo_0901210718193.jpg', '09-Jan-2021', '10', 1), (121, 'Sankalp International School', 'photo_0901210720380.jpg', '09-Jan-2021', '10', 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 (19, '', 'Every child is like a seed which has the potential to grow if it is nourished with love and care under the right guidance.', ''), (20, '', 'Every child is like a seed which has the potential to grow if it is nourished with love and care under the right guidance.', ''), (21, '', 'Every child is like a seed which has the potential to grow if it is nourished with love and care under the right guidance.', ''), (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', '1462898702_New Project - 2021-01-09T152223.200.jpg', '', 2), (8, 'Sankalp International School', '527078179_New Project - 2021-01-08T152341.712.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, ' Sports', 'Sankalp International School is the top choice of the students best sports, Game in Ahmedabad due to its excellent academic infrastructure. ', '682702722_New Project - 2021-01-09T145315.277.jpg', '', '2018-01-31', '2021-01-09', ''), (2, ' Computer Lab', 'Sankalp International School is the top choice of the students looking for the best boarding schools in Ahmedabad due to its excellent. ', '1498304770_computer-lab.jpg', '', '2018-01-31', '2021-01-09', ''), (4, ' Bus Services', 'Sankalp International School is the top choice of the students looking for the best boarding schools in Ahmedabad . ', '930899320_bus-service.jpg', '', '2018-01-31', '2021-01-09', ''), (5, ' Play Area', 'While kids explore school playgrounds they are building important life skills that will eventually help children become effective collaborators.', '775915862_New Project - 2021-01-09T145024.439.jpg', '', '2018-01-31', '2021-01-09', ''); -- -------------------------------------------------------- -- -- 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 (1, '1st', 1, '2020-02-01', '2020-02-01', 0), (3, '7th', 1, '2020-12-30', '2020-12-30', 0), (4, '8th', 1, '2020-12-31', '2020-12-31', 0), (5, '6th', 1, '2020-12-31', '2020-12-31', 0), (6, '10th', 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', '', '396461215_video-player-YouTube.svg', '', 'videogallery.php', '2019-02-09', '2021-01-11'), (2, 'Upcoming Events', '', '3031_graduate.svg', '', 'news.php', '2019-02-09', '2021-01-11'), (3, 'Photo Gallery', '', '889419872_art-gallery-15.svg', '', 'photogallery.php', '2019-02-09', '2021-01-09'), (4, 'Contact Us', '', '845755206_Button---Contact-Us.svg', 'hello this is a demo text', 'contact-us.php', '2019-02-09', '2021-01-11'), (5, 'Exam Schedule', '', '1117087223_check-list2.svg', '', '0', '2020-12-29', '2021-01-09'), (6, 'Admission Enquiry', '', '715998537_14-512.png', '', 'apply-online.php', '2020-12-29', '2021-01-11'); -- -------------------------------------------------------- -- -- 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', 'We assimilate in building a strong culture of parent - school engagement. We postulate the important role that both parents and teachers play ...', '833606095_New Project - 2021-01-09T142353.398.jpg', '', '2019-02-09', '2021-01-09'), (2, 'TRAINING OF THE TEACHERS', 'We believe in possessing a great deal of knowledge and skills with regards to both teaching and assessment practices in order to enhance ...', '779877633_New Project - 2021-01-09T115828.792.jpg', '', '2019-02-09', '2021-01-09'), (3, 'GLOBAL PLATFORM', 'We build our students and prepare them for a better tomorrow and compete with the world on a global platform. Our methodologies helps them to...', '829867974_New Project - 2021-01-09T115602.112.jpg', '', '2019-02-09', '2021-01-09'), (4, 'TEACHING STAFF', 'Innovative world class curriculum, follows the traditional montessori method where we encourage to learn, grow and conquer at their own pace...', '818367060_New Project - 2021-01-09T115252.903.jpg', '', '2019-02-09', '2021-01-09'); -- -------------------------------------------------------- -- -- 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) 75 676 33300 , (+91) 75 676 33322', 'sankalpintschool@gmail.com', 'Timings : 8:30 AM to 4:30 PM', '<div>Sankalp International School</div>\r\n<div>Opp, Sammet Avenue,Behind Vishala Landmark,</div>\r\n<div>Vrundavan Party Plot to - Viratnagar Road,</div>\r\n<div>New Nikol, Ahmedabad</div>', 'sdad', 'https://www.facebook.com/plugins/page.php?href=https%3A%2F%2Fwww.facebook.com%2Fpages%2Fcategory%2FInterest%2FSankalp-International-School-Nikol-655026304699870%2F&tabs=timeline&width=340&height=500&small_header=true&adapt_container_width=true&hide_cover=false&show_facepile=true&appId', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3671.695580589023!2d72.6719719142827!3d23.03494702164743!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x395e8705f4dbd0e1%3A0x1f4eb57405e7a98d!2sSankalp%20International%20School!5e0!3m2!1sen!2sin!4v1610169113180!5m2!1sen!2sin', '#', '#', '#', '#', '23365_logo1.png'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_messagedesk` -- CREATE TABLE `tbl_messagedesk` ( `id` int(11) NOT NULL, `client_name` varchar(100) NOT NULL, `details` text NOT NULL, `logo` varchar(100) NOT NULL, `client_desc` text 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_messagedesk` -- INSERT INTO `tbl_messagedesk` (`id`, `client_name`, `details`, `logo`, `client_desc`, `more_link`, `created_date`, `update_date`) VALUES (1, 'Chairman\'s Message', 'Sankalp International School is a premier school in Nikol-Naroda-Odhav area that provides excellence in education for all our students, going to be evidenced in a tradition of rigorous academic standards and achievements soon. ', '8226_t1.jpg', '', '1', '2021-01-11', '2021-01-11'), (2, 'Managing Director\'s Message', 'Do we know what the world will look like in 20 years time? This is difficult to say; we see trends in phenomena relationships, environmental changes and so on. The world is changing more rapidly than ever', '15027_t2.jpg', '', '0', '2021-01-11', '2021-01-11'), (3, 'Trustee\'s Message', 'Sankalp International School, with its holistic approach shall emerge from an unlimited vision that is conceived by team Sankalp comprising of business entrepreneurs, educators, intellectuals, parents and our former students.', '14448_t3.jpg', '', '0', '2021-01-11', '2021-01-11'); -- -------------------------------------------------------- -- -- 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, '758714232_admission.jpeg', '', 0, '2021-01-12'); -- -------------------------------------------------------- -- -- 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; -- -------------------------------------------------------- -- -- Table structure for table `tbl_sitedetails` -- CREATE TABLE `tbl_sitedetails` ( `id` int(10) NOT NULL, `headline` varchar(200) NOT NULL, `subheadline` varchar(500) NOT NULL, `hcimage` varchar(250) NOT NULL, `c_link` varchar(100) NOT NULL, `content` text NOT NULL, `description` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_sitedetails` -- INSERT INTO `tbl_sitedetails` (`id`, `headline`, `subheadline`, `hcimage`, `c_link`, `content`, `description`) VALUES (1, 'WELCOME TO SANKALP INTERNATIONAL SCHOOL', '', '23480_about-us.jpg', '1', 'Sankalp International School 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 Sankalp education Society which runs at AhmedabadSankalp International School 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 Sankalp International School Education Society which runs at Ahmedabad Sankalp International School 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 Sankalp International School Education Society which runs at Ahmedabad.', ''); -- -------------------------------------------------------- -- -- 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 BARIK11919301220619.pdf'); -- -------------------------------------------------------- -- -- 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, `video_desc` text NOT NULL, `created_date` date NOT NULL, `updated_date` date NOT NULL, `view_status` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_video` -- INSERT INTO `tbl_video` (`id`, `video_title`, `video_link`, `video_desc`, `created_date`, `updated_date`, `view_status`) VALUES (2, 'SANKALP INTERNATIONAL SCHOOL', 'https://www.youtube.com/embed/CSoCjCrIGKE', '', '2021-01-09', '0000-00-00', 1); -- -- 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_hunar` -- ALTER TABLE `ihm_hunar` ADD PRIMARY KEY (`id`); -- -- 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_messagedesk` -- ALTER TABLE `tbl_messagedesk` 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_sitedetails` -- ALTER TABLE `tbl_sitedetails` 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=191; -- -- 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_hunar` -- ALTER TABLE `ihm_hunar` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- 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=122; -- -- 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=9; -- -- 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=6; -- -- AUTO_INCREMENT for table `tbl_course` -- ALTER TABLE `tbl_course` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- 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_messagedesk` -- ALTER TABLE `tbl_messagedesk` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- 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_sitedetails` -- ALTER TABLE `tbl_sitedetails` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `tbl_tc` -- ALTER TABLE `tbl_tc` MODIFY `sr_no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `tbl_video` -- ALTER TABLE `tbl_video` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; 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 */;