--
-- Host: localhost    Database: symfony
-- ------------------------------------------------------


--
-- Table structure for table `blogs`
--

CREATE TABLE `blogs` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `title` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8mb3_unicode_ci NOT NULL,
  `image_url` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_F41BCA70A76ED395` (`user_id`),
  CONSTRAINT `FK_F41BCA70A76ED395` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `blogs`
--


--
-- Table structure for table `booking`
--

CREATE TABLE `booking` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hotel_id` int NOT NULL,
  `user_id` int NOT NULL,
  `check_in` datetime DEFAULT NULL,
  `check_out` datetime DEFAULT NULL,
  `total_price` double DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_E00CEDDE3243BB18` (`hotel_id`),
  KEY `IDX_E00CEDDEA76ED395` (`user_id`),
  CONSTRAINT `FK_E00CEDDE3243BB18` FOREIGN KEY (`hotel_id`) REFERENCES `hotels` (`id`),
  CONSTRAINT `FK_E00CEDDEA76ED395` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `booking`
--


--
-- Table structure for table `comment`
--

CREATE TABLE `comment` (
  `id` int NOT NULL AUTO_INCREMENT,
  `author_id` int NOT NULL,
  `blog_id` int NOT NULL,
  `message` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_9474526CF675F31B` (`author_id`),
  KEY `IDX_9474526CDAE07E97` (`blog_id`),
  CONSTRAINT `FK_9474526CDAE07E97` FOREIGN KEY (`blog_id`) REFERENCES `blogs` (`id`),
  CONSTRAINT `FK_9474526CF675F31B` FOREIGN KEY (`author_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `comment`
--


--
-- Table structure for table `doctrine_migration_versions`
--

CREATE TABLE `doctrine_migration_versions` (
  `version` varchar(191) COLLATE utf8mb3_unicode_ci NOT NULL,
  `executed_at` datetime DEFAULT NULL,
  `execution_time` int DEFAULT NULL,
  PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `doctrine_migration_versions`
--

INSERT INTO `doctrine_migration_versions` VALUES ('DoctrineMigrations\\Version20231031150320','2023-11-07 13:34:00',848),('DoctrineMigrations\\Version20231101213925','2023-11-07 13:34:01',421),('DoctrineMigrations\\Version20231102074620','2023-11-07 13:34:01',26),('DoctrineMigrations\\Version20231108120742','2023-11-08 12:07:52',226),('DoctrineMigrations\\Version20231108135828','2023-11-08 13:58:38',147),('DoctrineMigrations\\Version20231113100329','2023-11-13 10:03:40',29),('DoctrineMigrations\\Version20231114145942','2023-11-14 15:00:24',37),('DoctrineMigrations\\Version20231116102351','2023-11-16 10:24:26',46),('DoctrineMigrations\\Version20231116125053','2023-11-16 12:51:01',191),('DoctrineMigrations\\Version20231121121701','2023-11-21 12:17:11',46),('DoctrineMigrations\\Version20231122134146','2023-11-22 13:42:02',34);

--
-- Table structure for table `hotels`
--

CREATE TABLE `hotels` (
  `id` int NOT NULL AUTO_INCREMENT,
  `region_id` int NOT NULL,
  `name` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `address` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `image_url` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `image_urls` longtext COLLATE utf8mb3_unicode_ci NOT NULL COMMENT '(DC2Type:simple_array)',
  `contact_email` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `contact_phones` longtext COLLATE utf8mb3_unicode_ci NOT NULL COMMENT '(DC2Type:simple_array)',
  `is_active` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_E402F6256DE44026` (`description`),
  KEY `IDX_E402F62598260155` (`region_id`),
  CONSTRAINT `FK_E402F62598260155` FOREIGN KEY (`region_id`) REFERENCES `regions` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `hotels`
--

INSERT INTO `hotels` VALUES (71,105,'Kunterbunt im Harz','Hotel Address','Hotel Description','images/hotel/image 2.jpg','image1.jpg,image2.jpg','hotel@example.com','123456789,987654321',1),(72,111,'Kultur pur','Hotel2 Address','Hotel2 Description','images/hotel/image 3.jpg','image1.jpg,image2.jpg','hotel@example.com','123456789,987654321',1),(73,111,'Romantik zu Zweit','Hotel3 Address','Hotel3 Description','images/hotel/image 4.jpg','image1.jpg,image2.jpg','hotel@example.com','123456789,987654321',1),(74,111,'Romantik zu Zweittt','Hotel4 Address','Hotel4 Description','images/hotel/image 4.jpg','image1.jpg,image2.jpg','hotel@example.com','123456789,987654321',1);

--
-- Table structure for table `hotels_features`
--

CREATE TABLE `hotels_features` (
  `id` int NOT NULL AUTO_INCREMENT,
  `hotel_id` int NOT NULL,
  `name` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `value` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_7A280BEF3243BB18` (`hotel_id`),
  CONSTRAINT `FK_7A280BEF3243BB18` FOREIGN KEY (`hotel_id`) REFERENCES `hotels` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=109 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `hotels_features`
--

INSERT INTO `hotels_features` VALUES (101,71,'Cancellation','free'),(102,71,'Breackfast','included'),(103,72,'Cancellation','free'),(104,72,'Breackfast','included'),(105,73,'Cancellation','free'),(106,73,'Breackfast','included'),(107,74,'Cancellation','free'),(108,74,'Breackfast','included');

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` int NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `keywords` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `meta` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `pages`
--


--
-- Table structure for table `regions`
--

CREATE TABLE `regions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `description` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `image_url` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=112 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `regions`
--

INSERT INTO `regions` VALUES (105,'description','images/region/Group 240.jpg','Bad Harzburg'),(106,'description','images/region/Group 1695.jpg','Burg bei Magdeburg'),(107,'description','images/region/Group 241.jpg','Ilsenburg'),(108,'description','images/region/Group 243.jpg','Quedlinburg'),(109,'description','images/region/Group 1698.jpg','Schierke'),(110,'description','images/region/Group 245.jpg','Wernigerode'),(111,'description','images/region/Slider-Magdeburg-800x600 1.jpg','Wolmirstedt');

--
-- Table structure for table `reviews`
--

CREATE TABLE `reviews` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `hotel_id` int NOT NULL,
  `text` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `rating` double DEFAULT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_6970EB0FA76ED395` (`user_id`),
  KEY `IDX_6970EB0F3243BB18` (`hotel_id`),
  CONSTRAINT `FK_6970EB0F3243BB18` FOREIGN KEY (`hotel_id`) REFERENCES `hotels` (`id`),
  CONSTRAINT `FK_6970EB0FA76ED395` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `reviews`
--

INSERT INTO `reviews` VALUES (46,44,71,'text',5,'2023-11-22 13:42:10'),(47,44,72,'text',5,'2023-11-22 13:42:10'),(48,44,73,'text',5,'2023-11-22 13:42:10'),(49,44,74,'text',5,'2023-11-22 13:42:10');

--
-- Table structure for table `user_gdpr_policy`
--

CREATE TABLE `user_gdpr_policy` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `type` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `accepted_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_E98B371BA76ED395` (`user_id`),
  CONSTRAINT `FK_E98B371BA76ED395` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `user_gdpr_policy`
--



