-- phpMyAdmin SQL Dump
-- version 5.0.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jul 06, 2024 at 05:25 PM
-- Server version: 10.4.17-MariaDB
-- PHP Version: 8.0.1

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


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

--
-- Database: `jacyjoka`
--

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

--
-- Table structure for table `bookings`
--

CREATE TABLE `bookings` (
  `booking_id` int(11) NOT NULL,
  `room_id` int(11) NOT NULL,
  `user_name` varchar(20) NOT NULL,
  `check_in_date` datetime NOT NULL,
  `check_out_date` datetime NOT NULL,
  `guest` varchar(25) NOT NULL,
  `status` varchar(25) NOT NULL,
  `trans_id` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `category`
--

CREATE TABLE `category` (
  `cat_id` int(11) NOT NULL,
  `cate_name` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `category`
--

INSERT INTO `category` (`cat_id`, `cate_name`) VALUES
(5, 'Food'),
(4, 'Product'),
(6, 'Food-Item'),
(7, 'Consumable');

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

--
-- Table structure for table `customers`
--

CREATE TABLE `customers` (
  `customer_id` int(11) NOT NULL,
  `full_name` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `county` varchar(255) DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `phone_number` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `dispose`
--

CREATE TABLE `dispose` (
  `dispose_id` int(11) NOT NULL,
  `disposed_by` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `disposed_items`
--

CREATE TABLE `disposed_items` (
  `di_id` int(11) NOT NULL,
  `product_name` varchar(255) DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `dispose_id` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `employees`
--

CREATE TABLE `employees` (
  `employee_id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `phone_number` varchar(255) DEFAULT NULL,
  `registration_date` date DEFAULT NULL,
  `salary_amount` decimal(10,2) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `employees`
--

INSERT INTO `employees` (`employee_id`, `name`, `password`, `phone_number`, `registration_date`, `salary_amount`, `type`, `username`) VALUES
(2, 'CATHERINE', '7878', '0722918312', '2024-02-01', '0.00', 'Waiter', 'CATHY'),
(8, 'GEOFFREY', '1993', '0703827196', '2024-01-13', '0.00', 'Waiter', 'OKOTH'),
(5, 'MATHEKA', '2020', '0725798295', '2024-01-09', '0.00', 'Manager', 'MATHES'),
(6, 'LOISE', '32821453', '0795334087', '2024-01-09', '0.00', 'Receptionist', 'LOISE'),
(25, 'irene kilonzo', '6724', '0748440554', '2024-01-23', '0.00', 'Waiter', 'SOFTEE'),
(9, 'CYRUS', 'chamcy2024', '0718263182', '2024-01-13', '0.00', 'Manager', 'CYRUS'),
(15, 'Janet', 'NylahAmarah', '+254720027902', '2024-01-17', '0.00', 'CEO', 'Janet'),
(22, 'MATHEKA', '2020', '0725798295', '2024-01-17', '0.00', 'Cashier', 'nzomo'),
(18, 'Cyrus rec', 'chamcy2024', '0718263182', '2024-01-17', '0.00', 'Receptionist', 'Cyrus rec'),
(20, 'Cyrus cashier', 'chamcy2024', '0718263182', '2024-01-17', '0.00', 'Cashier', 'Cyrus cashier'),
(21, 'MATHEKA', '2020', '0725798295', '2024-01-17', '0.00', 'Receptionist', 'Kamotho'),
(26, '007', '007', '012335666', '2024-01-01', '10000.00', 'Manager', '007'),
(28, 'muthoki', '32821453', '0795334087', '2024-02-01', '0.00', 'Cashier', 'muthoki');

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

--
-- Table structure for table `employee_salary`
--

CREATE TABLE `employee_salary` (
  `salary_id` int(11) NOT NULL,
  `phone_number` varchar(255) DEFAULT NULL,
  `salary` decimal(10,2) DEFAULT NULL,
  `salary_date` date DEFAULT NULL,
  `method` varchar(255) DEFAULT NULL,
  `purpose` varchar(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `expenses`
--

CREATE TABLE `expenses` (
  `expense_id` int(11) NOT NULL,
  `expense_name` varchar(255) DEFAULT NULL,
  `expense_amount` decimal(10,2) DEFAULT NULL,
  `date_incurred` date DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `expense_type`
--

CREATE TABLE `expense_type` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `food`
--

CREATE TABLE `food` (
  `food_id` int(11) NOT NULL,
  `name` varchar(500) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `cost_price` decimal(10,2) NOT NULL,
  `food_group` varchar(50) NOT NULL,
  `image` varchar(100) DEFAULT NULL,
  `description` varchar(500) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `food`
--

INSERT INTO `food` (`food_id`, `name`, `price`, `cost_price`, `food_group`, `image`, `description`) VALUES
(1, 'pila', '450.00', '0.00', 'Single', NULL, NULL),
(2, 'testing group', '0.00', '0.00', '1', '', 'nice sinllge'),
(3, 'testing group', '0.00', '0.00', '0', '', 'nice sinllge'),
(4, 'testing group', '0.00', '0.00', '0', '', 'nice sinllge'),
(5, 'testing group', '0.00', '0.00', '0', '', 'nice sinllge'),
(6, 'testing group', '0.00', '0.00', '0', '', 'nice sinllge'),
(7, 'testing group', '0.00', '0.00', '0', '../uploads/1014_2_1438681110.webp', 'nice sinllge');

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

--
-- Table structure for table `food_group_items`
--

CREATE TABLE `food_group_items` (
  `id` int(11) NOT NULL,
  `food_id` int(11) NOT NULL,
  `quantity` decimal(10,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `food_group_items`
--

INSERT INTO `food_group_items` (`id`, `food_id`, `quantity`) VALUES
(1, 2, '28.00'),
(2, 2, '21.00'),
(3, 3, '28.00'),
(4, 3, '21.00'),
(5, 5, '28.00'),
(6, 5, '21.00'),
(7, 6, '28.00'),
(8, 6, '21.00'),
(9, 7, '28.00'),
(10, 7, '21.00');

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

--
-- Table structure for table `food_ingredients`
--

CREATE TABLE `food_ingredients` (
  `id` int(11) NOT NULL,
  `ingredient_id` int(11) NOT NULL,
  `quantity_required` decimal(10,2) NOT NULL,
  `food_id` int(11) NOT NULL,
  `cost_price` decimal(10,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `food_ingredients`
--

INSERT INTO `food_ingredients` (`id`, `ingredient_id`, `quantity_required`, `food_id`, `cost_price`) VALUES
(2, 1, '8.00', 5, '0.00'),
(3, 1, '8.00', 6, '0.00'),
(4, 1, '8.00', 7, '0.00');

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

--
-- Table structure for table `food_items`
--

CREATE TABLE `food_items` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `type` enum('Single','Group') NOT NULL,
  `cost_of_production` decimal(10,2) DEFAULT NULL,
  `selling_price` decimal(10,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `ingredients`
--

CREATE TABLE `ingredients` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `quantity` decimal(10,2) NOT NULL,
  `unit` varchar(50) NOT NULL,
  `cost_per_unit` decimal(10,2) NOT NULL,
  `buying_price` decimal(10,2) NOT NULL,
  `subtotal` decimal(10,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `ingredients`
--

INSERT INTO `ingredients` (`id`, `name`, `quantity`, `unit`, `cost_per_unit`, `buying_price`, `subtotal`) VALUES
(1, 'kolin', '10.00', 'grams', '155.00', '0.00', '0.00');

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

--
-- Table structure for table `invoice`
--

CREATE TABLE `invoice` (
  `invo_id` int(11) NOT NULL,
  `invoice_number` varchar(255) NOT NULL,
  `date` date DEFAULT NULL,
  `total` decimal(10,2) DEFAULT NULL,
  `supplier_name` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `issue`
--

CREATE TABLE `issue` (
  `issue_id` int(11) NOT NULL,
  `date` date DEFAULT NULL,
  `receiver_name` varchar(255) DEFAULT NULL,
  `receiver_id` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `issued`
--

CREATE TABLE `issued` (
  `issue_id` int(11) NOT NULL,
  `issued_by` varchar(255) DEFAULT NULL,
  `date_time` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `issued_products`
--

CREATE TABLE `issued_products` (
  `ipid` int(11) NOT NULL,
  `product_name` varchar(255) DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `issue_id` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `issue_items`
--

CREATE TABLE `issue_items` (
  `it_id` int(11) NOT NULL,
  `product_name` varchar(255) DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `issue_id` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `logs`
--

CREATE TABLE `logs` (
  `log_id` int(11) NOT NULL,
  `username` varchar(255) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `logintime` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `logs`
--

INSERT INTO `logs` (`log_id`, `username`, `user_id`, `logintime`) VALUES
(1, '007', NULL, '2024-04-17 18:22:40'),
(2, '007', NULL, '2024-04-17 18:47:33'),
(3, '007', NULL, '2024-04-17 19:54:02'),
(4, '007', NULL, '2024-04-18 05:06:42'),
(5, '007', NULL, '2024-04-18 06:53:42'),
(6, 'Cyrus ', NULL, '2024-04-18 11:46:14'),
(7, '007', NULL, '2024-04-19 09:55:01'),
(8, '007', NULL, '2024-07-05 12:43:10'),
(9, '007', NULL, '2024-07-05 14:40:15');

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

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `order_id` int(11) NOT NULL,
  `phone_number` varchar(255) DEFAULT NULL,
  `seller_name` varchar(255) DEFAULT NULL,
  `total_amount` decimal(10,2) DEFAULT NULL,
  `order_date` date DEFAULT NULL,
  `status` varchar(1) NOT NULL,
  `table_name` varchar(25) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `pay_id` int(11) NOT NULL,
  `payment_method` varchar(255) DEFAULT NULL,
  `trans_id` int(11) DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

CREATE TABLE `products` (
  `product_id` int(11) NOT NULL,
  `product_name` varchar(255) DEFAULT NULL,
  `buying_price` decimal(10,2) DEFAULT NULL,
  `selling_price` decimal(10,2) DEFAULT NULL,
  `company` varchar(255) DEFAULT NULL,
  `shop_quantity` float DEFAULT NULL,
  `store_quantity` int(11) DEFAULT NULL,
  `category` varchar(255) DEFAULT NULL,
  `food_group` varchar(25) DEFAULT NULL,
  `reorder_qty` int(11) NOT NULL DEFAULT 0,
  `image` varchar(100) DEFAULT NULL,
  `description` varchar(300) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `products` (`product_id`, `product_name`, `buying_price`, `selling_price`, `company`, `shop_quantity`, `store_quantity`, `category`, `food_group`, `reorder_qty`, `image`, `description`) VALUES
(1, 'BREAD', '130.00', '480.00', 'naivas', 0, 0, 'Product', 'Breakfast', 0, 'bread.jpg', 'moistened, kneaded, and sometimes fermented.  '),
(193, 'fish fillet', '1245.00', '800.00', 'anglo danish', 0.8, 0, 'Food', NULL, 0, NULL, NULL),
(3, 'SPANISH OMELET', '0.00', '200.00', 'JACY', 100000000000, 0, 'Food', NULL, 0, NULL, NULL),
(4, 'PLAIN OMELET', '0.00', '150.00', 'JACYJOKA', 1000000000000, 0, 'Food', NULL, 0, NULL, NULL),
(5, 'SCRAMBLED EGGS', '0.00', '150.00', 'JACY', 10000000000000, 0, 'Food', NULL, 0, NULL, NULL),
(6, 'FRIED EGG', '0.00', '100.00', 'JACY', 1000000000000, 0, 'Food', NULL, 0, NULL, NULL),
(7, 'PANCAKES', '0.00', '75.00', 'JACY', 10000000000000, 0, 'Food', NULL, 0, NULL, NULL),
(204, 'samosa', '40.00', '75.00', 'JACYJOKA', -10, 0, 'Product', 'Breakfast', 0, 'samosa.jpg', 'a deep fried pastry with a spiced filling usually made with mince meat, spices and herbs'),
(10, 'BACON', '839.00', '1400.00', 'naivas', 1.5, 0, 'Food-Item', 'Breakfast', 0, 'bacon.jpg', ' a type of salt-cured pork'),
(373, 'beef burger', '0.00', '600.00', 'JACYJOKA', 11, 0, 'Product', 'Meat', 0, 'burger.jpg', 'Juicy, big, loaded with toppings of my choice'),
(12, 'SOAP OMO', '186.00', '1300.00', 'naivas', 7, 0, 'Consumable', NULL, 0, NULL, NULL),
(13, 'TOASTED BREAD ', '0.00', '60.00', 'JACY', 10000000000000, 0, 'Food', NULL, 0, NULL, NULL),
(14, 'MIXED TEA', '0.00', '200.00', 'JACY', 10000000000000, 0, 'Food', NULL, 0, NULL, NULL),
(15, 'BLACK TEA', '0.00', '150.00', 'JACY', 1e15, 0, 'Food', NULL, 0, NULL, NULL),
(16, 'BLACK STRONG TEA', '0.00', '250.00', 'JACY', 1e15, 0, 'Food', NULL, 0, NULL, NULL),
(17, 'WHITE COFFEE', '0.00', '250.00', 'JACY', 1000000000000, 0, 'Food', NULL, 0, NULL, NULL),
(18, 'WHITE STRONG COFFEE', '0.00', '350.00', 'JACY', 10000000000000, 0, 'Food', NULL, 0, NULL, NULL),
(19, 'BLACK COFFEE', '0.00', '150.00', 'JACY', 1e17, 0, 'Food', NULL, 0, NULL, NULL),
(20, 'JUICE', '0.00', '150.00', 'JACY', 0, 0, 'Product', 'Drinks', 0, 'juice.jpg', 'flavoring in foods or other beverages, such as smoothies.'),
(21, 'COCKTAILS', '0.00', '250.00', 'JACY', 8, 0, 'Product', 'Drinks', 0, 'cocktail.jpg', ' any cocktail made with fruit juice and other ingredients'),
(22, 'CHIPS', '0.00', '250.00', 'JACY', 2.5e15, 0, 'Food', NULL, 0, NULL, NULL),
(23, 'UGALI', '0.00', '100.00', 'JACY', 1e15, 0, 'Food', NULL, 0, NULL, NULL),
(24, 'ROASTED POTATOES', '0.00', '250.00', 'JACY', 1e16, 0, 'Food', NULL, 0, NULL, NULL),
(25, 'RICE', '0.00', '150.00', 'JACY', 100000000000000, 0, 'Food', NULL, 0, NULL, NULL),
(26, 'GREENS', '0.00', '200.00', 'JACY', 1.1e16, 0, 'Food', NULL, 0, NULL, NULL),
(27, 'MASHED POTATOES', '0.00', '250.00', 'JACY', 1.002e15, 0, 'Food', NULL, 0, NULL, NULL),
(28, 'KACHUMBARI', '0.00', '150.00', 'JACY', 100000000000000, 0, 'Food', NULL, 0, NULL, NULL),
(29, 'BROWN UGALI', '0.00', '200.00', 'JACY', 1e20, 0, 'Food', NULL, 0, NULL, NULL),
(30, 'CHAPATI', '0.00', '160.00', 'JACY', 1.02e18, 0, 'Food', NULL, 0, NULL, NULL),
(262, 'OREGANO', '160.00', '0.00', 'NAIVAS', 2, 0, 'Consumable', NULL, 0, NULL, NULL),
(201, 'eggs', '21.00', '100.00', 'naivas', 19, 0, 'Product', 'Breakfast', 0, 'eggs.png', 'fried  plain eggs'),
(35, 'KIENYEJI', '900.00', '1700.00', 'LAI', 4, 0, 'Product', 'Vegetables', 0, 'kienyeji.jpg', 'greens'),
(377, 'disnf balls', '174.00', '0.00', 'naivas', 1, 0, 'Consumable', NULL, 0, NULL, NULL),
(202, 'beef fillet', '1200.00', '750.00', ' mkomani', 0, 0, 'Product', 'Meat', 0, 'beef fillet.jpeg', 'a very tender steak muscle which comes from the lower middle of the back and forms part of the sirloin'),
(376, 'scouring bright', '127.00', '0.00', 'naivas', 1, 0, 'Consumable', NULL, 0, NULL, NULL),
(40, 'BEEF BURGER', '0.00', '600.00', 'JACY', 0, 0, 'Food', NULL, 0, NULL, NULL),
(328, 'BREAD', '200.00', '0.00', 'NAIVAS', 1, 0, 'Food', NULL, 0, NULL, NULL),
(42, 'CHICKEN BURGER', '115.00', '650.00', 'naivas', 7, 0, 'Food', NULL, 0, NULL, NULL),
(43, 'MINCED MEAT', '1000.00', '0.00', 'naivas', 25, 0, 'Food-Item', 'Meat', 0, 'mince meat.jpg', 'meat that has been cut into very small pieces'),
(44, 'SPAGHETI', '460.00', '0.00', 'naivas', 2, 0, 'Food-Item', 'Lunch', 0, 'spaget.jpg', 'a long, thin, solid, cylindrical pasta'),
(45, 'MUTTON', '800.00', '1200.00', 'MKOMANI', 9.5, 0, 'Product', NULL, 0, NULL, NULL),
(46, 'COFFEE', '820.00', '0.00', 'naivas', 0, 0, 'Food-Item', 'Drinks', 0, 'coffee black.jpeg', 'flavoursome, fragrant and deeply rich in taste'),
(47, 'CHEESE', '980.00', '0.00', 'RATNA', 2, 0, 'Food-Item', NULL, 0, NULL, NULL),
(48, 'BURGER BUNS', '0.00', '0.00', 'JACY', 2, 0, 'Food-Item', 'Breakfast', 0, 'images.jpg', 'soft rolls with a high sugar and fat content'),
(49, 'COOKING OIL', '4879.00', '0.00', 'naivas', 0, 0, 'Consumable', NULL, 0, NULL, NULL),
(50, 'SOY SAUCE', '350.00', '0.00', 'naivas', 1, 0, 'Consumable', NULL, 0, NULL, NULL),
(52, 'RICE', '1750.00', '0.00', 'naivas', 0.5, 0, 'Food', NULL, 0, NULL, NULL),
(53, 'MUSHROOM WHOLE', '450.00', '0.00', 'naivas', 1, 0, 'Food-Item', NULL, 0, NULL, NULL),
(54, 'BANANA', '100.00', '0.00', 'JACYJOKA', 8, 0, 'Food-Item', NULL, 0, NULL, NULL),
(55, 'BACON', '839.00', '350.00', 'naivas', 1, 0, 'Food-Item', NULL, 0, NULL, NULL),
(375, 'plastic pegs', '178.00', '0.00', 'naivas', 2, 0, 'Consumable', NULL, 0, NULL, NULL),
(372, 'balozi', '4255.00', '250.00', 'SHIVA', 1, 0, 'Product', 'Drinks', 0, 'Balozi-Can.png', 'a rich, natural tasting beer made from the finest malted barley with no added sugar.'),
(58, 'WHEAT FLOUR', '189.00', '0.00', 'naivas', 10, 0, 'Food-Item', NULL, 0, NULL, NULL),
(59, 'SUGAR', '210.00', '0.00', 'naivas', 4, 0, 'Food-Item', NULL, 0, NULL, NULL),
(374, 'Sufuria scrubber', '1080.00', '0.00', 'naivas', 8, 0, 'Consumable', NULL, 0, NULL, NULL),
(61, 'BREAD', '130.00', '60.00', 'naivas', -1, 0, 'Product', NULL, 0, NULL, NULL),
(62, 'WATER MELON', '300.00', '0.00', 'KONGOWEA', 0, 0, 'Food', NULL, 0, NULL, NULL),
(261, 'EGGS', '590.00', '100.00', 'NAIVAS', 30, 0, 'Product', 'Breakfast', 0, 'eggs.png', 'produced by a bird, considered as food.'),
(64, 'MAYONNAISE', '480.00', '0.00', 'naivas', 1, 0, 'Food-Item', NULL, 0, NULL, NULL),
(65, 'BEEF SANDWICH', '280.00', '600.00', 'JACYJOKA', 353, 0, 'Food', NULL, 0, NULL, NULL),
(66, 'BEEF BURGER', '299.00', '600.00', 'JACYJOKA', 0, 0, 'Food', NULL, 0, NULL, NULL),
(67, 'CHICK BURGER', '300.00', '650.00', 'JACYJOKA', 0, 0, 'Food', NULL, 0, NULL, NULL),
(68, 'CHICKEN KIENYEJI', '900.00', '1700.00', 'JACYJOKA', 5, 0, 'Product', 'Chicken', 0, 'kienyeji.jpg', 'chicken but much more flavourful'),
(69, '1/2KIENYEJI PLATTER', '450.00', '1000.00', 'JACYJOKA', 1200, 0, 'Food', NULL, 0, NULL, NULL),
(70, 'KIENYEJI PLATTER FULL', '900.00', '2000.00', 'JACYJOKA', 0, 0, 'Food', NULL, 0, NULL, NULL),
(71, 'BROILER 1/2 PLATTER', '400.00', '900.00', 'JACYJOKA', 148, 0, 'Food', NULL, 0, NULL, NULL),
(72, 'BROILERPLATTER FULL', '800.00', '1700.00', 'JACYJOKA', 0, 0, 'Food', NULL, 0, NULL, NULL),
(73, 'GOAT PLATTER 1KG', '700.00', '1600.00', 'JACYJOKA', 0, 0, 'Food', NULL, 0, NULL, NULL),
(74, 'GOAT CHOMA 1KG', '850.00', '1500.00', 'JACY', 106, 0, 'Food', NULL, 0, NULL, NULL),
(75, 'PEPPER STEAK', '300.00', '850.00', 'JACYJOKA', 0, 0, 'Food', NULL, 0, NULL, NULL),
(76, 'WAGON STEAK', '300.00', '850.00', 'JACYJOKA', 0, 0, 'Food', NULL, 0, NULL, NULL),
(77, 'CORNA ASDA STEAK', '300.00', '850.00', 'JACYJOKA', 0, 0, 'Food', NULL, 0, NULL, NULL),
(78, 'Cape town Steak', '300.00', '850.00', 'JACYJOKA', 0, 0, 'Food', NULL, 0, NULL, NULL),
(79, 'GINGER MARINATED STEAK', '300.00', '850.00', 'JACYJOKA', 0, 0, 'Food', NULL, 0, NULL, NULL),
(80, 'BEEF WET FRY', '300.00', '700.00', 'JACYJOKA', 0, 0, 'Food', NULL, 0, NULL, NULL),
(81, 'BEEF DRY FRY', '300.00', '700.00', 'JACYJOKA', 0, 0, 'Food', NULL, 0, NULL, NULL),
(82, 'CHICKEN PILAU', '350.00', '650.00', 'JACYJOKA', 120, 0, 'Food', NULL, 0, NULL, NULL),
(83, 'BEEF PILAU', '350.00', '600.00', 'JACYJOKA', 117, 0, 'Food', NULL, 0, NULL, NULL),
(84, 'PORK CHOPS 1/2', '400.00', '850.00', 'JACYJOKA', 9996, 0, 'Food', NULL, 0, NULL, NULL),
(85, 'SPAGHETTI NAPOLITANO', '200.00', '450.00', 'JACYJOKA', 0, 0, 'Food', NULL, 0, NULL, NULL),
(86, 'SPAGHETTI BOLOGNAIS', '222.00', '750.00', 'JACYJOKA', 0, 0, 'Food', NULL, 0, NULL, NULL),
(87, 'SPAGHETTI AGIO OLIO', '320.00', '450.00', 'JACYJOKA', 0, 0, 'Food', NULL, 0, NULL, NULL),
(88, 'SPAGHETTI MUSHROOM', '320.00', '600.00', 'JACYJOKA', 0, 0, 'Food', NULL, 0, NULL, NULL),
(89, 'SPAGHETTI CARBONARA', '300.00', '800.00', 'JACYJOKA', 0, 0, 'Food', NULL, 0, NULL, NULL),
(90, 'AMATIRICANA', '350.00', '750.00', 'JACYJOKA', 0, 0, 'Food', NULL, 0, NULL, NULL),
(91, 'ARABIATA', '340.00', '550.00', 'JACYJOKA', 0, 0, 'Food', NULL, 0, NULL, NULL),
(92, 'PENNE ALAVEDURE', '300.00', '550.00', 'JACYJOKA', 0, 0, 'Food', NULL, 0, NULL, NULL),
(93, 'PENNE RAQUE', '340.00', '750.00', 'JACYJOKA', 0, 0, 'Food', NULL, 0, NULL, NULL),
(94, 'MIXED GREEN SALAD', '0.00', '400.00', 'JACYJOKA', 0, 0, 'Food', NULL, 0, NULL, NULL),
(95, 'COLESLAW SALAD', '0.00', '200.00', 'JACYJOKA', 0, 0, 'Food', NULL, 0, NULL, NULL),
(96, 'KACHUMBARI', '0.00', '150.00', 'JACYJOKA', 0, 0, 'Food', NULL, 0, NULL, NULL),
(97, 'TOMATO SOUP', '0.00', '250.00', 'JACYJOKA', 19996, 0, 'Food', NULL, 0, NULL, NULL),
(98, 'VEG SOUP', '0.00', '350.00', 'JACYJOKA', 0, 0, 'Food', NULL, 0, NULL, NULL),
(99, 'SPINACH SOUP', '0.00', '350.00', 'JACYJOKA', 100, 0, 'Food', NULL, 0, NULL, NULL),
(100, 'POTATOES SOUP', '0.00', '400.00', 'JACYJOKA', 0, 0, 'Food', NULL, 0, NULL, NULL),
(101, 'MAGARITA PIZZA', '0.00', '900.00', 'JACYJOKA', 120, 0, 'Food', NULL, 0, NULL, NULL),
(102, 'VEG PIZZA', '0.00', '900.00', 'JACYJOKA', 123, 0, 'Food', NULL, 0, NULL, NULL),
(103, 'VEG PIZZA', '0.00', '900.00', 'JACYJOKA', 123, 0, 'Food', NULL, 0, NULL, NULL),
(104, 'BACON PIZZA', '0.00', '1000.00', 'JACYJOKA', 121, 0, 'Food', NULL, 0, NULL, NULL),
(105, 'CHICKEN  PIZZA', '0.00', '1200.00', 'JACYJOKA', 122, 0, 'Food', NULL, 0, NULL, NULL),
(106, 'JACYJOKA PIZZA', '0.00', '1500.00', 'JACYJOKA', 1188, 0, 'Food', NULL, 0, NULL, NULL),
(107, 'HAWAIIAN PIZZA', '0.00', '1200.00', 'JACYJOKA', 99, 0, 'Food', NULL, 0, NULL, NULL),
(108, 'RED SNAPPER FILLET', '300.00', '800.00', 'JACYJOKA', 0, 0, 'Food', NULL, 0, NULL, NULL),
(109, 'FISH CHILLY', '300.00', '800.00', 'JACYJOKA', 0, 0, 'Food', NULL, 0, NULL, NULL),
(110, 'DEEP FRY  WHOLE FISH', '0.00', '750.00', 'JACYJOKA', 0, 0, 'Food', NULL, 0, NULL, NULL),
(111, 'Tusker Malt', '170.00', '250.00', 'SHIVA', 8, 0, 'Product', 'Drinks', 0, 'Tusker-Malt-Beer.jpg', 'finest Malt matured for twice as long as ordinary beer'),
(112, 'Tusker Lite', '190.00', '250.00', 'SHIVA', 9, 0, 'Product', 'Drinks', 0, 'tusker lite.jpg', ' a distinctively brewed low-calorie beer with a white head that offers a lighter body and reduced alcohol content'),
(113, 'GK', '4880.00', '300.00', 'SHIVA', -2, 0, 'Product', 'Drinks', 0, 'guinness-f-3.jpg', 'Famous for being dark, creamy, and foamy'),
(114, 'Smirnoff ice', '170.00', '250.00', 'SHIVA', 1, 0, 'Product', 'Drinks', 0, 'smirnoff ice guarana.jpg', 'a pre-mixed alcoholic drink that is stylish, trendy drink'),
(115, 'Smirnoff Guarana', '170.00', '250.00', 'SHIVA', 4, 0, 'Product', 'Drinks', 0, 'smirnoff ice guarana.jpg', 'a strong 5.5% blend of Smirnoff Vodka with a citrus mixer and a hit of Guarana for that extra boost.'),
(116, 'Snapp', '126.00', '250.00', 'SHIVA', 9, 0, 'Product', 'Drinks', 0, 'Snapp.jpg', 'a naturally refreshing, fruit flavoured alcoholic drink for the modern, sophisticated and classy woman.'),
(117, 'Heiniken', '4880.00', '300.00', 'S Liqour', -1, 0, 'Product', 'Drinks', 0, 'heineken-can-500ml.jpg', 'a lager style of beer so it is heavier than other types with a stronger taste to it'),
(209, '1/2 kienyeji', '350.00', '850.00', 'jacyjoka', 3, 0, 'Product', 'Chicken', 0, 'kienyeji.jpg', 'more flavoured local chicken'),
(119, 'Tusker Cider', '191.00', '280.00', 'SHIVA', 13, 0, 'Product', 'Drinks', 0, 'cider.jpg', 'the finest malted barley with no added sugar'),
(120, 'Smirnoff vodka 250 ml', '400.00', '600.00', 'SHIVA', 8, 0, 'Product', 'Drinks', 0, 'smirnoff vodka.png', 'triple distilled from only the finest grains'),
(121, 'Smirnoff vodka 750 ml', '1300.00', '3000.00', 'SHIVA', 0, 0, 'Product', 'Drinks', 0, 'smirnoff vodka.png', 'triple distilled from only the finest grains'),
(122, 'Smirnoff vodka 1L', '1700.00', '3500.00', 'SHIVA', 1, 0, 'Product', 'Drinks', 0, 'smirnoff vodka.png', 'triple distilled from only the finest grains'),
(123, 'Gin 250ml', '363.00', '600.00', 'SHIVA', 1, 0, 'Product', 'Drinks', 0, 'Gilbeys Gin.jpg', 'a classic juniper-led London Dry Gin.'),
(124, 'Gin 350ml', '480.00', '1000.00', 'SHIVA', 3, 0, 'Product', 'Drinks', 0, 'Gilbeys Gin.jpg', 'a classic juniper-led London Dry Gin.'),
(125, 'Gin 750ml', '1088.00', '3000.00', 'SHIVA', 3, 0, 'Product', 'Drinks', 0, 'Gilbeys Gin.jpg', 'a classic juniper-led London Dry Gin.'),
(127, 'Safari cocktail Rum', '650.00', '1500.00', 'SHIVA', 2, 0, 'Product', 'Drinks', 0, 'Safari cocktail  rum.jpg', ' subtle citrus notes balanced with sweet and tart cranberry flavours with fruity undertones'),
(128, 'VAT 69', '2199.00', '3200.00', 'SHIVA', 0, 0, 'Product', 'Drinks', 0, 'vat 69.jpg', 'this is a smooth, balanced spirit and a perennial favourite.'),
(129, 'Redbull', '216.00', '250.00', 'SHIVA', 4, 0, 'Product', 'Drinks', 0, 'redbull.png', 'a utility drink to be taken against mental or physical weariness or exhaustion.'),
(131, 'Jack Daniel 1L', '4000.00', '6000.00', 'S Liqour', 0, 0, 'Product', 'Drinks', 0, 'jack daniels.png', 'Nose Light with plenty of sweetness.'),
(132, 'Jack Daniel 700ML', '3200.00', '4500.00', 'S Liqour ', 0, 0, 'Product', 'Drinks', 0, 'jack daniels.png', 'Nose Light with plenty of sweetness.'),
(133, 'Jack Daniel honey 700ml', '3795.00', '7000.00', 'S Liqour', 0, 0, 'Product', 'Drinks', 0, 'jack daniels honey.jpg', 'A Mix Of Regular Old No 7 And A Spiced Honey Liqueur'),
(134, 'Johny walker black 1L', '4300.00', '6000.00', 'S Liqour', 1, 0, 'Product', 'Drinks', 0, 'johnny walker black label.jpg', 'a rich, smooth blended Scotch Whisky made using only single malt and grain whiskies.'),
(135, 'Johny walker black 750ML', '3700.00', '5500.00', 'S Liqour', 2, 0, 'Product', 'Drinks', 0, 'johnny walker black label.jpg', 'a rich, smooth blended Scotch Whisky made using only single malt and grain whiskies.'),
(136, 'Johny walker DB 1L', '5951.00', '10000.00', 'S Liqour ', 0, 0, 'Product', 'Drinks', 0, 'johnny walker db.jpeg', 'rebellious younger sibling of Johnnie Walker Black Label with a deep, brooding intensity'),
(137, 'Johny walker red 1L', '2650.00', '6000.00', 'S Liqour', 0, 0, 'Product', 'Drinks', 0, 'johnnie-walker-red-labe.jpg', 'the world\'s best-selling Blended Scotch Whisky'),
(138, 'Johny walker red 750ml', '2500.00', '4500.00', 'S Liqour ', 0, 0, 'Product', 'Drinks', 0, 'johnnie-walker-red-labe.jpg', 'the world\'s best-selling Blended Scotch Whisky'),
(139, 'Jameson 1L', '2850.00', '5000.00', 'S Liqour', 2, 0, 'Product', 'Drinks', 0, 'jameson.jpg', 'a blended Irish Whiskey'),
(140, 'Jameson 750ml', '2400.00', '3500.00', 'S Liqour ', 2, 0, 'Product', 'Drinks', 0, 'jameson.jpg', 'a blended Irish Whiskey'),
(141, 'Famous Grouse 1L', '2950.00', '4000.00', 'S Liqour', 0, 0, 'Product', 'Drinks', 0, 'famous grouse.jpg', 'scotch whisky against which the discerning drinker judges all others'),
(142, 'Famous Grouse 750ml', '2350.00', '3000.00', 'S Liqour ', 0, 0, 'Product', NULL, 0, NULL, NULL),
(143, 'Southern Comfort 1L', '3200.00', '4000.00', 'S Liqour', 2, 0, 'Product', 'Drinks', 0, 'Southern-Comfort.jpeg', 'American, naturally fruit-flavored, whiskey liqueur with fruit and spice accents.'),
(144, 'Southern Comfort 750ml', '2800.00', '3500.00', 'S Liqour ', 0, 0, 'Product', 'Drinks', 0, 'Southern-Comfort.jpeg', 'American, naturally fruit-flavored, whiskey liqueur with fruit and spice accents'),
(145, 'Captain Morgan 750ml', '1250.00', '3000.00', 'S Liqour', 0, 0, 'Product', 'Drinks', 0, 'captain morgan.jpeg', 'You\'ll taste notes of rich vanilla, brown sugar, warming spices with just the hint of oak'),
(146, 'Cellar Red 750ML', '1200.00', '1800.00', 'S Liqour ', 1, 0, 'Product', 'Drinks', 0, 'CELLAR-JB-RED-750ML.jpg', 'has notes of fresh berries with subtle spicy nuances'),
(147, 'Cellar White 750mL', '1200.00', '1800.00', 'S Liqour', 0, 0, 'Product', 'Drinks', 0, 'cellar-cask-white.png', 'an aromatic wine that pours a bright yellow straw colour with glints of green.'),
(148, 'Orange Rivers White', '1200.00', '1800.00', 'S Liqour ', 1, 0, 'Product', 'Drinks', 0, 'Orange River Cellars Dry White.jpg', 'The wine has a deep golden hue, and a taste that has intense ripe fruit blossoms and dried figs.'),
(149, 'Four Cousin red 750ML', '1200.00', '1800.00', 'S Liqour', 0, 0, 'Product', 'Drinks', 0, 'four cousins red.jpg', 'a fragrant, ruby-red wine with soft rose petal perfume'),
(150, 'Four Cousin white 750ML', '1200.00', '1800.00', 'S Liqour ', 1, 0, 'Product', 'Drinks', 0, 'four cousins white.png', 'fragrant & sunshine-coloured, with a gentle honey perfume.'),
(151, '4th Street red 750 ml', '1200.00', '1800.00', 'S Liqour', 1, 0, 'Product', 'Drinks', 0, '4th street red wine.png', 'offers a deep ruby colour and ripe, black cherryscented aromas.'),
(152, '4th Street white 750 ml', '1200.00', '1800.00', 'S Liqour ', 1, 0, 'Product', 'Drinks', 0, '4th sreet white wine.jpg', 'offers a deep ruby colour and ripe, black cherryscented aromas'),
(153, 'Gato negro red 750 ML', '1400.00', '3000.00', 'S Liqour', 2, 0, 'Product', 'Drinks', 0, 'gato_red_blend.png', 'a dark ruby-red color with a very intense aroma, full of red fruit aromas such as berries, cherries, and cassis, that meld perfectly with vanilla and chocolate notes.'),
(154, 'Gato negro White 750 ML', '1400.00', '1800.00', 'S Liqour ', 2, 0, 'Product', 'Drinks', 0, 'gato negroo white.jpg', 'it offers plenty of bright grape and cherry fruit with an intriguing smoky flavour.'),
(155, 'Gato negro sweet 750 ML', '1400.00', '1800.00', 'S Liqour', 2, 0, 'Product', 'Drinks', 0, 'gato negro sweet wine.png', 'soft in taste and with a pleasant acidity, which is set off perfectly with sweet notes of peach and apricot.'),
(156, 'Drosty dy hof red', '1200.00', '1800.00', 'S Liqour ', 2, 0, 'Product', 'Drinks', 0, 'drosty hof red.jpg', ' ruby red appearing medium bodied red wine. '),
(157, 'Drosty dy hof white', '1200.00', '1800.00', 'S Liqour', 3, 0, 'Product', 'Drinks', 0, 'drostdy-hof-white.jpg', ' a young, fresh, dry white wine, ideal for everyday enjoyment.'),
(158, 'Saint Celine', '1000.00', '1800.00', 'S Liqour ', 0, 0, 'Product', 'Drinks', 0, 'saint celine.jpg', ' a ravishing ruby colour with delicious sweet ripe black currant raspberry jam and clove spice'),
(159, 'Amarulla 1L', '3000.00', '4500.00', 'S Liqour', 2, 0, 'Product', 'Drinks', 0, 'amarulla.jpg', 'a cream liqueur from South Africa'),
(160, 'Amarulla 750ML', '2850.00', '3500.00', 'S Liqour ', 1, 0, 'Product', 'Drinks', 0, 'amarulla.jpg', 'a cream liqueur from South Africa'),
(161, 'Baileys cream 750ML', '2995.00', '3500.00', 'S Liqour ', 2, 0, 'Product', 'Drinks', 0, 'baileys.jpg', 'the sweetest meeting of fine Irish whiskey and spirits, Irish dairy cream, and rich chocolate and vanilla flavors. '),
(162, 'Dunhill cigarettes', '380.00', '400.00', 'S Liqour ', 13, 0, 'Product', 'Drinks', 0, 'dunill.jpg', 'Premium, additive-free luxury king size cigarettes known all around the world for their smooth flavour. '),
(163, 'Embassy cigarettes ', '380.00', '400.00', 'S Liqour', 12, 0, 'Product', 'Drinks', 0, 'Embassy-No1-20s-3D-Modem.jpg', 'a popular British brand of cigarettes, currently owned and manufactured by Imperial Tobacco.'),
(164, 'Water 1L', '38.00', '120.00', 'Aquamist water LTD', 0, 0, 'Product', 'Drinks', 0, 'water.png', 'It consists of three atoms : two of hydrogen and one of oxygen. '),
(165, 'Water 500ML', '24.00', '80.00', 'Aquamist water LTD', 80, 0, 'Product', 'Drinks', 0, 'water.png', 'It consists of three atoms : two of hydrogen and one of oxygen. '),
(167, 'Balentine whisky1L', '2300.00', '4000.00', 'S Liqour', 2, 0, 'Product', 'Drinks', 0, 'balentine.jpg', 'blended with 50 single malts and four single grains.'),
(168, 'Chardoney white wine', '1800.00', '3000.00', 'S Liqour ', 0, 0, 'Product', 'Drinks', 0, 'chardoney white.jpg', 'a dry, medium- to full-bodied wine with moderate acidity and alcohol.'),
(169, 'Bacardi Rum', '2600.00', '4000.00', 'S Liqour', 0, 0, 'Product', 'Drinks', 0, 'bacardi rum.jpg', 'A Dark And Intense Rum That Captures The Bold Flavors Of Oak, Orange Peel And Sweet Molasses'),
(170, 'Tequila Camino', '2900.00', '6000.00', 'S Liqour ', 0, 0, 'Product', 'Drinks', 0, 'tequila camino.png', 'a soft, light-tasting tequila made from a special kind of blue agave. '),
(171, 'William Lawson 750ML', '1350.00', '3000.00', 'S Liqour', 2, 0, 'Product', 'Drinks', 0, 'WILLIAM LAWSONS.jpg', 'sweet and medium-bodied in style, with a high malt content. '),
(172, 'Black and White 750ML', '1400.00', '3000.00', 'S Liqour ', 1, 0, 'Product', 'Drinks', 0, 'black_white.jpg', 'smooth, light, fresh and spicy with smoky hints.'),
(173, 'Three Barrels whisky 750ML', '2400.00', '3500.00', 'S Liqour ', 1, 0, 'Product', 'Drinks', 0, 'three barriers.jpg', 'a superior smooth, velvety style full of almond and walnut notes over candied fruit flavours and warming hints of ginger.'),
(174, 'Delmontee juice 500ML', '230.00', '350.00', 'S Liqour', -1, 0, 'Product', 'Drinks', 0, 'delmonte.jpg', 'a tantalizing fusion that strikes the perfect balance between sweetness and tanginess'),
(175, 'Captain Morgan Dark rum 750ml', '2450.00', '3500.00', 'S Liqour ', 0, 0, 'Product', 'Drinks', 0, 'captain morgan dar.jpg', 'made with a secret blend of fine Caribbean rums and exotic spices to make our darkest flavour rum.'),
(176, 'Foot Print red Dry ', '1459.00', '3000.00', 'S Liqour', 0, 0, 'Product', 'Drinks', 0, 'footprint-pinotage-rose red.jpg', 'deep red appearance with crimson tints.'),
(177, 'Foot Print white Dry', '1459.00', '3000.00', 'S Liqour ', 0, 0, 'Product', NULL, 0, NULL, NULL),
(178, 'Goat wet /dry fry', '300.00', '600.00', 'JACYJOKA', 118, 0, 'Food', NULL, 0, NULL, NULL),
(179, '1kg goat wet/dry fry', '700.00', '1200.00', 'JACYJOKA', 122, 0, 'Food', NULL, 0, NULL, NULL),
(180, 'Coffe', '820.00', '0.00', 'naivas', 1, 0, 'Food-Item', NULL, 0, NULL, NULL),
(181, 'john walker tots', '3500.00', '300.00', 'JACYJOKA', 30, 0, 'Product', 'Drinks', 0, 'johnny walker black label.jpg', 'a Scotch whisky classified as Blended scotch whisky.'),
(182, 'Gilbeys tots', '1300.00', '250.00', 'JACYJOKA', 16, 0, 'Product', 'Drinks', 0, 'Gilbeys Gin.jpg', 'A Smooth,Dry Refreshing Gin. '),
(183, 'Black label', '4000.00', '300.00', 'JACYJOKA', 16, 0, 'Product', 'Drinks', 0, 'johnny walker black label.jpg', 'A masterful blend of single malt and grain whiskies from across Scotland, aged for at least 12 years. '),
(185, 'Cellar red glasses', '910.00', '300.00', 'JACYJOKA', 3, 0, 'Product', 'Drinks', 0, 'CELLAR-JB-RED-750ML.jpg', ' a deep ruby colour and ripe, black cherryscented aromas'),
(186, 'Red label tots', '3800.00', '300.00', 'JACYJOKA', 26, 0, 'Product', 'Drinks', 0, 'johnnie-walker-red-labe.jpg', 'the world\'s best-selling Blended Scotch Whisky.'),
(187, 'Foot print glasses', '820.00', '300.00', 'JACYJOKA', 4, 0, 'Product', NULL, 0, NULL, NULL),
(188, 'Four cousin white glass', '820.00', '300.00', 'JACYJOKA', 0, 0, 'Product', 'Drinks', 0, 'white glass.jpg', ' a glass of Four cousin white'),
(189, '4th Street white glass', '820.00', '300.00', 'JACYJOKA', 0, 0, 'Product', 'Drinks', 0, 'white glass.jpg', 'a glass of 4th Street white'),
(190, '4th Street red glass', '820.00', '300.00', 'JACYJOKA', 0, 0, 'Product', 'Drinks', 0, 'red glass.jpg', 'a glass of 4th Street red'),
(191, 'Four cousins red glass', '820.00', '300.00', 'JACYJOKA', 3, 0, 'Product', 'Drinks', 0, 'red glass.jpg', 'a glass of Four cousins red'),
(192, 'Soda 300ml', '35.00', '100.00', 'Rahisi store', -1, 0, 'Product', 'Drinks', 0, 'soda.jpg', 'a class of nonalcoholic beverage '),
(323, 'pork', '800.00', '1800.00', 'Whitefield farm ltd', 6, 0, 'Product', 'Meat', 0, 'pork.jpg', 'firm and fine-grained, well-marbled'),
(194, 'omo', '1300.00', '0.00', 'naivas', 1, 0, 'Consumable', NULL, 0, NULL, NULL),
(195, 'steple pins', '290.00', '0.00', 'naivas', 1, 0, 'Consumable', NULL, 0, NULL, NULL),
(196, 'counter book', '135.00', '0.00', 'naivas', 1, 0, 'Consumable', NULL, 0, NULL, NULL),
(326, 'spinach', '180.00', '0.00', 'NAIVAS', 4, 0, 'Food-Item', NULL, 0, NULL, NULL),
(198, 'spanish omelet B', '50.00', '100.00', 'JACYJOKA', 999950, 0, 'Food', NULL, 0, NULL, NULL),
(199, 'POTATOE WAGES', '50.00', '100.00', 'JACYJOKA', 9964, 0, 'Food', NULL, 0, NULL, NULL),
(200, 'PLAIN OMELET B', '30.00', '100.00', 'JACYJOKA', 10000, 0, 'Food', NULL, 0, NULL, NULL),
(339, 'Balozi', '4225.00', '250.00', 'SHIVA', 0, 0, 'Product', 'Drinks', 0, 'Balozi-Can.png', 'finest malted barley with no added sugar'),
(210, 'test', '0.00', '1.00', 'JACY', 9, 0, 'Food', NULL, 0, NULL, NULL),
(211, 'Spaghetti Napolitano', '230.00', '450.00', 'Jacyjoka', 16, 0, 'Food', NULL, 0, NULL, NULL),
(212, 'Spaghetti Bolognais', '230.00', '750.00', 'Jacyjoka', 16, 0, 'Food', NULL, 0, NULL, NULL),
(213, 'Spaghetti Mashroom', '230.00', '600.00', 'Jacyjoka', 20, 0, 'Food', NULL, 0, NULL, NULL),
(214, 'Spaghetti Agio Olio', '230.00', '450.00', 'Jacyjoka', 20, 0, 'Food', NULL, 0, NULL, NULL),
(215, 'Spaghetti Cabonara', '230.00', '800.00', 'Jacyjoka', 18, 0, 'Food', NULL, 0, NULL, NULL),
(216, 'Amatiricana', '230.00', '750.00', 'Jacyjoka', 20, 0, 'Food', NULL, 0, NULL, NULL),
(217, 'Arabiata', '230.00', '550.00', 'Jacyjoka', 19, 0, 'Food', NULL, 0, NULL, NULL),
(218, 'Penne Alavedure', '230.00', '550.00', 'Jacyjoka', 19, 0, 'Food', NULL, 0, NULL, NULL),
(219, 'Penne Raque', '230.00', '750.00', 'Jacyjoka', 20, 0, 'Food', NULL, 0, NULL, NULL),
(220, 'Chicken Sandwich', '350.00', '700.00', 'Jacyjoka', 14, 0, 'Food', NULL, 0, NULL, NULL),
(221, 'Mixed Green Salad', '200.00', '400.00', 'Jacyjoka', 19, 0, 'Food', NULL, 0, NULL, NULL),
(222, 'vegetable soup', '200.00', '350.00', 'Jacyjoka', 20, 0, 'Food', NULL, 0, NULL, NULL),
(223, 'Potatoe soup', '200.00', '400.00', 'Jacyjoka', 20, 0, 'Food', NULL, 0, NULL, NULL),
(224, 'Beef wet fry', '350.00', '700.00', 'Jacyjoka', 16, 0, 'Food', NULL, 0, NULL, NULL),
(225, 'Pepper Steak', '400.00', '850.00', 'Jacyjoka', 16, 0, 'Food', NULL, 0, NULL, NULL),
(226, 'Wagon  Steak', '400.00', '850.00', 'Jacyjoka', 20, 0, 'Food', NULL, 0, NULL, NULL),
(227, 'Corn Asada Steak', '400.00', '850.00', 'Jacyjoka', 20, 0, 'Food', NULL, 0, NULL, NULL),
(228, 'Cape town Steak', '400.00', '850.00', 'Jacyjoka', 19, 0, 'Food', NULL, 0, NULL, NULL),
(229, 'Ginger marinated Steak', '400.00', '850.00', 'Jacyjoka', 20, 0, 'Food', NULL, 0, NULL, NULL),
(230, 'Beef Pilau', '350.00', '650.00', 'Jacyjoka', 29, 0, 'Food', NULL, 0, NULL, NULL),
(231, 'Chicken Pilau', '350.00', '650.00', 'Jacyjoka', 30, 0, 'Food', NULL, 0, NULL, NULL),
(232, 'Pork Chops 1/2 kg', '350.00', '850.00', 'Jacyjoka', 39, 0, 'Food', NULL, 0, NULL, NULL),
(233, 'Pork Chops 1 kg', '900.00', '1800.00', 'Jacyjoka', 40, 0, 'Food', NULL, 0, NULL, NULL),
(234, 'Goat 1/2 kg', '400.00', '600.00', 'Jacyjoka', 27, 0, 'Food', NULL, 0, NULL, NULL),
(235, 'Chicken Broiler 1/2 kg', '350.00', '750.00', 'Jacyjoka', 25, 0, 'Food', NULL, 0, NULL, NULL),
(236, 'Chicken Broiler 1kg', '450.00', '1500.00', 'Jacyjoka', 46, 0, 'Food', NULL, 0, NULL, NULL),
(237, 'Chicken Kienyeji 1/2 kg', '450.00', '850.00', 'Jacyjoka', 47, 0, 'Food', NULL, 0, NULL, NULL),
(238, 'Chicken Kienyeji 1 kg', '900.00', '1700.00', 'Jacyjoka', 50, 0, 'Food', NULL, 0, NULL, NULL),
(239, 'Chicken Kienyeji 1 kg plater', '1000.00', '2000.00', 'Jacyjoka', 50, 0, 'Food', NULL, 0, NULL, NULL),
(240, 'Chicken Kienyeji 1/2 kg plater', '500.00', '1200.00', 'Jacyjoka', 50, 0, 'Food', NULL, 0, NULL, NULL),
(241, 'Chicken Broiler 1kg plater', '550.00', '1700.00', 'Jacyjoka', 49, 0, 'Food', NULL, 0, NULL, NULL),
(242, 'Chicken Broiler 1/2kg plater', '500.00', '900.00', 'Jacyjoka', 45, 0, 'Food', NULL, 0, NULL, NULL),
(243, 'Fresh Juice', '70.00', '150.00', 'Jacyjoka', 20, 0, 'Product', 'Drinks', 0, 'juice.jpg', 'unfermented product obtained from the edible part of fruit which is sound, ripe and fresh'),
(244, 'Whole fish deep fry', '250.00', '750.00', 'Jacyjoka', 48, 0, 'Food', NULL, 0, NULL, NULL),
(245, 'Fish fillet', '450.00', '800.00', 'Jacyjoka', 27, 0, 'Food', NULL, 0, NULL, NULL),
(340, 'Pilsner', '4425.00', '250.00', 'SHIVA', 22, 0, 'Product', 'Drinks', 0, 'plisner.jpg', 'a pale lager with a crisp, refreshing taste'),
(247, 'CHAPATI', '180.00', '80.00', 'jacyjoka', 18, 0, 'Product', 'Lunch', 0, 'chapati.jpg', ' a round flat unleavened bread'),
(248, 'BACON', '839.00', '350.00', 'NAIVAS', 9, 0, 'Food', NULL, 0, NULL, NULL),
(249, 'COSLAW SALAD', '130.00', '200.00', 'jacyjoka', 45, 0, 'Food', NULL, 0, NULL, NULL),
(250, 'Fruit salad', '120.00', '300.00', 'Jacyjoka', 20, 0, 'Food', NULL, 0, NULL, NULL),
(251, 'Dawa concotion', '120.00', '250.00', 'Jacyjoka', 16, 0, 'Food', NULL, 0, NULL, NULL),
(252, 'Drinking Choclate', '250.00', '120.00', 'Jacyjoka', 15, 0, 'Food', NULL, 0, NULL, NULL),
(253, 'Beef Stew ', '250.00', '700.00', 'Jacyjoka', 16, 0, 'Food', NULL, 0, NULL, NULL),
(254, 'Baileys cream 1L', '3000.00', '5000.00', 'Jacyjoka', 2, 0, 'Product', 'Drinks', 0, 'baileys.jpg', 'Irish dairy cream, and rich chocolate and vanilla flavors.'),
(255, 'Tequila Camino 750ML SHOTS', '2900.00', '200.00', 'Jacyjoka', 18, 0, 'Product', 'Drinks', 0, 'tequila camino.png', ' is a soft, light-tasting'),
(256, 'Johny walker black 750ML shots', '3700.00', '250.00', 'Jacyjoka', 22, 0, 'Product', 'Drinks', 0, 'johnny walker black label.jpg', 'complex and well-balanced flavor profile'),
(257, 'Johny walker black 750ML shots', '3700.00', '300.00', 'Jacyjoka', 16, 0, 'Product', NULL, 0, NULL, NULL),
(263, 'CARDAMONS', '450.00', '0.00', 'NAIVAS', 1, 0, 'Consumable', NULL, 0, NULL, NULL),
(264, 'PILAU MASALA', '355.00', '0.00', 'NAIVAS', 1, 0, 'Consumable', NULL, 0, NULL, NULL),
(265, 'RICE', '1863.00', '150.00', 'NAIVAS', 4, 0, 'Food', NULL, 0, NULL, NULL),
(266, 'JIK', '1900.00', '0.00', 'NAIVAS', 5, 0, 'Consumable', NULL, 0, NULL, NULL),
(267, 'COUNTER BOOK', '325.00', '0.00', 'NAIVAS', 1, 0, 'Consumable', NULL, 0, NULL, NULL),
(268, 'SUGAR', '420.00', '0.00', 'NAIVAS', 2, 0, 'Consumable', NULL, 0, NULL, NULL),
(269, 'WHITE BREAD', '119.00', '60.00', 'NAIVAS', 6, 0, 'Product', 'Breakfast', 0, 'bread.jpg', 'baked food product made of flour '),
(270, 'MINCED MEAT', '1999.00', '0.00', 'NAIVAS', 2, 0, 'Food', NULL, 0, NULL, NULL),
(271, 'TOMATO SAUCE', '450.00', '0.00', 'NAIVAS', 5, 0, 'Consumable', NULL, 0, NULL, NULL),
(272, 'BAG', '55.00', '0.00', 'NAIVAS', 1, 0, 'Consumable', NULL, 0, NULL, NULL),
(341, 'Toilett tissues', '6870.00', '0.00', 'Chandaria industries', 240, 0, 'Consumable', NULL, 0, NULL, NULL),
(274, 'HONEY', '470.00', '0.00', 'NAIVAS', 1, 0, 'Consumable', NULL, 0, NULL, NULL),
(275, 'ONION', '1600.00', '0.00', 'localmarket', 1, 0, 'Food-Item', NULL, 0, NULL, NULL),
(276, 'BANANA', '200.00', '0.00', 'localmarket', 20, 0, 'Food', NULL, 0, NULL, NULL),
(277, 'GINGER', '300.00', '0.00', 'localmarket', 2, 0, 'Consumable', NULL, 0, NULL, NULL),
(278, 'HOHO', '360.00', '0.00', 'localmarket', 2, 0, 'Consumable', NULL, 0, NULL, NULL),
(279, 'PHOTO COPY PAPERS', '899.00', '0.00', 'NAIVAS', 1, 0, 'Consumable', NULL, 0, NULL, NULL),
(280, 'PUNNET+LID', '1815.00', '0.00', 'NAIVAS', 80, 0, 'Consumable', NULL, 0, NULL, NULL),
(282, 'PPR PIPE1/2', '180.00', '0.00', 'FLEX TIME', 1, 0, 'Consumable', NULL, 0, NULL, NULL),
(283, 'PPR PIPE 3/4', '270.00', '0.00', 'FLEX TIME', 1, 0, 'Consumable', NULL, 0, NULL, NULL),
(284, 'ELBOW 3/4', '225.00', '0.00', 'FLEX TIME', 10, 0, 'Consumable', NULL, 0, NULL, NULL),
(285, 'SOCKET 3/4', '160.00', '0.00', 'FLEX TIME', 8, 0, 'Consumable', NULL, 0, NULL, NULL),
(286, 'R/SOCKET', '90.00', '0.00', 'FLEX TIME', 3, 0, 'Consumable', NULL, 0, NULL, NULL),
(287, 'TEE PPR', '165.00', '0.00', 'FLEX TIME', 6, 0, 'Consumable', NULL, 0, NULL, NULL),
(288, 'GATS', '1100.00', '0.00', 'FLEX TIME', 2, 0, 'Consumable', NULL, 0, NULL, NULL),
(289, 'M/ADPTOR', '360.00', '0.00', 'FLEX TIME', 8, 0, 'Consumable', NULL, 0, NULL, NULL),
(290, 'THREAD TAPE', '120.00', '0.00', 'FLEX TIME', 4, 0, 'Consumable', NULL, 0, NULL, NULL),
(291, 'PIPE', '1700.00', '0.00', 'FLEX TIME', 1, 0, 'Consumable', NULL, 0, NULL, NULL),
(292, 'ELBOW', '120.00', '0.00', 'FLEX TIME', 4, 0, 'Consumable', NULL, 0, NULL, NULL),
(293, 'SCAD', '120.00', '0.00', 'FLEX TIME', 5, 0, 'Consumable', NULL, 0, NULL, NULL),
(294, 'G CAP', '100.00', '0.00', 'FLEX TIME', 2, 0, 'Consumable', NULL, 0, NULL, NULL),
(295, 'R/G CAP', '75.00', '0.00', 'FLEX TIME', 1, 0, 'Consumable', NULL, 0, NULL, NULL),
(296, 'G/ CAP', '50.00', '0.00', 'FLEX TIME', 1, 0, 'Consumable', NULL, 0, NULL, NULL),
(297, 'G/ CAP', '50.00', '0.00', 'FLEX TIME', 1, 0, 'Consumable', NULL, 0, NULL, NULL),
(298, 'CAP', '60.00', '0.00', 'FLEX TIME', 1, 0, 'Consumable', NULL, 0, NULL, NULL),
(299, 'TEE', '30.00', '0.00', 'FLEX TIME', 1, 0, 'Consumable', NULL, 0, NULL, NULL),
(300, 'SODA', '1560.00', '100.00', 'RAHISI STORE', 0, 0, 'Product', 'Drinks', 0, 'soda.jpg', 'soft drink'),
(301, 'MAIZE FLOUR', '1944.00', '0.00', 'NAIVAS', 12, 0, 'Food', NULL, 0, NULL, NULL),
(302, 'COOKING OIL', '2370.00', '0.00', 'FLEX TIME', 10, 0, 'Consumable', NULL, 0, NULL, NULL),
(303, 'MOP', '485.00', '0.00', 'NAIVAS', 1, 0, 'Consumable', NULL, 0, NULL, NULL),
(304, 'MILK', '732.00', '150.00', 'NAIVAS', 60, 0, 'Food', NULL, 0, NULL, NULL),
(305, 'OMO', '1300.00', '0.00', 'NAIVAS', 1, 0, 'Consumable', NULL, 0, NULL, NULL),
(351, 'Pilau Masala', '355.00', '0.00', 'naivas', 1, 0, 'Food-Item', NULL, 0, NULL, NULL),
(307, 'ALLUMINIUM FOIL', '1200.00', '0.00', 'NAIVAS', 1, 0, 'Consumable', NULL, 0, NULL, NULL),
(308, 'SUGAR', '778.00', '0.00', 'NAIVAS', 4, 0, 'Consumable', NULL, 0, NULL, NULL),
(309, 'BLUE BAND', '550.00', '0.00', 'NAIVAS', 1, 0, 'Consumable', NULL, 0, NULL, NULL),
(310, 'Captain Morgan 750ml shots', '1250.00', '200.00', 'Jacyjoka', 4, 0, 'Product', 'Drinks', 0, 'captain morgan.jpeg', 'A perfect blend of Caribbean rum'),
(311, 'Richot 750ml shots', '1200.00', '200.00', 'Jacyjoka', 18, 0, 'Product', 'Drinks', 0, 'richot 750ml.jpg', 'is excellently matured with a distinct aroma'),
(312, 'Richot 750ml ', '1200.00', '2500.00', 'Jacyjoka', 1, 0, 'Product', NULL, 0, NULL, NULL),
(313, 'Jameson 1L shot', '2850.00', '300.00', 'Jacyjoka', 1, 0, 'Product', 'Drinks', 0, 'jameson.jpg', ' A light floral fragrance, peppered with spicy wood and sweet notes'),
(314, 'Jameson 750ml shots', '2400.00', '200.00', 'Jacyjoka', 7, 0, 'Product', NULL, 0, NULL, NULL),
(315, 'Johny walker red 750ML shots', '2650.00', '250.00', 'Jacyjoka', 18, 0, 'Product', 'Drinks', 0, 'johnnie-walker-red-labe.jpg', 'Blended Scotch Whisky.'),
(316, 'Ballentines 1L shots', '2300.00', '250.00', 'Jacyjoka', 30, 0, 'Product', 'Drinks', 0, 'balentine.jpg', 'a brand of blended Scotch whisky'),
(317, 'Jack Daniel 700ML shots', '3200.00', '300.00', 'Jacyjoka', 22, 0, 'Product', 'Drinks', 0, 'jack daniels.png', ' mellow, slightly smoky character.'),
(318, 'Jack Daniel honey 700ML shots', '3795.00', '350.00', 'Jacyjoka', 18, 0, 'Product', 'Drinks', 0, 'jack daniels honey.jpg', ' a spiced honey liqueur'),
(319, 'Jhonny walker 750 ml', '3700.00', '300.00', 'Jacyjoka', 16, 0, 'Product', NULL, 0, NULL, NULL),
(320, 'Vat 69 Shots', '2199.00', '250.00', 'Jacyjoka', 10, 0, 'Product', 'Drinks', 0, 'vat 69.jpg', ' a blended Scotch with a light, very fresh and slightly spicy taste profile '),
(321, 'WHITE CAP', '4888.00', '280.00', 'SHIVA', 0, 0, 'Product', 'Drinks', 0, 'whitecap.jpg', ' a connoisseur\'s beer'),
(325, 'tusker', '4225.00', '250.00', 'SHIVA', 0, 0, 'Product', 'Drinks', 0, 'Tusker-Kenya-Beer-Lager-Sybarite-Cellars_2048x2048.jpg', 'rich, natural tasting beer made from pure water'),
(330, 'ROYCO CUBE', '140.00', '0.00', 'NAIVAS', 40, 0, 'Product', NULL, 0, NULL, NULL),
(331, 'CURRY POWDER', '270.00', '0.00', 'NAIVAS', 1, 0, 'Product', NULL, 0, NULL, NULL),
(333, 'SUGAR', '389.00', '0.00', 'NAIVAS', 1, 0, 'Product', NULL, 0, NULL, NULL),
(334, 'CUMIN SEED', '170.00', '0.00', 'NAIVAS', 2, 0, 'Product', NULL, 0, NULL, NULL),
(335, 'BLACK PEPPER', '500.00', '0.00', 'NAIVAS', 2, 0, 'Product', NULL, 0, NULL, NULL),
(336, 'SALT', '80.00', '0.00', 'NAIVAS', 2, 0, 'Consumable', NULL, 0, NULL, NULL),
(337, 'BREAD', '200.00', '60.00', 'NAIVAS', 1, 0, 'Food', NULL, 0, NULL, NULL),
(338, 'Tusker', '4225.00', '250.00', 'SHIVA', 0, 0, 'Product', NULL, 0, NULL, NULL),
(342, 'cling film', '2568.00', '0.00', 'Chandaria industries', 1, 0, 'Consumable', NULL, 0, NULL, NULL),
(343, 'Seviettes', '5530.00', '0.00', 'Chandaria industries', 60, 0, 'Consumable', NULL, 0, NULL, NULL),
(344, 'Air freshners', '2280.00', '0.00', 'Chandaria industries', 10, 0, 'Consumable', NULL, 0, NULL, NULL),
(345, 'Eggs', '590.00', '0.00', 'naivas', 1, 0, 'Food-Item', NULL, 0, NULL, NULL),
(346, 'oregano', '160.00', '0.00', 'naivas', 1, 0, 'Food-Item', NULL, 0, NULL, NULL),
(347, 'cardmond', '450.00', '0.00', 'naivas', 1, 0, 'Food-Item', NULL, 0, NULL, NULL),
(348, 'pilau masala', '355.00', '0.00', 'naivas', 1, 0, 'Food-Item', NULL, 0, NULL, NULL),
(349, 'Sausage', '750.00', '70.00', 'Jacyjoka', 52, 0, 'Product', 'Breakfast', 0, 'sausages.jpg', 'a mixture of ground meat, combined with spices'),
(352, 'Jik', '1900.00', '0.00', 'naivas', 1, 0, 'Consumable', NULL, 0, NULL, NULL),
(353, 'Counter Book', '325.00', '0.00', 'naivas', 1, 0, 'Consumable', NULL, 0, NULL, NULL),
(354, 'samosa', '0.00', '75.00', 'JACYJOKA', 0, 0, 'Product', 'Breakfast', 0, 'samosa.jpg', ' a deep fried pastry'),
(360, 'eggs', '590.00', '100.00', 'naivas', 44, 0, 'Product', NULL, 0, NULL, NULL),
(361, 'Milk', '720.00', '150.00', 'naivas', 12, 0, 'Product', 'Breakfast', 0, 'milk.jpg', ' is an emulsion of proteins, fats, vitamins, minerals, and sugars'),
(362, 'MAIZE FLOUR', '1944.00', '0.00', 'naivas', 10, 0, 'Product', NULL, 0, NULL, NULL),
(363, 'baking flour', '384.00', '0.00', 'naivas', 2, 0, 'Product', NULL, 0, NULL, NULL),
(364, 'BURGER BUNS', '0.00', '0.00', 'JACYJOKA', 5, 0, 'Food-Item', NULL, 0, NULL, NULL),
(365, 'chicken burger', '495.00', '650.00', 'naivas', 6, 0, 'Food', NULL, 0, NULL, NULL),
(366, 'fish fillet', '3600.00', '800.00', 'anglo danish', 4, 0, 'Product', 'Fish', 0, 'fish fillet.jpg', 'fish fillet'),
(367, 'tilapia', '300.00', '750.00', 'LOCAL MARKET', 23, 0, 'Product', 'Fish', 0, 'tilapia.jpg', 'Tilapia has a flakey texture and mild flavor.'),
(368, 'pork', '4800.00', '1800.00', 'MARY FARM', 6.5, 0, 'Product', 'Meat', 0, 'pork.jpg', 'pig meat'),
(369, 'mutton', '7000.00', '1200.00', 'mkomani', 10, 0, 'Product', NULL, 0, NULL, NULL),
(370, 'kienyeji', '9000.00', '1700.00', 'LOCAL MARKET', 17, 0, 'Product', 'Chicken', 0, 'kienyeji.jpg', 'chicken with more chicken flavour'),
(371, 'broilers', '500.00', '1500.00', 'Lai', 4.25, 0, 'Product', 'Chicken', 0, 'broiler.jpg', 'broiler chicken'),
(378, 'food containers', '2541.00', '0.00', 'naivas', 11, 0, 'Consumable', NULL, 0, NULL, NULL),
(380, 'mopper', '405.00', '0.00', 'naivas', 1, 0, 'Food-Item', NULL, 0, NULL, NULL),
(381, 'mopper', '405.00', '0.00', 'naivas', 1, 0, 'Consumable', NULL, 0, NULL, NULL),
(382, 'omo', '1300.00', '0.00', 'naivas', 1, 0, 'Consumable', NULL, 0, NULL, NULL),
(383, 'jik', '1449.00', '0.00', 'naivas', 1, 0, 'Consumable', NULL, 0, NULL, NULL),
(384, 'safisha scrubber', '194.00', '0.00', 'naivas', 2, 0, 'Consumable', NULL, 0, NULL, NULL),
(385, 'safisha scubber', '75.00', '0.00', 'naivas', 1, 0, 'Consumable', NULL, 0, NULL, NULL),
(386, 'BEEF', '9600.00', '750.00', 'mkomani', 24, 0, 'Product', 'Meat', 0, 'beef dry fry.jpg', 'beef '),
(387, 'CHACOAL', '3000.00', '0.00', 'localmarket', 1, 0, 'Consumable', NULL, 0, NULL, NULL),
(388, 'KITCHEN FRYER SWITCH', '3000.00', '0.00', 'DAVID', 1, 0, 'Consumable', NULL, 0, NULL, NULL),
(392, 'HEINKEN', '5880.00', '300.00', 'SLIQUOR', 1, 0, 'Product', NULL, 0, NULL, NULL),
(391, 'GK', '4880.00', '300.00', 'SHIVA', 10, 0, 'Product', NULL, 0, NULL, NULL),
(393, 'TUSKER', '4225.00', '250.00', 'SHIVA', 15, 0, 'Product', NULL, 0, NULL, NULL),
(394, 'WHITE', '4225.00', '250.00', 'SHIVA', 22, 0, 'Product', NULL, 0, NULL, NULL),
(396, 'WATER 1LT', '4325.00', '100.00', 'Aquamist water LTD', 78, 0, 'Product', NULL, 0, NULL, NULL),
(397, 'DELMONTE', '920.00', '350.00', 'SLIQUOR', 1, 0, 'Product', NULL, 0, NULL, NULL),
(398, 'VODKA TOTS', '1300.00', '200.00', 'SLIQUOR', 22, 0, 'Product', NULL, 0, NULL, NULL),
(399, 'DROST HOF', '920.00', '300.00', 'SLIQUOR', 3, 0, 'Product', NULL, 0, NULL, NULL),
(400, 'SAMOSA', '0.00', '75.00', 'JACY', 32, 0, 'Product', NULL, 0, NULL, NULL),
(401, 'cheese', '399.00', '0.00', 'naivas', 1, 0, 'Food-Item', NULL, 0, NULL, NULL),
(402, 'brown bread', '130.00', '60.00', 'naivas', 8, 0, 'Product', NULL, 0, NULL, NULL),
(403, 'EGGS', '590.00', '100.00', 'naivas', 30, 0, 'Product', NULL, 0, NULL, NULL),
(404, 'bananas', '197.00', '0.00', 'naivas', 10, 0, 'Food-Item', NULL, 0, NULL, NULL),
(405, 'sugar', '778.00', '0.00', 'naivas', 2, 0, 'Consumable', NULL, 0, NULL, NULL),
(406, 'melon', '240.00', '0.00', 'naivas', 0.5, 0, 'Food-Item', NULL, 0, NULL, NULL),
(407, 'bag', '55.00', '0.00', 'naivas', 1, 0, 'Consumable', NULL, 0, NULL, NULL),
(408, 'SOAP', '719.00', '0.00', 'A ONE', 2, 0, 'Consumable', NULL, 0, NULL, NULL),
(409, 'OMO', '1299.00', '0.00', 'A ONE', 1, 0, 'Consumable', NULL, 0, NULL, NULL),
(410, 'SALT', '80.00', '0.00', 'naivas', 1, 0, 'Consumable', NULL, 0, NULL, NULL),
(411, 'BALOZI', '4225.00', '250.00', 'SHIVA', 25, 0, 'Product', NULL, 0, NULL, NULL),
(412, 'TUSKER CIDER', '5552.00', '280.00', 'SHIVA', 25, 0, 'Product', NULL, 0, NULL, NULL),
(413, 'GILBEYS 750ML', '2594.00', '250.00', 'SHIVA', 25, 0, 'Product', NULL, 0, NULL, NULL),
(414, 'chicken pizza', '0.00', '1200.00', 'jacyjoka', 50, 0, 'Food', NULL, 0, NULL, NULL),
(415, 'salt', '80.00', '0.00', 'naivas', 2, 0, 'Consumable', NULL, 0, NULL, NULL),
(416, 'toothpicks', '100.00', '0.00', 'naivas', 4, 0, 'Consumable', NULL, 0, NULL, NULL),
(417, 'royco cubes', '140.00', '0.00', 'naivas', 2, 0, 'Consumable', NULL, 0, NULL, NULL),
(418, 'coffee', '820.00', '0.00', 'naivas', 1, 0, 'Consumable', NULL, 0, NULL, NULL),
(419, 'cooking oil', '2370.00', '0.00', 'naivas', 1, 0, 'Consumable', NULL, 0, NULL, NULL),
(420, 'cumin seeds', '440.00', '0.00', 'naivas', 1, 0, 'Consumable', NULL, 0, NULL, NULL),
(421, 'brown bread', '130.00', '60.00', 'naivas', 3, 0, 'Product', NULL, 0, NULL, NULL),
(422, 'white bread', '130.00', '60.00', 'naivas', 1, 0, 'Product', NULL, 0, NULL, NULL),
(423, 'jam', '429.00', '0.00', 'naivas', 1, 0, 'Food-Item', NULL, 0, NULL, NULL),
(424, 'tea leaves', '252.00', '0.00', 'naivas', 1, 0, 'Consumable', NULL, 0, NULL, NULL),
(425, 'blueband', '550.00', '0.00', 'naivas', 1, 0, 'Consumable', NULL, 0, NULL, NULL),
(426, 'cabbage', '99.00', '0.00', 'naivas', 1, 0, 'Food', NULL, 0, NULL, NULL),
(427, 'melon', '63.00', '0.00', 'naivas', 1, 0, 'Food', NULL, 0, NULL, NULL),
(428, 'melon', '67.00', '0.00', 'naivas', 0.5, 0, 'Food', NULL, 0, NULL, NULL),
(429, 'tomatoes', '20.00', '0.00', 'naivas', 20, 0, 'Food', NULL, 0, NULL, NULL),
(430, 'water melon', '152.00', '0.00', 'quick mart', 0.5, 0, 'Consumable', NULL, 0, NULL, NULL),
(431, 'banana', '310.00', '0.00', 'quick mart', 15, 0, 'Consumable', NULL, 0, NULL, NULL),
(432, 'arrow roots', '205.00', '0.00', 'naivas', 2, 0, 'Food-Item', NULL, 0, NULL, NULL),
(433, 'STRAWS', '150.00', '0.00', 'naivas', 3, 0, 'Consumable', NULL, 0, NULL, NULL),
(434, 'DELIVERY BOOKS', '196.00', '0.00', 'naivas', 3, 0, 'Consumable', NULL, 0, NULL, NULL),
(435, 'Bag', '15.00', '0.00', 'naivas', 1, 0, 'Consumable', NULL, 0, NULL, NULL),
(436, 'EGGS', '581.00', '150.00', 'Quick Mart', 24, 0, 'Consumable', NULL, 0, NULL, NULL),
(437, 'MILK', '660.00', '150.00', 'naivas', 12, 0, 'Food-Item', NULL, 0, NULL, NULL),
(438, 'BANANA', '148.00', '0.00', 'naivas', 0, 0, 'Consumable', NULL, 0, NULL, NULL),
(439, 'WHITE BREAD', '260.00', '60.00', 'naivas', 16, 0, 'Product', NULL, 0, NULL, NULL),
(440, 'water melon', '219.00', '0.00', 'naivas', 0.5, 0, 'Consumable', NULL, 0, NULL, NULL),
(441, 'PINEAPPLE', '252.00', '0.00', 'naivas', 1, 0, 'Consumable', NULL, 0, NULL, NULL),
(442, 'TOMATO', '150.00', '0.00', 'naivas', 1.8, 0, 'Food-Item', NULL, 0, NULL, NULL);

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

--
-- Table structure for table `purchase`
--

CREATE TABLE `purchase` (
  `purchase_id` int(11) NOT NULL,
  `vendor_id` int(11) DEFAULT NULL,
  `payment_method` varchar(255) DEFAULT NULL,
  `purchase_date` date DEFAULT NULL,
  `total_amount` decimal(10,2) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `purchase_orders`
--

CREATE TABLE `purchase_orders` (
  `purchase_order_id` int(11) NOT NULL,
  `purchase_date` date DEFAULT NULL,
  `productname` varchar(255) DEFAULT NULL,
  `price` decimal(10,2) DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `subtotal` decimal(10,2) DEFAULT NULL,
  `invo_id` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `requests`
--

CREATE TABLE `requests` (
  `request_id` int(11) NOT NULL,
  `request_by` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `status` varchar(50) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `request_items`
--

CREATE TABLE `request_items` (
  `irid` int(11) NOT NULL,
  `product_name` varchar(255) DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `request_id` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `rooms`
--

CREATE TABLE `rooms` (
  `room_id` int(11) NOT NULL,
  `room_name` varchar(255) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `image` mediumblob NOT NULL,
  `status` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `room_bills`
--

CREATE TABLE `room_bills` (
  `rbid` int(11) NOT NULL,
  `trans_id` int(11) DEFAULT NULL,
  `booking_id` int(11) DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `room_payments`
--

CREATE TABLE `room_payments` (
  `pid` int(11) NOT NULL,
  `paid_amount` decimal(10,2) NOT NULL,
  `booking_id` int(11) NOT NULL,
  `pay_method` varchar(50) NOT NULL,
  `date` datetime DEFAULT current_timestamp()
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `room_sales`
--

CREATE TABLE `room_sales` (
  `rsid` bigint(20) UNSIGNED NOT NULL,
  `trans_id` int(11) DEFAULT NULL,
  `room_name` varchar(255) DEFAULT NULL,
  `room_id` int(11) DEFAULT NULL,
  `nod` int(11) DEFAULT NULL,
  `room_price` decimal(10,2) DEFAULT NULL,
  `subtotal` decimal(10,2) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `sales`
--

CREATE TABLE `sales` (
  `sale_id` int(11) NOT NULL,
  `product_id` int(11) DEFAULT NULL,
  `product_name` varchar(255) DEFAULT NULL,
  `quantity` float DEFAULT NULL,
  `selling_price` decimal(10,2) DEFAULT NULL,
  `subtotal` decimal(10,2) DEFAULT NULL,
  `trans_id` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `sales_order`
--

CREATE TABLE `sales_order` (
  `product_name` varchar(255) DEFAULT NULL,
  `price` decimal(10,2) DEFAULT NULL,
  `quantity` decimal(10,2) DEFAULT NULL,
  `product_id` float DEFAULT NULL,
  `subtotal` decimal(10,2) DEFAULT NULL,
  `order_id` int(11) DEFAULT NULL,
  `sales_order_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `swimming`
--

CREATE TABLE `swimming` (
  `swimid` int(11) NOT NULL,
  `age_group` varchar(255) DEFAULT NULL,
  `cost` decimal(10,2) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `swimo`
--

CREATE TABLE `swimo` (
  `swimo_id` int(11) NOT NULL,
  `age_group` varchar(255) DEFAULT NULL,
  `cost` decimal(10,2) DEFAULT NULL,
  `no_persons` int(11) DEFAULT NULL,
  `total_cost` decimal(10,2) DEFAULT NULL,
  `date_column` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `tables`
--

CREATE TABLE `tables` (
  `table_name` varchar(20) NOT NULL,
  `table_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `table_payslip`
--

CREATE TABLE `table_payslip` (
  `payslip_id` int(11) NOT NULL,
  `employeeId` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `grossPay` decimal(10,2) DEFAULT NULL,
  `nssfTier1` decimal(10,2) DEFAULT NULL,
  `nssfTier2` decimal(10,2) DEFAULT NULL,
  `nhif` decimal(10,2) DEFAULT NULL,
  `housingLevy` decimal(10,2) DEFAULT NULL,
  `payeBeforeRelief` decimal(10,2) DEFAULT NULL,
  `dynamicRelief` decimal(10,2) DEFAULT NULL,
  `payeAfterRelief` decimal(10,2) DEFAULT NULL,
  `totalDeductions` decimal(10,2) DEFAULT NULL,
  `netPay` decimal(10,2) DEFAULT NULL,
  `date` date NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `toshop`
--

CREATE TABLE `toshop` (
  `product_id` int(11) NOT NULL,
  `quantity` int(11) NOT NULL,
  `tsid` int(11) NOT NULL,
  `tsdate` date NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tostore`
--

CREATE TABLE `tostore` (
  `product_id` int(11) NOT NULL,
  `quantity` int(11) NOT NULL,
  `stid` int(11) NOT NULL,
  `sdate` date NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `transaction_receipts`
--

CREATE TABLE `transaction_receipts` (
  `amount_received` decimal(10,2) NOT NULL,
  `payment_method` varchar(50) NOT NULL,
  `phone_number` varchar(20) NOT NULL,
  `seller_date` datetime NOT NULL,
  `seller_name` varchar(50) NOT NULL,
  `total` decimal(10,2) NOT NULL,
  `trans_id` int(11) NOT NULL,
  `booking_id` varchar(25) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `units`
--

CREATE TABLE `units` (
  `id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `vendors`
--

CREATE TABLE `vendors` (
  `company` varchar(50) NOT NULL,
  `vendor_address` varchar(100) NOT NULL,
  `vendor_email` varchar(50) NOT NULL,
  `vendor_id` int(11) NOT NULL,
  `vendor_name` varchar(50) NOT NULL,
  `vendor_phone` varchar(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `vendor_debts`
--

CREATE TABLE `vendor_debts` (
  `amount_owed` decimal(10,2) NOT NULL,
  `id` int(11) NOT NULL,
  `vendor_id` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `vendor_transactions`
--

CREATE TABLE `vendor_transactions` (
  `amount_transacted` decimal(10,2) NOT NULL,
  `id` int(11) NOT NULL,
  `transaction_type` varchar(50) NOT NULL,
  `vendor_id` int(11) NOT NULL,
  `date` date DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `bookings`
--
ALTER TABLE `bookings`
  ADD PRIMARY KEY (`booking_id`);

--
-- Indexes for table `category`
--
ALTER TABLE `category`
  ADD PRIMARY KEY (`cat_id`);

--
-- Indexes for table `customers`
--
ALTER TABLE `customers`
  ADD PRIMARY KEY (`customer_id`);

--
-- Indexes for table `dispose`
--
ALTER TABLE `dispose`
  ADD PRIMARY KEY (`dispose_id`);

--
-- Indexes for table `disposed_items`
--
ALTER TABLE `disposed_items`
  ADD PRIMARY KEY (`di_id`),
  ADD KEY `dispose_id` (`dispose_id`);

--
-- Indexes for table `employees`
--
ALTER TABLE `employees`
  ADD PRIMARY KEY (`employee_id`);

--
-- Indexes for table `employee_salary`
--
ALTER TABLE `employee_salary`
  ADD PRIMARY KEY (`salary_id`);

--
-- Indexes for table `expenses`
--
ALTER TABLE `expenses`
  ADD PRIMARY KEY (`expense_id`);

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

--
-- Indexes for table `food`
--
ALTER TABLE `food`
  ADD PRIMARY KEY (`food_id`);

--
-- Indexes for table `food_group_items`
--
ALTER TABLE `food_group_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `food_item_id` (`food_id`);

--
-- Indexes for table `food_ingredients`
--
ALTER TABLE `food_ingredients`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ingredient_id` (`ingredient_id`);

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

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

--
-- Indexes for table `invoice`
--
ALTER TABLE `invoice`
  ADD PRIMARY KEY (`invo_id`);

--
-- Indexes for table `issue`
--
ALTER TABLE `issue`
  ADD PRIMARY KEY (`issue_id`);

--
-- Indexes for table `issued`
--
ALTER TABLE `issued`
  ADD PRIMARY KEY (`issue_id`);

--
-- Indexes for table `issued_products`
--
ALTER TABLE `issued_products`
  ADD PRIMARY KEY (`ipid`),
  ADD KEY `issue_id` (`issue_id`);

--
-- Indexes for table `issue_items`
--
ALTER TABLE `issue_items`
  ADD PRIMARY KEY (`it_id`),
  ADD KEY `issue_id` (`issue_id`);

--
-- Indexes for table `logs`
--
ALTER TABLE `logs`
  ADD PRIMARY KEY (`log_id`);

--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`order_id`);

--
-- Indexes for table `payments`
--
ALTER TABLE `payments`
  ADD PRIMARY KEY (`pay_id`),
  ADD KEY `trans_id` (`trans_id`);

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

--
-- Indexes for table `purchase`
--
ALTER TABLE `purchase`
  ADD PRIMARY KEY (`purchase_id`);

--
-- Indexes for table `purchase_orders`
--
ALTER TABLE `purchase_orders`
  ADD PRIMARY KEY (`purchase_order_id`);

--
-- Indexes for table `requests`
--
ALTER TABLE `requests`
  ADD PRIMARY KEY (`request_id`);

--
-- Indexes for table `request_items`
--
ALTER TABLE `request_items`
  ADD PRIMARY KEY (`irid`),
  ADD KEY `request_id` (`request_id`);

--
-- Indexes for table `rooms`
--
ALTER TABLE `rooms`
  ADD PRIMARY KEY (`room_id`);

--
-- Indexes for table `room_bills`
--
ALTER TABLE `room_bills`
  ADD PRIMARY KEY (`rbid`),
  ADD KEY `booking_id` (`booking_id`);

--
-- Indexes for table `room_payments`
--
ALTER TABLE `room_payments`
  ADD PRIMARY KEY (`pid`);

--
-- Indexes for table `room_sales`
--
ALTER TABLE `room_sales`
  ADD PRIMARY KEY (`rsid`),
  ADD UNIQUE KEY `rsid` (`rsid`);

--
-- Indexes for table `sales`
--
ALTER TABLE `sales`
  ADD PRIMARY KEY (`sale_id`);

--
-- Indexes for table `sales_order`
--
ALTER TABLE `sales_order`
  ADD PRIMARY KEY (`sales_order_id`);

--
-- Indexes for table `swimming`
--
ALTER TABLE `swimming`
  ADD PRIMARY KEY (`swimid`);

--
-- Indexes for table `swimo`
--
ALTER TABLE `swimo`
  ADD PRIMARY KEY (`swimo_id`);

--
-- Indexes for table `tables`
--
ALTER TABLE `tables`
  ADD PRIMARY KEY (`table_id`);

--
-- Indexes for table `table_payslip`
--
ALTER TABLE `table_payslip`
  ADD PRIMARY KEY (`payslip_id`);

--
-- Indexes for table `toshop`
--
ALTER TABLE `toshop`
  ADD PRIMARY KEY (`tsid`);

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

--
-- Indexes for table `transaction_receipts`
--
ALTER TABLE `transaction_receipts`
  ADD PRIMARY KEY (`trans_id`);

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

--
-- Indexes for table `vendors`
--
ALTER TABLE `vendors`
  ADD PRIMARY KEY (`vendor_id`);

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `bookings`
--
ALTER TABLE `bookings`
  MODIFY `booking_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `category`
--
ALTER TABLE `category`
  MODIFY `cat_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `customers`
--
ALTER TABLE `customers`
  MODIFY `customer_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `dispose`
--
ALTER TABLE `dispose`
  MODIFY `dispose_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `disposed_items`
--
ALTER TABLE `disposed_items`
  MODIFY `di_id` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `employee_salary`
--
ALTER TABLE `employee_salary`
  MODIFY `salary_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `expenses`
--
ALTER TABLE `expenses`
  MODIFY `expense_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `expense_type`
--
ALTER TABLE `expense_type`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `food`
--
ALTER TABLE `food`
  MODIFY `food_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

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

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

--
-- AUTO_INCREMENT for table `food_items`
--
ALTER TABLE `food_items`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `invoice`
--
ALTER TABLE `invoice`
  MODIFY `invo_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `issue`
--
ALTER TABLE `issue`
  MODIFY `issue_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `issued`
--
ALTER TABLE `issued`
  MODIFY `issue_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `issued_products`
--
ALTER TABLE `issued_products`
  MODIFY `ipid` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `issue_items`
--
ALTER TABLE `issue_items`
  MODIFY `it_id` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `orders`
--
ALTER TABLE `orders`
  MODIFY `order_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `payments`
--
ALTER TABLE `payments`
  MODIFY `pay_id` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `purchase`
--
ALTER TABLE `purchase`
  MODIFY `purchase_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `purchase_orders`
--
ALTER TABLE `purchase_orders`
  MODIFY `purchase_order_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `requests`
--
ALTER TABLE `requests`
  MODIFY `request_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `request_items`
--
ALTER TABLE `request_items`
  MODIFY `irid` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `rooms`
--
ALTER TABLE `rooms`
  MODIFY `room_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `room_bills`
--
ALTER TABLE `room_bills`
  MODIFY `rbid` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `room_payments`
--
ALTER TABLE `room_payments`
  MODIFY `pid` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `room_sales`
--
ALTER TABLE `room_sales`
  MODIFY `rsid` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sales`
--
ALTER TABLE `sales`
  MODIFY `sale_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sales_order`
--
ALTER TABLE `sales_order`
  MODIFY `sales_order_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `swimming`
--
ALTER TABLE `swimming`
  MODIFY `swimid` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `swimo`
--
ALTER TABLE `swimo`
  MODIFY `swimo_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tables`
--
ALTER TABLE `tables`
  MODIFY `table_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `table_payslip`
--
ALTER TABLE `table_payslip`
  MODIFY `payslip_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `toshop`
--
ALTER TABLE `toshop`
  MODIFY `tsid` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tostore`
--
ALTER TABLE `tostore`
  MODIFY `stid` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `transaction_receipts`
--
ALTER TABLE `transaction_receipts`
  MODIFY `trans_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `units`
--
ALTER TABLE `units`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `vendors`
--
ALTER TABLE `vendors`
  MODIFY `vendor_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `vendor_debts`
--
ALTER TABLE `vendor_debts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `vendor_transactions`
--
ALTER TABLE `vendor_transactions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

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