-- MySQL dump 10.19 Distrib 10.3.37-MariaDB, for Linux (x86_64) -- -- Host: localhost Database: sapphire_staging -- ------------------------------------------------------ -- Server version 10.3.37-MariaDB-log /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `blogs` -- DROP TABLE IF EXISTS `blogs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `blogs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(191) NOT NULL, `description` text DEFAULT NULL, `thumb` varchar(500) DEFAULT NULL, `author` varchar(100) DEFAULT NULL, `is_active` tinyint(1) NOT NULL DEFAULT 0, `created_by` int(10) unsigned DEFAULT NULL, `updated_by` int(10) unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `publish_date` timestamp NULL DEFAULT NULL, `slug` varchar(200) DEFAULT NULL, `meta_title` text DEFAULT NULL, `meta_description` text DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `blogs` -- LOCK TABLES `blogs` WRITE; /*!40000 ALTER TABLE `blogs` DISABLE KEYS */; INSERT INTO `blogs` (`id`, `title`, `description`, `thumb`, `author`, `is_active`, `created_by`, `updated_by`, `created_at`, `updated_at`, `publish_date`, `slug`, `meta_title`, `meta_description`) VALUES (1,'YOUR CORPORATE LIMO REQUIREMENTS COVERED','
There are many businesses and organizations that hunt for the best transportation to suit their needs when traveling to a corporate event with luxury and comfort. Corporate events are so common these days in cities like Mississauga, so as to maintain a networking and establish your roots in the market. Hiring a corporate service limo is so important to go wherever you want comfortably and that too on time.
\r\n\r\nIrrespective of what your need is, either you are renting it to impress a client, giving them a relaxing and soothing drive, traveling to an airport, or want to entertain the client on their way to a corporate event, Sapphire Limo rentals cover all these needs and that too at competitive price. The chauffeurs are well-experienced and dressed and we offer the special meet and greet services for new and out-of-town clients.
\r\n\r\nLimos are the best when one wants to leave a great impression on the corporate client. If your organization has a large event or you are looking out for multiple cars for your employees, it is necessary to book the limo early. Booking a limo early has immense benefits as one can get access to customized packages and so that one can get ample of drivers and cars to cover everyone who will need a ride. One of the most important benefits of hiring a corporate service limo for your next business event is the safety reason. With appropriate allocated and effective limo services, employees can have a whale of a time and get drunk without bothering how they will get home later in the evening.
\r\n\r\nCorporate limos are not just confined to corporate events but can also be hired for other purposes like:
\r\n\r\nWe at Sapphire Luxury Limo services offer the finest and the best luxury vehicles, professional staff, and an authentic party bus rental service in Toronto. If you are planning to take a service from us, it means you are getting connected to an organization that values your requirements and priorities above all else and will take you everywhere on time. We comprehend the need for a high-quality, professional ground transportation service and we work hard so as to fulfill the needs of our clients.
\r\n\r\nIf you are on a hunt for the 24-hour transportation services specifically for the party limo rentals throughout the Greater Toronto Area, just get in touch with Sapphire Limo Rentals.
','1579754806.jpg',NULL,1,1,1,'2020-01-23 12:46:46','2020-01-29 14:53:41','2020-01-23 12:46:46','your-corporate-limo-requirements-covered-blog','YOUR CORPORATE LIMO REQUIREMENTS COVERED','There are many businesses and organizations that hunt for the best transportation to suit their needs when traveling to a corporate event with luxury and comfort. Corporate events are so common these days in cities like Mississauga, so as to maintain a networking and establish your roots in the market. Hiring a corporate service limo is so important to go wherever you want comfortably and that too on time.'),(2,'Party Bus Rentals Fantastic For Your Special Occasions','Party Buses are in vogue across Canada. When one hears the word “party bus”, the first word that comes to mind is the party and a group of drunken people enjoying in a bus. Party bus is the perfect abode to enjoy the party on wheels with friends and closed ones. Why party buses have gained popularity over some time is the reason that they are spacious and embedded with wonderful and magnificent facilities.
\r\n\r\nParty Buses in Toronto can easily accommodate 32 to 50 passengers and enhances one’s traveling experience. The superb vehicle makes the special occasions more luxurious and comfortable. Sapphire Limousine, a prominent and overlying traveling company offers the best-in-class luxurious vehicles and has a team of dedicated professionals.
\r\nHow Sapphire makes your occasion outstanding?
Sapphire is an extrusive brand and has gained immense popularity because of the wonderful services. Party buses are best when one wants to boost the traveling experience. The spacious buses are the best option for the needs such as airport travel, corporate travel, prom parties, and other special occasions. We have the world-class party buses loaded with extravagant and cutting-edge features. Following are the features that make our party bus rentals disparate.
\r\n\r\n• Advance Guard Technology
\r\n\r\nOur party bus rentals are embedded with newfangled features like GPS, tracking system, and navigation system. We update and maintain our vehicle time to time so that one can always have a seamless traveling experience.
\r\n\r\n• World-Class amenities
\r\n\r\nWe feel that one cannot enjoy in the party bus anywhere if they do not have the necessary facilities such as perimeter seating, music system, flat TV screens, wet bars, dance floors, and restroom as well. These opulent amenities make can make anyone happy as a clam.
\r\n\r\n• Well-Trained Chauffeurs
\r\n\r\nSapphire has the team of dynamic and experienced professionals. We have the trained and licensed chauffeurs to drop you safely to your destination. There is no need for one to worry about the chaos and traffic jams as the drivers are well-known with the fastest routes possible.
\r\n\r\nParty Buses for distinctive occasions
\r\n\r\nFor Concerts
\r\n\r\nPaint the town red and enjoy the concert with your friends. Hire the party bus rentals from Sapphire as the bus will pick you and your friends from different locations. We offer fully customized and affordable packages, it is completely one’s personal choice as all the packages guarantees hours of utility and worthy service.
\r\n\r\nSummer Weddings
\r\n\r\nSummer weddings are common in Toronto region and our party bus service is the perfect medium to take the guests and other friends to the venue. The bridesmaid and groomsmen will really enjoy the event as the amusement and relaxation available on the bus let them be free for the special occasions. Party Bus is the outstanding option for the bachelor or bachelorette party.
\r\n\r\nPress home the advantage by availing the best party bus options from Sapphire. We have different party buses which include Party Bus-50, Party Bus-26, Sprinter Bus 14, Party Bus-30, and much more. Browse through the different photo galleries and make your mind!!
','1579754888.jpg',NULL,1,1,1,'2020-01-23 12:48:08','2020-01-24 17:39:19','2020-01-23 12:48:08','party-bus-rentals-fantastic-for-your-special-occasions-blog','Sapphire Limo is Best For Your Special Occasions','Sapphire Limousine Services is the superior and foremost limousine rental company in Toronto that provides best-in-class luxurious vehicles and has a team of extremely dedicated and diligent professionals.'),(3,'A JOY TO BEHOLD WITH SAPPHIRE','Sapphire Limousine Services is the superior and foremost limousine rental company in Toronto that provides best-in-class luxurious vehicles and has a team of extremely dedicated and diligent professionals. Sapphire is not just a brand, it is an emotion. Since many years, people are connected with our brand and are hiring limousines and party buses from us for their special occasions. We are a well-renowned brand and offers services for almost every kind of occasion from events to parties. We treat the client as God and fight tooth and nail so as to fulfill their needs and make them feel contented.
\r\n
\r\nCONSIDERATE TEAM
There are many factors why we are disparate as compared to other competitive industries. The chauffeurs are courteous and well-mannered. They assist the clients gracefully and talk with them in a polite voice. They are well-known with the routes and hence, always reach on time. The team is highly experienced catering even to the minute needs of the clients.
\r\n
\r\nMODERN TECHNOLOGY
Sapphire Limousine never lags behind in the updated fleets. The fleets are stylish and impart a contemporary look. All the vehicles are embedded with the newfangled technology and are best. From time to time updating to utilizing latest technology like GPS, tracking, and navigational systems, the brand has left no stone unturned.
\r\n\r\nAIM FOR MOON
\r\n\r\nThe prominent brand has been catering to the diverse industries including government and state officials, businessmen, senior employees, teenagers, newlywed couples, and many private clients. Sapphire has a vision of becoming the top brand in Toronto and hence, we are continuously working on it. A highly trusted and loyal brand in Toronto area because of the factors like dedication, exceptional, and highly focused services.
\r\n\r\nSPECIAL SERVICES
\r\n\r\nWedding Limousines
\r\n\r\nSapphire makes your wedding extravagant by making the most special arrangements for your wedding. We are having many years of experience in managing the wedding transportation and have diverse fleets like stretch limos, Hummer limousines, escalades, vintage cars, and party buses. We make the best possible arrangements so that the bride and groom can arrive in style.
\r\n\r\nParty Limos/ Buses
\r\n\r\nThe trend of weekend parties is increasing among youngsters in Canada. If one is seeking out to enjoy the party on wheels, then Sapphire is the perfect abode. Irrespective of whether it is a birthday treat, anniversary celebration or prom, we have different arrangements for divergent occasions. A brand on which one can rely and trust.
\r\n
\r\nCorporate
These days in order to develop a great network one often needs to go to the business conferences and meetings. Hence, traveling in the lavish limousines makes one look classy and maintains a positive status among the clients. The extremely trained chauffeurs pick and drop the client on time. The limousines have many additional things like chilled bottled water, magazines, journals etc.
\r\n\r\nTo wrap up, Sapphire has become one of the most renowned and recognized limousine providers in Toronto area. One can trust our service blindly and can avail the benefit of the customized packages.
',NULL,NULL,1,1,1,'2020-01-23 12:50:30','2020-01-24 18:11:39','2020-01-23 12:50:30','a-joy-to-behold-with-sapphire-blog','A JOY TO BEHOLD WITH SAPPHIRE - Sapphire Limousine','Sapphire Limousine Services is the superior and foremost limousine rental company in Toronto that provides best-in-class luxurious vehicles and has a team of extremely dedicated and diligent professionals.'),(4,'In The Lap Of Luxury With Sapphire','Sapphire is a name which is built for comfort and to give you a king’s feeling. Sapphire is not just a name; it is a brand which is acclaimed for its high-quality service. At Sapphire Luxury Limo Services, we deal in providing rental service for Limousines and party buses in Toronto and Mississauga region. As it is said, “Take your pleasure where you find it”, make your journeys outstanding by traveling in the limousines and party bus for those auspicious occasions. We cater to the needs of our customers and provide world-class service. We offer limo bus, party bus and party limo for the most remarkable occasions of your life. Rated as Toronto’s number 1 limo and party bus rentals, we are marked as the best service provider in this industry and that too at such modest price.
\r\n\r\n
\r\nHow are we exceptional?
Our team is having a vast experience and the chauffeurs are very well trained who deliver unique service. We are an organization that has a great reputation, respects the time and provides picks and drop facility. The staff here is dedicated and hardworking that treats the customers in a well-responsive manner. Open communication with clients really helps us to work in a highly efficient manner. Various amenities and facilities like newspapers, TV videos, music to pump you up and make you feel enigmatic are there to make your journey unforgettable and extraordinary. We ensure your complete safety so that you and your kids are in safe hands. The drivers are trained in their work and the advanced technological techniques like GPS, tracking, and navigational system to take you off the route of least traffic. The fleets like party bus and limo bus are very well kept.
\r\n\r\nWe are providing outstanding service to our client catering different industries like government and state officials, business executives, senior employers, teenagers, and newlywed couples
\r\n\r\nWhat do we offer?
\r\n\r\nParty Limos/Buses: Social gatherings are really important these days to relieve stress and if you are the one who is looking to enjoy with your most special people while traveling, a party bus is a great option from Sapphire in Toronto, Mississauga and Greater Toronto area. The party bus can accommodate 32 to 50 people at a time and you can have the inner decoration as per your choice. Various other arrangements can be done like drinks and the food facilities. All our party buses are having amenities like perimeter seating, music system, flat TV screens, wet bars, dance floors and clean restrooms as well. Our fleet is properly maintained and timely service is provided. For your special days like weddings, to make them the most auspicious occasion of your life, hire the party limos and buses so that your friends can accompany you during the most important phase of your life.
','1579755103.jpg',NULL,1,1,1,'2020-01-23 12:51:43','2020-01-29 14:56:31','2020-01-23 12:51:43','in-the-lap-of-luxury-with-sapphire-blog','In The Lap Of Luxury With Sapphire - Sapphire Limousine','Sapphire Limousine offers best in class party bus, limo bus, and party limo in Mississauga & Toronto. Get More Information Regarding Our Brand.'),(5,'Choose A Limo According To Your Occasion','Welcome to the world of Limos, the companies provide the excellence in the service offered to their clients. Whether it is any special occasion, prom night, corporate affair/meeting or wedding they provide you with the experience and expectations associated with luxury limousine service. They even offer variety of vehicles and services to meet any need.
\r\n\r\nDifferent companies are coming ahead with their Limos services. With an aim to provide their clients the best quality chauffeurs service by offering unbeatable prices. The vehicles are latest models with all new amenities and communications. There is a wide array of Limos and it all depends upon your choice of selection according to your occasion.
\r\n\r\nLet’s have a look which Limo will be perfect for your occasion:-
\r\n\r\nMake wedding an extravagant affair
\r\n\r\nEvery bride and groom wants their big day to be very special and unique. Wedding is their one big lifetime experience, so for making it unique and stylish with a perfect entry to the venue they can hire the best Limo. From single to ten passengers along with your guests can travel in superlative style, privacy and luxury in your choice of Limos. With so many perfect facilities, you can make your wedding day as memorable and indulgent as you possibly can.
\r\n\r\nThey take you to your wedding venue in a style that you have always dreamed about. Apart from this the professional drivers will escort the guests to the venue in a much pampered way, an expedition they will remember for a lifetime. Limo service providers are specialist in weddings; they offer wedding packages which include red carpet, bridal ribbons, silk flowers and professional chauffeurs. Your wedding day should be full of fun and frolic, filled with wonderful memories.
\r\n\r\nParty Limos or Busses for your party
\r\n\r\nThinking of partying with your friends for a night and dancing all the way during your celebrations, hire the best fleet party limos or busses. Party Limos or buses offer the service for people ranging from 10 to 25. Leave your party bus requirements to them and you can easily enjoy the ride.
\r\n\r\nWhile riding with them for your party they will take care of your enjoyment but getting you to your destination safely and securely is their utmost priority. With these limos you can take your party celebrations to the next level. These Limos even ensures you that the vehicles you're getting has the space, features and look for your party celebration. The Limos are equipped with latest model technology and equipments to offer the customers with greater level of satisfaction.
\r\n\r\nSpecial fleets for Prom Nights
\r\n\r\nWhen it comes to your Prom Night, with ‘A’ class services and vehicles you can experience the best night. These nights matters a lot especially for the teenagers as after their high school they don’t want to compromise with their last party together. So they always want something classy and extraordinary to flaunt the onlookers. Prom Limos make your occasion, a full of good memories so that whenever you feel nostalgic first thing that will strike you about this night would be your perfect Limo journey as a star. Parents will be less worried as their kids are in safe hands while travelling through these Limos.
\r\n\r\nThey even take care of every aspect that the services should be up to the mark for kids also. The chauffeurs are well trained and are professionally dressed up. They provide the clients with best quality services from their pick up to drop point. They also offer the clients with best packages or the owners even tailor the package according to the customers need and requirement. We even built a reputation for being much more than chauffeurs. Different agencies come up with different rates but due to the competition many of the companies rates are very affordable as compared to others and Chauffeurs are professional and courteous. They understand the vitality of getting you to your desired destination timely and safely.
\r\n\r\nCorporate Affairs
\r\n\r\nExpert and experienced drivers will whisk you to and from your goals securely and proficiently. From your landing to takeoff, they will handle your transportation needs so you can concentrate on what you came to the place to fulfill.
\r\n\r\nThe luxury vehicles will offer your executives with a safe and timely ride. These Limo’s holders pride themselves on their reliably proficient and unparalleled service alongside their capacity to take into account the customers' every need.
\r\n\r\nAirport services
\r\n\r\nFor a stress free airport arrival or departure book a car from a wide range of vehicles available. For the sake of punctuality many Limo agencies subscribe to "Flight Tracker", an internet service that tracks the location of your flight. You don’t have to worry about your flight delay or early or about your luggage, your personal driver-guide will organize your baggage, your preferential parking.
\r\n\r\nThe Limo agencies believe in full transparency and honesty, while booking with them the final price you see is the final price you pay for your trip. Top notch companies have no hidden charges to pay, meaning you can accurately calculate your travel expenses in advance. All they require is a destination. So start your trip off right. Just sit back, relax and enjoy the ride. The companies pride themselves on being on time, every time and deliver their services keeping customer satisfaction in mind.
\r\n\r\nConclusion
\r\n\r\nYou can easily hire these services from a reputed limo rental company and for finding the best company; you need to do proper research. The reason behind this is, that a well reputed company will take care of your comfort and happiness as much as possible.
','1579755182.jpg',NULL,1,1,1,'2020-01-23 12:53:02','2020-01-24 17:47:47','2020-01-23 12:53:02','choose-a-limo-according-to-your-occasion-blog','Choose A Limo According To Your Occasion - Sapphire Limousine','Whether it is any special occasion, prom night, corporate affair/meeting or wedding Sapphire offers you an excellent limo services.'),(6,'Sapphire Limo A Trustworthy Limo Rental Company In Toronto','The trend of hiring the Limos in all over the Canada is increasing. Not only the wedding affairs have taken the western turn rather the prom nights, casino nights, Birthday parties and other events are celebrated in a stylish way. From simple to making the events really lavish and extravagant is the current scenario. Anyone who is throwing the party or organizing any event tries to do something unique to stay stylish and make the guests recall the celebration throughout their life.
\r\n\r\nThere are so many Limousine rental companies in Canada. You can hire the best fleet according to your need, convenience, budget, and occasion. By hiring the limousine you can make your celebrations more special by freezing the moments spent with your kith and kin. You can capture the moments and make it a perfect memory to recall. Youngsters these days are more into celebrating their parties in a style by hiring a limo. The demand of Hummer Limo by youth is on the rise.
\r\n\r\nEvery Limo rental company costs differently according to the type of fleet. Riding in a limo is like a dream ride for many. So many brides in order have a princess like entry to the wedding venue hires the best stretch limo and fulfill the dream of being a princess. It is no more astonishing that the demand of Limos hikes in peak wedding and holiday season. Plebeians love to travel with comfort, convenience and in a style.
\r\n\r\nForeigner students who are studying in Canada before returning back to their own province or migrating to some other place plan something very unique to collect the memories. But Canada is a very costly place to plan a party on wheels and the students cannot afford their own so for them planning their party and booking a limo few months prior can help them in some cost reduction as they have to ask their parents for the money. What else they can do is organizing a party in a limo and fulfilling their dream by contributing the amount and finds it not so expensive on their pockets.
\r\n\r\nThere are so many limo rental services but hiring the one that is trustworthy is the right choice. Companies like Sapphire Limo are focused to work in a way to give their clients with best riding experience and making their journey a memorable and safe with the professional chauffeurs driving for them. The clients hire the limo to have a good experience and this can be done when the fleets will be embedded with latest technology equipment, good seating capacity, and a mini pub to make everyone enjoy their fullest.
\r\n\r\nSo, at last, it’s all your choice whether you want to hire a limo from an unauthorized company just to save your few bucks with a regretting experience or wanted to rent a limo from your local favorite Limo Company Sapphire Limo.
','1580456039.jpg',NULL,1,1,1,'2020-01-23 12:54:29','2020-01-31 15:33:59','2020-01-23 12:54:29','sapphire-limo-a-trustworthy-limo-rental-company-in-toronto-blog','A Trustworthy Limo Rental Company - Sapphire Limo','Sapphire Limo are focused to work in a way to give their clients with best riding experience and making their journey a memorable.'),(7,'Test Blog','Test Description
','1639034726.png',NULL,1,1,1,'2021-12-09 15:25:27','2021-12-09 15:25:27','2021-12-09 15:25:26','test-blog-blog','Test Meta','Test Meta Description for blog'); /*!40000 ALTER TABLE `blogs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `comments` -- DROP TABLE IF EXISTS `comments`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `comments` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) NOT NULL, `email` varchar(191) NOT NULL, `comment` text NOT NULL, `website` text DEFAULT NULL, `blog_id` bigint(20) unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `approved` varchar(200) NOT NULL DEFAULT 'Pending', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `comments` -- LOCK TABLES `comments` WRITE; /*!40000 ALTER TABLE `comments` DISABLE KEYS */; INSERT INTO `comments` (`id`, `name`, `email`, `comment`, `website`, `blog_id`, `created_at`, `updated_at`, `approved`) VALUES (1,'elisa','elisa@yopmail.com','test comment',NULL,1,'2020-01-24 15:47:08','2020-01-24 15:47:08','0'),(2,'elisa Mcguire','elisa@yopmail.com','Test comment',NULL,6,'2020-01-24 18:32:38','2020-01-24 18:33:54','1'),(3,'Johnmcguire','Johnmcguire@yopmail.com','Test',NULL,5,'2020-01-27 12:27:11','2020-01-27 12:27:11','0'),(4,'test','test@yopmail.com','test comment',NULL,6,'2020-01-29 14:19:56','2020-01-29 14:19:56','0'),(5,'test','test@yopmail.com','testing for blog','https://www.sapphirelimo.ca/',6,'2020-01-29 14:20:35','2020-01-29 14:22:46','1'),(6,'user','USER@YOPMAIL.COM','test comment','https://www.staging.sapphirelimo.km2.ca/',1,'2020-01-29 14:24:26','2020-01-29 14:24:43','1'),(7,'John','John@yopmail.com','John mcguire',NULL,6,'2020-01-29 15:24:25','2020-01-29 15:24:25','0'),(8,'alisa','alisa@yopmail.com','comment description',NULL,6,'2020-01-29 15:25:12','2020-01-29 15:25:12','0'),(9,'Rose','rose@yopmail.com','Test',NULL,5,'2021-11-25 17:09:01','2021-11-25 17:09:01','Pending'),(10,'rose','rose@yopmail.com','fgdg','sapphaire.limo',5,'2021-11-25 17:12:35','2021-11-25 17:12:35','Pending'),(11,'elisa','elisa.mcguire@yopmail.com','test comment',NULL,5,'2021-11-25 17:18:12','2021-11-25 17:18:12','Pending'),(12,'elisa','elisa@yopmail.com','test','staging.sapphirelimo.km2.ca',5,'2021-11-25 17:19:12','2021-11-25 17:19:12','Pending'),(13,'elisa','elisa@yopmail.com','test','staging.sapphirelimo.km2.ca',4,'2021-11-25 17:30:50','2021-11-25 17:30:50','Pending'),(14,'john','john@yopmail.com','test comment','staging.sapphirelimo.km2.ca',4,'2021-11-25 17:31:25','2021-11-25 17:31:25','Pending'),(15,'Test User','testuser@yopmail.com','Test Comment','sapphire.ca',7,'2021-12-09 15:27:05','2021-12-09 15:27:49','Approved'); /*!40000 ALTER TABLE `comments` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `contacts` -- DROP TABLE IF EXISTS `contacts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `contacts` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `first_name` varchar(50) NOT NULL, `last_name` varchar(50) NOT NULL, `email` varchar(50) NOT NULL, `phone` varchar(50) NOT NULL, `message` varchar(4999) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `is_read` tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `contacts` -- LOCK TABLES `contacts` WRITE; /*!40000 ALTER TABLE `contacts` DISABLE KEYS */; INSERT INTO `contacts` (`id`, `first_name`, `last_name`, `email`, `phone`, `message`, `created_at`, `updated_at`, `is_read`) VALUES (1,'Matt','McGuire','matt.mcguire@yopmail.com','1234567890','Rather than just filling out a form, Sleeknote also offers help to the user with links directing them to find additional information or take popular actions. . They’ve also taken special care to add social proof, featuring trusted logos.','2020-01-23 20:17:21','2020-01-23 20:23:02',1),(2,'Alana','McGuire','alana.mcguire@yopmail.com','9876543210','Zendesk hit all the major needs with its contact us page while maintaining a clean design. . They have included a form, an option to contact product support, as well as location information with a map.\r\n\r\nAlthough the page contains all of the basic elements, it does lack the pops of color and graphics we see throughout the rest of the site and visual cues to guide the user down the page to the rest of the information.','2020-01-23 20:18:13','2020-01-23 20:19:49',1),(3,'John','McGuire','john.mcguire@yopmail.com','9876543210','The simple, high-contrast “Get In Touch” button leads to a form that opens in a lightbox. This is a great way to keep the page short and to the point while still enabling all the crucial functions. This kind of subtle, unexpected micro-interaction can add a refreshing approach to an otherwise standard contact us page.\r\nWhile the simplicity of the page is refreshing, it does lack the branding/ personality that is carried throughout the rest of the website. By adding a few of the illustrations used on other pages, the contact us page would feel more cohesive and on-brand.','2020-01-23 20:20:46','2020-01-27 13:13:05',1),(4,'Lanny','Mathew','lanny.mathew@yopmail.com','5432167890','Stripe’s hits all of the major checkboxes for a successful contact us page. It has a clean design that makes it clear how to reach out to their team ad the content on the page has a warm and friendly tone.\r\n\r\nWhat I love most about this page, though, is how they showcase a handful of the companies they work with right next to the form. Showcasing companies that use their software, made me think “If these big companies trust Stripe, why shouldn’t I,” and helps to ease any reservations a visitor might have about reaching out to their sales team. Seeing these logos made me think “If these big companies trust Stripe, why shouldn’t I.”\r\n\r\nThe biggest thing lacking on this page is the type of contact information available to the user. The form is great, but users aren’t privy to location or any phone numbers.\r\nStripe’s hits all of the major checkboxes for a successful contact us page. It has a clean design that makes it clear how to reach out to their team ad the content on the page has a warm and friendly tone.\r\n\r\nWhat I love most about this page, though, is how they showcase a handful of the companies they work with right next to the form. Showcasing companies that use their software, made me think “If these big companies trust Stripe, why shouldn’t I,” and helps to ease any reservations a visitor might have about reaching out to their sales team. Seeing these logos made me think “If these big companies trust Stripe, why shouldn’t I.”\r\n\r\nThe biggest thing lacking on this page is the type of contact information available to the user. The form is great, but users aren’t privy to location or any phone numbers.','2020-01-23 20:22:03','2020-01-27 13:12:49',1),(5,'Anna','Mcguire','anna.mcguire@gmail.com','1234567890',NULL,'2020-01-27 12:56:05','2020-01-27 13:12:57',1),(6,'Pabh','Singh','prabh@yopmail.com','1122345678','dddd','2020-01-29 11:52:28','2020-01-29 11:52:28',0),(7,'Matt','McGuire','matt.mcguire@yopmail.com','1234567890','Test','2020-01-29 13:15:31','2020-01-29 14:35:31',1),(8,'User','mcguire','test@yopmail.com','(445) 454-5454','testing','2020-01-29 14:17:29','2020-01-29 14:35:06',1),(9,'Trst','User','Test@yopmail.com','(123) 558-8888','Test message','2020-01-29 15:08:25','2020-01-29 15:08:25',0),(10,'Elisa','Mcguire','Elisa@yopmail.com','(354) 464-6565','Message','2020-01-29 15:30:21','2020-01-29 15:30:21',0),(11,'test','user','test2@yopmail.com','(444) 545-4545','test','2020-01-29 17:11:15','2020-01-29 17:11:15',0),(12,'Elisa','Mcguire','elisa.mcguire@yopmail.com','(123) 456-7890','test form','2021-11-25 14:19:58','2021-11-25 14:19:58',0),(13,'Elisa','Mcguire','elisa.mcguire@yopmail.com','(123) 456-7890','Test Form','2021-11-25 16:47:33','2021-11-25 16:47:33',0),(14,'Matt','Mcguire','matt.mcguire@yopmail.com','(123) 456-7890','Test Form','2021-11-25 16:56:06','2021-11-25 16:56:06',0),(15,'Kinex','Test','kinex.test@yopmail.com','(123) 456-7890','test','2021-11-25 17:17:25','2021-11-25 17:17:25',0),(16,'Test','User','test.user@yopmail.com','(123) 456-7890','test form','2021-11-25 17:23:50','2021-12-09 15:24:33',1),(17,'Test','User','test@yopmail.com','(789) 456-1321','Test Contact Message','2021-12-09 15:28:38','2021-12-09 15:29:18',1); /*!40000 ALTER TABLE `contacts` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `faqs` -- DROP TABLE IF EXISTS `faqs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `faqs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(300) NOT NULL, `description` varchar(1000) NOT NULL, `order` smallint(5) unsigned NOT NULL, `is_active` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `category` varchar(200) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `faqs` -- LOCK TABLES `faqs` WRITE; /*!40000 ALTER TABLE `faqs` DISABLE KEYS */; INSERT INTO `faqs` (`id`, `title`, `description`, `order`, `is_active`, `created_at`, `updated_at`, `category`) VALUES (1,'What Kinds Of Services Sapphire Limo Provides?','At Sapphire Limousine, we provide a comprehensive range of services, which includes birthday party limo, prom limo, wedding limo, and much more. We as well offer stretch limos for your corporate events. Browse through our services and categories of fleets to learn more.',1,1,'2020-01-23 12:30:56','2020-01-27 18:33:01','Home-Page'),(2,'Can You Drink Or Eat At The Party Bus?','There is no restriction on food and beverages in our fleets. But we do not provide any eatables or drinks apart from water bottles. Make sure you meet the legal drinking age if alcohol is involved.',2,1,'2020-01-23 12:31:20','2020-01-27 18:32:54','Home-Page'),(3,'How Much Does A Party Bus Rental Cost?','The cost of our party bus rentals depends upon the type of fleet you choose and the number of passengers you have. You can fill in the form on our website and ask us for a quote, and we will reach you in no time.',3,1,'2020-01-23 12:32:53','2020-01-27 18:32:47','Home-Page'),(4,'What Are The Hourly Limo Rates?','The hourly limo rates at Sapphire Limo vary. We have different per hour rates for party buses, wedding limousines, SUVs, etc. Request us for a quote by filling out our online form.',4,1,'2020-01-23 12:33:25','2020-01-27 18:32:39','Home-Page'),(5,'What Type Of Payment Methods Do You Accept?','We accept all kinds of payments, including Visa, MasterCard, Credit Card, Debit Card, Cash, and Check.',5,1,'2020-01-23 12:33:50','2020-01-27 18:32:32','Home-Page'),(6,'What Is The Limo Cancellation Policy?','For proms and weddings, we request you to notify us 30 days in advance. For other reservations, such as night parties, corporate events, etc. the cancellation must be made 15 days before the date of your trip',6,0,'2020-01-23 12:34:27','2020-01-27 18:38:41','Home-Page'),(7,'Do The Wedding Limo & Party Bus Come With Decorations?','Yes, we have an in-house florist to decorate the wedding limousine you have chosen. Besides, if you have a florist of your own, our driver will take you there, free-of-cost, a day before your wedding.',1,1,'2020-01-27 18:40:43','2020-01-27 18:40:43','Wedding-Page'),(8,'Is Wedding Limo Available at Hourly Rates?','Yes, our limousines are available at per hour rate, but the cost depends on the kind of fleet you have hired. The best way to decide the pricing is to call Sapphire Limo’s customer care.',2,1,'2020-01-27 18:41:08','2020-01-27 18:41:08','Wedding-Page'),(9,'Can We Bring Our Selection of Music?','Yes, Of course! We would be more than happy to play your taste of music. In fact, we encourage this practice.',3,1,'2020-01-27 18:41:31','2020-01-27 18:41:31','Wedding-Page'),(10,'Which Payment Methods Do You Accept?','We accept all kinds of payment methods, comprising Credit Card, Debit Card, Cheques, Cash, Discover, etc. Talk to our customer service for the method you are going to choose.',4,1,'2020-01-27 18:41:54','2020-01-27 18:41:54','Wedding-Page'); /*!40000 ALTER TABLE `faqs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `fleet_images` -- DROP TABLE IF EXISTS `fleet_images`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `fleet_images` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `fleets_id` bigint(20) unsigned NOT NULL, `filename` varchar(191) NOT NULL, `is_active` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `fleet_images_fleets_id_foreign` (`fleets_id`), CONSTRAINT `fleet_images_fleets_id_foreign` FOREIGN KEY (`fleets_id`) REFERENCES `fleets` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=115 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `fleet_images` -- LOCK TABLES `fleet_images` WRITE; /*!40000 ALTER TABLE `fleet_images` DISABLE KEYS */; INSERT INTO `fleet_images` (`id`, `fleets_id`, `filename`, `is_active`, `created_at`, `updated_at`) VALUES (11,1,'521579852433.jpg',1,'2020-01-24 15:53:53','2020-01-24 15:53:53'),(12,1,'391579852433.jpg',1,'2020-01-24 15:53:53','2020-01-24 15:53:53'),(13,1,'21579852433.jpg',1,'2020-01-24 15:53:53','2020-01-24 15:53:53'),(14,1,'831579852433.jpg',1,'2020-01-24 15:53:54','2020-01-24 15:53:54'),(15,1,'171579852434.jpg',1,'2020-01-24 15:53:54','2020-01-24 15:53:54'),(16,1,'181579852434.jpg',1,'2020-01-24 15:53:54','2020-01-24 15:53:54'),(17,2,'681579852604.jpg',1,'2020-01-24 15:56:44','2020-01-24 15:56:44'),(18,2,'211579852604.jpg',1,'2020-01-24 15:56:44','2020-01-24 15:56:44'),(19,2,'521579852604.jpg',1,'2020-01-24 15:56:45','2020-01-24 15:56:45'),(20,2,'701579852605.jpg',1,'2020-01-24 15:56:45','2020-01-24 15:56:45'),(21,2,'291579852605.jpg',1,'2020-01-24 15:56:45','2020-01-24 15:56:45'),(22,2,'41579852605.jpg',1,'2020-01-24 15:56:45','2020-01-24 15:56:45'),(23,3,'551579852702.jpg',1,'2020-01-24 15:58:22','2020-01-24 15:58:22'),(24,3,'841579852702.jpg',1,'2020-01-24 15:58:23','2020-01-24 15:58:23'),(25,3,'211579852703.jpg',1,'2020-01-24 15:58:23','2020-01-24 15:58:23'),(26,3,'711579852703.jpg',1,'2020-01-24 15:58:23','2020-01-24 15:58:23'),(27,3,'241579852703.jpg',1,'2020-01-24 15:58:23','2020-01-24 15:58:23'),(28,3,'471579852703.jpg',1,'2020-01-24 15:58:23','2020-01-24 15:58:23'),(29,4,'741579852787.jpg',1,'2020-01-24 15:59:47','2020-01-24 15:59:47'),(30,4,'361579852787.jpg',1,'2020-01-24 15:59:47','2020-01-24 15:59:47'),(31,4,'941579852787.jpg',1,'2020-01-24 15:59:47','2020-01-24 15:59:47'),(32,4,'841579852787.jpg',1,'2020-01-24 15:59:48','2020-01-24 15:59:48'),(33,4,'921579852788.jpg',1,'2020-01-24 15:59:48','2020-01-24 15:59:48'),(34,4,'291579852788.jpg',1,'2020-01-24 15:59:48','2020-01-24 15:59:48'),(35,5,'411579855878.jpg',1,'2020-01-24 16:51:18','2020-01-24 16:51:18'),(36,5,'551579855878.jpg',1,'2020-01-24 16:51:18','2020-01-24 16:51:18'),(37,5,'781579855878.jpg',1,'2020-01-24 16:51:19','2020-01-24 16:51:19'),(38,5,'151579855879.jpg',1,'2020-01-24 16:51:19','2020-01-24 16:51:19'),(39,5,'681579855879.jpg',1,'2020-01-24 16:51:19','2020-01-24 16:51:19'),(40,5,'351579855879.jpg',1,'2020-01-24 16:51:19','2020-01-24 16:51:19'),(41,6,'41579856016.jpg',1,'2020-01-24 16:53:36','2020-01-24 16:53:36'),(42,6,'591579856016.jpg',1,'2020-01-24 16:53:36','2020-01-24 16:53:36'),(43,6,'211579856016.jpg',1,'2020-01-24 16:53:37','2020-01-24 16:53:37'),(44,6,'941579856017.jpg',1,'2020-01-24 16:53:37','2020-01-24 16:53:37'),(45,7,'791579856112.jpg',1,'2020-01-24 16:55:12','2020-01-24 16:55:12'),(46,7,'111579856112.jpg',1,'2020-01-24 16:55:13','2020-01-24 16:55:13'),(47,7,'781579856113.jpg',1,'2020-01-24 16:55:13','2020-01-24 16:55:13'),(48,7,'391579856113.jpg',1,'2020-01-24 16:55:14','2020-01-24 16:55:14'),(49,7,'921579856114.jpg',1,'2020-01-24 16:55:14','2020-01-24 16:55:14'),(50,7,'291579856114.jpg',1,'2020-01-24 16:55:14','2020-01-24 16:55:14'),(51,7,'651579856114.jpg',1,'2020-01-24 16:55:15','2020-01-24 16:55:15'),(52,8,'311579856217.jpg',1,'2020-01-24 16:56:57','2020-01-24 16:56:57'),(53,8,'961579856217.jpg',1,'2020-01-24 16:56:58','2020-01-24 16:56:58'),(54,8,'431579856218.jpg',1,'2020-01-24 16:56:58','2020-01-24 16:56:58'),(55,8,'801579856218.jpg',1,'2020-01-24 16:56:58','2020-01-24 16:56:58'),(56,8,'181579856218.jpg',1,'2020-01-24 16:56:59','2020-01-24 16:56:59'),(57,8,'51579856219.jpg',1,'2020-01-24 16:56:59','2020-01-24 16:56:59'),(58,8,'141579856219.jpg',1,'2020-01-24 16:56:59','2020-01-24 16:56:59'),(59,9,'151579856339.jpg',1,'2020-01-24 16:58:59','2020-01-24 16:58:59'),(60,9,'51579856339.jpg',1,'2020-01-24 16:58:59','2020-01-24 16:58:59'),(61,9,'951579856339.jpg',1,'2020-01-24 16:58:59','2020-01-24 16:58:59'),(62,9,'931579856339.jpg',1,'2020-01-24 16:58:59','2020-01-24 16:58:59'),(63,9,'861579856339.jpg',1,'2020-01-24 16:59:00','2020-01-24 16:59:00'),(64,9,'591579856340.jpg',1,'2020-01-24 16:59:00','2020-01-24 16:59:00'),(65,10,'241579856436.jpg',1,'2020-01-24 17:00:36','2020-01-24 17:00:36'),(66,10,'21579856436.jpg',1,'2020-01-24 17:00:36','2020-01-24 17:00:36'),(67,10,'741579856436.jpg',1,'2020-01-24 17:00:37','2020-01-24 17:00:37'),(68,10,'251579856437.jpg',1,'2020-01-24 17:00:37','2020-01-24 17:00:37'),(69,10,'781579856437.jpg',1,'2020-01-24 17:00:37','2020-01-24 17:00:37'),(70,10,'871579856437.jpg',1,'2020-01-24 17:00:37','2020-01-24 17:00:37'),(71,11,'621579856559.jpg',1,'2020-01-24 17:02:39','2020-01-24 17:02:39'),(72,11,'981579856559.jpg',1,'2020-01-24 17:02:40','2020-01-24 17:02:40'),(73,11,'41579856560.jpg',1,'2020-01-24 17:02:40','2020-01-24 17:02:40'),(74,11,'421579856560.jpg',1,'2020-01-24 17:02:40','2020-01-24 17:02:40'),(75,11,'861579856560.jpg',1,'2020-01-24 17:02:41','2020-01-24 17:02:41'),(76,11,'571579856561.jpg',1,'2020-01-24 17:02:41','2020-01-24 17:02:41'),(77,12,'291579856653.jpg',1,'2020-01-24 17:04:13','2020-01-24 17:04:13'),(78,12,'651579856653.jpg',1,'2020-01-24 17:04:13','2020-01-24 17:04:13'),(79,12,'921579856653.jpg',1,'2020-01-24 17:04:13','2020-01-24 17:04:13'),(80,12,'211579856653.jpg',1,'2020-01-24 17:04:14','2020-01-24 17:04:14'),(81,12,'361579856654.jpg',1,'2020-01-24 17:04:14','2020-01-24 17:04:14'),(82,12,'201579856654.jpg',1,'2020-01-24 17:04:14','2020-01-24 17:04:14'),(83,12,'491579856654.jpg',1,'2020-01-24 17:04:14','2020-01-24 17:04:14'),(84,13,'891579856787.jpg',1,'2020-01-24 17:06:27','2020-01-24 17:06:27'),(85,13,'331579856787.jpg',1,'2020-01-24 17:06:28','2020-01-24 17:06:28'),(86,13,'581579856788.jpg',1,'2020-01-24 17:06:28','2020-01-24 17:06:28'),(87,13,'641579856788.jpg',1,'2020-01-24 17:06:28','2020-01-24 17:06:28'),(88,13,'841579856788.jpg',1,'2020-01-24 17:06:28','2020-01-24 17:06:28'),(89,13,'551579856788.jpg',1,'2020-01-24 17:06:29','2020-01-24 17:06:29'),(90,14,'341579856880.jpg',1,'2020-01-24 17:08:00','2020-01-24 17:08:00'),(91,14,'591579856880.jpg',1,'2020-01-24 17:08:01','2020-01-24 17:08:01'),(92,14,'591579856881.jpg',1,'2020-01-24 17:08:01','2020-01-24 17:08:01'),(93,14,'161579856881.jpg',1,'2020-01-24 17:08:02','2020-01-24 17:08:02'),(94,14,'801579856882.jpg',1,'2020-01-24 17:08:03','2020-01-24 17:08:03'),(95,15,'711579856976.jpg',1,'2020-01-24 17:09:36','2020-01-24 17:09:36'),(96,15,'21579856976.jpg',1,'2020-01-24 17:09:36','2020-01-24 17:09:36'),(97,15,'711579856976.jpg',1,'2020-01-24 17:09:37','2020-01-24 17:09:37'),(98,15,'291579856977.jpg',1,'2020-01-24 17:09:37','2020-01-24 17:09:37'),(99,15,'671579856977.jpg',1,'2020-01-24 17:09:37','2020-01-24 17:09:37'),(100,15,'971579856977.jpg',1,'2020-01-24 17:09:38','2020-01-24 17:09:38'),(101,15,'701579856978.jpg',1,'2020-01-24 17:09:38','2020-01-24 17:09:38'),(102,16,'291579857078.jpg',1,'2020-01-24 17:11:18','2020-01-24 17:11:18'),(103,16,'791579857078.jpg',1,'2020-01-24 17:11:19','2020-01-24 17:11:19'),(104,16,'51579857079.jpg',1,'2020-01-24 17:11:19','2020-01-24 17:11:19'),(105,16,'171579857079.jpg',1,'2020-01-24 17:11:19','2020-01-24 17:11:19'),(106,16,'641579857079.jpg',1,'2020-01-24 17:11:19','2020-01-24 17:11:19'),(107,16,'251579857079.jpg',1,'2020-01-24 17:11:20','2020-01-24 17:11:20'),(108,17,'801579857155.jpg',1,'2020-01-24 17:12:36','2020-01-24 17:12:36'),(109,17,'371579857156.jpg',1,'2020-01-24 17:12:36','2020-01-24 17:12:36'),(110,17,'901579857156.jpg',1,'2020-01-24 17:12:36','2020-01-24 17:12:36'),(111,17,'551579857156.jpg',1,'2020-01-24 17:12:37','2020-01-24 17:12:37'),(112,17,'461579857157.jpg',1,'2020-01-24 17:12:37','2020-01-24 17:12:37'),(113,17,'721579857157.jpg',1,'2020-01-24 17:12:37','2020-01-24 17:12:37'),(114,18,'821639033553.png',1,'2021-12-09 15:05:53','2021-12-09 15:05:53'); /*!40000 ALTER TABLE `fleet_images` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `fleets` -- DROP TABLE IF EXISTS `fleets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `fleets` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(500) NOT NULL, `description` varchar(3000) NOT NULL, `type` varchar(50) NOT NULL, `video` varchar(191) DEFAULT NULL, `no_of_seats` varchar(191) NOT NULL, `features` varchar(500) NOT NULL, `is_active` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `video_thumb` varchar(191) DEFAULT NULL, `slug` varchar(200) DEFAULT NULL, `meta_title` text DEFAULT NULL, `meta_description` text DEFAULT NULL, PRIMARY KEY (`id`), KEY `fleets_is_active_index` (`is_active`), KEY `fleets_slug_index` (`slug`) ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `fleets` -- LOCK TABLES `fleets` WRITE; /*!40000 ALTER TABLE `fleets` DISABLE KEYS */; INSERT INTO `fleets` (`id`, `name`, `description`, `type`, `video`, `no_of_seats`, `features`, `is_active`, `created_at`, `updated_at`, `video_thumb`, `slug`, `meta_title`, `meta_description`) VALUES (1,'Rolls Phantom 4','Rolls-Royce Phantom 4 is the ultimate luxury. Top-notch safety features comfort & convenience. Air conditioner, heater, and climate control make it the number one choice for your next big event or party.','Sedan and SUV','1579852433mp4','4','Air Conditioner, Specular Light, Music',1,'2020-01-24 12:26:12','2020-01-24 15:53:53','1579839972.jpg','rolls-phantom-4','Rolls Phantom 4 - Sapphire Limousine','Rolls-Royce Phantom 4 is the ultimate luxury. Top-notch safety features comfort & convenience. Air conditioner, heater, and climate control make it the number one choice for your next big event or party.'),(2,'Rolls Convertable 4','Embedded with cutting-edge technology like automatic climate control, anti-lock braking system, power steering- Rolls Convertible 4 is best for your next corporate event. Now drive in style and class. Enchanting interior with the heated seats.','Sedan and SUV','1579852604mp4','4','Air Conditioner, Specular Light, Music',1,'2020-01-24 15:56:44','2020-01-24 18:08:04','1579852604.jpg','rolls-convertable-4-fleet','Rolls Convertable 4 - Sapphire Limousine','Embedded with cutting-edge technology like automatic climate control, anti-lock braking system, power steering- Rolls Convertible 4 is best for your next corporate event.'),(3,'Bently Old -4','The dashing lights, the celebrity-style feeling, and the attractive interiors-all these words even can’t describe Bentley. An ideal choice for a romantic time to spend with your partner, it can hold 4 people.','Sedan and SUV','1579852702mp4','4','Specular Light, Music',1,'2020-01-24 15:58:22','2020-01-24 15:58:22','1579852702.jpg','bently-old--4-fleet','Bently Old -4 - Sapphire Limousine','The dashing lights, the celebrity-style feeling, and the attractive interiors-all these words even can’t describe Bentley. An ideal choice for a romantic time to spend with your partner, it can hold 4 people.'),(4,'Bently','Leather seats and steering wheel, cup holders, air quality control to many more positive points. Rent top class Bentley for your weddings, proms, parties, casino and airport visits.','Sedan and SUV','1579852787mp4','4','Air Conditioner, Specular Light, Music',1,'2020-01-24 15:59:47','2020-01-24 15:59:47','1579852787.jpg','bently-fleet','Bently - Sapphire Limousine','Leather seats and steering wheel, cup holders, air quality control to many more positive points. Rent top class Bentley for your weddings, proms, parties, casino and airport visits.'),(5,'Sprinter Bus 14','With room for 14 people, the interior of Mercedes-Benz Sprinter Bus gives plenty of room to move. Grab the best bus with innovative features. A vehicle made both with power and attractiveness.','Party Bus','1579855878mp4','12-14','Air Conditioner, Refrigerator, Specular Light, TV, Music',1,'2020-01-24 16:51:18','2020-01-24 18:05:30','1579855878.jpg','sprinter-bus-14-fleet','Sprinter Bus 14 - Sapphire Limousine','With room for 14 people, the interior of Mercedes-Benz Sprinter Bus gives plenty of room to move. Grab the best bus with innovative features.'),(6,'Party Bus 45-50 MCI3','The best option for huge gatherings and for anniversary parties while enjoying on the wheels. Party Bus can easily accommodate 45-50 people and can be used for many social occasions. Specular lights, refrigerators, and free wifi make it the no.1 choice.','Party Bus','1579856016mp4','45-50','Air Conditioner, Refrigerator, Specular Light, TV, Music',1,'2020-01-24 16:53:36','2020-01-24 18:04:43','1579856016.jpg','party-bus-45-50-mci3-fleet','Party Bus 45-50 MCI3 - Sapphire Limousine','The best option for huge gatherings and for anniversary parties while enjoying on the wheels. Party Bus can easily accommodate 45-50 people and can be used for many social occasions.'),(7,'Party Bus 45-50 MCI2','Equipped with the necessary features like DJ system, ambient lighting, wet bars, and dance floors. Your party will never stop in the luxurious and wonderful Party Bus 45-50 MCl2.','Party Bus','1579856112mp4','45-50','Air Conditioner, Refrigerator, Specular Light, TV, Music',1,'2020-01-24 16:55:12','2020-01-24 16:55:12','1579856112.jpg','party-bus-45-50-mci2-fleet','Party Bus 45-50 MCI2 - Sapphire Limousine','Equipped with the necessary features like DJ system, ambient lighting, wet bars, and dance floors. Your party will never stop in the luxurious and wonderful Party Bus 45-50 MCl2.'),(8,'Party Bus 45-50 MCI1','Equipped with the necessary features like DJ system, ambient lighting, wet bars, and dance floors. Your party will never stop in the luxurious and wonderful Party Bus 45-50 MC11.','Party Bus','1579856217mp4','45-50','Air Conditioner, Specular Light, TV, Music',1,'2020-01-24 16:56:57','2020-01-24 16:56:57','1579856217.jpg','party-bus-45-50-mci1-fleet','Party Bus 45-50 MCI1 - Sapphire Limousine','Equipped with the necessary features like DJ system, ambient lighting, wet bars, and dance floors. Your party will never stop in the luxurious and wonderful Party Bus 45-50 MC11.'),(9,'Party Bus 28-30','Party Bus is an ideal choice for corporate occasions, wedding parties, bachelor parties, concerts, and sight-seeing tours. Large HD Flat Screen, interior bars, and customized leather interior make it one of our bestseller.','Party Bus','1579856339mp4','28-30','Air Conditioner, Refrigerator, Specular Light, TV, Music',1,'2020-01-24 16:58:59','2020-01-24 18:01:45','1579856339.jpg','party-bus-28-30-fleet','Party Bus 28-30 - Sapphire Limousine','Party Bus is an ideal choice for corporate occasions, wedding parties, bachelor parties, concerts, and sight-seeing tours. Get a quote now.'),(10,'Party Bus 20-22','Party Bus 20-22 is a late-model luxury vehicle. Premier seating and spacious enough to accommodate around 22 people, it comes equipped with wonderful features to give you a celebrity feeling. Rear storage for luggage, illuminated rear controls, and the extraordinary features makes it the number 1 choice.','Party Bus','1579856436mp4','20-22','Air Conditioner, Refrigerator, Specular Light, TV, Music',1,'2020-01-24 17:00:36','2020-01-24 18:01:12','1579856436.jpg','party-bus-20-22-fleet','Party Bus 20-22 - Sapphire Limousine','Party Bus is an ideal choice for corporate occasions, wedding parties, bachelor parties, concerts, and sight-seeing tours.'),(11,'Lincoln Navigator New 12-14','For an innovative drive, Lincoln Navigator is the best option. Matching both your mood and the road, it can accommodate your friend group easily. Now head to your prom easily and comfortably.','Stretch Limousine','1579856559mp4','12-14','Air Conditioner, Specular Light, Music',1,'2020-01-24 17:02:39','2020-01-24 17:59:31','1579856559.jpg','lincoln-navigator-new-12-14-fleet','Lincoln Navigator New 12-14 - Sapphire Limousine','For an innovative drive, Lincoln Navigator is the best option. Matching both your mood and the road, it can accommodate your friend group easily.'),(12,'Lincoln Navigator 12-14','For an innovative drive, Lincoln Navigator is the best option. Matching both your mood and the road, it can accommodate your friend group easily. Now head to your prom easily and comfortably.','Stretch Limousine','1579856653mp4','12-14','Air Conditioner, Specular Light, Music',1,'2020-01-24 17:04:13','2020-01-24 17:04:13','1579856653.jpg','lincoln-navigator-12-14-fleet','Lincoln Navigator 12-14','For an innovative drive, Lincoln Navigator is the best option. Matching both your mood and the road, it can accommodate your friend group easily. Now head to your prom easily and comfortably.'),(13,'Lincoln Limo-8-10','Private party or a confidential meeting? Lincoln Limo overshines the expectations of the clients in terms of safety, security, and capacity. Enjoy the premium leather seating with a rear-seat amenities package.','Stretch Limousine','1579856787mp4','8-10','Air Conditioner, Specular Light, Music',1,'2020-01-24 17:06:27','2020-01-24 17:57:49','1579856787.jpg','lincoln-limo-8-10-fleet','Lincoln Limo-8-10 - Sapphire Limousine','Private party or a confidential meeting? Lincoln Limo overshines the expectations of the clients in terms of safety, security, and capacity.'),(14,'Lincoln Limo MKT-8-10','This Stretch limousine comes with electronic climate control and can easily accommodate 8-10 passengers. What makes it a perfect choice for events is the leather interior, privacy dividers, and flat screen.','Stretch Limousine','1579856880mp4','8-10','Air Conditioner, Specular Light, Music',1,'2020-01-24 17:08:00','2020-01-24 17:08:00','1579856880.jpg','lincoln-limo-mkt-8-10-fleet','Lincoln Limo MKT-8-10 - Sapphire Limousine','This Stretch limousine comes with electronic climate control and can easily accommodate 8-10 passengers. What makes it a perfect choice for events is the leather interior, privacy dividers, and flat screen.'),(15,'Hummer New 18-20','The perfect SUV Stretch Limousine is a symbol of class. It has one of the best sound systems and will surely impress your guests. The wet bars come pre-stocked with ice and water. A perfect fit for prom nights, Christmas parties, city tours, and airport rounds.','Stretch Limousine','1579856976mp4','18-20','Air Conditioner, Refrigerator, Specular Light, Music',1,'2020-01-24 17:09:36','2020-01-24 17:55:53','1579856976.jpg','hummer-new-18-20-fleet','Hummer New 18-20 - Sapphire Limousine','Hummer vehicles are special because of engine capacity and fuel efficiency. Book the Hummer New for your grand anniversary celebration. Spacious enough for 18-20 people, Hummer has all the necessary amenities.'),(16,'Hummer 18-20','The perfect SUV Stretch Limousine is a symbol of class. It has one of the best sound systems and will surely impress your guests. The wet bars come pre-stocked with ice and water. A perfect fit for prom nights, Christmas parties, city tours, and airport rounds.','Stretch Limousine','1579857078mp4','18-20','Air Conditioner, Refrigerator, Specular Light, Music',1,'2020-01-24 17:11:18','2020-01-24 17:54:58','1579857078.jpg','hummer-18-20-fleet','Hummer 18-20 - Sapphire Limousine','The perfect SUV Stretch Limousine is a symbol of class. It has one of the best sound systems and will surely impress your guests.'),(17,'Cadillac-18-20','Cadillac Escalade Super Stretch Limousine can easily hold 18-20 people. The specifications include a TV with DVD player, bar, and much more. The exterior is just amazing and enchanting. Perfect for bachelor parties and outdoor events with friends.','Stretch Limousine','1579858419mp4','18-20','Air Conditioner, Refrigerator, Specular Light, Music',1,'2020-01-24 17:12:35','2020-01-24 17:33:39','1579857155.jpg','cadillac-18-20-fleet','Cadillac-18-20 - Sapphire Limousine','Cadillac Escalade Super Stretch Limousine can easily hold 18-20 people. The specifications include a TV with DVD player, bar, and much more. The exterior is just amazing and enchanting. Perfect for bachelor parties and outdoor events with friends.'),(18,'Test Fleet','Test Description','Party Bus','1639033553.mp4','35','Refrigerator, Music',1,'2021-12-09 15:05:53','2021-12-09 15:05:53','1639033553.png','test-fleet-fleet','Test Meta','Test Meta Description'); /*!40000 ALTER TABLE `fleets` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `metas` -- DROP TABLE IF EXISTS `metas`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `metas` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `page` varchar(200) NOT NULL, `title` text NOT NULL, `description` text NOT NULL, `is_active` tinyint(1) NOT NULL DEFAULT 1, `created_by` int(10) unsigned DEFAULT NULL, `updated_by` int(10) unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `metas` -- LOCK TABLES `metas` WRITE; /*!40000 ALTER TABLE `metas` DISABLE KEYS */; INSERT INTO `metas` (`id`, `page`, `title`, `description`, `is_active`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES (1,'/','Party Bus Toronto, Party Limo Bus & Rental Service Toronto - SapphireLimo3','Sapphire limo home page.3',1,1,1,'2020-01-23 13:04:18','2020-01-29 20:08:58'),(2,'/login','Admin Login','Sapphire admin login page.',1,1,1,'2020-01-23 13:05:21','2020-01-24 18:25:18'),(3,'/blog','Blog - Sapphire Limousine','Sapphire limo blogs',1,1,1,'2020-01-23 13:06:08','2020-01-24 18:25:30'),(4,'/fleet','Fleet - Sapphire Limousine','Sapphire limo fleets page',1,1,1,'2020-01-23 13:08:13','2020-01-24 18:25:44'),(5,'/testimonials','Testimonials - Sapphire Limousine','Sapphire limo client review page',1,1,1,'2020-01-23 13:10:28','2020-01-29 16:39:39'),(6,'/about','About us - Sapphire Limousine','Sapphire limo about',1,1,1,'2020-01-23 13:10:56','2020-01-29 16:39:19'),(7,'/our-services','Our Services - Sapphire Limousine','Sapphire limo services page',1,1,1,'2020-01-23 13:11:28','2020-01-24 18:26:31'),(8,'/services/airport','Airport - Sapphire Limousine','Sapphire limo wedding limo toronto service page',1,1,1,'2020-01-23 13:12:28','2020-01-24 18:27:17'),(9,'/services/casino','Casino - Sapphire Limousine','Sapphire limo casino service page',1,1,1,'2020-01-23 13:13:55','2020-01-24 18:27:31'),(10,'/services/corporate','Corporate - Sapphire Limousine','Sapphire limo corporate service page',1,1,1,'2020-01-23 13:14:38','2020-01-24 18:27:40'),(11,'/services/party-limo-bus','Party Bus Limo - Sapphire Limousine','Sapphire limo party limo bus service page',1,1,1,'2020-01-23 13:16:31','2020-01-29 17:00:11'),(12,'/services/proms','Proms - Sapphire Limousine','Sapphire limo prom service page.',1,1,1,'2020-01-23 13:17:03','2020-01-24 18:28:04'),(13,'/services/wedding-limousines','Toronto Wedding Limo & Party Bus, Wedding Limo Rentals Service Toronto','Sapphire limo wedding limousines service page',1,1,1,'2020-01-23 13:17:42','2021-12-09 15:52:21'),(14,'/contact-us','Contact Us - Sapphire Limousine','Sapphire limo contact us page',1,1,1,'2020-01-23 13:18:15','2020-01-29 16:38:48'),(15,'/password/reset','Reset Password - Sapphire Limousine','Sapphire limo password reset page.',1,1,1,'2020-01-23 13:18:56','2020-01-29 17:05:27'),(16,'/thank-you','Thank You - Sapphire Limousine','Sapphire limo thank you page',1,1,1,'2020-01-23 13:19:29','2021-12-09 15:51:31'); /*!40000 ALTER TABLE `metas` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `migrations` -- DROP TABLE IF EXISTS `migrations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `migrations` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `migration` varchar(191) NOT NULL, `batch` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=58 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `migrations` -- LOCK TABLES `migrations` WRITE; /*!40000 ALTER TABLE `migrations` DISABLE KEYS */; INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (32,'2014_10_12_000000_create_users_table',1),(33,'2014_10_12_100000_create_password_resets_table',1),(34,'2020_01_09_085350_add_usertype_user_table',1),(35,'2020_01_10_062502_create_fleets_table',1),(36,'2020_01_10_062548_create_fleet_image_table',1),(37,'2020_01_10_062622_create_ride_reservations_table',1),(38,'2020_01_10_094739_create_contacts_table',1),(39,'2020_01_10_102545_create_social_media_tags_table',1),(40,'2020_01_10_112048_create_testimonials_table',1),(41,'2020_01_14_043255_create_metas_table',1),(42,'2020_01_14_075126_add_is_read_to_contacts_table',1),(43,'2020_01_15_090705_create_blogs_table',1),(44,'2020_01_15_090949_add_publish_date_to_blogs_table',1),(45,'2020_01_15_114356_create_comments_table',1),(46,'2020_01_20_112757_add_rating_testimonial_table',1),(47,'2020_01_21_042333_add_approved_column_to_comments_table',1),(48,'2020_01_21_060317_create_faqs_table',1),(49,'2020_01_22_115648_add_column_in_blogs_table',2),(50,'2020_01_23_060632_add_video_thumb_fleets_table',3),(51,'2020_01_23_100717_remove_designation_column_from_testimonials',3),(52,'2020_01_23_112919_change_datatype_in_comments',4),(53,'2020_01_23_122736_add_column_in_fleets_table',5),(54,'2020_01_27_091832_add_category_in_faqs_table',6),(55,'2020_02_06_100951_edit_approved_column_to_comments_table',7),(56,'2021_11_22_064324_create_index_in_fleets_table',8),(57,'2021_11_22_065049_add_index_for_testimonials_table',8); /*!40000 ALTER TABLE `migrations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `password_resets` -- DROP TABLE IF EXISTS `password_resets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `password_resets` ( `email` varchar(191) NOT NULL, `token` varchar(191) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, KEY `password_resets_email_index` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `password_resets` -- LOCK TABLES `password_resets` WRITE; /*!40000 ALTER TABLE `password_resets` DISABLE KEYS */; INSERT INTO `password_resets` (`email`, `token`, `created_at`) VALUES ('vikas@kinexmedia.com','$2y$10$gIg5iQLxVNyc7uEuFg7jKOaAtCse35k/j7R1QRBzwNbnrC1Tn2tqi','2020-01-30 17:18:45'); /*!40000 ALTER TABLE `password_resets` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ride_reservations` -- DROP TABLE IF EXISTS `ride_reservations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ride_reservations` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `email` varchar(50) NOT NULL, `phone` varchar(50) NOT NULL, `date` date NOT NULL, `event` varchar(200) NOT NULL, `vehicle_type` varchar(200) NOT NULL, `message` varchar(3000) NOT NULL, `status` varchar(200) NOT NULL DEFAULT 'New', `cancel_reason` varchar(3000) DEFAULT NULL, `notes` varchar(4000) DEFAULT NULL, `fleet_id` bigint(20) unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `ride_reservations_fleet_id_foreign` (`fleet_id`), CONSTRAINT `ride_reservations_fleet_id_foreign` FOREIGN KEY (`fleet_id`) REFERENCES `fleets` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ride_reservations` -- LOCK TABLES `ride_reservations` WRITE; /*!40000 ALTER TABLE `ride_reservations` DISABLE KEYS */; INSERT INTO `ride_reservations` (`id`, `name`, `email`, `phone`, `date`, `event`, `vehicle_type`, `message`, `status`, `cancel_reason`, `notes`, `fleet_id`, `created_at`, `updated_at`) VALUES (1,'Prabh2 Prabh2','prabh2@yopmail.com','9855576635','2020-08-22','Birthday Party','Party Bus','message','New',NULL,NULL,NULL,'2020-01-24 17:24:54','2020-01-24 17:24:54'),(2,'Elisa','elisa@yopmail.com','1234567890','2020-01-28','Dinner','Party Bus','Test','Confirmed',NULL,NULL,NULL,'2020-01-24 18:13:38','2020-01-24 18:14:13'),(3,'Mack','mack@yopmail.com','1234567890','2020-02-28','Dinner','Party Bus','Test message','Cancel','No reason',NULL,NULL,'2020-01-24 18:15:54','2020-01-24 18:16:28'),(4,'Jasmine','jasmine@yopmail.com','9876543210','2020-02-11','Night Out','Stretch Limousine','Message for Ride booking','Completed',NULL,NULL,NULL,'2020-01-27 13:07:58','2020-01-27 13:11:23'),(5,'Elis','elis@yopmail.com','1234567890','2020-02-11','Corporate','Sedan and SUV','test','New',NULL,NULL,NULL,'2020-01-27 13:22:33','2020-01-27 13:22:33'),(6,'Test user','test@yopmail.com','111111111111','2020-11-23','Birthday Party','Stretch Limousine','test','New',NULL,NULL,NULL,'2020-01-29 13:18:38','2020-01-29 13:18:38'),(7,'test','test@yopmail.com','21121212121','2020-11-23','Birthday Party','Stretch Limousine','tets','New',NULL,NULL,NULL,'2020-01-29 13:21:45','2020-01-29 13:21:45'),(8,'Test','John@yopmail.com','(356) 573-5753','2020-11-23','Night Out','Party Bus','Test','New',NULL,NULL,NULL,'2020-01-29 15:16:07','2020-01-29 15:16:07'),(9,'user','test@yopmail.com','(212) 121-2121','2020-11-23','Prom','Party Bus','test','New',NULL,NULL,NULL,'2020-01-29 17:09:00','2020-01-29 17:09:00'),(10,'user','user@yopmail.com','(545) 455-4545','2020-11-23','Birthday Party','Sedan and SUV','test','Confirmed',NULL,NULL,NULL,'2020-01-29 17:11:45','2020-01-30 17:09:53'),(11,'bvb','bn@yopmail.com','(222) 222-2222','2020-03-11','Corporate','Party Bus','ddfd','New',NULL,NULL,NULL,'2020-02-11 13:20:11','2020-02-11 13:20:11'),(12,'Test','test@yopmail.com','(454) 545-4545','2020-02-21','Prom','Party Bus','test','Completed',NULL,NULL,NULL,'2020-02-12 15:02:13','2020-03-23 15:11:23'),(13,'Anna Steel','anna.steel@yopmail.com','(123) 456-7890','2020-12-15','Birthday Party','Party Bus','In publishing and graphic design, Lorem ipsum is a placeholder text commonly used to demonstrate the visual form of a document or a typeface without relying on meaningful content. Wikipedia','New',NULL,NULL,NULL,'2020-06-17 18:57:07','2020-06-17 18:57:07'),(14,'Will Traynor','will.traynor@yopmail.com','(543) 216-7890','2020-12-15','Birthday Party','Sedan and SUV','In publishing and graphic design, Lorem ipsum is a placeholder text commonly used to demonstrate the visual form of a document or a typeface without relying on meaningful content. Wikipedia','New',NULL,NULL,NULL,'2020-06-17 19:05:30','2020-06-17 19:05:30'),(15,'Will Traynor','will.traynor@yopmail.com','(543) 216-7890','2020-12-15','Birthday Party','Sedan and SUV','In publishing and graphic design, Lorem ipsum is a placeholder text commonly used to demonstrate the visual form of a document or a typeface without relying on meaningful content. Wikipedia','New',NULL,NULL,NULL,'2020-06-17 19:05:32','2020-06-17 19:05:32'),(16,'Kinex Test','kinexmediatest@yopmail.com','(156) 456-5756','2022-12-12','Birthday Party','Party Bus','test','New',NULL,NULL,NULL,'2021-11-24 14:24:41','2021-11-24 14:24:41'),(17,'Kinex Test','kinexmediatest@yopmail.com','(156) 456-5756','2022-12-12','Dinner','Party Bus','test','New',NULL,NULL,NULL,'2021-11-24 15:27:29','2021-11-24 15:27:29'),(18,'Kinex Test','kinexmediatest@yopmail.com','(156) 456-5756','2022-12-12','Birthday Party','Party Bus','test','New',NULL,NULL,NULL,'2021-11-24 15:28:30','2021-11-24 15:28:30'),(19,'Kinex Media Test','kinexmediatesting@yopmail.com','(987) 654-3210','2022-02-02','Birthday Party','Party Bus','Testing Message','New',NULL,NULL,NULL,'2021-11-25 11:56:27','2021-11-25 11:56:27'),(20,'Kinex User','kinex.user@yopmail.com','(123) 456-7890','2021-12-05','Birthday Party','Party Bus','Testing','New',NULL,NULL,NULL,'2021-11-25 12:48:21','2021-11-25 12:48:21'),(21,'Kinex Test','Kinextest@yopmail.com','(123) 456-7890','2021-11-26','Birthday Party','Sedan and SUV','Test Form','New',NULL,NULL,NULL,'2021-11-25 13:39:39','2021-11-25 13:39:39'),(22,'Elisa','elisa.mcguire@yopmail.com','(123) 456-7890','2021-11-26','Birthday Party','Party Bus','Test user form','New',NULL,NULL,NULL,'2021-11-25 14:07:39','2021-11-25 14:07:39'),(23,'Matt Mcguire','matt.mcguire@yopmail.com','(123) 456-7890','2021-11-30','Birthday Party','Stretch Limousine','test form','New',NULL,NULL,NULL,'2021-11-25 14:18:55','2021-11-25 14:18:55'),(24,'Oliv','oli.mcguire@yopmail.com','(123) 456-7890','2021-11-26','Corporate','Stretch Limousine','test','New',NULL,NULL,NULL,'2021-11-25 17:02:42','2021-11-25 17:02:42'),(25,'Henry','henry@yopmail.com','(123) 456-7890','2021-11-26','Prom','Party Bus','test','New',NULL,NULL,NULL,'2021-11-25 17:09:26','2021-11-25 17:09:26'),(26,'Elisa','elisa@yopmail.com','(123) 456-7890','2021-11-26','Birthday Party','Party Bus','test','New',NULL,NULL,NULL,'2021-11-25 17:20:10','2021-11-25 17:20:10'),(27,'Chris','chris@yopmail.com','(123) 456-7890','2021-12-22','Dinner','Party Bus','test','New',NULL,NULL,NULL,'2021-11-25 17:22:05','2021-11-25 17:22:05'),(28,'Lisa','lisa.mcguire@yopmail.com','(123) 456-7890','2021-11-28','Birthday Party','Party Bus','test','New',NULL,NULL,NULL,'2021-11-25 17:24:38','2021-11-25 17:24:38'),(29,'Rose Mcguire','rose.mcguire@yopmail.com','(123) 456-7890','2022-01-31','Prom','Party Bus','Test Form','New',NULL,NULL,NULL,'2021-11-30 19:15:50','2021-11-30 19:15:50'),(30,'Riyaa Kumari','riya@yopmail.com','(987) 654-3210','2022-02-02','Corporate','Sedan and SUV','Test','New',NULL,NULL,NULL,'2021-12-09 14:26:47','2021-12-09 14:26:47'); /*!40000 ALTER TABLE `ride_reservations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `social_media_tags` -- DROP TABLE IF EXISTS `social_media_tags`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `social_media_tags` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `twitter_site` varchar(200) DEFAULT NULL, `twitter_title` varchar(500) NOT NULL, `twitter_description` varchar(3000) DEFAULT NULL, `twitter_image` varchar(500) DEFAULT NULL, `og_locale` varchar(50) DEFAULT NULL, `og_title` varchar(500) DEFAULT NULL, `og_image` varchar(500) DEFAULT NULL, `og_image_height` smallint(6) DEFAULT NULL, `og_image_width` smallint(6) DEFAULT NULL, `og_site_name` varchar(500) NOT NULL, `og_description` varchar(3000) DEFAULT NULL, `og_url` varchar(200) DEFAULT NULL, `og_type` varchar(200) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `social_media_tags` -- LOCK TABLES `social_media_tags` WRITE; /*!40000 ALTER TABLE `social_media_tags` DISABLE KEYS */; INSERT INTO `social_media_tags` (`id`, `twitter_site`, `twitter_title`, `twitter_description`, `twitter_image`, `og_locale`, `og_title`, `og_image`, `og_image_height`, `og_image_width`, `og_site_name`, `og_description`, `og_url`, `og_type`, `created_at`, `updated_at`) VALUES (1,'@sapphire','Party Bus Toronto, Party Limo Bus & Rental Service Toronto - SapphireLimo','SapphireLimo offers party bus Toronto with luxury features. Our chauffeurs provide the best limo bus rental services in Toronto & Mississauga flawlessly include weddings, proms, parties, & events as well.','wedding-limousine-oakville.jpg','en-US','Party Bus Toronto, Party Limo Bus & Rental Service Toronto - SapphireLimo','wedding-limousine-oakville.jpg',600,900,'Sapphire Limousine','SapphireLimo offers party bus Toronto with luxury features. Our chauffeurs provide the best limo bus rental services in Toronto & Mississauga flawlessly include weddings, proms, parties, & events as well.','https://staging.sapphirelimo.km2.ca/','website','2020-01-23 13:22:22','2020-01-24 20:02:40'); /*!40000 ALTER TABLE `social_media_tags` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `testimonials` -- DROP TABLE IF EXISTS `testimonials`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `testimonials` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) NOT NULL, `image` varchar(191) DEFAULT NULL, `comment` text NOT NULL, `is_active` tinyint(1) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `rating` decimal(5,1) NOT NULL DEFAULT 0.0, PRIMARY KEY (`id`), KEY `testimonials_is_active_index` (`is_active`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `testimonials` -- LOCK TABLES `testimonials` WRITE; /*!40000 ALTER TABLE `testimonials` DISABLE KEYS */; INSERT INTO `testimonials` (`id`, `name`, `image`, `comment`, `is_active`, `created_at`, `updated_at`, `rating`) VALUES (1,'Mackay','1579866666.jpg','\"Excellent services at the most convenient services. Sapphire Limousine made my birthday party even more special with the awesome ride and so many facilities. The chauffeur was really well behaved and everything else was even superb. I will surely be hiring this company again & again. Thank you guys.\"',1,'2020-01-24 19:51:06','2020-01-24 19:51:06',5.0),(2,'Mandy','1579866700.jpg','\"Hiring Sapphire Limousine was surely the best decision I made for my wedding. Their services were all on time and the hospitality was outstanding. Thank you for making my big day even more special. I will surely recommend this company to all my friends in Future.\"',1,'2020-01-24 19:51:40','2020-01-24 19:51:40',5.0),(3,'Daryl','1579866728.jpg','\"I hired this company for my airport travel and somehow I got late during pickup yet the chauffeur was already present and very cool with the situation. He drove me safely to the airport in time and I could catch the flight which I would have otherwise missed.Thank you for the awesome service.\"',1,'2020-01-24 19:52:08','2020-01-24 19:52:08',5.0); /*!40000 ALTER TABLE `testimonials` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `users` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `first_name` varchar(191) NOT NULL, `email` varchar(191) NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(191) NOT NULL, `remember_token` varchar(100) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `last_name` varchar(191) NOT NULL, `is_active` tinyint(1) NOT NULL DEFAULT 1, `user_type` tinyint(3) unsigned NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `users_email_unique` (`email`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; INSERT INTO `users` (`id`, `first_name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `last_name`, `is_active`, `user_type`) VALUES (1,'Vikas','vikas@kinexmedia.com',NULL,'$2y$10$AOABuAZBaf2CUtx3zwM6pedYndfbQ9nqXLEnGWpb5ZnovxvTP3DV.','dX4e1Z9ESzgIm4ZL1e3xNyc5x7XTNxYt98MnRhAWFAjdFRdO93wWnQMKNcKL','2020-01-23 12:10:03','2020-01-30 17:16:23','Bansal',1,1); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping events for database 'sapphire_staging' -- -- -- Dumping routines for database 'sapphire_staging' -- /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2022-11-29 23:54:30