Hello Darkforums community
today I will share the DB of UAE farms company . website was hacked by me few months ago I will repost its Data here it contains : full names, address , company details, emails, numbers ....etc
Full data link 3.5 GB (SQL) : https://www.mediafire.com/file/18sthq68p...E.sql/file
SAMPLE:
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";START TRANSACTION;SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;/*!40101 SET NAMES utf8mb4 */; ---- Database: `farmsuae_farm`--CREATE DATABASE IF NOT EXISTS `farmsuae_farm` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;USE `farmsuae_farm`; -- -------------------------------------------------------- ---- Table structure for table `areas`-- CREATE TABLE `areas` ( `id` bigint UNSIGNED NOT NULL, `name_ar` varchar(255) NOT NULL, `name_en` varchar(255) NOT NULL, `parent_id` bigint UNSIGNED DEFAULT NULL, `lat` int DEFAULT NULL, `lng` int DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC; ---- Dumping data for table `areas`-- INSERT INTO `areas` VALUES(296, 'الامارات', 'Emirates', NULL, NULL, NULL, '2024-06-07 06:09:10', '2024-06-07 06:27:29');INSERT INTO `areas` VALUES(298, 'أبوظبي', 'Abu Dhabi', 296, NULL, NULL, '2024-06-07 06:24:47', '2024-06-07 06:24:47');INSERT INTO `areas` VALUES(300, 'دبي', 'Dubai', 296, NULL, NULL, '2024-06-07 06:25:27', '2024-06-07 06:25:27');INSERT INTO `areas` VALUES(301, 'الشارقة', 'Sharjah', 296, NULL, NULL, '2024-06-07 06:25:53', '2024-06-07 06:25:53');INSERT INTO `areas` VALUES(302, 'عجمان', 'Ajman', 296, NULL, NULL, '2024-06-07 06:26:14', '2024-06-07 06:26:14');INSERT INTO `areas` VALUES(303, 'أم القيوين', 'Umm Al Quwain', 296, NULL, NULL, '2024-06-07 06:26:31', '2024-06-07 06:26:31');INSERT INTO `areas` VALUES(304, 'رأس الخيمة', 'Ras Al Khaimah', 296, NULL, NULL, '2024-06-07 06:28:20', '2024-06-07 06:28:20');INSERT INTO `areas` VALUES(305, 'الفجيرة', 'Fujairah', 296, NULL, NULL, '2024-06-07 06:28:45', '2024-06-07 06:28:45');INSERT INTO `areas` VALUES(10312, 'عمان', 'Oman', NULL, NULL, NULL, '2024-08-08 19:39:45', '2024-08-08 19:39:45');INSERT INTO `areas` VALUES(10313, 'السعوديه', 'Saudi Arabia', NULL, NULL, NULL, '2024-08-08 19:41:51', '2024-08-08 19:41:51');INSERT INTO `areas` VALUES(10314, 'الكويت', 'Kuwait', NULL, NULL, NULL, '2024-08-09 07:00:00', '2024-08-09 07:00:00');INSERT INTO `areas` VALUES(10315, 'البحرين', 'Bahrain', NULL, NULL, NULL, '2024-08-09 07:01:03', '2024-08-09 07:01:03');INSERT INTO `areas` VALUES(10316, 'قطر', 'Qatar', NULL, NULL, NULL, '2024-08-09 07:02:23', '2024-08-09 07:02:23');INSERT INTO `areas` VALUES(10320, 'العين', 'Alain', 296, NULL, NULL, '2024-08-10 10:09:11', '2024-08-10 10:09:11');INSERT INTO `areas` VALUES(10321, 'الختم', 'Al khatim', 298, NULL, NULL, '2024-08-10 10:09:48', '2024-08-10 10:09:48');INSERT INTO `areas` VALUES(10322, 'الفلاح', 'Al falah', 298, NULL, NULL, '2024-08-10 10:10:10', '2024-08-10 10:10:10');INSERT INTO `areas` VALUES(10323, 'اخرى', 'Other', 298, NULL, NULL, '2024-08-10 10:10:38', '2024-08-10 10:10:38');INSERT INTO `areas` VALUES(10324, 'الرحبة', 'Alrahba', 298, NULL, NULL, '2024-08-10 11:03:21', '2024-08-10 11:03:21');INSERT INTO `areas` VALUES(10325, 'العجبان', 'Alajban', 298, NULL, NULL, '2024-08-11 08:57:44', '2024-08-11 08:57:44');INSERT INTO `areas` VALUES(10326, 'مدينه زايد الظفره', 'Al dhafrah', 298, NULL, NULL, '2024-08-11 08:58:28', '2024-08-11 08:58:28');INSERT INTO `areas` VALUES(10327, 'غياثي', 'Ghayathi', 298, NULL, NULL, '2024-08-11 08:58:56', '2024-08-11 08:58:56');INSERT INTO `areas` VALUES(10328, 'مصفح', 'Mosafah', 298, NULL, NULL, '2024-08-11 08:59:52', '2024-08-11 08:59:52');INSERT INTO `areas` VALUES(10329, 'الطيبه', 'Al tayeba', 298, NULL, NULL, '2024-08-11 09:00:26', '2024-08-11 09:00:26');INSERT INTO `areas` VALUES(10330, 'الوثبه', 'Alwathbah', 298, NULL, NULL, '2024-08-11 09:01:02', '2024-08-11 09:01:02');INSERT INTO `areas` VALUES(10331, 'الشامخه', 'Al shamkhah', 298, NULL, NULL, '2024-08-11 09:01:50', '2024-08-11 09:01:50');INSERT INTO `areas` VALUES(10332, 'الرياض', 'Al ryad', 298, NULL, NULL, '2024-08-11 09:02:11', '2024-08-11 09:02:11');INSERT INTO `areas` VALUES(10333, 'ناهل', 'Nahel', 10320, NULL, NULL, '2024-08-11 09:03:29', '2024-08-11 09:03:29');INSERT INTO `areas` VALUES(10334, 'الخزنه', 'Al khaznah', 10320, NULL, NULL, '2024-08-11 09:03:51', '2024-08-11 09:03:51');INSERT INTO `areas` VALUES(10335, 'الساد', 'Al saad', 10320, NULL, NULL, '2024-08-11 09:04:42', '2024-08-11 09:04:42');INSERT INTO `areas` VALUES(10336, 'سويحان', 'Suwihan', 10320, NULL, NULL, '2024-08-11 09:05:08', '2024-08-11 09:05:08');INSERT INTO `areas` VALUES(10337, 'رماح', 'Remah', 10320, NULL, NULL, '2024-08-11 09:05:32', '2024-08-11 09:05:32');INSERT INTO `areas` VALUES(10338, 'اليحر', 'Al yaher', 10320, NULL, NULL, '2024-08-11 09:05:57', '2024-08-11 09:05:57');INSERT INTO `areas` VALUES(10339, 'الهير', 'Al hayar', 10320, NULL, NULL, '2024-08-11 09:07:25', '2024-08-11 09:07:25');INSERT INTO `areas` VALUES(10340, 'الفقع', 'Al faqaa', 10320, NULL, NULL, '2024-08-11 09:07:43', '2024-08-11 09:07:43');INSERT INTO `areas` VALUES(10341, 'الوقن', 'Al wagan', 10320, NULL, NULL, '2024-08-11 09:08:06', '2024-08-11 09:08:06');INSERT INTO `areas` VALUES(10342, 'القوع', 'Al qou', 10320, NULL, NULL, '2024-08-11 09:08:34', '2024-08-11 09:08:34');INSERT INTO `areas` VALUES(10343, 'ابوكريه', 'Abu kraya', 10320, NULL, NULL, '2024-08-11 09:09:00', '2024-08-11 09:09:00');INSERT INTO `areas` VALUES(10344, 'العراد', 'Al araad', 10320, NULL, NULL, '2024-08-11 09:09:20', '2024-08-11 09:09:20');INSERT INTO `areas` VALUES(10345, 'مدينه العين', 'Madinat al ain', 10320, NULL, NULL, '2024-08-11 09:09:52', '2024-08-11 09:09:52');INSERT INTO `areas` VALUES(10346, 'صناعية العين', 'Sanaaia', 10320, NULL, NULL, '2024-08-11 09:10:39', '2024-08-11 09:10:39');INSERT INTO `areas` VALUES(10347, 'المقام', 'Al maqam', 10320, NULL, NULL, '2024-08-11 09:11:02', '2024-08-11 09:11:02');INSERT INTO `areas` VALUES(10348, 'شعاب الاشخر', 'Sheab al alshqhar', 10320, NULL, NULL, '2024-08-11 09:11:42', '2024-08-28 05:27:50');INSERT INTO `areas` VALUES(10349, 'زاخر', 'Zakher', 10320, NULL, NULL, '2024-08-11 09:12:04', '2024-08-11 09:12:04');INSERT INTO `areas` VALUES(10350, 'الزعلة', 'Al zalaa', 10320, NULL, NULL, '2024-08-11 09:12:41', '2024-08-11 09:12:41');INSERT INTO `areas` VALUES(10352, 'بدع بنت سعود', 'Bade bin sauod', 10320, NULL, NULL, '2024-08-11 09:14:53', '2024-08-11 09:14:53');INSERT INTO `areas` VALUES(10353, 'نهشله', 'Nahshela', 298, NULL, NULL, '2024-08-11 09:17:24', '2024-08-11 09:17:24');INSERT INTO `areas` VALUES(10354, 'الرزين', 'Al razeen', 298, NULL, NULL, '2024-08-11 09:17:50', '2024-08-11 09:17:50');INSERT INTO `areas` VALUES(10355, 'الخريمه', 'Al khurima', 298, NULL, NULL, '2024-08-11 09:18:18', '2024-08-11 09:18:18');INSERT INTO `areas` VALUES(10356, 'الوافيه', 'Al wafya', 298, NULL, NULL, '2024-08-11 09:18:52', '2024-08-11 09:18:52');INSERT INTO `areas` VALUES(10357, 'البوادي', 'Al bawadi', 10320, NULL, NULL, '2024-08-11 09:27:54', '2024-08-11 09:27:54');INSERT INTO `areas` VALUES(10358, 'مزيد', 'Mazyad', 10320, NULL, NULL, '2024-08-11 09:28:27', '2024-08-11 09:28:27');INSERT INTO `areas` VALUES(10359, 'النباغ', 'Al nabagh', 10320, NULL, NULL, '2024-08-11 09:29:02', '2024-08-11 09:29:02');INSERT INTO `areas` VALUES(10360, 'البريمي', 'Al borimy', 10312, NULL, NULL, '2024-08-11 09:29:46', '2024-08-11 09:29:46');INSERT INTO `areas` VALUES(10361, 'مسقط', 'Masqat', 10312, NULL, NULL, '2024-08-11 09:30:08', '2024-08-11 09:30:08');INSERT INTO `areas` VALUES(10362, 'نزوى', 'Nazwa', 10312, NULL, NULL, '2024-08-11 09:30:25', '2024-08-11 09:30:25');INSERT INTO `areas` VALUES(10363, 'عبري', 'Ebrie', 10312, NULL, NULL, '2024-08-11 09:30:56', '2024-08-11 09:30:56');INSERT INTO `areas` VALUES(10364, 'صلاله', 'Salalah', 10312, NULL, NULL, '2024-08-11 09:31:22', '2024-08-11 09:31:22');INSERT INTO `areas` VALUES(10365, 'أخرى', 'Others', 10312, NULL, NULL, '2024-08-11 09:31:42', '2024-08-11 09:31:42');INSERT INTO `areas` VALUES(10366, 'صحار', 'Sohar', 10312, NULL, NULL, '2024-08-11 09:32:05', '2024-08-11 09:32:05');INSERT INTO `areas` VALUES(10367, 'الجبل الاخضر', 'Al jabal Al akhdar', 10312, NULL, NULL, '2024-08-11 09:32:53', '2024-08-11 09:32:53');INSERT INTO `areas` VALUES(10368, 'الوادي الكبير', 'Al wadi Al khabeer', 10312, NULL, NULL, '2024-08-11 09:33:28', '2024-08-11 09:33:28');INSERT INTO `areas` VALUES(10369, 'الفايه', 'Al faya', 298, NULL, NULL, '2024-08-11 10:26:46', '2024-08-11 10:26:46');INSERT INTO `areas` VALUES(10370, 'الباهيه', 'Al baheia', 298, NULL, NULL, '2024-08-11 10:27:50', '2024-08-11 10:27:50');INSERT INTO `areas` VALUES(10371, 'الشهامه', 'Al shaham', 298, NULL, NULL, '2024-08-11 10:28:15', '2024-08-11 10:28:15');INSERT INTO `areas` VALUES(10372, 'الشوامخ', 'Al shawamekh', 298, NULL, NULL, '2024-08-11 10:28:49', '2024-08-11 10:28:49');INSERT INTO `areas` VALUES(10373, 'مسافي', 'Masafi', 304, NULL, NULL, '2024-08-11 11:03:07', '2024-08-11 11:03:07');INSERT INTO `areas` VALUES(10374, 'رأس الخيمة', 'Ras alkhima', 304, NULL, NULL, '2024-08-11 11:03:41', '2024-08-11 11:09:16');INSERT INTO `areas` VALUES(10375, 'معيريض', 'Moeeired', 304, NULL, NULL, '2024-08-11 11:04:09', '2024-08-11 11:04:09');INSERT INTO `areas` VALUES(10376, 'اخرى', 'Others', 304, NULL, NULL, '2024-08-11 11:08:46', '2024-08-11 11:08:46');INSERT INTO `areas` VALUES(10377, 'الدقداقه', 'Al degdagah', 304, NULL, NULL, '2024-08-11 11:09:51', '2024-08-11 11:09:51');INSERT INTO `areas` VALUES(10378, 'الخران', 'Al kharan', 304, NULL, NULL, '2024-08-11 11:10:43', '2024-08-11 11:10:43');INSERT INTO `areas` VALUES(10379, 'الجزيرة الحمراء', 'Al jazira alhamra', 304, NULL, NULL, '2024-08-11 11:11:40', '2024-08-11 11:11:40');INSERT INTO `areas` VALUES(10380, 'الساعدي', 'Al sady', 304, NULL, NULL, '2024-08-11 11:12:08', '2024-08-11 11:12:08');INSERT INTO `areas` VALUES(10381, 'الغيل', 'Al gheel', 304, NULL, NULL, '2024-08-11 11:13:21', '2024-08-11 11:13:21');INSERT INTO `areas` VALUES(10382, 'الذيد', 'Al dheed', 301, NULL, NULL, '2024-08-11 20:31:01', '2024-08-11 20:31:01');INSERT INTO `areas` VALUES(10383, 'الصجعه', 'Al sajaa', 301, NULL, NULL, '2024-08-11 20:31:22', '2024-08-11 20:31:22');INSERT INTO `areas` VALUES(10384, 'الزبير', 'Al zobeer', 301, NULL, NULL, '2024-08-11 20:31:51', '2024-08-11 20:31:51');INSERT INTO `areas` VALUES(10385, 'مليحه', 'Meleeha', 301, NULL, NULL, '2024-08-11 20:32:36', '2024-08-11 20:32:36');INSERT INTO `areas` VALUES(10386, 'مدينه الشارقة', 'Al Sharjah', 301, NULL, NULL, '2024-08-11 20:33:32', '2024-08-11 20:33:32');INSERT INTO `areas` VALUES(10387, 'صناعية الشارقه', 'Sharjah industry airya', 301, NULL, NULL, '2024-08-11 20:35:38', '2024-08-11 20:35:38');INSERT INTO `areas` VALUES(10388, 'اخرى', 'Other', 301, NULL, NULL, '2024-08-11 20:36:31', '2024-08-11 20:36:31');INSERT INTO `areas` VALUES(10389, 'الحليو', 'Al helew', 302, NULL, NULL, '2024-08-11 20:37:25', '2024-08-11 20:37:25');INSERT INTO `areas` VALUES(10390, 'الجرف', 'Al jarf', 302, NULL, NULL, '2024-08-11 20:38:23', '2024-08-11 20:38:23');INSERT INTO `areas` VALUES(10391, 'الحميديه', 'Al homeidia', 302, NULL, NULL, '2024-08-11 20:38:45', '2024-08-11 20:38:45');INSERT INTO `areas` VALUES(10392, 'أخرى', 'Others', 302, NULL, NULL, '2024-08-11 20:39:03', '2024-08-11 20:39:03');INSERT INTO `areas` VALUES(10393, 'مصفوت', 'Masfout', 302, NULL, NULL, '2024-08-11 20:39:03', '2024-09-19 17:57:37');INSERT INTO `areas` VALUES(10394, 'كابر', 'Kaber', 303, NULL, NULL, '2024-08-11 20:40:24', '2024-08-11 20:40:24');INSERT INTO `areas` VALUES(10395, 'فلج المعلى', 'Falaj Al moala', 303, NULL, NULL, '2024-08-11 20:40:55', '2024-08-11 20:41:11');INSERT INTO `areas` VALUES(10396, 'مدينه أم القيوين', 'Um alquwin city', 303, NULL, NULL, '2024-08-11 20:43:40', '2024-08-11 20:43:40');INSERT INTO `areas` VALUES(10397, 'أخرى', 'Others', 303, NULL, NULL, '2024-08-11 20:44:04', '2024-08-11 20:44:04');INSERT INTO `areas` VALUES(10398, 'السلمه', 'Al salamah', 303, NULL, NULL, '2024-08-11 20:44:37', '2024-08-11 20:44:37');INSERT INTO `areas` VALUES(10399, 'سكمكم', 'Sakamkam', 305, NULL, NULL, '2024-08-11 20:45:46', '2024-08-11 20:45:46');INSERT INTO `areas` VALUES(10400, 'سوق الجمعه', 'Friday market', 305, NULL, NULL, '2024-08-11 20:46:15', '2024-08-11 20:46:15');INSERT INTO `areas` VALUES(10401, 'مسافي', 'Masafi', 305, NULL, NULL, '2024-08-11 20:46:38', '2024-08-11 20:46:38');INSERT INTO `areas` VALUES(10402, 'اخرى', 'Others', 305, NULL, NULL, '2024-08-11 20:46:55', '2024-08-11 20:46:55');INSERT INTO `areas` VALUES(10403, 'العوير', 'Alowir', 300, NULL, NULL, '2024-08-11 20:48:03', '2024-08-11 20:48:03');INSERT INTO `areas` VALUES(10404, 'ديره', 'Deira', 300, NULL, NULL, '2024-08-11 20:48:25', '2024-09-19 17:54:23');INSERT INTO `areas` VALUES(10405, 'اخرى', 'Others', 300, NULL, NULL, '2024-08-11 20:48:52', '2024-08-11 20:48:52');INSERT INTO `areas` VALUES(10406, 'المرموم', 'Al marmoom', 300, NULL, NULL, '2024-08-11 20:49:13', '2024-08-11 20:49:13');INSERT INTO `areas` VALUES(10407, 'جبل علي', 'Jabal ali', 300, NULL, NULL, '2024-08-11 20:49:41', '2024-08-11 20:49:41');INSERT INTO `areas` VALUES(10408, 'بر دبي', 'Bar dubai', 300, NULL, NULL, '2024-08-11 20:50:18', '2024-08-11 20:50:18');INSERT INTO `areas` VALUES(10409, 'الخوانيج', 'Al khawneej', 300, NULL, NULL, '2024-08-11 20:50:56', '2024-08-11 20:50:56');INSERT INTO `areas` VALUES(10410, 'صاع', 'Saa', 10320, NULL, NULL, '2024-08-12 11:03:43', '2024-08-12 11:03:43');INSERT INTO `areas` VALUES(10411, 'اخرى', 'Others', 10320, NULL, NULL, '2024-08-12 11:04:06', '2024-08-12 11:04:06');INSERT INTO `areas` VALUES(10412, 'ليوا', 'Liwa', 298, NULL, NULL, '2024-08-28 05:12:31', '2024-08-28 05:12:31');INSERT INTO `areas` VALUES(10413, 'جزيرة ابوظبي', 'Abu Dhabi', 298, NULL, NULL, '2024-08-28 05:15:39', '2024-08-28 05:15:39');INSERT INTO `areas` VALUES(10414, 'الميناء', 'Al meena', 298, NULL, NULL, '2024-08-28 05:16:45', '2024-08-28 05:16:45');INSERT INTO `areas` VALUES(10415, 'العدله', 'Al adlah', 298, NULL, NULL, '2024-08-28 05:17:50', '2024-08-28 05:17:50');INSERT INTO `areas` VALUES(10416, 'المرفأ', 'Al marfa', 298, NULL, NULL, '2024-08-28 05:18:56', '2024-08-28 05:18:56');INSERT INTO `areas` VALUES(10417, 'حميم', 'Hameem', 298, NULL, NULL, '2024-08-28 05:20:00', '2024-08-28 05:20:00');INSERT INTO `areas` VALUES(10418, 'الشويب', 'Al shuwib', 10320, NULL, NULL, '2024-08-28 05:24:45', '2024-08-28 05:24:45');INSERT INTO `areas` VALUES(10419, 'عين الفايضه', 'Sin alfaydah', 10320, NULL, NULL, '2024-08-28 05:26:04', '2024-08-28 05:26:04');INSERT INTO `areas` VALUES(10420, 'المدام', 'Al madam', 301, NULL, NULL, '2024-08-29 14:34:36', '2024-08-29 14:34:36');INSERT INTO `areas` VALUES(10422, 'الاحساء', 'Al ihsaa', 10313, NULL, NULL, '2024-08-29 14:36:36', '2024-08-29 14:36:36');INSERT INTO `areas` VALUES(10423, 'الرياض', 'Al riad', 10313, NULL, NULL, '2024-08-29 14:36:57', '2024-08-29 14:36:57');INSERT INTO `areas` VALUES(10424, 'الدمام', 'Damam', 10313, NULL, NULL, '2024-08-29 14:37:30', '2024-08-29 14:37:30');INSERT INTO `areas` VALUES(10425, 'مكه', 'Mekah', 10313, NULL, NULL, '2024-08-29 14:37:50', '2024-08-29 14:37:50');INSERT INTO `areas` VALUES(10426, 'المدينه المنوره', 'Madinah', 10313, NULL, NULL, '2024-08-29 14:38:17', '2024-08-29 14:38:17');INSERT INTO `areas` VALUES(10427, 'جده', 'Jedah', 10313, NULL, NULL, '2024-08-29 14:38:33', '2024-08-29 14:38:33');INSERT INTO `areas` VALUES(10428, 'حفر الباطن', 'Hafr Al baten', 10313, NULL, NULL, '2024-08-29 14:38:58', '2024-08-29 14:39:15');INSERT INTO `areas` VALUES(10429, 'اخرى', 'Others', 10313, NULL, NULL, '2024-08-29 14:39:35', '2024-08-29 14:39:35');INSERT INTO `areas` VALUES(10430, 'الظفره', 'Al dafrah', 298, NULL, NULL, '2024-09-02 10:35:57', '2024-09-02 10:35:57');INSERT INTO `areas` VALUES(10431, 'كل الإمارات', 'All UAE', 296, NULL, NULL, '2024-09-03 07:54:08', '2024-09-03 07:54:08');INSERT INTO `areas` VALUES(10432, 'الظاهره طريق الوقن', 'Al Dahrah', 10320, NULL, NULL, '2024-09-03 07:55:06', '2024-09-03 07:55:06');INSERT INTO `areas` VALUES(10433, 'الظاهر طريق مزيد', 'Al daher', 10320, NULL, NULL, '2024-09-03 07:55:37', '2024-09-03 07:55:37');INSERT INTO `areas` VALUES(10434, 'السلع', 'Alselaa', 298, NULL, NULL, '2024-09-03 07:56:51', '2024-09-03 07:56:51');INSERT INTO `areas` VALUES(10435, 'براكه', 'Baraaka', 298, NULL, NULL, '2024-09-03 07:57:14', '2024-09-03 07:57:14');INSERT INTO `areas` VALUES(10436, 'اذن', 'Aden', 304, NULL, NULL, '2024-09-05 18:35:55', '2024-09-05 18:35:55');INSERT INTO `areas` VALUES(10437, 'حرز', 'Herz', 10320, NULL, NULL, '2024-09-07 09:45:21', '2024-09-07 09:45:21');INSERT INTO `areas` VALUES(10438, 'دبا الفجيره', 'Dibba', 305, NULL, NULL, '2024-09-19 17:32:18', '2024-09-19 17:32:18');INSERT INTO `areas` VALUES(10439, 'خورفكان', 'Khor fakkan', 301, NULL, NULL, '2024-09-19 17:36:43', '2024-09-19 17:36:43');INSERT INTO `areas` VALUES(10440, 'كلباء', 'Kalba', 301, NULL, NULL, '2024-09-19 17:38:04', '2024-09-19 17:38:04');INSERT INTO `areas` VALUES(10441, 'الحمريه', 'Al hamriya', 301, NULL, NULL, '2024-09-19 17:39:56', '2024-09-19 17:39:56');INSERT INTO `areas` VALUES(10442, 'الفاو', 'Alfaw', 301, NULL, NULL, '2024-09-19 17:43:44', '2024-09-19 17:43:44');INSERT INTO `areas` VALUES(10443, 'وادي العمردي', 'Wadi alamardi', 300, NULL, NULL, '2024-09-19 17:46:23', '2024-09-19 17:46:23');INSERT INTO `areas` VALUES(10444, 'ورسان', 'Warsan', 300, NULL, NULL, '2024-09-19 17:47:27', '2024-09-19 17:47:27');INSERT INTO `areas` VALUES(10445, 'مرغم', 'Margham', 300, NULL, NULL, '2024-09-19 17:49:46', '2024-09-19 17:49:46');INSERT INTO `areas` VALUES(10446, 'الهباب', 'Lahbab', 300, NULL, NULL, '2024-09-19 17:50:41', '2024-09-19 17:50:41');INSERT INTO `areas` VALUES(10447, 'حتا', 'Hatta', 300, NULL, NULL, '2024-09-19 17:55:52', '2024-09-19 17:55:52');INSERT INTO `areas` VALUES(10448, 'المنامه', 'Al manamah', 302, NULL, NULL, '2024-09-19 17:58:22', '2024-09-19 17:58:22');INSERT INTO `areas` VALUES(10449, 'الحمرانيه', 'Alhamraniya', 304, NULL, NULL, '2024-09-21 14:10:50', '2024-09-21 14:10:50'); -- -------------------------------------------------------- ---- Table structure for table `blocks`-- CREATE TABLE `blocks` ( `id` bigint UNSIGNED NOT NULL, `user_id` bigint UNSIGNED NOT NULL, `blocked_id` bigint UNSIGNED NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; -- -------------------------------------------------------- ---- Table structure for table `cats`-- CREATE TABLE `cats` ( `id` bigint UNSIGNED NOT NULL, `name_ar` varchar(191) NOT NULL, `name_en` varchar(191) NOT NULL, `photo` text, `icon` text, `parent_id` bigint UNSIGNED DEFAULT NULL, `sort` int DEFAULT NULL, `show` int DEFAULT NULL, `is_year` tinyint DEFAULT '0' COMMENT '0->not has model year,1 has model year', `type` tinyint DEFAULT '0' COMMENT '0->other,1->car,2->car services', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; ---- Dumping data for table `cats`-- INSERT INTO `cats` VALUES(5, 'مزارع للبيع والإيجار', 'Farms', 'cats/1719223894d3614877f479d8e52f4a792e28f06fa52-home.png', NULL, NULL, 1, 1, 0, 0, '2021-03-04 07:27:17', '2024-08-21 20:34:09');INSERT INTO `cats` VALUES(6, 'مواشي وحيوانات', 'Animal', 'cats/1723284154b18821596af88bc3e2d8c55207394d4cfb35a877-3cc5-43ec-b572-0d18e798d224.jpeg', 'fal fa-sheep', NULL, 3, 1, 0, 0, '2021-03-04 07:28:58', '2024-08-10 10:02:34');INSERT INTO `cats` VALUES(10, 'مزارع للايجار', 'Farms for rent', NULL, NULL, 5, 2, 1, NULL, NULL, '2021-03-08 12:18:04', '2024-08-10 07:53:05');INSERT INTO `cats` VALUES(1173, 'مزارع للبيع', 'Farms for sale', NULL, NULL, 5, 1, 1, NULL, NULL, '2021-04-18 06:44:09', '2024-08-10 07:51:34');INSERT INTO `cats` VALUES(1175, 'أراضي ومنازل للبيع', 'Houses for sale', NULL, NULL, 5, 5, 1, NULL, NULL, '2021-04-18 06:45:26', '2024-08-10 21:23:42');INSERT INTO `cats` VALUES(1180, 'استراحات للايجار', 'Transfer business ownership', NULL, NULL, 5, NULL, 1, NULL, NULL, '2021-04-18 06:56:12', '2024-06-27 18:58:10');INSERT INTO `cats` VALUES(1182, 'محلات للايجار', 'Building for rent', NULL, NULL, 5, NULL, 1, NULL, NULL, '2021-04-18 06:57:12', '2024-07-06 21:46:40');INSERT INTO `cats` VALUES(1184, 'فلل للايجار', 'Villas for rent', NULL, NULL, 5, NULL, 1, NULL, NULL, '2021-04-18 06:59:34', '2024-07-06 21:49:24');INSERT INTO `cats` VALUES(2000, 'غنم وخرفان', 'Sheep', 'cats/animals/sheep.png', NULL, 6, 1, 1, NULL, NULL, NULL, '2024-08-26 08:55:19');INSERT INTO `cats` VALUES(2043, 'ماعز وتيوس', 'goats', 'cats/17259621799dff6077035ef727b1ac214d4e013be3IMG_6034.jpeg', NULL, 6, 2, 1, NULL, NULL, NULL, '2024-09-10 10:56:19');INSERT INTO `cats` VALUES(2051, 'جمل', 'Camel', 'cats/1725962131a1903aa89609424e7dc86cbc838fb080IMG_6027.jpeg', NULL, 6, 5, 1, NULL, NULL, NULL, '2024-09-10 10:55:31');INSERT INTO `cats` VALUES(2057, 'خيول', 'horses', 'cats/172596221732c31cf3f939cdc506145d21d938861bIMG_6033.jpeg', NULL, 6, 5, 1, NULL, NULL, NULL, '2024-09-10 10:56:58');INSERT INTO `cats` VALUES(2072, 'أبقار', 'Cow', 'cats/1725962286638a9c6012e2861879946b343be65925IMG_6035.jpeg', NULL, 6, NULL, 1, NULL, NULL, NULL, '2024-09-10 10:58:06');INSERT INTO `cats` VALUES(2086, 'ارانب', 'Rabbits', 'cats/172596234850ea427bcd49501db29f2d49cd81423bIMG_6029.jpeg', NULL, 6, 7, 1, NULL, NULL, NULL, '2024-09-10 10:59:09');INSERT INTO `cats` VALUES(2089, 'أخرى', 'Unclassified', '', NULL, 6, 8, 1, NULL, NULL, NULL, '2024-08-10 21:21:45');INSERT INTO `cats` VALUES(4347, 'مستلزمات المزارع والعزب والرحلات', 'Farm equipment', 'cats/1723324246742094892a031ded6032cc21fb92bd12312edd74-0349-460a-ba4e-04d269383d99.jpeg', NULL, NULL, 3, 1, 0, 0, '2023-09-03 16:52:14', '2024-09-02 09:43:23');INSERT INTO `cats` VALUES(4421, 'مكائن تحليه ومضخات', 'Agricultural machine', NULL, NULL, 4347, 3, 1, NULL, NULL, '2023-10-12 09:25:12', '2024-08-10 21:17:18');INSERT INTO `cats` VALUES(4774, 'أخرى', 'Unclassified', NULL, NULL, 5, 9, 1, NULL, NULL, '2024-07-05 12:53:55', '2024-08-10 08:00:41');INSERT INTO `cats` VALUES(5003, 'الطيور والدواجن وسمك', 'Birds and chickens،fish', 'cats/172596861461d91f0f6ed4bb7db92ea6d8ad6368dfIMG_6036.jpeg', NULL, NULL, 3, 1, 0, 0, '2024-08-08 20:58:46', '2024-09-10 12:43:34');INSERT INTO `cats` VALUES(5004, 'مزادات', 'Auction', NULL, 'fa fa-auction', NULL, 5, 1, 0, 0, '2024-08-08 21:09:36', '2024-08-08 21:09:36');INSERT INTO `cats` VALUES(5007, 'الباحثين عن عمل', 'Look for jobs', NULL, 'fa fa-jops', NULL, 7, 1, 0, 0, '2024-08-09 08:32:58', '2024-08-09 08:32:58');INSERT INTO `cats` VALUES(5009, 'استثمار', 'Investment', NULL, NULL, 10, 1, 1, NULL, NULL, '2024-08-10 08:03:29', '2024-08-10 08:03:29');INSERT INTO `cats` VALUES(5010, 'ايجار سنوي', 'For rent', NULL, NULL, 10, 2, 1, NULL, NULL, '2024-08-10 08:04:41', '2024-08-10 08:04:41');INSERT INTO `cats` VALUES(5011, 'الايجار الشهري', 'Monthly rent', NULL, NULL, 10, 3, 1, NULL, NULL, '2024-08-10 08:05:59', '2024-08-10 08:05:59');INSERT INTO `cats` VALUES(5012, 'منتجات المزارع', 'Farms products', NULL, 'fa fa-vegetable', NULL, 2, 1, 0, 0, '2024-08-10 08:22:13', '2024-08-10 08:34:09');INSERT INTO `cats` VALUES(5013, 'أعلاف', 'Feeds', NULL, NULL, NULL, 6, 1, 0, 0, '2024-08-10 08:47:39', '2024-08-10 10:03:34');INSERT INTO `cats` VALUES(5014, 'سيارات ومعدات المزارع', 'Farms cars', NULL, NULL, NULL, 10, 1, 0, 0, '2024-08-10 09:12:43', '2024-09-02 09:42:45');INSERT INTO `cats` VALUES(5015, 'أعلاف خضراء', 'Green feeds', NULL, NULL, 5013, 1, 1, NULL, NULL, '2024-08-10 09:17:40', '2024-08-10 09:17:40');INSERT INTO `cats` VALUES(5016, 'أعلاف جافه ومركبات', 'Feeds', NULL, NULL, 5013, 2, 1, NULL, NULL, '2024-08-10 09:18:47', '2024-08-10 09:18:47');INSERT INTO `cats` VALUES(5017, 'خلطات', 'Mixed feed', NULL, NULL, 5013, 3, 1, NULL, NULL, '2024-08-10 09:19:53', '2024-08-10 09:19:53');INSERT INTO `cats` VALUES(5018, 'دجاج', 'Chicken', 'cats/172596251586a8cd711c02c3e266ac61bb973d652fIMG_6037.jpeg', NULL, 5003, 1, 1, NULL, NULL, '2024-08-10 09:28:26', '2024-09-10 11:01:56');INSERT INTO `cats` VALUES(5019, 'بط ووز', 'Ducks', NULL, NULL, 5003, 2, 1, NULL, NULL, '2024-08-10 09:29:21', '2024-08-10 09:29:21');INSERT INTO `cats` VALUES(5020, 'حمام', 'Pigeons', 'cats/172596256472af703c60acf183807bf861ed5fd43aIMG_6030.jpeg', NULL, 5003, 4, 1, NULL, NULL, '2024-08-10 09:30:58', '2024-09-10 11:02:44');INSERT INTO `cats` VALUES(5021, 'أخرى', 'Not classified', NULL, NULL, 5003, 5, 1, NULL, NULL, '2024-08-10 09:32:28', '2024-08-10 09:33:46');INSERT INTO `cats` VALUES(5022, 'بغبغاوات وطيور زينه', 'Parrots and birds', NULL, NULL, 5003, 5, 0, NULL, NULL, '2024-08-10 09:36:23', '2024-08-10 09:36:23');INSERT INTO `cats` VALUES(5024, 'مستلزمات المزارع', 'Farms materials', NULL, NULL, 4347, 2, 1, NULL, NULL, '2024-08-10 09:41:53', '2024-08-10 09:41:53');INSERT INTO `cats` VALUES(5025, 'مولدات وجنريترات', 'Generators', NULL, NULL, 4347, 1, 1, NULL, NULL, '2024-08-10 10:54:33', '2024-08-10 10:54:33');INSERT INTO `cats` VALUES(5026, 'اقفاص وشبوك', 'Cages', NULL, NULL, 4347, 2, 1, NULL, NULL, '2024-08-10 10:56:07', '2024-08-10 10:56:07');INSERT INTO `cats` VALUES(5027, 'اخرى', 'Other', NULL, NULL, 4347, 3, 1, NULL, NULL, '2024-08-10 10:56:46', '2024-08-10 10:56:46');INSERT INTO `cats` VALUES(5028, 'شتلات', 'Planets', NULL, NULL, 5012, 1, 1, NULL, NULL, '2024-08-10 21:03:32', '2024-08-10 21:03:32');INSERT INTO `cats` VALUES(5029, 'خضروات', 'Vegetables', 'cats/172414472541341ad4ceca3e4d5c677d3c119473ecIMG_4777.jpeg', NULL, 5012, 2, 1, NULL, NULL, '2024-08-10 21:05:19', '2024-08-20 09:05:25');INSERT INTO `cats` VALUES(5030, 'فواكه', 'Fruits', NULL, NULL, 5012, 3, 1, NULL, NULL, '2024-08-10 21:06:52', '2024-08-10 21:06:52');INSERT INTO `cats` VALUES(5031, 'لوازم الرحلات', 'Picnic needs', NULL, NULL, 4347, 3, 1, NULL, NULL, '2024-08-10 21:12:45', '2024-08-10 21:12:45');INSERT INTO `cats` VALUES(5032, 'عسل', 'Honey', NULL, NULL, 5012, 4, 1, NULL, NULL, '2024-08-11 08:24:21', '2024-08-11 08:24:21');INSERT INTO `cats` VALUES(5033, 'سمن', 'Ghee', NULL, NULL, 5012, 5, 1, NULL, NULL, '2024-08-11 08:25:38', '2024-08-11 08:25:38');INSERT INTO `cats` VALUES(5034, 'تمر ورطب', 'Dates', NULL, NULL, 5012, 7, 1, NULL, NULL, '2024-08-11 08:27:14', '2024-08-11 08:27:14');INSERT INTO `cats` VALUES(5035, 'أخرى', 'Others', NULL, NULL, 5012, 8, 1, NULL, NULL, '2024-08-11 08:27:56', '2024-08-11 08:27:56');INSERT INTO `cats` VALUES(5036, 'اثاث', 'Furniture', NULL, NULL, 4347, 5, 1, 1, 2, '2024-08-11 09:38:23', '2024-08-11 09:38:23');INSERT INTO `cats` VALUES(5037, 'أسمده', 'Fertilizer', NULL, NULL, 4347, 6, 1, NULL, NULL, '2024-08-11 11:17:19', '2024-08-11 11:17:19');INSERT INTO `cats` VALUES(5038, 'فري سمان', 'Quail', NULL, NULL, 5003, 3, 1, NULL, NULL, '2024-08-11 21:14:33', '2024-08-11 21:14:33');INSERT INTO `cats` VALUES(5039, 'رومي', 'Turkey', NULL, NULL, 5003, 5, 1, NULL, NULL, '2024-08-12 20:05:03', '2024-08-12 20:05:03');INSERT INTO `cats` VALUES(5040, 'ملتقى المزارعين', 'Farmers range', NULL, NULL, NULL, 12, 1, 0, 0, '2024-08-20 09:34:36', '2024-08-21 21:00:15');INSERT INTO `cats` VALUES(5041, 'خزانات الماء', 'Water tanks', NULL, NULL, 4347, 5, 1, NULL, NULL, '2024-08-21 20:32:32', '2024-08-21 20:32:32');INSERT INTO `cats` VALUES(5042, 'العضوية الذهبية', 'Golden membership', NULL, NULL, NULL, 10, 1, 0, 0, '2024-08-21 20:59:09', '2024-08-21 20:59:09');INSERT INTO `cats` VALUES(5043, 'القناص للتجاره', 'Alqanass general trading', 'cats/1724274777c6fff585ee56353fd88400c588c68dbbIMG_4063.jpeg', NULL, 5042, 1, 1, NULL, NULL, '2024-08-21 21:11:06', '2024-08-21 21:12:57');INSERT INTO `cats` VALUES(5044, 'كرفانات', 'Caravan', NULL, NULL, 4347, 5, 1, NULL, NULL, '2024-08-24 08:07:32', '2024-08-24 08:07:32');INSERT INTO `cats` VALUES(5045, 'بيض', 'Egg', NULL, NULL, 5003, 3, 1, NULL, NULL, '2024-08-24 08:08:57', '2024-08-24 08:08:57');INSERT INTO `cats` VALUES(5046, 'الطلب', 'Inquiry', NULL, NULL, 5, 4, 1, NULL, NULL, '2024-08-25 06:15:25', '2024-08-25 06:15:25');INSERT INTO `cats` VALUES(5047, 'الطلب', 'Inquiry', NULL, NULL, 6, 5, 1, NULL, NULL, '2024-08-25 06:16:02', '2024-08-25 06:16:02');INSERT INTO `cats` VALUES(5048, 'الطلب', 'Inquiry', NULL, NULL, 4347, 5, 1, NULL, NULL, '2024-08-25 06:16:30', '2024-08-25 06:16:30');INSERT INTO `cats` VALUES(5049, 'الطلب', 'Inquiry', NULL, NULL, 5003, 5, 1, NULL, NULL, '2024-08-25 06:16:58', '2024-08-25 06:16:58');INSERT INTO `cats` VALUES(5050, 'الطلب', 'Inquiry', NULL, NULL, 5007, 5, 1, NULL, NULL, '2024-08-25 06:17:28', '2024-08-25 06:17:28');INSERT INTO `cats` VALUES(5051, 'الطلب', 'Inquiry', NULL, NULL, 5012, 4, 1, NULL, NULL, '2024-08-25 06:17:56', '2024-08-25 06:17:56');INSERT INTO `cats` VALUES(5052, 'الطلب', 'Inquiry', NULL, NULL, 5014, 5, 1, NULL, NULL, '2024-08-25 06:18:58', '2024-08-25 06:18:58');INSERT INTO `cats` VALUES(5053, 'نخيل وصرم', 'Palm trees', NULL, NULL, 5012, 3, 1, NULL, NULL, '2024-08-25 20:34:34', '2024-08-25 20:34:34');INSERT INTO `cats` VALUES(5054, 'قناص عمان', 'Qanass oman', NULL, NULL, 5042, 5, 1, NULL, NULL, '2024-08-25 21:34:36', '2024-08-25 21:34:36');INSERT INTO `cats` VALUES(5055, 'خدمات التوصيل', 'Delivery', NULL, NULL, NULL, 11, 1, 0, 0, '2024-08-26 07:11:50', '2024-08-26 07:11:50');INSERT INTO `cats` VALUES(5056, 'سمك', 'Fish', 'cats/1725962690c485fec947b3b7b7c45248d2db563befIMG_6031.jpeg', NULL, 5003, 7, 1, NULL, NULL, '2024-08-26 08:51:15', '2024-09-10 11:04:50');INSERT INTO `cats` VALUES(5057, 'سمك للاكل', 'Fish for eat', NULL, NULL, 5056, 2, 1, NULL, NULL, '2024-08-26 08:52:12', '2024-08-26 08:52:12');INSERT INTO `cats` VALUES(5058, 'سمك للتربيه والاستزراع', 'Fish for farming', NULL, NULL, 5056, 1, 1, NULL, NULL, '2024-08-26 08:53:22', '2024-08-26 08:53:22');INSERT INTO `cats` VALUES(5059, 'طاووس', 'Peacock', NULL, NULL, 5003, 6, 1, NULL, NULL, '2024-08-26 08:54:23', '2024-08-26 08:54:23');INSERT INTO `cats` VALUES(5060, 'خدمات الحلال حلاقه وجز وغيرها', 'Animals service', NULL, NULL, 6, 9, 1, NULL, NULL, '2024-08-26 09:18:15', '2024-08-26 09:18:15');INSERT INTO `cats` VALUES(5061, 'توصيل الحلال', 'Animals delivery', NULL, NULL, 5055, 2, 1, NULL, NULL, '2024-08-26 09:19:27', '2024-08-26 09:19:27');INSERT INTO `cats` VALUES(5062, 'توصيل عام', 'General delivery', NULL, NULL, 5055, 1, 1, NULL, NULL, '2024-08-26 09:20:13', '2024-08-26 09:20:13');INSERT INTO `cats` VALUES(5063, 'البذور', 'Seeds', NULL, NULL, 5012, 7, 1, NULL, NULL, '2024-08-26 10:30:54', '2024-08-26 10:30:54');INSERT INTO `cats` VALUES(5064, 'باحث عن عمل', 'Looking for jop', NULL, NULL, 5007, 1, 1, NULL, NULL, '2024-08-26 19:15:20', '2024-08-26 19:15:20');INSERT INTO `cats` VALUES(5065, 'الملتقى الزراعي', 'Farmers meeting room', NULL, NULL, 5040, 1, 1, NULL, NULL, '2024-08-26 19:16:16', '2024-08-26 19:16:16');INSERT INTO `cats` VALUES(5066, 'ملتقى الإنتاج الحيواني', 'Animals', NULL, NULL, 5040, 2, 1, NULL, NULL, '2024-08-26 19:17:23', '2024-08-26 19:17:23');INSERT INTO `cats` VALUES(5067, 'معلومات عامه', 'General information', NULL, NULL, 5040, 3, 1, NULL, NULL, '2024-08-26 19:18:15', '2024-09-10 03:52:56');INSERT INTO `cats` VALUES(5068, 'الطاقه الشمسيه', 'Solar', 'cats/172595992379c8e9da3ea8f88def8a0d8638ae97d2IMG_6023.jpeg', NULL, 4347, 7, 1, NULL, NULL, '2024-08-26 19:19:34', '2024-09-10 10:18:43');INSERT INTO `cats` VALUES(5069, 'المبيدات الحشريه والمقويات', 'Insecticides', NULL, NULL, 4347, 5, 1, NULL, NULL, '2024-08-26 19:39:50', '2024-08-26 19:39:50');INSERT INTO `cats` VALUES(5070, 'البيطره', 'Veterinary', NULL, NULL, NULL, 5, 1, 0, 0, '2024-08-26 19:45:10', '2024-08-26 19:45:10');INSERT INTO `cats` VALUES(5072, 'مقطوره قلص', 'Trolleys', NULL, NULL, 4347, 7, 1, NULL, NULL, '2024-08-31 14:25:34', '2024-08-31 14:25:34');INSERT INTO `cats` VALUES(5073, 'بغبغاوات وطيور زينه', 'Parrots and another', NULL, NULL, 5003, 6, 1, NULL, NULL, '2024-08-31 14:31:49', '2024-08-31 14:31:49');INSERT INTO `cats` VALUES(5074, 'سيارات بدون اوراق', 'Cars without documents', NULL, NULL, 5014, 2, 1, NULL, NULL, '2024-09-01 07:35:16', '2024-09-01 07:35:16');INSERT INTO `cats` VALUES(5075, 'سيارات مسجله', 'Registered cars', NULL, NULL, 5014, 1, 1, NULL, NULL, '2024-09-01 07:36:15', '2024-09-01 07:36:15');INSERT INTO `cats` VALUES(5076, 'دراجات وبقي', 'Bicks', NULL, NULL, 5014, 4, 1, NULL, NULL, '2024-09-01 07:38:49', '2024-09-01 07:38:49');INSERT INTO `cats` VALUES(5077, 'معدات الامارات', 'Madat.uae', NULL, NULL, 5042, 2, 1, NULL, NULL, '2024-09-01 08:30:50', '2024-09-01 08:30:50');INSERT INTO `cats` VALUES(5078, 'الطرادات والمكائن البحريه', 'Boats and mechans', NULL, NULL, NULL, 7, 1, 0, 0, '2024-09-01 10:53:09', '2024-09-01 10:53:09');INSERT INTO `cats` VALUES(5079, 'طرادات', 'Boats', NULL, NULL, 5078, 1, 1, NULL, NULL, '2024-09-01 10:53:58', '2024-09-01 10:53:58');INSERT INTO `cats` VALUES(5080, 'مكائن بحريه', 'Mechans', NULL, NULL, 5078, 2, 1, NULL, NULL, '2024-09-01 10:55:03', '2024-09-01 10:55:03');INSERT INTO `cats` VALUES(5081, 'الطلب', 'Search', NULL, NULL, 5078, 3, 1, NULL, NULL, '2024-09-01 10:56:04', '2024-09-01 10:56:04');INSERT INTO `cats` VALUES(5082, 'قطع غيار الطرادات', 'Boats parts', NULL, NULL, 5078, 3, 1, NULL, NULL, '2024-09-02 07:34:32', '2024-09-02 07:34:32');INSERT INTO `cats` VALUES(5083, 'آخرى', 'Others', NULL, NULL, 5078, 4, 1, NULL, NULL, '2024-09-02 07:35:12', '2024-09-02 07:35:12');INSERT INTO `cats` VALUES(5084, 'احوال الطقس', 'Weather', NULL, NULL, 5040, 2, 1, NULL, NULL, '2024-09-02 07:36:58', '2024-09-02 07:36:58');INSERT INTO `cats` VALUES(5085, 'فقاسات ولوازم الدواجن', 'Poultry farms equipment', NULL, NULL, 4347, 5, 1, NULL, NULL, '2024-09-02 09:37:00', '2024-09-02 09:37:00');INSERT INTO `cats` VALUES(5086, 'معدات وحراثات', 'Tractors', NULL, NULL, 5014, 3, 1, NULL, NULL, '2024-09-02 09:45:24', '2024-09-02 09:45:24');INSERT INTO `cats` VALUES(5087, 'خدمات السيارات', 'Car services', NULL, NULL, 5014, 4, 1, NULL, NULL, '2024-09-02 11:08:35', '2024-09-02 11:08:35');INSERT INTO `cats` VALUES(5088, 'مواد البناء', 'Building materials', NULL, NULL, 4347, 5, 1, NULL, NULL, '2024-09-05 17:08:12', '2024-09-05 17:08:12');INSERT INTO `cats` VALUES(5089, 'زمن الطيبين', 'Old times', NULL, NULL, 5040, 5, 1, NULL, NULL, '2024-09-05 19:55:01', '2024-09-05 19:55:01');INSERT INTO `cats` VALUES(5090, 'مقاولات', 'Construction', NULL, NULL, 4347, 10, 1, NULL, NULL, '2024-09-07 09:30:21', '2024-09-07 09:30:21');INSERT INTO `cats` VALUES(5091, 'غزلان', 'Gazelle', NULL, NULL, 6, 7, 1, NULL, NULL, '2024-09-07 09:34:14', '2024-09-07 09:34:14');INSERT INTO `cats` VALUES(5092, 'عزب للبيع', 'Izba for sale', NULL, NULL, 5, 5, 1, NULL, NULL, '2024-09-10 04:01:18', '2024-09-10 04:01:18');INSERT INTO `cats` VALUES(5093, 'خيبر', 'Guineafowl', 'cats/17259630915cd5e2389ce20ec3a3f754db8466025fIMG_6038.jpeg', NULL, 5003, 7, 1, NULL, NULL, '2024-09-10 11:10:44', '2024-09-10 11:11:32');INSERT INTO `cats` VALUES(5094, 'مستشارك في جورجيا', 'Your advisor in Georgia', NULL, NULL, 5042, 3, 1, NULL, NULL, '2024-09-19 17:24:47', '2024-09-19 17:24:47');INSERT INTO `cats` VALUES(5095, 'تبادل', 'Exchanges', NULL, NULL, NULL, 10, 1, 0, 0, '2024-09-24 06:35:47', '2024-09-24 06:35:47'); -- -------------------------------------------------------- ---- Table structure for table `comments`-- CREATE TABLE `comments` ( `id` bigint UNSIGNED NOT NULL, `user_id` bigint UNSIGNED NOT NULL, `post_id` bigint UNSIGNED NOT NULL, `comment` text NOT NULL, `parent_id` bigint UNSIGNED DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; ---- Dumping data for table `comments`-- INSERT INTO `comments` VALUES(207, 327, 143, 'السلام عليكم \r\nما هو نوع العلف المخصص الدجاج والبط والسمان واسعارة', NULL, '2024-08-27 08:57:05', '2024-08-27 08:57:05');INSERT INTO `comments` VALUES(208, 292, 278, 'test', NULL, '2024-08-29 03:24:42', '2024-08-29 03:24:42');INSERT INTO `comments` VALUES(209, 292, 278, 'test', NULL, '2024-08-29 03:24:50', '2024-08-29 03:24:50');INSERT INTO `comments` VALUES(210, 327, 302, 'السلام عليكم \r\nمتى موعد زراعه اليح', NULL, '2024-08-29 10:04:22', '2024-08-29 10:04:22');INSERT INTO `comments` VALUES(211, 345, 313, 'عمال مزرعة من الجنسية الإثيوبية يعرفون حق المزارع والحلال والبيوت والمكاتب \r\nجاهزين للعمل \r\n\r\nللتواصل\r\n0562774340', NULL, '2024-08-29 18:56:55', '2024-08-29 18:56:55');INSERT INTO `comments` VALUES(212, 327, 353, 'السلام عليكم \r\nإذا درهم أنا بشتريهم', NULL, '2024-08-30 21:23:42', '2024-08-30 21:23:42');INSERT INTO `comments` VALUES(213, 310, 374, 'بذور روسيه\r\nجوده \r\nومن ضمن افضل الشركات الروسيه في انتاج وتعبئه البذور\r\n\r\nF1\r\nبسعر محروق وب 5 دراهم \r\nلمشاهدة الصور مع الاسعار\r\n\r\nhttps://www.instagram.com/vip_seeds?igsh=MzRlODBiNWFlZA==', NULL, '2024-08-31 10:28:02', '2024-08-31 10:28:02');INSERT INTO `comments` VALUES(214, 359, 447, 'التوصيل مجاني الي مناطق العين ؟', NULL, '2024-09-03 13:04:40', '2024-09-03 13:04:40');INSERT INTO `comments` VALUES(215, 369, 192, 'السلام عليكم كم تأمين مرسيدس ٢٠٠٨ ثمانية سلندر ضد الغير', NULL, '2024-09-05 16:17:12', '2024-09-05 16:17:12');INSERT INTO `comments` VALUES(216, 377, 497, 'كم سلندر وكم من الاخر', NULL, '2024-09-05 19:09:19', '2024-09-05 19:09:19');INSERT INTO `comments` VALUES(217, 378, 246, 'سلام عليكم كم نهايتك لي الاثنين.', NULL, '2024-09-05 20:06:06', '2024-09-05 20:06:06');INSERT INTO `comments` VALUES(218, 345, 524, 'عامل مزرعة من اثيوبي يعرف حق المزرعة والحلال الهوش والبوش والدجاج ناطور والبيوت \r\nجاهز للعمل \r\n\r\nللتواصل 0566710471', NULL, '2024-09-06 10:26:40', '2024-09-06 10:26:40');INSERT INTO `comments` VALUES(219, 385, 409, 'كيف', NULL, '2024-09-06 18:53:00', '2024-09-06 18:53:00');INSERT INTO `comments` VALUES(220, 331, 466, 'مراحب الشيخ....اذا باخذ الكل ...على كم السعر...0504155133', NULL, '2024-09-07 09:23:02', '2024-09-07 09:23:02');INSERT INTO `comments` VALUES(221, 396, 528, 'هلا', NULL, '2024-09-08 21:29:56', '2024-09-08 21:29:56');INSERT INTO `comments` VALUES(222, 396, 528, 'مزارع الامارات \r\n\r\nمزارع الامارات \r\n\r\nمزراع الامارات', 221, '2024-09-08 21:33:30', '2024-09-08 21:33:30');INSERT INTO `comments` VALUES(223, 406, 641, 'الموقع لو سمحت', NULL, '2024-09-11 10:34:56', '2024-09-11 10:34:56');INSERT INTO `comments` VALUES(224, 418, 365, 'ليش جملة منو بيشتري ياخي خلهن بالحبات وخل الحلال يروح', NULL, '2024-09-15 20:40:01', '2024-09-15 20:40:01');INSERT INTO `comments` VALUES(225, 426, 798, 'ماشاء الله شي جميل', NULL, '2024-09-17 20:15:41', '2024-09-17 20:15:41');INSERT INTO `comments` VALUES(226, 438, 839, 'في خضم على السعر الحالي', NULL, '2024-09-20 08:36:52', '2024-09-20 08:36:52');INSERT INTO `comments` VALUES(227, 435, 830, 'مزرعه المدام تتميز بالجوده العاليه في الحلال', NULL, '2024-09-20 09:37:30', '2024-09-20 09:37:30');INSERT INTO `comments` VALUES(228, 396, 862, 'هلا', NULL, '2024-09-20 18:11:19', '2024-09-20 18:11:19');INSERT INTO `comments` VALUES(229, 406, 532, 'هل', NULL, '2024-09-20 18:14:07', '2024-09-20 18:14:07');INSERT INTO `comments` VALUES(230, 452, 905, 'التواصل واتساب رجاء', NULL, '2024-09-22 07:08:25', '2024-09-22 07:08:25');INSERT INTO `comments` VALUES(231, 452, 904, 'التواصل واتساب رجاء', NULL, '2024-09-22 07:08:44', '2024-09-22 07:08:44');INSERT INTO `comments` VALUES(232, 452, 903, 'التواصل واتساب رجاء', NULL, '2024-09-22 07:09:10', '2024-09-22 07:09:10');INSERT INTO `comments` VALUES(233, 453, 388, 'شي دياي حبحب', NULL, '2024-09-22 10:08:33', '2024-09-22 10:08:33');INSERT INTO `comments` VALUES(234, 345, 925, 'عاملات اثيوبيات قوله من طرف زهره يبا يترزق عامله اول مره قيمه العموله للفيزا باسم الكفيل 1900رتب العامله 800درهم عندها خبرة قيمة العموله الطلب الفيز باسم الكفيل 2800راتب العاملة 1200درهم موقت 800عموله بدون فيزا راتب عمله اول مره 800خبره 1500درهم واي ترجيع الريال يضمن لج ما عيبتج ضمان يرجعها محترم في التعامل واييبها لين عند باب البيت تواصل على رقم 0566710471', NULL, '2024-09-24 06:49:23', '2024-09-24 06:49:23');INSERT INTO `comments` VALUES(235, 468, 941, 'كم قيمة الصيصان من كل سلالة ( الاوركان - الاوليف - المران )', NULL, '2024-09-28 21:48:00', '2024-09-28 21:48:00');INSERT INTO `comments` VALUES(236, 327, 979, 'السلام عليكم ورحمة الله وبركاته \r\nكم آخر سعرك', NULL, '2024-09-30 18:18:58', '2024-09-30 18:18:58');INSERT INTO `comments` VALUES(237, 480, 1044, 'كم السعر', NULL, '2024-10-04 03:08:57', '2024-10-04 03:08:57');INSERT INTO `comments` VALUES(238, 480, 1019, 'هذي ذرة أمريكي؟', NULL, '2024-10-04 03:13:28', '2024-10-04 03:13:28');INSERT INTO `comments` VALUES(239, 480, 1019, 'كم حبة تقريبا في الباكيت؟', NULL, '2024-10-04 03:13:49', '2024-10-04 03:13:49');INSERT INTO `comments` VALUES(240, 462, 896, 'السلام عليك متوفر', NULL, '2024-10-04 06:09:08', '2024-10-04 06:09:08');INSERT INTO `comments` VALUES(241, 462, 985, 'السلام عليكم', NULL, '2024-10-04 06:11:07', '2024-10-04 06:11:07');INSERT INTO `comments` VALUES(242, 462, 985, 'متوفر', NULL, '2024-10-04 06:11:14', '2024-10-04 06:11:14');INSERT INTO `comments` VALUES(243, 360, 1048, 'بكم الملكات', NULL, '2024-10-05 04:33:13', '2024-10-05 04:33:13');INSERT INTO `comments` VALUES(244, 414, 1085, 'الفقاسة تاخذ 1584 بيضه', NULL, '2024-10-07 19:34:40', '2024-10-07 19:34:40');INSERT INTO `comments` VALUES(245, 429, 610, 'تم البيع يرجى الحذف', NULL, '2024-10-08 11:02:55', '2024-10-08 11:02:55');INSERT INTO `comments` VALUES(246, 495, 1061, 'السلام عليكم كم جونيه او كم الكميه التقريبيه', NULL, '2024-10-11 15:03:35', '2024-10-11 15:03:35'); -- -------------------------------------------------------- ---- Table structure for table `commession_transfers`-- CREATE TABLE `commession_transfers` ( `id` bigint UNSIGNED NOT NULL, `username` varchar(191) NOT NULL, `user_id` bigint UNSIGNED DEFAULT NULL, `phone` varchar(191) NOT NULL, `price` int NOT NULL, `bank_id` bigint UNSIGNED DEFAULT NULL, `userBankName` varchar(191) NOT NULL, `timeOfTransfer` bigint UNSIGNED DEFAULT NULL, `post_number` bigint UNSIGNED DEFAULT NULL, `package_id` bigint UNSIGNED DEFAULT NULL, `notes` text, `receiptPhoto` text, `type` tinyint NOT NULL COMMENT '0->commission,1->membership', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; -- -------------------------------------------------------- ---- Table structure for table `commission_members`-- CREATE TABLE `commission_members` ( `id` bigint UNSIGNED NOT NULL, `cat_id` bigint UNSIGNED DEFAULT NULL, `name_ar` varchar(191) NOT NULL, `name_en` varchar(191) NOT NULL, `desc_ar` text NOT NULL, `desc_en` text NOT NULL, `price` int DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; -- -------------------------------------------------------- ---- Table structure for table `contacts`-- CREATE TABLE `contacts` ( `id` bigint UNSIGNED NOT NULL, `email` varchar(191) NOT NULL, `desc` text NOT NULL, `photo` text, `why_id` bigint UNSIGNED NOT NULL, `status` tinyint DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; ---- Dumping data for table `contacts`-- INSERT INTO `contacts` VALUES(161, 'bellaZet@gmail.com', 'https://bit.ly/3Tgo9nI Huge selection!', NULL, 4, 0, '2024-03-16 12:23:10', '2024-03-16 12:23:10');INSERT INTO `contacts` VALUES(166, 'speedyindex@gmail.com', 'https://bit.ly/3OV6orJ service for fast indexing of links in Google. First result in 48 hours. 100 links for FREE.', NULL, 4, 0, '2024-03-21 04:41:22', '2024-03-21 04:41:22');INSERT INTO `contacts` VALUES(178, 'noreplyhere@aol.com', 'Hey there, ready to take your ad game to the next level? Imagine your message popping up in website contact forms all over the world, reaching heaps of potential customers! Starting at just under $100, our affordable packages pack a punch. Shoot me an email now to chat more about getting your brand out there! Let\'s make some noise together!\r\n\r\nP. Stewart\r\nEmail: petu7s@mail-to-form.xyz\r\nSkype: form-blasting', NULL, 4, 0, '2024-03-26 13:30:30', '2024-03-26 13:30:30');INSERT INTO `contacts` VALUES(181, 'BiseTaige2@gmail.com', 'ماذا عن أننا نحاول أن شريط النبيذ الجديد الجميع تم الهذيان حول لأمسية مريحة معا? - https://u.to/CXOGIA?niz', NULL, 4, 0, '2024-03-26 17:23:52', '2024-03-26 17:23:52');INSERT INTO `contacts` VALUES(190, 'peterHisp@gmail.com', 'Hello \r\n \r\nI have just checked soqgrs.com for its SEO metrics and saw that your website could use an upgrade. \r\n \r\nWe will improve your ranks organically and safely, using only state of the art AI and whitehat methods, while providing monthly reports and outstanding support. \r\n \r\nMore info: \r\nhttps://www.digital-x-press.com/unbeatable-seo/ \r\n \r\n \r\nRegards \r\nMike Chapman\r\n \r\nDigital X SEO Experts', NULL, 4, 0, '2024-04-10 01:57:42', '2024-04-10 01:57:42');INSERT INTO `contacts` VALUES(192, 'BiseTaigea@gmail.com', 'مرحبا, اهتم بالانضمام إلي في غطس نحيف في منتصف الليل? - https://u.to/CXOGIA?niz', NULL, 4, 0, '2024-04-11 10:58:43', '2024-04-11 10:58:43');INSERT INTO `contacts` VALUES(208, 'samy@gmail.com', 'xxxggggff', NULL, 2, 0, '2024-06-27 08:45:27', '2024-06-27 08:45:27');INSERT INTO `contacts` VALUES(213, 'thenickjsmith@gmail.com', 'I\'m running 5 x national/global advertising campaigns for qualifying websites in July ... for free!\r\n\r\nWould you like one of the spots?\r\n\r\nHit reply with a \"Tell Me More!\" and I\'ll send the details.\r\n\r\nYour Website: quicksellandbuy.com\r\n\r\nBest wishes\r\n\r\nNick Smith\r\n\r\nP.S. It really won\'t cost you anything! \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\nKemp House, 152-160 City Road, London. EC1V 2NX\r\n\r\nTo Avoid Future Marketing Messages Click Here\r\nhttps://email-sending.net/?domain=quicksellandbuy.com', NULL, 4, 0, '2024-07-01 23:58:08', '2024-07-01 23:58:08');INSERT INTO `contacts` VALUES(215, 'finn.rita57@gmail.com', 'We will create a custom website design tailored to your specific business needs,\r\nwhich are of the highest quality at affordable prices.\r\n\r\nFREE BASIC MOCK-UP DESIGN BEFORE WORK \r\n\r\nJust message us websdesignservices2000@gmail.com\r\n\r\nCheck our sample work https://drive.google.com/drive/folders/1...\nServices Offered by us :-\r\n\r\n1. Website Design\r\n2. Graphics Design\r\n3. Seo Services\r\n4. eCommerce Development\r\n5. Mobile App development\r\n6. Explainer Video\r\n7. Article Writing\r\n8. Website Fixing\r\n9. Website Traffic\r\n\r\nAre you looking for a new website, or you want to revamp your old one to a modern,\r\nfresh look with a responsive mobile layout? We are here to help you out.\r\n\r\nContact us at websdesignservices2000@gmail.com\r\nThanks', NULL, 4, 0, '2024-07-05 00:32:02', '2024-07-05 00:32:02');INSERT INTO `contacts` VALUES(216, 'mystichelptoday@gmail.com', '<b>House, Family, Good Job</b> - \r\n<a href=https://bit.ly/4ckS5WB><b><u>Find Your Success Way Right Now!</u></b></a>', NULL, 4, 0, '2024-07-07 04:13:51', '2024-07-07 04:13:51');INSERT INTO `contacts` VALUES(222, 'joannariggs278@gmail.com', 'Hi,\r\n\r\nI just visited quicksellandbuy.com and wondered if you\'d ever thought about having an engaging video to explain what you do?\r\n\r\nOur prices start from just $195.\r\n\r\nLet me know if you\'re interested in seeing samples of our previous work.\r\n\r\nRegards,\r\nJoanna\r\n\r\nUnsubscribe: https://removeme.click/ev/unsubscribe.ph...andbuy.com', NULL, 4, 0, '2024-07-14 02:38:44', '2024-07-14 02:38:44');INSERT INTO `contacts` VALUES(230, 'saifalg4540@gmail.com', 'ليش انحذف إعلاني', NULL, 4, 0, '2024-08-09 12:31:40', '2024-08-09 12:31:40');INSERT INTO `contacts` VALUES(231, 'submissions@searchindex.site', 'Hello,\r\n\r\nfor your website do be displayed in searches your domain needs to be indexed in the Google Search Index.\r\n\r\nTo add your domain to Google Search Index now, please visit \r\n\r\nhttps://searchregistry.net/', NULL, 2, 0, '2024-08-28 16:21:17', '2024-08-28 16:21:17');INSERT INTO `contacts` VALUES(232, 'submissions@searchindex.site', 'Hello,\r\n\r\nfor your website do be displayed in searches your domain needs to be indexed in the Google Search Index.\r\n\r\nTo add your domain to Google Search Index now, please visit \r\n\r\nhttps://searchregistry.net/', NULL, 4, 0, '2024-08-29 15:39:18', '2024-08-29 15:39:18');INSERT INTO `contacts` VALUES(233, 'submissions@searchindex.site', 'Hello,\r\n\r\nfor your website do be displayed in searches your domain needs to be indexed in the Google Search Index.\r\n\r\nTo add your domain to Google Search Index now, please visit \r\n\r\nhttps://searchregister.info/', NULL, 2, 0, '2024-08-31 11:54:50', '2024-08-31 11:54:50');INSERT INTO `contacts` VALUES(234, 'tommywebdevelopment@gmail.com', 'Hi,\r\n\r\nI am trying to get in touch regarding your website. Do you want to build a professional website or re-do your existing one cost-effectively?\r\n\r\nWe build attractive websites that convert visitors into customers.\r\n\r\nPlease let me know if you are interested, I will send through some price indicative and my work.\r\n\r\nYours Sincerely\r\n\r\nTommy Sam\r\ntommywebdevelopment@gmail.com', NULL, 2, 0, '2024-08-31 19:18:11', '2024-08-31 19:18:11');INSERT INTO `contacts` VALUES(237, 'kayleighbpsteamship@gmail.com', 'Salut, ech wollt Äre Präis wëssen.', NULL, 2, 0, '2024-09-09 18:04:24', '2024-09-09 18:04:24'); -- -------------------------------------------------------- ---- Table structure for table `conversations`-- CREATE TABLE `conversations` ( `id` bigint UNSIGNED NOT NULL, `user_id` bigint UNSIGNED NOT NULL, `follow_user_id` bigint UNSIGNED NOT NULL,