-- --------------------------------------------------------
-- 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 Datenbank Struktur für schedulehelper
DROP DATABASE IF EXISTS `schedulehelper`;
CREATE DATABASE IF NOT EXISTS `schedulehelper` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */;
USE `schedulehelper`;


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

/*!40000 ALTER TABLE `category` DISABLE KEYS */;
INSERT INTO `category` (`id`, `description`, `name`) VALUES
	(1, 'Language lessons & music', 'Language lessons & music');
/*!40000 ALTER TABLE `category` ENABLE KEYS */;



-- Exportiere Struktur von Tabelle schedulehelper.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 shoppinghelper.country: ~2 rows (ungefaehr)
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', 'Germany', '276', 'Germany');
/*!40000 ALTER TABLE `country` ENABLE KEYS */;


-- Exportiere Struktur von Tabelle schedulehelper.course_list
DROP TABLE IF EXISTS `course_list`;
CREATE TABLE IF NOT EXISTS `course_list` (
  `id` bigint(20) NOT NULL,
  `title` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
  `user_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKgnspsxgqyp5dq64ri46j0lfwb` (`user_id`),
  CONSTRAINT `FKgnspsxgqyp5dq64ri46j0lfwb` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*!40000 ALTER TABLE `course_list` DISABLE KEYS */;
INSERT INTO `course_list` (`id`, `title`, `user_id`) VALUES
	(1, 'Language courses list (Banana Joe)', 1);
/*!40000 ALTER TABLE `course_list` ENABLE KEYS */;



-- Exportiere Struktur von Tabelle schedulehelper.course_pack
DROP TABLE IF EXISTS `course_pack`;
CREATE TABLE IF NOT EXISTS `course_pack` (
  `id` bigint(20) NOT NULL,
  `description` varchar(3000) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `teacher` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


/*!40000 ALTER TABLE `course_pack` DISABLE KEYS */;
INSERT INTO `course_pack` (`id`, `description`, `name`, `teacher`) VALUES
	(1, 'Learning English, Lesson No.1', 'Learning English, Lesson No.1', 'The Dead Trousers');
/*!40000 ALTER TABLE `course_pack` ENABLE KEYS */;


-- Exportiere Struktur von Tabelle schedulehelper.selected_course
DROP TABLE IF EXISTS `selected_course`;
CREATE TABLE IF NOT EXISTS `selected_course` (
  `id` bigint(20) NOT NULL,
  `title` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
  `category_id` bigint(20) NOT NULL,
  `courseList_id` bigint(20) NOT NULL,
  `coursePack_id` bigint(20) DEFAULT NULL,
  `timeTable_id` bigint(20) DEFAULT NULL,
  `venue_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK7ii9c5i43v741m3ja1q3lr96y` (`category_id`),
  KEY `FKmb3xvoa7d52nvnoym5fempj36` (`courseList_id`),
  KEY `FKksenqkok1tsr9fgavmdyxtdo8` (`coursePack_id`),
  KEY `FK4eryv8cqcm37155w1jk1yysmu` (`timeTable_id`),
  KEY `FKss2dkcnl5st5kvf9f0blbc65q` (`venue_id`),
  CONSTRAINT `FK7ii9c5i43v741m3ja1q3lr96y` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`),
  CONSTRAINT `FKmb3xvoa7d52nvnoym5fempj36` FOREIGN KEY (`courseList_id`) REFERENCES `course_list` (`id`),
  CONSTRAINT `FKksenqkok1tsr9fgavmdyxtdo8` FOREIGN KEY (`coursePack_id`) REFERENCES `course_pack` (`id`),
  CONSTRAINT `FK4eryv8cqcm37155w1jk1yysmu` FOREIGN KEY (`timeTable_id`) REFERENCES `time_table` (`id`),
  CONSTRAINT `FKss2dkcnl5st5kvf9f0blbc65q` FOREIGN KEY (`venue_id`) REFERENCES `venue` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

/*!40000 ALTER TABLE `selected_course` DISABLE KEYS */;
INSERT INTO `selected_course` (`id`, `title`, `category_id`, `courseList_id`, `coursePack_id`, `timeTable_id`, `venue_id`) VALUES
	(1, 'Selected Language Courses', 1, 1, 1, 1, 1);
/*!40000 ALTER TABLE `selected_course` ENABLE KEYS */;


-- Exportiere Struktur von Tabelle schedulehelper.venue
DROP TABLE IF EXISTS `venue`;
CREATE TABLE IF NOT EXISTS `venue` (
  `id` bigint(20) NOT NULL,
  `city` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `state` 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,
  `linkGooglemaps` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `location` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `website` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `country_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKgbmuiqsqu2ots7ffjscnw22cj` (`country_id`),
  CONSTRAINT `FKgbmuiqsqu2ots7ffjscnw22cj` FOREIGN KEY (`country_id`) REFERENCES `country` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


-- Exportiere Daten aus Tabelle schedulehelper.venue
/*!40000 ALTER TABLE `venue` DISABLE KEYS */;
INSERT INTO `venue` (`id`, `city`, `state`, `street1`, `street2`, `zip_code`, `linkGooglemaps`, `location`, `name`, `website`, `country_id`) VALUES (1, 'Duisburg', 'NRW', 'Duesseldorfer Landstr. 347', NULL, '47259', 'https://www.google.de/maps/place/D%C3%BCsseldorfer+Landstra%C3%9Fe+347,+47259+Duisburg/@51.362718,6.7476223,17z/data=!4m13!1m7!3m6!1s0x47b8b858a856ac33:0x27c06dc780eb7f76!2sD%C3%BCsseldorfer+Landstra%C3%9Fe+347,+47259+Duisburg!3b1!8m2!3d51.362718!4d6.749811!3m4!1s0x47b8b858a856ac33:0x27c06dc780eb7f76!8m2!3d51.362718!4d6.749811', 'Duesseldorfer Landstr. 347, Duisburg-Huckingen', 'Steinhof Duisburg', 'http://www.steinhof-duisburg.de', 2);
/*!40000 ALTER TABLE `venue` ENABLE KEYS */;


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


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


-- Exportiere Struktur von Tabelle schedulehelper.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 schedulehelper.sequence_country: ~1 rows (ungefaehr)
DELETE FROM `sequence_country`;
/*!40000 ALTER TABLE `sequence_country` DISABLE KEYS */;
INSERT INTO `sequence_country` (`next_val`) VALUES
	(1);
/*!40000 ALTER TABLE `sequence_country` ENABLE KEYS */;


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

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


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

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


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

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


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

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


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

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


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

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


-- Exportiere Struktur von Tabelle schedulehelper.time_table
DROP TABLE IF EXISTS `time_table`;
CREATE TABLE IF NOT EXISTS `time_table` (
  `id` bigint(20) NOT NULL,
  `description` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  `end_date_time` datetime NOT NULL,
  `estimated_hours` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `start_date_time` datetime NOT NULL,
  `start_on` date NOT NULL,
  `status` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


/*!40000 ALTER TABLE `time_table` DISABLE KEYS */;
INSERT INTO `time_table` (`id`, `description`, `end_date_time`, `estimated_hours`, `start_date_time`, `start_on`, `status`) VALUES
	(1, 'weekdays evenings', '1986-10-20 20:00:00', '42', '1986-10-01 17:00:00', '1986-10-01', 'completed');
/*!40000 ALTER TABLE `time_table` ENABLE KEYS */;


-- Exportiere Struktur von Tabelle schedulehelper.user
DROP TABLE IF EXISTS `user`;
CREATE TABLE IF NOT EXISTS `user` (
  `id` bigint(20) NOT NULL,
  `city` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `state` 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,
  `firstName` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `lastName` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `login` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `middleName` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `password` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
  `phone` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `country_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKk1jeoaj2fixpghqk5olopn1lq` (`country_id`),
  CONSTRAINT `FKk1jeoaj2fixpghqk5olopn1lq` FOREIGN KEY (`country_id`) REFERENCES `country` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Exportiere Daten aus Tabelle shoppinghelper.user: ~1 rows (ungefaehr)
DELETE FROM `user`;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` (`id`, `city`, `state`, `street1`, `street2`, `zip_code`, `date_of_birth`, `email`, `firstName`, `lastName`, `login`, `middleName`, `password`, `phone`, `country_id`) VALUES
	(1, 'Phoenix', 'Arizona', '98th, Maple Ave', '', '63544', '1979-04-01', 'bananajoe@bananajoe.com', 'Joe', 'Banana', 'bananajoe', '', 'bananarama', '02211123456789', 1);
/*!40000 ALTER TABLE `user` 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 */;