--
-- Host: localhost    Database: pitapara_disefl
-- ------------------------------------------------------


--
-- Table structure for table `banquet`
--

CREATE TABLE `banquet` (
  `kid` int(11) NOT NULL AUTO_INCREMENT,
  `simage` varchar(150) NOT NULL,
  `status` int(15) NOT NULL,
  PRIMARY KEY (`kid`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `banquet`
--

INSERT INTO `banquet` (`kid`, `simage`, `status`) VALUES (1,'bqt-1.jpg',1),(2,'bqt-2.jpg',1),(3,'bqt-3.jpg',1),(4,'bqt-4.jpg',1),(5,'bqt-5.jpg',1),(6,'bqt-6.jpg',1),(7,'bqt-7.jpg',1);

--
-- Table structure for table `flash`
--

CREATE TABLE `flash` (
  `kid` int(11) NOT NULL AUTO_INCREMENT,
  `kname` varchar(200) NOT NULL,
  `simage` varchar(200) NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`kid`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `flash`
--

INSERT INTO `flash` (`kid`, `kname`, `simage`, `status`) VALUES (1,'','contrive-kenburns-bg1.jpg',1),(2,'','contrive-kenburns-bg2.jpg',1),(3,'','slider1.jpg',1),(4,'','slider2.jpg',1);

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

CREATE TABLE `gallery` (
  `kid` int(11) NOT NULL AUTO_INCREMENT,
  `kname` varchar(150) NOT NULL,
  `simage` varchar(250) NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`kid`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

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

INSERT INTO `gallery` (`kid`, `kname`, `simage`, `status`) VALUES (1,'','1.jpg',1),(2,'','2.jpg',1),(3,'','3.jpg',1),(4,'','4.jpg',1),(5,'','5.jpg',1),(6,'','6.jpg',1),(7,'','7.jpg',1),(8,'','8.jpg',1),(9,'','9.jpg',1),(10,'','10.jpg',1),(11,'','11.jpg',1),(12,'','12.jpg',1);

--
-- Table structure for table `link`
--

CREATE TABLE `link` (
  `lid` int(11) NOT NULL AUTO_INCREMENT,
  `urlname` varchar(250) NOT NULL,
  `url` varchar(150) NOT NULL,
  `status` int(15) NOT NULL,
  PRIMARY KEY (`lid`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `link`
--

INSERT INTO `link` (`lid`, `urlname`, `url`, `status`) VALUES (1,'Rss','https://www.rss.com/',1),(2,'Youtube','https://youtube.com',1),(3,'Google+','https://plus.google.com',1),(6,'Twitter','https://www.twitter.com/',1),(7,'Facebook','https://www.facebook.com/',1);

--
-- Table structure for table `menu`
--

CREATE TABLE `menu` (
  `kid` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(150) NOT NULL,
  `description` text NOT NULL,
  `status` int(15) NOT NULL,
  PRIMARY KEY (`kid`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `menu`
--

INSERT INTO `menu` (`kid`, `name`, `description`, `status`) VALUES (1,'APPETIZERS','<div class=\"contrive-col-6\">\r\n<div class=\"contrive-icon-with-title circle left style7\">\r\n<h6>VEGETARIAN GRAPE LEAVES</h6>\r\n<p>6 pieces stuffed with rice and herbs</p>\r\n<div class=\"content_1\"><strong> $5.99 </strong></div>\r\n</div>\r\n<div class=\"contrive-icon-with-title circle left style7\">\r\n<h6>PITA CHIPS</h6>\r\n<p>Home - made pita chips seasoned with roasted Thyme (Zataar)</p>\r\n<div class=\"content_1\"><strong> $4.99 </strong></div>\r\n</div>\r\n<div class=\"contrive-icon-with-title circle left style7\">\r\n<h6>TZATZIKI SAUCE</h6>\r\n<p>Home-made blend of yogurt, cucumber, mint and lemon</p>\r\n<div class=\"content_1\"><strong> $5.99 </strong></div>\r\n</div>\r\n<div class=\"contrive-icon-with-title circle left style7\">\r\n<h6>FALAFEL</h6>\r\n<p>3 Falafel pieces with pita, Tahini and pickles</p>\r\n<div class=\"content_1\"><strong> $5.99 </strong></div>\r\n</div>\r\n<div class=\"contrive-icon-with-title circle left style7\">\r\n<h6>FOUL (FAVA BEANS)</h6>\r\n<p>Fava beans saut&eacute;ed with lemon, garlic, tomatoes, and olive oil</p>\r\n<div class=\"content_1\"><strong> $5.99 </strong></div>\r\n</div>\r\n<div class=\"contrive-icon-with-title circle left style7\">\r\n<h6>HUMMUS</h6>\r\n<p>Chickpeas blended with Tahini, lemon and garlic /	Add chicken or gyros meat for 2.00</p>\r\n<div class=\"content_3\"><strong> $5.99 </strong></div>\r\n</div>\r\n<div class=\"contrive-icon-with-title circle left style7\">\r\n<h6>BABA GHANOUSH</h6>\r\n<p>Roasted Eggplant blended with Tahini, lemon and garlic</p>\r\n<div class=\"content_1\"><strong> $5.99 </strong></div>\r\n</div>\r\n</div>\r\n<div class=\"contrive-col-6\">\r\n<div class=\"contrive-icon-with-title circle left style7\">\r\n<h6>GRANDMA EGGPLANT</h6>\r\n<p>Delicious saut&eacute;ed eggplant, peppers, and tomatoes</p>\r\n<div class=\"content_1\"><strong> $6.50 </strong></div>\r\n</div>\r\n<div class=\"contrive-icon-with-title circle left style7\">\r\n<h6>CAULIFLOWER</h6>\r\n<p>Fried cauliflower seasoned with lemon and sumac</p>\r\n<div class=\"content_1\"><strong> $5.99 </strong></div>\r\n</div>\r\n<div class=\"contrive-icon-with-title circle left style7\">\r\n<h6>FRIED CALAMARI</h6>\r\n<p>Lightly seasoned calamari served with home-made tartar sauce</p>\r\n<div class=\"content_1\"><strong> $8.99 </strong></div>\r\n</div>\r\n<div class=\"contrive-icon-with-title circle left style7\">\r\n<h6>KIBBEH</h6>\r\n<p>Shells of meat and cracked wheat stuffed with meat, onions and nuts</p>\r\n<div class=\"content_1\"><strong> $7.50 </strong></div>\r\n</div>\r\n<div class=\"contrive-icon-with-title circle left style7\">\r\n<h6>SPICY POTATOES</h6>\r\n<p>Saut&eacute;ed home-made potatoes with garlic, chili and cilantro</p>\r\n<div class=\"content_1\"><strong> $6.25 </strong></div>\r\n</div>\r\n<div class=\"contrive-icon-with-title circle left style7\">\r\n<h6>APPETIZERS SPECIAL</h6>\r\n<p>A combination of Hummus, Baba Ghanoush, Tabouli, Grape Leaves, and Falafel</p>\r\n<div class=\"content_3\"><strong> $11.99 </strong></div>\r\n</div>\r\n</div>',1),(2,'OUR GARDEN','<div class=\"contrive-col-6\">\r\n<div class=\"contrive-icon-with-title circle left style7\">\r\n<h6>TOMATO SALAD</h6>\r\n<p>Tomato slices coated with Zataar (roasted Thyme) baby Arugula, onions and feta</p>\r\n<div class=\"content_1\"><strong> $8.99 </strong></div>\r\n</div>\r\n<div class=\"contrive-icon-with-title circle left style7\">\r\n<h6>ARUGULA SALAD</h6>\r\n<p>Baby Arugula with tomatoes, onions, Kalamata olives and feta cheese</p>\r\n<div class=\"content_3\"><strong> $8.99 </strong></div>\r\n</div>\r\n<div class=\"contrive-icon-with-title circle left style7\">\r\n<h6>GREEK SALAD</h6>\r\n<p>Cucumbers, tomatoes, Kalamata olives, and feta cheese</p>\r\n<div class=\"content_1\"><strong> $8.99 </strong></div>\r\n</div>\r\n</div>\r\n<div class=\"contrive-col-6\">\r\n<div class=\"contrive-icon-with-title circle left style7\">\r\n<h6>FATTOUCH SALAD</h6>\r\n<p>Cucumbers, tomatoes, Romaine lettuce, baby arugula and onions tossed with Pita chips</p>\r\n<div class=\"content_1\"><strong> $8.99 </strong></div>\r\n</div>\r\n<div class=\"contrive-icon-with-title circle left style7\">\r\n<h6>TABOULI</h6>\r\n<p>Chopped parsley with tomatoes, onions, cracked wheat, olive oil and lemon</p>\r\n<div class=\"content_3\"><strong> $8.99 </strong></div>\r\n</div>\r\n</div>',1),(3,'VEGETARIAN SPECIALS','<div class=\"contrive-col-6\">\r\n<div class=\"contrive-icon-with-title circle left style7\">\r\n<h6>FALAFEL PLATTER</h6>\r\n<p>4 falafel patties served with Hummus, Tabouli</p>\r\n<div class=\"content_1\"><strong> $10.99 </strong></div>\r\n</div>\r\n<div class=\"contrive-icon-with-title circle left style7\">\r\n<h6>SPANAKOPITA(SPINACH PIE)</h6>\r\n<p>Puff Pastry stuffed with a blend of spinach, Feta cheese and herbs</p>\r\n<div class=\"content_1\"><strong> $10.99 </strong></div>\r\n</div>\r\n</div>\r\n<div class=\"contrive-col-6\">\r\n<div class=\"contrive-icon-with-title circle left style7\">\r\n<h6>OKRA</h6>\r\n<p>Saut&eacute;ed okra in a delicious home-made tomato sauce served with rice</p>\r\n<div class=\"content_1\"><strong> $10.99 </strong></div>\r\n</div>\r\n</div>',1),(4,'PITA SANDWICHES','<div class=\"contrive-col-6\">\r\n<div class=\"contrive-icon-with-title circle left style7\">\r\n<h6>GYROS (Lamb or Chicken)</h6>\r\n<p>Gyros meat, Tzatziki sauce, tomatoes, onions and lettuce</p>\r\n<div class=\"content_1\"><strong> $9.99 </strong></div>\r\n</div>\r\n<div class=\"contrive-icon-with-title circle left style7\">\r\n<h6>CHICKEN SHAWARMA</h6>\r\n<p>Thinly sliced marinated chicken, fries, garlic sauce and cucumber pickles</p>\r\n<div class=\"content_3\"><strong> $9.99 </strong></div>\r\n</div>\r\n</div>\r\n<div class=\"contrive-col-6\">\r\n<div class=\"contrive-icon-with-title circle left style7\">\r\n<h6>BEEF SHAWARMA</h6>\r\n<p>Thinly sliced marinated beef tomatoes, onions, cucumber pickles and Tahini sauce</p>\r\n<div class=\"content_3\"><strong> $9.99 </strong></div>\r\n</div>\r\n<div class=\"contrive-icon-with-title circle left style7\">\r\n<h6>FALAFEL PITA</h6>\r\n<p>Savory chickpeas patties, tomatoes, cucumber pickles, lettuce and tahini sauce</p>\r\n<div class=\"content_3\"><strong> $9.99 </strong></div>\r\n</div>\r\n</div>',1),(5,'OUR GRILL','<div class=\"contrive-col-6\">\r\n<div class=\"contrive-icon-with-title circle left style7\">\r\n<h6>HOUSE STYLE LAMB CHOPS</h6>\r\n<p>Well seasoned lamb chops with house spices slowly cooked to perfection</p>\r\n<div class=\"content_3\"><strong> $17.99 </strong></div>\r\n</div>\r\n<div class=\"contrive-icon-with-title circle left style7\">\r\n<h6>LAMB KABOBS</h6>\r\n<p>Marinated lamb cubes slowly cooked to perfection</p>\r\n<div class=\"content_1\"><strong> $17.99 </strong></div>\r\n</div>\r\n<div class=\"contrive-icon-with-title circle left style7\">\r\n<h6>LAMB GYROS PLATTER</h6>\r\n<p>Freshly cut lamb gyros meat</p>\r\n<div class=\"content_1\"><strong> $13.99 </strong></div>\r\n</div>\r\n<div class=\"contrive-icon-with-title circle left style7\">\r\n<h6>BEEF ICAFTA</h6>\r\n<p>Well seasoned ground beef patties slowly cooked to perfection</p>\r\n<div class=\"content_1\"><strong> $13.99 </strong></div>\r\n</div>\r\n<div class=\"contrive-icon-with-title circle left style7\">\r\n<h6>BEEF KABOBS</h6>\r\n<p>Marinated beef cubes slowly cooked to perfection</p>\r\n<div class=\"content_1\"><strong> $14.99 </strong></div>\r\n</div>\r\n</div>\r\n<div class=\"contrive-col-6\">\r\n<div class=\"contrive-icon-with-title circle left style7\">\r\n<h6>CHICKEN KABOBS</h6>\r\n<p>Marinated chicken cubes slowly cooked to perfection</p>\r\n<div class=\"content_1\"><strong> $14.99 </strong></div>\r\n</div>\r\n<div class=\"contrive-icon-with-title circle left style7\">\r\n<h6>CHICKEN SHAWARMA PLATTER</h6>\r\n<p>Marinated thin chicken slices slowly cooked to perfection</p>\r\n<div class=\"content_1\"><strong> $14.99 </strong></div>\r\n</div>\r\n<div class=\"contrive-icon-with-title circle left style7\">\r\n<h6>KABOBS MIXED GRILL</h6>\r\n<p>Combination of Beef Chicken and Kafta substitute lamb for 3.99</p>\r\n<div class=\"content_1\"><strong> $17.99 </strong></div>\r\n</div>\r\n<div class=\"contrive-icon-with-title circle left style7\">\r\n<h6>MEDITERRANEAN STYLE GROUPER</h6>\r\n<p>Pan grilled Grouper filet with lemon, olive oil and special spices</p>\r\n<div class=\"content_1\"><strong> $15.99 </strong></div>\r\n</div>\r\n</div>',1),(6,'SIDES','<div class=\"contrive-col-6\">\r\n<div class=\"contrive-icon-with-title circle left style7\">\r\n<h6>FRIES</h6>\r\n<div class=\"content_2\"><strong> $2.99 </strong></div>\r\n</div>\r\n<div class=\"contrive-icon-with-title circle left style7\">\r\n<h6>RICE</h6>\r\n<div class=\"content_2\"><strong> $2.99 </strong></div>\r\n</div>\r\n<div class=\"contrive-icon-with-title circle left style7\">\r\n<h6>FALAFEL</h6>\r\n<div class=\"content_2\"><strong> $1.25 </strong></div>\r\n</div>\r\n</div>\r\n<div class=\"contrive-col-6\">\r\n<div class=\"contrive-icon-with-title circle left style7\">\r\n<h6>EXTRA SAUCE</h6>\r\n<div class=\"content_2\"><strong> $0.75 </strong></div>\r\n</div>\r\n<div class=\"contrive-icon-with-title circle left style7\">\r\n<h6>FETA CHEESE</h6>\r\n<div class=\"content_2\"><strong> $1.00 </strong></div>\r\n</div>\r\n<div class=\"contrive-icon-with-title circle left style7\">\r\n<h6>PITA BREAD</h6>\r\n<div class=\"content_2\"><strong> $1.00 </strong></div>\r\n</div>\r\n</div>',1),(7,'DRINKS','<div class=\"contrive-icon-with-title circle left style7\">\r\n<h6>SOFT DRINK</h6>\r\n<div class=\"content_2\"><strong> $1.99 </strong></div>\r\n</div>\r\n<div class=\"contrive-icon-with-title circle left style7\">\r\n<h6>MINT LEMONADE</h6>\r\n<div class=\"content_2\"><strong> $2.99 </strong></div>\r\n</div>\r\n<div class=\"contrive-icon-with-title circle left style7\">\r\n<h6>HOT MINT TEA</h6>\r\n<div class=\"content_2\"><strong> $2.99 </strong></div>\r\n</div>\r\n<div class=\"contrive-icon-with-title circle left style7\">\r\n<h6>TURKISH COFFEE</h6>\r\n<div class=\"content_2\"><strong> $2.99 </strong></div>\r\n</div>',1),(8,'DESSERTS','<div class=\"contrive-icon-with-title circle left style7\">\r\n<h6>BAKLAVA</h6>\r\n<div class=\"content_2\"><strong> $2.99 </strong></div>\r\n</div>\r\n<div class=\"contrive-icon-with-title circle left style7\">\r\n<h6>CHOCOLATE BAKLAVA</h6>\r\n<div class=\"content_2\"><strong> $3.99 </strong></div>\r\n</div>\r\n<div class=\"contrive-icon-with-title circle left style7\">\r\n<h6>CHEESE CAKE BAKLAVA</h6>\r\n<div class=\"content_2\"><strong> $5.99 </strong></div>\r\n</div>',1);

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

CREATE TABLE `products` (
  `pid` int(11) NOT NULL AUTO_INCREMENT,
  `catid` int(15) NOT NULL,
  `pname` varchar(250) NOT NULL,
  `price` varchar(50) NOT NULL,
  `description` varchar(250) NOT NULL,
  `status` int(16) NOT NULL,
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

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

INSERT INTO `products` (`pid`, `catid`, `pname`, `price`, `description`, `status`) VALUES (1,1,'VEGETARIAN GRAPE LEAVES','5.99','6 pieces stuffed with rice and herbs  ',1),(2,1,'PITA CHIPS','4.99','Home - made pita chips seasoned with roasted Thyme (Zataar)  ',1),(3,1,'TZATZIKI SAUCE ','5.99','Home-made blend of yogurt, cucumber, mint and lemon  ',1);

--
-- Table structure for table `scroll`
--

CREATE TABLE `scroll` (
  `kid` int(11) NOT NULL AUTO_INCREMENT,
  `kname` varchar(150) NOT NULL,
  `simage` varchar(150) NOT NULL,
  `status` int(15) NOT NULL,
  PRIMARY KEY (`kid`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `scroll`
--

INSERT INTO `scroll` (`kid`, `kname`, `simage`, `status`) VALUES (1,'','project1.jpg',1),(2,'','project2.jpg',1),(3,'','project3.jpg',1),(4,'','project4.jpg',1),(5,'','project5.jpg',1),(6,'','project6.jpg',1),(7,'','project7.jpg',1),(8,'','project8.jpg',1);

--
-- Table structure for table `store`
--

CREATE TABLE `store` (
  `stid` int(15) NOT NULL AUTO_INCREMENT,
  `storename` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `description` text COLLATE latin1_general_ci NOT NULL,
  `url` varchar(250) COLLATE latin1_general_ci NOT NULL,
  `title` varchar(250) COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`stid`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `store`
--

INSERT INTO `store` (`stid`, `storename`, `description`, `url`, `title`) VALUES (1,'index','<p style=\"width:85%; margin: 0 auto;\">Welcome to Pita Paradise, a healthy Lebanese-Mediterranean eatery. At Pita Paradise, you are not just a guest, you are one of our family where we strive to provide delicious home cooking meals and outstanding service. Our menu includes large selection of appetizers, salads, meat and much more. Also,We are vegetarian and vegan glutton free friendly. Come join us and have best home made  meal dine in or take out.</p>\r\n\r\n              ','',''),(2,'About us','A new Lebanese-Mediterranean Grill serving traditional Lebanese fare in a warm village house atmosphere . Pita Paradise blends many things such as delicious Lebanese authentic food, music and surrounding atmosphere that transform time and distance to give our guest the best experience of Mediterranean dinning we can offer. We ensure that only the finest items in the market can be used in our kitchen as a result we offer wider range of appetizers , salads and grilled items that fit all kind of appetites. located in the heart of Cocoa beach, few miles from Cape Carnival port and about 45 minutes from Orlando.','',''),(3,'Catering ','We can customize our menu to fit small or large parties, weddings and birthdays events.<h1 class=\"aligncenter\">Call Us: +1 (321) 784-4874 </h1>','',''),(4,'Contact Us','coming soon...','',''),(5,'Phone','<h6>PHONE</h6>\r\n<p>+1 (321) 784-4874</p>','',''),(6,'Address','<h6> ADDRESS </h6>\r\n				        		<p> 225 W Cocoa Beach Causeway, </p>\r\n				        		<p> Cocoa Beach, FL 32931, USA </p>','',''),(7,' Working Hours','<h6> WORKING HOURS</h6> 				        		<p> Mon - Sat: 11:00 Am - 8:30 Pm </p> 				        		<p> Sunday: Closed </p>','',''),(8,'Email id','<h6>EMAIL ID</h6>\r\n<p><a href=\"\" title=\"\"> info@pitaparadisefl.com </a><br />\r\n<a href=\"\" title=\"\"> www.pitaparadisefl.com </a></p>','','');

--
-- Table structure for table `tblcategories`
--

CREATE TABLE `tblcategories` (
  `category_id` int(11) NOT NULL AUTO_INCREMENT,
  `categoryname` varchar(150) NOT NULL,
  `description` text NOT NULL,
  `simage` varchar(150) NOT NULL,
  `status` int(15) NOT NULL,
  PRIMARY KEY (`category_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tblcategories`
--

INSERT INTO `tblcategories` (`category_id`, `categoryname`, `description`, `simage`, `status`) VALUES (1,'APPETIZERS','','',1),(2,'OUR GARDEN','','',1),(3,'PITA SANDWICHES','All sandwiches served with choice of Greek Salad or fries and soft drink * Try a Mint Lemonade for only $1 more** Lunch -9.99 / Dinner- 10.99','',1),(4,'OUR GRILL','All plates served with Greek Salad and Yellow rice','',1),(5,'SIDES','','',1);

--
-- Table structure for table `testimonals`
--

CREATE TABLE `testimonals` (
  `id_test` int(11) NOT NULL AUTO_INCREMENT,
  `name_test` varchar(123) NOT NULL,
  `testimonalsdes` text NOT NULL,
  `status` int(15) NOT NULL,
  PRIMARY KEY (`id_test`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `testimonals`
--

INSERT INTO `testimonals` (`id_test`, `name_test`, `testimonalsdes`, `status`) VALUES (1,'Bhagwatprasad M','				Precision Rehab has helped me recover from my Surgery on my wrist and carpal tunnel surgery. The care is remarkable and highly recommend them to everyone',0),(2,'Yang Y','fractured and dislocated my shoulder and John has helped me greatly. I attended therapy 3 times a week and could not have got my shoulder movement back without this specialized',0),(3,'Hyman, R','I had Surgery on my hand and can’t thank the all the therapist at this wonderful site-professionalism and A-1 care',0);

--
-- Dumping events for database 'pitapara_disefl'
--

--
-- Dumping routines for database 'pitapara_disefl'
--


