API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Feb 12th, 2016
74
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 18.91 KB | None | 0 0
raw download clone embed print report
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.5.1
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: 127.0.0.1
  6. -- Generation Time: 12 Feb 2016 la 13:08
  7. -- Versiune server: 10.1.9-MariaDB
  8. -- PHP Version: 7.0.1
  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 utf8mb4 */;
  18.  
  19. --
  20. -- Database: `crawler`
  21. --
  22.  
  23. -- --------------------------------------------------------
  24.  
  25. --
  26. -- Structura de tabel pentru tabelul `jobs`
  27. --
  28.  
  29. CREATE TABLE `jobs` (
  30. `criteria` varchar(1024) NOT NULL,
  31. `startdate` date NOT NULL,
  32. `enddate` date NOT NULL,
  33. `period` int(11) NOT NULL,
  34. `searchtime` time NOT NULL,
  35. `id` bigint(20) NOT NULL
  36. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  37.  
  38. --
  39. -- Salvarea datelor din tabel `jobs`
  40. --
  41.  
  42. INSERT INTO `jobs` (`criteria`, `startdate`, `enddate`, `period`, `searchtime`, `id`) VALUES
  43. ('{Make: ''BMW'', Model: ''X3'', FromYear: 2010, ToYear: 2011, Zip: 14534, DistanceFromZip: 10, WebSite: ''AutoTrader''}', '2016-02-10', '2016-02-12', 2, '17:30:00', 1),
  44. ('{Make: ''BMW'', Model: ''X6'', FromYear: 2012, ToYear: 2016, Zip: 14534, DistanceFromZip: 10, WebSite: ''eBay''}', '2016-02-11', '2016-02-22', 3, '15:37:00', 2);
  45.  
  46. -- --------------------------------------------------------
  47.  
  48. --
  49. -- Structura de tabel pentru tabelul `records`
  50. --
  51.  
  52. CREATE TABLE `records` (
  53. `id` bigint(20) UNSIGNED NOT NULL,
  54. `make` varchar(64) NOT NULL,
  55. `model` varchar(64) NOT NULL,
  56. `year` int(11) DEFAULT NULL,
  57. `vin` varchar(64) NOT NULL,
  58. `detailsurl` varchar(512) NOT NULL,
  59. `sellername` varchar(64) NOT NULL,
  60. `sellerphone` varchar(64) NOT NULL,
  61. `title` varchar(512) NOT NULL,
  62. `source` varchar(64) NOT NULL,
  63. `datecollected` datetime NOT NULL
  64. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  65.  
  66. --
  67. -- Salvarea datelor din tabel `records`
  68. --
  69.  
  70. INSERT INTO `records` (`id`, `make`, `model`, `year`, `vin`, `detailsurl`, `sellername`, `sellerphone`, `title`, `source`, `datecollected`) VALUES
  71. (745, 'BMW', 'X6', 2016, '5UXKU0C57G0F92898', 'http://cgi.ebay.com/ebaymotors/BMW-X6-sDrive35i-/291679130529?hash=item43e96e53a1:g:56EAAOSwWTRWtnuE&vxp=mtr', 'bmwandminiofaustin', 'Not available', '2016 BMW X6 sDrive35i', 'eBay', '2016-02-11 15:37:03'),
  72. (746, 'BMW', 'X6', 2013, '5UXFG2C56DL782428', 'http://cgi.ebay.com/ebaymotors/BMW-X6-XDRIVE35I-AWD-1-OWN-PREMIUM-TECH-SPORT-HUD-NAV-CAM-PDC-DVD-/252276240236?hash=item3abcd5ef6c:g:7zcAAOSwFMZWsmOB&vxp=mtr', 'drive_with_pride', 'Not available', '2013 BMW X6 XDRIVE35I AWD 1 OWN PREMIUM TECH SPORT HUD NAV CAM PDC DVD', 'eBay', '2016-02-11 15:37:04'),
  73. (747, 'BMW', 'X6', 2013, '5UXFG2C54DL787031', 'http://cgi.ebay.com/ebaymotors/BMW-X6-xDrive35i-/291680625544?hash=item43e9852388:g:2JAAAOSwzgRWuUCn&vxp=mtr', 'bmwandminiofaustin', 'Not available', '2013 BMW X6 xDrive35i', 'eBay', '2016-02-11 15:37:05'),
  74. (748, 'BMW', 'X6', 2013, '5YMGZ0C57DLL29866', 'http://cgi.ebay.com/ebaymotors/BMW-X6-M-/301868436289?hash=item4648c2cb41:g:9nMAAOSwB4NWuTWv&vxp=mtr', 'all_in_all_surplus', 'Not available', '2013 BMW X6 M', 'eBay', '2016-02-11 15:37:06'),
  75. (749, 'BMW', 'X6', 2016, '5UXKU0C57G0F92352', 'http://cgi.ebay.com/ebaymotors/BMW-X6-sDrive35i-/321979496974?hash=item4af7793a0e:g:lYgAAOSwFqJWnAr1&vxp=mtr', '123bmwofcolumbia', '888-469-1394', '2016 BMW X6 sDrive35i', 'eBay', '2016-02-11 15:37:07'),
  76. (750, 'BMW', 'X6', 2012, '5UXFG8C56CL590251', 'http://cgi.ebay.com/ebaymotors/BMW-X6-50i-/201520283889?hash=item2eeb8b80f1:g:PJAAAOSwUuFWuSXC&vxp=mtr', 'race13car', 'Not available', '2012 BMW X6 50i', 'eBay', '2016-02-11 15:37:09'),
  77. (751, 'BMW', 'X6', 2016, '5UXKU2C5XG0N81404', 'http://cgi.ebay.com/ebaymotors/BMW-X6-xDrive35i-/331741107417?hash=item4d3d4f94d9:g:dQYAAOSwSHZWfxDV&vxp=mtr', 'bmwoftulsa', '888-675-9328', '2016 BMW X6 xDrive35i', 'eBay', '2016-02-11 15:37:10'),
  78. (752, 'BMW', 'X6', 2015, '5YMKW8C56F0R42857', 'http://cgi.ebay.com/ebaymotors/BMW-X6-/361478853563?hash=item5429d193bb:g:nr0AAOSw--1Wqo7P&vxp=mtr', 'bmwmidtown', '888-754-0426', '2015 BMW X6', 'eBay', '2016-02-11 15:37:11'),
  79. (753, 'BMW', 'X6', 2016, '5UXKU2C59G0N79255', 'http://cgi.ebay.com/ebaymotors/BMW-X6-xDrive35i-/361478855814?hash=item5429d19c86:g:K38AAOSwKtlWqo9l&vxp=mtr', 'bmwmidtown', '888-754-0426', '2016 BMW X6 xDrive35i', 'eBay', '2016-02-11 15:37:12'),
  80. (754, 'BMW', 'X6', 2015, '5UXKU2C54F0N78092', 'http://cgi.ebay.com/ebaymotors/BMW-X6-xDrive35i-DRIVERS-ASSIST-PACKAGE-/361478861269?hash=item5429d1b1d5:g:4i0AAOSwX~dWqpHT&vxp=mtr', 'bmwmidtown', '888-754-0426', '2015 BMW X6 xDrive35i***DRIVERS ASSIST PACKAGE***', 'eBay', '2016-02-11 15:37:13'),
  81. (755, 'BMW', 'X6', 2012, '5YMGZ0C52CLK14560', 'http://cgi.ebay.com/ebaymotors/BMW-X6-/391382764754?hash=item5b203b0cd2:g:2doAAOSwuAVWu6-H&vxp=mtr', 'carsales999', 'Not available', '2012 BMW X6', 'eBay', '2016-02-11 15:37:14'),
  82. (756, 'BMW', 'X6', 2016, '5UXKU0C53G0F93062', 'http://cgi.ebay.com/ebaymotors/BMW-X6-sDrive35i-/361484116185?hash=item542a21e0d9:g:-UEAAOSwL7VWtITB&vxp=mtr', 'bmwmidtown', '888-754-0426', '2016 BMW X6 sDrive35i', 'eBay', '2016-02-11 15:37:15'),
  83. (757, 'BMW', 'X6', 2012, '5UXFG8C5XCLZ97442', 'http://cgi.ebay.com/ebaymotors/BMW-X6-50i-/151941193879?hash=item236066a097:g:GKUAAOSwa-dWjXCm&vxp=mtr', 'highlineautosales', '888-285-1680', '2012 BMW X6 50i', 'eBay', '2016-02-11 15:37:17'),
  84. (758, 'BMW', 'X6', 2016, '5UXKU6C50G0R34143', 'http://cgi.ebay.com/ebaymotors/BMW-X6-xDrive50i-/331751430657?hash=item4d3ded1a01:g:FCEAAOSwJkJWktdH&vxp=mtr', 'bmwoftulsa', '888-675-9328', '2016 BMW X6 xDrive50i', 'eBay', '2016-02-11 15:37:17'),
  85. (759, 'BMW', 'X6', 2016, '5UXKU0C5XG0F92412', 'http://cgi.ebay.com/ebaymotors/BMW-X6-sDrive35i-/361487823743?hash=item542a5a737f:g:ECoAAOSwx-9Wu7WJ&vxp=mtr', 'bmwmidtown', '888-754-0426', '2016 BMW X6 sDrive35i', 'eBay', '2016-02-11 15:37:18'),
  86. (760, 'BMW', 'X6', 2012, '5UXFG2C5XCLX09982', 'http://cgi.ebay.com/ebaymotors/BMW-X6-xDrive35i-Certified-2012-36K-MILES-AWD-NAV-SUNROOF-/191800002076?hash=item2ca82bc61c:g:42YAAOSwGotWs71k&vxp=mtr', 'vroom', 'Not available', '2012 BMW X6 xDrive35i Certified 2012 36K MILES AWD NAV SUNROOF', 'eBay', '2016-02-11 15:37:03'),
  87. (761, 'BMW', 'X6', 2013, '5YMGZ0C59DLL29822', 'http://cgi.ebay.com/ebaymotors/BMW-X6-M-Sport-/201518362662?hash=item2eeb6e3026:g:iVMAAOSwFqJWtTZF&vxp=mtr', 'formulaoneimports', 'Not available', '2013 BMW X6 M Sport', 'eBay', '2016-02-11 15:37:04'),
  88. (762, 'BMW', 'X6', 2016, '5UXKU2C58G0N79179', 'http://cgi.ebay.com/ebaymotors/BMW-X6-xDrive35i-/291680564678?hash=item43e98435c6:g:~VIAAOSwUuFWuSKc&vxp=mtr', 'bmwandminiofaustin', 'Not available', '2016 BMW X6 xDrive35i', 'eBay', '2016-02-11 15:37:05'),
  89. (763, 'BMW', 'X6', 2012, '5UXFG2C54CL779347', 'http://cgi.ebay.com/ebaymotors/BMW-X6-2012-xDrive35I-PREMI-/262242482741?hash=item3d0edeba35:g:3Y4AAOSwGotWmTg5&vxp=mtr', 'smartersolutions', '888.309-3106', '2012 BMW X6 2012 xDrive35I PREMI', 'eBay', '2016-02-11 15:37:06'),
  90. (764, 'BMW', 'X6', 2016, '5UXKU0C57G0F92352', 'http://cgi.ebay.com/ebaymotors/BMW-X6-sDrive35i-/321952795343?hash=item4af5e1cacf:g:iS0AAOSwUdlWdFV1&vxp=mtr', '123bmwofcolumbia', '888-469-1394', '2016 BMW X6 sDrive35i', 'eBay', '2016-02-11 15:37:07'),
  91. (765, 'BMW', 'X6', 2012, '5YMGZ0C55CLK14441', 'http://cgi.ebay.com/ebaymotors/BMW-X6-/351650861290?hash=item51e00650ea:g:XwgAAOSwuAVWu1FM&vxp=mtr', 'selectluxury', 'Not available', '2012 BMW X6', 'eBay', '2016-02-11 15:37:07'),
  92. (766, 'BMW', 'X6', 2012, '5YMGZ0C58CLK14563', 'http://cgi.ebay.com/ebaymotors/BMW-X6-/301861164878?hash=item464853d74e:g:zGUAAOSwL7VWrQwR&vxp=mtr', 'rockymountaineurosport', 'Not available', '2012 BMW X6', 'eBay', '2016-02-11 15:37:08'),
  93. (767, 'BMW', 'X6', 2014, '5UXFG2C50E0C44135', 'http://cgi.ebay.com/ebaymotors/BMW-X6-xDrive35i-Sport-Utility-4-Door-/331768168172?hash=item4d3eec7eec:g:7y8AAOSwa-dWkEkr&vxp=mtr', 'turboinfo', 'Not available', '2014 BMW X6', 'eBay', '2016-02-11 15:37:09'),
  94. (768, 'BMW', 'X6', 2013, '5UXFG2C57DL784740', 'http://cgi.ebay.com/ebaymotors/BMW-X6-xDrive35i-/231705936027?hash=item35f2c0009b:g:MMEAAOSwT4lWTjay&vxp=mtr', 'medi222', '(888) 469-7834', '2013 BMW X6 xDrive35i', 'eBay', '2016-02-11 15:37:10'),
  95. (769, 'BMW', 'X6', 2015, '5YMKW8C58F0R42925', 'http://cgi.ebay.com/ebaymotors/BMW-X6-/361478854523?hash=item5429d1977b:g:cQwAAOSwa-dWqo6z&vxp=mtr', 'bmwmidtown', '888-754-0426', '2015 BMW X6', 'eBay', '2016-02-11 15:37:11'),
  96. (770, 'BMW', 'X6', 2016, '5UXKU6C52G0R33639', 'http://cgi.ebay.com/ebaymotors/BMW-X6-xDrive50i-/361478856707?hash=item5429d1a003:g:t1YAAOSw--1Wqo~A&vxp=mtr', 'bmwmidtown', '888-754-0426', '2016 BMW X6 xDrive50i', 'eBay', '2016-02-11 15:37:12'),
  97. (771, 'BMW', 'X6', 2015, '5UXKU0C54F0F91903', 'http://cgi.ebay.com/ebaymotors/BMW-X6-sDrive35i-/361478864355?hash=item5429d1bde3:g:4UAAAOSwa-dWqpMV&vxp=mtr', 'bmwmidtown', '888-754-0426', '2015 BMW X6 sDrive35i', 'eBay', '2016-02-11 15:37:13'),
  98. (772, 'BMW', 'X6', 2013, '5UXFG2C50DL784370', 'http://cgi.ebay.com/ebaymotors/BMW-X6-xDrive35i-/262224495094?hash=item3d0dcc41f6:g:r0AAAOSwGotWiuMt&vxp=mtr', 'buyacarnc', '(888) 219-5892', '2013 BMW X6 xDrive35i', 'eBay', '2016-02-11 15:37:14'),
  99. (773, 'BMW', 'X6', 2013, '5YMGZ0C50DLL30115', 'http://cgi.ebay.com/ebaymotors/BMW-X6-/161969534087?hash=item25b622f487:g:YTQAAOSwFMZWtN~o&vxp=mtr', 'sdlev', '866-241-8492', '2013 BMW X6', 'eBay', '2016-02-11 15:37:15'),
  100. (774, 'BMW', 'X6', 2016, '5UXKU0C58G0F93087', 'http://cgi.ebay.com/ebaymotors/BMW-X6-sDrive35i-/361484578270?hash=item542a28edde:g:q8kAAOSwpzdWtRso&vxp=mtr', 'bmwmidtown', '888-754-0426', '2016 BMW X6 sDrive35i', 'eBay', '2016-02-11 15:37:16'),
  101. (775, 'BMW', 'X6', 2016, '5UXKU6C50G0R34143', 'http://cgi.ebay.com/ebaymotors/BMW-X6-xDrive50i-/331730533140?hash=item4d3cae3b14:g:Mg4AAOSwnipWayMq&vxp=mtr', 'bmwoftulsa', '888-675-9328', '2016 BMW X6 xDrive50i', 'eBay', '2016-02-11 15:37:17'),
  102. (776, 'BMW', 'X6', 2013, '5UXFG2C54DL786218', 'http://cgi.ebay.com/ebaymotors/BMW-X6-xDrive35i-/151979732143?hash=item2362b2acaf:g:ETcAAOSwll1Wu3xn&vxp=mtr', 'highlineautosales', '888-285-1680', '2013 BMW X6 xDrive35i', 'eBay', '2016-02-11 15:37:18'),
  103. (777, 'BMW', 'X6', 2016, '5UXKU0C55G0F92835', 'http://cgi.ebay.com/ebaymotors/BMW-X6-sDrive35i-/291679130488?hash=item43e96e5378:g:VyUAAOSwB4NWtnt-&vxp=mtr', 'bmwandminiofaustin', 'Not available', '2016 BMW X6 sDrive35i', 'eBay', '2016-02-11 15:37:03'),
  104. (778, 'BMW', 'X6', 2013, '5UXFG8C59DL591086', 'http://cgi.ebay.com/ebaymotors/BMW-X6-xDrive50i-/371549016848?hash=item56820c1310:g:CqAAAOSwL7VWtk9M&vxp=mtr', 'lewisville-autoplex', 'Not available', '2013 BMW X6 xDrive50i', 'eBay', '2016-02-11 15:37:04'),
  105. (779, 'BMW', 'X6', 2016, '5UXKU2C50G0N81332', 'http://cgi.ebay.com/ebaymotors/BMW-X6-xDrive35i-/291680633339?hash=item43e98541fb:g:bn8AAOSwDuJWuUV1&vxp=mtr', 'bmwandminiofaustin', 'Not available', '2016 BMW X6 xDrive35i', 'eBay', '2016-02-11 15:37:06'),
  106. (780, 'BMW', 'X6', 2013, '5UXFG2C58DL785329', 'http://cgi.ebay.com/ebaymotors/BMW-X6-xDrive35i-/121886868802?hash=item1c61060542:g:4HcAAOSwL7VWtUdu&vxp=mtr', 'luckymotors1', 'Not available', '2013 BMW X6 xDrive35i', 'eBay', '2016-02-11 15:37:06'),
  107. (781, 'BMW', 'X6', 2016, '5UXKU2C52G0N79047', 'http://cgi.ebay.com/ebaymotors/BMW-X6-xDrive35i-/321979497119?hash=item4af7793a9f:g:K3kAAOSwqrtWnAsH&vxp=mtr', '123bmwofcolumbia', '888-469-1394', '2016 BMW X6 xDrive35i', 'eBay', '2016-02-11 15:37:07'),
  108. (782, 'BMW', 'X6', 2013, '5UXFG2C52DL783477', 'http://cgi.ebay.com/ebaymotors/BMW-X6-xDrive35i-AWD-/222000913825?hash=item33b0491da1:g:8agAAOSwFqJWoBkn&vxp=mtr', 'superiorleasing.com', '888-618-1724', '2013 BMW X6 xDrive35i AWD', 'eBay', '2016-02-11 15:37:08'),
  109. (783, 'BMW', 'X6', 2016, '5UXKU2C54G0N81138', 'http://cgi.ebay.com/ebaymotors/BMW-X6-xDrive35i-/331760626030?hash=item4d3e79696e:g:MMsAAOSwoydWoq39&vxp=mtr', 'bmwoftulsa', '888-675-9328', '2016 BMW X6 xDrive35i', 'eBay', '2016-02-11 15:37:09'),
  110. (784, 'BMW', 'X6', 2016, '5UXKU2C5XG0N81404', 'http://cgi.ebay.com/ebaymotors/BMW-X6-xDrive35i-/331762969928?hash=item4d3e9d2d48:g:wkkAAOSwX~dWpqEp&vxp=mtr', 'bmwoftulsa', '888-675-9328', '2016 BMW X6 xDrive35i', 'eBay', '2016-02-11 15:37:10'),
  111. (785, 'BMW', 'X6', 2013, '5YMGZ0C5XD0C40121', 'http://cgi.ebay.com/ebaymotors/BMW-X6-M-/231705936109?hash=item35f2c000ed:g:ES8AAOSw37tWC-Ay&vxp=mtr', 'medi222', '(888) 469-7834', '2013 BMW X6 M', 'eBay', '2016-02-11 15:37:11'),
  112. (786, 'BMW', 'X6', 2016, '5YMKW8C55G0R43144', 'http://cgi.ebay.com/ebaymotors/BMW-X6-/361478855422?hash=item5429d19afe:g:8HoAAOSwXshWqo8F&vxp=mtr', 'bmwmidtown', '888-754-0426', '2016 BMW X6', 'eBay', '2016-02-11 15:37:12'),
  113. (787, 'BMW', 'X6', 2016, '5UXKU6C55G0R34042', 'http://cgi.ebay.com/ebaymotors/BMW-X6-xDrive50i-/361478857419?hash=item5429d1a2cb:g:FygAAOSwL7VWqpA8&vxp=mtr', 'bmwmidtown', '888-754-0426', '2016 BMW X6 xDrive50i', 'eBay', '2016-02-11 15:37:12'),
  114. (788, 'BMW', 'X6', 2013, '5UXFG8C50DL591767', 'http://cgi.ebay.com/ebaymotors/BMW-X6-XDrive50i-Premium-AWD-/222008977732?hash=item33b0c42944:g:eQQAAOSwKtlWqqcu&vxp=mtr', 'superiorleasing.com', '888-618-1724', '2013 BMW X6 XDrive50i Premium AWD', 'eBay', '2016-02-11 15:37:14'),
  115. (789, 'BMW', 'X6', 2016, '5UXKU6C58G0R34309', 'http://cgi.ebay.com/ebaymotors/BMW-X6-xDrive50i-/361484116264?hash=item542a21e128:g:dzEAAOSwKtlWtITJ&vxp=mtr', 'bmwmidtown', '888-754-0426', '2016 BMW X6 xDrive50i', 'eBay', '2016-02-11 15:37:15'),
  116. (790, 'BMW', 'X6', 2016, '5UXKU2C59G0N82107', 'http://cgi.ebay.com/ebaymotors/BMW-X6-xDrive35i-/361484578298?hash=item542a28edfa:g:BjIAAOSwKtlWtRu6&vxp=mtr', 'bmwmidtown', '888-754-0426', '2016 BMW X6 xDrive35i', 'eBay', '2016-02-11 15:37:16'),
  117. (791, 'BMW', 'X6', 2016, '5UXKU2C5XG0N80253', 'http://cgi.ebay.com/ebaymotors/BMW-X6-xDrive35i-/331730528080?hash=item4d3cae2750:g:E~cAAOSwcOFWayEu&vxp=mtr', 'bmwoftulsa', '888-675-9328', '2016 BMW X6 xDrive35i', 'eBay', '2016-02-11 15:37:17'),
  118. (792, 'BMW', 'X6', 2016, '5UXKU0C51G0F93089', 'http://cgi.ebay.com/ebaymotors/BMW-X6-sDrive35i-/361487434424?hash=item542a5482b8:g:E5cAAOSw~OVWuxyX&vxp=mtr', 'bmwmidtown', '888-754-0426', '2016 BMW X6 sDrive35i', 'eBay', '2016-02-11 15:37:18'),
  119. (793, 'BMW', 'X6', 2016, '5UXKU2C54G0N80720', 'http://cgi.ebay.com/ebaymotors/BMW-X6-xDrive35i-/331731401451?hash=item4d3cbb7aeb:g:zpwAAOSw7FRWbJzG&vxp=mtr', 'bmwoftulsa', '888-675-9328', '2016 BMW X6 xDrive35i', 'eBay', '2016-02-11 15:37:19'),
  120. (794, 'BMW', 'X6', 2016, '5UXKU6C52G0R34175', 'http://cgi.ebay.com/ebaymotors/BMW-X6-xDrive50i-/291679130860?hash=item43e96e54ec:g:vLMAAOSwx-9Wtnuh&vxp=mtr', 'bmwandminiofaustin', 'Not available', '2016 BMW X6 xDrive50i', 'eBay', '2016-02-11 15:37:03'),
  121. (795, 'BMW', 'X6', 2013, '5YMGZ0C55DLL29817', 'http://cgi.ebay.com/ebaymotors/BMW-X6-/131721552259?hash=item1eab376183:g:gY4AAOSwX~dWtfwK&vxp=mtr', 'autoworld500', 'Not available', '2013 BMW X6', 'eBay', '2016-02-11 15:37:04'),
  122. (796, 'BMW', 'X6', 2016, '5UXKU0C52G0F92811', 'http://cgi.ebay.com/ebaymotors/BMW-X6-sDrive35i-/291680632032?hash=item43e9853ce0:g:E0EAAOSwx-9WuUQD&vxp=mtr', 'bmwandminiofaustin', 'Not available', '2016 BMW X6 sDrive35i', 'eBay', '2016-02-11 15:37:05'),
  123. (797, 'BMW', 'X6', 2012, '5UXFG2C51CL781282', 'http://cgi.ebay.com/ebaymotors/BMW-X6-Shadow-line-/322003012306?hash=item4af8e00ad2:g:F54AAOSwJkJWlCa9&vxp=mtr', 'rickkent3', 'Not available', '2012 BMW X6', 'eBay', '2016-02-11 15:37:06'),
  124. (798, 'BMW', 'X6', 2016, '5UXKU2C52G0N79047', 'http://cgi.ebay.com/ebaymotors/BMW-X6-xDrive35i-/321952795417?hash=item4af5e1cb19:g:jFIAAOSwUdlWdFWf&vxp=mtr', '123bmwofcolumbia', '888-469-1394', '2016 BMW X6 xDrive35i', 'eBay', '2016-02-11 15:37:07'),
  125. (799, 'BMW', 'X6', 2013, '5UXFG2C51DL785902', 'http://cgi.ebay.com/ebaymotors/BMW-X6-xDrive35i-/291671680116?hash=item43e8fca474:g:Wb0AAOSwXshWqZRB&vxp=mtr', 'exotic-motors', 'Not available', '2013 BMW X6 xDrive35i', 'eBay', '2016-02-11 15:37:08'),
  126. (800, 'BMW', 'X6', 2016, '5UXKU2C54G0N81138', 'http://cgi.ebay.com/ebaymotors/BMW-X6-xDrive35i-/331738922364?hash=item4d3d2e3d7c:g:EPQAAOSwZ1lWeosX&vxp=mtr', 'bmwoftulsa', '888-675-9328', '2016 BMW X6 xDrive35i', 'eBay', '2016-02-11 15:37:09'),
  127. (801, 'BMW', 'X6', 2013, '5UXFG8C52DL591107', 'http://cgi.ebay.com/ebaymotors/BMW-X6-xDrive50i-/181913027670?hash=item2a5adc8456:g:EQsAAOSw7FRWXLSJ&vxp=mtr', 'brooklynmitsubishi', '(888) 299-9830', '2013 BMW X6 xDrive50i', 'eBay', '2016-02-11 15:37:10'),
  128. (802, 'BMW', 'X6', 2016, '5UXKU0C53G0F92302', 'http://cgi.ebay.com/ebaymotors/BMW-X6-sDrive35i-/361478855289?hash=item5429d19a79:g:88UAAOSwXshWqo8h&vxp=mtr', 'bmwmidtown', '888-754-0426', '2016 BMW X6 sDrive35i', 'eBay', '2016-02-11 15:37:11'),
  129. (803, 'BMW', 'X6', 2016, '5UXKU6C50G0R33994', 'http://cgi.ebay.com/ebaymotors/BMW-X6-xDrive50i-/361478857317?hash=item5429d1a265:g:QU8AAOSwnLdWqpAS&vxp=mtr', 'bmwmidtown', '888-754-0426', '2016 BMW X6 xDrive50i', 'eBay', '2016-02-11 15:37:12'),
  130. (804, 'BMW', 'X6', 2016, '5UXKU2C59G0N81331', 'http://cgi.ebay.com/ebaymotors/BMW-X6-xDrive35i-/331765956198?hash=item4d3ecabe66:g:DyoAAOSwvUlWq-rt&vxp=mtr', 'bmwoftulsa', '888-675-9328', '2016 BMW X6 xDrive35i', 'eBay', '2016-02-11 15:37:13'),
  131. (805, 'BMW', 'X6', 2016, '5UXKU0C52G0F93067', 'http://cgi.ebay.com/ebaymotors/BMW-X6-sDrive35i-/361483738333?hash=item542a1c1cdd:g:aqsAAOSwnLdWs89d&vxp=mtr', 'bmwmidtown', '888-754-0426', '2016 BMW X6 sDrive35i', 'eBay', '2016-02-11 15:37:14'),
  132. (806, 'BMW', 'X6', 2013, '5YMGZ0C50DLL30034', 'http://cgi.ebay.com/ebaymotors/BMW-X6-/151974555636?hash=item236263aff4:g:IG4AAOSwXshWtN~8&vxp=mtr', 'sdlev', '866-241-8492', '2013 BMW X6', 'eBay', '2016-02-11 15:37:15'),
  133. (807, 'BMW', 'X6', 2016, '5YMKW8C54G0R42955', 'http://cgi.ebay.com/ebaymotors/BMW-X6-/361484894100?hash=item542a2dbf94:g:fv0AAOSwL7VWtdku&vxp=mtr', 'bmwmidtown', '888-754-0426', '2016 BMW X6', 'eBay', '2016-02-11 15:37:16'),
  134. (808, 'BMW', 'X6', 2016, '5UXKU2C5XG0N80253', 'http://cgi.ebay.com/ebaymotors/BMW-X6-xDrive35i-/331751427823?hash=item4d3ded0eef:g:PUAAAOSwHaBWktYb&vxp=mtr', 'bmwoftulsa', '888-675-9328', '2016 BMW X6 xDrive35i', 'eBay', '2016-02-11 15:37:17'),
  135. (809, 'BMW', 'X6', 2016, '5UXKU2C58G0N82177', 'http://cgi.ebay.com/ebaymotors/BMW-X6-xDrive35i-/361487434586?hash=item542a54835a:g:ABYAAOSwe7BWuxzZ&vxp=mtr', 'bmwmidtown', '888-754-0426', '2016 BMW X6 xDrive35i', 'eBay', '2016-02-11 15:37:18'),
  136. (810, 'BMW', 'X6', 2016, '5UXKU2C54G0N80720', 'http://cgi.ebay.com/ebaymotors/BMW-X6-xDrive35i-/331752210863?hash=item4d3df901af:g:okYAAOSwYIhWlDEy&vxp=mtr', 'bmwoftulsa', '888-675-9328', '2016 BMW X6 xDrive35i', 'eBay', '2016-02-11 15:37:19');
  137.  
  138. --
  139. -- Indexes for dumped tables
  140. --
  141.  
  142. --
  143. -- Indexes for table `jobs`
  144. --
  145. ALTER TABLE `jobs`
  146. ADD PRIMARY KEY (`id`);
  147.  
  148. --
  149. -- Indexes for table `records`
  150. --
  151. ALTER TABLE `records`
  152. ADD PRIMARY KEY (`id`);
  153.  
  154. --
  155. -- AUTO_INCREMENT for dumped tables
  156. --
  157.  
  158. --
  159. -- AUTO_INCREMENT for table `jobs`
  160. --
  161. ALTER TABLE `jobs`
  162. MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  163. --
  164. -- AUTO_INCREMENT for table `records`
  165. --
  166. ALTER TABLE `records`
  167. MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=811;
  168. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  169. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  170. /*!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!