-- Table structure for table `PresentationReview`
--

CREATE TABLE `PresentationReview` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `presentation_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_4FF42BFDAB627E8B` (`presentation_id`),
  KEY `IDX_4FF42BFDA76ED395` (`user_id`),
  CONSTRAINT `FK_4FF42BFDA76ED395` FOREIGN KEY (`user_id`) REFERENCES `SiteUser` (`id`),
  CONSTRAINT `FK_4FF42BFDAB627E8B` FOREIGN KEY (`presentation_id`) REFERENCES `Presentation` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `PresentationReview`
--


--
-- Table structure for table `PresentationReviewCriteria`
--

CREATE TABLE `PresentationReviewCriteria` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `event_id` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_B21D01BD71F7E88B` (`event_id`),
  CONSTRAINT `FK_B21D01BD71F7E88B` FOREIGN KEY (`event_id`) REFERENCES `Event` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `PresentationReviewCriteria`
--


--
-- Table structure for table `PresentationReviewCriteriaOption`
--

CREATE TABLE `PresentationReviewCriteriaOption` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `criteria_id` int(11) DEFAULT NULL,
  `value_id` int(11) DEFAULT NULL,
  `point` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_A2B789A1990BEA15` (`criteria_id`),
  KEY `IDX_A2B789A1F920BBA2` (`value_id`),
  CONSTRAINT `FK_A2B789A1990BEA15` FOREIGN KEY (`criteria_id`) REFERENCES `PresentationReviewCriteria` (`id`),
  CONSTRAINT `FK_A2B789A1F920BBA2` FOREIGN KEY (`value_id`) REFERENCES `PresentationReviewCriteriaValue` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `PresentationReviewCriteriaOption`
--


--
-- Table structure for table `PresentationReviewCriteriaValue`
--

CREATE TABLE `PresentationReviewCriteriaValue` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `PresentationReviewCriteriaValue`
--


--
-- Table structure for table `PresentationReviewItem`
--

CREATE TABLE `PresentationReviewItem` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `option_id` int(11) DEFAULT NULL,
  `review_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_698E95E3A7C41D6F` (`option_id`),
  KEY `IDX_698E95E33E2E969B` (`review_id`),
  CONSTRAINT `FK_698E95E33E2E969B` FOREIGN KEY (`review_id`) REFERENCES `PresentationReview` (`id`),
  CONSTRAINT `FK_698E95E3A7C41D6F` FOREIGN KEY (`option_id`) REFERENCES `PresentationReviewCriteriaOption` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `PresentationReviewItem`
--


--
-- Table structure for table `PresentationSection`
--

CREATE TABLE `PresentationSection` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `event_id` int(11) DEFAULT NULL,
  `lecturehall_id` int(11) DEFAULT NULL,
  `tree_root` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `chairs` tinytext COLLATE utf8_unicode_ci,
  `start` datetime DEFAULT NULL,
  `end` datetime DEFAULT NULL,
  `lft` int(11) NOT NULL,
  `lvl` int(11) NOT NULL,
  `rgt` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_9C4E246171F7E88B` (`event_id`),
  KEY `IDX_9C4E2461EC858AFF` (`lecturehall_id`),
  KEY `IDX_9C4E2461A977936C` (`tree_root`),
  KEY `IDX_9C4E2461727ACA70` (`parent_id`),
  CONSTRAINT `FK_9C4E246171F7E88B` FOREIGN KEY (`event_id`) REFERENCES `Event` (`id`),
  CONSTRAINT `FK_9C4E2461727ACA70` FOREIGN KEY (`parent_id`) REFERENCES `PresentationSection` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_9C4E2461A977936C` FOREIGN KEY (`tree_root`) REFERENCES `PresentationSection` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_9C4E2461EC858AFF` FOREIGN KEY (`lecturehall_id`) REFERENCES `LectureHall` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `PresentationSection`
--

INSERT INTO `PresentationSection` VALUES (1,3,NULL,1,NULL,'Megnyitó',NULL,'Molnár Tamás, Kristóf Tünde, Miheller Pál','2020-03-06 09:15:00','2020-03-06 09:30:00',1,0,2),(2,3,NULL,2,NULL,'MIKROBIOM',NULL,'Üléselnök: Farkas Klaudia, Herszényi László, Banai János','2020-03-06 09:30:00','2020-03-06 11:00:00',1,0,2),(3,3,NULL,3,NULL,'Kávészünet',NULL,NULL,'2020-03-06 11:00:00','2020-03-06 11:30:00',1,0,2),(4,3,NULL,4,NULL,'Ferring szimpózium',NULL,'Üléselnök: Miheller Pál','2020-03-06 11:30:00','2020-03-06 12:00:00',1,0,2),(5,3,NULL,5,NULL,'Takeda szimpózium',NULL,'Moderátor: Palatka Károly','2020-03-06 12:00:00','2020-03-06 12:30:00',1,0,2),(6,3,NULL,6,NULL,'Ebédszünet',NULL,NULL,'2020-03-06 12:30:00','2020-03-06 13:30:00',1,0,2),(7,3,NULL,7,NULL,'KOLONOSZKÓPIA A NAPI RUTINTÓL A SIKERÉLMÉNYIG',NULL,'Üléselnök: Miheller Pál, Gurzó Zoltán','2020-03-06 13:30:00','2020-03-06 15:00:00',1,0,2),(8,3,NULL,8,NULL,'Kávészünet',NULL,NULL,'2020-03-06 15:30:00','2020-03-06 16:00:00',1,0,2),(9,3,NULL,9,NULL,'PRÓNAY EMLÉKELŐADÁS',NULL,'Novák János','2020-03-06 16:00:00','2020-03-06 16:45:00',1,0,2),(10,3,NULL,10,NULL,'Közgyűlés',NULL,'.','2020-03-06 16:45:00','2020-03-06 17:15:00',1,0,2),(11,3,NULL,11,NULL,'Takeda szimpózium – Percepció és valóság',NULL,'Üléselnök: Kristóf Tünde, Müllner Katalin','2020-03-06 17:15:00','2020-03-06 17:45:00',1,0,2),(12,3,NULL,12,NULL,'Fresenius szimpózium - Fenntartható anti-TNF-alfa kezelés gyulladásos bélbetegségekben',NULL,'Üléselnök: Molnár Tamás','2020-03-06 17:45:00','2020-03-06 18:15:00',1,0,2),(13,3,NULL,13,NULL,'Szabadon bejelentett előadások',NULL,'Üléselnök: Orosz Péter, Szamosi Tamás','2020-03-07 08:30:00','2020-03-07 10:00:00',1,0,2),(15,3,NULL,15,NULL,'ALSÓ TÁPCSATORNAI BETEGSÉGEK ÉS BEAVATKOZÁSOK SZÖVŐDMÉNYEI',NULL,'Üléselnök: Sarlós Patrícia, Kristóf Tünde, Altorjay István','2020-03-07 10:00:00','2020-03-07 11:30:00',1,0,2),(16,3,NULL,16,NULL,'Kávészünet',NULL,NULL,'2020-03-07 11:30:00','2020-03-07 12:00:00',1,0,2),(17,3,NULL,17,NULL,'Phytotec szimpózium',NULL,'Üléselnök: Varga Márta','2020-03-07 12:00:00','2020-03-07 12:30:00',1,0,2),(18,3,NULL,18,NULL,'Tesztírás, konferencia zárása',NULL,NULL,'2020-03-07 13:45:00','2020-03-07 14:00:00',1,0,2),(19,3,NULL,19,NULL,'Ebéd',NULL,NULL,'2020-03-07 14:00:00','2020-03-07 15:00:00',1,0,2),(20,3,NULL,20,NULL,'AZ IBD BIOLÓGIAI TERÁPIÁJÁNAK LEGÚJABB FINANSZÍROZÁSI PROTOKOLLJA',NULL,'Molnár Tamás','2020-03-07 13:00:00','2020-03-07 13:30:00',1,0,2),(21,3,NULL,21,NULL,'A 2020. ÉVI ÚJSZÁSZY DÍJ ÁTADÁSA',NULL,NULL,'2020-03-07 13:30:00','2020-03-07 13:45:00',1,0,2),(22,3,NULL,22,NULL,'Hibák és buktatók a vastagbélrákszűrő programban – gyakorlati útmutató',NULL,'Szepes Zoltán','2020-03-06 15:00:00','2020-03-06 15:15:00',1,0,2),(23,3,NULL,23,NULL,'CRC szűrési stratégia Kanadában',NULL,'Lakatos Péter László','2020-03-06 15:15:00','2020-03-06 15:30:00',1,0,2),(24,4,NULL,24,NULL,'Skill I. - Szeptikus láb sebészete',NULL,'Moderátor: Mező Róbert','2020-03-27 09:00:00','2020-03-27 12:00:00',1,0,2),(25,4,NULL,25,NULL,'Skill II. - Laparoscopos training',NULL,'Moderátor: Szabó Zoltán','2020-03-27 09:00:00','2020-03-27 12:00:00',1,0,2),(26,4,NULL,26,NULL,'Skill III. - Stomaterápia',NULL,'Moderátor: Bercsényi Anna, Kákonyiné Katalin','2020-03-27 09:00:00','2020-03-27 12:00:00',1,0,2),(27,4,NULL,27,NULL,'Sebfertőzések',NULL,'Üléselnök:','2020-03-27 14:15:00','2020-03-27 15:45:00',1,0,2),(28,4,NULL,28,NULL,'Megnyitó, köszöntő',NULL,NULL,'2020-03-27 14:00:00','2020-03-27 14:15:00',1,0,2),(29,4,NULL,29,NULL,'Ebédszünet',NULL,NULL,'2020-03-27 12:00:00','2020-03-27 14:00:00',1,0,2),(30,4,NULL,30,NULL,'Interaktív esetbemutatások (7+3 perc)',NULL,'Üléselnök:','2020-03-27 16:10:00','2020-03-27 18:10:00',1,0,2),(31,4,NULL,31,NULL,'Konszenzus konferenciák sebészi vonatkozásainak diszkussziója',NULL,'Szijártó Attila, Győry Ferenc','2020-03-28 10:00:00','2020-03-28 11:30:00',1,0,2),(32,4,NULL,32,NULL,'A végbélrák minimálisan invazív kezelési lehetőségei',NULL,'Üléselnök:','2020-03-28 13:00:00','2020-03-28 15:30:00',1,0,2),(33,4,NULL,33,NULL,'A nyelőcső és cardiat motilitászavarainak gasztroenterológiai és sebészi vonatkozásai',NULL,'Üléselnök:','2020-03-29 09:00:00','2020-03-29 11:00:00',1,0,2),(34,4,NULL,34,NULL,'Regisztráció',NULL,NULL,'2020-03-27 08:30:00','2020-03-27 18:00:00',1,0,2),(35,4,NULL,35,NULL,'Regisztráció',NULL,NULL,'2020-03-28 08:30:00','2020-03-28 18:00:00',1,0,2),(36,4,NULL,36,NULL,'Regisztráció',NULL,NULL,'2020-03-29 08:30:00','2020-03-29 12:00:00',1,0,2),(37,4,NULL,37,NULL,'Poszter szekció',NULL,'Moderátor:','2020-03-27 18:20:00','2020-03-27 19:20:00',1,0,2),(38,4,NULL,38,NULL,'Interaktív esetbemutatások (7+3 perc)',NULL,NULL,'2020-03-28 16:00:00','2020-03-28 18:00:00',1,0,2),(39,4,NULL,39,NULL,'Poszter szekció',NULL,'Moderátor:','2020-03-28 18:10:00','2020-03-28 19:10:00',1,0,2),(40,4,NULL,40,NULL,'Interaktív esetbemutatások (7+3 perc)',NULL,'Üléselnök:','2020-03-29 11:30:00','2020-03-29 13:10:00',1,0,2),(41,4,NULL,41,NULL,'Műtősasszisztensi szekció',NULL,'Üléselnök:','2020-03-28 09:00:00','2020-03-28 10:00:00',1,0,2),(42,4,NULL,42,NULL,'Ebédszünet',NULL,NULL,'2020-03-28 12:00:00','2020-03-28 13:00:00',1,0,2),(43,4,NULL,43,NULL,'Tesztírás, konferencia zárása',NULL,NULL,'2020-03-29 13:10:00','2020-03-29 13:30:00',1,0,2),(44,4,NULL,44,NULL,'Ebéd',NULL,NULL,'2020-03-29 13:30:00','2020-03-29 14:30:00',1,0,2),(45,3,NULL,45,NULL,'Janssen szimpózium',NULL,'Üléselnök: Kristóf Tünde','2020-03-07 12:30:00','2020-03-07 13:00:00',1,0,2),(46,4,NULL,46,NULL,'Skill IV. - Prevenció és Infekciókontroll innovatív megoldásai (műtéti beavatkozás ideje alatt és azt követően)',NULL,'Moderátor: Dr. Pécsi Örs Dániel (Sopron)','2020-03-27 09:00:00','2020-03-27 12:00:00',1,0,2);

--
-- Table structure for table `PresentationType`
--

CREATE TABLE `PresentationType` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `PresentationType`
--

INSERT INTO `PresentationType` VALUES (1,'Szóbeli prezentáció'),(2,'Poszter');

--
-- Table structure for table `PurchaseOrder`
--

CREATE TABLE `PurchaseOrder` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `customer_id` int(11) DEFAULT NULL,
  `reference_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `date` date NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_AA004F119395C3F3` (`customer_id`),
  CONSTRAINT `FK_AA004F119395C3F3` FOREIGN KEY (`customer_id`) REFERENCES `Customer` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `PurchaseOrder`
--


--
-- Table structure for table `Quiz`
--

CREATE TABLE `Quiz` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `event_id` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8_unicode_ci,
  `minutes` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_42055AC71F7E88B` (`event_id`),
  CONSTRAINT `FK_42055AC71F7E88B` FOREIGN KEY (`event_id`) REFERENCES `Event` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Quiz`
--


--
-- Table structure for table `QuizAnswer`
--

CREATE TABLE `QuizAnswer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `question_id` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `is_correct` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_E467D9DF1E27F6BF` (`question_id`),
  CONSTRAINT `FK_E467D9DF1E27F6BF` FOREIGN KEY (`question_id`) REFERENCES `QuizQuestion` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `QuizAnswer`
--


--
-- Table structure for table `QuizQuestion`
--

CREATE TABLE `QuizQuestion` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `quiz_id` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_31A2BC3D853CD175` (`quiz_id`),
  CONSTRAINT `FK_31A2BC3D853CD175` FOREIGN KEY (`quiz_id`) REFERENCES `Quiz` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `QuizQuestion`
--


--
-- Table structure for table `QuizResult`
--

CREATE TABLE `QuizResult` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `identification` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `result` longtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `QuizResult`
--


--
-- Table structure for table `RegistrantType`
--

CREATE TABLE `RegistrantType` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=98 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `RegistrantType`
--

INSERT INTO `RegistrantType` VALUES (1,'ESPGHAN members'),(2,'Non members'),(3,'Orvos'),(4,'Szakdolgozó, asszisztens'),(5,'Cégképviselő'),(6,'Napijegy'),(7,'Orvostanhallgató (hallgatói jogviszony igazolása esetén)'),(8,'Nyugdíjas'),(9,'FISESZ tag (40 év alatti)'),(10,'FISESZ pártoló tag (40 év feletti)'),(11,'Nem tag'),(12,'Kiállító'),(13,'FIGAMU tag (40 év alatti)'),(14,'FIGAMU pártoló tag (40 év feletti)'),(15,'MAGYOT tag'),(17,'Szakdolgozó'),(18,'MGYT Tag - 35 év alatt'),(19,'MGYT Tag - 35 év felett'),(20,'Nem MGYT Tag'),(22,'Rezidens'),(23,'Szakdolgozó'),(24,'MGYGT tag (befizetett tagdíj esetén)'),(25,'Nem MGYGT tag'),(26,'Nappali PhD hallgató (hallgatói jogviszony igazolása esetén)'),(27,'Orvos MMTT tag'),(28,'Orvos nem MMTT tag'),(29,'Gyógyszerész'),(30,'Dietetikus'),(31,'Asszisztens'),(32,'Kísérő'),(33,'Hivatásukat nem gyakorló nyugdíjasok'),(34,'35 év alatti orvos'),(35,'35 év feletti orvos'),(36,'Diplomás MST tag'),(37,'35 év alatti Diplomás MST tag'),(38,'Asszisztens MST tag'),(40,'Gasztroenterológus szakorvos jelölt'),(41,'Endoszkópos szakasszisztens'),(42,'Előadó'),(43,'Vezetőségi tag'),(44,'Registration fee'),(45,'Reduced registration fee for members of MGT, MGYT, and medical assistants'),(46,'Registration fee for members of HUPIR'),(49,'Egyéni regisztráció'),(50,'Közszférában dolgozók részére  (nem META tag) 2 napos regisztráció'),(51,'Közszférában dolgozók részére  (META tag) 2 napos regisztráció'),(52,'Versenyszférában dolgozók részére  (nem META tag) 2 napos regisztráció'),(53,'Nappali tagozatos egyetemisták részére  (nem META tag) 2 napos regisztráció'),(54,'Nappali tagozatos egyetemisták részére  (META tag) 2 napos regisztráció'),(55,'Közszférában dolgozók részére  (nem META tag) 1 napos regisztráció (2018.05.09.)'),(56,'Közszférában dolgozók részére  (nem META tag) 1 napos regisztráció (2018.05.10.)'),(57,'Közszférában dolgozók részére  (META tag) 1 napos regisztráció (2018.05.09.)'),(58,'Közszférában dolgozók részére  (META tag) 1 napos regisztráció (2018.05.10.)'),(59,'Versenyszférában dolgozók részére  (nem META tag) 1 napos regisztráció (2018.05.09.)'),(60,'Versenyszférában dolgozók részére  (nem META tag) 1 napos regisztráció (2018.05.10.)'),(61,'Nappali tagozatos egyetemisták részére  (nem META tag) 1 napos regisztráció (2018.05.09.)'),(62,'Nappali tagozatos egyetemisták részére  (nem META tag) 1 napos regisztráció (2018.05.10.)'),(63,'Nappali tagozatos egyetemisták részére  (META tag) 1 napos regisztráció (2018.05.09.)'),(64,'Nappali tagozatos egyetemisták részére  (META tag) 1 napos regisztráció (2018.05.10.)'),(65,'Versenyszférában dolgozók részére  (META tag) 2 napos regisztráció'),(66,'Versenyszférában dolgozók részére  (META tag) 1 napos regisztráció (2018.05.09.)'),(67,'Versenyszférában dolgozók részére  (META tag) 1 napos regisztráció (2018.05.10.)'),(68,'Napijegy - 2018. május 17.'),(69,'Nem MGYT Tag - 35 év alatt'),(70,'Nem MGYT Tag - 35 év felett'),(71,'Részvételi díj'),(72,'Díjmentes regisztráció'),(74,'30 év alatti orvos - díjmentes regisztráció'),(75,'Napi regisztráció (2020. január 31.)'),(76,'Napi regisztráció (2020. február 1.)'),(77,'Közszférában dolgozók részére  (nem META tag)'),(78,'Közszférában dolgozók részére  (META tag)'),(79,'Versenyszférában dolgozók részére  (nem META tag)'),(80,'Versenyszférában dolgozók részére  (META tag)'),(81,'Nappali tagozatos egyetemisták részére  (META tag)'),(82,'Nappali tagozatos egyetemisták részére  (nem META tag)'),(83,'Nyugdíjasok részére (nem META tag)'),(84,'Nyugdíjasok részére (META tag)'),(85,'HGYE tag*'),(86,'nem HGYE tag'),(87,'Rezidens/szakorvos jelölt'),(88,'Védőnő'),(89,'Felkért előadó'),(90,'Medical student'),(91,'AEPC junior member'),(92,'AEPC member'),(93,'non AEPC member'),(94,'Egyedi kedvezményes regisztráció'),(95,'Faculty member'),(96,'Regisztráció'),(97,'Colon Szekció tag');

--
-- Table structure for table `RegistrantTypeEvent`
--

CREATE TABLE `RegistrantTypeEvent` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `registranttype_id` int(11) DEFAULT NULL,
  `event_id` int(11) DEFAULT NULL,
  `price_before` int(11) NOT NULL,
  `price_after` int(11) NOT NULL,
  `price_included_dining` int(11) NOT NULL,
  `position` int(11) NOT NULL,
  `need_membership` tinyint(1) NOT NULL,
  `hidden` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_208AE2559D497D04` (`registranttype_id`),
  KEY `IDX_208AE25571F7E88B` (`event_id`),
  CONSTRAINT `FK_208AE25571F7E88B` FOREIGN KEY (`event_id`) REFERENCES `Event` (`id`),
  CONSTRAINT `FK_208AE2559D497D04` FOREIGN KEY (`registranttype_id`) REFERENCES `RegistrantType` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `RegistrantTypeEvent`
--

INSERT INTO `RegistrantTypeEvent` VALUES (1,96,1,30000,30000,2000,1,0,0),(2,96,2,30000,30000,2000,1,0,0),(3,97,3,30000,35000,7600,1,0,0),(4,11,3,35000,40000,7600,2,0,0),(5,5,3,35000,40000,7600,3,0,0),(6,4,3,25000,30000,7600,4,0,0),(7,6,3,20000,20000,0,5,0,0),(8,7,3,0,0,0,6,0,0),(9,33,3,0,0,0,7,0,0),(10,9,4,0,8000,1350,1,0,0),(11,10,4,8000,12000,1350,2,0,0),(12,11,4,15000,18000,1350,3,0,0),(13,5,4,18000,23000,1350,4,0,0),(14,4,4,0,0,0,5,0,0),(15,7,4,0,0,0,6,0,0),(16,33,4,0,0,0,7,0,0),(17,13,5,0,8000,1350,1,0,0),(18,14,5,8000,12000,1350,2,0,0),(19,11,5,15000,18000,1350,3,0,0),(20,5,5,18000,23000,1350,4,0,0),(21,4,5,0,0,0,5,0,0),(22,7,5,0,0,0,6,0,0),(23,33,5,0,0,0,7,0,0),(24,72,5,0,0,0,8,0,1),(25,72,3,0,0,0,8,0,1),(26,72,4,0,0,0,8,0,1),(27,27,6,20000,25000,0,1,0,0),(28,28,6,25000,30000,0,2,0,0),(29,29,6,20000,25000,0,3,0,0),(30,30,6,15000,20000,0,4,0,0),(31,4,6,15000,20000,0,5,0,0),(32,5,6,25000,30000,0,6,0,0),(33,32,6,15000,15000,0,7,0,0),(34,6,6,15000,15000,0,8,0,0),(35,7,6,0,0,0,9,0,0);

--
-- Table structure for table `Room`
--

CREATE TABLE `Room` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `event_id` int(11) DEFAULT NULL,
  `roomtype_id` int(11) DEFAULT NULL,
  `accomodation_id` int(11) DEFAULT NULL,
  `price` double NOT NULL,
  `extra_price` double DEFAULT NULL,
  `number_of_beds` int(11) NOT NULL,
  `total_number` int(11) NOT NULL,
  `price_included_dining` int(11) NOT NULL,
  `status` tinyint(1) NOT NULL,
  `hidden` tinyint(1) NOT NULL,
  `breakfastType_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_D2ADFEA571F7E88B` (`event_id`),
  KEY `IDX_D2ADFEA57D31ADD1` (`roomtype_id`),
  KEY `IDX_D2ADFEA58EB69B2B` (`breakfastType_id`),
  KEY `IDX_D2ADFEA5FD70509C` (`accomodation_id`),
  CONSTRAINT `FK_D2ADFEA571F7E88B` FOREIGN KEY (`event_id`) REFERENCES `Event` (`id`),
  CONSTRAINT `FK_D2ADFEA57D31ADD1` FOREIGN KEY (`roomtype_id`) REFERENCES `RoomType` (`id`),
  CONSTRAINT `FK_D2ADFEA58EB69B2B` FOREIGN KEY (`breakfastType_id`) REFERENCES `BreakfastType` (`id`),
  CONSTRAINT `FK_D2ADFEA5FD70509C` FOREIGN KEY (`accomodation_id`) REFERENCES `Accomodation` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Room`
--

INSERT INTO `Room` VALUES (1,1,11,92,27000,0,1,100,0,1,0,NULL),(2,1,12,92,19000,0,2,100,0,1,0,NULL),(3,2,11,1,26000,0,1,100,0,1,0,NULL),(4,2,12,1,16000,0,2,100,0,1,0,NULL),(5,3,11,57,27000,NULL,1,10,0,1,0,NULL),(6,3,12,57,18000,NULL,2,10,0,1,0,NULL),(7,4,9,24,31000,NULL,1,15,7600,1,0,NULL),(8,4,10,24,23000,NULL,2,10,7600,1,0,NULL),(9,4,9,11,27000,NULL,1,1,7600,1,0,NULL),(10,4,10,11,21000,NULL,2,1,7600,1,0,NULL),(11,4,9,12,28500,NULL,1,1,7600,1,0,NULL),(12,4,10,12,23000,NULL,2,1,7600,1,0,NULL),(13,4,9,68,31000,NULL,1,3,7600,1,0,NULL),(14,4,10,68,24000,NULL,2,3,7600,1,0,NULL),(15,4,10,49,24000,NULL,0,0,7600,1,0,NULL),(16,5,9,24,31000,NULL,1,10,7600,1,0,NULL),(17,5,10,24,23000,NULL,2,10,7600,1,0,NULL),(18,5,9,11,27000,NULL,1,1,7600,1,0,NULL),(19,5,10,11,21000,NULL,2,1,7600,1,0,NULL),(20,5,9,12,28500,NULL,1,1,7600,1,0,NULL),(21,5,10,12,23000,NULL,2,1,7600,1,0,NULL),(22,5,9,41,25000,NULL,1,1,7600,1,0,NULL),(23,5,10,41,19000,NULL,2,1,7600,1,0,NULL),(24,5,10,49,24000,NULL,0,0,7600,1,0,NULL),(25,6,9,57,33500,0,1,0,0,1,0,NULL),(26,6,10,57,22500,0,2,0,0,1,0,NULL);

--
-- Table structure for table `RoomMate`
--

CREATE TABLE `RoomMate` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `roomReservation_id` int(11) DEFAULT NULL,
  `eventRegistration_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_C13F117FB3B61FF7` (`roomReservation_id`),
  UNIQUE KEY `UNIQ_C13F117F8C55A21` (`eventRegistration_id`),
  CONSTRAINT `FK_C13F117F8C55A21` FOREIGN KEY (`eventRegistration_id`) REFERENCES `EventRegistration` (`id`),
  CONSTRAINT `FK_C13F117FB3B61FF7` FOREIGN KEY (`roomReservation_id`) REFERENCES `RoomReservation` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `RoomMate`
--


--
-- Table structure for table `RoomReservation`
--

CREATE TABLE `RoomReservation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `room_id` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `persons` smallint(6) DEFAULT NULL,
  `check_in` date DEFAULT NULL,
  `check_out` date DEFAULT NULL,
  `roommate` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `hidden` tinyint(1) NOT NULL,
  `eventRegistration_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_1B2878788C55A21` (`eventRegistration_id`),
  KEY `IDX_1B28787854177093` (`room_id`),
  KEY `IDX_1B287878727ACA70` (`parent_id`),
  CONSTRAINT `FK_1B28787854177093` FOREIGN KEY (`room_id`) REFERENCES `Room` (`id`),
  CONSTRAINT `FK_1B287878727ACA70` FOREIGN KEY (`parent_id`) REFERENCES `RoomReservation` (`id`),
  CONSTRAINT `FK_1B2878788C55A21` FOREIGN KEY (`eventRegistration_id`) REFERENCES `EventRegistration` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=694 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `RoomReservation`
--

INSERT INTO `RoomReservation` VALUES (1,1,NULL,1,'2019-11-08','2019-11-09',NULL,0,1),(2,1,NULL,1,'2019-11-08','2019-11-09',NULL,0,2),(3,1,NULL,1,'2019-11-08','2019-11-09',NULL,0,3),(4,1,NULL,1,'2019-11-08','2019-11-09',NULL,0,4),(5,3,NULL,1,'2019-11-15','2019-11-16',NULL,0,5),(6,NULL,NULL,1,'2019-11-15','2019-11-16',NULL,0,6),(7,NULL,NULL,1,'2019-11-15','2019-11-16',NULL,0,7),(8,4,NULL,1,'2019-11-15','2019-11-16',NULL,0,8),(9,3,NULL,1,'2019-11-15','2019-11-16',NULL,0,9),(10,6,NULL,1,'2020-03-06','2020-03-07','jxg hkfdh',0,10),(11,5,NULL,1,'2020-03-05','2020-03-07',NULL,0,11),(12,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,12),(13,17,NULL,1,'2020-03-27','2020-03-29',NULL,0,13),(14,24,NULL,1,'2020-03-27','2020-03-29',NULL,0,14),(15,16,NULL,1,'2020-03-27','2020-03-29','Nincs',0,15),(16,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,16),(17,NULL,NULL,1,NULL,NULL,'Nincs',0,17),(18,14,NULL,1,'2020-03-27','2020-03-29','jhkk',0,18),(19,6,37,1,'2020-03-06','2020-03-07','Both Katalin',0,19),(20,17,NULL,1,'2020-03-27','2020-03-29','Dr. Papp Veronika',0,20),(21,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,21),(22,17,NULL,1,'2020-03-27','2020-03-28','Balogh Erika',0,22),(23,17,NULL,1,'2020-03-27','2020-03-28','Dudlák Melinda',0,23),(24,17,22,1,'2020-03-27','2020-03-28','Simoradik Gyöngyi',0,24),(25,16,NULL,1,'2020-03-27','2020-03-28',NULL,0,25),(26,16,NULL,1,'2020-03-27','2020-03-28',NULL,0,26),(27,16,NULL,1,'2020-03-27','2020-03-28',NULL,0,27),(28,NULL,NULL,0,NULL,NULL,NULL,0,28),(29,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,29),(30,NULL,NULL,1,'2020-03-06','2020-03-07',NULL,0,30),(31,NULL,NULL,1,'2020-03-06','2020-03-07',NULL,0,31),(32,NULL,NULL,1,'2020-03-06','2020-03-07',NULL,0,32),(33,17,34,1,'2020-03-27','2020-03-29','Dr Franka János',0,33),(34,17,NULL,1,'2020-03-27','2020-03-29','Dr. Csontos Ágnes Anna',0,34),(35,NULL,NULL,1,'2020-03-06','2020-03-07',NULL,0,35),(36,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,36),(37,6,NULL,1,'2020-03-06','2020-03-07','Durst-Regős Zsanett',0,37),(38,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,38),(39,NULL,NULL,1,'2020-03-06','2020-03-07',NULL,0,39),(40,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,40),(41,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,41),(42,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,42),(43,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,43),(44,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,44),(45,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,45),(46,17,47,1,'2020-03-27','2020-03-29','Vági Orsolya',0,46),(47,17,NULL,1,'2020-03-27','2020-03-29','dr. Domján Beatrix',0,47),(48,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,48),(49,7,NULL,1,'2020-03-27','2020-03-29','-',0,49),(50,7,NULL,1,'2020-03-27','2020-03-29',NULL,0,50),(51,8,265,1,'2020-03-27','2020-03-29','Farkas Katalin',0,51),(52,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,52),(53,7,NULL,1,'2020-03-27','2020-03-29',NULL,0,53),(54,8,86,1,'2020-03-27','2020-03-29','Dr Kovács Éva Lilla',0,54),(55,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,55),(56,7,NULL,1,'2020-03-27','2020-03-29',NULL,0,56),(57,6,NULL,1,'2020-03-06','2020-03-07','Papp Csilla',0,57),(58,6,57,1,'2020-03-06','2020-03-07','Laki Krisztna',0,58),(59,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,59),(60,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,60),(61,9,NULL,1,'2020-03-27','2020-03-29',NULL,0,61),(62,6,NULL,1,'2020-03-06','2020-03-07','Dr.Demeter Pál-al egy szobában',0,62),(63,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,63),(64,6,NULL,1,'2020-03-06','2020-03-07','Dr.Demeter Pál-al egy szobában',0,64),(65,17,NULL,1,'2020-03-27','2020-03-29','Papp Csilla',0,65),(66,17,65,1,'2020-03-27','2020-03-29','Laki Krisztna',0,66),(67,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,67),(68,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,68),(69,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,69),(70,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,70),(71,7,NULL,1,'2020-03-27','2020-03-29',NULL,0,71),(72,7,NULL,1,'2020-03-27','2020-03-29',NULL,0,72),(73,17,NULL,1,'2020-03-27','2020-03-29',NULL,0,73),(74,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,74),(75,7,NULL,1,'2020-03-27','2020-03-29',NULL,0,75),(76,17,NULL,1,'2020-03-27','2020-03-29',NULL,0,76),(77,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,77),(78,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,78),(79,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,79),(80,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,80),(81,6,NULL,2,'2020-03-05','2020-03-07','Vad Ildikó /Késérő/   panorámás  szoba!!!',0,81),(82,NULL,NULL,1,'2020-03-06','2020-03-06',NULL,0,82),(83,5,NULL,1,'2020-03-05','2020-03-07',NULL,0,83),(84,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,84),(85,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,85),(86,8,NULL,1,'2020-03-27','2020-03-29','Dr. Varga Petra',0,86),(87,5,NULL,1,'2020-03-05','2020-03-07',NULL,0,87),(88,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,88),(89,7,NULL,1,'2020-03-27','2020-03-29',NULL,0,89),(90,6,NULL,1,'2020-03-05','2020-03-07','Svébis Márk',0,90),(91,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,91),(92,7,NULL,1,'2020-03-27','2020-03-28',NULL,0,92),(93,NULL,NULL,1,'2020-03-28','2020-03-28',NULL,0,93),(94,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,94),(95,17,NULL,1,'2020-03-27','2020-03-28',NULL,0,95),(96,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,96),(97,7,NULL,1,'2020-03-27','2020-03-29',NULL,0,97),(98,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,98),(99,6,241,1,'2020-03-05','2020-03-07','Mikó Alexandra',0,99),(100,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,100),(101,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,101),(102,7,NULL,1,'2020-03-27','2020-03-29',NULL,0,102),(103,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,103),(104,7,NULL,1,'2020-03-27','2020-03-29',NULL,0,104),(105,17,NULL,1,'2020-03-27','2020-03-29','Dr. Balogh Izolda',0,105),(106,17,105,1,'2020-03-27','2020-03-29','Dr. Sepsi Balázs',0,106),(107,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,107),(108,17,109,1,'2020-03-27','2020-03-29','Dr Virág Alexandra',0,108),(109,17,NULL,1,'2020-03-27','2020-03-29','Dr Suga Boglárka',0,109),(110,17,111,1,'2020-03-27','2020-03-29','Dr. Hajdu Helga',0,110),(111,17,NULL,1,'2020-03-27','2020-03-29','Dr Weiszenberger Orsolya',0,111),(112,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,112),(113,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,113),(114,7,NULL,1,'2020-03-27','2020-03-29',NULL,0,114),(115,7,NULL,1,'2020-03-27','2020-03-29',NULL,0,115),(116,7,NULL,1,'2020-03-27','2020-03-29',NULL,0,116),(117,7,NULL,1,'2020-03-27','2020-03-29',NULL,0,117),(118,6,NULL,1,'2020-03-05','2020-03-07','Udvarhelyi Gábor',0,118),(119,8,NULL,1,'2020-03-27','2020-03-28','Dr. Haulik László',0,119),(120,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,120),(121,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,121),(122,NULL,NULL,1,'2020-03-05','2020-03-07',NULL,0,122),(123,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,123),(124,11,NULL,1,'2020-03-27','2020-03-29',NULL,0,124),(125,6,NULL,1,'2020-03-05','2020-03-07','Szabó Csaba, pici baba - babakád, babaágy!',0,125),(126,8,NULL,1,'2020-03-27','2020-03-29','Dr. Soós Péter',0,126),(127,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,127),(128,8,126,1,'2020-03-27','2020-03-29','Dr. Halász Orsolya Bernadett',0,128),(129,NULL,NULL,1,'2020-03-06','2020-03-07',NULL,0,129),(130,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,130),(131,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,131),(132,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,132),(133,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,133),(134,9,NULL,1,'2020-03-27','2020-03-29',NULL,0,134),(135,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,135),(136,7,NULL,1,'2020-03-27','2020-03-29',NULL,0,136),(137,7,NULL,1,'2020-03-27','2020-03-29',NULL,0,137),(138,7,NULL,1,'2020-03-27','2020-03-29',NULL,0,138),(139,7,NULL,1,'2020-03-27','2020-03-29',NULL,0,139),(140,6,118,1,'2020-03-05','2020-03-07','Bényi Zoltán',0,140),(141,6,NULL,1,'2020-03-05','2020-03-07','Farkas Alexandra',0,141),(142,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,142),(143,7,NULL,1,'2020-03-27','2020-03-29',NULL,0,143),(144,17,NULL,1,'2020-03-27','2020-03-29',NULL,0,144),(145,17,NULL,1,'2020-03-27','2020-03-29','Pálinkás Dániel',0,145),(146,6,NULL,1,'2020-03-06','2020-03-08','Vakarcs Szilárd férj, Vakarcs Szabó Eszter gyermek',0,146),(147,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,147),(148,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,148),(149,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,149),(150,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,150),(151,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,151),(152,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,152),(153,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,153),(154,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,154),(155,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,155),(156,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,156),(157,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,157),(158,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,158),(159,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,159),(160,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,160),(161,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,161),(162,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,162),(163,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,163),(164,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,164),(165,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,165),(166,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,166),(167,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,167),(168,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,168),(169,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,169),(170,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,170),(171,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,171),(172,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,172),(173,8,NULL,1,'2020-03-27','2020-03-29','dr Tóth Gábor',0,173),(174,8,NULL,1,'2020-03-27','2020-03-29','Dr. Petrovics Laura',0,174),(175,8,NULL,1,'2020-03-27','2020-03-29','Tölgyes Tamás',0,175),(176,8,NULL,1,'2020-03-27','2020-03-29','Dr.  Csucska Máté',0,176),(177,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,177),(178,7,NULL,1,'2020-03-27','2020-03-29',NULL,0,178),(179,8,NULL,1,'2020-03-27','2020-03-29','Dr. Hardi Péter',0,179),(180,8,179,1,'2020-03-27','2020-03-29','Dr. Nagy Tibor',0,180),(181,8,NULL,1,'2020-03-27','2020-03-29','Márton-Vörös Katalin',0,181),(182,8,181,1,'2020-03-27','2020-03-29','Dr. Bognár Laura',0,182),(183,6,141,1,'2020-03-05','2020-03-07','Szántó Kata',0,183),(184,8,176,1,'2020-03-27','2020-03-29','Dr. Kovács Balázs',0,184),(185,8,174,1,'2020-03-27','2020-03-29','Dr. Sindler Lili',0,185),(186,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,186),(187,6,NULL,1,'2020-03-06','2020-03-07','Balogh Erika',0,187),(188,6,187,1,'2020-03-06','2020-03-07','Bíró Erika',0,188),(189,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,189),(190,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,190),(191,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,191),(192,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,192),(193,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,193),(194,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,194),(195,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,195),(196,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,196),(197,6,442,1,'2020-03-05','2020-03-07','Dr. Gönczi Lóránt (külön ágyas szoba lehetőség szerint)',0,197),(198,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,198),(199,8,NULL,1,'2020-03-27','2020-03-29','Pázmándy Ágnes',0,199),(200,8,199,1,'2020-03-27','2020-03-29','Telek Vivien',0,200),(201,7,NULL,1,'2020-03-27','2020-03-29',NULL,0,201),(202,7,NULL,1,'2020-03-27','2020-03-29',NULL,0,202),(203,5,NULL,1,'2020-03-05','2020-03-07','Nincs',0,203),(204,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,204),(205,7,NULL,1,'2020-03-27','2020-03-29',NULL,0,205),(206,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,206),(207,8,NULL,1,'2020-03-27','2020-03-29','Dr Bártfay Noémi',0,207),(208,5,NULL,1,'2020-03-05','2020-03-07',NULL,0,208),(209,7,NULL,1,'2020-03-27','2020-03-29',NULL,0,209),(210,16,NULL,1,'2020-03-27','2020-03-28',NULL,0,210),(211,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,211),(212,17,NULL,1,'2020-03-26','2020-03-28','Dr. Aszalós Szilvia',0,212),(213,17,212,1,'2020-03-26','2020-03-28','Dr. Csomor Krisztina',0,213),(214,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,214),(215,17,246,1,'2020-03-27','2020-03-29','Marosvölgyi Katalin',0,215),(216,7,NULL,1,'2020-03-27','2020-03-28',NULL,0,216),(217,6,NULL,1,'2020-03-05','2020-03-07','Dr.Lőrincz Csaba',0,217),(218,6,217,1,'2020-03-05','2020-03-07','Dr. Czompa Diána',0,218),(219,5,NULL,1,'2020-03-05','2020-03-07',NULL,0,219),(220,6,NULL,1,'2020-03-06','2020-03-07','Hamvas Menczel Zsuzsanna',0,220),(221,NULL,NULL,1,'2020-03-06','2020-03-07','Hamvas József',0,221),(222,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,222),(223,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,223),(224,7,NULL,1,'2020-03-27','2020-03-29',NULL,0,224),(225,7,NULL,1,'2020-03-27','2020-03-29',NULL,0,225),(226,7,NULL,1,'2020-03-27','2020-03-29',NULL,0,226),(227,7,NULL,1,'2020-03-27','2020-03-29',NULL,0,227),(228,7,NULL,1,'2020-03-27','2020-03-29',NULL,0,228),(229,7,NULL,1,'2020-03-27','2020-03-29',NULL,0,229),(230,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,230),(231,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,231),(232,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,232),(233,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,233),(234,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,234),(235,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,235),(236,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,236),(237,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,237),(238,7,NULL,1,'2020-03-27','2020-03-29',NULL,0,238),(239,7,NULL,1,'2020-03-27','2020-03-29',NULL,0,239),(240,17,NULL,1,'2020-03-27','2020-03-29','Dr. Szemes Kata',0,240),(241,6,NULL,1,'2020-03-05','2020-03-07','Dr. Szemes Kata',0,241),(242,7,NULL,1,'2020-03-27','2020-03-29',NULL,0,242),(243,8,NULL,1,'2020-03-27','2020-03-29','Németh Karolina',0,243),(244,8,243,1,'2020-03-27','2020-03-29','Végi Bernadett',0,244),(245,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,245),(246,17,NULL,1,'2020-03-28','2020-03-29','Ládi Ildikó',0,246),(247,17,145,1,'2020-03-27','2020-03-29','Orbán-Szilágyi Ákos',0,247),(248,7,NULL,1,'2020-03-27','2020-03-29',NULL,0,248),(249,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,249),(250,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,250),(251,7,NULL,1,'2020-03-27','2020-03-29',NULL,0,251),(252,13,NULL,1,'2020-03-27','2020-03-29',NULL,0,252),(253,17,NULL,1,'2020-03-27','2020-03-29',NULL,0,253),(254,17,NULL,1,'2020-03-26','2020-03-29','Bősze Zsófia',0,254),(255,8,327,1,'2020-03-27','2020-03-29','Jakabovics Adrienn',0,255),(256,8,NULL,1,'2020-03-27','2020-03-29',NULL,0,256),(257,8,NULL,1,'2020-03-27','2020-03-29',NULL,0,257),(258,8,NULL,1,'2020-03-27','2020-03-29','Később adnám meg.',0,258),(259,5,NULL,1,'2020-03-05','2020-03-07',NULL,0,259),(260,17,NULL,1,'2020-03-27','2020-03-29','Dr. Husz Annamária',0,260),(261,8,175,1,'2020-03-27','2020-03-29','Dr. Egyed Tamás',0,261),(262,17,NULL,1,'2020-03-27','2020-03-29','Dr. Lőrinczi Csaba',0,262),(263,17,262,1,'2020-03-27','2020-03-29','Dr. Czompa Diána',0,263),(264,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,264),(265,8,NULL,1,'2020-03-27','2020-03-29','Móga Natália',0,265),(266,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,266),(267,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,267),(268,9,NULL,1,'2020-03-27','2020-03-28',NULL,0,268),(269,9,NULL,1,'2020-03-27','2020-03-28',NULL,0,269),(270,8,NULL,1,'2020-03-27','2020-03-28','Ivicsics Erzsébet',0,270),(271,8,270,1,'2020-03-27','2020-03-28','Gál Nana',0,271),(272,17,NULL,1,'2020-03-27','2020-03-29','Dr. Tajti János',0,272),(273,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,273),(274,17,275,1,'2020-03-27','2020-03-29','Dr. Ivány Emese',0,274),(275,17,NULL,1,'2020-03-27','2020-03-29','Dr. Halász Réka Mária',0,275),(276,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,276),(277,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,277),(278,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,278),(279,8,NULL,1,'2020-03-27','2020-03-29','Kocsis Mónika',0,279),(280,7,NULL,1,'2020-03-27','2020-03-29',NULL,0,280),(281,8,279,1,'2020-03-27','2020-03-29','Kádár Afrodité',0,281),(282,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,282),(283,7,NULL,1,'2020-03-27','2020-03-29',NULL,0,283),(284,8,NULL,1,'2020-03-27','2020-03-29',NULL,0,284),(285,8,NULL,1,'2020-03-27','2020-03-29','Barok Bianka',0,285),(286,7,NULL,1,'2020-03-27','2020-03-29',NULL,0,286),(287,9,NULL,1,'2020-03-27','2020-03-29',NULL,0,287),(288,10,NULL,1,'2020-03-27','2020-03-29','Dr. Sajtos Viktor',0,288),(289,10,288,1,'2020-03-27','2020-03-29','Dr. Vas János',0,289),(290,7,NULL,1,'2020-03-27','2020-03-28','-',0,290),(291,7,NULL,1,'2020-03-27','2020-03-28','-',0,291),(292,7,NULL,1,'2020-03-27','2020-03-28','-',0,292),(293,7,NULL,1,'2020-03-28','2020-03-29','-',0,293),(294,7,NULL,1,'2020-03-28','2020-03-29','-',0,294),(295,7,NULL,1,'2020-03-27','2020-03-28','-',0,295),(296,7,NULL,1,'2020-03-27','2020-03-29','-',0,296),(297,7,NULL,1,'2020-03-27','2020-03-28',NULL,0,297),(298,8,NULL,1,'2020-03-27','2020-03-29','Dr Papp Anita',0,298),(299,8,NULL,1,'2020-03-27','2020-03-29','Dr. PeklinDamján',0,299),(300,5,NULL,1,'2020-03-05','2020-03-07','Dánielné Kocsis Éva',0,300),(301,8,413,1,'2020-03-27','2020-03-29','Németh Franciska',0,301),(302,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,302),(303,8,NULL,1,'2020-03-27','2020-03-29','Gorbay-Nagy Réka',0,303),(304,8,303,1,'2020-03-27','2020-03-29','Dr Vagács Tibor',0,304),(305,NULL,NULL,1,NULL,NULL,NULL,0,305),(306,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,306),(307,10,NULL,1,'2020-03-27','2020-03-29','Dr. Buzás András',0,307),(308,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,308),(309,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,309),(310,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,310),(311,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,311),(312,NULL,NULL,1,'2020-03-06','2020-03-07',NULL,0,312),(313,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,313),(314,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,314),(315,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,315),(316,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,316),(317,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,317),(318,9,NULL,1,'2020-03-27','2020-03-28',NULL,0,318),(319,9,NULL,1,'2020-03-27','2020-03-28',NULL,0,319),(320,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,320),(321,8,NULL,2,'2020-03-26','2020-03-29','feleség',0,321),(322,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,322),(323,9,NULL,1,'2020-03-27','2020-03-28',NULL,0,323),(324,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,324),(325,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,325),(326,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,326),(327,8,NULL,1,'2020-03-27','2020-03-29','Dr. Erlitz Luca',0,327),(328,10,330,1,'2020-03-27','2020-03-29','Dr. Szerencsés Csilla',0,328),(329,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,329),(330,10,NULL,1,'2020-03-27','2020-03-29','Dr. Szöllősi Barbara',0,330),(331,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,331),(332,10,NULL,1,'2020-03-27','2020-03-29','Dr. Szöllősi Barbara',0,332),(333,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,333),(334,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,334),(335,10,307,1,'2020-03-27','2020-03-29','Dr. Vas Márton Árpád',0,335),(336,10,NULL,1,'2020-03-27','2020-03-28','Csog Szende',0,336),(337,14,NULL,1,'2020-03-27','2020-03-29','Dr. Lakatos Lóránd László',0,337),(338,14,337,1,'2020-03-27','2020-03-29','Dr. Durczi Mihály Károly',0,338),(339,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,339),(340,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,340),(341,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,341),(342,12,NULL,1,'2020-03-27','2020-03-29','Lehet bárki',0,342),(343,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,343),(344,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,344),(345,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,345),(346,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,346),(347,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,347),(348,6,NULL,1,'2020-03-05','2020-03-07','Dr. Gellért-Cserháti Zsófia',0,348),(349,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,349),(350,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,350),(351,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,351),(352,15,NULL,1,'2020-03-27','2020-03-29','Veltiné',0,352),(353,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,353),(354,6,NULL,1,'2020-03-06','2020-03-07','Dr. Karácsony Tibor',0,354),(355,6,354,1,'2020-03-06','2020-03-07','Dr. Joó Judit',0,355),(356,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,356),(357,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,357),(358,NULL,NULL,1,NULL,NULL,NULL,0,358),(359,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,359),(360,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,360),(361,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,361),(362,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,362),(363,13,NULL,1,'2020-03-27','2020-03-29',NULL,0,363),(364,15,NULL,1,'2020-03-27','2020-03-29','Dr. Tóth Enikő',0,364),(365,13,NULL,1,'2020-03-27','2020-03-29',NULL,0,365),(366,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,366),(367,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,367),(368,9,NULL,1,'2020-03-27','2020-03-28','egyágyas szobát igénylünk a Monopolyban, amennyiben lehetséges',0,368),(369,5,NULL,1,'2020-03-05','2020-03-07',NULL,0,369),(370,5,NULL,1,'2020-03-06','2020-03-08','feleség, 3 fő gyermek',0,370),(371,5,NULL,1,'2020-03-05','2020-03-07',NULL,0,371),(372,5,NULL,1,'2020-03-05','2020-03-07',NULL,0,372),(373,11,NULL,1,'2020-03-27','2020-03-29',NULL,0,373),(374,NULL,NULL,1,'2020-03-06','2020-03-07',NULL,0,374),(375,11,NULL,1,'2020-03-27','2020-03-29',NULL,0,375),(376,11,NULL,1,'2020-03-27','2020-03-29',NULL,0,376),(377,7,NULL,1,'2020-03-27','2020-03-28',NULL,0,377),(378,7,NULL,1,'2020-03-27','2020-03-29',NULL,0,378),(379,5,NULL,1,'2020-03-05','2020-03-07',NULL,0,379),(380,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,380),(381,5,NULL,1,'2020-03-05','2020-03-07',NULL,0,381),(382,6,NULL,1,'2020-03-06','2020-03-07',NULL,0,382),(383,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,383),(384,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,384),(385,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,385),(386,5,NULL,1,'2020-03-04','2020-03-07',NULL,0,386),(387,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,387),(388,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,388),(389,5,NULL,1,'2020-03-05','2020-03-07',NULL,0,389),(390,5,NULL,1,'2020-03-05','2020-03-07',NULL,0,390),(391,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,391),(392,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,392),(393,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,393),(394,20,NULL,1,'2020-03-27','2020-03-29',NULL,0,394),(395,20,NULL,1,'2020-03-27','2020-03-29',NULL,0,395),(396,20,NULL,1,'2020-03-27','2020-03-29',NULL,0,396),(397,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,397),(398,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,398),(399,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,399),(400,14,NULL,1,'2020-03-27','2020-03-29','dr Kondér Fruzsina',0,400),(401,14,400,1,'2020-03-27','2020-03-29','dr Kulcsicka-Gut Judit',0,401),(402,18,NULL,1,'2020-03-27','2020-03-29',NULL,0,402),(403,18,NULL,1,'2020-03-27','2020-03-29',NULL,0,403),(404,20,NULL,1,'2020-03-27','2020-03-29',NULL,0,404),(405,19,NULL,1,'2020-03-27','2020-03-29','Dr. Dabi Ágnes',0,405),(406,19,405,1,'2020-03-27','2020-03-29','Dr. Bíró Ágnes',0,406),(407,18,NULL,1,'2020-03-27','2020-03-29',NULL,0,407),(408,18,NULL,1,'2020-03-27','2020-03-29',NULL,0,408),(409,18,NULL,1,'2020-03-27','2020-03-29',NULL,0,409),(410,18,NULL,1,'2020-03-27','2020-03-29',NULL,0,410),(411,5,NULL,1,'2020-03-05','2020-03-07',NULL,0,411),(412,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,412),(413,8,NULL,1,'2020-03-27','2020-03-29','Hevér Tímea',0,413),(414,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,414),(415,13,NULL,1,'2020-03-27','2020-03-29',NULL,0,415),(416,NULL,NULL,1,'2020-03-27','2020-03-29','Dr.Czeller Dániel',0,416),(417,13,NULL,1,'2020-03-27','2020-03-28',NULL,0,417),(418,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,418),(419,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,419),(420,NULL,NULL,1,'2020-03-06','2020-03-07',NULL,0,420),(421,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,421),(422,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,422),(423,20,NULL,1,'2020-03-27','2020-03-29',NULL,0,423),(424,12,NULL,1,'2020-03-27','2020-03-29',NULL,0,424),(425,22,NULL,1,'2020-03-27','2020-03-29',NULL,0,425),(426,22,NULL,1,'2020-03-27','2020-03-29',NULL,0,426),(427,5,NULL,1,'2020-03-05','2020-03-07',NULL,0,427),(428,5,NULL,1,'2020-03-05','2020-03-07',NULL,0,428),(429,5,NULL,1,'2020-03-05','2020-03-07',NULL,0,429),(430,13,NULL,1,'2020-03-27','2020-03-29',NULL,0,430),(431,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,431),(432,NULL,NULL,1,'2020-03-06','2020-03-07',NULL,0,432),(433,7,NULL,1,'2020-03-28','2020-03-29',NULL,0,433),(434,12,NULL,1,'2020-03-27','2020-03-29','Dr. Pallag Géza',0,434),(435,8,119,1,'2020-03-27','2020-03-28','Dr. Sárvári Katalin',0,435),(436,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,436),(437,6,NULL,1,'2020-03-06','2020-03-08','Dr. Martonos Éva',0,437),(438,5,NULL,1,'2020-03-05','2020-03-07',NULL,0,438),(439,5,NULL,1,'2020-03-05','2020-03-07',NULL,0,439),(440,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,440),(441,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,441),(442,6,NULL,1,'2020-03-06','2020-03-07','Liebe Rebeka',0,442),(443,5,NULL,1,'2020-03-05','2020-03-07',NULL,0,443),(444,5,NULL,1,'2020-03-05','2020-03-07',NULL,0,444),(445,5,NULL,1,'2020-03-05','2020-03-07',NULL,0,445),(446,5,NULL,1,'2020-03-05','2020-03-07',NULL,0,446),(447,5,NULL,1,'2020-03-05','2020-03-07',NULL,0,447),(448,5,NULL,1,'2020-03-05','2020-03-07',NULL,0,448),(449,5,NULL,1,'2020-03-05','2020-03-07',NULL,0,449),(450,5,NULL,1,'2020-03-05','2020-03-07',NULL,0,450),(451,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,451),(452,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,452),(453,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,453),(454,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,454),(455,12,NULL,2,'2020-03-27','2020-03-29','kísérő',0,455),(456,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,456),(457,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,457),(458,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,458),(459,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,459),(460,5,NULL,1,'2020-03-05','2020-03-07',NULL,0,460),(461,5,NULL,1,'2020-03-05','2020-03-07',NULL,0,461),(462,17,20,1,'2020-03-27','2020-03-29','Dr. Szatmári Réka',0,462),(463,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,463),(464,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,464),(465,12,NULL,1,'2020-03-27','2020-03-29','Dr.Szelle Bálint',0,465),(466,8,298,1,'2020-03-27','2020-03-29','Jencsik Józsefné',0,466),(467,9,NULL,1,'2020-03-27','2020-03-29',NULL,0,467),(468,9,NULL,1,'2020-03-27','2020-03-29',NULL,0,468),(469,23,NULL,1,'2020-03-27','2020-03-29',NULL,0,469),(470,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,470),(471,22,NULL,1,'2020-03-27','2020-03-29',NULL,0,471),(472,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,472),(473,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,473),(474,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,474),(475,23,NULL,1,'2020-03-27','2020-03-29','Bagdy Virág',0,475),(476,23,475,1,'2020-03-27','2020-03-29','Korom Nikoletta',0,476),(477,6,NULL,1,'2020-03-06','2020-03-07','Balogh József',0,477),(478,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,478),(479,22,NULL,1,'2020-03-27','2020-03-29','Dr. Bártfay Noémi',0,479),(480,NULL,NULL,1,'2020-03-06','2020-03-07',NULL,0,480),(481,NULL,NULL,1,'2020-03-06','2020-03-07',NULL,0,481),(482,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,482),(483,6,64,1,'2020-03-06','2020-03-07','Pelle Judit',0,483),(484,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,484),(485,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,485),(486,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,486),(487,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,487),(488,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,488),(489,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,489),(490,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,490),(491,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,491),(492,NULL,NULL,1,'2020-03-06','2020-03-07',NULL,0,492),(493,NULL,NULL,1,'2020-03-06','2020-03-07',NULL,0,493),(494,6,NULL,1,'2020-03-05','2020-03-07','Rizmayer Andrea',0,494),(495,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,495),(496,6,NULL,1,'2020-03-06','2020-03-07','lehet bárki',0,496),(497,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,497),(498,NULL,NULL,1,'2020-03-27','2020-03-29','Balasi Katalin',0,498),(499,NULL,NULL,1,'2020-03-27','2020-03-29','Henczné Varga Judit',0,499),(500,NULL,NULL,1,'2020-03-27','2020-03-28',NULL,0,500),(501,NULL,NULL,1,'2020-03-27','2020-03-28',NULL,0,501),(502,NULL,NULL,1,'2020-03-27','2020-03-28','Merényi Böbe',0,502),(503,NULL,NULL,1,'2020-03-27','2020-03-28','Sigér Gyuláné',0,503),(504,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,504),(505,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,505),(506,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,506),(507,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,507),(508,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,508),(509,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,509),(510,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,510),(511,8,512,1,'2020-03-27','2020-03-29','Kocsis Erika (Hunguest Hotel megbeszélés szerint)',0,511),(512,8,NULL,1,'2020-03-27','2020-03-29','Boros Rita',0,512),(513,8,514,1,'2020-03-27','2020-03-29','Farnas Csaba',0,513),(514,8,NULL,1,'2020-03-27','2020-03-29','Keszeg Csongor',0,514),(515,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,515),(516,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,516),(517,17,607,1,'2020-03-26','2020-03-29','Svébisné Lovász Barbara',0,517),(518,14,519,1,'2020-03-27','2020-03-28','Jeszenszky Ágnes',0,518),(519,14,NULL,1,'2020-03-27','2020-03-28','Baráth Katalin',0,519),(520,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,520),(521,5,NULL,1,'2020-03-05','2020-03-07',NULL,0,521),(522,NULL,NULL,1,'2020-03-06','2020-03-07',NULL,0,522),(523,NULL,NULL,1,'2020-03-06','2020-03-07',NULL,0,523),(524,NULL,NULL,1,'2020-03-06','2020-03-07',NULL,0,524),(525,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,525),(526,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,526),(527,NULL,NULL,1,'2020-03-27','2020-03-29','Dr Urbán Dániel Dr Seszták Gergő',0,527),(528,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,528),(529,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,529),(530,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,530),(531,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,531),(532,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,532),(533,7,NULL,1,'2020-03-28','2020-03-29',NULL,0,533),(534,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,534),(535,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,535),(536,6,NULL,1,'2020-03-06','2020-03-07',NULL,0,536),(537,NULL,NULL,1,'2020-03-27','2020-03-28',NULL,0,537),(538,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,538),(539,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,539),(540,5,NULL,1,'2020-03-04','2020-03-07',NULL,0,540),(541,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,541),(542,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,542),(543,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,543),(544,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,544),(545,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,545),(546,12,NULL,1,'2020-03-27','2020-03-29','Berncherer Gyöngyi',0,546),(547,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,547),(548,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,548),(549,5,NULL,1,'2020-03-05','2020-03-07',NULL,0,549),(550,6,437,1,'2020-03-06','2020-03-08','Dr. Gáll János',0,550),(551,NULL,NULL,1,'2020-03-06','2020-03-07',NULL,0,551),(552,6,NULL,1,'2020-03-06','2020-03-08','Dr. Károlyi Zsuzsánna',0,552),(553,6,NULL,1,'2020-03-06','2020-03-07','Pálinkás Krisztina',0,553),(554,6,553,1,'2020-03-06','2020-03-07','Varga Judit',0,554),(555,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,555),(556,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,556),(557,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,557),(558,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,558),(559,NULL,NULL,1,'2020-03-06','2020-03-07',NULL,0,559),(560,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,560),(561,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,561),(562,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,562),(563,5,NULL,1,'2020-03-05','2020-03-07',NULL,0,563),(564,5,NULL,1,'2020-03-05','2020-03-07',NULL,0,564),(565,5,NULL,1,'2020-03-05','2020-03-07',NULL,0,565),(566,22,NULL,1,'2020-03-27','2020-03-29',NULL,0,566),(567,NULL,NULL,1,NULL,NULL,NULL,0,567),(568,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,568),(569,NULL,NULL,1,NULL,NULL,NULL,0,569),(570,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,570),(571,NULL,NULL,1,NULL,NULL,NULL,0,571),(572,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,572),(573,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,573),(574,NULL,NULL,1,'2020-03-28','2020-03-29','Dr. Piedl Zita, Dr. Peleskei Kinga',0,574),(575,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,575),(576,16,NULL,1,'2020-03-27','2020-03-29',NULL,0,576),(577,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,577),(578,22,NULL,1,'2020-03-27','2020-03-29',NULL,0,578),(579,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,579),(580,16,NULL,1,'2020-03-28','2020-03-29',NULL,0,580),(581,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,581),(582,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,582),(583,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,583),(584,NULL,NULL,1,NULL,NULL,NULL,0,584),(585,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,585),(586,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,586),(587,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,587),(588,5,NULL,1,'2020-03-05','2020-03-07',NULL,0,588),(589,11,NULL,1,'2020-03-27','2020-03-29',NULL,0,589),(590,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,590),(591,6,NULL,1,'2020-03-06','2020-03-07','Dr. Fekete Csaba',0,591),(592,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,592),(593,NULL,NULL,1,'2020-03-06','2020-03-07',NULL,0,593),(594,NULL,NULL,1,'2020-03-06','2020-03-07','egyágyas',0,594),(595,7,NULL,1,'2020-03-26','2020-03-29',NULL,0,595),(596,6,NULL,1,'2020-03-06','2020-03-07',NULL,0,596),(597,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,597),(598,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,598),(599,17,23,1,'2020-03-27','2020-03-28','Bíró Erika',0,599),(600,17,NULL,1,'2020-03-27','2020-03-28','Széky Gabriella, Tóth Andrea',0,600),(601,17,NULL,1,'2020-03-27','2020-03-28','Vinczéné Oláh Judit, Tóth Andrea',0,601),(602,17,601,1,'2020-03-27','2020-03-28','Széky Gabriella, Vinczén Tóth Judit',0,602),(603,7,NULL,1,'2020-03-26','2020-03-29',NULL,0,603),(604,16,NULL,1,'2020-03-26','2020-03-29',NULL,0,604),(605,16,NULL,1,'2020-03-26','2020-03-29',NULL,0,605),(606,17,NULL,1,'2020-03-26','2020-03-29','feleség',0,606),(607,17,NULL,1,'2020-03-26','2020-03-29','Svébis Márk',0,607),(608,7,NULL,1,'2020-03-26','2020-03-29',NULL,0,608),(609,7,NULL,1,'2020-03-26','2020-03-29',NULL,0,609),(610,7,NULL,1,'2020-03-26','2020-03-29',NULL,0,610),(611,7,NULL,1,'2020-03-26','2020-03-29',NULL,0,611),(612,16,NULL,1,'2020-03-26','2020-03-29',NULL,0,612),(613,16,NULL,1,'2020-03-26','2020-03-29',NULL,0,613),(614,NULL,NULL,1,NULL,NULL,'Tajti Máté (FIGAMU)',0,614),(615,7,NULL,1,'2020-03-26','2020-03-29',NULL,0,615),(616,16,NULL,1,'2020-03-26','2020-03-29',NULL,0,616),(617,16,NULL,1,'2020-03-26','2020-03-29',NULL,0,617),(618,17,NULL,1,'2020-03-26','2020-03-29','Szabó Dorottya',0,618),(619,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,619),(620,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,620),(621,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,621),(622,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,622),(623,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,623),(624,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,624),(625,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,625),(626,NULL,NULL,1,'2020-03-06','2020-03-07',NULL,0,626),(627,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,627),(628,12,546,1,'2020-03-27','2020-03-29','Hamza Kinga',0,628),(629,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,629),(630,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,630),(631,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,631),(632,NULL,NULL,1,'2020-03-27','2020-03-29','Kecskés Szilvia',0,632),(633,NULL,NULL,1,'2020-03-27','2020-03-29','Dr.Sándor zsuzsanna',0,633),(634,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,634),(635,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,635),(636,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,636),(637,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,637),(638,5,NULL,1,'2020-03-06','2020-03-07','egyágyas szoba',0,638),(639,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,639),(640,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,640),(641,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,641),(642,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,642),(643,NULL,NULL,1,NULL,NULL,NULL,0,643),(644,NULL,NULL,1,NULL,NULL,NULL,0,644),(645,NULL,NULL,1,'2020-03-06','2020-03-07',NULL,0,645),(646,5,NULL,1,'2020-03-06','2020-03-07',NULL,0,646),(647,NULL,NULL,1,'2020-03-27','2020-03-29','Dr. Menyhárt Orsolya',0,647),(648,NULL,NULL,1,'2020-03-06','2020-03-07',NULL,0,648),(649,NULL,NULL,1,NULL,NULL,NULL,0,649),(650,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,650),(651,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,651),(652,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,652),(653,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,653),(654,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,654),(655,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,655),(656,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,656),(657,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,657),(658,NULL,NULL,1,'2020-03-27','2020-03-29','Varga Márton',0,658),(659,NULL,NULL,1,'2020-03-27','2020-03-29','Szabó Balázs Előd',0,659),(660,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,660),(661,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,661),(662,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,662),(663,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,663),(664,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,664),(665,NULL,NULL,1,'2020-03-06','2020-03-07',NULL,0,665),(666,NULL,NULL,1,'2020-03-06','2020-03-07',NULL,0,666),(667,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,667),(668,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,668),(669,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,669),(670,NULL,NULL,1,'2020-03-06','2020-03-07',NULL,0,670),(671,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,671),(672,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,672),(673,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,673),(674,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,674),(675,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,675),(676,NULL,NULL,1,'2020-03-27','2020-03-29','Dr. Levek Lili',0,676),(677,NULL,NULL,1,'2020-03-27','2020-03-29','Dr. Ferenczy Katalin',0,677),(678,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,678),(679,NULL,NULL,1,'2020-03-06','2020-03-07',NULL,0,679),(680,NULL,NULL,1,'2020-03-06','2020-03-07',NULL,0,680),(681,11,NULL,1,'2020-03-27','2020-03-29',NULL,0,681),(682,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,682),(683,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,683),(684,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,684),(685,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,685),(686,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,686),(687,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,687),(688,NULL,NULL,1,'2020-03-27','2020-03-29','PÁLINKÁS DÁNIEL',0,688),(689,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,689),(690,NULL,NULL,1,'2020-03-27','2020-03-29','FÁBIÁN ANNA',0,690),(691,NULL,NULL,1,'2020-03-27','2020-03-29','Dr. Caleb Ibitamuno',0,691),(692,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,692),(693,NULL,NULL,1,'2020-03-27','2020-03-29',NULL,0,693);

--
-- Table structure for table `RoomType`
--

CREATE TABLE `RoomType` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `RoomType`
--

INSERT INTO `RoomType` VALUES (1,'Single room'),(2,'Double room'),(3,'Apartman 2 fő részére'),(4,'Apartman 3 fő részére'),(5,'Lakosztály 2 fő részére'),(6,'Lakosztály 3 fő részére'),(7,'Lakosztály 4 fő részére'),(8,'Pótágy'),(9,'Egyágyas szoba félpanzióval'),(10,'Kétágyas szoba félpanzióval'),(11,'Egyágyas szoba reggelivel'),(12,'Kétágyas szoba reggelivel'),(13,'Kétágyas szoba  (két szobához 1 fürdő tartozik) '),(14,'Kétágyas szoba  (2 db emeletes ágy alsó szintjei)'),(15,'Négyágyas szoba  (szimpla ágyak)'),(16,'Egyágyas szoba'),(17,'Kétágyas szoba'),(18,'Háromágyas szoba'),(19,'Háromágyas szoba reggelivel'),(20,'Egyágyas szoba hideg, bővített kontinentális reggelivel'),(21,'Kétágyas szoba hideg, bővített kontinentális reggelivel'),(22,'Háromágyas szoba hideg, bővített kontinentális reggelivel'),(23,'Standard - Egyágyas szoba reggelivel'),(24,'Standard - Kétágyas szoba reggelivel'),(25,'Superior - Egyágyas szoba reggelivel'),(26,'Superior - Kétágyas szoba reggelivel'),(27,'Single room with breakfast'),(28,'Double room with breakfast'),(29,'Háromágyas szoba félpanzióval'),(30,'Egyágyas szoba reggelivel - Economy'),(31,'Kétágyas szoba reggelivel - Economy'),(32,'Egyágyas szoba reggelivel - Standard'),(33,'Kétágyas szoba reggelivel - Standard'),(34,'Parkolás'),(35,'Négyágyas bungalló reggelivel'),(36,'Prémium egyágyas szoba, reggelivel'),(37,'Prémium kétágyas szoba reggelivel'),(38,'Prémium egyágyas szoba reggelivel'),(39,'Prémium junior suit egyágyas reggelivel'),(40,'Prémium junior suit kétágyas reggelivel'),(41,'Kétágyas szoba + pótágy, reggelivel');

--
-- Table structure for table `TeamMember`
--

CREATE TABLE `TeamMember` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `phone` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TeamMember`
--

INSERT INTO `TeamMember` VALUES (1,'Veres Emese','emese.veres@ementin.hu','+36 20 419 9219'),(3,'Lupkovics Vanessa','vanessa.lupkovics@ementin.hu','+36 1 999 0784'),(4,'Tihanyi Barbara','barbara.tihanyi@timelessevent.hu','+36 20 419 8988'),(5,'Szabó Bernadett','bernadett.szabo@timelessevent.hu','+36 1 999 0781');

--
-- Table structure for table `Transfer`
--

CREATE TABLE `Transfer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `departure` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `eventRegistration_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_B942C1968C55A21` (`eventRegistration_id`),
  CONSTRAINT `FK_B942C1968C55A21` FOREIGN KEY (`eventRegistration_id`) REFERENCES `EventRegistration` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `Transfer`
--


--
-- Table structure for table `TransferEvent`
--

CREATE TABLE `TransferEvent` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `event_id` int(11) DEFAULT NULL,
  `price` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `departure` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `date` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_2CC1322F71F7E88B` (`event_id`),
  CONSTRAINT `FK_2CC1322F71F7E88B` FOREIGN KEY (`event_id`) REFERENCES `Event` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TransferEvent`
--


--
-- Table structure for table `TransferEventReservation`
--

CREATE TABLE `TransferEventReservation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `transfer_event_id` int(11) DEFAULT NULL,
  `eventRegistration_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_BC538F848C55A21` (`eventRegistration_id`),
  KEY `IDX_BC538F849046C5E1` (`transfer_event_id`),
  CONSTRAINT `FK_BC538F848C55A21` FOREIGN KEY (`eventRegistration_id`) REFERENCES `EventRegistration` (`id`),
  CONSTRAINT `FK_BC538F849046C5E1` FOREIGN KEY (`transfer_event_id`) REFERENCES `TransferEvent` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `TransferEventReservation`
--


--
-- Table structure for table `acl_classes`
--

CREATE TABLE `acl_classes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `class_type` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_69DD750638A36066` (`class_type`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `acl_classes`
--

INSERT INTO `acl_classes` VALUES (5,'Pixeloid\\AppBundle\\Entity\\Accomodation'),(2,'Pixeloid\\AppBundle\\Entity\\DiningType'),(1,'Pixeloid\\AppBundle\\Entity\\Event'),(10,'Pixeloid\\AppBundle\\Entity\\EventRegistration'),(9,'Pixeloid\\AppBundle\\Entity\\ExtraProgram'),(8,'Pixeloid\\AppBundle\\Entity\\ExtraProgramGroup'),(4,'Pixeloid\\AppBundle\\Entity\\Presentation'),(3,'Pixeloid\\AppBundle\\Entity\\PresentationSection'),(6,'Pixeloid\\AppBundle\\Entity\\RegistrantType'),(7,'Pixeloid\\AppBundle\\Entity\\TeamMember');

--
-- Table structure for table `acl_entries`
--

CREATE TABLE `acl_entries` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `class_id` int(10) unsigned NOT NULL,
  `object_identity_id` int(10) unsigned DEFAULT NULL,
  `security_identity_id` int(10) unsigned NOT NULL,
  `field_name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ace_order` smallint(5) unsigned NOT NULL,
  `mask` int(11) NOT NULL,
  `granting` tinyint(1) NOT NULL,
  `granting_strategy` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `audit_success` tinyint(1) NOT NULL,
  `audit_failure` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_46C8B806EA000B103D9AB4A64DEF17BCE4289BF4` (`class_id`,`object_identity_id`,`field_name`,`ace_order`),
  KEY `IDX_46C8B806EA000B103D9AB4A6DF9183C9` (`class_id`,`object_identity_id`,`security_identity_id`),
  KEY `IDX_46C8B806EA000B10` (`class_id`),
  KEY `IDX_46C8B8063D9AB4A6` (`object_identity_id`),
  KEY `IDX_46C8B806DF9183C9` (`security_identity_id`),
  CONSTRAINT `FK_46C8B8063D9AB4A6` FOREIGN KEY (`object_identity_id`) REFERENCES `acl_object_identities` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_46C8B806DF9183C9` FOREIGN KEY (`security_identity_id`) REFERENCES `acl_security_identities` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_46C8B806EA000B10` FOREIGN KEY (`class_id`) REFERENCES `acl_classes` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=219 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `acl_entries`
--

INSERT INTO `acl_entries` VALUES (1,1,NULL,1,NULL,0,64,1,'all',0,0),(2,1,NULL,2,NULL,1,32,1,'all',0,0),(3,1,NULL,3,NULL,2,4,1,'all',0,0),(4,1,NULL,4,NULL,3,1,1,'all',0,0),(5,1,1,5,NULL,1,128,1,'all',0,0),(6,2,NULL,6,NULL,0,64,1,'all',0,0),(7,2,NULL,7,NULL,1,32,1,'all',0,0),(8,2,NULL,8,NULL,2,4,1,'all',0,0),(9,2,NULL,9,NULL,3,1,1,'all',0,0),(10,2,2,10,NULL,0,128,1,'all',0,0),(11,1,3,10,NULL,1,128,1,'all',0,0),(12,3,NULL,11,NULL,0,64,1,'all',0,0),(13,3,NULL,12,NULL,1,32,1,'all',0,0),(14,3,NULL,13,NULL,2,4,1,'all',0,0),(15,3,NULL,14,NULL,3,1,1,'all',0,0),(16,3,4,10,NULL,1,128,1,'all',0,0),(17,3,5,10,NULL,1,128,1,'all',0,0),(18,4,NULL,15,NULL,0,64,1,'all',0,0),(19,4,NULL,16,NULL,1,32,1,'all',0,0),(20,4,NULL,17,NULL,2,4,1,'all',0,0),(21,4,NULL,18,NULL,3,1,1,'all',0,0),(22,4,6,10,NULL,1,128,1,'all',0,0),(23,4,7,10,NULL,1,128,1,'all',0,0),(24,4,8,10,NULL,1,128,1,'all',0,0),(25,3,9,10,NULL,1,128,1,'all',0,0),(26,3,10,10,NULL,1,128,1,'all',0,0),(27,4,11,10,NULL,1,128,1,'all',0,0),(28,4,12,10,NULL,1,128,1,'all',0,0),(29,4,13,10,NULL,1,128,1,'all',0,0),(30,4,14,10,NULL,1,128,1,'all',0,0),(31,1,1,19,NULL,0,128,1,'all',0,0),(32,5,NULL,20,NULL,0,64,1,'all',0,0),(33,5,NULL,21,NULL,1,32,1,'all',0,0),(34,5,NULL,22,NULL,2,4,1,'all',0,0),(35,5,NULL,23,NULL,3,1,1,'all',0,0),(36,5,15,19,NULL,0,128,1,'all',0,0),(37,6,NULL,24,NULL,0,64,1,'all',0,0),(38,6,NULL,25,NULL,1,32,1,'all',0,0),(39,6,NULL,26,NULL,2,4,1,'all',0,0),(40,6,NULL,27,NULL,3,1,1,'all',0,0),(41,6,16,19,NULL,0,128,1,'all',0,0),(42,1,3,19,NULL,0,128,1,'all',0,0),(43,7,NULL,28,NULL,0,64,1,'all',0,0),(44,7,NULL,29,NULL,1,32,1,'all',0,0),(45,7,NULL,30,NULL,2,4,1,'all',0,0),(46,7,NULL,31,NULL,3,1,1,'all',0,0),(47,7,17,19,NULL,0,128,1,'all',0,0),(48,7,18,19,NULL,0,128,1,'all',0,0),(49,1,19,19,NULL,0,128,1,'all',0,0),(50,6,20,19,NULL,0,128,1,'all',0,0),(51,3,4,19,NULL,0,128,1,'all',0,0),(52,3,5,19,NULL,0,128,1,'all',0,0),(53,3,9,19,NULL,0,128,1,'all',0,0),(54,3,10,19,NULL,0,128,1,'all',0,0),(55,3,21,19,NULL,0,128,1,'all',0,0),(56,3,22,19,NULL,0,128,1,'all',0,0),(57,3,23,19,NULL,0,128,1,'all',0,0),(58,3,24,19,NULL,0,128,1,'all',0,0),(59,3,25,19,NULL,0,128,1,'all',0,0),(60,3,26,19,NULL,0,128,1,'all',0,0),(61,3,27,19,NULL,0,128,1,'all',0,0),(62,3,28,19,NULL,0,128,1,'all',0,0),(63,3,29,19,NULL,0,128,1,'all',0,0),(64,3,30,19,NULL,0,128,1,'all',0,0),(65,3,31,19,NULL,0,128,1,'all',0,0),(66,3,32,19,NULL,0,128,1,'all',0,0),(67,3,33,19,NULL,0,128,1,'all',0,0),(68,3,34,19,NULL,0,128,1,'all',0,0),(69,3,35,19,NULL,0,128,1,'all',0,0),(70,4,6,19,NULL,0,128,1,'all',0,0),(71,4,7,19,NULL,0,128,1,'all',0,0),(72,4,8,19,NULL,0,128,1,'all',0,0),(73,4,11,19,NULL,0,128,1,'all',0,0),(74,4,12,19,NULL,0,128,1,'all',0,0),(75,4,13,19,NULL,0,128,1,'all',0,0),(76,4,14,19,NULL,0,128,1,'all',0,0),(77,4,36,19,NULL,0,128,1,'all',0,0),(78,4,37,19,NULL,0,128,1,'all',0,0),(79,4,38,19,NULL,0,128,1,'all',0,0),(80,4,39,19,NULL,0,128,1,'all',0,0),(81,4,40,19,NULL,0,128,1,'all',0,0),(82,4,41,19,NULL,0,128,1,'all',0,0),(83,4,42,19,NULL,0,128,1,'all',0,0),(84,4,43,19,NULL,0,128,1,'all',0,0),(85,4,44,19,NULL,0,128,1,'all',0,0),(86,4,45,19,NULL,0,128,1,'all',0,0),(87,4,46,19,NULL,0,128,1,'all',0,0),(88,4,47,19,NULL,0,128,1,'all',0,0),(89,4,48,19,NULL,0,128,1,'all',0,0),(90,4,49,19,NULL,0,128,1,'all',0,0),(91,4,50,19,NULL,0,128,1,'all',0,0),(92,4,51,19,NULL,0,128,1,'all',0,0),(93,4,52,19,NULL,0,128,1,'all',0,0),(94,4,53,19,NULL,0,128,1,'all',0,0),(95,4,54,19,NULL,0,128,1,'all',0,0),(96,3,55,19,NULL,0,128,1,'all',0,0),(97,3,56,19,NULL,0,128,1,'all',0,0),(98,3,57,19,NULL,0,128,1,'all',0,0),(99,3,58,19,NULL,0,128,1,'all',0,0),(100,1,59,19,NULL,0,128,1,'all',0,0),(101,1,60,19,NULL,0,128,1,'all',0,0),(102,8,NULL,32,NULL,0,64,1,'all',0,0),(103,8,NULL,33,NULL,1,32,1,'all',0,0),(104,8,NULL,34,NULL,2,4,1,'all',0,0),(105,8,NULL,35,NULL,3,1,1,'all',0,0),(106,8,61,19,NULL,0,128,1,'all',0,0),(107,9,NULL,36,NULL,0,64,1,'all',0,0),(108,9,NULL,37,NULL,1,32,1,'all',0,0),(109,9,NULL,38,NULL,2,4,1,'all',0,0),(110,9,NULL,39,NULL,3,1,1,'all',0,0),(111,9,62,19,NULL,0,128,1,'all',0,0),(112,8,63,19,NULL,0,128,1,'all',0,0),(113,9,64,19,NULL,0,128,1,'all',0,0),(114,9,65,19,NULL,0,128,1,'all',0,0),(115,9,66,19,NULL,0,128,1,'all',0,0),(116,3,67,19,NULL,0,128,1,'all',0,0),(117,3,68,19,NULL,0,128,1,'all',0,0),(118,3,69,19,NULL,0,128,1,'all',0,0),(119,3,70,19,NULL,0,128,1,'all',0,0),(120,3,71,19,NULL,0,128,1,'all',0,0),(121,3,72,19,NULL,0,128,1,'all',0,0),(122,3,73,19,NULL,0,128,1,'all',0,0),(123,3,74,19,NULL,0,128,1,'all',0,0),(124,3,75,19,NULL,0,128,1,'all',0,0),(125,3,76,19,NULL,0,128,1,'all',0,0),(126,4,77,19,NULL,0,128,1,'all',0,0),(127,4,78,19,NULL,0,128,1,'all',0,0),(128,4,79,19,NULL,0,128,1,'all',0,0),(129,4,80,19,NULL,0,128,1,'all',0,0),(130,4,81,19,NULL,0,128,1,'all',0,0),(131,4,82,19,NULL,0,128,1,'all',0,0),(132,4,83,19,NULL,0,128,1,'all',0,0),(133,4,84,19,NULL,0,128,1,'all',0,0),(134,4,85,19,NULL,0,128,1,'all',0,0),(135,4,86,19,NULL,0,128,1,'all',0,0),(136,4,87,19,NULL,0,128,1,'all',0,0),(137,4,88,19,NULL,0,128,1,'all',0,0),(138,4,89,19,NULL,0,128,1,'all',0,0),(139,4,90,19,NULL,0,128,1,'all',0,0),(140,4,91,19,NULL,0,128,1,'all',0,0),(141,4,92,19,NULL,0,128,1,'all',0,0),(142,3,93,19,NULL,0,128,1,'all',0,0),(143,3,94,19,NULL,0,128,1,'all',0,0),(144,3,95,19,NULL,0,128,1,'all',0,0),(145,3,96,19,NULL,0,128,1,'all',0,0),(146,3,97,19,NULL,0,128,1,'all',0,0),(147,3,98,19,NULL,0,128,1,'all',0,0),(148,3,99,19,NULL,0,128,1,'all',0,0),(149,3,100,19,NULL,0,128,1,'all',0,0),(150,3,101,19,NULL,0,128,1,'all',0,0),(151,3,102,19,NULL,0,128,1,'all',0,0),(152,3,103,19,NULL,0,128,1,'all',0,0),(153,10,NULL,40,NULL,0,64,1,'all',0,0),(154,10,NULL,41,NULL,1,32,1,'all',0,0),(155,10,NULL,42,NULL,2,4,1,'all',0,0),(156,10,NULL,43,NULL,3,1,1,'all',0,0),(157,10,104,19,NULL,0,128,1,'all',0,0),(158,10,105,19,NULL,0,128,1,'all',0,0),(159,4,106,19,NULL,0,128,1,'all',0,0),(160,4,107,19,NULL,0,128,1,'all',0,0),(161,4,108,19,NULL,0,128,1,'all',0,0),(162,4,109,19,NULL,0,128,1,'all',0,0),(163,4,110,19,NULL,0,128,1,'all',0,0),(164,4,111,19,NULL,0,128,1,'all',0,0),(165,4,112,19,NULL,0,128,1,'all',0,0),(166,4,113,19,NULL,0,128,1,'all',0,0),(167,3,114,19,NULL,0,128,1,'all',0,0),(168,4,115,19,NULL,0,128,1,'all',0,0),(169,4,116,19,NULL,0,128,1,'all',0,0),(170,10,117,19,NULL,0,128,1,'all',0,0),(171,10,118,19,NULL,0,128,1,'all',0,0),(172,10,119,19,NULL,0,128,1,'all',0,0),(173,10,120,19,NULL,0,128,1,'all',0,0),(174,10,121,19,NULL,0,128,1,'all',0,0),(175,10,122,19,NULL,0,128,1,'all',0,0),(176,10,123,19,NULL,0,128,1,'all',0,0),(177,10,124,19,NULL,0,128,1,'all',0,0),(178,10,125,19,NULL,0,128,1,'all',0,0),(179,10,126,19,NULL,0,128,1,'all',0,0),(180,10,127,19,NULL,0,128,1,'all',0,0),(181,10,128,19,NULL,0,128,1,'all',0,0),(182,10,129,19,NULL,0,128,1,'all',0,0),(183,10,130,19,NULL,0,128,1,'all',0,0),(184,10,131,19,NULL,0,128,1,'all',0,0),(185,10,132,19,NULL,0,128,1,'all',0,0),(186,10,133,19,NULL,0,128,1,'all',0,0),(187,10,134,19,NULL,0,128,1,'all',0,0),(188,10,135,44,NULL,0,128,1,'all',0,0),(189,10,136,44,NULL,0,128,1,'all',0,0),(190,10,137,44,NULL,0,128,1,'all',0,0),(191,10,138,44,NULL,0,128,1,'all',0,0),(192,10,139,19,NULL,0,128,1,'all',0,0),(193,10,140,44,NULL,0,128,1,'all',0,0),(194,10,141,44,NULL,0,128,1,'all',0,0),(195,10,142,44,NULL,0,128,1,'all',0,0),(196,10,143,44,NULL,0,128,1,'all',0,0),(197,10,144,19,NULL,0,128,1,'all',0,0),(198,10,145,19,NULL,0,128,1,'all',0,0),(199,10,146,19,NULL,0,128,1,'all',0,0),(200,10,147,19,NULL,0,128,1,'all',0,0),(201,10,148,44,NULL,0,128,1,'all',0,0),(202,10,149,44,NULL,0,128,1,'all',0,0),(203,10,150,19,NULL,0,128,1,'all',0,0),(204,10,151,19,NULL,0,128,1,'all',0,0),(205,10,152,44,NULL,0,128,1,'all',0,0),(206,10,153,44,NULL,0,128,1,'all',0,0),(207,10,154,44,NULL,0,128,1,'all',0,0),(208,10,155,19,NULL,0,128,1,'all',0,0),(209,10,156,44,NULL,0,128,1,'all',0,0),(210,10,157,44,NULL,0,128,1,'all',0,0),(211,10,158,19,NULL,0,128,1,'all',0,0),(212,10,159,19,NULL,0,128,1,'all',0,0),(213,10,160,19,NULL,0,128,1,'all',0,0),(214,4,161,44,NULL,0,128,1,'all',0,0),(215,9,162,19,NULL,0,128,1,'all',0,0),(216,3,163,19,NULL,0,128,1,'all',0,0),(217,10,164,19,NULL,0,128,1,'all',0,0),(218,1,165,19,NULL,0,128,1,'all',0,0);

--
-- Table structure for table `acl_object_identities`
--

CREATE TABLE `acl_object_identities` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `parent_object_identity_id` int(10) unsigned DEFAULT NULL,
  `class_id` int(10) unsigned NOT NULL,
  `object_identifier` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `entries_inheriting` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_9407E5494B12AD6EA000B10` (`object_identifier`,`class_id`),
  KEY `IDX_9407E54977FA751A` (`parent_object_identity_id`),
  CONSTRAINT `FK_9407E54977FA751A` FOREIGN KEY (`parent_object_identity_id`) REFERENCES `acl_object_identities` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=166 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `acl_object_identities`
--

INSERT INTO `acl_object_identities` VALUES (1,NULL,1,'1',1),(2,NULL,2,'23',1),(3,NULL,1,'2',1),(4,NULL,3,'1',1),(5,NULL,3,'2',1),(6,NULL,4,'1',1),(7,NULL,4,'2',1),(8,NULL,4,'3',1),(9,NULL,3,'3',1),(10,NULL,3,'4',1),(11,NULL,4,'4',1),(12,NULL,4,'5',1),(13,NULL,4,'6',1),(14,NULL,4,'7',1),(15,NULL,5,'92',1),(16,NULL,6,'96',1),(17,NULL,7,'4',1),(18,NULL,7,'5',1),(19,NULL,1,'3',1),(20,NULL,6,'97',1),(21,NULL,3,'5',1),(22,NULL,3,'6',1),(23,NULL,3,'7',1),(24,NULL,3,'8',1),(25,NULL,3,'9',1),(26,NULL,3,'10',1),(27,NULL,3,'11',1),(28,NULL,3,'12',1),(29,NULL,3,'13',1),(30,NULL,3,'14',1),(31,NULL,3,'15',1),(32,NULL,3,'16',1),(33,NULL,3,'17',1),(34,NULL,3,'18',1),(35,NULL,3,'19',1),(36,NULL,4,'8',1),(37,NULL,4,'9',1),(38,NULL,4,'10',1),(39,NULL,4,'11',1),(40,NULL,4,'12',1),(41,NULL,4,'13',1),(42,NULL,4,'14',1),(43,NULL,4,'15',1),(44,NULL,4,'16',1),(45,NULL,4,'17',1),(46,NULL,4,'18',1),(47,NULL,4,'19',1),(48,NULL,4,'20',1),(49,NULL,4,'21',1),(50,NULL,4,'22',1),(51,NULL,4,'23',1),(52,NULL,4,'24',1),(53,NULL,4,'25',1),(54,NULL,4,'26',1),(55,NULL,3,'20',1),(56,NULL,3,'21',1),(57,NULL,3,'22',1),(58,NULL,3,'23',1),(59,NULL,1,'4',1),(60,NULL,1,'5',1),(61,NULL,8,'1',1),(62,NULL,9,'1',1),(63,NULL,8,'2',1),(64,NULL,9,'2',1),(65,NULL,9,'3',1),(66,NULL,9,'4',1),(67,NULL,3,'24',1),(68,NULL,3,'25',1),(69,NULL,3,'26',1),(70,NULL,3,'27',1),(71,NULL,3,'28',1),(72,NULL,3,'29',1),(73,NULL,3,'30',1),(74,NULL,3,'31',1),(75,NULL,3,'32',1),(76,NULL,3,'33',1),(77,NULL,4,'182',1),(78,NULL,4,'183',1),(79,NULL,4,'184',1),(80,NULL,4,'185',1),(81,NULL,4,'186',1),(82,NULL,4,'187',1),(83,NULL,4,'188',1),(84,NULL,4,'189',1),(85,NULL,4,'190',1),(86,NULL,4,'191',1),(87,NULL,4,'192',1),(88,NULL,4,'193',1),(89,NULL,4,'194',1),(90,NULL,4,'195',1),(91,NULL,4,'196',1),(92,NULL,4,'197',1),(93,NULL,3,'34',1),(94,NULL,3,'35',1),(95,NULL,3,'36',1),(96,NULL,3,'37',1),(97,NULL,3,'38',1),(98,NULL,3,'39',1),(99,NULL,3,'40',1),(100,NULL,3,'41',1),(101,NULL,3,'42',1),(102,NULL,3,'43',1),(103,NULL,3,'44',1),(104,NULL,10,'483',1),(105,NULL,10,'485',1),(106,NULL,4,'392',1),(107,NULL,4,'393',1),(108,NULL,4,'394',1),(109,NULL,4,'395',1),(110,NULL,4,'397',1),(111,NULL,4,'398',1),(112,NULL,4,'399',1),(113,NULL,4,'400',1),(114,NULL,3,'45',1),(115,NULL,4,'401',1),(116,NULL,4,'402',1),(117,NULL,10,'560',1),(118,NULL,10,'562',1),(119,NULL,10,'563',1),(120,NULL,10,'564',1),(121,NULL,10,'565',1),(122,NULL,10,'567',1),(123,NULL,10,'568',1),(124,NULL,10,'569',1),(125,NULL,10,'570',1),(126,NULL,10,'571',1),(127,NULL,10,'572',1),(128,NULL,10,'583',1),(129,NULL,10,'584',1),(130,NULL,10,'585',1),(131,NULL,10,'586',1),(132,NULL,10,'587',1),(133,NULL,10,'588',1),(134,NULL,10,'595',1),(135,NULL,10,'599',1),(136,NULL,10,'600',1),(137,NULL,10,'601',1),(138,NULL,10,'602',1),(139,NULL,10,'603',1),(140,NULL,10,'604',1),(141,NULL,10,'605',1),(142,NULL,10,'606',1),(143,NULL,10,'607',1),(144,NULL,10,'608',1),(145,NULL,10,'609',1),(146,NULL,10,'610',1),(147,NULL,10,'611',1),(148,NULL,10,'612',1),(149,NULL,10,'613',1),(150,NULL,10,'614',1),(151,NULL,10,'615',1),(152,NULL,10,'616',1),(153,NULL,10,'617',1),(154,NULL,10,'618',1),(155,NULL,10,'624',1),(156,NULL,10,'625',1),(157,NULL,10,'627',1),(158,NULL,10,'643',1),(159,NULL,10,'644',1),(160,NULL,10,'649',1),(161,NULL,4,'466',1),(162,NULL,9,'5',1),(163,NULL,3,'46',1),(164,NULL,10,'681',1),(165,NULL,1,'6',1);

--
-- Table structure for table `acl_object_identity_ancestors`
--

CREATE TABLE `acl_object_identity_ancestors` (
  `object_identity_id` int(10) unsigned NOT NULL,
  `ancestor_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`object_identity_id`,`ancestor_id`),
  KEY `IDX_825DE2993D9AB4A6` (`object_identity_id`),
  KEY `IDX_825DE299C671CEA1` (`ancestor_id`),
  CONSTRAINT `FK_825DE2993D9AB4A6` FOREIGN KEY (`object_identity_id`) REFERENCES `acl_object_identities` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_825DE299C671CEA1` FOREIGN KEY (`ancestor_id`) REFERENCES `acl_object_identities` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `acl_object_identity_ancestors`
--

INSERT INTO `acl_object_identity_ancestors` VALUES (1,1),(2,2),(3,3),(4,4),(5,5),(6,6),(7,7),(8,8),(9,9),(10,10),(11,11),(12,12),(13,13),(14,14),(15,15),(16,16),(17,17),(18,18),(19,19),(20,20),(21,21),(22,22),(23,23),(24,24),(25,25),(26,26),(27,27),(28,28),(29,29),(30,30),(31,31),(32,32),(33,33),(34,34),(35,35),(36,36),(37,37),(38,38),(39,39),(40,40),(41,41),(42,42),(43,43),(44,44),(45,45),(46,46),(47,47),(48,48),(49,49),(50,50),(51,51),(52,52),(53,53),(54,54),(55,55),(56,56),(57,57),(58,58),(59,59),(60,60),(61,61),(62,62),(63,63),(64,64),(65,65),(66,66),(67,67),(68,68),(69,69),(70,70),(71,71),(72,72),(73,73),(74,74),(75,75),(76,76),(77,77),(78,78),(79,79),(80,80),(81,81),(82,82),(83,83),(84,84),(85,85),(86,86),(87,87),(88,88),(89,89),(90,90),(91,91),(92,92),(93,93),(94,94),(95,95),(96,96),(97,97),(98,98),(99,99),(100,100),(101,101),(102,102),(103,103),(104,104),(105,105),(106,106),(107,107),(108,108),(109,109),(110,110),(111,111),(112,112),(113,113),(114,114),(115,115),(116,116),(117,117),(118,118),(119,119),(120,120),(121,121),(122,122),(123,123),(124,124),(125,125),(126,126),(127,127),(128,128),(129,129),(130,130),(131,131),(132,132),(133,133),(134,134),(135,135),(136,136),(137,137),(138,138),(139,139),(140,140),(141,141),(142,142),(143,143),(144,144),(145,145),(146,146),(147,147),(148,148),(149,149),(150,150),(151,151),(152,152),(153,153),(154,154),(155,155),(156,156),(157,157),(158,158),(159,159),(160,160),(161,161),(162,162),(163,163),(164,164),(165,165);

--
-- Table structure for table `acl_security_identities`
--

CREATE TABLE `acl_security_identities` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `identifier` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `username` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_8835EE78772E836AF85E0677` (`identifier`,`username`)
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `acl_security_identities`
--

INSERT INTO `acl_security_identities` VALUES (44,'Pixeloid\\UserBundle\\Entity\\User-barbara.tihanyi@timelessevent.hu',1),(19,'Pixeloid\\UserBundle\\Entity\\User-bernadett.szabo@timelessevent.hu',1),(5,'Pixeloid\\UserBundle\\Entity\\User-emese',1),(10,'Pixeloid\\UserBundle\\Entity\\User-emese.veres@ementin.hu',1),(20,'ROLE_PIXELOID_APP_ADMIN_ACCOMODATION_ADMIN',0),(21,'ROLE_PIXELOID_APP_ADMIN_ACCOMODATION_EDITOR',0),(23,'ROLE_PIXELOID_APP_ADMIN_ACCOMODATION_GUEST',0),(22,'ROLE_PIXELOID_APP_ADMIN_ACCOMODATION_STAFF',0),(6,'ROLE_PIXELOID_APP_ADMIN_DINING_TYPE_ADMIN',0),(7,'ROLE_PIXELOID_APP_ADMIN_DINING_TYPE_EDITOR',0),(9,'ROLE_PIXELOID_APP_ADMIN_DINING_TYPE_GUEST',0),(8,'ROLE_PIXELOID_APP_ADMIN_DINING_TYPE_STAFF',0),(1,'ROLE_PIXELOID_APP_ADMIN_EVENT_ADMIN',0),(2,'ROLE_PIXELOID_APP_ADMIN_EVENT_EDITOR',0),(4,'ROLE_PIXELOID_APP_ADMIN_EVENT_GUEST',0),(40,'ROLE_PIXELOID_APP_ADMIN_EVENT_REGISTRATION_ADMIN',0),(41,'ROLE_PIXELOID_APP_ADMIN_EVENT_REGISTRATION_EDITOR',0),(43,'ROLE_PIXELOID_APP_ADMIN_EVENT_REGISTRATION_GUEST',0),(42,'ROLE_PIXELOID_APP_ADMIN_EVENT_REGISTRATION_STAFF',0),(3,'ROLE_PIXELOID_APP_ADMIN_EVENT_STAFF',0),(36,'ROLE_PIXELOID_APP_ADMIN_EXTRA_PROGRAM_ADMIN',0),(37,'ROLE_PIXELOID_APP_ADMIN_EXTRA_PROGRAM_EDITOR',0),(32,'ROLE_PIXELOID_APP_ADMIN_EXTRA_PROGRAM_GROUP_ADMIN',0),(33,'ROLE_PIXELOID_APP_ADMIN_EXTRA_PROGRAM_GROUP_EDITOR',0),(35,'ROLE_PIXELOID_APP_ADMIN_EXTRA_PROGRAM_GROUP_GUEST',0),(34,'ROLE_PIXELOID_APP_ADMIN_EXTRA_PROGRAM_GROUP_STAFF',0),(39,'ROLE_PIXELOID_APP_ADMIN_EXTRA_PROGRAM_GUEST',0),(38,'ROLE_PIXELOID_APP_ADMIN_EXTRA_PROGRAM_STAFF',0),(15,'ROLE_PIXELOID_APP_ADMIN_PRESENTATION_ADMIN',0),(16,'ROLE_PIXELOID_APP_ADMIN_PRESENTATION_EDITOR',0),(18,'ROLE_PIXELOID_APP_ADMIN_PRESENTATION_GUEST',0),(11,'ROLE_PIXELOID_APP_ADMIN_PRESENTATION_SECTION_ADMIN',0),(12,'ROLE_PIXELOID_APP_ADMIN_PRESENTATION_SECTION_EDITOR',0),(14,'ROLE_PIXELOID_APP_ADMIN_PRESENTATION_SECTION_GUEST',0),(13,'ROLE_PIXELOID_APP_ADMIN_PRESENTATION_SECTION_STAFF',0),(17,'ROLE_PIXELOID_APP_ADMIN_PRESENTATION_STAFF',0),(24,'ROLE_PIXELOID_APP_ADMIN_REGISTRANT_TYPE_ADMIN',0),(25,'ROLE_PIXELOID_APP_ADMIN_REGISTRANT_TYPE_EDITOR',0),(27,'ROLE_PIXELOID_APP_ADMIN_REGISTRANT_TYPE_GUEST',0),(26,'ROLE_PIXELOID_APP_ADMIN_REGISTRANT_TYPE_STAFF',0),(28,'ROLE_PIXELOID_APP_ADMIN_TEAM_MEMBER_ADMIN',0),(29,'ROLE_PIXELOID_APP_ADMIN_TEAM_MEMBER_EDITOR',0),(31,'ROLE_PIXELOID_APP_ADMIN_TEAM_MEMBER_GUEST',0),(30,'ROLE_PIXELOID_APP_ADMIN_TEAM_MEMBER_STAFF',0);

--
-- Table structure for table `calendar`
--

CREATE TABLE `calendar` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `datefield` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `calendar`
--


--
-- Table structure for table `classification__category`
--

CREATE TABLE `classification__category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) DEFAULT NULL,
  `context` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `media_id` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  `slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `position` int(11) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_43629B36727ACA70` (`parent_id`),
  KEY `IDX_43629B36E25D857E` (`context`),
  KEY `IDX_43629B36EA9FDD75` (`media_id`),
  CONSTRAINT `FK_43629B36727ACA70` FOREIGN KEY (`parent_id`) REFERENCES `classification__category` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_43629B36E25D857E` FOREIGN KEY (`context`) REFERENCES `classification__context` (`id`),
  CONSTRAINT `FK_43629B36EA9FDD75` FOREIGN KEY (`media_id`) REFERENCES `media__media` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `classification__category`
--

INSERT INTO `classification__category` VALUES (1,NULL,'default',NULL,'default',1,'default','default',NULL,'2019-10-13 19:32:14','2019-10-13 19:32:14');

--
-- Table structure for table `classification__collection`
--

CREATE TABLE `classification__collection` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `context` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `media_id` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  `slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tag_collection` (`slug`,`context`),
  KEY `IDX_A406B56AE25D857E` (`context`),
  KEY `IDX_A406B56AEA9FDD75` (`media_id`),
  CONSTRAINT `FK_A406B56AE25D857E` FOREIGN KEY (`context`) REFERENCES `classification__context` (`id`),
  CONSTRAINT `FK_A406B56AEA9FDD75` FOREIGN KEY (`media_id`) REFERENCES `media__media` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `classification__collection`
--


--
-- Table structure for table `classification__context`
--

CREATE TABLE `classification__context` (
  `id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `classification__context`
--

INSERT INTO `classification__context` VALUES ('default','default',1,'2019-10-13 19:32:14','2019-10-13 19:32:14');

--
-- Table structure for table `classification__tag`
--

CREATE TABLE `classification__tag` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `context` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  `slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tag_context` (`slug`,`context`),
  KEY `IDX_CA57A1C7E25D857E` (`context`),
  CONSTRAINT `FK_CA57A1C7E25D857E` FOREIGN KEY (`context`) REFERENCES `classification__context` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `classification__tag`
--


--
-- Table structure for table `ext_log_entries`
--

CREATE TABLE `ext_log_entries` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `action` varchar(8) COLLATE utf8_unicode_ci NOT NULL,
  `logged_at` datetime NOT NULL,
  `object_id` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `object_class` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `version` int(11) NOT NULL,
  `data` longtext COLLATE utf8_unicode_ci COMMENT '(DC2Type:array)',
  `username` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `log_class_lookup_idx` (`object_class`),
  KEY `log_date_lookup_idx` (`logged_at`),
  KEY `log_user_lookup_idx` (`username`),
  KEY `log_version_lookup_idx` (`object_id`,`object_class`,`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ext_log_entries`
--


--
-- Table structure for table `ext_translations`
--

CREATE TABLE `ext_translations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `locale` varchar(8) COLLATE utf8_unicode_ci NOT NULL,
  `object_class` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `field` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `foreign_key` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`),
  UNIQUE KEY `lookup_unique_idx` (`locale`,`object_class`,`field`,`foreign_key`),
  KEY `translations_lookup_idx` (`locale`,`object_class`,`foreign_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ext_translations`
--


--
-- Table structure for table `extraprogram_extraprogramreservation`
--

CREATE TABLE `extraprogram_extraprogramreservation` (
  `extraprogram_id` int(11) NOT NULL,
  `extraprogramreservation_id` int(11) NOT NULL,
  PRIMARY KEY (`extraprogram_id`,`extraprogramreservation_id`),
  KEY `IDX_91952F7881087A01` (`extraprogram_id`),
  KEY `IDX_91952F78D50F4AAB` (`extraprogramreservation_id`),
  CONSTRAINT `FK_91952F7881087A01` FOREIGN KEY (`extraprogram_id`) REFERENCES `ExtraProgram` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_91952F78D50F4AAB` FOREIGN KEY (`extraprogramreservation_id`) REFERENCES `ExtraProgramReservation` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `extraprogram_extraprogramreservation`
--

INSERT INTO `extraprogram_extraprogramreservation` VALUES (1,1),(1,5),(1,6),(1,15),(1,19),(1,48),(1,54),(1,61),(1,67),(1,72),(1,74),(1,75),(1,76),(1,77),(1,78),(1,79),(1,80),(1,81),(1,172),(1,190),(1,196),(1,203),(1,208),(1,223),(1,224),(1,263),(1,283),(1,291),(1,298),(1,380),(1,394),(1,395),(1,401),(1,404),(1,467),(1,555),(1,556),(1,557),(1,559),(1,679),(2,29),(2,88),(2,94),(2,96),(2,99),(2,103),(2,108),(2,151),(2,197),(2,207),(2,233),(2,276),(2,328),(2,329),(2,456),(2,691),(2,726),(2,840),(2,841),(2,842),(3,28),(3,40),(3,41),(3,73),(3,83),(3,101),(3,102),(3,138),(3,200),(3,222),(3,287),(3,290),(3,296),(3,355),(3,359),(4,35),(4,161),(4,191),(4,217),(4,218),(4,219),(4,220),(4,260),(4,330),(4,462),(4,466),(4,588),(4,729),(4,866),(5,796);

--
-- Table structure for table `media__gallery`
--

CREATE TABLE `media__gallery` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `event_id` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `context` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `default_format` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_3C02B7F571F7E88B` (`event_id`),
  CONSTRAINT `FK_3C02B7F571F7E88B` FOREIGN KEY (`event_id`) REFERENCES `Event` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `media__gallery`
--


--
-- Table structure for table `media__gallery_media`
--

CREATE TABLE `media__gallery_media` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gallery_id` int(11) DEFAULT NULL,
  `media_id` int(11) DEFAULT NULL,
  `position` int(11) NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_80D4C5414E7AF8F` (`gallery_id`),
  KEY `IDX_80D4C541EA9FDD75` (`media_id`),
  CONSTRAINT `FK_80D4C5414E7AF8F` FOREIGN KEY (`gallery_id`) REFERENCES `media__gallery` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_80D4C541EA9FDD75` FOREIGN KEY (`media_id`) REFERENCES `media__media` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `media__gallery_media`
--


--
-- Table structure for table `media__media`
--

CREATE TABLE `media__media` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category_id` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `enabled` tinyint(1) NOT NULL,
  `provider_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `provider_status` int(11) NOT NULL,
  `provider_reference` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `provider_metadata` longtext COLLATE utf8_unicode_ci COMMENT '(DC2Type:json)',
  `width` int(11) DEFAULT NULL,
  `height` int(11) DEFAULT NULL,
  `length` decimal(10,0) DEFAULT NULL,
  `content_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `content_size` int(11) DEFAULT NULL,
  `copyright` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `author_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `context` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cdn_is_flushable` tinyint(1) DEFAULT NULL,
  `cdn_flush_identifier` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cdn_flush_at` datetime DEFAULT NULL,
  `cdn_status` int(11) DEFAULT NULL,
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_5C6DD74E12469DE2` (`category_id`),
  CONSTRAINT `FK_5C6DD74E12469DE2` FOREIGN KEY (`category_id`) REFERENCES `classification__category` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `media__media`
--



