Guest User

MySql Store System Base SQL Dump by Rokzlive

a guest
Mar 27th, 2011
304
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.46 KB | None | 0 0
  1. -- phpMyAdmin SQL Dump
  2. -- version 3.3.9
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: localhost
  6. -- Generation Time: Mar 27, 2011 at 11:24 PM
  7. -- Server version: 5.5.8
  8. -- PHP Version: 5.3.5
  9.  
  10. SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
  11.  
  12.  
  13. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  14. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  15. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  16. /*!40101 SET NAMES utf8 */;
  17.  
  18. --
  19. -- Database: `bus`
  20. --
  21.  
  22. -- --------------------------------------------------------
  23.  
  24. --
  25. -- Table structure for table `stores`
  26. --
  27.  
  28. CREATE TABLE IF NOT EXISTS `stores` (
  29.   `id` INT(11) NOT NULL AUTO_INCREMENT,
  30.   `X` FLOAT NOT NULL,
  31.   `Y` FLOAT NOT NULL,
  32.   `Z` FLOAT NOT NULL,
  33.   PRIMARY KEY (`id`)
  34. ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;
  35.  
  36. --
  37. -- Dumping data for table `stores`
  38. --
  39.  
  40. INSERT INTO `stores` (`id`, `X`, `Y`, `Z`) VALUES
  41. (6, -152.795, 70.2877, 6.28111),
  42. (7, 143.203, -201.151, 1.57812),
  43. (8, 251.889, -57.1905, 1.57031),
  44. (9, 822.329, -557.76, 16.3359),
  45. (10, 1315.47, -898.572, 39.5781),
  46. (11, 437.34, -1310.69, 15.1121),
  47. (12, 802.697, -1794.76, 13.0234),
  48. (13, 1450.04, -2287.26, 13.5469),
  49. (14, 1940.92, -2116.01, 13.6953),
  50. (15, 1833.02, -1842.61, 13.5781),
  51. (16, 2685.08, -2515.12, 13.1273),
  52. (17, 2117.83, 897.498, 11.1797),
  53. (18, 2319.67, -89.3282, 26.4844),
  54. (19, 2302.48, 57.4316, 26.4844),
  55. (20, -78.7974, -1169.57, 2.14838),
  56. (21, -2034.19, 148.741, 28.8359);
Add Comment
Please, Sign In to add comment