5Uubu0qc

· 10 years ago · Sep 26, 2016, 07:00 PM
1//JUGADOR
2
3-- phpMyAdmin SQL Dump
4-- version 4.1.14
5-- http://www.phpmyadmin.net
6--
7-- Host: 127.0.0.1
8-- Generation Time: 26-09-2016 a les 20:41:45
9-- VersiÃƒÂ³ del servidor: 5.6.17
10-- PHP Version: 5.5.12
11
12SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
13SET time_zone = "+00:00";
14
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8 */;
20
21--
22-- Database: `balonoro`
23--
24
25-- --------------------------------------------------------
26
27--
28-- Estructura de la taula `jugador`
29--
30
31CREATE TABLE IF NOT EXISTS `jugador` (
32  `cod_jugador` int(11) NOT NULL AUTO_INCREMENT,
33  `nombre` text NOT NULL,
34  `nacionalidad` text NOT NULL,
35  `wiki` text NOT NULL,
36  PRIMARY KEY (`cod_jugador`)
37) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=685 ;
38
39--
40-- Bolcant dades de la taula `jugador`
41--
42
43INSERT INTO `jugador` (`cod_jugador`, `nombre`, `nacionalidad`, `wiki`) VALUES
44(597, 'Alain Giresse', 'FRA', 'https://en.wikipedia.org/wiki/Alain_Giresse'),
45(640, 'Alan Shearer', 'ENG', 'https://en.wikipedia.org/wiki/Alan_Shearer'),
46(519, 'Alfredo Di StÃƒÆ’Ã‚Â©fano', 'SPA', 'https://en.wikipedia.org/wiki/Alfredo_Di_St%C3%A9fano'),
47(601, 'Allan Simonsen', 'DEN', ''),
48(544, 'Amancio', 'ESP', 'https://en.wikipedia.org/wiki/Amancio_Amaro'),
49(622, 'Andreas Brehme', 'GER', ''),
50(662, 'Andriy Shevchenko', 'UKR', ''),
51(607, 'Bernd Schuster', 'FRG', ''),
52(522, 'Billy Wright', 'ENG', ''),
53(555, 'Bobby Charlton', 'ENG', ''),
54(561, 'Bobby Moore', 'ENG', ''),
55(674, 'Cristiano Ronaldo', 'POR', ''),
56(648, 'David Beckham', 'ENG', ''),
57(645, 'Davor Ãƒâ€¦Ã‚Â uker', 'CRO', ''),
58(663, 'Deco', 'POR', ''),
59(624, 'Dejan SaviÃƒâ€žÃ¢â‚¬Â¡eviÃƒâ€žÃ¢â‚¬Â¡', 'YUG', ''),
60(542, 'Denis LawÂ (SCO)', '', ''),
61(630, 'Dennis Bergkamp', 'NED', ''),
62(570, 'Dino Zoff', 'ITA', ''),
63(556, 'Dragan DÃƒâ€¦Ã‚Â¾ajiÃƒâ€žÃ¢â‚¬Â¡', 'YUG', ''),
64(523, 'Duncan Edwards', 'ENG', ''),
65(613, 'Emilio ButragueÃƒÆ’Ã‚Â±o', 'SPA', ''),
66(631, 'Eric Cantona', 'FRA', ''),
67(549, 'EusÃƒÆ’Ã‚Â©bio', 'POR', ''),
68(668, 'Fabio Cannavaro', 'ITA', ''),
69(531, 'Ferenc PuskÃƒÆ’Ã‚Â¡s', 'HUN', ''),
70(676, 'Fernando Torres', 'SPA', ''),
71(551, 'FlÃƒÆ’Ã‚Â³riÃƒÆ’Ã‚Â¡n Albert', 'HUN', ''),
72(618, 'Franco Baresi', 'ITA', ''),
73(666, 'Frank Lampard', 'ENG', ''),
74(619, 'Frank Rijkaard', 'NED', ''),
75(578, 'Franz Beckenbauer', 'W_GER', ''),
76(609, 'Gary Lineker', 'ENG', ''),
77(565, 'George Best', 'NIR', ''),
78(635, 'George Weah', 'LBR', ''),
79(559, 'Gerd MÃƒÆ’Ã‚Â¼ller', 'W_GER', ''),
80(546, 'Giacinto Facchetti', 'ITA', ''),
81(669, 'Gianluigi Buffon', 'ITA', ''),
82(557, 'Gianni Rivera', 'ITA', ''),
83(585, 'Hans KranklÂ (AUT)', '', ''),
84(525, 'Helmut Rahn', 'W_GER', ''),
85(632, 'Hristo StoichkovÂ (BUL)', '', ''),
86(608, 'Igor Belanov', 'URS', ''),
87(580, 'Ivo Viktor', 'TCH', ''),
88(637, 'Jari Litmanen', 'FIN', ''),
89(636, 'JÃƒÆ’Ã‚Â¼rgen Klinsmann', 'GER', ''),
90(603, 'Jean Tigana', 'FRA', ''),
91(623, 'Jean-Pierre Papin', 'FRA', ''),
92(541, 'Jimmy Greaves', 'ENG', ''),
93(553, 'Jimmy Johnstone', 'SCO', ''),
94(563, 'Johan Cruyff', 'NED', ''),
95(529, 'John Charles', 'WAL', ''),
96(535, 'Johnny Haynes', 'ENG', ''),
97(536, 'Josef Masopust', 'TCH', ''),
98(526, 'Just Fontaine', 'FRA', ''),
99(671, 'KakÃƒÆ’Ã‚Â¡', 'BRA', ''),
100(538, 'Karl-Heinz Schnellinger', 'W_GER', ''),
101(574, 'Kazimierz Deyna', 'POL', ''),
102(600, 'Kenny Dalglish', 'SCO', ''),
103(584, 'Kevin Keegan', 'ENG', ''),
104(539, 'Lev Yashin', 'URS', ''),
105(677, 'Lionel Messi', 'ARG', ''),
106(620, 'Lothar MatthÃƒÆ’Ã‚Â¤us', 'GER', ''),
107(650, 'LuÃƒÆ’Ã‚Âs Figo', 'POR', ''),
108(562, 'Luigi Riva', 'ITA', ''),
109(547, 'Luis SuÃƒÆ’Ã‚Â¡rez', 'SPA', ''),
110(626, 'Marco van Basten', 'NED', ''),
111(638, 'Matthias Sammer', 'GER', ''),
112(653, 'Michael Owen', 'ENG', ''),
113(605, 'Michel Platini', 'FRA', ''),
114(575, 'Oleg Blokhin', 'URS', ''),
115(658, 'Oliver Kahn', 'GER', ''),
116(533, 'Omar SÃƒÆ’Ã‚Âvori', 'ITA', ''),
117(661, 'Paolo Maldini', 'ITA', ''),
118(596, 'Paolo Rossi', 'ITA', ''),
119(594, 'Paul Breitner', 'W_GER', ''),
120(612, 'Paulo FutreÂ (POR)', '', ''),
121(659, 'Pavel NedvÃƒâ€žÃ¢â‚¬ÂºdÂ (CZE)', '', ''),
122(606, 'Preben ElkjÃƒÆ’Ã‚Â¦r', 'DEN', ''),
123(642, 'Predrag MijatoviÃƒâ€žÃ¢â‚¬Â¡', 'YUG', ''),
124(654, 'RaÃƒÆ’Ã‚Âºl', 'SPA', ''),
125(528, 'Raymond Kopa', 'FRA', ''),
126(647, 'RivaldoÂ (BRA)', '', ''),
127(586, 'Rob Rensenbrink', 'NED', ''),
128(633, 'Roberto Baggio', 'ITA', ''),
129(657, 'Roberto Carlos', 'BRA', ''),
130(665, 'Ronaldinho', 'BRA', ''),
131(646, 'Ronaldo', 'BRA', ''),
132(615, 'Ruud Gullit', 'NED', ''),
133(589, 'Ruud Krol', 'NED', ''),
134(621, 'Salvatore Schillaci', 'ITA', ''),
135(564, 'Sandro Mazzola', 'ITA', ''),
136(518, 'Stanley Matthews', 'ENG', ''),
137(667, 'Steven Gerrard', 'ENG', ''),
138(670, 'Thierry Henry', 'FRA', ''),
139(532, 'Uwe Seeler', 'W_GER', ''),
140(681, 'Xavi', 'SPA', ''),
141(651, 'Zinedine Zidane', 'FRA', '');
142
143/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
144/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
145/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
146
147
148
149
150
151//EQUIPO
152
153
154-- phpMyAdmin SQL Dump
155-- version 4.1.14
156-- http://www.phpmyadmin.net
157--
158-- Host: 127.0.0.1
159-- Generation Time: 26-09-2016 a les 20:56:24
160-- VersiÃƒÂ³ del servidor: 5.6.17
161-- PHP Version: 5.5.12
162
163SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
164SET time_zone = "+00:00";
165
166
167/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
168/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
169/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
170/*!40101 SET NAMES utf8 */;
171
172--
173-- Database: `balonoro`
174--
175
176-- --------------------------------------------------------
177
178--
179-- Estructura de la taula `equipo`
180--
181
182CREATE TABLE IF NOT EXISTS `equipo` (
183  `cod_equipo` int(11) NOT NULL AUTO_INCREMENT,
184  `nombre` text NOT NULL,
185  `nacionalidad` text NOT NULL,
186  `wiki` text NOT NULL,
187  PRIMARY KEY (`cod_equipo`)
188) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1368 ;
189
190--
191-- Bolcant dades de la taula `equipo`
192--
193
194INSERT INTO `equipo` (`cod_equipo`, `nombre`, `nacionalidad`, `wiki`) VALUES
195(1271, 'Ajax', '', ''),
196(1268, 'Anderlecht', '', ''),
197(1352, 'Arsenal', '', ''),
198(1294, 'AtlÃƒÆ’Ã‚Â©tico Madrid', '', ''),
199(1277, 'Barcelona', '', ''),
200(1276, 'Bayern Munich', '', ''),
201(1231, 'Benfica', '', ''),
202(1200, 'Blackpool', '', ''),
203(1279, 'Bordeaux', '', ''),
204(1320, 'Borussia Dortmund', '', ''),
205(1263, 'Borussia MÃƒÆ’Ã‚Â¶nchengladbach', '', ''),
206(1244, 'Cagliari', '', ''),
207(1235, 'Celtic', '', ''),
208(1348, 'Chelsea', '', ''),
209(1262, 'Dukla Prague', '', ''),
210(1257, 'Dynamo Kyiv', '', ''),
211(1221, 'Dynamo Moscow', '', ''),
212(1233, 'FerencvÃƒÆ’Ã‚Â¡ros', '', ''),
213(1217, 'Fulham', '', ''),
214(1269, 'Hamburg', '', ''),
215(1288, 'Hellas Verona', '', ''),
216(1246, 'Inter Milan', '', ''),
217(1278, 'Juventus', '', ''),
218(1220, 'KÃƒÆ’Ã‚Â¶ln', '', ''),
219(1256, 'Legia Warsaw', '', ''),
220(1358, 'Liverpool', '', ''),
221(1247, 'Manchester United', '', ''),
222(1305, 'Marseille', '', ''),
223(1239, 'Milan', '', ''),
224(1265, 'Nancy', '', ''),
225(1322, 'Newcastle United', '', ''),
226(1226, 'Real Madrid', '', ''),
227(1238, 'Red Star Belgrade', '', ''),
228(1207, 'Rot-Weiss Essen', '', ''),
229(1274, 'Saint-ÃƒÆ’Ã¢â‚¬Â°tienne', '', ''),
230(1208, 'Stade de Reims', '', ''),
231(1223, 'Tottenham Hotspur', '', ''),
232(1283, 'Vejle', '', ''),
233(1243, 'West Ham United', '', ''),
234(1204, 'Wolverhampton Wanderers', '', '');
235
236/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
237/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
238/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;