Advertisement
ZumeZero

SQL / RACES INCLUDE

Jan 23rd, 2015
522
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 2.57 KB | None | 0 0
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.2.11
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Servidor: 127.0.0.1
  6. -- Tiempo de generación: 23-01-2015 a las 19:22:41
  7. -- Versión del servidor: 5.6.21
  8. -- Versión de PHP: 5.5.19
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET time_zone = "+00:00";
  12.  
  13.  
  14. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  15. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  16. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  17. /*!40101 SET NAMES utf8 */;
  18.  
  19. --
  20. -- Base de datos: `x367`
  21. --
  22.  
  23. -- --------------------------------------------------------
  24.  
  25. --
  26. -- Estructura de tabla para la tabla `races`
  27. --
  28.  
  29. CREATE TABLE IF NOT EXISTS `races` (
  30. `id` INT(11) NOT NULL,
  31.   `name` VARCHAR(24) NOT NULL,
  32.   `pos0` FLOAT NOT NULL,
  33.   `pos1` FLOAT NOT NULL,
  34.   `pos2` FLOAT NOT NULL,
  35.   `pos3` FLOAT NOT NULL,
  36.   `vw` INT(5) NOT NULL,
  37.   `int` INT(5) NOT NULL
  38. ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
  39.  
  40. --
  41. -- Volcado de datos para la tabla `races`
  42. --
  43.  
  44. INSERT INTO `races` (`id`, `name`, `pos0`, `pos1`, `pos2`, `pos3`, `vw`, `int`) VALUES
  45. (6, 'Untitled', 264.325, -69.2728, 0.992318, 169.5, 0, 0);
  46.  
  47. -- --------------------------------------------------------
  48.  
  49. --
  50. -- Estructura de tabla para la tabla `tracks`
  51. --
  52.  
  53. CREATE TABLE IF NOT EXISTS `tracks` (
  54.   `pos0` FLOAT NOT NULL,
  55.   `pos1` FLOAT NOT NULL,
  56.   `pos2` FLOAT NOT NULL,
  57.   `raceowner` INT(11) NOT NULL,
  58. `ID` INT(12) NOT NULL
  59. ) ENGINE=InnoDB AUTO_INCREMENT=342 DEFAULT CHARSET=latin1;
  60.  
  61. --
  62. -- Volcado de datos para la tabla `tracks`
  63. --
  64.  
  65. INSERT INTO `tracks` (`pos0`, `pos1`, `pos2`, `raceowner`, `ID`) VALUES
  66. (236.093, -68.8784, 0.9859, 6, 337),
  67. (200.129, -68.6164, 0.9279, 6, 338),
  68. (151.886, -68.3603, 0.9957, 6, 339),
  69. (129.038, -118.352, 0.9955, 6, 340),
  70. (170.004, -146.148, 1.0069, 6, 341);
  71.  
  72. --
  73. -- Índices para tablas volcadas
  74. --
  75.  
  76. --
  77. -- Indices de la tabla `races`
  78. --
  79. ALTER TABLE `races`
  80.  ADD PRIMARY KEY (`id`);
  81.  
  82. --
  83. -- Indices de la tabla `tracks`
  84. --
  85. ALTER TABLE `tracks`
  86.  ADD PRIMARY KEY (`ID`), ADD UNIQUE KEY `ID` (`ID`);
  87.  
  88. --
  89. -- AUTO_INCREMENT de las tablas volcadas
  90. --
  91.  
  92. --
  93. -- AUTO_INCREMENT de la tabla `races`
  94. --
  95. ALTER TABLE `races`
  96. MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
  97. --
  98. -- AUTO_INCREMENT de la tabla `tracks`
  99. --
  100. ALTER TABLE `tracks`
  101. MODIFY `ID` INT(12) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=342;
  102. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  103. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  104. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement