text: -- MySQL dump 10.13  Distrib 5.7.23, for osx10.13 (x86_64)
  --
  -- Host: localhost    Database: restaurants
  -- ------------------------------------------------------
  -- Server version	5.7.23
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8 */;
  /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  /*!40103 SET TIME_ZONE='+00:00' */;
  /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  
  --
  -- Dumping data for table `banners`
  --
  
  LOCK TABLES `banners` WRITE;
  /*!40000 ALTER TABLE `banners` DISABLE KEYS */;
  INSERT INTO `banners` VALUES (1,'Schmeler and Sons','http://lorempixel.com/640/480','http://lorempixel.com/640/480','6722 Devyn Light','(253) 363-2495 x2315',5,8185,1,34),(2,'VonRueden - McGlynn','http://lorempixel.com/640/480','http://lorempixel.com/640/480','40803 Syble Station','593-043-4642 x76940',4,10368,0,16),(3,'Hirthe - Cruickshank','http://lorempixel.com/640/480','http://lorempixel.com/640/480','05199 Shaun Crescent','1-255-456-1877',5,6246,1,26),(4,'Hand Inc','http://lorempixel.com/640/480','http://lorempixel.com/640/480','08818 McLaughlin Circles','606-603-2825 x5393',4,12522,0,42),(5,'Kozey, Muller and Nolan','http://lorempixel.com/640/480','http://lorempixel.com/640/480','080 Greenfelder Street','423-610-0061 x325',1,8410,1,37),(6,'Collier, Doyle and Fahey','http://lorempixel.com/640/480','http://lorempixel.com/640/480','133 Goyette Court','000-018-2869 x788',5,8536,0,39),(7,'Leuschke, O\'Hara and Nolan','http://lorempixel.com/640/480','http://lorempixel.com/640/480','80256 Theodora Lake','1-000-726-8870 x30974',4,12976,0,30),(8,'Bradtke LLC','http://lorempixel.com/640/480','http://lorempixel.com/640/480','426 Chelsea Groves','1-967-112-0975 x23799',4,18111,1,14),(9,'Block - Kihn','http://lorempixel.com/640/480','http://lorempixel.com/640/480','56343 Elsie Greens','(729) 508-2907 x6761',2,9978,1,5),(10,'McClure, McClure and Brekke','http://lorempixel.com/640/480','http://lorempixel.com/640/480','3392 Aiyana Loop','(349) 282-8646',2,6582,1,48),(11,'Morissette - Hansen','http://lorempixel.com/640/480','http://lorempixel.com/640/480','304 Susie Haven','1-820-520-8789 x1171',1,14826,1,12),(12,'Koepp, Crist and Goyette','http://lorempixel.com/640/480','http://lorempixel.com/640/480','0749 Ethyl Roads','1-556-406-0387',1,12326,1,24),(13,'Stanton, Mosciski and Paucek','http://lorempixel.com/640/480','http://lorempixel.com/640/480','71952 Payton Fords','296-955-3548',1,3521,0,50),(14,'Senger Group','http://lorempixel.com/640/480','http://lorempixel.com/640/480','073 Annie Park','(662) 478-8929',5,5291,1,1),(15,'Ruecker, Beatty and Pollich','http://lorempixel.com/640/480','http://lorempixel.com/640/480','36158 Bode Brooks','(829) 781-4521',4,2863,0,48),(16,'West, Eichmann and Hilpert','http://lorempixel.com/640/480','http://lorempixel.com/640/480','3639 Durgan Union','417-390-5879',1,6021,1,42),(17,'Renner - Prohaska','http://lorempixel.com/640/480','http://lorempixel.com/640/480','01874 Brakus Crescent','1-642-695-4479',1,7788,1,8),(18,'Ritchie, Krajcik and Breitenberg','http://lorempixel.com/640/480','http://lorempixel.com/640/480','0132 Rowan Extensions','678.722.7889',1,9977,1,7),(19,'Beier - Bednar','http://lorempixel.com/640/480','http://lorempixel.com/640/480','634 Kling Inlet','(318) 189-1922',3,19073,0,24),(20,'Kuphal - Willms','http://lorempixel.com/640/480','http://lorempixel.com/640/480','1270 Greenholt Mission','133-342-7261',2,4734,1,24),(21,'Shields - Beer','http://lorempixel.com/640/480','http://lorempixel.com/640/480','04554 Morgan Station','104-044-4673 x89252',3,14139,1,42),(22,'O\'Conner LLC','http://lorempixel.com/640/480','http://lorempixel.com/640/480','23472 Markus Haven','389.077.9396 x02933',1,3125,0,24),(23,'Muller LLC','http://lorempixel.com/640/480','http://lorempixel.com/640/480','7656 Hoppe Lake','460.249.1261 x100',5,12905,0,9),(24,'Thompson, Nader and Brekke','http://lorempixel.com/640/480','http://lorempixel.com/640/480','9674 Zemlak Vista','781.509.8586',2,8564,1,36),(25,'Hessel, Hauck and Boehm','http://lorempixel.com/640/480','http://lorempixel.com/640/480','327 Corine Lodge','1-378-815-5483 x805',4,5294,0,41),(26,'Leuschke - Schroeder','http://lorempixel.com/640/480','http://lorempixel.com/640/480','56600 Wendy Crossing','962.820.8912 x922',1,2801,1,30),(27,'Stoltenberg and Sons','http://lorempixel.com/640/480','http://lorempixel.com/640/480','57479 Hermann Centers','(941) 279-0188 x96309',5,17552,0,15),(28,'Hayes - Erdman','http://lorempixel.com/640/480','http://lorempixel.com/640/480','468 Tina Vista','(722) 102-3238 x041',3,11823,0,24),(29,'Fadel, Quitzon and Ritchie','http://lorempixel.com/640/480','http://lorempixel.com/640/480','517 Parisian Points','(931) 679-6760 x6202',3,8213,1,27),(30,'Heidenreich, Wilderman and Olson','http://lorempixel.com/640/480','http://lorempixel.com/640/480','750 Herzog Summit','408-174-5115',4,4276,1,35),(31,'Schaden - Thiel','http://lorempixel.com/640/480','http://lorempixel.com/640/480','7511 Willow Gardens','(834) 488-7509',4,8847,0,26),(32,'Greenholt - Russel','http://lorempixel.com/640/480','http://lorempixel.com/640/480','8441 Leslie Corner','442.080.4162',4,426,0,39),(33,'Russel and Sons','http://lorempixel.com/640/480','http://lorempixel.com/640/480','94130 Cameron Expressway','(098) 787-4873 x63484',2,19526,1,41),(34,'Leffler - Daugherty','http://lorempixel.com/640/480','http://lorempixel.com/640/480','0366 Augustine Court','198.744.0786 x20608',5,12025,1,21),(35,'Powlowski, Collins and Johns','http://lorempixel.com/640/480','http://lorempixel.com/640/480','3222 Gertrude Key','1-783-576-7229 x22338',1,15925,1,12),(36,'Nolan - Runolfsdottir','http://lorempixel.com/640/480','http://lorempixel.com/640/480','763 Michael Crossing','1-305-843-9421',1,4793,0,23),(37,'Doyle, Murazik and Smith','http://lorempixel.com/640/480','http://lorempixel.com/640/480','92411 Balistreri Gateway','057-531-7252 x6242',2,11958,0,6),(38,'Mante - Stamm','http://lorempixel.com/640/480','http://lorempixel.com/640/480','4847 Muriel Green','1-058-949-6899 x20292',4,16914,0,15),(39,'Dare LLC','http://lorempixel.com/640/480','http://lorempixel.com/640/480','9279 Feest Meadow','705.910.0294 x4742',1,13343,0,25),(40,'Schiller, Toy and Zulauf','http://lorempixel.com/640/480','http://lorempixel.com/640/480','4503 Katrine Alley','(700) 939-3901 x122',2,2835,0,19),(41,'Harber - Hoeger','http://lorempixel.com/640/480','http://lorempixel.com/640/480','1417 Selmer Ports','331.892.7038',1,2190,0,40),(42,'Cole Group','http://lorempixel.com/640/480','http://lorempixel.com/640/480','4650 Kaia Course','368-102-9374 x540',4,15001,1,11),(43,'Kiehn and Sons','http://lorempixel.com/640/480','http://lorempixel.com/640/480','1915 Senger Lodge','1-769-912-7599',2,16568,1,6),(44,'Zboncak Group','http://lorempixel.com/640/480','http://lorempixel.com/640/480','797 Buckridge Crossroad','(427) 729-1739',3,2757,1,48),(45,'Moore, Rau and Zboncak','http://lorempixel.com/640/480','http://lorempixel.com/640/480','628 Kirlin Locks','431-552-7448',1,5247,0,1),(46,'Carroll, Harris and Graham','http://lorempixel.com/640/480','http://lorempixel.com/640/480','92943 Dach Field','905.377.7792 x53116',2,3049,0,11),(47,'Kshlerin LLC','http://lorempixel.com/640/480','http://lorempixel.com/640/480','4120 Douglas Light','623.305.1739 x95658',1,17200,1,42),(48,'O\'Conner, Hermann and Batz','http://lorempixel.com/640/480','http://lorempixel.com/640/480','62179 Laurianne Course','1-198-306-2780 x93980',3,16865,0,37),(49,'Jakubowski - Breitenberg','http://lorempixel.com/640/480','http://lorempixel.com/640/480','483 Waters Mill','912.384.3566 x5521',3,18755,0,33),(50,'Gleason - Dooley','http://lorempixel.com/640/480','http://lorempixel.com/640/480','2077 Schiller Burg','1-408-326-5492 x5806',3,16223,0,39),(51,'Bayer, Treutel and Ziemann','http://lorempixel.com/640/480','http://lorempixel.com/640/480','9651 Skiles Point','1-665-918-3465',1,16388,1,23),(52,'Mosciski - Torphy','http://lorempixel.com/640/480','http://lorempixel.com/640/480','4818 Hermann Meadow','951-196-5140 x98758',4,17356,0,16),(53,'Schowalter - Abbott','http://lorempixel.com/640/480','http://lorempixel.com/640/480','74349 Citlalli Rest','1-195-007-8270',4,14193,0,43),(54,'Schmidt - Williamson','http://lorempixel.com/640/480','http://lorempixel.com/640/480','671 Claude Harbor','391-459-7666',5,1647,1,39),(55,'Hayes, Rolfson and Crooks','http://lorempixel.com/640/480','http://lorempixel.com/640/480','42698 Graham Corners','(324) 881-8007 x2965',1,8544,0,14),(56,'McKenzie - Hauck','http://lorempixel.com/640/480','http://lorempixel.com/640/480','01902 Schuppe Path','1-120-143-7912 x25343',3,15742,0,3),(57,'Skiles - Rippin','http://lorempixel.com/640/480','http://lorempixel.com/640/480','5358 Alberto Ports','750-714-4506',2,4488,1,23),(58,'Smith - Daniel','http://lorempixel.com/640/480','http://lorempixel.com/640/480','45112 Van Loaf','1-535-154-6458 x1103',4,16858,0,36),(59,'Kreiger - Corkery','http://lorempixel.com/640/480','http://lorempixel.com/640/480','996 Beier Stravenue','(273) 313-7619',1,9042,0,14),(60,'Rohan LLC','http://lorempixel.com/640/480','http://lorempixel.com/640/480','8789 Cronin Way','1-238-048-8505',5,10099,1,10),(61,'Herzog, Kassulke and Schuppe','http://lorempixel.com/640/480','http://lorempixel.com/640/480','473 Lennie Key','1-861-258-3034 x976',1,6662,1,50),(62,'Schulist, Hirthe and Bednar','http://lorempixel.com/640/480','http://lorempixel.com/640/480','78774 Gerry Cliff','1-913-933-5078',5,1909,0,25),(63,'Nitzsche - Purdy','http://lorempixel.com/640/480','http://lorempixel.com/640/480','81940 Durgan Stream','1-261-101-6615 x822',3,14774,0,20),(64,'Graham LLC','http://lorempixel.com/640/480','http://lorempixel.com/640/480','8945 Javier Circle','624.753.7290 x2643',5,9401,1,24),(65,'Trantow - Yundt','http://lorempixel.com/640/480','http://lorempixel.com/640/480','51253 Janis Crescent','1-453-341-0716 x081',4,8610,0,4),(66,'MacGyver - Bergnaum','http://lorempixel.com/640/480','http://lorempixel.com/640/480','1927 Reynolds Drive','1-542-053-1002 x207',2,14675,0,45),(67,'Runolfsdottir - Wiza','http://lorempixel.com/640/480','http://lorempixel.com/640/480','71477 O\'Connell Village','(689) 057-7529',3,784,1,35),(68,'Kertzmann Group','http://lorempixel.com/640/480','http://lorempixel.com/640/480','70770 Mekhi Valley','433-656-6168',4,18346,1,25),(69,'Pfannerstill - Russel','http://lorempixel.com/640/480','http://lorempixel.com/640/480','5321 Kihn Brooks','1-515-755-1489',1,12368,0,15),(70,'Rempel, Bartoletti and Bashirian','http://lorempixel.com/640/480','http://lorempixel.com/640/480','5784 Carroll Spurs','1-847-259-4206',1,9573,1,33),(71,'Farrell - Kuhn','http://lorempixel.com/640/480','http://lorempixel.com/640/480','264 Ward Motorway','866.052.9493 x597',3,2579,0,37),(72,'Jenkins LLC','http://lorempixel.com/640/480','http://lorempixel.com/640/480','538 May Lock','485-036-3720 x8817',5,13034,0,12),(73,'Davis - Maggio','http://lorempixel.com/640/480','http://lorempixel.com/640/480','126 Wiza Mount','1-162-845-1241 x565',3,17330,1,20),(74,'Kilback LLC','http://lorempixel.com/640/480','http://lorempixel.com/640/480','891 Rice Parks','(033) 736-3024',2,13225,1,4),(75,'Beatty - Schimmel','http://lorempixel.com/640/480','http://lorempixel.com/640/480','447 Robb Spurs','(919) 792-7887',3,12974,1,31),(76,'Effertz, Hilll and Wilkinson','http://lorempixel.com/640/480','http://lorempixel.com/640/480','0543 Mertz Path','(278) 863-8081 x364',5,3053,1,19),(77,'Parisian - Keebler','http://lorempixel.com/640/480','http://lorempixel.com/640/480','688 Chelsey Courts','621-123-2131',4,8749,1,46),(78,'Steuber - Rempel','http://lorempixel.com/640/480','http://lorempixel.com/640/480','4517 Eichmann Stravenue','(876) 119-9705 x2394',3,4525,0,30),(79,'Hermiston - Lockman','http://lorempixel.com/640/480','http://lorempixel.com/640/480','459 Schuppe Haven','(132) 479-0334',3,7795,0,21),(80,'Kertzmann, Walter and Buckridge','http://lorempixel.com/640/480','http://lorempixel.com/640/480','96348 Emmett View','308.531.3339 x0708',3,4909,1,28),(81,'Rath Inc','http://lorempixel.com/640/480','http://lorempixel.com/640/480','926 Breana Drive','425.444.7076',4,19319,1,1),(82,'Spencer - Hauck','http://lorempixel.com/640/480','http://lorempixel.com/640/480','90258 Boris Key','043.910.2022',5,10715,1,49),(83,'Blick Group','http://lorempixel.com/640/480','http://lorempixel.com/640/480','767 Towne Fork','1-156-558-5585 x1521',3,11941,1,30),(84,'Senger - Ankunding','http://lorempixel.com/640/480','http://lorempixel.com/640/480','4258 Waldo Summit','1-837-704-5540',1,4064,0,2),(85,'Effertz, McCullough and Ritchie','http://lorempixel.com/640/480','http://lorempixel.com/640/480','1042 Joyce Throughway','1-349-703-2949 x669',1,16951,1,35),(86,'Denesik - Bernier','http://lorempixel.com/640/480','http://lorempixel.com/640/480','71181 Royal Underpass','371-933-8396',1,2531,0,9),(87,'Treutel Group','http://lorempixel.com/640/480','http://lorempixel.com/640/480','91201 Sawayn Club','543.303.8537',1,18685,0,34),(88,'Wehner Inc','http://lorempixel.com/640/480','http://lorempixel.com/640/480','3883 Feeney Lane','254-155-2290 x41882',2,3597,0,3),(89,'Metz LLC','http://lorempixel.com/640/480','http://lorempixel.com/640/480','7688 Mueller Crescent','124-469-3735 x493',1,18145,0,17),(90,'King, Strosin and Marks','http://lorempixel.com/640/480','http://lorempixel.com/640/480','19545 Aliya Valley','(595) 221-7613 x667',2,10471,0,20),(91,'Abbott and Sons','http://lorempixel.com/640/480','http://lorempixel.com/640/480','91871 Grant Dam','003.321.2550 x23778',5,11634,1,3),(92,'Ebert, Hansen and Wisoky','http://lorempixel.com/640/480','http://lorempixel.com/640/480','213 Kayli Ferry','1-889-730-1933 x919',5,8140,1,33),(93,'Kulas LLC','http://lorempixel.com/640/480','http://lorempixel.com/640/480','3306 Zelda Causeway','603.701.6792 x0163',1,13065,1,38),(94,'Bernier - Gaylord','http://lorempixel.com/640/480','http://lorempixel.com/640/480','7996 Millie Via','848.978.4744 x45418',4,5866,1,3),(95,'Balistreri - D\'Amore','http://lorempixel.com/640/480','http://lorempixel.com/640/480','94018 Nikolaus Lake','524-025-3427',4,14706,0,31),(96,'Harvey LLC','http://lorempixel.com/640/480','http://lorempixel.com/640/480','02231 Kozey Heights','(338) 156-7821 x288',4,4786,0,25),(97,'Kertzmann and Sons','http://lorempixel.com/640/480','http://lorempixel.com/640/480','953 Ebony Keys','(478) 499-0976',4,2346,1,30),(98,'Hagenes LLC','http://lorempixel.com/640/480','http://lorempixel.com/640/480','74306 Trantow Ridges','985.539.4697 x705',4,6427,1,14),(99,'Huels and Sons','http://lorempixel.com/640/480','http://lorempixel.com/640/480','943 Elmore Curve','(285) 592-5624 x302',4,3952,0,5),(100,'Rath - Bahringer','http://lorempixel.com/640/480','http://lorempixel.com/640/480','609 Weimann Cape','653.583.9531 x6076',4,2296,1,34);
  /*!40000 ALTER TABLE `banners` ENABLE KEYS */;
  UNLOCK TABLES;
  /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  
  /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  
  -- Dump completed on 2018-11-09 20:23:57
  