--
-- Host: localhost    Database: admission
-- ------------------------------------------------------


--
-- Table structure for table `abroad`
--

CREATE TABLE `abroad` (
  `abroad_id` int(11) NOT NULL AUTO_INCREMENT,
  `country` varchar(100) NOT NULL DEFAULT '0',
  `detail` longtext NOT NULL,
  PRIMARY KEY (`abroad_id`),
  UNIQUE KEY `country` (`country`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `abroad`
--

INSERT INTO `abroad` VALUES (1,'0','[BLOB]'),(2,'Ukraine','[BLOB]'),(4,'Russia','[BLOB]'),(5,'Armenia','[BLOB]'),(6,'Belarus','[BLOB]'),(7,'Philippines','[BLOB]'),(8,'Kazakhstan','[BLOB]'),(9,'Kyrgyzstan','[BLOB]'),(10,'China','[BLOB]'),(11,'Georgia','[BLOB]'),(12,'Nepal','[BLOB]'),(13,'Bangladesh','[BLOB]');

--
-- Table structure for table `bitly`
--

CREATE TABLE `bitly` (
  `bitly_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `college` int(10) unsigned NOT NULL,
  `link` varchar(500) NOT NULL,
  `start_date` datetime NOT NULL,
  `end_date` datetime NOT NULL,
  PRIMARY KEY (`bitly_id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bitly`
--

INSERT INTO `bitly` VALUES (1,1751,'https://bit.ly/3GnrqeF','0000-00-00 00:00:00','0000-00-00 00:00:00'),(2,1949,'https://bit.ly/47YOdch','0000-00-00 00:00:00','0000-00-00 00:00:00'),(3,884,'https://bit.ly/3HIqt0t','0000-00-00 00:00:00','0000-00-00 00:00:00'),(4,82,'https://sms.lpu.in/g4bcbmiPs','0000-00-00 00:00:00','0000-00-00 00:00:00'),(5,1810,'http://bit.ly/3ZfUOul','0000-00-00 00:00:00','0000-00-00 00:00:00'),(6,1709,'https://bitly.ws/3gZEF','0000-00-00 00:00:00','0000-00-00 00:00:00'),(7,3022,'https://rb.gy/ppcy4c','0000-00-00 00:00:00','0000-00-00 00:00:00'),(8,832,'https://bit.ly/3X0c85D','0000-00-00 00:00:00','0000-00-00 00:00:00'),(9,1661,'https://bit.ly/4719Ffq','0000-00-00 00:00:00','0000-00-00 00:00:00'),(10,1662,'https://bit.ly/4719Ffq','0000-00-00 00:00:00','0000-00-00 00:00:00'),(11,857,'https://jecrcuapplication.jecrcuniversity.edu.in/application-form?utm_source=J-Publisher&utm_medium=Code2&utm_campaign=Code2','0000-00-00 00:00:00','0000-00-00 00:00:00'),(12,847,'https://bit.ly/3TtHaCj','0000-00-00 00:00:00','0000-00-00 00:00:00'),(13,1756,'https://bit.ly/3TtHaCj','0000-00-00 00:00:00','0000-00-00 00:00:00'),(14,2897,'https://bit.ly/3TtHaCj','0000-00-00 00:00:00','0000-00-00 00:00:00');

--
-- Table structure for table `category`
--

CREATE TABLE `category` (
  `category_id` int(11) NOT NULL AUTO_INCREMENT,
  `category` varchar(200) NOT NULL,
  `detail` longtext NOT NULL,
  PRIMARY KEY (`category_id`),
  UNIQUE KEY `category` (`category`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `category`
--

INSERT INTO `category` VALUES (1,'Engineering','[BLOB]'),(2,'Management','[BLOB]'),(3,'Law','[BLOB]'),(4,'Medical','[BLOB]'),(5,'Architecture','[BLOB]'),(6,'Pharmacy','[BLOB]'),