-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `firstlookbh_system`
--

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

--
-- Table structure for table `about`
--

CREATE TABLE `about` (
  `id` int(11) NOT NULL,
  `image` varchar(255) NOT NULL,
  `image_backGround` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `content` text NOT NULL,
  `title_en` varchar(255) NOT NULL,
  `content_en` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `about`
--

INSERT INTO `about` (`id`, `image`, `image_backGround`, `title`, `content`, `title_en`, `content_en`) VALUES
(1, 'http://firstlookbh.com/system/api/uploads/about/165693162_313415747637248_4096486997960079631_n.jpg', 'http://firstlookbh.com/system/api/uploads/about/1657212326165693162_313415747637248_4096486997960079631_n.jpg', 'First Look Restaurant App', 'First Look Restaurant App', 'First Look Restaurant App', 'First Look Restaurant App');

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

--
-- Table structure for table `branches`
--

CREATE TABLE `branches` (
  `id` int(11) NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `name_ar` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `display` int(11) NOT NULL,
  `branch_show` int(11) NOT NULL DEFAULT 1,
  `date` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `branches`
--

INSERT INTO `branches` (`id`, `name`, `name_ar`, `display`, `branch_show`, `date`) VALUES
(1, 'first look RESTUARANT - MEGHABA', 'مطعم فيرست لوك- مغابة', 1, 1, '');

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

--
-- Table structure for table `branches_regions`
--

CREATE TABLE `branches_regions` (
  `id` int(11) NOT NULL,
  `region_id` int(11) NOT NULL,
  `branche_id` int(11) NOT NULL,
  `date` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

--
-- Table structure for table `cart`
--

CREATE TABLE `cart` (
  `cart_id` int(11) NOT NULL,
  `sub_category_id` varchar(255) NOT NULL,
  `size_id` varchar(255) NOT NULL DEFAULT '0',
  `addition_id` varchar(255) NOT NULL,
  `quantity` varchar(255) NOT NULL,
  `price` varchar(255) NOT NULL,
  `client_id` varchar(255) NOT NULL,
  `remove_id` varchar(255) NOT NULL,
  `side_id` varchar(255) DEFAULT NULL,
  `note` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `date` varchar(255) NOT NULL DEFAULT '0',
  `cart_type` int(11) NOT NULL DEFAULT 1 COMMENT '1:mobileOrder,2:WebOrder	'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `cart`
--

INSERT INTO `cart` (`cart_id`, `sub_category_id`, `size_id`, `addition_id`, `quantity`, `price`, `client_id`, `remove_id`, `side_id`, `note`, `status`, `date`, `cart_type`) VALUES
(1, '11', '219', '', '1', '3', '1', '', '', '', 1, '2022-07-05', 1),
(2, '3', '211', '', '1', '2.5', '1', '', '', '', 1, '2022-07-05', 1),
(5, '4', '3', '', '3', '7.5', '1', '', '', '', 1, '2022-07-06', 1),
(6, '11', '219', '', '2', '6', '1', '', '', '', 0, '2022-07-06', 1),
(8, '8', '218', '', '1', '3.5', '1', '', '', '', 0, '2022-07-06', 1),
(9, '104', '159', '', '4', '14', '2', '', '', '', 1, '2022-07-06', 1),
(10, '14', '13', '', '3', '4.5', '2', '', '', '', 1, '2022-07-06', 1),
(11, '5', '4', '', '1', '1.5', '2', '', '', '', 1, '2022-07-06', 1),
(14, '82', '111', '', '1', '1.2', '1', '', '', '', 0, '2022-08-04', 1),
(15, '65', '74', '', '1', '3', '1', '', '', '', 0, '2022-08-04', 1);

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

--
-- Table structure for table `client_addresses`
--

CREATE TABLE `client_addresses` (
  `client_address_id` int(11) NOT NULL,
  `lat_loca` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `long_loca` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `region` int(11) NOT NULL DEFAULT 0,
  `block` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `road` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `building` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `flat_number` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `client_phone` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `note` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `client_id` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `date` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `client_addresses`
--

INSERT INTO `client_addresses` (`client_address_id`, `lat_loca`, `long_loca`, `region`, `block`, `road`, `building`, `flat_number`, `client_phone`, `note`, `client_id`, `date`) VALUES
(2, '', '', 1, '231', 'Egypt', '123', '123', '8', '', '1', '2022-07-06'),
(3, '', '', 29, '1', '1800 Ellis St, San Francisco, CA 94115، الولايات المتحدة', '1', '1', '1', '', '2', '2022-07-06');

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

--
-- Table structure for table `client_fav`
--

CREATE TABLE `client_fav` (
  `fav_id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL,
  `sub_category_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `client_search_key`
--

CREATE TABLE `client_search_key` (
  `id` int(11) NOT NULL,
  `search_key` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `client_id` int(11) NOT NULL DEFAULT 0,
  `date_added` varchar(225) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

--
-- Table structure for table `closed_dates`
--

CREATE TABLE `closed_dates` (
  `id` int(11) NOT NULL,
  `date` date NOT NULL,
  `date_added` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

--
-- Table structure for table `complaints`
--

CREATE TABLE `complaints` (
  `id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `content` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `date` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `complaint_images`
--

CREATE TABLE `complaint_images` (
  `id` int(11) NOT NULL,
  `complaint_id` int(11) NOT NULL,
  `image` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `contact`
--

CREATE TABLE `contact` (
  `id` int(11) NOT NULL,
  `address` varchar(255) NOT NULL,
  `address_en` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `mobile` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `instagram` varchar(255) NOT NULL,
  `twitter` varchar(255) NOT NULL,
  `facebook` varchar(255) NOT NULL,
  `whatsapp` varchar(255) NOT NULL,
  `snapchat` varchar(255) NOT NULL,
  `website` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `contact`
--

INSERT INTO `contact` (`id`, `address`, `address_en`, `phone`, `mobile`, `email`, `instagram`, `twitter`, `facebook`, `whatsapp`, `snapchat`, `website`) VALUES
(1, 'First Look Restaurant App', 'First Look Restaurant App', '', '', 'info@emcan-group.com', 'https://www.instagram.com', '#', '#', '+973 3340 5497', '#', '#');

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

--
-- Table structure for table `contact_links`
--

CREATE TABLE `contact_links` (
  `id` int(11) NOT NULL,
  `branche_id` int(11) NOT NULL,
  `link` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `contact_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

--
-- Table structure for table `delivered_way`
--

CREATE TABLE `delivered_way` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `name_en` varchar(255) NOT NULL,
  `display` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `delivered_way`
--

INSERT INTO `delivered_way` (`id`, `name`, `name_en`, `display`) VALUES
(1, 'توصيل ', 'Delivery', 1),
(2, 'إستلام من الفرع', 'Pickup', 1),
(3, 'داخل المطعم', 'In Restaurant', 0);

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

--
-- Table structure for table `devices`
--

CREATE TABLE `devices` (
  `id` int(11) NOT NULL,
  `device_token_id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL,
  `login` int(11) NOT NULL,
  `date_added` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `devices`
--

INSERT INTO `devices` (`id`, `device_token_id`, `client_id`, `login`, `date_added`) VALUES
(11, 11, 3, 1, '2022-08-06 18:07:22'),
(10, 10, 1, 1, '2022-08-06 15:40:06');

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

--
-- Table structure for table `dish_of_day`
--

CREATE TABLE `dish_of_day` (
  `id` int(11) NOT NULL,
  `parent_category_id` int(11) NOT NULL,
  `sub_category_id` int(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `show_date` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `drinks`
--

CREATE TABLE `drinks` (
  `id` int(11) NOT NULL,
  `title_ar` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `title_en` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `price` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

--
-- Table structure for table `latest`
--

CREATE TABLE `latest` (
  `id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `parent_category_id` int(11) NOT NULL,
  `display` int(11) NOT NULL DEFAULT 1,
  `date_added` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `latest`
--

INSERT INTO `latest` (`id`, `product_id`, `parent_category_id`, `display`, `date_added`) VALUES
(2, 3, 1, 1, '2022-05-18 16:38:33'),
(3, 14, 3, 1, '2022-05-18 16:38:38'),
(5, 11, 2, 1, '2022-05-28 15:49:36');

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

--
-- Table structure for table `messages`
--

CREATE TABLE `messages` (
  `id` int(11) NOT NULL,
  `message_type_id` int(11) NOT NULL,
  `content` mediumtext NOT NULL,
  `client_id` varchar(255) DEFAULT NULL,
  `complaint_id` varchar(255) NOT NULL,
  `type` int(11) NOT NULL COMMENT 'client=>1',
  `is_read` int(11) NOT NULL,
  `date` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `messages_type`
--

CREATE TABLE `messages_type` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `title_ar` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `messages_type`
--

INSERT INTO `messages_type` (`id`, `title`, `title_ar`, `date`) VALUES
(1, 'Complaints', 'شكوى أو إقتراح', ''),
(2, 'Offers', 'عروض', ''),
(3, 'Events', 'مناسبات', '');

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

--
-- Table structure for table `most_request_sub`
--

CREATE TABLE `most_request_sub` (
  `id` int(11) NOT NULL,
  `parent_category_id` int(11) NOT NULL,
  `sub_category_id` int(11) NOT NULL,
  `date_added` datetime NOT NULL DEFAULT current_timestamp(),
  `display` int(11) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `most_request_sub`
--

INSERT INTO `most_request_sub` (`id`, `parent_category_id`, `sub_category_id`, `date_added`, `display`) VALUES
(6, 4, 34, '2022-06-03 23:50:30', 1),
(7, 6, 65, '2022-06-03 23:51:00', 1),
(8, 6, 66, '2022-06-03 23:51:11', 1);

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

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` int(11) NOT NULL,
  `text` text CHARACTER SET utf32 COLLATE utf32_general_ci NOT NULL,
  `client_id` int(11) NOT NULL,
  `type` varchar(255) NOT NULL,
  `text_id` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `notifications`
--

INSERT INTO `notifications` (`id`, `text`, `client_id`, `type`, `text_id`, `date`) VALUES
(1, 'Your order Approved', 1, 'order', '1', '2022-07-05 13:56:32'),
(2, 'Your order under processing', 1, 'order', '1', '2022-07-05 13:57:38'),
(3, 'Your order has been Delivered', 1, 'order', '1', '2022-07-05 13:57:50'),
(4, 'Your order Approved', 1, 'order', '2', '2022-07-05 15:07:20');

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

--
-- Table structure for table `offers`
--

CREATE TABLE `offers` (
  `id` int(11) NOT NULL,
  `parent_category_id` int(11) NOT NULL,
  `sub_category_id` int(11) NOT NULL,
  `date_added` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

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

CREATE TABLE `orders` (
  `order_id` int(11) NOT NULL,
  `cart_id` varchar(255) NOT NULL,
  `client_id` int(11) NOT NULL,
  `client_address_id` varchar(255) DEFAULT NULL,
  `branch_id` varchar(255) NOT NULL DEFAULT '0',
  `total_price` float NOT NULL,
  `charge_cost` varchar(255) NOT NULL,
  `discount_percentage` varchar(255) NOT NULL,
  `vat` float NOT NULL,
  `vat_percentage` varchar(55) NOT NULL DEFAULT '5',
  `net_price` float NOT NULL,
  `order_status` varchar(255) NOT NULL,
  `order_follow` int(11) NOT NULL,
  `payment` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `deliver_id` int(11) NOT NULL DEFAULT 1,
  `mobile_type` varchar(255) DEFAULT NULL,
  `mobile_version` varchar(255) DEFAULT NULL,
  `order_now` int(11) NOT NULL DEFAULT 1,
  `order_date` varchar(255) DEFAULT NULL,
  `order_time` varchar(255) DEFAULT NULL,
  `date` varchar(255) NOT NULL,
  `del` int(11) NOT NULL DEFAULT 0,
  `delete_reason` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '',
  `delete_date` varchar(255) NOT NULL DEFAULT '',
  `user_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT 'admin'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` (`order_id`, `cart_id`, `client_id`, `client_address_id`, `branch_id`, `total_price`, `charge_cost`, `discount_percentage`, `vat`, `vat_percentage`, `net_price`, `order_status`, `order_follow`, `payment`, `deliver_id`, `mobile_type`, `mobile_version`, `order_now`, `order_date`, `order_time`, `date`, `del`, `delete_reason`, `delete_date`, `user_name`) VALUES
(1, '1', 1, '', '1', 3, '0', '0', 0.3, '10', 3.3, '1', 3, 'cash', 2, 'ios', '1.0', 1, '2022-07-05', '', '2022-07-05 13:48:19', 0, '', '', 'admin'),
(2, '2', 1, '', '1', 2.5, '0', '0', 0.25, '10', 2.75, '1', 1, 'cash', 2, 'ios', '1.0', 1, '2022-07-05', '', '2022-07-05 15:07:04', 0, '', '', 'admin'),
(3, '5', 1, '2', '1', 7.5, '1', '0', 0.75, '10', 9.25, '0', 0, 'cash', 1, 'ios', '1.0', 1, '2022-07-06', '', '2022-07-06 10:24:57', 0, '', '', 'admin'),
(4, '9', 2, '3', '1', 14, '0.750', '0', 1.4, '10', 16.15, '0', 0, 'cash', 1, 'ios', '1.0', 1, '2022-07-06', '', '2022-07-06 18:30:51', 0, '', '', 'admin'),
(5, '10,11', 2, '', '1', 6, '0', '0', 0.6, '10', 6.6, '0', 0, 'cash', 2, 'ios', '1.0', 1, '2022-07-17', '', '2022-07-17 10:52:25', 0, '', '', 'admin');

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

--
-- Table structure for table `orders_history`
--

CREATE TABLE `orders_history` (
  `order_id` int(11) NOT NULL,
  `cart_id` varchar(255) NOT NULL,
  `client_id` int(11) NOT NULL,
  `client_address_id` varchar(255) DEFAULT NULL,
  `branch_id` varchar(255) NOT NULL DEFAULT '0',
  `total_price` float NOT NULL,
  `charge_cost` varchar(255) NOT NULL,
  `discount_percentage` varchar(255) NOT NULL,
  `vat` float NOT NULL,
  `vat_percentage` varchar(255) NOT NULL DEFAULT '5',
  `net_price` float NOT NULL,
  `order_status` varchar(255) NOT NULL,
  `order_follow` int(11) NOT NULL,
  `payment` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `deliver_id` int(11) NOT NULL DEFAULT 1,
  `mobile_type` varchar(255) DEFAULT NULL,
  `mobile_version` varchar(255) DEFAULT NULL,
  `order_now` int(11) NOT NULL DEFAULT 1,
  `order_date` varchar(255) DEFAULT NULL,
  `order_time` varchar(255) DEFAULT NULL,
  `date` varchar(255) NOT NULL,
  `user_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT 'admin'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

--
-- Table structure for table `order_delete_reason`
--

CREATE TABLE `order_delete_reason` (
  `id` int(11) NOT NULL,
  `order_id` varchar(255) NOT NULL,
  `delete_reason` varchar(255) NOT NULL,
  `date_added` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `parent_categories`
--

CREATE TABLE `parent_categories` (
  `parent_category_id` int(11) NOT NULL,
  `parent_category_name` varchar(255) NOT NULL,
  `parent_category_desc` varchar(225) NOT NULL,
  `parent_category_name_ar` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `parent_category_desc_ar` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `parent_category_image` varchar(255) NOT NULL,
  `display` int(255) NOT NULL DEFAULT 1,
  `arrangement` int(11) NOT NULL,
  `type` int(11) NOT NULL DEFAULT 0,
  `removes_type` int(11) NOT NULL DEFAULT 1,
  `addition_type` int(11) NOT NULL DEFAULT 1,
  `date` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `parent_categories`
--

INSERT INTO `parent_categories` (`parent_category_id`, `parent_category_name`, `parent_category_desc`, `parent_category_name_ar`, `parent_category_desc_ar`, `parent_category_image`, `display`, `arrangement`, `type`, `removes_type`, `addition_type`, `date`) VALUES
(1, 'SOUPS', 'SOUPS', 'شوربات', 'شوربات', 'http://zellarestaurants.com/system/api/uploads/parent_category/1/1653741685.jpg', 1, 0, 0, 1, 1, ''),
(2, 'SALADS', 'SALADS', 'سلطة', 'سلطة', 'http://zellarestaurants.com/system/api/uploads/parent_category/2/1654279942.jpg', 1, 1, 0, 1, 1, ''),
(3, 'ENTREES', 'ENTREES', 'مقبلات', 'مقبلات', 'http://zellarestaurants.com/system/api/uploads/parent_category/3/1654280066.jpg', 1, 2, 0, 1, 1, ''),
(4, 'CHICKEN ITEMS', 'CHICKEN ITEMS', 'أصناف الدجاج', 'أصناف الدجاج', 'http://zellarestaurants.com/system/api/uploads/parent_category/4/1654280293.jpg', 1, 3, 0, 1, 1, ''),
(5, 'SEAFOOD ITEMS', 'SEAFOOD ITEMS', 'أصناف المأكولات البحرية', 'أصناف المأكولات البحرية', 'http://zellarestaurants.com/system/api/uploads/parent_category/5/1654261714.jpg', 1, 4, 0, 1, 1, ''),
(6, 'BEEF / MUTTON ITEMS', 'BEEF / MUTTON ITEMS', 'أصناف لحوم البقر / موتون', 'أصناف لحوم البقر / موتون', '', 1, 5, 0, 1, 1, ''),
(7, 'GRILLED FOODS / IRANIAN STYLE', 'GRILLED FOODS / IRANIAN STYLE', 'كلات مشوية / على الطريقة الايرانية', 'كلات مشوية / على الطريقة الايرانية', '', 1, 6, 0, 1, 1, ''),
(8, 'GRILLED FOODS / TURKISH STYLE', 'GRILLED FOODS / TURKISH STYLE', 'اكلات مشوية / على الطريقة التركية', 'اكلات مشوية / على الطريقة التركية', '', 1, 7, 0, 1, 1, ''),
(9, 'RICE ITEMS', 'RICE ITEMS', 'أصناف الأرز', 'أصناف الأرز', '', 1, 8, 0, 1, 1, ''),
(10, 'BREAD ITEMS', 'BREAD ITEMS', 'أصناف الخبز', 'أصناف الخبز', '', 1, 9, 0, 1, 1, ''),
(11, 'PASTAS & SPEGETTIES', 'PASTAS & SPEGETTIES', 'الباستاس والتوابل', 'الباستاس والتوابل', '', 1, 10, 0, 1, 1, ''),
(12, 'BROSTED ITEMS', 'BROSTED ITEMS', 'العناصر المبروزة', 'العناصر المبروزة', '', 1, 11, 0, 1, 1, ''),
(13, 'BREAK FAST ITEMS', 'BREAK FAST ITEMS', 'كسر العناصر السريعة', 'كسر العناصر السريعة', '', 1, 12, 0, 1, 1, ''),
(14, 'HEALTHY FOODS', 'HEALTHY FOODS', 'أغذية صحية', 'أغذية صحية', 'http://zellarestaurants.com/system/api/uploads/parent_category/14/1654198189.jpg', 1, 13, 0, 1, 1, ''),
(15, 'MALGOOMS IN SAAJ', 'MALGOOMS IN SAAJ', 'مالجوم في صاج', 'مالجوم في صاج', '', 1, 16, 0, 1, 1, ''),
(16, 'SAAJ WRAPS', 'SAAJ WRAPS', 'لفائف الصاج', 'لفائف الصاج', 'http://zellarestaurants.com/system/api/uploads/parent_category/16/1654272548.jpg', 1, 17, 0, 1, 1, ''),
(17, 'REGULAR SANDWITCHES', 'REGULAR SANDWITCHES', 'الساندويتشات العادية', 'الساندويتشات العادية', 'http://zellarestaurants.com/system/api/uploads/parent_category/17/1654272309.jpg', 1, 18, 0, 1, 1, ''),
(18, 'ZINGER SANWITCHES', 'ZINGER SANWITCHES', 'حلويات زنجر', 'حلويات زنجر', '', 1, 19, 0, 1, 1, ''),
(19, 'CLUB SANDWITCHES', 'CLUB SANDWITCHES', 'الساندويتش كلوب', 'الساندويتش كلوب', '', 1, 20, 0, 1, 1, ''),
(20, 'JUMBO SANDWITCHES', 'JUMBO SANDWITCHES', 'ساندويتشات جامبو', 'ساندويتشات جامبو', 'http://zellarestaurants.com/system/api/uploads/parent_category/20/1654278057.jpg', 1, 21, 0, 1, 1, ''),
(21, 'KIDS MEALS', 'KIDS MEALS', 'وجبات الاطفال', 'وجبات الاطفال', '', 1, 22, 0, 1, 1, ''),
(22, 'KIDS COMBOS', 'KIDS COMBOS', 'مجموعات الأطفال', 'مجموعات الأطفال', '', 1, 23, 0, 1, 1, ''),
(23, 'PIZZAS', 'PIZZAS', 'بيتزا', 'بيتزا', 'http://zellarestaurants.com/system/api/uploads/parent_category/23/1654290314.jpg', 1, 24, 0, 1, 1, ''),
(24, 'FRESH JUICES', 'FRESH JUICES', 'عصائر طازجة', 'عصائر طازجة', '', 1, 25, 0, 1, 1, ''),
(25, 'MILK SHAKES', 'MILK SHAKES', 'مخفوق الحليب', 'مخفوق الحليب', 'http://zellarestaurants.com/system/api/uploads/parent_category/25/1654198645.jpg', 1, 27, 0, 0, 0, '2022-06-02 22:37:25'),
(26, 'SHAWARMAS', 'SHAWARMAS', 'شوارماس', 'شوارماس', 'http://zellarestaurants.com/system/api/uploads/parent_category/26/1654258734.jpg', 1, 14, 0, 0, 0, '2022-06-03 15:18:53'),
(27, 'MALGOOMS IN CHAPPATHI', 'MALGOOMS IN CHAPPATHI', 'مالغومز في تشاباثي', 'مالغومز في تشاباثي', 'http://zellarestaurants.com/system/api/uploads/parent_category/27/1654258777.jpg', 1, 15, 0, 0, 0, '2022-06-03 15:19:37'),
(28, 'PURE JUICES', 'PURE JUICES', 'عصائر نقية', 'عصائر نقية', 'http://zellarestaurants.com/system/api/uploads/parent_category/28/1654258831.jpg', 1, 26, 0, 0, 0, '2022-06-03 15:20:31'),
(29, 'JUICE COMBOS', 'JUICE COMBOS', 'مجموعات العصير', 'مجموعات العصير', 'http://zellarestaurants.com/system/api/uploads/parent_category/29/1654258856.jpg', 1, 28, 0, 0, 0, '2022-06-03 15:20:56'),
(30, 'CHOCOLATE MILK SHAKES', 'CHOCOLATE MILK SHAKES', 'مخفوق الحليب بالشوكولاتة', 'مخفوق الحليب بالشوكولاتة', 'http://zellarestaurants.com/system/api/uploads/parent_category/30/1654258886.jpg', 1, 29, 0, 0, 0, '2022-06-03 15:21:25'),
(31, 'MOJITOS & SPARKLINGS', 'MOJITOS & SPARKLINGS', 'موهيتوس وبريق', 'موهيتوس وبريق', 'http://zellarestaurants.com/system/api/uploads/parent_category/31/1654258930.jpg', 1, 30, 0, 0, 0, '2022-06-03 15:22:10'),
(32, 'ICE CREAMS & FRUITS SALADS', 'ICE CREAMS & FRUITS SALADS', 'سلطة الآيس كريم والفواكه', 'سلطة الآيس كريم والفواكه', 'http://zellarestaurants.com/system/api/uploads/parent_category/32/1654258987.jpg', 1, 31, 0, 0, 0, '2022-06-03 15:23:07'),
(33, 'CAKES & PASTRIES', 'CAKES & PASTRIES', 'الكيك والمعجنات', 'الكيك والمعجنات', 'http://zellarestaurants.com/system/api/uploads/parent_category/33/1654259016.jpg', 1, 32, 0, 0, 0, '2022-06-03 15:23:36'),
(34, 'TEA & COFEES', 'TEA & COFEES', 'TEA & COFEES', 'TEA & COFEES', 'http://zellarestaurants.com/system/api/uploads/parent_category/34/1654259041.jpg', 1, 34, 0, 0, 0, '2022-06-03 15:24:01');

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

--
-- Table structure for table `payment`
--

CREATE TABLE `payment` (
  `id` int(11) NOT NULL,
  `client_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `order_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `payment_id` varchar(255) NOT NULL,
  `operation_order_id` varchar(255) DEFAULT NULL,
  `result_indicator` varchar(255) DEFAULT NULL,
  `value` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `result` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `payment_type` varchar(255) NOT NULL,
  `date` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

--
-- Table structure for table `payment_methods`
--

CREATE TABLE `payment_methods` (
  `id` int(11) NOT NULL,
  `name_ar` text NOT NULL,
  `name_en` text NOT NULL,
  `display` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `payment_methods`
--

INSERT INTO `payment_methods` (`id`, `name_ar`, `name_en`, `display`) VALUES
(1, 'كاش', 'Cash', 1),
(2, 'ديبت كارد', 'Debit Card', 0),
(3, 'كريدت كارد', 'Credit Card', 0);

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

--
-- Table structure for table `popUp_imges`
--

CREATE TABLE `popUp_imges` (
  `id` int(11) NOT NULL,
  `type` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '1=>item & 2=>just image	',
  `parent_category_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `product_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `date_added` datetime DEFAULT current_timestamp(),
  `image` text DEFAULT NULL,
  `display` int(11) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `popUp_imges`
--

INSERT INTO `popUp_imges` (`id`, `type`, `parent_category_id`, `product_id`, `date_added`, `image`, `display`) VALUES
(14, '1', '7', '73', '2022-05-30 17:10:10', 'http://firstlookbh.com/system/api/uploads/popUp_imges/14/1658350919.jpg', 1);

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

--
-- Table structure for table `privacy_police`
--

CREATE TABLE `privacy_police` (
  `id` int(11) NOT NULL,
  `title` text NOT NULL,
  `title_en` text CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `privacy_police`
--

INSERT INTO `privacy_police` (`id`, `title`, `title_en`) VALUES
(1, 'في حالة وجود أي مشكلة فنية في التطبيق برجاء الإتصال على الرقم التالي', 'In case of any technical problem in the application please contact the following number');

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

--
-- Table structure for table `regions`
--

CREATE TABLE `regions` (
  `region_id` int(11) NOT NULL,
  `region_name_ar` varchar(255) NOT NULL,
  `region_name_en` varchar(255) NOT NULL,
  `charge` varchar(255) NOT NULL,
  `min_order` varchar(255) NOT NULL,
  `order_period` varchar(255) NOT NULL,
  `display` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `regions`
--

INSERT INTO `regions` (`region_id`, `region_name_ar`, `region_name_en`, `charge`, `min_order`, `order_period`, `display`) VALUES
(1, 'العكر', ' Al Eker', '1', '6.3', '180', 1),
(3, 'القدم', 'Al Qadam', '0.750', '6.3', '180', 1),
(4, 'القرية', 'Al Qurayah', '0.75', '6.3', '180', 1),
(5, 'القضيبية', 'Qudaibiya', '1', '6.3', '180', 1),
(6, 'قلالي', 'Qalali', '1', '6.3', '180', 1),
(7, 'القلعة', 'Al Qalah', '1', '6.3', '180', 1),
(8, 'كرانة', 'Karranah', '0.750', '6.3', '180', 1),
(9, 'الحجر', 'Al Hajar', '0.750', '6.3', '180', 1),
(10, 'كرباباد', 'Karbabad', '0.750', '6.3', '180', 1),
(11, 'كرزكان', 'Karzakan', '1', '6.3', '180', 1),
(12, 'الماحوز', 'Mahooz', '1', '6', '180', 1),
(13, 'المالكية', 'Malkiah', '1', '6', '180', 1),
(15, 'مدينة زايد', 'Zayed Town', '1', '6.3', '180', 1),
(16, 'مدينة عيسى', 'Isa Town', '1', '6.3', '180', 1),
(17, 'المحرق', 'Al Muharraq', '1', '6.3', '180', 1),
(18, 'مقابة', 'Maqabah', '0.750', '6.3', '180', 1),
(19, 'المقشع', 'Al Maqsha', '0.750', '6.3', '180', 1),
(20, 'المنامة', 'Manama', '1', '6.3', '180', 1),
(21, 'النبيه صالح', 'Nabih Saleh', '1', '6.3', '180', 1),
(22, 'النعيم', 'Alnaim', '1', '6.3', '45', 1),
(23, 'النويدرات', 'Nuwaidrat', '1', '6.3', '180', 1),
(24, 'الهملة', 'Al Hamala', '1', '6.3', '180', 1),
(25, 'البلاد القديم', 'Bilad Al Qadeem', '0.750', '6.3', '180', 1),
(26, 'الكورة', 'Kawarah', '1', '6.3', '180', 1),
(27, 'سلماباد', 'Salmabad', '1', '6.3', '180', 1),
(28, 'أبو صيبع', 'Abu Saiba', '0.750', '6.3', '180', 1),
(29, 'أبوقوة', 'Bu Quwah', '0.750', '6.3', '180', 1),
(30, 'أم الحصم', 'Umm Al Hassam', '1', '6.3', '180', 1),
(31, 'المصلي', 'Al Musalla', '0.750', '6.3', '180', 1),
(32, 'توبلي', 'Tubli', '1', '6.3', '180', 1),
(33, 'باربار', 'Barbar', '0.750', '6.3', '180', 1),
(34, 'البديع', 'Budaiya', '0.750', '6.3', '180', 1),
(35, 'البسيتين', 'Busaiten', '1', '6.3', '180', 1),
(36, 'بوكوارة', 'Bu Kowarah', '1', '6.3', '180', 1),
(37, 'البحير', 'Al Bahair', '1', '6.3', '180', 1),
(38, 'بني جمرة', 'Bani Jamra', '0.750', '6.3', '180', 1),
(39, 'بوري', 'Buri', '1', '6.3', '180', 1),
(40, 'جبلة حبشي', 'Jeblat Hebshi', '0.750', '6.3', '180', 1),
(41, 'جد الحاج', 'Jid Al Haj', '1', '6.3', '180', 1),
(42, 'جد حفص', 'Jidhafs', '0.750', '6.3', '180', 1),
(43, 'جد علي', 'Jid Ali', '1', '6.3', '180', 1),
(44, 'جرداب', 'Jurdab', '1', '6.3', '180', 1),
(47, 'الجفير', 'AlJuffair', '1', '6.3', '180', 1),
(48, 'الجنبية', 'Aljanabiya', '1', '6.3', '80', 1),
(49, 'جنوسان', 'Jannusan', '0.750', '6.3', '180', 1),
(50, 'جو', 'Jaw', '2', '6.3', '180', 1),
(51, 'الحد', 'AL Hidd', '1', '6.3', '180', 1),
(52, 'الحجيات', 'Alhajiyat', '1', '6.3', '180', 1),
(53, 'حلة العبد الصالح', 'Hillat Abdul Saleh', '0.750', '6.3', '180', 1),
(54, 'الحورة', 'Al Hoora', '1', '6.3', '180', 1),
(55, 'الخميس', 'Khamis', '1', '6.3', '180', 1),
(56, 'دار كليب', 'Dar Kulaib', '1', '6.3', '180', 1),
(57, 'المنطقة الدبلوماسية', 'Diplomatic Area', '1', '6.3', '180', 1),
(58, 'الدراز', 'Diraz', '0.750', '6.3', '180', 1),
(59, 'دمستان', 'Dimstan', '1.5', '6.3', '180', 1),
(60, 'الدير', 'Aldair', '1', '6.3', '180', 1),
(61, 'الديه', 'Daih', '0.750', '6.3', '180', 1),
(62, 'رأس رمان', 'Ras Rumman', '1', '6.3', '180', 1),
(64, 'الرفاع', ' Riffa', '1', '6.3', '180', 1),
(66, 'الزنج', 'Zinj', '1', '6.3', '180', 1),
(67, 'السقية', 'AL SAGYAH', '1', '6.3', '180', 1),
(68, 'سار', 'Saar', '1', '6.3', '180', 1),
(69, 'سترة', 'sitra', '1', '6.3', '180', 1),
(70, 'سماهيج', 'Samaheej', '1', '6.3', '180', 1),
(71, 'السنابس', 'Sanabis', '0.750', '6.3', '180', 1),
(72, 'سند', 'Sanad', '1', '6.3', '180', 1),
(73, 'السهلة ', 'Sehla', '0.750', '6.3', '180', 1),
(74, 'ضاحية السيف', 'seef', '1', '6.3', '180', 1),
(75, 'الشاخورة', 'Shakhurah', '0.750', '6.3', '180', 1),
(76, 'شهركان', 'Sharakan', '1', '6.3', '180', 1),
(78, 'الصالحية', 'Salihiya', '1', '6.3', '180', 1),
(80, 'عالي', 'Aali', '1', '6.3', '180', 1),
(81, 'العدلية', 'Adliya', '1', '6.3', '180', 1),
(83, 'عراد', 'Arad', '1', '6.3', '180', 1),
(84, 'عسكر', 'askr', '1.5', '6.3', '180', 1),
(85, 'مدينة حمد ', 'Hamad Town ', '1', '6.3', '180', 1),
(87, 'جزر أمواج', 'Amwaj Island', '2', '6.3', '180', 1),
(88, 'دلمونيا', 'Dilmunia', '2', '6.3', '240', 0),
(89, 'الدرة', 'durrat al bahrain', '2', '6.3', '240', 0),
(90, 'عذاري', 'adhari', '1', '6.3', '180', 1),
(91, 'الجسرة', 'Aljasra', '1', '6.3', '180', 1),
(92, 'الزلاق', 'Zallaq', '2', '6.3', '240', 0),
(93, 'سافرة', 'safra', '1', '6.3', '180', 1),
(94, 'صدد', 'sadad', '1', '6.3', '180', 1),
(95, 'عوالي', 'Awaali', '1', '6.3', '180', 1),
(96, 'معامير', 'maameer', '1', '6.3', '180', 1),
(97, 'بو غزال', 'Bu ghazal', '1', '6.3', '180', 1),
(98, 'بو عشيرة', 'Bu ashira', '1', '6.3', '180', 1),
(99, 'السلمانية', 'Salmaniya', '1', '6.3', '180', 1),
(100, 'البرهامة', 'Alburhama', '1', '6.3', '180', 1),
(101, 'مدينة سلمان', 'Salman town', '1', '6.3', '180', 1),
(102, 'الحلة', 'Alhilla', '0.750', '6.3', '180', 1),
(103, 'الناصفة', 'Alnasfa', '1', '6.3', '240', 1),
(104, 'ديار المحرق', 'Diyar Almuharaq', '2', '6.3', '240', 1),
(105, 'اللوزي', 'Al lozi', '1', '6.3', '240', 1),
(106, 'الغريفة', 'Alghuraifa', '1', '6.3', '240', 1),
(107, 'السهلة الشمالية', 'North Sehla', '0.750', '6', '180', 1),
(108, 'عين الدار', 'Ain aldar', '0.750', '6.3', '180', 1);

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

--
-- Table structure for table `removes`
--

CREATE TABLE `removes` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `title_ar` varchar(255) NOT NULL,
  `sub_category_id` int(11) NOT NULL,
  `date` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `setting`
--

CREATE TABLE `setting` (
  `id` int(11) NOT NULL,
  `accept_orders` int(11) NOT NULL,
  `colse_delivery` int(11) NOT NULL DEFAULT 0,
  `close_charge` int(11) NOT NULL,
  `discount` int(11) NOT NULL,
  `discount_percentage` int(255) NOT NULL,
  `branch_id` varchar(255) NOT NULL,
  `vat` int(11) NOT NULL,
  `complains_email` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '',
  `orders_email` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '',
  `calendar_start` int(11) NOT NULL,
  `android_version` varchar(255) NOT NULL,
  `ios_version` varchar(255) NOT NULL,
  `opening_time` time NOT NULL DEFAULT '10:00:00',
  `closing_time` time NOT NULL DEFAULT '22:00:00',
  `ios_link` varchar(255) NOT NULL,
  `android_link` varchar(255) NOT NULL,
  `main_color` varchar(100) NOT NULL,
  `hover_color` varchar(100) NOT NULL,
  `copyright_name` varchar(255) NOT NULL,
  `copyright_link` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `setting`
--

INSERT INTO `setting` (`id`, `accept_orders`, `colse_delivery`, `close_charge`, `discount`, `discount_percentage`, `branch_id`, `vat`, `complains_email`, `orders_email`, `calendar_start`, `android_version`, `ios_version`, `opening_time`, `closing_time`, `ios_link`, `android_link`, `main_color`, `hover_color`, `copyright_name`, `copyright_link`) VALUES
(1, 1, 1, 1, 0, 0, '1', 10, 'info@emcan-group.com', 'info@emcan-group.com', 4, '1.23', '1.0', '09:30:00', '21:30:00', '#', '#', '#C4904E', '#C74640', 'Emcan', 'https://www.instagram.com/emcan_solutions/');

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

--
-- Table structure for table `sides`
--

CREATE TABLE `sides` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `title_ar` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `slider`
--

CREATE TABLE `slider` (
  `id` int(11) NOT NULL,
  `type` int(11) NOT NULL DEFAULT 1 COMMENT '1=>item & 2=>just image	',
  `parent_category_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `display` int(11) NOT NULL DEFAULT 1,
  `date_added` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `slider`
--

INSERT INTO `slider` (`id`, `type`, `parent_category_id`, `product_id`, `image`, `display`, `date_added`) VALUES
(1, 2, 0, 0, 'http://zellarestaurants.com/system/api/uploads/slider/1/1654193372.jpg', 1, '2022-05-18 16:39:18'),
(2, 2, 0, 0, 'http://zellarestaurants.com/system/api/uploads/slider/2/1654193273.jpg', 1, '2022-05-18 16:39:25'),
(3, 2, 0, 0, 'http://zellarestaurants.com/system/api/uploads/slider/3/1653742534.jpg', 1, '2022-05-28 15:55:34'),
(6, 0, 0, 0, 'http://zellarestaurants.com/system/api/uploads/slider/6/1654290152.jpg', 1, '2022-06-04 00:02:31'),
(7, 2, 0, 0, 'http://zellarestaurants.com/system/api/uploads/slider/7/1654293492.jpg', 1, '2022-06-04 00:58:11'),
(8, 0, 0, 0, 'http://zellarestaurants.com/system/api/uploads/slider/8/1654293535.jpg', 1, '2022-06-04 00:58:54'),
(9, 0, 0, 0, 'http://zellarestaurants.com/system/api/uploads/slider/9/1654447391.jpg', 1, '2022-06-05 19:43:11');

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

--
-- Table structure for table `sub_categories`
--

CREATE TABLE `sub_categories` (
  `sub_category_id` int(11) NOT NULL,
  `sub_category_name` varchar(255) NOT NULL,
  `sub_category_name_ar` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `sub_category_desc` text NOT NULL,
  `sub_category_desc_ar` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `sub_category_image` varchar(255) DEFAULT '',
  `parent_category_id` int(11) NOT NULL,
  `discount_type` int(11) NOT NULL DEFAULT 0,
  `discount` int(11) NOT NULL DEFAULT 0,
  `discount_percentage` varchar(255) DEFAULT NULL,
  `date_from` varchar(255) DEFAULT NULL,
  `date_to` varchar(255) DEFAULT NULL,
  `display` int(255) NOT NULL,
  `date` varchar(255) NOT NULL,
  `arrangement` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `sub_categories`
--

INSERT INTO `sub_categories` (`sub_category_id`, `sub_category_name`, `sub_category_name_ar`, `sub_category_desc`, `sub_category_desc_ar`, `sub_category_image`, `parent_category_id`, `discount_type`, `discount`, `discount_percentage`, `date_from`, `date_to`, `display`, `date`, `arrangement`) VALUES
(1, 'CREAM OF MUSHROOM SOUP', 'CREAM OF MUSHROOM SOUP', 'CREAM OF MUSHROOM SOUP', 'CREAM OF MUSHROOM SOUP', 'http://zellarestaurants.com/system/api/uploads/sub_category/1/1653749090.jpg', 1, 0, 0, '', '', '', 1, '', 0),
(2, 'CREAM OF CHICKEN SOUP', 'شوربة كريمة الدجاج', 'CREAM OF CHICKEN SOUP', 'CREAM OF CHICKEN SOUP', 'http://zellarestaurants.com/system/api/uploads/sub_category/2/1653749185.jpg', 1, 0, 0, '', '', '', 1, '', 0),
(3, 'CREAM OF BROCCOLI SOUP', 'CREAM OF BROCCOLI SOUP', 'CREAM OF BROCCOLI SOUP', 'CREAM OF BROCCOLI SOUP', 'http://zellarestaurants.com/system/api/uploads/sub_category/3/1654289317.jpg', 1, 0, 0, '', '', '', 1, '', 0),
(4, 'MIX SEAFOOD SOUP', 'شوربة المأكولات البحرية المختلطة', 'MIX SEAFOOD SOUP', 'MIX SEAFOOD SOUP', '', 1, 0, 0, '', '', '', 1, '', 0),
(5, 'LENTIL SOUP', 'شوربة العدس', 'LENTIL SOUP', 'LENTIL SOUP', 'http://zellarestaurants.com/system/api/uploads/sub_category/5/1653749816.jpg', 1, 0, 0, '', '', '', 1, '', 0),
(6, 'CHICKEN CORN SOUP', 'شوربة ذرة الدجاج', 'CHICKEN CORN SOUP', 'CHICKEN CORN SOUP', 'http://zellarestaurants.com/system/api/uploads/sub_category/6/1653749751.jpg', 1, 0, 0, '', '', '', 1, '', 0),
(7, 'TOM YUM SOUP', 'شوربة توم يام', 'TOM YUM SOUP', 'TOM YUM SOUP', 'http://zellarestaurants.com/system/api/uploads/sub_category/7/1653743593.jpg', 1, 0, 0, '', '', '', 1, '', 0),
(8, 'CHICKEN CAESAR SALAD', 'سلطة سيزر بالدجاج', 'CHICKEN CAESAR SALAD', 'CHICKEN CAESAR SALAD', 'http://zellarestaurants.com/system/api/uploads/sub_category/8/1653752292.jpg', 2, 0, 0, '', '', '', 1, '', 0),
(9, 'CRAB AND SHRIMP SALAD', ' سلطة الروبيان والسلطعون', 'CRAB AND SHRIMP SALAD', 'CRAB AND SHRIMP SALAD', 'http://zellarestaurants.com/system/api/uploads/sub_category/9/1653752267.jpg', 2, 0, 0, '', '', '', 1, '', 0),
(10, 'GRILLED CHICKEN SALAD', 'سلطة الدجاج المشوي', 'GRILLED CHICKEN SALAD', 'GRILLED CHICKEN SALAD', 'http://zellarestaurants.com/system/api/uploads/sub_category/10/1653752235.jpg', 2, 0, 0, '', '', '', 1, '', 0),
(11, 'GREEK SALAD', 'سلطة يونانية', 'GREEK SALAD', 'GREEK SALAD', 'http://zellarestaurants.com/system/api/uploads/sub_category/11/1653752208.jpg', 2, 0, 0, '', '', '', 1, '', 0),
(12, 'QUINOA AVOCADO SALAD', 'كينوا أفوكادو سلطة', 'QUINOA AVOCADO SALAD', 'QUINOA AVOCADO SALAD', 'http://zellarestaurants.com/system/api/uploads/sub_category/12/1653752176.jpg', 2, 0, 0, '', '', '', 1, '', 0),
(13, 'ROCCA SALAD', 'سلطة الجرجير', 'ROCCA SALAD', 'ROCCA SALAD', 'http://zellarestaurants.com/system/api/uploads/sub_category/13/1653752147.jpg', 2, 0, 0, '', '', '', 1, '', 0),
(14, 'GREEN SALAD', 'سلطة خضراء', 'GREEN SALAD', 'GREEN SALAD', 'http://zellarestaurants.com/system/api/uploads/sub_category/14/1653752101.jpg', 2, 0, 0, '', '', '', 1, '', 0),
(15, 'HAWAIIAN PESTO SALAD', 'سلطة هاويان بيستو', 'HAWAIIAN PESTO SALAD', 'HAWAIIAN PESTO SALAD', 'http://zellarestaurants.com/system/api/uploads/sub_category/15/1653752066.jpg', 2, 0, 0, '', '', '', 1, '', 0),
(16, 'MIX SEAFOOD GARDEN SALAD', 'مزيج سلطة المأكولات البحرية', 'MIX SEAFOOD GARDEN SALAD', 'MIX SEAFOOD GARDEN SALAD', 'http://zellarestaurants.com/system/api/uploads/sub_category/16/1653752035.jpg', 2, 0, 0, '', '', '', 1, '', 0),
(17, 'COLD MEZZE PLATTER', 'صحن مقبلات بارد', 'COLD MEZZE PLATTER', 'COLD MEZZE PLATTER', 'http://zellarestaurants.com/system/api/uploads/sub_category/17/1654161500.jpg', 3, 0, 0, '', '', '', 1, '', 0),
(18, 'HOT MEZZE PLATTER', 'طبق المقبلات الساخنة', 'HOT MEZZE PLATTER', 'HOT MEZZE PLATTER', 'http://zellarestaurants.com/system/api/uploads/sub_category/18/1654161467.jpg', 3, 0, 0, '', '', '', 1, '', 0),
(19, 'CRISPY PRAWN', 'الجمبري المقرمش', 'CRISPY PRAWN', 'CRISPY PRAWN', 'http://zellarestaurants.com/system/api/uploads/sub_category/19/1654161429.jpg', 3, 0, 0, '', '', '', 1, '', 0),
(20, 'CRISPY CHICKEN', 'دجاج مقرمش', 'CRISPY CHICKEN', 'CRISPY CHICKEN', 'http://zellarestaurants.com/system/api/uploads/sub_category/20/1654161404.jpg', 3, 0, 0, '', '', '', 1, '', 0),
(21, 'CURLY FRIES', 'كورلي فرايز', 'CURLY FRIES', 'CURLY FRIES', 'http://zellarestaurants.com/system/api/uploads/sub_category/21/1654162533.jpg', 3, 0, 0, '', '', '', 1, '', 0),
(22, 'FRENCH FRIES', 'البطاطس المقلية', 'FRENCH FRIES', 'FRENCH FRIES', 'http://zellarestaurants.com/system/api/uploads/sub_category/22/1654161377.jpg', 3, 0, 0, '', '', '', 1, '', 0),
(23, 'GARLIC CHEESE BREAD', 'خبز جبن الثوم', 'GARLIC CHEESE BREAD', 'GARLIC CHEESE BREAD', '', 3, 0, 0, '', '', '', 1, '', 0),
(24, 'POTATO WEDGES', 'بطاطس ودجز', 'POTATO WEDGES', 'POTATO WEDGES', 'http://zellarestaurants.com/system/api/uploads/sub_category/24/1654161346.jpg', 3, 0, 0, '', '', '', 1, '', 0),
(25, 'HUMMUS', 'الحمص', 'HUMMUS', 'HUMMUS', 'http://zellarestaurants.com/system/api/uploads/sub_category/25/1654161319.jpg', 3, 0, 0, '', '', '', 1, '', 0),
(26, 'MUTABAL', 'متبل', 'MUTABAL', 'MUTABAL', 'http://zellarestaurants.com/system/api/uploads/sub_category/26/1654161293.jpg', 3, 0, 0, '', '', '', 1, '', 0),
(27, 'BABA GANOUSH', 'بابا غنوج', 'BABA GANOUSH', 'BABA GANOUSH', 'http://zellarestaurants.com/system/api/uploads/sub_category/27/1654161266.jpg', 3, 0, 0, '', '', '', 1, '', 0),
(28, 'MOZZARELLA STICK', 'أصابع الموزاريلا', 'MOZZARELLA STICK', 'MOZZARELLA STICK', '', 3, 0, 0, '', '', '', 1, '', 0),
(29, 'CALAMARI RING SPECIAL', 'حلقات كالاماري خاص', 'CALAMARI RING SPECIAL', 'CALAMARI RING SPECIAL', 'http://zellarestaurants.com/system/api/uploads/sub_category/29/1654161233.jpg', 3, 0, 0, '', '', '', 1, '', 0),
(30, 'MIX FRIES', 'ميكس فرايز', 'MIX FRIES', 'MIX FRIES', '', 3, 0, 0, '', '', '', 1, '', 0),
(31, 'ONION RING', 'حلقات البصل', 'ONION RING', 'ONION RING', '', 3, 0, 0, '', '', '', 1, '', 0),
(32, 'CHICKEN POPCORN', 'فشار دجاج', 'CHICKEN POPCORN', 'CHICKEN POPCORN', '', 3, 0, 0, '', '', '', 1, '', 0),
(33, 'CHICKEN DIJON IN MUSHROOM', 'دجاج ديجون بالفطر', 'CHICKEN DIJON IN MUSHROOM', 'CHICKEN DIJON IN MUSHROOM', '', 4, 0, 0, '', '', '', 1, '', 0),
(34, 'CHICKEN KIEV IN CREAMY SAUCE', 'كيف الدجاج بصلصة كريمية', 'Pieces of tender chicken that are pounded, seasoned in spiced crumbs and fried until they are golden brown. Served with mashed potatoes and creamy mushroom sauce, this fabulous dish is undoubtedly an all-time favourite.', 'قطع من الدجاج الطري ، متبلة بفتات البقسماط ومقلية حتى يصبح لونها بنيا ذهبيا. يُقدم مع البطاطس المهروسة وصلصة الفطر الكريمية ، وهذا الطبق الرائع بلا شك هو المفضل على الإطلاق.', 'http://zellarestaurants.com/system/api/uploads/sub_category/34/1654280400.jpg', 4, 0, 0, '', '', '', 1, '', 0),
(35, 'CHICKEN STROGANOFF', ' دجاج ستروجانوف', 'CHICKEN STROGANOFF', 'CHICKEN STROGANOFF', '', 4, 0, 0, '', '', '', 1, '', 0),
(36, 'CHICKEN SIZZLING', 'سيزلنج الدجاج', 'CHICKEN SIZZLING', 'CHICKEN SIZZLING', '', 4, 0, 0, '', '', '', 1, '', 0),
(37, 'CHICKEN CHILLI', 'دجاج بالفلفل الحار', 'CHICKEN CHILLI', 'CHICKEN CHILLI', '', 4, 0, 0, '', '', '', 1, '', 0),
(38, 'CHICKEN MAKHANI', 'دجاج مخاني', 'CHICKEN MAKHANI', 'CHICKEN MAKHANI', '', 4, 0, 0, '', '', '', 1, '', 0),
(39, 'BUTTER CHICKEN', 'دجاج الزبدة', 'BUTTER CHICKEN', 'BUTTER CHICKEN', '', 4, 0, 0, '', '', '', 1, '', 0),
(40, 'MOROCCAN CHICKEN', 'الدجاج المغربي', 'MOROCCAN CHICKEN', 'MOROCCAN CHICKEN', '', 4, 0, 0, '', '', '', 1, '', 0),
(41, 'GRILLED CHICKEN STEAK', 'ستيك دجاج مشوي', 'GRILLED CHICKEN STEAK', 'GRILLED CHICKEN STEAK', '', 4, 0, 0, '', '', '', 1, '', 0),
(42, 'CHICKEN RISOTTO', 'ريزوتو الدجاج', 'CHICKEN RISOTTO', 'CHICKEN RISOTTO', '', 4, 0, 0, '', '', '', 1, '', 0),
(43, 'CHICKEN PICCATA', 'بيكاتا الدجاج', 'CHICKEN PICCATA', 'CHICKEN PICCATA', '', 4, 0, 0, '', '', '', 1, '', 0),
(44, 'CHICKEN ASPARAGUS CITRON', 'دجاج اسبراجوس سيترون', 'CHICKEN ASPARAGUS CITRON', 'CHICKEN ASPARAGUS CITRON', '', 4, 0, 0, '', '', '', 1, '', 0),
(45, 'SALMON RISOTTO', 'ريزوتو السلمون', 'SALMON RISOTTO', 'SALMON RISOTTO', '', 5, 0, 0, '', '', '', 1, '', 0),
(46, 'SALMON SESAME', 'سمك السلمون السمسم', 'SALMON SESAME', 'SALMON SESAME', '', 5, 0, 0, '', '', '', 1, '', 0),
(47, 'SPICY PRAWN', 'قرديس حار', 'SPICY PRAWN', 'SPICY PRAWN', '', 5, 0, 0, '', '', '', 1, '', 0),
(48, 'CHILI HAMMOUR', 'هامور حار', 'CHILI HAMMOUR', 'CHILI HAMMOUR', '', 5, 0, 0, '', '', '', 1, '', 0),
(49, 'SEAFOOD RISOTTO', 'ريستو المأكولات البحرية', 'SEAFOOD RISOTTO', 'SEAFOOD RISOTTO', '', 5, 0, 0, '', '', '', 1, '', 0),
(50, 'PRAWN SIZZLING', 'سيزلنج الجمبري', 'PRAWN SIZZLING', 'PRAWN SIZZLING', '', 5, 0, 0, '', '', '', 1, '', 0),
(51, 'HAMMOUR SIZZLING', 'سيزلنج هامور', 'HAMMOUR SIZZLING', 'HAMMOUR SIZZLING', '', 5, 0, 0, '', '', '', 1, '', 0),
(52, 'SAFFRON PRAWN', 'جمبري الزعفران', 'SAFFRON PRAWN', 'SAFFRON PRAWN', '', 5, 0, 0, '', '', '', 1, '', 0),
(53, 'HAMMOUR RATATOUILLE', 'هامور راتاتويل', 'HAMMOUR RATATOUILLE', 'HAMMOUR RATATOUILLE', '', 5, 0, 0, '', '', '', 1, '', 0),
(54, 'HAMMOUR CITRON', 'هامور سيترون', 'HAMMOUR CITRON', 'HAMMOUR CITRON', '', 5, 0, 0, '', '', '', 1, '', 0),
(55, 'GARLIC PRAWN', 'قرديس الثوم', 'GARLIC PRAWN', 'GARLIC PRAWN', '', 5, 0, 0, '', '', '', 1, '', 0),
(56, 'LOBSTER GRILL', 'لوبستر جريل', 'Classic fancy and incredibly delicious grilled lobster stuffed with chedddar cheese for luxorious feast.Served with creamy risotto.', 'لوبستر كلاسيكي فاخر ولذيذ بشكل لا يصدق محشو بجبنة الشيدر لوليمة فاخرة يقدم مع أرز كريمي.', 'http://zellarestaurants.com/system/api/uploads/sub_category/56/1654161587.jpg', 5, 0, 0, '', '', '', 1, '', 0),
(57, 'LOBSTER WITH SALAD', 'لوبستر مع سلطة', 'Arranged on lettuce leaves with avocado wedges, fresh off-the boat lobster flavored in healthy spices resulting in a luxurious and refereshing meal.', 'مرتبة على أوراق الخس مع أسافين الأفوكادو وجراد البحر الطازج المنكه في التوابل الصحية مما ينتج عنه وجبة فاخرة ومرجعية.', 'http://zellarestaurants.com/system/api/uploads/sub_category/57/1654161563.jpg', 5, 0, 0, '', '', '', 1, '', 0),
(58, 'TENDERLOIN STEAK', 'تندرلوين ستيك', 'TENDERLOIN STEAK', 'TENDERLOIN STEAK', '', 6, 0, 0, '', '', '', 1, '', 0),
(59, 'SPICY BEEF', 'لحم بقري حاري', 'SPICY BEEF', 'SPICY BEEF', '', 6, 0, 0, '', '', '', 1, '', 0),
(60, 'BEEF STROGANOFF', 'ستروجانوف لحم', 'BEEF STROGANOFF', 'BEEF STROGANOFF', '', 6, 0, 0, '', '', '', 1, '', 0),
(61, 'BEEF PICCATA', 'بيكاتا لحم البقر', 'BEEF PICCATA', 'BEEF PICCATA', '', 6, 0, 0, '', '', '', 1, '', 0),
(62, 'BEEF SIZZLING', 'سيزلنج اللحم البقري', 'BEEF SIZZLING', 'BEEF SIZZLING', '', 6, 0, 0, '', '', '', 1, '', 0),
(63, 'BEEF TERIYAKI', 'ترياكي لحم بقري', 'BEEF TERIYAKI', 'BEEF TERIYAKI', '', 6, 0, 0, '', '', '', 1, '', 0),
(64, 'MUTTON ROGAN', 'MUTTON ROGAN', 'MUTTON ROGAN', 'MUTTON ROGAN', 'http://zellarestaurants.com/system/api/uploads/sub_category/64/1654118654.jpg', 6, 0, 0, '', '', '', 1, '', 0),
(65, 'MUTTON MASALA', 'موتون لحم الشاة', 'MUTTON MASALA', 'MUTTON MASALA', 'http://zellarestaurants.com/system/api/uploads/sub_category/65/1654118566.jpg', 6, 0, 0, '', '', '', 1, '', 0),
(66, 'MUTTON SALONA', 'صالون لحم الشاة', 'MUTTON SALONA', 'MUTTON SALONA', 'http://zellarestaurants.com/system/api/uploads/sub_category/66/1654338988.jpg', 6, 0, 0, '', '', '', 1, '', 0),
(67, 'MIX GRILL', 'مشاوي مختلطة', 'MIX GRILL', 'MIX GRILL', '', 7, 0, 0, '', '', '', 1, '', 0),
(68, 'LAMB CHOP', 'فرم لحم ضاني', 'LAMB CHOP', 'LAMB CHOP', '', 7, 0, 0, '', '', '', 1, '', 0),
(69, 'CHICKEN TIKKA', 'دجاج تيكا', 'CHICKEN TIKKA', 'CHICKEN TIKKA', '', 7, 0, 0, '', '', '', 1, '', 0),
(70, 'LEMON TIKKA', 'ليمون تكا', 'LEMON TIKKA', 'LEMON TIKKA', '', 7, 0, 0, '', '', '', 1, '', 0),
(71, 'MEAT KEBAB', 'كباب لحم', 'MEAT KEBAB', 'MEAT KEBAB', '', 7, 0, 0, '', '', '', 1, '', 0),
(72, 'CHICKEN KEBAB', 'كباب دجاج', 'CHICKEN KEBAB', 'CHICKEN KEBAB', '', 7, 0, 0, '', '', '', 1, '', 0),
(73, 'ARRAYES', 'ارايس', 'ARRAYES', 'ARRAYES', '', 7, 0, 0, '', '', '', 1, '', 0),
(74, 'SHISH TAWOOK', 'شيش طاوق', 'SHISH TAWOOK', 'SHISH TAWOOK', '', 8, 0, 0, '', '', '', 1, '', 0),
(75, 'FULL CHICKEN GRILL', 'فرخة كاملة مشوية', 'FULL CHICKEN GRILL', 'FULL CHICKEN GRILL', '', 8, 0, 0, '', '', '', 1, '', 0),
(76, 'HALF CHICKEN', 'نصف فرخة مشوية', 'HALF CHICKEN', 'HALF CHICKEN', 'http://zellarestaurants.com/system/api/uploads/sub_category/76/1654118451.jpg', 8, 0, 0, '', '', '', 1, '', 0),
(77, 'CHICKEN BIRYANI ZELLA SPECIAL', 'دجاج برياني زيلا خاص', 'CHICKEN BIRYANI ZELLA SPECIAL', 'CHICKEN BIRYANI ZELLA SPECIAL', '', 9, 0, 0, '', '', '', 1, '', 0),
(78, 'CHICKEN BIRYANI', 'دجاج برياني', 'CHICKEN BIRYANI', 'CHICKEN BIRYANI', 'http://zellarestaurants.com/system/api/uploads/sub_category/78/1654164524.jpg', 9, 0, 0, '', '', '', 1, '', 0),
(79, 'CHICKEN MAJBOOS', 'دجاج مجبوس ', 'CHICKEN MAJBOOS', 'CHICKEN MAJBOOS', 'http://zellarestaurants.com/system/api/uploads/sub_category/79/1654163412.jpg', 9, 0, 0, '', '', '', 1, '', 0),
(80, 'CHICKEN MANDI', 'دجاج ماندي', 'CHICKEN MANDI', 'CHICKEN MANDI', '', 9, 0, 0, '', '', '', 1, '', 0),
(81, 'CHICKEN OUZY', 'دجاج قوزي', 'CHICKEN OUZY', 'CHICKEN OUZY', '', 9, 0, 0, '', '', '', 1, '', 0),
(82, 'CHICKEN MATHGOOT', 'دجاج ماثجوت', 'CHICKEN MATHGOOT', 'CHICKEN MATHGOOT', 'http://zellarestaurants.com/system/api/uploads/sub_category/82/1654163547.jpg', 9, 0, 0, '', '', '', 1, '', 0),
(83, 'CHICKEN KABSA', 'كبسة دجاج', 'CHICKEN KABSA', 'CHICKEN KABSA', '', 9, 0, 0, '', '', '', 1, '', 0),
(84, 'MUTTON BIRYANI SPECIAL', 'برياني لحم شاة خاص', 'MUTTON BIRYANI SPECIAL', 'MUTTON BIRYANI SPECIAL', '', 9, 0, 0, '', '', '', 1, '', 0),
(85, 'MUTTON BIRYANI', 'برياني لحم شاة', 'MUTTON BIRYANI', 'MUTTON BIRYANI', 'http://zellarestaurants.com/system/api/uploads/sub_category/85/1654163911.jpg', 9, 0, 0, '', '', '', 1, '', 0),
(86, 'MUTTON MAJBOOS', 'ماجبوس لحم شاة', 'MUTTON MAJBOOS', 'MUTTON MAJBOOS', 'http://zellarestaurants.com/system/api/uploads/sub_category/86/1654163884.jpg', 9, 0, 0, '', '', '', 1, '', 0),
(87, 'MUTTON MANDI', 'ماندي لحم شاة', 'MUTTON MANDI', 'MUTTON MANDI', '', 9, 0, 0, '', '', '', 1, '', 0),
(88, 'MUTTON OUZY', 'قوزي لحم شاة', 'MUTTON OUZY', 'MUTTON OUZY', 'http://zellarestaurants.com/system/api/uploads/sub_category/88/1654163841.jpg', 9, 0, 0, '', '', '', 1, '', 0),
(89, 'MUTTON KABSA', 'كبسة لحم شاة', 'MUTTON KABSA', 'MUTTON KABSA', 'http://zellarestaurants.com/system/api/uploads/sub_category/89/1654163817.jpg', 9, 0, 0, '', '', '', 1, '', 0),
(90, 'PRAWN BIRYANI', 'برياني قريدس', 'PRAWN BIRYANI', 'PRAWN BIRYANI', '', 9, 0, 0, '', '', '', 1, '', 0),
(91, 'FISH BIRIYANI', 'سمك البرياني', 'FISH BIRIYANI', 'FISH BIRIYANI', '', 9, 0, 0, '', '', '', 1, '', 0),
(92, 'FISH MAJBOOS', 'مجبوس السمك', 'FISH MAJBOOS', 'FISH MAJBOOS', '', 9, 0, 0, '', '', '', 1, '', 0),
(93, 'PRAWN MAJBOOS', 'مجبوس القريدس', 'PRAWN MAJBOOS', 'PRAWN MAJBOOS', '', 9, 0, 0, '', '', '', 1, '', 0),
(94, 'BIRYANI RICE', 'أرز برياني', 'BIRYANI RICE', 'BIRYANI RICE', '', 9, 0, 0, '', '', '', 1, '', 0),
(95, 'CHICKEN FRIED RICE', 'أرز مقلي بالدجاج', 'CHICKEN FRIED RICE', 'CHICKEN FRIED RICE', '', 9, 0, 0, '', '', '', 1, '', 0),
(96, 'VEGETABLE FRIED RICE', 'أرز مقلي بالخضار', 'VEGETABLE FRIED RICE', 'VEGETABLE FRIED RICE', '', 9, 0, 0, '', '', '', 1, '', 0),
(97, 'EGG FRIED RICE', 'أرز مقلي بالبيض', 'EGG FRIED RICE', 'EGG FRIED RICE', '', 9, 0, 0, '', '', '', 1, '', 0),
(98, 'STEAM RICE', 'رز تم تسويتة بالبخار', 'STEAM RICE', 'STEAM RICE', '', 9, 0, 0, '', '', '', 1, '', 0),
(99, 'BAHRAINI KUBOOS', 'كوبوس بحريني', 'BAHRAINI KUBOOS', 'BAHRAINI KUBOOS', '', 10, 0, 0, '', '', '', 1, '', 0),
(100, 'PLAIN NAN', 'بلين نان', 'PLAIN NAN', 'PLAIN NAN', '', 10, 0, 0, '', '', '', 1, '', 0),
(101, 'BUTTER NAAN', 'بتر نان', 'BUTTER NAAN', 'BUTTER NAAN', '', 10, 0, 0, '', '', '', 1, '', 0),
(102, 'CHEESE POROTTA', 'جبن بوروتا', 'CHEESE POROTTA', 'CHEESE POROTTA', '', 10, 0, 0, '', '', '', 1, '', 0),
(103, 'POTATO POROTTA', 'بطاطس بوروتا', 'POTATO POROTTA', 'POTATO POROTTA', '', 10, 0, 0, '', '', '', 1, '', 0),
(104, 'FETTUCCINE ALFREDO PASTA', 'فيتوشيني ألفريدو باستا', 'FETTUCCINE ALFREDO PASTA', 'FETTUCCINE ALFREDO PASTA', '', 11, 0, 0, '', '', '', 1, '', 0),
(105, 'PENNE ROSE PASTA', 'باستا بين روز', 'PENNE ROSE PASTA', 'PENNE ROSE PASTA', '', 11, 0, 0, '', '', '', 1, '', 0),
(106, 'SPAGHETTI BOLOGNESE PASTA', 'سباغيتي بوبونيز باستا', 'SPAGHETTI BOLOGNESE PASTA', 'SPAGHETTI BOLOGNESE PASTA', '', 11, 0, 0, '', '', '', 1, '', 0),
(107, 'MIX SEAFOOD PASTA', 'باستا مزيج المأكولات البحرية ', 'MIX SEAFOOD PASTA', 'MIX SEAFOOD PASTA', '', 11, 0, 0, '', '', '', 1, '', 0),
(108, 'ARRABBIATA PENNE PASTA', 'ارابياتا بيني باستا', 'ARRABBIATA PENNE PASTA', 'ARRABBIATA PENNE PASTA', '', 11, 0, 0, '', '', '', 1, '', 0),
(109, 'CHICKEN PASTA', 'باستا الدجاج', 'CHICKEN PASTA', 'CHICKEN PASTA', '', 11, 0, 0, '', '', '', 1, '', 0),
(110, 'VEGETABLE PASTA', 'باستا نباتية', 'VEGETABLE PASTA', 'VEGETABLE PASTA', '', 11, 0, 0, '', '', '', 1, '', 0),
(111, 'SAUSAGE PASTA', 'باستا سجق', 'SAUSAGE PASTA', 'SAUSAGE PASTA', '', 11, 0, 0, '', '', '', 1, '', 0),
(112, 'VEG + SAUSAGE MIX PASTA', 'باستا خضار + سجق', 'VEG + SAUSAGE MIX PASTA', 'VEG + SAUSAGE MIX PASTA', '', 11, 0, 0, '', '', '', 1, '', 0),
(113, 'SEAFOOD LINGUINE PASTA', 'الباستا الطويلة للمأكولات البحرية', 'SEAFOOD LINGUINE PASTA', 'SEAFOOD LINGUINE PASTA', '', 11, 0, 0, '', '', '', 1, '', 0),
(114, 'MIX SPAGHETTI PASTA', 'مزيج اسباغتي وباستا', 'MIX SPAGHETTI PASTA', 'MIX SPAGHETTI PASTA', '', 11, 0, 0, '', '', '', 1, '', 0),
(115, 'BROASTED CHICKEN 20 PCS', 'دجاج بروستد  20 قطعة', 'BROASTED CHICKEN 20 PCS', 'BROASTED CHICKEN 20 PCS', '', 12, 0, 0, '', '', '', 1, '', 0),
(116, 'BROASTED CHICKEN 16 PCS', 'دجاج بروستد  16 قطعة', 'BROASTED CHICKEN 16 PCS', 'BROASTED CHICKEN 16 PCS', '', 12, 0, 0, '', '', '', 1, '', 0),
(117, 'BROASTED CHICKEN 12 PCS', 'دجاج بروستد  12 قطعة', 'BROASTED CHICKEN 12 PCS', 'BROASTED CHICKEN 12 PCS', '', 12, 0, 0, '', '', '', 1, '', 0),
(118, 'BROASTED CHICKEN 8 PCS', 'دجاج بروستد  8 قطعة', 'BROASTED CHICKEN 8 PCS', 'BROASTED CHICKEN 8 PCS', '', 12, 0, 0, '', '', '', 1, '', 0),
(119, 'BROASTED CHICKEN 6 PCS', 'دجاج بروستد  6 قطعة', 'BROASTED CHICKEN 6 PCS', 'BROASTED CHICKEN 6 PCS', '', 12, 0, 0, '', '', '', 1, '', 0),
(120, 'BROASTED CHICKEN 4 PCS', 'دجاج بروستد  4 قطعة', 'BROASTED CHICKEN 4 PCS', 'BROASTED CHICKEN 4 PCS', '', 12, 0, 0, '', '', '', 1, '', 0),
(121, 'BROASTED CHICKEN 2 PCS', 'دجاج بروستد  2 قطعة', 'BROASTED CHICKEN 2 PCS', 'BROASTED CHICKEN 2 PCS', '', 12, 0, 0, '', '', '', 1, '', 0),
(122, 'CHICKEN NUGGETS 8 PcS', 'CHICKEN NUGGETS 8 PcS', 'CHICKEN NUGGETS 8 PcS', 'CHICKEN NUGGETS 8 PcS', '', 12, 0, 0, NULL, NULL, NULL, 1, '', 0),
(123, 'CHICKEN NUGGETS MEAL ( 12 Pcs )', 'وجبة دجاج ناجتس (12 قطعة)', 'CHICKEN NUGGETS MEAL ( 12 Pcs )', 'CHICKEN NUGGETS MEAL ( 12 Pcs )', '', 12, 0, 0, '', '', '', 1, '', 0),
(124, 'FISH FILLET 8 Pcs', 'فيليه سمك 8 قطع', 'FISH FILLET 8 Pcs', 'FISH FILLET 8 Pcs', '', 12, 0, 0, '', '', '', 1, '', 0),
(125, 'FISH FILLET MEAL 12 Pcs', 'وجبة سمك فيليه 12 قطعة', 'FISH FILLET MEAL 12 Pcs', 'FISH FILLET MEAL 12 Pcs', '', 12, 0, 0, '', '', '', 1, '', 0),
(126, 'GOOD MORNING ZELLA BREAKFAST SET', 'مجموعة فطور زيلا جود مورنج', 'GOOD MORNING ZELLA BREAKFAST SET', 'GOOD MORNING ZELLA BREAKFAST SET', 'http://zellarestaurants.com/system/api/uploads/sub_category/126/1654118064.jpg', 13, 0, 0, '', '', '', 1, '', 0),
(127, 'FOUL', 'فويل', 'FOUL', 'FOUL', 'http://zellarestaurants.com/system/api/uploads/sub_category/127/1654118039.jpg', 13, 0, 0, '', '', '', 1, '', 0),
(128, 'NEEKHI', 'نيقي', 'NEEKHI', 'NEEKHI', 'http://zellarestaurants.com/system/api/uploads/sub_category/128/1654118009.jpg', 13, 0, 0, '', '', '', 1, '', 0),
(129, 'BALALEET', 'بلاليط', 'BALALEET', 'BALALEET', 'http://zellarestaurants.com/system/api/uploads/sub_category/129/1654117971.jpg', 13, 0, 0, '', '', '', 1, '', 0),
(130, 'FALAFEL', 'فلافل', 'FALAFEL', 'FALAFEL', 'http://zellarestaurants.com/system/api/uploads/sub_category/130/1654117910.jpg', 13, 0, 0, '', '', '', 1, '', 0),
(131, 'POTATO', 'البطاطس', 'POTATO', 'POTATO', 'http://zellarestaurants.com/system/api/uploads/sub_category/131/1654117858.jpg', 13, 0, 0, '', '', '', 1, '', 0),
(132, 'CHEESE OMELETTE', 'أومليت الجبن', 'CHEESE OMELETTE', 'CHEESE OMELETTE', '', 13, 0, 0, '', '', '', 1, '', 0),
(133, 'MIX OMELETTE', 'ميكس أومليت', 'MIX OMELETTE', 'MIX OMELETTE', '', 13, 0, 0, '', '', '', 1, '', 0),
(134, 'ZAATAR SAAJ', 'صاج زعتر', 'ZAATAR SAAJ', 'ZAATAR SAAJ', '', 13, 0, 0, '', '', '', 1, '', 0),
(135, 'HALLOUMI SAJ', 'حلومي صاج', 'HALLOUMI SAJ', 'HALLOUMI SAJ', '', 13, 0, 0, '', '', '', 1, '', 0),
(136, 'FRENCH TOAST', 'خبز فرنسي محمص', 'FRENCH TOAST', 'FRENCH TOAST', 'http://zellarestaurants.com/system/api/uploads/sub_category/136/1654117771.jpg', 13, 0, 0, '', '', '', 1, '', 0),
(137, 'PANCAKES', 'بان كيك', 'PANCAKES', 'PANCAKES', 'http://zellarestaurants.com/system/api/uploads/sub_category/137/1654117730.jpg', 13, 0, 0, '', '', '', 1, '', 0),
(138, 'MAHAYAWA', 'مهياوة', 'MAHAYAWA', 'MAHAYAWA', '', 13, 0, 0, '', '', '', 1, '', 0),
(139, 'CHEESE SAJ', 'صاج الجبن', 'CHEESE SAJ', 'CHEESE SAJ', '', 13, 0, 0, '', '', '', 1, '', 0),
(140, 'LEBNA ZATER SAJ', 'LEBNA ZATER SAJ', 'LEBNA ZATER SAJ', 'LEBNA ZATER SAJ', '', 13, 0, 0, NULL, NULL, NULL, 1, '', 0),
(141, 'LEBNAH SAJ', 'لبنة صاج', 'LEBNAH SAJ', 'LEBNAH SAJ', '', 13, 0, 0, '', '', '', 1, '', 0),
(142, 'SCRAMBLE EGG', 'بيض مخفوق', 'SCRAMBLE EGG', 'SCRAMBLE EGG', 'http://zellarestaurants.com/system/api/uploads/sub_category/142/1654117664.jpg', 13, 0, 0, '', '', '', 1, '', 0),
(143, 'GRILL HALLOUMI', 'حلوم مشوي', 'GRILL HALLOUMI', 'GRILL HALLOUMI', '', 13, 0, 0, '', '', '', 1, '', 0),
(144, 'SPANISH OMELETS', 'أومليت إسباني', 'SPANISH OMELETS', 'SPANISH OMELETS', '', 13, 0, 0, '', '', '', 1, '', 0),
(145, 'BAKED BEANS', 'فاصوليا مخبوزة', 'BAKED BEANS', 'BAKED BEANS', '', 13, 0, 0, '', '', '', 1, '', 0),
(146, 'CHICKEN LIVER', 'كبد الدجاج', 'CHICKEN LIVER', 'CHICKEN LIVER', '', 13, 0, 0, '', '', '', 1, '', 0),
(147, 'BEEF LIVER', 'كبد لحم البقر', 'BEEF LIVER', 'BEEF LIVER', '', 13, 0, 0, '', '', '', 1, '', 0),
(148, 'ENGLISH BREAK FAST', 'وجبة الإفطار الانجليزية', 'ENGLISH BREAK FAST', 'ENGLISH BREAK FAST', '', 13, 0, 0, '', '', '', 1, '', 0),
(149, 'SAUSAGE', 'سجق', 'SAUSAGE', 'SAUSAGE', '', 13, 0, 0, '', '', '', 1, '', 0),
(150, 'HASH BROWN POTATO', 'بطاطس هاش براونز', 'HASH BROWN POTATO', 'HASH BROWN POTATO', '', 13, 0, 0, '', '', '', 1, '', 0),
(151, 'LEBNAH ZATER SAJ', 'لبنا زعتر صاج', 'LEBNAH ZATER SAJ', 'LEBNAH ZATER SAJ', '', 13, 0, 0, '', '', '', 1, '', 0),
(152, 'SAK SUKKA', 'صك سكا', 'SAK SUKKA', 'SAK SUKKA', 'http://zellarestaurants.com/system/api/uploads/sub_category/152/1654117621.jpg', 13, 0, 0, '', '', '', 1, '', 0),
(153, 'CROISSANT', 'كرواسون', 'CROISSANT', 'CROISSANT', '', 13, 0, 0, '', '', '', 1, '', 0),
(154, 'MIX MAHAYAWA', 'مهياوة', 'MIX MAHAYAWA', 'MIX MAHAYAWA', '', 13, 0, 0, '', '', '', 1, '', 0),
(155, 'TOM YAM SEAFOOD SOUP', 'TOM YAM SEAFOOD SOUP', 'TOM YAM SEAFOOD SOUP', 'TOM YAM SEAFOOD SOUP', 'http://zellarestaurants.com/system/api/uploads/sub_category/155/1653741519.jpg', 14, 0, 0, '', '', '', 1, '', 0),
(156, 'ALMOND SHRIMP', 'ALMOND SHRIMP', 'ALMOND SHRIMP', 'ALMOND SHRIMP', '', 14, 0, 0, NULL, NULL, NULL, 1, '', 0),
(157, 'STUFFED MUSHROOM', 'STUFFED MUSHROOM', 'STUFFED MUSHROOM', 'STUFFED MUSHROOM', '', 14, 0, 0, NULL, NULL, NULL, 1, '', 0),
(158, 'CHEESY BACON', 'CHEESY BACON', 'CHEESY BACON', 'CHEESY BACON', 'http://zellarestaurants.com/system/api/uploads/sub_category/158/1654118334.jpg', 14, 0, 0, '', '', '', 1, '', 0),
(159, 'MOZZARELLA CHEESE STICK', 'MOZZARELLA CHEESE STICK', 'MOZZARELLA CHEESE STICK', 'MOZZARELLA CHEESE STICK', '', 14, 0, 0, NULL, NULL, NULL, 1, '', 0),
(160, 'QUINOA SALAD', 'QUINOA SALAD', 'QUINOA SALAD', 'QUINOA SALAD', '', 14, 0, 0, NULL, NULL, NULL, 1, '', 0),
(161, 'AVOCADO QUINOA SALAD', 'AVOCADO QUINOA SALAD', 'AVOCADO QUINOA SALAD', 'AVOCADO QUINOA SALAD', '', 14, 0, 0, NULL, NULL, NULL, 1, '', 0),
(162, 'HALLOUMI SALAD', 'HALLOUMI SALAD', 'HALLOUMI SALAD', 'HALLOUMI SALAD', 'http://zellarestaurants.com/system/api/uploads/sub_category/162/1654118279.jpg', 14, 0, 0, '', '', '', 1, '', 0),
(163, 'CRAB SALAD', 'CRAB SALAD', 'CRAB SALAD', 'CRAB SALAD', 'http://zellarestaurants.com/system/api/uploads/sub_category/163/1654118244.jpg', 14, 0, 0, '', '', '', 1, '', 0),
(164, 'CHICKEN FAJITA', 'CHICKEN FAJITA', 'CHICKEN FAJITA', 'CHICKEN FAJITA', '', 14, 0, 0, NULL, NULL, NULL, 1, '', 0),
(165, 'CHICKEN QUESADILLA', 'CHICKEN QUESADILLA', 'CHICKEN QUESADILLA', 'CHICKEN QUESADILLA', '', 14, 0, 0, NULL, NULL, NULL, 1, '', 0),
(166, 'CHICKEN TURKEY PANINI', 'CHICKEN TURKEY PANINI', 'CHICKEN TURKEY PANINI', 'CHICKEN TURKEY PANINI', '', 14, 0, 0, NULL, NULL, NULL, 1, '', 0),
(167, 'CRISPY CHICKEN BURGER', 'CRISPY CHICKEN BURGER', 'CRISPY CHICKEN BURGER', 'CRISPY CHICKEN BURGER', '', 14, 0, 0, NULL, NULL, NULL, 1, '', 0),
(168, 'ANGUS BURGER', 'ANGUS BURGER', 'ANGUS BURGER', 'ANGUS BURGER', '', 14, 0, 0, NULL, NULL, NULL, 1, '', 0),
(169, 'PULLED BRISKET BURGER', 'PULLED BRISKET BURGER', 'PULLED BRISKET BURGER', 'PULLED BRISKET BURGER', '', 14, 0, 0, NULL, NULL, NULL, 1, '', 0),
(170, 'TUNA SANDWICH', 'TUNA SANDWICH', 'TUNA SANDWICH', 'TUNA SANDWICH', '', 14, 0, 0, NULL, NULL, NULL, 1, '', 0),
(171, 'CHICKEN TERIYAKI', 'CHICKEN TERIYAKI', 'CHICKEN TERIYAKI', 'CHICKEN TERIYAKI', '', 14, 0, 0, NULL, NULL, NULL, 1, '', 0),
(172, 'GRILLED CHICKEN WITH MUSHROOM', 'GRILLED CHICKEN WITH MUSHROOM', 'GRILLED CHICKEN WITH MUSHROOM', 'GRILLED CHICKEN WITH MUSHROOM', '', 14, 0, 0, NULL, NULL, NULL, 1, '', 0),
(173, 'RISOTTO NEAPOLITAN', 'RISOTTO NEAPOLITAN', 'RISOTTO NEAPOLITAN', 'RISOTTO NEAPOLITAN', '', 14, 0, 0, NULL, NULL, NULL, 1, '', 0),
(174, 'TENDERLOIN STEAK P. FORESTER', 'TENDERLOIN STEAK P. FORESTER', 'TENDERLOIN STEAK P. FORESTER', 'TENDERLOIN STEAK P. FORESTER', '', 14, 0, 0, NULL, NULL, NULL, 1, '', 0),
(175, 'CHICKEN DIJON', 'CHICKEN DIJON', 'CHICKEN DIJON', 'CHICKEN DIJON', 'http://zellarestaurants.com/system/api/uploads/sub_category/175/1654117213.jpg', 14, 0, 0, '', '', '', 1, '', 0),
(176, 'JACKET POTATO', 'JACKET POTATO', 'JACKET POTATO', 'JACKET POTATO', 'http://zellarestaurants.com/system/api/uploads/sub_category/176/1654118110.jpg', 14, 0, 0, '', '', '', 1, '', 0),
(177, 'CHICKEN KIEV', 'CHICKEN KIEV', 'CHICKEN KIEV', 'CHICKEN KIEV', 'http://zellarestaurants.com/system/api/uploads/sub_category/177/1654280365.jpg', 14, 0, 0, '', '', '', 1, '', 0),
(178, 'PENNE ROSE', 'PENNE ROSE', 'PENNE ROSE', 'PENNE ROSE', '', 14, 0, 0, NULL, NULL, NULL, 1, '', 0),
(179, 'ALFREDO PASTA', 'ALFREDO PASTA', 'ALFREDO PASTA', 'ALFREDO PASTA', '', 14, 0, 0, NULL, NULL, NULL, 1, '', 0),
(180, 'GRILLED SALMON RISOTTO', 'GRILLED SALMON RISOTTO', 'GRILLED SALMON RISOTTO', 'GRILLED SALMON RISOTTO', '', 14, 0, 0, NULL, NULL, NULL, 1, '', 0),
(181, 'PRAWN RISOTTO', 'PRAWN RISOTTO', 'PRAWN RISOTTO', 'PRAWN RISOTTO', '', 14, 0, 0, NULL, NULL, NULL, 1, '', 0),
(182, 'CRISPY BEEF', 'CRISPY BEEF', 'CRISPY BEEF', 'CRISPY BEEF', '', 14, 0, 0, NULL, NULL, NULL, 1, '', 0),
(183, 'ZEBAL SPECIAL CLUB SANDWICH', 'ZEBAL SPECIAL CLUB SANDWICH', 'ZEBAL SPECIAL CLUB SANDWICH', 'ZEBAL SPECIAL CLUB SANDWICH', 'http://zellarestaurants.com/system/api/uploads/sub_category/183/1654165205.jpg', 14, 0, 0, '', '', '', 1, '', 0),
(184, 'LOADED ZEBAL BURGER', 'LOADED ZEBAL BURGER', 'LOADED ZEBAL BURGER', 'LOADED ZEBAL BURGER', 'http://zellarestaurants.com/system/api/uploads/sub_category/184/1654165263.jpg', 14, 0, 0, '', '', '', 1, '', 0),
(185, 'MINI BURGER', 'MINI BURGER', 'MINI BURGER', 'MINI BURGER', 'http://zellarestaurants.com/system/api/uploads/sub_category/185/1654168342.jpg', 14, 0, 0, '', '', '', 1, '', 0),
(186, 'FAJITA SANDWICH', 'FAJITA SANDWICH', 'FAJITA SANDWICH', 'FAJITA SANDWICH', 'http://zellarestaurants.com/system/api/uploads/sub_category/186/1654165150.jpg', 14, 0, 0, '', '', '', 1, '', 0),
(187, 'CHICKEN AVOCADO SANDWICH', 'CHICKEN AVOCADO SANDWICH', 'CHICKEN AVOCADO SANDWICH', 'CHICKEN AVOCADO SANDWICH', '', 14, 0, 0, NULL, NULL, NULL, 1, '', 0),
(188, 'CHICKEN FILLET SANDWICH', 'CHICKEN FILLET SANDWICH', 'CHICKEN FILLET SANDWICH', 'CHICKEN FILLET SANDWICH', '', 14, 0, 0, NULL, NULL, NULL, 1, '', 0),
(189, 'SPICY FRENCH SANDWICH', 'SPICY FRENCH SANDWICH', 'SPICY FRENCH SANDWICH', 'SPICY FRENCH SANDWICH', '', 14, 0, 0, NULL, NULL, NULL, 1, '', 0),
(190, 'HOME MADE BEEF BURGER', 'HOME MADE BEEF BURGER', 'HOME MADE BEEF BURGER', 'HOME MADE BEEF BURGER', '', 14, 0, 0, NULL, NULL, NULL, 1, '', 0),
(191, 'CHICKEN MINI BURGER', 'CHICKEN MINI BURGER', 'CHICKEN MINI BURGER', 'CHICKEN MINI BURGER', '', 14, 0, 0, NULL, NULL, NULL, 1, '', 0),
(192, 'BEEF MINI BURGER', 'BEEF MINI BURGER', 'BEEF MINI BURGER', 'BEEF MINI BURGER', '', 14, 0, 0, NULL, NULL, NULL, 1, '', 0),
(193, 'CHICKEN FESTA', 'CHICKEN FESTA', 'CHICKEN FESTA', 'CHICKEN FESTA', 'http://zellarestaurants.com/system/api/uploads/sub_category/193/1654163286.jpg', 14, 0, 0, '', '', '', 1, '', 0),
(194, 'CHICKEN TIKKA MALGOOM ( SAAJ )', 'CHICKEN TIKKA MALGOOM ( SAAJ )', 'CHICKEN TIKKA MALGOOM ( SAAJ )', 'CHICKEN TIKKA MALGOOM ( SAAJ )', '', 15, 0, 0, NULL, NULL, NULL, 1, '', 0),
(195, 'MEAT TIKKA MALGOOM ( SAAJ )', 'MEAT TIKKA MALGOOM ( SAAJ )', 'MEAT TIKKA MALGOOM ( SAAJ )', 'MEAT TIKKA MALGOOM ( SAAJ )', '', 15, 0, 0, NULL, NULL, NULL, 1, '', 0),
(196, 'LIVER MALGOOM ( SAAJ )', 'LIVER MALGOOM ( SAAJ )', 'LIVER MALGOOM ( SAAJ )', 'LIVER MALGOOM ( SAAJ )', '', 15, 0, 0, NULL, NULL, NULL, 1, '', 0),
(197, 'NUGGETS MALGOOM ( SAAJ )', 'NUGGETS MALGOOM ( SAAJ )', 'NUGGETS MALGOOM ( SAAJ )', 'NUGGETS MALGOOM ( SAAJ )', '', 15, 0, 0, NULL, NULL, NULL, 1, '', 0),
(198, 'BURGER MALGOOM ( SAAJ )', 'BURGER MALGOOM ( SAAJ )', 'BURGER MALGOOM ( SAAJ )', 'BURGER MALGOOM ( SAAJ )', '', 15, 0, 0, NULL, NULL, NULL, 1, '', 0),
(199, 'CHICKEN ROSE ROLL', 'CHICKEN ROSE ROLL', 'CHICKEN ROSE ROLL', 'CHICKEN ROSE ROLL', 'http://zellarestaurants.com/system/api/uploads/sub_category/199/1654165124.jpg', 15, 0, 0, '', '', '', 1, '', 0),
(200, 'BBQ SAAJ', 'BBQ SAAJ', 'BBQ SAAJ', 'BBQ SAAJ', '', 16, 0, 0, NULL, NULL, NULL, 1, '', 0),
(201, 'HALLOUMI WITH ZAATAR SAAJ', 'HALLOUMI WITH ZAATAR SAAJ', 'HALLOUMI WITH ZAATAR SAAJ', 'HALLOUMI WITH ZAATAR SAAJ', '', 16, 0, 0, NULL, NULL, NULL, 1, '', 0),
(202, 'FALAFEL SAAJ', 'FALAFEL SAAJ', 'FALAFEL SAAJ', 'FALAFEL SAAJ', '', 16, 0, 0, NULL, NULL, NULL, 1, '', 0),
(203, 'CHICKEN KABAB SAAJ', 'CHICKEN KABAB SAAJ', 'CHICKEN KABAB SAAJ', 'CHICKEN KABAB SAAJ', '', 16, 0, 0, NULL, NULL, NULL, 1, '', 0),
(204, 'BEEF KABAB SAAJ', 'BEEF KABAB SAAJ', 'BEEF KABAB SAAJ', 'BEEF KABAB SAAJ', '', 16, 0, 0, NULL, NULL, NULL, 1, '', 0),
(205, 'CHICKEN MAYONNAISE', 'CHICKEN MAYONNAISE', 'CHICKEN MAYONNAISE', 'CHICKEN MAYONNAISE', '', 17, 0, 0, NULL, NULL, NULL, 1, '', 0),
(206, 'CHICKEN FILLET', 'CHICKEN FILLET', 'CHICKEN FILLET', 'CHICKEN FILLET', '', 17, 0, 0, NULL, NULL, NULL, 1, '', 0),
(207, 'CHICKEN NUGGETS SANDWICH', 'CHICKEN NUGGETS SANDWICH', 'CHICKEN NUGGETS SANDWICH', 'CHICKEN NUGGETS SANDWICH', '', 17, 0, 0, NULL, NULL, NULL, 1, '', 0),
(208, 'CHICKEN POPCORN SANDWICH', 'CHICKEN POPCORN SANDWICH', 'CHICKEN POPCORN SANDWICH', 'CHICKEN POPCORN SANDWICH', '', 17, 0, 0, NULL, NULL, NULL, 1, '', 0),
(209, 'VEGETABLE SANDWICH', 'VEGETABLE SANDWICH', 'VEGETABLE SANDWICH', 'VEGETABLE SANDWICH', '', 17, 0, 0, NULL, NULL, NULL, 1, '', 0),
(213, 'CHICKEN ZINGER', 'CHICKEN ZINGER', 'CHICKEN ZINGER', 'CHICKEN ZINGER', 'http://zellarestaurants.com/system/api/uploads/sub_category/213/1654277792.jpg', 18, 0, 0, '', '', '', 1, '', 0),
(214, 'SUPREME ZINGER', 'SUPREME ZINGER', 'SUPREME ZINGER', 'SUPREME ZINGER', '', 18, 0, 0, NULL, NULL, NULL, 1, '', 0),
(215, 'FILLET ZINGER', 'FILLET ZINGER', 'FILLET ZINGER', 'FILLET ZINGER', '', 18, 0, 0, NULL, NULL, NULL, 1, '', 0),
(216, 'DOUBLE ZINGER', 'DOUBLE ZINGER', 'DOUBLE ZINGER', 'DOUBLE ZINGER', '', 18, 0, 0, NULL, NULL, NULL, 1, '', 0),
(217, 'MORTADELLA ZINGER', 'MORTADELLA ZINGER', 'MORTADELLA ZINGER', 'MORTADELLA ZINGER', '', 18, 0, 0, NULL, NULL, NULL, 1, '', 0),
(218, 'ZINGER WITH CHEDDAR CHEESE', 'ZINGER WITH CHEDDAR CHEESE', 'ZINGER WITH CHEDDAR CHEESE', 'ZINGER WITH CHEDDAR CHEESE', '', 18, 0, 0, NULL, NULL, NULL, 1, '', 0),
(219, 'VEGETABLE CLUB', 'VEGETABLE CLUB', 'VEGETABLE CLUB', 'VEGETABLE CLUB', '', 19, 0, 0, NULL, NULL, NULL, 1, '', 0),
(220, 'SAUSAGE CLUB', 'SAUSAGE CLUB', 'SAUSAGE CLUB', 'SAUSAGE CLUB', '', 19, 0, 0, NULL, NULL, NULL, 1, '', 1),
(221, 'FISH CLUB', 'FISH CLUB', 'FISH CLUB', 'FISH CLUB', '', 19, 0, 0, NULL, NULL, NULL, 1, '', 2),
(222, 'CHICKEN BEEF MIX CLUB', 'CHICKEN BEEF MIX CLUB', 'CHICKEN BEEF MIX CLUB', 'CHICKEN BEEF MIX CLUB', '', 19, 0, 0, NULL, NULL, NULL, 1, '', 3),
(223, 'FAMILY CLUB', 'FAMILY CLUB', 'FAMILY CLUB', 'FAMILY CLUB', '', 19, 0, 0, NULL, NULL, NULL, 1, '', 4),
(224, 'ROYAL CLUB', 'ROYAL CLUB', 'ROYAL CLUB', 'ROYAL CLUB', '', 19, 0, 0, NULL, NULL, NULL, 1, '', 5),
(225, 'PARTY CLUB + PEPSI', 'PARTY CLUB + PEPSI', 'PARTY CLUB + PEPSI', 'PARTY CLUB + PEPSI', '', 19, 0, 0, NULL, NULL, NULL, 1, '', 6),
(226, 'CHICKEN FILLET JUMBO', 'CHICKEN FILLET JUMBO', 'CHICKEN FILLET JUMBO', 'CHICKEN FILLET JUMBO', '', 20, 0, 0, NULL, NULL, NULL, 1, '', 0),
(227, 'DOUBLE BURGER - CHICKEN', 'DOUBLE BURGER - CHICKEN', 'DOUBLE BURGER - CHICKEN', 'DOUBLE BURGER - CHICKEN', '', 20, 0, 0, '', '', '', 1, '', 0),
(228, 'ZINGER MATHAFI', 'ZINGER MATHAFI', 'ZINGER MATHAFI', 'ZINGER MATHAFI', '', 20, 0, 0, NULL, NULL, NULL, 1, '', 0),
(229, 'MIX MINI PIZZA', 'MIX MINI PIZZA', 'MIX MINI PIZZA', 'MIX MINI PIZZA', '', 21, 0, 0, NULL, NULL, NULL, 1, '', 0),
(230, 'PAN CAKE', 'PAN CAKE', 'PAN CAKE', 'PAN CAKE', '', 21, 0, 0, NULL, NULL, NULL, 1, '', 0),
(231, 'MIX MINI SLIDER', 'MIX MINI SLIDER', 'MIX MINI SLIDER', 'MIX MINI SLIDER', '', 21, 0, 0, NULL, NULL, NULL, 1, '', 0),
(232, 'CHICKEN NUGGETS', 'CHICKEN NUGGETS', 'CHICKEN NUGGETS', 'CHICKEN NUGGETS', '', 21, 0, 0, NULL, NULL, NULL, 1, '', 0),
(233, 'TAMIYA', 'TAMIYA', 'TAMIYA', 'TAMIYA', '', 21, 0, 0, NULL, NULL, NULL, 1, '', 0),
(234, 'CRAP NUTRULLA', 'CRAP NUTRULLA', 'CRAP NUTRULLA', 'CRAP NUTRULLA', '', 21, 0, 0, NULL, NULL, NULL, 1, '', 0),
(235, 'MIX MINI CAKE', 'MIX MINI CAKE', 'MIX MINI CAKE', 'MIX MINI CAKE', '', 21, 0, 0, NULL, NULL, NULL, 1, '', 0),
(236, 'BANANA SPLIT', 'BANANA SPLIT', 'BANANA SPLIT', 'BANANA SPLIT', '', 21, 0, 0, NULL, NULL, NULL, 1, '', 0),
(237, 'PARMOSATION CHICKEN BITES', 'PARMOSATION CHICKEN BITES', 'PARMOSATION CHICKEN BITES', 'PARMOSATION CHICKEN BITES', '', 21, 0, 0, NULL, NULL, NULL, 1, '', 0),
(238, 'CHICKEN QUESADILLAS', 'CHICKEN QUESADILLAS', 'CHICKEN QUESADILLAS', 'CHICKEN QUESADILLAS', '', 21, 0, 0, NULL, NULL, NULL, 1, '', 0),
(239, 'SEASONED CHICKEN STRIPS', 'SEASONED CHICKEN STRIPS', 'SEASONED CHICKEN STRIPS', 'SEASONED CHICKEN STRIPS', '', 21, 0, 0, NULL, NULL, NULL, 1, '', 0),
(240, 'BURGER BOX', 'BURGER BOX', 'BURGER BOX', 'BURGER BOX', '', 22, 0, 0, NULL, NULL, NULL, 1, '', 0),
(241, 'NEGET BOX', 'NEGET BOX', 'NEGET BOX', 'NEGET BOX', '', 22, 0, 0, NULL, NULL, NULL, 1, '', 0),
(242, 'CRAP NUTRELLA', 'CRAP NUTRELLA', 'CRAP NUTRELLA', 'CRAP NUTRELLA', '', 22, 0, 0, NULL, NULL, NULL, 1, '', 0),
(243, 'KIDS MINI PIZZA', 'KIDS MINI PIZZA', 'KIDS MINI PIZZA', 'KIDS MINI PIZZA', '', 22, 0, 0, NULL, NULL, NULL, 1, '', 0),
(244, 'ZABEL SPECIAL PIZZA', 'ZABEL SPECIAL PIZZA', 'ZABEL SPECIAL PIZZA', 'ZABEL SPECIAL PIZZA', '', 23, 0, 0, NULL, NULL, NULL, 1, '', 0),
(245, 'PEPPERONI PIZZA', 'PEPPERONI PIZZA', 'PEPPERONI PIZZA', 'PEPPERONI PIZZA', 'http://zellarestaurants.com/system/api/uploads/sub_category/245/1654273567.jpg', 23, 0, 0, '', '', '', 1, '', 0),
(246, 'MARGARITA PIZZA', 'MARGARITA PIZZA', 'MARGARITA PIZZA', 'MARGARITA PIZZA', '', 23, 0, 0, NULL, NULL, NULL, 1, '', 0),
(247, 'VEGETARIAN PIZZA', 'VEGETARIAN PIZZA', 'VEGETARIAN PIZZA', 'VEGETARIAN PIZZA', '', 23, 0, 0, NULL, NULL, NULL, 1, '', 0),
(248, 'POLO PIZZA', 'POLO PIZZA', 'POLO PIZZA', 'POLO PIZZA', '', 23, 0, 0, NULL, NULL, NULL, 1, '', 0),
(249, 'HAWAIIAN PIZZA', 'HAWAIIAN PIZZA', 'HAWAIIAN PIZZA', 'HAWAIIAN PIZZA', '', 23, 0, 0, NULL, NULL, NULL, 1, '', 0),
(250, 'ORANGE', 'ORANGE', 'ORANGE', 'ORANGE', '', 24, 0, 0, NULL, NULL, NULL, 1, '', 0),
(251, 'AVOCADO', 'AVOCADO', 'AVOCADO', 'AVOCADO', 'http://zellarestaurants.com/system/api/uploads/sub_category/251/1654117496.jpg', 24, 0, 0, '', '', '', 1, '', 0),
(252, 'MANGO', 'MANGO', 'MANGO', 'MANGO', 'http://zellarestaurants.com/system/api/uploads/sub_category/252/1654117531.jpg', 24, 0, 0, '', '', '', 1, '', 0),
(253, 'PINEAPPLE', 'PINEAPPLE', 'PINEAPPLE', 'PINEAPPLE', '', 24, 0, 0, NULL, NULL, NULL, 1, '', 0),
(254, 'POMEGRANATE', 'POMEGRANATE', 'POMEGRANATE', 'POMEGRANATE', 'http://zellarestaurants.com/system/api/uploads/sub_category/254/1654162340.jpg', 24, 0, 0, '', '', '', 1, '', 0),
(255, 'WATER MELON', 'WATER MELON', 'WATER MELON', 'WATER MELON', 'http://zellarestaurants.com/system/api/uploads/sub_category/255/1654117448.jpg', 24, 0, 0, '', '', '', 1, '', 0),
(256, 'SWEET MELON', 'SWEET MELON', 'SWEET MELON', 'SWEET MELON', '', 24, 0, 0, NULL, NULL, NULL, 1, '', 0),
(257, 'STRAWBERRY JUICE', 'عصير فراولة', 'A Delicious Drink with the perfect balance of sweet and tangy with a refreshing flavour ', 'مشروب لذيذ مع التوازن المثالي بين الحلو والحامض بنكهة منعشة', '', 24, 0, 0, '', '', '', 1, '', 0),
(258, 'GRAPE', 'GRAPE', 'GRAPE', 'GRAPE', '', 24, 0, 0, NULL, NULL, NULL, 1, '', 0),
(259, 'APPLE', 'APPLE', 'APPLE', 'APPLE', '', 24, 0, 0, NULL, NULL, NULL, 1, '', 0),
(260, 'KIWI', 'KIWI', 'KIWI', 'KIWI', '', 24, 0, 0, NULL, NULL, NULL, 1, '', 0),
(261, 'GUAVA', 'GUAVA', 'GUAVA', 'GUAVA', '', 24, 0, 0, NULL, NULL, NULL, 1, '', 0),
(262, 'PAPAYA', 'PAPAYA', 'PAPAYA', 'PAPAYA', '', 24, 0, 0, NULL, NULL, NULL, 1, '', 0),
(263, 'CHIKOO', 'CHIKOO', 'CHIKOO', 'CHIKOO', '', 24, 0, 0, NULL, NULL, NULL, 1, '', 0),
(264, 'BANANA', 'BANANA', 'BANANA', 'BANANA', '', 24, 0, 0, NULL, NULL, NULL, 1, '', 0),
(265, 'PEECH', 'PEECH', 'PEECH', 'PEECH', '', 24, 0, 0, NULL, NULL, NULL, 1, '', 0),
(266, 'LEMON', 'LEMON', 'LEMON', 'LEMON', '', 24, 0, 0, NULL, NULL, NULL, 1, '', 0),
(267, 'JACKFRUIT', 'JACKFRUIT', 'JACKFRUIT', 'JACKFRUIT', '', 24, 0, 0, NULL, NULL, NULL, 1, '', 0),
(268, 'FASHION FRUIT', 'FASHION FRUIT', 'FASHION FRUIT', 'FASHION FRUIT', '', 24, 0, 0, NULL, NULL, NULL, 1, '', 0),
(269, 'PURE POMEGRANATE', 'PURE POMEGRANATE', 'PURE POMEGRANATE', 'PURE POMEGRANATE', '', 28, 0, 0, '', '', '', 1, '', 0),
(270, 'PURE SHAMAM', 'PURE SHAMAM', 'PURE SHAMAM', 'PURE SHAMAM', '', 28, 0, 0, '', '', '', 1, '', 0),
(271, 'LEMON MINT', 'LEMON MINT', 'LEMON MINT', 'LEMON MINT', '', 29, 0, 0, '', '', '', 1, '', 0),
(272, 'MIX JUICE', 'MIX JUICE', 'MIX JUICE', 'MIX JUICE', '', 29, 0, 0, '', '', '', 1, '', 0),
(273, 'CARROT WITH BEETROOT', 'CARROT WITH BEETROOT', 'CARROT WITH BEETROOT', 'CARROT WITH BEETROOT', '', 29, 0, 0, '', '', '', 1, '', 0),
(274, 'CARROT WITH ORANGE', 'CARROT WITH ORANGE', 'CARROT WITH ORANGE', 'CARROT WITH ORANGE', '', 29, 0, 0, '', '', '', 1, '', 0),
(275, 'AVOCADO WITH MANGO', 'AVOCADO WITH MANGO', 'AVOCADO WITH MANGO', 'AVOCADO WITH MANGO', '', 29, 0, 0, '', '', '', 1, '', 0),
(276, 'AVOCADO WITH POMEGRANATE', 'AVOCADO WITH POMEGRANATE', 'AVOCADO WITH POMEGRANATE', 'AVOCADO WITH POMEGRANATE', '', 29, 0, 0, '', '', '', 1, '', 0),
(277, 'AVOCADO WITH HONEY', 'AVOCADO WITH HONEY', 'AVOCADO WITH HONEY', 'AVOCADO WITH HONEY', '', 29, 0, 0, '', '', '', 1, '', 0),
(278, 'AVOCADO WITH ICE CREAM', 'AVOCADO WITH ICE CREAM', 'AVOCADO WITH ICE CREAM', 'AVOCADO WITH ICE CREAM', '', 29, 0, 0, '', '', '', 1, '', 0),
(279, 'ABOOD', 'ABOOD', 'ABOOD', 'ABOOD', '', 29, 0, 0, '', '', '', 1, '', 0),
(280, 'AVARGHALB', 'AVARGHALB', 'AVARGHALB', 'AVARGHALB', '', 29, 0, 0, '', '', '', 1, '', 0),
(281, 'YOGURT POMEGRANATE', 'YOGURT POMEGRANATE', 'YOGURT POMEGRANATE', 'YOGURT POMEGRANATE', '', 29, 0, 0, '', '', '', 1, '', 0),
(282, 'YOGURT MANGO', 'YOGURT MANGO', 'YOGURT MANGO', 'YOGURT MANGO', '', 29, 0, 0, '', '', '', 1, '', 0),
(283, 'YOGURT STRAWBERRY', 'YOGURT STRAWBERRY', 'YOGURT STRAWBERRY', 'YOGURT STRAWBERRY', '', 29, 0, 0, '', '', '', 1, '', 0),
(284, 'LEMON SODA SARBATH', 'LEMON SODA SARBATH', 'LEMON SODA SARBATH', 'LEMON SODA SARBATH', '', 29, 0, 0, '', '', '', 1, '', 0),
(285, 'MANGO MILK SHAKES', 'MANGO MILK SHAKES', 'MANGO MILK SHAKES', 'MANGO MILK SHAKES', '', 25, 0, 0, '', '', '', 1, '', 0),
(286, 'PISTA MILK SHAKE', 'PISTA MILK SHAKE', 'PISTA MILK SHAKE', 'PISTA MILK SHAKE', '', 25, 0, 0, '', '', '', 1, '', 0),
(287, 'STRAWBERRY MILKSHAKE', 'STRAWBERRY MILKSHAKE', 'STRAWBERRY MILKSHAKE', 'STRAWBERRY MILKSHAKE', 'http://zellarestaurants.com/system/api/uploads/sub_category/287/1654278452.jpg', 25, 0, 0, '', '', '', 1, '', 0),
(288, 'VANILLA MILKSHAKE', 'VANILLA MILKSHAKE', 'VANILLA MILKSHAKE', 'VANILLA MILKSHAKE', '', 25, 0, 0, '', '', '', 1, '', 0),
(289, 'CHIKOO MILK SHAKE', 'CHIKOO MILK SHAKE', 'CHIKOO MILK SHAKE', 'CHIKOO MILK SHAKE', '', 25, 0, 0, '', '', '', 1, '', 0),
(290, 'BANANA MILK SHAKE', 'BANANA MILK SHAKE', 'BANANA MILK SHAKE', 'BANANA MILK SHAKE', '', 25, 0, 0, '', '', '', 1, '', 0),
(291, 'BANANA WITH VANILLA SHAKE', 'BANANA WITH VANILLA SHAKE', 'BANANA WITH VANILLA SHAKE', 'BANANA WITH VANILLA SHAKE', '', 25, 0, 0, '', '', '', 1, '', 0),
(292, 'CHOCOLATE MILKSHAKE', 'CHOCOLATE MILKSHAKE', 'CHOCOLATE MILKSHAKE', 'CHOCOLATE MILKSHAKE', '', 30, 0, 0, '', '', '', 1, '', 0),
(293, 'OREO MILKSHAKES', 'OREO MILKSHAKES', 'OREO MILKSHAKES', 'OREO MILKSHAKES', '', 30, 0, 0, '', '', '', 1, '', 0),
(294, 'NUTELLA SHAKE', 'NUTELLA SHAKE', 'NUTELLA SHAKE', 'NUTELLA SHAKE', '', 30, 0, 0, '', '', '', 1, '', 0),
(295, 'SNICKERS MILKSHAKE', 'SNICKERS MILKSHAKE', 'SNICKERS MILKSHAKE', 'SNICKERS MILKSHAKE', '', 30, 0, 0, '', '', '', 1, '', 0),
(296, 'GALAXY MILKSHAKE', 'GALAXY MILKSHAKE', 'GALAXY MILKSHAKE', 'GALAXY MILKSHAKE', '', 30, 0, 0, '', '', '', 1, '', 0),
(297, 'MALTESERS MILKSHAKE', 'MALTESERS MILKSHAKE', 'MALTESERS MILKSHAKE', 'MALTESERS MILKSHAKE', '', 30, 0, 0, '', '', '', 1, '', 0),
(298, 'STRAWBERRY MOJITO', 'STRAWBERRY MOJITO', 'STRAWBERRY MOJITO', 'STRAWBERRY MOJITO', '', 31, 0, 0, '', '', '', 1, '', 0),
(299, 'PINEAPPLE MOJITO', 'PINEAPPLE MOJITO', 'PINEAPPLE MOJITO', 'PINEAPPLE MOJITO', '', 31, 0, 0, '', '', '', 1, '', 0),
(300, 'CHERRY MOJITO', 'CHERRY MOJITO', 'CHERRY MOJITO', 'CHERRY MOJITO', '', 31, 0, 0, '', '', '', 1, '', 0),
(301, 'POMEGRANATE MOJITO', 'POMEGRANATE MOJITO', 'POMEGRANATE MOJITO', 'POMEGRANATE MOJITO', '', 31, 0, 0, '', '', '', 1, '', 0),
(302, 'GRAPE MOJITO', 'GRAPE MOJITO', 'GRAPE MOJITO', 'GRAPE MOJITO', '', 31, 0, 0, '', '', '', 1, '', 0),
(303, 'APPLE MOJITO', 'APPLE MOJITO', 'APPLE MOJITO', 'APPLE MOJITO', '', 31, 0, 0, '', '', '', 1, '', 0),
(304, 'SPANKLING WITH ENERGY DRINK', 'SPANKLING WITH ENERGY DRINK', 'SPANKLING WITH ENERGY DRINK', 'SPANKLING WITH ENERGY DRINK', '', 31, 0, 0, '', '', '', 1, '', 0),
(305, 'ZELLA SPECIAL SPARKLING', 'ZELLA SPECIAL SPARKLING', 'ZELLA SPECIAL SPARKLING', 'ZELLA SPECIAL SPARKLING', '', 31, 0, 0, '', '', '', 1, '', 0),
(306, 'SPARKLING WITH LEMON MINT', 'SPARKLING WITH LEMON MINT', 'SPARKLING WITH LEMON MINT', 'SPARKLING WITH LEMON MINT', 'http://zellarestaurants.com/system/api/uploads/sub_category/306/1654117022.jpg', 31, 0, 0, '', '', '', 1, '', 0),
(307, 'CHOCOLATE CAKE', 'CHOCOLATE CAKE', 'CHOCOLATE CAKE', 'CHOCOLATE CAKE', '', 33, 0, 0, '', '', '', 1, '', 0),
(308, 'CARROT CAKE', 'CARROT CAKE', 'CARROT CAKE', 'CARROT CAKE', '', 33, 0, 0, '', '', '', 1, '', 0),
(309, 'BROWNIE CAKE', 'BROWNIE CAKE', 'BROWNIE CAKE', 'BROWNIE CAKE', '', 33, 0, 0, '', '', '', 1, '', 0),
(310, 'STRAWBERRY CHEESECAKE', 'STRAWBERRY CHEESECAKE', 'STRAWBERRY CHEESECAKE', 'STRAWBERRY CHEESECAKE', '', 33, 0, 0, '', '', '', 1, '', 0),
(311, 'BLUEBERRY CHEESE CAKE', 'BLUEBERRY CHEESE CAKE', 'BLUEBERRY CHEESE CAKE', 'BLUEBERRY CHEESE CAKE', '', 33, 0, 0, '', '', '', 1, '', 0),
(312, 'CHICKEN CLUB', '', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/312/1654275257.jpg', 19, 0, 0, '', '', '', 1, '2022-06-03 19:54:16', 0),
(313, 'BEEF CLUB', '', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/313/1654275309.jpg', 19, 0, 0, '', '', '', 1, '2022-06-03 19:55:09', 0),
(314, 'ZINGER CLUB', '', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/314/1654275342.jpg', 19, 0, 0, '', '', '', 1, '2022-06-03 19:55:42', 0),
(315, 'FILLET CLUB', '', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/315/1654275370.jpg', 19, 0, 0, '', '', '', 1, '2022-06-03 19:56:09', 0),
(316, 'MIX GRILL / TURISH', 'مشاوي مختلطة', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/316/1654284905.jpg', 8, 0, 0, '', '', '', 1, '2022-06-03 22:35:04', 0),
(317, 'LAMB CHOP / TURISH', 'فرم لحم ضاني', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/317/1654284932.jpg', 8, 0, 0, '', '', '', 1, '2022-06-03 22:35:32', 0),
(318, 'CHICKEN TIKKA / TURISH', 'دجاج تيكا', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/318/1654284978.jpg', 8, 0, 0, '', '', '', 1, '2022-06-03 22:36:18', 0),
(319, 'LEMON TIKKA / TURISH', 'ليمون تكا', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/319/1654285001.jpg', 8, 0, 0, '', '', '', 1, '2022-06-03 22:36:41', 0),
(320, 'MEAT KEBAB / TURISH', 'كباب لحم', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/320/1654285029.jpg', 8, 0, 0, '', '', '', 1, '2022-06-03 22:37:08', 0),
(321, 'CHICKEN KEBAB / TURISH', 'كباب دجاج', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/321/1654285058.jpg', 8, 0, 0, '', '', '', 1, '2022-06-03 22:37:38', 0),
(322, 'CREAM OF MUSHROOM SOUP-HF', 'شوربة الفطر', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/322/1654285138.jpg', 14, 0, 0, '', '', '', 1, '2022-06-03 22:38:57', 0),
(323, 'CREAM OF BROCCOLI SOUP-HF', 'شوربة كريمة البروكلي', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/323/1654285163.jpg', 14, 0, 0, '', '', '', 1, '2022-06-03 22:39:23', 0),
(324, 'CHICKEN CAESAR SALAD - HF', 'CHICKEN CAESAR SALAD - HF', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/324/1654285196.jpg', 14, 0, 0, '', '', '', 1, '2022-06-03 22:39:56', 0),
(325, 'GREEK SALAD - HF', 'GREEK SALAD - HF', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/325/1654285220.jpg', 14, 0, 0, '', '', '', 1, '2022-06-03 22:40:20', 0),
(326, 'CHICKEN STROGANOFF - HF', 'CHICKEN STROGANOFF - HF', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/326/1654285266.jpg', 14, 0, 0, '', '', '', 1, '2022-06-03 22:41:06', 0),
(327, 'CHICKEN BIRYANI - HF', 'CHICKEN BIRYANI - HF', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/327/1654285318.jpg', 14, 0, 0, '', '', '', 1, '2022-06-03 22:41:58', 0),
(328, 'CHICKEN SHAWARMA', 'شاورما الدجاج', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/328/1654285352.jpg', 26, 0, 0, '', '', '', 1, '2022-06-03 22:42:32', 0),
(329, 'SHAWARMA MALGOOM', 'شاورما ملقوم', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/329/1654285376.jpg', 26, 0, 0, '', '', '', 1, '2022-06-03 22:42:55', 0),
(330, 'SHAWARMA MALGOOM (CHAPPATHI )', 'شاورما ملقوم (شباثي)', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/330/1654285445.jpg', 26, 0, 0, '', '', '', 1, '2022-06-03 22:44:05', 0),
(331, 'SHAWARMA SAROOKH', 'شاورما سروخ', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/331/1654285477.jpg', 26, 0, 0, '', '', '', 1, '2022-06-03 22:44:36', 0),
(332, 'SHAWARMA SAROOKH ( CHAPPATHI)', 'شاورما صاروخ (شباثي)', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/332/1654285501.jpg', 26, 0, 0, '', '', '', 1, '2022-06-03 22:45:01', 0),
(333, 'SHAWARMA ARABIC', 'شاورما عربي', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/333/1654285541.jpg', 26, 0, 0, '', '', '', 1, '2022-06-03 22:45:40', 0),
(334, 'SHAWARMA HUMMUS', 'شاورما حمص', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/334/1654285562.jpg', 26, 0, 0, '', '', '', 1, '2022-06-03 22:46:01', 0),
(335, 'PLATE SHAWARMA', 'شاورما طبق', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/335/1654285605.jpg', 26, 0, 0, '', '', '', 1, '2022-06-03 22:46:44', 0),
(336, 'CHICKEN TIKKA MALGOOM ( CHAPPATHI)', 'دجاج تكا ملقوم (تشاباتي)', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/336/1654285716.jpg', 27, 0, 0, '', '', '', 1, '2022-06-03 22:48:35', 0),
(337, 'MEAT TIKKA MALGOOM ( CHAPPATHI)', 'لحم تكا ملقوم', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/337/1654285771.jpg', 27, 0, 0, '', '', '', 1, '2022-06-03 22:49:31', 0),
(338, 'KEBAB MEAT MALGOOM  ( CHAPPATHI)', 'لحم كباب ملقوم', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/338/1654285792.jpg', 27, 0, 0, '', '', '', 1, '2022-06-03 22:49:52', 0),
(339, 'KABAB CHICKEN MALGOOM  ( CHAPPATHI)', 'كباب دجاج ملقوم', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/339/1654285835.jpg', 27, 0, 0, '', '', '', 1, '2022-06-03 22:50:35', 0),
(340, 'LIVER MALGOOM  ( CHAPPATHI)', 'ملقوم كبد', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/340/1654285858.jpg', 27, 0, 0, '', '', '', 1, '2022-06-03 22:50:58', 0),
(341, 'HOT DOG MALGOOM  ( CHAPPATHI)', 'HOT DOG MALGOOM  ( CHAPPATHI)', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/341/1654285892.jpg', 27, 0, 0, '', '', '', 1, '2022-06-03 22:51:32', 0),
(342, 'FILLET MALGOOM  ( CHAPPATHI)', 'FILLET MALGOOM  ( CHAPPATHI)', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/342/1654285950.jpg', 27, 0, 0, '', '', '', 1, '2022-06-03 22:52:29', 0),
(343, 'NUGGETS MALGOOM  ( CHAPPATHI)', 'NUGGETS MALGOOM  ( CHAPPATHI)', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/343/1654285971.jpg', 27, 0, 0, '', '', '', 1, '2022-06-03 22:52:51', 0),
(344, 'BURGER MALGOOM  ( CHAPPATHI)', 'BURGER MALGOOM  ( CHAPPATHI)', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/344/1654286126.jpg', 27, 0, 0, '', '', '', 1, '2022-06-03 22:55:25', 0),
(345, 'EGG MALGOOM  ( CHAPPATHI)', 'EGG MALGOOM  ( CHAPPATHI)', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/345/1654286153.jpg', 27, 0, 0, '', '', '', 1, '2022-06-03 22:55:52', 0),
(346, 'ZINGER MALGOOM  ( CHAPPATHI)', 'ZINGER MALGOOM  ( CHAPPATHI)', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/346/1654286184.jpg', 27, 0, 0, '', '', '', 1, '2022-06-03 22:56:24', 0);
INSERT INTO `sub_categories` (`sub_category_id`, `sub_category_name`, `sub_category_name_ar`, `sub_category_desc`, `sub_category_desc_ar`, `sub_category_image`, `parent_category_id`, `discount_type`, `discount`, `discount_percentage`, `date_from`, `date_to`, `display`, `date`, `arrangement`) VALUES
(347, 'KEBAB MEAT MALGOOM ( SAAJ )', 'KEBAB MEAT MALGOOM ( SAAJ )', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/347/1654286282.jpg', 15, 0, 0, '', '', '', 1, '2022-06-03 22:58:02', 0),
(348, 'KABAB CHICKEN MALGOOM ( SAAJ )', 'KABAB CHICKEN MALGOOM ( SAAJ )', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/348/1654286301.jpg', 15, 0, 0, '', '', '', 1, '2022-06-03 22:58:20', 0),
(349, 'HOT DOG MALGOOM ( SAAJ )', 'HOT DOG MALGOOM ( SAAJ )', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/349/1654286319.jpg', 15, 0, 0, '', '', '', 1, '2022-06-03 22:58:38', 0),
(350, 'FILLET MALGOOM ( SAAJ )', 'FILLET MALGOOM ( SAAJ )', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/350/1654286345.jpg', 15, 0, 0, '', '', '', 1, '2022-06-03 22:59:04', 0),
(351, 'EGG MALGOOM ( SAAJ )', 'EGG MALGOOM ( SAAJ )', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/351/1654286365.jpg', 15, 0, 0, '', '', '', 1, '2022-06-03 22:59:24', 0),
(352, 'ZINGER MALGOOM ( SAAJ )', 'ZINGER MALGOOM ( SAAJ )', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/352/1654286380.jpg', 15, 0, 0, '', '', '', 1, '2022-06-03 22:59:40', 0),
(353, 'TURKEY SAAJ', 'TURKEY SAAJ', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/353/1654286408.jpg', 16, 0, 0, '', '', '', 1, '2022-06-03 23:00:07', 0),
(354, 'SISHTWOOK SAAJ', 'SISHTWOOK SAAJ', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/354/1654286426.jpg', 16, 0, 0, '', '', '', 1, '2022-06-03 23:00:26', 0),
(355, 'ZAATAR SAAJ', 'ZAATAR SAAJ', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/355/1654286448.jpg', 16, 0, 0, '', '', '', 1, '2022-06-03 23:00:48', 0),
(356, 'CHICKEN ZELLA ROLL', 'CHICKEN ZELLA ROLL', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/356/1654286467.jpg', 16, 0, 0, '', '', '', 1, '2022-06-03 23:01:06', 0),
(357, 'CHICKEN BURGER', 'CHICKEN BURGER', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/357/1654286510.jpg', 17, 0, 0, '', '', '', 1, '2022-06-03 23:01:49', 0),
(358, 'BEEF BURGER', 'BEEF BURGER', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/358/1654286539.jpg', 17, 0, 0, '', '', '', 1, '2022-06-03 23:02:18', 0),
(359, 'CHICKEN BURGER - GRILLED', 'CHICKEN BURGER - GRILLED', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/359/1654286561.jpg', 17, 0, 0, '', '', '', 1, '2022-06-03 23:02:40', 0),
(360, 'BEEF BURGER - GRILLED', 'BEEF BURGER - GRILLED', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/360/1654286578.jpg', 17, 0, 0, '', '', '', 1, '2022-06-03 23:02:58', 0),
(361, 'CHEESE SANDWICH', 'CHEESE SANDWICH', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/361/1654286622.jpg', 17, 0, 0, '', '', '', 1, '2022-06-03 23:03:42', 0),
(362, 'OMELETTE SANDWICH', 'OMELETTE SANDWICH', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/362/1654286642.jpg', 17, 0, 0, '', '', '', 1, '2022-06-03 23:04:02', 0),
(363, 'TAMIYA SANDWICH', 'TAMIYA SANDWICH', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/363/1654286668.jpg', 17, 0, 0, '', '', '', 1, '2022-06-03 23:04:28', 0),
(364, 'EGG TOMATO', 'EGG TOMATO', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/364/1654286698.jpg', 17, 0, 0, '', '', '', 1, '2022-06-03 23:04:58', 0),
(365, 'SAUSAGE CHICKEN', 'SAUSAGE CHICKEN', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/365/1654286722.jpg', 17, 0, 0, '', '', '', 1, '2022-06-03 23:05:22', 0),
(366, 'CLASSIC CHICKEN', 'CLASSIC CHICKEN', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/366/1654286744.jpg', 17, 0, 0, '', '', '', 1, '2022-06-03 23:05:43', 0),
(367, 'SUPREME CHICKEN', 'SUPREME CHICKEN', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/367/1654286760.jpg', 17, 0, 0, '', '', '', 1, '2022-06-03 23:05:59', 0),
(368, 'CRYSTAL CHICKEN', 'CRYSTAL CHICKEN', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/368/1654286777.jpg', 17, 0, 0, '', '', '', 1, '2022-06-03 23:06:17', 0),
(369, 'DOUBLE BURGER - BEEF', 'DOUBLE BURGER - BEEF', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/369/1654287090.jpg', 20, 0, 0, '', '', '', 1, '2022-06-03 23:11:30', 0),
(370, 'TWISTER COMBO', 'TWISTER COMBO', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/370/1654287109.jpg', 20, 0, 0, '', '', '', 1, '2022-06-03 23:11:48', 0),
(371, 'NUGGETS MATHAFI', 'NUGGETS MATHAFI', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/371/1654287130.jpg', 20, 0, 0, '', '', '', 1, '2022-06-03 23:12:10', 0),
(372, 'FRENCH FRIES - KM', 'FRENCH FRIES - KM', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/372/1654287163.jpg', 21, 0, 0, '', '', '', 1, '2022-06-03 23:12:43', 0),
(373, 'BANANA SPLIT - KC', 'BANANA SPLIT - KC', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/373/1654287212.jpg', 22, 0, 0, '', '', '', 1, '2022-06-03 23:13:31', 0),
(374, 'PURE ORANGE', 'PURE ORANGE', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/374/1654287286.jpg', 28, 0, 0, '', '', '', 1, '2022-06-03 23:14:45', 0),
(375, 'PURE CARROT', 'PURE CARROT', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/375/1654287349.jpg', 28, 0, 0, '', '', '', 1, '2022-06-03 23:15:49', 0),
(376, 'PURE WATERMELON', 'PURE WATERMELON', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/376/1654287423.jpg', 28, 0, 0, '', '', '', 1, '2022-06-03 23:17:03', 0),
(377, 'SWEET MELON MOJITO', 'SWEET MELON MOJITO', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/377/1654287515.jpg', 31, 0, 0, '', '', '', 1, '2022-06-03 23:18:34', 0),
(378, 'WATER MELON MOJITO', 'WATER MELON MOJITO', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/378/1654287554.jpg', 31, 0, 0, '', '', '', 1, '2022-06-03 23:19:14', 0),
(379, 'FRUIT SALADS WITH ICE CREAM', 'FRUIT SALADS WITH ICE CREAM', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/379/1654287651.jpg', 32, 0, 0, '', '', '', 1, '2022-06-03 23:20:51', 0),
(380, 'FALOODA', 'FALOODA', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/380/1654287701.jpg', 32, 0, 0, '', '', '', 1, '2022-06-03 23:21:40', 0),
(381, 'ZELLA SPECIAL COCKTAIL', 'ZELLA SPECIAL COCKTAIL', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/381/1654287730.jpg', 32, 0, 0, '', '', '', 1, '2022-06-03 23:22:10', 0),
(382, 'COCKTAIL AVAR QALB', 'COCKTAIL AVAR QALB', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/382/1654287766.jpg', 32, 0, 0, '', '', '', 1, '2022-06-03 23:22:45', 0),
(383, 'LABNANI COCKTAIL', 'LABNANI COCKTAIL', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/383/1654287791.jpg', 32, 0, 0, '', '', '', 1, '2022-06-03 23:23:10', 0),
(384, 'ITALIAN COCKTAIL', 'ITALIAN COCKTAIL', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/384/1654287819.jpg', 32, 0, 0, '', '', '', 1, '2022-06-03 23:23:38', 0),
(385, 'KUWAITI COCKTAIL', 'KUWAITI COCKTAIL', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/385/1654287855.jpg', 32, 0, 0, '', '', '', 1, '2022-06-03 23:24:15', 0),
(386, 'BANANA SPLIT', 'BANANA SPLIT', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/386/1654287884.jpg', 32, 0, 0, '', '', '', 1, '2022-06-03 23:24:44', 0),
(387, 'ZELLA SURPRISE', 'ZELLA SURPRISE', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/387/1654288039.jpg', 32, 0, 0, '', '', '', 1, '2022-06-03 23:27:18', 0),
(388, 'CHOCO BALL', 'CHOCO BALL', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/388/1654288059.jpg', 32, 0, 0, '', '', '', 1, '2022-06-03 23:27:38', 0),
(389, 'MIX FRUIT SALAD', 'MIX FRUIT SALAD', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/389/1654288112.jpg', 32, 0, 0, '', '', '', 1, '2022-06-03 23:28:32', 0),
(390, 'BROWNIE WITH ICE CREAM', 'BROWNIE WITH ICE CREAM', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/390/1654288146.jpg', 33, 0, 0, '', '', '', 1, '2022-06-03 23:29:06', 0),
(391, 'KARAK TEA', 'KARAK TEA', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/391/1654288206.jpg', 34, 0, 0, '', '', '', 1, '2022-06-03 23:30:05', 0),
(392, 'ARABIC COFFEE', 'ARABIC COFFEE', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/392/1654288232.jpg', 34, 0, 0, '', '', '', 1, '2022-06-03 23:30:31', 0),
(393, 'MOROCCAN TEA', 'MOROCCAN TEA', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/393/1654288278.jpg', 34, 0, 0, '', '', '', 1, '2022-06-03 23:31:17', 0),
(394, 'LEMON TEA', 'LEMON TEA', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/394/1654288311.jpg', 34, 0, 0, '', '', '', 1, '2022-06-03 23:31:50', 0),
(395, 'GINGER TEA', 'GINGER TEA', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/395/1654288344.jpg', 34, 0, 0, '', '', '', 1, '2022-06-03 23:32:23', 0),
(396, 'GREEN TEA', 'GREEN TEA', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/396/1654288383.jpg', 34, 0, 0, '', '', '', 1, '2022-06-03 23:33:02', 0),
(397, 'GINGER HONEY TEA', 'GINGER HONEY TEA', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/397/1654288420.jpg', 34, 0, 0, '', '', '', 1, '2022-06-03 23:33:40', 0),
(398, 'GREEN TEA WITH MINT', 'GREEN TEA WITH MINT', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/398/1654288463.jpg', 34, 0, 0, '', '', '', 1, '2022-06-03 23:34:23', 0),
(399, 'ESPRESSO SINGLE', 'ESPRESSO SINGLE', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/399/1654288488.jpg', 34, 0, 0, '', '', '', 1, '2022-06-03 23:34:48', 0),
(400, 'COFFEE LATTE', 'COFFEE LATTE', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/400/1654288514.jpg', 34, 0, 0, '', '', '', 1, '2022-06-03 23:35:14', 0),
(401, 'CAPPUCCINO', 'CAPPUCCINO', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/401/1654288536.jpg', 34, 0, 0, '', '', '', 1, '2022-06-03 23:35:35', 0),
(402, 'AMERICANO', 'AMERICANO', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/402/1654288589.jpg', 34, 0, 0, '', '', '', 1, '2022-06-03 23:36:29', 0),
(403, 'SINGLE TURKISH COFFEE', 'SINGLE TURKISH COFFEE', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/403/1654288622.jpg', 34, 0, 0, '', '', '', 1, '2022-06-03 23:37:02', 0),
(404, 'SINGLE FRENCH COFFEE ESPRESSO MACCHIATO', 'SINGLE FRENCH COFFEE ESPRESSO MACCHIATO', '', '', 'http://zellarestaurants.com/system/api/uploads/sub_category/404/1654288648.jpg', 34, 0, 0, '', '', '', 1, '2022-06-03 23:37:27', 0);

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

--
-- Table structure for table `sub_categories_addition_prices`
--

CREATE TABLE `sub_categories_addition_prices` (
  `sub_category_addition_price_id` int(11) NOT NULL,
  `sub_category_addition_name` varchar(255) NOT NULL,
  `sub_category_addition_name_ar` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `sub_category_addition_price` varchar(255) NOT NULL,
  `sub_category_id` int(11) NOT NULL,
  `date` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

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

--
-- Table structure for table `sub_categories_size_prices`
--

CREATE TABLE `sub_categories_size_prices` (
  `sub_category_size_price_id` int(11) NOT NULL,
  `sub_category_size_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `sub_category_size_name_ar` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `sub_category_size_price` varchar(255) NOT NULL,
  `sub_category_id` int(11) NOT NULL,
  `display` int(11) NOT NULL DEFAULT 1,
  `date` varchar(225) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `sub_categories_size_prices`
--

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

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

--
-- Table structure for table `sub_category_comments`
--

CREATE TABLE `sub_category_comments` (
  `comment_id` int(11) NOT NULL,
  `client_id` varchar(255) NOT NULL,
  `sub_category_id` varchar(255) NOT NULL,
  `comment` text NOT NULL,
  `rate` varchar(255) NOT NULL,
  `viewed` int(11) NOT NULL,
  `date` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

--
-- Table structure for table `support`
--

CREATE TABLE `support` (
  `id` int(11) NOT NULL,
  `title` text NOT NULL,
  `title_en` text CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `number` text CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `support`
--

INSERT INTO `support` (`id`, `title`, `title_en`, `number`) VALUES
(1, 'في حالة وجود أي مشكلة فنية في التطبيق برجاء الإتصال على الإيميل التالي', 'In case of any technical problem in the application please contact the following email', 'soon@gmail.com');

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

--
-- Table structure for table `terms_conditions`
--

CREATE TABLE `terms_conditions` (
  `id` int(11) NOT NULL,
  `type` int(11) NOT NULL COMMENT 'depit=>1 & credit=>2',
  `name_ar` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `name_en` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `terms_conditions`
--

INSERT INTO `terms_conditions` (`id`, `type`, `name_ar`, `name_en`) VALUES
(1, 1, 'الرجاء قراءة  شروط الاستخدام و إخلاء المسؤلية بعناية قبل استخدام بطاقة الإئتمان.\r\n\r\n-يجب أن تكون بطاقات الإئتمان/السحب الآلي المستخدمة للسداد على تطبيق مخابز المنار أو تطبيقاته ملك المستخدم.\r\n- كل عملية سداد تتم بعد التحقق من صلاحية البطاقة و مستخدمها من قبل الشركة المسئولة عن تشغيل بوابة الدفع الالكتروني\r\n\r\n• يلتزم العميل عند استلامه للطلب بالسداد النقدى لاى رسوم مستحقة عن اية اضافات ( خاصة او عامه) لم تكن مضافة وقت اتمام عملية الشراء .\r\n\r\n للعميل الحق في الغاء الطلب إذا تاخر التوصيل أكثر من الوقت المحدد للتوصيل والمذكور على صفحة معلومات المخبز في تطبيق مخابز المنار .وسوف يتم إعادة القيمة المدفوعة إلى حساب العميل ، بعد التحقق من سبب التأخير .\r\n\r\n• للعميل الحق في الغاء الطلب إذا تاخر التوصيل أكثر من الوقت المحدد للتوصيل والمذكور على صفحة معلومات المخبز في تطبيق مخابز المنار. وسوف يتم إعادة القيمة المدفوعة إلى حساب العميل ،بعد التحقق من سبب التأخير .\r\n\r\n• تستغرق اجراءات استرداد العميل لاي مبالغ مستحقة له حسب الانظمة المتبعة داخل البنك التي تعود اليه البطاقة وبمدة اقصاها 21 يوم عمل ، في حال التاخير عن رد المبلغ الى الحساب على العميل مراجعة بنكه ، وسوف نقوم بارسال بريد الكتروني يتضمن نسخه من أشعار الاسترجاع الصادر من بوابة الدفع الالكتروني حتى يتمكن العميل من المتابعة في حال تأخر بنكه .\r\n\r\n • العملاء الذين يستخدمون خدمة بوابة الدفع الالكتروني يجب أن تكون ارقام هواتف العميل محدثة وصالحة .\r\n\r\n • اذا لم يتوفر صنف معين من الطلب الذي قام به العميل ، يحق للعميل استبداله بصنف اخر بموافقة العميل والمخبز او يحق له الغاء الطلب وانشاء طلب اخر عن طريق تطبيق مخابز المنار او تطبيقاته ، وسوف يتم رد القيمة المدفوعه للطلب الملغي الى حساب العميل خلال المدة المذكورة في البند السادس .\r\n\r\n• يقر العميل بقبول جميع شروط و أحكام الخدمة في حال استخدامها .', 'Please read the following terms of use and disclaimers carefully before using Credit Card:\r\n\r\n- Credit/Debit Cards used in placing orders through the online payment gateway facility on Al Manar Bakery website or applications must belong to the user.\r\n\r\n- All transactions are being processed after on online payment gateway service provider\'s validation process.\r\n\r\n-The customer is liable to pay cash on delivery to the driver in case the \"Special Request\" or \"General Request\" may requires extra charges required by Bakery.<br/>.\r\n\r\n-You may cancel the order if the delivery time exceeded the Bakery delivery promise time highlighted in the Bakery info section, your paid amount will be refunded back to your account, and after validating the delay reason.\r\n\r\n-The customer refund procedure depend on the charge back process of customer\'s bank with maximum period of 21 working days, and then the customer has to follow on with his bank in case any delay in crediting his account back with the amount previously paid by him. Al Manar Bakery will be sending an email to the customer that contains a printout of the refund advice printed from online payment gateway as reference in case the customer wants to revise the bank with.\r\n\r\n- Customers using the online payment facility are requested to be available on their respective contact numbers.\r\n\r\n-If customer faces the inconvenience of a missing item informed by Bakery, both parties (Bakery and customer) can agree on a substitute item. In any other case, the customer can cancel his order and place a new order via Al Manar Bakery App platforms, in this case the full amount of his canceled order will be refunded as mentioned above in item no. 6\r\n\r\n- The customer is entirely liable for placing an order using the Credit Cards facility after carefully reading all the terms & conditions');

--
-- Indexes for dumped tables
--

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

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

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

--
-- Indexes for table `cart`
--
ALTER TABLE `cart`
  ADD PRIMARY KEY (`cart_id`);

--
-- Indexes for table `client_addresses`
--
ALTER TABLE `client_addresses`
  ADD PRIMARY KEY (`client_address_id`);

--
-- Indexes for table `client_fav`
--
ALTER TABLE `client_fav`
  ADD PRIMARY KEY (`fav_id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `parent_categories`
--
ALTER TABLE `parent_categories`
  ADD PRIMARY KEY (`parent_category_id`);

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

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

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

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

--
-- Indexes for table `regions`
--
ALTER TABLE `regions`
  ADD PRIMARY KEY (`region_id`);

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

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

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

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

--
-- Indexes for table `sub_categories`
--
ALTER TABLE `sub_categories`
  ADD PRIMARY KEY (`sub_category_id`);

--
-- Indexes for table `sub_categories_addition_prices`
--
ALTER TABLE `sub_categories_addition_prices`
  ADD PRIMARY KEY (`sub_category_addition_price_id`);

--
-- Indexes for table `sub_categories_size_prices`
--
ALTER TABLE `sub_categories_size_prices`
  ADD PRIMARY KEY (`sub_category_size_price_id`);

--
-- Indexes for table `sub_category_comments`
--
ALTER TABLE `sub_category_comments`
  ADD PRIMARY KEY (`comment_id`);

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

--
-- AUTO_INCREMENT for table `cart`
--
ALTER TABLE `cart`
  MODIFY `cart_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `client_addresses`
--
ALTER TABLE `client_addresses`
  MODIFY `client_address_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `parent_categories`
--
ALTER TABLE `parent_categories`
  MODIFY `parent_category_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;

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

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

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

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

--
-- AUTO_INCREMENT for table `regions`
--
ALTER TABLE `regions`
  MODIFY `region_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=109;

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

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

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

--
-- AUTO_INCREMENT for table `sub_categories`
--
ALTER TABLE `sub_categories`
  MODIFY `sub_category_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=405;

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

--
-- AUTO_INCREMENT for table `sub_categories_size_prices`
--
ALTER TABLE `sub_categories_size_prices`
  MODIFY `sub_category_size_price_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=712;

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

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

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

