EE8e9jEu

1SET SQL_SAFE_UPDATES = 0; 
2
3CREATE TABLE IF NOT EXISTS `yevgeniya_migranova`.`Game` (
4  `Date` DATE NOT NULL,
5  `Stadium` VARCHAR(45) NOT NULL,
6  `HomeGoals` INT NULL,
7  `AwayGoals` INT NULL,
8  `ID` INT NOT NULL,
9  PRIMARY KEY (`ID`),
10  UNIQUE INDEX `ID_UNIQUE` (`ID` ASC))
11ENGINE = InnoDB
12ROW_FORMAT = DEFAULT;
13
14CREATE TABLE IF NOT EXISTS `yevgeniya_migranova`.`Team` (
15  `Country` VARCHAR(45) NOT NULL,
16  `City` VARCHAR(45) NOT NULL,
17  `Coach` VARCHAR(45) NULL,
18  `Name` VARCHAR(45) NOT NULL,
19  PRIMARY KEY (`Name`))
20ENGINE = InnoDB;
21
22
23CREATE TABLE IF NOT EXISTS `yevgeniya_migranova`.`Away_Team` (
24  `Team_Name` VARCHAR(45) NOT NULL,
25  `Game_ID` INT NOT NULL,
26  PRIMARY KEY (`Game_ID`),
27  INDEX `fk_Away_Team_Team1_idx` (`Team_Name` ASC),
28  INDEX `fk_Away_Team_Game1_idx` (`Game_ID` ASC),
29  CONSTRAINT `fk_Away_Team_Team1`
30    FOREIGN KEY (`Team_Name`)
31    REFERENCES `yevgeniya_migranova`.`Team` (`Name`)
32    ON DELETE NO ACTION
33    ON UPDATE NO ACTION,
34  CONSTRAINT `fk_Away_Team_Game1`
35    FOREIGN KEY (`Game_ID`)
36    REFERENCES `yevgeniya_migranova`.`Game` (`ID`)
37    ON DELETE NO ACTION
38    ON UPDATE NO ACTION)
39ENGINE = InnoDB;
40
41CREATE TABLE IF NOT EXISTS `yevgeniya_migranova`.`Home_Team` (
42  `Game_ID` INT NOT NULL,
43  `Team_Name` VARCHAR(45) NOT NULL,
44  PRIMARY KEY (`Game_ID`),
45  INDEX `fk_Home_Team_Team1_idx` (`Team_Name` ASC),
46  CONSTRAINT `fk_Home_Team_Game1`
47    FOREIGN KEY (`Game_ID`)
48    REFERENCES `yevgeniya_migranova`.`Game` (`ID`)
49    ON DELETE NO ACTION
50    ON UPDATE NO ACTION,
51  CONSTRAINT `fk_Home_Team_Team1`
52    FOREIGN KEY (`Team_Name`)
53    REFERENCES `yevgeniya_migranova`.`Team` (`Name`)
54    ON DELETE NO ACTION
55    ON UPDATE NO ACTION)
56ENGINE = InnoDB;
57
58CREATE TABLE IF NOT EXISTS `yevgeniya_migranova`.`Player` (
59  `Number` INT NOT NULL,
60  `Name` VARCHAR(45) NOT NULL,
61  `Position` VARCHAR(45) NULL,
62  `Team_Name` VARCHAR(45) NOT NULL,
63  PRIMARY KEY (`Name`),
64  INDEX `fk_Player_Team_idx` (`Team_Name` ASC),
65  CONSTRAINT `fk_Player_Team`
66    FOREIGN KEY (`Team_Name`)
67    REFERENCES `yevgeniya_migranova`.`Team` (`Name`)
68    ON DELETE NO ACTION
69    ON UPDATE NO ACTION)
70ENGINE = InnoDB;
71
72CREATE TABLE IF NOT EXISTS `yevgeniya_migranova`.`Player_has_Game` (
73  `Player_Name` VARCHAR(45) NOT NULL,
74  `YellowCards` INT NULL,
75  `RedCards` INT NULL,
76  `Goals` INT NULL,
77  `Game_ID` INT NOT NULL,
78 
79  INDEX `fk_Player_has_Game_Player1_idx` (`Player_Name` ASC),
80  INDEX `fk_Player_has_Game_Game1_idx` (`Game_ID` ASC),
81
82  CONSTRAINT `fk_Player_has_Game_ID`  PRIMARY KEY (`Player_Name`, `Game_ID`)
83  )
84ENGINE = InnoDB;
85
86
87
88INSERT INTO `yevgeniya_migranova`.`Game` (`Date`, `Stadium`, `HomeGoals`, `AwayGoals`, `ID`) VALUES ('2016-10-19', 'Stade de Lyon', 0, 1, 1);
89INSERT INTO `yevgeniya_migranova`.`Game` (`Date`, `Stadium`, `HomeGoals`, `AwayGoals`, `ID`) VALUES ('2016-10-19', 'Stadion Maksimir', 0, 1, 2);
90INSERT INTO `yevgeniya_migranova`.`Game` (`Date`, `Stadium`, `HomeGoals`, `AwayGoals`, `ID`) VALUES ('2016-10-19', 'Jan Breydelstadion', 1, 2, 3);
91INSERT INTO `yevgeniya_migranova`.`Game` (`Date`, `Stadium`, `HomeGoals`, `AwayGoals`, `ID`) VALUES ('2016-10-19', 'Leicester City Stadium', 1, 0, 4);
92INSERT INTO `yevgeniya_migranova`.`Game` (`Date`, `Stadium`, `HomeGoals`, `AwayGoals`, `ID`) VALUES ('2016-10-19', 'Estadio Santiago Bernabéu', 5, 1, 5);
93INSERT INTO `yevgeniya_migranova`.`Game` (`Date`, `Stadium`, `HomeGoals`, `AwayGoals`, `ID`) VALUES ('2016-10-19', 'José Alvalade', 1, 2, 6);
94INSERT INTO `yevgeniya_migranova`.`Game` (`Date`, `Stadium`, `HomeGoals`, `AwayGoals`, `ID`) VALUES ('2016-10-19', 'BayArena', 0, 0, 7);
95INSERT INTO `yevgeniya_migranova`.`Game` (`Date`, `Stadium`, `HomeGoals`, `AwayGoals`, `ID`) VALUES ('2016-10-19', 'Stadion CSKA Moskva', 1, 1, 8);
96INSERT INTO `yevgeniya_migranova`.`Game` (`Date`, `Stadium`, `HomeGoals`, `AwayGoals`, `ID`) VALUES ('2016-10-20', 'Fußball Arena München', 4, 1, 9);
97INSERT INTO `yevgeniya_migranova`.`Game` (`Date`, `Stadium`, `HomeGoals`, `AwayGoals`, `ID`) VALUES ('2016-10-20', 'Olimp 2', 0, 1, 10);
98INSERT INTO `yevgeniya_migranova`.`Game` (`Date`, `Stadium`, `HomeGoals`, `AwayGoals`, `ID`) VALUES ('2016-10-20', 'Camp Nou', 4, 0, 11);
99INSERT INTO `yevgeniya_migranova`.`Game` (`Date`, `Stadium`, `HomeGoals`, `AwayGoals`, `ID`) VALUES ('2016-10-20', 'Celtic Park', 0, 2, 12);
100INSERT INTO `yevgeniya_migranova`.`Game` (`Date`, `Stadium`, `HomeGoals`, `AwayGoals`, `ID`) VALUES ('2016-10-20', 'NSK Olimpiyskyi', 0, 2, 13);
101INSERT INTO `yevgeniya_migranova`.`Game` (`Date`, `Stadium`, `HomeGoals`, `AwayGoals`, `ID`) VALUES ('2016-10-20', 'Stadio San Paolo', 2, 3, 14);
102INSERT INTO `yevgeniya_migranova`.`Game` (`Date`, `Stadium`, `HomeGoals`, `AwayGoals`, `ID`) VALUES ('2016-10-20', 'Parc des Princes', 3, 0, 15);
103INSERT INTO `yevgeniya_migranova`.`Game` (`Date`, `Stadium`, `HomeGoals`, `AwayGoals`, `ID`) VALUES ('2016-10-20', 'Arsenal Stadium', 6, 0, 16);
104INSERT INTO `yevgeniya_migranova`.`Game` (`Date`, `Stadium`, `HomeGoals`, `AwayGoals`, `ID`) VALUES ('2016-11-01', 'Besiktas Arena', 1, 1, 17);
105INSERT INTO `yevgeniya_migranova`.`Game` (`Date`, `Stadium`, `HomeGoals`, `AwayGoals`, `ID`) VALUES ('2016-11-01', 'PSV Stadion', 1, 2, 18);
106INSERT INTO `yevgeniya_migranova`.`Game` (`Date`, `Stadium`, `HomeGoals`, `AwayGoals`, `ID`) VALUES ('2016-11-01', 'Estadio Vicente Calderón', 2, 1, 19);
107INSERT INTO `yevgeniya_migranova`.`Game` (`Date`, `Stadium`, `HomeGoals`, `AwayGoals`, `ID`) VALUES ('2016-11-01', 'City of Manchester Stadium', 3, 1, 20);
108INSERT INTO `yevgeniya_migranova`.`Game` (`Date`, `Stadium`, `HomeGoals`, `AwayGoals`, `ID`) VALUES ('2016-11-01', 'Borussia-Park', 1, 1, 21);
109INSERT INTO `yevgeniya_migranova`.`Game` (`Date`, `Stadium`, `HomeGoals`, `AwayGoals`, `ID`) VALUES ('2016-11-01', 'Estádio do Sport Lisboa e Benfica', 1, 0, 22);
110INSERT INTO `yevgeniya_migranova`.`Game` (`Date`, `Stadium`, `HomeGoals`, `AwayGoals`, `ID`) VALUES ('2016-11-01', 'St. Jakob-Park', 1, 2, 23);
111INSERT INTO `yevgeniya_migranova`.`Game` (`Date`, `Stadium`, `HomeGoals`, `AwayGoals`, `ID`) VALUES ('2016-11-01', 'Natsionalen Stadion Vasil Levski', 2, 3, 24);
112INSERT INTO `yevgeniya_migranova`.`Game` (`Date`, `Stadium`, `HomeGoals`, `AwayGoals`, `ID`) VALUES ('2016-11-03', 'Juventus Stadium', 1, 1, 25);
113INSERT INTO `yevgeniya_migranova`.`Game` (`Date`, `Stadium`, `HomeGoals`, `AwayGoals`, `ID`) VALUES ('2016-11-03', 'Estadio Ramón Sánchez Pizjuán', 4, 0, 26);
114INSERT INTO `yevgeniya_migranova`.`Game` (`Date`, `Stadium`, `HomeGoals`, `AwayGoals`, `ID`) VALUES ('2016-11-03', 'Estádio do Dragão', 1, 0, 27);
115
116INSERT INTO `yevgeniya_migranova`.`Team` (`Country`, `City`, `Coach`, `Name`) VALUES ('France', 'Lyon', 'Bruno Génésio', 'Lyon');
117INSERT INTO `yevgeniya_migranova`.`Team` (`Country`, `City`, `Coach`, `Name`) VALUES ('Croatia', 'Zagreb', 'Ivaylo Petev', 'Dinamo Zagreb');
118INSERT INTO `yevgeniya_migranova`.`Team` (`Country`, `City`, `Coach`, `Name`) VALUES ('Italy', 'Turin', 'Maurizio Trombetta', 'Juventus');
119INSERT INTO `yevgeniya_migranova`.`Team` (`Country`, `City`, `Coach`, `Name`) VALUES ('Spain', 'Seville', 'Jorge Sampaoli', 'Sevilla');
120INSERT INTO `yevgeniya_migranova`.`Team` (`Country`, `City`, `Coach`, `Name`) VALUES ('Belgium', 'Brugge', 'Michel Preud\'homme', 'Club Brugge');
121INSERT INTO `yevgeniya_migranova`.`Team` (`Country`, `City`, `Coach`, `Name`) VALUES ('Portugal', 'Porto', 'Nuno Espírito Santo', 'Porto');
122INSERT INTO `yevgeniya_migranova`.`Team` (`Country`, `City`, `Coach`, `Name`) VALUES ('England', 'Leicester', 'Claudio Ranieri', 'Leicester');
123INSERT INTO `yevgeniya_migranova`.`Team` (`Country`, `City`, `Coach`, `Name`) VALUES ('Denmark', 'Copenhagen', 'Stale Solbakken', 'Kobenhavn');
124INSERT INTO `yevgeniya_migranova`.`Team` (`Country`, `City`, `Coach`, `Name`) VALUES ('Spain', 'Madrid', 'Zinedine Zidane', 'Real Madrid');
125INSERT INTO `yevgeniya_migranova`.`Team` (`Country`, `City`, `Coach`, `Name`) VALUES ('Poland', 'Warszawa', 'Jacek Magiera', 'Legia');
126INSERT INTO `yevgeniya_migranova`.`Team` (`Country`, `City`, `Coach`, `Name`) VALUES ('NA', 'NA', 'NA', 'Sporting CP');
127INSERT INTO `yevgeniya_migranova`.`Team` (`Country`, `City`, `Coach`, `Name`) VALUES ('NA', 'NA', 'NA', 'Leverkusen');
128INSERT INTO `yevgeniya_migranova`.`Team` (`Country`, `City`, `Coach`, `Name`) VALUES ('NA', 'NA', 'NA', 'CSKA Moskva');
129INSERT INTO `yevgeniya_migranova`.`Team` (`Country`, `City`, `Coach`, `Name`) VALUES ('NA', 'NA', 'NA', 'Bayern');
130INSERT INTO `yevgeniya_migranova`.`Team` (`Country`, `City`, `Coach`, `Name`) VALUES ('NA', 'NA', 'NA', 'Rostov');
131INSERT INTO `yevgeniya_migranova`.`Team` (`Country`, `City`, `Coach`, `Name`) VALUES ('NA', 'NA', 'NA', 'Barcelona');
132INSERT INTO `yevgeniya_migranova`.`Team` (`Country`, `City`, `Coach`, `Name`) VALUES ('NA', 'NA', 'NA', 'Celtic');
133INSERT INTO `yevgeniya_migranova`.`Team` (`Country`, `City`, `Coach`, `Name`) VALUES ('NA', 'NA', 'NA', 'Dynamo Kyiv');
134INSERT INTO `yevgeniya_migranova`.`Team` (`Country`, `City`, `Coach`, `Name`) VALUES ('NA', 'NA', 'NA', 'Napoli');
135INSERT INTO `yevgeniya_migranova`.`Team` (`Country`, `City`, `Coach`, `Name`) VALUES ('NA', 'NA', 'NA', 'Paris');
136INSERT INTO `yevgeniya_migranova`.`Team` (`Country`, `City`, `Coach`, `Name`) VALUES ('NA', 'NA', 'NA', 'Arsenal');
137INSERT INTO `yevgeniya_migranova`.`Team` (`Country`, `City`, `Coach`, `Name`) VALUES ('NA', 'NA', 'NA', 'Besiktas');
138INSERT INTO `yevgeniya_migranova`.`Team` (`Country`, `City`, `Coach`, `Name`) VALUES ('NA', 'NA', 'NA', 'PSV');
139INSERT INTO `yevgeniya_migranova`.`Team` (`Country`, `City`, `Coach`, `Name`) VALUES ('NA', 'NA', 'NA', 'Atletico');
140INSERT INTO `yevgeniya_migranova`.`Team` (`Country`, `City`, `Coach`, `Name`) VALUES ('NA', 'NA', 'NA', 'Manchester City');
141INSERT INTO `yevgeniya_migranova`.`Team` (`Country`, `City`, `Coach`, `Name`) VALUES ('NA', 'NA', 'NA', 'Monchengladbach');
142INSERT INTO `yevgeniya_migranova`.`Team` (`Country`, `City`, `Coach`, `Name`) VALUES ('NA', 'NA', 'NA', 'Benfica');
143INSERT INTO `yevgeniya_migranova`.`Team` (`Country`, `City`, `Coach`, `Name`) VALUES ('NA', 'NA', 'NA', 'Basel');
144INSERT INTO `yevgeniya_migranova`.`Team` (`Country`, `City`, `Coach`, `Name`) VALUES ('NA', 'NA', 'NA', 'Ludogorets');
145INSERT INTO `yevgeniya_migranova`.`Team` (`Country`, `City`, `Coach`, `Name`) VALUES ('NA', 'NA', 'NA', 'Dortmund');
146INSERT INTO `yevgeniya_migranova`.`Team` (`Country`, `City`, `Coach`, `Name`) VALUES ('NA', 'NA', 'NA', 'Tottenham');
147INSERT INTO `yevgeniya_migranova`.`Team` (`Country`, `City`, `Coach`, `Name`) VALUES ('NA', 'NA', 'NA', 'Monaco');
148
149
150
151INSERT INTO `yevgeniya_migranova`.`Home_Team` (`Game_ID`, `Team_Name`) VALUES (1, 'Lyon');
152INSERT INTO `yevgeniya_migranova`.`Home_Team` (`Game_ID`, `Team_Name`) VALUES (2, 'Dinamo Zagreb');
153INSERT INTO `yevgeniya_migranova`.`Home_Team` (`Game_ID`, `Team_Name`) VALUES (3, 'Club Brugge');
154INSERT INTO `yevgeniya_migranova`.`Home_Team` (`Game_ID`, `Team_Name`) VALUES (4, 'Leicester');
155INSERT INTO `yevgeniya_migranova`.`Home_Team` (`Game_ID`, `Team_Name`) VALUES (5, 'Real Madrid');
156INSERT INTO `yevgeniya_migranova`.`Home_Team` (`Game_ID`, `Team_Name`) VALUES (6, 'Sporting CP');
157INSERT INTO `yevgeniya_migranova`.`Home_Team` (`Game_ID`, `Team_Name`) VALUES (7, 'Leverkusen');
158INSERT INTO `yevgeniya_migranova`.`Home_Team` (`Game_ID`, `Team_Name`) VALUES (8, 'CSKA Moskva');
159INSERT INTO `yevgeniya_migranova`.`Home_Team` (`Game_ID`, `Team_Name`) VALUES (9, 'Bayern');
160INSERT INTO `yevgeniya_migranova`.`Home_Team` (`Game_ID`, `Team_Name`) VALUES (10, 'Rostov');
161INSERT INTO `yevgeniya_migranova`.`Home_Team` (`Game_ID`, `Team_Name`) VALUES (11, 'Barcelona');
162INSERT INTO `yevgeniya_migranova`.`Home_Team` (`Game_ID`, `Team_Name`) VALUES (12, 'Celtic');
163INSERT INTO `yevgeniya_migranova`.`Home_Team` (`Game_ID`, `Team_Name`) VALUES (13, 'Dynamo Kyiv');
164INSERT INTO `yevgeniya_migranova`.`Home_Team` (`Game_ID`, `Team_Name`) VALUES (14, 'Napoli');
165INSERT INTO `yevgeniya_migranova`.`Home_Team` (`Game_ID`, `Team_Name`) VALUES (15, 'Paris');
166INSERT INTO `yevgeniya_migranova`.`Home_Team` (`Game_ID`, `Team_Name`) VALUES (16, 'Arsenal');
167INSERT INTO `yevgeniya_migranova`.`Home_Team` (`Game_ID`, `Team_Name`) VALUES (17, 'Besiktas');
168INSERT INTO `yevgeniya_migranova`.`Home_Team` (`Game_ID`, `Team_Name`) VALUES (18, 'PSV');
169INSERT INTO `yevgeniya_migranova`.`Home_Team` (`Game_ID`, `Team_Name`) VALUES (19, 'Atletico');
170INSERT INTO `yevgeniya_migranova`.`Home_Team` (`Game_ID`, `Team_Name`) VALUES (20, 'Manchester City');
171INSERT INTO `yevgeniya_migranova`.`Home_Team` (`Game_ID`, `Team_Name`) VALUES (21, 'Monchengladbach');
172INSERT INTO `yevgeniya_migranova`.`Home_Team` (`Game_ID`, `Team_Name`) VALUES (22, 'Benfica');
173INSERT INTO `yevgeniya_migranova`.`Home_Team` (`Game_ID`, `Team_Name`) VALUES (23, 'Basel');
174INSERT INTO `yevgeniya_migranova`.`Home_Team` (`Game_ID`, `Team_Name`) VALUES (24, 'Ludogorets');
175INSERT INTO `yevgeniya_migranova`.`Home_Team` (`Game_ID`, `Team_Name`) VALUES (25, 'Juventus');
176INSERT INTO `yevgeniya_migranova`.`Home_Team` (`Game_ID`, `Team_Name`) VALUES (26, 'Sevilla');
177INSERT INTO `yevgeniya_migranova`.`Home_Team` (`Game_ID`, `Team_Name`) VALUES (27, 'Porto');
178
179INSERT INTO `yevgeniya_migranova`.`Away_Team` (`Team_Name`, `Game_ID`) VALUES ('Juventus', 1);
180INSERT INTO `yevgeniya_migranova`.`Away_Team` (`Team_Name`, `Game_ID`) VALUES ('Sevilla', 2);
181INSERT INTO `yevgeniya_migranova`.`Away_Team` (`Team_Name`, `Game_ID`) VALUES ('Porto', 3);
182INSERT INTO `yevgeniya_migranova`.`Away_Team` (`Team_Name`, `Game_ID`) VALUES ('Kobenhavn', 4);
183INSERT INTO `yevgeniya_migranova`.`Away_Team` (`Team_Name`, `Game_ID`) VALUES ('Legia', 5);
184INSERT INTO `yevgeniya_migranova`.`Away_Team` (`Team_Name`, `Game_ID`) VALUES ('Dortmund', 6);
185INSERT INTO `yevgeniya_migranova`.`Away_Team` (`Team_Name`, `Game_ID`) VALUES ('Tottenham', 7);
186INSERT INTO `yevgeniya_migranova`.`Away_Team` (`Team_Name`, `Game_ID`) VALUES ('Monaco', 8);
187INSERT INTO `yevgeniya_migranova`.`Away_Team` (`Team_Name`, `Game_ID`) VALUES ('PSV', 9);
188INSERT INTO `yevgeniya_migranova`.`Away_Team` (`Team_Name`, `Game_ID`) VALUES ('Atletico', 10);
189INSERT INTO `yevgeniya_migranova`.`Away_Team` (`Team_Name`, `Game_ID`) VALUES ('Manchester City', 11);
190INSERT INTO `yevgeniya_migranova`.`Away_Team` (`Team_Name`, `Game_ID`) VALUES ('Monchengladbach', 12);
191INSERT INTO `yevgeniya_migranova`.`Away_Team` (`Team_Name`, `Game_ID`) VALUES ('Benfica', 13);
192INSERT INTO `yevgeniya_migranova`.`Away_Team` (`Team_Name`, `Game_ID`) VALUES ('Besiktas', 14);
193INSERT INTO `yevgeniya_migranova`.`Away_Team` (`Team_Name`, `Game_ID`) VALUES ('Basel', 15);
194INSERT INTO `yevgeniya_migranova`.`Away_Team` (`Team_Name`, `Game_ID`) VALUES ('Ludogorets', 16);
195INSERT INTO `yevgeniya_migranova`.`Away_Team` (`Team_Name`, `Game_ID`) VALUES ('Napoli', 17);
196INSERT INTO `yevgeniya_migranova`.`Away_Team` (`Team_Name`, `Game_ID`) VALUES ('Bayern', 18);
197INSERT INTO `yevgeniya_migranova`.`Away_Team` (`Team_Name`, `Game_ID`) VALUES ('Rostov', 19);
198INSERT INTO `yevgeniya_migranova`.`Away_Team` (`Team_Name`, `Game_ID`) VALUES ('Barcelona', 20);
199INSERT INTO `yevgeniya_migranova`.`Away_Team` (`Team_Name`, `Game_ID`) VALUES ('Celtic', 21);
200INSERT INTO `yevgeniya_migranova`.`Away_Team` (`Team_Name`, `Game_ID`) VALUES ('Barcelona', 22);
201INSERT INTO `yevgeniya_migranova`.`Away_Team` (`Team_Name`, `Game_ID`) VALUES ('Paris', 23);
202INSERT INTO `yevgeniya_migranova`.`Away_Team` (`Team_Name`, `Game_ID`) VALUES ('Arsenal', 24);
203INSERT INTO `yevgeniya_migranova`.`Away_Team` (`Team_Name`, `Game_ID`) VALUES ('Lyon', 25);
204INSERT INTO `yevgeniya_migranova`.`Away_Team` (`Team_Name`, `Game_ID`) VALUES ('Dinamo Zagreb', 26);
205INSERT INTO `yevgeniya_migranova`.`Away_Team` (`Team_Name`, `Game_ID`) VALUES ('Club Brugge', 27);
206
207INSERT INTO `yevgeniya_migranova`.`Player` (`Number`, `Name`, `Position`, `Team_Name`) VALUES (1, 'Keylor Navas', 'G', 'Real Madrid');
208INSERT INTO `yevgeniya_migranova`.`Player` (`Number`, `Name`, `Position`, `Team_Name`) VALUES (2, 'Dani Carvaja', 'D', 'Real Madrid');
209INSERT INTO `yevgeniya_migranova`.`Player` (`Number`, `Name`, `Position`, `Team_Name`) VALUES (3, 'Pepe', 'D', 'Real Madrid');
210INSERT INTO `yevgeniya_migranova`.`Player` (`Number`, `Name`, `Position`, `Team_Name`) VALUES (6, 'Nacho', 'D', 'Real Madrid');
211INSERT INTO `yevgeniya_migranova`.`Player` (`Number`, `Name`, `Position`, `Team_Name`) VALUES (7, 'Cristiano Ronaldo', 'A', 'Real Madrid');
212INSERT INTO `yevgeniya_migranova`.`Player` (`Number`, `Name`, `Position`, `Team_Name`) VALUES (8, 'Toni Kroos', 'M', 'Real Madrid');
213INSERT INTO `yevgeniya_migranova`.`Player` (`Number`, `Name`, `Position`, `Team_Name`) VALUES (9, 'Karim Benzema', 'A', 'Real Madrid');
214INSERT INTO `yevgeniya_migranova`.`Player` (`Number`, `Name`, `Position`, `Team_Name`) VALUES (11, 'Gareth Bale', 'A', 'Real Madrid');
215INSERT INTO `yevgeniya_migranova`.`Player` (`Number`, `Name`, `Position`, `Team_Name`) VALUES (15, 'Fabio Coentrao', 'D', 'Real Madrid');
216INSERT INTO `yevgeniya_migranova`.`Player` (`Number`, `Name`, `Position`, `Team_Name`) VALUES (16, 'Mateo Kovacic', 'M', 'Real Madrid');
217INSERT INTO `yevgeniya_migranova`.`Player` (`Number`, `Name`, `Position`, `Team_Name`) VALUES (21, 'Alvario Morata', 'A', 'Real Madrid');
218INSERT INTO `yevgeniya_migranova`.`Player` (`Number`, `Name`, `Position`, `Team_Name`) VALUES (1, 'Arkadiusz Malarz', 'G', 'Legia');
219INSERT INTO `yevgeniya_migranova`.`Player` (`Number`, `Name`, `Position`, `Team_Name`) VALUES (2, 'Michał Pazdan', 'D', 'Legia');
220INSERT INTO `yevgeniya_migranova`.`Player` (`Number`, `Name`, `Position`, `Team_Name`) VALUES (6, 'Guilherme', 'M', 'Legia');
221INSERT INTO `yevgeniya_migranova`.`Player` (`Number`, `Name`, `Position`, `Team_Name`) VALUES (8, 'Vadis Odjidja', 'M', 'Legia');
222INSERT INTO `yevgeniya_migranova`.`Player` (`Number`, `Name`, `Position`, `Team_Name`) VALUES (11, 'Nemanja Nikolić', 'A', 'Legia');
223INSERT INTO `yevgeniya_migranova`.`Player` (`Number`, `Name`, `Position`, `Team_Name`) VALUES (14, 'Adam Hloušek', 'D', 'Legia');
224INSERT INTO `yevgeniya_migranova`.`Player` (`Number`, `Name`, `Position`, `Team_Name`) VALUES (15, 'Michał Kopczyński', 'M', 'Legia');
225INSERT INTO `yevgeniya_migranova`.`Player` (`Number`, `Name`, `Position`, `Team_Name`) VALUES (19, 'Bartosz Bereszyński', 'D', 'Legia');
226INSERT INTO `yevgeniya_migranova`.`Player` (`Number`, `Name`, `Position`, `Team_Name`) VALUES (25, 'Jakub Rzeźniczak', 'D', 'Legia');
227INSERT INTO `yevgeniya_migranova`.`Player` (`Number`, `Name`, `Position`, `Team_Name`) VALUES (32, 'Miroslav Radović', 'M', 'Legia');
228INSERT INTO `yevgeniya_migranova`.`Player` (`Number`, `Name`, `Position`, `Team_Name`) VALUES (75, 'Thibault Moulin', 'M', 'Legia');
229
230
231INSERT INTO `yevgeniya_migranova`.`Player_has_Game` (`Player_Name`, `YellowCards`, `RedCards`, `Goals`, `Game_ID`) VALUES ('Keylor Navas', 0, 0, 0, 1);
232INSERT INTO `yevgeniya_migranova`.`Player_has_Game` (`Player_Name`, `YellowCards`, `RedCards`, `Goals`, `Game_ID`) VALUES ('Dani Carvajal', 0, 0, 0, 1);
233INSERT INTO `yevgeniya_migranova`.`Player_has_Game` (`Player_Name`, `YellowCards`, `RedCards`, `Goals`, `Game_ID`) VALUES ('Pepe', 1, 0, 0, 1);
234INSERT INTO `yevgeniya_migranova`.`Player_has_Game` (`Player_Name`, `YellowCards`, `RedCards`, `Goals`, `Game_ID`) VALUES ('Nacho', 0, 0, 0, 1);
235INSERT INTO `yevgeniya_migranova`.`Player_has_Game` (`Player_Name`, `YellowCards`, `RedCards`, `Goals`, `Game_ID`) VALUES ('  Cristiano Ronaldo', 0, 0, 0, 1);
236INSERT INTO `yevgeniya_migranova`.`Player_has_Game` (`Player_Name`, `YellowCards`, `RedCards`, `Goals`, `Game_ID`) VALUES ('Toni Kroos', 0, 0, 0, 1);
237INSERT INTO `yevgeniya_migranova`.`Player_has_Game` (`Player_Name`, `YellowCards`, `RedCards`, `Goals`, `Game_ID`) VALUES ('Karim Benzema', 1, 0, 1, 1);
238INSERT INTO `yevgeniya_migranova`.`Player_has_Game` (`Player_Name`, `YellowCards`, `RedCards`, `Goals`, `Game_ID`) VALUES ('Gareth Bale', 0, 0, 1, 1);
239INSERT INTO `yevgeniya_migranova`.`Player_has_Game` (`Player_Name`, `YellowCards`, `RedCards`, `Goals`, `Game_ID`) VALUES ('Fabio Coentrao', 0, 1, 0, 1);
240INSERT INTO `yevgeniya_migranova`.`Player_has_Game` (`Player_Name`, `YellowCards`, `RedCards`, `Goals`, `Game_ID`) VALUES ('Mateo Kovacic', 0, 0, 1, 1);
241INSERT INTO `yevgeniya_migranova`.`Player_has_Game` (`Player_Name`, `YellowCards`, `RedCards`, `Goals`, `Game_ID`) VALUES ('Alvario Morata', 0, 0, 0, 1);
242INSERT INTO `yevgeniya_migranova`.`Player_has_Game` (`Player_Name`, `YellowCards`, `RedCards`, `Goals`, `Game_ID`) VALUES ('Arkadiusz Malarz', 0, 0, 0, 1);
243INSERT INTO `yevgeniya_migranova`.`Player_has_Game` (`Player_Name`, `YellowCards`, `RedCards`, `Goals`, `Game_ID`) VALUES ('Michał Pazdan', 0, 0, 0, 1);
244INSERT INTO `yevgeniya_migranova`.`Player_has_Game` (`Player_Name`, `YellowCards`, `RedCards`, `Goals`, `Game_ID`) VALUES ('Guilherme', 0, 0, 0, 1);
245INSERT INTO `yevgeniya_migranova`.`Player_has_Game` (`Player_Name`, `YellowCards`, `RedCards`, `Goals`, `Game_ID`) VALUES ('Vadis Odjidja', 0, 0, 1, 1);
246INSERT INTO `yevgeniya_migranova`.`Player_has_Game` (`Player_Name`, `YellowCards`, `RedCards`, `Goals`, `Game_ID`) VALUES ('Nemanja Nikolić', 0, 0, 0, 1);
247INSERT INTO `yevgeniya_migranova`.`Player_has_Game` (`Player_Name`, `YellowCards`, `RedCards`, `Goals`, `Game_ID`) VALUES ('Adam Hloušek', 0, 0, 0, 1);
248INSERT INTO `yevgeniya_migranova`.`Player_has_Game` (`Player_Name`, `YellowCards`, `RedCards`, `Goals`, `Game_ID`) VALUES ('Michał Kopczyński', 0, 0, 0, 1);
249INSERT INTO `yevgeniya_migranova`.`Player_has_Game` (`Player_Name`, `YellowCards`, `RedCards`, `Goals`, `Game_ID`) VALUES ('Bartosz Bereszyński', 0, 0, 0, 1);
250INSERT INTO `yevgeniya_migranova`.`Player_has_Game` (`Player_Name`, `YellowCards`, `RedCards`, `Goals`, `Game_ID`) VALUES ('Jakub Rzeźniczak', 1, 0, 0, 1);
251INSERT INTO `yevgeniya_migranova`.`Player_has_Game` (`Player_Name`, `YellowCards`, `RedCards`, `Goals`, `Game_ID`) VALUES ('Miroslav Radović', 0, 0, 1, 1);
252INSERT INTO `yevgeniya_migranova`.`Player_has_Game` (`Player_Name`, `YellowCards`, `RedCards`, `Goals`, `Game_ID`) VALUES ('Thibault Moulin', 0, 0, 1, 1);