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

START TRANSACTION;



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

--
-- Table structure for table `tbl_achievement`
--

CREATE TABLE `tbl_achievement` (
  `id` int(11) NOT NULL,
  `department` varchar(111) NOT NULL,
  `title` varchar(250) NOT NULL,
  `slug` varchar(250) NOT NULL,
  `created` varchar(250) NOT NULL,
  `description` blob NOT NULL,
  `status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_achievement`
--

INSERT INTO `tbl_achievement` (`id`, `department`, `title`, `slug`, `created`, `description`, `status`) VALUES
(1, 'computer-science-and-engineering', 'test', 'test', 'Jan-27-2020', 0x3c703e3c7374726f6e673e4d722e2053617572616268206b756d617220676f7420474f4c44204d4544414c20696e203230313820666f72207365637572696e672031737420706f736974696f6e20696e20414b5455206d65726974206c6973742e3c2f7374726f6e673e3c2f703e0d0a, 1),
(2, 'information-technology', 'ACADEMIC ACHIEVEMENTS', 'academic-achievements', 'Jan-27-2020', 0x3c68333e3c7374726f6e673e4d722e2044656570616b2059616461762073656375726564204149522031383920696e204741544520323031392e3c2f7374726f6e673e3c2f68333e0d0a, 1);

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

--
-- Table structure for table `tbl_achievement_gallery`
--

CREATE TABLE `tbl_achievement_gallery` (
  `id` int(111) NOT NULL,
  `e_id` int(111) NOT NULL,
  `name` varchar(222) NOT NULL,
  `image` varchar(222) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_achievement_gallery`
--

INSERT INTO `tbl_achievement_gallery` (`id`, `e_id`, `name`, `image`) VALUES
(2, 2, 'dsfsdafdsa', '1580136001dfd.jpg'),
(4, 2, 'TESTT', '158013623515786714501573745859scholarship2.jpg'),
(5, 2, 'DFD', '158013624115786714391573745669course2.jpg'),
(6, 1, 'DDDDDD', '158013627015786714391573745669course2.jpg');

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

--
-- Table structure for table `tbl_announce`
--

CREATE TABLE `tbl_announce` (
  `id` int(11) NOT NULL,
  `name` varchar(222) NOT NULL,
  `status` varchar(11) NOT NULL,
  `created` varchar(111) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_announce`
--

INSERT INTO `tbl_announce` (`id`, `name`, `status`, `created`) VALUES
(1, 'Congratulations!!! to Dr. Meghna Singh (Assistant Professor in Department of Bio-Technology IMSEC Ghaziabad)', '1', ''),
(2, 'IIC Certificate Of Establishment awarded to IMSEC at First Annual Innovation Festival of MHRD Innovation Cell.', '1', ''),
(4, 'Congratulations!!! Project titled “Post-Harvest Crop Management System Using IOT and AI” won overall first prize.', '1', '');

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

--
-- Table structure for table `tbl_category`
--

CREATE TABLE `tbl_category` (
  `id` int(11) NOT NULL,
  `p_id` int(11) NOT NULL,
  `name` varchar(250) NOT NULL,
  `sno` int(11) NOT NULL,
  `image` varchar(255) NOT NULL,
  `slug` varchar(250) NOT NULL,
  `bg_color` varchar(250) NOT NULL,
  `seo_title` varchar(250) NOT NULL,
  `seo_key` varchar(225) NOT NULL,
  `seo_des` varchar(225) NOT NULL,
  `zero` varchar(233) NOT NULL,
  `description` blob NOT NULL,
  `status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_category`
--

INSERT INTO `tbl_category` (`id`, `p_id`, `name`, `sno`, `image`, `slug`, `bg_color`, `seo_title`, `seo_key`, `seo_des`, `zero`, `description`, `status`) VALUES
(1, 0, 'Core Faculty', 0, '', 'core-faculty', '', '', '', '', '', '', 0),
(2, 0, 'Staff and Administration', 0, '', 'staff-and-administration', '', '', '', '', '', '', 0),
(3, 0, 'Corporate Resource Center', 0, '', 'corporate-resource-center', '', '', '', '', '', '', 0),
(4, 1, 'Director Profile', 1, '', 'director-profile', '', 'Faculty Director Profile in IMS Ghaziabad', 'Faculty Director Profile in IMS Ghaziabad', 'Faculty Director Profile in IMS Ghaziabad', '', '', 0),
(5, 1, 'Marketing', 2, '', 'marketing', '', 'Faculty Marketing in IMS Ghaziabad', 'Faculty Marketing in IMS Ghaziabad', 'Faculty Marketing in IMS Ghaziabad', '', '', 0),
(8, 2, 'Library', 1, '', 'library', '', 'Library Department of IMS Ghaziabad', 'Library Department of IMS Ghaziabad', 'Library Department of IMS Ghaziabad', '', '', 0),
(9, 3, 'Training and placement', 0, '', 'training-and-placement', '', 'Faculty Training and placement in IMS Ghaziabad', 'Faculty Training and placement in IMS Ghaziabad', 'Faculty Training and placement in IMS Ghaziabad', '', '', 0),
(10, 1, 'Finance ', 3, '', 'finance-', '', 'Faculty Finance in IMS Ghaziabad', 'Faculty Finance in IMS Ghaziabad', 'Faculty Finance in IMS Ghaziabad', '', '', 0),
(11, 1, 'HR', 4, '', 'hr', '', 'Faculty HR in IMS Ghaziabad', 'Faculty HR in IMS Ghaziabad', 'Faculty HR in IMS Ghaziabad', '', '', 0),
(12, 1, 'Corporate Law and Governance', 5, '', 'corporate-law-and-governance', '', 'Faculty Corporate Law and Governance in IMS Ghaziabad', 'Faculty Corporate Law and Governance in IMS Ghaziabad', 'Faculty Corporate Law and Governance in IMS Ghaziabad', '', '', 0),
(13, 1, 'Operations ', 6, '', 'operations-', '', 'Faculty Operations in IMS Ghaziabad', 'Faculty Operations in IMS Ghaziabad', 'Faculty Operations in IMS Ghaziabad', '', '', 0),
(14, 1, 'Economics', 7, '', 'economics', '', 'Faculty Economics in IMS Ghaziabad', 'Faculty Economics in IMS Ghaziabad', 'Faculty Economics in IMS Ghaziabad', '', '', 0),
(15, 1, 'QTM', 9, '', 'qtm', '', 'Faculty QTM in IMS Ghaziabad', 'Faculty QTM in IMS Ghaziabad', 'Faculty QTM in IMS Ghaziabad', '', '', 0),
(17, 1, 'Information Technology', 10, '', 'information-technology', '', 'Faculty Information Technology in IMS Ghaziabad', 'Faculty Information Technology in IMS Ghaziabad', 'Faculty Information Technology in IMS Ghaziabad', '', '', 0),
(19, 2, 'Academic Office', 2, '', 'academic-office', '', 'Academic Department of IMS Ghaziabad', 'Academic Department of IMS Ghaziabad', 'Academic Department of IMS Ghaziabad', '', '', 0),
(20, 2, 'IT Department', 3, '', 'it-department', '', 'IT Department in IMS Ghaziabad', 'IT Department in IMS Ghaziabad', 'IT Department in IMS Ghaziabad', '', '', 0),
(21, 2, 'H.R. Department', 4, '', 'hr-department', '', 'H.R. Department in IMS Ghaziabad', 'H.R. Department in IMS Ghaziabad', 'H.R. Department in IMS Ghaziabad', '', '', 0),
(22, 2, 'Administration', 5, '', 'administration', '', 'Administration in IMS Ghaziabad', 'Administration in IMS Ghaziabad', 'Administration in IMS Ghaziabad', '', '', 0),
(24, 2, 'Admission Department', 6, '', 'admission-department', '', 'Admission Department in IMS Ghaziabad', 'Admission Department in IMS Ghaziabad', 'Admission Department in IMS Ghaziabad', '', '', 0),
(27, 1, 'PPSP', 11, '', 'ppsp', '', 'Faculty PPSP of IMS Ghaziabad', 'Faculty PPSP of IMS Ghaziabad', 'Faculty PPSP of IMS Ghaziabad', '', '', 0),
(28, 1, 'International  Business', 8, '', 'international-business', '', '', '', '', '', '', 0),
(29, 2, 'Registrar office', 7, '', 'registrar-office', '', 'Registrar office', 'Registrar office', 'Registrar office', '', '', 0),
(30, 0, 'test', 0, '', 'test', '', '', '', '', '', '', 0),
(31, 30, 'aaaa', 3, '', 'aaaa', '', 'aa', 'aaaaaaaaaaaaaa', 'aaaaaaaaaaaa', '', 0x3c703e6161616161616161616161616161616161613c2f703e0d0a, 0),
(32, 1, 'Professor', 0, '', 'professor', '', '', '', '', '', '', 0);

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

--
-- Table structure for table `tbl_cource`
--

CREATE TABLE `tbl_cource` (
  `id` int(11) NOT NULL,
  `name` varchar(111) NOT NULL,
  `slug` varchar(111) NOT NULL,
  `heading` varchar(222) NOT NULL,
  `description` blob NOT NULL,
  `image` varchar(222) NOT NULL,
  `seo_title` varchar(111) NOT NULL,
  `seo_key` varchar(222) NOT NULL,
  `seo_meta` varchar(888) NOT NULL,
  `home` int(11) NOT NULL,
  `status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_cource`
--

INSERT INTO `tbl_cource` (`id`, `name`, `slug`, `heading`, `description`, `image`, `seo_title`, `seo_key`, `seo_meta`, `home`, `status`) VALUES
(1, 'Postgraduate Diploma', 'postgraduate-diploma', 'Postgraduate Diploma In Digital Business Management (PGDBM)', 0x[BLOB], '1573748470computing-lab.jpg', '', '', '', 0, 1),
(2, 'pgdm', 'pgdm', 'Post Graduate Diploma in Digital Business Management (PGDBM)', 0x[BLOB], '1574081557course3.jpg', '', '', '', 0, 1),
(3, 'Postgraduate Programmes', 'postgraduate-programmes', 'Postgraduate Diploma In International Management In Digital Economy (PGDIM-DE)', 0x[BLOB], '1574081745course5.jpg', '', '', '', 0, 1),
(4, 'Post Graduate Diploma', 'post-graduate-diploma', 'Post Graduate Diploma in Digital Business Management (PGDBM)', 0x[BLOB], '1574081765course6.jpg', '', '', '', 0, 1);

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

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

CREATE TABLE `tbl_department` (
  `id` int(11) NOT NULL,
  `name` varchar(222) NOT NULL,
  `slug` varchar(111) NOT NULL,
  `status` int(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `tbl_department` (`id`, `name`, `slug`, `status`) VALUES
(1, 'biotechnology', 'biotechnology', 1),
(2, 'MBA', 'mba', 1),
(3, 'Computer science and engineering', 'computer-science-and-engineering', 1),
(4, 'Information Technology', 'information-technology', 1),
(5, 'Electronics and Communication', 'electronics-and-communication', 1),
(6, 'Electrical and Electronics', 'electrical-and-electronics', 1),
(7, 'Mechanical Engineering', 'mechanical-engineering', 1);

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

--
-- Table structure for table `tbl_event`
--

CREATE TABLE `tbl_event` (
  `id` int(11) NOT NULL,
  `department` varchar(111) NOT NULL,
  `event_title` varchar(250) NOT NULL,
  `category` int(11) NOT NULL,
  `slug` varchar(250) NOT NULL,
  `created` varchar(250) NOT NULL,
  `about` varchar(888) NOT NULL,
  `description` blob NOT NULL,
  `event_date` varchar(250) NOT NULL,
  `timing` varchar(222) NOT NULL,
  `location` varchar(111) NOT NULL,
  `image` varchar(222) NOT NULL,
  `seo_title` varchar(222) NOT NULL,
  `seo_key` varchar(555) NOT NULL,
  `seo_des` varchar(555) NOT NULL,
  `home` int(11) NOT NULL,
  `status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_event`
--

INSERT INTO `tbl_event` (`id`, `department`, `event_title`, `category`, `slug`, `created`, `about`, `description`, `event_date`, `timing`, `location`, `image`, `seo_title`, `seo_key`, `seo_des`, `home`, `status`) VALUES
(1, 'information-technology', 'PGDM Students won 2nd Prize in CII Majestic Skill Will Lead', 1, 'pgdm-students-won-2nd-prize-in-cii-majestic-skill-will-lead', 'Jan-24-2020', 'dsfdasf', 0x[BLOB], '2018-10-23', '', '', '1579880783biotech.png', 'PGDM Students won 2nd Prize in CII Majestic Skill Will Lead', '', ' ', 0, 1),
(2, 'information-technology', 'helllo', 2, 'helllo', 'Jan-24-2020', 'dsfasd', 0x3c703e737373737373737373733c2f703e0d0a, '2018-10-27', '', '', '1579880776algoworks.jpg', 'PGDM Students won 2nd Prize in CII Majestic Skill Will Lead2', '', ' ', 0, 1),
(3, 'electronics-and-communication', 'sdafdsa', 1, 'sdafdsa', 'Jan-22-2020', 'dfadsf', 0x3c703e6461666473613c2f703e0d0a, '2018-10-04', '', '', '1540565743jellyfish.jpg', 'sdafdsa', '', ' ', 0, 1),
(4, 'biotechnology', 'Faculty Exchange Programme at MADE in India Academy, Bangalore', 2, 'faculty-exchange-programme-at-made-in-india-academy-bangalore', 'Jan-22-2020', 'sdafdsa', 0x[BLOB], '2018-10-14', '8:00 am - 5:00 pm', 'India', '1573745911scholarship1.jpg', 'erferendis adip..Lorem ipsum dolor sit amet, consectetur adipisic', 'erferendis adip..Lorem ipsum dolor sit amet, consectetur adipisic', ' erferendis adip..Lorem ipsum dolor sit amet, consectetur adipisic', 1, 1),
(5, 'civil-engineering', '  Sept Student Exchange Programme   ', 2, 'sept-student-exchange-programme', 'Jan-22-2020', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit. Assumenda est quae eveniet a perferendis adipisci, tempora molestias alias eos nam quam, deleniti illum sed, modi iste? Eveniet maior', 0x[BLOB], '2019-10-07', '8:00 am - 5:00 pm', 'India', '1573745859scholarship2.jpg', 'ssumenda est q', 'ssumenda est q', ' ssumenda est q', 1, 1),
(6, 'computer-science-and-engineering', 'NGO Meet organised by MADE in India Academy, Bangalore', 1, 'ngo-meet-organised-by-made-in-india-academy-bangalore', 'Jan-22-2020', 'asdfdsafdsa', 0x[BLOB], '2019-10-15', '8:00 am - 5:00 pm', 'New York, US', '1573745669course2.jpg', 'NGO Meet organised by MADE in India Academy, Bangalore', 'NGO Meet organised by MADE in India Academy, Bangalore', ' NGO Meet organised by MADE in India Academy, Bangalore', 1, 1),
(7, 'biotechnology', 'sssss', 1, 'sssss', 'Jan-22-2020', 'sssssssssssssss', '', '2020-01-13', '', '', '15789284433.jpg', 'sssss', '', ' ', 1, 1),
(8, 'electrical-and-electronics', 'dsafads', 2, 'dsafads', 'Jan-24-2020', 'fdsaf', 0x3c703e647361663c2f703e0d0a, '2020-01-07', 'dsafdsa', '', '1579881077capitalvia.png', 'fdsaf', 'dsa', 'fads', 1, 1),
(9, 'mba', 'dsafdas', 1, 'dsafdas', 'Jan-24-2020', 'fdasf', 0x3c703e647361663c2f703e0d0a, '2020-01-08', '', '', '1579881384capitalvia.png', 'dsafdas', '', ' ', 1, 1);

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

--
-- Table structure for table `tbl_event_cat`
--

CREATE TABLE `tbl_event_cat` (
  `id` int(11) NOT NULL,
  `name` varchar(222) NOT NULL,
  `status` int(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_event_cat`
--

INSERT INTO `tbl_event_cat` (`id`, `name`, `status`) VALUES
(1, 'first', 1),
(2, 'test', 0),
(3, 'dsafdsaf', 1);

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

--
-- Table structure for table `tbl_event_gallery`
--

CREATE TABLE `tbl_event_gallery` (
  `id` int(111) NOT NULL,
  `e_id` int(111) NOT NULL,
  `name` varchar(222) NOT NULL,
  `image` varchar(222) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_event_gallery`
--

INSERT INTO `tbl_event_gallery` (`id`, `e_id`, `name`, `image`) VALUES
(5, 4, 'dsfgsfd', '1540563915penguins.jpg'),
(6, 2, 'fdsgdsf', '1540563930hydrangeas.jpg'),
(8, 3, 'sdafdsa', '1540568486desert.jpg'),
(9, 5, 'aaaaaaaaaaaa', '15714134492.jpg'),
(12, 5, 'fdsgsdf', '15714150481.jpg'),
(13, 5, 'dsafdsaf', '15714153653.jpg'),
(14, 6, 'asdfads', '15789224132.jpg'),
(15, 6, 'sdfd', '15789224183.jpg'),
(16, 6, 'dsfds', '15789224271.jpg'),
(17, 7, 'df', '157970619315790162141573745669course2.jpg');

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

--
-- Table structure for table `tbl_faculty1`
--

CREATE TABLE `tbl_faculty1` (
  `id` int(11) NOT NULL,
  `department` varchar(111) NOT NULL,
  `name` varchar(222) NOT NULL,
  `about` varchar(555) NOT NULL,
  `designation` varchar(111) NOT NULL,
  `email` varchar(111) NOT NULL,
  `phone` varchar(111) NOT NULL,
  `education` varchar(333) NOT NULL,
  `position` varchar(111) NOT NULL,
  `experience` varchar(555) NOT NULL,
  `qualification` varchar(111) NOT NULL,
  `exp` varchar(111) NOT NULL,
  `award` varchar(555) NOT NULL,
  `journal` varchar(555) NOT NULL,
  `image` varchar(111) NOT NULL,
  `slug` varchar(111) NOT NULL,
  `seo_des` varchar(555) NOT NULL,
  `seo_title` varchar(111) NOT NULL,
  `seo_key` varchar(222) NOT NULL,
  `status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_faculty1`
--

INSERT INTO `tbl_faculty1` (`id`, `department`, `name`, `about`, `designation`, `email`, `phone`, `education`, `position`, `experience`, `qualification`, `exp`, `award`, `journal`, `image`, `slug`, `seo_des`, `seo_title`, `seo_key`, `status`) VALUES
(1, 'Operations Committee', 'dsafdsaf', '<p>\r\n	dsafdsafdfg fds gfdsg</p>\r\n', 'ttttttttttt', 'sdfgsfd', 'dfsgfd', '', '', '', '', '', '', '', '', '', '', '', '', 1),
(2, 'Governing Council', 'G K C Reddy', '<p>\r\n	&nbsp;G K C Reddy</p>\r\n', '', ' ', ' G K C Reddy', '', '', '', '', '', '', '', '', '', '', '', '', 1),
(3, 'Governing Council', 'Prof. S L Rao', '<p>\r\n	<span style=\"color: rgb(122, 122, 122); font-family: Roboto, sans-serif; font-size: 13px; text-align: center;\">Former Director General NCAER, New Delhi.</span><br style=\"box-sizing: inherit; color: rgb(122, 122, 122); font-family: Roboto, sans-serif; font-size: 13px; text-align: center;\" />\r\n	<span style=\"color: rgb(122, 122, 122); font-family: Roboto, sans-serif; font-size: 13px; text-align: center;\">Former, Chairman, Governing Council, ISEC, Bangalore</span></p>\r\n', ' ', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 1),
(4, 'Operations Committee', 'ddddddddd', '<p>\r\n	dfsgsfd fds fdsg dsfg</p>\r\n', 'ffffffffff', 'fgfds', 'dfsgsfdg', '', '', '', '', '', '', '', '', '', '', '', '', 1),
(5, 'Information Technology', 'aaaaaaaa', '<p>adsfadsf</p>\r\n', 'dsafdsa', 'fsdaf', 'dsaf', '', '', '', '', '', '', '', '', '', ' dsaf', 'sadf', 'dsaf', 1),
(6, 'Computer Science And Engineering', 'V. Umesh', '<p>Additional Chief Secretary, Govt of Karnataka<br />\r\nI A S (Retd)</p>\r\n', '', '', '', '', '', '', '', '', '', '', '', '', ' fdsa', 'adsfdsa', 'fdsa', 1),
(7, 'Biotechnology', 'test', '<p>adfsda fdsa fsda</p>\r\n', 'ssssss', 'ss@gmail.com', '32423423', 'dsafsdaf', '', 'sdafdsaf', '', '12 year', 'sdafsdaf', 'sdafds', '15790163221573745669course2.jpg', 'test', 'fsdafds', 'dsafdsa', 'fdsa', 1);

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

--
-- Table structure for table `tbl_feedback`
--

CREATE TABLE `tbl_feedback` (
  `id` int(11) NOT NULL,
  `name` varchar(222) NOT NULL,
  `email` varchar(222) NOT NULL,
  `phone` varchar(222) NOT NULL,
  `address` varchar(333) NOT NULL,
  `description` varchar(999) NOT NULL,
  `creation` varchar(222) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_feedback`
--

INSERT INTO `tbl_feedback` (`id`, `name`, `email`, `phone`, `address`, `description`, `creation`) VALUES
(1, 'sadfdsa', 'fsda@sdf', 'sdafdsa', 'fdsaf', 'dsafdsa', '25/11/19'),
(2, 'fdsafsad', 'dsaf', 'fsdaf', 'dsafdsa', 'fdas', '25/11/19'),
(3, 'adsfads', 'fdsaf', 'dsafdas', 'dasf', 'fdsaf', '25/11/19'),
(4, 'fsda', 'fdsaf', 'sdaf', 'dasfdsa', 'fdsaf', '25/11/19');

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

--
-- Table structure for table `tbl_news`
--

CREATE TABLE `tbl_news` (
  `id` int(11) NOT NULL,
  `department` varchar(111) NOT NULL,
  `news_title` varchar(250) NOT NULL,
  `image` varchar(111) NOT NULL,
  `slug` varchar(250) NOT NULL,
  `created` varchar(250) NOT NULL,
  `description` blob NOT NULL,
  `news_date` varchar(250) NOT NULL,
  `seo_title` varchar(222) NOT NULL,
  `seo_key` varchar(555) NOT NULL,
  `seo_des` varchar(555) NOT NULL,
  `home` int(11) NOT NULL,
  `status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_news`
--

INSERT INTO `tbl_news` (`id`, `department`, `news_title`, `image`, `slug`, `created`, `description`, `news_date`, `seo_title`, `seo_key`, `seo_des`, `home`, `status`) VALUES
(1, '', 'News Heading', '', 'news-heading', 'Oct-26-2018', 0x3c703e0d0a0974657374206f6e65206465736372697074696f6e266e6273703b74657374206f6e65206465736372697074696f6e266e6273703b74657374206f6e65206465736372697074696f6e3c2f703e0d0a, '2018-10-16', '', '', '', 0, 0),
(2, 'Civil Engineering', 'facebook news', '', 'facebook-news', 'Jan-10-2020', 0x[BLOB], '2018-10-10', 'facebook news', '', ' ', 0, 0),
(3, '', 'dsaf', '', 'dsaf', 'Oct-18-2019', 0x3c703e0d0a09647361663c2f703e0d0a, '2018-10-08', 'dsaf', '', ' ', 0, 1),
(4, '', 'Marlabs Featured In BDCC Global List Of Top Devops Consulting Companies In The World.', '', 'marlabs-featured-in-bdcc-global-list-of-top-devops-consulting-companies-in-the-world.', 'Nov-14-2019', 0x[BLOB], '2019-10-17', 'Marlabs Featured In BDCC Global List Of Top Devops Consulting Companies In The World.', 'Marlabs Featured In BDCC Global List Of Top Devops Consulting Companies In The World.', ' Marlabs Featured In BDCC Global List Of Top Devops Consulting Companies In The World.', 1, 1),
(5, 'Electronics and Communication', 'Healthcare 4.0 At The Intersection Of Data Automation, And Analytics', '', 'healthcare-4.0-at-the-intersection-of-data-automation-and-analytics', 'Jan-10-2020', 0x[BLOB], '2019-10-18', 'afdsa', 'fdasf', ' fdasf', 1, 1),
(7, 'Information Technology', 'Exclusive Webinar The Fallacy Of Cloud Security', '15786714501573745859scholarship2.jpg', 'exclusive-webinar-the-fallacy-of-cloud-security', 'Jan-10-2020', 0x3c703e3c6120687265663d22687474703a2f2f6c6f63616c686f73742f6d6164652f6e6577732d6465736372697074696f6e2e706870223e4578636c757369766520576562696e61723a205468652046616c6c616379204f6620436c6f75642053656375726974793c2f613e3c2f703e0d0a, '2019-10-08', 'sdafdsa', 'fdsaf', ' fdsaf', 1, 1),
(8, 'Computer Science And Engineering', 'sadfdsa', '15786714391573745669course2.jpg', 'sadfdsa', 'Jan-10-2020', 0x3c703e616161616161616161616161616161616161613c2f703e0d0a, '2020-01-07', 'adsfdas', 'fdsaf', ' fdsaf', 1, 1),
(9, 'Biotechnology', 'test', '158013368515786714501573745859scholarship2.jpg', 'test sty', 'Jan-27-2020', 0x3c703e61616161616161616161613c2f703e0d0a, '2020-01-28', 'dfsd', 'fsdf', ' fsdf', 1, 1);

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

--
-- Table structure for table `tbl_placement`
--

CREATE TABLE `tbl_placement` (
  `id` int(111) NOT NULL,
  `clg_session` varchar(111) NOT NULL,
  `department` varchar(111) NOT NULL,
  `name` varchar(111) NOT NULL,
  `rollno` varchar(111) NOT NULL,
  `image` varchar(111) NOT NULL,
  `logo` varchar(111) NOT NULL,
  `seo_title` varchar(111) NOT NULL,
  `seo_key` varchar(222) NOT NULL,
  `seo_des` varchar(222) NOT NULL,
  `created` varchar(22) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_placement`
--

INSERT INTO `tbl_placement` (`id`, `clg_session`, `department`, `name`, `rollno`, `image`, `logo`, `seo_title`, `seo_key`, `seo_des`, `created`) VALUES
(1, '2017-2018', 'biotechnology', 'test', '1123', '1579876659dummyg.jpg', '1579876645amazon.png', 'a', 'aaaaaaaaaaaaaaaa', ' aaaaaaaaaaaaaaaa', 'Jan-24-2020'),
(3, '2016-2017', 'civil-engineering', 'test', '12321', '1579876689dummyg.jpg', '1579876689bhilwara.png', 'dsaf', 'dasf', ' dasf', 'Jan-24-2020'),
(4, '2016-2017', 'biotechnology', 'aaaa', 'aaaaaaaaaaaaaaa', '1579879506dummy.jpg', '1579878392capagemini.png', 'sdafdsa', 'fdsa', ' fdsa', 'Jan-24-2020'),
(5, '2016-2017', 'biotechnology', 'tttttttttt', '123132', '1579878518dummy.jpg', '1579878518capagemini.png', 'dsfd', 'fd', ' fd', 'Jan-24-2020'),
(6, '2016-2017', 'information-technology', 'sdfds', '24324', '1579879568dummy.jpg', '1579879568acxiom.png', 'dsaf', 'dsaf', 'dasf', 'Jan-24-2020'),
(7, '2016-2017', 'electronics-and-communication', 'sdafdsa', 'dfsaf', '1579879626dummy.jpg', '1579879626lifecell.png', 'sdafdas', 'fdas', 'fdasf', 'Jan-24-2020'),
(8, '2018-2019', 'mba', 'dsaf', 'fadsf', '1579879679dummy.jpg', '1579879679delveinsight.png', 'dsaf', '', '', 'Jan-24-2020'),
(9, '2016-2017', 'computer-science-and-engineering', 'sdafsad', 'fdasf', '1579879844dummyg.jpg', '1579879844sixredmarbles.png', ' ', '', '', 'Jan-24-2020'),
(10, '2016-2017', 'electrical-and-electronics', 'asdfdsa', 'fdsa', '1579881113dummy.jpg', '1579881113lifecell.png', 'asdfdsa', '', '', 'Jan-24-2020'),
(11, '2018-2019', 'mechanical-engineering', 'sdafsda', 'fdsaf', '1579881358dummyg.jpg', '1579881358delveinsight.png', 'sdafsda', '', '', 'Jan-24-2020');

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

--
-- Table structure for table `tbl_query`
--

CREATE TABLE `tbl_query` (
  `id` int(11) NOT NULL,
  `name` varchar(222) NOT NULL,
  `email` varchar(222) NOT NULL,
  `phone` varchar(222) NOT NULL,
  `description` varchar(999) NOT NULL,
  `creation` varchar(222) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_query`
--

INSERT INTO `tbl_query` (`id`, `name`, `email`, `phone`, `description`, `creation`) VALUES
(1, 'shakher tyagi s', 'sha@gmail.com', '9540445874', '', '21-03-18'),
(2, 'shakher', 'email@gmail.com', '95458745', 'aaaaaaaaaa', '26/10/18'),
(3, '', '', '', '', '26/10/18'),
(4, 'shakher', 'sha@gmail.com', '987458745', 'test message', '20/11/19'),
(5, 'shakher', 'email@gmail.com', '234234', 'test', '20/11/19'),
(6, 'dsfsd', 'fdsaf', '34324', 'fdsafdfdsaf', '20/11/19'),
(7, 'dsfsd', 'fdsaf@gmail.com', '34324', 'fdsafdfdsaf', '20/11/19'),
(8, 'dsfsd', 'fdsaf@gmail.com', '34324', 'fdsafdfdsaf', '20/11/19'),
(9, 'sdsfasdf', 'sdfdsa@dafasd.sad', '32423423423', 'dafsdaf afdsaf', '20/11/19'),
(10, 'sadfda', 'sfadsf@dafa', '324324', 'dfdsafsd', '20/11/19'),
(11, 'sadfda', 'sfadsf@dafa', '324324', 'dfdsafsd', '20/11/19'),
(12, 'sdafdas', 'dsafdsa@dfads', '234324324', 'dsfdsafasd', '20/11/19'),
(13, 'sdafdas', 'dsafdsa@dfads', '234324324', 'dsfdsafasd', '20/11/19'),
(14, 'sdafdas', 'dsafdsa@dfads', '234324324', 'dsfdsafasd', '20/11/19'),
(15, 'sdafdas', 'dsafdsa@dfads', '234324324', 'dsfdsafasd', '20/11/19'),
(16, 'shhsdaf', 'sdafds@dfad', '23432423', 'sfdsa sdafdsa', '20/11/19');

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

--
-- Table structure for table `tbl_setting`
--

CREATE TABLE `tbl_setting` (
  `id` int(11) NOT NULL,
  `paypal_id` varchar(225) NOT NULL,
  `contact` blob NOT NULL,
  `contact_id` varchar(225) NOT NULL,
  `image` varchar(225) NOT NULL,
  `phone` varchar(225) NOT NULL,
  `location` varchar(555) NOT NULL,
  `whatsapp_no` varchar(225) NOT NULL,
  `slider` int(11) NOT NULL,
  `blog` int(11) NOT NULL,
  `youtube` varchar(222) NOT NULL,
  `recently` int(11) NOT NULL,
  `deal` int(11) NOT NULL,
  `facebook` varchar(111) NOT NULL,
  `twitter` varchar(111) NOT NULL,
  `linkedin` varchar(111) NOT NULL,
  `special` int(11) NOT NULL,
  `footer1` varchar(888) NOT NULL,
  `footer2` varchar(888) NOT NULL,
  `footer3` varchar(888) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_setting`
--

INSERT INTO `tbl_setting` (`id`, `paypal_id`, `contact`, `contact_id`, `image`, `phone`, `location`, `whatsapp_no`, `slider`, `blog`, `youtube`, `recently`, `deal`, `facebook`, `twitter`, `linkedin`, `special`, `footer1`, `footer2`, `footer3`) VALUES
(1, '', '', 'admissions@madeinindiaacademy.com', '1574255302admin.jpg', 'Mobile: (900) 802 6666', '298, Outer Ring Rd, Kathriguppe IV Phase, Banashankari 3rd Stage, Banashankari, Bengaluru, Karnataka 560085', '1234565', 1, 1, 'asdfdsa', 1, 1, 'a', 'df', 'df', 1, 'This DIGITAL MANAGEMENT ACADEMY is the largest aggregator of Digital Economy courses in India with five Centres of Learning and Eight Centres of Excellence in critical areas of Digital Technologies.', 'This digital management ACADEMY caters to a wide range of social and corporate needs of the Digital Economy. Therefore it operates at multiple levels from formal education to specialised corporate training and basic levels for beginners.', 'This Digital Management ACADEMY offers opportunities to integrate digital skills in various art forms. Applying digital skills in graphics, painting, design, music etc.');

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

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

CREATE TABLE `tbl_slider` (
  `id` int(11) NOT NULL,
  `image` varchar(111) NOT NULL,
  `url` varchar(111) NOT NULL,
  `about` varchar(555) NOT NULL,
  `status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `tbl_slider` (`id`, `image`, `url`, `about`, `status`) VALUES
(4, '1573744267slide3.jpg', 'dsafdsafds', '<h4 class=\"fadeInDown animated\">India\'s Largest Aggregator of Digital Economy Courses</h4>\r\n\r\n											<h2 class=\"fadeInLeft\">Welcome to The World of<br>Digital Economy</h2>', 1),
(5, '1573744249slide1.jpg', 'aaaaaa', '<h4 class=\"fadeInDown animated\">India\'s Largest Aggregator of Digital Economy Courses</h4>\r\n\r\n											<h2 class=\"fadeInLeft\">Welcome to The World of<br>Digital Economy</h2>', 1),
(6, '1573744282slide5.jpg', 'aaaaaa', '<h4 class=\"fadeInDown animated\">India\'s Largest Aggregator of Digital Economy Courses</h4>\r\n\r\n											<h2 class=\"fadeInLeft\">Welcome to The World of<br>Digital Economy</h2>', 1);

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

--
-- Table structure for table `tbl_subscriber`
--

CREATE TABLE `tbl_subscriber` (
  `id` int(1) NOT NULL,
  `email_id` varchar(222) NOT NULL,
  `status` int(11) NOT NULL,
  `created` varchar(50) NOT NULL,
  `name` varchar(222) NOT NULL,
  `phone` varchar(222) NOT NULL,
  `description` varchar(5555) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_subscriber`
--

INSERT INTO `tbl_subscriber` (`id`, `email_id`, `status`, `created`, `name`, `phone`, `description`) VALUES
(1, 'sha@gmail.com', 1, '', '', '', ''),
(2, 'sha@gmail.com', 1, '18/05/2018', 'shakher', '9540445874', 'test description'),
(3, 'sha@gmail.com', 0, '18/05/2018', 'shakher', '9540445874', 'aaaaaaaaa');

--
-- Indexes for table `tbl_achievement`
--
ALTER TABLE `tbl_achievement`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_achievement_gallery`
--
ALTER TABLE `tbl_achievement_gallery`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_announce`
--
ALTER TABLE `tbl_announce`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_category`
--
ALTER TABLE `tbl_category`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_cource`
--
ALTER TABLE `tbl_cource`
  ADD PRIMARY KEY (`id`);

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

--
-- Indexes for table `tbl_event`
--
ALTER TABLE `tbl_event`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_event_cat`
--
ALTER TABLE `tbl_event_cat`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_event_gallery`
--
ALTER TABLE `tbl_event_gallery`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_faculty1`
--
ALTER TABLE `tbl_faculty1`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_feedback`
--
ALTER TABLE `tbl_feedback`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_news`
--
ALTER TABLE `tbl_news`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_placement`
--
ALTER TABLE `tbl_placement`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_query`
--
ALTER TABLE `tbl_query`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tbl_setting`
--
ALTER TABLE `tbl_setting`
  ADD PRIMARY KEY (`id`);

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

--
-- Indexes for table `tbl_subscriber`
--
ALTER TABLE `tbl_subscriber`
  ADD PRIMARY KEY (`id`);

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

--
-- AUTO_INCREMENT for table `tbl_achievement_gallery`
--
ALTER TABLE `tbl_achievement_gallery`
  MODIFY `id` int(111) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

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

--
-- AUTO_INCREMENT for table `tbl_category`
--
ALTER TABLE `tbl_category`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;

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

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

--
-- AUTO_INCREMENT for table `tbl_event`
--
ALTER TABLE `tbl_event`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

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

--
-- AUTO_INCREMENT for table `tbl_event_gallery`
--
ALTER TABLE `tbl_event_gallery`
  MODIFY `id` int(111) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

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

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

--
-- AUTO_INCREMENT for table `tbl_news`
--
ALTER TABLE `tbl_news`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `tbl_placement`
--
ALTER TABLE `tbl_placement`
  MODIFY `id` int(111) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `tbl_query`
--
ALTER TABLE `tbl_query`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

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

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

--
-- AUTO_INCREMENT for table `tbl_subscriber`
--
ALTER TABLE `tbl_subscriber`
  MODIFY `id` int(1) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
COMMIT;

