![](\"https://lh6.googleusercontent.com/g9rZx_bMFbmHu1DllC4lCOEkiyYLNP7xrZ0hnfg90c0bdEGYH3dzNKsiXM5Knu_fLTtam9iJGl82Ml98_yxPFpQGdbuepo_hc_zLccQN9eDIQL9_VbYvpApQt3BCmOzKsVgKrb4\")
We all have our reasons for traveling—wanderlust, the love of a new culture, a desire to just leave it all behind, the need to take a break from your daily routine, or the need to meet new people. Whenever we get that itch to get out of town, the last thing we want is to spend a lot of time and money planning a vacation.
\r\n\r\nOur business is making your dream vacation affordable. So we’ve put together some clever tips for seasoned jetsetters and first-timers alike on how to save money when booking airfare, hotels, rental cars, and more.
\r\n\r\nBelieve it or not, there is a correlation between when you purchase airfare or accommodation and how much it could potentially cost. Here’s our advice.
\r\n\r\nAccording to Expedia’s annual Air Travel Outlook report, from most parts of the world
\r\n\r\n—regardless of destination— average ticket prices (ATPs) for economy and premium cabins tend to rise as the departure date gets closer. Waiting to book at the last minute can be an expensive gamble. Booking three weeks ahead of a trip is the “sweet spot” for fare savings.
\r\n\r\nEconomy and premium cabin ATPs tend to be lower when booked on a weekend, usually on a Sunday. (New Zealand is one exception, where Tuesday is usually the least expensive day to book air travel.) Many people save up to 20%, and some can save as much as 36% by booking on a Sunday. The most expensive tickets tend to be booked on Thursdays and Fridays.
\r\n\r\nDrawing from Expedia Group’s inventory of more than 895,000 properties offered, data analysts compared the average daily rates (ADR) across different reservation days. Results reveal travelers generally find lowest ADRs on Fridays. Unlike airfares, the most expensive day to book a hotel is generally on a Sunday.
\r\n\r\nFlight data confirms that traveling ahead of the holidays is bound to be hectic. These are the busiest air travel days of the year, and will likely be more expensive:
\r\n\r\nThe least busy travel days of the year also fall around the holidays: the day after Christmas, Christmas Day and New Year’s Day. Consider flying on these days to save time and money.
\r\n\r\nExpedia also conducted a study last year that found rental car demand spiked on summer Fridays, specifically ahead of July 4th and Labor Day. These are clearly big weekends for travel and road trips, so it’s a good idea to reserve your ride early to lock in availability and a good rate. If you’re planning a trip during the holidays, try to avoid the peak travel days (usually the Wednesday before Thanksgiving and Sunday following) to score better prices and shorter lines at the airport.
\r\n\r\nKeep in mind for your vacation planning how to use the holidays to your advantage. Most of us don’t have unlimited time off from work, so building your trip around three-day weekends, like Labor Day, can be a smart way to extend your trip and get the most out of your vacation.
\r\n\r\nNo matter where you’re headed, start your journey on Thursday or Friday to save.
\r\n\r\nOne surefire way to save money on spring break travel is to book a package. On a site like Expedia, you can save an average of $600 just by bundling your flight and hotel together, which is really significant.
\r\n\r\nPackages are a great way to save, but it isn’t always the easiest or most convenient way to book. In fact, nearly 50% of people prefer to book their flight first and come back for their hotel later. It makes sense – the flight is the easy part, but choosing a hotel requires researching your destination, comparing rates and amenities, flipping through room photos. And it’s expensive to book everything all at once.
\r\n\r\nYou can get discounted hotel rates when you add on to your existing trip. Begin by shopping for your flight tickets, rental car, activity or vacation package on Expedia.com. After you book, you’ll instantly unlock savings up to 43% off select hotels until the day of your trip—giving you time to find just the right hotel. You’ll also unlock savings on rental cars and activities.
\r\n\r\nThe ability to add on to an existing flight reservation is the perfect solution for travelers, no matter how or when they like to book.
\r\n\r\nEnjoy the comforts of home—spacious living, privacy and fully-stocked kitchens—by staying in a vacation rental. Expedia has milions of unique places to stay around the world, and travelers who rent vacation homes often get twice the space for half the cost of a hotel.
\r\n\r\nSometimes life throws you a curveball and you can’t always plan ahead. Whether you’re booking a getaway on a whim or needing a place to rest during an unexpected event, the last minute deals page on Expedia.com has tons of flights, hotel, cruise and package deals that will help you save on travel.
\r\n\r\nLast-minute hotel deals: In some instances, waiting until the last minute to book a hotel can result in a lower average daily rate as some hoteliers look to fill as many rooms as possible.
\r\n\r\nLast-minute flight deals: Expedia’s cheap fight deals will save you money on your unplanned travel arrangements. Check out our huge selection of last-minute airfare, custom search options, and personalized recommendations to soar into your adventures tomorrow.
\r\n\r\nThe ability to earn points or miles or rewards is important, regardless of how frequently or infrequently you travel. If you haven’t already done so, sign up for ALL of the loyalty programs. Rack up the frequent flier miles, hotel points, and sign up for expedia rewards to double down—you’ll collect points on all your bookings and you can use them immediately.
\r\n\r\nFly with points: When travelers collect enough points to cover the full cost of a flight, the “Use My Points” option will appear at checkout on Expedia.com.
\r\n\r\nUse as many or as few as you want: In addition to hotels, members can now redeem points to save money on rental cars and Things to Do (tours, attractions and activities). For added flexibility, you can redeem as many (or as few) available points as you want to shave a couple dollars off or to cover the full booking.
\r\n\r\n\r\n', '10', 1, 1, 'f11563fcd9fcb069c45c83442688a5bf.jpg', '0622279ece55f7791972d4ef9483b22e.jpg', '1572667200', '1572843600'), (3, 'AMERICA’S FAVORITE CHEAP PLACES TO EAT', '
Have you ever tried to define “American food”? It’s a deliciously complex undertaking, isn’t it? America’s cuisine, like its culture, is diverse and exciting. Where can you get kimchi tacos and paneer pizza? America! As you travel the 50 states, you’ll see a range of prices, too. When it comes to tasting your way through the home of the free, it’s important to save money on cheap foods…so you can eat more.
\r\n\r\nWe created a series of guides to America’s best cheap places to eat, so you can navigate each tasty town on a budget. Get the highlights here and pack your stretchy pants!
\r\n\r\nBoston's best cheap eats are all about student-friendly menus in historical haunts. Flour Bakery + Café is a charming place to get savory and sweet eats at multiple locations. Living that plant-based life on a budget? You’ll dig the flavorful bowls at veggie-forward Spyce. Before you say “Bye, Boston,” sample real New England clam chowder at The Boston Chowda Co. in historic Quincy Market.
\r\n\r\nWhen it comes to cheap eats in Atlantic City, local eateries are very serious about serving up delicious dishes for small budgets. Get your hands on an unbelievably fresh fried platter from Barbera Seafood Market, opt for ramen and boba tea at Empire Kitchen, or order the Italian sub at White House Sub Shop. Each one is a landmark and serves some of the yummiest food in town.
\r\n\r\nBetween wicked waves and sunset strolls in Honolulu, order Hawaii’s own innovation Spam musubi from Musubi Café Iyasumi. Crave a classic bento with island vibes? Make Highway Inn your go-to for some of the cheap Honolulu food on the island. And when you need short ribs ASAP, Helena’s Hawaiian Food is the locals-approved place to be!
\r\n\r\nEncircled in beaches and spectacular dive sites, Key West can work up your appetite pretty quickly. Start the day with a cheap breakfast of eggs and grits—and heaps of personality—at Harpoon Harry’s. Cuban Coffee Queen is the epitome of beach town casual and makes oh-so affordable eats and drinks. If coffee counts as cheap food, so does beer. First Flight Brewery has a tropical outdoor patio and $5 happy hour specials. Bottoms up with the best cheap eats in Key West!
\r\n\r\nMaui makes it easy to find some of the best cheap retaurants in the country. Tin Roof is famous for its Polynesian breakfasts for early morning surf trips or late-morning comfort food. For casual diner delights, head to Tasty Crust in Wailuku. And when you want a grab-and-go snack in the quiet community of Haiku, order a fresh loaf from Aunty Sandy’s Banana Bread.
\r\n\r\nIn Miami, the vibrancy of Caribbean and Latin cultures takes the lead and you can taste it in Miami's cheap eats cuisine. Start your day with coffee and carbs at Salty Donut; their seasonal selection is as inventive as it is yummy. Then, enjoy traditional cortado coffee and Cuban-style croquettes at Versailles, or make a splash My Ceviche—a seafood place that serves wild fish and colorful bowls.
\r\n\r\nIs the U.S. capital on your must-visit list? Then you need to know where to find good cheap places to eat in D.C. Believe it or not, the White House doesn’t give out cheeseburgers. Instead, dig into D.C.’s famous chili and half-smokes at Ben’s Chili Bowl, or eat your favorite sammie with a twist at Wicked Waffle. Feeling fresh? The salads and falafel at Zorba’s Café will hit the spot.
\r\n\r\nNew Orleans is a great place to sample some of the best cheap eats in the world. You can get three beignets for under $3 at Café du Monde—need we say more? Well, you can’t live on delectable donuts alone! Mother’s Restaurant is known for their baked ham, and Killer Poboys makes savory sandwiches with a lot of attitude and small prices. So, make sure you save room for sammies when you explore NOLA's best cheap eats.
\r\n\r\nThis NorCal city is known for its billion-dollar tech companies and expensive views of the Pacific. So, when you’re eating your way through San Francisco on a budget, consider us your best travel buddy. And the best friends help you find tacos, like the super affordable hand-helds at Street Taco and Super Duper Burgers. Taste San Francisco’s Cantonese heritage in food form at Sam Wo Restaurant, a city favorite since 1907.
\r\n\r\nNashville cheap eats are hearty, bold, and perfected by generations of tasting and sharing. You’ll find that truth at the bottom of an $8 gravy-smothered biscuit plate at aptly named Biscuit Love, or in the carefully crafted pastries at Vegan Vee. Music City’s signature dish will have you singing for more at Hattie B’s Hot Chicken—it’s fried, hot, and easy on the budget. Yum!
\r\n\r\nMany travelers think of Asheville as a beer town, but the local food scene is just as refreshing as the award-winning libations. Laughing Seed Café is sure to make your taste buds smile, whether you’re a vegan, vegetarian, or a gluten-free omnivore. Looking for a chic experience with a budget-friendly price? Sovereign Remedies is the perfect place to get affordable boozy brunch. Top off your menu of cheap Asheville eats with handmade sweets from Vortext Doughnuts.
\r\n\r\nBay Lake and the Orlando area is where you’ll find the best cheap places to eat when you’re exploring popular theme parks. Keep up with the kids with a little help from the folks at Foxtail Coffee Co., a coffee roaster and pastry slinger. For lunch, indulge in some good ol’ fashioned biscuit sandwiches at Holler & Dash Biscuit House, then make sure everyone in the family has something fresh, healthy, and delish at Greenbeat. Cheap restaurants near Orlando are all about balance, especially when you’re park hopping.
\r\n\r\nFood brings people together and gives us energy for our most memorable experiences. Now that you know where to find some of the best cheap restaurants in the U.S., let the adventures begin!
\r\n', '1', 1, 1, 'f51408a1aa2c45625be91526079c7c61.jpg', 'd332829cf1ec8aa389f72caeab926fb4.jpg', '1572753600', '1572843600'), (4, 'A FITNESS DAY IN JOHANNESBURG', 'My name is David Jacobsz from Johannesburg, South Africa. I’m a real family man, who just loves sports. My current sport is powerlifting, so being in the gym on a daily basis I don’t see as training but rather a daily routine. To relax, I spend time with my wife and daughter doing the things they love to do—and that is shopping, or we take a drive to explore or try out something new. On holidays or long weekends, we try to go and see all South Africa has to offer, and every now and then we explore international destinations.
\r\n\r\nIt is 5:30 a.m. in Johannesburg. Many people don’t know this, but Johannesburg was named the world’s largest hand-made forest. So it’s not strange to hear the sounds of birds this early in the morning. It is Saturday morning, so in general people feel the need to sleep in after a hard week at work. Actually, it’s a good time for a workout at the local gym. I take the opportunity to have all the equipment for myself and take full advantage of the time I have for training and to clear my mind. Others prefer to take on the tar road with their bicycles. For me, a good workout is the perfect start to any day. It relaxes the mind and energizes the body; the endorphins released during training triggers a positive feeling. With my companion Fitbit, I start counting my steps and calories. Before my workout I already had 1,039 steps and burned 625 calories. After my workout I did 2,029 steps and burned 914 calories.
\r\n\r\nFresh air is always good for a person, especially if you live in the city. Now it’s almost 8 a.m. and time for a parkrun. These events take place in pleasant parkland surroundings and they encourage people of all ages to take part—from walkers or those taking their first steps in running to Olympians; from juniors to those with more experience; everybody is welcome. I usually take my family for this fun run. My daughter is only 2 years old and she just loves it.
\r\n\r\nThe route is multi-terrain, taking in tar, gravel, grass fairways, medium rough grass, and cart paths. Family and friends enjoy the run next to the Van Ryn Dam for a beautiful backdrop on this scenic route, with different birdlife and antelopes on the golf course. Today I left the family slightly behind as I ran my personal best in the parkrun. Before the start I already did 2,574 steps and burned 1,118 calories. After the 5km run, I did 7,834 steps and burned 1,775 calories.
\r\n\r\nIt’s almost 10 a.m. and time for another fun activity that is sure to leave you out of breath and a good overall body workout. It’s time for I-Jump (also known as Bounce). It is an indoor trampoline arena with lots of fun for the whole family. From dodgeball to wall climbing and even slam dunks, this place also provides great fun for team building events, as many corporate companies use it for a fun day out or secretly get the team to do some exercise. They work on hourly time slots, which is more than enough for that full body workout. It is also perfect for children’s birthday parties—both parents and children join in the fun. The various trampolines cater to all levels.
\r\n\r\nWhether you are there for fun or a serious session, there is something for all. The dodgeball area is always good fun for team building (or a perfect opportunity to get even with the boss). Personally I enjoy the slam dunks—I’m not the tallest, so to be able to jump that high is just an amazing feeling.
\r\n\r\nBefore this fun exercise I already did 8,516 steps and burned 2,112 calories. After all the jumping, I did 11,040 steps and burned 2,600 calories.
\r\n\r\nAfter a good exercise day like today there is nothing better than to eat a traditional South African braai (barbecue)—the more meat (protein) the better. Should we feel the need for some vegetables we add some chicken to the braai. This is also rugby season in South Africa, so the only snack available is some good biltong (beef jerky). Over weekends the only smell in the air is that of fires getting ready for a braai. South Africans love to braai so much we even have a National Braai Day!
\r\n\r\nThis was a fun filled exercise day. Just before 8 p.m., I finished with 15,457 steps, 12.5km, burned 4,090 calories, did 15 staircases, and my overall training time was for 190 minutes.
\r\n', '27', 1, 1, 'dbec45531e836946fd8975ef49d86568.jpg', '0982f6c9df44158cdbda4b9a17d9619f.jpg', '1572753600', '1572843600'), (5, 'PARIS TRAVEL TIPS FOR FIRST-TIMERS', 'Paris. The city that’s inspired a million love poems, high-end fashion, and a certain je ne sais quoi lifestyle. It’s a place that rightly belongs at the top of any bucket list. Here are some Paris travel tips that will get you ready for your first vacation in the City of Lights.
\r\n\r\nLate March through June and September through late October are regarded as the best months to visit Paris. Temperatures hover between 55-57 degrees in both March and April, and up to 64-70 degrees in May and June. As long as you don’t mind wearing a coat and gloves, you can enjoy the city just fine in spring. On the flip side of the year, temperatures hover between 60-68 degrees in fall.
\r\n\r\nThere are three major airports around Paris, though most flights to Paris land at Charles De Gaulle Airport (CDG). Charles De Gaulle hosts the most international flights, and is located around 22 miles north of the city. Orly Airport (ORY) is closest to the city center at 12 miles south, though is on the smaller side and often used by European travelers or visitors flying in from New York. Tillé Airport (BVA) is the furthest from the city at 60 miles north, but hosts budget airlines if you’re willing to trade time for money.
\r\n\r\nIt’s important to show respect by learning a few basic French phrases before your trip. Automatically speaking in English is considered arrogant and rude. That said, many French people do know basic English. As long as you make that first attempt, they’ll often help you out. Here are some phrases to memorize before traveling to Paris for the first time.
\r\n\r\nKnowing these phrases–and a few others–will help you tremendously as you explore the city.
\r\n\r\nThe train system around Paris is phenomenal and offers stops at all the major attractions around the city. Walking around town is also a top option. Several attractions are close together and the architecture alone is worth the stroll. A few interesting notes about Parisian train stations:
\r\n\r\nYou may be surprised how easy it is to navigate Paris once you start exploring.
\r\n\r\nParis can be expensive or cheap, depending on your travel style. International flights can get pricey, though the ones from major cities like LA or New York can be dirt cheap. A weekend or week pass from the metro is higher than other destinations, but that’s all the transportation costs you’ll need for the trip. And yes, some hotels are pricey, but a well-located hotel in Paris puts you within walking distance of everything you want to see.
\r\n\r\nThis pricing philosophy applies to food as well. High-end restaurants will cost you a pretty penny, while street cart food is legendary in quality and only costs a handful of euros. Finally, many museums are free the first Sunday of the month from October to March, and outdoor sites like the Wall of Love are always free.
\r\n\r\nTipping is much different in Paris than American cities. Tipping for regular service in America runs between 15-20%, which is seen as far too extravagant in France. Here’s a helpful guide for how much to tip:
\r\n\r\nRemember to keep a few extra euros around for these tipping opportunities.
\r\n\r\nNo. The French tend to be more reserved and direct than Americans, which can take travelers by surprise. They’re a lot like residents in major cities like Chicago, San Francisco, or LA; French folks aren’t overly friendly, but they will kindly assist you if you need help. They’re also very respectful, so you’ll hear “Pardon” immediately if someone accidentally bumps into you and there are far fewer instances of manspreading on trains.
\r\n\r\nParis is a gorgeous city with a ton to do, but it also operates at a slower pace. While you can cram tons of attractions into your day, a top Paris travel tip is to stick to a few highlights and take your time with each point of interest.
\r\n\r\n- Atelier Des Lumieres: You’ve never been to an art exhibit quite like this. This immersive experience projects elements of Van Gogh’s paintings on the walls and floors. Watch as colors blend and change, while figures move throughout the landscapes. Each painting “scene” has a different musical soundtrack. The highlight is “Starry Night.” The painting is projected on the walls and floors—making you feel like you’re standing in the middle of it.
\r\n\r\n- Eiffel Tower: Yeah, it really is that beautiful. The gold coppers are lovelier in person than you’ve ever seen in pictures. If you want to take in a dazzling view of the city, head to the top—there’s a champagne bar there that will give you a view to remember.
\r\n\r\n- Pere Lachaise Cemetery: Are you a writer or creative type? You might be surprised how inspired you’ll feel after visiting Pere Lachaise Cemetery. It’s the most visited cemetery in the world, with celebrities like Oscar Wilde, Frederic Chopin, and Jim Morrison laid to rest here. The ancient mausoleums, mossy tombstones, and stone paths lined by squawking black crows all give the place a spooky atmosphere.
\r\n\r\n- The Louvre: You’ve no doubt heard about it and seen it featured in plenty of movies—”Wonder Woman” being one of the most recent ones. It’s the biggest museum in the world, and home to 380,000 art pieces. This includes the iconic “Mona Lisa” and “Liberty Leading the People.” You can spend days exploring all the rooms, so give yourself plenty of time to explore.
\r\n\r\n- Stravinsky Fountain – This whimsical fountain blends old-world architecture with colorful modern art—both in the water and on murals around the area. This is a good spot to sit and enjoy some street cart food like crepes and naughty baguettes from Legay Choc. The fountain is also a central location. You’re within walking distance of Centre Pompidou, Notre Dame, and the Seine river.
\r\n\r\nThese attractions are just a few of the many incredible things to see in the city.
\r\n\r\nEuropean outlets are different than American ones, so bring a travel adapter for your electronics.
\r\n\r\n- Parisians are well-known for their sense of style, and it’s wise to meet their standards. This doesn’t necessarily mean flashy fashion; Parisian style includes well-fitted coats and pants, quality boots and shoes, ironed shirts, and colorful scarves.
\r\n\r\n- Be aware of pickpockets. They’re common enough that even locals will remind you to be smart with what you’re keeping loose in your pockets. Keep an eye out for people who ask you to sign petitions, as this is often part of a pickpocketing scheme; someone can pick through your backpack while you’re distracted.
\r\n\r\n- Protests can get crazy, and it’s advisable to avoid them if they pop up. The city tends to be proud of its protest culture, but don’t get swept up in the possible chaos.The food is just as good as you’ve heard. If you’re visiting in winter, try the hot chocolate. The liquid is so thick, cafes give you a plastic spoon to help stir! The butter, cheese, and bread are just as unforgettable.
\r\n\r\nHave you ever been somewhere that felt like a dream? Paris is just like that. The grand buildings, the sweet chocolate, the bombastic artwork all make Paris the best city you’ve ever explored. Simply follow our tips and tricks and you’ll feel like a local in no time.
\r\n\r\n
\r\n
With sand, seafood and serious entertainment, a weekend in Virginia Beach is the ultimate beach break. You can feast on freshly-caught fish, listen to live music or simply stroll alongside the Atlantic Ocean – the issue is how to fit everything in. Here’s our itinerary, with ideas for spending two or three days in Virginia Beach.
\r\n\r\nYou only have 72 hours in Virginia Beach, so make Friday night memorable. Dump your bags and make a beeline for Virginia Beach’s buzzing boardwark. The three-mile long boardwalk is a hub for nightlife, with bars, restaurants and live music venues overlooking the ocean. Get your first taste of Virginian seafood at Catch 31. Its “dock to table” menu includes a raw bar and impressive oyster selection.
\r\n\r\nFor after-dinner entertainment, usually from June through Labor Day Weekend, look no further than Live! On Atlantic. The program features street performers and free live music at four open-air oceanfront venues. Come during the annual Neptune Festival in September for more live music, art shows and sand sculpting. Near the 7th Street stage, laid-back Chix on the Beach has late-night DJ sessions and an extensive drinks menu. Try the Orange Crush, the favorite cocktail of Virginia Beach locals.
\r\n\r\nShake off last night’s Orange Crushes and spend the first of your remaining 48 hours at Commune, a sustainable, organic café. It focuses on farm-to-table dining showcasing local ingredients from the café’s farm. The menu features hearty breakfasts like the Winter Heirloom Grit Bowl and Big Backyard Salad.
\r\n\r\nCommune is within Virginia Beach’s ViBe Creative District, an area for artists and creative businesses, a few blocks from the beach. Wander the area after breakfast and you might run into the regular farmer’s market or community art project.
\r\n\r\nVirginia Museum of Contemporary Art (MOCA) is a short walk away and displays works from regional, national and international artists. As well as regularly changing exhibitions focused on painting, sculpture, photography, glass and other visual media, MOCA hosts the Boardwark Art Show, in June. The museum is open 10am-4pm on weekends, but check ahead as it closes during exhibition installation. Entry is $8.
\r\n\r\nBack in the ViBe district, drop into the Chesapeake Bay Distillery, Virginia’s first gold and double gold craft distillery. The distillery serves everything from Ghost Pepper Infused Vodka to Dr. Stoner’s Smoky Herb Whiskey. Tastings are available, and free tours can be enjoyed on Saturdays from 12pm to 4pm (you’ll need to book a slot). If beer is your tipple, Virginia Beach has a vibrant craft brewing scene. Follow the beer trail to up to 25 city brewing destinations, with beers ranging from flavor-filled IPAs to a pumpkin porter.
\r\n\r\nTreat yourself for Saturday night in Virginia Beach with a dinner to remember at award-winning Terrapin. Using the freshest, locally-sourced ingredients, the restaurant supports organic farmers and fishermen in the region. It’s one of Virginia Beach’s most-acclaimed restaurants. The eclectic menu includes everything from crispy short rib with cauliflower and kimchi to softshell crab with bok choy and jalapeno-cilantro emulsion. Book a table in advance.
\r\n\r\nDo as the locals do and spend Sunday morning in Virginia Beach walking, jogging or cycling along the boardwalk. If you fancy meeting one of the city’s most famous residents, walk until 31st Street where the 26-foot tall statue of King Neptune looms over the boardwalk.
\r\n\r\nYou’ve now got fewer than 24 hours left in Virginia Beach, so if you really want to make the most of it get up before the sun. You’ll be rewarded with a cool Atlantic breeze and a sunrise over the ocean.
\r\n\r\nOn your way to First Landing State Park, stop by Bay Local Eatery. Here you can fill up on brunch fare like fried chicken and waffles or biscuits with sausage gravy. Once inside the park, you can follow one of nine hiking trails through 3,888 acres of woodlands, including a 1.5-mile strip along Chesapeake Bay beach.
\r\n\r\nThe Virginia Aquarium & Marine Science Center is located just south of Rudee Inlet at the southern end of Virginia Beach Boardwalk. The center houses more than 300 species including sharks, Komodo dragons and loggerhead sea turtles. It’s open from 9am-5pm.
\r\n\r\nCheck the events calendar to time your visit with a ray feeding or a talk about harbor seals. On the marine theme, Pleasure House Oysters run farm tours on the Lynnhaven River. Bringing a bottle of wine is encouraged and you can even dine in waders as part of the Chef’s Table Tour.
\r\n\r\nSunday night in Virginia Beach can be relatively quiet, but Hot Tuna on Shore Drive takes advantage of the final weekend hours. With seafood from Chesapeake Bay and Certified Hereford steaks, Hot Tuna is also known for its outdoor fire pits, live music and daily happy hour from 4-6pm.
\r\n\r\nVirginia Beach is one of the country’s most famous beaches – but it’s much more than a stretch of sand. The city comes alive in summer and the vibrant nightlife, creative culture and top quality food and drink scene is year-round. A weekend is barely enough but it’s a start. So book your getaway to Virginia Beach today.
\r\n\r\n\r\n', '2', 1, 1, '834d506e330f01a8be9cd5c360729065.jpg', '0bf6e852657a27056a09e4e0f1031c43.jpg', '1572753600', '1572843600'); INSERT INTO `blogs` (`id`, `title`, `blog_text`, `category_id`, `user_id`, `status`, `blog_thumbnail`, `blog_cover`, `added_date`, `modified_date`) VALUES (7, '10 VACATION SPOTS TO UNPLUG', '
We recently released the results of our 18th annual Vacation Deprivation study, which showed that people struggle to use vacation time and disconnect. In fact, around a quarter of American workers admit to checking their work email/voicemail at least once a day while on vacation.
\r\n\r\nTo help workers truly unplug, we identified 10 destinations/hotels where visitors are essentially FORCED to leave work and life behind (no wifi, ‘digital detox concierges, etc). The winter months are a great time to visit any and all of these destinations, so now’s the perfect time to start planning a trip.
\r\n\r\nDon’t join the tourists at Cancun, instead head two hours northwest to Isla Holbox and prepare to be transported straight to paradise. With no TV’s, phones, alarm clocks, and very limited WiFi, at CasaSandra you’re free to focus on the beautiful white beaches, exotic animals, daily yoga and delicious local food.
\r\n\r\nDitch your electronics and slow down at the largest stretch of beach in Tulum. At the Maya Tulum Resort, you can explore Mexico’s Riviera’s crystal-clear water and restore your body with their healing Spa treatments.
\r\n\r\nIf you must post pictures of your stay here, you can book a cabana that has WiFi. But we highly recommend you put your phone away to fully immerse yourself in all the experiences that this resort has to offer.
\r\n\r\nTucked away in the lush rainforest of Costa Rica is Nayara Springs, a luxury hotel that offers a three-day digital detox package. This adult only hotel asks you to hand over your devices but provides you with your own private pool, daily yoga/meditation classes, and massages. The seclusion and beauty of this location is therapeutic, that’s even without the daily classes. Trust us, you won’t be missing technology.
\r\n\r\nIf you want to withdraw from technology but don’t have the willpower to abstain, then the Grand Velas Resort's Mexico Digital Detox is the program for you. A ‘Detox Concierge’ collects your electronics when you check in, gives you a t-shirt that reads “We are digital detoxing”, and a bracelet that allows you free access to hotel activities like biking, snorkeling, and massages. Swapping your cell phone for massages and the Caribbean Sea sounds like a good trade to us.
\r\n\r\nJust a 45-minute ride through the jungle from Porto Seguro will land you in tropical paradise. UXUA is a small beachside resort comprised of 11 casas filled with beautiful local art. You’ll be so enthralled by the lush garden, beautiful white sand beaches, and swimming pools full of healing crystals that you will have forgotten all about your phone.
\r\n\r\nUnwind from the daily grind in the Guatemalan highlands at Casa Palopa. Give your eyes a break from staring at a screen and enjoy the views of Lake Atitlan located directly below the hotel and three volcanos on the skyline. You will be so busy taking cultural tours, exploring Lake Atitlan, and relaxing in the infinity edge pool that you won’t even feel the need to check your devices.
\r\n\r\nRight at the end of the Maui’s famous Road to Hana, the sprawling Travaasa Hana resort is the epitome of laid back luxury. While you won’t find TV’s in the rooms here, you will find a private lanai (a Hawaiian term for an enclosed balcony) with views of the Pacific Ocean that will take your breath away. WiFi is available but be brave and swap it out for everything from fishing, yoga and horseback riding to paddle-boarding, coastal walks and aquarobics. Seniors in the local community are invited to join any hotel activities free of charge, giving travelers the chance to learn all the secret beaches, food trucks and walking trails from the experts.
\r\n\r\nIf you’re looking to get back to nature, Emerald Lake Lodge is the place to go. Tucked away in the middle of Yoho National Park without cell reception, you can fully immerse yourself in hiking, mountain biking, fishing and skiing in the winter. The scenery here will leave you feeling rejuvenated, and you won’t miss your digital life one bit.
\r\n\r\nPerfect for couples or anyone looking to relax in paradise, Bird Island encourages visitors to focus on the beauty of its natural surroundings by eliminating modern day distractions such as TVs and phones. With miles of sandy white beaches and only 24 private beach bungalows, your days will be blissfully filled with snorkeling, birdwatching and pure zen.
\r\n\r\nNestled between two National Parks within the World Heritage-listed Greater Blue Mountains, Wolgan Valley Resort is an ideal escape from reality. Due to the remote location, there is no cell reception, allowing you to fully connect to the nature that surrounds you. With activities like horseback riding, archery, and mountain biking you won’t even have time to look at your phones.
\r\n\r\n\r\n', '15', 1, 1, 'd96d0a0b03252dd69fa1367ab7aae58e.jpg', '2acdeeea013d5b64c8a59f20444c065b.jpg', '1572753600', '1572843600'), (8, 'WHAT YOU NEED TO KNOW ABOUT OREGON SHAKESPEARE FESTIVAL', '
“Can one desire too much of a good thing?” Orlando asks in “As You Like It.” Each year, the Oregon Shakespeare Festival puts Orlando’s query to the test with several months of plays and musicals in Ashland, Oregon. Well, theater enthusiasts like you know there’s no such thing as too much performing arts. This celebration of storytelling has a new lineup every year, with a mix of Shakespeare’s plays and the works of contemporary playwrights. The 2019 season features compelling productions, including the world premiere of “Mother Road” by Octavio Solis and Tony Award-winning “Indecent” by Paula Vogel.
\r\n\r\nKeep reading to learn everything you need to know to get the most out of your OSF experience.
\r\n\r\nThe Oregon Shakespeare Festival fills the city of Ashland with performing arts for more than half the year. The dates and lineup vary each season. March 1 marks the first performance of 2019, the opening night of “As You Like It,” and the final performances of the festival will take the stage on October 27.
\r\n\r\nEach year, the lineup at OSF includes a mix of plays and musicals that will challenge and delight you. Whether you want to see the Bard’s work come to life in new ways or you seek out contemporary offerings from today’s boldest artists, you’ll find it in Ashland.
\r\n\r\n- In 2019, Bill Rauch concludes his 11-year tenure as Artistic Director by directing two productions: “Mother Road” and “La Comedia of Errors.” The latter is a bilingual staging of the Shakespearian classic.
\r\n\r\n- At the same time, Nakita Garrett begins her role as Oregon Shakespeare Festival’s Artistic Director and directs “How to Catch Creation.”
\r\n\r\n- Make sure you see “Cambodian Rock Band” by Lauren Yee, winner of the 2019 Harold and Mimi Steinberg/American Theatre Critics Association New Play Award, among other accolades.
\r\n\r\n- Matinee Discussions follow each midday performance and offer insights into the creative process, as well as a chance to explore the themes of each play.
\r\n\r\n- This season’s hotly anticipated production “Indecent” has been commissioned by OSF’s American Revolutions project and directed by Shana Cooper.
\r\n\r\nOregon Shakespeare Festival tickets are available directly from the OSF tickets website or by calling the box office. You can book season tickets or plan ahead for the new season and reserve preview tickets for an early look at the year’s top productions.
\r\n\r\nFull-price season passes to the Shakespeare festival in Oregon are very affordable, considering the season runs for 8 months and includes several plays. You may also be eligible for the following discounts:
\r\n\r\n- Youth 6-17 Discount (30% off)
\r\n\r\n- Member Discount until March 1 (25% off)
\r\n\r\n- Bricks Member Discount (15% off)
\r\n\r\n- Previews Only Discount (25% off)
\r\n\r\n\r\n\r\n
Ashland’s Oregon Shakespeare Festival enjoys the temperate weather of Southern Oregon. In fact, Shakespeare could have been daydreaming about June in Ashland when he penned, “Shall I compare thee to a summer’s day?” (he probably wasn’t).
\r\n\r\nBecause OSF spans several months, consider the seasons to help you pack for the best experience possible.
\r\n\r\n- Spring: When the events kick off in early spring, expect mild weather with cool temperatures in the 50s and chances of gentle rain.
\r\n\r\n- Summer: As the festival continues through the summer months, pack for sunshine and warm temperatures ranging from 70 to the high 80s.
\r\n\r\n- Fall: Finally, autumn in Ashland is beautiful and one of the best times to visit the region. Expect cool, crisp days with clear skies.
\r\n\r\n\r\n\r\n
While you’re attending Ashland’s Shakespeare festival, take time to savor the local eats. It’s easy to find vegan, vegetarian, and gluten-free menu options in this city. Check out these locally loved hot spots:
\r\n\r\n- Greenleaf Restaurant: Craving comfort food with a twist? Greenleaf serves fusion cuisine with Mediterranean and Pan-Asian influences.
\r\n\r\n- Pangea: Are you in the midst of your “salad days”? We know where you need to eat! Soups, salads, wraps, and more—Pangea serves refreshing, flavorful dishes for vivacious herbivores and omnivores alike.
\r\n\r\n- Oberon's: We can’t think of a more fitting dining experience while you’re at OSF than a rollicking pre-show happy hour at Oberon’s, a rustic British pub with creative cocktails.
\r\n\r\n- Noble Coffee Roasting: In Oregon, coffee is a vegetable (or a bean at least). Start your day with a cup of locally roasted organic coffee.
\r\n\r\nDoes Ashland, Oregon have an airport? The closest major airport to Ashland is Rogue Valley International-Medford Airport in nearby Medford. If you fly in to attend the festival, you’ll arrive just 16 miles northwest of downtown Ashland. Medford Airport receives flights from all over the western United States, so finding fights to Ashland is easy.
\r\n\r\nDriving is a convenient option, especially if you’re traveling in a small group. Ashland is small and the festival welcomes over 400,000 visitors each year, so navigating the city is straightforward, but parking will require some planning (arrive at least 20 minutes before performances begin to find parking).
\r\n\r\n- For handicapped parking spaces and parking for patrons with mobility needs, look for spaces on the lowest level of the parking garage behind Thomas Theatre.
\r\n\r\n- For more detailed parking information, check out this map of downtown public parking options provided by the City of Ashland.
\r\n\r\nBiking and walking are great transportation options for people who want to save money on rental cars. Ashland is very environmentally conscientious, and it’s easy to make eco-friendly transportation choices while you visit.
\r\n\r\n- Downtown Ashland is very walkable and public transportation is available for your airport commute.
\r\n\r\n- Ashland is a great place for cyclists, whether you’re seeking adventure or simply trying to get around town. Park your wheels at the bicycle corrals on Oak Street and Third Street.
\r\n\r\nPublic transportation is plentiful along Main Street, with several bus stops between Wilmer Street to the north and the Southern Oregon University Campus near the south side of Ashland. The bus commute from Medford Airport takes approximately one hour and includes a transfer, but it’s a direct route.
\r\n\r\nAshland hotels do fill up for the Oregon Shakespeare Festival. Fortunately, the events last almost year-round, so there is less of a spike in rates and occupancies.
\r\n\r\nThe main festival venues—Allen Elizabethan Theatre, Angus Bowmer Theatre, and Thomas Theatre— are all located in downtown Ashland directly north of Lithia Park. Thanks to the small-town vibes and nonstop performances all over the city, you can stay practically anywhere and enjoy OSF.
\r\n\r\nBook these top hotels in Ashland:
\r\n\r\n- Ashland Springs Hotel: Located within walking distance of the festival’s theaters, Ashland Springs is a convenient choice. The historical property boasts elegant rooms and a full-service spa. Breakfast is included at no charge.
\r\n\r\n- Plaza Inn & Suites at Ashland Creek: Start your day with a complimentary breakfast, then walk to the festival or relax in the quiet setting north of downtown. Book a room or a suite and feel right at home.
\r\n\r\n- The Bard's Inn: Embrace the William Shakespeare’s life and legacy at The Bard’s Inn. Each room is named after a character, setting, or theme that appears in his plays.
\r\n\r\n- Winchester Inn: This renovated Victorian home will charm you with its intimate boutique hotel amenities and beautiful rooms. Lounge on the terrace and read Will’s sonnets as you look out over Ashland.
\r\n\r\nIf you ask any local, “What is Ashland, Oregon known for?” you’re going to get a few answers, and Oregon Shakespeare Festival is just one of them. The city is a renowned community for artists of all disciplines, award-winning wineries, and unforgettable outdoor adventures. Include these activities on your itinerary when you aren’t celebrating the Bard:
\r\n\r\n- Oregon Cabaret Theatre: This city landmark produced its first show in 1986 and has been filling Southern Oregon with song, dance, and sequins ever since.
\r\n\r\n- Local performances: In addition to the official OSF lineup, local theater artists produce popup performances all over the city.
\r\n\r\n- Lithia Artisans Market: Southern Oregon has a diverse and active community of artists and craftspeople. LAMA is dedicated to developing and selling their work and showcasing the region’s musicians.
\r\n\r\n- Wine tasting: Ashland is surrounded by some of the best vineyards and wineries in Oregon. Take time to enjoy a tasting at nearby favorites, including Dana Campbell Vineyards, EdenVale Winery, and Irvine & Roberts Vineyards.
\r\n\r\n- Schneider Museum of Art: Schneider Museum of Art is affiliated with the Oregon Center for the Arts at Southern Oregon University and features sculptures, mixed media, and other visual arts. It’s a great conversation starter!
\r\n\r\n- Water adventures: For thrills and chills, take a whitewater rafting trip on nearby waterways. You’ll want to carve out a few hours for an exciting half day raft trip on the Rague River.
\r\n\r\nAs Shakespeare once wrote, “All the world’s a stage, and all the men and women merely players.” If that’s the case, play the role of savvy traveler on your next trip to Ashland!
\r\n\r\n\r\n', '4', 1, 1, '57ee20e39fce85f7f828020e136016fd.jpg', 'a0b56ebe01f72b841c0cb5a281dbdeab.jpg', '1572753600', '1572843600'); -- -------------------------------------------------------- -- -- Table structure for table `blog_comments` -- DROP TABLE IF EXISTS `blog_comments`; CREATE TABLE `blog_comments` ( `id` int(11) UNSIGNED NOT NULL, `comment` longtext NOT NULL, `blog_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `under_comment_id` varchar(255) NOT NULL DEFAULT '0', `added_date` varchar(255) NOT NULL, `modified_date` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `blog_comments` -- INSERT INTO `blog_comments` (`id`, `comment`, `blog_id`, `user_id`, `under_comment_id`, `added_date`, `modified_date`) VALUES (1, 'We live and breathe travel, and want to help you discover your next vacation by sharing trip ideas, creative destination inspiration, useful information about booking travel, and savvy advice about world-wandering. So dig in to our travel articles, and find your next destination.', 6, 2, '0', '1572912000', '1572912000'), (2, 'As a staff writer for Expedia, Chloe Mulliner is dedicated to providing top travel tips for your jaunts around the world. She believes there are adventures to be had on every inch of the globe from surf spots on the Peruvian coast to the charming villages of the English countryside. Chloe specializes in showcasing all the must-see attractions on your travel wish list. She lives by the belief that every adventure is a story worth sharing.', 6, 1, '1', '1572912000', ''), (3, 'This tour company is wonderful! This was the first time my husband and I had used a travel agent in many years and now we can’t imagine planning a trip without them. We contacted the travel agent at this tour company after having already planned a portion of our trip on our own.', 2, 2, '0', '1572912000', '1572912000'), (4, 'The best trip and experience thus far. Such an amazing experience the memories and experiences will last a lifetime. This travel company did a great job planning our vacation. We told our trip planner our budget and she stayed within while giving us everything we expected and more. She was a great communicator', 2, 3, '0', '1572912000', ''), (5, 'Our travel designer and the travel team went above and beyond for our trip. The accommodation was always incredible, and all other organisations that were a part of the trip were locally-run and staffed, small and, most often, eco-friendly.', 2, 1, '3', '1572912000', ''), (6, 'The trip planner did a fantastic planning our Turkish journey. We had any emails and phone conversations customizing our complicated trip. When a few minor inconveniences came up locally, he reacted immediately to remediate the situations.', 2, 1, '4', '1572912000', ''), (8, 'The honeymoon of our dreams!!\n\nWe cannot thank this travel company enough for planning the trip of our dreams. Our trip planners were such a pleasure to work with. They were extremely responsive and very engaging as we worked out the details of our trip with them.', 5, 2, '0', '1572912000', ''), (9, 'I started working with the travel designer in April to plan an October honeymoon trip. She was extremely responsive and always answered my hundreds of e-mails with all the changes I asked her to make to the itinerary.', 2, 2, '3', '1572912000', ''), (11, 'We had a really wonderful 9 day trip to Sicily. I had a general idea of what I wanted to see, but needed guidance as to the overall flow of the trip, what we can see (and should) in 9 days and recommendations for hotels etc. The trip planner of this travel team made it all happen and was very easy to work with.', 5, 3, '0', '1572912000', ''), (12, 'Reception and all service staff were very helpful and cordial. Our beachfront room on the third floor had a balcony and a great view of the pool area, the ocean, and sunrise- magnificent. Food in the tavern for dinner and breakfast was good. Especially liked the lowcountry shrimp and grits. They surprised my husband with a slice of chocolate cake with "Happy Birthday" written on the plate when we casually mentioned that it was his birthday!', 3, 3, '0', '1572912000', ''), (13, 'All the good reviews that I have read about this property are true. The friendliness of the staff seems genuine. I have never seen such good customer service as I experienced poolside.', 3, 2, '0', '1572912000', '1572912000'), (14, 'All the good reviews that I have read about this property are true. The friendliness of the staff seems genuine. I have never seen such good customer service as I experienced poolside.', 4, 2, '0', '1572912000', ''), (15, 'Our travel designer and the travel team went above and beyond for our trip. The accommodation was always incredible, and all other organisations that were a part of the trip were locally-run and staffed, small and, most often, eco-friendly.', 2, 1, '0', '1572912000', ''); -- -------------------------------------------------------- -- -- Table structure for table `booking` -- DROP TABLE IF EXISTS `booking`; CREATE TABLE `booking` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `requester_id` int(11) NOT NULL, `listing_id` int(11) NOT NULL, `booking_date` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `additional_information` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `created_at` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `listing_type` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `status` int(11) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `booking` -- INSERT INTO `booking` (`id`, `user_id`, `requester_id`, `listing_id`, `booking_date`, `additional_information`, `created_at`, `listing_type`, `status`) VALUES (1, 1, 2, 33, '1566950400', '{\"time\":1567000800,\"service\":\"16\",\"note\":\"i need a service\"}', '1566950400', 'beauty', 1), (2, 1, 2, 33, '1567555200', '{\"time\":1566996300,\"service\":\"15\",\"note\":\"\"}', '1566950400', 'beauty', 0), (3, 2, 1, 35, '1571184000', '{\"time\":1567004400,\"service\":\"8\",\"note\":\"\"}', '1566950400', 'beauty', 1), (4, 1, 2, 28, '1568851200', '{\"adult_guests\":\"3\",\"child_guests\":\"0\",\"time\":\"dinner\"}', '1566950400', 'restaurant', 0), (5, 1, 2, 12, '1570708327 - 1571140327', '{\"adult_guests\":\"2\",\"child_guests\":\"0\",\"room_type\":\"Deluxe King Size\"}', '1566950400', 'hotel', 1), (6, 1, 2, 6, '1570709176 - 1571141176', '{\"adult_guests\":\"2\",\"child_guests\":\"2\",\"room_type\":\"Standard room\"}', '1566950400', 'hotel', 0), (7, 2, 1, 19, '1572955831 - 1573301431', '{\"adult_guests\":\"4\",\"child_guests\":\"2\",\"room_type\":\"Deluxe Suite\"}', '1566950400', 'hotel', 1), (8, 2, 1, 20, '1571875200', '{\"adult_guests\":\"4\",\"child_guests\":\"3\",\"time\":\"lunch\"}', '1566950400', 'restaurant', 0), (9, 2, 1, 10, '1571184000', '{\"adult_guests\":\"3\",\"child_guests\":\"0\",\"time\":\"dinner\"}', '1566950400', 'restaurant', 0), (10, 1, 1, 6, '1596446000 - 1600247600', '{\"adult_guests\":\"3\",\"child_guests\":\"0\",\"room_type\":\"Executive Room\"}', '1596326400', 'hotel', 0); -- -------------------------------------------------------- -- -- Table structure for table `category` -- DROP TABLE IF EXISTS `category`; CREATE TABLE `category` ( `id` int(11) NOT NULL, `parent` int(11) DEFAULT '0', `icon_class` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `name` longtext COLLATE utf8_unicode_ci, `slug` longtext COLLATE utf8_unicode_ci, `thumbnail` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `category` -- INSERT INTO `category` (`id`, `parent`, `icon_class`, `name`, `slug`, `thumbnail`) VALUES (1, 0, 'fas fa-utensils', 'Restaurant', 'restaurant', 'b7a02ba759334421a68877b77d53cddd.jpg'), (2, 1, 'fas fa-child', 'Family style', 'family-style', NULL), (3, 1, 'fas fa-utensil-spoon', 'Fine dining', 'fine-dining', NULL), (4, 1, 'fas fa-coffee', 'Cafe bistro', 'cafe-bistro', NULL), (5, 1, 'fas fa-birthday-cake', 'Fast food', 'fast-food', NULL), (6, 1, 'fab fa-nutritionix', 'Restaurant buffet', 'restaurant-buffet', NULL), (7, 1, 'fas fa-glass-martini', 'Barbecue', 'barbecue', NULL), (8, 1, 'fas fa-dot-circle', 'Doughnut shops', 'doughnut-shops', NULL), (9, 1, 'fas fa-beer', 'Juice bars', 'juice-bars', NULL), (10, 0, 'fas fa-h-square', 'Hotel', 'hotel', '24ce544a504521b45555ed0ee710656e.jpg'), (11, 10, 'far fa-building', 'Apartment hotel', 'apartment-hotel', NULL), (12, 10, 'fas fa-bed', 'Bed and breakfast', 'bed-and-breakfast', NULL), (13, 10, 'fas fa-chess-king', 'Casino hotel', 'casino-hotel', NULL), (14, 10, 'fas fa-building', 'Condo hotel', 'condo-hotel', NULL), (15, 10, 'fab fa-fort-awesome', 'Guesthouse', 'guesthouse', NULL), (16, 10, 'fas fa-industry', 'Inn', 'inn', NULL), (17, 10, 'fab fa-houzz', 'Motel', 'motel', NULL), (18, 0, 'fas fa-shopping-cart', 'Shopping', 'shopping', '47a13b9539d7e09f160efa7271b901f9.jpg'), (19, 18, 'fab fa-black-tie', 'Fashion', 'fashion', NULL), (20, 18, 'fas fa-mobile-alt', 'Mobile', 'mobile', NULL), (21, 18, 'fas fa-laptop', 'Computer', 'computer', NULL), (22, 18, 'fab fa-empire', 'Jewelry', 'jewelry', NULL), (23, 18, 'fas fa-home', 'Home and garden', 'home-and-garden', NULL), (24, 18, 'fas fa-shopping-bag', 'Bags', 'bags', NULL), (25, 18, 'fas fa-dolly', 'Shoes', 'shoes', NULL), (26, 18, 'fas fa-car', 'Automobile', 'automobile', NULL), (27, 0, 'fas fa-gem', 'Fitness', 'fitness', '11b4f846fa3513cf17d9802fda0041c6.jpg'), (28, 27, 'fab fa-odnoklassniki', 'Acrobatics', 'acrobatics', NULL), (29, 27, 'fab fa-fly', 'Lycra', 'lycra', NULL), (30, 27, 'fab fa-strava', 'Yoga', 'yoga', NULL), (31, 27, 'fas fa-weight', 'Boxing', 'boxing', NULL), (32, 27, 'fab fa-tencent-weibo', 'Hammock', 'hammock', NULL), (33, 27, 'fas fa-bowling-ball', 'Kettlebell', 'kettlebell', NULL), (34, 27, 'fas fa-bicycle', 'Cycling', 'cycling', NULL), (35, 27, 'fab fa-react', 'Pilates', 'pilates', NULL), (37, 0, 'fas fa-cut', 'Beauty', 'beauty', 'b66115b8d735db7d6d2fa0dda5a3280d.jpg'), (38, 37, 'fas fa-cut', 'Hair salon', 'hair-salon', NULL), (39, 37, 'fab fa-modx', 'Hair removal', 'hair-removal', NULL), (40, 37, 'fab fa-ethereum', 'Nail care', 'nail-care', NULL), (41, 37, 'far fa-smile', 'Facial', 'facial', NULL), (42, 37, 'fas fa-paint-brush', 'Makeup', 'makeup', NULL), (43, 37, 'fas fa-eye', 'Eye color', 'eye-color', NULL), (44, 37, 'fab fa-pagelines', 'Med spa', 'med-spa', NULL), (45, 37, 'fab fa-staylinked', 'Tattoo', 'tattoo', NULL); -- -------------------------------------------------------- -- -- Table structure for table `city` -- DROP TABLE IF EXISTS `city`; CREATE TABLE `city` ( `id` int(11) NOT NULL, `name` longtext COLLATE utf8_unicode_ci, `slug` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `country_id` int(11) DEFAULT NULL, `state_id` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `city` -- INSERT INTO `city` (`id`, `name`, `slug`, `country_id`, `state_id`) VALUES (1, 'Paris', 'paris', 73, NULL), (2, 'Lyon', 'lyon', 73, NULL), (3, 'Nice', 'nice', 73, NULL), (4, 'Marseille', 'marseille', 73, NULL), (5, 'Bordeaux', 'bordeaux', 73, NULL), (6, 'Toulouse', 'toulouse', 73, NULL), (7, 'Strasbourg', 'strasbourg', 73, NULL), (8, 'Dijon', 'dijon', 73, NULL), (9, 'Nantes', 'nantes', 73, NULL), (10, 'Lille', 'lille', 73, NULL); -- -------------------------------------------------------- -- -- Table structure for table `claimed_listing` -- DROP TABLE IF EXISTS `claimed_listing`; CREATE TABLE `claimed_listing` ( `id` int(11) NOT NULL, `listing_id` int(11) DEFAULT NULL, `user_id` int(11) DEFAULT NULL, `full_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `additional_information` longtext COLLATE utf8_unicode_ci NOT NULL, `status` int(11) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `claimed_listing` -- INSERT INTO `claimed_listing` (`id`, `listing_id`, `user_id`, `full_name`, `phone`, `additional_information`, `status`) VALUES (1, 4, 2, 'Jane Doe', '+33 3333443443', 'This is my real proof.', 0), (2, 10, 2, 'Jane Doe', '+1 (336) 676-3025', 'This is my real proof.', 1), (3, 31, 2, 'Jane Doe', '+1 (283) 282-1469687', 'This is my real proof.', 1), (4, 20, 2, 'Jane Doe', '+33 3333443443', 'This is my real proof.', 1), (5, 19, 2, 'Jane Doe', '+1 (336) 676-3025', 'This is my real proof.', 0); -- -------------------------------------------------------- -- -- Table structure for table `comment` -- DROP TABLE IF EXISTS `comment`; CREATE TABLE `comment` ( `id` int(11) NOT NULL, `user_id` int(11) DEFAULT NULL, `listing_id` int(11) DEFAULT NULL, `reply_to` int(11) DEFAULT NULL, `comment` longtext COLLATE utf8_unicode_ci ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `country` -- DROP TABLE IF EXISTS `country`; CREATE TABLE `country` ( `id` int(5) NOT NULL, `name` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL, `code` varchar(2) COLLATE utf8_unicode_ci DEFAULT NULL, `dial_code` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL, `currency_name` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL, `currency_symbol` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL, `currency_code` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `country` -- INSERT INTO `country` (`id`, `name`, `code`, `dial_code`, `currency_name`, `currency_symbol`, `currency_code`) VALUES (1, 'Afghanistan', 'AF', '+93', 'Afghan afghani', '؋', 'AFN'), (2, 'Aland Islands', 'AX', '+358', '', '', ''), (3, 'Albania', 'AL', '+355', 'Albanian lek', 'L', 'ALL'), (4, 'Algeria', 'DZ', '+213', 'Algerian dinar', 'د.ج', 'DZD'), (5, 'AmericanSamoa', 'AS', '+1684', '', '', ''), (6, 'Andorra', 'AD', '+376', 'Euro', '€', 'EUR'), (7, 'Angola', 'AO', '+244', 'Angolan kwanza', 'Kz', 'AOA'), (8, 'Anguilla', 'AI', '+1264', 'East Caribbean dolla', '$', 'XCD'), (9, 'Antarctica', 'AQ', '+672', '', '', ''), (10, 'Antigua and Barbuda', 'AG', '+1268', 'East Caribbean dolla', '$', 'XCD'), (11, 'Argentina', 'AR', '+54', 'Argentine peso', '$', 'ARS'), (12, 'Armenia', 'AM', '+374', 'Armenian dram', '', 'AMD'), (13, 'Aruba', 'AW', '+297', 'Aruban florin', 'ƒ', 'AWG'), (14, 'Australia', 'AU', '+61', 'Australian dollar', '$', 'AUD'), (15, 'Austria', 'AT', '+43', 'Euro', '€', 'EUR'), (16, 'Azerbaijan', 'AZ', '+994', 'Azerbaijani manat', '', 'AZN'), (17, 'Bahamas', 'BS', '+1242', '', '', ''), (18, 'Bahrain', 'BH', '+973', 'Bahraini dinar', '.د.ب', 'BHD'), (19, 'Bangladesh', 'BD', '+880', 'Bangladeshi taka', '৳', 'BDT'), (20, 'Barbados', 'BB', '+1246', 'Barbadian dollar', '$', 'BBD'), (21, 'Belarus', 'BY', '+375', 'Belarusian ruble', 'Br', 'BYR'), (22, 'Belgium', 'BE', '+32', 'Euro', '€', 'EUR'), (23, 'Belize', 'BZ', '+501', 'Belize dollar', '$', 'BZD'), (24, 'Benin', 'BJ', '+229', 'West African CFA fra', 'Fr', 'XOF'), (25, 'Bermuda', 'BM', '+1441', 'Bermudian dollar', '$', 'BMD'), (26, 'Bhutan', 'BT', '+975', 'Bhutanese ngultrum', 'Nu.', 'BTN'), (27, 'Bolivia, Plurination', 'BO', '+591', '', '', ''), (28, 'Bosnia and Herzegovi', 'BA', '+387', '', '', ''), (29, 'Botswana', 'BW', '+267', 'Botswana pula', 'P', 'BWP'), (30, 'Brazil', 'BR', '+55', 'Brazilian real', 'R$', 'BRL'), (31, 'British Indian Ocean', 'IO', '+246', '', '', ''), (32, 'Brunei Darussalam', 'BN', '+673', '', '', ''), (33, 'Bulgaria', 'BG', '+359', 'Bulgarian lev', 'лв', 'BGN'), (34, 'Burkina Faso', 'BF', '+226', 'West African CFA fra', 'Fr', 'XOF'), (35, 'Burundi', 'BI', '+257', 'Burundian franc', 'Fr', 'BIF'), (36, 'Cambodia', 'KH', '+855', 'Cambodian riel', '៛', 'KHR'), (37, 'Cameroon', 'CM', '+237', 'Central African CFA ', 'Fr', 'XAF'), (38, 'Canada', 'CA', '+1', 'Canadian dollar', '$', 'CAD'), (39, 'Cape Verde', 'CV', '+238', 'Cape Verdean escudo', 'Esc or $', 'CVE'), (40, 'Cayman Islands', 'KY', '+ 345', 'Cayman Islands dolla', '$', 'KYD'), (41, 'Central African Repu', 'CF', '+236', '', '', ''), (42, 'Chad', 'TD', '+235', 'Central African CFA ', 'Fr', 'XAF'), (43, 'Chile', 'CL', '+56', 'Chilean peso', '$', 'CLP'), (44, 'China', 'CN', '+86', 'Chinese yuan', '¥ or 元', 'CNY'), (45, 'Christmas Island', 'CX', '+61', '', '', ''), (46, 'Cocos (Keeling) Isla', 'CC', '+61', '', '', ''), (47, 'Colombia', 'CO', '+57', 'Colombian peso', '$', 'COP'), (48, 'Comoros', 'KM', '+269', 'Comorian franc', 'Fr', 'KMF'), (49, 'Congo', 'CG', '+242', '', '', ''), (50, 'Congo, The Democrati', 'CD', '+243', '', '', ''), (51, 'Cook Islands', 'CK', '+682', 'New Zealand dollar', '$', 'NZD'), (52, 'Costa Rica', 'CR', '+506', 'Costa Rican colón', '₡', 'CRC'), (53, 'Cote d\'Ivoire', 'CI', '+225', 'West African CFA fra', 'Fr', 'XOF'), (54, 'Croatia', 'HR', '+385', 'Croatian kuna', 'kn', 'HRK'), (55, 'Cuba', 'CU', '+53', 'Cuban convertible pe', '$', 'CUC'), (56, 'Cyprus', 'CY', '+357', 'Euro', '€', 'EUR'), (57, 'Czech Republic', 'CZ', '+420', 'Czech koruna', 'Kč', 'CZK'), (58, 'Denmark', 'DK', '+45', 'Danish krone', 'kr', 'DKK'), (59, 'Djibouti', 'DJ', '+253', 'Djiboutian franc', 'Fr', 'DJF'), (60, 'Dominica', 'DM', '+1767', 'East Caribbean dolla', '$', 'XCD'), (61, 'Dominican Republic', 'DO', '+1849', 'Dominican peso', '$', 'DOP'), (62, 'Ecuador', 'EC', '+593', 'United States dollar', '$', 'USD'), (63, 'Egypt', 'EG', '+20', 'Egyptian pound', '£ or ج.م', 'EGP'), (64, 'El Salvador', 'SV', '+503', 'United States dollar', '$', 'USD'), (65, 'Equatorial Guinea', 'GQ', '+240', 'Central African CFA ', 'Fr', 'XAF'), (66, 'Eritrea', 'ER', '+291', 'Eritrean nakfa', 'Nfk', 'ERN'), (67, 'Estonia', 'EE', '+372', 'Euro', '€', 'EUR'), (68, 'Ethiopia', 'ET', '+251', 'Ethiopian birr', 'Br', 'ETB'), (69, 'Falkland Islands (Ma', 'FK', '+500', '', '', ''), (70, 'Faroe Islands', 'FO', '+298', 'Danish krone', 'kr', 'DKK'), (71, 'Fiji', 'FJ', '+679', 'Fijian dollar', '$', 'FJD'), (72, 'Finland', 'FI', '+358', 'Euro', '€', 'EUR'), (73, 'France', 'FR', '+33', 'Euro', '€', 'EUR'), (74, 'French Guiana', 'GF', '+594', '', '', ''), (75, 'French Polynesia', 'PF', '+689', 'CFP franc', 'Fr', 'XPF'), (76, 'Gabon', 'GA', '+241', 'Central African CFA ', 'Fr', 'XAF'), (77, 'Gambia', 'GM', '+220', '', '', ''), (78, 'Georgia', 'GE', '+995', 'Georgian lari', 'ლ', 'GEL'), (79, 'Germany', 'DE', '+49', 'Euro', '€', 'EUR'), (80, 'Ghana', 'GH', '+233', 'Ghana cedi', '₵', 'GHS'), (81, 'Gibraltar', 'GI', '+350', 'Gibraltar pound', '£', 'GIP'), (82, 'Greece', 'GR', '+30', 'Euro', '€', 'EUR'), (83, 'Greenland', 'GL', '+299', '', '', ''), (84, 'Grenada', 'GD', '+1473', 'East Caribbean dolla', '$', 'XCD'), (85, 'Guadeloupe', 'GP', '+590', '', '', ''), (86, 'Guam', 'GU', '+1671', '', '', ''), (87, 'Guatemala', 'GT', '+502', 'Guatemalan quetzal', 'Q', 'GTQ'), (88, 'Guernsey', 'GG', '+44', 'British pound', '£', 'GBP'), (89, 'Guinea', 'GN', '+224', 'Guinean franc', 'Fr', 'GNF'), (90, 'Guinea-Bissau', 'GW', '+245', 'West African CFA fra', 'Fr', 'XOF'), (91, 'Guyana', 'GY', '+595', 'Guyanese dollar', '$', 'GYD'), (92, 'Haiti', 'HT', '+509', 'Haitian gourde', 'G', 'HTG'), (93, 'Holy See (Vatican Ci', 'VA', '+379', '', '', ''), (94, 'Honduras', 'HN', '+504', 'Honduran lempira', 'L', 'HNL'), (95, 'Hong Kong', 'HK', '+852', 'Hong Kong dollar', '$', 'HKD'), (96, 'Hungary', 'HU', '+36', 'Hungarian forint', 'Ft', 'HUF'), (97, 'Iceland', 'IS', '+354', 'Icelandic króna', 'kr', 'ISK'), (98, 'India', 'IN', '+91', 'Indian rupee', '₹', 'INR'), (99, 'Indonesia', 'ID', '+62', 'Indonesian rupiah', 'Rp', 'IDR'), (100, 'Iran, Islamic Republ', 'IR', '+98', '', '', ''), (101, 'Iraq', 'IQ', '+964', 'Iraqi dinar', 'ع.د', 'IQD'), (102, 'Ireland', 'IE', '+353', 'Euro', '€', 'EUR'), (103, 'Isle of Man', 'IM', '+44', 'British pound', '£', 'GBP'), (104, 'Israel', 'IL', '+972', 'Israeli new shekel', '₪', 'ILS'), (105, 'Italy', 'IT', '+39', 'Euro', '€', 'EUR'), (106, 'Jamaica', 'JM', '+1876', 'Jamaican dollar', '$', 'JMD'), (107, 'Japan', 'JP', '+81', 'Japanese yen', '¥', 'JPY'), (108, 'Jersey', 'JE', '+44', 'British pound', '£', 'GBP'), (109, 'Jordan', 'JO', '+962', 'Jordanian dinar', 'د.ا', 'JOD'), (110, 'Kazakhstan', 'KZ', '+7 7', 'Kazakhstani tenge', '', 'KZT'), (111, 'Kenya', 'KE', '+254', 'Kenyan shilling', 'Sh', 'KES'), (112, 'Kiribati', 'KI', '+686', 'Australian dollar', '$', 'AUD'), (113, 'Korea, Democratic Pe', 'KP', '+850', '', '', ''), (114, 'Korea, Republic of S', 'KR', '+82', '', '', ''), (115, 'Kuwait', 'KW', '+965', 'Kuwaiti dinar', 'د.ك', 'KWD'), (116, 'Kyrgyzstan', 'KG', '+996', 'Kyrgyzstani som', 'лв', 'KGS'), (117, 'Laos', 'LA', '+856', 'Lao kip', '₭', 'LAK'), (118, 'Latvia', 'LV', '+371', 'Euro', '€', 'EUR'), (119, 'Lebanon', 'LB', '+961', 'Lebanese pound', 'ل.ل', 'LBP'), (120, 'Lesotho', 'LS', '+266', 'Lesotho loti', 'L', 'LSL'), (121, 'Liberia', 'LR', '+231', 'Liberian dollar', '$', 'LRD'), (122, 'Libyan Arab Jamahiri', 'LY', '+218', '', '', ''), (123, 'Liechtenstein', 'LI', '+423', 'Swiss franc', 'Fr', 'CHF'), (124, 'Lithuania', 'LT', '+370', 'Euro', '€', 'EUR'), (125, 'Luxembourg', 'LU', '+352', 'Euro', '€', 'EUR'), (126, 'Macao', 'MO', '+853', '', '', ''), (127, 'Macedonia', 'MK', '+389', '', '', ''), (128, 'Madagascar', 'MG', '+261', 'Malagasy ariary', 'Ar', 'MGA'), (129, 'Malawi', 'MW', '+265', 'Malawian kwacha', 'MK', 'MWK'), (130, 'Malaysia', 'MY', '+60', 'Malaysian ringgit', 'RM', 'MYR'), (131, 'Maldives', 'MV', '+960', 'Maldivian rufiyaa', '.ރ', 'MVR'), (132, 'Mali', 'ML', '+223', 'West African CFA fra', 'Fr', 'XOF'), (133, 'Malta', 'MT', '+356', 'Euro', '€', 'EUR'), (134, 'Marshall Islands', 'MH', '+692', 'United States dollar', '$', 'USD'), (135, 'Martinique', 'MQ', '+596', '', '', ''), (136, 'Mauritania', 'MR', '+222', 'Mauritanian ouguiya', 'UM', 'MRO'), (137, 'Mauritius', 'MU', '+230', 'Mauritian rupee', '₨', 'MUR'), (138, 'Mayotte', 'YT', '+262', '', '', ''), (139, 'Mexico', 'MX', '+52', 'Mexican peso', '$', 'MXN'), (140, 'Micronesia, Federate', 'FM', '+691', '', '', ''), (141, 'Moldova', 'MD', '+373', 'Moldovan leu', 'L', 'MDL'), (142, 'Monaco', 'MC', '+377', 'Euro', '€', 'EUR'), (143, 'Mongolia', 'MN', '+976', 'Mongolian tögrög', '₮', 'MNT'), (144, 'Montenegro', 'ME', '+382', 'Euro', '€', 'EUR'), (145, 'Montserrat', 'MS', '+1664', 'East Caribbean dolla', '$', 'XCD'), (146, 'Morocco', 'MA', '+212', 'Moroccan dirham', 'د.م.', 'MAD'), (147, 'Mozambique', 'MZ', '+258', 'Mozambican metical', 'MT', 'MZN'), (148, 'Myanmar', 'MM', '+95', 'Burmese kyat', 'Ks', 'MMK'), (149, 'Namibia', 'NA', '+264', 'Namibian dollar', '$', 'NAD'), (150, 'Nauru', 'NR', '+674', 'Australian dollar', '$', 'AUD'), (151, 'Nepal', 'NP', '+977', 'Nepalese rupee', '₨', 'NPR'), (152, 'Netherlands', 'NL', '+31', 'Euro', '€', 'EUR'), (153, 'Netherlands Antilles', 'AN', '+599', '', '', ''), (154, 'New Caledonia', 'NC', '+687', 'CFP franc', 'Fr', 'XPF'), (155, 'New Zealand', 'NZ', '+64', 'New Zealand dollar', '$', 'NZD'), (156, 'Nicaragua', 'NI', '+505', 'Nicaraguan córdoba', 'C$', 'NIO'), (157, 'Niger', 'NE', '+227', 'West African CFA fra', 'Fr', 'XOF'), (158, 'Nigeria', 'NG', '+234', 'Nigerian naira', '₦', 'NGN'), (159, 'Niue', 'NU', '+683', 'New Zealand dollar', '$', 'NZD'), (160, 'Norfolk Island', 'NF', '+672', '', '', ''), (161, 'Northern Mariana Isl', 'MP', '+1670', '', '', ''), (162, 'Norway', 'NO', '+47', 'Norwegian krone', 'kr', 'NOK'), (163, 'Oman', 'OM', '+968', 'Omani rial', 'ر.ع.', 'OMR'), (164, 'Pakistan', 'PK', '+92', 'Pakistani rupee', '₨', 'PKR'), (165, 'Palau', 'PW', '+680', 'Palauan dollar', '$', ''), (166, 'Palestinian Territor', 'PS', '+970', '', '', ''), (167, 'Panama', 'PA', '+507', 'Panamanian balboa', 'B/.', 'PAB'), (168, 'Papua New Guinea', 'PG', '+675', 'Papua New Guinean ki', 'K', 'PGK'), (169, 'Paraguay', 'PY', '+595', 'Paraguayan guaraní', '₲', 'PYG'), (170, 'Peru', 'PE', '+51', 'Peruvian nuevo sol', 'S/.', 'PEN'), (171, 'Philippines', 'PH', '+63', 'Philippine peso', '₱', 'PHP'), (172, 'Pitcairn', 'PN', '+872', '', '', ''), (173, 'Poland', 'PL', '+48', 'Polish z?oty', 'zł', 'PLN'), (174, 'Portugal', 'PT', '+351', 'Euro', '€', 'EUR'), (175, 'Puerto Rico', 'PR', '+1939', '', '', ''), (176, 'Qatar', 'QA', '+974', 'Qatari riyal', 'ر.ق', 'QAR'), (177, 'Romania', 'RO', '+40', 'Romanian leu', 'lei', 'RON'), (178, 'Russia', 'RU', '+7', 'Russian ruble', '', 'RUB'), (179, 'Rwanda', 'RW', '+250', 'Rwandan franc', 'Fr', 'RWF'), (180, 'Reunion', 'RE', '+262', '', '', ''), (181, 'Saint Barthelemy', 'BL', '+590', '', '', ''), (182, 'Saint Helena, Ascens', 'SH', '+290', '', '', ''), (183, 'Saint Kitts and Nevi', 'KN', '+1869', '', '', ''), (184, 'Saint Lucia', 'LC', '+1758', 'East Caribbean dolla', '$', 'XCD'), (185, 'Saint Martin', 'MF', '+590', '', '', ''), (186, 'Saint Pierre and Miq', 'PM', '+508', '', '', ''), (187, 'Saint Vincent and th', 'VC', '+1784', '', '', ''), (188, 'Samoa', 'WS', '+685', 'Samoan t?l?', 'T', 'WST'), (189, 'San Marino', 'SM', '+378', 'Euro', '€', 'EUR'), (190, 'Sao Tome and Princip', 'ST', '+239', '', '', ''), (191, 'Saudi Arabia', 'SA', '+966', 'Saudi riyal', 'ر.س', 'SAR'), (192, 'Senegal', 'SN', '+221', 'West African CFA fra', 'Fr', 'XOF'), (193, 'Serbia', 'RS', '+381', 'Serbian dinar', 'дин. or din.', 'RSD'), (194, 'Seychelles', 'SC', '+248', 'Seychellois rupee', '₨', 'SCR'), (195, 'Sierra Leone', 'SL', '+232', 'Sierra Leonean leone', 'Le', 'SLL'), (196, 'Singapore', 'SG', '+65', 'Brunei dollar', '$', 'BND'), (197, 'Slovakia', 'SK', '+421', 'Euro', '€', 'EUR'), (198, 'Slovenia', 'SI', '+386', 'Euro', '€', 'EUR'), (199, 'Solomon Islands', 'SB', '+677', 'Solomon Islands doll', '$', 'SBD'), (200, 'Somalia', 'SO', '+252', 'Somali shilling', 'Sh', 'SOS'), (201, 'South Africa', 'ZA', '+27', 'South African rand', 'R', 'ZAR'), (202, 'South Georgia and th', 'GS', '+500', '', '', ''), (203, 'Spain', 'ES', '+34', 'Euro', '€', 'EUR'), (204, 'Sri Lanka', 'LK', '+94', 'Sri Lankan rupee', 'Rs or රු', 'LKR'), (205, 'Sudan', 'SD', '+249', 'Sudanese pound', 'ج.س.', 'SDG'), (206, 'Suriname', 'SR', '+597', 'Surinamese dollar', '$', 'SRD'), (207, 'Svalbard and Jan May', 'SJ', '+47', '', '', ''), (208, 'Swaziland', 'SZ', '+268', 'Swazi lilangeni', 'L', 'SZL'), (209, 'Sweden', 'SE', '+46', 'Swedish krona', 'kr', 'SEK'), (210, 'Switzerland', 'CH', '+41', 'Swiss franc', 'Fr', 'CHF'), (211, 'Syrian Arab Republic', 'SY', '+963', '', '', ''), (212, 'Taiwan', 'TW', '+886', 'New Taiwan dollar', '$', 'TWD'), (213, 'Tajikistan', 'TJ', '+992', 'Tajikistani somoni', 'ЅМ', 'TJS'), (214, 'Tanzania, United Rep', 'TZ', '+255', '', '', ''), (215, 'Thailand', 'TH', '+66', 'Thai baht', '฿', 'THB'), (216, 'Timor-Leste', 'TL', '+670', '', '', ''), (217, 'Togo', 'TG', '+228', 'West African CFA fra', 'Fr', 'XOF'), (218, 'Tokelau', 'TK', '+690', '', '', ''), (219, 'Tonga', 'TO', '+676', 'Tongan pa?anga', 'T$', 'TOP'), (220, 'Trinidad and Tobago', 'TT', '+1868', 'Trinidad and Tobago ', '$', 'TTD'), (221, 'Tunisia', 'TN', '+216', 'Tunisian dinar', 'د.ت', 'TND'), (222, 'Turkey', 'TR', '+90', 'Turkish lira', '', 'TRY'), (223, 'Turkmenistan', 'TM', '+993', 'Turkmenistan manat', 'm', 'TMT'), (224, 'Turks and Caicos Isl', 'TC', '+1649', '', '', ''), (225, 'Tuvalu', 'TV', '+688', 'Australian dollar', '$', 'AUD'), (226, 'Uganda', 'UG', '+256', 'Ugandan shilling', 'Sh', 'UGX'), (227, 'Ukraine', 'UA', '+380', 'Ukrainian hryvnia', '₴', 'UAH'), (228, 'United Arab Emirates', 'AE', '+971', 'United Arab Emirates', 'د.إ', 'AED'), (229, 'United Kingdom', 'GB', '+44', 'British pound', '£', 'GBP'), (230, 'United States', 'US', '+1', 'United States dollar', '$', 'USD'), (231, 'Uruguay', 'UY', '+598', 'Uruguayan peso', '$', 'UYU'), (232, 'Uzbekistan', 'UZ', '+998', 'Uzbekistani som', '', 'UZS'), (233, 'Vanuatu', 'VU', '+678', 'Vanuatu vatu', 'Vt', 'VUV'), (234, 'Venezuela, Bolivaria', 'VE', '+58', '', '', ''), (235, 'Vietnam', 'VN', '+84', 'Vietnamese ??ng', '₫', 'VND'), (236, 'Virgin Islands, Brit', 'VG', '+1284', '', '', ''), (237, 'Virgin Islands, U.S.', 'VI', '+1340', '', '', ''), (238, 'Wallis and Futuna', 'WF', '+681', 'CFP franc', 'Fr', 'XPF'), (239, 'Yemen', 'YE', '+967', 'Yemeni rial', '﷼', 'YER'), (240, 'Zambia', 'ZM', '+260', 'Zambian kwacha', 'ZK', 'ZMW'), (241, 'Zimbabwe', 'ZW', '+263', 'Botswana pula', 'P', 'BWP'); -- -------------------------------------------------------- -- -- Table structure for table `currency` -- DROP TABLE IF EXISTS `currency`; CREATE TABLE `currency` ( `id` int(11) NOT NULL, `name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `code` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `symbol` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `paypal_supported` int(11) NOT NULL DEFAULT '0', `stripe_supported` int(11) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `currency` -- INSERT INTO `currency` (`id`, `name`, `code`, `symbol`, `paypal_supported`, `stripe_supported`) VALUES (1, 'Leke', 'ALL', 'Lek', 0, 1), (2, 'Dollars', 'USD', '$', 1, 1), (3, 'Afghanis', 'AFN', '؋', 0, 1), (4, 'Pesos', 'ARS', '$', 0, 1), (5, 'Guilders', 'AWG', 'ƒ', 0, 1), (6, 'Dollars', 'AUD', '$', 1, 1), (7, 'New Manats', 'AZN', 'ман', 0, 1), (8, 'Dollars', 'BSD', '$', 0, 1), (9, 'Dollars', 'BBD', '$', 0, 1), (10, 'Rubles', 'BYR', 'p.', 0, 0), (11, 'Euro', 'EUR', '€', 1, 1), (12, 'Dollars', 'BZD', 'BZ$', 0, 1), (13, 'Dollars', 'BMD', '$', 0, 1), (14, 'Bolivianos', 'BOB', '$b', 0, 1), (15, 'Convertible Marka', 'BAM', 'KM', 0, 1), (16, 'Pula', 'BWP', 'P', 0, 1), (17, 'Leva', 'BGN', 'лв', 0, 1), (18, 'Reais', 'BRL', 'R$', 1, 1), (19, 'Pounds', 'GBP', '£', 1, 1), (20, 'Dollars', 'BND', '$', 0, 1), (21, 'Riels', 'KHR', '៛', 0, 1), (22, 'Dollars', 'CAD', '$', 1, 1), (23, 'Dollars', 'KYD', '$', 0, 1), (24, 'Pesos', 'CLP', '$', 0, 1), (25, 'Yuan Renminbi', 'CNY', '¥', 0, 1), (26, 'Pesos', 'COP', '$', 0, 1), (27, 'Colón', 'CRC', '₡', 0, 1), (28, 'Kuna', 'HRK', 'kn', 0, 1), (29, 'Pesos', 'CUP', '₱', 0, 0), (30, 'Koruny', 'CZK', 'Kč', 1, 1), (31, 'Kroner', 'DKK', 'kr', 1, 1), (32, 'Pesos', 'DOP ', 'RD$', 0, 1), (33, 'Dollars', 'XCD', '$', 0, 1), (34, 'Pounds', 'EGP', '£', 0, 1), (35, 'Colones', 'SVC', '$', 0, 0), (36, 'Pounds', 'FKP', '£', 0, 1), (37, 'Dollars', 'FJD', '$', 0, 1), (38, 'Cedis', 'GHC', '¢', 0, 0), (39, 'Pounds', 'GIP', '£', 0, 1), (40, 'Quetzales', 'GTQ', 'Q', 0, 1), (41, 'Pounds', 'GGP', '£', 0, 0), (42, 'Dollars', 'GYD', '$', 0, 1), (43, 'Lempiras', 'HNL', 'L', 0, 1), (44, 'Dollars', 'HKD', '$', 1, 1), (45, 'Forint', 'HUF', 'Ft', 1, 1), (46, 'Kronur', 'ISK', 'kr', 0, 1), (47, 'Rupees', 'INR', 'Rp', 1, 1), (48, 'Rupiahs', 'IDR', 'Rp', 0, 1), (49, 'Rials', 'IRR', '﷼', 0, 0), (50, 'Pounds', 'IMP', '£', 0, 0), (51, 'New Shekels', 'ILS', '₪', 1, 1), (52, 'Dollars', 'JMD', 'J$', 0, 1), (53, 'Yen', 'JPY', '¥', 1, 1), (54, 'Pounds', 'JEP', '£', 0, 0), (55, 'Tenge', 'KZT', 'лв', 0, 1), (56, 'Won', 'KPW', '₩', 0, 0), (57, 'Won', 'KRW', '₩', 0, 1), (58, 'Soms', 'KGS', 'лв', 0, 1), (59, 'Kips', 'LAK', '₭', 0, 1), (60, 'Lati', 'LVL', 'Ls', 0, 0), (61, 'Pounds', 'LBP', '£', 0, 1), (62, 'Dollars', 'LRD', '$', 0, 1), (63, 'Switzerland Francs', 'CHF', 'CHF', 1, 1), (64, 'Litai', 'LTL', 'Lt', 0, 0), (65, 'Denars', 'MKD', 'ден', 0, 1), (66, 'Ringgits', 'MYR', 'RM', 1, 1), (67, 'Rupees', 'MUR', '₨', 0, 1), (68, 'Pesos', 'MXN', '$', 1, 1), (69, 'Tugriks', 'MNT', '₮', 0, 1), (70, 'Meticais', 'MZN', 'MT', 0, 1), (71, 'Dollars', 'NAD', '$', 0, 1), (72, 'Rupees', 'NPR', '₨', 0, 1), (73, 'Guilders', 'ANG', 'ƒ', 0, 1), (74, 'Dollars', 'NZD', '$', 1, 1), (75, 'Cordobas', 'NIO', 'C$', 0, 1), (76, 'Nairas', 'NGN', '₦', 0, 1), (77, 'Krone', 'NOK', 'kr', 1, 1), (78, 'Rials', 'OMR', '﷼', 0, 0), (79, 'Rupees', 'PKR', '₨', 0, 1), (80, 'Balboa', 'PAB', 'B/.', 0, 1), (81, 'Guarani', 'PYG', 'Gs', 0, 1), (82, 'Nuevos Soles', 'PEN', 'S/.', 0, 1), (83, 'Pesos', 'PHP', 'Php', 1, 1), (84, 'Zlotych', 'PLN', 'zł', 1, 1), (85, 'Rials', 'QAR', '﷼', 0, 1), (86, 'New Lei', 'RON', 'lei', 0, 1), (87, 'Rubles', 'RUB', 'руб', 0, 1), (88, 'Pounds', 'SHP', '£', 0, 1), (89, 'Riyals', 'SAR', '﷼', 0, 1), (90, 'Dinars', 'RSD', 'Дин.', 0, 1), (91, 'Rupees', 'SCR', '₨', 0, 1), (92, 'Dollars', 'SGD', '$', 1, 1), (93, 'Dollars', 'SBD', '$', 0, 1), (94, 'Shillings', 'SOS', 'S', 0, 1), (95, 'Rand', 'ZAR', 'R', 0, 1), (96, 'Rupees', 'LKR', '₨', 0, 1), (97, 'Kronor', 'SEK', 'kr', 1, 1), (98, 'Dollars', 'SRD', '$', 0, 1), (99, 'Pounds', 'SYP', '£', 0, 0), (100, 'New Dollars', 'TWD', 'NT$', 1, 1), (101, 'Baht', 'THB', '฿', 1, 1), (102, 'Dollars', 'TTD', 'TT$', 0, 1), (103, 'Lira', 'TRY', 'TL', 0, 1), (104, 'Liras', 'TRL', '£', 0, 0), (105, 'Dollars', 'TVD', '$', 0, 0), (106, 'Hryvnia', 'UAH', '₴', 0, 1), (107, 'Pesos', 'UYU', '$U', 0, 1), (108, 'Sums', 'UZS', 'лв', 0, 1), (109, 'Bolivares Fuertes', 'VEF', 'Bs', 0, 0), (110, 'Dong', 'VND', '₫', 0, 1), (111, 'Rials', 'YER', '﷼', 0, 1), (112, 'Zimbabwe Dollars', 'ZWD', 'Z$', 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `facebook_messenger` -- DROP TABLE IF EXISTS `facebook_messenger`; CREATE TABLE `facebook_messenger` ( `id` int(11) UNSIGNED NOT NULL, `listing_id` int(11) DEFAULT NULL, `page_id` varchar(255) DEFAULT NULL, `color` varchar(20) DEFAULT NULL, `logged_in_greeting` longtext ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `facebook_messenger` -- INSERT INTO `facebook_messenger` (`id`, `listing_id`, `page_id`, `color`, `logged_in_greeting`) VALUES (1, 1, '110300907170562', '#004dda', 'Hi! How can we help you?'), (2, 2, '110300907170562', '#32e9e5', 'Hi! How can we help you?'), (3, 3, '110300907170562', '#ed9354', 'Hi! How can we help you?'), (4, 4, '110300907170562', '#02e7aa', 'Hi! How can we help you?'), (5, 5, '110300907170562', '#02e7aa', 'Hi! How can we help you?'), (6, 6, '110300907170562', '#004dda', 'Hi! How can we help you?'), (7, 7, '110300907170562', '#32e9e5', 'Hi! How can we help you?'), (8, 8, '110300907170562', '#ed9354', 'Hi! How can we help you?'), (9, 9, '110300907170562', '#02e7aa', 'Hi! How can we help you?'), (10, 10, '110300907170562', '#02e7aa', 'Hi! How can we help you?'), (11, 11, '110300907170562', '#004dda', 'Hi! How can we help you?'), (12, 12, '110300907170562', '#32e9e5', 'Hi! How can we help you?'), (13, 13, '110300907170562', '#ed9354', 'Hi! How can we help you?'), (14, 14, '110300907170562', '#02e7aa', 'Hi! How can we help you?'), (15, 15, '110300907170562', '#02e7aa', 'Hi! How can we help you?'), (16, 16, '110300907170562', '#004dda', 'Hi! How can we help you?'), (17, 17, '110300907170562', '#32e9e5', 'Hi! How can we help you?'), (18, 18, '110300907170562', '#ed9354', 'Hi! How can we help you?'), (19, 19, '110300907170562', '#02e7aa', 'Hi! How can we help you?'), (20, 20, '110300907170562', '#02e7aa', 'Hi! How can we help you?'), (21, 21, '110300907170562', '#004dda', 'Hi! How can we help you?'), (22, 22, '110300907170562', '#32e9e5', 'Hi! How can we help you?'), (23, 23, '110300907170562', '#ed9354', 'Hi! How can we help you?'), (24, 24, '110300907170562', '#02e7aa', 'Hi! How can we help you?'), (25, 25, '110300907170562', '#02e7aa', 'Hi! How can we help you?'), (26, 26, '110300907170562', '#004dda', 'Hi! How can we help you?'), (27, 27, '110300907170562', '#32e9e5', 'Hi! How can we help you?'), (28, 28, '110300907170562', '#ed9354', 'Hi! How can we help you?'), (29, 29, '110300907170562', '#02e7aa', 'Hi! How can we help you?'), (30, 30, '110300907170562', '#02e7aa', 'Hi! How can we help you?'), (31, 31, '110300907170562', '#004dda', 'Hi! How can we help you?'), (32, 32, '110300907170562', '#32e9e5', 'Hi! How can we help you?'), (33, 33, '110300907170562', '#ed9354', 'Hi! How can we help you?'), (34, 34, '110300907170562', '#02e7aa', 'Hi! How can we help you?'), (35, 35, '110300907170562', '#02e7aa', 'Hi! How can we help you?'); -- -------------------------------------------------------- -- -- Table structure for table `food_menu` -- DROP TABLE IF EXISTS `food_menu`; CREATE TABLE `food_menu` ( `id` int(11) NOT NULL, `listing_id` int(11) DEFAULT NULL, `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `price` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `items` longtext COLLATE utf8_unicode_ci, `photo` longtext COLLATE utf8_unicode_ci ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `food_menu` -- INSERT INTO `food_menu` (`id`, `listing_id`, `name`, `price`, `items`, `photo`) VALUES (1, 1, 'WILD ATLANTIC SCALLOPS', '20', ' lobster prosecco sauce,peas,crispy pancetta,straw fries', '57de5e92b33f5d39780a89a6006fc3c3.jpg'), (2, 1, 'Grilled Sea Bass', '15', 'samphire mash potato,roasted Mediterranean-style vegetables,green beans', '4983c370090a41db32d84604f4dd987a.jpg'), (3, 5, ' BUTTERMILK CHICKEN JIBARITOS', '12', 'Caribbean twist,buttermilk fried chicken', '998cd9adea252e386067ad1c894d5fe7.jpg'), (4, 5, 'BUTTERMILK CHICKEN', '9.99', 'crispy chicken,spicy corn, smoked cheese fritter,grilled asparagus ', '5671ce4522a312360a136faa5540b0a2.jpg'), (5, 9, 'STEAK HOUSE BURGER', '12', 'slow cooked beef,smoked beef bacon,smoked Cheddar cheese,beef dripping sauce', '57de5e92b33f5d39780a89a6006fc3c3.jpg'), (6, 9, 'BAKED CHEDDAR MUSHROOMS', '12.47', 'Button mushrooms,creamy Cheddar,spinach sauce', '998cd9adea252e386067ad1c894d5fe7.jpg'), (7, 10, 'RUM RUNNER, ISLAMORADA DETAILS', '8.49', ' ISLAMORADA DETAILS Bacardi Silver,Bacardi Black Rums, banana liqueur,blackberry brandy', '47b47c9f6683a1ba1ff0990506e33467.jpg'), (8, 10, 'GOOMBAY SMASH, BAHAMAS DETAILS', '7.99', 'Cruzan Coconut,Spiced and Bacardi Black Rums', '5671ce4522a312360a136faa5540b0a2.jpg'), (9, 17, 'WILD ATLANTIC SCALLOPS', '10', 'lobster prosecco sauce, peas, crispy pancetta,straw fries', '4983c370090a41db32d84604f4dd987a.jpg'), (10, 17, 'OVEN ROASTED STUFFED AUBERGINE', '12', 'rich tomato sauce, black olives, peppers', '1d4575d777df3af5fd9c5dcb358db385.jpg'), (11, 20, 'ZOMBIE, CALIFORNIA', '8.49', 'Bacardi Black,Barbancourt Rums,Peach Schnapps ', 'ee765b00421ab189cbaa64ac2435a0ef.jpg'), (12, 20, 'JERK CHICKEN SANDWICH', '12', 'jerk chicken,Buttermilk fried chicken breast, cabbage-jicama slaw', '4983c370090a41db32d84604f4dd987a.jpg'), (13, 22, 'CLASSIC CRÈME BRÛLÉE', '11', 'Madagascan vanilla glazed brûlée,home baked vanilla biscuit,fresh berries', '5671ce4522a312360a136faa5540b0a2.jpg'), (14, 22, 'GRILLED CHICKEN BREAST SANDWICH DETAILS', '20', 'toasted brioche bun,lettuce, sliced onions', 'f3b6e32e86ef262ce2109bfba5608689.jpg'), (15, 23, ' CUBAN SANDWICH', '12.49', 'Ham, roasted pork, Swiss cheese, pickles', '998cd9adea252e386067ad1c894d5fe7.jpg'), (16, 23, 'JERK CHICKEN SANDWICH', '15', 'Cuban bread,jerk chicken', '5671ce4522a312360a136faa5540b0a2.jpg'), (17, 28, 'BEEF EMPANADAS', '11', 'Handmade pastries,savory beef', '57de5e92b33f5d39780a89a6006fc3c3.jpg'), (18, 28, 'TOSTONES WITH CHICKEN', '9', ' sweet pepper,Twice-fried plantains topped with chicken', '47b47c9f6683a1ba1ff0990506e33467.jpg'), (19, 30, 'SPINACH DIP & CHIPS', '10', 'Spinach and artichokes in a creamy cheese dip,tortilla chips', '5671ce4522a312360a136faa5540b0a2.jpg'), (20, 30, 'CHICKEN QUESADILLA', '12', 'Sliced chicken with onions, sweet peppers, spinach', '1d4575d777df3af5fd9c5dcb358db385.jpg'), (21, 30, 'ISLAND HOPPER COMBO', '20', 'Jamaican chicken wings, crispy coconut shrimp, onion rings', '4983c370090a41db32d84604f4dd987a.jpg'); -- -------------------------------------------------------- -- -- Table structure for table `frontend_settings` -- DROP TABLE IF EXISTS `frontend_settings`; CREATE TABLE `frontend_settings` ( `id` int(11) UNSIGNED NOT NULL, `type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `description` longtext COLLATE utf8_unicode_ci ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `frontend_settings` -- INSERT INTO `frontend_settings` (`id`, `type`, `description`) VALUES (1, 'banner_title', 'Atlas Business Directory Listing'), (2, 'banner_sub_title', 'Subtitle Of Atlas Directory Listing'), (3, 'about_us', 'About us'), (4, 'terms_and_condition', 'Terms and conditions'), (5, 'privacy_policy', 'Privacy Poilicy'), (6, 'social_links', '{\"facebook\":\"\",\"twitter\":\"\",\"linkedin\":\"\",\"google\":\"\",\"instagram\":\"\",\"pinterest\":\"\"}'), (7, 'slogan', 'Find your local places, you love most to roam around.'), (8, 'faq', 'Faq'), (9, 'cookie_note', 'This Website Uses Cookies To Personalize Content And Analyse Traffic In Order To Offer You A Better Experience.'), (10, 'cookie_status', '1'), (13, 'hero_settings', '{\"title\":\"How it works\",\"sub_title\":\"Atlas is a professional business directory listing website. Atlas works with the combination of admin and customers. Atlas is a kind of web page that lists businesses and directories that exist on a website.\",\"topic_one\":\"Search locations\",\"icon_picker_one\":\"fas fa-search\",\"sub_topic_one\":\"Businesses and directories can be searched by location from the search bar and listings page.\",\"topic_two\":\"Search by category\",\"icon_picker_two\":\"fas fa-info-circle\",\"sub_topic_two\":\"Businesses and directories listings can be filtered or searched category-wise.\",\"topic_three\":\"Book, Reach or Call\",\"icon_picker_three\":\"far fa-thumbs-up\",\"sub_topic_three\":\"Customers can book, reach or call the businesses directories and payment can be received online\\/offline.\"}'); -- -------------------------------------------------------- -- -- Table structure for table `hotel_room_specification` -- DROP TABLE IF EXISTS `hotel_room_specification`; CREATE TABLE `hotel_room_specification` ( `id` int(11) NOT NULL, `listing_id` int(11) DEFAULT NULL, `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `description` longtext COLLATE utf8_unicode_ci, `price` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `amenities` longtext COLLATE utf8_unicode_ci, `photo` longtext COLLATE utf8_unicode_ci ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `hotel_room_specification` -- INSERT INTO `hotel_room_specification` (`id`, `listing_id`, `name`, `description`, `price`, `amenities`, `photo`) VALUES (1, 2, 'Deluxe King Size', 'Our Deluxe king size room has a seating area, ample storage, digital safe, minibar and luxurious duck down bedding. ', '1200', 'TV,Pool,Free WiFi,Pet Friendly', 'fc89f280a4de73b2fc6c97de0ed959b6.jpg'), (2, 2, 'The Hughes Suite', 'The Hughes Suite is a 2-bedroom suite that offers a master bedroom with a queen-size bed. ', '1100', 'Hairdryer,Refrigerator,Microwave', 'c78070fcbad799ad83716deaf547d56e.jpg'), (3, 6, 'Executive Room', 'They all have big floor-to-ceiling windows to give you an amazing view of either the city of Copenhagen, Combine’s Garden or Islands Brygge.', '900', 'Restaurant,Air Conditioning,bar', 'fc89f280a4de73b2fc6c97de0ed959b6.jpg'), (4, 6, 'Standard room', 'Our Standard rooms are all of comfortable and functional décor to meet the basic needs for you during your stay.', '1000', 'Breakfast Buffet,Wellness Spa,Parking', '2c4f809463bf36e5f3aee195cec9f18d.jpg'), (5, 11, 'Executive Room', 'They all have big floor-to-ceiling windows to give you an amazing view of either the city of Copenhagen, Combine’s Garden or Islands Brygge.', '2000', 'Breakfast Buffet,Swimming Pool,TV,Hair Dryer', 'ed80fbbbd669e453f2e3da0558a4e854.jpg'), (6, 11, 'Grand Deluxe Room', 'Grand Deluxe uniquely designed 2 storey luxury accommodation with contemporary architecture room structures.', '2200', 'Pet Friendly,Air Conditioning,Swimming Pool', '2c4f809463bf36e5f3aee195cec9f18d.jpg'), (7, 12, 'Deluxe King Size', 'Our Deluxe king size room has a seating area, ample storage, digital safe, minibar and luxurious duck down bedding.', '1200', 'Room Service,Desk,Wellness Spa,Laundry Facilities', 'aad06cacf28df4ab85079352ec5209df.jpg'), (8, 12, 'The Hughes Suite', 'The Hughes Suite is a 2-bedroom suite that offers a master bedroom with a queen-size bed. The smaller bedroom offers a full-size bed.', '1500', 'Pet Friendly,Air Conditioning,Desk', '2f3f18bf43dbd8d8d4e2afe954e3406d.jpg'), (9, 13, 'Grand Deluxe Room', 'Grand Deluxe uniquely designed 2 storey luxury accommodation with contemporary architecture room structures.', '1650', 'Television,Free WiFi,Pet allowed', '25bd1ccc1aae7e55a3474fce11f61a1c.jpg'), (10, 13, 'Deluxe Suite', 'Designed to maximize the sense of spaciousness, the Deluxe Suites are tastefully adorned in colors and with artefacts that are paired with a comprehensive set of indulgent services.', '1400', 'Swimming Pool,Hair Dryer,Kitchen Facilities', 'fc89f280a4de73b2fc6c97de0ed959b6.jpg'), (11, 14, 'Executive Room', 'They all have big floor-to-ceiling windows to give you an amazing view of either the city of Copenhagen, Combine’s Garden or Islands Brygge.', '1900', 'Desk,Wellness Spa,Laundry Facilities', '2f3f18bf43dbd8d8d4e2afe954e3406d.jpg'), (12, 14, 'Deluxe King Size', 'Our Deluxe king size room has a seating area, ample storage, digital safe, minibar and luxurious duck down bedding.', '1400', 'Parking,Air Conditioning,Fitness Center', '2c4f809463bf36e5f3aee195cec9f18d.jpg'), (13, 15, 'Deluxe King Size', 'Our Deluxe king size room has a seating area, ample storage, digital safe, minibar and luxurious duck down bedding.', '1350', 'Air Conditioning,Hair Dryer,Desk', '25bd1ccc1aae7e55a3474fce11f61a1c.jpg'), (14, 15, 'Deluxe Suite', 'Designed to maximize the sense of spaciousness, the Deluxe Suites are tastefully adorned in colors and with artefacts that are paired with a comprehensive set of indulgent services.', '1900', 'Bar,Free WiFi,Fitness Center,Room Service', 'ed80fbbbd669e453f2e3da0558a4e854.jpg'), (15, 16, 'Grand Deluxe Room', 'Grand Deluxe uniquely designed 2 storey luxury accommodation with contemporary architecture room structures.', '2000', 'Breakfast Buffet,Bar,Air Conditioning,TV', 'c78070fcbad799ad83716deaf547d56e.jpg'), (16, 16, 'The Hughes Suite', 'The Hughes Suite is a 2-bedroom suite that offers a master bedroom with a queen-size bed. The smaller bedroom offers a full-size bed.', '2200', 'Swimming Pool,Kitchen Facilities,Hair Dryer', 'fc89f280a4de73b2fc6c97de0ed959b6.jpg'), (17, 18, 'Deluxe King Size', 'Our Deluxe king size room has a seating area, ample storage, digital safe, minibar and luxurious duck down bedding.', '1800', 'Swimming Pool,Bar,Room Service,Desk', 'c78070fcbad799ad83716deaf547d56e.jpg'), (18, 18, 'Executive Room', 'They all have big floor-to-ceiling windows to give you an amazing view of either the city of Copenhagen, Combine’s Garden or Islands Brygge.', '1340', 'Fitness Center,Kitchen Facilities,Bar,Pet Friendly', 'ed80fbbbd669e453f2e3da0558a4e854.jpg'), (19, 19, 'Deluxe Suite', 'Designed to maximize the sense of spaciousness, the Deluxe Suites are tastefully adorned in colors and with artefacts that are paired with a comprehensive set of indulgent services.', '1780', 'Hair Dryer,Pet Friendly,Restaurant,Breakfast Buffet', '2f3f18bf43dbd8d8d4e2afe954e3406d.jpg'), (20, 19, 'Deluxe King Size', 'Our Deluxe king size room has a seating area, ample storage, digital safe, minibar and luxurious duck down bedding.', '1900', 'Wellness Spa,Room Service,Desk,Kitchen Facilities', '2c4f809463bf36e5f3aee195cec9f18d.jpg'); -- -------------------------------------------------------- -- -- Table structure for table `inventory` -- DROP TABLE IF EXISTS `inventory`; CREATE TABLE `inventory` ( `id` int(11) UNSIGNED NOT NULL, `name` varchar(255) DEFAULT NULL, `listing_id` int(11) DEFAULT NULL, `category_id` int(11) DEFAULT NULL, `details` longtext, `price` varchar(255) DEFAULT NULL, `availability` int(11) DEFAULT NULL, `thumbnail` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `inventory` -- INSERT INTO `inventory` (`id`, `name`, `listing_id`, `category_id`, `details`, `price`, `availability`, `thumbnail`) VALUES (1, 'Hair Accessories', 3, 6, 'Wholesales Fashion Hair Accessories New Strip Pea', '1', 1, 'zfUCdQ17hav9X2s43FbS.jpg'), (2, 'Trendy Bedroom things', 25, 17, 'Simple modern economic Trend bedroom furniture.', '500', 1, 'Usrj9q6IatmM3hX7pAJL.jpg'), (3, 'Hilton Oak Bed', 25, 17, 'Great Selection Of Wood Bedding Furniture!', '499', 1, 'Qg9RcUYTmuFCvPs15Ait.jpg'), (4, 'Colorful artwork', 25, 17, 'Victorian Bedroom Furniture Sets & Best Decor Idea', '350', 1, 'XcvVNTwdWpq38n5SL4yI.jpg'), (5, 'Trendy skyblue curtain', 25, 9, 'This is so beautiful curtain of blue color.', '80', 1, 'r0zb1mdGcfg3yHtEYSoV.jpg'), (6, 'Coffee table', 25, 8, 'Very nice mini coffee table.', '350', 1, 'h2wuJTF8X0bAft5niYCK.jpg'), (7, 'Dining Table - Dark Chocolate', 25, 8, 'Finest quality imported accessories ensure the strong structure.', '500', 1, 'ytWwQ8HBo6Fcj2lgqJEi.jpg'), (8, 'Harvey Norman', 25, 17, 'it is the perfect solution to all your sleeping and storage needs.', '359', 1, 'viFUZcqNrk1O8SAMnLyl.jpg'), (9, 'Light master bedroom', 6, 10, 'Very nice comfortable room.', '100', 1, '1veVXB3nHTIljW2xu594.jpg'), (10, 'Over Alleged', 6, 10, 'Very nice master bedroom.', '120', 1, 'pZAOm6Wu7s8EGJxtXC0o.jpg'), (11, 'Double bed', 6, 11, 'Childrens Bed rooms designed with parents in mind', '150', 1, 'zP5ljoRYJrTZxGK2v7k8.jpg'), (12, 'Single bed', 6, 11, 'Make Your Children Sleep Soundly.', '110', 1, 'UF0B3tKMnaIHeobTZSp7.jpg'), (13, 'Double Bedroom', 6, 12, 'Classic Interior Designs - Home Interiors by AB Space.', '125', 1, '0zPvIYjlNVh5tBbwn9xc.jpg'), (14, 'Broth', 22, 15, 'Medium onion, peeled and quartered', '12', 1, 'Wrb1et5zCiSMaYnTNVmQ.jpg'), (15, 'Vegetable Broth', 22, 15, 'Rich with scrap, delicious vegetable broth.', '10', 1, 'me7Kpd369RxZHiVJkTDb.jpg'), (16, 'Spinach Pasta', 22, 16, 'Perfect for busy weeknights! ', '15', 1, 'QRbTDPomve0C6tnzOgsq.jpg'), (17, 'Simple Russian Soup', 22, 16, 'Russian soup recipe loaded with seasoned chicken.', '10', 1, '6DwjlBUsCuShH52VrERo.jpg'), (18, 'Mango', 25, 1, 'Lots of sweet mangoes [1 kg].', '8', 1, 'JSmhlBbcYDsGO7i5CHQg.jpg'), (19, 'Eggplant', 25, 1, 'Fresh Eggplant [1 kg].', '7', 1, 'bsWHLVMK5zOej7qlFEoY.jpg'), (20, 'Orange', 25, 1, 'Small size orange [10 pc].', '8', 1, 'nNdaloZx4WLzKRw93PTy.jpg'), (21, 'Cauliflower', 25, 1, 'Pesticide-free cauliflower [1 kg].', '6', 1, '5xKtk0bA2HQBU7y4gqVC.jpg'), (22, 'Cabbage', 25, 1, 'Cabbage [1 pc]', '5', 1, 'D6HhpJ4LbtGoP1C8SmYj.jpg'), (23, 'Tomato', 25, 1, 'Ripe Tomato [5 kg]', '9', 1, 'Wr7b5wR9ODm1GdCuiVvs.jpg'), (24, 'Apple', 25, 1, 'Large fresh apples [1 kg]', '8', 1, 'gs8iV0KWDQCGInB1LvMq.jpg'), (25, 'Green apple', 25, 1, 'Green apple [1 kg]', '7', 1, 'RfIgr7D3dec2uHCqjzKG.jpg'); -- -------------------------------------------------------- -- -- Table structure for table `inventory_category` -- DROP TABLE IF EXISTS `inventory_category`; CREATE TABLE `inventory_category` ( `id` int(11) UNSIGNED NOT NULL, `name` varchar(255) DEFAULT NULL, `listing_id` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `inventory_category` -- INSERT INTO `inventory_category` (`id`, `name`, `listing_id`) VALUES (1, 'Fruits and vegetables', 25), (2, 'Vehicles and Accessories', 3), (3, 'Consumer Electronics', 3), (4, 'Home Appliances', 3), (5, 'Apparel', 3), (6, 'Fashion Accessories', 3), (8, 'Table', 25), (9, 'Curtain', 25), (10, 'Master bedroom', 6), (11, 'Childrens bedroom', 6), (12, 'guest bedroom', 6), (14, 'King type', 6), (15, 'Canned foods', 22), (16, 'Dry goods', 22), (17, 'Bedroom Furniture', 25), (19, 'Machinery', 3); -- -------------------------------------------------------- -- -- Table structure for table `listing` -- DROP TABLE IF EXISTS `listing`; CREATE TABLE `listing` ( `id` int(11) NOT NULL, `code` longtext COLLATE utf8_unicode_ci, `name` longtext COLLATE utf8_unicode_ci, `description` longtext COLLATE utf8_unicode_ci, `categories` longtext COLLATE utf8_unicode_ci, `amenities` longtext COLLATE utf8_unicode_ci, `photos` longtext COLLATE utf8_unicode_ci, `video_url` longtext COLLATE utf8_unicode_ci, `video_provider` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `tags` longtext COLLATE utf8_unicode_ci, `address` longtext COLLATE utf8_unicode_ci, `email` longtext COLLATE utf8_unicode_ci, `phone` longtext COLLATE utf8_unicode_ci, `website` longtext COLLATE utf8_unicode_ci, `social` longtext COLLATE utf8_unicode_ci, `user_id` int(11) DEFAULT NULL, `latitude` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `longitude` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `country_id` int(11) DEFAULT NULL, `city_id` int(11) DEFAULT NULL, `status` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'pending', `listing_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `listing_thumbnail` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `listing_cover` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `seo_meta_tags` longtext COLLATE utf8_unicode_ci, `date_added` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `date_modified` int(11) DEFAULT NULL, `is_featured` int(11) NOT NULL DEFAULT '0', `google_analytics_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `meta_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `package_expiry_date` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `state_id` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `listing` -- INSERT INTO `listing` (`id`, `code`, `name`, `description`, `categories`, `amenities`, `photos`, `video_url`, `video_provider`, `tags`, `address`, `email`, `phone`, `website`, `social`, `user_id`, `latitude`, `longitude`, `country_id`, `city_id`, `status`, `listing_type`, `listing_thumbnail`, `listing_cover`, `seo_meta_tags`, `date_added`, `date_modified`, `is_featured`, `google_analytics_id`, `meta_description`, `package_expiry_date`, `state_id`) VALUES (1, '89b387c90e74ec65fca9fbf404ed4f64', 'Ristorante Del Arte', 'We are committed to uniting fresh, locally grown produce with farm-raised and wild-caught seafood to make the freshest dishes you’ll find anywhere. Our signature raw bar offers a variety of Rhode Island oysters, crisp cherrystones, littleneck clams, and jumbo shrimp. Our Matunuck Oysters are grown in Potter Pond right off our waterfront patio and many of our herbs and vegetables are grown in our vegetable farm on the north end of the pond.', '[\"1\",\"5\",\"2\"]', '[\"2\",\"5\",\"10\",\"16\"]', '[\"d67b95942a2b6e1c7db8c628c2c31b77.jpg\",\"3295ee0a008aff0224fb3addb48ea20f.jpg\",\"b16f50f37fb7e0f89be8f5200d1cf721.jpg\",\"aef23fd6dd797d653e8366c049ebc24f.jpg\",\"4625c0228cf7232127bedadf688f24e9.jpg\",\"f928b590e7e26ce33a7959b4298fd096.jpg\"]', 'https://vimeo.com/183648707', 'vimeo', 'seafood,carryout,family meals', 'Alençon, France', '', '+48929485960', 'http://yourcompany.com', '{\"facebook\":\"\",\"twitter\":\"\",\"linkedin\":\"\"}', 1, '48.433844', '0.065869', 73, 1, 'active', 'restaurant', '0d28ef819e4f63b9ecc4a71ec0edbe8a.jpg', 'c9ff6666a00e4ba34c124f3efe339900.jpg', 'buffet,bistro,asian', '1557619200', 1557878400, 0, NULL, '', 'admin', NULL), (2, '3f55048ca2b79b7787bc247d89256d05', 'La Cour Berbisey', 'This hotel sits in central Nice, just 1,150 feet from the ferry port and a 20-minute walk from the Promenade des Anglais. Its rooms are air-conditioned with free Wi-Fi access. The guest rooms are equipped with flat-screen TVs with satellite channels and a private bathroom. Each is serviced by a lift. It has a 24-hour reception, which is hosted by a multilingual team. The hotel serves a buffet breakfast every morning.', '[\"10\",\"11\",\"16\"]', '[\"5\",\"6\",\"10\",\"11\",\"15\"]', '[\"265fa4326dada754ca9139ea804de30d.jpg\",\"3ee21c4723f9d05afe864d6df5e6d12c.jpg\",\"9828f4d7c838cdf247ee5d8898c07cca.jpg\",\"d2686c0c133d7e4f47ee13b59999c33c.jpg\",\"30b474614df35970b90020d982db967f.jpg\",\"f40a1dcae4c9c45bbf72e3e502b021de.jpg\"]', 'https://vimeo.com/18966531', 'vimeo', '5 star hotel,beach resort', 'Dijon, France', 'yourbusiness@example.com', '+48929485960', '', '{\"facebook\":\"\",\"twitter\":\"\",\"linkedin\":\"\"}', 1, '47.318454', '5.036589', 73, 8, 'active', 'hotel', '7bd5f999459adb7a12c585de2aecf7cc.jpg', '1960a183c7adb42c6982f8d6831b519a.jpg', 'luxury hotels,motel,family room', '1557705600', 1572843600, 0, '', '', 'admin', NULL), (3, '556e6631600be55855b61c863c618ffd', 'Depot vente luxe Mademoiselle', 'Our store principal business is carried out by retail trade. Here people get delivery of goods or other product services. It differs from a convenience store or corner shop in that it will be the main shop for the community rather than a convenient supplement.', '[\"18\",\"21\",\"23\"]', '[\"1\",\"6\",\"7\",\"16\"]', '[\"87d60693a8f35d35162d3d4110bc5514.jpg\",\"47604a3e6d23f38ea1f3545cda958e1e.jpg\",\"f52aaf82af73dd3725d5711ef842eb9b.jpg\",\"42e9c1a19329ac2462be4d21bf47c7fd.jpg\",\"c92bd5e901ff47d7d29d970ed2a0f92c.jpg\",\"6b27e7bad3d2c615670c88ca684e6114.jpg\",\"86538dd26e48aa30e99920f255ef3373.jpg\"]', 'https://vimeo.com/95929658', 'vimeo', 'online shopping mall,shop cinema', 'Nice, France', 'yourbusiness@example.com', '+48929485960', 'http://yourcompany.com', '{\"facebook\":\"\",\"twitter\":\"\",\"linkedin\":\"\"}', 1, '43.696033', '7.261461', 73, 3, 'active', 'shop', 'f3b6e32e86ef262ce2109bfba5608689.jpg', 'c8d0e12dafd1481aaa5c44a196e254e8.jpg', 'shoppers guide,shops', '1557792000', 1557878400, 0, NULL, '', 'admin', NULL), (4, 'b71fac22258c2037106ee5e87a2e919f', 'Crossfit ELAFI', 'It is a unique lifestyle program designed to achieve every individual member’s respective health and fitness goals. Whether our members are beginners or enthusiasts, every program, product, and experience we offer begins and ends with creating a premier and comfortable atmosphere tailored for their individual and overall success and safety.', '[\"27\",\"28\",\"33\",\"30\"]', '[\"5\",\"6\",\"7\",\"9\",\"16\"]', '[\"ac9884c61b126e282138bcaccd9b0f1e.jpg\",\"82268c98f3307df94980931841c99eab.jpg\",\"08536a4842954b40c98d20b03ccb9bd0.jpg\",\"98a4056f3ae2b4df7dfd6a6f30f7cbe9.jpg\",\"356ac8052df8a68ede987e1c91285b64.jpg\",\"163c01776ad7bf16bc6f7e3081848169.jpg\",\"cc268cd350292b094a790d627fa66fd0.jpg\"]', 'https://vimeo.com/302154751', 'vimeo', 'local fitness gyms,gym center,gym specials', 'Lyon, France', 'yourbusiness@example.com', '', 'http://yourcompany.com', '{\"facebook\":\"\",\"twitter\":\"\",\"linkedin\":\"\"}', 2, '45.743210', '4.849847', 73, 2, 'active', 'general', '06cdd46cb8abdc55338c773642777dfa.jpg', '0cfb306a0810b77e04b0e22150a7cefb.jpg', 'health club membership,affordable gym membership,gym facilities', '1557878400', 1561939200, 0, NULL, '', '1574726400', NULL), (5, 'b67ba71907190937a26dd3f4121b8fef', 'La Maison d Horbe', 'We are committed to uniting fresh, locally grown produce with farm-raised and wild-caught seafood to make the freshest dishes you’ll find anywhere. Our signature raw bar offers a variety of Rhode Island oysters, crisp cherrystones, littleneck clams, and jumbo shrimp. Our Matunuck Oysters are grown in Potter Pond right off our waterfront patio and many of our herbs and vegetables are grown in our vegetable farm on the north end of the pond.', '[\"1\",\"8\",\"7\"]', '[\"2\",\"6\",\"10\",\"11\",\"16\"]', '[\"b91e5e340aed973e32144d75d53c4bb0.jpg\",\"1c9b8fab15df27d5d70be2bb5cc64568.jpg\",\"8c0b1e256be81f39ca6ca75471da5413.jpg\",\"9611ed5221072c1847e837f415729863.jpg\",\"4294c23051f61bf74dee442181531321.jpg\",\"7ed5c361d9d304b70f3cab5105bf2622.jpg\"]', 'https://vimeo.com/23851992', 'vimeo', 'family,best brunch', 'La Perrière, France', 'yourbusiness@example.com', '+48929485960', 'http://yourcompany.com', '{\"facebook\":\"\",\"twitter\":\"\",\"linkedin\":\"\"}', 1, '48.401004', '0.440857', 73, 6, 'active', 'restaurant', '2eeae1148e1e7f691cb9521a9c41fff6.jpg', 'bb2bc9902b6d238c103c944c300f7cb5.jpg', 'large groups,cafe america,catering services', '1557619200', 1572843600, 0, '', '', 'admin', NULL), (6, '9eb131c8e0f5e5e3796606e6246b76e0', 'Clarance Hotel', 'This hotel sits in central Nice, just 1,150 feet from the ferry port and a 20-minute walk from the Promenade des Anglais. Its rooms are air-conditioned with free Wi-Fi access. The guest rooms are equipped with flat-screen TVs with satellite channels and a private bathroom. Each is serviced by a lift. It has a 24-hour reception, which is hosted by a multilingual team. The hotel serves a buffet breakfast every morning.', '[\"10\",\"12\",\"16\",\"17\"]', '[\"5\",\"6\",\"7\",\"8\",\"9\",\"15\"]', '[\"2179747a781559ef75f2a2b7eb4f4dac.jpg\",\"368643249380d4ad6e01c15adba67b16.jpg\",\"0e4451533ff60b9a99b317c9eb56c63d.jpg\",\"3eb37ed33c73ccac865fa2b8cbbc004b.jpg\",\"a624135bd3f738a648d5be5a82e888cf.jpg\",\"adcc3f941c2df75c85b6f056c8598f7f.jpg\"]', 'https://vimeo.com/214125425', 'vimeo', 'best hotel rooms,top luxury hotels', 'Lille, France', 'yourbusiness@example.com', '+48929485960', 'http://yourcompany.com', '{\"facebook\":\"\",\"twitter\":\"\",\"linkedin\":\"\"}', 1, '50.638833', '3.056990', 73, 10, 'active', 'hotel', '98008ded21258aa9c869d4f64a6ba7b6.jpg', 'dbedaa03c04d1686bc675edd3e15f6e9.jpg', 'cheap rooms,exclusive hotels,meeting hotel', '1557705600', 1557705600, 1, NULL, '', 'admin', NULL), (7, '0c6b47734c10b735b78fc8f1180b8905', 'Galerie Vivienne', 'Our store principal business is carried out by retail trade. Here people get delivery of goods or other product services. It differs from a convenience store or corner shop in that it will be the main shop for the community rather than a convenient supplement.', '[\"18\",\"20\",\"23\",\"24\"]', '[\"6\",\"11\",\"12\"]', '[\"7df6a62898c8a10f75031b198ae001ba.jpg\",\"b9873ef878d83f620957891b1df8c5e4.jpg\",\"59a78eec7782876c1ad85b2dceb0c8af.jpg\",\"a2420fbfaca3717daa106d06eb0046ee.jpg\",\"c2ba30e5cda176527335d0c3264ea6ec.jpg\",\"647f5c9731cf14303350dc528ff9ad3c.jpg\"]', 'https://vimeo.com/37398997', 'vimeo', 'home shopping,shopping outlets', 'Paris, France', 'yourbusiness@example.com', '+48929485960', 'http://yourcompany.com', '{\"facebook\":\"\",\"twitter\":\"\",\"linkedin\":\"\"}', 1, '48.867055', '2.339490', 73, 1, 'active', 'shop', '40206eb4f7de800c5fa595c7c7f2df1d.jpg', 'e237e4044d1bde3b93e22e171d422873.jpg', 'shopping,online shopping,shopping mall', '1557792000', 1566259200, 0, '', '', 'admin', NULL), (8, 'd897afbf6d6057ee807ca798b1ef5919', 'Fit Factory CrossFit Massilia', 'It is a unique lifestyle program designed to achieve every individual member’s respective health and fitness goals. Whether our members are beginners or enthusiasts, every program, product, and experience we offer begins and ends with creating a premier and comfortable atmosphere tailored for their individual and overall success and safety.', '[\"27\",\"32\",\"31\",\"30\"]', '[\"5\",\"6\",\"9\",\"16\"]', '[\"282ed47897460e901f53f0ff3eace9fb.jpg\",\"b64a3c3775d0ac469339c66a1b922ea6.jpg\",\"6030dd9e4fe497adc7c4aba4d1b4c4a2.jpg\",\"780b6cefbc1178a1e6e9f37c31226ae0.jpg\",\"f6a1f87b68aca29a9c52104c910446f7.jpg\",\"02589add6cce9ef423187a2b35358fe3.jpg\",\"838e5a753a6dc5791dd4f1946dccc2aa.jpg\"]', 'https://vimeo.com/34313969', 'vimeo', 'gym class,health & fitness', 'Marseille, France', '', '+48929485960', 'http://yourcompany.com', '{\"facebook\":\"\",\"twitter\":\"\",\"linkedin\":\"\"}', 1, '43.243198', '5.397923', 73, 4, 'active', 'general', 'efe439e788a46a2b00f553dac1d18e4a.jpg', '76906f19b06f4b15a5b16b9c66e6b44b.jpg', 'womens gym,fitness facility,fit studio', '1557878400', NULL, 0, NULL, '', 'admin', NULL), (9, '57a1510023062dc470e72fe19ee75674', 'Pizzeria Rosa-Maria', 'We are committed to uniting fresh, locally grown produce with farm-raised and wild-caught seafood to make the freshest dishes you’ll find anywhere. Our signature raw bar offers a variety of Rhode Island oysters, crisp cherrystones, littleneck clams, and jumbo shrimp. Our Matunuck Oysters are grown in Potter Pond right off our waterfront patio and many of our herbs and vegetables are grown in our vegetable farm on the north end of the pond.', '[\"1\",\"5\"]', '[\"2\",\"4\",\"7\"]', '[\"4573e653c8d3e1fa20a9e44285d29261.jpg\",\"96e4dd6a50f6e64c5542fc01753bbf4c.jpg\",\"6e81617d543a3fa7a779a82d8fad5f88f.jpg\",\"fed060ca844c93f17d019fb832227573.jpg\",\"93875ea67d7d6f381ebaccecc727abdb.jpg\",\"09be3a77d03715ef942c1d15fa524a30.jpg\"]', 'https://vimeo.com/183648707', 'vimeo', 'steak,restaurants local,buffet', 'Mauron, France', 'yourbusiness@example.com', '+48929485960', 'http://yourcompany.com', '{\"facebook\":\"\",\"twitter\":\"\",\"linkedin\":\"\"}', 1, '48.083271', '-2.286561', 73, 10, 'active', 'restaurant', 'cbf89b5c3a16902a893b252c2d2dac84.jpg', '564ec65147a44e86d42d2babf2c22829.jpg', 'sur paris,italian menu', '1557619200', NULL, 0, NULL, '', 'admin', NULL), (10, '44d09c5280055d8aade379d19520101e', 'Restaurant Zest', 'We are committed to uniting fresh, locally grown produce with farm-raised and wild-caught seafood to make the freshest dishes you’ll find anywhere. Our signature raw bar offers a variety of Rhode Island oysters, crisp cherrystones, littleneck clams, and jumbo shrimp. Our Matunuck Oysters are grown in Potter Pond right off our waterfront patio and many of our herbs and vegetables are grown in our vegetable farm on the north end of the pond.', '[\"1\",\"3\",\"9\",\"8\"]', '[\"1\",\"2\",\"14\",\"16\"]', '[\"24238e99a0c840c2f8bf745d579e74d3.jpg\",\"bbae030643830b600d79aa38b4c7f409.jpg\",\"d3185080c97fbef258257b20baf486f9.jpg\",\"78a84230f69c392a5d3fad7491b5f5e7.jpg\",\"477f444796e12e7c4f00911bc74e0e26.jpg\",\"7fd932704ee3758326d3e390639883ce.jpg\"]', 'https://vimeo.com/5486880', 'vimeo', 'avis,cafe', 'Cesson-Sévigné, France', 'yourbusiness@example.com', '', 'http://yourcompany.com', '{\"facebook\":\"\",\"twitter\":\"\",\"linkedin\":\"\"}', 2, '48.116340', '1.606972', 73, 8, 'active', 'restaurant', 'bad767a3506c4960d2ea984a3459634f.jpg', '5b18e01695fb5f18fb252a8876286193.jpg', 'resto a paris,tapas,bar', '1557619200', NULL, 0, NULL, '', '1574726400', NULL), (11, 'd5965dfac99bcfbf85b5d391a5942ed9', 'Le Bristol Paris', 'This hotel sits in central Nice, just 1,150 feet from the ferry port and a 20-minute walk from the Promenade des Anglais. Its rooms are air-conditioned with free Wi-Fi access. The guest rooms are equipped with flat-screen TVs with satellite channels and a private bathroom. Each is serviced by a lift. It has a 24-hour reception, which is hosted by a multilingual team. The hotel serves a buffet breakfast every morning.', '[\"10\",\"11\",\"13\"]', '[\"3\",\"6\",\"8\",\"9\",\"15\"]', '[\"71e9d3913e7312b83c714d211c5730a4.jpg\",\"f0176907be8b0bbb35403144fa22c202.jpg\",\"abbbb026f5ab290750ffb41efefe8e18.jpg\",\"9d3bd61e7746b12ffd36f40ff7b5c4e3.jpg\",\"83fd5a4f4827e1a9c77791f14ca348b2.jpg\"]', 'https://vimeo.com/214125425', 'vimeo', 'cheap hotels,best hotel prices', 'Paris, France', 'yourbusiness@example.com', '+48929485960', 'http://yourcompany.com', '{\"facebook\":\"\",\"twitter\":\"\",\"linkedin\":\"\"}', 1, '48.872439', '2.314749', 73, 1, 'active', 'hotel', '2e11ad3d8048c3268f935b7e7fc5e8ff.jpg', '72ac56d12b547ba6b61555f2ba623dd3.jpg', 'motel,local ,hotel packages', '1557705600', 1557705600, 0, NULL, '', 'admin', NULL), (12, '757e184124dc9bc15f327672018e2ae0', 'Hotel Ritz Paris', 'This hotel sits in central Nice, just 1,150 feet from the ferry port and a 20-minute walk from the Promenade des Anglais. Its rooms are air-conditioned with free Wi-Fi access. The guest rooms are equipped with flat-screen TVs with satellite channels and a private bathroom. Each is serviced by a lift. It has a 24-hour reception, which is hosted by a multilingual team. The hotel serves a buffet breakfast every morning.', '[\"10\",\"13\",\"16\",\"14\"]', '[\"4\",\"5\",\"11\",\"12\"]', '[\"324bdb5922142678a13f7ea5dbc73997.jpg\",\"3ee21c4723f9d05afe864d6df5e6d12c.jpg\",\"70c837809bedfa7eb0f7ea4855532606.jpg\",\"3d130d828d133133977510af657479bc.jpg\",\"eb67911f5733fd5fe6043cf0514d0c9e.jpg\"]', 'https://vimeo.com/18966531', 'vimeo', 'low price,airport hotel,com hotel', 'paris, France', 'yourbusiness@example.com', '', 'http://yourcompany.com', '{\"facebook\":\"\",\"twitter\":\"\",\"linkedin\":\"\"}', 1, '48.868387', '2.329019', 73, 1, 'active', 'hotel', 'dc497400417f81c25cb2fac7da4d4e07.jpg', '73d2653316f20d6386a74e5111fccf65.jpg', 'cheap luxury hotels,discount lodging', '1557705600', 1557705600, 0, NULL, '', 'admin', NULL), (13, '2a290a15018fbf793857159639d7693f', 'Hotel Cap-Estel', 'This hotel sits in central Nice, just 1,150 feet from the ferry port and a 20-minute walk from the Promenade des Anglais. Its rooms are air-conditioned with free Wi-Fi access. The guest rooms are equipped with flat-screen TVs with satellite channels and a private bathroom. Each is serviced by a lift. It has a 24-hour reception, which is hosted by a multilingual team. The hotel serves a buffet breakfast every morning.', '[\"10\",\"14\",\"17\",\"12\"]', '[\"5\",\"6\",\"7\",\"9\",\"10\"]', '[\"952f1db1edd67a355727a7423aa4a1a7.jpg\",\"3ee21c4723f9d05afe864d6df5e6d12c.jpg\",\"3d130d828d133133977510af657479bc.jpg\",\"ae418cd6f0a6b844bfd30d5661266605.jpg\",\"06373f6c63fbf5e254422bb9dd287492.jpg\",\"a90184d050413d2de7c74994bc663618.jpg\"]', 'https://vimeo.com/185296158', 'vimeo', 'booking hotel,five star hotel', 'Eze, France', 'yourbusiness@example.com', '+48929485960', 'http://yourcompany.com', '{\"facebook\":\"\",\"twitter\":\"\",\"linkedin\":\"\"}', 1, '43.720305', '7.373927', 73, 3, 'active', 'hotel', 'ad8540e9cad71f895a01b57b72eadce5.jpg', '43312b8cf76048f1de8b8931aa4f7cfd.jpg', 'accommodation sites,motel discounts', '1557705600', 1572843600, 0, '', '', 'admin', NULL), (14, 'eb3151e6177fdddc72f5065b8d04f595', 'Villa Florentine', 'This hotel sits in central Nice, just 1,150 feet from the ferry port and a 20-minute walk from the Promenade des Anglais. Its rooms are air-conditioned with free Wi-Fi access. The guest rooms are equipped with flat-screen TVs with satellite channels and a private bathroom. Each is serviced by a lift. It has a 24-hour reception, which is hosted by a multilingual team. The hotel serves a buffet breakfast every morning.', '[\"10\",\"17\",\"15\"]', '[\"4\",\"5\",\"6\",\"12\"]', '[\"a73878671faa0fb9c99f6423bfa1b95a.jpg\",\"58ac50e1742bea39c51ad110744cedb7.jpg\",\"0b8c7a45fa8ea8795b960599bf27d60e.jpg\",\"c56676afe5e146fbc98bd2b14efdd7d4.jpg\",\"0e4451533ff60b9a99b317c9eb56c63d.jpg\"]', 'https://vimeo.com/188840379', 'vimeo', 'hotel inn,cheap lodges', 'Lyon, France', 'yourbusiness@example.com', '+48929485960', 'http://yourcompany.com', '{\"facebook\":\"\",\"twitter\":\"\",\"linkedin\":\"\"}', 1, '45.763209', '4.825801', 73, 2, 'active', 'hotel', '5e6338412a983c825fe4eccd28597345.jpg', '7d6d3637c72e4cf7fbb6a5accedd7f45.jpg', 'hotel suite,five star hotel,cheap luxury hotels', '1557705600', 1557705600, 0, NULL, '', 'admin', NULL), (15, '4f96a4ad1dcbc9c846f601eeabe43425', 'Le Petit Nice Passedat', 'This hotel sits in central Nice, just 1,150 feet from the ferry port and a 20-minute walk from the Promenade des Anglais. Its rooms are air-conditioned with free Wi-Fi access. The guest rooms are equipped with flat-screen TVs with satellite channels and a private bathroom. Each is serviced by a lift. It has a 24-hour reception, which is hosted by a multilingual team. The hotel serves a buffet breakfast every morning.', '[\"10\",\"11\",\"14\",\"15\"]', '[\"3\",\"9\",\"10\",\"11\"]', '[\"f968b8962dec22085692c77c957a8c6f.jpg\",\"7399e97735ded6f562fee86f94f854bf.jpg\",\"fa37610bd506195df49b5455a2cae9cf.jpg\",\"3ee21c4723f9d05afe864d6df5e6d12c.jpg\",\"91333c74ddb1d59c2a9dd75f6276e8e8.jpg\",\"793715dc65e89612c65288cae430d3f2.jpg\"]', 'https://vimeo.com/18966531', 'vimeo', 'cheap airport hotels,park hotel', 'Marseille, France', 'yourbusiness@example.com', '', 'http://yourcompany.com', '{\"facebook\":\"\",\"twitter\":\"\",\"linkedin\":\"\"}', 1, '43.280494', '5.352184', 73, 4, 'active', 'hotel', '4a8c24c96f7c1bd77a0ce2f34c2656a5.jpg', 'f2b363af463a24f219e8e9613b1eb6dc.jpg', 'discount lodging,find hotel specials,accommodations', '1557705600', NULL, 0, NULL, '', 'admin', NULL), (16, '271d9a5b2f118bcd60adc12e9ac709eb', 'Intercontinental Bordeaux Le Grand Hotel', 'This hotel sits in central Nice, just 1,150 feet from the ferry port and a 20-minute walk from the Promenade des Anglais. Its rooms are air-conditioned with free Wi-Fi access. The guest rooms are equipped with flat-screen TVs with satellite channels and a private bathroom. Each is serviced by a lift. It has a 24-hour reception, which is hosted by a multilingual team. The hotel serves a buffet breakfast every morning.', '[\"10\",\"16\",\"15\",\"13\"]', '[\"1\",\"3\",\"5\",\"6\",\"7\"]', '[\"85c577b3e8196e8066d453599a227d90.jpg\",\"82a42056739892bcfeb849345122dc5c.jpg\",\"3d130d828d133133977510af657479bc.jpg\",\"3eb37ed33c73ccac865fa2b8cbbc004b.jpg\",\"9bb94102c72d909e1fa773ee79ff649e.jpg\"]', 'https://vimeo.com/188840379', 'vimeo', 'check hotel prices,accomodation', 'Bordeaux, France', 'yourbusiness@example.com', '+48929485960', 'http://yourcompany.com', '{\"facebook\":\"\",\"twitter\":\"\",\"linkedin\":\"\"}', 2, '44.842442', '-0.574885', 73, 5, 'active', 'hotel', '758b728bc1f27b2bf62064ac077e8d6d.jpg', '0da45f8089e9e2d011aba121f3874bb3.jpg', 'grand hotel,motel booking sites,local hotels', '1557705600', 1557705600, 0, NULL, '', '1574726400', NULL), (17, 'ac06fedf0b25619965a62740b646cd85', 'Restaurant Le Grand Gousier', 'We are committed to uniting fresh, locally grown produce with farm-raised and wild-caught seafood to make the freshest dishes you’ll find anywhere. Our signature raw bar offers a variety of Rhode Island oysters, crisp cherrystones, littleneck clams, and jumbo shrimp. Our Matunuck Oysters are grown in Potter Pond right off our waterfront patio and many of our herbs and vegetables are grown in our vegetable farm on the north end of the pond.', '[\"1\",\"2\",\"6\"]', '[\"1\",\"4\",\"5\",\"6\",\"10\"]', '[\"8c76cbdc438cddfb9838cbacfa0636b3.jpg\",\"6a48ae8bcc2cbe545cec616c85bb1b68.jpg\",\"449b9644f102264a8edd922e1533203d.jpg\",\"80e7d0f9f82cc0673136e296d596d3ad.jpg\",\"6e835741bc1f2d1ae212557b07560168.jpg\",\"ad9c2130f3fd100f331b9e5c5dafa8b7.jpg\"]', 'https://vimeo.com/46441876', 'vimeo', 'food,pizza,coffee', 'Domfront, France', 'yourbusiness@example.com', '+48929485960', 'http://yourcompany.com', '{\"facebook\":\"http:\\/\\/facebook.com\\/yourcompany\",\"twitter\":\"http:\\/\\/twitter.com\\/yourcompany\",\"linkedin\":\"http:\\/\\/linkedin.com\\/yourcompany\"}', 1, '48.614694', '-0.646657', 73, 5, 'active', 'restaurant', '939f93fce676624e6a32882c3d2234db.jpg', 'b54d04ea5245038abda3b1f0a530e92d.jpg', 'mexican,steakhouse', '1557619200', 1572843600, 0, '', '', 'admin', NULL), (18, '114f6f314314838bfe0b96b397170999', 'Hotel Sofitel Strasbourg Grande Ile', 'This hotel sits in central Nice, just 1,150 feet from the ferry port and a 20-minute walk from the Promenade des Anglais. Its rooms are air-conditioned with free Wi-Fi access. The guest rooms are equipped with flat-screen TVs with satellite channels and a private bathroom. Each is serviced by a lift. It has a 24-hour reception, which is hosted by a multilingual team. The hotel serves a buffet breakfast every morning.', '[\"10\",\"11\",\"14\",\"15\"]', '[\"4\",\"5\",\"6\",\"7\",\"12\"]', '[\"3995aefefc250193b06a39fb3cf74d92.jpg\",\"c8f2dd4c7b91b573ffe581bc9c95ddca.jpg\",\"2150c5beda9a9928c8b60a8fcf8c4bc7.jpg\",\"4bee37c2f584d384fa671c7f2182efaf.jpg\",\"3eb37ed33c73ccac865fa2b8cbbc004b.jpg\",\"61efac3a7b539521dc65bac407fd828d.jpg\"]', 'https://vimeo.com/214125425', 'vimeo', 'business hotel,snow hotel,quality hotel', 'Strasbourg, France', 'yourbusiness@example.com', '+48929485960', '', '{\"facebook\":\"\",\"twitter\":\"\",\"linkedin\":\"\"}', 1, '48.585353', '7.745935', 73, 7, 'active', 'hotel', '6c5e3f755a3b921c757e111827764697.jpg', 'a3d24ddb19260da8952e68109c7f9a8b.jpg', 'economy hotel,resort hotel', '1557705600', NULL, 0, NULL, '', 'admin', NULL), (19, 'bba1e84710e3cbb2bbd717c33b4a8493', 'Hotel Oceania Hotel de France', 'This hotel sits in central Nice, just 1,150 feet from the ferry port and a 20-minute walk from the Promenade des Anglais. Its rooms are air-conditioned with free Wi-Fi access. The guest rooms are equipped with flat-screen TVs with satellite channels and a private bathroom. Each is serviced by a lift. It has a 24-hour reception, which is hosted by a multilingual team. The hotel serves a buffet breakfast every morning.', '[\"10\",\"11\",\"12\",\"15\"]', '[\"6\",\"7\",\"9\",\"10\",\"12\"]', '[\"29449827ff6f03a85a16cfddf8cdae0b.jpg\",\"e83c794a68dade32b4121af5b411ebc5.jpg\",\"3d130d828d133133977510af657479bc.jpg\",\"3eb37ed33c73ccac865fa2b8cbbc004b.jpg\",\"3eb37ed33c73ccac865fa2b8cbbc004b.jpg\",\"aad7cd2d7561ee07b574938bec807de3.jpg\"]', 'https://vimeo.com/188840379', 'vimeo', 'city hotel,lakeside hotel,hotel and resort', 'Nantes, France', 'yourbusiness@example.com', '+48929485960', 'http://yourcompany.com', '{\"facebook\":\"\",\"twitter\":\"\",\"linkedin\":\"\"}', 2, '47.213471', '-1.561656', 73, 9, 'active', 'hotel', '36be7c2e49cf9572ca373c329ee435fe.jpg', '0dab81ac05ab2cb9238ac57955408613.jpg', 'holiday hotel,village hotel', '1557705600', NULL, 0, NULL, '', '1574726400', NULL), (20, '3c4505c777335d88cc1d424a87fd0e45', 'Le Bistrot des Ecuries', 'We are committed to uniting fresh, locally grown produce with farm-raised and wild-caught seafood to make the freshest dishes you’ll find anywhere. Our signature raw bar offers a variety of Rhode Island oysters, crisp cherrystones, littleneck clams, and jumbo shrimp. Our Matunuck Oysters are grown in Potter Pond right off our waterfront patio and many of our herbs and vegetables are grown in our vegetable farm on the north end of the pond.', '[\"1\",\"8\",\"4\",\"7\"]', '[\"1\",\"10\",\"14\"]', '[\"23bd2117992d8cde2019398530c8cf63.jpg\",\"fbbd28ff0a74acf94f6d1e2e5ef8f7b1.jpg\",\"cbf37cb1fd45a51e4eb1171a1e1e4458.jpg\",\"cc88be833333abe6c66dcb6b905017b5.jpg\",\"0d56a840a8c5735e0692648f3c740349.jpg\",\"b3e93919f9a0d19809c99ddd312a3ef5.jpg\",\"6bc3f7bfebf90510f7e95d8911d4ca2d.jpg\"]', 'https://vimeo.com/23851992', 'vimeo', 'cheap meals,outdoor', 'Maugis, France', 'yourbusiness@example.com', '+48929485960', '', '{\"facebook\":\"\",\"twitter\":\"\",\"linkedin\":\"\"}', 2, '48.448760', '0.744210', 73, 7, 'active', 'restaurant', '50762555c9494e8bcb1c12dd36a54832.jpg', '5cecaf1d6c1313cc6264cde17c7b6b27.jpg', 'casual dining,cafe,best steak', '1557619200', 1557619200, 0, NULL, '', '1574726400', NULL), (21, 'b7566c75172e2478c333f51bc3504ad1', 'Bring Home France', 'Our store principal business is carried out by retail trade. Here people get delivery of goods or other product services. It differs from a convenience store or corner shop in that it will be the main shop for the community rather than a convenient supplement.', '[\"18\",\"19\",\"22\",\"25\"]', '[\"4\",\"6\",\"12\",\"14\"]', '[\"872995414daeadb3a7a68d0cfeb3e2e8.jpg\",\"319d4671dd01681beb5c8c77965c889f.jpg\",\"b9873ef878d83f620957891b1df8c5e4.jpg\",\"a162222ef223a5951511e9ce17fc2616.jpg\",\"4bf5417c0c89fe7ccbce6d8852826e6f.jpg\",\"8458af2305958f01080a41c17e20ee85.jpg\"]', 'https://vimeo.com/112570931', 'vimeo', 'local shopping,web shopping', 'Paris, France', 'yourbusiness@example.com', '+48929485960', 'http://yourcompany.com', '{\"facebook\":\"\",\"twitter\":\"\",\"linkedin\":\"\"}', 1, '48.853999', '2.364864', 73, 1, 'active', 'shop', '6691bc3b52e8012205465b40e5ce1df6.jpg', '856b85644dd9558eaa427550eb30af28.jpg', 'best shopping,international shopping', '1557792000', 1557792000, 0, NULL, '', 'admin', NULL), (22, '4aba38ce323f9dce072901260e2670b5', 'Au Normandy SARL', 'We are committed to uniting fresh, locally grown produce with farm-raised and wild-caught seafood to make the freshest dishes you’ll find anywhere. Our signature raw bar offers a variety of Rhode Island oysters, crisp cherrystones, littleneck clams, and jumbo shrimp. Our Matunuck Oysters are grown in Potter Pond right off our waterfront patio and many of our herbs and vegetables are grown in our vegetable farm on the north end of the pond.', '[\"1\",\"7\",\"4\"]', '[\"4\",\"5\",\"6\",\"7\"]', '[\"b08d7e0f314822becc29c1e520e08c9f.jpg\",\"2fd319394c350dd0d53c240b36a44cdf.jpg\",\"1af0b23c94a43d74ac4b85c0e2ee75ca.jpg\",\"82482aa9e103b8b12438eab9d43ac2bb.jpg\",\"dd21002a2009e874385d86079e05e9c5.jpg\"]', 'https://vimeo.com/46441876', 'vimeo', 'bar food,fancy', 'Sées, France', 'yourbusiness@example.com', '+48929485960', 'http://yourcompany.com', '{\"facebook\":\"\",\"twitter\":\"\",\"linkedin\":\"\"}', 1, '48.617811', '0.175409', 73, 6, 'active', 'restaurant', '9d650320fe0bb163bc53750b45af5314.jpg', 'c62c17468757c94d301c36ad04e6560d.jpg', 'sushi menu,steak house,food guide', '1557619200', NULL, 1, NULL, '', 'admin', NULL), (23, '728fbaf5daf79c5383dcc3952d2dd6ca', 'Rive Droite', 'We are committed to uniting fresh, locally grown produce with farm-raised and wild-caught seafood to make the freshest dishes you’ll find anywhere. Our signature raw bar offers a variety of Rhode Island oysters, crisp cherrystones, littleneck clams, and jumbo shrimp. Our Matunuck Oysters are grown in Potter Pond right off our waterfront patio and many of our herbs and vegetables are grown in our vegetable farm on the north end of the pond.', '[\"1\",\"3\",\"4\"]', '[\"2\",\"6\",\"11\",\"16\"]', '[\"f928b590e7e26ce33a7959b4298fd096.jpg\",\"f8010e8f2b93568acae811b4997fff86.jpg\",\"bea9cb5d8ff81a16df786bffef1c5228.jpg\",\"17de46cff0ed921139299e58c593ae16.jpg\",\"dfe1cb7f6696999cd1f49bf02c517536.jpg\",\"6e81617d543a3fa7a779a82d8fad5f88.jpg\"]', 'https://vimeo.com/5486880', 'vimeo', 'bar food,kids restaurants', 'Alençon, France', '', '+48929485960', 'http://yourcompany.com', '{\"facebook\":\"\",\"twitter\":\"\",\"linkedin\":\"\"}', 1, '48.428727', '0.088896', 73, 2, 'active', 'restaurant', '8b2921a5e2839724649f7566472ae27e.jpg', '7874f95c887f7ba7b8152e836f719824.jpg', 'sushi menu,outdoor,lunch', '1557619200', 1557705600, 0, NULL, '', 'admin', NULL), (24, 'fecfe2a17dba2cbae72cccb050a061dd', 'La Boutique de la Truffe', 'Our store principal business is carried out by retail trade. Here people get delivery of goods or other product services. It differs from a convenience store or corner shop in that it will be the main shop for the community rather than a convenient supplement.', '[\"18\",\"20\",\"25\",\"26\"]', '[\"6\",\"12\",\"14\",\"16\"]', '[\"a03124d8c05f1bed068dbd032627b803.jpg\",\"2828dabbc19b28cdaf7223b72e5b813c.jpg\",\"8293009ff9946fc3e231b79218314b69.jpg\",\"ec30a74133a87719038e23339360b775.jpg\",\"8c4c38d0e328ec4d2de254de4cf58223.jpg\",\"72fe69a3d846f008a568b51613a50bde.jpg\"]', 'https://vimeo.com/37398997', 'vimeo', 'shopping internet,local shopping', 'Dijon, France', 'yourbusiness@example.com', '+48929485960', 'http://yourcompany.com', '{\"facebook\":\"\",\"twitter\":\"\",\"linkedin\":\"\"}', 2, '47.323097', '5.043547', 73, 8, 'active', 'shop', '1bca9f7f867a5f6ec3b67d0f3fc657c7.jpg', '7d3e41381d662ebadb1e4309ffe042d6.jpg', 'shopping mall,shopping centre,cineshop', '1557792000', NULL, 0, NULL, '', '1574726400', NULL), (25, '714f4d4fd6ceda7d8837537d2ccde0e8', 'Le Printemps de Marnie', 'Our store principal business is carried out by retail trade. Here people get delivery of goods or other product services. It differs from a convenience store or corner shop in that it will be the main shop for the community rather than a convenient supplement.', '[\"18\",\"22\",\"21\",\"23\"]', '[\"1\",\"6\",\"11\",\"12\",\"16\"]', '[\"fd708e1ecfc422c5b8411150ddfc9c24.jpg\",\"25b69d0acc08ec348f8993e019cc65cd.jpg\",\"7e0fbe2025b33b94cce5660ad502d327.jpg\",\"4bf5417c0c89fe7ccbce6d8852826e6f.jpg\",\"698208a119804374429dcea235f219fa.jpg\",\"b97bd4d66bd2479868229dc1c920fc0e.jpg\"]', 'https://vimeo.com/188840379', 'vimeo', 'international shopping,web shopping', 'Nantes, France', 'yourbusiness@example.com', '+48929485960', 'http://yourcompany.com', '{\"facebook\":\"\",\"twitter\":\"\",\"linkedin\":\"\"}', 1, '47.214805', '-1.554298', 73, 9, 'active', 'shop', '32d56d76f7a9def59cc488ab34d4cc6e.jpg', 'fac9fbd3da90f352062f97a851328a87.jpg', 'shopping internet,online shopping stores,shopping list', '1557792000', NULL, 1, NULL, '', 'admin', NULL), (26, '4d0f4c9d48f91c5b3f94cce5287e742e', 'BODYHIT CLUB NANTES', 'It is a unique lifestyle program designed to achieve every individual member’s respective health and fitness goals. Whether our members are beginners or enthusiasts, every program, product, and experience we offer begins and ends with creating a premier and comfortable atmosphere tailored for their individual and overall success and safety.', '[\"27\",\"35\",\"33\",\"30\"]', '[\"5\",\"6\",\"9\",\"16\"]', '[\"79f3c64201c305e417cccef9388748c7.jpg\",\"088a94f5b37f7e4057992d362ef62c41.jpg\",\"b35c33a9823c7fcd11a70b24d7fa1ff4.jpg\",\"3110a6f80a83e78fc2a69715e4fb39f2.jpg\",\"9840f70df9fba8ac1bb60718609d9c3d.jpg\",\"7f2ce914460df764c3c79ddad51fb983.jpg\"]', 'https://vimeo.com/177130731', 'vimeo', 'gym,local gyms', 'Nantes, France', 'yourbusiness@example.com', '+48929485960', 'http://yourcompany.com', '{\"facebook\":\"\",\"twitter\":\"\",\"linkedin\":\"\"}', 1, '47.217870', '-1.555153', 73, 9, 'active', 'general', '490659db2cfa1dff865d6f7adbca2437.jpg', '0548984f3f63140be258b61af62e0eea.jpg', 'gym membership,fitness club,gym fitness', '1557878400', 1572843600, 0, '', '', 'admin', NULL), (27, '9a73f60883399b1c4fd6ffac30f0be27', 'Affordable Yoga & Fitness', 'It is a unique lifestyle program designed to achieve every individual member’s respective health and fitness goals. Whether our members are beginners or enthusiasts, every program, product, and experience we offer begins and ends with creating a premier and comfortable atmosphere tailored for their individual and overall success and safety.', '[\"27\",\"29\",\"28\",\"33\"]', '[\"5\",\"6\",\"7\",\"16\"]', '[\"6d3cf1dd813c08bbc11f75f1c14a2a99.jpg\",\"c12cd448df731269efca0ddcdfef8892.jpg\",\"bb0ca29faa303d459aa8e663aa95292b.jpg\",\"0af28f79d83fdfb2d5e6d99c1abd494d.jpg\",\"18a13c257165925631fa71d1b3237146.jpg\",\"9e446c40143e691d5f97f90b78f479f8.jpg\"]', 'https://vimeo.com/164921647', 'vimeo', 'gym exercise,gym membership cost', 'Paris, France', 'yourbusiness@example.com', '+48929485960', 'http://yourcompany.com', '{\"facebook\":\"\",\"twitter\":\"\",\"linkedin\":\"\"}', 1, '48.824265', '2.326032', 73, 1, 'active', 'general', 'b2385d7d47be86131f821eda7d30de38.jpg', '74488b78edda84ad09f384217ae493e6.jpg', 'health clubs,gym website,family fitness center', '1557878400', NULL, 0, NULL, '', 'admin', NULL), (28, 'c57b0f8ba9084cb7cdd3d507cf7336e2', 'Au Vrai Normand', 'We are committed to uniting fresh, locally grown produce with farm-raised and wild-caught seafood to make the freshest dishes you’ll find anywhere. Our signature raw bar offers a variety of Rhode Island oysters, crisp cherrystones, littleneck clams, and jumbo shrimp. Our Matunuck Oysters are grown in Potter Pond right off our waterfront patio and many of our herbs and vegetables are grown in our vegetable farm on the north end of the pond.', '[\"1\",\"7\",\"2\"]', '[\"4\",\"11\",\"15\"]', '[\"3d74c4768b911cc17f8220f9301107e7.jpg\",\"50126c8509a9a0842b293dda0af0d509.jpg\",\"c8e474c2e1617f95b8c28ea1d8006010.jpg\",\"3085db6f40276bcab77f6a03008944e9.jpg\",\"99da4b64695a83f3a6f03eed3fc4bfc9.jpg\",\"c1d572d51267ef92da7888f667967e9a.jpg\"]', 'https://vimeo.com/178439907', 'vimeo', 'brunch buffet,breakfast menu', 'Villers-Bocage, France', 'yourbusiness@example.com', '+48929485960', 'http://yourcompany.com', '{\"facebook\":\"\",\"twitter\":\"\",\"linkedin\":\"\"}', 1, '49.110621', '-0.660500', 73, 9, 'active', 'restaurant', '83b6cf27f6484e3e6dafacefa5eef7e9.jpg', '7830294b89bb53718a9c2e2c0eab5b64.jpg', 'resto ,bar cuisine,formal dining', '1557619200', 1557619200, 0, NULL, '', 'admin', NULL), (29, 'c20ff1f0374d862b19bcbc10abc586f5', 'Beverly Hills Studios Riviera', 'It is a unique lifestyle program designed to achieve every individual member’s respective health and fitness goals. Whether our members are beginners or enthusiasts, every program, product, and experience we offer begins and ends with creating a premier and comfortable atmosphere tailored for their individual and overall success and safety.', '[\"27\",\"34\",\"31\",\"35\"]', '[\"6\",\"9\",\"16\"]', '[\"c78aa4caae13ab203be7d189150ea535.jpg\",\"7880b908d754d39d46205701d685cd19.jpg\",\"67d3651984f06645c2939ff3ffabd07b.jpg\",\"2b181724b414d7e2155e4e16e5a2a689.jpg\",\"4b5935dc96b6d35159b83746c784150e.jpg\",\"5fef242b113a7a4e1b4f01a758e625e7.jpg\",\"42ae576aece17f17a72f806d2f377c5b.jpg\"]', 'https://vimeo.com/177130731', 'vimeo', 'club gym,fitness step,fitness trainers', 'Nice, France', 'yourbusiness@example.com', '+48929485960', 'http://yourcompany.com', '{\"facebook\":\"\",\"twitter\":\"\",\"linkedin\":\"\"}', 1, '43.700286', '7.270635', 73, 3, 'active', 'general', 'c4c8a7a043df81915ee674580e4cbb5a.jpg', '7a746ff17320e67c55855341f0b15300.jpg', 'athletic center,local fitness centers,the fitness club', '1557878400', 1566259200, 0, '', '', 'admin', NULL), (30, '33cff7ebe32ee90fd2e2d32977ea8592', 'Le Celtic', 'We are committed to uniting fresh, locally grown produce with farm-raised and wild-caught seafood to make the freshest dishes you’ll find anywhere. Our signature raw bar offers a variety of Rhode Island oysters, crisp cherrystones, littleneck clams, and jumbo shrimp. Our Matunuck Oysters are grown in Potter Pond right off our waterfront patio and many of our herbs and vegetables are grown in our vegetable farm on the north end of the pond.', '[\"9\",\"5\",\"1\"]', '[\"7\",\"14\",\"15\"]', '[\"aa45f4387e3e44caaabd12b3de4d9faa.jpg\",\"d3f7ff5db36159ca3e8a2d7ec09c670f.jpg\",\"4e138bec5f0320ebe8b231734d0c5b55.jpg\",\"1c9b8fab15df27d5d70be2bb5cc64568.jpg\",\"e6884190fb371141dd4c6659372cfac4.jpg\"]', 'https://vimeo.com/178439907', 'vimeo', 'romantic dinner,american cuisine', 'Alençon, France', 'yourbusiness@example.com', '+48929485960', 'http://yourcompany.com', '{\"facebook\":\"\",\"twitter\":\"\",\"linkedin\":\"\"}', 1, '48.430913', '0.083520', 73, 4, 'active', 'restaurant', '7dd0022ddbf38852db21fb3cfc3e85a0.jpg', '2ad3c7cc184f2c70265ab0ede99a6d34.jpg', 'bar menu,fine dining,romantic meal ideas', '1557619200', 1557619200, 0, NULL, '', 'admin', NULL), (31, '778d2c424c74a89c2d95f14cde52830c', 'The Beauty Shop', 'The Beauty Shop was created on October 2, 2011 by Gaëlle. The concept is simple, as indicated by its slogan "Esthetics and tasteful music".\r\n\r\nIt is a beauty salon where we find all the classic services, but in a totally different atmosphere. Here we are pampered, we talk, we get acquainted by listening to good music, mainly rock'n'roll and all this in a frame straight out of the 50s! Why? Because Gaëlle likes it and wants to share it with her clients! She will relax, take care of your body, your hands, your feet, your face and comfort you with your heartaches! Joana accompanies him in this beautiful adventure! ', '[\"37\",\"42\",\"43\",\"44\",\"38\"]', '[\"3\",\"4\",\"5\",\"6\",\"8\",\"16\"]', '[\"1d371722fcbf9626d9e38beca3f4335c.jpg\",\"5a8d69eff0fb05de82e4865db6a3119a.jpg\",\"7c2e376f157a770b4ce6a73dad07ad5e.jpg\",\"cfa4fdfde6c56577cfbbe63028b946fb.jpg\",\"0a05afcd81e8d503a90a65c6041885b8.jpg\",\"653713c1fb995c7d8edd3fdd791f3512.jpg\"]', 'https://vimeo.com/32195486', 'vimeo', 'Beauty salon,Spa,Massage,Nail treatment ', 'Lyon, France', 'yourbusiness@example.com', '+48929485960', 'http://yourcompany.com', '{\"facebook\":\"\",\"twitter\":\"\",\"linkedin\":\"\"}', 2, '45.773751', '4.856175', 73, 2, 'active', 'beauty', '0ffcd6e989a5d5a5192545fb3b91eedb.jpg', '429b189aa589e7118caf5794389eb92b.jpg', 'Beauty salon,Beauty parlour,Make up,Spa,Nail treatment ', '1566259200', 1566950400, 1, '', '', '1574726400', NULL), (32, 'd04cdfbd8c45d2f7627c6d88db52c779', 'Beauty Clarene Marseille', 'We believe in beauty with a conscience. We have created a shop that offers the highest quality beauty services in a setting that is healthier for the environment, our guests and our staff. It is our goal to exceed your expectations. Come experience a family atmosphere where you come as guests and leave as friends. Our staff is highly trained with diversity in all aspects of Hair, Waxing, and Massage.', '[\"37\",\"43\",\"39\",\"38\",\"41\",\"42\"]', '[\"1\",\"3\",\"6\",\"7\",\"12\",\"16\"]', '[\"2f8701f5d8ce92183db089f4587837be.jpg\",\"0b889d0dd9d31be6d1300b95eb4e550c.jpg\",\"0125cac5caad7118fde0734716dfc507.jpg\",\"511125b432e845a7cd4ee79460f620cf.jpg\",\"0a05afcd81e8d503a90a65c6041885b8.jpg\",\"631ea11496bb2bcad5994dc72647002a.jpg\",\"9aa64f141e61d0abf50e7b02694bdda0.jpg\"]', 'https://vimeo.com/220346904', 'vimeo', 'beauty,salon,spa,hair salon', 'Marseille, France', 'yourbusiness@example.com', '+4892948560', 'http://yourcompany.com', '{\"facebook\":\"\",\"twitter\":\"\",\"linkedin\":\"\"}', 1, '43.287986', '5.365483', 73, 4, 'active', 'beauty', 'dfe0d5caea1fa7711864881191cb9f5f.jpg', '1ee6206e78fcf65ac56aa78530fcaebf.jpg', 'Beauty salon,Skin treatments,spa,Make up', '1566259200', 1566950400, 0, '', '', 'admin', NULL), (33, '812f5ddc0ca1de97634afc162f255f33', 'Mix Beauty Paris', 'We believe in beauty with a conscience. We have created a shop that offers the highest quality beauty services in a setting that is healthier for the environment, our guests and our staff. It is our goal to exceed your expectations. Come experience a family atmosphere where you come as guests and leave as friends. Our staff is highly trained with diversity in all aspects of Hair, Waxing, and Massage.', '[\"37\",\"38\",\"45\",\"44\",\"40\",\"41\"]', '[\"3\",\"4\",\"5\",\"6\",\"8\",\"16\"]', '[\"a275d50cd3e823e24bbe80b6b5acbc22.jpg\",\"2d206d79098cd3b7dc0938e66fe73f4e.jpg\",\"24a220bfce620bcebe0454a7bef0bdc4.jpg\",\"e0bf63d9e04e09452f5ed39877d1856f.jpg\",\"5c3c303bfec7b3c0a0391fce21e9fb7d.jpg\",\"310e2a76852a709995cde744c8cb6677.jpg\",\"b1b837d6ddd64dc8e9f8aee58982e0af.jpg\"]', 'https://vimeo.com/132032546', 'vimeo', 'salon,spa,manicure,hair', 'Paris, France', 'yourbusiness@example.com', '+4929485960', 'http://yourcompany.com', '{\"facebook\":\"\",\"twitter\":\"\",\"linkedin\":\"\"}', 1, '48.859530', '2.345712', 73, 1, 'active', 'beauty', '7beea46563eec08f16fa1d56b7ac1026.jpg', 'c243e0c6dc04383d8e214d1889a4ea8d.jpg', 'Hair styling ,Barber,Manicure,Spa treatments', '1566259200', 1566950400, 1, '', '', 'admin', NULL), (34, '1295fd64d32d7f39683fa9a0e476a72e', 'Sorong Coiffure barber man', 'We believe in beauty with a conscience. We have created a shop that offers the highest quality beauty services in a setting that is healthier for the environment, our guests and our staff. It is our goal to exceed your expectations. Come experience a family atmosphere where you come as guests and leave as friends. Our staff is highly trained with diversity in all aspects of Hair, Waxing, and Massage.', '[\"37\",\"38\",\"39\",\"41\",\"45\"]', '[\"5\",\"6\",\"7\",\"11\",\"16\"]', '[\"5cafffeddd9f42f18ed3f16e77a27345.jpg\",\"33629b0f95e13abcca41e97cefabab97.jpg\",\"686806e37608ab1ce831fa7bca0c3e66.jpg\",\"e8e4773fb55e26dca56b87f32a0f022a.jpg\",\"7d9e94751eb400ab5c13ce77490169a5.jpg\",\"a1f600cb9729f8bf8554e40fbab156e1.jpg\",\"37ee43fbb88cca2a95c2ff7cb6ebec36.jpg\"]', 'https://vimeo.com/163180524', 'vimeo', 'Hair styling,Barber ,salon', 'Nantes, France', 'yourbusiness@example.com', '+35456467897', 'http://yourcompany.com', '{\"facebook\":\"\",\"twitter\":\"\",\"linkedin\":\"\"}', 1, '47.216451', '-1.551938', 73, 9, 'active', 'beauty', '25f4f72faad60a952eec218b2cd34ea2.jpg', '1c81a9abb4ca5fffcf287f5700864c3b.jpg', 'Hair styling ,Hair cut ,Barber,Hair salon', '1566259200', 1566950400, 0, '', '', 'admin', NULL), (35, '4f9c55236733549020f46ee96da28386', 'Le local_barbershop', 'We believe in beauty with a conscience. We have created a shop that offers the highest quality beauty services in a setting that is healthier for the environment, our guests and our staff. It is our goal to exceed your expectations. Come experience a family atmosphere where you come as guests and leave as friends. Our staff is highly trained with diversity in all aspects of Hair, Waxing, and Massage.', '[\"37\",\"45\",\"38\",\"44\"]', '[\"3\",\"5\",\"6\",\"7\",\"11\",\"16\"]', '[\"f27378a95a7a4a909240e93f1886948c.jpg\",\"45e61c1dfcf8484e5e9ee98d875df917.jpg\",\"0f8840c4e053be1893cb205ac3fa13a4.jpg\",\"29344fa848a8b2863f66eddfd1c4ea02.jpg\",\"05f4b11784e950a6366953a7a0af8baa.jpg\",\"e563d8c12f4b35d8d41e759a24929f35.jpg\"]', 'https://vimeo.com/181714626', 'vimeo', 'salon,hair style,Spa salon', 'Nice, France', 'yourbusiness@example.com', '+48929485960', ' http://yourcompany.com', '{\"facebook\":\"\",\"twitter\":\"\",\"linkedin\":\"\"}', 2, '43.702070', '7.272992', 73, 3, 'pending', 'beauty', '1b77a2761f84fd274a2f17c234710b5b.jpg', 'c6a0d2b67354d7eddd325d980c62a9f2.jpg', 'Barbershop,Beauty salon,Hair salon,Hairdresser ', '1566432000', 1566950400, 1, '', '', '1574726400', NULL); -- -------------------------------------------------------- -- -- Table structure for table `order` -- DROP TABLE IF EXISTS `order`; CREATE TABLE `order` ( `id` int(11) UNSIGNED NOT NULL, `code` varchar(255) DEFAULT NULL, `user_id` int(11) DEFAULT NULL, `listing_id` int(11) DEFAULT NULL, `listing_owner_id` int(11) DEFAULT NULL, `customer_name` varchar(255) DEFAULT NULL, `delivery_address` longtext, `delivery_contact` longtext, `note` longtext, `delivery_status` varchar(255) DEFAULT NULL, `payment_status` varchar(255) DEFAULT NULL, `total_amount` varchar(255) DEFAULT NULL, `order_placed_at` int(11) DEFAULT NULL, `order_delivered_at` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `order` -- INSERT INTO `order` (`id`, `code`, `user_id`, `listing_id`, `listing_owner_id`, `customer_name`, `delivery_address`, `delivery_contact`, `note`, `delivery_status`, `payment_status`, `total_amount`, `order_placed_at`, `order_delivered_at`) VALUES (1, 'gQpdwUsk0LPNxRu', 2, 6, 1, 'John Roic', 'Road-39, street-2, New York', '44565465465', 'Please deliver the product as soon as possible.', 'delivered', 'paid', '1500', 1596240000, 1596326400), (2, 'shpI2wdUg0qQCNR', 2, 25, 1, 'John Roec', 'Home 930, Road-10, New York', '44548654684', 'Please deliver my products as soon as possible.', 'pending', 'pending', '108', 1596326400, NULL), (3, '3f75mkY4HJuAQUb', 2, 25, 1, 'John Son', 'Home-04, Road-2, New York.', '768768754565', '', 'pending', 'pending', '27', 1596326400, NULL), (4, 'np6jhRsQUreboG1', 2, 25, 1, 'Thomson', 'Avenue 30, New York', '44778945369', '', 'pending', 'pending', '31', 1596326400, NULL); -- -------------------------------------------------------- -- -- Table structure for table `order_details` -- DROP TABLE IF EXISTS `order_details`; CREATE TABLE `order_details` ( `id` int(11) UNSIGNED NOT NULL, `code` varchar(255) DEFAULT NULL, `inventory_id` int(11) DEFAULT NULL, `quantity` int(11) DEFAULT NULL, `total_amount` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `order_details` -- INSERT INTO `order_details` (`id`, `code`, `inventory_id`, `quantity`, `total_amount`) VALUES (1, 'gQpdwUsk0LPNxRu', 2, 1, '1500'), (2, 'shpI2wdUg0qQCNR', 5, 1, '80'), (3, 'shpI2wdUg0qQCNR', 18, 1, '8'), (4, 'shpI2wdUg0qQCNR', 19, 1, '7'), (5, 'shpI2wdUg0qQCNR', 25, 1, '7'), (6, 'shpI2wdUg0qQCNR', 21, 1, '6'), (7, '3f75mkY4HJuAQUb', 22, 1, '5'), (8, '3f75mkY4HJuAQUb', 21, 1, '6'), (9, '3f75mkY4HJuAQUb', 19, 1, '7'), (10, '3f75mkY4HJuAQUb', 23, 1, '9'), (11, 'np6jhRsQUreboG1', 25, 1, '7'), (12, 'np6jhRsQUreboG1', 24, 1, '8'), (13, 'np6jhRsQUreboG1', 20, 1, '8'), (14, 'np6jhRsQUreboG1', 18, 1, '8'); -- -------------------------------------------------------- -- -- Table structure for table `package` -- DROP TABLE IF EXISTS `package`; CREATE TABLE `package` ( `id` int(11) NOT NULL, `name` longtext COLLATE utf8_unicode_ci, `price` int(11) DEFAULT NULL, `validity` int(11) NOT NULL DEFAULT '0' COMMENT 'validity should be in days', `ability_to_add_video` int(11) NOT NULL DEFAULT '0', `ability_to_add_contact_form` int(11) NOT NULL DEFAULT '0', `number_of_photos` int(11) NOT NULL DEFAULT '0', `number_of_tags` int(11) NOT NULL DEFAULT '0', `number_of_categories` int(11) NOT NULL DEFAULT '0', `is_recommended` int(11) NOT NULL DEFAULT '0', `package_type` int(11) NOT NULL DEFAULT '0', `number_of_listings` int(11) NOT NULL DEFAULT '0', `featured` int(11) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `package` -- INSERT INTO `package` (`id`, `name`, `price`, `validity`, `ability_to_add_video`, `ability_to_add_contact_form`, `number_of_photos`, `number_of_tags`, `number_of_categories`, `is_recommended`, `package_type`, `number_of_listings`, `featured`) VALUES (1, 'Free', 0, 10, 0, 0, 4, 7, 4, 0, 0, 2, 0), (2, 'Premium', 65, 60, 1, 1, 8, 10, 5, 1, 1, 8, 1), (3, 'Ultimate', 95, 90, 1, 1, 12, 20, 10, 0, 1, 15, 1); -- -------------------------------------------------------- -- -- Table structure for table `package_purchased_history` -- DROP TABLE IF EXISTS `package_purchased_history`; CREATE TABLE `package_purchased_history` ( `id` int(11) NOT NULL, `package_id` int(11) DEFAULT NULL, `user_id` int(11) DEFAULT NULL, `expired_date` int(11) DEFAULT NULL, `amount_paid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `purchase_date` int(11) DEFAULT NULL, `payment_method` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `package_purchased_history` -- INSERT INTO `package_purchased_history` (`id`, `package_id`, `user_id`, `expired_date`, `amount_paid`, `purchase_date`, `payment_method`) VALUES (1, 3, 2, 1560470400, '95', 1557878400, 'stripe'), (2, 1, 2, 1562803200, '0', 1561939200, 'free'), (3, 1, 2, 1562803200, '0', 1561939200, 'free'), (4, 2, 2, 1567123200, '65', 1561939200, 'paypal'), (5, 3, 2, 1574726400, '95', 1566950400, 'stripe'); -- -------------------------------------------------------- -- -- Table structure for table `product_details` -- DROP TABLE IF EXISTS `product_details`; CREATE TABLE `product_details` ( `id` int(11) NOT NULL, `listing_id` int(11) DEFAULT NULL, `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `variant` longtext COLLATE utf8_unicode_ci, `price` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `photo` longtext COLLATE utf8_unicode_ci ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `product_details` -- INSERT INTO `product_details` (`id`, `listing_id`, `name`, `variant`, `price`, `photo`) VALUES (1, 3, 'Smart Watch', 'Fashion Sports Band,CF18,Black', '59', 'bf03287bef8a3016daae9ffeb01f1a9d.jpg'), (3, 3, 'ECCO Men\'s St1 Sneaker', 'Medium,White Perforated,Black/Black Perforated', '99', '8cba2b7107eb6c5342b65dbd713f4669.jpg'), (4, 7, 'Erigaray Classic Fedora Straw Hat', 'Medium,Large,Brown,Black,Red', '55', 'e2fbb6150378084692a342894e7b49d4.jpg'), (5, 7, 'Women High Heel Sandals', 'Black,Gold,Large', '100', '91f13737f14cc747d5ada666d1002c08.jpg'), (6, 21, 'Waterproof Quartz Analog Watch', 'Black Red,Blue Black,Gold Black', '79', 'bf03287bef8a3016daae9ffeb01f1a9d.jpg'), (7, 21, 'Party Solid Color Shoes', 'Hot Pink,Gold,Silver', '89', '91f13737f14cc747d5ada666d1002c08.jpg'), (8, 24, 'DC Men\'s Court Graffik Skate Shoe', 'Black/Lime,Navy White,Dark Blue,Medium', '69', '8cba2b7107eb6c5342b65dbd713f4669.jpg'), (9, 24, 'Headshion Skull Cap', 'Black & Gray,Unisex,Multipurpose Headwear', '50', 'e2fbb6150378084692a342894e7b49d4.jpg'), (10, 25, 'Sam Edelman Women\'s Ariella Heeled Sandal', 'Tangelo Patent,Bright White Leather,Candy Red,Medium,Small', '150', '91f13737f14cc747d5ada666d1002c08.jpg'), (11, 25, 'Fitness Tracker Watch', 'Rosegold,Steelblack,Steelblue,Water Resistant:', '89', 'bf03287bef8a3016daae9ffeb01f1a9d.jpg'); -- -------------------------------------------------------- -- -- Table structure for table `reported_listing` -- DROP TABLE IF EXISTS `reported_listing`; CREATE TABLE `reported_listing` ( `id` int(11) NOT NULL, `listing_id` int(11) NOT NULL DEFAULT '0', `reporter_id` int(11) NOT NULL DEFAULT '0', `report` longtext COLLATE utf8_unicode_ci, `status` int(11) NOT NULL DEFAULT '0', `date_added` int(11) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `review` -- DROP TABLE IF EXISTS `review`; CREATE TABLE `review` ( `review_id` int(11) NOT NULL, `listing_id` int(11) DEFAULT NULL, `reviewer_id` int(11) DEFAULT NULL, `review_comment` longtext COLLATE utf8_unicode_ci, `review_rating` int(11) DEFAULT NULL, `timestamp` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `review` -- INSERT INTO `review` (`review_id`, `listing_id`, `reviewer_id`, `review_comment`, `review_rating`, `timestamp`) VALUES (1, 1, 2, 'This is an extremely beautiful place to enjoy with family and friends', 5, 1557705600), (2, 1, 2, ' The staff is welcoming and very jovial! The dishes are very good. Good value for money!', 5, 1557878400), (3, 1, 2, 'Staff really very welcoming, meal and service well done even at times when the restaurant is crowded. Very good management.', 5, 1557878400), (4, 6, 2, 'Beautiful room, comfortable bed, excellent location, great breakfast, the owner is the perfect host, parking provided for the car, soft towels, good quality sheets, complimentary water, charming hotel.', 5, 1557878400), (5, 6, 2, 'Beautiful, elegant rooms. Fabulous wooden beams. Very comfortable, clean and spacious. High ceilings. Great bathroom. Gated off-street parking. Perfectly positioned to wander into the old town centre on foot. Everything you want to see within easy walking distance. Expensive but worth the price.', 5, 1557878400), (6, 7, 2, 'Every time I visit Paris, I go to Galerie Vivienne. The wine shop, the Bistro, and the bookstore are amazing, and the Consignment clothing stores are fantastic. The architecture is beautiful!', 5, 1557878400); -- -------------------------------------------------------- -- -- Table structure for table `review_wise_quality` -- DROP TABLE IF EXISTS `review_wise_quality`; CREATE TABLE `review_wise_quality` ( `id` int(11) NOT NULL, `rating_from` float DEFAULT NULL, `rating_to` float DEFAULT NULL, `quality` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `review_wise_quality` -- INSERT INTO `review_wise_quality` (`id`, `rating_from`, `rating_to`, `quality`) VALUES (1, 1, 1.5, 'Bad!!'), (2, 1.6, 2.8, 'Not Bad'), (3, 2.9, 3.4, 'So So'), (4, 3.5, 4.5, 'Good'), (5, 4.6, 5, 'Awesome'); -- -------------------------------------------------------- -- -- Table structure for table `role` -- DROP TABLE IF EXISTS `role`; CREATE TABLE `role` ( `id` int(11) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `role` -- INSERT INTO `role` (`id`, `name`) VALUES (1, 'Admin'), (2, 'User'); -- -------------------------------------------------------- -- -- Table structure for table `settings` -- DROP TABLE IF EXISTS `settings`; CREATE TABLE `settings` ( `id` int(11) NOT NULL, `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `description` longtext COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `settings` -- INSERT INTO `settings` (`id`, `type`, `description`) VALUES (1, 'website_title', 'Atlas Business Directory Listing'), (2, 'system_title', 'ATLAS Directory Listing CMS'), (4, 'system_email', 'company@example.com'), (5, 'address', 'New York'), (6, 'phone', '1234567890'), (7, 'vat_percentage', ''), (8, 'country_id', '5'), (9, 'text_align', ''), (10, 'currency_position', 'left'), (11, 'language', 'english'), (12, 'purchase_code', 'your-purchase-code'), (13, 'timezone', 'Africa/Abidjan'), (14, 'paypal', '[{\"active\":\"1\",\"mode\":\"sandbox\",\"sandbox_client_id\":\"AfGaziKslex-scLAyYdDYXNFaz2aL5qGau-SbDgE_D2E80D3AFauLagP8e0kCq9au7W4IasmFbirUUYc\",\"production_client_id\":\"12345\",\"sandbox_secret_key\":\"EMa5pCTuOpmHkhHaCGibGhVUcKg0yt5-C3CzJw-OWJCzaXXzTlyD17SICob_BkfM_0Nlk7TWnN42cbGz\",\"production_secret_key\":\"12345\"}]'), (15, 'stripe', '[{\"active\":\"1\",\"testmode\":\"on\",\"public_key\":\"pk_test_LnMXAA8Rox0ITcpDgkIjbcR600u09yZlhQ\",\"secret_key\":\"sk_test_9iN1igv6l9R5tolcyZLrIgMP00rcDJMVnJ\",\"public_live_key\":\"pk_live_xxxxxxxxxxxxxxxxxxxxxxxx\",\"secret_live_key\":\"sk_live_xxxxxxxxxxxxxxxxxxxxxxxx\"}]'), (18, 'system_currency', 'USD'), (19, 'paypal_currency', 'USD'), (20, 'stripe_currency', 'USD'), (21, 'youtube_api_key', ''), (22, 'vimeo_api_key', ''), (23, 'protocol', 'sendmail'), (24, 'smtp_host', 'ssl://smtp.googlemail.com'), (25, 'smtp_port', '465'), (26, 'smtp_user', ''), (27, 'smtp_pass', ''), (28, 'social_links', '{\"facebook\":\"\",\"twitter\":\"\",\"linkedin\":\"\"}'), (29, 'about', ''), (30, 'term_and_condition', ''), (31, 'privacy_policy', ''), (32, 'faq', ''), (35, 'version', '2.12'), (36, 'footer_text', 'Creativeitem'), (37, 'footer_link', 'http://creativeitem.com/'), (38, 'meta_keyword', ''), (39, 'meta_description', ''), (40, 'map_access_token', 'pk.eyJ1IjoicG9sbG9idGVzdGluZ3I3IiwiYSI6ImNrZmwybHFmYjFrdHoyeXMybDdxNjgxaWYifQ.Gp_boLx9d0F6eM4ju6phiQ'), (41, 'max_zoom_level', '18'), (42, 'min_zoom_listings_page', '2'), (43, 'min_zoom_directory_page', '2'), (44, 'default_location', '40.706486, -74.014700'), (45, 'recaptcha_sitekey', '6Lc1CLkZAAAAAOn-7yL8gi9UWZjrwcwe1TCYY7-Q'), (46, 'recaptcha_secretkey', '6Lc1CLkZAAAAAClCBZEclEMENVIOn3zUizq6W11z'), (47, 'active_map', 'openstreetmap'), (48, 'recaptcha_status', '0'), (49, 'meta_pixel', '0'); -- -------------------------------------------------------- -- -- Table structure for table `shopping_cart` -- DROP TABLE IF EXISTS `shopping_cart`; CREATE TABLE `shopping_cart` ( `id` int(11) UNSIGNED NOT NULL, `user_id` int(11) DEFAULT NULL, `listing_id` int(11) DEFAULT NULL, `inventory_id` int(11) DEFAULT NULL, `quantity` int(11) DEFAULT NULL, `price` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `shopping_cart` -- INSERT INTO `shopping_cart` (`id`, `user_id`, `listing_id`, `inventory_id`, `quantity`, `price`) VALUES (5, 2, 3, 1, 1, '1'), (17, 2, 6, 9, 1, '100'); -- -------------------------------------------------------- -- -- Table structure for table `state` -- DROP TABLE IF EXISTS `state`; CREATE TABLE `state` ( `id` int(11) UNSIGNED NOT NULL, `name` varchar(255) DEFAULT NULL, `slug` varchar(255) DEFAULT NULL, `country_id` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `time_configuration` -- DROP TABLE IF EXISTS `time_configuration`; CREATE TABLE `time_configuration` ( `id` int(11) UNSIGNED NOT NULL, `listing_id` int(11) DEFAULT NULL, `saturday` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `sunday` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `monday` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `tuesday` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `wednesday` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `thursday` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `friday` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `time_configuration` -- INSERT INTO `time_configuration` (`id`, `listing_id`, `saturday`, `sunday`, `monday`, `tuesday`, `wednesday`, `thursday`, `friday`) VALUES (1, 1, '5-22', '2-17', '11-15', 'closed-closed', 'closed-closed', 'closed-closed', 'closed-closed'), (2, 2, '14-22', 'closed-closed', '14-22', '15-22', '15-22', '15-22', '15-22'), (3, 3, 'closed-closed', '11-21', '11-21', '15-21', '15-21', '17-20', '17-20'), (4, 4, '9-19', '8-19', '8-20', '10-20', '10-20', '10-20', '10-20'), (5, 5, '9-20', 'closed-closed', '9-20', '11-9', '11-21', '11-21', '11-21'), (6, 6, '14-22', '14-21', '16-21', '16-22', '16-22', '14-23', '18-23'), (7, 7, '10-23', '10-22', '19-22', '19-21', '15-21', '15-23', '15-23'), (8, 8, '14-21', '18-23', '15-21', '15-20', '15-23', '16-22', '17-22'), (9, 9, 'closed-closed', '11-17', '10-18', '8-18', '9-20', '8-20', '9-20'), (10, 10, '8-22', '12-20', '12-20', '11-22', '8-21', '9-20', '9-22'), (11, 11, 'closed-closed', '7-23', '8-23', '8-22', '7-22', '7-23', '7-23'), (12, 12, '6-23', '6-0', '8-23', '7-22', '7-22', '8-22', '7-22'), (13, 13, '7-21', '7-22', '8-23', '8-23', '7-23', '7-23', '8-23'), (14, 14, '7-23', '7-23', '8-23', '8-23', '7-23', '7-22', '8-22'), (15, 15, '7-23', '7-23', '9-22', '8-22', '8-22', '9-22', 'closed-closed'), (16, 16, '8-23', '8-22', '7-23', '7-22', '8-23', '8-21', '8-23'), (17, 17, '7-22', '7-22', '8-23', '8-23', 'closed-closed', '9-22', '8-22'), (18, 18, '7-21', '7-22', '8-0', '8-21', '8-21', 'closed-closed', '9-22'), (19, 19, '7-23', '8-22', '8-22', 'closed-closed', '9-22', '9-22', '9-22'), (20, 20, '7-21', '7-23', '8-22', '8-22', '8-23', '8-22', '9-23'), (21, 21, 'closed-closed', 'closed-closed', 'closed-closed', 'closed-closed', 'closed-closed', 'closed-closed', 'closed-closed'), (22, 21, 'closed-closed', 'closed-closed', 'closed-closed', 'closed-closed', 'closed-closed', 'closed-closed', 'closed-closed'), (23, 22, '8-23', 'closed-closed', '8-21', '8-22', '8-23', '9-20', '9-22'), (24, 23, '8-22', '9-22', '9-21', 'closed-closed', '11-23', '11-22', '10-23'), (25, 24, '9-22', '9-23', '8-21', '8-22', '9-22', '9-22', '9-23'), (26, 25, '9-20', '9-22', '11-20', '9-20', 'closed-closed', '11-21', '11-23'), (27, 26, '12-21', 'closed-closed', '11-22', '12-20', '11-21', '11-22', '10-21'), (28, 27, '13-21', '12-21', '11-22', '14-22', '9-23', '11-22', '12-23'), (29, 28, '11-21', '10-21', '10-21', '12-21', '11-21', '10-22', '12-23'), (30, 29, '14-22', '15-23', '12-22', '12-21', '15-22', '14-23', '14-23'), (31, 30, '10-22', '14-21', '12-21', '12-20', '12-20', '14-23', '14-22'), (32, 31, '9-19', '9-closed', '9-21', '9-21', '9-21', '9-21', '9-21'), (33, 32, '9-19', 'closed-closed', '9-20', '9-20', '9-20', '9-20', '9-20'), (34, 33, 'closed-closed', '10-21', '10-21', '10-21', '10-21', '9-21', '9-20'), (35, 34, '9-20', '9-20', '9-20', '9-20', '9-20', '9-20', '9-20'), (36, 35, '8-21', 'closed-closed', '9-21', '9-19', '9-19', '9-19', '9-19'); -- -------------------------------------------------------- -- -- Table structure for table `user` -- DROP TABLE IF EXISTS `user`; CREATE TABLE `user` ( `id` int(11) NOT NULL, `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT '', `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT '', `address` longtext COLLATE utf8_unicode_ci, `phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT '', `website` varchar(255) COLLATE utf8_unicode_ci DEFAULT '', `social` longtext COLLATE utf8_unicode_ci, `about` longtext COLLATE utf8_unicode_ci, `password` varchar(255) COLLATE utf8_unicode_ci DEFAULT '', `role_id` int(11) DEFAULT NULL, `wishlists` longtext COLLATE utf8_unicode_ci, `verification_code` longtext COLLATE utf8_unicode_ci, `is_verified` int(11) NOT NULL DEFAULT '0', `updated_date` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `meta_pixel` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `user` -- INSERT INTO `user` (`id`, `name`, `email`, `address`, `phone`, `website`, `social`, `about`, `password`, `role_id`, `wishlists`, `verification_code`, `is_verified`, `updated_date`, `meta_pixel`) VALUES (1, 'John Doe', 'admin@example.com', '', '', NULL, '{\"facebook\":\"\",\"twitter\":\"\",\"linkedin\":\"\"}', NULL, '7110eda4d09e062aa5e4a390b0a572ac0d2c0220', 1, '[]', NULL, 1, NULL, NULL), (2, 'Jane Roie', 'user@example.com', 'Sydney, Australia', '+284782745', NULL, '{\"facebook\":null,\"twitter\":null,\"linkedin\":null}', NULL, '7110eda4d09e062aa5e4a390b0a572ac0d2c0220', 2, '[\"4\",\"24\",\"21\",\"25\",\"26\",\"30\",\"12\",\"15\"]', '3dff0ecad9c0adb0f30d51773eff4a7f', 1, NULL, NULL), (3, 'John Fuice', 'user2@example.com', 'Sydney, Australia', '284782745677', NULL, '{\"facebook\":null,\"twitter\":null,\"linkedin\":null}', NULL, '7110eda4d09e062aa5e4a390b0a572ac0d2c0220', 2, '[]', '729aa8ea6bd57f0d1645cca4e1955e9b', 1, NULL, NULL); -- -- Indexes for dumped tables -- -- -- Indexes for table `addons` -- ALTER TABLE `addons` ADD PRIMARY KEY (`id`); -- -- Indexes for table `amenities` -- ALTER TABLE `amenities` ADD PRIMARY KEY (`id`); -- -- Indexes for table `beauty_service` -- ALTER TABLE `beauty_service` ADD PRIMARY KEY (`id`); -- -- Indexes for table `blogs` -- ALTER TABLE `blogs` ADD PRIMARY KEY (`id`); -- -- Indexes for table `blog_comments` -- ALTER TABLE `blog_comments` ADD PRIMARY KEY (`id`); -- -- Indexes for table `booking` -- ALTER TABLE `booking` ADD PRIMARY KEY (`id`); -- -- Indexes for table `category` -- ALTER TABLE `category` ADD PRIMARY KEY (`id`); -- -- Indexes for table `city` -- ALTER TABLE `city` ADD PRIMARY KEY (`id`); -- -- Indexes for table `claimed_listing` -- ALTER TABLE `claimed_listing` ADD PRIMARY KEY (`id`); -- -- Indexes for table `comment` -- ALTER TABLE `comment` ADD PRIMARY KEY (`id`); -- -- Indexes for table `country` -- ALTER TABLE `country` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `code` (`code`); -- -- Indexes for table `currency` -- ALTER TABLE `currency` ADD PRIMARY KEY (`id`); -- -- Indexes for table `facebook_messenger` -- ALTER TABLE `facebook_messenger` ADD PRIMARY KEY (`id`); -- -- Indexes for table `food_menu` -- ALTER TABLE `food_menu` ADD PRIMARY KEY (`id`); -- -- Indexes for table `frontend_settings` -- ALTER TABLE `frontend_settings` ADD PRIMARY KEY (`id`); -- -- Indexes for table `hotel_room_specification` -- ALTER TABLE `hotel_room_specification` ADD PRIMARY KEY (`id`); -- -- Indexes for table `inventory` -- ALTER TABLE `inventory` ADD PRIMARY KEY (`id`); -- -- Indexes for table `inventory_category` -- ALTER TABLE `inventory_category` ADD PRIMARY KEY (`id`); -- -- Indexes for table `listing` -- ALTER TABLE `listing` ADD PRIMARY KEY (`id`); -- -- Indexes for table `order` -- ALTER TABLE `order` ADD PRIMARY KEY (`id`); -- -- Indexes for table `order_details` -- ALTER TABLE `order_details` ADD PRIMARY KEY (`id`); -- -- Indexes for table `package` -- ALTER TABLE `package` ADD PRIMARY KEY (`id`); -- -- Indexes for table `package_purchased_history` -- ALTER TABLE `package_purchased_history` ADD PRIMARY KEY (`id`); -- -- Indexes for table `product_details` -- ALTER TABLE `product_details` ADD PRIMARY KEY (`id`); -- -- Indexes for table `reported_listing` -- ALTER TABLE `reported_listing` ADD PRIMARY KEY (`id`); -- -- Indexes for table `review` -- ALTER TABLE `review` ADD PRIMARY KEY (`review_id`); -- -- Indexes for table `review_wise_quality` -- ALTER TABLE `review_wise_quality` ADD PRIMARY KEY (`id`); -- -- Indexes for table `role` -- ALTER TABLE `role` ADD PRIMARY KEY (`id`); -- -- Indexes for table `settings` -- ALTER TABLE `settings` ADD PRIMARY KEY (`id`); -- -- Indexes for table `shopping_cart` -- ALTER TABLE `shopping_cart` ADD PRIMARY KEY (`id`); -- -- Indexes for table `state` -- ALTER TABLE `state` ADD PRIMARY KEY (`id`); -- -- Indexes for table `time_configuration` -- ALTER TABLE `time_configuration` ADD PRIMARY KEY (`id`); -- -- Indexes for table `user` -- ALTER TABLE `user` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `addons` -- ALTER TABLE `addons` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `amenities` -- ALTER TABLE `amenities` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17; -- -- AUTO_INCREMENT for table `beauty_service` -- ALTER TABLE `beauty_service` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18; -- -- AUTO_INCREMENT for table `blogs` -- ALTER TABLE `blogs` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `blog_comments` -- ALTER TABLE `blog_comments` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16; -- -- AUTO_INCREMENT for table `booking` -- ALTER TABLE `booking` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `category` -- ALTER TABLE `category` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=46; -- -- AUTO_INCREMENT for table `city` -- ALTER TABLE `city` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `claimed_listing` -- ALTER TABLE `claimed_listing` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `comment` -- ALTER TABLE `comment` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `country` -- ALTER TABLE `country` MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=242; -- -- AUTO_INCREMENT for table `currency` -- ALTER TABLE `currency` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=113; -- -- AUTO_INCREMENT for table `facebook_messenger` -- ALTER TABLE `facebook_messenger` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36; -- -- AUTO_INCREMENT for table `food_menu` -- ALTER TABLE `food_menu` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22; -- -- AUTO_INCREMENT for table `frontend_settings` -- ALTER TABLE `frontend_settings` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- AUTO_INCREMENT for table `hotel_room_specification` -- ALTER TABLE `hotel_room_specification` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21; -- -- AUTO_INCREMENT for table `inventory` -- ALTER TABLE `inventory` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26; -- -- AUTO_INCREMENT for table `inventory_category` -- ALTER TABLE `inventory_category` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20; -- -- AUTO_INCREMENT for table `listing` -- ALTER TABLE `listing` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36; -- -- AUTO_INCREMENT for table `order` -- ALTER TABLE `order` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `order_details` -- ALTER TABLE `order_details` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15; -- -- AUTO_INCREMENT for table `package` -- ALTER TABLE `package` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `package_purchased_history` -- ALTER TABLE `package_purchased_history` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `product_details` -- ALTER TABLE `product_details` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12; -- -- AUTO_INCREMENT for table `reported_listing` -- ALTER TABLE `reported_listing` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `review` -- ALTER TABLE `review` MODIFY `review_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `review_wise_quality` -- ALTER TABLE `review_wise_quality` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `role` -- ALTER TABLE `role` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `settings` -- ALTER TABLE `settings` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=50; -- -- AUTO_INCREMENT for table `shopping_cart` -- ALTER TABLE `shopping_cart` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37; -- -- AUTO_INCREMENT for table `state` -- ALTER TABLE `state` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `time_configuration` -- ALTER TABLE `time_configuration` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37; -- -- AUTO_INCREMENT for table `user` -- ALTER TABLE `user` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; COMMIT; /*!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 */;
![\"The](\"https://lh6.googleusercontent.com/Kq3gzifn3yjnQe4jpV64nh5TWIFLLY_2ayXMJxaA4TNkruaCAPrhe9QOS_Au_tsHp2Y70MKgmzjYbEKCCzGuIPS8Dxxg7KCGxqBl-TXsoOqBHHTPvKZQVNDKqlC-dP6zWmZWXtY\")
![\"A](\"https://lh5.googleusercontent.com/vHY17129B2MtrmWdqdSEyhvutAS59YMmSRwrGJBwxpHFoTBPb842OIg84QDHcTy3v5rDbLz-vziaylYFp2EI_bObRZ3oujggHjIGpOpIb9JbZ67PYo5Ck4b_b-bMHuL9OPkWU2s\")
![\"A](\"https://lh3.googleusercontent.com/woEdXCmaicnJoQ_8snNXAluWf1S8LZ9_m712B6lkoC-XkHSdRNrAgPKiEiH416-cQKFW1pFLxBoY4WioKfSPJzY6e3hRAQuZlIvGmoRzpasY4P3ZGqZvc3Kj1RRLX4u9RpxuKd8\")
![\"Collection](\"https://lh6.googleusercontent.com/K97IkOxK3nWxz4mlIG-ZfqilXAFKwN0AbnSpK5jJscnz_PR2ZFK9K57IxUpqcG4yU72WeCoaGzIlP_YQsFom0YBQ52yYB1tFI6v9MBjFAXKyiRNJ-EpCRBLgqyxGYnbftTHCmR4\")
![\"A](\"https://lh6.googleusercontent.com/Iujz3wQAcLUjdrTXFKyh6xrMpTCgbcNRwnX8H_Rjb_nqzmPYp7DlJYcf9JLWbBztg_heYCzQrRfGAf0ell4dhov-2hjj3t1v1pSVHMq9Xh44prHbHZXCk6eXdcuZOJmMWgdxAYE\")
![\"A](\"https://lh5.googleusercontent.com/iRQ1yoEMS5GRQCkfO9AMHoCqJaGUdeAMzp7AI4WKUiqPqiydDuf_MzeuEAMyPyyjl9BW6SqEE_OA9rHuzbpfvefbMfhVPyQKyywoKoOrke922lykQxfMGpDdoJ4UE_2rtOO_3e0\")
![\"A](\"https://lh4.googleusercontent.com/_SCAu4eM7ZOg3BR_8SLXLqJ7rjFRS7xEPoO-F6SIicS6-rxqEjzP7McedbPM6L3o1yiZc_kZhV5TxjLwlJQFjD1FJlWmcTKLbx6RK3RFcz0dK-cVvooe_oVeGAuWqwnACinPc2w\")
![\"A](\"https://lh5.googleusercontent.com/g30wyRPkqGq3DkeT_m4SmldAvpqFtL4rXFfjvKWQWOxx9-ymegz12BJGQl9tM9nqSbzXKDfu4Zu3fXfNFur3sl2XAvZTvyzLw2zRVyBtY51goE1o7aH8g6pnxFPDaDYebV12eR8\")
![\"A](\"https://lh3.googleusercontent.com/CeeWIOLGz2cssSbF99bjE1ZLVfW_xZyTZVkaBz_R2tRgwZKy9tvZ9FbJNTiAjY4pq8eWJeVTsYWhsCI-LEjZGX3H7OcTqcvb4HZ6oV1bOSNBtQy_1u-64Mvl8aQE1fEIlLQ9Plc\")
![\"A](\"https://lh4.googleusercontent.com/p8IGkb3HA8KZnkjgWMSTFvs5_nbFXYB4iW9uiXnXUP5m0OBlT3fdfkU5vqU3jt2y4v4ryJDADDmBkGrT-G_2o3z1QKYKNbW4tMRlbkBED2_-wYxMVYfUkjgUjIrxkLVaKY5Xkh8\")
![\"A](\"https://lh4.googleusercontent.com/uMYzM5ev_aoY6iN3z6ostY1-cTNfpCPcZPd9oytO2crayXl-pkrrMYyV2XNAgEdvTl9lmvVCdw4j8-U76u9A2fRvLbLRuQLZ8b3JFNttpjr2bIuPJxiRB9dmVSpYGKQn5KAwgUE\")
![\"A](\"https://lh5.googleusercontent.com/i_0SJFhtEjy8pioiEOCWCEMtVUuHQ1k0aZBMON2j_z6VQRECqizeX5ATqzOV7kt4ah-Dxqf-ZeCZnowliAj7dDSMknthK8vizJNFeo-9Nf8GxaxlEIzvrXYgR0i8v0G54_cneyk\")
![](\"https://lh5.googleusercontent.com/zvKInOAG9z6fwkFWcgaRapi-WC3f_loBStKtV0U9U2NaQrgYJQK4-_2bekjtdptuziN-AaQGEYQ82ESs-jkdodmu8qgv-5FVqlh87yJkvzT3DnRKJ5qcpdwZLWHbARmsGRbjlFk\")
![\"European](\"https://lh6.googleusercontent.com/jIjN89kn2PVxuvwMmxJDohssYScfJBrER02tvFtAfsmahSLAkSwPO477i9uhCpwdefNPfV3kZNtvJs3YSOlx5eKFFjci6Gs28e-C1fCZh18ZFxRalG1fXTGStsADRb8fMse1IZQ\")
![\"The](\"https://lh3.googleusercontent.com/l-XQd8Y5TnifWgwaMTCFwyT9guUoFoK_qB3Tu4cLscH2j1q47F2i732e6uY2oLZel24h3kYsbBebf93MeiKfcOk6yikcYCTG4URRXMsByV41qFgE5WZxJt7DvSsNgoH89gcE6KU\")
![\"Red](\"https://lh6.googleusercontent.com/7djvGvm9aFmoJxi7M996O34F9HmR5M-bSkt_ytoMviR-0cT9ytLVMRR9uQcLsLOAa_AdUQOS1bZ3GkytMOs-KC1Pxu1CeJPxsUJT4oulV06a9RCwok3TZBIyYH8eGbzvf_0r7YU\")
![\"Two](\"https://lh6.googleusercontent.com/WZuGCOg-DLKVW5b0qMDiwor9wm9nyMw4miBdtlOPkFx6S7YpdCJf8Vnb6Eq6j_aSN2Mli7dh5xdpaCXYFgWUPBUvmOclzILTBGxoZevkdXsrSJ2Vsq0jDggx97gxFHAHM1aknU0\")
![\"A](\"https://lh3.googleusercontent.com/qzPrHPjSwtaegFpAIQc6JX7hGAEfy4RpwJMdIkdk7NDAnaWx1JVtsHEdXeBbHhxwQawJhIXC4PtHFFqtjSY6YIW95lUENUVijWJnAnpxJj54jXC6gEONZ5bQIpqlAeW1-ckAFaw\")
![\"Hotel](\"https://lh3.googleusercontent.com/mCKav8Hqd2Asygh9MZqmDQM0JLqJRiomzLn7yOyAVh7G8LY1cpRdzaJR0HlpGxj3XLSQUTUfIHaa3D3hKG5PFZ3oXiERJgdfM-wHMTeaNH4XpI-mHImKvvsbKezDvON2KL6MfBY\")
![\"Euro](\"https://lh5.googleusercontent.com/a1MqPP4g22q8ftfESPIKqnb6m78yZMyWRJQhtF-pfniv_XOy8CSZSIteqjP159kV7-IYk9qFPBdrNiIybX4M-4ltqr4pkk76sn0IbLC465hbxqmdOcvlQKIrHNP5tozTMToBqFM\")
![\"Group](\"https://lh3.googleusercontent.com/PE3RrynHj2v2SHBotlKTNtske7lAfddmW8P7jwyLCES0v6yZQoksjvkfS6c3B3WHrR8D2WPF8HWb3oibJsj1shb7UwGV5M0OVcrkE7Qsj-is9z9kgDLhe6K56y5smGPC4iCf-FQ\")
![\"The](\"https://lh5.googleusercontent.com/j53PCPgLpUuORHYDWNRXsDn8a8V4Ooxh0WpbBbiEnYRrKjOUCIS-YUtLGj1XQDBGnb6banxi0AmoUrCUgSrZtqeGfSCZT3h5hprW7p8jwMO8z5G3YLqQbWvp52D5YKeBmjvdrGA\")
![\"Hot](\"https://lh3.googleusercontent.com/jBeC5Zhd5IJbhui7dS6l0y0z3f0D0hVb_wZPCQIA25NpqhMKIVEUlLpYo2xxWy6EPBhXH-QATevzy8e947gy9DBTR7Zq9Yp_Hz4t0g_Sr8EZU0WHP8OgK3my3CfHoqzt5KVk_tg\")
![\"Chesapeake](\"https://lh6.googleusercontent.com/EXiPAzRBwikZ--CHO2IeKULNrYdmDig1PzmYQHhUBeXVQJe0HyJQtkhvghoyFG2GPNZoNAKH04nC0woS-v1nj1jDhCGaaKabF22pWe7hnPdBbRzTDrpN6Hwoy62TfBlxcmTsSXk\")
![\"First](\"https://lh5.googleusercontent.com/gMASptD4gPpNyqrjAm6YF9mx6Z0YjnXyx-IaLCK4Qf4E0jB6opVJH2k-LPcmCAs7fhyNyZHuINatl2ava1i_9XRFXcmceA-vSSbkn3haGAMMDpfNkaKpdwEMqTAJvv3jIp7ROvM\")
![\"places](\"https://lh6.googleusercontent.com/5_U5Q0P9T8QX5PU9j_2oc62VvgYAAT7hJ6_dwnhHu3hkZZUGCFAVnHTg0Yh11xp2Hiv69_7K1nFPp8OTpU62vNSDHMhP6mSRKPefzXVs0ID1pINOuCK5MNPr4kSg7kXRAoMucuE\")
![\"casa](\"https://lh5.googleusercontent.com/gwt0STMuS73QQYNQ5f3fyn5XzCZzqjH0xKw4rsCuVFs9iY_AgWOlHA8BF-BUkvHMsPZnAB27Fcxc9UZ3vndYU-s6ZjQ6PPaX-KppaXfxyygxCucu3ZFhaxKfE75UsMW1CgMcr1U\")
![\"maya](\"https://lh5.googleusercontent.com/xsvFelkKBOfC1mzSpHwgnaMRbHZgJSELlKd3hlAWJZBtChZssLzBfqdPmNf_vpDrdpi5-v0dYCxfhzpfIGwFD6D5OWOw3Y91N8Al_o_LxqdPrj-phCC_GRE6RyR-oK19vkREQTI\")
![\"nayara](\"https://lh6.googleusercontent.com/Kuum-2pekPslR0Yc4paxD0bSrOvCZhTfFGu-YkDn8tR4P7qccoLPbhmHjMplayeQfmmPs8jOOhu8LbbMaYfnQcr6v-T1Plmwwadmcg7KtMOvtQPXLwqcDTHBXMbSv2vMyvnUj4Y\")
![\"grand](\"https://lh4.googleusercontent.com/ksLuPOq6a3rNcwyGlfWmDjPJ9dpu3uX5cc9Nx5muMiEwHha7BA4ZRRTpPgZgp-_LvqRfjD5KgoETmfb71oFMvTbq6m073MfjQCXNxkiEdpY-xKUgJGA3iUh0u4Dsl8pM6KHvwQU\")
![\"uxua](\"https://lh4.googleusercontent.com/joMQSKcFhiAFkG8XRCzZ0FU7E-ZAwf9kTGGIiKQEfnAOo1n_xzloC4ytFxRRP_xfWjW1BurIvFpchHfj5dgori50_Gsy0dFbelJ28eEb23T3eh5RqC_hGWjqiIKPh4_G5E3eLG4\")
![\"casa](\"https://lh4.googleusercontent.com/5odSZ2_rLOzxy7tQwivZ7J6m6ZIk05js-sFVh5iPzx9cuIRiny9FLYQ-0kvdoJjC2vveLCLEvDF4eCFCqEVBPj56BhVEqEmwqc0HNesjWnyhIqKOAXal4aq_n1DGAp1Z7mvAgDk\")
![\"travaasa](\"https://lh3.googleusercontent.com/PRTn4R_V0XWsDQsChjGYhAy_0Ri57rsjfjkAokLLr4WMfQrpb-BO4FCGIZEMYCxxfizBnNbzMtuWEPLAMe6bLu_LQfcl66elTumBnYQI2NO0zlfhVRCTiswDt8DTHQgFnnd3In4\")
![\"emerald](\"https://lh4.googleusercontent.com/Aki2cLqgX7u3qO_j8EQHQpy74edPJ65FdH_ZhE5O0wzOcQpUa6AaBOdKC4YKhwL4aH-BProHuV4kLXa1owEz792IEq9d5YAmK4r8onRS5gVm6Zf84-UYGExlzNVFDbTcj5EiiQg\")
![\"bird](\"https://lh4.googleusercontent.com/XJKxXcbo3KdVPaHputRXy5H3zFUTBomChi0P-B5kAEOWadNGWY8nl9Pru4diScTJ99AFrNS7aVlpXCLZSzxCwAxgbRUH9_6CE1EzIB6ANE7gBhvKwzxTIayR0bd1c7CAAUN2JFQ\")
![\"wolgan](\"https://lh3.googleusercontent.com/bwKUYIypJSjR5_hHd2YRzDHTMddkFfjZLadkGjNvDIplYDiIp0-rTKPksCRuAEFp8VMB6CYB6uUTFPqNbBuyxUvqxXZbsUg3i_ZnxPOjGRfPuGb5b0cZiM4P3QRVD_xvCnc7UdY\")
![\"The](\"https://lh6.googleusercontent.com/cmIO7C89k90TjECvlEAG2bmFvh-r70FlU5N4PnhgQ3s5ayDyuuKoZj-imraClHgatm9xkGcKwXCcsBNwTyJv1ai1yJ8TE6JQrcH0_THg-L5mPkUVrXUk60IilIaEfw1jgjVILi4\")
![\"Autumn](\"https://lh3.googleusercontent.com/VQRp5pWNVmyF_8wknDAOqkXjj3SQQhL6Gm_G6RpBG6jVowRXUcHj67D_CSKyxJGegJIri4vXD3byEHi9u8V-TKf5MFd86CKqYQy0_FlNcsPhOIe8EpxFS0pvDJBtChFT9CDTjvc\")
![\"Fresh](\"https://lh4.googleusercontent.com/nPORx-HXMZYs5Kgs7u3Aotl8kYZaCsM4oma2v015IH75Ur_eH9nqynH0JXctMoaXTuaWn0kQ6yoQWG9if6XJnRxNCvEmeKAGF4rGHkVbCi2RkazlWRDT5noEBnR75yJEtvQtCQY\")
![\"The](\"https://lh4.googleusercontent.com/zz6DqRZoLgaEWP6Rb_u6nz_6AUGjKJYEdsjacT9uV96s1jHIgrDI0qzDgTrHQulM2rAa8sx9xl1UToBoOULpGzu-S1Iae1rl0pj_HSfv53ByGy13d5Hf-6JGGjpmbdknDV50v4E\")
![\"Kayaker](\"https://lh4.googleusercontent.com/wLPXkfo4cVLjszU4pKMLwBnk37Hnx69p33iY0V8clEGr9HarKsOhmBjT2TY42oTM4EnjywxiXv6XxZpGiI_QQ0AiPSBk5D3Js9VmL4428l0y7MA3xcYvR8H7zUTLfPogOCu-Nto\")