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

START TRANSACTION;



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

--
-- Table structure for table `clients`
--

CREATE TABLE `clients` (
  `id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `client_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `client_phone` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `whatsapp_no` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order_details` text COLLATE utf8mb4_unicode_ci,
  `img` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `is_activate` tinyint NOT NULL DEFAULT '1',
  `city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `budget` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `clients`
--

INSERT INTO `clients` (`id`, `created_at`, `updated_at`, `client_name`, `client_phone`, `whatsapp_no`, `order_name`, `status`, `order_details`, `img`, `deleted_at`, `is_activate`, `city`, `budget`, `notes`) VALUES
(2, '2025-09-27 20:04:38', '2025-09-27 20:04:38', 'kkkk', '12312132132', '121321132123', 'mmmm', 'ttttttttttttttttttttttt', 'rrrrrrrrrrrrrrrrrrrrrrrrr', 'admin/assets/images/clients/175901067857148.png', NULL, 1, NULL, NULL, NULL),
(3, '2025-09-27 20:25:13', '2025-09-27 20:25:13', 'اسم العميل', '7800000', '14000000', 'اسم الطلب', 'حالة الطلب', 'تفاصيل الطلب تفاصيل الطلب تفاصيل الطلب', 'admin/assets/images/clients/175901191342144.png', NULL, 1, NULL, NULL, NULL),
(4, NULL, NULL, 'اسم العميل', '7800000', '14000000', 'اسم الطلب', 'حالة الطلب', 'تفاصيل الطلب تفاصيل الطلب تفاصيل الطلب', NULL, NULL, 1, NULL, NULL, NULL),
(5, NULL, NULL, 'kkkk', '12312132132', '121321132123', 'mmmm', 'ttttttttttttttttttttttt', 'rrrrrrrrrrrrrrrrrrrrrrrrr', NULL, NULL, 1, NULL, NULL, NULL),
(6, NULL, NULL, 'اسم العميل', '7800000', '14000000', 'اسم الطلب', 'حالة الطلب', 'تفاصيل الطلب تفاصيل الطلب تفاصيل الطلب', NULL, NULL, 1, NULL, NULL, NULL),
(7, NULL, NULL, 'kkkk', '12312132132', '121321132123', 'mmmm', 'ttttttttttttttttttttttt', 'rrrrrrrrrrrrrrrrrrrrrrrrr', NULL, NULL, 1, NULL, NULL, NULL);

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

--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `message` text COLLATE utf8mb4_unicode_ci,
  `deleted_at` datetime DEFAULT NULL,
  `is_activate` tinyint NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contacts`
--

INSERT INTO `contacts` (`id`, `created_at`, `updated_at`, `name`, `email`, `mobile`, `message`, `deleted_at`, `is_activate`) VALUES
(1, '2025-09-28 08:06:16', '2025-09-28 08:06:16', 'Duncan Trujillo', 'rymofox@mailinator.com', '98123132132', 'Sed dolor ullamco qu', NULL, 1),
(2, '2025-09-28 15:33:14', '2025-09-28 15:33:14', 'Orson Price', 'gytale@mailinator.com', '5456465492', 'Vero laboris ad enim', NULL, 1),
(3, '2025-12-14 11:05:00', '2025-12-14 11:05:00', 'Quinlan Justice', 'bivaqonuv@mailinator.com', '0555555539', 'Distinctio Nostrud', NULL, 1),
(4, '2025-12-14 11:06:22', '2025-12-14 11:06:22', 'Quinlan Justice', 'bivaqonuv@mailinator.com', '0555555539', 'Distinctio Nostrud', NULL, 1),
(5, '2025-12-14 11:06:38', '2025-12-14 11:06:38', 'Quinlan Justice', 'bivaqonuv@mailinator.com', '0555555539', 'Distinctio Nostrud', NULL, 1),
(6, '2025-12-14 11:07:32', '2025-12-14 11:07:32', 'amr hussien', 'amr@gmail.com', '01201867608', 'Rerum eveniet exerc', NULL, 1),
(7, '2025-12-14 11:10:37', '2025-12-14 11:10:37', 'amr hussien', 'amr@gmail.com', '01201867608', 'Rerum eveniet exerc', NULL, 1),
(8, '2025-12-14 11:12:08', '2025-12-14 11:12:08', 'amr hussien', 'amr@gmail.com', '01201867608', 'Rerum eveniet exerc', NULL, 1),
(9, '2025-12-14 11:15:56', '2025-12-14 11:15:56', 'amr hussien', 'amr@gmail.com', '01201867608', 'Rerum eveniet exerc', NULL, 1),
(10, '2025-12-14 11:16:56', '2025-12-14 11:16:56', 'amr hussien', 'amr@gmail.com', '01201867608', 'Rerum eveniet exerc', NULL, 1),
(11, '2025-12-16 08:43:58', '2025-12-16 08:43:58', 'amr hussien', 'amr@gmail.com', '01201867608', 'Rerum eveniet exerc', NULL, 1),
(12, '2025-12-16 08:45:57', '2025-12-16 08:45:57', 'Astra Kline', 'ticaloru@mailinator.com', '520000000000000', 'Dolores ipsum corpo', NULL, 1),
(13, '2025-12-16 08:46:15', '2025-12-16 08:46:15', 'Astra Kline', 'ticaloru@mailinator.com', '112233445566', 'Dolores ipsum corpo', NULL, 1),
(14, '2025-12-16 08:46:42', '2025-12-16 08:46:42', 'Astra Kline', 'ticaloru@mailinator.com', '112233445566', 'Dolores ipsum corpo', NULL, 1),
(15, '2025-12-16 08:47:02', '2025-12-16 08:47:02', 'Nora Hughes', 'pydoxokimo@mailinator.com', '33665522', 'Aut harum hic cupidi', NULL, 1);

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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint UNSIGNED NOT NULL,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_reset_tokens_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2023_10_19_000000_create_admins_table', 1),
(6, '2023_10_19_000000_create_page_deatils_table', 2),
(7, '2023_10_19_000000_create_pages_table', 2),
(8, '2023_10_19_000000_create_Partners_table', 3),
(9, '2023_10_19_000000_create_ratings_table', 4),
(10, '2023_10_19_000000_create_values_table', 5),
(11, '2023_10_19_000000_create_offer_imgs_table', 6),
(12, '2023_10_19_000000_create_offers_table', 6),
(13, '2023_10_19_000000_create_offer_details_table', 7),
(14, '2023_10_19_000000_create_requests_table', 8),
(15, '2023_10_19_000000_create_clients_table', 9),
(16, '2023_10_19_000000_create_contacts_table', 10),
(17, '2025_10_19_000000_create_clients_table', 11);

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

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

CREATE TABLE `offers` (
  `id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rooms_count` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bathrooms_count` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `area` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `facade` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `offer_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `offer_number` int DEFAULT NULL,
  `price` decimal(15,2) DEFAULT NULL,
  `city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `parking_count` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('متاح','مباع','مؤجر') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'متاح',
  `img` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nears_from` varchar(1255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `features` varchar(1255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `guarantees` json DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `is_activate` tinyint NOT NULL DEFAULT '1',
  `pro_info_offer_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pro_info_status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pro_info_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pro_info_city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pro_info_rooms_count` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pro_info_area` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pro_info_region` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pro_info_floor` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pro_info_details` varchar(1255) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `offers`
--

INSERT INTO `offers` (`id`, `created_at`, `updated_at`, `title`, `type`, `rooms_count`, `bathrooms_count`, `area`, `facade`, `offer_type`, `offer_number`, `price`, `city`, `parking_count`, `status`, `img`, `nears_from`, `features`, `guarantees`, `deleted_at`, `is_activate`, `pro_info_offer_number`, `pro_info_status`, `pro_info_type`, `pro_info_city`, `pro_info_rooms_count`, `pro_info_area`, `pro_info_region`, `pro_info_floor`, `pro_info_details`) VALUES
(1, '2025-09-21 19:57:40', '2025-09-21 20:18:13', 'Incididunt modi irur', NULL, '5', '1', '150 m', 'aaaaaaaaa aaaaaaaaaa aaaaaaaaaaaaa', '2', NULL, 5510.00, 'Hic fuga Molestias', '1', 'متاح', 'admin/assets/images/offers/175849307713439.png', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2, '2025-09-21 19:58:58', '2025-09-21 19:58:58', 'Eligendi minima dolo', NULL, '4', '4', '70 m', NULL, '2', NULL, 5856.00, 'Sapiente dicta repre', '4', 'متاح', 'admin/assets/images/offers/175849236029321.png', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(3, '2025-09-21 20:06:00', '2025-09-21 20:06:00', 'Non cumque incididun', NULL, '4', '2', '90 m', 'Ut sed vitae recusan', '2', NULL, 5778.00, 'Officiis enim illo n', '2', 'متاح', 'admin/assets/images/offers/175849236029321.png', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4, '2025-09-21 20:13:32', '2025-09-25 05:04:40', 'Omnis quia veniam q', NULL, '2', '2', '120 m', 'Nobis vel doloribus', '1', NULL, 5167.00, 'Non et earum impedit', '3', 'متاح', 'admin/assets/images/offers/175849281221927.png', 'Alias necessitatibus,Odit aut cillum volu,Accusamus id sunt mi,Delectus dolor arch,Dolor omnis perspici,6666666666', 'Est Nam consequuntur,Perspiciatis molest,Ea sint pariatur A,Debitis eum illo nis,Laborum ullamco vel,Aliqua Qui id excep,Libero et dolore ali,222222222,77777777777777777,8888888888888888', '{\"2\": {\"years\": \"1992\", \"content\": \"Fuga Ipsa esse off\"}, \"3\": {\"years\": \"2008\", \"content\": \"Recusandae Molestia\"}, \"4\": {\"years\": \"1971\", \"content\": \"Ut sint illum irur\"}, \"1000001\": {\"years\": \"1980\", \"content\": \"Voluptates consectet\"}, \"1000002\": {\"years\": \"2000\", \"content\": \"Adipisci optio temp\"}}', NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(5, '2025-09-21 19:57:40', '2025-09-21 20:18:13', 'Incididunt modi irur', NULL, '5', '1', '150 m', 'aaaaaaaaa aaaaaaaaaa aaaaaaaaaaaaa', '2', NULL, 2510.00, 'Hic fuga Molestias', '1', 'متاح', 'admin/assets/images/offers/175849307713439.png', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(6, '2025-09-21 20:06:00', '2025-09-21 20:06:00', 'Non cumque incididun', NULL, '4', '2', '90 m', 'Ut sed vitae recusan', '2', NULL, 2778.00, 'Officiis enim illo n', '2', 'متاح', 'admin/assets/images/offers/175849236029321.png', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(7, '2025-09-21 20:13:32', '2025-09-24 03:15:24', 'Omnis quia veniam q', NULL, '2', '2', '120 m', 'Nobis vel doloribus', '1', NULL, 2167.00, 'Non et earum impedit', '3', 'متاح', 'admin/assets/images/offers/175849281221927.png', 'Alias necessitatibus,Odit aut cillum volu,Accusamus id sunt mi,Delectus dolor arch,Dolor omnis perspici,6666666666', 'Est Nam consequuntur,Perspiciatis molest,Ea sint pariatur A,Debitis eum illo nis,Laborum ullamco vel,Aliqua Qui id excep,Libero et dolore ali,222222222,33333333333', '{\"2\": {\"years\": \"1992\", \"content\": \"Fuga Ipsa esse off\"}, \"3\": {\"years\": \"2008\", \"content\": \"Recusandae Molestia\"}, \"4\": {\"years\": \"1971\", \"content\": \"Ut sint illum irur\"}, \"1000001\": {\"years\": \"1980\", \"content\": \"Voluptates consectet\"}, \"1000002\": {\"years\": \"2000\", \"content\": \"Adipisci optio temp\"}}', NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(8, '2025-09-21 19:58:58', '2025-12-14 07:39:14', 'Eligendi minima dolo', NULL, '4', '4', '70 m', NULL, '2', NULL, 2856.00, 'Sapiente dicta repre', '4', 'متاح', 'admin/assets/images/offers/175849236029321.png', 'Officia minim blandi,Id fugiat aut incid', 'Aute mollitia labori,Ratione voluptatum l', '{\"1000001\": {\"years\": \"2000\", \"content\": \"Et sed est voluptate\"}, \"1000002\": {\"years\": \"1985\", \"content\": \"In voluptas officia\"}}', NULL, 1, '63', 'متاح', '1', 'Accusamus placeat s', 'Distinctio Animi v', 'Autem vitae quod qui', 'Inventore consectetu', NULL, 'Aut iste molestiae i');

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

--
-- Table structure for table `offer_details`
--

CREATE TABLE `offer_details` (
  `id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `offer_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `offer_status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `offer_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rooms_count` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `area` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `front` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `floor` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `offer_id` int DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `is_activate` tinyint NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `offer_details`
--

INSERT INTO `offer_details` (`id`, `created_at`, `updated_at`, `offer_number`, `offer_status`, `offer_type`, `city`, `rooms_count`, `area`, `front`, `price`, `floor`, `offer_id`, `deleted_at`, `is_activate`) VALUES
(1, '2025-09-22 09:11:44', '2025-09-22 09:11:44', '273000', 'متاح', NULL, NULL, '4', '150 m', '1231', '9600', '3', 4, NULL, 1),
(3, '2025-09-22 09:45:44', '2025-09-22 10:28:40', '6815500', 'محجوز', NULL, NULL, 'Qui libero est adipi55', 'Commodo elit omnis55', 'Nihil qui vel quod e55', '4755', 'Ullamco aut dolore a55', 4, NULL, 1),
(4, '2025-09-22 09:45:55', '2025-09-22 10:31:59', '996', 'متاح', NULL, NULL, 'Odio aliqua Eaque a', 'Quam dolorem volupta', 'Sit eligendi sequi', '751', 'Ut quia tempore Nam', 4, NULL, 1),
(5, '2025-09-22 09:51:41', '2025-09-22 09:51:41', '636', 'مباع', NULL, NULL, 'Quae mollit cumque c', 'Alias explicabo Eaq', 'A ad sit placeat an', '430', 'In obcaecati laboris', 4, NULL, 1),
(8, '2025-12-14 07:32:05', '2025-12-14 07:32:05', '247', 'مباع', NULL, NULL, 'Quo ut sint et conse', 'Fugit in iste culpa', 'Unde voluptatem ea q', '957', 'Nisi molestias quas', 8, NULL, 1);

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

--
-- Table structure for table `offer_imgs`
--

CREATE TABLE `offer_imgs` (
  `id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `img` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `offer_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `is_activate` tinyint NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `offer_imgs`
--

INSERT INTO `offer_imgs` (`id`, `created_at`, `updated_at`, `img`, `offer_id`, `deleted_at`, `is_activate`) VALUES
(10, NULL, NULL, 'admin/assets/images/offers/175854588530985.mp4', '4', NULL, 1),
(13, NULL, NULL, 'admin/assets/images/offers/175854604899120.png', '4', NULL, 1),
(15, NULL, NULL, 'admin/assets/images/offers/175872376413007.webp', '4', NULL, 1),
(16, NULL, NULL, 'admin/assets/images/offers/175872376495272.jpg', '4', NULL, 1),
(17, NULL, NULL, 'admin/assets/images/offers/176570817959285.png', '8', NULL, 1),
(18, NULL, NULL, 'admin/assets/images/offers/176570817987906.png', '8', NULL, 1);

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

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `base_img` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `info` varchar(1255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `message_img` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `statistic_img` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `statistics` json DEFAULT NULL,
  `page_no` tinyint DEFAULT NULL COMMENT '{ 1 => الرئيسيه },{ 2 => قيمنا },{ 3 => نوع المساكن العقاريه },{ 4 => خدمتنا }',
  `deleted_at` datetime DEFAULT NULL,
  `is_activate` tinyint NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` (`id`, `created_at`, `updated_at`, `title`, `base_img`, `info`, `message_img`, `statistic_img`, `statistics`, `page_no`, `deleted_at`, `is_activate`) VALUES
(1, NULL, '2025-09-26 21:54:22', 'Numquam sit asperior 222', 'admin/assets/images/pages/175787936125171.jpg', 'Aliquam officiis dol 222', NULL, 'admin/assets/images/pages/175871113295614.png', '{\"2\": {\"title\": \"650 مليون ريال\", \"content\": \"إجمالي حجم تمويلك عن طريق نوع المساكن بالتعاون مع جهات التمويل\"}, \"3\": {\"title\": \"250%\", \"content\": \"كفاءة في العملية البيعية (عن طريق أتمتة العمليات)\"}, \"4\": {\"title\": \"4x\", \"content\": \"سرعة بيع العقار مقارنة بمتوسط السوق (متوسط البيع 4 أسابيع)\"}, \"5\": {\"title\": \"4000\", \"content\": \"عقود الوساطة العقارية\"}, \"6\": {\"title\": \"6000\", \"content\": \"عقود الإيجار\"}}', 1, NULL, 1),
(2, NULL, '2025-09-27 14:13:14', 'Veritatis maxime rat', 'admin/assets/images/pages/175793747480180.jpg', 'Expedita consequatur', 'admin/assets/images/pages/175898959467373.avif', NULL, NULL, 2, NULL, 1),
(3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, 1),
(4, NULL, '2025-09-27 16:12:54', 'Eum laudantium prov', 'admin/assets/images/pages/175795622030479.jpg', 'Qui aliquip suscipit', 'admin/assets/images/pages/175898914492563.jpg', NULL, NULL, 4, NULL, 1);

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

--
-- Table structure for table `page_details`
--

CREATE TABLE `page_details` (
  `id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `info` varchar(1255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `page_id` int DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `is_activate` tinyint NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `partners`
--

CREATE TABLE `partners` (
  `id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `img` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `page_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `is_activate` tinyint NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `partners`
--

INSERT INTO `partners` (`id`, `created_at`, `updated_at`, `img`, `page_id`, `deleted_at`, `is_activate`) VALUES
(5, '2025-09-14 18:21:33', '2025-09-14 18:21:33', 'admin/assets/images/pages/175788129336278.png', '1', NULL, 1),
(7, '2025-09-14 18:22:01', '2025-09-14 18:22:01', 'admin/assets/images/pages/175788132186871.png', '1', NULL, 1),
(8, '2025-09-14 18:22:12', '2025-09-14 18:22:12', 'admin/assets/images/pages/175788133216683.webp', '1', NULL, 1),
(9, '2025-09-24 05:23:21', '2025-09-24 05:23:21', 'admin/assets/images/pages/175869860163988.png', '1', NULL, 1),
(10, '2025-09-24 05:23:21', '2025-09-24 05:23:21', 'admin/assets/images/pages/175869860197038.png', '1', NULL, 1),
(11, '2025-09-24 05:23:21', '2025-09-24 05:23:21', 'admin/assets/images/pages/175869860151517.png', '1', NULL, 1),
(12, '2025-09-24 05:23:21', '2025-09-24 05:23:21', 'admin/assets/images/pages/175869860182290.png', '1', NULL, 1),
(13, '2025-09-24 05:23:21', '2025-09-24 05:23:21', 'admin/assets/images/pages/175869860137669.jpg', '1', NULL, 1),
(14, '2025-09-24 05:23:21', '2025-09-24 05:23:21', 'admin/assets/images/pages/175869860165184.webp', '1', NULL, 1);

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

--
-- Table structure for table `ratings`
--

CREATE TABLE `ratings` (
  `id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` varchar(1255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `img` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rating_at` date DEFAULT NULL,
  `rating` int DEFAULT NULL,
  `page_id` int DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `is_activate` tinyint NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ratings`
--

INSERT INTO `ratings` (`id`, `created_at`, `updated_at`, `title`, `comment`, `img`, `rating_at`, `rating`, `page_id`, `deleted_at`, `is_activate`) VALUES
(1, '2025-09-14 20:45:45', '2025-09-14 20:45:45', 'aaaaa', 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaas', 'admin/assets/images/pages/175788994587572.png', '2025-09-10', 3, 1, NULL, 1),
(2, '2025-09-14 20:45:45', '2025-09-14 20:45:45', 'sssss', 'sssssssssssssssssssssssssssssssssssssssss', 'admin/assets/images/pages/175788994591125.png', '2025-09-11', 4, 1, NULL, 1),
(5, '2025-09-15 09:16:29', '2025-09-15 09:16:29', 'vvvvvvvvvvvvvvvvvvvvvvvvv', 'vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv', 'admin/assets/images/pages/175793498930103.png', '2025-09-15', 3, 1, NULL, 1),
(6, '2025-09-24 06:04:09', '2025-09-24 06:04:09', 'vvvvvvvvvvvvvvvvvvvvvvvvv', 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa', 'admin/assets/images/pages/175870104930356.png', '2025-09-20', 5, 1, NULL, 1);

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

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

CREATE TABLE `requests` (
  `id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `purpose` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `category` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ptype` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `buy_budget` decimal(15,2) DEFAULT NULL,
  `invest_budget` decimal(15,2) DEFAULT NULL,
  `city` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `full_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ctype` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `agree` tinyint(1) NOT NULL DEFAULT '1',
  `deleted_at` datetime DEFAULT NULL,
  `is_activate` tinyint NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `requests`
--

INSERT INTO `requests` (`id`, `created_at`, `updated_at`, `purpose`, `category`, `ptype`, `buy_budget`, `invest_budget`, `city`, `full_name`, `phone`, `ctype`, `agree`, `deleted_at`, `is_activate`) VALUES
(1, '2025-09-24 18:01:52', '2025-09-24 18:01:52', 'إيجار', 'تجاري', 'فيلا', 1200.00, 12000.00, 'الرياض', 'Aurelia Noel', '+1 (245) 203-1948', 'مستثمر', 1, NULL, 1),
(2, '2025-09-24 18:02:33', '2025-09-24 18:02:33', 'إيجار', 'تجاري', 'شقة', 10000.00, 100000.00, 'الرياض', 'Russell Howard', '+1 (604) 144-7465', 'مستثمر', 1, NULL, 1),
(3, '2025-09-24 18:03:18', '2025-09-24 18:03:18', 'إيجار', 'تجاري', 'فيلا', 100000.00, 200000.00, 'الدمام', 'Kirk Gilmore', '+1 (208) 998-9293', 'يبحث عن عقار', 1, NULL, 1),
(4, '2025-09-24 18:03:37', '2025-09-24 18:03:37', 'إيجار', 'تجاري', 'فيلا', 9600.00, 32000.00, 'الرياض', 'Aileen Ashley', '+1 (106) 379-1741', 'مستثمر', 1, NULL, 1);

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

--
-- Table structure for table `values`
--

CREATE TABLE `values` (
  `id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` varchar(1255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `img` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `page_id` int DEFAULT NULL,
  `value_no` tinyint DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `is_activate` tinyint NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `values`
--

INSERT INTO `values` (`id`, `created_at`, `updated_at`, `title`, `comment`, `img`, `page_id`, `value_no`, `deleted_at`, `is_activate`) VALUES
(5, '2025-09-15 12:28:35', '2025-09-27 14:13:14', 'الشفافية والمصداقية', 'الشفافية والمصداقية', 'admin/assets/images/pages/175871364477109.png', 2, 1, NULL, 1),
(6, '2025-09-15 12:28:35', '2025-09-27 14:13:15', 'الاحترافية في التنفيذ', 'الاحترافية في التنفيذ', 'admin/assets/images/pages/175871376129382.png', 2, 2, NULL, 1),
(7, '2025-09-15 12:28:35', '2025-09-27 14:13:15', 'رضا العميل في كل مرحلة', 'نسعى لفهم احتياجات عملائنا وتقديم حلول تناسب تطلعاتهم في كل خطوة.', 'admin/assets/images/pages/175871398225666.png', 2, 3, NULL, 1),
(8, '2025-09-15 12:28:35', '2025-09-27 17:36:41', 'الابتكار في التسويق', 'نستخدم أدوات التسويق الذكي لنقدّم العقار بصورة إبداعية وجذابة تلفت الأنظار.', 'admin/assets/images/pages/175871394789448.png', 2, 4, NULL, 1),
(9, '2025-09-24 09:13:37', '2025-09-27 15:41:41', 'الوساطة العقارية', 'نساعدك في بيع، شراء، أو تأجير العقارات بكل سلاسة وكفاءة، عبر فريق من الوسطاء العقاريين المحترفين المتخصصين في تقديم حلول ذكية وخدمات عقارية تلبي احتياجاتك بدقة', 'admin/assets/images/pages/175871552416493.png', 4, 5, NULL, 1),
(10, '2025-09-24 09:13:37', '2025-09-27 15:41:35', 'التسويق الحصري لعقارك -احترافية، نتائج مضمونة', 'عقارك وكأنه ملك لنا، ونتعامل معه بأعلى درجات الالتزام لخدمة عملائك بأفضل صورة – من خلال تفاصيل دقيقة وخطة تسويقية مدروسة بعناية. 💼 دع عنك عناء التسويق... واترك لنا المهمة، وكن مستعدًا للنتائج.', 'admin/assets/images/pages/175871552490415.png', 4, 6, NULL, 1),
(12, '2025-09-24 09:18:47', '2025-09-27 14:05:44', 'عقودالإيجار الالكتروني', 'نوفر لك خدمة توثيق عقود الإيجار السكنية والتجارية عبر منصة إيجار، بتوثيق فوري معتمد دون الحاجة لحضور الأطراف، وبسهولة تامة في جميع أنحاء المملكة العربية السعودية', 'admin/assets/images/pages/175871552476551.png', 4, 7, NULL, 1),
(14, '2025-09-27 16:12:54', '2025-09-27 16:12:54', 'Voluptas qui sed tem', 'Id corporis magni du Id corporis magni du Id corporis magni du', 'admin/assets/images/pages/175899677485568.png', 4, NULL, NULL, 1);

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

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

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `clients`
--
ALTER TABLE `clients`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `contacts`
--
ALTER TABLE `contacts`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `offers`
--
ALTER TABLE `offers`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `offer_details`
--
ALTER TABLE `offer_details`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `offer_imgs`
--
ALTER TABLE `offer_imgs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `pages`
--
ALTER TABLE `pages`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `page_details`
--
ALTER TABLE `page_details`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `partners`
--
ALTER TABLE `partners`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `ratings`
--
ALTER TABLE `ratings`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `requests`
--
ALTER TABLE `requests`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `values`
--
ALTER TABLE `values`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;
COMMIT;

