-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Server Version:               5.1.53-community - MySQL Community Server (GPL)
-- Server Betriebssystem:        Win64
-- HeidiSQL Version:             8.0.0.4396
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

-- Exportiere Struktur von Tabelle jobapplication.additional_info
DROP TABLE IF EXISTS `additional_info`;
CREATE TABLE IF NOT EXISTS `additional_info` (
  `id` bigint(20) NOT NULL,
  `date_of_entry` date NOT NULL,
  `former_employer` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `quitting_option_time` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `salary` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `customer_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_pyqfog13d5r4sb607l2l7i9y7` (`customer_id`),
  CONSTRAINT `FK_pyqfog13d5r4sb607l2l7i9y7` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Exportiere Daten aus Tabelle jobapplication.additional_info: ~1 rows 
DELETE FROM `additional_info`;
/*!40000 ALTER TABLE `additional_info` DISABLE KEYS */;
INSERT INTO `additional_info` (`id`, `date_of_entry`, `former_employer`, `quitting_option_time`, `salary`, `customer_id`) VALUES
	(1, '2007-09-01', 'Human Resources Company', '1 Monat', 'Verhandlungssache', 1);
/*!40000 ALTER TABLE `additional_info` ENABLE KEYS */;


-- Exportiere Struktur von Tabelle jobapplication.contact
DROP TABLE IF EXISTS `contact`;
CREATE TABLE IF NOT EXISTS `contact` (
  `id` bigint(20) NOT NULL,
  `department` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `phone_number` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Exportiere Daten aus Tabelle jobapplication.contact: ~1 rows 
DELETE FROM `contact`;
/*!40000 ALTER TABLE `contact` DISABLE KEYS */;
INSERT INTO `contact` (`id`, `department`, `name`, `phone_number`) VALUES
	(1, 'HR Campus, Service Center', 'Frau Human-Resources', '+49 221 123456-789');
/*!40000 ALTER TABLE `contact` ENABLE KEYS */;


-- Exportiere Struktur von Tabelle jobapplication.country
DROP TABLE IF EXISTS `country`;
CREATE TABLE IF NOT EXISTS `country` (
  `id` bigint(20) NOT NULL,
  `iso3` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  `iso_code` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  `numcode` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  `printable_name` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Exportiere Daten aus Tabelle jobapplication.country: ~2 rows 
DELETE FROM `country`;
/*!40000 ALTER TABLE `country` DISABLE KEYS */;
INSERT INTO `country` (`id`, `iso3`, `iso_code`, `name`, `numcode`, `printable_name`) VALUES
	(1, 'USA', 'US', 'United States Of America', '840', 'United States Of America'),
	(2, 'DEU', 'DE', 'Bundesrepublik Deutschland', '276', 'BRD');
/*!40000 ALTER TABLE `country` ENABLE KEYS */;


-- Exportiere Struktur von Tabelle jobapplication.customer
DROP TABLE IF EXISTS `customer`;
CREATE TABLE IF NOT EXISTS `customer` (
  `id` bigint(20) NOT NULL,
  `city` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `street1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `street2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `zip_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date_of_birth` date NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `familyName` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `firstName` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `login` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
  `phone` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `second_phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `country_id` bigint(20) DEFAULT NULL,
  `mrmrs_id` bigint(20) DEFAULT NULL,
  `nationality_id` bigint(20) DEFAULT NULL,
  `source_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_t8foxcd1xtapa8gydjyuy8v6p` (`country_id`),
  KEY `FK_muafifwekceyk5ubfgpet8g7l` (`nationality_id`),
  KEY `FK_gvjkct7rr6nk8esinc7m5dfpf` (`source_id`),
  KEY `FK_rjppgqsd8foa64i6bb2vohjh` (`mrmrs_id`),
  CONSTRAINT `FK_gvjkct7rr6nk8esinc7m5dfpf` FOREIGN KEY (`source_id`) REFERENCES `jobadvertising_source` (`id`),
  CONSTRAINT `FK_muafifwekceyk5ubfgpet8g7l` FOREIGN KEY (`nationality_id`) REFERENCES `nationality` (`id`),
  CONSTRAINT `FK_rjppgqsd8foa64i6bb2vohjh` FOREIGN KEY (`mrmrs_id`) REFERENCES `mrmrs` (`id`),
  CONSTRAINT `FK_t8foxcd1xtapa8gydjyuy8v6p` FOREIGN KEY (`country_id`) REFERENCES `country` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Exportiere Daten aus Tabelle jobapplication.customer: ~1 rows 
DELETE FROM `customer`;
/*!40000 ALTER TABLE `customer` DISABLE KEYS */;
INSERT INTO `customer` (`id`, `city`, `street1`, `street2`, `zip_code`, `date_of_birth`, `email`, `familyName`, `firstName`, `login`, `password`, `phone`, `second_phone`, `title`, `country_id`, `mrmrs_id`, `nationality_id`, `source_id`) VALUES
	(1, 'Phoenix', '98th, Maple Ave', '', '63544', '1979-04-01', 'bananajoe@bananajoe.com', 'Banana', 'Joey', 'bananajoe', 'bananarama', '02211123456789', '02211123456710', '', 1, 1, 1, 1);
/*!40000 ALTER TABLE `customer` ENABLE KEYS */;


-- Exportiere Struktur von Tabelle jobapplication.file_upload
DROP TABLE IF EXISTS `file_upload`;
CREATE TABLE IF NOT EXISTS `file_upload` (
  `id` bigint(20) NOT NULL,
  `cover_letter_path` varchar(1000) COLLATE utf8_unicode_ci NOT NULL,
  `cv_path` varchar(1000) COLLATE utf8_unicode_ci NOT NULL,
  `profile_pic_path` varchar(1000) COLLATE utf8_unicode_ci NOT NULL,
  `testimonial_1_path` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
  `testimonial_2_path` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
  `testimonial_3_path` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
  `testimonial_4_path` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
  `testimonial_5_path` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cover_letter` mediumblob NOT NULL,
  `cv` mediumblob NOT NULL,
  `profile_pic` mediumblob NOT NULL,
  `testimonial1` mediumblob,
  `testimonial2` mediumblob,
  `testimonial3` mediumblob,
  `testimonial4` mediumblob,
  `testimonial5` mediumblob,
  `customer_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_a7t5djx5u8st3jpj3su5r8rvn` (`customer_id`),
  CONSTRAINT `FK_a7t5djx5u8st3jpj3su5r8rvn` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Exportiere Daten aus Tabelle jobapplication.file_upload: ~0 rows 
DELETE FROM `file_upload`;
/*!40000 ALTER TABLE `file_upload` DISABLE KEYS */;
/*!40000 ALTER TABLE `file_upload` ENABLE KEYS */;


-- Exportiere Struktur von Tabelle jobapplication.jobadvertising_source
DROP TABLE IF EXISTS `jobadvertising_source`;
CREATE TABLE IF NOT EXISTS `jobadvertising_source` (
  `id` bigint(20) NOT NULL,
  `name` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Exportiere Daten aus Tabelle jobapplication.jobadvertising_source: ~4 rows 
DELETE FROM `jobadvertising_source`;
/*!40000 ALTER TABLE `jobadvertising_source` DISABLE KEYS */;
INSERT INTO `jobadvertising_source` (`id`, `name`) VALUES
	(1, 'Stepstone'),
	(2, 'Monster'),
	(3, 'Jobstairs'),
	(4, 'Dice');
/*!40000 ALTER TABLE `jobadvertising_source` ENABLE KEYS */;


-- Exportiere Struktur von Tabelle jobapplication.mrmrs
DROP TABLE IF EXISTS `mrmrs`;
CREATE TABLE IF NOT EXISTS `mrmrs` (
  `id` bigint(20) NOT NULL,
  `name` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Exportiere Daten aus Tabelle jobapplication.mrmrs: ~4 rows 
DELETE FROM `mrmrs`;
/*!40000 ALTER TABLE `mrmrs` DISABLE KEYS */;
INSERT INTO `mrmrs` (`id`, `name`) VALUES
	(1, 'Mr.'),
	(2, 'Mrs.'),
	(3, 'Sir'),
	(4, 'Madam');
/*!40000 ALTER TABLE `mrmrs` ENABLE KEYS */;


-- Exportiere Struktur von Tabelle jobapplication.nationality
DROP TABLE IF EXISTS `nationality`;
CREATE TABLE IF NOT EXISTS `nationality` (
  `id` bigint(20) NOT NULL,
  `name` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Exportiere Daten aus Tabelle jobapplication.nationality: ~2 rows 
DELETE FROM `nationality`;
/*!40000 ALTER TABLE `nationality` DISABLE KEYS */;
INSERT INTO `nationality` (`id`, `name`) VALUES
	(1, 'amerikanisch'),
	(2, 'deutsch');
/*!40000 ALTER TABLE `nationality` ENABLE KEYS */;


-- Exportiere Struktur von Tabelle jobapplication.sequence_additional_info
DROP TABLE IF EXISTS `sequence_additional_info`;
CREATE TABLE IF NOT EXISTS `sequence_additional_info` (
  `next_val` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Exportiere Daten aus Tabelle jobapplication.sequence_additional_info: ~1 rows 
DELETE FROM `sequence_additional_info`;
/*!40000 ALTER TABLE `sequence_additional_info` DISABLE KEYS */;
INSERT INTO `sequence_additional_info` (`next_val`) VALUES
	(2);
/*!40000 ALTER TABLE `sequence_additional_info` ENABLE KEYS */;


-- Exportiere Struktur von Tabelle jobapplication.sequence_advertising
DROP TABLE IF EXISTS `sequence_advertising`;
CREATE TABLE IF NOT EXISTS `sequence_advertising` (
  `next_val` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Exportiere Daten aus Tabelle jobapplication.sequence_advertising: ~1 rows 
DELETE FROM `sequence_advertising`;
/*!40000 ALTER TABLE `sequence_advertising` DISABLE KEYS */;
INSERT INTO `sequence_advertising` (`next_val`) VALUES
	(5);
/*!40000 ALTER TABLE `sequence_advertising` ENABLE KEYS */;


-- Exportiere Struktur von Tabelle jobapplication.sequence_contact
DROP TABLE IF EXISTS `sequence_contact`;
CREATE TABLE IF NOT EXISTS `sequence_contact` (
  `next_val` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Exportiere Daten aus Tabelle jobapplication.sequence_contact: ~1 rows 
DELETE FROM `sequence_contact`;
/*!40000 ALTER TABLE `sequence_contact` DISABLE KEYS */;
INSERT INTO `sequence_contact` (`next_val`) VALUES
	(2);
/*!40000 ALTER TABLE `sequence_contact` ENABLE KEYS */;


-- Exportiere Struktur von Tabelle jobapplication.sequence_country
DROP TABLE IF EXISTS `sequence_country`;
CREATE TABLE IF NOT EXISTS `sequence_country` (
  `next_val` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Exportiere Daten aus Tabelle jobapplication.sequence_country: ~1 rows 
DELETE FROM `sequence_country`;
/*!40000 ALTER TABLE `sequence_country` DISABLE KEYS */;
INSERT INTO `sequence_country` (`next_val`) VALUES
	(3);
/*!40000 ALTER TABLE `sequence_country` ENABLE KEYS */;


-- Exportiere Struktur von Tabelle jobapplication.sequence_customer
DROP TABLE IF EXISTS `sequence_customer`;
CREATE TABLE IF NOT EXISTS `sequence_customer` (
  `next_val` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Exportiere Daten aus Tabelle jobapplication.sequence_customer: ~1 rows 
DELETE FROM `sequence_customer`;
/*!40000 ALTER TABLE `sequence_customer` DISABLE KEYS */;
INSERT INTO `sequence_customer` (`next_val`) VALUES
	(2);
/*!40000 ALTER TABLE `sequence_customer` ENABLE KEYS */;


-- Exportiere Struktur von Tabelle jobapplication.sequence_file_upload
DROP TABLE IF EXISTS `sequence_file_upload`;
CREATE TABLE IF NOT EXISTS `sequence_file_upload` (
  `next_val` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Exportiere Daten aus Tabelle jobapplication.sequence_file_upload: ~1 rows 
DELETE FROM `sequence_file_upload`;
/*!40000 ALTER TABLE `sequence_file_upload` DISABLE KEYS */;
INSERT INTO `sequence_file_upload` (`next_val`) VALUES
	(2);
/*!40000 ALTER TABLE `sequence_file_upload` ENABLE KEYS */;


-- Exportiere Struktur von Tabelle jobapplication.sequence_mrmrs
DROP TABLE IF EXISTS `sequence_mrmrs`;
CREATE TABLE IF NOT EXISTS `sequence_mrmrs` (
  `next_val` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Exportiere Daten aus Tabelle jobapplication.sequence_mrmrs: ~1 rows 
DELETE FROM `sequence_mrmrs`;
/*!40000 ALTER TABLE `sequence_mrmrs` DISABLE KEYS */;
INSERT INTO `sequence_mrmrs` (`next_val`) VALUES
	(5);
/*!40000 ALTER TABLE `sequence_mrmrs` ENABLE KEYS */;


-- Exportiere Struktur von Tabelle jobapplication.sequence_nationality
DROP TABLE IF EXISTS `sequence_nationality`;
CREATE TABLE IF NOT EXISTS `sequence_nationality` (
  `next_val` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Exportiere Daten aus Tabelle jobapplication.sequence_nationality: ~1 rows 
DELETE FROM `sequence_nationality`;
/*!40000 ALTER TABLE `sequence_nationality` DISABLE KEYS */;
INSERT INTO `sequence_nationality` (`next_val`) VALUES
	(3);
/*!40000 ALTER TABLE `sequence_nationality` ENABLE KEYS */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;