rms.sql

-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Oct 24, 2013 at 02:29 PM
-- Server version: 5.1.41
-- PHP Version: 5.3.1

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!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 utf8 */;

--
-- Database: `rms`
--

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

--
-- Table structure for table `item`
--

CREATE TABLE IF NOT EXISTS `item` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `menu_id` int(11) NOT NULL,
  `name` varchar(150) NOT NULL,
  `rate` int(11) NOT NULL,
  `item_type` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `menu_id` (`menu_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=162 ;

--
-- Dumping data for table `item`
--

INSERT INTO `item` (`id`, `menu_id`, `name`, `rate`, `item_type`) VALUES
(3, 2, 'Continental Breakfast', 255, 0),
(4, 2, 'American Breakfast', 350, 0),
(6, 4, 'Soft Drinks', 50, 1),
(7, 4, 'Mineral Water', 34, 1),
(8, 4, 'Red Bull', 160, 1),
(9, 5, 'Chicken Karahi ', 100, 0),
(10, 5, 'Chicken Pateyala Karahi', 100, 0),
(11, 6, 'Chocolate Chip', 190, 0),
(12, 6, 'Vanilla', 160, 0),
(13, 7, 'Russian Salad', 100, 0),
(14, 7, 'Fresh Salad', 100, 0),
(15, 7, 'Zeera Raita', 100, 0),
(27, 2, 'Crown Breakfast', 375, 0),
(28, 2, 'Omelette of your Choice', 230, 0),
(29, 2, 'Cereals', 155, 0),
(30, 3, 'Waffle', 220, 0),
(31, 3, 'Aloo Bhujia', 190, 0),
(32, 3, 'Keema with Paratha', 220, 0),
(33, 3, 'Beef Sausages & Potato Hash Brown', 220, 0),
(34, 3, 'French Toast with Maple Syrup', 150, 0),
(35, 3, 'Baked Beans on Toast', 150, 0),
(36, 3, 'Toast with Butter & Preserves', 120, 0),
(37, 3, 'Fresh Bread Basket', 180, 0),
(38, 3, 'Danish Pastries', 105, 0),
(39, 3, 'Croissant', 105, 0),
(40, 3, 'Plain Yogurt', 95, 0),
(41, 3, 'Fresh Fruit Platter', 245, 0),
(42, 17, 'Buffet Breakfast', 450, 0),
(43, 17, 'Buffet Lunch', 975, 0),
(44, 17, 'Buffet Dinner', 975, 0),
(45, 17, 'Hi - Tea', 495, 0),
(46, 3, 'Apple Juice', 140, 0),
(47, 3, 'Orange Juice', 140, 0),
(48, 3, 'Mango Juice', 140, 0),
(49, 3, 'Fresh Juices', 220, 0),
(50, 3, 'Milk [Hot or Cold]', 95, 0),
(51, 3, 'Lassi [Sweet or Saltish]', 120, 0),
(52, 3, 'Tea', 105, 0),
(53, 3, 'Coffee', 120, 0),
(54, 3, 'Cappuccino', 130, 0),
(55, 3, 'Espresso', 130, 0),
(56, 3, 'Hot Chocolate', 130, 0),
(57, 4, 'Spicy Chicken Wings', 255, 0),
(58, 4, 'Shrimp Cocktail', 415, 0),
(59, 4, 'Golden Chicken Strips', 275, 0),
(60, 4, 'Fried Mushrooms', 265, 0),
(61, 4, 'Chilli Garlic Prawns', 470, 0),
(62, 5, 'Soup of the Day', 150, 0),
(63, 5, 'Mulligatawny Soup', 165, 0),
(64, 5, 'Cream of Chicken Soup', 150, 0),
(65, 5, 'Hot & Sour Soup', 165, 0),
(66, 5, 'Vegetable Clear Soup', 140, 0),
(67, 5, 'French Onion', 165, 0),
(68, 6, 'Chef''s Salad Bowl', 240, 0),
(69, 6, 'Russian Salad', 240, 0),
(70, 6, 'Green Salad', 200, 0),
(71, 6, 'Thai Beef Salad', 335, 0),
(72, 6, 'Chicken Waldrof Salad', 300, 0),
(73, 6, 'Salad Bar', 440, 0),
(74, 7, 'Crown Club Sandwich', 345, 0),
(75, 7, 'Grilled Cheese & T.Sandwich', 270, 0),
(76, 7, 'Chicken Breast Sandwich', 345, 0),
(77, 7, 'Grilled Chicken Sandwich', 345, 0),
(78, 7, 'Tuna Sandwich', 315, 0),
(79, 7, 'Steak Sandwich', 395, 0),
(80, 7, 'Vegetable Sandwich', 245, 0),
(81, 7, 'Chilli Chicken Burger', 345, 0),
(82, 7, 'American Beef Burger', 375, 0),
(83, 7, 'Beef or Chicken Cheese Burger', 325, 0),
(84, 7, 'Hot Dog', 270, 0),
(85, 7, 'Roast Beef Sandwich', 390, 0),
(86, 8, 'Chicken Cordon Bleu', 495, 0),
(87, 8, 'Chicken Steak', 485, 0),
(88, 8, 'Chicken Shashlik', 485, 0),
(89, 8, 'Sheesh Tauk', 490, 0),
(90, 8, 'Grilled Lebanese Chicken', 490, 0),
(91, 8, 'Chicken Cashew Nuts', 495, 0),
(92, 8, 'Chicken Stronganoff', 465, 0),
(93, 8, 'Chicken Mongolian', 485, 0),
(94, 8, 'Beef Steak', 485, 0),
(95, 8, 'Fillet Mignon', 495, 0),
(96, 8, 'Beef Stronganoff', 465, 0),
(97, 8, 'Beef Mongolian', 485, 0),
(98, 8, 'Fried Fish', 535, 0),
(99, 8, 'Grilled Fish', 535, 0),
(100, 8, 'Fried Prawns', 595, 0),
(101, 9, 'Brain Masala', 370, 0),
(102, 9, 'Prawn Masala', 535, 0),
(103, 9, 'Shahi Qorma [Chicken or Mutton]', 410, 0),
(104, 9, 'Chicken Handi', 495, 0),
(105, 9, 'Mutton Handi', 540, 0),
(106, 9, 'Lahori Fried Fish', 535, 0),
(107, 9, 'Laziz Mix Vegetable', 245, 0),
(108, 9, 'Daal Tarka', 235, 0),
(109, 10, 'Mix Grilled Platter', 495, 0),
(110, 10, 'Chicken Seekh Kabab', 275, 0),
(111, 10, 'Grilled Lamb Chops', 495, 0),
(112, 10, 'Chicken Tikka', 245, 0),
(113, 10, 'Chicken Boti', 325, 0),
(114, 10, 'Chicken Malai Boti', 375, 0),
(115, 11, 'Mutton Biryani', 350, 0),
(116, 11, 'Chicken Biryani', 350, 0),
(117, 11, 'Steam Rice', 190, 0),
(118, 11, 'Tandoori Roti', 30, 0),
(119, 11, 'Roughani Nan', 40, 0),
(120, 11, 'Paratha', 70, 0),
(121, 12, 'Penne Pasta', 335, 0),
(122, 12, 'Spaghetti Bolognese', 335, 0),
(123, 12, 'Spaghetti Napolitano', 315, 0),
(124, 12, 'Lasagna [Meat or Chicken]', 425, 0),
(125, 13, 'Chocolate Cake', 255, 0),
(126, 13, 'Choice of Ice Cream [2 Scoop]', 225, 0),
(127, 13, 'Chocolate Mousse', 190, 0),
(128, 13, 'Cream Caramel', 190, 0),
(129, 13, 'Hot Gulab Jamun', 150, 0),
(130, 13, 'Kheer', 150, 0),
(131, 13, 'Fresh Fruit Platter', 250, 0),
(132, 13, 'Dessert Buffet', 425, 0),
(133, 14, 'Soup of the Day', 150, 0),
(134, 14, 'Chicken Chilli Burger', 345, 0),
(135, 14, 'Beef or Chicken Cheese Burger', 325, 0),
(136, 14, 'Grilled Cheese Sanwich', 345, 0),
(137, 14, 'Crown Club Sandwich', 345, 0),
(138, 14, 'Fried Fish With Tartar Sauce', 535, 0),
(139, 14, 'Chicken Handi', 495, 0),
(140, 14, 'Mutton Handi', 540, 0),
(141, 14, 'Daal of the Day', 235, 0),
(142, 14, 'Chicken Mongolian', 485, 0),
(143, 15, 'Soft Drink', 90, 1),
(144, 15, 'F.L. Pepsi or 7up', 100, 1),
(145, 15, 'Diet Pepsi or 7up', 125, 1),
(146, 15, 'Old Fashioned Lemonade', 115, 1),
(147, 15, 'Non Alcoholic Beer', 190, 1),
(148, 15, 'M.Water [L]', 125, 1),
(149, 15, 'M.Water [S]', 90, 1),
(150, 15, 'Perrier Water [Can]', 215, 1),
(151, 15, 'Ice tea', 155, 1),
(152, 15, 'Fresh Juice', 220, 1),
(153, 15, 'Juice', 140, 1),
(154, 15, 'Lassi', 120, 1),
(155, 16, 'Coffee', 120, 0),
(156, 16, 'Cappuccino', 130, 0),
(157, 16, 'Espresso', 13, 0),
(158, 16, 'Hot Chocolate', 130, 0),
(159, 16, 'Black Tea', 105, 0),
(160, 16, 'Green Tea', 95, 0),
(161, 15, 'Soft Drink [Can]', 125, 0);

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

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

CREATE TABLE IF NOT EXISTS `menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(150) NOT NULL,
  `status` int(11) NOT NULL,
  `tableorder` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=18 ;

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

INSERT INTO `menu` (`id`, `name`, `status`, `tableorder`) VALUES
(2, 'Breakfast', 1, 1),
(3, 'Ala Carte Selection', 1, 1),
(4, 'Starters', 1, 1),
(5, 'Soup', 1, 1),
(6, 'Salads', 1, 1),
(7, 'Burgers & Sandwiches', 1, 1),
(8, 'Around The World', 1, 1),
(9, 'Pakistani Cuisine', 1, 1),
(10, 'Charcoal Grill', 1, 1),
(11, 'Sides', 1, 1),
(12, 'Italian Corner', 1, 1),
(13, 'Desserts', 1, 1),
(14, 'Midnight Menu', 1, 1),
(15, 'Cold Drinks', 1, 1),
(16, 'Hot Drinks', 1, 1),
(17, 'Buffet Meals', 1, 1);

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

--
-- Table structure for table `orderdetail`
--

CREATE TABLE IF NOT EXISTS `orderdetail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `quantity` int(11) NOT NULL,
  `menu_id` int(11) DEFAULT NULL,
  `item_id` int(11) NOT NULL,
  `tableorder_id` int(11) NOT NULL,
  `rate` double NOT NULL,
  PRIMARY KEY (`id`),
  KEY `menu_id` (`menu_id`),
  KEY `item_id` (`item_id`),
  KEY `tableorder_id` (`tableorder_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=753 ;

--
-- Dumping data for table `orderdetail`
--

INSERT INTO `orderdetail` (`id`, `quantity`, `menu_id`, `item_id`, `tableorder_id`, `rate`) VALUES
(1, 1, NULL, 4, 19, 100),
(4, 1, NULL, 4, 19, 100),
(14, 1, NULL, 4, 19, 100),
(17, 2, NULL, 4, 19, 100),
(20, 1, NULL, 4, 20, 100),
(22, 5, NULL, 8, 20, 160),
(23, 1, NULL, 7, 20, 34),
(24, 1, NULL, 6, 20, 50),
(26, -3, NULL, 4, 19, 100),
(27, 1, NULL, 3, 21, 12),
(30, 1, NULL, 8, 21, 160),
(31, 1, NULL, 7, 21, 34),
(32, 1, NULL, 10, 21, 100),
(33, 1, NULL, 12, 21, 160),
(34, 1, NULL, 14, 21, 100),
(35, 1, NULL, 13, 21, 100),
(36, -1, NULL, 10, 21, 100),
(37, -1, NULL, 7, 21, 34),
(38, -1, NULL, 3, 21, 12),
(39, 1, NULL, 13, 22, 100),
(40, 1, NULL, 14, 22, 100),
(41, 1, NULL, 15, 22, 100),
(42, 1, NULL, 14, 23, 100),
(43, 1, NULL, 15, 23, 100),
(44, 2, NULL, 6, 23, 50),
(45, 5, NULL, 7, 23, 34),
(46, 8, NULL, 8, 23, 160),
(47, 500, NULL, 8, 24, 160),
(48, 1000, NULL, 7, 24, 34),
(49, 700, NULL, 6, 24, 50),
(50, 500, NULL, 8, 25, 160),
(51, 45000, NULL, 6, 25, 50),
(52, 800, NULL, 6, 25, 50),
(53, 1, NULL, 3, 26, 12),
(54, 1, NULL, 4, 26, 100),
(57, 1, NULL, 6, 26, 50),
(58, 1, NULL, 7, 26, 34),
(59, 1, NULL, 8, 26, 160),
(60, 1, NULL, 9, 26, 100),
(61, 1, NULL, 10, 26, 100),
(62, 1, NULL, 11, 26, 190),
(63, 1, NULL, 12, 26, 160),
(64, 1, NULL, 13, 26, 100),
(65, 1, NULL, 14, 26, 100),
(66, 1, NULL, 15, 26, 100),
(67, 1, NULL, 8, 26, 160),
(68, 1, NULL, 8, 26, 160),
(69, 1, NULL, 8, 26, 160),
(70, 1, NULL, 14, 26, 100),
(71, 1, NULL, 3, 27, 12),
(72, 1, NULL, 4, 27, 100),
(74, 1, NULL, 6, 27, 50),
(75, 1, NULL, 7, 27, 34),
(76, 1, NULL, 8, 27, 160),
(77, 1, NULL, 9, 27, 100),
(78, 1, NULL, 10, 27, 100),
(79, 1, NULL, 11, 27, 190),
(80, 1, NULL, 12, 27, 160),
(81, 1, NULL, 14, 27, 100),
(82, 1, NULL, 13, 27, 100),
(83, 1, NULL, 15, 27, 100),
(84, 1, NULL, 3, 28, 12),
(85, 1, NULL, 4, 28, 100),
(88, 1, NULL, 6, 28, 50),
(89, 1, NULL, 7, 28, 34),
(90, 1, NULL, 8, 28, 160),
(91, 1, NULL, 9, 28, 100),
(92, 1, NULL, 10, 28, 100),
(93, 1, NULL, 11, 28, 190),
(94, 1, NULL, 12, 28, 160),
(95, 1, NULL, 13, 28, 100),
(96, 1, NULL, 14, 28, 100),
(97, 1, NULL, 15, 28, 100),
(99, 1, NULL, 3, 26, 12),
(100, 1, NULL, 4, 26, 100),
(101, 1, NULL, 8, 26, 160),
(102, 1, NULL, 4, 26, 100),
(103, 1, NULL, 4, 29, 100),
(104, 1, NULL, 4, 29, 100),
(105, 1, NULL, 4, 29, 100),
(106, 1, NULL, 4, 29, 100),
(107, 1, NULL, 4, 29, 100),
(108, 1, NULL, 4, 29, 100),
(109, 1, NULL, 4, 29, 100),
(110, 1, NULL, 4, 29, 100),
(111, 1, NULL, 4, 27, 100),
(112, 1, NULL, 4, 28, 100),
(113, 1, NULL, 4, 29, 100),
(114, 1, NULL, 4, 11, 100),
(115, 1, NULL, 4, 11, 100),
(116, 1, NULL, 4, 12, 100),
(117, 1, NULL, 4, 12, 100),
(118, 1, NULL, 4, 12, 100),
(119, 1, NULL, 4, 13, 100),
(120, 1, NULL, 4, 13, 100),
(121, 1, NULL, 4, 13, 100),
(123, 1, NULL, 7, 14, 34),
(124, 1, NULL, 6, 14, 50),
(125, 1, NULL, 8, 14, 160),
(128, 1, NULL, 3, 15, 12),
(129, 1, NULL, 4, 15, 100),
(130, 1, NULL, 7, 15, 34),
(131, 1, NULL, 8, 15, 160),
(132, 1, NULL, 6, 15, 50),
(133, 1, NULL, 3, 16, 12),
(134, 1, NULL, 4, 16, 100),
(135, 5, NULL, 8, 16, 160),
(136, 1, NULL, 7, 16, 34),
(137, 1, NULL, 6, 16, 50),
(138, 1, NULL, 3, 18, 12),
(139, 1, NULL, 4, 18, 100),
(140, 1, NULL, 7, 18, 34),
(141, 1, NULL, 6, 18, 50),
(142, 1, NULL, 8, 18, 160),
(143, 1, NULL, 10, 18, 100),
(144, 1, NULL, 9, 18, 100),
(145, 1, NULL, 4, 14, 100),
(146, 1, NULL, 4, 23, 100),
(147, 1, NULL, 4, 15, 100),
(148, 1, NULL, 3, 30, 12),
(149, 1, NULL, 4, 30, 100),
(153, 1, NULL, 6, 30, 50),
(154, 6, NULL, 8, 30, 160),
(155, 6, NULL, 7, 30, 34),
(156, 1, NULL, 10, 30, 100),
(157, 1, NULL, 9, 30, 100),
(158, 1, NULL, 10, 31, 100),
(159, 1, NULL, 9, 31, 100),
(160, 5, NULL, 7, 31, 34),
(161, 1, NULL, 8, 31, 160),
(162, 1, NULL, 6, 31, 50),
(163, 1, NULL, 7, 31, 34),
(164, 1, NULL, 8, 31, 160),
(165, 1, NULL, 3, 32, 12),
(166, 1, NULL, 7, 32, 34),
(167, 1, NULL, 6, 32, 50),
(168, 1, NULL, 6, 32, 50),
(169, 1, NULL, 7, 32, 34),
(170, 1, NULL, 8, 32, 160),
(171, 1, NULL, 13, 32, 100),
(172, 1, NULL, 14, 32, 100),
(173, 1, NULL, 4, 18, 100),
(174, 1, NULL, 3, 18, 12),
(175, 1, NULL, 3, 18, 12),
(176, 1, NULL, 8, 18, 160),
(177, -1, NULL, 3, 18, 12),
(178, -1, NULL, 3, 18, 12),
(179, -1, NULL, 3, 18, 12),
(180, -1, NULL, 4, 18, 100),
(181, -1, NULL, 7, 18, 34),
(182, -1, NULL, 6, 18, 50),
(183, 1, NULL, 4, 18, 100),
(184, 1, NULL, 4, 22, 100),
(185, -1, NULL, 13, 22, 100),
(186, 1, NULL, 4, 18, 100),
(187, 789, NULL, 3, 20, 12),
(188, 7, NULL, 4, 20, 100),
(189, 1, NULL, 6, 20, 50),
(190, 1, NULL, 7, 20, 34),
(191, 23, NULL, 148, 33, 125),
(192, 1, NULL, 43, 33, 975),
(193, 3, NULL, 44, 33, 975),
(194, 2, NULL, 42, 33, 450),
(195, 3, NULL, 45, 33, 495),
(196, 1, NULL, 144, 34, 100),
(197, 1, NULL, 150, 34, 215),
(198, 1, NULL, 126, 34, 225),
(199, 1, NULL, 132, 34, 425),
(200, 1, NULL, 128, 34, 190),
(201, 1, NULL, 27, 35, 375),
(202, 1, NULL, 29, 36, 155),
(203, 1, NULL, 28, 36, 230),
(204, 1, NULL, 27, 36, 375),
(205, 1, NULL, 4, 36, 350),
(206, 1, NULL, 3, 36, 255),
(207, 1597, NULL, 125, 36, 255),
(208, 1, NULL, 130, 36, 150),
(209, 1, NULL, 131, 36, 250),
(210, 1, NULL, 132, 36, 425),
(211, 1, NULL, 127, 36, 190),
(212, 1, NULL, 126, 36, 225),
(213, 1, NULL, 125, 36, 255),
(214, 1, NULL, 128, 36, 190),
(215, 1, NULL, 129, 36, 150),
(216, 1, NULL, 134, 37, 345),
(217, 1, NULL, 139, 37, 495),
(218, 1, NULL, 140, 37, 540),
(219, 1, NULL, 148, 37, 125),
(220, 1, NULL, 74, 39, 345),
(221, 2, NULL, 52, 39, 105),
(222, 1, NULL, 31, 41, 190),
(223, -1, NULL, 31, 41, 190),
(224, 1, NULL, 98, 38, 535),
(225, 1, NULL, 133, 43, 150),
(226, 2, NULL, 52, 44, 105),
(227, -1, NULL, 98, 38, 535),
(228, 2, NULL, 65, 51, 165),
(229, 1, NULL, 148, 51, 125),
(230, 2, NULL, 159, 51, 105),
(231, 1, NULL, 77, 51, 345),
(232, 1, NULL, 74, 51, 345),
(233, 2, NULL, 105, 53, 540),
(234, 1, NULL, 105, 54, 540),
(235, 1, NULL, 105, 55, 540),
(236, 1, NULL, 112, 56, 245),
(237, 1, NULL, 112, 57, 245),
(238, 1, NULL, 109, 52, 495),
(239, 1, NULL, 110, 50, 275),
(240, 1, NULL, 109, 49, 495),
(241, 1, NULL, 109, 47, 495),
(242, 1, NULL, 109, 46, 495),
(243, 1, NULL, 114, 42, 375),
(244, 1, NULL, 114, 41, 375),
(245, 1, NULL, 114, 40, 375),
(246, 1, NULL, 114, 38, 375),
(247, 1, NULL, 110, 58, 275),
(248, 2, NULL, 52, 59, 105),
(249, 1, NULL, 44, 60, 975),
(250, 1, NULL, 149, 60, 90),
(251, 3, NULL, 44, 61, 975),
(252, 1, NULL, 148, 61, 125),
(253, 1, NULL, 44, 62, 975),
(254, 1, NULL, 148, 62, 125),
(255, 1, NULL, 44, 63, 975),
(256, 1, NULL, 44, 64, 975),
(257, 1, NULL, 44, 65, 975),
(258, 1, NULL, 149, 65, 90),
(259, 1, NULL, 143, 65, 90),
(260, -1, NULL, 143, 65, 90),
(261, 1, NULL, 144, 65, 100),
(262, -1, NULL, 144, 65, 100),
(263, 1, NULL, 145, 65, 125),
(264, 1, NULL, 44, 66, 975),
(265, 1, NULL, 148, 66, 125),
(266, 1, NULL, 44, 67, 975),
(267, 1, NULL, 149, 67, 90),
(268, 1, NULL, 149, 67, 90),
(269, 1, NULL, 44, 68, 975),
(270, 1, NULL, 44, 69, 975),
(271, 1, NULL, 148, 69, 125),
(272, 1, NULL, 44, 70, 975),
(273, 1, NULL, 145, 70, 125),
(274, 1, NULL, 44, 71, 975),
(275, 1, NULL, 149, 71, 90),
(276, 1, NULL, 44, 71, 975),
(277, 1, NULL, 148, 71, 125),
(278, 1, NULL, 145, 71, 125),
(279, -1, NULL, 44, 71, 975),
(280, -1, NULL, 149, 71, 90),
(281, 1, NULL, 44, 72, 975),
(282, 1, NULL, 44, 73, 975),
(283, 1, NULL, 149, 73, 90),
(284, 2, NULL, 52, 74, 105),
(285, 1, NULL, 148, 74, 125),
(286, 1, NULL, 27, 75, 375),
(287, 1, NULL, 149, 75, 90),
(288, 1, NULL, 32, 75, 220),
(289, -1, NULL, 32, 75, 220),
(290, 6, NULL, 45, 76, 495),
(291, 2, NULL, 148, 76, 125),
(292, 2, NULL, 143, 76, 90),
(293, 2, NULL, 45, 76, 495),
(294, 2, NULL, 45, 77, 495),
(295, 1, NULL, 70, 78, 200),
(296, 1, NULL, 62, 78, 150),
(297, 1, NULL, 74, 79, 345),
(298, 1, NULL, 47, 80, 140),
(299, 1, NULL, 52, 80, 105),
(300, 1, NULL, 43, 81, 975),
(301, 1, NULL, 149, 81, 90),
(302, 2, NULL, 52, 82, 105),
(303, 2, NULL, 44, 83, 975),
(304, 1, NULL, 148, 83, 125),
(305, 1, NULL, 122, 84, 335),
(306, 1, NULL, 44, 85, 975),
(307, -1, NULL, 44, 85, 975),
(308, 2, NULL, 44, 85, 975),
(309, 1, NULL, 148, 85, 125),
(310, 3, NULL, 98, 86, 535),
(311, 5, NULL, 52, 86, 105),
(312, 3, NULL, 160, 86, 95),
(313, 4, NULL, 143, 86, 90),
(314, 3, NULL, 52, 86, 105),
(315, 3, NULL, 52, 87, 105),
(316, 2, NULL, 44, 88, 975),
(317, 4, NULL, 52, 88, 105),
(318, 8, NULL, 153, 88, 140),
(319, 2, NULL, 52, 89, 105),
(320, 3, NULL, 52, 90, 105),
(321, 2, NULL, 53, 91, 120),
(322, 1, NULL, 48, 92, 140),
(323, -2, NULL, 52, 89, 105),
(324, 1, NULL, 53, 93, 120),
(325, -1, NULL, 53, 93, 120),
(326, 1, NULL, 28, 93, 230),
(327, 1, NULL, 4, 95, 350),
(328, 1, NULL, 4, 96, 350),
(329, 1, NULL, 27, 94, 375),
(330, -1, NULL, 27, 94, 375),
(331, 1, NULL, 3, 94, 255),
(332, 4, NULL, 43, 97, 975),
(333, 1, NULL, 148, 97, 125),
(334, 2, NULL, 52, 98, 105),
(335, 1, NULL, 52, 99, 105),
(336, 3, NULL, 45, 100, 495),
(337, 1, NULL, 148, 100, 125),
(338, 2, NULL, 45, 101, 495),
(339, 1, NULL, 149, 101, 90),
(340, 11, NULL, 45, 102, 495),
(341, 3, NULL, 148, 102, 125),
(342, 22, NULL, 45, 103, 495),
(343, 1, NULL, 45, 104, 495),
(344, 2, NULL, 45, 105, 495),
(345, 1, NULL, 149, 105, 90),
(346, 1, NULL, 45, 106, 495),
(347, 1, NULL, 148, 106, 125),
(348, 4, NULL, 49, 107, 220),
(349, 1, NULL, 105, 108, 540),
(350, 2, NULL, 52, 106, 105),
(351, 1, NULL, 149, 106, 90),
(352, 0, NULL, 52, 109, 105),
(353, 1, NULL, 149, 109, 90),
(354, 2, NULL, 52, 110, 105),
(355, 1, NULL, 149, 110, 90),
(356, 1, NULL, 104, 111, 495),
(357, 1, NULL, 108, 111, 235),
(358, 1, NULL, 148, 111, 125),
(359, 1, NULL, 44, 113, 975),
(360, 1, NULL, 149, 113, 90),
(361, 4, NULL, 52, 114, 105),
(362, 1, NULL, 149, 114, 90),
(363, -4, NULL, 52, 114, 105),
(364, 4, NULL, 52, 114, 105),
(365, 1, NULL, 46, 115, 140),
(366, 1, NULL, 42, 112, 450),
(367, 2, NULL, 3, 116, 255),
(368, 1, NULL, 149, 116, 90),
(369, 2, NULL, 42, 117, 450),
(370, 1, NULL, 149, 117, 90),
(371, 2, NULL, 45, 119, 495),
(372, 1, NULL, 149, 119, 90),
(373, 2, NULL, 45, 118, 495),
(374, 1, NULL, 148, 118, 125),
(375, 2, NULL, 145, 120, 125),
(376, 3, NULL, 44, 121, 975),
(377, 3, NULL, 145, 121, 125),
(378, 3, NULL, 52, 122, 105),
(379, 3, NULL, 64, 122, 150),
(380, 2, NULL, 64, 123, 150),
(381, 1, NULL, 105, 124, 540),
(382, 1, NULL, 91, 124, 495),
(383, 1, NULL, 148, 124, 125),
(384, 1, NULL, 87, 124, 485),
(385, -1, NULL, 87, 124, 485),
(386, 1, NULL, 110, 124, 275),
(387, 1, NULL, 44, 125, 975),
(388, 1, NULL, 143, 125, 90),
(389, 1, NULL, 44, 124, 975),
(390, 1, NULL, 149, 124, 90),
(391, -1, NULL, 105, 124, 540),
(392, -1, NULL, 44, 125, 975),
(393, -1, NULL, 143, 125, 90),
(394, 1, NULL, 149, 126, 90),
(395, 1, NULL, 149, 125, 90),
(396, 1, NULL, 27, 127, 375),
(397, 2, NULL, 74, 128, 345),
(398, 4, NULL, 49, 128, 220),
(399, 1, NULL, 105, 129, 540),
(400, 1, NULL, 106, 129, 535),
(401, 1, NULL, 115, 129, 350),
(402, -1, NULL, 115, 129, 350),
(403, 2, NULL, 115, 129, 350),
(404, 1, NULL, 107, 129, 245),
(405, 3, NULL, 105, 130, 540),
(406, 1, NULL, 106, 130, 535),
(407, 2, NULL, 115, 130, 350),
(408, 1, NULL, 107, 130, 245),
(409, 1, NULL, 116, 130, 350),
(410, 1, NULL, 148, 130, 125),
(411, 1, NULL, 145, 130, 125),
(412, 2, NULL, 132, 130, 425),
(413, 5, NULL, 44, 131, 975),
(414, 2, NULL, 148, 131, 125),
(415, 2, NULL, 44, 132, 975),
(416, 1, NULL, 148, 132, 125),
(417, 2, NULL, 93, 133, 485),
(418, 1, NULL, 104, 133, 495),
(419, 1, NULL, 148, 133, 125),
(420, -5, NULL, 44, 131, 975),
(421, 2, NULL, 4, 134, 350),
(422, 1, NULL, 149, 135, 90),
(423, 1, NULL, 104, 136, 495),
(424, 1, NULL, 62, 136, 150),
(425, 1, NULL, 148, 136, 125),
(426, 1, NULL, 74, 137, 345),
(427, 1, NULL, 77, 137, 345),
(428, 3, NULL, 52, 137, 105),
(429, 1, NULL, 149, 137, 90),
(430, 2, NULL, 156, 138, 130),
(431, 1, NULL, 52, 138, 105),
(432, 1, NULL, 152, 138, 220),
(433, 1, NULL, 49, 138, 220),
(434, 2, NULL, 156, 139, 130),
(435, 1, NULL, 52, 139, 105),
(436, 2, NULL, 47, 139, 140),
(437, 1, NULL, 45, 140, 495),
(438, 1, NULL, 144, 140, 100),
(439, 2, NULL, 45, 141, 495),
(440, 1, NULL, 148, 141, 125),
(441, 2, NULL, 45, 142, 495),
(442, 1, NULL, 148, 142, 125),
(443, 2, NULL, 153, 143, 140),
(444, 5, NULL, 45, 144, 495),
(445, 1, NULL, 148, 144, 125),
(446, 3, NULL, 62, 145, 150),
(447, 522, NULL, 148, 146, 125),
(448, 2, NULL, 52, 147, 105),
(449, 1, NULL, 148, 147, 125),
(450, 1, NULL, 104, 148, 495),
(451, 1, NULL, 108, 148, 235),
(452, 1, NULL, 148, 148, 125),
(453, 1, NULL, 44, 149, 975),
(454, 1, NULL, 149, 149, 90),
(455, 3, NULL, 52, 150, 105),
(456, 3652, NULL, 44, 151, 975),
(457, 1, NULL, 148, 151, 125),
(458, 2, NULL, 44, 152, 975),
(459, 1, NULL, 148, 152, 125),
(460, 2, NULL, 64, 153, 150),
(461, 1, NULL, 108, 153, 235),
(462, 1, NULL, 59, 153, 275),
(463, 2, NULL, 149, 153, 90),
(464, 1, NULL, 53, 154, 120),
(465, 2, NULL, 44, 155, 975),
(466, 1, NULL, 150, 155, 215),
(467, -1, NULL, 150, 155, 215),
(468, 1, NULL, 143, 155, 90),
(469, -1, NULL, 143, 155, 90),
(470, 1, NULL, 149, 155, 90),
(471, 1, NULL, 144, 155, 100),
(472, 1, NULL, 150, 155, 215),
(473, -1, NULL, 144, 155, 100),
(474, -1, NULL, 150, 155, 215),
(475, 1, NULL, 146, 155, 115),
(476, -1, NULL, 146, 155, 115),
(477, 1, NULL, 44, 156, 975),
(478, 1, NULL, 149, 156, 90),
(479, 2, NULL, 52, 157, 105),
(480, 1, NULL, 148, 157, 125),
(481, 1, NULL, 149, 158, 90),
(482, 1, NULL, 149, 159, 90),
(483, 1, NULL, 156, 160, 130),
(484, 1, NULL, 52, 160, 105),
(485, 1, NULL, 149, 160, 90),
(486, 1, NULL, 43, 161, 975),
(487, 1, NULL, 43, 161, 975),
(488, 1, NULL, 148, 161, 125),
(489, 3, NULL, 52, 162, 105),
(490, 1, NULL, 53, 162, 120),
(491, 1, NULL, 148, 162, 125),
(492, 6, NULL, 45, 163, 495),
(493, 2, NULL, 148, 163, 125),
(494, 23, NULL, 45, 164, 495),
(495, 2, NULL, 44, 165, 975),
(496, 1, NULL, 148, 165, 125),
(497, 1, NULL, 42, 166, 450),
(498, 1, NULL, 52, 167, 105),
(499, 1, NULL, 155, 167, 120),
(500, 8, NULL, 43, 168, 975),
(501, 2, NULL, 148, 168, 125),
(502, 7, NULL, 43, 169, 975),
(503, 2, NULL, 148, 169, 125),
(504, 4, NULL, 143, 169, 90),
(505, 1, NULL, 57, 170, 255),
(506, 4, NULL, 65, 170, 165),
(507, 1, NULL, 101, 170, 370),
(508, 1, NULL, 105, 170, 540),
(509, 1, NULL, 148, 170, 125),
(510, 5, NULL, 52, 171, 105),
(511, 3, NULL, 77, 171, 345),
(512, 1, NULL, 109, 172, 495),
(513, 1, NULL, 148, 172, 125),
(514, 1, NULL, 107, 173, 245),
(515, 1, NULL, 104, 173, 495),
(516, 1, NULL, 148, 173, 125),
(517, 2, NULL, 99, 174, 535),
(518, 1, NULL, 148, 174, 125),
(519, 5, NULL, 62, 174, 150),
(520, 2, NULL, 44, 175, 975),
(521, 1, NULL, 148, 175, 125),
(522, 1, NULL, 148, 175, 125),
(523, 1, NULL, 149, 176, 90),
(524, 3, NULL, 52, 177, 105),
(525, 1, NULL, 148, 177, 125),
(526, 1, NULL, 143, 178, 90),
(527, 1, NULL, 144, 178, 100),
(528, 1, NULL, 150, 178, 215),
(529, 1, NULL, 144, 178, 100),
(530, -1, NULL, 143, 178, 90),
(531, 1, NULL, 145, 178, 125),
(532, 1, NULL, 145, 179, 125),
(533, 1, NULL, 44, 180, 975),
(534, 1, NULL, 148, 180, 125),
(535, 1, NULL, 148, 181, 125),
(536, 1, NULL, 43, 182, 975),
(537, 1, NULL, 149, 182, 90),
(538, 3, NULL, 52, 183, 105),
(539, 1, NULL, 148, 183, 125),
(540, 1, NULL, 148, 184, 125),
(541, 1, NULL, 53, 185, 120),
(542, 3, NULL, 43, 186, 975),
(543, 3, NULL, 143, 186, 90),
(544, 1, NULL, 148, 186, 125),
(545, 2, NULL, 43, 187, 975),
(546, 2, NULL, 143, 187, 90),
(547, 1, NULL, 148, 187, 125),
(548, 1, NULL, 74, 188, 345),
(549, 1, NULL, 53, 188, 120),
(550, 1, NULL, 143, 188, 90),
(551, 1, NULL, 52, 188, 105),
(552, 1, NULL, 74, 189, 345),
(553, 1, NULL, 53, 189, 120),
(554, 1, NULL, 145, 189, 125),
(555, 1, NULL, 52, 189, 105),
(556, 1, NULL, 149, 189, 90),
(557, 1, NULL, 148, 190, 125),
(558, 3, NULL, 43, 190, 975),
(559, 1, NULL, 145, 190, 125),
(560, 1, NULL, 160, 191, 95),
(561, 1, NULL, 49, 192, 220),
(562, 2, NULL, 52, 192, 105),
(563, 1, NULL, 127, 192, 190),
(564, -1, NULL, 127, 192, 190),
(565, 1, NULL, 126, 192, 225),
(566, 1, NULL, 44, 193, 975),
(567, 1, NULL, 149, 193, 90),
(568, 2, NULL, 149, 194, 90),
(569, 2, NULL, 63, 194, 165),
(570, 1, NULL, 109, 194, 495),
(571, 1, NULL, 108, 194, 235),
(572, 3, NULL, 128, 195, 190),
(573, 3, NULL, 129, 195, 150),
(574, 3, NULL, 126, 195, 225),
(575, -3, NULL, 129, 195, 150),
(576, -3, NULL, 128, 195, 190),
(577, 1, NULL, 42, 196, 450),
(578, 1, NULL, 148, 197, 125),
(579, 4, NULL, 53, 198, 120),
(580, 1, NULL, 52, 199, 105),
(581, 1, NULL, 145, 199, 125),
(582, 4, NULL, 43, 200, 975),
(583, 1, NULL, 148, 200, 125),
(584, 1, NULL, 145, 200, 125),
(585, 1, NULL, 64, 201, 150),
(586, 1, NULL, 69, 201, 240),
(587, 6, NULL, 43, 203, 975),
(588, 1, NULL, 148, 203, 125),
(589, 2, NULL, 45, 204, 495),
(590, 4, NULL, 43, 205, 975),
(591, 1, NULL, 148, 205, 125),
(592, 4, NULL, 43, 206, 975),
(593, 1, NULL, 148, 206, 125),
(594, 4, NULL, 52, 207, 105),
(595, 2, NULL, 149, 207, 90),
(596, 1, NULL, 74, 207, 345),
(597, 3, NULL, 44, 208, 975),
(598, 4, NULL, 148, 208, 125),
(599, 1, NULL, 148, 208, 125),
(600, 7, NULL, 44, 209, 975),
(601, 2, NULL, 148, 209, 125),
(602, 2, NULL, 44, 210, 975),
(603, 2, NULL, 149, 210, 90),
(604, 1, NULL, 76, 211, 345),
(605, 1, NULL, 77, 211, 345),
(606, 1, NULL, 82, 211, 375),
(607, 1, NULL, 107, 211, 245),
(608, 1, NULL, 107, 212, 245),
(609, 1, NULL, 103, 212, 410),
(610, -1, NULL, 103, 212, 410),
(611, 1, NULL, 6, 212, 50),
(612, -1, NULL, 6, 212, 50),
(613, 1, NULL, 7, 212, 34),
(614, -1, NULL, 7, 212, 34),
(615, 1, NULL, 148, 212, 125),
(616, 1, NULL, 149, 213, 90),
(617, 1, NULL, 148, 214, 125),
(618, 1, NULL, 155, 202, 120),
(619, 1, NULL, 77, 202, 345),
(620, 1, NULL, 160, 202, 95),
(621, 9, NULL, 44, 215, 975),
(622, 3, NULL, 148, 215, 125),
(623, 1, NULL, 144, 215, 100),
(624, 1, NULL, 145, 215, 125),
(625, -1, NULL, 144, 215, 100),
(626, 9, NULL, 44, 216, 975),
(627, 3, NULL, 148, 216, 125),
(628, 9, NULL, 44, 217, 975),
(629, 3, NULL, 148, 217, 125),
(630, 3, NULL, 145, 217, 125),
(631, 9, NULL, 44, 202, 975),
(632, 1, NULL, 148, 216, 125),
(633, 9, NULL, 44, 219, 975),
(634, 9, NULL, 145, 219, 125),
(635, 3, NULL, 148, 219, 125),
(636, 9, NULL, 44, 220, 975),
(637, 2, NULL, 148, 220, 125),
(638, 1, NULL, 104, 221, 495),
(639, 1, NULL, 52, 221, 105),
(640, 2, NULL, 53, 222, 120),
(641, 1, NULL, 148, 222, 125),
(642, 1, NULL, 108, 223, 235),
(643, 1, NULL, 149, 223, 90),
(644, 1, NULL, 125, 224, 255),
(645, 1, NULL, 126, 224, 225),
(646, 1, NULL, 127, 224, 190),
(647, 1, NULL, 128, 224, 190),
(648, 1, NULL, 129, 224, 150),
(649, 1, NULL, 130, 224, 150),
(650, 1, NULL, 131, 224, 250),
(651, 1, NULL, 132, 224, 425),
(652, 1, NULL, 29, 202, 155),
(653, 1, NULL, 160, 226, 95),
(654, 1, NULL, 98, 227, 535),
(655, 1, NULL, 87, 227, 485),
(656, 2, NULL, 145, 227, 125),
(657, 1, NULL, 148, 227, 125),
(658, 1, NULL, 88, 227, 485),
(659, 1, NULL, 75, 228, 270),
(660, 1, NULL, 52, 228, 105),
(661, 1, NULL, 149, 206, 90),
(662, 1, NULL, 149, 229, 90),
(663, 1, NULL, 149, 225, 90),
(664, 1, NULL, 149, 218, 90),
(665, 1, NULL, 148, 230, 125),
(666, 1, NULL, 149, 231, 90),
(667, 1, NULL, 144, 231, 100),
(668, 1, NULL, 145, 231, 125),
(669, 1, NULL, 146, 231, 115),
(670, 1, NULL, 147, 231, 190),
(671, 1, NULL, 151, 231, 155),
(672, 1, NULL, 150, 231, 215),
(673, 1, NULL, 149, 231, 90),
(674, 1, NULL, 148, 231, 125),
(675, 1, NULL, 143, 231, 90),
(676, 1, NULL, 143, 231, 90),
(677, 1, NULL, 145, 231, 125),
(678, 1, NULL, 145, 231, 125),
(679, 1, NULL, 145, 231, 125),
(680, 1, NULL, 145, 231, 125),
(681, 1, NULL, 145, 231, 125),
(682, 1, NULL, 145, 231, 125),
(683, 1, NULL, 145, 231, 125),
(684, 1, NULL, 145, 231, 125),
(685, 1, NULL, 145, 231, 125),
(686, 1, NULL, 145, 231, 125),
(687, 1, NULL, 145, 231, 125),
(688, 1, NULL, 145, 231, 125),
(689, 1, NULL, 145, 231, 125),
(690, 1, NULL, 145, 231, 125),
(691, 1, NULL, 145, 231, 125),
(692, 1, NULL, 149, 232, 90),
(693, 1, NULL, 64, 230, 150),
(694, 1, NULL, 161, 230, 125),
(695, 1, NULL, 161, 230, 125),
(696, 3, NULL, 156, 233, 130),
(697, 1, NULL, 149, 233, 90),
(698, 2, NULL, 112, 234, 245),
(699, 1, NULL, 99, 234, 535),
(700, 2, NULL, 148, 234, 125),
(701, 1, NULL, 103, 235, 410),
(702, 1, NULL, 108, 235, 235),
(703, 1, NULL, 148, 235, 125),
(704, 2, NULL, 63, 235, 165),
(705, 1, NULL, 116, 236, 350),
(706, 1, NULL, 104, 236, 495),
(707, 1, NULL, 107, 236, 245),
(708, 1, NULL, 148, 236, 125),
(709, 1, NULL, 98, 237, 535),
(710, 1, NULL, 105, 237, 540),
(711, 3, NULL, 161, 237, 125),
(712, 1, NULL, 109, 238, 495),
(713, 1, NULL, 117, 238, 190),
(714, 1, NULL, 148, 238, 125),
(715, 2, NULL, 160, 239, 95),
(716, 1, NULL, 148, 239, 125),
(717, 1, NULL, 42, 240, 450),
(718, 1, NULL, 65, 241, 165),
(719, 1, NULL, 121, 241, 335),
(720, 3, NULL, 156, 242, 130),
(721, 1, NULL, 64, 243, 150),
(722, 1, NULL, 91, 243, 495),
(723, 1, NULL, 110, 243, 275),
(724, 1, NULL, 98, 243, 535),
(725, 1, NULL, 149, 243, 90),
(726, 1, NULL, 63, 243, 165),
(727, 3, NULL, 83, 244, 325),
(728, 2, NULL, 59, 244, 275),
(729, 1, NULL, 104, 244, 495),
(730, 1, NULL, 148, 244, 125),
(731, 1, NULL, 74, 245, 345),
(732, 1, NULL, 116, 246, 350),
(733, 1, NULL, 148, 246, 125),
(734, 1, NULL, 145, 247, 125),
(735, 3, NULL, 62, 248, 150),
(736, 3, NULL, 87, 248, 485),
(737, 1, NULL, 148, 248, 125),
(738, 1, NULL, 144, 249, 100),
(739, 1, NULL, 145, 250, 125),
(740, 1, NULL, 145, 251, 125),
(741, 1, NULL, 156, 252, 130),
(742, 1, NULL, 52, 252, 105),
(743, 1, NULL, 65, 253, 165),
(744, 2, NULL, 98, 253, 535),
(745, 1, NULL, 99, 253, 535),
(746, 1, NULL, 90, 253, 490),
(747, 1, NULL, 148, 253, 125),
(748, 1, NULL, 65, 254, 165),
(749, 2, NULL, 98, 254, 535),
(750, 1, NULL, 99, 254, 535),
(751, 1, NULL, 90, 254, 490),
(752, 1, NULL, 148, 254, 125);

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

--
-- Table structure for table `tableorder`
--

CREATE TABLE IF NOT EXISTS `tableorder` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tableordertype` tinyint(1) NOT NULL DEFAULT '1',
  `tableno` varchar(20) NOT NULL,
  `waiter_id` int(11) NOT NULL,
  `date_of_tableorder` datetime NOT NULL,
  `comments` varchar(200) DEFAULT NULL,
  `cover` int(11) DEFAULT NULL,
  `gst_rate` tinyint(2) NOT NULL,
  `gst` double DEFAULT NULL,
  `discountrate` tinyint(3) NOT NULL,
  `discount` double NOT NULL DEFAULT '0',
  `payment` double DEFAULT NULL,
  `change` double DEFAULT NULL,
  `status` tinyint(4) NOT NULL,
  `check_no` varchar(20) NOT NULL,
  `total` double DEFAULT NULL,
  `footer` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `waiter_id` (`waiter_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=255 ;

--
-- Dumping data for table `tableorder`
--

INSERT INTO `tableorder` (`id`, `tableordertype`, `tableno`, `waiter_id`, `date_of_tableorder`, `comments`, `cover`, `gst_rate`, `gst`, `discountrate`, `discount`, `payment`, `change`, `status`, `check_no`, `total`, `footer`) VALUES
(11, 1, '11', 1, '2013-09-17 01:00:33', NULL, 5, 17, NULL, 0, 0, NULL, NULL, 1, 'fjkads', 234, NULL),
(12, 1, '03', 1, '2013-09-17 01:01:19', NULL, 5, 17, NULL, 0, 0, NULL, NULL, 1, 'asdas', 351, NULL),
(13, 1, '05', 1, '2013-09-17 01:02:37', NULL, 6, 0, NULL, 10, 0, NULL, NULL, 1, 'dsadsa', 720, NULL),
(14, 1, '89', 1, '2013-09-17 01:32:26', NULL, 5, 17, NULL, 20, 0, NULL, NULL, 1, '213', 1200.19, NULL),
(15, 1, '8', 1, '2013-09-17 01:33:20', NULL, 23, 17, NULL, 5, 0, NULL, NULL, 1, '5', 522.92, NULL),
(16, 1, '54', 1, '2013-09-17 01:33:37', NULL, 544, 0, NULL, 0, 250, NULL, NULL, 1, '4', 746, NULL),
(18, 1, '1', 1, '2013-09-17 01:49:56', NULL, 2, 17, NULL, 0, 0, NULL, NULL, 1, '001', 959.4, 'it is my new company'),
(19, 1, '2', 1, '2013-09-17 01:50:12', NULL, 3, 17, NULL, 0, 50, NULL, NULL, 1, '002', 1027.49, NULL),
(20, 1, '3', 1, '2013-09-17 01:50:22', NULL, 5, 0, NULL, 15, 0, NULL, NULL, 1, '003', 11820.8, NULL),
(21, 1, '5', 1, '2013-09-17 04:35:49', NULL, 8, 17, NULL, 0, 0, NULL, NULL, 1, '2131', 1027.49, NULL),
(22, 1, '4', 1, '2013-09-17 04:36:37', NULL, 8, 0, NULL, 0, 0, NULL, NULL, 1, '2185', 300, NULL),
(23, 1, '45', 1, '2013-09-17 04:36:46', NULL, 234, 17, NULL, 0, 0, NULL, NULL, 1, '4234', 2164.5, NULL),
(24, 1, '8', 1, '2013-09-17 05:11:02', NULL, 856, 17, NULL, 0, 0, NULL, NULL, 1, '51', 1027.49, NULL),
(25, 1, '55', 1, '2013-09-17 05:12:24', NULL, 854684, 17, NULL, 0, 0, NULL, NULL, 1, '845', 1027.49, NULL),
(26, 1, '945', 1, '2013-09-17 05:16:57', NULL, 8851, 17, NULL, 0, 200, NULL, NULL, 1, '84846', 1027.49, NULL),
(27, 1, '1848', 1, '2013-09-17 05:38:46', NULL, 84845, 17, NULL, 0, 0, NULL, NULL, 1, '87', 1027.49, NULL),
(28, 1, '4578', 1, '2013-09-17 05:40:03', NULL, 18, 17, NULL, 0, 0, NULL, NULL, 1, '68681', 1027.49, NULL),
(29, 1, '9', 1, '2013-09-17 06:23:22', NULL, 6, 17, NULL, 0, 25.6, NULL, NULL, 1, 'fdsfds', 1027.49, NULL),
(30, 1, '012', 1, '2013-09-20 03:52:23', NULL, 571, 17, NULL, 0, 500, NULL, NULL, 1, '5616', 4278.28, NULL),
(31, 1, '013', 1, '2013-09-20 03:53:10', NULL, 51, 0, NULL, 10, 0, NULL, NULL, 1, '6571', 754, NULL),
(32, 1, '014', 1, '2013-09-20 03:54:18', NULL, 84, 17, NULL, 20, 0, NULL, NULL, 1, '648', 589.4, NULL),
(33, 1, '2312323', 1, '2013-09-26 15:19:05', NULL, 4545, 17, NULL, 0, 0, NULL, NULL, 1, '1213112312312', 10717.2, NULL),
(34, 1, '56', 1, '2013-09-26 15:30:18', NULL, 5, 17, NULL, 10, 0, NULL, NULL, 1, '53423', 1267.35, NULL),
(35, 1, '2', 1, '2013-09-27 19:12:27', NULL, 2, 17, NULL, 0, 0, NULL, NULL, 1, '1', 438.75, NULL),
(36, 1, '1', 1, '2013-09-27 19:14:23', NULL, 1, 17, NULL, 100, 0, NULL, NULL, 1, '1', 69776.12, NULL),
(37, 1, '2', 1, '2013-09-28 16:18:13', NULL, 3, 17, NULL, 0, 0, NULL, NULL, 1, '12', 1760.85, NULL),
(38, 1, '16', 1, '2013-09-28 18:36:59', NULL, 2, 17, NULL, 0, 0, NULL, NULL, 1, '1084', 438.75, NULL),
(39, 1, '17', 1, '2013-09-28 18:39:01', NULL, 2, 17, NULL, 20, 0, NULL, NULL, 1, '1084', 538.35, 'Mr Farhan '),
(40, 1, '21', 1, '2013-09-28 18:44:24', NULL, 1, 17, NULL, 0, 0, NULL, NULL, 1, '1', 438.75, NULL),
(41, 1, '12', 1, '2013-09-28 18:52:01', NULL, 2, 17, NULL, 0, 0, NULL, NULL, 1, '1085', 438.75, NULL),
(42, 1, '17', 1, '2013-09-28 19:02:29', NULL, 3, 17, NULL, 0, 0, NULL, NULL, 1, '1086', 438.75, NULL),
(43, 1, 'loby', 1, '2013-09-28 20:57:20', NULL, 1, 17, NULL, 0, 0, NULL, NULL, 1, '1087', 175.5, NULL),
(44, 1, '11', 1, '2013-10-01 11:24:17', NULL, 2, 17, NULL, 45, 0, NULL, NULL, 1, '1115', 151.2, 'Mr Farhan(Account)'),
(45, 1, '1', 1, '2013-10-01 13:14:13', NULL, 2, 17, NULL, 0, 0, NULL, NULL, 1, '123', NULL, NULL),
(46, 1, '2', 1, '2013-10-01 13:15:46', NULL, 2, 17, NULL, 0, 0, NULL, NULL, 1, '2', 579.15, NULL),
(47, 1, '1', 1, '2013-10-01 13:22:02', NULL, 1, 17, NULL, 0, 0, NULL, NULL, 1, '15', 579.15, NULL),
(48, 1, '20', 1, '2013-10-01 13:23:01', NULL, 2, 17, NULL, 0, 0, NULL, NULL, 1, '1116', NULL, NULL),
(49, 1, '61', 1, '2013-10-01 13:25:43', NULL, 2, 17, NULL, 0, 0, NULL, NULL, 1, '1616', 579.15, NULL),
(50, 1, '78', 1, '2013-10-01 13:26:18', NULL, 1, 17, NULL, 0, 0, NULL, NULL, 1, '16', 321.75, NULL),
(51, 1, '11', 1, '2013-10-01 13:32:49', NULL, 2, 17, NULL, 0, 0, NULL, NULL, 1, '1115', 1585.35, NULL),
(52, 1, '0', 1, '2013-10-01 17:42:58', NULL, 2, 17, NULL, 0, 0, NULL, NULL, 1, '1116', 579.15, NULL),
(53, 1, '0', 1, '2013-10-01 17:44:42', NULL, 2, 17, NULL, 0, 0, NULL, NULL, 1, '1116', 1263.6, 'Mubarak(Cook)'),
(54, 1, '0', 1, '2013-10-01 17:46:17', NULL, 1, 17, NULL, 0, 0, NULL, NULL, 1, '1117', 631.8, 'Aftab(Account)'),
(55, 1, '0', 1, '2013-10-01 17:48:10', NULL, 1, 17, NULL, 0, 0, NULL, NULL, 1, '1118', 631.8, 'HAmid(Store)'),
(56, 1, '0', 1, '2013-10-01 17:49:06', NULL, 1, 17, NULL, 0, 0, NULL, NULL, 1, '1119', 286.65, 'Shaukat(Bar B Q)'),
(57, 1, '0', 1, '2013-10-01 17:50:55', NULL, 1, 17, NULL, 0, 0, NULL, NULL, 1, '1120', 286.65, 'Asif(F/O)'),
(58, 1, '16', 1, '2013-10-01 18:59:20', NULL, 2, 17, NULL, 0, 0, NULL, NULL, 1, '1121', 321.75, NULL),
(59, 1, '16', 1, '2013-10-01 18:59:59', NULL, 2, 17, NULL, 0, 0, NULL, NULL, 1, '1121', 245.7, NULL),
(60, 1, '16', 1, '2013-10-01 21:14:42', NULL, 1, 17, NULL, 0, 0, NULL, NULL, 1, '1122', 1246.05, NULL),
(61, 1, '16', 1, '2013-10-01 21:41:43', NULL, 3, 17, NULL, 33, 0, NULL, NULL, 1, '1123', 2603.25, NULL),
(62, 1, '10', 1, '2013-10-01 21:49:17', NULL, 1, 17, NULL, 0, 0, NULL, NULL, 1, '1124', 1287, NULL),
(63, 1, '9', 1, '2013-10-01 21:55:37', NULL, 1, 17, NULL, 0, 0, NULL, NULL, 1, '1125', 1140.75, NULL),
(64, 1, '9', 1, '2013-10-01 21:57:19', NULL, 1, 17, NULL, 0, 0, NULL, NULL, 1, '1127', 1140.75, NULL),
(65, 1, '16', 1, '2013-10-01 21:57:57', NULL, 1, 17, NULL, 0, 0, NULL, NULL, 1, '1127', 1392.3, NULL),
(66, 1, '16', 1, '2013-10-01 21:59:49', NULL, 1, 17, NULL, 0, 0, NULL, NULL, 1, '1128', 1287, NULL),
(67, 1, '9', 1, '2013-10-01 22:00:54', NULL, 1, 17, NULL, 0, 0, NULL, NULL, 1, '1130', 1351.35, NULL),
(68, 1, '10', 1, '2013-10-01 22:17:29', NULL, 1, 17, NULL, 0, 0, NULL, NULL, 1, '1132', 1140.75, NULL),
(69, 1, '11', 1, '2013-10-01 22:18:00', NULL, 1, 17, NULL, 0, 0, NULL, NULL, 1, '1133', 1287, NULL),
(70, 1, '1', 1, '2013-10-01 23:19:49', NULL, 1, 17, NULL, 0, 0, NULL, NULL, 1, '1134', 1287, NULL),
(71, 1, '10', 1, '2013-10-01 23:21:00', NULL, 1, 17, NULL, 0, 0, NULL, NULL, 1, '1135', 1433.25, NULL),
(72, 1, '12', 1, '2013-10-01 23:25:07', NULL, 1, 17, NULL, 0, 0, NULL, NULL, 1, '1138', 1140.75, NULL),
(73, 1, '16', 1, '2013-10-01 23:53:18', NULL, 1, 17, NULL, 0, 0, NULL, NULL, 1, '1149', 1246.05, NULL),
(74, 1, 'loby', 1, '2013-10-02 10:39:32', NULL, 2, 17, NULL, 0, 0, NULL, NULL, 1, '1141', 391.95, NULL),
(75, 1, '11', 1, '2013-10-02 13:03:18', NULL, 2, 17, NULL, 0, 0, NULL, NULL, 1, '1144', 544.05, NULL),
(76, 1, '11', 1, '2013-10-02 15:44:33', NULL, 6, 17, NULL, 0, 0, NULL, NULL, 1, '1145', 5136.3, NULL),
(77, 1, '20', 1, '2013-10-02 17:08:38', NULL, 2, 17, NULL, 100, 0, NULL, NULL, 1, '1146', 168.3, NULL),
(78, 1, '15', 1, '2013-10-02 18:29:01', NULL, 1, 17, NULL, 0, 0, NULL, NULL, 1, '1147', 409.5, NULL),
(79, 1, 'take away', 1, '2013-10-03 08:08:51', NULL, 1, 17, NULL, 0, 0, NULL, NULL, 1, '1162', 403.65, NULL),
(80, 1, '11', 1, '2013-10-04 11:31:22', NULL, 2, 17, NULL, 0, 0, NULL, NULL, 1, '1180', 286.65, NULL),
(81, 1, '11', 1, '2013-10-04 14:49:13', NULL, 1, 17, NULL, 15, 0, NULL, NULL, 1, '1181', 1099.8, 'Raja Latif'),
(82, 1, '21', 1, '2013-10-04 20:27:17', NULL, 2, 17, NULL, 0, 0, NULL, NULL, 1, '1182', 245.7, NULL),
(83, 1, '16', 1, '2013-10-04 21:20:21', NULL, 2, 17, NULL, 0, 0, NULL, NULL, 1, '1183', 2427.75, NULL),
(84, 1, '416', 1, '2013-10-04 21:21:46', NULL, 2, 17, NULL, 0, 0, NULL, NULL, 1, '16', 391.95, NULL),
(85, 1, '21', 1, '2013-10-04 21:53:52', NULL, 2, 17, NULL, 0, 0, NULL, NULL, 1, '1184', 2427.75, NULL),
(86, 1, '15', 1, '2013-10-05 02:38:04', NULL, 6, 17, NULL, 0, 0, NULL, NULL, 1, '1185', 3615.3, NULL),
(87, 1, 'lobi', 1, '2013-10-05 10:46:52', NULL, 3, 17, NULL, 0, 0, NULL, NULL, 1, '1196', 368.55, NULL),
(88, 1, ';kol', 1, '2013-10-05 11:35:16', NULL, 32, 17, NULL, 50, 0, NULL, NULL, 1, '15125', 2898.3, NULL),
(89, 1, '16', 1, '2013-10-05 12:19:57', NULL, 2, 17, NULL, 0, 0, NULL, NULL, 1, '1187', 0, NULL),
(90, 1, '15', 1, '2013-10-05 12:43:37', NULL, 3, 17, NULL, 0, 0, NULL, NULL, 1, '1183', 368.55, NULL),
(91, 1, '2', 1, '2013-10-05 12:44:34', NULL, 2, 17, NULL, 0, 0, NULL, NULL, 1, '1189', 280.8, NULL),
(92, 1, '12', 1, '2013-10-05 12:45:20', NULL, 1, 17, NULL, 0, 0, NULL, NULL, 1, '1100', 163.8, NULL),
(93, 1, '11', 1, '2013-10-05 12:57:08', NULL, 3, 17, NULL, 0, 0, NULL, NULL, 1, '1191', 269.1, NULL),
(94, 1, '1', 1, '2013-10-05 12:59:43', NULL, 3, 17, NULL, 0, 0, NULL, NULL, 1, '1191', 298.35, NULL),
(95, 1, '15', 1, '2013-10-05 13:00:49', NULL, 3, 17, NULL, 0, 0, NULL, NULL, 1, '1191', 409.5, NULL),
(96, 1, '10', 1, '2013-10-05 13:19:32', NULL, 1, 17, NULL, 0, 0, NULL, NULL, 1, '1194', 409.5, NULL),
(97, 1, '8', 1, '2013-10-05 15:43:17', NULL, 4, 17, NULL, 0, 0, NULL, NULL, 1, '1195', 4709.25, NULL),
(98, 1, '2', 1, '2013-10-05 16:30:56', NULL, 2, 17, NULL, 0, 0, NULL, NULL, 1, '1196', 245.7, NULL),
(99, 1, '11', 1, '2013-10-05 16:50:32', NULL, 1, 17, NULL, 0, 0, NULL, NULL, 1, '1197', 122.85, NULL),
(100, 1, '1', 1, '2013-10-05 17:55:07', NULL, 3, 17, NULL, 0, 0, NULL, NULL, 1, '1198', 1883.7, NULL),
(101, 1, '11', 1, '2013-10-05 17:57:38', NULL, 2, 17, NULL, 0, 0, NULL, NULL, 1, '1199', 1263.6, NULL),
(102, 1, '15', 1, '2013-10-05 18:14:00', NULL, 11, 17, NULL, 0, 0, NULL, NULL, 1, '1200', 6809.4, NULL),
(103, 1, '15', 1, '2013-10-05 18:15:02', NULL, 2, 17, NULL, 0, 0, NULL, NULL, 1, '1201', 12741.3, NULL),
(104, 1, '16', 1, '2013-10-05 18:16:07', NULL, 1, 17, NULL, 0, 0, NULL, NULL, 1, '1201', 579.15, NULL),
(105, 1, '15', 1, '2013-10-05 18:17:05', NULL, 2, 17, NULL, 100, 0, NULL, NULL, 1, '1202', 273.6, NULL),
(106, 1, '15', 1, '2013-10-05 19:07:24', NULL, 6, 17, NULL, 0, 0, NULL, NULL, 1, '1203', 1076.4, NULL),
(107, 1, '16', 1, '2013-10-05 19:25:10', NULL, 4, 17, NULL, 0, 0, NULL, NULL, 1, '1204', 1029.6, NULL),
(108, 1, 'T/A', 1, '2013-10-05 19:54:00', NULL, 1, 17, NULL, 20, 0, NULL, NULL, 1, '1205', 523.8, 'DAwood(F&B)'),
(109, 1, '16', 1, '2013-10-05 19:58:07', NULL, 2, 17, NULL, 0, 0, NULL, NULL, 1, '1206', 129.87, NULL),
(110, 1, '15', 1, '2013-10-05 19:58:44', NULL, 2, 17, NULL, 0, 0, NULL, NULL, 1, '1206', 351, NULL),
(111, 1, '11', 1, '2013-10-05 20:45:55', NULL, 2, 17, NULL, 0, 0, NULL, NULL, 1, '1207', 1000.35, NULL),
(112, 1, '17', 1, '2013-10-05 20:59:15', NULL, 2, 16, NULL, 0, 0, NULL, NULL, 1, '1208', 522, NULL),
(113, 1, '15', 1, '2013-10-05 22:14:59', NULL, 1, 16, NULL, 0, 0, NULL, NULL, 1, '1209', 1246.05, NULL),
(114, 1, 'lobi', 1, '2013-10-05 23:23:24', NULL, 3, 16, NULL, 0, 0, NULL, NULL, 1, '1210', 596.7, NULL),
(115, 1, '21', 1, '2013-10-06 00:33:44', NULL, 3, 16, NULL, 0, 0, NULL, NULL, 1, '1111', 162.4, NULL),
(116, 1, '1', 1, '2013-10-06 10:10:09', NULL, 2, 16, NULL, 0, 0, NULL, NULL, 1, '1211', 696, NULL),
(117, 1, '1', 1, '2013-10-06 10:14:36', NULL, 2, 16, NULL, 0, 0, NULL, NULL, 1, '1211', 1148.4, NULL),
(118, 1, '20', 1, '2013-10-06 15:45:28', NULL, 1, 16, NULL, 50, 0, NULL, NULL, 1, '1212', 798.4, 'S Tanvir A Jafri'),
(119, 1, '11', 1, '2013-10-06 17:05:14', NULL, 2, 16, NULL, 0, 0, NULL, NULL, 1, '1212', 1252.8, NULL),
(120, 1, '2', 1, '2013-10-06 20:13:54', NULL, 2, 16, NULL, 0, 0, NULL, NULL, 1, '1214', 290, NULL),
(121, 1, '35', 1, '2013-10-06 20:26:47', NULL, 3, 16, NULL, 0, 0, NULL, NULL, 1, '1215', 3828, NULL),
(122, 1, '16', 1, '2013-10-06 21:10:02', NULL, 3, 16, NULL, 0, 0, NULL, NULL, 1, '1216', 887.4, NULL),
(123, 1, '2', 1, '2013-10-06 21:13:25', NULL, 2, 16, NULL, 0, 0, NULL, NULL, 1, '1217', 348, NULL),
(124, 1, '13', 1, '2013-10-06 22:36:06', NULL, 5, 16, NULL, 0, 0, NULL, NULL, 1, '1213', 2273.6, NULL),
(125, 1, '17', 1, '2013-10-06 22:49:16', NULL, 1, 16, NULL, 0, 0, NULL, NULL, 1, '1219', 104.4, NULL),
(126, 1, '15', 1, '2013-10-07 07:17:05', NULL, 1, 16, NULL, 0, 0, NULL, NULL, 1, '1221', 104.4, NULL),
(127, 1, '32', 1, '2013-10-07 10:47:32', NULL, 1, 16, NULL, 0, 0, NULL, NULL, 1, '1225', 435, NULL),
(128, 1, '12', 1, '2013-10-07 11:52:07', NULL, 4, 16, NULL, 0, 0, NULL, NULL, 1, '1226', 1821.2, NULL),
(129, 1, '23', 1, '2013-10-07 20:48:14', NULL, 4, 16, NULL, 0, 0, NULL, NULL, 1, '1231', 2343.2, NULL),
(130, 1, '23', 1, '2013-10-07 20:50:37', NULL, 4, 16, NULL, 0, 0, NULL, NULL, 1, '1231', 5278, NULL),
(131, 1, '05', 1, '2013-10-07 21:30:00', NULL, 5, 16, NULL, 20, 0, NULL, NULL, 1, '1282', 290, 'Mr Khalil(UAE Embassy)'),
(132, 1, '16', 1, '2013-10-07 22:13:10', NULL, 2, 16, NULL, 0, 0, NULL, NULL, 1, '1233', 2407, NULL),
(133, 1, '15', 1, '2013-10-08 02:46:43', NULL, 3, 16, NULL, 0, 0, NULL, NULL, 1, '1235', 1844.4, NULL),
(134, 1, '17', 1, '2013-10-08 10:32:37', NULL, 2, 16, NULL, 0, 0, NULL, NULL, 1, '1236', 812, NULL),
(135, 1, '18', 1, '2013-10-08 10:36:11', NULL, 1, 16, NULL, 0, 0, NULL, NULL, 1, '1237', 104.4, NULL),
(136, 1, '15', 1, '2013-10-08 14:30:15', NULL, 1, 16, NULL, 0, 0, NULL, NULL, 1, '1238', 893.2, NULL),
(137, 1, '16', 1, '2013-10-08 16:37:40', NULL, 3, 16, NULL, 0, 0, NULL, NULL, 1, '1239', 1270.2, NULL),
(138, 1, '17', 1, '2013-10-08 17:00:27', NULL, 5, 16, NULL, 0, 0, NULL, NULL, 1, '1240', 933.8, NULL),
(139, 1, '18', 1, '2013-10-08 17:04:31', NULL, 5, 16, NULL, 0, 0, NULL, NULL, 1, '1240', 748.2, NULL),
(140, 1, '3', 1, '2013-10-08 17:11:16', NULL, 2, 16, NULL, 0, 0, NULL, NULL, 1, '1241', 690.2, NULL),
(141, 1, '13', 1, '2013-10-08 17:19:27', NULL, 2, 16, NULL, 0, 0, NULL, NULL, 1, '1242', 1293.4, NULL),
(142, 1, '14', 1, '2013-10-08 17:31:41', NULL, 2, 16, NULL, 100, 0, NULL, NULL, 1, '1243', 303.4, 'Amjad Shahzad'),
(143, 1, '1', 1, '2013-10-08 17:36:42', NULL, 1, 16, NULL, 10, 0, NULL, NULL, 1, '1231', 324.8, 'jjjj'),
(144, 1, '11', 1, '2013-10-08 17:43:35', NULL, 5, 16, NULL, 10, 0, NULL, NULL, 1, '1244', 2768.5, 'C/O Mr Zulfiqar'),
(145, 1, '12', 1, '2013-10-08 18:31:44', NULL, 3, 16, NULL, 0, 0, NULL, NULL, 1, '1246', 522, NULL),
(146, 1, '7', 1, '2013-10-08 19:23:24', NULL, 1, 16, NULL, 0, 0, NULL, NULL, 1, '1244', 75690, NULL),
(147, 1, '50', 1, '2013-10-08 19:30:11', NULL, 2, 16, NULL, 0, 0, NULL, NULL, 1, '1243', 388.6, NULL),
(148, 1, '20', 1, '2013-10-08 19:32:54', NULL, 2, 16, NULL, 0, 0, NULL, NULL, 1, '1249', 991.8, NULL),
(149, 1, '55', 1, '2013-10-08 20:34:40', NULL, 1, 16, NULL, 0, 0, NULL, NULL, 1, '1250', 1235.4, NULL),
(150, 1, '30', 1, '2013-10-08 20:39:20', NULL, 3, 16, NULL, 0, 0, NULL, NULL, 1, '1251', 365.4, NULL),
(151, 1, '03', 1, '2013-10-08 21:05:40', NULL, 2, 16, NULL, 0, 0, NULL, NULL, 1, '1252', 4130557, NULL),
(152, 1, '19', 1, '2013-10-08 21:06:24', NULL, 2, 16, NULL, 0, 0, NULL, NULL, 1, '1255', 2407, NULL),
(153, 1, '17', 1, '2013-10-08 21:07:51', NULL, 2, 16, NULL, 0, 0, NULL, NULL, 1, '1253', 1148.4, NULL),
(154, 1, '01', 1, '2013-10-08 21:14:54', NULL, 1, 16, NULL, 0, 0, NULL, NULL, 1, '1254', 139.2, NULL),
(155, 1, '22', 1, '2013-10-08 21:44:43', NULL, 2, 16, NULL, 50, 0, NULL, NULL, 1, '1255', 1391.4, 'Raja Amir'),
(156, 1, '61', 1, '2013-10-08 21:53:25', NULL, 1, 16, NULL, 0, 0, NULL, NULL, 1, '1266', 1235.4, NULL),
(157, 1, '15', 1, '2013-10-08 23:56:14', NULL, 2, 16, NULL, 0, 0, NULL, NULL, 1, '1257', 388.6, NULL),
(158, 1, '300', 1, '2013-10-09 09:09:36', NULL, 1, 16, NULL, 0, 0, NULL, NULL, 1, '1253', 104.4, NULL),
(159, 1, '114', 1, '2013-10-09 09:33:44', NULL, 1, 16, NULL, 0, 0, NULL, NULL, 1, '1259', 104.4, NULL),
(160, 1, '4b', 1, '2013-10-09 13:58:22', NULL, 2, 16, NULL, 0, 0, NULL, NULL, 1, '1260', 377, NULL),
(161, 1, '304', 1, '2013-10-09 14:33:13', NULL, 2, 16, NULL, 0, 0, NULL, NULL, 1, '1261', 2407, NULL),
(162, 1, '5', 1, '2013-10-09 17:54:40', NULL, 3, 16, NULL, 0, 0, NULL, NULL, 1, '1263', 649.6, NULL),
(163, 1, '6', 1, '2013-10-09 18:03:04', NULL, 6, 16, NULL, 0, 0, NULL, NULL, 1, '1264', 3735.2, NULL),
(164, 1, '18', 1, '2013-10-09 18:06:44', NULL, 23, 16, NULL, 0, 0, NULL, NULL, 1, '1265', 13206.6, NULL),
(165, 1, '16', 1, '2013-10-09 21:46:17', NULL, 2, 16, NULL, 0, 0, NULL, NULL, 1, '1263', 2407, NULL),
(166, 1, '413', 1, '2013-10-10 09:33:27', NULL, 1, 16, NULL, 0, 0, NULL, NULL, 1, '1274', 522, NULL),
(167, 1, 'labi', 1, '2013-10-10 10:54:30', NULL, 2, 16, NULL, 0, 0, NULL, NULL, 1, '1275', 261, NULL),
(168, 1, '12', 1, '2013-10-10 13:50:31', NULL, 8, 16, NULL, 0, 0, NULL, NULL, 1, '1275', 9338, NULL),
(169, 1, '16', 1, '2013-10-10 15:36:26', NULL, 7, 16, NULL, 0, 0, NULL, NULL, 1, '1277', 8624.6, NULL),
(170, 1, '11', 1, '2013-10-10 16:31:40', NULL, 4, 16, NULL, 0, 0, NULL, NULL, 1, '1278', 2262, NULL),
(171, 1, '111111', 1, '2013-10-10 19:35:59', NULL, 111111, 16, NULL, 0, 0, NULL, NULL, 1, '11111111111', 1809.6, NULL),
(172, 1, '456', 1, '2013-10-10 19:38:38', NULL, 789, 16, NULL, 0, 0, NULL, NULL, 1, '123', 719.2, NULL),
(173, 1, '213', 1, '2013-10-10 19:47:59', NULL, 2323, 16, NULL, 0, 0, NULL, NULL, 1, '123', 1003.4, NULL),
(174, 1, '5555555', 1, '2013-10-10 20:02:18', NULL, 1649, 16, NULL, 0, 0, NULL, NULL, 1, '123', 2256.2, NULL),
(175, 1, '129', 1, '2013-10-10 22:12:05', NULL, 15, 16, NULL, 0, 0, NULL, NULL, 1, '1288', 2552, NULL),
(176, 1, '10', 1, '2013-10-11 11:16:51', NULL, 1, 16, NULL, 0, 0, NULL, NULL, 1, '1291', 104.4, NULL),
(177, 1, '17', 1, '2013-10-11 12:11:37', NULL, 3, 16, NULL, 0, 0, NULL, NULL, 1, '1292', 510.4, NULL),
(178, 1, '1', 1, '2013-10-11 14:19:06', NULL, 1, 16, NULL, 0, 0, NULL, NULL, 1, '1293', 626.4, NULL),
(179, 1, '14', 1, '2013-10-11 14:21:43', NULL, 1, 16, NULL, 0, 0, NULL, NULL, 1, '1293', 145, NULL),
(180, 1, '19', 1, '2013-10-11 19:46:46', NULL, 1, 16, NULL, 0, 0, NULL, NULL, 1, '3312', 1276, NULL),
(181, 1, '305', 1, '2013-10-12 09:30:14', NULL, 1, 16, NULL, 0, 0, NULL, NULL, 1, '1303', 145, NULL),
(182, 1, '23', 1, '2013-10-12 13:46:13', NULL, 1, 16, NULL, 0, 0, NULL, NULL, 1, '1304', 1235.4, NULL),
(183, 1, 'lobi', 1, '2013-10-12 13:50:02', NULL, 3, 16, NULL, 0, 0, NULL, NULL, 1, '1305', 510.4, NULL),
(184, 1, '4', 1, '2013-10-12 15:05:06', NULL, 1, 16, NULL, 0, 0, NULL, NULL, 1, '1306', 145, NULL),
(185, 1, '1', 1, '2013-10-12 16:12:57', NULL, 1, 16, NULL, 0, 0, NULL, NULL, 1, '1307', 139.2, NULL),
(186, 1, '03', 1, '2013-10-12 16:59:40', NULL, 3, 16, NULL, 0, 0, NULL, NULL, 1, '1308', 3851.2, NULL),
(187, 1, '21', 1, '2013-10-12 17:01:44', NULL, 2, 16, NULL, 0, 0, NULL, NULL, 1, '1309', 2615.8, NULL),
(188, 1, '18', 1, '2013-10-12 17:22:52', NULL, 3, 16, NULL, 0, 0, NULL, NULL, 1, '1310', 765.6, NULL),
(189, 1, '20', 1, '2013-10-12 17:25:34', NULL, 3, 16, NULL, 0, 0, NULL, NULL, 1, '1310', 910.6, NULL),
(190, 1, '10', 1, '2013-10-12 17:43:00', NULL, 3, 16, NULL, 0, 0, NULL, NULL, 1, '1311', 3683, NULL),
(191, 1, '22', 1, '2013-10-12 17:46:20', NULL, 1, 16, NULL, 0, 0, NULL, NULL, 1, '1312', 110.2, NULL),
(192, 1, '3', 1, '2013-10-12 18:32:01', NULL, 2, 16, NULL, 0, 0, NULL, NULL, 1, '1313', 759.8, NULL),
(193, 1, '11', 1, '2013-10-12 19:45:12', NULL, 1, 16, NULL, 0, 0, NULL, NULL, 1, '1314', 1235.4, NULL),
(194, 1, '13', 1, '2013-10-12 21:03:41', NULL, 2, 16, NULL, 0, 0, NULL, NULL, 1, '1315', 1438.4, NULL),
(195, 1, '12', 1, '2013-10-12 23:36:49', NULL, 3, 16, NULL, 0, 0, NULL, NULL, 1, '1316', 783, NULL),
(196, 1, '6', 1, '2013-10-13 09:24:22', NULL, 1, 16, NULL, 0, 0, NULL, NULL, 1, '1319', 522, NULL),
(197, 1, 'loby', 1, '2013-10-13 11:43:32', NULL, 1, 16, NULL, 0, 0, NULL, NULL, 1, '1321', 145, NULL),
(198, 1, '15', 1, '2013-10-13 12:33:46', NULL, 4, 16, NULL, 0, 0, NULL, NULL, 1, '1322', 556.8, NULL),
(199, 1, 'lobby', 1, '2013-10-13 14:44:00', NULL, 2, 16, NULL, 0, 0, NULL, NULL, 1, '1323', 266.8, NULL),
(200, 1, '12', 1, '2013-10-13 15:53:18', NULL, 4, 16, NULL, 0, 0, NULL, NULL, 1, '1324', 4814, NULL),
(201, 1, '406', 1, '2013-10-13 16:26:49', NULL, 1, 16, NULL, 0, 0, NULL, NULL, 1, '1324', 452.4, NULL),
(202, 1, '1325', 1, '2013-10-13 17:37:24', NULL, 6, 16, NULL, 0, 0, NULL, NULL, 1, '1325', 11008.4, NULL),
(203, 1, '13', 1, '2013-10-13 17:43:38', NULL, 6, 16, NULL, 0, 0, NULL, NULL, 1, '1325', 6931, NULL),
(204, 1, '12', 1, '2013-10-13 18:30:40', NULL, 2, 16, NULL, 100, 0, NULL, NULL, 1, '1326', 158.4, 'M Sufyan '),
(205, 1, '16', 1, '2013-10-13 18:33:23', NULL, 4, 16, NULL, 0, 0, NULL, NULL, 1, '1327', 4669, NULL),
(206, 1, '11', 1, '2013-10-13 18:34:06', NULL, 4, 16, NULL, 25, 0, NULL, NULL, 1, '1327', 3798.4, 'M Suffian'),
(207, 1, '21', 1, '2013-10-13 19:20:25', NULL, 4, 16, NULL, 0, 0, NULL, NULL, 1, '1328', 1096.2, NULL),
(208, 1, '18', 1, '2013-10-13 21:34:08', NULL, 3, 16, NULL, 0, 0, NULL, NULL, 1, '1330', 4118, NULL),
(209, 1, '14', 1, '2013-10-13 22:06:08', NULL, 7, 16, NULL, 0, 0, NULL, NULL, 1, '1331', 8207, NULL),
(210, 1, '15', 1, '2013-10-13 22:17:30', NULL, 2, 16, NULL, 0, 0, NULL, NULL, 1, '1332', 2470.8, NULL),
(211, 1, '05', 1, '2013-10-13 23:30:07', NULL, 4, 16, NULL, 0, 0, NULL, NULL, 1, '1333', 1519.6, NULL),
(212, 1, '7', 1, '2013-10-13 23:36:08', NULL, 1, 16, NULL, 0, 0, NULL, NULL, 1, '1234', 429.2, NULL),
(213, 1, '411', 1, '2013-10-14 08:25:53', NULL, 1, 16, NULL, 0, 0, NULL, NULL, 1, '1334', 104.4, NULL),
(214, 1, '1552', 1, '2013-10-14 09:40:06', NULL, 1, 16, NULL, 0, 0, NULL, NULL, 1, '1335', 145, NULL),
(215, 1, '144', 1, '2013-10-14 20:36:41', NULL, 9, 16, NULL, 0, 0, NULL, NULL, 1, '1231', 10759, NULL),
(216, 1, '156', 1, '2013-10-14 20:38:06', NULL, 9, 16, NULL, 0, 0, NULL, NULL, 1, '1564', 10759, NULL),
(217, 1, '123', 1, '2013-10-14 20:39:11', NULL, 9, 16, NULL, 0, 0, NULL, NULL, 1, '1546', 11049, NULL),
(218, 1, '152', 1, '2013-10-14 20:42:20', NULL, 9, 16, NULL, 0, 0, NULL, NULL, 1, '1456', 104.4, NULL),
(219, 1, '4', 1, '2013-10-14 20:52:12', NULL, 9, 16, NULL, 0, 0, NULL, NULL, 1, '1600', 11919, NULL),
(220, 1, '40', 1, '2013-10-14 21:06:54', NULL, 9, 16, NULL, 0, 0, NULL, NULL, 1, '1336', 10469, NULL),
(221, 1, '400', 1, '2013-10-14 23:16:41', NULL, 2, 16, NULL, 20, 0, NULL, NULL, 1, '1337', 576, NULL),
(222, 1, '213', 1, '2013-10-15 00:53:22', NULL, 2, 16, NULL, 0, 0, NULL, NULL, 1, '1333', 423.4, NULL),
(223, 1, '17', 1, '2013-10-15 14:17:34', NULL, 1, 16, NULL, 0, 0, NULL, NULL, 1, '1338', 377, NULL),
(224, 1, 'coffee', 1, '2013-10-15 17:23:56', NULL, 1, 16, NULL, 0, 0, NULL, NULL, 1, '1339', 2128.6, NULL),
(225, 1, '40', 1, '2013-10-15 20:45:26', NULL, 1, 16, NULL, 0, 0, NULL, NULL, 1, '1340', 104.4, NULL),
(226, 1, '41', 1, '2013-10-15 20:46:43', NULL, 1, 16, NULL, 0, 0, NULL, NULL, 1, '1340', 110.2, NULL),
(227, 1, '140', 1, '2013-10-16 18:31:43', NULL, 2, 16, NULL, 0, 0, NULL, NULL, 1, '1341', 2180.8, NULL),
(228, 1, '19', 1, '2013-10-17 20:05:04', NULL, 1, 16, NULL, 0, 0, NULL, NULL, 1, '1343', 435, NULL),
(229, 1, '22', 1, '2013-10-19 07:53:45', NULL, 1, 16, NULL, 0, 0, NULL, NULL, 1, '1344', 104.4, NULL),
(230, 1, '01', 1, '2013-10-19 09:54:13', NULL, 1, 16, NULL, 0, 0, NULL, NULL, 1, '1345', 609, NULL),
(231, 1, '02', 1, '2013-10-19 10:21:53', NULL, 1, 16, NULL, 0, 0, NULL, NULL, 1, '1347', 3781.6, NULL),
(232, 1, '03', 1, '2013-10-19 16:03:58', NULL, 1, 16, NULL, 0, 0, NULL, NULL, 1, '1348', 104.4, NULL),
(233, 1, '04', 1, '2013-10-19 18:18:17', NULL, 3, 16, NULL, 0, 0, NULL, NULL, 1, '1350', 556.8, NULL),
(234, 1, '05', 1, '2013-10-19 19:27:56', NULL, 2, 16, NULL, 0, 0, NULL, NULL, 1, '1351', 1479, NULL),
(235, 1, '06', 1, '2013-10-19 21:02:08', NULL, 2, 16, NULL, 0, 0, NULL, NULL, 1, '1352', 1276, NULL),
(236, 1, '18', 1, '2013-10-19 23:13:38', NULL, 3, 16, NULL, 0, 0, NULL, NULL, 1, '1353', 1409.4, NULL),
(237, 1, '01', 1, '2013-10-20 14:46:49', NULL, 1, 16, NULL, 0, 0, NULL, NULL, 1, '1354', 1682, NULL),
(238, 1, '40', 1, '2013-10-20 22:33:11', NULL, 2, 16, NULL, 15, 0, NULL, NULL, 1, '1355', 836.85, 'Samad Khan'),
(239, 1, '10', 1, '2013-10-20 23:48:58', NULL, 2, 16, NULL, 0, 0, NULL, NULL, 1, '1356', 365.4, NULL),
(240, 1, '110', 1, '2013-10-21 08:23:12', NULL, 1, 16, NULL, 0, 0, NULL, NULL, 1, '1357', 522, NULL),
(241, 1, '01', 1, '2013-10-21 14:02:09', NULL, 2, 16, NULL, 0, 0, NULL, NULL, 1, '1353', 580, NULL),
(242, 1, '01', 1, '2013-10-21 15:07:41', NULL, 3, 16, NULL, 0, 0, NULL, NULL, 1, '1350', 452.4, NULL),
(243, 1, '01', 1, '2013-10-21 18:15:11', NULL, 2, 16, NULL, 0, 0, NULL, NULL, 1, '1360', 1983.6, NULL),
(244, 1, '01', 1, '2013-10-21 18:49:53', NULL, 5, 16, NULL, 0, 0, NULL, NULL, 1, '1361', 2488.2, NULL),
(245, 1, 'Take Away', 1, '2013-10-21 21:51:27', NULL, 1, 16, NULL, 0, 0, NULL, NULL, 1, '1662', 400.2, NULL),
(246, 1, '18', 1, '2013-10-21 22:34:59', NULL, 2, 16, NULL, 0, 0, NULL, NULL, 1, '1363', 551, NULL),
(247, 1, 'Lobby', 1, '2013-10-21 22:55:23', NULL, 1, 16, NULL, 0, 0, NULL, NULL, 1, '1364', 145, NULL),
(248, 1, '25', 1, '2013-10-21 23:27:43', NULL, 3, 16, NULL, 0, 0, NULL, NULL, 1, '1365', 2354.8, NULL),
(249, 1, '11', 1, '2013-10-22 12:27:48', NULL, 1, 16, NULL, 0, 0, NULL, NULL, 1, '1366', 116, NULL),
(250, 1, '12', 1, '2013-10-22 12:29:39', NULL, 1, 16, NULL, 0, 0, NULL, NULL, 1, '1366', 145, NULL),
(251, 1, '11', 1, '2013-10-22 13:29:40', NULL, 1, 16, NULL, 0, 0, NULL, NULL, 0, '1366', 145, NULL),
(252, 1, '15', 1, '2013-10-22 14:35:30', NULL, 2, 16, NULL, 0, 0, NULL, NULL, 0, '1368', 272.6, NULL),
(253, 1, '40', 1, '2013-10-22 17:53:19', NULL, 3, 16, NULL, 0, 0, NULL, NULL, 0, '1369', 2766.6, NULL),
(254, 1, '32', 1, '2013-10-22 17:57:12', NULL, 3, 16, NULL, 0, 0, NULL, NULL, 0, '1370', 2766.6, NULL);

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

--
-- Table structure for table `user`
--

CREATE TABLE IF NOT EXISTS `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `username` varchar(20) NOT NULL,
  `password` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`id`, `name`, `username`, `password`) VALUES
(1, 'imdad', 'imdad', '1'),
(2, 'fgsfdgfsd', 'gdsfgfdsg', '1'),
(3, 'fsadf', 'fdsafds', '1'),
(5, 'لديك', 'لديك', 'لديك'),
(6, 'لديك', 'الجديدة', '1'),
(7, 'imdad', 'imdadhussain', '1'),
(8, 'ali', 'ali', '1'),
(9, 'إمداد حسين', 'إمداد حسين', '1'),
(10, 'بابار', 'بابار', '1'),
(11, 'إمداد حسين', 'إمداد حسين v', '1');

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

--
-- Table structure for table `waiter`
--

CREATE TABLE IF NOT EXISTS `waiter` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `waiter`
--

INSERT INTO `waiter` (`id`, `name`) VALUES
(1, 'Ali c');

--
-- Constraints for dumped tables
--

--
-- Constraints for table `item`
--
ALTER TABLE `item`
  ADD CONSTRAINT `item_ibfk_1` FOREIGN KEY (`menu_id`) REFERENCES `menu` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `orderdetail`
--
ALTER TABLE `orderdetail`
  ADD CONSTRAINT `orderdetail_ibfk_1` FOREIGN KEY (`menu_id`) REFERENCES `menu` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `orderdetail_ibfk_2` FOREIGN KEY (`item_id`) REFERENCES `item` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `orderdetail_ibfk_3` FOREIGN KEY (`tableorder_id`) REFERENCES `tableorder` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `tableorder`
--
ALTER TABLE `tableorder`
  ADD CONSTRAINT `tableorder_ibfk_1` FOREIGN KEY (`waiter_id`) REFERENCES `waiter` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

/*!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 */;