-- https://www.phpmyadmin.net/
--

START TRANSACTION;



-- --------------------------------------------------------

--
-- Table structure for table `cms`
--

CREATE TABLE `cms` (
  `stid` int(11) NOT NULL,
  `title` varchar(150) NOT NULL,
  `tabname` varchar(150) NOT NULL,
  `content` text NOT NULL,
  `status` int(15) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cms`
--

INSERT INTO `cms` (`stid`, `title`, `tabname`, `content`, `status`) VALUES
(1, 'About us', 'Aboutus', '           <h4>The Best Care For Your Pets Anywhere \"Call Uncle Jeff\"<br>&nbsp; &nbsp; &nbsp;Main 818-884-8757&nbsp; Mobile 818-378-9934</h4>\r\n<p>We all love our pets and we would love to take them everywhere we go, but that\'s not always possible. That is why we hope you will call your pet\'s favorite Uncle when you think of pet care and boarding. Uncle Jeff\'s Pet Sitting &amp; More provides doggy day care, dog/ puppy training, dog walking, daily activities for puppies and adult dogs, large exercise area with puppy pools and cat and dog boarding services in Canoga park, California. Also offering his services in&nbsp; Winnetka, Woodland Hills, West Hills, Calabasas, and Agoura Hills, Uncle Jeff is an expert veterinarian technician since 1999 with experience in taking care of animals of all kinds. From dog dental cleaning to cat and dog grooming, your pet\'s health and well-being is Uncle Jeff\'s highest priority.Check out our<a href=\"services.html\"> list of services.</a></p>\r\n \r\n				   <h4>Pet Sitting Services with T.L.C. in Canoga Park, California</h4>\r\n<p>Never worry about your beloved pets no matter where you are when you leave them at Uncle Jeff\'s. Our comprehensive cat and dog boarding services includes round-the-clock attention, daily walking assistance, on-time feeding, administering of medicine (if needed), comfortable beddings, and lots more. For your peace of mind, we even send pictures and updates of your pets while you\'re away. With kind and gentle care, your dear pups and feline friends will be in good hands as they are comforted within a clean, safe, and healthy environment - guaranteed.<br>\r\nUncle Jeff\'s Pet Sitting &amp; More is bonded, insured, and is a member of the A.S.P.C.A and Humane Society. With plenty of repeat clients, references are likewise available upon request.<br>\r\nWhen you need expert dog or puppy training in West Hills, full-service cat or dog boarding in Calabasas, or nurturing dog walking and doggy day care services in Woodland Hills, Uncle Jeff has you covered. Take your pets to their home away from home and contact Uncle Jeff\'s Pet Sitting &amp; More today.</p>\r\n \r\n<h4>I am concerned with the health and well being of your pet!</h4>\r\n<p>I believe in kind and gentle care of all animals and know that you will get only love and appreciation from your pets.your pets are guaranteed to be cared for in a clean,safe and healthy environment.<br>\r\nI have a lot of repeat clients and plenty of references. references available upon request!</p>\r\n<h4>Member of the better business bureau!</h4>\r\n<p>Member of A.S.P.C.A and Humane Society<br>\r\nBonded and insured Since 2000<br>Canoga Park, 91304</p><br>', 0),
(2, 'Training & Grooming', 'Training', '\r\n<p>We train adult dog and puppies in potty training and basic obedience at Uncle Jeff\'s. Training method is derived from Positive Reinforcement and reward techniques used by Cesar Milan, \"The Dog Whisperer\". I have 18 plus years experience in Dog training and have a very good rate of success.</p>\r\n<p>\r\nOur Grooming Services consist of clipping and bathing for existing uncle Jeff\'s clientele whom board or doggy day care. We also bath Cats.</p>', 0),
(3, 'We Love Pets', 'index', '            <h3>We Love Pets</h3>\r\n               <p>Never worry about your beloved pets no matter where you are when you leave them at Uncle Jeff\'s. Our comprehensive cat and dog boarding services includes round-the-clock attention, daily walking assistance, on-time feeding, administering of medicine (if needed), comfortable bedding, and lots more. For your peace of mind, we even send pictures and updates of your pets while you\'re away. With kind and gentle care, your dear pups and feline friends will be in good hands as they are comforted within a Clean, Safe, Healthy and Secure environment - guaranteed. Serving Canoga Park, Woodland Hills, West Hills, Calabasas and the entire San Fernando Valley</p>\r\n               <a href=\"contact.html\" class=\"btn\">Contact us</a>', 0);

-- --------------------------------------------------------

--
-- Table structure for table `gallery`
--

CREATE TABLE `gallery` (
  `sid` int(11) NOT NULL,
  `title` varchar(50) NOT NULL,
  `fimage` varchar(150) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `gallery`
--

INSERT INTO `gallery` (`sid`, `title`, `fimage`) VALUES
(1, '', 'gallery1.jpg'),
(2, '', 'gallery2.jpg'),
(3, '', 'gallery3.jpg'),
(4, '', 'gallery4.jpg'),
(5, '', 'gallery5.jpg'),
(6, '', 'gallery6.jpg'),
(7, '', 'gallery7.jpg'),
(8, '', 'gallery8.jpg'),
(9, '', 'gallery9.jpg'),
(10, '', 'gallery10.jpg'),
(11, '', 'gallery11.jpg'),
(12, '', 'gallery12.jpg'),
(13, '', 'gallery13.jpg'),
(14, '', 'gallery14.jpg'),
(15, '', 'gallery15.jpg'),
(16, '', 'gallery16.jpg'),
(17, '', 'gallery17.jpg'),
(18, '', 'gallery18.jpg'),
(19, '', 'gallery19.jpg'),
(20, '', 'gallery20.jpg'),
(21, '', 'gallery21.jpg'),
(22, '', 'gallery22.jpg'),
(23, '', 'gallery23.jpg'),
(24, '', 'gallery24.jpg'),
(25, '', 'gallery25.jpg'),
(26, '', 'gallery26.jpg'),
(27, '', 'gallery27.jpg'),
(28, '', 'gallery28.jpg'),
(29, '', 'gallery29.jpg'),
(30, '', 'gallery30.jpg'),
(31, '', 'gallery31.jpg'),
(32, '', 'gallery32.jpg'),
(33, '', 'gallery33.jpg'),
(34, '', 'gallery34.jpg'),
(35, '', 'gallery35.jpg'),
(36, '', '20171216_131513003 (1).jpeg'),
(37, '', 'gallery37.jpg'),
(38, '', 'gallery38.jpg'),
(39, '', 'gallery39.jpg'),
(40, '', 'gallery40.jpg'),
(41, '', 'gallery41.jpg'),
(42, '', 'gallery42.jpg'),
(43, '', 'Resized_20171223_134856_6029 (3).jpeg'),
(45, '', '20181027_113610.jpg'),
(46, '', '20181026_100937 (1).jpg'),
(47, '', '20180523_110611.jpg'),
(48, '', '-1895682487_20181201_143633_2050350.jpg'),
(49, '', '-437545096_20181213_130438_2036667.jpg'),
(50, '', '922142189_FB_IMG_1544771857990_141929.jpg'),
(52, '', '1617819343_20181202_154854_1705329.jpg'),
(53, '', '-1895682487_20181201_143633_2050350.jpg'),
(54, '', '-437545096_20181213_130438_2036667.jpg'),
(55, '', '1617819343_20181202_154854_1705329.jpg'),
(56, '', '-1895682487_20181201_143633_2050350.jpg'),
(57, '', '2126545093_Resized_20171223_134856_6029_174007.jpeg'),
(58, '', 'jeffuncle.jpg');

-- --------------------------------------------------------

--
-- Table structure for table `ourservices`
--

CREATE TABLE `ourservices` (
  `id` int(11) NOT NULL,
  `title` varchar(150) NOT NULL,
  `content` text NOT NULL,
  `image` varchar(150) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ourservices`
--

INSERT INTO `ourservices` (`id`, `title`, `content`, `image`) VALUES
(1, 'Boarding', ' Uncle Jeff\'s Pet Sitting &amp; More is bonded, insured, and is a member of the A.S.P.C.A and Humane Society. <br>', ''),
(2, 'High Quality Pet Care', 'Uncle Jeff\'s Pet Sitting &amp; More is bonded, insured, and is a member of the A.S.P.C.A and Humane Society.&nbsp; ', ''),
(3, 'Dental cleaning Service for dogs', 'Gentle Anesthesia Free Dental Cleaning, Under the Gums  and Complete Tartar Removal and Polishing', ''),
(4, 'Special care for Senior Dogs', 'Uncle Jeff\'s Pet Sitting &amp; More is bonded, insured, and is a member of the A.S.P.C.A and Humane Society.&nbsp; ', ''),
(5, 'Exotic Birds and Reptiles', 'Experience with Amazons, Cockatoos, Cockatiels , Parkeets  and all small  birds.', ''),
(6, 'Dental Service', 'Thorough Cleaning of the Teeth and Gums, Polishing and Rinsing', ''),
(7, 'Boarding For Cats', ' home style boarding for cats ', ''),
(8, 'Pet Hotel', 'Take your pets to their home away from home and contact Uncle Jeff\'s Pet Sitting &amp; More today. ', ''),
(9, 'Dog Walking', 'One or multiple dogs we handle your dog walking needs ', '');

-- --------------------------------------------------------

--
-- Table structure for table `overview`
--

CREATE TABLE `overview` (
  `sid` int(11) NOT NULL,
  `kname` varchar(1000) NOT NULL,
  `Description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `overview`
--

INSERT INTO `overview` (`sid`, `kname`, `Description`) VALUES
(1, 'Customer Service', 'Our customers are the most important asset to our business and our\r\n\r\nnetwork of Professional, Talented Chauffers in Canada who knows\r\ntheir way around Toronto, Ontario. Canada. Each and every member\r\n\r\nof our team knows we are not doing\r\ncustomers a courtesy by delivering a service, they are doing us a\r\ncourtesy by giving us an opportunity to do so our Goal and\r\n\r\ncommitment is customer comes first \" Canada Executive Limousine\r\n\r\ndoes more than pick you up from your destination, we take care of\r\n\r\nyou too.<br><br>\r\n	\r\nThis begins with the customers initial contact with Canada limo, we\r\nare the best first-in-class ground transportation, Airport limo\r\nChauffer, VIP meet and greet and tour services in Canada with over\r\n10 years of experience providing best transportation, limo service to\r\nvariety of travelling customers, from Celebrities to corporate\r\nexecutive, brides, grooms and everyday travelers, We offer reliable\r\ndoor-to-door limo service in Toronto and GTA, Our fleet is\r\nmeticulously cared for and maintained with the highest level of care.\r\nwe detail cleaned our sedans and SUVs regularly. All of this created\r\nonly to serve our customers better'),
(2, 'Corporate Occasions', '<p>Your business is demanding, so why worry about the transportation of your employees and clients. Professionalism and discretion is our top priority.<br>\r\n</p>\r\n<p>\r\n<p class=\"p2\"><i class=\"fa fa-check-square-o fa-2x fa-fw checks\"></i>Airport Limo Pick Ups</p>\r\n<p class=\"p2\"><i class=\"fa fa-check-square-o fa-2x fa-fw checks\"></i>Limousine Airport Drop Offs</p>\r\n<p class=\"p2\"><i class=\"fa fa-check-square-o fa-2x fa-fw checks\"></i>Meet & Greet, Child Car Seats</p>\r\n\r\n</p>'),
(3, 'Hourly Travel', '<p>You will be sure to arrive in style when you and your guests arrive to your destination with Network Executive Limousine. Our new and diverse fleet of vehicles are the finest in luxury transportation and can get you to your next meeting safe and on time.<br>\r\n</p>\r\n<p>\r\n<p class=\"p2\"><i class=\"fa fa-check-square-o fa-2x fa-fw checks\"></i>Airport Limo Pick Ups</p>\r\n<p class=\"p2\"><i class=\"fa fa-check-square-o fa-2x fa-fw checks\"></i>Limousine Airport Drop Offs</p>\r\n<p class=\"p2\"><i class=\"fa fa-check-square-o fa-2x fa-fw checks\"></i>Meet & Greet, Child Car Seats</p>\r\n\r\n</p>'),
(4, 'Private Tours', '<p class=\"p1\">New to the city? Let Network Limo show you around and take you from place to place in luxury and style.</p>\r\n<p>\r\n<p class=\"p2\"><i class=\"fa fa-check-square-o fa-2x fa-fw checks\"></i>Airport Limo Pick Ups</p>\r\n<p class=\"p2\"><i class=\"fa fa-check-square-o fa-2x fa-fw checks\"></i>Limousine Airport Drop Offs</p>\r\n<p class=\"p2\"><i class=\"fa fa-check-square-o fa-2x fa-fw checks\"></i>Meet & Greet, Child Car Seats</p>\r\n\r\n</p>'),
(5, 'Airports & Transfers', '<p class=\"p1\">Enjoy first class means of service with door to door service to and from the airport. Sit back, relax, and let Network Limo take you to and from the airport in one of our private cars in comfort and style.</p>\r\n<p>\r\n<p class=\"p2\"><i class=\"fa fa-check-square-o fa-2x fa-fw checks\"></i>Airport Limo Pick Ups</p>\r\n<p class=\"p2\"><i class=\"fa fa-check-square-o fa-2x fa-fw checks\"></i>Limousine Airport Drop Offs</p>\r\n<p class=\"p2\"><i class=\"fa fa-check-square-o fa-2x fa-fw checks\"></i>Meet & Greet, Child Car Seats</p>\r\n\r\n</p>'),
(6, 'Special Occasions', '<p class=\"p1\">Canada Limo knows how to treat you and your guests in elegance. So if it is a night out to celebrate a birthday, an achievement, or a milestone, Canada Limo &amp; luxury transportation available for you.</p>\r\n<p>\r\n</p><p class=\"p2\"><i class=\"fa fa-check-square-o fa-2x fa-fw checks\"></i>Airport Limo Pick Ups</p>\r\n<p class=\"p2\"><i class=\"fa fa-check-square-o fa-2x fa-fw checks\"></i>Limousine Airport Drop Offs</p>\r\n<p class=\"p2\"><i class=\"fa fa-check-square-o fa-2x fa-fw checks\"></i>Meet &amp; Greet, Child Car Seats</p>\r\n\r\n<p></p>'),
(7, 'Nights Out', '<p class=\"p1\">Start your night off by arriving in style, and enjoy safe and luxury transportation door to door from the venue of your choosing.</p>\r\n<p>\r\n<p class=\"p2\"><i class=\"fa fa-check-square-o fa-2x fa-fw checks\"></i>Airport Limo Pick Ups</p>\r\n<p class=\"p2\"><i class=\"fa fa-check-square-o fa-2x fa-fw checks\"></i>Limousine Airport Drop Offs</p>\r\n<p class=\"p2\"><i class=\"fa fa-check-square-o fa-2x fa-fw checks\"></i>Meet & Greet, Child Car Seats</p>\r\n\r\n</p>'),
(8, 'Sporting Events', '<p class=\"p1\">You will be hitting a home run when you arrive in style to your sporting event. Imagine your night with no traffic or finding a parking spot. All you have to do is cheer on your home town team!</p>\r\n<p>\r\n</p><p class=\"p2\"><i class=\"fa fa-check-square-o fa-2x fa-fw checks\"></i>Airport Limo Pick Ups</p>\r\n<p class=\"p2\"><i class=\"fa fa-check-square-o fa-2x fa-fw checks\"></i>Limousine Airport Drop Offs</p>\r\n<p class=\"p2\"><i class=\"fa fa-check-square-o fa-2x fa-fw checks\"></i>Meet &amp; Greet, Child Car Seats</p>\r\n\r\n<p></p>'),
(9, 'Weddings', '<p class=\"p1\">Weddings are occasions that need to be celebrated and not fretted over. Let Network Limo help make your special day an unforgettable one.</p>\r\n<p>\r\n<p class=\"p2\"><i class=\"fa fa-check-square-o fa-2x fa-fw checks\"></i>Airport Limo Pick Ups</p>\r\n<p class=\"p2\"><i class=\"fa fa-check-square-o fa-2x fa-fw checks\"></i>Limousine Airport Drop Offs</p>\r\n<p class=\"p2\"><i class=\"fa fa-check-square-o fa-2x fa-fw checks\"></i>Meet & Greet, Child Car Seats</p>\r\n\r\n</p>'),
(10, 'Proms & Other', '<p class=\"p1\">Your prom is a night you will never forget. Start your evening off with one of our extravagant stretch limousines equipped with fiber optic lights, LCD televisions, surround sound stereo systems and plenty of comfortable seating.</p>\r\n<p>\r\n<p class=\"p2\"><i class=\"fa fa-check-square-o fa-2x fa-fw checks\"></i>Airport Limo Pick Ups</p>\r\n<p class=\"p2\"><i class=\"fa fa-check-square-o fa-2x fa-fw checks\"></i>Limousine Airport Drop Offs</p>\r\n<p class=\"p2\"><i class=\"fa fa-check-square-o fa-2x fa-fw checks\"></i>Meet & Greet, Child Car Seats</p>\r\n\r\n</p>'),
(11, 'Vip Meet & Greet', '<p class=\"p1\">A backstage pass is an employee pass which allows its bearer access to employees-only areas ... intended for specially selected fans that get to \"meet and greet\" the performers, and can also be used for guests.</p>\r\n\r\n<p>\r\n<p class=\"p2\"><i class=\"fa fa-check-square-o fa-2x fa-fw checks\"></i>Airport Limo Pick Ups</p>\r\n<p class=\"p2\"><i class=\"fa fa-check-square-o fa-2x fa-fw checks\"></i>Limousine Airport Drop Offs</p>\r\n<p class=\"p2\"><i class=\"fa fa-check-square-o fa-2x fa-fw checks\"></i>Meet & Greet, Child Car Seats</p>\r\n\r\n</p>'),
(12, 'Niagara Falls Tours', '<p class=\"p1\">The Niagara Falls is world-famous for its breathtaking beauty. business travelers from out of town and international tourists from around the world having a Limited time frame. we can design their trip according to their schedule. You can also design your own trip to Niagara Falls, Niagara on the Lake &amp; Casino Niagara with your Choice of Vehicle Time &amp; Budget in our Private Vehicle.</p>\r\n\r\n<p>\r\n</p><p class=\"p2\"><i class=\"fa fa-check-square-o fa-2x fa-fw checks\"></i>Airport Limo Pick Ups</p>\r\n<p class=\"p2\"><i class=\"fa fa-check-square-o fa-2x fa-fw checks\"></i>Limousine Airport Drop Offs</p>\r\n<p class=\"p2\"><i class=\"fa fa-check-square-o fa-2x fa-fw checks\"></i>Meet &amp; Greet, Child Car Seats</p>\r\n\r\n<p></p>'),
(13, 'Long Distance Private Car Service', '<p class=\"p1\">Your prom is a night you will never forget. Start your evening off with one of our extravagant stretch limousines equipped with fiber optic lights, LCD televisions, surround sound stereo systems and plenty of comfortable seating.</p>\r\n\r\n<p>\r\n</p><p class=\"p2\"><i class=\"fa fa-check-square-o fa-2x fa-fw checks\"></i>Airport Limo Pick Ups</p>\r\n<p class=\"p2\"><i class=\"fa fa-check-square-o fa-2x fa-fw checks\"></i>Limousine Airport Drop Offs</p>\r\n<p class=\"p2\"><i class=\"fa fa-check-square-o fa-2x fa-fw checks\"></i>Meet &amp; Greet, Child Car Seats</p>\r\n\r\n<p></p>'),
(14, 'Quality Assurance', 'Canada Limo foundation is customer service built on quality assurance programs and a dedicated Chauffer.<br>\r\n Our Quality Assurance Department focuses on the following programs:'),
(15, 'Our Customers', 'Our customers are the most important asset to our business.\r\nEach and every member of our team knows we are not doing our customers a courtesy by delivering a service, they are doing us a courtesy by giving us an opportunity to do so.'),
(16, 'OUR CLIENTS SAY IT BEST', '<h3>Read Customer Reviews</h3>'),
(17, 'Its About Time.', 'Find out why companies throughout Chicagoland and around the world are choosing Windy City Limousine for their car, limo, and bus services.');

-- --------------------------------------------------------

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `sid` int(11) NOT NULL,
  `category` int(11) NOT NULL,
  `title` varchar(50) NOT NULL,
  `content` text NOT NULL,
  `fimage` varchar(150) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `products`
--

INSERT INTO `products` (`sid`, `category`, `title`, `content`, `fimage`) VALUES
(1, 1, '1110', '<p> G2.5 / GCG6 <br> G2.5 18 1/2\"W x 21\"D x 27 1/2\"H <br> GCG6 22 1/2\"W x 21\"D x 36 1/4\"H <br> G2.5 2 Flat Shelves / GCG6 3 Flat Shelves </p>\n              \n      			<p>1110.49 COOL G2.5 Strbucks Dbl Sht <br> 1110.55 COOL G2.5 Starbucks <br> 1110.57 COOL GCG6 Cntrtp Rockstar <br> 1110.99 Mini Cntrtp Spec Graph</p>', '21.jpg'),
(2, 1, '1119', '<p> G4 <br> 18\"W x 21\"D x 42\"H <br> 3 Flat Wire Shelves <br> - </p>\n                            <br>\n      			<p>1119.25 COOL G4 Mt. Dew <br> 1119.55 COOL G4 Starbucks <br> 1119.99 COOL G4 Black <br> - </p>', '22.jpg'),
(3, 1, '1120', '<p> 6 or 7 Cubic Foot <br> 21 1/4\" W x 25\"D x 37 3/4\"H <br> 2 Flat Wire Shelves = 96 Bottles <br> - </p>\n                    <p>1120.10 6/7 CF Pepsi <br> 1120.20 6/7 CF Aquafina <br> 1120.30 6/7 CF Gatorade <br> 1120.32 6/7 CF HG <br> 1120.55 6/7 CF Starbucks <br> 1120.65 6/7 CF Lipton Pure <br> 1120.84 6/7 CF KFC-Pepsi <br> 1120.99 6/7 CF Spec Graphics </p', '23.jpg'),
(4, 1, '1130', '         <p> 10 Cubic Foot <br> 25 5/8\"W x 22 3/4\"D x 54\"H <br> 3 Flat Wire Shelves = 126 Bottles </p>\n                    <p>3 Flat Wire Shelves = 126 Bottles <br> 1130.25 1-DR 10 CF Mtn Dew <br> 1130.32 1-DR 10 CF HG <br> 1130.42 1-DR 10 CF Hydration Pop - White <br> 1130.55 1-DR 10 CF Starbucks <br> 1130.57 1-DR 10 CF Rockstar <br> 1130.65 1-DR 10 CF Lipton Pure <br> 1130.69 COOL 1-DR 10 CF Life WTR <br> 1130.99 1-DR 10 CF Spec Graph </p>', ''),
(5, 1, '1140', '<p> 12 Cubic Foot <br> 25 5/8\"W x 25\"D x 62 1/4\"H <br> 4 Flat Wire Shelves = 168 Bottles </p>\n                    <p>1140.10 1-DR 12 CF Pepsi <br> 1140.20 1-DR 12 CF Aquafina <br> 1140.25 1-DR 12 CF Mtn Dew <br> 1140.30 1-DR 12 CF Gatorade <br> 1140.32 1-DR 12 CF HG <br> 1140.42 1-DR 12 CF Hydration Pop - White <br> 1140.55 1-DR 12 CF Starbucks <br> 1140.57 1-DR 12 CF Rockstar <br> 1140.65 1-DR 12 CF Lipton Pure <br> 1140.69 1-DR 12 CF Life WTR <br> 1140.99 1-DR 12 CF Spec Graph </p>', '25.jpg'),
(6, 1, '1160', ' <p> 26 Cubic Foot <br> 31\"W x 30\"D x 78 1/4\"H <br> 5 Flat Wire Shelves = 360 Bottles </p>\n                    <p>1160.10 1-DR 26 CF Pepsi <br> 1160.20 1-DR 26 CF Aquafina <br> 1160.25 1-DR 26 CF Mtn Dew <br> 1160.30 1-DR 26 CF Gatorade <br> 1160.32 1-DR 26 CF HG <br> 1160.42 1-DR 26 CF Hydration Pop - White <br> 1160.55 1-DR 26 CF Starbucks <br> 1160.65 1-DR 26 CF Lipton Pure <br> 1160.99 1-DR 26 CF Spec Graph </p>', '26.jpg'),
(7, 2, '1907', '<p> Kelon FL49 Pepsi / Spec Graphic <br> 23 6/10 X 25 X 72 7/10 <br> 5 Flat Shelves = 180 20oz Bottles </p>\n                        <br>\n      			<p>1907.10 Kelon Pepsi <br> 1907.80 Kelon Spec Graphic </p>', ''),
(8, 2, '1222', '<p> QBD PC8 <br> 19 1/2 X 24 1/2 X 74 1/4 <br> 4 Flat Shelves = 150 20oz Bottles </p>\n                    <p> 1978.55 PC8 Starbucks <br> 1978.65 PC8 Lipton Pure Leaf </p>', '27.jpg'),
(9, 2, '1978', '<p> QBD PC8 <br> 19 1/2 X 24 1/2 X 74 1/4 <br> 4 Flat Shelves = 150 20oz Bottles </p>\n                    	<p> 1978.55 PC8 Starbucks <br> 1978.65 PC8 Lipton Pure Leaf </p>', ''),
(10, 2, '1333', '<p> GDM-41SL-54 <br> 47 1/4\"W x 21\"D x 54 1/8\"H <br> 6 Flat Wire Shelves = 180 </p>\n                          			<p> 1333.10 2-DR SM 41SL54 Pepsi </p>', '29.jpg'),
(11, 2, '1334', '<p> GDM33SSL-54 <br> 36\"W x 18 7/8\"D x 54 1/8H <br> 3 Wire Glide Shelves = 120 </p>\n                          			<p> 1334.10 2-DR SM 33SSL54 Pepsi </p>\n', '30.jpg'),
(12, 2, '1340', '<p> CD-4148 <br> 48\" W x 24.5\"D x 48\"H <br> 6 Flat Wire Shelves = 204 </p>\n                          			<p> 1340.10 2-DR Slide 41C48 Pepsi </p>', '30.jpg'),
(13, 2, '1360', ' <p> 45 Cubic Foot - Slide Door <br> 52\" W x 29 5/8\"D x 78 5/8\"H <br> 10 Flat Wire Shelves = 560 Bottles </p>\r\n                                    <br>\r\n      			<p> 1360.10 2-DR 45/47 CF Slide Pepsi <br> 1360.99 2-DR 45/47 Spec Graph <br></p><p><br></p><p><br></p>', '');

-- --------------------------------------------------------

--
-- Table structure for table `promotions`
--

CREATE TABLE `promotions` (
  `sid` int(11) NOT NULL,
  `title` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `fimage` varchar(250) NOT NULL,
  `status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `promotions`
--

INSERT INTO `promotions` (`sid`, `title`, `description`, `fimage`, `status`) VALUES
(10, '', ' Brake  Special $79.99 per axle	<br>\r\n							 5 qrt on oil change<br>\r\n4 Tire get 1 free \r\n						', 'g1.jpg', 1),
(11, '', 'Regular oil change $24.99+tax	<br>\n							 5 qrt on oil change<br>\n4 Tire get 1 free ', 'g2.jpg', 1),
(12, '', 'Synthetic blend.        $29.99+tax	<br>\n							 5 qrt on oil change<br>\n4 Tire get 1 free \n							 5 qrt on oil change<br>\n4 Tire get 1 free ', 'g3.jpg', 1),
(13, '', 'Fully synthetic oil.       $49.99+tax\n							<br>\n							 5 qrt on oil change<br>\n4 Tire get 1 free ', 'g4.jpg', 1);

-- --------------------------------------------------------

--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `id` int(11) NOT NULL,
  `title` varchar(150) NOT NULL,
  `content` text NOT NULL,
  `status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `services`
--

INSERT INTO `services` (`id`, `title`, `content`, `status`) VALUES
(1, 'Home Style Boarding For Dogs And Cats', ' <ul>\r\n  <li>Absolutely No Cages</li>\r\n  <li>Gated Free Roaming Environment</li>\r\n  <li>Round the clock Attention</li>\r\n  <li>Clean and healthy Environment</li>\r\n  <li>Field trips to local off leash parks</li>\r\n  <li>Fresh Purified water 3xs a day</li>\r\n  <li>On time feeding up to 3xs a day</li>\r\n  <li>Meds Administered If Needed</li>\r\n  <li>Daily walks up to 3xs a day</li>\r\n  <li>Special attention to senior or Ailing Animals</li>\r\n  <li>Daily Pet Massage</li>\r\n  <li>Brush Coat</li>\r\n  <li>Brush Teeth</li>\r\n  <li>Animal companionship available</li>\r\n  <li>Extra Bedding Available</li>\r\n  <li>Treats Available</li>\r\n  <li>Plenty of toys available for dogs and cats</li>\r\n  <li>Puppy cool off Pool</li>\r\n  <li>Lots of T.L.C.</li>\r\n  </ul>', 0),
(2, 'Doggy Day Care', '  <ul>\r\n  <li>Gated Free Roaming Environment</li>\r\n  <li>Clean and healthy Environment</li>\r\n  <li>Round the clock Attention</li>\r\n  <li>Field trips to local off leash parks</li>\r\n  <li>Fresh Purified water 3 xs a Day</li>\r\n  <li>Daily Feeding</li>\r\n  <li>Medication Administered if Necessary</li>\r\n  <li>Daily Walks</li>\r\n  <li>Daily Pet Massage</li>\r\n  <li>Brush Teeth</li>\r\n  <li>Brush Coat</li>\r\n  <li>Playtime in Gated Yard</li>\r\n  <li>Bedding for Napping</li>\r\n  <li>Animal Companionship Available</li>\r\n  <li>Treats Available</li>\r\n  <li>Plenty of toys for Dogs and Cats</li>\r\n  <li>Puppy Cool Off Pool</li>\r\n  <li>Lots of T.L.C.</li>\r\n  </ul>', 0),
(3, 'Daily Dog Walking', ' <ul>\r\n  <li>Guaranteed 50 Minute Walk Throughout Neighborhood or Park</li>\r\n  <li>Fresh Purified Water</li>\r\n  <li>Pet Massage</li>\r\n  <li>Treats Available</li>\r\n  </ul>', 0),
(4, 'In Home Daily Visits', '<ul>\r\n  <li>Guaranteed one hour visit</li>\r\n  <li>Fresh Purified Water </li>\r\n  <li>Clean Litter Box</li>\r\n  <li>Feed all Animals</li>\r\n  <li>Medications Administered If Needed</li>\r\n  <li>45 minute Dog Walk</li>\r\n  <li>Continue ongoing basic Obedience Training</li>\r\n  <li>Complete Daily home Security Checks</li>\r\n  <li>Lots of T.L.C.</li>\r\n  </ul>', 0),
(5, 'Overnight Pet Sitting', '&nbsp;     <br><ul><li>Sleepover with your pet</li><li>Feeding and Water</li><li>Dog walking</li><li>Administer Meds</li><li>Poop Cleanup</li><li>Bring in packages</li><li>Alarm Set</li></ul><div><span style=\"color: rgb(0, 0, 0); font-family: Arial, Helvetica, sans-serif; font-size: small;\"><br></span></div><div><br></div>', 0),
(6, 'Adult Dog And Puppy Training', '          <ul>\r\n  <li>Sit</li>\r\n  <li>Stay</li>\r\n  <li>Come</li>\r\n  <li>No Jumping</li>\r\n  <li>Potty Training</li>\r\n  <li>Heel</li>\r\n  <li>no biting</li>\r\n  <li>Roll Over</li>\r\n  </ul>', 0),
(7, 'Dental Cleaning For Dogs', '     <ul>\r\n  <li>Absolutely no anesthesia</li>\r\n  <li>Kind and gentile technique</li>\r\n  <li>inexpensive</li>\r\n  <li>daily appointments</li>\r\n  <li>polish and disenfect teeth and gums</li>\r\n  </ul>\r\n          ', 0),
(8, 'Horse Sitting And Overnight Care', '<ul>\r\n  <li>Feed</li>\r\n  <li>Muck stalls </li>\r\n  <li>Longing</li>\r\n  <li>Check water source daily</li>\r\n  <li>Updates and pictures on a daily basis</li>\r\n  <li>Administer Medications if Necessary</li>\r\n  </ul>', 0),
(9, 'Pet Taxi', ' <ul>\r\n  <li>To and From</li>\r\n  <li>Groomers</li>\r\n  <li>Veterinarians</li>\r\n  <li>Anywhere</li>\r\n  <li>Pick Up And Delivery To And From Your Home</li>\r\n  </ul>', 0),
(10, 'Dog Grooming', '<ul>\r\n  <li>Baths for Dogs and Cats</li>\r\n  <li>Nail Clipping</li>\r\n  <li>Ear Cleansing</li>\r\n  <li>Teeth Cleaning</li>\r\n  <li>Flea and Tick Treatments</li>\r\n  </ul>', 0),
(11, 'Adult Dog And Puppy training', '  <ul>\r\n  <li>Training in obedience and Behavioral problems</li>\r\n  </ul>', 0),
(12, 'Experience With', ' <ul>\r\n  <li>Horses</li>\r\n  <li>Dogs</li>\r\n  <li>Cats</li>\r\n  <li>Exotic Birds</li>\r\n  <li>Fish</li>\r\n  <li>Reptiles</li>\r\n  </ul>', 0),
(13, 'Pet Bathing For Dogs And Cats', '  <ul>\r\n  <li>Horses</li>\r\n  <li>Dogs</li>\r\n  <li>Cats</li>\r\n  <li>Exotic Birds</li>\r\n  <li>Fish</li>\r\n  <li>Reptiles</li>\r\n  </ul>', 0),
(14, 'Boarding For Birds, Reptiles And Fish', '   <ul>\r\n  <li>Pet Sitting &amp; More welcomes pets from Woodland Hills, West Hills, Calabasas, Agoura Hills, and neighboring areas in California. Contact us and schedule an appointment for our cat/ dog boarding, dog &amp; puppy training, dog walking, or doggy day care services today.\r\n\r\n</li>\r\n  </ul>', 0);

-- --------------------------------------------------------

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(11) NOT NULL,
  `phone` varchar(50) NOT NULL,
  `fax` varchar(50) NOT NULL,
  `hours` varchar(250) NOT NULL,
  `address` varchar(250) NOT NULL,
  `email` varchar(150) NOT NULL,
  `facebook` varchar(250) NOT NULL,
  `twitter` varchar(250) NOT NULL,
  `insta` varchar(250) NOT NULL,
  `google` varchar(250) NOT NULL,
  `youtube` varchar(250) NOT NULL,
  `rss` varchar(250) NOT NULL,
  `creationDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updationDate` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `phone`, `fax`, `hours`, `address`, `email`, `facebook`, `twitter`, `insta`, `google`, `youtube`, `rss`, `creationDate`, `updationDate`) VALUES
(1001, '818-884-8757', '', '', '8444 Desoto Ave. Winnetka, CA. 91304', 'unclejeffs@aol.com', 'https://www.facebook.com/uncle Jeff', 'https://twitter.com/', 'https://www.pinintereset.com/', 'https://plus.google.com/', '', 'https://www.rss.com/', '2017-01-24 16:21:18', '10-08-2017 09:25:02 PM');

-- --------------------------------------------------------

--
-- Table structure for table `slider`
--

CREATE TABLE `slider` (
  `sid` int(11) NOT NULL,
  `title` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `fimage` varchar(250) NOT NULL,
  `status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `slider`
--

INSERT INTO `slider` (`sid`, `title`, `description`, `fimage`, `status`) VALUES
(4, '', '', '2.jpg', 1),
(5, '', '', '3.jpg', 1),
(6, '', '', '4.jpg', 1),
(7, '', '', '6.jpg', 1),
(9, '.', '.', 'geff.jpg', 1),
(10, '', '', 'jeff 3.jpg', 1);

-- --------------------------------------------------------

--
-- Table structure for table `subservice`
--

CREATE TABLE `subservice` (
  `sid` int(11) NOT NULL,
  `cid` int(11) NOT NULL,
  `serviceName` varchar(250) NOT NULL,
  `servicetab` varchar(150) NOT NULL,
  `content` text NOT NULL,
  `title` text NOT NULL,
  `keywords` text NOT NULL,
  `description` text NOT NULL,
  `status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `subservice`
--

INSERT INTO `subservice` (`sid`, `cid`, `serviceName`, `servicetab`, `content`, `title`, `keywords`, `description`, `status`) VALUES
(1, 1, 'IPHONE', 'IPHONE', '', '', '', '', 0),
(2, 1, 'SAMSUNG', 'SAMSUNG', '', '', '', '', 0),
(4, 1, 'LG', 'LG', '', '', '', '', 0),
(5, 1, 'Samsung Galaxy Note 9', 'Samsung-Galaxy-Note-9', '', '', '', '', 0),
(6, 1, 'SKY DEVICES', 'SKY-DEVICES', '', '', '', '', 0),
(7, 1, 'Blu', 'Blu', '', '', '', '', 0),
(8, 1, 'iphone x', 'iphone-x', '', '', '', '', 0),
(9, 2, 'Acer', 'Acer', '', '', '', '', 0),
(10, 2, 'Lenovo', 'Lenovo', '', '', '', '', 0),
(11, 2, 'Apple', 'Apple', '', '', '', '', 0),
(12, 2, 'Dell', 'Dell', '', '', '', '', 0),
(13, 2, 'Lenovo Computer', 'Lenovo-Computer', '', '', '', '', 0),
(14, 2, 'Hcl Computer', 'Hcl-Computer', '', '', '', '', 0),
(15, 2, 'Dell Computer', 'Dell-Computer', '', '', '', '', 0),
(16, 2, 'Acer Computer', 'Acer-Computer', '', '', '', '', 0),
(17, 3, 'Head Set', 'Head-Set', '', '', '', '', 0),
(18, 3, 'Bluetooth Headset', 'Bluetooth-Headset', '', '', '', '', 0),
(19, 3, 'Charger Wire H', 'Charger-Wire-H', '', '', '', '', 0),
(20, 3, 'Power Bank', 'Power-Bank', '', '', '', '', 0),
(21, 3, 'Wireless Charger', 'Wireless-Charger', '', '', '', '', 0),
(22, 3, 'Car Mount', 'Car-Mount', '', '', '', '', 0),
(23, 3, 'Gps Holder', 'Gps-Holder', '', '', '', '', 0),
(24, 3, 'Tv Antenna', 'Tv-Antenna', '', '', '', '', 0),
(25, 3, 'Wifi Box', 'Wifi-Box', '', '', '', '', 0),
(26, 3, 'Convert Box', 'Convert-Box', '', '', '', '', 0),
(27, 3, 'Cell Phone Cases', 'Cell-Phone-Cases', '', '', '', '', 0),
(29, 3, 'Tablet Cases', 'Tablet-Cases', '', '', '', '', 0),
(30, 3, 'Ipad Cases', 'Ipad-Cases', '', '', '', '', 0),
(31, 3, 'Cell Phone Batteries', 'Cell-Phone-Batteries', '', '', '', '', 0),
(32, 3, 'USB Pen Drives', 'USB-Pen-Drives', '', '', '', '', 0),
(33, 3, 'Car Bluetooth Transmitter', 'Car-Bluetooth-Transmitter', '', '', '', '', 0),
(34, 3, 'Aux Cable', 'Aux-Cable', '', '', '', '', 0),
(35, 3, 'Wireless Display Dongle', 'Wireless-Display-Dongle', '', '', '', '', 0),
(36, 3, 'Hd Tv Lightning Cable', 'Hd-Tv-Lightning-Cable', '', '', '', '', 0),
(37, 3, 'Hdmi Cable', 'Hdmi-Cable', '', '', '', '', 0);

-- --------------------------------------------------------

--
-- Table structure for table `testimonials`
--

CREATE TABLE `testimonials` (
  `tid` int(11) NOT NULL,
  `name` varchar(150) NOT NULL,
  `designation` varchar(150) NOT NULL,
  `quality` varchar(150) NOT NULL,
  `description` text NOT NULL,
  `service` varchar(250) NOT NULL,
  `creationDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updationDate` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `testimonials`
--

INSERT INTO `testimonials` (`tid`, `name`, `designation`, `quality`, `description`, `service`, `creationDate`, `updationDate`) VALUES
(4, 'Stephanie M', '5/31/2018 ', 'Attentiveness, experience, clean and secure environment', 'My name is Steph, and I\'m an overprotective dog mom. You know, that mom \r\nthat worries about her boy\'s hunger strikes when he\'s in a new place; \r\nhow he\'s too smart for his own good and will break into the pantry for \r\nchocolate; how he has to sleep on the bed with a pillow for his precious\r\n head... you get the picture. I am obsessed with my dog. Uncle Jeff is the only one I trust with my precious boy. he has incredible amount of experience with animals of all kinds.Uncle Jeff sends me pictures and updates while I\'m away. Love it..Gives me much needed piece of mind. Jeff is Great!<br>', 'Boarding and Doggy Day Care', '2018-11-29 22:27:23', '29-11-2018 12:27:23 PM'),
(5, 'Stacy W', '6/3/2018 ', 'Secure and safe environment', 'I just took my Pug and Pointer for their evaluation today. The space is \r\nbright, clean, and I felt at ease leaving my fur kids there. They had a \r\nreally good space lots of outside play. I cannot stress how clean it \r\nwas! My dogs spent the day there playing. They\'re currently passed out \r\nand they got full baths, and are super soft and clean. I am really \r\nexcited this near me, the staff was extremely helpful, communicative, \r\nand quick to respond. I look forward to sending them back to Uncle Jeff\'s Pet Sitting and More.<br>', 'Boarding and Doggy Day Care', '2018-11-29 22:29:00', '29-11-2018 12:29:00 PM'),
(6, 'Herman Z.', '6/18/2018', '', '<strong>Studio City, Los Angeles, CA</strong>I cannot begin to express \r\nthe amount of gratitude I have for this man! He goes above and beyond \r\nhis means to care for other people\'s animals. Just by talking to him you\r\n can tell the love and passion he has for his business. I came to him \r\nlast minute, I did not expect him to take my dog due to the last minute \r\nnature of the encounter, and special needs. Uncle Jeff\'s Pet Sitting  IS\r\n WORTH EVERY PENNY! THANK YOU! THANK YOU! THANK YOU!<br>', '', '2018-11-27 18:55:14', ''),
(7, 'Paul K', '5/31/2018 ', '', '<strong>Glendale, CA</strong>I love Uncle Jeff\'s Pet Sitting  and his \r\nanimals. My baby pup also loves going for the day  to Uncle Jeff\'s Pet \r\nSitting \'s place. <br>I gave five stars because I\'ve been to many places for various reasons but Uncle Jeff\'s Pet Sitting  is the most authentic.<br>', '', '2018-11-27 18:55:34', ''),
(8, 'Darryl C', '2/2/2018 ', '', '<strong>Los Angeles, CA</strong>When I need some place trusted but \r\nreasonable to leave my rambunctious, beautiful German Shepherd Abbey to \r\nbe watched, Uncle Jeff\'s Pet Sitting  is the man.<br>For the last few \r\nyears, when I need to go out of town I just call up Uncle Jeff\'s Pet \r\nSitting  and he is always friendly, available and ready to take Abbey.  I\r\n would highly recommend Uncle Jeff\'s Pet Sitting  to anyone.<br>', '', '2018-11-27 18:55:53', ''),
(9, 'Regina O', '5/3/2018', '', '<strong>North Valleys, Reno, NV</strong>I have used  Uncle Jeff\'s Pet \r\nSitting \'s  pet training  services.  My furbabies love Uncle Jeff\'s Pet \r\nSitting \'s,  he has done wonders with their training.  My furbabies  are\r\n so well behaved now. Uncle Jeff\'s Pet Sitting \'s  is loving and \r\ncompassionate  and patient . I would recommend  his services  to anyone \r\nwho is needing training  for their pets.<br>', '', '2018-11-27 18:56:09', ''),
(10, 'Sara M', ' 5/3/2018 ', '', '<strong>Los Angeles, CA</strong>I have been using Uncle Jeff\'s Pet \r\nSitting   for several years now and have recommended them to lots of our\r\n friends. We started with weekly dog walking with one dog and now that \r\nwe have two, they walk them both. We\'ve had a couple different caring \r\nand professional walkers over the years and also substitute walkers when\r\n we need to schedule a last minute walk. Uncle Jeff\'s Pet Sitting  is \r\nalso great - very accommodating and helpful with scheduling and last \r\nminute emergencies. He also sends me pictures of my dogs and videos to \r\nkeep me posted when I am away.<br>', '', '2018-11-27 18:56:30', ''),
(11, 'Rhea D', '6/1/2018 ', '', '<strong>Calabasas, CA  </strong>\"Uncle Jeff\'s Pet Sitting \" will dote on\r\n your animal/s and give them the care and affection they need so you can\r\n have peace of mind when they aren\'t with you.<br>', '', '2018-11-27 18:56:44', ''),
(12, 'Mali M', '8/29/2017 ', '', '<strong>WOODLAND HLS, CA</strong>first of all,  Thank you so much Uncle Jeff\'s Pet Sitting , for taking GREAT care of my friend\'s dog.<br>I\r\n called Uncle Jeff\'s Pet Sitting  at 9.30 pm. to ask him if he can help \r\nme take care of my friend\'s dog.( my friend has emergency over sea trip \r\nand he just drop off his dog at my house,  I have 2 yr boy and another 2\r\n big dogs already, so I cannot take care of extra big dog)  he told me \r\nto just bring the dog in even 10.00 pm . (I know that is very late) and I\r\n really appreciated that so much. <br>Uncle Jeff\'s Pet Sitting  is so \r\nnice, he even send me the pictures of the dog to me everyday, so we know\r\n our dog is in a good hand.<br>', '', '2018-11-27 18:57:00', ''),
(13, 'Julie P', '2/3/2018', '', '<strong>Canoga Park, Los Angeles, CA </strong>Ive been using Uncle \r\nJeff\'s Pet Sitting  now twice a month for the past year. He takes care \r\nof my 4 cats and my bichon. Uncle Jeff\'s Pet Sitting  sends me regular \r\nphotos which is so important to me. He gives me regular updates on how \r\nthey are all doing. Nothing is ever too much trouble for Uncle Jeff\'s \r\nPet Sitting . Uncle Jeff\'s Pet Sitting  is very flexible when it comes \r\nto ypur pets needs. He is \r\n					to visit your house to feed/walk/potty break or he boards at his \r\nown home. <br>For a worrier like me, the reassurances and regular photos are jsut what i need to put my mind at ease.<br>Also Uncle Jeff\'s Pet Sitting  is very reasonable in price and will try to accomodate you even at shirt notice.<br>', '', '2018-11-27 18:57:18', ''),
(14, 'Joe Marsella', ' 2010 (hired more than once)', 'Great Results, On Time, High Integrity', '<p>I\'ve written this recommendation of your work to share with other LinkedIn users.</p>\r\n    <p>Details of the Recommendation: I\'ve written this recommendation \r\nof your work to share with other LinkedIn users. Details of the \r\nRecommendation: \"I would trust nobody other than   to take care of my \r\ndog when I am away. He listens to any special arrangements I request, \r\nand he shows extra care and precaution depending on the needs of the \r\ndog. He is very flexible to changes and easy to work with. He takes \r\ngreat care of these dogs and it\'s really like they are going to visit \r\nhim as opposed to being put in a kennel.   makes my vacations that much \r\nmore relaxing because I know my dog is safe, secure, and in the company \r\nof someone who really loves dogs and most of all someone I can trust.\"</p>', 'Pet Sitting', '2018-11-27 18:59:18', ''),
(15, 'Sara Mohlin', '2001 (hired more than once)', 'Expert, Good Value, High Integrity', '<p>I\'ve written this recommendation of your work to share with other LinkedIn users..</p>\r\n    <p>Details of the Recommendation: I\'ve written this recommendation \r\nof your work to share with other LinkedIn users. Details of the \r\nRecommendation: \"Without hesitation I want to recommend  I learned of \r\nhis services from a business associate. As all of us know, there is \r\nnothing better than a recommendation from someone you know who has \r\nexperienced a service provided. When  provides Uncle Jeff\'s Pet Sitting \r\n services he leaves a daily record of is interactions with our dogs. I \r\nrecommend  without hesitation. He is the best and his is trustworthy and\r\n reliable. My dogs love.\"</p>', 'Pet Sit my dogs and groom my dogs', '2018-11-27 18:59:59', ''),
(16, 'Tom Ingram', '2009 (hired more than once)', 'Great Results, Expert, High Integrity', '<p>I\'ve written this recommendation of your work to share with other LinkedIn users.</p>\r\n    <p>Details of the Recommendation: I\'ve written this recommendation \r\nof your work to share with other LinkedIn users. Details of the \r\nRecommendation: \"The best service and attention to details. Thumps up.\"</p>', 'Pet Sitting', '2018-11-27 19:00:47', ''),
(17, 'Marilyn Vance', '2009 (hired more than once)', 'Personable, Expert, High Integrity', '<p>I\'ve written this recommendation of your work to share with other LinkedIn users.</p>\r\n    <p>Details of the Recommendation: I\'ve written this recommendation \r\nof your work to share with other LinkedIn users. Details of the \r\nRecommendation: \"  is not only very personable, knowledgeable and \r\ndependable, he is above all extremely responsible. He takes care of my \r\ntwo dogs when I am out of town and in town as well. The girls love him \r\nand are always happy to see him and eager to go with him. That should \r\ntell you something about  . Marilyn Vance\"</p>', 'Pet Care', '2018-11-27 19:01:44', ''),
(18, 'Jerry LeVine', '2005', 'Great Results, Personable, High Integrity', '<p>I\'ve written this recommendation of your work to share with other LinkedIn users.</p>\r\n    <p>Details of the Recommendation: I\'ve written this recommendation \r\nof your work to share with other LinkedIn users. Details of the \r\nRecommendation: \"  has taken care of our family pets for several years. \r\nThey love him and we feel comfortable with him caring them. He treats \r\nthem as if they were his own.\"</p>', 'Pet setting/walking', '2018-11-27 19:02:27', ''),
(19, 'Renee Pulve', '2009 (hired more than once)', 'Personable, Good Value, High Integrity', '<p>I\'ve written this recommendation of your work to share with other LinkedIn users.</p>\r\n    <p>Details of the Recommendation: I\'ve written this recommendation \r\nof your work to share with other LinkedIn users. Details of the \r\nRecommendation: \"  has taken care of both of my dogs when I needed to \r\ntravel for work. He\'s very reliable and understanding of each pets \r\nindividual needs. One of my dogs needed consistent medical care which he\r\n was happy to provide at no additional cost. If your looking for \r\npersonalized service in a home setting, then look no further.\"</p>', 'Pet Setting', '2018-11-27 19:03:06', ''),
(20, 'Michael Elliott', '2014', 'Personable, Expert, Good Valu', '<p>I\'ve written this recommendation of your work to share with other LinkedIn users.</p>\r\n    <p>Details of the Recommendation: I\'ve written this recommendation \r\nof your work to share with other LinkedIn users. Details of the \r\nRecommendation: \"  has everything covered with is pet care services. His\r\n background in working with animals has helped him create a business \r\nmodel that is sure to be successful.\"</p>', 'Pet Setting', '2018-11-27 19:03:51', ''),
(21, 'Anne DeVenzio', '2013', 'Personable, Expert, High Integrity', '<p>I\'ve written this recommendation of your work to share with other LinkedIn users.</p>\r\n    <p>Details of the Recommendation: \"  cleaned my dog\'s teeth, which \r\nis no easy task! He communicates well with people and animals. I look \r\nforward to using his services again.\"</p>', 'Animal Care', '2018-11-27 19:04:38', ''),
(22, 'Bill Johnson', 'No', 'No', '<p>I\'ve written this recommendation of your work to share with other LinkedIn users.</p>\r\n    <p>Details of the Recommendation: \"I have known   for a number of \r\nyears and I\'m impressed with the services he offers.  \'s animal care \r\nbusiness is tops in our area and you simply won\'t find any better. For \r\nspecial care with your pet see   Capco for their needs.\"</p>', 'No', '2018-11-27 19:05:21', ''),
(23, 'Hilary Kokenda', '2007 (hired more than once)', 'Great Results, Expert, High Integrity', '<p>I\'ve written this recommendation of your work to share with other LinkedIn users.</p>\r\n    <p>Details of the Recommendation: \"I highly recommend  . He has been\r\n Uncle Jeff\'s Pet Sitting  for me for several years, and my dogs are \r\nalways loved and happy under his care.\"</p>', 'Pet sitting', '2018-11-27 19:06:37', ''),
(24, 'Anthony Hall', '2002', 'Professional Services', '<p>I\'ve written this recommendation of your work to share with other LinkedIn users.</p>\r\n    <p>Details of the Recommendation: Anthony Hall has recommended you \r\non LinkedIn Anthony Hall Writerr/Producer/Director at Old Canyon Films, \r\nLLC June 23, 2014 4:44 AM Anthony Hall has recommended your work as \r\nOWNER at   This recommendation is visible in your profile.  I\'ve written\r\n this recommendation of your work to share with other LinkedIn users. \r\nDetails of the Recommendation: \"  is good with animals. He has an \r\nintuitive understanding of animal behavior and acts accordingly so as to\r\n keep the pet calm and happy.   and his team take good care with your \r\npets.\" Service Category: Pet Care Provider Year first hired: 2002 (hired\r\n more than once) Top Qualities: Personable, Expert, High Integrity</p>', 'Pet Sitting', '2018-11-27 19:07:24', ''),
(25, 'Larry Troesken', '2013', 'Integrity, Professionalism, Knowledge', '<p>I\'ve written this recommendation of your work to share with other LinkedIn users.</p>\r\n    <p>Details of the Recommendation: Larry Troesken CEO at \r\nDuplicationation Wealth Generation   really cares for each &amp; every \r\nanimal that he has in his care. A person can tell when they\'ve found \r\nsomeone passionate about what they do &amp;   obviously doesn\'t view his\r\n business as work because he loves what he does! I would leave my dogs \r\nin  \'s care again in a heart beat! August 8, 2013, Larry was  \'s client</p>', 'Pet Care', '2018-11-27 19:08:19', ''),
(26, 'Tish Smiley', '2007', 'Professionalism /High Integrity / Knowledge', '<p>I\'ve written this recommendation of your work to share with other LinkedIn users.</p>\r\n    <p>Details of the Recommendation: LinkedIn Recommendations Tish \r\nSmiley has written an updated recommendation of your work as OWNER at \r\nPET SITTING AND MORE . Here\'s a revised version of the recommendation I \r\nwrote for you. Details of the Recommendation: \" , is an incredible \r\nresource for anyone who loves their dogs and wants peace of mind that \r\ntheir canine has a safe, clean, FUN place to stay while you are out of \r\ntown - or just away at work all day. Instead of your best friend sitting\r\n in a cage all day,   creates a fluid environment where they can easily \r\ngo inside or outside, play with other dogs, or just find a place under \r\nthe tree for a nap. We love!\" Service Category: Pet Sitting Year first \r\nhired: 2007 Top Qualities: Great Results, Good Value, Creative&nbsp;&nbsp;</p>', 'Pet Sitting/ Boarding/ Doggy Day Care', '2018-11-27 19:10:00', ''),
(27, 'Robyn Bryant', '2003', 'Professionalism/Knowledge/Quality', '<p>I\'ve written this recommendation of your work to share with other LinkedIn users.</p>\r\n    <p>Details of the Recommendation: Bryant Robyn Owner/Founder \"Total \r\nEnergy Health\" &amp; \"Robyn Bryant Music and Fine art\"   Capco is \r\nincredible! I have worked with him with Uncle Jeff\'s Pet Sitting  and \r\nboarding for many years.   truly, truly loves animals and it show in his\r\n work and in the way the animals respond to him. I recommend him to \r\nanyone who needs pet care, boarding even overnight and extended care. \r\nYou won\'t find someone who cares more about your animal/s. May 2, 2012, \r\nBryant worked directly with   at Pet Sitting and more.&nbsp; &nbsp; &nbsp;</p>', 'Pet Sitting and Boarding', '2018-11-27 19:10:55', ''),
(28, 'Ray Rodriguez', '2010', 'Professionalism/Integrity/Quality', '<p>I\'ve written this recommendation of your work to share with other LinkedIn users.</p>\r\n    <p>Details of the Recommendation: LinkedIn Recommendations Raymond \r\nRodriguez has recommended your work as OWNER at I\'ve written this \r\nrecommendation of your work to share with other LinkedIn users. Details \r\nof the Recommendation: \"  does an excellent job taking care of my German\r\n Shepard dog, Roxy. She loves him and he makes her feel at home whenever\r\n I need to leave town. Thanks for all you do and continue to do for Roxy\r\n  !\" Service Category: Dog care Year first hired: 2010 (hired more than \r\nonce) Top Qualities: Great Results, Personable, Expert&nbsp; &nbsp; &nbsp;</p>', 'Pet Sitting and Boarding', '2018-11-27 19:11:40', '');

-- --------------------------------------------------------

--
-- Table structure for table `tgallery`
--

CREATE TABLE `tgallery` (
  `sid` int(11) NOT NULL,
  `title` varchar(50) NOT NULL,
  `fimage` varchar(150) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tgallery`
--

INSERT INTO `tgallery` (`sid`, `title`, `fimage`) VALUES
(1, '', 'test_1.jpg'),
(2, '', 'test_2.jpg'),
(3, '', 'test_3.jpg'),
(4, '', 'test_4.jpg'),
(5, '', 'test_5.jpg'),
(6, '', 'test_6.jpg'),
(7, '', 'test_7.jpg'),
(8, '', 'test_8.jpg');

-- --------------------------------------------------------

--
-- Table structure for table `videos`
--

CREATE TABLE `videos` (
  `id` int(11) NOT NULL,
  `title` varchar(150) NOT NULL,
  `link` text NOT NULL,
  `image` varchar(150) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `videos`
--

INSERT INTO `videos` (`id`, `title`, `link`, `image`) VALUES
(1, 'Funny cats and Dogs Compilation', 'https://www.youtube.com/embed/t8tjT9MA7yU', ''),
(2, 'Cats Meeting puppies for the first time', 'https://www.youtube.com/embed/E__F5a2pQco', ''),
(4, 'Dog hates Obama', 'https://vimeo.com/225183662', ''),
(6, 'Dog Training', 'https://vimeo.com/225183662', '');

--
-- Indexes for table `cms`
--
ALTER TABLE `cms`
  ADD PRIMARY KEY (`stid`);

--
-- Indexes for table `gallery`
--
ALTER TABLE `gallery`
  ADD PRIMARY KEY (`sid`);

--
-- Indexes for table `ourservices`
--
ALTER TABLE `ourservices`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `overview`
--
ALTER TABLE `overview`
  ADD PRIMARY KEY (`sid`);

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`sid`);

--
-- Indexes for table `promotions`
--
ALTER TABLE `promotions`
  ADD PRIMARY KEY (`sid`);

--
-- Indexes for table `services`
--
ALTER TABLE `services`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `slider`
--
ALTER TABLE `slider`
  ADD PRIMARY KEY (`sid`);

--
-- Indexes for table `subservice`
--
ALTER TABLE `subservice`
  ADD PRIMARY KEY (`sid`);

--
-- Indexes for table `testimonials`
--
ALTER TABLE `testimonials`
  ADD PRIMARY KEY (`tid`);

--
-- Indexes for table `tgallery`
--
ALTER TABLE `tgallery`
  ADD PRIMARY KEY (`sid`);

--
-- Indexes for table `videos`
--
ALTER TABLE `videos`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for table `cms`
--
ALTER TABLE `cms`
  MODIFY `stid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `gallery`
--
ALTER TABLE `gallery`
  MODIFY `sid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=59;

--
-- AUTO_INCREMENT for table `ourservices`
--
ALTER TABLE `ourservices`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `overview`
--
ALTER TABLE `overview`
  MODIFY `sid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `sid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `promotions`
--
ALTER TABLE `promotions`
  MODIFY `sid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `services`
--
ALTER TABLE `services`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1002;

--
-- AUTO_INCREMENT for table `slider`
--
ALTER TABLE `slider`
  MODIFY `sid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `subservice`
--
ALTER TABLE `subservice`
  MODIFY `sid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;

--
-- AUTO_INCREMENT for table `testimonials`
--
ALTER TABLE `testimonials`
  MODIFY `tid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

--
-- AUTO_INCREMENT for table `tgallery`
--
ALTER TABLE `tgallery`
  MODIFY `sid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `videos`
--
ALTER TABLE `videos`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
COMMIT;

