kohjhjhصثقص5572hjkhk7872ثقصثقgdfgdg
Ele57885fddfg872782782782 hjkhj782dfgfghgقفغفغفقhfg555434536
/
home4
/
kisgavwq
/
shashwatschool.ac.in
/
Upload FileeE
HOME
-- phpMyAdmin SQL Dump -- version 4.9.7 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Jul 08, 2022 at 09:03 AM -- Server version: 5.6.41-84.1 -- PHP Version: 7.4.30 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_shaswat` -- -- -------------------------------------------------------- -- -- 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', 'valkaschool@gmail.com', '8160790500', 1, '1', '2012-07-09'); -- -------------------------------------------------------- -- -- 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'), (190, '1', '24-09-2021 07:27', '::1'), (191, '1', '27-09-2021 11:11', '::1'), (192, '1', '30-09-2021 09:22', '::1'), (193, '1', '02-10-2021 07:52', '49.37.40.30'), (194, '1', '05-10-2021 01:06', '49.37.43.205'), (195, '1', '05-10-2021 01:31', '49.37.43.205'), (196, '1', '05-10-2021 02:45', '49.37.43.205'), (197, '1', '06-10-2021 01:39', '122.170.117.223'), (198, '1', '06-10-2021 04:14', '122.170.117.223'), (199, '1', '06-10-2021 05:13', '49.37.43.181'), (200, '1', '06-10-2021 01:43', '::1'), (201, '10', '18-01-2022 06:32', '::1'), (202, '10', '20-01-2022 08:27', '::1'), (203, '10', '21-01-2022 12:22', '::1'), (204, '1', '28-01-2022 07:33', '::1'), (205, '1', '18-04-2022 11:01', '::1'), (206, '1', '19-04-2022 08:20', '::1'), (207, '1', '20-04-2022 08:09', '::1'), (208, '1', '29-04-2022 12:49', '::1'), (209, '1', '14-05-2022 09:36', '::1'), (210, '1', '14-05-2022 01:11', '::1'), (211, '1', '14-05-2022 01:13', '::1'), (212, '1', '16-05-2022 08:46', '49.37.44.40'), (213, '1', '16-05-2022 08:50', '49.37.44.40'), (214, '1', '20-05-2022 07:42', '122.170.149.203'), (215, '1', '23-06-2022 04:06', '42.105.167.78'), (216, '1', '23-06-2022 08:28', '27.57.173.180'), (217, '1', '24-06-2022 02:31', '49.37.47.50'), (218, '1', '24-06-2022 10:37', '157.41.159.177'), (219, '1', '24-06-2022 11:34', '157.41.82.243'), (220, '1', '25-06-2022 01:23', '49.37.45.80'), (221, '1', '28-06-2022 10:19', '::1'), (222, '1', '29-06-2022 11:18', '::1'), (223, '1', '29-06-2022 12:41', '::1'), (224, '1', '29-06-2022 07:22', '49.37.45.244'), (225, '1', '08-07-2022 12:18', '49.37.47.134'), (226, '1', '08-07-2022 02:46', '49.37.47.134'), (227, '1', '08-07-2022 05:43', '157.41.143.73'), (228, '1', '08-07-2022 06:30', '49.37.47.134'); -- -------------------------------------------------------- -- -- 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, 0, 'Currently No News', 'currently-no-news', '6/29/2022', 'announcement_1535936471.png', '', 'Currently No News', 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', `menu_page` varchar(200) DEFAULT NULL, `menu_image` varchar(250) NOT NULL, `menu_target` varchar(20) DEFAULT NULL, `menu_status` char(2) DEFAULT NULL, `menu_type` int(1) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `ihm_menus` -- INSERT INTO `ihm_menus` (`menu_id`, `menu_pid`, `menu_name`, `menu_position`, `menu_page`, `menu_image`, `menu_target`, `menu_status`, `menu_type`) VALUES (1, 0, 'Home', 1, 'index.php', '', '', '1', 1), (2, 0, 'About', 2, '0', '', '', '1', 2), (3, 0, 'Admissions', 3, '67', '', '', '1', 1), (4, 0, 'Academics', 4, '67', '', '', '1', 0), (5, 0, 'Facilities', 5, '0', '', '', '1', 0), (6, 0, 'Activities', 6, '0', '', '', '1', 0), (7, 0, 'Gallery', 7, '0', '', '', '1', 0), (8, 0, 'Contact', 8, '0', '', '', '1', 0), (9, 133, 'Demo1', 1, '0', '', '', '1', 0), (10, 133, 'Mission', 1, '0', '', '', '1', 0), (11, 2, 'About Us', 1, '76', '', '', '1', 0), (12, 2, 'Principal\'s message', 3, '69', '', '', '1', 0), (13, 2, 'Vision & Mission', 2, '77', '', '', '1', 0), (14, 2, 'Trustee Sir\'s message', 4, '68', '', '', '1', 0), (15, 7, 'Photo Gallery', 1, 'photogallery.php', '', '', '1', 0), (16, 7, 'Video Gallery', 2, 'videogallery.php', '', '', '1', 0), (20, 0, 'Transfer Certificate', 7, 'transfer-certificates.php', '', '', '1', 0); -- -------------------------------------------------------- -- -- 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', '6/29/2022', '', '', 'Currently No News', 1, 1, 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 (76, 'About Us', 'about-us', 'static', '2022-07-08 01:15', 1), (77, 'Vision & Mission', 'vision-mission', 'static', '2022-06-29 11:22', 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 (76, 76, 'About Us', 'About Us', 'About Us', '<div style=\"text-align: justify;\">We believe that the destiny of a nation depends on the quality of education provided to its people. Children must always be empowered to become independent, perseverant, and responsible. Each child is unique with her own potential, strengths, weaknesses, interests, and attitude. The challenge before us is to strike a balance among information overload, exam-oriented teaching, and knowledge gain for sheer pleasure. We’re committed to bring individualized learning to all kinds of minds, and removing barriers that keep children from reaching their true potential. Our parents and students have the right to expect that our school provides a high-quality education endorsed by the education world.</div>'), (77, 77, 'Vision & Mission', '', '', ''); -- -------------------------------------------------------- -- -- 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 (28, 'Photo6', 'photo6', 1), (27, 'Photo5', 'photo5', 1), (23, 'Photo1', 'photo1', 1), (24, 'Photo2', 'photo2', 1), (25, 'Photo3', 'photo3', 1), (26, 'Photo4', 'photo4', 1), (29, 'Photo7', 'photo7', 1), (30, 'Photo8', 'photo8', 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 (121, 'Photo8', 'photo_2906220808310.jpg', '29-Jun-2022', '30', 1), (115, 'Photo2', 'photo_2906220803010.jpg', '29-Jun-2022', '24', 1), (116, 'Photo3', 'photo_2906220803480.jpg', '29-Jun-2022', '25', 1), (117, 'Photo4', 'nluo_1656558303.jpg', '29-Jun-2022', '26', 1), (118, 'Photo5', 'photo_2906220805590.jpg', '29-Jun-2022', '27', 1), (119, 'Photo6', 'photo_2906220806590.jpg', '29-Jun-2022', '28', 1), (120, 'Photo7', 'photo_2906220807380.jpg', '29-Jun-2022', '29', 1), (114, 'Photo 1', 'photo_2906220800557.jpg', '29-Jun-2022', '23', 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, `logo` varchar(255) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl1_testimonial` -- INSERT INTO `tbl1_testimonial` (`id`, `title`, `contents`, `Name`, `logo`) VALUES (22, 'Pranit Shah', 'Every child is like a seed which has the potential to grow if it is nourished with love and care under the right guidance.Every child is like a seed which has the potential to grow if it is nourished with love and care under the right guidance.', 'Pranit Shah', '1406886957_testimonial_3-100x100.jpg'), (23, 'Jaspal Sing', 'Every child is like a seed which has the potential to grow if it is nourished with love and care under the right guidance.Every child is like a seed which has the potential to grow if it is nourished with love and care under the right guidance.', 'Jaspal Sing', '472832832_testimonial_1-100x100.jpg'), (27, 'Nandini Sharma', 'Every child is like a seed which has the potential to grow if it is nourished with love and care under the right guidance.Every child is like a seed which has the potential to grow if it is nourished with love and care under the right guidance.', 'Nandini Sharma', '41148849_testimonial_2-100x100.jpg'), (28, 'NItya Devi', 'Every child is like a seed which has the potential to grow if it is nourished with love and care under the right guidance.Every child is like a seed which has the potential to grow if it is nourished with love and care under the right guidance.', 'NItya Devi', '1307138049_41148849_testimonial_2-100x100.jpg'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_alumni` -- CREATE TABLE `tbl_alumni` ( `id` int(11) NOT NULL, `name` varchar(200) NOT NULL, `dob` date NOT NULL, `email` varchar(200) NOT NULL, `phone` varchar(200) NOT NULL, `address` text NOT NULL, `yearpass` int(20) NOT NULL, `stream` varchar(100) NOT NULL, `classteacher` varchar(200) NOT NULL, `occupation` varchar(200) NOT NULL, `salary` varchar(100) NOT NULL, `country` varchar(200) NOT NULL, `aboutschool` text NOT NULL, `donate` varchar(100) NOT NULL, `adoptation` varchar(200) NOT NULL, `amout` varchar(200) NOT NULL, `bank` varchar(200) NOT NULL, `dated_added` date NOT NULL, `last_update` date NOT NULL, `annually` varchar(200) NOT NULL, `memories` text NOT NULL, `images` varchar(200) NOT NULL, `favteacher` varchar(200) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `tbl_alumni_registration` -- CREATE TABLE `tbl_alumni_registration` ( `id` int(11) NOT NULL, `name` varchar(200) NOT NULL, `address` text NOT NULL, `mobile` varchar(200) NOT NULL, `email` varchar(200) NOT NULL, `admission_batch` varchar(200) NOT NULL, `programme` varchar(200) NOT NULL, `year of passing` varchar(200) NOT NULL, `photo` varchar(255) NOT NULL, `student_education` varchar(200) NOT NULL, `salaried` varchar(200) NOT NULL, `entrepreneur` varchar(200) NOT NULL, `housemaker` varchar(200) NOT NULL, `compitative_exam` varchar(200) NOT NULL, `higer_education` varchar(200) NOT NULL, `specialization` varchar(200) NOT NULL, `institution` varchar(200) NOT NULL, `state` varchar(200) NOT NULL, `organization` varchar(200) NOT NULL, `office_address` varchar(200) NOT NULL, `designation` varchar(200) NOT NULL, `technical_experise` varchar(200) NOT NULL, `status` tinyint(1) NOT NULL, `created_date` date NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- 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', '1634015419_banner.jpg', '', 1), (8, 'Banner', '1230648886_banner11.jpg', '', 2); -- -------------------------------------------------------- -- -- 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, 'Science Lab', 'The school has well equipped laboratories for physics, chemistry and biology', '1165364116_test-results.png', '', '2018-01-31', '2021-09-30', ''), (2, 'Library', ' We strive to imbue in our students the determination and abilities to discover the... ', '934261720_book.png', '', '2018-01-31', '2022-01-18', ''), (3, 'Counselling', 'Guidance and counselling are important for children and schools have a huge role in bringing...', '1201522302_communication.png', '', '2018-01-31', '2022-07-08', '77'), (4, 'Computer Lab', 'The students are initiated to a host of integrated tools assisting the overall learning', '156068660_lab.png', '', '2018-01-31', '2021-09-30', ''), (5, 'Cafeteria Food', 'Safe and good quality foods are essential for maintaining sound health. ', '1021949028_cafeteria.png', '', '2018-01-31', '2021-09-30', ''), (6, 'Sports', 'Sports and games curriculum is an integrated and compulsory part of the education..', '254353367_sport.png', '', '2018-01-31', '2022-01-18', ''); -- -------------------------------------------------------- -- -- 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, 'Academics', '', '1893966292_diploma.png', 'To provide quality education with Indian ethos, ensure burdenless learning, develop the individuality of each child in a cognitive and happy environment', '', '2019-02-09', '2022-01-18'), (2, 'Admission', '', '1427845858_writing.png', 'To provide quality education with Indian ethos, ensure burdenless learning, develop the individuality of each child in a cognitive and happy environment', '', '2019-02-09', '2022-01-18'), (3, 'Upcoming Events', '', '1429572913_event.png', 'To provide quality education with Indian ethos, ensure burdenless learning, develop the individuality of each child in a cognitive and happy environment', '', '2019-02-09', '2022-01-18'), (4, 'Online Classes', '', '377811349_webinar.png', 'To provide quality education with Indian ethos, ensure \r\nburdenless learning, develop the individuality of each child in a cognitive and happy environment', '', '2019-02-09', '2022-04-19'); -- -------------------------------------------------------- -- -- 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, 'Republic Day', 'We believe that the destiny of a nation depends on the quality of education provided... ', '839703428_fa12.jpg', '', '2019-02-09', '2022-06-28'), (2, 'Creative Activites', 'We believe that the destiny of a nation depends on the quality of education provided... ', '1950670213_fa11.jpg', '', '2019-02-09', '2022-06-28'), (3, 'Plating Seeds', 'We believe that the destiny of a nation depends on the quality of education provided... ', '600628933_New Project.jpg', '', '2019-02-09', '2022-06-28'), (6, ' Holistic Learning', 'We believe that the destiny of a nation depends on the quality of education provided...', '2045403784_fa13.jpg', '77', '2022-04-19', '2022-07-08'); -- -------------------------------------------------------- -- -- 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, `whatsapp` varchar(100) 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`, `whatsapp`) VALUES (1, '9100092300 / 9124091240', 'info@shaswatschool.org', ' ', '<div>Nr. Sampad Residency, Bhat Motera Link Rd,<br />\r\nopp. Dev Prayag, Motera, <br />\r\nAhmedabad, Gujarat 382424</div>\r\n<div> </div>\r\n<div> </div>', 'sdad', 'https://www.facebook.com/plugins/page.php?href=https%3A%2F%2Fwww.facebook.com%2FMicroWebSolutions%2F&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!1d7339.615116697967!2d72.6111599!3d23.1041395!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x395e83d71f96f825%3A0x6e931c673ed77d69!2sShashwat%20School!5e0!3m2!1sen!2sin!4v1656505520485!5m2!1sen!2sin', '', '', '', '', '1664887521_logo01.png', 'https://api.whatsapp.com/send?phone=919100091000'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_implink` -- CREATE TABLE `tbl_implink` ( `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_implink` -- INSERT INTO `tbl_implink` (`id`, `link_name`, `link_url`, `created_date`, `update_date`) VALUES (1, 'ALUMNI', 'alumni.php', '2021-10-05', '2021-10-05'), (2, 'STUDENT', '0', '2021-10-05', '2021-10-05'), (3, 'FACULTIES', '0', '2021-10-05', '2021-10-05'), (4, 'CAREERS', '0', '2021-10-05', '2021-10-05'); -- -------------------------------------------------------- -- -- 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, '1025125555_banner13.jpg', '', 0, '2022-07-08'); -- -------------------------------------------------------- -- -- 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, 'Home', '', '2019-02-09', '2022-06-29'), (2, 'About', '', '2019-02-09', '2022-06-29'), (3, 'Admission', '', '2019-02-09', '2022-06-29'), (4, 'Academics', '', '2019-02-09', '2022-06-29'), (5, 'Facilities', '', '2019-02-09', '2022-06-29'), (6, 'Activities', '', '2022-06-29', '2022-06-29'), (7, 'Gallery', '', '2022-06-29', '2022-06-29'), (8, 'Contact', '', '2022-06-29', '2022-06-29'); -- -------------------------------------------------------- -- -- 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_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, `site_add` text NOT NULL, `city` varchar(100) NOT NULL, `pin` varchar(100) NOT NULL, `state` varchar(100) NOT NULL, `country` varchar(100) NOT NULL, `mobile` varchar(250) NOT NULL, `phone` varchar(250) NOT NULL, `email` varchar(250) NOT NULL, `facebook` varchar(250) NOT NULL, `twitter` varchar(250) NOT NULL, `google` varchar(250) NOT NULL, `solution_title` varchar(100) NOT NULL, `solution_content` varchar(250) 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`, `site_add`, `city`, `pin`, `state`, `country`, `mobile`, `phone`, `email`, `facebook`, `twitter`, `google`, `solution_title`, `solution_content`) VALUES (1, 'WELCOME TO SHASHWAT SCHOOL', '', '676064150_about.jpg', '76', '<div style=\"text-align: justify;\">To transform the school into a Centre of Excellence in where the students as well as teachers gain the best possible experiences, exposure and opportunities to acquire knowledge and learning through most effective tools and technology so that the true scope and depth of education can be fully realised. To provide quality education with Indian ethos, ensure burdenless learning, develop the individuality of each child in a cognitive and happy environment so that they develop spiritually and morally, become confident and compassionate are resilient and have the competencies to flourish with an entrepreneurial spirit, problem solving, teamwork, and a positive attitude towards their work, family and community.</div>', '', '', '', '', '', '', '9100091000', '', 'tpm@gmail.com', 'a', 'a', 'a', 'Enterprise Solutions', ''); -- -------------------------------------------------------- -- -- 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 (4, 'Swadhin Kumar barik', 'V', '122', 'SWADHIN KUMAR BARIK122228722366.pdf'), (5, 'Shantanu Kumar barik', '6', '125', 'SHANTANU KUMAR BARIK125258722521.pdf'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_titles` -- CREATE TABLE `tbl_titles` ( `id` int(11) NOT NULL, `title` varchar(250) NOT NULL, `description` text NOT NULL, `image` varchar(200) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbl_titles` -- INSERT INTO `tbl_titles` (`id`, `title`, `description`, `image`) VALUES (1, 'Latest Notice', '', ''), (8, 'School Facilities', '', ''), (9, 'Latest News & Events', 'To bring out the latent talent in each child keeping the school’s ethos of ‘Each Child a Champion’.', ''), (10, 'Parent\'s Speak', '', ''), (11, 'School Activities', 'To bring out the latent talent in each child keeping the school’s ethos of ‘Each Child a Champion’.', ''), (12, 'Life at The SHASHWAT JUNIORS SCHOOL', '', ''); -- -------------------------------------------------------- -- -- 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, 'Powers of Mind | Swami Vivekananda', 'https://www.youtube.com/embed/QDjh1A3c3z0', '2021-10-05', '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_alumni` -- ALTER TABLE `tbl_alumni` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_alumni_registration` -- ALTER TABLE `tbl_alumni_registration` 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_implink` -- ALTER TABLE `tbl_implink` 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_titles` -- ALTER TABLE `tbl_titles` ADD PRIMARY KEY (`id`); -- -- 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=229; -- -- 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=21; -- -- AUTO_INCREMENT for table `ihm_news` -- ALTER TABLE `ihm_news` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=83; -- -- 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=78; -- -- AUTO_INCREMENT for table `ihm_page_contents` -- ALTER TABLE `ihm_page_contents` MODIFY `page_cid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=78; -- -- AUTO_INCREMENT for table `ihm_photo_category` -- ALTER TABLE `ihm_photo_category` MODIFY `category_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31; -- -- 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=29; -- -- AUTO_INCREMENT for table `tbl_alumni` -- ALTER TABLE `tbl_alumni` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tbl_alumni_registration` -- ALTER TABLE `tbl_alumni_registration` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tbl_banner` -- ALTER TABLE `tbl_banner` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10; -- -- 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=5; -- -- AUTO_INCREMENT for table `tbl_glance` -- ALTER TABLE `tbl_glance` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- 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_implink` -- ALTER TABLE `tbl_implink` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- 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=9; -- -- 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=6; -- -- AUTO_INCREMENT for table `tbl_titles` -- ALTER TABLE `tbl_titles` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- 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 */;