-- --------------------------------------------------------
-- 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 travelbooking
DROP DATABASE IF EXISTS `travelbooking`;
CREATE DATABASE IF NOT EXISTS `travelbooking` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */;
USE `travelbooking`;


-- Exportiere Struktur von Tabelle travelbooking.available_guest
DROP TABLE IF EXISTS `available_guest`;
CREATE TABLE IF NOT EXISTS `available_guest` (
  `id` bigint(20) NOT NULL,
  `arrival` date NOT NULL,
  `departure` date NOT NULL,
  `title` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
  `guest_id` bigint(20) DEFAULT NULL,
  `guestList_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK1qesdaa95okj2hw8pi0odxqha` (`guest_id`),
  KEY `FK25hwgyfns5s9ch4faupd3xmhu` (`guestList_id`),
  CONSTRAINT `FK1qesdaa95okj2hw8pi0odxqha` FOREIGN KEY (`guest_id`) REFERENCES `guest` (`id`),
  CONSTRAINT `FK25hwgyfns5s9ch4faupd3xmhu` FOREIGN KEY (`guestList_id`) REFERENCES `guest_list` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Exportiere Daten aus Tabelle travelbooking.available_guest: ~1 rows (ungefähr)
DELETE FROM `available_guest`;
/*!40000 ALTER TABLE `available_guest` DISABLE KEYS */;
INSERT INTO `available_guest` (`id`, `arrival`, `departure`, `title`, `guest_id`, `guestList_id`) VALUES
	(1, '2020-12-06', '2020-12-17', 'Family Vacation Banana Joe', 1, 4);
/*!40000 ALTER TABLE `available_guest` ENABLE KEYS */;


-- Exportiere Struktur von Tabelle travelbooking.booking
DROP TABLE IF EXISTS `booking`;
CREATE TABLE IF NOT EXISTS `booking` (
  `id` bigint(20) NOT NULL,
  `airport_shuttle` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `booking_number` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `booking_time` datetime NOT NULL,
  `cancellation_time` datetime DEFAULT NULL,
  `cancelled` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `checkin_time` datetime NOT NULL,
  `checkout_time` datetime NOT NULL,
  `comment` varchar(3000) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(3000) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `nights` int(11) NOT NULL,
  `category_id` bigint(20) NOT NULL,
  `invoice_id` bigint(20) DEFAULT NULL,
  `room_id` bigint(20) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  `venue_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK7vcip04fp617nnprquypt7i86` (`category_id`),
  KEY `FK82k7adeh1fnk72hidnpp65aun` (`invoice_id`),
  KEY `FKq83pan5xy2a6rn0qsl9bckqai` (`room_id`),
  KEY `FKkgseyy7t56x7lkjgu3wah5s3t` (`user_id`),
  KEY `FKp0qid0epicmuxn39fha72x6e8` (`venue_id`),
  CONSTRAINT `FK7vcip04fp617nnprquypt7i86` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`),
  CONSTRAINT `FK82k7adeh1fnk72hidnpp65aun` FOREIGN KEY (`invoice_id`) REFERENCES `invoice` (`id`),
  CONSTRAINT `FKkgseyy7t56x7lkjgu3wah5s3t` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FKp0qid0epicmuxn39fha72x6e8` FOREIGN KEY (`venue_id`) REFERENCES `venue` (`id`),
  CONSTRAINT `FKq83pan5xy2a6rn0qsl9bckqai` FOREIGN KEY (`room_id`) REFERENCES `room` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Exportiere Daten aus Tabelle travelbooking.booking: ~1 rows (ungefähr)
DELETE FROM `booking`;
/*!40000 ALTER TABLE `booking` DISABLE KEYS */;
INSERT INTO `booking` (`id`, `airport_shuttle`, `booking_number`, `booking_time`, `cancellation_time`, `cancelled`, `checkin_time`, `checkout_time`, `comment`, `description`, `name`, `nights`, `category_id`, `invoice_id`, `room_id`, `user_id`, `venue_id`) VALUES
	(1, 'none', '12345678911', '2020-05-01 07:30:00', NULL, 'no', '2020-12-21 18:10:00', '2020-12-31 07:20:00', 'Family Vacation 2020 Family Banana Joe', 'Vacation Booking, Banana Joe', 'Family Vacation 2020 Booking Banana Joe', 10, 1, 1, 1, 1, 1);
/*!40000 ALTER TABLE `booking` ENABLE KEYS */;


-- Exportiere Struktur von Tabelle travelbooking.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(50) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Exportiere Daten aus Tabelle travelbooking.category: ~2 rows (ungefähr)
DELETE FROM `category`;
/*!40000 ALTER TABLE `category` DISABLE KEYS */;
INSERT INTO `category` (`id`, `description`, `name`) VALUES
	(1, 'Booking a vacation', 'Vacation'),
	(2, 'Booking a business trip', 'Business');
/*!40000 ALTER TABLE `category` ENABLE KEYS */;


-- Exportiere Struktur von Tabelle travelbooking.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 travelbooking.country: ~2 rows (ungefähr)
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 travelbooking.guest
DROP TABLE IF EXISTS `guest`;
CREATE TABLE IF NOT EXISTS `guest` (
  `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,
  `middleName` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `country_id` bigint(20) DEFAULT NULL,
  `booking_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK5w97l6avtpl8j68u9d4j1ev1o` (`country_id`),
  KEY `FKbekeu8ai4px9yt54imbqry6sh` (`booking_id`),
  CONSTRAINT `FK5w97l6avtpl8j68u9d4j1ev1o` FOREIGN KEY (`country_id`) REFERENCES `country` (`id`),
  CONSTRAINT `FKbekeu8ai4px9yt54imbqry6sh` FOREIGN KEY (`booking_id`) REFERENCES `booking` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Exportiere Daten aus Tabelle travelbooking.guest: ~1 rows (ungefähr)
DELETE FROM `guest`;
/*!40000 ALTER TABLE `guest` DISABLE KEYS */;
INSERT INTO `guest` (`id`, `city`, `state`, `street1`, `street2`, `zip_code`, `date_of_birth`, `email`, `firstName`, `lastName`, `middleName`, `phone`, `country_id`, `booking_id`) VALUES
	(1, 'Phoenix', 'Arizona', '98th, Maple Ave', '', '63544', '1979-04-01', 'bananajoe@bananajoe.com', 'Joe', 'Banana', '', '02211123456789', 1, 1);
/*!40000 ALTER TABLE `guest` ENABLE KEYS */;


-- Exportiere Struktur von Tabelle travelbooking.guest_list
DROP TABLE IF EXISTS `guest_list`;
CREATE TABLE IF NOT EXISTS `guest_list` (
  `id` bigint(20) NOT NULL,
  `title` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
  `booking_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKsb1naw10piyxar3vungq456tg` (`booking_id`),
  CONSTRAINT `FKsb1naw10piyxar3vungq456tg` FOREIGN KEY (`booking_id`) REFERENCES `booking` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Exportiere Daten aus Tabelle travelbooking.guest_list: ~1 rows (ungefähr)
DELETE FROM `guest_list`;
/*!40000 ALTER TABLE `guest_list` DISABLE KEYS */;
INSERT INTO `guest_list` (`id`, `title`, `booking_id`) VALUES
	(4, '2020 Family Banana', 1);
/*!40000 ALTER TABLE `guest_list` ENABLE KEYS */;


-- Exportiere Struktur von Tabelle travelbooking.invoice
DROP TABLE IF EXISTS `invoice`;
CREATE TABLE IF NOT EXISTS `invoice` (
  `id` bigint(20) NOT NULL,
  `currency` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `invoice_date` date DEFAULT NULL,
  `invoice_number` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `total_excluding_vat` float NOT NULL,
  `total_including_vat` float NOT NULL,
  `vat` float NOT NULL,
  `user_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKjunvl5maki3unqdvljk31kns3` (`user_id`),
  CONSTRAINT `FKjunvl5maki3unqdvljk31kns3` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Exportiere Daten aus Tabelle travelbooking.invoice: ~1 rows (ungefähr)
DELETE FROM `invoice`;
/*!40000 ALTER TABLE `invoice` DISABLE KEYS */;
INSERT INTO `invoice` (`id`, `currency`, `invoice_date`, `invoice_number`, `total_excluding_vat`, `total_including_vat`, `vat`, `user_id`) VALUES
	(1, 'USD', '2020-06-03', '12345678910111121314ABCDEFG', 299.95, 350.94, 50.99, 1);
/*!40000 ALTER TABLE `invoice` ENABLE KEYS */;


-- Exportiere Struktur von Tabelle travelbooking.payment
DROP TABLE IF EXISTS `payment`;
CREATE TABLE IF NOT EXISTS `payment` (
  `id` bigint(20) NOT NULL,
  `amount` float NOT NULL,
  `cancellation_time` datetime DEFAULT NULL,
  `cancelled` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `currency` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `pay_time` datetime DEFAULT NULL,
  `type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `booking_id` bigint(20) DEFAULT NULL,
  `invoice_id` bigint(20) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKqewrl4xrv9eiad6eab3aoja65` (`booking_id`),
  KEY `FKsb24p8f52refbb80qwp4gem9n` (`invoice_id`),
  KEY `FK4spfnm9si9dowsatcqs5or42i` (`user_id`),
  CONSTRAINT `FK4spfnm9si9dowsatcqs5or42i` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FKqewrl4xrv9eiad6eab3aoja65` FOREIGN KEY (`booking_id`) REFERENCES `booking` (`id`),
  CONSTRAINT `FKsb24p8f52refbb80qwp4gem9n` FOREIGN KEY (`invoice_id`) REFERENCES `invoice` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Exportiere Daten aus Tabelle travelbooking.payment: ~1 rows (ungefähr)
DELETE FROM `payment`;
/*!40000 ALTER TABLE `payment` DISABLE KEYS */;
INSERT INTO `payment` (`id`, `amount`, `cancellation_time`, `cancelled`, `currency`, `pay_time`, `type`, `booking_id`, `invoice_id`, `user_id`) VALUES
	(2, 350.94, NULL, 'no', 'USD', '2020-06-03 16:19:20', 'credit', 1, 1, 1);
/*!40000 ALTER TABLE `payment` ENABLE KEYS */;


-- Exportiere Struktur von Tabelle travelbooking.room
DROP TABLE IF EXISTS `room`;
CREATE TABLE IF NOT EXISTS `room` (
  `id` bigint(20) NOT NULL,
  `base_price_per_night` float NOT NULL,
  `bath` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `bed` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `breakfast` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `checkout` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` varchar(3000) COLLATE utf8_unicode_ci NOT NULL,
  `extra_bed` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `kitchen` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `max_persons` int(11) NOT NULL,
  `minibar` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `smoker` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `view` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Exportiere Daten aus Tabelle travelbooking.room: ~3 rows (ungefähr)
DELETE FROM `room`;
/*!40000 ALTER TABLE `room` DISABLE KEYS */;
INSERT INTO `room` (`id`, `base_price_per_night`, `bath`, `bed`, `breakfast`, `checkout`, `description`, `extra_bed`, `kitchen`, `max_persons`, `minibar`, `name`, `smoker`, `view`) VALUES
	(1, 25.9, 'showertubs', 'TWO_QUEENS', 'continental', 'early', 'Family Vacation 2020, room for the Banana Joe', 'none', 'none', 4, 'yes', 'Family Vacation 2020, Banana Joe', 'nonsmoking', 'ocean'),
	(2, 23.9, 'showertub', 'TWO_QUEENS', 'buffet', 'late', 'Family Vacation 2020, room for the Banana Joe', 'yes', 'yes', 4, 'no', 'Family Vacation 2020, Banana Joe', 'smoker', 'premium'),
	(3, 23.9, 'doubled', 'TWO_QUEENS', 'buffet', 'late', 'Family Vacation 2020, room for the Banana Joe', 'yes', 'yes', 4, 'yes', 'Family Vacation 2020, Banana Joe', 'nonsmoking', 'ocean');
/*!40000 ALTER TABLE `room` ENABLE KEYS */;


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

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


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

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


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


-- Exportiere Struktur von Tabelle travelbooking.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 travelbooking.sequence_country: ~1 rows (ungefähr)
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 travelbooking.sequence_guest
DROP TABLE IF EXISTS `sequence_guest`;
CREATE TABLE IF NOT EXISTS `sequence_guest` (
  `next_val` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


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

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


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

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


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

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


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

-- Exportiere Daten aus Tabelle travelbooking.sequence_room: ~1 rows (ungefähr)
DELETE FROM `sequence_room`;
/*!40000 ALTER TABLE `sequence_room` DISABLE KEYS */;
INSERT INTO `sequence_room` (`next_val`) VALUES
	(4);
/*!40000 ALTER TABLE `sequence_room` ENABLE KEYS */;


-- Exportiere Struktur von Tabelle travelbooking.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 travelbooking.sequence_user: ~1 rows (ungefähr)
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 travelbooking.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 travelbooking.sequence_venue: ~1 rows (ungefähr)
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 travelbooking.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 `FKge8lxibk9q3wf206s600otk61` (`country_id`),
  CONSTRAINT `FKge8lxibk9q3wf206s600otk61` FOREIGN KEY (`country_id`) REFERENCES `country` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Exportiere Daten aus Tabelle travelbooking.user: ~1 rows (ungefähr)
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 */;


-- Exportiere Struktur von Tabelle travelbooking.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(100) 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 travelbooking.venue: ~1 rows (ungefähr)
DELETE FROM `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 */;
/*!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 */;