   KEY `FK_vacancy_user` (`userid`),
   CONSTRAINT `FK_vacancy_user` FOREIGN KEY (`userid`) REFERENCES `user` (`userid`),
   CONSTRAINT `FK_vacancy_vacancytype` FOREIGN KEY (`typeid`) REFERENCES `vacancytype` (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-
--- Data exporting was unselected.
+) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
+
+-- Dumping data for table hoyanna.vacancy: ~1 rows (approximately)
+DELETE FROM `vacancy`;
+/*!40000 ALTER TABLE `vacancy` DISABLE KEYS */;
+INSERT INTO `vacancy` (`id`, `name`, `description`, `date`, `userid`, `typeid`) VALUES
+	(1, 'testing', 'test desc', '2015-12-11 18:32:46', 1, 1);
+/*!40000 ALTER TABLE `vacancy` ENABLE KEYS */;
 
 
 -- Dumping structure for table hoyanna.vacancytype

  CONSTRAINT `FK__role` FOREIGN KEY (`role_id`) REFERENCES `role` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Data exporting was unselected.


-- Dumping structure for table hoyanna.vacancy

  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

-- Dumping data for table hoyanna.industry: ~5 rows (approximately)
DELETE FROM `industry`;
/*!40000 ALTER TABLE `industry` DISABLE KEYS */;
INSERT INTO `industry` (`id`, `name`) VALUES
	(1, 'Travel & Tourism'),
	(2, 'Hospitality, Catering'),
	(3, 'Idustrial, Manufacturing & Production'),
	(4, ' Agriculture, Forestry & Outdoor'),
	(5, 'Transport, Logistics & Distribution');
/*!40000 ALTER TABLE `industry` ENABLE KEYS */;


-- Dumping structure for table hoyanna.permission
