   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
--- Data exporting was unselected.
+-- Dumping data for table hoyanna.role: ~0 rows (approximately)
+DELETE FROM `role`;
+/*!40000 ALTER TABLE `role` DISABLE KEYS */;
+/*!40000 ALTER TABLE `role` ENABLE KEYS */;
 
 
 -- Dumping structure for table hoyanna.role_permission

  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

  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 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
