API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 8th, 2018
81
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.11 KB | None | 0 0
raw download clone embed print report
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.7.4
  3. -- https://www.phpmyadmin.net/
  4. --
  5. -- Servidor: 127.0.0.1:3306
  6. -- Tiempo de generación: 08-05-2018 a las 18:44:55
  7. -- Versión del servidor: 5.7.19
  8. -- Versión de PHP: 5.6.31
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET AUTOCOMMIT = 0;
  12. START TRANSACTION;
  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 utf8mb4 */;
  20.  
  21. --
  22. -- Base de datos: `tote`
  23. --
  24.  
  25. -- --------------------------------------------------------
  26.  
  27. --
  28. -- Estructura de tabla para la tabla `coches`
  29. --
  30.  
  31. DROP TABLE IF EXISTS `coches`;
  32. CREATE TABLE IF NOT EXISTS `coches` (
  33. `id` int(11) NOT NULL AUTO_INCREMENT,
  34. `Descripcion` varchar(255) NOT NULL DEFAULT 'Ninguno',
  35. `Posicion` varchar(255) NOT NULL,
  36. `Rotacion` varchar(255) NOT NULL,
  37. `Color1` int(11) NOT NULL DEFAULT '0',
  38. `Color2` int(11) NOT NULL DEFAULT '0',
  39. `Owner` varchar(255) NOT NULL DEFAULT 'Nadie',
  40. `OwnerId` int(11) NOT NULL DEFAULT '0',
  41. `Matricula` int(11) NOT NULL,
  42. `Valor` int(11) NOT NULL DEFAULT '1000',
  43. `Faccion` int(11) NOT NULL DEFAULT '100',
  44. `Trabajo` int(11) NOT NULL DEFAULT '100',
  45. `Bloqueo` int(11) NOT NULL DEFAULT '0',
  46. `Motor` int(11) NOT NULL DEFAULT '0',
  47. `Gasolina` float NOT NULL DEFAULT '100',
  48. `Kms` float NOT NULL DEFAULT '0',
  49. `Maletero` varchar(255) NOT NULL DEFAULT '0/0/0/0/0/0/0/0/0/0',
  50. `MaleteroCant` varchar(255) NOT NULL DEFAULT '0/0/0/0/0/0/0/0/0/0',
  51. PRIMARY KEY (`id`)
  52. ) ENGINE=MyISAM AUTO_INCREMENT=45 DEFAULT CHARSET=latin1;
  53.  
  54. --
  55. -- Volcado de datos para la tabla `coches`
  56. --
  57.  
  58. INSERT INTO `coches` (`id`, `Descripcion`, `Posicion`, `Rotacion`, `Color1`, `Color2`, `Owner`, `OwnerId`, `Matricula`, `Valor`, `Faccion`, `Trabajo`, `Bloqueo`, `Motor`, `Gasolina`, `Kms`, `Maletero`, `MaleteroCant`) VALUES
  59. (1, 'oppressor', '-762,1589.-2166,446.14,45611', '2,468693.-15,14179.135,0977', 5, 5, 'Adams Lawrence', 6, 1000, 1000, 100, 100, 0, 0, 100, 0, '0/0/0/0/0/0/0/0/0/0', '0/0/0/0/0/0/0/0/0/0'),
  60. (2, 'oppressor', '-304,7492.-1984,03.65,08382', '7,332932.-8,359082.57,38369', 0, 0, 'Nadie', 0, 1001, 1000, 100, 100, 0, 0, 100, 0, '0/0/0/0/0/0/0/0/0/0', '0/0/0/0/0/0/0/0/0/0'),
  61. (4, 'prototipo', '-483,3439.-366,9656.33,6564', '-1,664196.-0,2373741.-86,60223', 1, 1, 'Nadie', 0, 1003, 1000, 100, 100, 0, 0, 100, 0, '0/0/0/0/0/0/0/0/0/0', '0/0/0/0/0/0/0/0/0/0'),
  62. (3, 'prototipo', '-771,0575.-2150,128.8,12795', '0,1736598.0,07637034.1,867379', 6, 6, 'Nadie', 0, 1002, 1000, 100, 100, 0, 0, 100, 0, '0/0/0/0/0/0/0/0/0/0', '0/0/0/0/0/0/0/0/0/0'),
  63. (5, 'polmav', '-528,4127.-350,1689.35,48033', '2,097943.0,8014514.45,54034', 0, 0, 'Nadie', 0, 1004, 1000, 100, 100, 0, 0, 100, 0, '0/0/0/0/0/0/0/0/0/0', '0/0/0/0/0/0/0/0/0/0'),
  64. (6, 'police4', '-441,9116.6026,828.30,94608', '0,004266799.-0,03064835.38,3589', 15, 15, 'Nadie', 0, 1005, 1000, 100, 100, 0, 0, 100, 0, '0/0/0/0/0/0/0/0/0/0', '0/0/0/0/0/0/0/0/0/0'),
  65. (7, 'fbi2', '-468,5888.-356,6702.33,66637', '3,277113.0,1311203.-36,45461', 0, 0, 'Nadie', 0, 1006, 1000, 100, 100, 0, 0, 100, 0, '0/0/0/0/0/0/0/0/0/0', '0/0/0/0/0/0/0/0/0/0'),
  66. (8, 'fbi', '-512,9543.-395,4571.34,68443', '-0,7298238.0,04537994.-129,672', 0, 0, 'Nadie', 0, 1007, 1000, 100, 100, 0, 0, 100, 0, '0/0/0/0/0/0/0/0/0/0', '0/0/0/0/0/0/0/0/0/0'),
  67. (9, 'polmav', '-475,9108.5988,06.31,72503', '0,4379527.0,003175771.-43,36657', 1, 0, 'Nadie', 0, 1008, 1000, 100, 100, 0, 0, 100, 0, '0/0/0/0/0/0/0/0/0/0', '0/0/0/0/0/0/0/0/0/0'),
  68. (10, 'police', '-452,5297.6050,142.30,94595', '0,00235838.0,01177697.-141,9224', 15, 122, 'Nadie', 0, 1009, 1000, 100, 100, 0, 0, 100, 0, '0/0/0/0/0/0/0/0/0/0', '0/0/0/0/0/0/0/0/0/0'),
  69. (11, 'sheriff', '-448,8553.6052,754.30,94481', '0,4434006.-0,02706925.-146,471', 0, 0, 'Nadie', 0, 1010, 1000, 100, 100, 0, 0, 100, 0, '0/0/0/0/0/0/0/0/0/0', '0/0/0/0/0/0/0/0/0/0'),
  70. (12, 'police', '-204,8176.6445,528.30,80561', '0,5246453.1,165299.85,8576', 122, 122, 'Nadie', 0, 1011, 1000, 100, 100, 0, 0, 100, 0, '0/0/0/0/0/0/0/0/0/0', '0/0/0/0/0/0/0/0/0/0'),
  71. (13, 'police2', '-479,0694.6027,876.30,95212', '-0,03257794.-0,01476166.-133,8068', 122, 122, 'Nadie', 0, 1012, 1000, 100, 100, 0, 0, 100, 0, '0/0/0/0/0/0/0/0/0/0', '0/0/0/0/0/0/0/0/0/0'),
  72. (14, 'police3', '-475,4362.6031,107.31,0951', '0,02227975.-0,007791796.-136,3884', 122, 122, 'Nadie', 0, 1013, 1000, 100, 100, 0, 0, 100, 0, '0/0/0/0/0/0/0/0/0/0', '0/0/0/0/0/0/0/0/0/0'),
  73. (15, 'riot', '-448,0429.5994,483.30,99244', '-0,01000859.-0,06412689.85,70489', 0, 0, 'Nadie', 0, 1014, 1000, 100, 100, 0, 0, 100, 0, '0/0/0/0/0/0/0/0/0/0', '0/0/0/0/0/0/0/0/0/0'),
  74. (16, 'fbi', '-482,5787.6024,638.30,98591', '-0,03104311.-0,02301372.-137,3295', 87, 87, 'Nadie', 0, 1015, 1000, 100, 100, 0, 0, 100, 0, '0/0/0/0/0/0/0/0/0/0', '0/0/0/0/0/0/0/0/0/0'),
  75. (17, 'fbi2', '-452,4152.5998,547.30,96199', '0,0008722861.-0,009562001.87,45822', 78, 78, 'Nadie', 0, 1016, 1000, 100, 100, 0, 0, 100, 0, '0/0/0/0/0/0/0/0/0/0', '0/0/0/0/0/0/0/0/0/0'),
  76. (18, 'apc', '-455,2198.6001,889.31,0348', '0,01991613.0,003859397.85,0641', 12, 12, 'Nadie', 0, 1017, 1000, 100, 100, 0, 0, 100, 0, '0/0/0/0/0/0/0/0/0/0', '0/0/0/0/0/0/0/0/0/0'),
  77. (19, 'ocelot', '-466,0588.6020,623.31,34053', '0.0.-17,71742', 0, 0, 'Nadie', 0, 1018, 1000, 100, 100, 0, 0, 100, 0, '0/0/0/0/0/0/0/0/0/0', '0/0/0/0/0/0/0/0/0/0'),
  78. (20, 'towtruck', '-456,4201.6039,394.31,30625', '-0,6814824.-0,02175391.133,9338', 0, 0, 'Nadie', 0, 1019, 1000, 100, 100, 0, 0, 100, 0, '0/0/0/0/0/0/0/0/0/0', '0/0/0/0/0/0/0/0/0/0'),
  79. (21, 'sheriff', '-11,46091.6524,518.31,03648', '0,4706103.0,8315488.138,3058', 1, 1, 'Nadie', 0, 1020, 1000, 100, 100, 0, 0, 100, 0, '0/0/0/0/0/0/0/0/0/0', '0/0/0/0/0/0/0/0/0/0'),
  80. (22, 'sheriff', '-469,0102.6038,546.30,94477', '0,4449092.-0,03676161.-134,7149', 131, 1, 'Nadie', 0, 1021, 1000, 100, 100, 0, 0, 100, 0, '0/0/0/0/0/0/0/0/0/0', '0/0/0/0/0/0/0/0/0/0'),
  81. (23, 'police4', '-472,2136.6034,911.30,94609', '0,005912735.-0,03178133.-138,4325', 3, 3, 'Nadie', 0, 1022, 1000, 100, 100, 0, 0, 100, 0, '0/0/0/0/0/0/0/0/0/0', '0/0/0/0/0/0/0/0/0/0'),
  82. (24, 'fbi1', '-433,0366.6036,315.31,34069', '0.0.100,9772', 1, 1, 'Nadie', 0, 1023, 1000, 100, 100, 0, 0, 100, 0, '0/0/0/0/0/0/0/0/0/0', '0/0/0/0/0/0/0/0/0/0'),
  83. (25, 'fbi1', '-434,3193.6035,867.31,34054', '0.0.-167,7309', 0, 0, 'Nadie', 0, 1024, 1000, 100, 100, 0, 0, 100, 0, '0/0/0/0/0/0/0/0/0/0', '0/0/0/0/0/0/0/0/0/0'),
  84. (26, 'fbi', '342,2905.6781,498.40,8257', '41,06572.-29,6558.37,14275', 0, 0, 'Nadie', 0, 1025, 1000, 100, 100, 0, 0, 100, 0, '0/0/0/0/0/0/0/0/0/0', '0/0/0/0/0/0/0/0/0/0'),
  85. (27, 'police2', '-299,5914.6223,729.31,02838', '1,172051.-1,319303.133,3375', 3, 3, 'Nadie', 0, 1026, 1000, 100, 100, 0, 0, 100, 0, '0/0/0/0/0/0/0/0/0/0', '0/0/0/0/0/0/0/0/0/0'),
  86. (28, 'police', '-465,9278.6041,829.30,9467', '-0,001349237.0,0265447.-135,1657', 3, 3, 'Nadie', 0, 1027, 1000, 100, 100, 0, 0, 100, 0, '0/0/0/0/0/0/0/0/0/0', '0/0/0/0/0/0/0/0/0/0'),
  87. (29, 'riot', '-272,0714.6371,263.30,58915', '-4,054341.-3,762028.-10,61763', 0, 0, 'Nadie', 0, 1028, 1000, 100, 100, 0, 0, 100, 0, '0/0/0/0/0/0/0/0/0/0', '0/0/0/0/0/0/0/0/0/0'),
  88. (31, 'police4', '-368,5083.6321,182.29,17144', '-4,397852.3,071105.133,0164', 56, 56, 'Nadie', 0, 1030, 1000, 100, 100, 0, 0, 100, 0, '0/0/0/0/0/0/0/0/0/0', '0/0/0/0/0/0/0/0/0/0'),
  89. (30, 'apc', '73,8359.-1053,643.29,09789', '-0,4437074.1,116564.155,4061', 0, 0, 'Nadie', 0, 1029, 1000, 100, 100, 0, 0, 100, 0, '0/0/0/0/0/0/0/0/0/0', '0/0/0/0/0/0/0/0/0/0'),
  90. (38, 'faggio2', '-379,6893.6170,005.31,1487', '71,23309.-8,420391.153,6474', 0, 0, 'Nadie', 0, 1036, 1000, 100, 100, 0, 0, 100, 0, '0/0/0/0/0/0/0/0/0/0', '0/0/0/0/0/0/0/0/0/0'),
  91. (33, 'firetruck', '-368,9744.6127,083.31,50616', '0,09926606.-0,0301588.45,56588', 0, 0, 'Nadie', 0, 1031, 1000, 100, 100, 0, 0, 100, 0, '0/0/0/0/0/0/0/0/0/0', '0/0/0/0/0/0/0/0/0/0'),
  92. (34, 'Starling', '-376,3358.6139,734.31,34109', '0.0.64,90597', 0, 0, 'Nadie', 0, 1032, 1000, 100, 100, 0, 0, 100, 0, '0/0/0/0/0/0/0/0/0/0', '0/0/0/0/0/0/0/0/0/0'),
  93. (35, 'Starling', '-382,1886.6142,407.31,24883', '0.0.122,5621', 0, 0, 'Nadie', 0, 1033, 1000, 100, 100, 0, 0, 100, 0, '0/0/0/0/0/0/0/0/0/0', '0/0/0/0/0/0/0/0/0/0'),
  94. (36, 'ambulance', '-372,6256.6123,825.31,20817', '0,02338243.-0,03130855.45,60881', 0, 0, 'Nadie', 0, 1034, 1000, 100, 100, 0, 0, 100, 0, '0/0/0/0/0/0/0/0/0/0', '0/0/0/0/0/0/0/0/0/0'),
  95. (37, 'Pbus', '-495,3944.5991,022.31,55818', '-0,0405905.0,1128371.42,23064', 0, 0, 'Nadie', 0, 1035, 1000, 100, 100, 0, 0, 100, 0, '0/0/0/0/0/0/0/0/0/0', '0/0/0/0/0/0/0/0/0/0'),
  96. (39, 'faggio', '-306,1044.6245,385.30,74181', '0,439439.20,6313.-38,42277', 88, 88, 'Nadie', 0, 1037, 1000, 100, 100, 0, 0, 100, 0, '0/0/0/0/0/0/0/0/0/0', '0/0/0/0/0/0/0/0/0/0'),
  97. (40, 'faggio3', '-412,6799.6185,187.30,97046', '1,141438.-9,212071.46,87844', 88, 88, 'Nadie', 0, 1038, 1000, 100, 100, 0, 0, 100, 0, '0/0/0/0/0/0/0/0/0/0', '0/0/0/0/0/0/0/0/0/0'),
  98. (41, 'burrito3', '-119,0896.6457,31.31,22853', '0,1535809.-1,393271.40,91349', 88, 88, 'Nadie', 0, 1039, 1000, 100, 100, 0, 0, 100, 0, '0/0/0/0/0/0/0/0/0/0', '0/0/0/0/0/0/0/0/0/0'),
  99. (42, 'carbonrs', '-482,4632.6002,19.30,83459', '0,6947242.-3,336316.-48,13542', 0, 0, 'Nadie', 0, 1040, 1000, 100, 100, 0, 0, 100, 0, '0/0/0/0/0/0/0/0/0/0', '0/0/0/0/0/0/0/0/0/0'),
  100. (43, 'TR4', '-435,9245.6064,387.31,31946', '0.0.13,97575', 0, 0, 'Nadie', 0, 1041, 1000, 100, 100, 0, 0, 100, 0, '0/0/0/0/0/0/0/0/0/0', '0/0/0/0/0/0/0/0/0/0'),
  101. (44, 'Phantom3', '-836,5303.5621,327.18,47047', '25,03685.-78,42142.-159,9125', 55, 55, 'Nadie', 0, 1042, 1000, 100, 100, 0, 0, 100, 0, '0/0/0/0/0/0/0/0/0/0', '0/0/0/0/0/0/0/0/0/0');
  102.  
  103. -- --------------------------------------------------------
  104.  
  105. --
  106. -- Estructura de tabla para la tabla `players`
  107. --
  108.  
  109. DROP TABLE IF EXISTS `players`;
  110. CREATE TABLE IF NOT EXISTS `players` (
  111. `id` int(11) NOT NULL AUTO_INCREMENT,
  112. `SocialClubName` varchar(50) NOT NULL,
  113. `Usuario` varchar(255) NOT NULL,
  114. `Nombre` varchar(255) NOT NULL,
  115. `AdminLevel` int(11) NOT NULL DEFAULT '0',
  116. `Nivel` int(11) NOT NULL DEFAULT '1',
  117. `uLogin` varchar(255) NOT NULL,
  118. `Edad` int(11) NOT NULL DEFAULT '18',
  119. `Sexo` varchar(255) NOT NULL DEFAULT 'Hombre',
  120. `AdminNombre` varchar(255) NOT NULL,
  121. `Dinero` int(11) DEFAULT '250',
  122. `Banco` int(11) DEFAULT '250',
  123. `Coche` int(11) NOT NULL DEFAULT '0',
  124. `Posicion` varchar(255) NOT NULL,
  125. PRIMARY KEY (`id`)
  126. ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
  127.  
  128. --
  129. -- Volcado de datos para la tabla `players`
  130. --
  131.  
  132. INSERT INTO `players` (`id`, `SocialClubName`, `Usuario`, `Nombre`, `AdminLevel`, `Nivel`, `uLogin`, `Edad`, `Sexo`, `AdminNombre`, `Dinero`, `Banco`, `Coche`, `Posicion`) VALUES
  133. (1, 'Ultralodeo', '', 'Juanjo Escalona', 4, 1, '05/09/2017 17:25:04', 18, 'Hombre', '', 250, 250, 0, '-367,2454.6319,231.29,66932'),
  134. (2, 'Rocco_Stewart', '', 'Roco_Stewart', 0, 1, '31/08/2017 18:02:06', 18, 'Hombre', '', 250, 250, 0, ''),
  135. (3, 'llalvaro12', '', 'llalvaro12', 0, 1, '31/08/2017 18:02:06', 18, 'Hombre', '', 12222323, 250, 0, ''),
  136. (4, 'Alessia_Brooks', '', 'Alessia Brooks', 1, 1, '05/09/2017 11:58:36', 18, 'Hombre', 'llalvaro12', 23, 250, 0, '-122,2353.6456,293.31,44753'),
  137. (6, 'AndreuMartinez', 'Tote', 'Adams Lawrence', 4, 1, '31/08/2017 18:02:06', 18, 'Hombre', 'Tote', 5000, 250, 0, '-97,28523.6564,598.29,18313'),
  138. (7, 'Ekaitzooo', 'Antenastyle', 'James Rivas', 4, 2, '05/09/2017 17:30:28', 18, 'Hombre', 'Eka', 1470, 250, 0, '-140,715.6521,239.29,16015'),
  139. (8, 'Marcos_Hernandez', '', 'Marcos Hernandez', 0, 1, '31/08/2017 18:02:06', 18, 'Hombre', '', 250, 250, 0, ''),
  140. (9, 'Flanagan', '', 'Flanagan', 4, 1, '31/08/2017 18:02:06', 18, 'Hombre', '', 300, 250, 0, ''),
  141. (10, 'Flanagansito', '', 'Marc Flanagan', 4, 1, '31/08/2017 18:02:06', 18, 'Hombre', 'Flana', 250, 250, 0, '-772,7792.-2154,519.8,847972'),
  142. (11, 'EizeNNNN', '', 'Daniel Mendoza', 4, 1, '31/08/2017 18:02:06', 18, 'Hombre', 'Eizen', 250, 250, 0, '-772,7792.-2154,519.8,847972');
  143.  
  144. -- --------------------------------------------------------
  145.  
  146. --
  147. -- Estructura de tabla para la tabla `ropa`
  148. --
  149.  
  150. DROP TABLE IF EXISTS `ropa`;
  151. CREATE TABLE IF NOT EXISTS `ropa` (
  152. `id` int(11) NOT NULL AUTO_INCREMENT,
  153. `Tipo` int(11) NOT NULL,
  154. `Modelo` int(11) NOT NULL,
  155. `Textura` int(11) NOT NULL,
  156. `Uso` int(11) NOT NULL,
  157. `IdSql` int(11) NOT NULL,
  158. PRIMARY KEY (`id`)
  159. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  160.  
  161. -- --------------------------------------------------------
  162.  
  163. --
  164. -- Estructura de tabla para la tabla `usuariosforo`
  165. --
  166.  
  167. DROP TABLE IF EXISTS `usuariosforo`;
  168. CREATE TABLE IF NOT EXISTS `usuariosforo` (
  169. `id` int(11) NOT NULL AUTO_INCREMENT,
  170. `Usuario` varchar(255) NOT NULL,
  171. `Password` varchar(255) NOT NULL,
  172. `Email` varchar(255) NOT NULL,
  173. PRIMARY KEY (`id`)
  174. ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
  175.  
  176. --
  177. -- Volcado de datos para la tabla `usuariosforo`
  178. --
  179.  
  180. INSERT INTO `usuariosforo` (`id`, `Usuario`, `Password`, `Email`) VALUES
  181. (1, 'Antenastyle', '123456', 'email@gmail.com'),
  182. (2, 'Tote', '123456', 'email@gmail.com'),
  183. (3, 'Flanagansito', '123456', 'email@gmail.com');
  184. COMMIT;
  185.  
  186. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  187. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  188. /*!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!