--
-- 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','[encoded data, 70724 characters]'),(2,'Ukraine','[encoded data, 4476 characters]'),(4,'Russia','[encoded data, 7696 characters]'),(5,'Armenia','[encoded data, 5476 characters]'),(6,'Belarus','[encoded data, 4708 characters]'),(7,'Philippines','[encoded data, 5680 characters]'),(8,'Kazakhstan','[encoded data, 5964 characters]'),(9,'Kyrgyzstan','[encoded data, 5716 characters]'),(10,'China','PGRpdj48aW1nIHNyYz0iaHR0cHM6Ly9pLmltZ3VyLmNvbS9HRnB1cXRpLmpwZyI+PC9kaXY+PHVsIGNsYXNzPSJoaWdobGlnaHRzIj48bGk+PGIgc3R5bGU9ImZvbnQtc2l6ZTogc21hbGw7Ij5DYXBpdGFsOiZuYnNwOzwvYj48c3BhbiBzdHlsZT0iZm9udC1zaXplOiBzbWFsbDsiPkJlaWppbmc8L3NwYW4+PC9saT48bGk+PGIgc3R5bGU9ImZvbnQtc2l6ZTogMTFwdDsgZm9udC1mYW1pbHk6IENhbGlicmksIHNhbnMtc2VyaWY7Ij5DdXJyZW5jeTo8L2I+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZTogMTFwdDsgZm9udC1mYW1pbHk6IENhbGlicmksIHNhbnMtc2VyaWY7Ij4gPC9zcGFuPjxmb250IHNpemU9IjIiPjxzcGFuIHN0eWxlPSJmb250LWZhbWlseTogQ2FsaWJyaSwgc2Fucy1zZXJpZjsiPlJlbm1pbmJpDQooQ05ZKSAoUk1CKTwvc3Bhbj48L2ZvbnQ+PC9saT48bGk+PGIgc3R5bGU9ImZvbnQtc2l6ZTogMTFwdDsgZm9udC1mYW1pbHk6IENhbGlicmksIHNhbnMtc2VyaWY7Ij5EaWFsaW5nIENvZGU6IDwvYj48Zm9udCBzaXplPSIyIj48c3BhbiBzdHlsZT0iZm9udC1mYW1pbHk6IENhbGlicmksIHNhbnMtc2VyaWY7Ij4rODY8L3NwYW4+PC9mb250PjwvbGk+PGxpPjxiIHN0eWxlPSJmb250LXNpemU6IDExcHQ7IGZvbnQtZmFtaWx5OiBDYWxpYnJpLCBzYW5zLXNlcmlmOyI+T2ZmaWNpYWwgTGFuZ3VhZ2U6PC9iPjxzcGFuIHN0eWxlPSJmb250LXNpemU6IDExcHQ7IGZvbnQtZmFtaWx5OiBDYWxpYnJpLCBzYW5zLXNlcmlmOyI+IDwvc3Bhbj48c3BhbiBzdHlsZT0iZm9udC1zaXplOiAxNXB4OyBmb250LWZhbWlseTogQ2FsaWJyaSwgc2Fucy1zZXJpZjsiPjxmb250IHNpemU9IjIiPkNoaW5lc2U8L2ZvbnQ+PC9zcGFuPjwvbGk+PGxpPjxiIHN0eWxlPSJmb250LXNpemU6IDExcHQ7IGZvbnQtZmFtaWx5OiBDYWxpYnJpLCBzYW5zLXNlcmlmOyI+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZTogMTFwdDsgbGluZS1oZWlnaHQ6IDExNSU7Ij5SZWxpZ2lvbjo8L3NwYW4+PC9iPjxzcGFuIHN0eWxlPSJmb250LXNpemU6IDExcHQ7IGZvbnQtZmFtaWx5OiBDYWxpYnJpLCBzYW5zLXNlcmlmOyBsaW5lLWhlaWdodDogMTE1JTsiPiZuYnNwOzwvc3Bhbj48c3BhbiBzdHlsZT0iZm9udC1zaXplOiAxNXB4OyBmb250LWZhbWlseTogQ2FsaWJyaSwgc2Fucy1zZXJpZjsgbGluZS1oZWlnaHQ6IDExNSU7Ij48Zm9udCBzaXplPSIyIj5UYW9pc20sIENvbmZ1Y2lhbmlzbTwvZm9udD48L3NwYW4+PC9saT48L3VsPjxwPjwvcD48cD48c3BhbiBzdHlsZT0iZm9udC1zaXplOiAxNXB4OyI+Q2hpbmEgaXMgbG9jYXRlZCBpbiB0aGUgZWFzdGVybiBwYXJ0IG9mIEFzaWEgd2l0aCBhIHN3aWZ0bHkNCmRldmVsb3BpbmcgZWNvbm9teS4gVGhlIGNvdW50cnkgaXMgYWxzbyBvZmZpY2lhbGx5IHRlcm1lZCBhcyB0aGUgUGVvcGxl4oCZcw0KUmVwdWJsaWMgb2YgQ2hpbmEgYW5kIGl0IGhhcyB0aGUgd29ybGTigJlzIGxhcmdlc3QgcG9wdWxhdGlvbi4gRHVlIHRvIHRoZQ0KbGFyZ2UgZ2VvZ3JhcGhpY2FsIHNpemUgb2YgdGhlIGNvdW50cnksIHBlb3BsZSBjYW4gZmluZCBkaWZmZXJlbnQgdHlwZXMgb2YNCmNsaW1hdGVzIGluIGRpZmZlcmVudCBwYXJ0cyBvZiBDaGluYS4gUGVvcGxlIG9mIENoaW5hIHNwZWFrIENoaW5lc2UgYnV0IGluIHRoZQ0KbWFqb3IgY2l0aWVzIG9mIHRoZSBjb3VudHJ5LCBwZW9wbGUgY2FuIGFsc28gcGVvcGxlIHNwZWFraW5nIGFuZCB1bmRlcnN0YW5kaW5nDQpFbmdsaXNoLiBUaGUgdHJhbnNwb3J0IHN5c3RlbSBvZiB0aGUgY291bnRyeSBpcyB3ZWxsIGRldmVsb3BlZCBhbmQgeW91IGNhbg0KY29tbXV0ZSB0byBldmVuIHRoZSByZW1vdGVzdCBhcmVhcyBlYXNpbHkuIER1ZSB0byB0aGUgZ3JlYXQgaGlzdG9yaWNhbA0KYmFja2dyb3VuZCBvZiBDaGluYSwgb25lIGNhbiBmaW5kIENoaW5lc2UgcGVvcGxlIHdlbGwgY3VsdHVyZWQgYW5kIGhvc3BpdGFibGUNCnRvd2FyZHMgZm9yZWlnbmVycy48YnI+PC9zcGFuPjxzcGFuIHN0eWxlPSJmb250LXNpemU6IDE1cHg7Ij5UbyBwcm9tb3RlIGVkdWNhdGlvbiwgdGhlIGdvdmVybm1lbnQgb2YgQ2hpbmEgcHJvdmlkZXMNCnNwZWNpYWwgc3VwcG9ydCB0byBzdHVkZW50cyBjb21pbmcgZnJvbSBmb3JlaWduIGNvdW50cmllcy4gVGhlIGdvdmVybm1lbnQgaGFzDQptYWRlIHNwZWNpYWwgYXJyYW5nZW1lbnRzIGZvciBvdmVyc2VhcyBzdHVkZW50cyB0aGF0IGVuc3VyZSBzYWZldHkgYW5kDQpmaW5hbmNpYWwgc3VwcG9ydC4gVGh1cywgaW4gQ2hpbmEsIHlvdSBjYW4gc3R1ZHkgcGVhY2VmdWxseSB3aXRoIHRoZSBtb3N0DQphZHZhbmNlZCBmYWNpbGl0aWVzIHdpdGhpbiBhIGxpbWl0ZWQgYnVkZ2V0Ljxicj48L3NwYW4+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZTogMTVweDsiPk1vc3Qgb2YgdGhlIENoaW5lc2UgTWVkaWNhbCBVbml2ZXJzaXRpZXMgcmFuayBhbW9uZyB0aGUgYmVzdA0KNTAwIHVuaXZlcnNpdGllcyBpbiB0aGUgd29ybGQgJmFtcDsgaXQgaXMgYWJvdXQgNzAlIGNoZWFwZXIgdGhhbiB1bmRlcnRha2luZw0KdGhlIHNhbWUgY291cnNlIGluIEV1cm9wZSBvciB0aGUgVVNBLiBUaGUgbG93ZXIgY29zdCBvZiBsaXZpbmcgYW5kIGxvdyB0dWl0aW9uDQpmZWVzIGFyZSBvbmUgZmFjdG9yIHRoYXQgbWlnaHQgaGVscCB5b3UgbWFrZSB5b3VyIGRlY2lzaW9uLjxicj48L3NwYW4+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZTogMTVweDsiPkFyb3VuZCA0NSBVbml2ZXJzaXRpZXMNCmFyZSBsaXN0ZWQgaW4gTWVkaWNhbCBDb3VuY2lsIGluIEluZGlhIGhhdmUgYXJvdW5kIDMwMDAgc2VhdHMgZm9yIGludGVybmF0aW9uYWwNCnN0dWRlbnRzIHBlciB5ZWFyLiBNb3JlIHRoYW4gMTAsMDAwIEluZGlhbiBzdHVkZW50cyBhcmUgYWxyZWFkeSBzdHVkeWluZyBpbg0KY2hpbmEuPC9zcGFuPjwvcD48cD48L3A+'),(11,'Georgia','[encoded data, 5280 characters]'),(12,'Nepal','[encoded data, 5540 characters]'),(13,'Bangladesh','[encoded data, 7608 characters]');

--
-- 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','[encoded data, 13532 characters]'),(2,'Management','[encoded data, 80440 characters]'),(3,'Law','[encoded data, 48624 characters]'),(4,'Medical','[encoded data, 36432 characters]'),(5,'Architecture','[encoded data, 46228 characters]'),(6,'Pharmacy','[encoded data, 124512 characters]'),