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

START TRANSACTION;



--
-- Database: `imsec`
--

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

--
-- Table structure for table `admin_login`
--

CREATE TABLE `admin_login` (
  `id` int(11) NOT NULL,
  `username` varchar(250) NOT NULL,
  `password` varchar(250) NOT NULL,
  `email` varchar(111) NOT NULL,
  `status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `admin_login`
--

INSERT INTO `admin_login` (`id`, `username`, `password`, `email`, `status`) VALUES
(1, 'admin', '123', 'sha@gmnail.com', 1);

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

--
-- 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)', 0x3c703e0d0a093c7370616e207374796c653d22636f6c6f723a20726762283132322c203132322c20313232293b20666f6e742d66616d696c793a20526f626f746f2c2073616e732d73657269663b20666f6e742d73697a653a20313470783b223e546865204d616e6167656d656e742041636164656d7920666f72204469676974616c2045636f6e6f6d7920696e20496e64696120284d41444520696e20494e4449412920686173206265656e20636f6e63656976656420616761696e737420746865206261636b67726f756e64206f6620726973696e6720676c6f62616c204469676974616c2045636f6e6f6d7920616e6420496e64696126727371756f3b7320656e646561766f757220746f206c65617066726f672074686520646576656c6f706d656e74616c2070726f636573732e2049742069732061204e65772047656e65726174696f6e207468696e6b696e6720696e737469747574696f6e202d20616e20696e6e6f766174696f6e2d6d65646961746564206b6e6f776c6564676520656e7465727072697365202d2064656469636174656420746f20707265706172652068756d616e20617373657473202d206469676974616c6c792064726976656e20656e7472657072656e6575727320616e64204469676974616c204c656164657273202d20666f72207468652070726f6d6f74696f6e206f66206469676974616c2065636f6e6f6d792e20496e206f7264657220746f2070726f76696465207065727370656374697665207468652041636164656d7920636f6e736973747320666f72206669766520696e74656772617465642043656e74726573206f66204c6561726e693c2f7370616e3e3c7370616e207374796c653d22636f6c6f723a20726762283132322c203132322c20313232293b20666f6e742d66616d696c793a20526f626f746f2c2073616e732d73657269663b20666f6e742d73697a653a20313470783b223e546865204d616e6167656d656e742041636164656d7920666f72204469676974616c2045636f6e6f6d7920696e20496e64696120284d41444520696e20494e4449412920686173206265656e20636f6e63656976656420616761696e737420746865206261636b67726f756e64206f6620726973696e6720676c6f62616c204469676974616c2045636f6e6f6d7920616e6420496e64696126727371756f3b7320656e646561766f757220746f206c65617066726f672074686520646576656c6f706d656e74616c2070726f636573732e2049742069732061204e65772047656e65726174696f6e207468696e6b696e6720696e737469747574696f6e202d20616e20696e6e6f766174696f6e2d6d65646961746564206b6e6f776c6564676520656e7465727072697365202d2064656469636174656420746f20707265706172652068756d616e20617373657473202d206469676974616c6c792064726976656e20656e7472657072656e6575727320616e64204469676974616c204c656164657273202d20666f72207468652070726f6d6f74696f6e206f66206469676974616c2065636f6e6f6d792e20496e206f7264657220746f2070726f76696465207065727370656374697665207468652041636164656d7920636f6e736973747320666f72206669766520696e74656772617465642043656e74726573206f66204c6561726e693c2f7370616e3e3c7370616e207374796c653d22636f6c6f723a20726762283132322c203132322c20313232293b20666f6e742d66616d696c793a20526f626f746f2c2073616e732d73657269663b20666f6e742d73697a653a20313470783b223e546865204d616e6167656d656e742041636164656d7920666f72204469676974616c2045636f6e6f6d7920696e20496e64696120284d41444520696e20494e4449412920686173206265656e20636f6e63656976656420616761696e737420746865206261636b67726f756e64206f6620726973696e6720676c6f62616c204469676974616c2045636f6e6f6d7920616e6420496e64696126727371756f3b7320656e646561766f757220746f206c65617066726f672074686520646576656c6f706d656e74616c2070726f636573732e2049742069732061204e65772047656e65726174696f6e207468696e6b696e6720696e737469747574696f6e202d20616e20696e6e6f766174696f6e2d6d65646961746564206b6e6f776c6564676520656e7465727072697365202d2064656469636174656420746f20707265706172652068756d616e20617373657473202d206469676974616c6c792064726976656e20656e7472657072656e6575727320616e64204469676974616c204c656164657273202d20666f72207468652070726f6d6f74696f6e206f66206469676974616c2065636f6e6f6d792e20496e206f7264657220746f2070726f76696465207065727370656374697665207468652041636164656d7920636f6e736973747320666f72206669766520696e74656772617465642043656e74726573206f66204c6561726e693c2f7370616e3e3c2f703e0d0a, '1573748470computing-lab.jpg', '', '', '', 0, 1),
(2, 'pgdm', 'pgdm', 'Post Graduate Diploma in Digital Business Management (PGDBM)', 0x[encoded data, 11350 characters], '1574081557course3.jpg', '', '', '', 0, 1),
(3, 'Postgraduate Programmes', 'postgraduate-programmes', 'Postgraduate Diploma In International Management In Digital Economy (PGDIM-DE)', 0x[encoded data, 11350 characters], '1574081745course5.jpg', '', '', '', 0, 1),
(4, 'Post Graduate Diploma', 'post-graduate-diploma', 'Post Graduate Diploma in Digital Business Management (PGDBM)', 0x[encoded data, 11350 characters], '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', 0x3c703e556e64657220746865206b696e6420706174726f6e61676520447220416a6179206b204a61696e2c204469726563746f7220494d53204768617a69616261642c205047444d2053747564656e74732062726f75676874206c617572656c20746f2074686520496e7374697475746520616e64206672617465726e6974792062792077696e6e696e6720746865205365636f6e64207072697a6520696e2070726573656e746174696f6e20636f6d7065746974696f6e206f7267616e697a65642062792043494920496e69746961746564202671756f743b536b696c6c266e646173683b57696c6c202d204c6561642671756f743b2070726f6772616d6d6520617420494d53204768617a6961626164206f6e204f63746f62657220342c20323031382e3c2f703e0d0a0d0a3c703e41205465616d206f66204d732e205269636861204167617277616c20616e64204d732e204e696b6974612066726f6d205047444d20323031382d32302042617463682920776f6e207468697320706f736974696f6e2062792070726573656e74696e672074686569722074686f7567687473206f6e20266c6471756f3b4469676974616c204d61726b6574696e6726726471756f3b2e2054686569722070726573656e746174696f6e2026616d703b2064697363757373696f6e207761732074686f726f7567686c7920656e6a6f796564206279207468652073747564656e747320616e642074686520656d696e656e74206a757279206d656d626572732e2054686520466163756c747920436f6f7264696e61746f72206f6620746865206576656e74207765726520447220537572616268692053696e676820616e6420447220476f70616c204b726973686e6120447769766564692e3c2f703e0d0a, '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', 0x3c703e4c6f72656d20697073756d20646f6c6f722073697420616d65742c20636f6e7365637465747572206164697069736963696e6720656c69742e20417373756d656e6461206573742071756165206576656e696574206120706572666572656e6469732061646970697363692c2074656d706f7261206d6f6c65737469617320616c69617320656f73206e616d207175616d2c2064656c656e69746920696c6c756d207365642c206d6f646920697374653f204576656e696574206d61696f726573206e656d6f2c20656f732e204c6f72656d20697073756d20646f6c6f722073697420616d65744c6f72656d20697073756d20646f6c6f722073697420616d65742c20636f6e7365637465747572206164697069736963696e6720656c69742e20417373756d656e646120657374266e6273703b4c6f72656d20697073756d20646f6c6f722073697420616d65742c20636f6e7365637465747572206164697069736963696e6720656c69742e20417373756d656e6461206573742071756165206576656e696574206120706572666572656e6469732061646970697363692c2074656d706f7261206d6f6c65737469617320616c69617320656f73206e616d207175616d2c2064656c656e69746920696c6c756d207365642c206d6f646920697374653f204576656e696574206d61696f726573206e656d6f2c20656f732e204c6f72656d20697073756d20646f6c6f722073697420616d65744c6f72656d20697073756d20646f6c6f722073697420616d65742c20636f6e7365637465747572206164697069736963696e6720656c69742e20417373756d656e6461206573742071753c2f703e0d0a, '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', 0x3c703e4c6f72656d20697073756d20646f6c6f722073697420616d65742c20636f6e7365637465747572206164697069736963696e6720656c69742e20417373756d656e6461206573742071756165206576656e696574206120706572666572656e6469732061646970697363692c2074656d706f7261206d6f6c65737469617320616c69617320656f73206e616d207175616d2c2064656c656e69746920696c6c756d207365642c206d6f646920697374653f204576656e696574206d61696f726573206e656d6f2c20656f732e204c6f72656d20697073756d20646f6c6f722073697420616d65744c6f72656d20697073756d20646f6c6f722073697420616d65742c20636f6e7365637465747572206164697069736963696e6720656c69742e20417373756d656e6461206573742071756165206576656e696574206120706572666572656e6469732061646970697363692c2074656d706f7261206d6f6c65737469617320616c69617320656f73206e616d207175616d2c2064656c656e69746920696c6c756d207365642c206d6f646920697374653f204576656e696574206d61696f726573206e656d6f2c20656f732e204c6f72656d20697073756d20646f6c6f722073697420616d65744c6f72656d20697073756d20646f6c6f722073697420616d65742c20636f6e7365637465747572206164697069736963696e6720656c69742e20417373756d656e6461206573742071756165206576656e696574206120706572666572656e6469732061646970697363692c2074656d706f7261206d6f6c65737469617320616c69617320656f73206e616d207175616d2c2064656c656e69746920696c6c756d207365642c206d6f646920697374653f204576656e696574206d61696f726573206e656d6f2c20656f732e204c6f72656d20697073756d20646f6c6f722073697420616d65744c6f72656d20697073756d20646f6c6f722073697420616d65742c20636f6e7365637465747572206164697069736963696e6720656c69742e20417373756d656e6461206573742071756165206576656e696574206120706572666572656e6469732061646970697363692c2074656d706f7261206d6f6c65737469617320616c69617320656f73206e616d207175616d2c2064656c656e69746920696c6c756d207365642c206d6f646920697374653f204576656e696574206d61696f726573206e656d6f2c20656f732e204c6f72656d20697073756d20646f6c6f722073697420616d65743c2f703e0d0a, '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', 0x3c703e4c6f72656d20697073756d20646f6c6f722073697420616d65742c20636f6e7365637465747572206164697069736963696e6720656c69742e20417373756d656e6461206573742071756165206576656e696574206120706572666572656e6469732061646970697363692c2074656d706f7261206d6f6c65737469617320616c69617320656f73206e616d207175616d2c2064656c656e69746920696c6c756d207365642c206d6f646920697374653f204576656e696574206d61696f726573206e656d6f2c20656f732e204c6f72656d20697073756d20646f6c6f722073697420616d65742e4c6f72656d20697073756d20646f6c6f722073697420616d65742c20636f6e7365637465747572206164697069736963696e6720656c69742e20417373756d656e6461206573742071756165206576656e696574206120706572666572656e6469732061646970697363692c2074656d706f7261206d6f6c65737469617320616c69617320656f73206e616d207175616d2c2064656c656e69746920696c6c756d207365642c206d6f646920697374653f204576656e696574206d61696f726573206e656d6f2c20656f732e204c6f72656d20697073756d20646f6c6f722073697420616d65742e4c6f72656d20697073756d20646f6c6f722073697420616d65742c20636f6e7365637465747572206164697069736963696e6720656c69742e20417373756d656e6461206573742071756165206576656e696574206120706572666572656e6469732061646970697363692c2074656d706f7261206d6f6c65737469617320616c69617320656f73206e616d207175616d2c2064656c656e69746920696c6c756d207365642c206d6f646920697374653f204576656e696574206d61696f726573206e656d6f2c20656f732e204c6f72656d20697073756d20646f6c6f722073697420616d65742e3c2f703e0d0a, '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_faculty`
--

CREATE TABLE `tbl_faculty` (
  `id` int(11) NOT NULL,
  `cat_id` int(11) NOT NULL,
  `subcat_id` int(11) NOT NULL,
  `sno` int(11) NOT NULL,
  `faculty_password` varchar(111) NOT NULL,
  `faculty_email` varchar(111) NOT NULL,
  `slug` varchar(250) NOT NULL,
  `designation` varchar(999) NOT NULL,
  `department` varchar(111) NOT NULL,
  `faculty_name` varchar(999) NOT NULL,
  `area` varchar(222) NOT NULL,
  `contact` text NOT NULL,
  `web` text NOT NULL,
  `br_profile` text NOT NULL,
  `educational` text NOT NULL,
  `experience` blob NOT NULL,
  `total_exp` varchar(111) NOT NULL,
  `consult` text NOT NULL,
  `awards` blob NOT NULL,
  `interest` blob NOT NULL,
  `art_contribute` text NOT NULL,
  `book_auther` blob NOT NULL,
  `book_edited` blob NOT NULL,
  `res_pub_n_j` blob NOT NULL,
  `res_pub_in_j` blob NOT NULL,
  `pap_pre_in_con` blob NOT NULL,
  `pap_pre_nat_con` blob NOT NULL,
  `mdp_org` blob NOT NULL,
  `fdp_org` blob NOT NULL,
  `semi_n` blob NOT NULL,
  `semi_in` blob NOT NULL,
  `work_at` varchar(12000) NOT NULL,
  `work_con` blob NOT NULL,
  `fdp_at` blob NOT NULL,
  `mdp_at` varchar(18000) NOT NULL,
  `semi_con_n` blob NOT NULL,
  `semi_con_in` blob NOT NULL,
  `res_pr_und` text NOT NULL,
  `status` int(11) NOT NULL,
  `image` blob NOT NULL,
  `seo_title` varchar(250) NOT NULL,
  `seo_key` varchar(225) NOT NULL,
  `seo_des` varchar(225) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=REDUNDANT;

--
-- Dumping data for table `tbl_faculty`
--

INSERT INTO `tbl_faculty` (`id`, `cat_id`, `subcat_id`, `sno`, `faculty_password`, `faculty_email`, `slug`, `designation`, `department`, `faculty_name`, `area`, `contact`, `web`, `br_profile`, `educational`, `experience`, `total_exp`, `consult`, `awards`, `interest`, `art_contribute`, `book_auther`, `book_edited`, `res_pub_n_j`, `res_pub_in_j`, `pap_pre_in_con`, `pap_pre_nat_con`, `mdp_org`, `fdp_org`, `semi_n`, `semi_in`, `work_at`, `work_con`, `fdp_at`, `mdp_at`, `semi_con_n`, `semi_con_in`, `res_pr_und`, `status`, `image`, `seo_title`, `seo_key`, `seo_des`) VALUES
(39, 1, 14, 3, '123', 'geeti.sharma@imsgzb.com', '-geeti-sharma', '', 'electrical-and-electronics', ' Geeti Sharma', '', '', '', '', '<p>Ph.D(Pur),M.A.(Eco),PGDM,PGDIT,BBA</p>\r\n', 0x3c703e4569676874207965617273206f6620657870657269656e636520696e207465616368696e6720616e642061646d696e697374726174696f6e2e3c2f703e0d0a, '10 year', '', 0x3c703e3c7374726f6e673e312e266e6273703b3c2f7374726f6e673e4d65726974205363686f6c617273686970206177617264656420696e205047444d2028323030322d303429496d616e746563204768617a69616261643c2f703e0d0a0d0a3c703e3c7374726f6e673e322e266e6273703b3c2f7374726f6e673e4c6966652074696d65206d656d62657220555055454128557474617220507261646573682d55747472616b68616e642045636f6e6f6d6963204173736f63696174696f6e293c2f703e0d0a, 0x3c703e4d616e6167657269616c2045636f6e6f6d6963732c20496e6469616e2045636f6e6f6d7920616e64204167726963756c747572616c2045636f6e6f6d6963732e3c2f703e0d0a, '', 0x3c703e3c7374726f6e673e312e266e6273703b3c2f7374726f6e673e48616e6420426f6f6b206f6e20496e6469616e2045636f6e6f6d792062792056617264616e205075626c69636174696f6e7320323031323c2f703e0d0a0d0a3c703e3c7374726f6e673e322e3c2f7374726f6e673e48616e6420426f6f6b206f6e2047656e6572616c2045636f6e6f6d6963732062792056617264616e205075626c69636174696f6e7320323031313c2f703e0d0a0d0a3c703e3c7374726f6e673e332e266e6273703b3c2f7374726f6e673e48616e6420426f6f6b206f6e204d6f6e657920616e642046696e616e6369616c2053797374656d2062792056617264616e205075626c69636174696f6e732e3c2f703e0d0a0d0a3c703e3c7374726f6e673e342e266e6273703b3c2f7374726f6e673e48616e6420426f6f6b206f6e20496e7465726e6174696f6e616c2054726164652062792056617264616e205075626c69636174696f6e7320323031303c2f703e0d0a, '', '', '', 0x3c703e0d0a093c7374726f6e673e312ec2a03c2f7374726f6e673e50726573656e7465642061207061706572207469746c65642022436f6d6d65726369616c204d6963726f2066696e616e6365206173206120737472617465677920746f776172647320506f766572747920416c6c6576696174696f6e2d2054686520496e6469616e20457870657269656e63652e22206f6e20352636204a616e203230313320696e20496e7465726e6174696f6e616c20436f6e666572656e6365206f7267616e697a65642062792053434d532c204e6f696461206174204949432c44656c68692e3c2f703e0d0a, 0x3c703e0d0a093c7374726f6e673e312ec2a03c2f7374726f6e673e4c656164657273686970204368616c6c656e67657320696e205472616e73666f726d6174696f6e3a204120476c6f62616c2050657273706563746976652c20466562203230313120696e204e6174696f6e616c20436f6e666572656e6365206f6e20537472617465676963205472616e73666f726d6174696f6e20696e20476c6f62616c697365642045726120617420544954732042686977616e693c2f703e0d0a3c703e0d0a093c7374726f6e673e322ec2a03c2f7374726f6e673e476c6f62616c697a6174696f6e20616e6420506f766572747920416c6c6576696174696f6e20696e20496e6469613a20616e204173736573736d656e742c204a616e203230313020696e205547432053706f6e736f726564204e6174696f6e616c2053656d696e6172206f6e20696d70616374206f6620476c6f62616c697a6174696f6e206f6e20496e636f6d6520446973747269627574696f6e20696e20496e64696120617420442e4e2e20436f6c6c656765204d65657275742e3c2f703e0d0a3c703e0d0a093c7374726f6e673e332ec2a03c2f7374726f6e673e50726573656e7465642061207061706572207469746c65642022496e6e6f766174696f6e7320696e20527572616c204372656469742044656c697665727920696e20496e6469613a2054686520526f616420416865616422206f6e203138204175672c3230313220696e204e6174696f6e616c20436f6e666572656e6365206f7267616e697a6564206279204b494554204768617a69616261642e3c2f703e0d0a, '', '', 0x3c703e0d0a093c7374726f6e673e312ec2a03c2f7374726f6e673e53656d696e6172206f6e20466f726569676e2044697265637420496e766573746d656e74204f7267616e697a656420627920494d52206174204949432044656c68693c2f703e0d0a3c703e0d0a093c7374726f6e673e322ec2a03c2f7374726f6e673e485220436f6e636c61766520546865204368616e67696e672066616365206f66204c656164657273686970c29d20617420494d522043616d7075732041756469746f7269756d2d20436f6e76656e657220666f72207468652050726f6772616d3c2f703e0d0a, '', '', '', 0x3c703e0d0a093c7374726f6e673e312ec2a03c2f7374726f6e673e446576656c6f70696e6720466163696c69746174696f6e20536b696c6c7320666f72205465616368696e6720616e6420547261696e696e6720446563203230313020536978206461792050726f6772616d204f7267616e697a656420627920494d532053706f6e736f7265642062792041494354452e3c2f703e0d0a3c703e0d0a093c7374726f6e673e322ec2a03c2f7374726f6e673e496d706f7274616e6365206f66204d6f7469766174696f6e20696e205465616368696e672062792050726f662e20526168756c20426861746e616761722c20466562203230303720494d522043616d7075733c2f703e0d0a, '', '', 0x202020202020202020, '         ', 0, 0x313537393632303134356e6568612e6a7067, 'Geeti Sharma', 'Geeti Sharma', 'Geeti Sharma'),
(40, 1, 10, 3, '12345', 'khushboo.sherwani@imsgzb.com', 'khushboo-sherwani', '', 'mechanical-engineering', 'Khushboo Sherwani', '', '333333333333', '', '<p>Khushboo Sherwani holds a niche yet versatile career graph in which she has a blend of corporate and academics . She has been associated with Wipro, Zee, NDTV, Shri Ram Management College, Amity University to name a few. She has her expertise in Corporate Training, Personality Enrichment, Personnel Branding and Human Psychological Mapping.Her academic assignments are in the areas of Managerial Communication and Human Resource Management.Her keen interest lies in exploring the domain of Talent Acquisition,Leadership Communication focusing on the inter- disciplinary approaches for enriching management and organizational behavior. Presently she is an active columnist with the Canadian Asian Times , Canada.She has recently completed her Joint Research project on &quot;Inclusive and Sustainable Business Model:Opportunities for Asian Sub Continent&quot; with Massachusetts Institute of Technology,USA .</p>\r\n', '<p>B.A English(Hons),M.A(Mass Communication) MCRC Jamia Millia Islamia , MBA Chandigarh Business School,Chandigarh.</p>\r\n', 0x3c703e35207972733c2f703e0d0a, '5 Years', '', 0x3c703e476f6c64204d6564616c69737420496e20456e676c697368204c697465726174757265202e426174636820546f7070657220696e204d42412e20417761726465642077697468202671756f743b546865204265737420436f6d6d756e69636174696f6e20547261696e65722671756f743b2061742052656c69616e63652e3c2f703e0d0a, 0x3c703e547261696e696e6720616e6420446576656c6f706d656e742c20506572736f6e616c69747920456e726963686d656e74202c4c65616465727368697020436f6d6d756e69636174696f6e202c20526f6c65206f6620696d706c6963697420616e64206578706c6963697420617474697475646520646f6d696e6174696e672050737963686f6c6f6779202c4f7267616e697a6174696f6e616c204265686176696f7220616e642047726f75702044796e616d6963732e54686561746572204163746976697374733a20746865697220726f6c6520616e6420636f6e747269627574696f6e20696e20636f6e74656d706f7261727920496e6469612e446f63756d656e746172792046696c6d204d616b696e672e3c2f703e0d0a, '6', '', '', '', '', 0x31, 0x32, '', '', '', '', '', '', '', '', '', 0x20202020202020202020, '          ', 1, 0x31353739363230303833696e64752e6a7067, 'Khushboo Sherwani', 'Khushboo Sherwani', 'Khushboo Sherwani'),
(41, 1, 5, 4, '12345', 'shalini.sharma@imsgzb.com', 'shalini-sharma', '', 'information-technology', 'Shalini Sharma', '', '4444444', '', '<p>A seasoned professional with over 6 years of varied experience in the fields of Marketing, Communication, Media Production, Training and Development. An effective communicator with strong analytical, interpersonal &amp; organizational abilities. Her strength includes effectively using industry exposure to train students for campus interviews and to prepare them for their corporate journey. Apart from bringing a nuanced understanding of topics, she does her work with a lot of passion and firmly believes that learning never ends. Her academic achievements include B.com, M.com from Delhi University. She also holds a master degree in Mass communication and a post graduate diploma in marketing. She is currently pursuing Ph.d from Banasthli Vidyapeeth, Rajasthan.</p>\r\n', '<p>Currently pursuing Ph.d from Banasthali Vidyapeeth .Graduation and Post-graduation in commerce form Delhi University, PG Diploma in Marketing Management from Times School of Marketing, PG Diploma in Mass Communication Bhartiya Vidya Bhavan, and Master in Mass Communication from Hissar University.</p>\r\n', 0x3c703e4f766572203620797273206f6620657870657269656e636520696e206164766572746973696e6720616e64206d656469612e204861766520776f726b6564207769746820766172696f7573206272616e6473206c696b65205361686172612c204a6179706565202c2054696d6573206f6620496e646961206574632e204861766520612068616e6473206f6e206578706f7375726520696e20746865206669656c64206f6620636c69656e7420646576656c6f706d656e742c204964656174696e6720616e6420646576656c6f70696e67206372656174697665206d61726b6574696e6720636f6d6d756e69636174696f6e2c2073747261746567697a696e67206120636f6d6d756e69636174696f6e20706c616e2c20706c616e6e696e67206f7267616e697a696e6720616e642070726f647563696e6720766172696f75732070726f6772616d7320616d6f6e677374206f74686572732e204173206120467265656c616e636520747261696e65722073686520686173206265656e20496d70617274696e67206b6e6f776c65646765206173207065722061636164656d696320637572726963756c756d3b207265636f676e697a696e672c2072657370656374696e6720616e64206e7572747572696e672074686520637265617469766520706f74656e7469616c206f6620656163682073747564656e743b20636f6e6365707475616c697a696e672026616d703b20646576656c6f70696e6720747261696e696e672026616d703b20646576656c6f706d656e7420696e69746961746976657320666f7220696d70726f7665642070726f6475637469766974792c206361706162696c697479206275696c64696e6720616e64207175616c69747920656e68616e63656d656e742e2044656c69766572696e6720747261696e696e672073657373696f6e7320666f7220626f746820696e2d686f75736520616e64206f7574736f7572636564207265736f75726365732061732077656c6c20617320666f72206e65772f6578697374696e67207265736f75726365732c2061732070657220726571756972656d656e743b207465616368696e672073747564656e74732026616d703b2074616b696e672070726163746963616c2073657373696f6e732c206d616b696e67207468656d20756e6465727374616e642074686520636f6e63657074732026616d703b206261736963732061742067726f756e64206c6576656c20616e6420707265706172696e672073747564656e747320666f722063616d70757320696e74657276696577732e3c2f703e0d0a, '6 Years', '', '', 0x3c703e506572736f6e616c69747920646576656c6f706d656e742c204c69666520736b696c6c732c20536f667420736b696c6c732c204d61737320436f6d6d756e69636174696f6e20616e64204d61726b6574696e673c2f703e0d0a, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0x2020202020202020202020, '           ', 1, 0x313537393631393734306d6567686e612e6a7067, 'Shalini Sharma', 'Shalini Sharma', 'Shalini Sharma'),
(42, 1, 32, 5, 'suhasiniom', 'suhasini@imsgzb.com', 'suhasini-sharma', '', 'mba', 'Suhasini Sharma', '', '9999999999', '', '<p>Suhasini Sharma did her Graduation from Hansraj College, Delhi University, PG Degree and Diploma in Foreign Language (German) and Corporate Communication from Amity University, Noida. Her areas of interest include Business Communication, PPSP, Behavioural aspects. She has attended workshops based on Corporate Communication, International Conference IRCTMD-2015, Corporate Governance ICCG-2017.</p>\r\n', '<p>mba</p>\r\n', '', '12 year', '', '', 0x3c703e436f6d6d756e69636174696f6e2c5050535020616e64204265686176696f7572616c20617370656374732c2053706972697475616c6974792e3c2f703e0d0a, '', '', '', '', '', '', '', '', '', '', '', 'workshops based on corporate commmunication,International conference IRCTMD-2015,Corporate governance ICCG-2017.', 0x436f6e64756374656420766172696f757320776f726b73686f7073206261736564206f6e20636f72706f7261746520636f6d6d756e69636174696f6e20616e64206265686176696f7572616c20736369656e6365732e, '', '', '', 0x20202020202020202020202020202020, '                ', 1, 0x3135373936313934393873686f6d696e692e6a7067, 'Suhasini Sharma', 'Suhasini Sharma', 'Suhasini Sharma'),
(48, 1, 17, 1, '123', 'avadhesh@gmail.com', 'dr-avadhesh-kumar-gupta', '', 'computer-science-and-engineering', 'Dr. Avadhesh Kumar Gupta', '', ' 971XXXXXXX', '', '<p>&nbsp; management projects. He has also delivered various invited lectures on IT, Big Data Management and Software Engineering.He has also organized attended various FDP&nbsp;&nbsp;</p>\r\n', '<p>M.C.A.,M.Tech(IT), Diploma in Business Management(IMT) , Ph.D.</p>\r\n', 0x3c703e31342b2059656172733c2f703e0d0a, '15 Years', '<p>management projects. He has also delivered various invited lectures on IT, Big Data Management and Software Engineering.He has also organized attended various FDP&nbsp;</p>\r\n', 0x3c703e6d616e6167656d656e742070726f6a656374732e2048652068617320616c736f2064656c69766572656420766172696f757320696e7669746564206c65637475726573206f6e2049542c204269672044617461204d616e6167656d656e7420616e6420536f66747761726520456e67696e656572696e672e48652068617320616c736f206f7267616e697a656420617474656e64656420766172696f757320464450266e6273703b3c2f703e0d0a, 0x3c703e426967204461746120436f6d707574696e67202c20446174612057617265686f7573696e6720616e642044617461204d696e696e67202c20427573696e65737320496e74656c6c6967656e63652c2044424d53202c2048756d616e2056616c75657320616e642070726f66657373696f6e616c204574686963733c2f703e0d0a, '', 0x3c703e6d616e6167656d656e742070726f6a656374732e2048652068617320616c736f2064656c69766572656420766172696f757320696e7669746564206c65637475726573206f6e2049542c204269672044617461204d616e6167656d656e7420616e6420536f66747761726520456e67696e656572696e672e48652068617320616c736f206f7267616e697a656420617474656e64656420766172696f757320464450266e6273703b3c2f703e0d0a, '', 0x3c703e0d0a093c7374726f6e673e312e3c2f7374726f6e673e3c7370616e20636c6173733d224170706c652d7461622d7370616e22207374796c653d2277686974652d73706163653a707265223e203c2f7370616e3e4f6e65207061706572207075626c697368656420696e2074686520e2809c4a6f75726e616c206f66204950454de2809d207469746c656420e2809c20416e20456d7069726963616c204672616d65776f726b206f6620427573696e65737320496e74656c6c6967656e636520616e6420646174612077617265686f7573696e67e2809d20696e204a756c792d323030392d446563656d62657220323030392045646974696f6e3c2f703e0d0a3c703e0d0a093c7374726f6e673e322e3c2f7374726f6e673e3c7370616e20636c6173733d224170706c652d7461622d7370616e22207374796c653d2277686974652d73706163653a707265223e203c2f7370616e3e4f6e65207061706572207075626c697368656420696e20746865204a6f75726e616c20e2809c537275737469204d616e6167656d656e7420526576696577e2809d207075626c69736865642066726f6d205372757374692041636164656d79206f66204d616e6167656d656e74202c2042687577616e6573687761724f72697373617469746c6564e2809c4d6561737572696e67206566666563746976656e657373206f662049542073757276657973207468726f75676820737461746973746963616c2073616d706c696e6720736368656d65e2809d20696e204a616e2d4a756e6520323031302065646974696f6e3c2f703e0d0a3c703e0d0a093c7374726f6e673e332e3c2f7374726f6e673e3c7370616e20636c6173733d224170706c652d7461622d7370616e22207374796c653d2277686974652d73706163653a707265223e203c2f7370616e3e4f6e65205061706572207075626c697368656420696e2045646974656420426f6f6b20e2809c496e6e6f766174696f6e20616e642043726561746976697479204d616e6167656d656e742d5468652064657369676e20666f7220667574757265e2809d207075626c697368656420627920426861727469205075626c69636174696f6e73202c204e65772044656c6869207469746c656420e2809c43757272656e7420537461747573206f6620496e666f726d6174696f6e20616e6420436f6d6d756e69636174696f6e20546563686e6f6c6f677920696e20446576656c6f70696e67204469676974616c20496e64696129e2809d205965617220323031353c2f703e0d0a, 0x[encoded data, 6920 characters], 0x[encoded data, 6410 characters], 0x3c703e0d0a093c7374726f6e673e312e3c2f7374726f6e673e204176616468657368204b756d61722047757074612c20e2809c5374756479206f6620436c6f756420436f6d707574696e6720546563686e6f6c6f677920696e207265666572656e636520746f20452d476f7665726e616e636520496d706c656d656e746174696f6ee2809d2c204e6174696f6e616c20436f6e666572656e6365206f6e20456d657267696e67205472656e647320696e20496e666f726d6174696f6e20546563686e6f6c6f677920617420494d53204768617a696162616420e280934e6f762e203234202c20323031323c2f703e0d0a3c703e0d0a093c7374726f6e673e322e3c2f7374726f6e673e204176616468657368204b756d617220477570746120e2809c506172616c6c656c697a6174696f6e20546563686e697175657320666f722044617461204d696e696e6720616c676f726974686d20696e20736861726564206d656d6f727920456e7669726f6e6d656e74e2809d2c204e6174696f6e616c20436f6e666572656e6365206f6e20456d657267696e67205472656e647320696e20496e666f726d6174696f6e20546563686e6f6c6f677920617420494d53204768617a696162616420e280934e6f762e203234202c20323031322e3c2f703e0d0a, '', 0x3c703e0d0a093c7374726f6e673e312e3c2f7374726f6e673e20436f6e76656e6572206f6620464450206f6e20e28098426967204461746120436f6d707574696e6720e2809820696e20636f6c6c61626f726174696f6e20776974682049424d205265736561726368204c6162202c496e646961202832303134293c2f703e0d0a3c703e0d0a093c7374726f6e673e322e3c2f7374726f6e673e20436869656620436f6e76656e657220e28093204644502028352d4461797329206f6e20426967204461746120436f6d707574696e6720616e6420416e616c797469637320696e20636f6c6c61626f726174696f6e20776974682044722e2041504a20416264756c204b616c616d20546563686e6963616c20556e697665727369747920e280934c75636b6e6f77202832377468204a616e756172792d33317374204a616e756172792c2032303136293c2f703e0d0a3c703e0d0a093c7374726f6e673e332e3c2f7374726f6e673e20417474656e646564206120466163756c747920446576656c6f706d656e742070726f6772616d20617420494d532d4748415a49414241442028444543454d424552202d32303130293c2f703e0d0a3c703e0d0a093c7374726f6e673e342e3c2f7374726f6e673e20417474656e646564204f6e652046445020617420416d69747920556e6976657273697479204e6f6964613c2f703e0d0a, 0x3c703e0d0a093c7374726f6e673e312e3c2f7374726f6e673e205061727469636970617465642064796e616d6963616c6c79206173206f7267616e697a6572206f662061204e6174696f6e616c2073656d696e6172206f6e20e2809c204c6174657374205472656e6473206f6620496e666f726d6174696f6e20546563686e6f6c6f67792d2061206e657720457261e2809d206174204954532d204768617a69616261642028417072696c20e280932032303036293c2f703e0d0a3c703e0d0a093c7374726f6e673e322e3c2f7374726f6e673e20416e63686f72656420616e6420686f73746564207365766572616c20776f726b73686f70732c2073656d696e61727320616e6420696e7465722d696e737469747574696f6e616c206576656e74732061742070726576696f757320776f726b656420696e737469747574696f6e732e3c2f703e0d0a3c703e0d0a093c7374726f6e673e332e3c2f7374726f6e673e20417474656e646564206120776f726b73686f70206f6e20e2809c4d6f6465726e20746f6f6c7320696e206170706c6965642053746174697374696373e2809d20696e204a616d6d7520556e69766572736974792e20e280a2c2a0c2a0c2a0c2a0c2a0c2a0c2a0c2a0c2a0c2a0c2a0c2a0c2a0c2a0c2a0c2a0c2a0c2a0c2a0c2a0c2a0c2a0c2a0c2a02050617274696369706174656420696e206120776f726b73686f70206f6e20e2809c4c494e555820616e64204f70656e20536f757263657320546563686e6f6c6f6779e2809d20617420496e6472617072617374686120456e67696e656572696e6720436f6c6c65676520e280934768617a6961626164202855502920696e204a756e65202d323030382e3c2f703e0d0a3c703e0d0a093c7374726f6e673e342e3c2f7374726f6e673e2050617274696369706174656420696e2061204e6174696f6e616c2053656d696e6172206f6e20e2809c4c6174657374205472656e647320696e20446174612077617265686f7573696e6720616e642044617461204d696e696e67e2809d20617420492e502e452e4d2e2d4768617a69616261642e3c2f703e0d0a3c703e0d0a093c7374726f6e673e352e3c2f7374726f6e673e20417474656e646564206120776f726b73686f7020696e20556e6976657273697479206f66204a616d6d75202820446563656d6265722030342d3037202c3230313029206f6e20e2809c4d6f6465726e20546f6f6c7320696e204170706c6965642053746174697374696373e2809d3c2f703e0d0a3c703e0d0a093c7374726f6e673e362e3c2f7374726f6e673e20417474656e64656420616e642070617274696369706174656420696e2061204e6174696f6e616c2053656d696e6172206f6e20526f6c65206f6620496e666f726d6174696f6e20616e6420436f6d6d756e69636174696f6e20546563686e6f6c6f677920696e2048696768657220456475636174696f6e20284943542920616e6420616c736f20636f6e7472696275746564206120706170657220656e7469746c656420e28098526f6c65206f662049435420696e2068696768657220456475636174696f6ee28099202d313274682d3133746820466562727561727920323031323c2f703e0d0a3c703e0d0a093c7374726f6e673e372e3c2f7374726f6e673e20436f6e647563746564206120776f726b73686f70206f6e20e2809948756d616e2056616c75657320616e642070726f66657373696f6e616c20457468696373e2809920617420494d532d4768617a6961626164206f6e2032347468204175677573742d323031323c2f703e0d0a3c703e0d0a093c7374726f6e673e382e3c2f7374726f6e673e20436f2d43686169726564204e6174696f6e616c20436f6e666572656e6365206f7267616e697a656420627920492e4d2e532e204768617a69616261643c2f703e0d0a3c703e0d0a093c7374726f6e673e392e3c2f7374726f6e673e20417474656e646564206120382d6461797320776f726b73686f702066726f6d20397468204a756c792c3230313220746f2031367468204a756c79202c2032303132206174204949542028496e6469616e20496e73746974757465206f6620546563686e6f6c6f6779292d4b616e707572206f6e20e2809c48756d616e2056616c75657320616e642050726f66657373696f6e616c20457468696373e2809d20616e6420676f742063657274696669656420666f72206265636f6d696e6720612070726f66657373696f6e616c20666f722064656c69766572696e672061636164656d6963733c2f703e0d0a, 0x3c703e0d0a093c7374726f6e673e312e3c2f7374726f6e673e205061727469636970617465642064796e616d6963616c6c79206173206f7267616e697a6572206f662061204e6174696f6e616c2073656d696e6172206f6e20e2809c204c6174657374205472656e6473206f6620496e666f726d6174696f6e20546563686e6f6c6f67792d2061206e657720457261e2809d206174204954532d204768617a69616261642028417072696c20e280932032303036293c2f703e0d0a3c703e0d0a093c7374726f6e673e322e3c2f7374726f6e673e20416e63686f72656420616e6420686f73746564207365766572616c20776f726b73686f70732c2073656d696e61727320616e6420696e7465722d696e737469747574696f6e616c206576656e74732061742070726576696f757320776f726b656420696e737469747574696f6e732e20e280a2c2a0c2a0c2a0c2a0c2a0c2a0c2a0c2a0c2a0c2a0c2a0c2a0c2a0c2a0c2a0c2a0c2a0c2a0c2a0c2a0c2a020417474656e646564206120776f726b73686f70206f6e20e2809c4d6f6465726e20746f6f6c7320696e206170706c6965642053746174697374696373e2809d20696e204a616d6d7520556e69766572736974792e3c2f703e0d0a3c703e0d0a093c7374726f6e673e332e3c2f7374726f6e673e2050617274696369706174656420696e206120776f726b73686f70206f6e20e2809c4c494e555820616e64204f70656e20536f757263657320546563686e6f6c6f6779e2809d20617420496e6472617072617374686120456e67696e656572696e6720436f6c6c65676520e280934768617a6961626164202855502920696e204a756e65202d323030382e3c2f703e0d0a3c703e0d0a093c7374726f6e673e342e3c2f7374726f6e673e2050617274696369706174656420696e2061204e6174696f6e616c2053656d696e6172206f6e20e2809c4c6174657374205472656e647320696e20446174612077617265686f7573696e6720616e642044617461204d696e696e67e2809d20617420492e502e452e4d2e2d4768617a69616261642e3c2f703e0d0a3c703e0d0a093c7374726f6e673e352e3c2f7374726f6e673e20417474656e646564206120776f726b73686f7020696e20556e6976657273697479206f66204a616d6d75202820446563656d6265722030342d3037202c3230313029206f6e20e2809c4d6f6465726e20546f6f6c7320696e204170706c6965642053746174697374696373e2809d3c2f703e0d0a3c703e0d0a093c7374726f6e673e362e3c2f7374726f6e673e20417474656e64656420616e642070617274696369706174656420696e2061204e6174696f6e616c2053656d696e6172206f6e20526f6c65206f6620496e666f726d6174696f6e20616e6420436f6d6d756e69636174696f6e20546563686e6f6c6f677920696e2048696768657220456475636174696f6e20284943542920616e6420616c736f20636f6e7472696275746564206120706170657220656e7469746c656420e28098526f6c65206f662049435420696e2068696768657220456475636174696f6ee28099202d313274682d3133746820466562727561727920323031323c2f703e0d0a3c703e0d0a093c7374726f6e673e372e3c2f7374726f6e673e20436f6e647563746564206120776f726b73686f70206f6e20e2809948756d616e2056616c75657320616e642070726f66657373696f6e616c20457468696373e2809920617420494d532d4768617a6961626164206f6e2032347468204175677573742d323031323c2f703e0d0a3c703e0d0a093c7374726f6e673e382e3c2f7374726f6e673e20436f2d43686169726564204e6174696f6e616c20436f6e666572656e6365206f7267616e697a656420627920492e4d2e532e204768617a69616261643c2f703e0d0a3c703e0d0a093c7374726f6e673e392e3c2f7374726f6e673e20417474656e646564206120382d6461797320776f726b73686f702066726f6d20397468204a756c792c3230313220746f2031367468204a756c79202c2032303132206174204949542028496e6469616e20496e73746974757465206f6620546563686e6f6c6f6779292d4b616e707572206f6e20e2809c48756d616e2056616c75657320616e642050726f66657373696f6e616c20457468696373e2809d20616e6420676f742063657274696669656420666f72206265636f6d696e6720612070726f66657373696f6e616c20666f722064656c69766572696e672061636164656d6963733c2f703e0d0a, '<p>\r\n	<strong>1.</strong> Participated dynamically as organizer of a National seminar on Latest Trends of Information Technology- a new Eraat ITS- Ghaziabad (April,  2006)</p>\r\n<p>\r\n	<strong>2.</strong> Anchored and hosted several workshops, seminars and inter-institutional events at previous worked institutions.</p>\r\n<p>\r\n	<strong>3.</strong>  Attended a workshop on Modern tools in applied Statistics in Jammu University.</p>\r\n<p>\r\n	<strong>4.</strong> Participated in a workshop on LINUX and Open Sources Technology at Indraprastha Engineering College Ghaziabad (UP) in June -2008.</p>\r\n<p>\r\n	<strong>5.</strong> Participated in a National Seminar on Latest Trends in Data warehousing and Data Mining  at I.P.E.M.-Ghaziabad.</p>\r\n<p>\r\n	<strong> 6.</strong> Attended a workshop in University of Jammu ( December 04-07 ,2010) on Modern Tools in Applied Statistics Attended and participated in a National Seminar on Role of Information and Communication Technology in Higher Education (ICT) and also contributed a paper entitled â€˜Role of ICT in higher Education -12th-13th February 2012</p>\r\n<p>\r\n	<strong>7.</strong>  Conducted a workshop on  Human Values and professional Ethics at IMS-Ghaziabad on 24th August-2012</p>\r\n<p>\r\n	<strong>8.</strong> Co-Chaired National Conference organized by I.M.S. Ghaziabad</p>\r\n<p>\r\n	<strong>9.</strong> Attended a 8-days workshop from 9th July,2012 to 16th July , 2012 at IIT (Indian Institute of Technology)-Kanpur on Human Values and Professional Ethics and got certified for becoming a professional for delivering academics</p>\r\n', 0x3c703e0d0a3c7374726f6e673e312e3c2f7374726f6e673e20205061727469636970617465642064796e616d6963616c6c79206173206f7267616e697a6572206f662061204e6174696f6e616c2073656d696e6172206f6e20e2809c204c6174657374205472656e6473206f6620496e666f726d6174696f6e20546563686e6f6c6f67792d2061206e657720457261e2809d206174204954532d204768617a69616261642028417072696c20e280932032303036290d0a3c2f703e0d0a0d0a3c703e0d0a3c7374726f6e673e322e3c2f7374726f6e673e20416e63686f72656420616e6420686f73746564207365766572616c20776f726b73686f70732c2073656d696e61727320616e6420696e7465722d696e737469747574696f6e616c206576656e74732061742070726576696f757320776f726b656420696e737469747574696f6e732e20e280a209417474656e646564206120776f726b73686f70206f6e20e2809c4d6f6465726e20746f6f6c7320696e206170706c6965642053746174697374696373e2809d20696e204a616d6d7520556e69766572736974792e0d0a3c2f703e0d0a0d0a3c703e0d0a3c7374726f6e673e332e3c2f7374726f6e673e2050617274696369706174656420696e206120776f726b73686f70206f6e20e2809c4c494e555820616e64204f70656e20536f757263657320546563686e6f6c6f6779e2809d20617420496e6472617072617374686120456e67696e656572696e6720436f6c6c65676520e280934768617a6961626164202855502920696e204a756e65202d323030382e0d0a3c2f703e0d0a0d0a3c703e0d0a3c7374726f6e673e342e3c2f7374726f6e673e2050617274696369706174656420696e2061204e6174696f6e616c2053656d696e6172206f6e20e2809c4c6174657374205472656e647320696e20446174612077617265686f7573696e6720616e642044617461204d696e696e67e2809d20617420492e502e452e4d2e2d4768617a69616261642e0d0a3c2f703e0d0a0d0a3c703e0d0a3c7374726f6e673e352e3c2f7374726f6e673e20417474656e646564206120776f726b73686f7020696e20556e6976657273697479206f66204a616d6d75202820446563656d6265722030342d3037202c3230313029206f6e20e2809c4d6f6465726e20546f6f6c7320696e204170706c6965642053746174697374696373e2809d0d0a3c2f703e0d0a0d0a3c703e0d0a3c7374726f6e673e362e3c2f7374726f6e673e20417474656e64656420616e642070617274696369706174656420696e2061204e6174696f6e616c2053656d696e6172206f6e20526f6c65206f6620496e666f726d6174696f6e20616e6420436f6d6d756e69636174696f6e20546563686e6f6c6f677920696e2048696768657220456475636174696f6e20284943542920616e6420616c736f20636f6e7472696275746564206120706170657220656e7469746c656420e28098526f6c65206f662049435420696e2068696768657220456475636174696f6ee28099202d313274682d3133746820466562727561727920323031320d0a3c2f703e0d0a0d0a3c703e0d0a3c7374726f6e673e372e3c2f7374726f6e673e20436f6e647563746564206120776f726b73686f70206f6e20e2809948756d616e2056616c75657320616e642070726f66657373696f6e616c20457468696373e2809920617420494d532d4768617a6961626164206f6e2032347468204175677573742d3230313220e280a209436f2d43686169726564204e6174696f6e616c20436f6e666572656e6365206f7267616e697a656420627920492e4d2e532e204768617a69616261640d0a3c2f703e0d0a0d0a3c703e0d0a3c7374726f6e673e382e3c2f7374726f6e673e20417474656e646564206120382d6461797320776f726b73686f702066726f6d20397468204a756c792c3230313220746f2031367468204a756c79202c2032303132206174204949542028496e6469616e20496e73746974757465206f6620546563686e6f6c6f6779292d4b616e707572206f6e20e2809c48756d616e2056616c75657320616e642050726f66657373696f6e616c20457468696373e2809d20616e6420676f742063657274696669656420666f72206265636f6d696e6720612070726f66657373696f6e616c20666f722064656c69766572696e672061636164656d6963730d0a3c2f703e0d0a, '', '', '', 0x2020202020202020202020, '           ', 1, 0x313537393631373633336e6172656e6472612e6a7067, 'Avadhesh Kumar Gupta', 'Avadhesh Kumar Gupta', 'Avadhesh Kumar Gupta');
INSERT INTO `tbl_faculty` (`id`, `cat_id`, `subcat_id`, `sno`, `faculty_password`, `faculty_email`, `slug`, `designation`, `department`, `faculty_name`, `area`, `contact`, `web`, `br_profile`, `educational`, `experience`, `total_exp`, `consult`, `awards`, `interest`, `art_contribute`, `book_auther`, `book_edited`, `res_pub_n_j`, `res_pub_in_j`, `pap_pre_in_con`, `pap_pre_nat_con`, `mdp_org`, `fdp_org`, `semi_n`, `semi_in`, `work_at`, `work_con`, `fdp_at`, `mdp_at`, `semi_con_n`, `semi_con_in`, `res_pr_und`, `status`, `image`, `seo_title`, `seo_key`, `seo_des`) VALUES
(50, 1, 32, 2, '123', 'sivapvsc@gmail.com', 'prof-siva-pvsc', '', 'biotechnology', 'Prof. Siva PVSC', '', '09818194997', '', '<p>Dr Nripendra Dwivedi is working as Associate professor (Comp.Sc) in Institute of Management Studies, Ghaziabad. He has done B.Sc, MCA (Computer Application-73%),M.Phil(Comp.Sc-79%), M.Tech (Comp.Sc-79%) (Gold Medalist) and Ph.D(Comp.Sc-awarded on Analysis of Different Search Engines: Comparative Study&Acirc; from Govt State university , University of Rajasthan, Jaipur, India. He has published around 40 research papers in referred National/International Journals/Conferences viz. IEEE Xplore, Journal of Science and Technology, International journal of computer theory &amp; engineering etc and has presented papers at various National/International Conferences/Seminars. He is having around 16 years of Experience in academia as well as Industry. He is also life time member of reputed professional organization IETE (Institute of Electronics and telecommunication Engineers) He has been honored as session chairperson in different reputed International conferences (including International conference organized by IMT, Ghaziabad etc). He has worked as Head-MCA, Chairperson-Computer Centre and Web Master in different reputed organizations. He also contributed by taking responsibility as Head Examiner (Many times) for evaluation of answer sheets of B.Tech/MCA of entire Mahamaya technical University &amp;UP Technical University.He has been achieved various awards like&nbsp;&nbsp;</p>\r\n', '<p>B.Sc, MCA, M.Tech(Comp.Sc) (Gold Medalist), M.Phil(Comp.Sc), Ph.D</p>\r\n', 0x3c703e313620796561727328417070726f782928496e20446966666572656e742072657075746564206f7267616e697a6174696f6e293c2f703e0d0a, '15 Years', '<p>Developed Site of Indian oil corporation with associated team members</p>\r\n', 0x3c703e3c7374726f6e673e312e3c2f7374726f6e673e204e6174696f6e616c207363686f6c61727368697020486f6c6465723c2f703e0d0a0d0a3c703e3c7374726f6e673e322e3c2f7374726f6e673e204d2e54656368285365637572656420486967686573742072616e6b2d20476f6c64206d6564616c697374293c2f703e0d0a0d0a3c703e3c7374726f6e673e332e3c2f7374726f6e673e204d6963726f736f66742e4e65742043657269666965642028436c6561726564204d6963726f736f66742063657274696669636174696f6e293c2f703e0d0a0d0a3c703e3c7374726f6e673e342e3c2f7374726f6e673e204e434328476f6c64204d6564616c697374293c2f703e0d0a0d0a3c703e3c7374726f6e673e352e3c2f7374726f6e673e20486f6e6f757265642061732073657373696f6e206368616972706572736f6e20696e20646966666572656e74207265707574656420496e7465726e6174696f6e616c20636f6e666572656e636573202820696e636c7564696e6720496e7465726e6174696f6e616c20636f6e666572656e6365206f7267616e697a656420627920494d542c204768617a696162616420657463293c2f703e0d0a0d0a3c703e3c7374726f6e673e362e3c2f7374726f6e673e20486f6e6f757265642061732048656164204578616d696e6572206f6620447220416262756c204b616c616d20546563686e6963616c20556e6976657273697479202f555020546563686e6963616c20556e69766572736974792f204d6168616d61796120556e69766572736974792e3c2f703e0d0a0d0a3c703e3c7374726f6e673e372e3c2f7374726f6e673e20436f2d436f6e76656e6572206f6620496e7465726e6174696f6e616c20436f6e666572656e63653a205375636365737366756c6c79206f7267616e697a656420496e7465726e6174696f6e616c20636f6e666572656e6365206f6e20536b696c6c20446576656c6f706d656e7420616e6420546563686e6f6c6f676963616c20496e6e6f766174696f6e7320666f722045636f6e6f6d69632047726f7774682028494353542d32303135293c2f703e0d0a0d0a3c703e3c7374726f6e673e382e3c2f7374726f6e673e20576f726b65642061732050726163746963616c204578616d696e657220666f722073747564656e7473206f66204d2e546563682028436f6d702e536329206f6620496e64726170726173746820556e6976657273697479202c2044656c68693c2f703e0d0a0d0a3c703e3c7374726f6e673e392e3c2f7374726f6e673e20526576696577657220666f72204945454520496e7465726e6174696f6e616c20436f6e666572656e63653c2f703e0d0a, 0x3c703e44617461205374727563747572652c202e4e65746672616d6520776f726b2c20416476616e636520446174616261736520616e64204175746f6d617461205468656f72793c2f703e0d0a, '', 0x3c703e54776f20626f6f6b7320776f756c642062652073686f72746c79207075626c69736865643c2f703e0d0a, '', '', 0x[encoded data, 17898 characters], '', '', '', 0x3c703e0d0a093c7374726f6e673e312e203c2f7374726f6e673e464450206f6e20e2809c4269676461746120636f6d707574696e6720616e6420416e616c7974696373e2809d696e20636f6c6c61626f726174696f6e20776974682049424d205265736561726368204c6162202c496e646961206973206f7267616e697a65642061732061206d656d626572206f6620436f2d6f7264696e6174696f6e20636f6d6d697474656520617420494d53202c204768617a69616261643c2f703e0d0a, '', '', '', 0x576f726b73686f7020636f6e64756374656420696e20766172696f75732052657075746564206f7267616e697a6174696f6e20496e73746974757465206f6620546563686e6f6c6f6779206f6620536369656e63652c4768617a69616261642026494d532c204768617a6961626164, '', '', 0x53656d696e617220636f6e64756374656420696e20766172696f75732052657075746564206f7267616e697a6174696f6e20696e636c7564696e6720496e73746974757465206f6620546563686e6f6c6f6779206f6620536369656e63652c4768617a69616261642026494d532c204768617a6961626164, 0x3c703e0d0a093c7374726f6e673e312e203c2f7374726f6e673e436f2d436f6e76656e6572206f6620496e7465726e6174696f6e616c20436f6e666572656e63653a205375636365737366756c6c79206f7267616e697a656420496e7465726e6174696f6e616c20636f6e666572656e6365206f6e20536b696c6c20446576656c6f706d656e7420616e6420546563686e6f6c6f676963616c20496e6e6f766174696f6e7320666f722045636f6e6f6d69632047726f7774682028494353542d323031352920617320436f2d436f6e76656e65722e3c2f703e0d0a3c703e0d0a093c7374726f6e673e322e203c2f7374726f6e673e496e7465726e6174696f6e616c20636f6e666572656e636520e2809c496e6e6f766174696f6e20616e642043726561746976697479204d616e6167656d656e743a2046757475726520666f72205375737461696e61626c6520446576656c6f706d656e74202849434d203230313429e2809d206f7267616e697a65722061732061637469766520636f6d6d6974746565206d656d62657220c2a0c2a03c2f703e0d0a202020202020202020202020, '                ', 1, 0x31353739353334393639736976612e6a7067, 'Prof. Siva PVSC', 'Prof. Siva PVSC', 'Prof. Siva PVSC'),
(51, 1, 32, 3, '123', 'rashmi@imsec.ac.in', 'prof-rashmi-chandra', '', 'biotechnology', 'Prof. Rashmi Chandra', 'head', '+91 9999999999', '', '<p>More than 17 years of experience in Training / Teaching practising Professionals as well as Under Graduate and Post Graduate students in Computer Networks, Advanced Computer Networks, WAN Routing Protocols, LAN Technologies &ldquo; Ethernet, Web Technologies, Java, JDBC, Servlets, RMI. Author of book on Programming In Java published by Oxford University press India</p>\r\n', '<p>M.Sc (Biotechnology)&nbsp; M.Tech (Biotechnology)</p>\r\n', 0x3c703e4d6f7265207468616e203137205965617273206f6620457870657269656e63653c2f703e0d0a, '20 Years', '<ol>\r\n	<li>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed.</li>\r\n	<li>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore.</li>\r\n	<li>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor.</li>\r\n</ol>\r\n', 0x3c703e4265737420547261636b20506170657220417761726420647572696e6720496e7465726e6174696f6e616c20436f6e666572656e6365206f6e20436f72706f7261746520476f7665726e616e63653a20526574726f737065637420616e642050726f7370656374732c2046656272756172792031322026616d703b2031332c20323031373c2f703e0d0a, 0x3c703e44424d532c204144424d532c2044617461204d696e696e6720446174612057617265686f757365204f7065726174696e672053797374656d20556e69782f4c696e757820616e6420432c20432b2b2026616d703b205368656c6c2050726f6772616d6d696e672c3c2f703e0d0a, '', 0x3c756c3e0d0a093c6c693e2671756f743b50726f6772616d6d696e6720496e204a61766120322f652671756f743b207075626c6973686564206279204f78666f726420556e697665727369747920507265737320496e6469613c2f6c693e0d0a093c6c693e2671756f743b50726f6772616d6d696e6720496e204a61766120322f652671756f743b207075626c6973686564206279204f78666f726420556e697665727369747920507265737320496e6469613c2f6c693e0d0a093c6c693e2671756f743b50726f6772616d6d696e6720496e204a61766120322f652671756f743b207075626c6973686564206279204f78666f726420556e697665727369747920507265737320496e6469613c2f6c693e0d0a3c2f756c3e0d0a, '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0x202020202020202020202020202020202020, '                  ', 1, 0x31353739353332333338726173686d692e6a7067, 'Prof. Rashmi Chandra', 'Prof. Rashmi Chandra', 'Prof. Rashmi Chandra');

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

--
-- 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', 0x3c703e3c7374726f6e673e66616365626f6f6b206e6577733c2f7374726f6e673e3c2f703e0d0a0d0a3c703e446174652031302f31322f323031383c2f703e0d0a0d0a3c703e48656c6c6f20746869732069732066616365626f6f6b206e6577732074657374206465736372697074696f6e206f6e6c7920666f722074657374696e67202e746869732069732062756d6d79206465736372697074696f6e202e48656c6c6f20746869732069732066616365626f6f6b206e6577732074657374206465736372697074696f6e206f6e6c7920666f722074657374696e67202e746869732069732062756d6d79206465736372697074696f6e266e6273703b48656c6c6f20746869732069732066616365626f6f6b206e6577732074657374206465736372697074696f6e206f6e6c7920666f722074657374696e67202e746869732069732062756d6d79206465736372697074696f6e266e6273703b3c2f703e0d0a0d0a3c703e7468616e6b733c2f703e0d0a0d0a3c703e266e6273703b3c2f703e0d0a0d0a3c703e266e6273703b3c2f703e0d0a, '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', 0x3c703e0d0a093c6120687265663d22687474703a2f2f6c6f63616c686f73742f6d6164652f6e6577732d6465736372697074696f6e2e70687022207374796c653d22626f782d73697a696e673a20696e68657269743b20636f6c6f723a207267622833382c2033382c203338293b20746578742d6465636f726174696f6e2d6c696e653a206e6f6e653b20746578742d7472616e73666f726d3a206361706974616c697a653b20666f6e742d73697a653a20313570783b207472616e736974696f6e3a20616c6c20302e337320656173652030733b20666f6e742d66616d696c793a20526f626f746f2c2073616e732d73657269663b223e4d61726c61627320466561747572656420496e204244434320476c6f62616c204c697374204f6620546f70204465766f707320436f6e73756c74696e6720436f6d70616e69657320496e2054686520576f726c642e3c2f613e3c2f703e0d0a, '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', 0x3c703e3c6120687265663d22687474703a2f2f6c6f63616c686f73742f6d6164652f6e6577732d6465736372697074696f6e2e706870223e4865616c74686361726520342e302041742054686520496e74657273656374696f6e204f662044617461204175746f6d6174696f6e2c20416e6420416e616c79746963733c2f613e3c2f703e0d0a, '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 dumped tables
--

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

--
-- 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_faculty`
--
ALTER TABLE `tbl_faculty`
  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 dumped tables
--

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

--
-- 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_faculty`
--
ALTER TABLE `tbl_faculty`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=453;

--
-- 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;

