   `total_price` int(9) NOT NULL
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
---
--- Dumping data for table `cart`
---
-
-INSERT INTO `cart` (`id`, `till`, `code`, `name`, `price`, `quantity`, `total_price`) VALUES
-(2, 2, 265, 'pizza', 250, 1, 250),
-(6, 1, 819, 'Chicken Chilly', 200, 1, 200),
-(7, 1, 865, 'Taccos', 200, 1, 200),
-(8, 1, 931, 'palak panneer', 125, 1, 125),
-(9, 1, 790, 'Chicken Chilly', 200, 1, 200),
-(10, 1, 582, 'Black Forest Cake', 150, 1, 150);
-
 -- --------------------------------------------------------
 
 --

  `user` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `report`
--

INSERT INTO `report` (`id`, `report_date`, `visible`, `code`, `name`, `price`, `quantity`, `total_sales`, `delivery_type`, `from_time`, `to_time`, `user_id`, `user`) VALUES
(128, '2015/11/22', 0, 354, 'Burger', 100, 1, 100, 'Eat In', '23:23:56', '', 18, 'admin'),
(129, '2015/11/22', 0, 96, 'Fanta', 25, 1, 25, 'Eat In', '23:24:04', '', 18, 'admin'),
(130, '2015/11/22', 0, 658, 'Chicken Kabab', 250, 1, 250, 'Eat In', '23:24:09', '', 18, 'admin'),
(132, '2015/11/22', 0, 752, 'banana momo', 80, 1, 80, 'Eat In', '23:35:13', '', 19, 'manager'),
(133, '2015/11/22', 0, 857, 'Chicken Kabab', 250, 1, 250, 'Eat In', '23:35:16', '', 19, 'manager'),
(134, '2015/11/22', 0, 823, 'Burger', 100, 1, 100, 'Eat In', '23:42:35', '', 18, 'admin'),
(136, '2015/11/23', 0, 879, 'banana milkshake', 50, 1, 50, 'Eat In', '00:57:49', '01:05:40', 20, 'staff'),
(137, '2015/11/23', 0, 640, 'mango juice', 50, 1, 50, 'Eat In', '00:57:53', '01:05:39', 20, 'staff'),
(138, '2015/11/23', 0, 396, 'Burger', 100, 2, 200, 'Eat In', '00:57:57', '01:05:39', 20, 'staff'),
(139, '2015/11/23', 0, 240, 'c momo', 70, 1, 70, 'Eat In', '01:07:01', '20:39:43', 18, 'admin'),
(140, '2015/11/27', 0, 806, 'aalu dum', 45, 1, 45, 'Eat In', '12:21:55', '12:22:08', 18, 'admin'),
(141, '2015/11/29', 0, 473, 'Burger', 100, 2, 200, 'Eat In', '14:08:06', '14:11:06', 18, 'admin'),
(142, '2015/11/29', 0, 513, 'banana milkshake', 50, 1, 50, 'Eat In', '14:08:16', '14:11:05', 18, 'admin'),
(143, '2015/11/29', 0, 24, 'banana milkshake', 50, 1, 50, 'Eat In', '14:16:44', '20:52:40', 20, 'staff'),
(144, '2015/11/29', 0, 618, 'Chicken Chilly', 200, 1, 200, 'Eat In', '14:29:13', '14:29:32', 18, 'admin'),
(145, '2015/11/29', 0, 187, 'Burger', 100, 1, 100, 'Eat In', '20:24:32', '20:52:39', 18, 'admin'),
(147, '2015/12/05', 0, 265, 'pizza', 250, 1, 250, 'Eat In', '13:14:57', '13:41:25', 19, 'manager'),
(148, '2015/12/05', 0, 538, 'Burger', 100, 1, 100, 'Eat In', '13:25:50', '13:41:26', 18, 'admin'),
(149, '2015/12/05', 0, 328, 'Chicken Chilly', 200, 1, 200, 'Eat In', '13:39:38', '13:41:27', 18, 'admin'),
(150, '2015/12/05', 0, 63, 'Chicken Chilly', 200, 1, 200, 'Eat In', '13:42:30', '', 18, 'admin'),
(151, '2015/12/05', 1, 819, 'Chicken Chilly', 200, 1, 200, 'Eat In', '13:49:54', '14:08:47', 20, 'staff'),
(152, '2015/12/05', 1, 865, 'Taccos', 200, 1, 200, 'Eat In', '13:53:52', '14:08:51', 18, 'admin'),
(153, '2015/12/05', 1, 931, 'palak panneer', 125, 1, 125, 'Eat In', '14:21:46', '14:22:05', 18, 'admin'),
(154, '2015/12/10', 1, 790, 'Chicken Chilly', 200, 1, 200, 'Eat In', '16:41:19', '', 18, 'admin'),
(155, '2015/12/10', 1, 582, 'Black Forest Cake', 150, 1, 150, 'Eat In', '16:50:10', '', 18, 'admin');

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

--

  `name` varchar(30) NOT NULL,
  `category_code` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

