<gh_stars>0
-- MySQL dump 10.13  Distrib 5.7.23, for Linux (x86_64)
--
-- Host: db    Database: homecloud
-- ------------------------------------------------------
-- Server version	5.7.23

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `home_moviegenre`
--

USE `homecloud`; 

DROP TABLE IF EXISTS `home_moviegenre`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `home_moviegenre` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `movie_id` int(11) NOT NULL,
  `genre_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `home_moviegenre_d06c534f` (`movie_id`),
  KEY `home_moviegenre_33e6008b` (`genre_id`),
  CONSTRAINT `genre_id_refs_id_40572fb7` FOREIGN KEY (`genre_id`) REFERENCES `home_genre` (`id`),
  CONSTRAINT `movie_id_refs_id_3535dbf6` FOREIGN KEY (`movie_id`) REFERENCES `home_movie` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1031 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `home_moviegenre`
--

LOCK TABLES `home_moviegenre` WRITE;
/*!40000 ALTER TABLE `home_moviegenre` DISABLE KEYS */;
INSERT INTO `home_moviegenre` VALUES
(135,56,19),
(136,56,20),
(137,56,21),
(138,57,20),
(139,57,22),
(140,58,22),
(141,58,23),
(142,58,24),
(143,59,25),
(144,59,26),
(145,59,27),
(146,59,28),
(147,60,20),
(148,60,23),
(149,61,19),
(150,61,25),
(151,61,29),
(152,62,19),
(153,62,25),
(154,62,26),
(155,63,19),
(156,63,20),
(157,63,30),
(158,63,21),
(159,64,20),
(160,64,30),
(161,65,29),
(162,66,19),
(163,66,22),
(164,66,24),
(165,66,31),
(166,67,20),
(167,67,23),
(168,68,25),
(169,68,22),
(170,68,26),
(171,69,20),
(172,69,22),
(173,69,21),
(174,70,20),
(175,71,19),
(176,71,30),
(177,71,26),
(178,71,24),
(179,72,19),
(180,72,22),
(181,72,24),
(182,73,19),
(183,73,25),
(184,73,20),
(185,73,30),
(186,73,22),
(187,73,27),
(188,73,24),
(189,74,19),
(190,74,25),
(191,74,29),
(192,75,22),
(193,75,32),
(194,76,19),
(195,76,25),
(196,76,24),
(197,77,19),
(198,77,25),
(199,77,33),
(200,78,20),
(201,79,20),
(202,79,22),
(203,79,21),
(204,80,26),
(205,81,23),
(206,81,27),
(207,82,25),
(208,82,34),
(209,82,20),
(210,82,35),
(211,82,28),
(212,83,22),
(213,83,24),
(214,84,25),
(215,84,26),
(216,84,28),
(217,85,22),
(218,85,24),
(219,86,19),
(220,86,25),
(221,86,26),
(222,87,19),
(223,87,25),
(224,87,36),
(225,87,29),
(226,87,24),
(227,88,22),
(228,88,21),
(229,89,19),
(230,89,25),
(231,89,20),
(232,89,29),
(233,90,20),
(234,90,21),
(235,91,22),
(236,92,20),
(237,92,28),
(238,93,19),
(239,93,26),
(240,93,23),
(241,94,19),
(242,94,26),
(243,95,19),
(244,95,25),
(245,95,29),
(246,96,20),
(247,96,30),
(248,97,25),
(249,97,34),
(250,97,20),
(251,97,26),
(252,97,28),
(253,98,19),
(254,98,30),
(255,98,22),
(256,98,24),
(257,99,30),
(258,99,22),
(259,99,24),
(260,100,19),
(261,100,22),
(262,100,23),
(263,100,29),
(264,100,24),
(265,101,23),
(266,102,23),
(267,102,24),
(268,103,20),
(269,103,30),
(270,104,20),
(271,105,23),
(272,106,20),
(273,106,35),
(274,106,28),
(275,107,19),
(276,107,25),
(277,107,26),
(278,108,22),
(279,108,23),
(280,109,25),
(281,110,20),
(282,111,19),
(283,111,25),
(284,111,20),
(285,111,26),
(286,111,28),
(287,112,30),
(288,112,22),
(289,112,37),
(290,113,20),
(291,113,23),
(292,114,23),
(293,115,19),
(294,115,26),
(295,115,24),
(296,116,19),
(297,116,20),
(298,116,30),
(299,117,30),
(300,117,22),
(301,117,24),
(302,117,21),
(303,118,20),
(304,119,26),
(305,121,20),
(306,122,20),
(307,123,23),
(308,123,24),
(309,124,19),
(310,124,25),
(311,124,29),
(312,124,24),
(313,125,19),
(314,125,25),
(315,125,34),
(316,125,20),
(317,125,26),
(318,125,28),
(319,126,20),
(320,127,30),
(321,127,22),
(322,127,38),
(323,128,22),
(324,128,29),
(325,128,24),
(326,129,30),
(327,129,23),
(328,130,20),
(329,131,30),
(330,131,23),
(331,131,24),
(332,132,19),
(333,132,25),
(334,132,29),
(335,133,19),
(336,133,25),
(337,133,20),
(338,133,30),
(339,133,24),
(340,134,19),
(341,134,20),
(342,134,22),
(343,134,24),
(344,135,19),
(345,135,25),
(346,135,29),
(347,136,20),
(348,137,19),
(349,137,25),
(350,138,20),
(351,139,19),
(352,139,25),
(353,139,29),
(354,140,19),
(355,140,25),
(356,140,29),
(357,141,22),
(358,141,23),
(359,141,24),
(360,142,20),
(361,143,20),
(362,144,30),
(363,144,22),
(364,144,24),
(365,145,19),
(366,145,25),
(367,145,20),
(368,145,30),
(369,145,24),
(370,146,19),
(371,146,20),
(372,146,29),
(373,147,19),
(374,147,25),
(375,147,30),
(376,147,22),
(377,147,24),
(378,148,19),
(379,148,22),
(380,148,24),
(381,149,20),
(382,150,22),
(383,151,19),
(384,151,24),
(385,151,21),
(386,152,19),
(387,152,25),
(388,152,29),
(389,152,24),
(390,153,19),
(391,153,25),
(392,153,23),
(393,153,29),
(394,154,22),
(395,155,19),
(396,155,20),
(397,155,29),
(398,156,19),
(399,156,25),
(400,156,20),
(401,156,26),
(402,156,29),
(403,157,19),
(404,157,25),
(405,157,26),
(406,157,29),
(407,158,23),
(408,158,24),
(409,159,19),
(410,159,22),
(411,159,29),
(412,159,39),
(413,161,19),
(414,161,25),
(415,161,30),
(416,161,27),
(417,161,24),
(418,162,23),
(419,162,24),
(420,163,19),
(421,163,25),
(422,163,29),
(423,164,23),
(424,164,24),
(425,165,19),
(426,165,25),
(427,165,29),
(428,165,24),
(429,166,19),
(430,166,25),
(431,166,22),
(432,166,26),
(433,167,19),
(434,167,20),
(435,167,30),
(436,168,19),
(437,168,29),
(438,168,24),
(439,168,33),
(440,169,25),
(441,169,22),
(442,169,29),
(443,169,24),
(444,170,20),
(445,171,23),
(446,171,27),
(447,172,20),
(448,172,30),
(449,173,20),
(450,173,21),
(451,174,20),
(452,174,23),
(453,174,29),
(454,175,30),
(455,175,23),
(456,175,24),
(457,176,23),
(458,176,27),
(459,177,23),
(460,178,20),
(461,178,22),
(462,179,20),
(463,179,21),
(464,180,22),
(465,180,32),
(466,181,27),
(467,181,29),
(468,181,24),
(469,182,19),
(470,182,25),
(471,182,29),
(472,183,20),
(473,183,22),
(474,184,23),
(475,185,22),
(476,185,23),
(477,185,21),
(478,185,37),
(479,186,19),
(480,186,25),
(481,186,29),
(482,187,19),
(483,187,25),
(484,187,29),
(485,188,19),
(486,188,30),
(487,188,27),
(488,188,24),
(489,189,19),
(490,189,25),
(491,189,34),
(492,189,20),
(493,189,26),
(494,189,28),
(495,190,20),
(496,190,21),
(497,191,20),
(498,191,21),
(499,192,20),
(500,193,19),
(501,193,20),
(502,194,19),
(503,194,20),
(504,194,30),
(505,195,25),
(506,195,29),
(507,196,30),
(508,196,23),
(509,196,27),
(510,197,23),
(511,197,24),
(512,198,19),
(513,198,23),
(514,198,29),
(515,199,19),
(516,199,30),
(517,199,22),
(518,199,24),
(519,200,19),
(520,200,24),
(521,201,19),
(522,201,20),
(523,201,30),
(524,202,19),
(525,202,20),
(526,202,24),
(527,203,19),
(528,203,30),
(529,203,24),
(530,204,23),
(531,205,20),
(532,206,19),
(533,206,25),
(534,206,26),
(535,207,25),
(536,207,26),
(537,207,28),
(538,208,25),
(539,208,22),
(540,208,24),
(541,209,30),
(542,209,24),
(543,210,25),
(544,210,26),
(545,210,28),
(546,211,29),
(547,211,24),
(548,212,20),
(549,212,21),
(550,213,19),
(551,213,25),
(552,214,19),
(553,214,20),
(554,215,19),
(555,215,25),
(556,215,27),
(557,215,29),
(558,215,24),
(559,216,19),
(560,216,20),
(561,216,30),
(562,216,24),
(563,217,23),
(564,217,27),
(565,218,20),
(566,219,19),
(567,219,30),
(568,219,24),
(569,220,20),
(570,221,22),
(571,221,23),
(572,221,24),
(573,222,19),
(574,222,30),
(575,222,24),
(576,223,25),
(577,223,35),
(578,223,21),
(579,224,19),
(580,224,30),
(581,224,22),
(582,225,25),
(583,225,26),
(584,225,28),
(585,226,20),
(586,226,22),
(587,226,21),
(588,227,19),
(589,227,25),
(590,227,29),
(591,227,24),
(592,228,20),
(593,228,26),
(594,229,19),
(595,229,25),
(596,229,29),
(597,229,24),
(598,230,19),
(599,230,29),
(600,230,31),
(601,231,20),
(602,231,22),
(603,231,35),
(604,231,21),
(605,232,23),
(606,232,24),
(607,233,23),
(608,234,19),
(609,234,24),
(610,235,22),
(611,235,39),
(612,236,20),
(613,236,22),
(614,237,19),
(615,237,25),
(616,237,26),
(617,238,19),
(618,238,20),
(619,238,24),
(620,238,28),
(621,239,22),
(622,240,19),
(623,240,25),
(624,240,20),
(625,240,29),
(626,241,34),
(627,241,20),
(628,241,28),
(629,242,22),
(630,242,27),
(631,242,40),
(632,242,24),
(633,243,19),
(634,243,25),
(635,243,29),
(636,244,20),
(637,245,22),
(638,245,41),
(639,245,38),
(640,246,19),
(641,246,25),
(642,246,26),
(643,246,31),
(644,247,19),
(645,247,25),
(646,247,20),
(647,247,24),
(648,248,23),
(649,249,25),
(650,249,20),
(651,249,21),
(652,250,19),
(653,250,25),
(654,250,26),
(655,251,19),
(656,251,25),
(657,251,26),
(658,252,20),
(659,253,20),
(660,254,19),
(661,254,24),
(662,255,22),
(663,256,20),
(664,256,22),
(665,257,19),
(666,257,25),
(667,257,29),
(668,258,22),
(669,258,39),
(670,259,22),
(671,259,41),
(672,259,21),
(673,260,20),
(674,260,30),
(675,261,34),
(676,261,28),
(677,262,25),
(678,262,27),
(679,262,29),
(680,263,20),
(681,264,20),
(682,264,21),
(683,265,20),
(684,265,22),
(685,266,19),
(686,266,25),
(687,266,29),
(688,267,23),
(689,267,27),
(690,268,19),
(691,268,22),
(692,268,32),
(693,269,19),
(694,269,20),
(695,269,24),
(696,270,20),
(697,270,30),
(698,271,20),
(699,271,26),
(700,272,30),
(701,272,22),
(702,273,19),
(703,273,23),
(704,273,29),
(705,273,24),
(706,274,23),
(707,274,27),
(708,274,24),
(709,275,22),
(710,276,19),
(711,276,25),
(712,276,26),
(713,277,19),
(714,277,20),
(715,277,30),
(716,277,24),
(717,278,30),
(718,278,23),
(719,278,24),
(720,279,20),
(721,279,28),
(722,280,19),
(723,280,36),
(724,280,22),
(725,280,21),
(726,281,19),
(727,281,25),
(728,281,26),
(729,282,30),
(730,282,23),
(731,282,24),
(732,283,19),
(733,283,23),
(734,283,29),
(735,283,24),
(736,284,22),
(737,284,29),
(738,285,19),
(739,285,22),
(740,285,29),
(741,285,24),
(742,286,20),
(743,287,19),
(744,287,30),
(745,287,24),
(746,288,19),
(747,288,25),
(748,288,22),
(749,288,26),
(750,289,20),
(751,290,20),
(752,290,21),
(753,291,25),
(754,291,26),
(755,291,29),
(756,292,20),
(757,293,20),
(758,293,23),
(759,293,21),
(760,294,19),
(761,294,25),
(762,294,24),
(763,295,34),
(764,295,26),
(765,295,41),
(766,295,28),
(767,296,19),
(768,296,29),
(769,296,24),
(770,297,20),
(771,298,19),
(772,298,20),
(773,298,30),
(774,299,20),
(775,300,20),
(776,301,22),
(777,301,23),
(778,301,24),
(779,302,20),
(780,302,21),
(781,303,20),
(782,304,20),
(783,304,30),
(784,304,27),
(785,305,19),
(786,305,25),
(787,305,29),
(788,306,20),
(789,306,30),
(790,306,22),
(791,307,19),
(792,307,25),
(793,308,19),
(794,308,26),
(795,308,24),
(796,309,19),
(797,309,25),
(798,309,26),
(799,310,23),
(800,310,27),
(801,311,19),
(802,311,25),
(803,311,26),
(804,312,20),
(805,313,19),
(806,313,38),
(807,315,19),
(808,315,25),
(809,316,22),
(810,317,30),
(811,317,23),
(812,317,27),
(813,318,22),
(814,318,29),
(815,318,24),
(816,319,19),
(817,319,30),
(818,319,27),
(819,319,24),
(820,320,19),
(821,320,25),
(822,320,26),
(823,320,21),
(824,321,27),
(825,321,24),
(826,322,22),
(827,322,21),
(828,323,22),
(829,323,24),
(830,324,20),
(831,325,22),
(832,325,27),
(833,326,19),
(834,326,25),
(835,326,29),
(836,327,19),
(837,327,25),
(838,327,30),
(839,327,24),
(840,328,27),
(841,328,29),
(842,328,24),
(843,329,20),
(844,329,26),
(845,329,21),
(846,330,19),
(847,330,20),
(848,330,30),
(849,331,23),
(850,331,27),
(851,332,19),
(852,332,20),
(853,332,30),
(854,332,24),
(855,333,19),
(856,333,25),
(857,333,34),
(858,333,23),
(859,333,29),
(860,334,20),
(861,334,30),
(862,335,19),
(863,335,30),
(864,335,22),
(865,335,24),
(866,336,19),
(867,336,23),
(868,336,29),
(869,336,24),
(870,337,19),
(871,337,25),
(872,337,26),
(873,337,29),
(874,338,19),
(875,338,20),
(876,338,30),
(877,339,19),
(878,339,27),
(879,339,24),
(880,340,20),
(881,340,22),
(882,340,21),
(883,341,20),
(884,341,22),
(885,341,29),
(886,341,21),
(887,342,19),
(888,342,25),
(889,343,19),
(890,343,22),
(891,343,24),
(892,344,19),
(893,344,20),
(894,345,19),
(895,345,25),
(896,345,24),
(897,346,20),
(898,347,34),
(899,347,20),
(900,347,28),
(901,348,30),
(902,348,22),
(903,348,23),
(904,349,19),
(905,349,25),
(906,349,29),
(907,349,24),
(908,350,22),
(909,350,21),
(910,351,19),
(911,351,24),
(912,352,20),
(913,352,21),
(914,353,20),
(915,353,21),
(916,354,19),
(917,354,30),
(918,354,22),
(919,354,24),
(920,355,20),
(921,355,21),
(922,357,19),
(923,357,20),
(924,357,30),
(925,358,19),
(926,358,20),
(927,358,30),
(928,359,19),
(929,359,29),
(930,359,24),
(931,360,19),
(932,360,25),
(933,360,29),
(934,361,19),
(935,361,30),
(936,361,24),
(937,362,20),
(938,362,21),
(939,363,20),
(940,363,21),
(941,364,19),
(942,364,25),
(943,364,26),
(944,365,25),
(945,365,26),
(946,365,28),
(947,366,19),
(948,366,25),
(949,366,26),
(950,367,19),
(951,367,24),
(952,368,19),
(953,368,25),
(954,368,20),
(955,368,26),
(956,368,28),
(957,369,30),
(958,369,23),
(959,369,24),
(960,370,19),
(961,370,20),
(962,370,30),
(963,371,19),
(964,371,20),
(965,371,30),
(966,372,19),
(967,372,25),
(968,372,22),
(969,372,26),
(970,372,29),
(971,373,23),
(972,373,27),
(973,374,25),
(974,374,26),
(975,374,28),
(976,375,42),
(977,376,20),
(978,377,26),
(979,378,19),
(980,378,25),
(981,378,20),
(982,378,30),
(983,379,22),
(984,379,21),
(985,380,19),
(986,380,25),
(987,380,26),
(988,380,29),
(989,381,19),
(990,381,25),
(991,381,29),
(992,381,21),
(993,382,19),
(994,382,25),
(995,382,22),
(996,383,30),
(997,383,22),
(998,384,19),
(999,384,22),
(1000,384,24),
(1001,385,23),
(1002,385,24),
(1003,386,19),
(1004,386,30),
(1005,386,24),
(1006,387,20),
(1007,387,33),
(1008,388,23),
(1009,388,29),
(1010,388,24),
(1011,389,22),
(1012,389,32),
(1013,389,24),
(1014,390,19),
(1015,390,25),
(1016,390,26),
(1017,390,29),
(1018,391,19),
(1019,391,30),
(1020,391,22),
(1021,391,24),
(1022,392,19),
(1023,392,25),
(1024,392,29),
(1025,393,19),
(1026,393,25),
(1027,393,29),
(1028,394,19),
(1029,394,29),
(1030,395,20);
/*!40000 ALTER TABLE `home_moviegenre` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2018-08-30 11:39:10
