 --
 
 CREATE TABLE IF NOT EXISTS `schools` (
-  `id` int(11) NOT NULL,
+  `id` int(11) NOT NULL AUTO_INCREMENT,
   `sc_name` varchar(10) NOT NULL,
   `sc_full_name` varchar(70) NOT NULL,
   `about_us` text NOT NULL,
   `course_structure` text NOT NULL,
   `faculty` text NOT NULL,
   `placements` text NOT NULL,
-  `tagline` varchar(200) NOT NULL
-) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
+  `tagline` varchar(200) NOT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;
 
 --
 -- Dumping data for table `schools`
 --
 
 INSERT INTO `schools` (`id`, `sc_name`, `sc_full_name`, `about_us`, `course_structure`, `faculty`, `placements`, `tagline`) VALUES
-(12, 'soict', 'School Of Information and Communication  Technology', '<ul>\r\n<li>Department of Computer Science & Engineering</li>\r\n<li>Department of Electronics & Communication Engineering</li>\r\n</ul>\r\n\r\n', '<ul>\r\n<li>Integrated Dual Degree</li>\r\n<li>Post Graduate</li>\r\n<li>Doctrate</li>\r\n</ul>', '<b>    Dr. Ela Kumar</b><br>    Dean(I/C), School of ICT, Gautam Buddha University<br><p class="panel-body"><dl><dt>Dr. Om Prakash Sangwan                </dt><dd>School of ICT, Gautam Buddha University </dd><br><dt>Dr. Anurag Singh Bhagel                </dt><dd>School of ICT, Gautam Buddha University </dd></dl></p>', 'Placement Session will begin from 3rd December and will continue till 28th June.', 'abcedf'),
-(13, 'sovsas', 'School Of Vocational Studies And Applied Sciences', '<ul>\r\n<li>Department of Applied Mathematics</li>\r\n<li>Department of Applied Physics</li>\r\n<li>Department of Applied Chemistry</li>\r\n<li>Department of Environmental Sciences</li>\r\n<li>Department of Vocational Studies</li>\r\n<li>Department of Food Processing & Technology</li>\r\n</ul>\r\n\r\n', '<ul><li> Integrated Dual Degree</li><li> Post Graduate</li><li> Doctrate</li></ul>', '<dl><dt>Dr. Ela Kumar                </dt><dd>Dean(I/C), School of ICT, Gautam Buddha University </dd><br><dt>Dr. Om Prakash Sangwan                </dt><dd>School of ICT, Gautam Buddha University </dd><br><dt>Dr. Anurag Singh Bhagel                </dt><dd>School of ICT, Gautam Buddha University </dd></dl>', 'Placement Session will begin from 3rd December and will continue till 28th June.', ''),
-(15, 'sobt', 'School of Biotechnology', '<ul>\r\n<li>Department of Biotechnology</li>\r\n</ul>\r\n\r\n', '<ul><li>&nbsp;Integrated Dual Degree</li><li>&nbsp;Post Graduate</li><li>Doctrate</li></ul>', '<dl><dt>Dr. Ela Kumar                </dt><dd>Dean(I/C), School of ICT, Gautam Buddha University </dd><br><dt>Dr. Om Prakash Sangwan                </dt><dd>School of ICT, Gautam Buddha University </dd><br><dt>Dr. Anurag Singh Bhagel                </dt><dd>School of ICT, Gautam Buddha University </dd></dl>', 'Placement Session will begin from 3rd December and will continue till 28th June.', ''),
-(16, 'soe', ' School of Engineering', '<ul>\r\n<li>Department of Civil Engineering</li>\r\n<li>Department of Electrical Engineering</li>\r\n<li>Department of Mechanical Engineering</li>\r\n<li>Department of Architecture & Regional Planning</li>\r\n</ul>\r\n\r\n', '<ul><li>&nbsp;Integrated Dual Degree</li><li>&nbsp;Post Graduate</li><li>&nbsp;Doctrate</li></ul>', '<dl><dt>Dr. Ela Kumar                </dt><dd>Dean(I/C), School of ICT, Gautam Buddha University </dd><br><dt>Dr. Om Prakash Sangwan                </dt><dd>School of ICT, Gautam Buddha University </dd><br><dt>Dr. Anurag Singh Bhagel                </dt><dd>School of ICT, Gautam Buddha University </dd></dl>', 'Placement Session will begin from 3rd December and will continue till 28th June.', ''),
+(12, 'soict', 'School Of Information and Communication  Technology', '<ul>\r\n<li>Department of Computer Science & Engineering</li>\r\n<li>Department of Electronics & Communication Engineering</li>\r\n</ul>\r\n\r\n', '<ol><li>Integrated Dual Degree <br></li><ul type="disc"><li>(B.Tech + M.Tech/MBA) - Computer Science and Engineering</li><li>(B.Tech + M.Tech/MBA) - Electronics and Communication Engineering</li></ul><br><li>Post Graduate</li><ul type="disc"><li>M.Tech (ICT) - Intelligent Systems and Robotics</li><li>M.Tech (ICT) - Software Engineering</li><li>M.Tech (ICT) - VLSI Design</li><li>M.Tech (ICT) - Wireless Communication and Networks</li><li>M.Tech - Computer Science</li></ul><br><li>Doctrate Programs</li></ol>', '', 'Placement Session will begin from 3rd December and will continue till 28th June.', 'abcedf'),
+(13, 'sovsas', 'School Of Vocational Studies And Applied Sciences', '<ul><li>Department of Applied Mathematics</li><li>Department of Applied Chemistry</li><li>Department of Applied Physics</li><li>Department of Environmental Sciences</li><li>Department of Vocational Studies</li><li>Department of Food Processing & Technology</li></ul>', '<ol><li>Integrated Dual Degree <br></li><ul type="disc"><li>(B.Tech + M.Tech/MBA) - Food Processing and Technology<br></li></ul><br><li>Post Graduate</li><ul type="disc"><li>M.Tech  - Food Processing and Technology<br></li><li>M.Sc - Applied Mathematics<br></li><li>M.Sc - Applied Chemistry</li><li>M.Sc - Applied Physics</li><li>M.Sc - Environmental Science</li><li>M.Sc - Food Science<br></li></ul><br><li>Doctoral Programs<br></li><ul type="disc"><li>Ph.D - Applied Mathematics</li><li>Ph.D - Applied Chemistry<br></li><li>Ph.D - Applied Physics <br></li></ul></ol>', '', 'Placement Session will begin from 3rd December and will continue till 28th June.', ''),
+(15, 'sobt', 'School of Biotechnology', '<ul>\r\n<li>Department of Biotechnology</li>\r\n</ul>\r\n\r\n', '<ol><li>Integrated Dual Degree <br></li><ul type="disc"><li>(B.Tech + M.Tech/MBA) - Biotechnology<br></li></ul><br><li>Post Graduate</li><ul type="disc"><li>M.Tech  - Biotechnology</li></ul><br><li>Doctoral Programs<br></li><ul type="disc"><li>Ph.D - Various areas of Biotechnology</li></ul></ol>', '', 'Placement Session will begin from 3rd December and will continue till 28th June.', ''),
+(16, 'soe', ' School of Engineering', '<ul>\r\n<li>Department of Civil Engineering</li>\r\n<li>Department of Electrical Engineering</li>\r\n<li>Department of Mechanical Engineering</li>\r\n<li>Department of Architecture & Regional Planning</li>\r\n</ul>\r\n\r\n', '<ol><li>Integrated Dual Degree <br></li><ul type="disc"><li>(B.Tech + M.Tech/MBA) - Mechanical Engineering</li><li>(B.Tech + M.Tech/MBA) - Electrical Engineering</li><li>(B.Tech + M.Tech/MBA) - Civil Engineering</li></ul><br><li>Post Graduate</li><ul type="disc"><li>M.Plan - Urban and Regional Planning<br></li></ul><br><li>Doctoral Programs<br></li><ul type="disc"><li>Ph.D - Applied Mathematics</li><li>Ph.D - Applied Chemistry<br></li><li>Ph.D - Applied Physics <br></li></ul></ol>', '', 'Placement Session will begin from 3rd December and will continue till 28th June.', ''),
 (17, 'som', ' School of Management', '<ul>\r\n<li>Department of Bussiness Management</li>\r\n</ul>\r\n\r\n', '<ul><li>&nbsp;Integrated Dual Degree</li><li>&nbsp;Post Graduate</li><li>&nbsp;Doctrate</li></ul>', '<dl><dt>Dr. Ela Kumar                </dt><dd>Dean(I/C), School of ICT, Gautam Buddha University </dd><br><dt>Dr. Om Prakash Sangwan                </dt><dd>School of ICT, Gautam Buddha University </dd><br><dt>Dr. Anurag Singh Bhagel                </dt><dd>School of ICT, Gautam Buddha University </dd></dl>', 'Placement Session will begin from 3rd December and will continue till 28th June.', ''),
 (18, 'soljg', ' School of Law, Justice and Governance', '', '<ul><li>&nbsp;Integrated Dual Degree</li><li>&nbsp;Post Graduate</li><li>&nbsp;Doctrate</li></ul>', '<dl><dt>Dr. Ela Kumar                </dt><dd>Dean(I/C), School of ICT, Gautam Buddha University </dd><br><dt>Dr. Om Prakash Sangwan                </dt><dd>School of ICT, Gautam Buddha University </dd><br><dt>Dr. Anurag Singh Bhagel                </dt><dd>School of ICT, Gautam Buddha University </dd></dl>', 'Placement Session will begin from 3rd December and will continue till 28th June.', ''),
 (19, 'sobsc', ' School of Buddhist Studies And Civilization ', '', '<ul><li>&nbsp;Integrated Dual Degree</li><li>&nbsp;Post Graduate</li><li>&nbsp;Doctrate</li></ul>', '<dl><dt>Dr. Ela Kumar                </dt><dd>Dean(I/C), School of ICT, Gautam Buddha University </dd><br><dt>Dr. Om Prakash Sangwan                </dt><dd>School of ICT, Gautam Buddha University </dd><br><dt>Dr. Anurag Singh Bhagel                </dt><dd>School of ICT, Gautam Buddha University </dd></dl>', 'Placement Session will begin from 3rd December and will continue till 28th June.', ''),

--

CREATE TABLE IF NOT EXISTS `exams` (
  `id` int(11) NOT NULL,
  `sc_name` varchar(10) NOT NULL,
  `year` int(11) NOT NULL,
  `paper_name` varchar(30) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `exams`

--

CREATE TABLE IF NOT EXISTS `clubs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `about_us` text NOT NULL,
  `faculty` text NOT NULL,
  `students` text NOT NULL,
  `c_name` varchar(25) NOT NULL,
  `c_full_name` varchar(70) NOT NULL,
  `tagline` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `clubs`
