-- Table structure for table `exam`
--

CREATE TABLE `exam` (
  `exam_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `abbreviation` varchar(50) NOT NULL,
  `category` varchar(1000) NOT NULL,
  `program` varchar(1000) NOT NULL,
  `detail` longtext NOT NULL,
  PRIMARY KEY (`exam_id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=82 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `exam`
--

INSERT INTO `exam` VALUES (1,'Joint Entrance Examination (Main) – Paper 1st  (JEE Main -Paper 1st)','JEE Main - Paper 1st','[\"Engineering\",\"Architecture\"]','[\"Bachelor of Technology\",\"Bachelor of Engineering\",\"Bachelor of Architecture\",\"Integrated M.Tech. (B.Tech. and M.Tech.)\",\"B.Tech. (Part-Time)\"]','[BLOB]'),(2,'Joint Entrance Examination (Main) – Paper 2nd (JEE Main - Paper 2nd)','JEE Main - Paper 2nd ','[\"Architecture\"]','[\"Bachelor of Architecture\"]','[BLOB]'),(11,'Joint Entrance Examination - Advanced (JEE Advanced)','JEE-Advanced','[\"Engineering\"]','[\"Bachelor of Technology\",\"Bachelor of Engineering\"]','[BLOB]'),(12,'Birla Institute of Technology & Science Admission Test (BITSAT)','BITSAT','[\"Engineering\",\"Pharmacy\"]','[\"Bachelor of Engineering\",\"Bachelor of Pharmacy\"]','[BLOB]'),(13,'Vellore Institute of Technology Engineering Entrance Exam (VITEEE)','VITEEE','[\"Engineering\"]','[\"Bachelor of Technology\"]','[BLOB]'),(14,'Manipal Entrance Test (MET)','Manipal (MET)','[\"Engineering\"]','[\"Bachelor of Technology\"]','[BLOB]'),(15,'Amrita Engineering Entrance Exam (AEEE)','Amrita (AEEE)','[\"Engineering\"]','[\"Bachelor of Technology\"]','[BLOB]'),(17,'Bharti Vidyapeeth Deemed University Common Entrance Test (BVP-CET)','BVP-CET','[\"Engineering\"]','[\"Bachelor of Technology\"]','[BLOB]'),