API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 26th, 2016
100
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.57 KB | None | 0 0
raw download clone embed print report
  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.  
  12. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  13. SET 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.  
  31. CREATE 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.  
  43. INSERT 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.  
  163. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  164. SET 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.  
  182. CREATE 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.  
  194. INSERT 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 */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!