--
-- Host: localhost    Database: pitapara_pita
-- ------------------------------------------------------


--
-- 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=5 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` (
  `stid` int(11) NOT NULL AUTO_INCREMENT,
  `storename` varchar(150) NOT NULL,
  `description` text NOT NULL,
  `status` int(15) NOT NULL,
  PRIMARY KEY (`stid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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


--
-- 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','Welcome to Pita Paradise, a healthy Lebanese-Mediterranean eatery. At Pita Paradise, you are not just a guest,<br /> you are one of our family where we strive to provide delicious home cooking meals and outstanding service.<br /> Our menu includes large selection of appetizers, salads, meat and much more. Also,We are vegetarian and<br /> vegan glutton free friendly. Come join us and have best home made  meal dine in or take out.','',''),(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>\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 Time','<h6> WORKING TIME </h6>\r\n				        		<p> Mon - Sat: 11:00 Am - 8:30 Pm </p>\r\n				        		<p> Sunday: Closed </p>','',''),(8,'Email id','<h6> EMAIL ID </h6>\r\n				        		<a href=\"\" title=\"\"> info@pitaparadisefl.com </a>\r\n				        		<a href=\"\" title=\"\"> www.pitaparadisefl.com </a>','','');

--
-- 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_pita'
--

--
-- Dumping routines for database 'pitapara_pita'
--


