-- Table structure for table `product_images`
--

CREATE TABLE `product_images` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` int(11) DEFAULT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_images`
--

INSERT INTO `product_images` (`id`, `product_id`, `image`, `created_at`, `updated_at`) VALUES
(19, 7, '5f006ffd15442.jpg', '2020-05-01 04:06:03', '2020-07-04 06:07:17'),
(20, 7, '5f006ffd18542.jpg', '2020-05-01 04:06:03', '2020-07-04 06:07:17'),
(21, 7, '5f006ffd7884b.jpg', '2020-05-01 04:06:03', '2020-07-04 06:07:17'),
(79, 13, '5f006ffd7884b.jpg', '2020-06-25 06:10:25', '2020-07-04 06:07:17'),
(80, 13, '5f006ffd79b1c.jpg', '2020-06-25 06:10:25', '2020-07-04 06:07:17'),
(81, 13, '5f006ffde2622.jpg', '2020-06-25 06:34:21', '2020-07-04 06:07:17'),
(82, 13, '5f006ffde7ce0.jpg', '2020-06-25 06:34:23', '2020-07-04 06:07:17'),
(83, 13, '5f006ffd15442.jpg', '2020-06-25 06:34:26', '2020-07-04 06:07:17'),
(84, 13, '5f006ffd18542.jpg', '2020-06-25 06:34:45', '2020-07-04 06:07:17'),
(85, 10, '5f006ffd7884b.jpg', '2020-06-25 08:16:28', '2020-07-04 06:07:17'),
(86, 10, '5f006ffd79b1c.jpg', '2020-06-25 08:16:28', '2020-07-04 06:07:17'),
(88, 10, '5f006ffde2622.jpg', '2020-06-25 08:16:28', '2020-07-04 06:07:17'),
(89, 10, '5f006ffde7ce0.jpg', '2020-06-25 08:16:29', '2020-07-04 06:07:17'),
(90, 10, '5f006ffd15442.jpg', '2020-06-25 08:16:29', '2020-07-04 06:07:17'),
(91, 10, '5f006ffd18542.jpg', '2020-06-25 08:18:32', '2020-07-04 06:07:17'),
(92, 7, '5f006ffd7884b.jpg', '2020-06-25 08:22:48', '2020-07-04 06:07:17'),
(93, 7, '5f006ffd79b1c.jpg', '2020-06-25 08:22:48', '2020-07-04 06:07:17'),
(94, 7, '5f006ffde2622.jpg', '2020-06-25 08:22:48', '2020-07-04 06:07:17'),
(95, 6, '5f006ffde7ce0.jpg', '2020-06-25 08:25:08', '2020-07-04 06:07:17'),
(96, 6, '5f006ffd15442.jpg', '2020-06-25 08:25:08', '2020-07-04 06:07:17'),
(97, 6, '5f006ffd18542.jpg', '2020-06-25 08:25:09', '2020-07-04 06:07:17'),
(98, 6, '5f006ffd7884b.jpg', '2020-06-25 08:25:09', '2020-07-04 06:07:17'),
(99, 6, '5f006ffd79b1c.jpg', '2020-06-25 08:25:10', '2020-07-04 06:07:17'),
(100, 6, '5f006ffde2622.jpg', '2020-06-25 08:25:10', '2020-07-04 06:07:17'),
(101, 5, '5f006ffde7ce0.jpg', '2020-06-25 08:27:08', '2020-07-04 06:07:17'),
(102, 5, '5f006ffd15442.jpg', '2020-06-25 08:27:08', '2020-07-04 06:07:17'),
(103, 5, '5f006ffd18542.jpg', '2020-06-25 08:27:09', '2020-07-04 06:07:17'),
(104, 5, '5f006ffd7884b.jpg', '2020-06-25 08:27:09', '2020-07-04 06:07:17'),
(105, 5, '5f006ffd79b1c.jpg', '2020-06-25 08:27:09', '2020-07-04 06:07:17'),
(106, 5, '5f006ffde2622.jpg', '2020-06-25 08:27:09', '2020-07-04 06:07:17'),
(113, 14, '5f006ffde7ce0.jpg', '2020-06-25 08:45:50', '2020-07-04 06:07:17'),
(114, 14, '5f006ffd15442.jpg', '2020-06-25 08:45:50', '2020-07-04 06:07:17'),
(115, 14, '5f006ffd18542.jpg', '2020-06-25 08:45:50', '2020-07-04 06:07:17'),
(116, 14, '5f006ffd7884b.jpg', '2020-06-25 08:45:50', '2020-07-04 06:07:17'),
(117, 14, '5f006ffd79b1c.jpg', '2020-06-25 08:45:50', '2020-07-04 06:07:17'),
(118, 14, '5f006ffde2622.jpg', '2020-06-25 08:45:50', '2020-07-04 06:07:17'),
(119, 15, '5f006ffde7ce0.jpg', '2020-06-25 08:48:42', '2020-07-04 06:07:17'),
(120, 15, '5f006ffd15442.jpg', '2020-06-25 08:48:42', '2020-07-04 06:07:17'),
(121, 15, '5f006ffd18542.jpg', '2020-06-25 08:48:43', '2020-07-04 06:07:17'),
(122, 15, '5f006ffd7884b.jpg', '2020-06-25 08:48:43', '2020-07-04 06:07:17'),
(123, 15, '5f006ffd79b1c.jpg', '2020-06-25 08:48:43', '2020-07-04 06:07:17'),
(124, 15, '5f006ffde2622.jpg', '2020-06-25 08:48:43', '2020-07-04 06:07:17'),
(125, 16, '5f006ffde7ce0.jpg', '2020-06-25 08:51:00', '2020-07-04 06:07:17'),
(126, 16, '5f006ffd15442.jpg', '2020-06-25 08:51:00', '2020-07-04 06:07:17'),
(127, 16, '5f006ffd18542.jpg', '2020-06-25 08:51:00', '2020-07-04 06:07:17'),
(128, 16, '5f006ffd7884b.jpg', '2020-06-25 08:51:00', '2020-07-04 06:07:17'),
(129, 16, '5f006ffd79b1c.jpg', '2020-06-25 08:51:01', '2020-07-04 06:07:17'),
(130, 16, '5f006ffde2622.jpg', '2020-06-25 08:51:01', '2020-07-04 06:07:17'),
(240, NULL, '5f006ffde7ce0.jpg', '2020-06-26 01:47:09', '2020-07-04 06:07:17'),
(241, NULL, '5f006ffd15442.jpg', '2020-06-26 01:47:09', '2020-07-04 06:07:17'),
(242, NULL, '5f006ffd18542.jpg', '2020-06-26 01:47:10', '2020-07-04 06:07:17'),
(243, NULL, '5f006ffd7884b.jpg', '2020-06-26 01:47:10', '2020-07-04 06:07:17'),
(244, NULL, '5f006ffd79b1c.jpg', '2020-06-26 01:47:10', '2020-07-04 06:07:17'),
(245, NULL, '5f006ffde2622.jpg', '2020-06-26 01:47:10', '2020-07-04 06:07:17'),
(252, NULL, '5f006ffde7ce0.jpg', '2020-06-26 04:52:38', '2020-07-04 06:07:17'),
(253, NULL, '5f006ffd15442.jpg', '2020-06-26 04:52:38', '2020-07-04 06:07:17'),
(254, NULL, '5f006ffd18542.jpg', '2020-06-26 04:52:39', '2020-07-04 06:07:17'),
(255, NULL, '5f006ffd7884b.jpg', '2020-06-26 04:52:39', '2020-07-04 06:07:17'),
(256, NULL, '5f006ffd79b1c.jpg', '2020-06-26 04:52:39', '2020-07-04 06:07:17'),
(257, NULL, '5f006ffde2622.jpg', '2020-06-26 04:52:46', '2020-07-04 06:07:17'),
(258, 35, '5f006ffde7ce0.jpg', '2020-06-26 05:05:06', '2020-07-04 06:07:17'),
(259, 35, '5f006ffd15442.jpg', '2020-06-26 05:05:07', '2020-07-04 06:07:17'),
(260, 35, '5f006ffd18542.jpg', '2020-06-26 05:05:07', '2020-07-04 06:07:18'),
(261, 35, '5f006ffd7884b.jpg', '2020-06-26 05:05:07', '2020-07-04 06:07:18'),
(262, 35, '5f006ffd79b1c.jpg', '2020-06-26 05:05:07', '2020-07-04 06:07:18'),
(263, 35, '5f006ffde2622.jpg', '2020-06-26 05:05:13', '2020-07-04 06:07:18'),
(264, 36, '5f006ffde7ce0.jpg', '2020-06-26 05:11:00', '2020-07-04 06:07:18'),
(265, 36, '5f006ffd15442.jpg', '2020-06-26 05:11:00', '2020-07-04 06:07:18'),
(266, 36, '5f006ffd18542.jpg', '2020-06-26 05:11:00', '2020-07-04 06:07:18'),
(267, 36, '5f006ffd7884b.jpg', '2020-06-26 05:11:00', '2020-07-04 06:07:18'),
(268, 36, '5f006ffd79b1c.jpg', '2020-06-26 05:11:01', '2020-07-04 06:07:18'),
(269, 36, '5f006ffde2622.jpg', '2020-06-26 05:11:01', '2020-07-04 06:07:18'),
(270, 37, '5f006ffde7ce0.jpg', '2020-06-26 05:18:56', '2020-07-04 06:07:18'),
(271, 37, '5f006ffd15442.jpg', '2020-06-26 05:18:56', '2020-07-04 06:07:18'),
(272, 37, '5f006ffd18542.jpg', '2020-06-26 05:18:56', '2020-07-04 06:07:18'),
(273, 37, '5f006ffd7884b.jpg', '2020-06-26 05:18:56', '2020-07-04 06:07:18'),
(274, 37, '5f006ffd79b1c.jpg', '2020-06-26 05:18:57', '2020-07-04 06:07:18'),
(275, 37, '5f006ffde2622.jpg', '2020-06-26 05:18:57', '2020-07-04 06:07:18'),
(276, 38, '5f006ffde7ce0.jpg', '2020-06-26 05:22:26', '2020-07-04 06:07:18'),
(277, 38, '5f006ffd15442.jpg', '2020-06-26 05:22:26', '2020-07-04 06:07:18'),
(278, 38, '5f006ffd18542.jpg', '2020-06-26 05:22:26', '2020-07-04 06:07:18'),
(279, 38, '5f006ffd7884b.jpg', '2020-06-26 05:22:26', '2020-07-04 06:07:18'),
(280, 38, '5f006ffd79b1c.jpg', '2020-06-26 05:22:27', '2020-07-04 06:07:18'),
(281, 38, '5f006ffde2622.jpg', '2020-06-26 05:22:27', '2020-07-04 06:07:18'),
(282, 39, '5f006ffde7ce0.jpg', '2020-06-26 05:26:44', '2020-07-04 06:07:18'),
(283, 39, '5f006ffd15442.jpg', '2020-06-26 05:26:44', '2020-07-04 06:07:18'),
(284, 39, '5f006ffd18542.jpg', '2020-06-26 05:26:44', '2020-07-04 06:07:18'),
(285, 39, '5f006ffd7884b.jpg', '2020-06-26 05:26:44', '2020-07-04 06:07:18'),
(286, 39, '5f006ffd79b1c.jpg', '2020-06-26 05:26:45', '2020-07-04 06:07:18'),
(287, 39, '5f006ffde2622.jpg', '2020-06-26 05:26:45', '2020-07-04 06:07:18'),
(288, 40, '5f006ffde7ce0.jpg', '2020-06-26 05:29:55', '2020-07-04 06:07:18'),
(289, 40, '5f006ffd15442.jpg', '2020-06-26 05:29:55', '2020-07-04 06:07:18'),
(290, 40, '5f006ffd18542.jpg', '2020-06-26 05:29:55', '2020-07-04 06:07:18'),
(291, 40, '5f006ffd7884b.jpg', '2020-06-26 05:29:55', '2020-07-04 06:07:18'),
(292, 40, '5f006ffd79b1c.jpg', '2020-06-26 05:29:55', '2020-07-04 06:07:18'),
(293, 40, '5f006ffde2622.jpg', '2020-06-26 05:29:55', '2020-07-04 06:07:18'),
(294, 41, '5f006ffde7ce0.jpg', '2020-06-26 05:34:55', '2020-07-04 06:07:18'),
(295, 41, '5f006ffd15442.jpg', '2020-06-26 05:34:55', '2020-07-04 06:07:18'),
(296, 41, '5f006ffd18542.jpg', '2020-06-26 05:34:56', '2020-07-04 06:07:18'),
(297, 41, '5f006ffd7884b.jpg', '2020-06-26 05:34:56', '2020-07-04 06:07:18'),
(298, 41, '5f006ffd79b1c.jpg', '2020-06-26 05:34:56', '2020-07-04 06:07:18'),
(299, 41, '5f006ffde2622.jpg', '2020-06-26 05:34:56', '2020-07-04 06:07:18'),
(300, 42, '5f006ffde7ce0.jpg', '2020-06-26 05:38:55', '2020-07-04 06:07:18'),
(301, 42, '5f006ffd15442.jpg', '2020-06-26 05:38:55', '2020-07-04 06:07:18'),
(302, 42, '5f006ffd18542.jpg', '2020-06-26 05:38:56', '2020-07-04 06:07:18'),
(303, 42, '5f006ffd7884b.jpg', '2020-06-26 05:38:56', '2020-07-04 06:07:18'),
(304, 42, '5f006ffd79b1c.jpg', '2020-06-26 05:38:56', '2020-07-04 06:07:18'),
(305, 42, '5f006ffde2622.jpg', '2020-06-26 05:38:56', '2020-07-04 06:07:18'),
(306, 43, '5f006ffde7ce0.jpg', '2020-06-26 05:40:23', '2020-07-04 06:07:18'),
(307, 43, '5f006ffd15442.jpg', '2020-06-26 05:40:23', '2020-07-04 06:07:18'),
(308, 43, '5f006ffd18542.jpg', '2020-06-26 05:40:23', '2020-07-04 06:07:18'),
(309, 43, '5f006ffd7884b.jpg', '2020-06-26 05:40:23', '2020-07-04 06:07:18'),
(311, 43, '5f006ffd79b1c.jpg', '2020-06-26 05:40:24', '2020-07-04 06:07:18'),
(312, 43, '5f006ffde2622.jpg', '2020-06-26 05:40:24', '2020-07-04 06:07:18'),
(313, 4, '5f006ffde7ce0.jpg', '2020-07-04 06:03:09', '2020-07-04 06:07:18'),
(314, 4, '5f006ffd15442.jpg', '2020-07-04 06:03:09', '2020-07-04 06:07:18'),
(315, 4, '5f006ffd18542.jpg', '2020-07-04 06:03:09', '2020-07-04 06:07:18'),
(316, 4, '5f006ffd7884b.jpg', '2020-07-04 06:03:09', '2020-07-04 06:07:18'),
(317, 4, '5f006ffd79b1c.jpg', '2020-07-04 06:03:09', '2020-07-04 06:07:18'),
(318, 4, '5f006ffde2622.jpg', '2020-07-04 06:03:09', '2020-07-04 06:07:18'),
(332, 46, '5f006ffde7ce0.jpg', '2020-06-26 05:40:23', '2020-07-04 06:07:18'),
(333, 46, '5f006ffd15442.jpg', '2020-06-26 05:40:23', '2020-07-04 06:07:18'),
(334, 46, '5f006ffd18542.jpg', '2020-06-26 05:40:23', '2020-07-04 06:07:18'),
(335, 46, '5f006ffd7884b.jpg', '2020-06-26 05:40:23', '2020-07-04 06:07:18'),
(336, 46, '5f006ffd79b1c.jpg', '2020-06-26 05:40:24', '2020-07-04 06:07:18'),
(337, 46, '5f006ffde2622.jpg', '2020-06-26 05:40:24', '2020-07-04 06:07:18'),
(338, 47, '5f006ffde7ce0.jpg', '2020-07-04 06:03:09', '2020-07-04 06:07:18'),
(339, 47, '5f006ffd15442.jpg', '2020-07-04 06:03:09', '2020-07-04 06:07:18'),
(340, 47, '5f006ffd18542.jpg', '2020-07-04 06:03:09', '2020-07-04 06:07:18'),
(341, 47, '5f006ffd7884b.jpg', '2020-07-04 06:03:09', '2020-07-04 06:07:18'),
(342, 47, '5f006ffd79b1c.jpg', '2020-07-04 06:03:09', '2020-07-04 06:07:18'),
(343, 47, '5f006ffde2622.jpg', '2020-07-04 06:03:09', '2020-07-04 06:07:18'),
(366, 53, '5f006ffde7ce0.jpg', '2020-06-26 05:40:23', '2020-07-04 06:07:18'),
(367, 53, '5f006ffd15442.jpg', '2020-06-26 05:40:23', '2020-07-04 06:07:18'),
(368, 53, '5f006ffd18542.jpg', '2020-06-26 05:40:23', '2020-07-04 06:07:18'),
(369, 53, '5f006ffd7884b.jpg', '2020-06-26 05:40:23', '2020-07-04 06:07:18'),
(370, 53, '5f006ffd79b1c.jpg', '2020-06-26 05:40:24', '2020-07-04 06:07:18'),
(371, 53, '5f006ffde2622.jpg', '2020-06-26 05:40:24', '2020-07-04 06:07:18'),
(372, 54, '5f006ffde7ce0.jpg', '2020-07-04 06:03:09', '2020-07-04 06:07:18'),
(373, 54, '5f006ffd15442.jpg', '2020-07-04 06:03:09', '2020-07-04 06:07:18'),
(374, 54, '5f006ffd18542.jpg', '2020-07-04 06:03:09', '2020-07-04 06:07:18'),
(375, 54, '5f006ffd7884b.jpg', '2020-07-04 06:03:09', '2020-07-04 06:07:18');

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

--
-- Table structure for table `product_orders`
--

CREATE TABLE `product_orders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `billing_country` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `billing_fname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `billing_lname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `billing_address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `billing_city` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `billing_email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `billing_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `shpping_country` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `shpping_fname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `shpping_lname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `shpping_address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `shpping_city` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `shpping_email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `shpping_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cart_total` decimal(8,2) NOT NULL DEFAULT '0.00',
  `discount` decimal(8,2) NOT NULL DEFAULT '0.00',
  `tax` decimal(8,2) NOT NULL DEFAULT '0.00',
  `total` decimal(11,2) DEFAULT NULL,
  `method` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `gateway_type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `shipping_method` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_charge` decimal(11,2) DEFAULT NULL,
  `payment_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `txnid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `charge_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `invoice_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `receipt` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_orders`
--

INSERT INTO `product_orders` (`id`, `user_id`, `billing_country`, `billing_fname`, `billing_lname`, `billing_address`, `billing_city`, `billing_email`, `billing_number`, `shpping_country`, `shpping_fname`, `shpping_lname`, `shpping_address`, `shpping_city`, `shpping_email`, `shpping_number`, `cart_total`, `discount`, `tax`, `total`, `method`, `gateway_type`, `currency_code`, `order_number`, `shipping_method`, `shipping_charge`, `payment_status`, `order_status`, `txnid`, `charge_id`, `created_at`, `updated_at`, `invoice_number`, `receipt`) VALUES
(189, 26, 'Australia', 'John', 'Doe', 'Melbourne, Australia', 'Melbourne', 'geniustest11@gmail.com', '262332', 'Australia', 'John', 'Doe', 'Melbourne, Australia', 'Melbourne', 'geniustest11@gmail.com', '3636237', '1061.00', '0.00', '53.05', '1114.05', 'mollie', 'online', 'USD', 'vhWX1619160365', NULL, '0.00', 'Completed', 'pending', 'txn_3aBckhcF1619160365', 'ch_icP8PV9fE1619160365', '2021-04-23 02:46:05', '2021-04-23 02:46:22', 'Zi1W1619160377.pdf', NULL),
(190, 26, 'Australia', 'John', 'Doe', 'Melbourne, Australia', 'Melbourne', 'geniustest11@gmail.com', '262332', 'Australia', 'John', 'Doe', 'Melbourne, Australia', 'Melbourne', 'geniustest11@gmail.com', '3636237', '111.00', '0.00', '5.55', '116.55', 'Concert', 'offline', 'USD', 'vT5p1619160444', NULL, '0.00', 'Pending', 'pending', 'txn_gxYtPBDg1619160444', 'ch_vCEZ3zSqa1619160444', '2021-04-23 02:47:24', '2021-04-23 02:47:29', 'iOrI1619160444.pdf', '60826d7cc0936.jpg'),
(191, 26, 'Australia', 'John', 'Doe', 'Melbourne, Australia', 'Melbourne', 'geniustest11@gmail.com', '262332', 'Australia', 'John', 'Doe', 'Melbourne, Australia', 'Melbourne', 'geniustest11@gmail.com', '3636237', '85.00', '0.00', '4.25', '89.25', 'mollie', 'online', 'USD', '2si01619160477', NULL, '0.00', 'Completed', 'pending', 'txn_09wXOWlP1619160477', 'ch_kYikzeoI21619160477', '2021-04-23 02:47:57', '2021-04-23 02:48:12', 'fgLs1619160486.pdf', NULL),
(192, 26, 'Australia', 'John', 'Doe', 'Melbourne, Australia', 'Melbourne', 'geniustest11@gmail.com', '262332', 'Australia', 'John', 'Doe', 'Melbourne, Australia', 'Melbourne', 'geniustest11@gmail.com', '3636237', '120.00', '0.00', '6.00', '126.00', 'paypal', 'online', 'USD', 'x4ac1619160573', NULL, '0.00', 'Completed', 'pending', '92H316910D389741X', 'PAYID-MCBG3XY8C758321J3613780H', '2021-04-23 02:49:33', '2021-04-23 02:49:39', 'Pa4W1619160573.pdf', NULL),
(193, 26, 'Australia', 'John', 'Doe', 'Melbourne, Australia', 'Melbourne', 'geniustest11@gmail.com', '262332', 'Australia', 'John', 'Doe', 'Melbourne, Australia', 'Melbourne', 'geniustest11@gmail.com', '3636237', '290.00', '0.00', '14.50', '304.50', 'stripe', 'online', 'USD', 'TkRk1619160630', NULL, '0.00', 'Completed', 'pending', 'txn_1IjIqSJlIV5dN9n7MV1IayJ4', 'ch_1IjIqSJlIV5dN9n7ljeXVRmr', '2021-04-23 02:50:30', '2021-04-23 02:50:34', 'kRZJ1619160630.pdf', NULL),
(194, 26, 'Australia', 'John', 'Doe', 'Melbourne, Australia', 'Melbourne', 'geniustest11@gmail.com', '262332', 'Australia', 'John', 'Doe', 'Melbourne, Australia', 'Melbourne', 'geniustest11@gmail.com', '3636237', '60.00', '0.00', '3.00', '63.00', 'mollie', 'online', 'USD', 'D1GF1619172781', NULL, '0.00', 'Completed', 'pending', 'txn_p3EIoFmu1619172781', 'ch_hK2qKA4N61619172781', '2021-04-23 06:13:01', '2021-04-23 06:13:17', '02oL1619172792.pdf', NULL),
(195, 26, 'Australia', 'John', 'Doe', 'Melbourne, Australia', 'Melbourne', 'geniustest11@gmail.com', '262332', 'Australia', 'John', 'Doe', 'Melbourne, Australia', 'Melbourne', 'geniustest11@gmail.com', '3636237', '61.00', '0.00', '3.05', '74.05', 'paypal', 'online', 'USD', 'qG1L1619175463', 'Same Day Shipping', '10.00', 'Completed', 'pending', '30R54466LG0826941', 'PAYID-MCBKPUA5TN241911N973805S', '2021-04-23 06:57:43', '2021-04-23 06:57:47', 'bj4x1619175463.pdf', NULL),
(196, 26, 'Australia', 'John', 'Doe', 'Melbourne, Australia', 'Melbourne', 'geniustest11@gmail.com', '262332', 'Australia', 'John', 'Doe', 'Melbourne, Australia', 'Melbourne', 'geniustest11@gmail.com', '3636237', '180.00', '0.00', '9.00', '199.00', 'payumoney', 'online', 'INR', 'n56O1619335908', 'Same Day Shipping', '10.00', 'Pending', 'pending', 'txn_fKN8deHV1619335908', 'ch_oU0NoXRRe1619335908', '2021-04-25 03:31:48', '2021-04-25 03:31:48', NULL, NULL),
(197, 26, 'Australia', 'John', 'Doe', 'Melbourne, Australia', 'Melbourne', 'geniustest11@gmail.com', '262332', 'Australia', 'John', 'Doe', 'Melbourne, Australia', 'Melbourne', 'geniustest11@gmail.com', '3636237', '180.00', '0.00', '9.00', '199.00', 'payumoney', 'online', 'INR', 'tbHx1619335939', 'Same Day Shipping', '10.00', 'Pending', 'pending', 'txn_3bevh7bN1619335939', 'ch_mGh4u6NeM1619335939', '2021-04-25 03:32:19', '2021-04-25 03:32:19', NULL, NULL),
(198, 26, 'Australia', 'John', 'Doe', 'Melbourne, Australia', 'Melbourne', 'geniustest11@gmail.com', '262332', 'Australia', 'John', 'Doe', 'Melbourne, Australia', 'Melbourne', 'geniustest11@gmail.com', '3636237', '120.00', '0.00', '6.00', '126.00', 'mollie', 'online', 'USD', 'XIA01619416083', NULL, '0.00', 'Pending', 'pending', 'txn_hmfxNyzj1619416083', 'ch_mOz1pvVKE1619416083', '2021-04-26 01:48:03', '2021-04-26 01:48:03', NULL, NULL),
(199, 26, 'Australia', 'John', 'Doe', 'Melbourne, Australia', 'Melbourne', 'geniustest11@gmail.com', '262332', 'Australia', 'John', 'Doe', 'Melbourne, Australia', 'Melbourne', 'geniustest11@gmail.com', '3636237', '120.00', '0.00', '6.00', '126.00', 'mollie', 'online', 'USD', 'QZuh1619416083', NULL, '0.00', 'Completed', 'pending', 'txn_s1DhmRGo1619416083', 'ch_6xQZWhZds1619416083', '2021-04-26 01:48:03', '2021-04-26 01:48:19', 'Oxnn1619416094.pdf', NULL);

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

--
-- Table structure for table `product_reviews`
--

CREATE TABLE `product_reviews` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `review` int(11) DEFAULT NULL,
  `comment` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_reviews`
--

INSERT INTO `product_reviews` (`id`, `user_id`, `product_id`, `review`, `comment`, `created_at`, `updated_at`) VALUES
(25, 26, 47, 5, 'Great product with great features', '2021-04-27 11:23:39', '2021-04-27 11:23:39'),
(26, 26, 46, 4, 'Needs more improvement', '2021-04-27 11:24:22', '2021-04-27 11:24:22'),
(27, 26, 16, 3, 'Slow Delivery', '2021-04-27 11:29:17', '2021-04-27 11:29:17'),
(28, 26, 14, 5, 'Awesome Product Quality', '2021-04-27 11:30:01', '2021-04-27 11:30:01'),
(29, 26, 10, 5, 'Loved this', '2021-04-27 11:30:21', '2021-04-27 11:30:21');

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

--
-- Table structure for table `push_subscriptions`
--

CREATE TABLE `push_subscriptions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `subscribable_id` int(11) DEFAULT NULL,
  `subscribable_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `endpoint` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `public_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `auth_token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content_encoding` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `push_subscriptions`
--

INSERT INTO `push_subscriptions` (`id`, `subscribable_id`, `subscribable_type`, `endpoint`, `public_key`, `auth_token`, `content_encoding`, `created_at`, `updated_at`) VALUES
(8, 8, 'App\\Guest', 'https://updates.push.services.mozilla.com/wpush/v2/gAAAAABgWtflfgOQ6Zu9YS1cgmd5CpfOnjSoxolT02byjYLKCQBrtUypVyYG9YxI0_ypNnyfZpRSf3tOur7GBiN1R5NGZVkaazRPwt1rILBAeNfNw6AW_N3hWD7Uz-RLxfFc7G7PAegKlgGYoL0n1oUMuZOUI3cIZIb3hYtBa0YoP1YDgAfoAi0', 'BPnWQRwG0w9UpT9SgGIvZu14qiOh6xeJw7LH0SGB9yQ8rotD3PcoVP6baA5tkgHYeKbkBVc0zKscFanqLvSE2jI', 'xXBSBQEM1NUoevPvlcWIVw', NULL, '2021-03-24 01:10:47', '2021-03-24 01:10:47'),
(12, 12, 'App\\Guest', 'https://fcm.googleapis.com/fcm/send/ePVnvajFeiI:APA91bGq-39Kc1Fkd-zRkBFQpDGMg_5imZE3v9rAr2lROlddO8kuaGYu14TIqTgCcSfYcj2vdE4SseA6GGkWUSbWZ36QfQZ473gjhmySfjrejZCWzeUMPA7rvC1vSKAQO0Y_pFdi5GN4', 'BP8zlomQZjQJiXQSIq76fXOnx97m8FQ7A8HEcKcec1QctWy-XbMjltJzkrOVeBVbf-QwuyHau3q07ybsf2Qm3Wc', 'jervq3GZEY9dDVZAqzJ07Q', NULL, '2021-03-24 01:34:25', '2021-03-24 01:34:25'),
(13, 13, 'App\\Guest', 'https://fcm.googleapis.com/fcm/send/fu6oitmYVck:APA91bHhXzg09rOpqrdAoT0Yh0IZqeU-9e_x19erSEj0vTSTR3l6rwMeAqgdItO424bGFKspr3e8YzMQqBWRB92w2wIOt2jl4JoFOKCkwJf5-mlyCbEm8b1OTM8XBvnaIWK80n1vIiaR', 'BKVDKIk2ATHOu5to_S_3ZfQQVCP1Gm6zV5sOX7SAHMU8jW5rrrQWfo514rTYpeokmsmwAfXHHF77WtwD9UK2gOM', 'hd6ymyExKJVa0YCu5FFpWQ', NULL, '2021-03-27 03:01:25', '2021-03-27 03:01:25'),
(14, 14, 'App\\Guest', 'https://fcm.googleapis.com/fcm/send/dpgbvm6epIE:APA91bEUYPYKzkwFwSKeXHBV8tfnMzl5AD4ppwV5rWxXecMbgWa4xHR8MvrtQbZp3yzccKxtwkWD_kpGaY8JAv_Kqu7Jk3SgeeHFOHepdHgOf8E4N508LYPVgYkNiy5QxgqgIUr5q0IZ', 'BKnwb86nKQbTku3-ISzx5ePQM_nBRBLViVG4N-rbbJsJ2wuwcb3w_T3tXXOVaGRQq9SP7OCL8mfy23aPShl96k8', 's-tG0IObSQZD8ojoGdHvCw', NULL, '2021-04-14 10:44:25', '2021-04-14 10:44:25'),
(15, 15, 'App\\Guest', 'https://fcm.googleapis.com/fcm/send/c2XDdsDjihs:APA91bGw6qL9AlsxupM7pm_pMnmreYoKA2XR-mzMgYY-38jsoGGnLeVLJtvel1ZYxT65CTWCjrf_ORsauuT-tf0f4gt5mViEW_Dsfmquznydd6tAUtvlYuEY_vWYt3RbvUI1_XJeeqgv', 'BFDTotw-yfDWUPLHaE3ekIk--nP__ysHpVTGvhLfHX88oSBhPgj4QHhCGOSq4IAWwiYCg3cu9pg0aDti5nHO1us', '2zvOZ-TR_uIZVC2g_O_C8g', NULL, '2021-04-25 09:06:36', '2021-04-25 09:06:36'),
(16, 16, 'App\\Guest', 'https://fcm.googleapis.com/fcm/send/d06HjG6uuJA:APA91bEldEfcLC3LXmfqc5hCaNAG-EMSHfstmJJUR_Aij198-1M7wVSsSOjQmbcyY6IM9MnOHUNEpxNgxmKk4FntREOvvmU11YcPPZavaSnjfdDVA93V1n3fxU-pEFiNqv_X8E3BkRT2', 'BGtLBCEPoXpSJokUfWe7orbOTnJWgRst07qRlt3X2S68TKz6wGt_KTjx2dUcuwvEYj3k5cux1grJ7QK02h6jUKg', 'h18crFw74nhwg5R8YhKVKg', NULL, '2021-04-27 02:32:16', '2021-04-27 02:32:16'),
(17, 17, 'App\\Guest', 'https://fcm.googleapis.com/fcm/send/eKTWhxsYWbI:APA91bHc7rvS_TSHtRbjd4xum5InsJaZ8aDy1J8Nf49wh93cAsJF4144oHSQ_QDZK4mO9OIL-5huovIpag9QPWaa7yuWwPyX4fJAhW6jKql7lHJkcIjgGAV_f2zBOuIp70HVM4Q8l27r', 'BMuX_yvlsrSOyHKywAxDuQu3_P0j752i6UaEr-HFXuiHAPOtl9kaf9m-j5Uc2sIIDxkOVsyrIM6EY5cF3BgNjlI', 'hk9aG-EYTPsp5XHPj7h_Qw', NULL, '2021-04-27 02:37:26', '2021-04-27 02:37:26'),
(18, 18, 'App\\Guest', 'https://fcm.googleapis.com/fcm/send/fwojJWPvePo:APA91bFOGKbDMjw1De_t6xM46UcTTsjpU3M5aVGn_ZDSTMls2lvybwGjCOOBqLsTgM8DY4gV2FEmFGQIsN1DxMa-jxsiUHdfjxmKfOfc2fGVss_TkKPa5YGEjlZMoR7jngMuBrKewkHo', 'BOoUElEJH7lUtIr4qhbTLncEt2ozSQBfbd06b0OU-hQ-EaWdRePCEtdfkKU_lqWhHGszZMz8suXsscqdbPxG4KQ', 'jsoqD0zF_6WF3dXtO8jMcw', NULL, '2021-04-27 08:16:34', '2021-04-27 08:16:34'),
(19, 19, 'App\\Guest', 'https://fcm.googleapis.com/fcm/send/eHjC8h2vvJo:APA91bF0hUTLdlj4R8CLHvEMvZDX5EtK3DWwXzQEuNDXTtBV1kw_gGQAcTKPcL_KaFzgDoFTY-TVy8QlKHjbTHCb8DE9jUslWGMx0UJt1-PLkSlElt1hmVJFcMveCULBv5pmRhwYBY3J', 'BHEOiU7w9jbIcBVbyxCRcCobWeN67Jya3gbVBnJHyRsAkzfyAR14Q-CsaxW43M9V-kGTw8ZHUULfyLzplimSFbk', '_xx3CCmB5JRBFegl3trS0w', NULL, '2021-04-27 11:49:58', '2021-04-27 11:49:58'),
(20, 20, 'App\\Guest', 'https://fcm.googleapis.com/fcm/send/d39WZ-aogGo:APA91bFShKOxCjmO1S48qxxH6kxPNyAFklI346h0N2b3Lhas7_rIY21OhvbxJOBct5OEdrgxFqi35cs0wocm2-UxFBA_QeeupON4JAGEf7Dnp62uNpxHOOLkxLuMzIVKESTLWclZiJDX', 'BKXz8PH4XqueMNoRvo7l-4k7VON_qZ1nTdJ8nsJU3jpBBlsWENWMc0lISi74bXiKPKBKU9K947ZAJx0uy0dJKWk', '8-pAUv-QlWK6TCYZ1kR4RQ', NULL, '2021-04-29 03:34:46', '2021-04-29 03:34:46');

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

--
-- Table structure for table `queue_jobs`
--

CREATE TABLE `queue_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint(3) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `quotes`
--

CREATE TABLE `quotes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fields` text COLLATE utf8mb4_unicode_ci,
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0-pending, 1-prcessing, 2-completed, 3-rejected',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `quotes`
--

INSERT INTO `quotes` (`id`, `name`, `email`, `fields`, `status`, `created_at`, `updated_at`) VALUES
(1, 'تجربة ماجيك', 'k.aladi907@gmail.com', '{\"\\u0631\\u0642\\u0645_\\u0627\\u0644\\u0627\\u062a\\u0635\\u0627\\u0644\":{\"value\":\"94989890\",\"type\":1},\"\\u0628\\u0644\\u062f\":{\"value\":\"oman\",\"type\":1},\"\\u0627\\u0644\\u0645\\u064a\\u0632\\u0627\\u0646\\u064a\\u0629_\\u0627\\u0644\\u062a\\u0642\\u0631\\u064a\\u0628\\u064a\\u0629\":{\"value\":\"\\u0642\\u0627\\u0628\\u0644 \\u0644\\u0644\\u062a\\u0641\\u0627\\u0648\\u0636\",\"type\":2},\"\\u0631\\u0642\\u0645_Skype_/_\\u0631\\u0642\\u0645_\\u0648\\u0627\\u062a\\u0633\\u0627\\u0628\":{\"value\":\"94989890\",\"type\":1},\"\\u0627\\u062e\\u062a\\u0631_\\u0646\\u0648\\u0639_\\u0627\\u0644\\u062e\\u062f\\u0645\\u0629_\\u0627\\u0644\\u062a\\u064a_\\u062a\\u0631\\u064a\\u062f\\u0647\\u0627\":{\"value\":[\"\\u0645\\u0648\\u0642\\u0639 \\u0634\\u062e\\u0635\\u064a\"],\"type\":3},\"\\u062a\\u0641\\u0627\\u0635\\u064a\\u0644\":{\"value\":\"test\",\"type\":4},\"\\u0648\\u0642\\u062a\":{\"value\":\"01:30 AM\",\"type\":7},\"\\u0627\\u0644\\u0645\\u0631\\u0641\\u0642\\u0627\\u062a_1\":{\"value\":\"61f7a18bb4cea.zip\",\"type\":5},\"\\u062a\\u0627\\u0631\\u064a\\u062e\":{\"value\":\"01/11/2022\",\"type\":6},\"\\u0627\\u0644\\u0645\\u0644\\u062d\\u0642_2\":{\"value\":\"61f7a18bb503a.zip\",\"type\":5}}', 0, '2022-01-31 15:44:59', '2022-01-31 15:44:59');

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

--
-- Table structure for table `quote_inputs`
--

CREATE TABLE `quote_inputs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT '0',
  `type` tinyint(4) DEFAULT NULL COMMENT '1-text, 2-select, 3-checkbox, 4-textarea, 5-file',
  `label` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `placeholder` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `required` tinyint(4) NOT NULL DEFAULT '0' COMMENT '1 - required, 0 - optional',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `quote_inputs`
--

INSERT INTO `quote_inputs` (`id`, `language_id`, `type`, `label`, `name`, `placeholder`, `required`, `created_at`, `updated_at`) VALUES
(18, 169, 1, 'Contact Number', 'contact_number', 'Enter Contact Number', 1, '2019-12-25 18:57:49', '2019-12-25 18:57:49'),
(19, 169, 1, 'Country', 'country', 'Enter Country Name', 1, '2019-12-25 18:58:11', '2019-12-25 18:58:11'),
(20, 169, 2, 'Approximate Budget', 'approximate_budget', 'Select Approximate Budget', 1, '2019-12-25 18:59:35', '2019-12-25 18:59:35'),
(21, 169, 1, 'Skype ID / Whatsapp Number', 'skype_id_whatsapp_number', 'Enter Skype ID / Whatsapp Number', 1, '2019-12-25 19:00:49', '2019-12-25 19:00:49'),
(22, 169, 3, 'Select Your Choices', 'Select_Your_Choices', NULL, 1, '2019-12-25 19:01:53', '2021-01-23 06:17:55'),
(23, 169, 4, 'Details', 'Details', 'Project Description', 1, '2019-12-25 19:10:59', '2021-01-23 06:28:37'),
(46, 0, 1, 'Contact Number', 'contact_number', 'Enter Contact Number', 1, '2019-12-25 22:30:26', '2019-12-25 22:30:26'),
(47, 0, 1, 'Country', 'country', 'Enter Country Name', 1, '2019-12-25 22:30:58', '2019-12-25 22:30:58'),
(48, 0, 2, 'Approximate Budget', 'approximate_budget', 'Select Approximate Budget', 1, '2019-12-25 22:32:19', '2019-12-25 22:32:19'),
(49, 0, 1, 'Skype ID / Whatsapp Number', 'skype_id_whatsapp_number', 'Enter Skype ID / Whatsapp Number', 1, '2019-12-25 22:32:38', '2019-12-25 22:32:38'),
(50, 0, 3, 'Select Your Choices', 'select_your_choices', NULL, 1, '2019-12-25 22:33:21', '2019-12-25 22:33:21'),
(51, 0, 4, 'Details', 'details', 'Project Description', 1, '2019-12-25 22:33:42', '2019-12-25 22:33:42'),
(54, 173, 1, 'رقم الاتصال', 'رقم_الاتصال', 'أدخل رقم الاتصال', 1, '2019-12-27 22:22:31', '2020-01-07 04:36:34'),
(55, 173, 1, 'بلد', 'بلد', 'أدخل اسم البلد', 1, '2019-12-27 22:22:58', '2020-01-07 04:36:44'),
(56, 173, 2, 'الميزانية التقريبية', 'الميزانية_التقريبية', 'حدد الميزانية التقريبية', 1, '2019-12-27 22:24:59', '2020-01-07 04:36:51'),
(57, 173, 1, 'رقم Skype / رقم واتساب', 'رقم_Skype_/_رقم_واتساب', 'أدخل معرف Skype / رقم Whatsapp', 1, '2019-12-27 22:26:41', '2020-01-07 04:37:03'),
(58, 173, 3, 'اختر نوع الخدمة التي تريدها', 'اختر_نوع_الخدمة_التي_تريدها', NULL, 1, '2019-12-27 22:27:52', '2021-08-20 04:12:30'),
(59, 173, 4, 'تفاصيل', 'تفاصيل', 'وصف المشروع', 1, '2019-12-27 22:28:20', '2020-01-07 04:37:15'),
(61, 169, 7, 'Time', 'Time', 'Enter Time', 1, '2021-01-23 06:18:45', '2021-02-20 22:16:09'),
(62, 169, 5, 'Attachment 1', 'Attachment_1', NULL, 0, '2021-01-23 06:21:39', '2021-02-20 22:16:43'),
(65, 169, 6, 'Date', 'Date', 'Enter Date', 1, '2021-01-23 06:23:45', '2021-02-20 22:16:31'),
(66, 169, 5, 'Attachment 2', 'Attachment_2', NULL, 1, '2021-01-23 06:23:59', '2021-02-20 22:16:55'),
(76, 173, 7, 'وقت', 'وقت', 'أدخل الوقت', 1, '2021-02-20 22:23:21', '2021-02-20 22:23:21'),
(77, 173, 5, 'المرفقات 1', 'المرفقات_1', NULL, 0, '2021-02-20 22:23:33', '2021-02-20 22:23:33'),
(78, 173, 6, 'تاريخ', 'تاريخ', 'أدخل التاريخ', 1, '2021-02-20 22:23:55', '2021-02-20 22:23:55'),
(79, 173, 5, 'الملحق 2', 'الملحق_2', NULL, 1, '2021-02-20 22:24:07', '2021-02-20 22:24:07');

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

--
-- Table structure for table `quote_input_options`
--

CREATE TABLE `quote_input_options` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `quote_input_id` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `quote_input_options`
--

INSERT INTO `quote_input_options` (`id`, `quote_input_id`, `name`, `created_at`, `updated_at`) VALUES
(86, 20, 'less than $10000', '2019-12-25 18:59:35', '2019-12-25 18:59:35'),
(87, 20, '$10000 to $25000', '2019-12-25 18:59:35', '2019-12-25 18:59:35'),
(88, 20, '$25000 to $50000', '2019-12-25 18:59:35', '2019-12-25 18:59:35'),
(89, 20, '$50000+', '2019-12-25 18:59:35', '2019-12-25 18:59:35'),
(90, 20, 'Negotiable', '2019-12-25 18:59:35', '2019-12-25 18:59:35'),
(119, 48, 'less than $10000', '2019-12-25 22:32:19', '2019-12-25 22:32:19'),
(120, 48, '$10000 to $25000', '2019-12-25 22:32:19', '2019-12-25 22:32:19'),
(121, 48, '$25000 to $50000', '2019-12-25 22:32:19', '2019-12-25 22:32:19'),
(122, 48, '$50000+', '2019-12-25 22:32:19', '2019-12-25 22:32:19'),
(123, 48, 'Negotiable', '2019-12-25 22:32:19', '2019-12-25 22:32:19'),
(124, 50, 'Bootstrap 4 Template', '2019-12-25 22:33:21', '2019-12-25 22:33:21'),
(125, 50, 'PSD to HTML', '2019-12-25 22:33:21', '2019-12-25 22:33:21'),
(126, 50, 'HTML & CSS', '2019-12-25 22:33:21', '2019-12-25 22:33:21'),
(127, 50, 'Laravel Framework', '2019-12-25 22:33:21', '2019-12-25 22:33:21'),
(128, 50, 'React Native App', '2019-12-25 22:33:21', '2019-12-25 22:33:21'),
(139, 56, 'أقل من 10000 دولار', '2020-01-07 04:36:51', '2020-01-07 04:36:51'),
(140, 56, '10000 دولار إلى 25000 دولار', '2020-01-07 04:36:51', '2020-01-07 04:36:51'),
(141, 56, '25000 دولار إلى 50000 دولار', '2020-01-07 04:36:51', '2020-01-07 04:36:51'),
(142, 56, '$ 50000 +', '2020-01-07 04:36:51', '2020-01-07 04:36:51'),
(143, 56, 'قابل للتفاوض', '2020-01-07 04:36:51', '2020-01-07 04:36:51'),
(237, 22, 'Personal Web Site', '2021-08-20 03:56:34', '2021-08-20 03:56:34'),
(238, 22, 'Agency web Site', '2021-08-20 03:56:34', '2021-08-20 03:56:34'),
(239, 22, 'News Letter / Magazine Site', '2021-08-20 03:56:34', '2021-08-20 03:56:34'),
(240, 22, 'Ecommerce Web Site', '2021-08-20 03:56:34', '2021-08-20 03:56:34'),
(241, 22, 'Booking  System web site', '2021-08-20 03:56:34', '2021-08-20 03:56:34'),
(242, 22, 'Smart School System Site', '2021-08-20 03:56:34', '2021-08-20 03:56:34'),
(243, 22, 'Academy Online Web site', '2021-08-20 03:56:34', '2021-08-20 03:56:34'),
(244, 22, 'Classified Ads App Web Site', '2021-08-20 03:56:34', '2021-08-20 03:56:34'),
(245, 22, 'Real Estate Web Site', '2021-08-20 03:56:34', '2021-08-20 03:56:34'),
(246, 22, 'Hotel Reservation Web Site', '2021-08-20 03:56:34', '2021-08-20 03:56:34'),
(247, 22, 'Point Of Sale', '2021-08-20 03:56:34', '2021-08-20 03:56:34'),
(248, 22, 'Stock Control System', '2021-08-20 03:56:34', '2021-08-20 03:56:34'),
(249, 22, 'Mobile Application System', '2021-08-20 03:56:34', '2021-08-20 03:56:34'),
(250, 22, 'Shop App', '2021-08-20 03:56:34', '2021-08-20 03:56:34'),
(251, 22, 'Service Provider App', '2021-08-20 03:56:34', '2021-08-20 03:56:34'),
(252, 22, 'Doctor Appointment App', '2021-08-20 03:56:34', '2021-08-20 03:56:34'),
(253, 22, 'Hospital Management System', '2021-08-20 03:56:34', '2021-08-20 03:56:34'),
(254, 22, 'Human  resource System \"HR\"', '2021-08-20 03:56:34', '2021-08-20 03:56:34'),
(255, 22, 'Customer relationship management \"CRM \"', '2021-08-20 03:56:34', '2021-08-20 03:56:34'),
(256, 22, 'Enterprise resource planning \"ERP\"', '2021-08-20 03:56:34', '2021-08-20 03:56:34'),
(282, 58, 'موقع شخصي', '2021-08-20 04:12:42', '2021-08-20 04:12:42'),
(283, 58, 'موقع ويب لشركة أو مؤسسة', '2021-08-20 04:12:42', '2021-08-20 04:12:42'),
(284, 58, 'موقع مدونة إخبارية / موقع مجلة', '2021-08-20 04:12:42', '2021-08-20 04:12:42'),
(285, 58, 'موقع التجارة الإلكترونية \"متجر إلكتروني\"', '2021-08-20 04:12:42', '2021-08-20 04:12:42'),
(286, 58, 'موقع وتطبيق  نظام الحجوزات أون لاين', '2021-08-20 04:12:42', '2021-08-20 04:12:42'),
(287, 58, 'موقع وتطبيق  نظام المدرسة الذكية المتكامل', '2021-08-20 04:12:42', '2021-08-20 04:12:42'),
(288, 58, 'موقع  وتطبيق الأكاديمية أونلاين للدروس المسجلة أو المباشرة على الإنترنت', '2021-08-20 04:12:42', '2021-08-20 04:12:42'),
(289, 58, 'موقع ويب وتطبيق الإعلانات المبوبة', '2021-08-20 04:12:42', '2021-08-20 04:12:42'),
(290, 58, 'موقع ويب وتطبيق  متخصص بالعقارات', '2021-08-20 04:12:42', '2021-08-20 04:12:42'),
(291, 58, 'موقع ويب وتطبيق  متخصص في حجز الفنادق', '2021-08-20 04:12:42', '2021-08-20 04:12:42'),
(292, 58, 'نظام نقاط البيع. POS', '2021-08-20 04:12:42', '2021-08-20 04:12:42'),
(293, 58, 'نظام مراقبة المخزون', '2021-08-20 04:12:42', '2021-08-20 04:12:42'),
(294, 58, 'تطبيق  موبايل متخصص', '2021-08-20 04:12:42', '2021-08-20 04:12:42'),
(295, 58, 'تطبيق موبايل لمتجر إلكتروني', '2021-08-20 04:12:42', '2021-08-20 04:12:42'),
(296, 58, 'تطبيق مشغلي  الخدمات   Service provider', '2021-08-20 04:12:42', '2021-08-20 04:12:42'),
(297, 58, 'تطبيق التوصيل مثل أوبر ، و كريم', '2021-08-20 04:12:42', '2021-08-20 04:12:42'),
(298, 58, 'تطبيق تعيين الحجوزات مع الأطباء', '2021-08-20 04:12:42', '2021-08-20 04:12:42'),
(299, 58, 'نظام إدارة المستشفيات', '2021-08-20 04:12:42', '2021-08-20 04:12:42'),
(300, 58, 'نظام إدارة  الموارد البشرية \"HR\"', '2021-08-20 04:12:42', '2021-08-20 04:12:42'),
(301, 58, 'إدارة علاقات العملاء \"CRM\"', '2021-08-20 04:12:42', '2021-08-20 04:12:42'),
(302, 58, 'نظام تخطيط موارد المؤسسات (ERP)', '2021-08-20 04:12:42', '2021-08-20 04:12:42');

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `permissions` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `name`, `permissions`, `created_at`, `updated_at`) VALUES
(1, 'Moderator', '[\"Dashboard\",\"Theme & Home\",\"Content Management\",\"Pages\",\"Event Calendar\",\"Shop Management\",\"Events Management\",\"Knowledgebase\",\"Tickets\"]', '2019-10-03 03:47:30', '2021-04-22 07:07:55'),
(3, 'Super Admin', '[\"Dashboard\",\"Basic Settings\",\"Subscribers\",\"Quote Management\",\"Home Page\",\"Footer\",\"Pages\",\"Service Page\",\"Portfolio Management\",\"Event Calendar\",\"Gallery Management\",\"FAQ Management\",\"Blogs\",\"Contact Page\",\"Role Management\",\"Users Management\",\"Language Management\",\"Backup\"]', '2019-10-04 02:52:29', '2020-03-06 05:48:34'),
(4, 'Admin', '[\"Dashboard\",\"Basic Settings\",\"Quote Management\",\"Home Page\",\"Footer\",\"Service Page\",\"Portfolio Management\",\"Gallery Management\",\"FAQ Management\",\"Blogs\",\"Contact Page\"]', '2019-10-04 02:52:53', '2019-10-04 02:53:21');

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

--
-- Table structure for table `rss_feeds`
--

CREATE TABLE `rss_feeds` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `language_id` int(11) DEFAULT NULL,
  `feed_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `feed_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `post_limit` int(11) DEFAULT NULL,
  `read_more_button` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `rss_feeds`
--

INSERT INTO `rss_feeds` (`id`, `language_id`, `feed_name`, `feed_url`, `post_limit`, `read_more_button`, `created_at`, `updated_at`) VALUES
(9, 169, 'ABC News', 'https://www.abc.net.au/news/feed/4570058/rss.xml', 5, 'Read More', '2020-03-27 16:29:30', NULL),
(10, 169, 'CNN News', 'http://rss.cnn.com/rss/edition_world.rss', 10, 'Read More', NULL, NULL),
(11, 169, 'Independent News', 'http://www.independent.co.uk/news/world/rss', 10, 'Read More', NULL, NULL),
(12, NULL, NULL, NULL, NULL, 'Read More', NULL, NULL),
(13, NULL, NULL, NULL, NULL, 'Read More', NULL, NULL);

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

--
-- Table structure for table `rss_posts`
--

CREATE TABLE `rss_posts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `language_id` int(11) DEFAULT NULL,
  `rss_feed_id` int(11) DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `photo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `rss_link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `rss_posts`
--

INSERT INTO `rss_posts` (`id`, `language_id`, `rss_feed_id`, `title`, `slug`, `photo`, `description`, `rss_link`, `created_at`, `updated_at`) VALUES
(15, 169, 9, 'As city gigs dry up, unemployed look to farmers for a job', 'As-city-gigs-dry-up,-unemployed-look-to-farmers-for-a-job', 'https://www.abc.net.au/news/image/11765638-16x9-2150x1210.jpg', '<p>Coronavirus is expected to force hundreds of thousands of Australians out of work, and farmers are already being inundated with enquiries from the unemployed.</p>', 'https://www.abc.net.au/news/2020-03-28/covid-19-downturn-sees-farmers-inundated-by-jobseekers/12097012', '2020-03-27 16:29:52', NULL),
(16, 169, 9, '\'Ugly\' fruit and vegetables hit top shelf to meet demand during COVID-19', '\'Ugly\'-fruit-and-vegetables-hit-top-shelf-to-meet-demand-during-COVID-19', 'https://www.abc.net.au/news/image/7837650-16x9-2150x1210.jpg', '<p>Consumers can expect some different-looking fruit and vegetables in the aisles as COVID-19 demand forces supermarkets to relax specifications.</p>', 'https://www.abc.net.au/news/2020-03-25/supermarkets-change-fruit-vegetable-specifications-covid19/12085326', '2020-03-27 16:29:53', NULL),
(17, 169, 9, 'Another hit to rural tourism in Tasmania', 'Another-hit-to-rural-tourism-in-Tasmania', 'https://www.abc.net.au/news/image/12085520-16x9-2150x1210.jpg', 'The rural tourism industry in southern Tasmania has been hit with closures of regional pubs and restaurants due to coronavirus', 'https://www.abc.net.au/radio/programs/tas-country-hour/bangor-closed/12085570', '2020-03-27 16:29:53', NULL),
(18, 169, 9, 'While many are losing their jobs, these businesses need more workers', 'While-many-are-losing-their-jobs,-these-businesses-need-more-workers', 'https://www.abc.net.au/news/image/12084808-16x9-2150x1210.jpg', '<p>As tens of thousands of Australians lose their jobs because of new rules around social distancing, some businesses including food producers, are looking for new workers.</p>', 'https://www.abc.net.au/news/2020-03-24/some-businesses-looking-for-workers-amid-coronavirus-layoffs/12084182', '2020-03-27 16:29:53', NULL),
(19, 169, 9, 'Farmer doesn\'t let coronavirus squash his giant pumpkin strides', 'Farmer-doesn\'t-let-coronavirus-squash-his-giant-pumpkin-strides', 'https://www.abc.net.au/news/image/12081934-16x9-2150x1210.jpg', '<p>Sorell farmer Shane Newitt put six months of love into his giant pumpkin to compete at the Bream Creek Show, but its cancellation hasn\'t stopped him showing it off.</p>', 'https://www.abc.net.au/news/2020-03-24/tasmanian-farmer-shane-newitt-shows-off-giant-pumpkin/12081512', '2020-03-27 16:29:53', NULL),
(20, 169, 10, 'It\'s shockingly easy to get a $150 bonus with this card', 'It\'s-shockingly-easy-to-get-a-$150-bonus-with-this-card', 'https://cdn.cnn.com/cnnnext/dam/assets/200306170259-cc-pastelcashstack-super-169.jpg', '<img src=\"http://feeds.feedburner.com/~r/rss/edition_world/~4/BF-YqghZ2po\" height=\"1\" width=\"1\" alt=\"\">', 'http://rss.cnn.com/~r/rss/edition_world/~3/BF-YqghZ2po/best-cash-back-quicksilver', NULL, NULL),
(21, 169, 10, 'Iceland lab\'s testing suggests 50% of cases have no symptoms', 'Iceland-lab\'s-testing-suggests-50%-of-cases-have-no-symptoms', 'https://cdn.cnn.com/cnnnext/dam/assets/200331132121-02-iceland-coronavirus-testing-super-169.jpg', 'There\'s a lot about Iceland that other countries could envy: Its spectacular natural surroundings, its place among the world\'s happiest countries, and, now, its large-scale testing for the novel coronavirus, which could influence how the world understands the outbreak.<img src=\"http://feeds.feedburner.com/~r/rss/edition_world/~4/odv9kN_humI\" height=\"1\" width=\"1\" alt=\"\">', 'http://rss.cnn.com/~r/rss/edition_world/~3/odv9kN_humI/index.html', NULL, NULL),
(22, 169, 10, 'Can the Tour de France go ahead?', 'Can-the-Tour-de-France-go-ahead?', 'https://cdn.cnn.com/cnnnext/dam/assets/190704153713-eddy-mercxx-super-169.jpg', 'With the list of sporting postponements growing ever longer, the fate of cycling\'s Tour de France would seem almost inevitable.<img src=\"http://feeds.feedburner.com/~r/rss/edition_world/~4/ppR7f_Hvqo8\" height=\"1\" width=\"1\" alt=\"\">', 'http://rss.cnn.com/~r/rss/edition_world/~3/ppR7f_Hvqo8/index.html', NULL, NULL),
(23, 169, 10, 'Asia may have been right about coronavirus and face masks', 'Asia-may-have-been-right-about-coronavirus-and-face-masks', 'https://cdn.cnn.com/cnnnext/dam/assets/200401141239-hong-kong-face-mask-0323-01-super-169.jpg', '<img src=\"http://feeds.feedburner.com/~r/rss/edition_world/~4/ZlwuatLpZnk\" height=\"1\" width=\"1\" alt=\"\">', 'http://rss.cnn.com/~r/rss/edition_world/~3/ZlwuatLpZnk/index.html', NULL, NULL),
(24, 169, 10, 'UK races to convert convention hall into ICU', 'UK-races-to-convert-convention-hall-into-ICU', 'https://cdn.cnn.com/cnnnext/dam/assets/200401074352-nhs-nightingale-hospital-excel-center-super-169.jpg', 'The UK will open the doors this week on what could soon be the biggest intensive care unit in the country. Nick Paton Walsh reports from east London.<img src=\"http://feeds.feedburner.com/~r/rss/edition_world/~4/JDrSljdXw7s\" height=\"1\" width=\"1\" alt=\"\">', 'http://rss.cnn.com/~r/rss/edition_world/~3/JDrSljdXw7s/london-nick-paton-walsh-nhs-excel-nightingale-hospital.cnn', NULL, NULL),
(25, 169, 10, 'Cruise ships are still scrambling for safe harbor', 'Cruise-ships-are-still-scrambling-for-safe-harbor', 'https://cdn.cnn.com/cnnnext/dam/assets/200327135115-01-zaandam-0327-super-169.jpg', 'More than a dozen cruise ships remain stranded at sea right now -- some with and some without passengers -- as ports deny entry and passengers panic about returning home.<img src=\"http://feeds.feedburner.com/~r/rss/edition_world/~4/tirk0A6nwoc\" height=\"1\" width=\"1\" alt=\"\">', 'http://rss.cnn.com/~r/rss/edition_world/~3/tirk0A6nwoc/index.html', NULL, NULL),
(26, 169, 10, 'Analysis: Power-hungry leaders itching to exploit this crisis', 'Analysis:-Power-hungry-leaders-itching-to-exploit-this-crisis', 'https://cdn.cnn.com/cnnnext/dam/assets/200330112237-01-viktor-orban-0304-super-169.jpg', 'As Covid-19 brings the world to a halt, some world leaders have spotted an opportunity to tighten their grip on power.<img src=\"http://feeds.feedburner.com/~r/rss/edition_world/~4/7BOgm5Y7KI0\" height=\"1\" width=\"1\" alt=\"\">', 'http://rss.cnn.com/~r/rss/edition_world/~3/7BOgm5Y7KI0/index.html', NULL, NULL),
(27, 169, 10, 'How Huawei is returning to work', 'How-Huawei-is-returning-to-work', 'https://cdn.cnn.com/cnnnext/dam/assets/200331141553-huawei-shenzhen-file-super-169.jpg', 'At Huawei\'s first ever virtual press conference on Tuesday, CEO Eric Xu waited patiently as dozens of reporters attempted to get the moderator\'s attention on video conferencing platform Zoom.<img src=\"http://feeds.feedburner.com/~r/rss/edition_world/~4/sknDExqjy8I\" height=\"1\" width=\"1\" alt=\"\">', 'http://rss.cnn.com/~r/rss/edition_world/~3/sknDExqjy8I/index.html', NULL, NULL),
(28, 169, 10, 'How some investors have profited from the stock market\'s huge losses', 'How-some-investors-have-profited-from-the-stock-market\'s-huge-losses', 'https://cdn.cnn.com/cnnnext/dam/assets/200326111241-bill-ackman-1112-file-super-169.jpg', 'Hedge fund manager Bill Ackman appeared on CNBC earlier this month tearfully begging for the stock market to be shut down because he thought \"hell\" was coming,\"<img src=\"http://feeds.feedburner.com/~r/rss/edition_world/~4/J3F-ryolr6Y\" height=\"1\" width=\"1\" alt=\"\">', 'http://rss.cnn.com/~r/rss/edition_world/~3/J3F-ryolr6Y/index.html', NULL, NULL),
(29, 169, 10, 'Pandemic could push 11 million people in Asia into poverty', 'Pandemic-could-push-11-million-people-in-Asia-into-poverty', 'https://cdn.cnn.com/cnnnext/dam/assets/200331141303-manila-philippines-0331-super-169.jpg', 'The economic fallout from the coronavirus pandemic could drive an additional 11 million people into poverty in East Asia and the Pacific unless \"urgent action\" is taken, the World Bank warned in a report released Monday.<img src=\"http://feeds.feedburner.com/~r/rss/edition_world/~4/N_u5Z8QWPmc\" height=\"1\" width=\"1\" alt=\"\">', 'http://rss.cnn.com/~r/rss/edition_world/~3/N_u5Z8QWPmc/index.html', NULL, NULL),
(30, 169, 11, 'US medical workers hit by pay cuts at height of coronavirus', 'US-medical-workers-hit-by-pay-cuts-at-height-of-coronavirus', 'https://static.independent.co.uk/s3fs-public/thumbnails/image/2020/04/01/14/new-york-doctor.jpg', 'One of the largest medical staffing agencies in the US announced cuts to staff whilst they care for coronavirus patients', 'https://www.independent.co.uk/news/world/americas/us-politics/coronavirus-us-healthcare-doctor-pay-nurse-wages-a9440521.html', NULL, NULL),
(31, 169, 11, 'Tornado and hurricane seasons could be worse this year due to abnormally high sea temperature', 'Tornado-and-hurricane-seasons-could-be-worse-this-year-due-to-abnormally-high-sea-temperature', 'https://static.independent.co.uk/s3fs-public/thumbnails/image/2020/04/01/12/tornado.jpg', 'Southern US states have seen unusually warm weather so far this year', 'https://www.independent.co.uk/news/world/americas/tornado-hurricane-season-high-sea-temperature-gulf-mexico-a9440331.html', NULL, NULL),
(32, 169, 11, 'Coronavirus: Nuclear aircraft carrier will evacuate after desperate plea from captain', 'Coronavirus:-Nuclear-aircraft-carrier-will-evacuate-after-desperate-plea-from-captain', 'https://static.independent.co.uk/s3fs-public/thumbnails/image/2015/04/21/00/web-USS-Roosevelt-Get-v2.jpg', '\'We are not at war,\' wrote Captain Brett Crozier. \'Sailors do not need to die\'', 'https://www.independent.co.uk/news/world/americas/coronavirus-us-war-ship-theodore-roosevelt-navy-aircraft-carrier-guam-brett-crozier-a9439901.html', NULL, NULL),
(33, 169, 11, 'Trump blames impeachment for slow response to coronavirus', 'Trump-blames-impeachment-for-slow-response-to-coronavirus', 'https://static.independent.co.uk/s3fs-public/thumbnails/image/2020/04/01/13/trump-hoax-rally.jpg', 'President suggests his administration was distracted by impeachment process in January', 'https://www.independent.co.uk/news/world/americas/us-politics/trump-coronavirus-impeachment-white-house-press-briefing-a9440351.html', NULL, NULL),
(34, 169, 11, 'Coronavirus: 350 bodies sent away from Bergamo after local crematorium overwhelmed', 'Coronavirus:-350-bodies-sent-away-from-Bergamo-after-local-crematorium-overwhelmed', 'https://static.independent.co.uk/s3fs-public/thumbnails/image/2020/03/27/17/Italy-coronavirus-deaths.jpg', 'Florence reportedly offered help this week', 'https://www.independent.co.uk/news/world/europe/coronavirus-cremation-bergamo-bodies-sent-ferrara-venice-florence-a9440436.html', NULL, NULL),
(35, 169, 11, 'Trump news – live: President warns nation facing &amp;apos;hell of a bad two weeks&amp;apos; and predicts death toll of up to 240,000 even if lockdown measures kept up', 'Trump-news-–-live:-President-warns-nation-facing-&amp;apos;hell-of-a-bad-two-weeks&amp;apos;-and-predicts-death-toll-of-up-to-240,000-even-if-lockdown-measures-kept-up', 'https://static.independent.co.uk/s3fs-public/thumbnails/image/2020/03/31/22/donald-trump-anthony-fauci-coronavirus.jpg', 'Follow the latest updates', 'https://www.independent.co.uk/news/world/americas/us-politics/trump-news-live-coronavirus-update-white-house-live-press-conference-cases-a9439936.html', NULL, NULL),
(36, 169, 11, 'US coronavirus death toll passes 4,000 as cases near 200,000', 'US-coronavirus-death-toll-passes-4,000-as-cases-near-200,000', 'https://static.independent.co.uk/s3fs-public/thumbnails/image/2020/04/01/11/refrigeration-units-ny.jpg', 'The US death toll passed another marker on Wednesday, as coronavirus fatalities surpassed those of 9/11', 'https://www.independent.co.uk/news/world/americas/us-politics/us-coronavirus-death-toll-cases-latest-trump-news-a9440151.html', NULL, NULL),
(37, 169, 11, 'Coronavirus news – live: UK daily death toll exceeds 500 for first time, as &amp;apos;1.7 million Britons may have had disease&amp;apos; and UN warns world faces &amp;apos;worst crisis&amp;apos; since WW2', 'Coronavirus-news-–-live:-UK-daily-death-toll-exceeds-500-for-first-time,-as-&amp;apos;1.7-million-Britons-may-have-had-disease&amp;apos;-and-UN-warns-world-faces-&amp;apos;worst-crisis&amp;apos;-since-WW2', 'https://static.independent.co.uk/s3fs-public/thumbnails/image/2020/04/01/07/pri148122028.jpg', 'Follow the latest updates', 'https://www.independent.co.uk/news/health/coronavirus-update-live-news-cases-uk-map-latest-today-deaths-a9439711.html', NULL, NULL),
(38, 169, 11, '&amp;apos;People do not realise what is coming&amp;apos;: What a coronavirus crisis would look like in war-torn Syria, Yemen and Libya', '&amp;apos;People-do-not-realise-what-is-coming&amp;apos;:-What-a-coronavirus-crisis-would-look-like-in-war-torn-Syria,-Yemen-and-Libya', 'https://static.independent.co.uk/s3fs-public/thumbnails/image/2020/04/01/14/syria.jpg', 'In more than a dozen interviews, doctors and medical charities tells Bel Trew how years of conflict has left them completely unable to stop the spread of coronavirus', 'https://www.independent.co.uk/news/world/middle-east/coronavirus-syria-yemen-libya-cases-update-death-toll-doctors-a9440486.html', NULL, NULL),
(39, 169, 11, '&amp;apos;You could run from Katrina. You can&amp;apos;t run from this&amp;apos;: Hurricane&amp;apos;s legacy haunts Louisiana&amp;apos;s fight against coronavirus', '&amp;apos;You-could-run-from-Katrina.-You-can&amp;apos;t-run-from-this&amp;apos;:-Hurricane&amp;apos;s-legacy-haunts-Louisiana&amp;apos;s-fight-against-coronavirus', 'https://static.independent.co.uk/s3fs-public/thumbnails/image/2020/04/01/12/New-Orleans-21.jpg', 'With Mardi Gras in hindsight, New Orleans becomes a scapegoat as the city braces for more trauma under a national microscope', 'https://www.independent.co.uk/news/world/americas/coronavirus-louisiana-new-orleans-hurricane-katrina-death-toll-cases-a9439616.html', NULL, NULL),
(40, 169, 9, 'South Australian cellar doors closed amid coronavirus cluster concerns', 'South-Australian-cellar-doors-closed-amid-coronavirus-cluster-concerns', 'https://www.abc.net.au/news/image/12103596-16x9-2150x1210.jpg', '<p>With wine tasting already off the menu due to COVID-19 restrictions, many wineries have been relying on cellar-door sales to keep them afloat, but they are now being banned too.</p>', 'https://www.abc.net.au/news/2020-03-30/south-australian-wineries-to-close-amid-coronavirus-concerns/12103540', NULL, NULL),
(41, 169, 9, '\'Just going to waste\': Flowers dumped as sales plummet amid coronavirus closures', '\'Just-going-to-waste\':-Flowers-dumped-as-sales-plummet-amid-coronavirus-closures', 'https://www.abc.net.au/news/image/12101024-16x9-2150x1210.jpg', '<p>Australian flower growers destroy tens of thousands of flowers after events and florists are shut down in coronavirus measures.</p>', 'https://www.abc.net.au/news/2020-03-30/flowers-dumped-as-coronavirus-closes-events-and-florists/12100998', NULL, NULL),
(42, 169, 11, '&amp;apos;We have a life and death situation&amp;apos;: Trump lambasted for blaming slow coronavirus response on impeachment', '&amp;apos;We-have-a-life-and-death-situation&amp;apos;:-Trump-lambasted-for-blaming-slow-coronavirus-response-on-impeachment', 'https://static.independent.co.uk/s3fs-public/thumbnails/image/2020/03/13/14/pelosi-coronavirus.jpg', 'Pelosi: \'That\'s an admission that perhaps the president and the majority leader cannot handle the job\'', 'https://www.independent.co.uk/news/world/americas/us-politics/coronavirus-trump-impeachment-pandemic-us-pelosi-mitch-mcconnell-a9441136.html', NULL, NULL),
(43, 169, 11, 'Coronavirus: Florida issues stay-at-home order', 'Coronavirus:-Florida-issues-stay-at-home-order', 'https://static.independent.co.uk/s3fs-public/thumbnails/image/2018/09/26/17/breaking-4.png', 'The governor of Florida has issued a statewide stay-at-home order to remain in effect for at least 30 days beginning Thursday, after facing extensive criticism over a seemingly slow response to the novel coronavirus pandemic.', 'https://www.independent.co.uk/news/world/americas/coronavirus-florida-stay-at-home-order-lockdown-update-today-a9441116.html', NULL, NULL),
(44, 169, 11, 'Trump says Iran is planning &amp;apos;sneak attack&amp;apos; on US interests in Iraq', 'Trump-says-Iran-is-planning-&amp;apos;sneak-attack&amp;apos;-on-US-interests-in-Iraq', 'https://static.independent.co.uk/s3fs-public/thumbnails/image/2018/09/26/17/breaking-4.png', 'Donald Trump claimed Wednesday that Iran is planning a \"sneak attack\" against US forces in Iraq, without providing any evidence or sourcing for the assertion.', 'https://www.independent.co.uk/news/world/americas/trump-iran-us-troops-iraq-sanctions-military-latest-a9441056.html', NULL, NULL),
(45, 169, 11, 'Coronavirus: New York governor says peak will hit at end of April, as death toll nears 2,000', 'Coronavirus:-New-York-governor-says-peak-will-hit-at-end-of-April,-as-death-toll-nears-2,000', 'https://static.independent.co.uk/s3fs-public/thumbnails/image/2020/04/01/18/ap-20090603494496.jpg', 'Cases in state rise to 83,712 people infected', 'https://www.independent.co.uk/news/world/americas/coronavirus-new-york-cases-andrew-cuomo-press-briefing-latest-a9440976.html', NULL, NULL),
(46, 169, 11, 'Coronavirus: 28 spring breakers test positive after returning home to Texas', 'Coronavirus:-28-spring-breakers-test-positive-after-returning-home-to-Texas', 'https://static.independent.co.uk/s3fs-public/thumbnails/image/2020/04/01/17/florida-beach.jpg', '\'Four of the confirmed cases did not present any symptoms\'', 'https://www.independent.co.uk/news/world/americas/coronavirus-spring-break-test-positive-austin-texas-a9440911.html', NULL, NULL),
(47, 169, 11, 'Coronavirus stimulus package: Who is eligible and when will you get your checks?', 'Coronavirus-stimulus-package:-Who-is-eligible-and-when-will-you-get-your-checks', 'https://static.independent.co.uk/s3fs-public/thumbnails/image/2020/04/01/16/stimulus-bill.jpg', 'Payment will be one-off that is calculated by looking at your 2019 tax return', 'https://www.independent.co.uk/news/world/americas/coronavirus-stimulus-package-when-checks-who-eligible-2020-trump-bill-a9440611.html', NULL, NULL),
(48, 169, 11, 'Coronavirus: Trump administration claims it only found out alarming death toll figures at weekend despite experts issuing warning weeks ago', 'Coronavirus:-Trump-administration-claims-it-only-found-out-alarming-death-toll-figures-at-weekend-despite-experts-issuing-warning-weeks-ago', 'https://static.independent.co.uk/s3fs-public/thumbnails/image/2020/03/30/18/screenshot-2020-03-30-at-11.53.31-am.png', 'American life likely mostly shut down into \'early June,\' VP warns', 'https://www.independent.co.uk/news/world/americas/us-politics/coronavirus-trump-us-death-toll-pence-dr-birx-covid-stats-cases-a9440841.html', NULL, NULL),
(49, 169, 11, 'Churches remain packed as pastors are arrested and lobby for exemptions to coronavirus lockdown orders', 'Churches-remain-packed-as-pastors-are-arrested-and-lobby-for-exemptions-to-coronavirus-lockdown-orders', 'https://static.independent.co.uk/s3fs-public/thumbnails/image/2020/04/01/17/new-york.jpg', 'Pastors sue for \'religious liberty\' exemptions as thousands of people die across the country from Covid-19', 'https://www.independent.co.uk/news/world/americas/churches-coronavirus-lock-down-louisiana-texas-pastors-arrest-a9440956.html', NULL, NULL),
(50, 169, 11, 'Coronavirus: Man uses cherry picker to visit his mother on third floor of care home', 'Coronavirus:-Man-uses-cherry-picker-to-visit-his-mother-on-third-floor-of-care-home', 'https://static.independent.co.uk/s3fs-public/thumbnails/image/2020/04/01/15/care-home.png', '\'Her spirits were kind of down because she\'s used to being able to get out go places and do things\'', 'https://www.independent.co.uk/news/world/americas/coronavirus-care-home-visit-cherry-picker-social-distancing-elderly-a9440466.html', NULL, NULL);

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

--
-- Table structure for table `scategories`
--

CREATE TABLE `scategories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `short_text` text COLLATE utf8mb4_unicode_ci,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `serial_number` int(11) NOT NULL DEFAULT '0',
  `feature` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0 - will not show in home, 1 - will show in home'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `scategories`
--

INSERT INTO `scategories` (`id`, `language_id`, `name`, `image`, `short_text`, `status`, `serial_number`, `feature`) VALUES
(54, 169, 'Web Design', '6113fd7e97acc.png', 'In addition to all the features and benefits of branding and marketing, our customers enjoy the benefits of optimized, time-tested workflows tailored to each project!', 1, 1, 1),
(55, 169, 'Web Development', '6113fda572b09.png', 'Our website developers provide expert web application development and web design services to our clients. we offers a variety of website development services, from creating mobile web development solutions and responsive website designs, to building custom e-commerce and intranet experiences using the latest and proven web technologies. With up to 85% of consumers visiting company’s or service provider’s website before making a purchase, more and more consumers make decisions based on their online experience: the appearance, usability and accessibility of your website is more important than ever, especially in an increasingly competitive market.', 1, 2, 1),
(56, 169, 'Graphic Design', '6113fdba6ee69.png', 'There\'s no limit to what you can get designed with us. Whether you\'re looking for a spectacular new logo or some stunning flyers, the talented global community of designers at our company can make it happen. Magictis prides itself on it\'s high quality designers who deliver only the best graphic design services.', 1, 3, 1),
(57, 169, 'Mobile Apps', '6113fdd1ca5ec.png', 'Across any industry, mobile application is crucial for better customer engagement. To achieve this goal, you must get an intuitive, secure and fast mobile app with positive experiences. We provide mobile application development services enriching your business with the most reliable mobile solutions. Mobile technologies keep on replacing desktops so most business owners want to create mobile versions of existing web solutions. With the team of our skilled mobile developers, you are guaranteed to get high-quality development of mobile software that is tailored to the specific needs of your business area.', 1, 4, 1),
(58, 169, 'Social Media', '6113fde5aa970.png', 'Social media digital marketing allows you to showcase your brand to potential customers at exactly the moment they are ready to convert. More importantly, combined digital and social media marketing efforts enable you to maximize available customer touchpoints and conversion opportunities.', 1, 5, 0),
(59, 169, 'SEO', '6113fdf789c88.png', 'Around 75% of businesses invest in search engine optimization (SEO). With our advanced SEO techniques, your company can gain a competitive edge in search results on Google, Bing, and other search engines.', 1, 6, 1),
(60, 169, 'Multimedia', '6113fe09ed0b1.png', 'Our mission is to provide support and assistance in all aspects of multimedia, video production and editing, audio production services, as well as media distribution services that include streaming media, video, and interactivity.', 1, 7, 1),
(61, 169, 'Consultation', '6113fe1e47bd7.png', 'In technical consulting, we work to transform digital product ideas into integrated, realistic works with high quality We offer you creative ideas on how to turn the idea into a reality for an e-commerce project', 1, 8, 1),
(70, 173, 'تصميم  وبرمجة  مواقع', '6113ff487b3e7.png', 'بالإضافة إلى جميع ميزات وفوائد العلامات التجارية والتسويق ، يتمتع عملاؤنا بمزايا سير العمل المُحسَّن والمُختبَر بالوقت والمُصمم خصيصًا لكل مشروع!', 1, 1, 1),
(71, 173, 'تطوير مواقع ويب', '6113ff34297d9.png', 'يوفر مطورو مواقع الويب لدينا خدمات تطوير تطبيقات الويب وتصميم الويب لعملائنا. نحن نقدم مجموعة متنوعة من خدمات تطوير مواقع الويب ، بدءًا من إنشاء حلول تطوير ويب للجوال وتصميمات مواقع الويب سريعة الاستجابة ، إلى بناء تجارب مخصصة للتجارة الإلكترونية والإنترانت باستخدام أحدث تقنيات الويب التي أثبتت جدواها. نظرًا لأن ما يصل إلى 85٪ من المستهلكين يزورون موقع الويب الخاص بالشركة أو مزود الخدمة قبل إجراء عملية شراء ، فإن المزيد والمزيد من المستهلكين يتخذون قرارات بناءً على تجربتهم عبر الإنترنت: يعد مظهر موقع الويب الخاص بك وسهولة استخدامه والوصول إليه أكثر أهمية من أي وقت مضى ، لا سيما في ظل المنافسة المتزايدة سوق.', 1, 2, 1),
(72, 173, 'التصميم الجرافيكي', '6113ff203bfba.png', 'لا يوجد حد لما يمكنك تصميمه معنا. سواء كنت تبحث عن شعار جديد مذهل أو بعض النشرات المذهلة ، يمكن للمجتمع العالمي الموهوب من المصممين في شركتنا تحقيق ذلك. تفتخر Magictis بمصمميها ذوي الجودة العالية الذين يقدمون فقط أفضل خدمات التصميم الجرافيكي.', 1, 4, 1),
(73, 173, 'تطوير تطبيقات الموبايل', '6113ff0a4259e.png', 'في أي صناعة ، يعد تطبيق الهاتف المحمول أمرًا بالغ الأهمية لتحسين مشاركة العملاء. لتحقيق هذا الهدف ، يجب أن تحصل على تطبيق جوال سهل الاستخدام وآمن وسريع مع تجارب إيجابية. نحن نقدم خدمات تطوير تطبيقات الهاتف المحمول لإثراء عملك بأكثر حلول الأجهزة المحمولة موثوقية. تستمر تقنيات الأجهزة المحمولة في استبدال أجهزة سطح المكتب ، لذا يرغب معظم أصحاب الأعمال في إنشاء إصدارات محمولة من حلول الويب الحالية. مع فريق مطوري الأجهزة المحمولة المهرة لدينا ، نضمن لك الحصول على تطوير عالي الجودة لبرامج الهاتف المحمول المصممة خصيصًا لتلبية الاحتياجات المحددة لمنطقة عملك.', 1, 3, 1),
(74, 173, 'التسويق الإلكتروني', '6113fefa937ba.png', 'يتيح لك التسويق الرقمي عبر وسائل التواصل الاجتماعي عرض علامتك التجارية للعملاء المحتملين في اللحظة التي يكونون فيها على استعداد للتحويل. والأهم من ذلك ، تمكّنك جهود التسويق عبر الوسائط الرقمية والاجتماعية المشتركة من تعظيم نقاط اتصال العملاء وفرص التحويل المتاحة.', 1, 5, 1),
(75, 173, 'تحسين محركات البحث  SEO', '6113fee84150f.png', 'حوالي 75٪ من الشركات تستثمر في تحسين محركات البحث (SEO). من خلال تقنيات تحسين محركات البحث المتقدمة لدينا ، يمكن لشركتك أن تكتسب ميزة تنافسية في نتائج البحث على Google و Bing ومحركات البحث الأخرى.', 1, 6, 1),
(76, 173, 'ملتيميديا', '6113fed7ef2b3.png', 'مهمتنا هي تقديم الدعم والمساعدة في جميع جوانب الوسائط المتعددة ، وإنتاج وتحرير الفيديو ، وخدمات إنتاج الصوت ، فضلاً عن خدمات توزيع الوسائط التي تشمل وسائط البث ، والفيديو ، والتفاعل.', 1, 7, 1),
(77, 173, 'استشارات  عامة', '6113fec8ecb8b.png', 'في الإستشارات التقنية نعمل على تحويل أفكار المنتجات الرقمية لأعمال واقعية متكاملة بجودة عالية نقدم لك أفكارا ابداعية حول كيفية تحويل الفكرة لواقع مشروع تجاري الكتروني', 1, 8, 1);

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

--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT '0',
  `scategory_id` int(11) DEFAULT NULL,
  `main_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` blob,
  `summary` text COLLATE utf8mb4_unicode_ci,
  `serial_number` int(11) NOT NULL DEFAULT '0',
  `meta_keywords` text COLLATE utf8mb4_unicode_ci,
  `meta_description` text COLLATE utf8mb4_unicode_ci,
  `feature` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0 - will not show in home, 1 - will show in home',
  `details_page_status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1 - enable, 0 - disable',
  `sidebar` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1 - enable, 0 - disable'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `services`
--

INSERT INTO `services` (`id`, `language_id`, `scategory_id`, `main_image`, `title`, `slug`, `content`, `summary`, `serial_number`, `meta_keywords`, `meta_description`, `feature`, `details_page_status`, `sidebar`) VALUES
(131, 169, 54, '61a8637d1d59b.jpg', 'Virtual Stores', 'Virtual-Stores', 0x3c7020636c6173733d224d736f4e6f726d616c223e3c623e3c7370616e207374796c653d22666f6e742d73697a653a31382e3070743b6c696e652d6865696768743a313037253b0a666f6e742d66616d696c793a2671756f743b54696d6573204e657720526f6d616e2671756f743b2c73657269663b6d736f2d61736369692d7468656d652d666f6e743a6d616a6f722d626964693b6d736f2d68616e73692d7468656d652d666f6e743a0a6d616a6f722d626964693b6d736f2d626964692d7468656d652d666f6e743a6d616a6f722d62696469223e57686174206973205669727475616c2053746f72653f3c6f3a703e3c2f6f3a703e3c2f7370616e3e3c2f623e3c2f703e3c7020636c6173733d224d736f4e6f726d616c22207374796c653d22746578742d616c69676e3a6a757374696679223e3c7370616e207374796c653d22666f6e742d73697a653a31362e3070743b0a6c696e652d6865696768743a313037253b666f6e742d66616d696c793a2671756f743b54696d6573204e657720526f6d616e2671756f743b2c73657269663b6d736f2d61736369692d7468656d652d666f6e743a6d616a6f722d626964693b0a6d736f2d68616e73692d7468656d652d666f6e743a6d616a6f722d626964693b6d736f2d626964692d7468656d652d666f6e743a6d616a6f722d62696469223e5669727475616c2073746f7265730a61726520612077656220636f6d70616e7920776974682061206368616e6e656c207370656369616c697a656420696e20636f6d6d65726365206f6e2074686520496e7465726e65742c2077686963680a726561707320616c6d6f737420616c6c206f662069747320696e636f6d652066726f6d2073616c6573206f6e2074686520496e7465726e65742e3c6f3a703e3c2f6f3a703e3c2f7370616e3e3c2f703e3c7020636c6173733d224d736f4e6f726d616c22207374796c653d226d617267696e2d626f74746f6d3a20313570743b206c696e652d6865696768743a20323870783b206261636b67726f756e642d696d6167653a20696e697469616c3b206261636b67726f756e642d706f736974696f6e3a20696e697469616c3b206261636b67726f756e642d73697a653a20696e697469616c3b206261636b67726f756e642d7265706561743a20696e697469616c3b206261636b67726f756e642d6174746163686d656e743a20696e697469616c3b206261636b67726f756e642d6f726967696e3a20696e697469616c3b206261636b67726f756e642d636c69703a20696e697469616c3b223e0a0a0a0a3c2f703e3c7020636c6173733d224d736f4e6f726d616c22207374796c653d22746578742d616c69676e3a6a757374696679223e3c7370616e207374796c653d22666f6e742d73697a653a31362e3070743b0a6c696e652d6865696768743a313037253b666f6e742d66616d696c793a2671756f743b54696d6573204e657720526f6d616e2671756f743b2c73657269663b6d736f2d61736369692d7468656d652d666f6e743a6d616a6f722d626964693b0a6d736f2d68616e73692d7468656d652d666f6e743a6d616a6f722d626964693b6d736f2d626964692d7468656d652d666f6e743a6d616a6f722d62696469223e5669727475616c2073746f7265730a70726f76696465206d616e7920696e746572657374696e6720666561747572657320616e6420696e74657261637469766520746f6f6c7320666f7220796f7572207765622073746f72652c2061730a7468697320746563686e6f6c6f67792070726f76696465732066756e20666f7220637573746f6d65727320696e207468652070726f63657373206f662073686f7070696e672066726f6d0a7669727475616c2073746f7265732c20616e6420746865726520617265206d616e7920706f73736962696c697469657320616e64206f7074696f6e7320666f72207573696e6720746869730a616476616e63656420746563686e6f6c6f677920696e207669727475616c2073746f7265732c20746865206d6f737420696d706f7274616e74206f66207768696368206172653a20446973706c61790a796f75722070726f647563747320696e20612064697374696e6374697665207761792c20736f2074686174204175676d656e746564207265616c69747920746563686e6f6c6f67792063616e2062650a7573656420746f2073686f776361736520796f75722070726f647563747320696e206120766572792062656175746966756c207761792e20416c736f207573696e67204845524fc2ae0a746563686e6f6c6f67792c206272616e64732063616e20637265617465206d6f726520706572736f6e616c697a6564207669727475616c2073746f726520657870657269656e6365732062790a616c6c6f77696e6720637573746f6d65727320746f20636f6e6e65637420776974682073746f726520706172746e65727320696e7374616e746c792e3c6f3a703e3c2f6f3a703e3c2f7370616e3e3c2f703e, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et', 2, 'virtual stores,virtual,stores', NULL, 1, 1, 1),
(132, 169, 54, '61a86422a390d.jpg', 'Smart School', 'Smart-School', 0x[encoded data, 5162 characters], 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et', 3, 'smart school,school,smart,المدرسة الذكية', NULL, 1, 1, 1),
(133, 169, 54, '61a8650266ec6.jpg', 'POS', 'POS', 0x[encoded data, 4908 characters], 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et', 4, 'sales point,sales,POS,pos', NULL, 1, 1, 1),
(134, 169, 54, '61a8665b65bcf.jpg', 'Electronic Stores', 'Electronic-Stores', 0x[encoded data, 5844 characters], 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et', 5, 'electronic stores ,electronic,electron,store,e-store', NULL, 1, 1, 1),
(141, 169, 55, '61a86794920cf.jpg', 'Corporate website Development', 'Corporate-website-Development', 0x[encoded data, 10488 characters], 'Virtual stores can be set up for brands across a range of industries and there are a number of different ways brands choose to implement them.', 12, 'corporate web devlopment,web devlopment,website devlopment', NULL, 1, 1, 1),
(142, 169, 55, '61a869f4624d6.jpg', 'News Website development', 'News-Website-development', 0x[encoded data, 5062 characters], 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et', 13, 'news website devlopment,news devlopment,news,News', NULL, 1, 1, 1),
(143, 169, 56, '61a86c830d3a8.jpg', 'Visual Identity and Branding', 'Visual-Identity-and-Branding', 0x[encoded data, 9706 characters], '..', 14, 'brand ,branding ,virtual', NULL, 0, 1, 1);
INSERT INTO `services` (`id`, `language_id`, `scategory_id`, `main_image`, `title`, `slug`, `content`, `summary`, `serial_number`, `meta_keywords`, `meta_description`, `feature`, `details_page_status`, `sidebar`) VALUES
(144, 169, 56, '61a86dcd89083.jpg', 'Graphic  Design', 'Graphic-Design', 0x[encoded data, 4560 characters], '•	What is graphic design?\r\nIt is a creative approach carried out by a designer or a group of designers at the request of the customer or the customer and cooperates on the implementation of its physical data, a group of producers (print workers, programmers, directors, etc.) in order to deliver a specific message (or group of messages) to the target audience. Graphic design refers to a number of technical and professional disciplines that focus on visual communication and its presentation. Various methods are used to create and combine symbols, images or words to create a visual representation of ideas and messages. A graphic designer may use techniques such as calligraphy, visual arts, and page layout to reach the end result. This graphic design often refers to both the process (design) through which communication is created as well as products (designs).Among the users of the art of graphic design are magazines, advertisements and packaging products. For example, a set of products might include a logo or other artwork, structured text and some pure design elements such as shapes and colors that would mold the product into one. Composition is one of the most important features of graphic design, especially when using pre-made materials or various elements.', 15, 'graphic,graphic desing ,design', NULL, 0, 1, 1),
(145, 169, 56, '61a87799df71c.jpg', 'User Interface  Design  UI', 'User-Interface-Design-UI', 0x[encoded data, 6334 characters], 'It is the graphic interface of the application, consisting of the buttons that the user presses, the displayed texts, images, animated slides, the text fields in which the user enters his data and all the elements that the user interacts with.', 16, 'User Interface  Design  UI,UI,User Interface', NULL, 1, 1, 1);
INSERT INTO `services` (`id`, `language_id`, `scategory_id`, `main_image`, `title`, `slug`, `content`, `summary`, `serial_number`, `meta_keywords`, `meta_description`, `feature`, `details_page_status`, `sidebar`) VALUES
(146, 169, 56, '61a87378f39cd.jpg', 'Publication Design', 'Publication-Design', 0x[encoded data, 52480 characters], 'Paper printing depends primarily on paper, as the paper size, thickness, color and type vary depending on the design to be implemented and the purpose for which it is used.', 17, 'Publication Design  ,Publication , Design', NULL, 1, 1, 1);
INSERT INTO `services` (`id`, `language_id`, `scategory_id`, `main_image`, `title`, `slug`, `content`, `summary`, `serial_number`, `meta_keywords`, `meta_description`, `feature`, `details_page_status`, `sidebar`) VALUES
(147, 169, 56, '61a878126b908.jpg', 'User Experience Design  UX', 'User-Experience-Design-UX', 0x3c7020636c6173733d224d736f4e6f726d616c22207374796c653d226d617267696e2d626f74746f6d3a20313570743b206c696e652d6865696768743a20323870783b206261636b67726f756e642d696d6167653a20696e697469616c3b206261636b67726f756e642d706f736974696f6e3a20696e697469616c3b206261636b67726f756e642d73697a653a20696e697469616c3b206261636b67726f756e642d7265706561743a20696e697469616c3b206261636b67726f756e642d6174746163686d656e743a20696e697469616c3b206261636b67726f756e642d6f726967696e3a20696e697469616c3b206261636b67726f756e642d636c69703a20696e697469616c3b223e3c62723e3c2f703e, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et', 18, 'User Experience Design  UX, UX,User Experience', NULL, 1, 1, 1),
(148, 169, 57, '61ac58da817a8.png', 'Medical Clinics App', 'Medical-Clinics-App', 0x[encoded data, 24714 characters], 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et', 19, 'Medical Clinics App, Clinics App,Medical Clinics', NULL, 1, 1, 1);
INSERT INTO `services` (`id`, `language_id`, `scategory_id`, `main_image`, `title`, `slug`, `content`, `summary`, `serial_number`, `meta_keywords`, `meta_description`, `feature`, `details_page_status`, `sidebar`) VALUES
(149, 169, 57, '61ac67907372e.png', 'Salon  App', 'Salon-App', 0x[encoded data, 34306 characters], 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et', 20, 'Salon  App ,Salon', NULL, 1, 1, 1),
(150, 169, 57, '61ac67e346e58.png', 'Service Operators App', 'Service-Operators-App', 0x3c7020636c6173733d224d736f4e6f726d616c22207374796c653d226d617267696e2d626f74746f6d3a20313570743b206c696e652d6865696768743a20323870783b206261636b67726f756e642d696d6167653a20696e697469616c3b206261636b67726f756e642d706f736974696f6e3a20696e697469616c3b206261636b67726f756e642d73697a653a20696e697469616c3b206261636b67726f756e642d7265706561743a20696e697469616c3b206261636b67726f756e642d6174746163686d656e743a20696e697469616c3b206261636b67726f756e642d6f726967696e3a20696e697469616c3b206261636b67726f756e642d636c69703a20696e697469616c3b223e3c7370616e207374796c653d22666f6e742d73697a653a2031332e3570743b206c696e652d6865696768743a20333670783b20666f6e742d66616d696c793a2048656c7665746963612c2073616e732d73657269663b223e3c62723e3c2f7370616e3e3c2f703e3c7020636c6173733d224d736f4e6f726d616c22207374796c653d226d617267696e2d626f74746f6d3a20313570743b206c696e652d6865696768743a20323870783b206261636b67726f756e642d696d6167653a20696e697469616c3b206261636b67726f756e642d706f736974696f6e3a20696e697469616c3b206261636b67726f756e642d73697a653a20696e697469616c3b206261636b67726f756e642d7265706561743a20696e697469616c3b206261636b67726f756e642d6174746163686d656e743a20696e697469616c3b206261636b67726f756e642d6f726967696e3a20696e697469616c3b206261636b67726f756e642d636c69703a20696e697469616c3b223e3c62723e3c2f703e, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et', 21, 'Service Operators App ,Service  App,Service Operators', NULL, 1, 1, 1);
INSERT INTO `services` (`id`, `language_id`, `scategory_id`, `main_image`, `title`, `slug`, `content`, `summary`, `serial_number`, `meta_keywords`, `meta_description`, `feature`, `details_page_status`, `sidebar`) VALUES
(151, 169, 57, '61ac697d95fd7.png', 'Restaurants App', 'Restaurants-App', 0x[encoded data, 13998 characters], 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et', 22, 'Restaurants App,Restaurants ,App', NULL, 1, 1, 1),
(152, 169, 57, '61ac69e5c7db7.png', 'Store App', 'Store-App', 0x[encoded data, 10178 characters], 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et', 23, 'Store App, App,Store', NULL, 1, 1, 1);
INSERT INTO `services` (`id`, `language_id`, `scategory_id`, `main_image`, `title`, `slug`, `content`, `summary`, `serial_number`, `meta_keywords`, `meta_description`, `feature`, `details_page_status`, `sidebar`) VALUES
(153, 169, 57, '61ac6aa6e4140.png', 'Classified ads App', 'Classified-ads-App', 0x[encoded data, 28242 characters], 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et', 24, 'Classified ads App, ads App,Classified ads', NULL, 1, 1, 1),
(155, 169, 58, '1593839395.jpg', 'Javascript Plugin', 'javascript-plugin', 0x[encoded data, 10054 characters], 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et', 26, NULL, NULL, 0, 1, 0),
(156, 169, 58, '1593839417.jpg', 'Chrome Extensions', 'chrome-extensions', 0x[encoded data, 10054 characters], 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et', 27, NULL, NULL, 0, 1, 0);
INSERT INTO `services` (`id`, `language_id`, `scategory_id`, `main_image`, `title`, `slug`, `content`, `summary`, `serial_number`, `meta_keywords`, `meta_description`, `feature`, `details_page_status`, `sidebar`) VALUES
(157, 169, 58, '1593839426.jpg', 'PHP Plugin', 'php-plugin', 0x[encoded data, 10054 characters], 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et', 28, NULL, NULL, 0, 1, 1),
(159, 169, 59, '61ac53e83eceb.jpg', 'SEO', 'SEO', 0x[encoded data, 4554 characters], 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et', 30, 'seo,SEO,محركات البحث', NULL, 1, 1, 1),
(162, 169, 60, '61ac7c2985f79.png', 'Video Slider', 'Video-Slider', 0x3c6832207374796c653d226d617267696e3a2030636d2030636d20302e3030303170743b206261636b67726f756e642d696d6167653a20696e697469616c3b206261636b67726f756e642d706f736974696f6e3a20696e697469616c3b206261636b67726f756e642d73697a653a20696e697469616c3b206261636b67726f756e642d7265706561743a20696e697469616c3b206261636b67726f756e642d6174746163686d656e743a20696e697469616c3b206261636b67726f756e642d6f726967696e3a20696e697469616c3b206261636b67726f756e642d636c69703a20696e697469616c3b223e3c623e3c7370616e207374796c653d22666f6e742d66616d696c793a202671756f743b54696d6573204e657720526f6d616e2671756f743b3b20666f6e742d73697a653a20313870783b223e566964656f20536c696465723c2f7370616e3e3c6f3a703e3c2f6f3a703e3c2f623e3c2f68323e3c6832207374796c653d226d617267696e3a2030636d2030636d20302e3030303170743b206261636b67726f756e642d696d6167653a20696e697469616c3b206261636b67726f756e642d706f736974696f6e3a20696e697469616c3b206261636b67726f756e642d73697a653a20696e697469616c3b206261636b67726f756e642d7265706561743a20696e697469616c3b206261636b67726f756e642d6174746163686d656e743a20696e697469616c3b206261636b67726f756e642d6f726967696e3a20696e697469616c3b206261636b67726f756e642d636c69703a20696e697469616c3b223e0a0a3c7020636c6173733d224d736f4e6f726d616c223e3c7370616e207374796c653d22666f6e742d73697a653a20313670743b206c696e652d6865696768743a20313037253b223e3c6f3a703e266e6273703b3c2f6f3a703e3c2f7370616e3e3c2f703e0a0a3c70207374796c653d226d617267696e3a30636d3b6d617267696e2d626f74746f6d3a2e3030303170743b746578742d616c69676e3a6a757374696679223e3c7370616e207374796c653d2277686974652d73706163653a7072652d77726170223e3c7370616e207374796c653d22666f6e742d73697a653a20313670743b206261636b67726f756e642d696d6167653a20696e697469616c3b206261636b67726f756e642d706f736974696f6e3a20696e697469616c3b206261636b67726f756e642d73697a653a20696e697469616c3b206261636b67726f756e642d7265706561743a20696e697469616c3b206261636b67726f756e642d6174746163686d656e743a20696e697469616c3b206261636b67726f756e642d6f726967696e3a20696e697469616c3b206261636b67726f756e642d636c69703a20696e697469616c3b20666f6e742d66616d696c793a202671756f743b54696d6573204e657720526f6d616e2671756f743b3b223e4974206973206120626c6f6767657220746f6f6c207573656420746f20646973706c617920746f7069637320666f7220796f75206f7220616e797468696e6720696e2074686520666f726d206f6620616e696d6174656420696d6167657320746861742067697665206120776f6e64657266756c20736861706520746f2074686520626c6f6720616e6420696e637265617365207468652076697369746f72277320696e74657265737420696e207768617420697320646973706c6179656420696e207468697320736c6964652073686f772e20427920636f6e76657274696e67207468656d20746f20766964656f20736c6964657320616e64206d657267696e6720696d6167657320616e6420617564696f2066696c65732c207468656e2073657474696e672077617973206f72206566666563747320746f206d6f76652066726f6d206f6e6520696d61676520746f20616e6f746865722c20696e2072657475726e20666f7220676976696e67207468656d206c69666520616e6420766974616c6974792e3c2f7370616e3e3c2f7370616e3e3c7370616e207374796c653d22666f6e742d73697a653a20313670743b223e3c6f3a703e3c2f6f3a703e3c2f7370616e3e3c2f703e3c2f68323e, 'It is a blogger tool used to display topics for you or anything in the form of animated images', 33, 'Video Slider,Video ,Slider', NULL, 1, 1, 1),
(163, 169, 60, '61ac7cc97b37a.jpg', 'Promo Video', 'Promo-Video', 0x[encoded data, 13490 characters], 'Video is one of the most important sources of promotion and rapid spread instead of long and boring pages, and it is the most effective and effective promotional tool to impress users and site visitors, with a summary of the idea and goal, and contributes to influencing the chances of increasing sales of websites and services and Products in large percentages of more than 75% when it is dazzling and fun.', 34, 'Promo Video,Promo', NULL, 1, 1, 1),
(164, 169, 60, '61ac7d3cd17c9.jpg', 'Motion Graphic', 'Motion-Graphic', 0x[encoded data, 11238 characters], 'Animation is an animated display of graphics intended to clarify and simplify information.', 35, 'Motion Graphic,Motion , Graphic', NULL, 1, 1, 1);
INSERT INTO `services` (`id`, `language_id`, `scategory_id`, `main_image`, `title`, `slug`, `content`, `summary`, `serial_number`, `meta_keywords`, `meta_description`, `feature`, `details_page_status`, `sidebar`) VALUES
(165, 169, 60, '61ac7dba41125.jpg', 'Infographic', 'Infographic', 0x[encoded data, 12640 characters], 'It is the art of transforming data and information into easy-to-understand images and graphics to change the routine way of presenting information and data to the public.', 36, 'Infographic,InfoGraphic', NULL, 1, 1, 1),
(169, 169, 61, '61ac8391a694f.jpg', 'Technical Consulting', 'Technical-Consulting', 0x3c7020636c6173733d224d736f4e6f726d616c22207374796c653d226d617267696e2d626f74746f6d3a20313570743b206c696e652d6865696768743a20323870783b206261636b67726f756e642d696d6167653a20696e697469616c3b206261636b67726f756e642d706f736974696f6e3a20696e697469616c3b206261636b67726f756e642d73697a653a20696e697469616c3b206261636b67726f756e642d7265706561743a20696e697469616c3b206261636b67726f756e642d6174746163686d656e743a20696e697469616c3b206261636b67726f756e642d6f726967696e3a20696e697469616c3b206261636b67726f756e642d636c69703a20696e697469616c3b223e3c7370616e207374796c653d22666f6e742d73697a653a2031332e3570743b206c696e652d6865696768743a20333670783b20666f6e742d66616d696c793a2048656c7665746963612c2073616e732d73657269663b223e3c62723e3c2f7370616e3e3c2f703e3c7020636c6173733d224d736f4e6f726d616c22207374796c653d226d617267696e2d626f74746f6d3a20313570743b206c696e652d6865696768743a20323870783b206261636b67726f756e642d696d6167653a20696e697469616c3b206261636b67726f756e642d706f736974696f6e3a20696e697469616c3b206261636b67726f756e642d73697a653a20696e697469616c3b206261636b67726f756e642d7265706561743a20696e697469616c3b206261636b67726f756e642d6174746163686d656e743a20696e697469616c3b206261636b67726f756e642d6f726967696e3a20696e697469616c3b206261636b67726f756e642d636c69703a20696e697469616c3b223e3c62723e3c2f703e, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et', 40, 'Technical Consulting, Consulting,Technical', NULL, 1, 1, 1),
(209, 173, 70, '6179001f8fdf8.jpg', 'المتاجر الإفتراضية', 'المتاجر-الإفتراضية', 0x[encoded data, 6976 characters], 'ما هي المتاجر الافتراضية؟\r\nالمتاجر الافتراضية هي عبارة عن شركة ويبِ ذات قناةِ تختص بالتجارة على الإنترنت، والتي تحصد تقريباً كُلّ دخلها مِنْ المبيعاتِ على الإنترنتِ، فالتاجر هنا يقوم بتَقديم الصفقاتِ التجارية عن طريق المتجر من خلال الإنترنت.', 1, 'المتجر,المتجر الافتراضي,الافتراضي,متجر افتراضي', 'توفر المتاجر الافتراضية العديد من الميّزات والأدوات التفاعلية المثيرة للاهتمام  لمتجر الويب الخاص بك، حيث توفّر هذه التقنية متعة للعملاء في عملية التسوّق من المتاجر الافتراضية، ويوجد العديد من الاحتمالات والخيارات لاستخدام هذه التقنية المتطورة في المتاجر الافتراضية ومن أهمها هي :عرض منتجاتك بطريقة مميّزة ، بحيث يمكن استخدام تقنية الواقع المعزز لتعرض منتجاتك بطريقة جميلة جدًا.أيضاً استخدام تقنية HERO® ، يمكن للعلامات التجارية إنشاء المزيد من تجارب المتاجر الافتراضية الشخصية من خلال السماح للعملاء بالتواصل مع الشركاء في المتجر على الفور.', 1, 1, 1),
(211, 173, 70, '6179007ad1d38.jpg', 'المدرسة الذكية', 'المدرسة-الذكية', 0x[encoded data, 8746 characters], 'هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز على الشكل الخارجي للنص أو شكل توضع', 3, 'المدرسة,المدرسة الذكية', NULL, 1, 1, 1),
(212, 173, 70, '617900df55edc.jpg', 'نقاط البيع', 'نقاط-البيع', 0x[encoded data, 11082 characters], 'هناك حقيقة مثبتة منذ زمن طويل وهي أن المحتوى المقروء لصفحة ما سيلهي القارئ عن التركيز على الشكل الخارجي للنص أو شكل توضع', 4, 'pos', 'pos', 1, 1, 1);
