cdiego

video_mapas SCRIPT BD

Aug 28th, 2013
2,174
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.99 KB | None | 0 0
  1. -- phpMyAdmin SQL Dump
  2. -- version 3.4.10.1
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Servidor: localhost
  6. -- Tiempo de generación: 28-08-2013 a las 21:21:44
  7. -- Versión del servidor: 5.5.20
  8. -- Versión de PHP: 5.3.10
  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: `mapas`
  21. --
  22.  
  23. -- --------------------------------------------------------
  24.  
  25. --
  26. -- Estructura de tabla para la tabla `puntos`
  27. --
  28.  
  29. CREATE TABLE IF NOT EXISTS `puntos` (
  30.   `IdPunto` INT(11) NOT NULL AUTO_INCREMENT,
  31.   `Titulo` text COLLATE utf8_spanish_ci NOT NULL,
  32.   `cx` text COLLATE utf8_spanish_ci NOT NULL,
  33.   `cy` text COLLATE utf8_spanish_ci NOT NULL,
  34.   PRIMARY KEY (`IdPunto`)
  35. ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci AUTO_INCREMENT=12 ;
  36.  
  37. --
  38. -- Volcado de datos para la tabla `puntos`
  39. --
  40.  
  41. INSERT INTO `puntos` (`IdPunto`, `Titulo`, `cx`, `cy`) VALUES
  42. (1, 'primer punto a la db', '-13.158554946192757', ' -72.54770278930664'),
  43. (2, 'segundo punto a la bd', '-13.17343121885015', ' -72.54650115966797'),
  44. (3, 'tercer marcador', '-13.129301215619058', ' -72.51628875732422'),
  45. (4, 'cuarto marcador', '-13.309448548494611', ' -72.94921875'),
  46. (5, 'amazonas', '-5.528510525692801', ' -65.56640625'),
  47. (6, 'marcador norte', '-12.441940749941743', ' -72.8009033203125'),
  48. (7, 'bolivia', '-17.895114303749143', ' -65.126953125'),
  49. (8, 'chile', '-24.046463999666567', ' -69.873046875'),
  50. (9, 'argentina', '-34.52466147177172', ' -64.86328125'),
  51. (10, 'paraguay', '-22.10599879975055', ' -59.765625'),
  52. (11, 'brasil', '-9.96885060854611', ' -54.140625');
  53.  
  54. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  55. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  56. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment