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


-- Exportiere Struktur von Tabelle moviebooking.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 moviebooking.category: ~1 rows (ungefaehr)
DELETE FROM `category`;
/*!40000 ALTER TABLE `category` DISABLE KEYS */;
INSERT INTO `category` (`id`, `description`, `name`) VALUES
	(1, 'funny movies with slapsticks and lots of laughs for the audience', 'comedy');
/*!40000 ALTER TABLE `category` ENABLE KEYS */;


-- Exportiere Struktur von Tabelle moviebooking.category_type
DROP TABLE IF EXISTS `category_type`;
CREATE TABLE IF NOT EXISTS `category_type` (
  `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;

-- Exportiere Daten aus Tabelle moviebooking.category_type: ~0 rows (ungefaehr)
DELETE FROM `category_type`;
/*!40000 ALTER TABLE `category_type` DISABLE KEYS */;
/*!40000 ALTER TABLE `category_type` ENABLE KEYS */;


-- Exportiere Struktur von Tabelle moviebooking.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 moviebooking.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 moviebooking.drinks_and_beverages
DROP TABLE IF EXISTS `drinks_and_beverages`;
CREATE TABLE IF NOT EXISTS `drinks_and_beverages` (
  `id` bigint(20) NOT NULL,
  `title` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
  `categoryType_id` bigint(20) NOT NULL,
  `movie_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK2ywykn5inxfqw0olfwb4tqa9r` (`categoryType_id`),
  KEY `FK1a4ygu1svrkhi5sfl4itw4b5a` (`movie_id`),
  CONSTRAINT `FK2ywykn5inxfqw0olfwb4tqa9r` FOREIGN KEY (`categoryType_id`) REFERENCES `categorytype` (`id`),
  CONSTRAINT `FK1a4ygu1svrkhi5sfl4itw4b5a` FOREIGN KEY (`movie_id`) REFERENCES `movie` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Exportiere Daten aus Tabelle moviebooking.drinks_and_beverages: ~0 rows (ungefaehr)
DELETE FROM `drinks_and_beverages`;
/*!40000 ALTER TABLE `drinks_and_beverages` DISABLE KEYS */;
/*!40000 ALTER TABLE `drinks_and_beverages` ENABLE KEYS */;


-- Exportiere Struktur von Tabelle moviebooking.movie
DROP TABLE IF EXISTS `movie`;
CREATE TABLE IF NOT EXISTS `movie` (
  `id` bigint(20) NOT NULL,
  `adult_only` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cinemaHostname` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` varchar(3000) COLLATE utf8_unicode_ci NOT NULL,
  `imdbRating` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `linkDetails` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `linkGooglemaps` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `performerNames` varchar(2000) COLLATE utf8_unicode_ci DEFAULT NULL,
  `title` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `website` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
  `year` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `category_id` bigint(20) NOT NULL,
  `country_id` bigint(20) DEFAULT NULL,
  `venue_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK5e3qbgdbp67ml7el1odwu65gi` (`category_id`),
  KEY `FK5h5hkyxprvsgpqg69nqsq5p48` (`country_id`),
  KEY `FKn1wxue79qktv2if6bcstwg2fc` (`venue_id`),
  CONSTRAINT `FK5e3qbgdbp67ml7el1odwu65gi` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`),
  CONSTRAINT `FK5h5hkyxprvsgpqg69nqsq5p48` FOREIGN KEY (`country_id`) REFERENCES `country` (`id`),
  CONSTRAINT `FKn1wxue79qktv2if6bcstwg2fc` FOREIGN KEY (`venue_id`) REFERENCES `venue` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Exportiere Daten aus Tabelle moviebooking.movie: ~1 rows (ungefaehr)
DELETE FROM `movie`;
/*!40000 ALTER TABLE `movie` DISABLE KEYS */;
INSERT INTO `movie` (`id`, `adult_only`, `cinemaHostname`, `description`, `imdbRating`, `linkDetails`, `linkGooglemaps`, `performerNames`, `title`, `website`, `year`, `category_id`, `country_id`, `venue_id`) VALUES
	(1, 'no', 'CINEMAXX', 'Banana Joe with Bud Spencer is a fun movie about Joe, who will do almost everything to keep his banana delivery service. Fun for the whole family.', '5.0', NULL, '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', 'Bud Spencer, Marina Langner et al', 'Banana Joe', NULL, '1978', 1, 1, 1);
/*!40000 ALTER TABLE `movie` ENABLE KEYS */;


-- Exportiere Struktur von Tabelle moviebooking.movie_booking
DROP TABLE IF EXISTS `movie_booking`;
CREATE TABLE IF NOT EXISTS `movie_booking` (
  `id` bigint(20) NOT 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,
  `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,
  `user_id` bigint(20) NOT NULL,
  `venue_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK7u84ce6c4rvi98n8v8bqqicjy` (`user_id`),
  KEY `FK64f0hox0b2pi5p6ia0yf0t1o6` (`venue_id`),
  CONSTRAINT `FK7u84ce6c4rvi98n8v8bqqicjy` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FK64f0hox0b2pi5p6ia0yf0t1o6` FOREIGN KEY (`venue_id`) REFERENCES `venue` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Exportiere Daten aus Tabelle moviebooking.movie_booking: ~2 rows (ungefaehr)
DELETE FROM `movie_booking`;
/*!40000 ALTER TABLE `movie_booking` DISABLE KEYS */;
INSERT INTO `movie_booking` (`id`, `booking_number`, `booking_time`, `cancellation_time`, `cancelled`, `comment`, `description`, `name`, `user_id`, `venue_id`) VALUES
	(1, '1234567', '2021-01-31 11:02:00', NULL, 'no', 'Back seats, if possible, for me and my lovely wife', '2 Tickets for Valentine\'s movie Banana Joe', '2 Tickets for Banana Joe', 1, 1),
	(2, '1234567', '2021-01-31 10:03:00', NULL, 'no', 'Back seats, if possible, for me and my lovely wife', '2 Tickets for Valentine\'s movie Banana Joe', '2 Tickets for Banana Joe (2)', 1, 1);
/*!40000 ALTER TABLE `movie_booking` ENABLE KEYS */;


-- Exportiere Struktur von Tabelle moviebooking.payment
DROP TABLE IF EXISTS `payment`;
CREATE TABLE IF NOT EXISTS `payment` (
  `id` bigint(20) NOT NULL,
  `amount` varchar(255) COLLATE utf8_unicode_ci 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) NOT NULL,
  `ticket_id` bigint(20) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKk76mlad64na78wukyl7jeg9vx` (`booking_id`),
  KEY `FKknnc0dgh1i8fkalxi2qcj2bwl` (`ticket_id`),
  KEY `FK4spfnm9si9dowsatcqs5or42i` (`user_id`),
  CONSTRAINT `FKk76mlad64na78wukyl7jeg9vx` FOREIGN KEY (`booking_id`) REFERENCES `movie_booking` (`id`),
  CONSTRAINT `FK4spfnm9si9dowsatcqs5or42i` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FKknnc0dgh1i8fkalxi2qcj2bwl` FOREIGN KEY (`ticket_id`) REFERENCES `ticket` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Exportiere Daten aus Tabelle moviebooking.payment: ~1 rows (ungefaehr)
DELETE FROM `payment`;
/*!40000 ALTER TABLE `payment` DISABLE KEYS */;
INSERT INTO `payment` (`id`, `amount`, `cancellation_time`, `cancelled`, `currency`, `pay_time`, `type`, `booking_id`, `ticket_id`, `user_id`) VALUES
	(1, '20.00', NULL, 'no', 'USD', '2021-01-31 11:17:00', 'provider', 1, 1, 1),
	(3, '0.00', NULL, 'no', 'USD', '2021-01-31 10:20:00', 'provider', 2, 2, 1);
/*!40000 ALTER TABLE `payment` ENABLE KEYS */;


-- Exportiere Struktur von Tabelle moviebooking.phone_contact
DROP TABLE IF EXISTS `phone_contact`;
CREATE TABLE IF NOT EXISTS `phone_contact` (
  `id` bigint(20) NOT NULL,
  `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `phoneNumber` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `venue_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKjb7mqba1dkv2b5gutqyrc87a2` (`venue_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Exportiere Daten aus Tabelle moviebooking.phone_contact: ~0 rows (ungefaehr)
DELETE FROM `phone_contact`;
/*!40000 ALTER TABLE `phone_contact` DISABLE KEYS */;
/*!40000 ALTER TABLE `phone_contact` ENABLE KEYS */;


-- Exportiere Struktur von Tabelle moviebooking.seat
DROP TABLE IF EXISTS `seat`;
CREATE TABLE IF NOT EXISTS `seat` (
  `id` bigint(20) NOT NULL,
  `description` varchar(300) 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;

-- Exportiere Daten aus Tabelle moviebooking.seat: ~2 rows (ungefaehr)
DELETE FROM `seat`;
/*!40000 ALTER TABLE `seat` DISABLE KEYS */;
INSERT INTO `seat` (`id`, `description`, `name`) VALUES
	(1, 'Back row center seat', '137'),
	(2, 'Back row center seat', '138');
/*!40000 ALTER TABLE `seat` ENABLE KEYS */;


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


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

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


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

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


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

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


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

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


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


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

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


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

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


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

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


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

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


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


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


-- Exportiere Struktur von Tabelle moviebooking.ticket
DROP TABLE IF EXISTS `ticket`;
CREATE TABLE IF NOT EXISTS `ticket` (
  `id` bigint(20) NOT NULL,
  `currency` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ticket_date` date DEFAULT NULL,
  `ticket_number` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `total_excluding_vat` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `total_including_vat` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `vat` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `movie_id` bigint(20) NOT NULL,
  `movieBooking_id` bigint(20) DEFAULT NULL,
  `seat_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK76th994c74fm9ohowlu53yfpx` (`movie_id`),
  KEY `FKjirxbw7wgo5jr61i9gxxgnxie` (`movieBooking_id`),
  KEY `FKqahao9a85drt47ikjp0b8syvh` (`seat_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Exportiere Daten aus Tabelle moviebooking.ticket: ~2 rows (ungefaehr)
DELETE FROM `ticket`;
/*!40000 ALTER TABLE `ticket` DISABLE KEYS */;
INSERT INTO `ticket` (`id`, `currency`, `ticket_date`, `ticket_number`, `total_excluding_vat`, `total_including_vat`, `vat`, `movie_id`, `movieBooking_id`, `seat_id`) VALUES
	(1, 'EUR', '2021-01-31', '117710', '16.20', '20.00', '3.80', 1, 1, 1),
	(2, 'EUR', '2021-01-31', '117711', '16.20', '20.00', '3.80', 1, 2, 2);
/*!40000 ALTER TABLE `ticket` ENABLE KEYS */;


-- Exportiere Struktur von Tabelle moviebooking.ticket_payment
DROP TABLE IF EXISTS `ticket_payment`;
CREATE TABLE IF NOT EXISTS `ticket_payment` (
  `Ticket_id` bigint(20) NOT NULL,
  `payment_id` bigint(20) NOT NULL,
  PRIMARY KEY (`Ticket_id`,`payment_id`),
  UNIQUE KEY `UK_jhief2cwnpqv69wb33tqh3beu` (`payment_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


-- Exportiere Struktur von Tabelle moviebooking.time_and_charge
DROP TABLE IF EXISTS `time_and_charge`;
CREATE TABLE IF NOT EXISTS `time_and_charge` (
  `id` bigint(20) NOT NULL,
  `charge` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `days` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `endTime` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `startTime` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `movie_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FKku8figjdkckx1r3iat7va36qe` (`movie_id`),
  CONSTRAINT `FKku8figjdkckx1r3iat7va36qe` FOREIGN KEY (`movie_id`) REFERENCES `movie` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Exportiere Daten aus Tabelle moviebooking.time_and_charge: ~0 rows (ungefaehr)
DELETE FROM `time_and_charge`;
/*!40000 ALTER TABLE `time_and_charge` DISABLE KEYS */;
/*!40000 ALTER TABLE `time_and_charge` ENABLE KEYS */;


-- Exportiere Struktur von Tabelle moviebooking.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,
  `aliasName` varchar(50) COLLATE utf8_unicode_ci NOT 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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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


-- Exportiere Struktur von Tabelle moviebooking.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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Exportiere Daten aus Tabelle moviebooking.venue: ~1 rows (ungefaehr)
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 */;