-- https://www.phpmyadmin.net/
--
-- إصدار الخادم: 10.11.14-MariaDB

START TRANSACTION;



--
-- Database: `pioneergym_shapooov_v1`
--

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

--
-- بنية الجدول `branches`
--

CREATE TABLE `branches` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `branch_code` varchar(10) NOT NULL,
  `name` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`name`)),
  `short_name` varchar(20) DEFAULT NULL,
  `gender` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0 = men, 1 = women',
  `branch_category_id` bigint(20) UNSIGNED NOT NULL,
  `branch_type_id` bigint(20) UNSIGNED NOT NULL,
  `city_id` bigint(20) UNSIGNED NOT NULL,
  `primary_phone` varchar(255) NOT NULL,
  `phones` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`phones`)),
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `address` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`address`)),
  `min_age` tinyint(3) UNSIGNED DEFAULT NULL,
  `max_discount_percent` decimal(5,2) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- إرجاع أو استيراد بيانات الجدول `branches`
--

INSERT INTO `branches` (`id`, `branch_code`, `name`, `short_name`, `gender`, `branch_category_id`, `branch_type_id`, `city_id`, `primary_phone`, `phones`, `active`, `address`, `min_age`, `max_discount_percent`, `created_at`, `updated_at`) VALUES
(1, '001', '{\"ar\":\"فرع القيروان\",\"en\":\"Al-Qirawan Club\"}', 'QRN', 0, 1, 2, 4, '0560855525', '[{\"label\":{\"ar\":\"Ahmed Aldosary\",\"en\":\"Ahmed Aldosary\"},\"number\":\"0560855525\"}]', 1, '{\"full\":{\"ar\":\"hgvdhq\",\"en\":null},\"short\":{\"ar\":null,\"en\":null},\"street\":{\"ar\":\"\\u0645\\u0633\\u0643\\u0627\\u0646\",\"en\":null},\"district\":{\"ar\":null,\"en\":null},\"building_no\":null,\"postal_code\":\"13343\",\"tax_no\":\"312578917800003\"}', NULL, NULL, '2026-01-21 02:06:43', '2026-01-21 02:06:43');

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

--
-- بنية الجدول `branch_categories`
--

CREATE TABLE `branch_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`name`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- إرجاع أو استيراد بيانات الجدول `branch_categories`
--

INSERT INTO `branch_categories` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, '{\"ar\":\"الفئة الاحترافية\",\"en\":\"Professional Category\"}', '2025-10-19 04:46:25', '2025-12-04 02:18:13'),
(2, '{\"ar\":\"الفئة الاقتصادية\",\"en\":\"Economy Category\"}', '2025-10-19 04:46:25', '2025-12-04 02:18:34');

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

--
-- بنية الجدول `branch_monthly_goals`
--

CREATE TABLE `branch_monthly_goals` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `branch_id` bigint(20) UNSIGNED NOT NULL,
  `year` smallint(6) NOT NULL,
  `month` tinyint(4) NOT NULL,
  `actual` decimal(12,2) NOT NULL DEFAULT 0.00,
  `target` decimal(12,2) NOT NULL DEFAULT 0.00,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- بنية الجدول `branch_service_provided`
--

CREATE TABLE `branch_service_provided` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `service_id` bigint(20) UNSIGNED NOT NULL,
  `branch_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- إرجاع أو استيراد بيانات الجدول `branch_service_provided`
--

INSERT INTO `branch_service_provided` (`id`, `service_id`, `branch_id`) VALUES
(4, 1, 1),
(5, 2, 1),
(6, 3, 1),
(7, 4, 1);

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

--
-- بنية الجدول `branch_service_sold`
--

CREATE TABLE `branch_service_sold` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `service_id` bigint(20) UNSIGNED NOT NULL,
  `branch_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- إرجاع أو استيراد بيانات الجدول `branch_service_sold`
--

INSERT INTO `branch_service_sold` (`id`, `service_id`, `branch_id`) VALUES
(2, 1, 1),
(4, 2, 1),
(5, 3, 1),
(6, 4, 1);

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

--
-- بنية الجدول `branch_types`
--

CREATE TABLE `branch_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`name`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- إرجاع أو استيراد بيانات الجدول `branch_types`
--

INSERT INTO `branch_types` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, '{\"ar\":\"الإدارات\",\"en\":\"Departments\"}', '2025-10-19 04:46:25', '2025-12-04 02:20:30'),
(2, '{\"ar\":\"الصالات الرجالية\",\"en\":\"Men Gym\"}', '2025-10-19 04:46:25', '2025-12-04 02:20:51'),
(3, '{\"ar\":\"الصالات النسائية\",\"en\":\"Ladies Gym\"}', '2025-10-19 04:46:25', '2025-12-04 02:21:10'),
(4, '{\"en\":\"Kids Gym\",\"ar\":\"صالات الأصفال\"}', '2025-12-04 02:21:25', '2025-12-04 02:21:25'),
(5, '{\"en\":\"Family Gym\",\"ar\":\"الصالات العائلية\"}', '2025-12-04 02:21:41', '2025-12-04 02:21:41'),
(6, '{\"en\":\"On Cloud Applications\",\"ar\":\"التطبيقات السحابية\"}', '2025-12-04 02:22:07', '2025-12-04 02:22:07');

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

--
-- بنية الجدول `cities`
--

CREATE TABLE `cities` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`name`)),
  `state_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- إرجاع أو استيراد بيانات الجدول `cities`
--

INSERT INTO `cities` (`id`, `name`, `state_id`, `created_at`, `updated_at`) VALUES
(1, '{\"ar\":\"مدينة نصر\",\"en\":\"Nasr City\"}', 1, '2025-10-19 04:46:20', '2025-10-19 04:46:20'),
(2, '{\"ar\":\"الزمالك\",\"en\":\"Zamalek\"}', 1, '2025-10-19 04:46:20', '2025-10-19 04:46:20'),
(3, '{\"ar\":\"الملز\",\"en\":\"Olaya\"}', 4, '2025-10-19 04:46:20', '2025-10-19 04:46:20'),
(4, '{\"ar\":\"الخبر\",\"en\":\"Al-Khobar\"}', 4, '2025-10-19 04:46:20', '2025-10-19 04:46:20'),
(5, '{\"ar\":\"الخليج الغربي\",\"en\":\"West Bay\"}', 13, '2025-10-19 04:46:22', '2025-10-19 04:46:22'),
(6, '{\"ar\":\"السد\",\"en\":\"Al Sadd\"}', 13, '2025-10-19 04:46:22', '2025-10-19 04:46:22');

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

--
-- بنية الجدول `company_settings`
--

CREATE TABLE `company_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`name`)),
  `logo_path` varchar(255) DEFAULT NULL,
  `primary_color` varchar(255) NOT NULL DEFAULT '#0ea5b6',
  `secondary_color` varchar(255) NOT NULL DEFAULT '#1e293b',
  `email` varchar(255) DEFAULT NULL,
  `tax_number` varchar(100) DEFAULT NULL,
  `phones` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`phones`)),
  `country_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- إرجاع أو استيراد بيانات الجدول `company_settings`
--

INSERT INTO `company_settings` (`id`, `name`, `logo_path`, `primary_color`, `secondary_color`, `email`, `tax_number`, `phones`, `country_id`, `created_at`, `updated_at`) VALUES
(1, '{\"ar\":\"شركة الفولاذ الاسطوري للرياضة\",\"en\":\"Legendary Steel Sports Company\"}', 'logo_path/logo_20260128_070024_mSHL5g.fla', '#0ea5b6', '#1e293b', 'info@shpooov.com', '312578917800003', '[{\"label\":{\"ar\":\"\\u0627\\u0644\\u0645\\u0628\\u064a\\u0639\\u0627\\u062a\",\"en\":\"Sales\"},\"number\":\"+966560855525\"},{\"label\":{\"ar\":\"\\u0627\\u0644\\u062f\\u0639\\u0645\",\"en\":\"Support\"},\"number\":\"+966560855525\"}]', 2, '2025-10-19 04:46:24', '2026-01-28 04:00:24');

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

--
-- بنية الجدول `countries`
--

CREATE TABLE `countries` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`name`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- إرجاع أو استيراد بيانات الجدول `countries`
--

INSERT INTO `countries` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, '{\"ar\":\"مصر\",\"en\":\"Egypt\"}', '2025-10-19 04:46:20', '2025-10-19 04:46:20'),
(2, '{\"ar\":\"السعودية\",\"en\":\"Saudi Arabia\"}', '2025-10-19 04:46:20', '2025-10-19 04:46:20'),
(3, '{\"ar\":\"الإمارات\",\"en\":\"United Arab Emirates\"}', '2025-10-19 04:46:21', '2025-10-19 04:46:21'),
(4, '{\"ar\":\"الأردن\",\"en\":\"Jordan\"}', '2025-10-19 04:46:21', '2025-10-19 04:46:21'),
(5, '{\"ar\":\"لبنان\",\"en\":\"Lebanon\"}', '2025-10-19 04:46:21', '2025-10-19 04:46:21'),
(6, '{\"ar\":\"الجزائر\",\"en\":\"Algeria\"}', '2025-10-19 04:46:21', '2025-10-19 04:46:21'),
(7, '{\"ar\":\"المغرب\",\"en\":\"Morocco\"}', '2025-10-19 04:46:21', '2025-10-19 04:46:21'),
(8, '{\"ar\":\"تونس\",\"en\":\"Tunisia\"}', '2025-10-19 04:46:21', '2025-10-19 04:46:21'),
(9, '{\"ar\":\"العراق\",\"en\":\"Iraq\"}', '2025-10-19 04:46:21', '2025-10-19 04:46:21'),
(10, '{\"ar\":\"الكويت\",\"en\":\"Kuwait\"}', '2025-10-19 04:46:21', '2025-10-19 04:46:21'),
(11, '{\"ar\":\"عمان\",\"en\":\"Oman\"}', '2025-10-19 04:46:21', '2025-10-19 04:46:21'),
(12, '{\"ar\":\"قطر\",\"en\":\"Qatar\"}', '2025-10-19 04:46:22', '2025-10-19 04:46:22'),
(13, '{\"ar\":\"البحرين\",\"en\":\"Bahrain\"}', '2025-10-19 04:46:23', '2025-10-19 04:46:23'),
(14, '{\"ar\":\"فلسطين\",\"en\":\"Palestine\"}', '2025-10-19 04:46:23', '2025-10-19 04:46:23'),
(15, '{\"ar\":\"سوريا\",\"en\":\"Syria\"}', '2025-10-19 04:46:23', '2025-10-19 04:46:23'),
(16, '{\"ar\":\"اليمن\",\"en\":\"Yemen\"}', '2025-10-19 04:46:23', '2025-10-19 04:46:23');

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

--
-- بنية الجدول `customers`
--

CREATE TABLE `customers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `customer_code` varchar(7) NOT NULL,
  `branch_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- إرجاع أو استيراد بيانات الجدول `customers`
--

INSERT INTO `customers` (`id`, `customer_code`, `branch_id`, `name`, `created_at`, `updated_at`) VALUES
(1, '0100001', 1, 'محمدصالح العباد', '2026-01-24 13:41:10', '2026-01-24 13:41:10');

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

--
-- بنية الجدول `failed_jobs`
--

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

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

--
-- بنية الجدول `member_payments`
--

CREATE TABLE `member_payments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `member_id` bigint(20) UNSIGNED NOT NULL,
  `item_type` enum('offer','service') NOT NULL,
  `item_id` bigint(20) UNSIGNED NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `currency` varchar(3) NOT NULL DEFAULT 'SAR',
  `merchant_transaction_id` varchar(255) NOT NULL,
  `checkout_id` varchar(255) DEFAULT NULL,
  `transaction_id` varchar(255) DEFAULT NULL,
  `result_code` varchar(50) DEFAULT NULL,
  `result_description` varchar(255) DEFAULT NULL,
  `status` enum('pending','paid','failed') NOT NULL DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- إرجاع أو استيراد بيانات الجدول `member_payments`
--

INSERT INTO `member_payments` (`id`, `member_id`, `item_type`, `item_id`, `amount`, `currency`, `merchant_transaction_id`, `checkout_id`, `transaction_id`, `result_code`, `result_description`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 'offer', 1, 8000.00, 'SAR', 'c45fcae0-39ac-423c-97c9-b32d5ffc18c2', '377EBC3C678DA422144E42E1C8D54A7A.uat01-vm-tx01', NULL, NULL, NULL, 'pending', '2026-01-21 05:37:17', '2026-01-21 05:37:18'),
(2, 2, 'offer', 1, 8000.00, 'SAR', '67748008-8e31-4aa4-84ff-37724eb5432f', 'B5A753710EC7E6FE425DDA82E71A775C.uat01-vm-tx02', NULL, NULL, NULL, 'pending', '2026-01-21 15:50:48', '2026-01-21 15:50:49'),
(3, 1, 'offer', 1, 8000.00, 'SAR', '3f5d43dc-7bc1-47d4-8be4-58e9cd53f3b1', '9F60B5D7D4CC93549649CC93DEE2AD95.uat01-vm-tx01', NULL, NULL, NULL, 'pending', '2026-01-22 03:28:13', '2026-01-22 03:28:14'),
(4, 1, 'offer', 1, 8000.00, 'SAR', '3fa80641-e9e4-4342-997f-d82ec76c5bf8', 'BE6C955F1A972277EE9509714193DC45.uat01-vm-tx03', NULL, NULL, NULL, 'pending', '2026-01-22 03:34:43', '2026-01-22 03:34:43'),
(5, 35, 'offer', 1, 8000.00, 'SAR', 'ecabca98-2e4b-47db-b5e3-13194eaf701c', '46A666F049971AFB5B309F7818366899.uat01-vm-tx02', NULL, NULL, NULL, 'pending', '2026-01-22 09:43:22', '2026-01-22 09:43:22'),
(6, 214, 'offer', 1, 8000.00, 'SAR', '26fe1b64-8ab8-4b72-a39f-e4ad14f3d5d4', '7A87AE8E44452A2E85DAF0213053BFCC.uat01-vm-tx01', NULL, NULL, NULL, 'pending', '2026-01-27 09:31:44', '2026-01-27 09:31:44'),
(7, 214, 'offer', 1, 8000.00, 'SAR', '1264fcef-8e37-45c3-9b8e-bf02b09d8cf8', 'D1256AFBB01C6E777F3AE1C5B8D18D25.uat01-vm-tx01', NULL, NULL, NULL, 'pending', '2026-01-27 10:18:50', '2026-01-27 10:18:51');

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

--
-- بنية الجدول `member_sequences`
--

CREATE TABLE `member_sequences` (
  `branch_id` bigint(20) UNSIGNED NOT NULL,
  `prefix` char(2) NOT NULL,
  `last_seq` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- إرجاع أو استيراد بيانات الجدول `member_sequences`
--

INSERT INTO `member_sequences` (`branch_id`, `prefix`, `last_seq`, `created_at`, `updated_at`) VALUES
(1, '01', 370, '2026-01-21 02:18:52', '2026-01-31 11:34:43');

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

--
-- بنية الجدول `migrations`
--

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

--
-- إرجاع أو استيراد بيانات الجدول `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_01_20_195147_create_countries_table', 1),
(2, '2014_01_20_195616_create_states_table', 1),
(3, '2014_01_20_195637_create_cities_table', 1),
(4, '2014_01_25_060108_create_branch_categories_table', 1),
(5, '2014_01_25_062659_create_branch_types_table', 1),
(6, '2014_01_25_082216_create_branches_table', 1),
(7, '2014_10_12_000000_create_users_table', 1),
(8, '2014_10_12_100000_create_password_reset_tokens_table', 1),
(9, '2014_10_12_100000_create_password_resets_table', 1),
(10, '2019_08_19_000000_create_failed_jobs_table', 1),
(11, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(12, '2025_09_25_071042_create_company_settings_table', 1),
(13, '2025_09_25_082331_create_branch_monthly_goals_table', 1),
(14, '2025_09_25_170137_create_service_types_table', 1),
(15, '2025_09_25_172350_create_service_categories_table', 1),
(16, '2025_09_25_184345_create_services_table', 1),
(17, '2025_10_03_195032_create_customers_table', 1),
(18, '2025_10_03_204536_create_members_table', 1),
(19, '2025_10_03_231239_create_member_sequences_table', 1),
(20, '2025_10_06_075050_create_offers_table', 1),
(21, '2025_10_06_075203_create_offer_items_table', 1),
(22, '2025_10_18_120945_create_permission_tables', 1);

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

--
-- بنية الجدول `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- بنية الجدول `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- إرجاع أو استيراد بيانات الجدول `model_has_roles`
--

INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES
(1, 'App\\Models\\User', 1),
(1, 'App\\Models\\User', 4);

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

--
-- بنية الجدول `offers`
--

CREATE TABLE `offers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `offer_no` bigint(20) UNSIGNED NOT NULL,
  `name` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`name`)),
  `scope` enum('all','members','customers','coupons') NOT NULL DEFAULT 'all',
  `target_member_ids` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`target_member_ids`)),
  `target_customer_ids` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`target_customer_ids`)),
  `coupon_codes` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`coupon_codes`)),
  `start_date_g` date NOT NULL,
  `end_date_g` date NOT NULL,
  `start_date_h` varchar(20) DEFAULT NULL,
  `end_date_h` varchar(20) DEFAULT NULL,
  `duration_days` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `discount_type` enum('percent','amount') NOT NULL DEFAULT 'percent',
  `discount_value` decimal(10,2) NOT NULL DEFAULT 0.00,
  `extra_days` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `is_live` tinyint(1) NOT NULL DEFAULT 1 COMMENT '0 = hidden, 1 = live'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- إرجاع أو استيراد بيانات الجدول `offers`
--

INSERT INTO `offers` (`id`, `offer_no`, `name`, `scope`, `target_member_ids`, `target_customer_ids`, `coupon_codes`, `start_date_g`, `end_date_g`, `start_date_h`, `end_date_h`, `duration_days`, `discount_type`, `discount_value`, `extra_days`, `active`, `created_at`, `updated_at`, `is_live`) VALUES
(1, 1, '{\"ar\":\"\\u0639\\u0631\\u0636 \\u0627\\u0644\\u0645\\u0624\\u0633\\u0633\",\"en\":\"Founder\'s Promotion\"}', 'members', NULL, NULL, NULL, '2026-01-20', '2026-03-30', '1447-08-02', '1447-10-11', 70, 'amount', 5000.00, 0, 1, '2026-01-21 02:50:14', '2026-01-21 06:07:04', 1),
(2, 2, '{\"ar\":\"\\u0639\\u0631\\u0636 \\u0627\\u0644\\u0623\\u0635\\u062f\\u0642\\u0627\\u0621\",\"en\":\"Friends Promotion\"}', 'members', NULL, NULL, NULL, '2026-01-20', '2026-03-30', '1447-08-02', '1447-10-11', 70, 'percent', 100.00, 0, 1, '2026-01-21 06:06:48', '2026-01-25 12:07:17', 0),
(3, 3, '{\"ar\":\"\\u0639\\u0631\\u0636 \\u0627\\u0628\\u0648\\u0631\\u0628\\u064a\\u0639\\u0629\",\"en\":\"\\u0639\\u0631\\u0636 \\u0627\\u0628\\u0648\\u0631\\u0628\\u064a\\u0639\\u0629\"}', 'members', NULL, NULL, NULL, '2026-01-25', '2027-01-31', '1447-08-07', '1448-08-24', 372, 'percent', 50.00, 0, 1, '2026-01-25 14:16:12', '2026-01-25 14:16:56', 0);

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

--
-- بنية الجدول `offer_items`
--

CREATE TABLE `offer_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `offer_id` bigint(20) UNSIGNED NOT NULL,
  `service_id` bigint(20) UNSIGNED NOT NULL,
  `service_name` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`service_name`)),
  `base_price` decimal(10,2) NOT NULL,
  `base_duration_value` int(10) UNSIGNED NOT NULL,
  `base_duration_unit` enum('days','months','years') NOT NULL,
  `row_discount_type` enum('percent','amount') DEFAULT NULL,
  `row_discount_value` decimal(10,2) DEFAULT NULL,
  `row_extra_days` int(10) UNSIGNED DEFAULT NULL,
  `final_price` decimal(10,2) NOT NULL,
  `final_duration_value` int(10) UNSIGNED NOT NULL,
  `final_duration_unit` enum('days','months','years') NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- إرجاع أو استيراد بيانات الجدول `offer_items`
--

INSERT INTO `offer_items` (`id`, `offer_id`, `service_id`, `service_name`, `base_price`, `base_duration_value`, `base_duration_unit`, `row_discount_type`, `row_discount_value`, `row_extra_days`, `final_price`, `final_duration_value`, `final_duration_unit`, `created_at`, `updated_at`) VALUES
(6, 1, 3, '\"\\u0627\\u0634\\u062a\\u0631\\u0627\\u0643 \\u0633\\u0646\\u062a\\u064a\\u0646\"', 13000.00, 24, 'months', NULL, NULL, NULL, 8000.00, 24, 'months', '2026-01-22 03:39:47', '2026-01-22 03:39:47'),
(8, 2, 2, '\"\\u0627\\u0634\\u062a\\u0631\\u0627\\u0643 \\u0633\\u0646\\u0648\\u064a\"', 5999.00, 12, 'months', NULL, NULL, NULL, 0.00, 12, 'months', '2026-01-25 12:07:17', '2026-01-25 12:07:17'),
(13, 3, 2, '\"\\u0627\\u0634\\u062a\\u0631\\u0627\\u0643 \\u0633\\u0646\\u0648\\u064a\"', 5999.00, 12, 'months', NULL, NULL, NULL, 2999.50, 12, 'months', '2026-01-25 14:16:56', '2026-01-25 14:16:56'),
(14, 3, 1, '\"\\u0627\\u0634\\u062a\\u0631\\u0627\\u0643 \\u0646\\u0635\\u0641 \\u0633\\u0646\\u0648\\u064a\"', 3999.00, 6, 'months', NULL, NULL, NULL, 1999.50, 6, 'months', '2026-01-25 14:16:56', '2026-01-25 14:16:56');

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

--
-- بنية الجدول `payment_methods`
--

CREATE TABLE `payment_methods` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name_ar` varchar(100) NOT NULL,
  `name_en` varchar(100) NOT NULL,
  `code` varchar(30) DEFAULT NULL,
  `active` tinyint(1) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- إرجاع أو استيراد بيانات الجدول `payment_methods`
--

INSERT INTO `payment_methods` (`id`, `name_ar`, `name_en`, `code`, `active`, `created_at`, `updated_at`) VALUES
(1, 'نقدي', 'Cash', 'cash', 1, '2025-10-28 07:07:08', '2025-10-28 07:07:08'),
(2, 'بطاقة بنكية', 'Card', 'card', 1, '2025-10-28 07:07:08', '2025-10-28 07:07:08'),
(3, 'تحويل بنكي', 'Bank Transfer', 'bank', 1, '2025-10-28 07:07:08', '2025-10-28 07:07:08'),
(4, 'مدى', 'Mada', 'mada', 1, '2025-10-28 07:07:08', '2025-10-28 07:07:08'),
(5, 'Apple Pay', 'Apple Pay', 'apple', 1, '2025-10-28 07:07:08', '2025-10-28 07:07:08'),
(6, 'Google Pay', 'Google Pay', 'google', 1, '2025-10-28 07:07:08', '2025-10-28 07:07:08'),
(7, 'بطاقة إئتمانية', 'Credit Card', '7', 1, '2025-10-29 03:11:51', '2025-10-29 03:11:51');

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

--
-- بنية الجدول `permissions`
--

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

--
-- إرجاع أو استيراد بيانات الجدول `permissions`
--

INSERT INTO `permissions` (`id`, `name`, `guard_name`, `branch_id`, `created_at`, `updated_at`) VALUES
(1, 'users.view', 'web', NULL, '2025-10-19 04:46:24', '2025-10-19 04:46:24'),
(2, 'users.create', 'web', NULL, '2025-10-19 04:46:24', '2025-10-19 04:46:24'),
(3, 'users.edit', 'web', NULL, '2025-10-19 04:46:24', '2025-10-19 04:46:24'),
(4, 'users.delete', 'web', NULL, '2025-10-19 04:46:24', '2025-10-19 04:46:24'),
(5, 'roles.view', 'web', NULL, '2025-10-19 04:46:24', '2025-10-19 04:46:24'),
(6, 'roles.create', 'web', NULL, '2025-10-19 04:46:24', '2025-10-19 04:46:24'),
(7, 'roles.edit', 'web', NULL, '2025-10-19 04:46:24', '2025-10-19 04:46:24'),
(8, 'roles.delete', 'web', NULL, '2025-10-19 04:46:24', '2025-10-19 04:46:24'),
(9, 'branches.view', 'web', NULL, '2025-10-19 04:46:24', '2025-10-19 04:46:24'),
(10, 'branches.create', 'web', NULL, '2025-10-19 04:46:24', '2025-10-19 04:46:24'),
(11, 'branches.edit', 'web', NULL, '2025-10-19 04:46:24', '2025-10-19 04:46:24'),
(12, 'branches.delete', 'web', NULL, '2025-10-19 04:46:24', '2025-10-19 04:46:24'),
(13, 'reports.view', 'web', NULL, '2025-10-19 04:46:25', '2025-10-19 04:46:25'),
(14, 'reports.export', 'web', NULL, '2025-10-19 04:46:25', '2025-10-19 04:46:25');

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

--
-- بنية الجدول `roles`
--

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

--
-- إرجاع أو استيراد بيانات الجدول `roles`
--

INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'super_admin', 'web', '2025-10-19 04:46:25', '2025-10-19 04:46:25');

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

--
-- بنية الجدول `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- إرجاع أو استيراد بيانات الجدول `role_has_permissions`
--

INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
(1, 1),
(2, 1),
(3, 1),
(4, 1),
(5, 1),
(6, 1),
(7, 1),
(8, 1),
(9, 1),
(10, 1),
(11, 1),
(12, 1),
(13, 1),
(14, 1);

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

--
-- بنية الجدول `services`
--

CREATE TABLE `services` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `service_code` varchar(10) DEFAULT NULL,
  `name` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`name`)),
  `service_category_id` bigint(20) UNSIGNED NOT NULL,
  `service_type_id` bigint(20) UNSIGNED NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `duration_value` int(10) UNSIGNED NOT NULL,
  `duration_unit` enum('days','months','years') NOT NULL,
  `start_time` time DEFAULT NULL,
  `end_time` time DEFAULT NULL,
  `notes` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`notes`)),
  `settings` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`settings`)),
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- إرجاع أو استيراد بيانات الجدول `services`
--

INSERT INTO `services` (`id`, `service_code`, `name`, `service_category_id`, `service_type_id`, `price`, `duration_value`, `duration_unit`, `start_time`, `end_time`, `notes`, `settings`, `active`, `created_at`, `updated_at`) VALUES
(1, '1001', '{\"ar\":\"اشتراك نصف سنوي\",\"en\":\"Subscription 6Months\"}', 1, 1, 3999.00, 6, 'months', '00:00:00', '23:59:00', '{\"en\":null}', '{\"pause\":{\"enabled\":\"1\",\"max_times\":\"4\",\"max_duration_value\":\"30\",\"max_duration_unit\":\"days\"}}', 1, '2026-01-21 02:14:49', '2026-01-21 02:14:49'),
(2, '1002', '{\"ar\":\"اشتراك سنوي\",\"en\":\"Subscriptions 12Months\"}', 1, 1, 5999.00, 12, 'months', '00:00:00', '23:59:00', '{\"en\":null}', '{\"pause\":{\"enabled\":\"1\",\"max_times\":\"6\",\"max_duration_value\":\"60\",\"max_duration_unit\":\"days\"}}', 1, '2026-01-21 02:17:08', '2026-01-21 02:17:08'),
(3, '1003', '{\"ar\":\"اشتراك سنتين\",\"en\":\"Subscriptions 24Months\"}', 1, 1, 13000.00, 24, 'months', '00:00:00', '23:59:00', '{\"en\":null}', '{\"pause\":{\"enabled\":\"1\",\"max_times\":\"10\",\"max_duration_value\":\"120\",\"max_duration_unit\":\"days\"}}', 1, '2026-01-21 02:48:25', '2026-01-21 02:48:25'),
(4, '1004', '{\"ar\":\"اشتراك يومي\",\"en\":\"subscription Daily\"}', 1, 3, 130.00, 1, 'days', '00:00:00', '11:59:00', '{\"en\":null}', NULL, 1, '2026-01-21 05:24:32', '2026-01-24 13:01:50');

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

--
-- بنية الجدول `service_categories`
--

CREATE TABLE `service_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`name`)),
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`description`)),
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- إرجاع أو استيراد بيانات الجدول `service_categories`
--

INSERT INTO `service_categories` (`id`, `name`, `description`, `active`, `created_at`, `updated_at`) VALUES
(1, '{\"en\":\"General Memberships\",\"ar\":\"الاشتراكات العامة\"}', '{\"en\":\"Voluptatum blanditii\",\"ar\":\"Iure minima voluptat\"}', 1, '2025-10-22 03:33:25', '2025-11-17 01:58:17'),
(2, '{\"en\":\"Personal Memberships\",\"ar\":\"إشتراكات التدريب الشخصي\"}', '{\"ar\":null}', 1, '2025-11-17 01:58:53', '2025-11-17 01:58:53'),
(3, '{\"en\":\"Swimming Personal Training Memberships\",\"ar\":\"إشتراكات التدريب الشخصي سباحة\"}', '{\"ar\":null}', 1, '2025-11-17 02:01:26', '2025-11-17 02:01:26');

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

--
-- بنية الجدول `service_invoices`
--

CREATE TABLE `service_invoices` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `document_no` bigint(20) UNSIGNED NOT NULL,
  `invoice_no` varchar(255) NOT NULL,
  `branch_id` bigint(20) UNSIGNED DEFAULT NULL,
  `member_id` bigint(20) UNSIGNED DEFAULT NULL,
  `provider_user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `service_user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `account_user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `greg_date` date NOT NULL,
  `hijri_date` varchar(255) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `payment_methods` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`payment_methods`)),
  `total_price` decimal(10,2) DEFAULT 0.00,
  `total_discount` decimal(10,2) DEFAULT 0.00,
  `total_tax` decimal(10,2) DEFAULT 0.00,
  `total_net` decimal(10,2) DEFAULT 0.00,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- إرجاع أو استيراد بيانات الجدول `service_invoices`
--

INSERT INTO `service_invoices` (`id`, `document_no`, `invoice_no`, `branch_id`, `member_id`, `provider_user_id`, `service_user_id`, `created_by`, `account_user_id`, `greg_date`, `hijri_date`, `notes`, `payment_methods`, `total_price`, `total_discount`, `total_tax`, `total_net`, `created_at`, `updated_at`) VALUES
(1, 1, 'QRN/2026/S000001', 1, 92, 2, NULL, 2, 2, '2026-01-24', '5-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-24 17:52:25', '2026-01-24 17:52:25'),
(2, 2, 'QRN/2026/S000002', 1, 101, 2, NULL, 2, 2, '2026-01-24', '5-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-24 19:05:35', '2026-01-24 19:05:35'),
(3, 3, 'ALL/2026/S000003', NULL, 122, 2, NULL, 2, 2, '2026-01-24', '5-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-24 19:16:29', '2026-01-24 19:16:29'),
(4, 4, 'QRN/2026/S000004', 1, 123, 6, NULL, 2, 2, '2026-01-25', '6-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-24 21:24:01', '2026-01-24 21:24:01'),
(5, 5, 'QRN/2026/S000005', 1, 38, 2, NULL, 2, 2, '2026-01-25', '6-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-25 03:12:46', '2026-01-25 03:12:46'),
(6, 6, 'QRN/2026/S000006', 1, 127, 2, NULL, 2, 2, '2026-01-25', '6-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-25 03:16:10', '2026-01-25 03:16:10'),
(7, 7, 'QRN/2026/S000007', 1, 128, 2, NULL, 2, 2, '2026-01-25', '6-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-25 04:43:44', '2026-01-25 04:43:44'),
(8, 8, 'QRN/2026/S000008', 1, 129, 3, NULL, 2, 2, '2026-01-25', '6-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-25 05:00:01', '2026-01-25 05:00:01'),
(9, 9, 'QRN/2026/S000009', 1, 134, 2, NULL, 2, 2, '2026-01-25', '6-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-25 06:55:11', '2026-01-25 06:55:11'),
(10, 10, 'QRN/2026/S000010', 1, 135, 3, NULL, 2, 2, '2026-01-25', '6-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-25 07:34:44', '2026-01-25 07:34:44'),
(11, 11, 'QRN/2026/S000011', 1, 139, 2, NULL, 2, 2, '2026-01-25', '6-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-25 08:08:56', '2026-01-25 08:08:56'),
(12, 12, 'QRN/2026/S000012', 1, 141, 2, NULL, 2, 2, '2026-01-25', '6-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-25 08:57:37', '2026-01-25 08:57:37'),
(13, 13, 'QRN/2026/S000013', 1, 142, 2, NULL, 2, 2, '2026-01-25', '6-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-25 09:06:47', '2026-01-25 09:06:47'),
(14, 14, 'QRN/2026/S000014', 1, 144, 2, NULL, 2, 2, '2026-01-25', '6-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-25 09:37:55', '2026-01-25 09:37:55'),
(15, 15, 'QRN/2026/S000015', 1, 147, 2, NULL, 2, 2, '2026-01-25', '6-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-25 10:05:06', '2026-01-25 10:05:06'),
(16, 16, 'QRN/2026/S000016', 1, 151, 2, NULL, 2, 2, '2026-01-25', '6-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-25 11:27:11', '2026-01-25 11:27:11'),
(17, 17, 'QRN/2026/S000017', 1, 154, 2, NULL, 2, 2, '2026-01-25', '6-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-25 12:35:22', '2026-01-25 12:35:22'),
(18, 18, 'QRN/2026/S000018', 1, 156, 2, NULL, 2, 2, '2026-01-25', '6-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-25 12:57:25', '2026-01-25 12:57:25'),
(19, 19, 'QRN/2026/S000019', 1, 157, 2, NULL, 2, 2, '2026-01-25', '6-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-25 13:48:55', '2026-01-25 13:48:55'),
(20, 20, 'QRN/2026/S000020', 1, 159, 5, NULL, 2, 2, '2026-01-25', '6-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-25 14:00:39', '2026-01-25 14:00:39'),
(21, 21, 'QRN/2026/S000021', 1, 162, 2, NULL, 2, 2, '2026-01-25', '6-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-25 15:01:51', '2026-01-25 15:01:51'),
(22, 22, 'ALL/2026/S000022', NULL, 165, 2, NULL, 2, 2, '2026-01-25', '6-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-25 15:41:09', '2026-01-25 15:41:09'),
(23, 23, 'QRN/2026/S000023', 1, 170, 2, NULL, 2, 2, '2026-01-26', '7-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-26 03:18:14', '2026-01-26 03:18:14'),
(24, 24, 'QRN/2026/S000024', 1, 171, 2, NULL, 2, 2, '2026-01-26', '7-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-26 04:19:17', '2026-01-26 04:19:17'),
(25, 25, 'QRN/2026/S000025', 1, 173, 2, NULL, 2, 2, '2026-01-26', '7-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-26 05:42:13', '2026-01-26 05:42:13'),
(26, 26, 'QRN/2026/S000026', 1, 174, 2, NULL, 2, 2, '2026-01-26', '7-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-26 05:44:10', '2026-01-26 05:44:10'),
(27, 27, 'QRN/2026/S000027', 1, 175, 2, NULL, 2, 2, '2026-01-26', '7-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-26 05:49:38', '2026-01-26 05:49:38'),
(28, 28, 'QRN/2026/S000028', 1, 178, 2, NULL, 2, 2, '2026-01-26', '7-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-26 07:34:07', '2026-01-26 07:34:07'),
(29, 29, 'QRN/2026/S000029', 1, 179, 2, NULL, 2, 2, '2026-01-26', '7-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-26 07:35:37', '2026-01-26 07:35:37'),
(30, 30, 'QRN/2026/S000030', 1, 181, 2, NULL, 2, 2, '2026-01-26', '7-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-26 08:46:59', '2026-01-26 08:46:59'),
(31, 31, 'QRN/2026/S000031', 1, 182, 2, NULL, 2, 2, '2026-01-26', '7-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-26 09:13:33', '2026-01-26 09:13:33'),
(32, 32, 'QRN/2026/S000032', 1, 183, 2, NULL, 2, 2, '2026-01-26', '7-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-26 09:16:52', '2026-01-26 09:16:52'),
(33, 33, 'QRN/2026/S000033', 1, 185, 2, NULL, 2, 2, '2026-01-26', '7-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-26 09:58:45', '2026-01-26 09:58:45'),
(34, 34, 'QRN/2026/S000034', 1, 144, 2, NULL, 2, 2, '2026-01-26', '7-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-26 10:52:47', '2026-01-26 10:52:47'),
(35, 35, 'QRN/2026/S000035', 1, 187, 2, NULL, 2, 2, '2026-01-26', '7-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-26 11:45:09', '2026-01-26 11:45:09'),
(36, 36, 'QRN/2026/S000036', 1, 188, 2, NULL, 2, 2, '2026-01-26', '7-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-26 12:38:09', '2026-01-26 12:38:09'),
(37, 37, 'QRN/2026/S000037', 1, 134, 7, NULL, 2, 2, '2026-01-26', '7-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-26 13:14:32', '2026-01-26 13:14:32'),
(38, 38, 'QRN/2026/S000038', 1, 189, 5, NULL, 2, 2, '2026-01-26', '7-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-26 13:33:51', '2026-01-26 13:33:51'),
(39, 39, 'QRN/2026/S000039', 1, 190, 5, NULL, 2, 2, '2026-01-26', '7-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-26 13:34:36', '2026-01-26 13:34:36'),
(40, 40, 'QRN/2026/S000040', 1, 191, 2, NULL, 2, 2, '2026-01-26', '7-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-26 13:38:56', '2026-01-26 13:38:56'),
(41, 41, 'ALL/2026/S000041', NULL, 193, 2, NULL, 2, 2, '2026-01-26', '7-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-26 14:26:10', '2026-01-26 14:26:10'),
(42, 42, 'QRN/2026/S000042', 1, 196, 5, NULL, 2, 2, '2026-01-26', '7-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-26 15:22:59', '2026-01-26 15:22:59'),
(43, 43, 'QRN/2026/S000043', 1, 198, 2, NULL, 2, 2, '2026-01-26', '7-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-26 17:20:57', '2026-01-26 17:20:57'),
(44, 44, 'QRN/2026/S000044', 1, 199, 2, NULL, 2, 2, '2026-01-27', '8-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-26 22:51:22', '2026-01-26 22:51:22'),
(45, 45, 'QRN/2026/S000045', 1, 201, 2, NULL, 2, 2, '2026-01-27', '8-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-27 00:39:56', '2026-01-27 00:39:56'),
(46, 46, 'QRN/2026/S000046', 1, 202, 2, NULL, 2, 2, '2026-01-27', '8-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-27 04:42:20', '2026-01-27 04:42:20'),
(47, 47, 'QRN/2026/S000047', 1, 203, 2, NULL, 2, 2, '2026-01-27', '8-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-27 05:15:37', '2026-01-27 05:15:37'),
(48, 48, 'QRN/2026/S000048', 1, 204, 2, NULL, 2, 2, '2026-01-27', '8-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-27 05:26:45', '2026-01-27 05:26:45'),
(49, 49, 'QRN/2026/S000049', 1, 179, 2, NULL, 2, 2, '2026-01-27', '8-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-27 07:50:21', '2026-01-27 07:50:21'),
(50, 50, 'QRN/2026/S000050', 1, 207, 2, NULL, 2, 2, '2026-01-27', '8-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-27 08:05:24', '2026-01-27 08:05:24'),
(51, 51, 'QRN/2026/S000051', 1, 142, 2, NULL, 2, 2, '2026-01-27', '8-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-27 08:09:39', '2026-01-27 08:09:39'),
(52, 52, 'QRN/2026/S000052', 1, 134, 2, NULL, 2, 2, '2026-01-27', '8-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-27 08:26:49', '2026-01-27 08:26:49'),
(53, 53, 'QRN/2026/S000053', 1, 208, 2, NULL, 2, 2, '2026-01-27', '8-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-27 08:34:34', '2026-01-27 08:34:34'),
(54, 54, 'QRN/2026/S000054', 1, 210, 2, NULL, 2, 2, '2026-01-27', '8-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-27 09:17:58', '2026-01-27 09:17:58'),
(55, 55, 'QRN/2026/S000055', 1, 211, 2, NULL, 2, 2, '2026-01-27', '8-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-27 09:29:11', '2026-01-27 09:29:11'),
(56, 56, 'QRN/2026/S000056', 1, 212, 2, NULL, 2, 2, '2026-01-27', '8-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-27 09:29:50', '2026-01-27 09:29:50'),
(57, 57, 'QRN/2026/S000057', 1, 217, 2, NULL, 2, 2, '2026-01-27', '8-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-27 10:50:36', '2026-01-27 10:50:36'),
(58, 58, 'QRN/2026/S000058', 1, 154, 7, NULL, 2, 2, '2026-01-27', '8-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-27 11:06:43', '2026-01-27 11:06:43'),
(59, 59, 'QRN/2026/S000059', 1, 220, 2, NULL, 2, 2, '2026-01-27', '8-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-27 12:08:41', '2026-01-27 12:08:41'),
(60, 60, 'QRN/2026/S000060', 1, 221, 2, NULL, 2, 2, '2026-01-27', '8-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-27 12:32:28', '2026-01-27 12:32:28'),
(61, 61, 'QRN/2026/S000061', 1, 100, 2, NULL, 2, 2, '2026-01-27', '8-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-27 12:38:57', '2026-01-27 12:38:57'),
(62, 62, 'QRN/2026/S000062', 1, 224, 7, NULL, 2, 2, '2026-01-27', '8-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-27 13:26:52', '2026-01-27 13:26:52'),
(63, 63, 'QRN/2026/S000063', 1, 225, 7, NULL, 2, 2, '2026-01-27', '8-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-27 13:40:31', '2026-01-27 13:40:31'),
(64, 64, 'QRN/2026/S000064', 1, 226, 7, NULL, 2, 2, '2026-01-27', '8-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-27 14:16:28', '2026-01-27 14:16:28'),
(65, 65, 'QRN/2026/S000065', 1, 227, 2, NULL, 2, 2, '2026-01-27', '8-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-27 18:06:58', '2026-01-27 18:06:58'),
(66, 66, 'QRN/2026/S000066', 1, 228, 2, NULL, 2, 2, '2026-01-27', '8-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-27 18:07:48', '2026-01-27 18:07:48'),
(67, 67, 'QRN/2026/S000067', 1, 229, 2, NULL, 2, 2, '2026-01-28', '9-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-28 03:35:28', '2026-01-28 03:35:28'),
(68, 68, 'QRN/2026/S000068', 1, 230, 3, NULL, 2, 2, '2026-01-28', '9-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-28 03:51:16', '2026-01-28 03:51:16'),
(69, 69, 'QRN/2026/S000069', 1, 231, 3, NULL, 2, 2, '2026-01-28', '9-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-28 04:08:41', '2026-01-28 04:08:42'),
(70, 70, 'QRN/2026/S000070', 1, 202, 2, NULL, 2, 2, '2026-01-28', '9-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-28 04:09:37', '2026-01-28 04:09:37'),
(71, 71, 'QRN/2026/S000071', 1, 179, 3, NULL, 2, 2, '2026-01-28', '9-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-28 04:58:12', '2026-01-28 04:58:12'),
(72, 72, 'QRN/2026/S000072', 1, 233, 2, NULL, 2, 2, '2026-01-28', '9-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-28 06:22:02', '2026-01-28 06:22:02'),
(73, 73, 'QRN/2026/S000073', 1, 234, 2, NULL, 2, 2, '2026-01-28', '9-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-28 06:23:14', '2026-01-28 06:23:14'),
(74, 74, 'QRN/2026/S000074', 1, 236, 2, NULL, 2, 2, '2026-01-28', '9-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-28 06:46:31', '2026-01-28 06:46:31'),
(75, 75, 'QRN/2026/S000075', 1, 238, 2, NULL, 2, 2, '2026-01-28', '9-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-28 09:10:13', '2026-01-28 09:10:13'),
(76, 76, 'QRN/2026/S000076', 1, 239, 2, NULL, 2, 2, '2026-01-28', '9-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-28 09:10:18', '2026-01-28 09:10:18'),
(77, 77, 'QRN/2026/S000077', 1, 243, 3, NULL, 2, 2, '2026-01-28', '9-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-28 09:23:32', '2026-01-28 09:23:32'),
(78, 78, 'QRN/2026/S000078', 1, 242, 2, NULL, 2, 2, '2026-01-28', '9-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-28 09:26:19', '2026-01-28 09:26:19'),
(79, 79, 'QRN/2026/S000079', 1, 82, 2, NULL, 2, 2, '2026-01-28', '9-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-28 09:27:53', '2026-01-28 09:27:53'),
(80, 80, 'QRN/2026/S000080', 1, 240, 2, NULL, 2, 2, '2026-01-28', '9-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-28 09:29:23', '2026-01-28 09:29:23'),
(81, 81, 'QRN/2026/S000081', 1, 244, 2, NULL, 2, 2, '2026-01-28', '9-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-28 11:42:07', '2026-01-28 11:42:07'),
(82, 82, 'QRN/2026/S000082', 1, 245, 7, NULL, 2, 2, '2026-01-28', '9-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-28 11:43:40', '2026-01-28 11:43:40'),
(83, 83, 'QRN/2026/S000083', 1, 247, 7, NULL, 2, 2, '2026-01-28', '9-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-28 12:05:02', '2026-01-28 12:05:02'),
(84, 84, 'QRN/2026/S000084', 1, 248, 7, NULL, 2, 2, '2026-01-28', '9-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-28 12:42:29', '2026-01-28 12:42:29'),
(85, 85, 'QRN/2026/S000085', 1, 250, 2, NULL, 2, 2, '2026-01-28', '9-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-28 13:01:52', '2026-01-28 13:01:52'),
(86, 86, 'QRN/2026/S000086', 1, 251, 2, NULL, 2, 2, '2026-01-28', '9-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-28 14:40:24', '2026-01-28 14:40:24'),
(87, 87, 'QRN/2026/S000087', 1, 252, 2, NULL, 2, 2, '2026-01-28', '9-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-28 14:41:05', '2026-01-28 14:41:05'),
(88, 88, 'QRN/2026/S000088', 1, 253, 7, NULL, 2, 2, '2026-01-28', '9-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-28 15:40:50', '2026-01-28 15:40:50'),
(89, 89, 'QRN/2026/S000089', 1, 254, 2, NULL, 2, 2, '2026-01-28', '9-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-28 15:41:56', '2026-01-28 15:41:56'),
(90, 90, 'QRN/2026/S000090', 1, 165, 2, NULL, 2, 2, '2026-01-28', '9-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-28 16:13:38', '2026-01-28 16:13:38'),
(91, 91, 'QRN/2026/S000091', 1, 256, 2, NULL, 2, 2, '2026-01-28', '9-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-28 16:44:31', '2026-01-28 16:44:31'),
(92, 92, 'QRN/2026/S000092', 1, 257, 2, NULL, 2, 2, '2026-01-28', '9-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-28 16:45:59', '2026-01-28 16:45:59'),
(93, 93, 'QRN/2026/S000093', 1, 77, 2, NULL, 2, 2, '2026-01-28', '9-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-28 20:01:56', '2026-01-28 20:01:56'),
(94, 94, 'QRN/2026/S000094', 1, 199, 2, NULL, 2, 2, '2026-01-29', '10-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-28 22:22:20', '2026-01-28 22:22:20'),
(95, 95, 'QRN/2026/S000095', 1, 260, 3, NULL, 2, 2, '2026-01-29', '10-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-29 05:18:38', '2026-01-29 05:18:38'),
(96, 96, 'QRN/2026/S000096', 1, 261, 2, NULL, 2, 2, '2026-01-29', '10-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-29 05:19:12', '2026-01-29 05:19:12'),
(97, 97, 'QRN/2026/S000097', 1, 262, 2, NULL, 2, 2, '2026-01-29', '10-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-29 05:30:03', '2026-01-29 05:30:03'),
(98, 98, 'QRN/2026/S000098', 1, 263, 2, NULL, 2, 2, '2026-01-29', '10-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-29 05:35:17', '2026-01-29 05:35:17'),
(99, 99, 'QRN/2026/S000099', 1, 264, 2, NULL, 2, 2, '2026-01-29', '10-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-29 05:43:48', '2026-01-29 05:43:48'),
(100, 100, 'QRN/2026/S000100', 1, 265, 2, NULL, 2, 2, '2026-01-29', '10-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-29 06:09:52', '2026-01-29 06:09:52'),
(101, 101, 'QRN/2026/S000101', 1, 267, 2, NULL, 2, 2, '2026-01-29', '10-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-29 06:25:46', '2026-01-29 06:25:46'),
(102, 102, 'QRN/2026/S000102', 1, 269, 2, NULL, 2, 2, '2026-01-29', '10-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-29 07:51:50', '2026-01-29 07:51:50'),
(103, 103, 'QRN/2026/S000103', 1, 236, 3, NULL, 2, 2, '2026-01-29', '10-8-1447', NULL, '[{\"method\":\"1\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-29 08:17:59', '2026-01-29 08:17:59'),
(104, 104, 'QRN/2026/S000104', 1, 270, 2, NULL, 2, 2, '2026-01-29', '10-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-29 08:20:02', '2026-01-29 08:20:02'),
(105, 105, 'QRN/2026/S000105', 1, 272, 3, NULL, 2, 2, '2026-01-29', '10-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-29 08:52:55', '2026-01-29 08:52:55'),
(106, 106, 'QRN/2026/S000106', 1, 274, 3, NULL, 2, 2, '2026-01-29', '10-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-29 09:43:17', '2026-01-29 09:43:17'),
(107, 107, 'QRN/2026/S000107', 1, 275, 7, NULL, 2, 2, '2026-01-29', '10-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-29 10:20:21', '2026-01-29 10:20:21'),
(108, 108, 'QRN/2026/S000108', 1, 277, 2, NULL, 2, 2, '2026-01-29', '10-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-29 10:49:29', '2026-01-29 10:49:29'),
(109, 109, 'QRN/2026/S000109', 1, 279, 2, NULL, 2, 2, '2026-01-29', '10-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-29 10:58:31', '2026-01-29 10:58:31'),
(110, 110, 'QRN/2026/S000110', 1, 281, 2, NULL, 2, 2, '2026-01-29', '10-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-29 11:01:25', '2026-01-29 11:01:25'),
(111, 111, 'QRN/2026/S000111', 1, 280, 7, NULL, 2, 2, '2026-01-29', '10-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-29 11:01:26', '2026-01-29 11:01:26'),
(112, 112, 'QRN/2026/S000112', 1, 282, 7, NULL, 7, 7, '2026-01-29', '10-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-29 11:26:18', '2026-01-29 11:26:18'),
(113, 113, 'QRN/2026/S000113', 1, 283, 5, NULL, 5, 5, '2026-01-29', '10-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-29 11:26:39', '2026-01-29 11:26:39'),
(114, 114, 'QRN/2026/S000114', 1, 284, 5, NULL, 5, 5, '2026-01-29', '10-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-29 11:59:21', '2026-01-29 11:59:21'),
(115, 115, 'QRN/2026/S000115', 1, 286, 7, NULL, 7, 7, '2026-01-29', '10-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-29 12:28:43', '2026-01-29 12:28:43'),
(116, 116, 'QRN/2026/S000116', 1, 287, 7, NULL, 7, 7, '2026-01-29', '10-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-29 13:12:42', '2026-01-29 13:12:42'),
(117, 117, 'QRN/2026/S000117', 1, 288, 7, NULL, 7, 7, '2026-01-29', '10-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-29 13:14:27', '2026-01-29 13:14:27'),
(118, 118, 'QRN/2026/S000118', 1, 290, 7, NULL, 7, 7, '2026-01-29', '10-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-29 13:37:41', '2026-01-29 13:37:41'),
(119, 119, 'QRN/2026/S000119', 1, 291, 7, NULL, 7, 7, '2026-01-29', '10-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-29 13:38:28', '2026-01-29 13:38:28'),
(120, 120, 'QRN/2026/S000120', 1, 291, 7, NULL, 7, 7, '2026-01-29', '10-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-29 13:38:29', '2026-01-29 13:38:29'),
(121, 121, 'QRN/2026/S000121', 1, 293, 5, NULL, 5, 5, '2026-01-29', '10-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-29 13:41:22', '2026-01-29 13:41:22'),
(122, 122, 'QRN/2026/S000122', 1, 294, 5, NULL, 5, 5, '2026-01-29', '10-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-29 13:41:59', '2026-01-29 13:41:59'),
(123, 123, 'QRN/2026/S000123', 1, 295, 2, NULL, 7, 7, '2026-01-29', '10-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-29 13:42:29', '2026-01-29 13:42:29'),
(124, 124, 'QRN/2026/S000124', 1, 144, 5, NULL, 5, 5, '2026-01-29', '10-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-29 13:43:40', '2026-01-29 13:43:40'),
(125, 125, 'QRN/2026/S000125', 1, 292, 2, NULL, 7, 7, '2026-01-29', '10-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-29 13:44:16', '2026-01-29 13:44:16'),
(126, 126, 'QRN/2026/S000126', 1, 292, 2, NULL, 7, 7, '2026-01-29', '10-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-29 13:44:16', '2026-01-29 13:44:16'),
(127, 127, 'QRN/2026/S000127', 1, 291, 7, NULL, 7, 7, '2026-01-29', '10-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-29 13:46:28', '2026-01-29 13:46:28'),
(128, 128, 'QRN/2026/S000128', 1, 296, 5, NULL, 5, 5, '2026-01-29', '10-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-29 13:54:50', '2026-01-29 13:54:50'),
(129, 129, 'QRN/2026/S000129', 1, 228, 7, NULL, 7, 7, '2026-01-29', '10-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-29 14:11:14', '2026-01-29 14:11:14'),
(130, 130, 'QRN/2026/S000130', 1, 298, 7, NULL, 7, 7, '2026-01-29', '10-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-29 14:15:45', '2026-01-29 14:15:45'),
(131, 131, 'QRN/2026/S000131', 1, 297, 5, NULL, 5, 5, '2026-01-29', '10-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-29 14:17:18', '2026-01-29 14:17:18'),
(132, 132, 'QRN/2026/S000132', 1, 299, 7, NULL, 7, 7, '2026-01-29', '10-8-1447', NULL, '[{\"method\":\"1\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-29 15:49:44', '2026-01-29 15:49:44'),
(133, 133, 'QRN/2026/S000133', 1, 165, 5, NULL, 5, 5, '2026-01-29', '10-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-29 16:18:08', '2026-01-29 16:18:08'),
(134, 134, 'QRN/2026/S000134', 1, 248, 5, NULL, 5, 5, '2026-01-29', '10-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-29 17:50:07', '2026-01-29 17:50:07'),
(135, 135, 'QRN/2026/S000135', 1, 302, 2, NULL, 2, 2, '2026-01-30', '11-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-29 22:31:49', '2026-01-29 22:31:49'),
(136, 136, 'QRN/2026/S000136', 1, 199, 2, NULL, 2, 2, '2026-01-30', '11-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-29 23:04:11', '2026-01-29 23:04:11'),
(137, 137, 'QRN/2026/S000137', 1, 303, 2, NULL, 2, 2, '2026-01-30', '11-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-29 23:31:08', '2026-01-29 23:31:08'),
(138, 138, 'QRN/2026/S000138', 1, 304, 2, NULL, 2, 2, '2026-01-30', '11-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-30 00:25:02', '2026-01-30 00:25:02'),
(139, 139, 'QRN/2026/S000139', 1, 305, 2, NULL, 2, 2, '2026-01-30', '11-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-30 01:47:44', '2026-01-30 01:47:44'),
(140, 140, 'QRN/2026/S000140', 1, 307, 3, NULL, 2, 2, '2026-01-30', '11-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-30 03:20:09', '2026-01-30 03:20:09'),
(141, 141, 'QRN/2026/S000141', 1, 306, 3, NULL, 2, 2, '2026-01-30', '11-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-30 03:21:36', '2026-01-30 03:21:36'),
(142, 142, 'QRN/2026/S000142', 1, 308, 2, NULL, 2, 2, '2026-01-30', '11-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-30 03:39:11', '2026-01-30 03:39:11'),
(143, 143, 'QRN/2026/S000143', 1, 309, 2, NULL, 2, 2, '2026-01-30', '11-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-30 07:06:22', '2026-01-30 07:06:22'),
(144, 144, 'QRN/2026/S000144', 1, 310, 2, NULL, 2, 2, '2026-01-30', '11-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-30 07:07:10', '2026-01-30 07:07:10'),
(145, 145, 'QRN/2026/S000145', 1, 311, 2, NULL, 2, 2, '2026-01-30', '11-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-30 07:07:38', '2026-01-30 07:07:38'),
(146, 146, 'QRN/2026/S000146', 1, 312, 2, NULL, 2, 2, '2026-01-30', '11-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-30 07:08:10', '2026-01-30 07:08:10'),
(147, 147, 'QRN/2026/S000147', 1, 313, 2, NULL, 2, 2, '2026-01-30', '11-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-30 07:08:36', '2026-01-30 07:08:36'),
(148, 148, 'QRN/2026/S000148', 1, 315, 3, NULL, 2, 2, '2026-01-30', '11-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-30 07:28:51', '2026-01-30 07:28:51'),
(149, 149, 'QRN/2026/S000149', 1, 317, 3, NULL, 2, 2, '2026-01-30', '11-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-30 08:02:34', '2026-01-30 08:02:34'),
(150, 150, 'QRN/2026/S000150', 1, 318, 3, NULL, 2, 2, '2026-01-30', '11-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-30 08:19:56', '2026-01-30 08:19:56'),
(151, 151, 'QRN/2026/S000151', 1, 44, 2, NULL, 2, 2, '2026-01-30', '11-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-30 08:23:41', '2026-01-30 08:23:41'),
(152, 152, 'QRN/2026/S000152', 1, 319, 2, NULL, 2, 2, '2026-01-30', '11-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-30 08:41:11', '2026-01-30 08:41:11'),
(153, 153, 'QRN/2026/S000153', 1, 320, 3, NULL, 2, 2, '2026-01-30', '11-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-30 08:50:27', '2026-01-30 08:50:27'),
(154, 154, 'QRN/2026/S000154', 1, 321, 2, NULL, 2, 2, '2026-01-30', '11-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-30 09:02:35', '2026-01-30 09:02:35'),
(155, 155, 'QRN/2026/S000155', 1, 326, 2, NULL, 2, 2, '2026-01-30', '11-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-30 09:45:11', '2026-01-30 09:45:11'),
(156, 156, 'QRN/2026/S000156', 1, 325, 2, NULL, 2, 2, '2026-01-30', '11-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-30 09:45:55', '2026-01-30 09:45:55'),
(157, 157, 'QRN/2026/S000157', 1, 324, 2, NULL, 2, 2, '2026-01-30', '11-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-30 09:46:32', '2026-01-30 09:46:32'),
(158, 158, 'QRN/2026/S000158', 1, 327, 3, NULL, 2, 2, '2026-01-30', '11-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-30 09:56:58', '2026-01-30 09:56:58'),
(159, 159, 'QRN/2026/S000159', 1, 328, 2, NULL, 2, 2, '2026-01-30', '11-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-30 09:58:28', '2026-01-30 09:58:28'),
(160, 160, 'QRN/2026/S000160', 1, 329, 2, NULL, 2, 2, '2026-01-30', '11-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-30 10:01:13', '2026-01-30 10:01:13'),
(161, 161, 'QRN/2026/S000161', 1, 330, 3, NULL, 2, 2, '2026-01-30', '11-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-30 10:01:46', '2026-01-30 10:01:46'),
(162, 162, 'QRN/2026/S000162', 1, 322, 7, NULL, 7, 7, '2026-01-30', '11-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-30 10:07:13', '2026-01-30 10:07:13'),
(163, 163, 'QRN/2026/S000163', 1, 323, 2, NULL, 7, 7, '2026-01-30', '11-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-30 10:10:10', '2026-01-30 10:10:10'),
(164, 164, 'QRN/2026/S000164', 1, 179, 5, NULL, 5, 5, '2026-01-30', '11-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-30 10:22:09', '2026-01-30 10:22:09'),
(165, 165, 'QRN/2026/S000165', 1, 286, 7, NULL, 7, 7, '2026-01-30', '11-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-30 10:43:11', '2026-01-30 10:43:11'),
(166, 166, 'QRN/2026/S000166', 1, 282, 5, NULL, 5, 5, '2026-01-30', '11-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-30 10:45:45', '2026-01-30 10:45:45'),
(167, 167, 'QRN/2026/S000167', 1, 134, 7, NULL, 7, 7, '2026-01-30', '11-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-30 10:52:12', '2026-01-30 10:52:12'),
(168, 168, 'QRN/2026/S000168', 1, 283, 7, NULL, 7, 7, '2026-01-30', '11-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-30 10:55:27', '2026-01-30 10:55:27'),
(169, 169, 'QRN/2026/S000169', 1, 331, 7, NULL, 7, 7, '2026-01-30', '11-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-30 11:07:41', '2026-01-30 11:07:41'),
(170, 170, 'QRN/2026/S000170', 1, 100, 7, NULL, 7, 7, '2026-01-30', '11-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-30 11:08:39', '2026-01-30 11:08:39'),
(171, 171, 'QRN/2026/S000171', 1, 332, 7, NULL, 7, 7, '2026-01-30', '11-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-30 11:14:45', '2026-01-30 11:14:45'),
(172, 172, 'QRN/2026/S000172', 1, 334, 7, NULL, 7, 7, '2026-01-30', '11-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-30 12:42:56', '2026-01-30 12:42:56'),
(173, 173, 'QRN/2026/S000173', 1, 335, 7, NULL, 7, 7, '2026-01-30', '11-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-30 13:12:50', '2026-01-30 13:12:50'),
(174, 174, 'QRN/2026/S000174', 1, 336, 5, NULL, 5, 5, '2026-01-30', '11-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-30 13:39:36', '2026-01-30 13:39:36'),
(175, 175, 'QRN/2026/S000175', 1, 337, 7, NULL, 7, 7, '2026-01-30', '11-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-30 13:55:20', '2026-01-30 13:55:20'),
(176, 176, 'QRN/2026/S000176', 1, 338, 5, NULL, 5, 5, '2026-01-30', '11-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-30 13:56:39', '2026-01-30 13:56:39'),
(177, 177, 'QRN/2026/S000177', 1, 339, 7, NULL, 7, 7, '2026-01-30', '11-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-30 14:25:56', '2026-01-30 14:25:56'),
(178, 178, 'QRN/2026/S000178', 1, 340, 5, NULL, 5, 5, '2026-01-30', '11-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-30 16:56:24', '2026-01-30 16:56:24'),
(179, 179, 'QRN/2026/S000179', 1, 341, 5, NULL, 5, 5, '2026-01-30', '11-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-30 16:57:03', '2026-01-30 16:57:03'),
(180, 180, 'QRN/2026/S000180', 1, 342, 5, NULL, 5, 5, '2026-01-30', '11-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-30 16:59:00', '2026-01-30 16:59:00'),
(181, 181, 'QRN/2026/S000181', 1, 343, 5, NULL, 5, 5, '2026-01-30', '11-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-30 16:59:54', '2026-01-30 16:59:54'),
(182, 182, 'QRN/2026/S000182', 1, 344, 5, NULL, 5, 5, '2026-01-30', '11-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-30 17:10:06', '2026-01-30 17:10:06'),
(183, 183, 'QRN/2026/S000183', 1, 199, 5, NULL, 5, 5, '2026-01-31', '12-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-30 23:24:11', '2026-01-30 23:24:11'),
(184, 184, 'QRN/2026/S000184', 1, 346, 5, NULL, 5, 5, '2026-01-31', '12-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-30 23:30:49', '2026-01-30 23:30:49'),
(185, 185, 'QRN/2026/S000185', 1, 347, 5, NULL, 5, 5, '2026-01-31', '12-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-30 23:31:20', '2026-01-30 23:31:20'),
(186, 186, 'QRN/2026/S000186', 1, 348, 5, NULL, 5, 5, '2026-01-31', '12-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-31 02:40:06', '2026-01-31 02:40:06'),
(187, 187, 'QRN/2026/S000187', 1, 349, 5, NULL, 5, 5, '2026-01-31', '12-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-31 02:41:00', '2026-01-31 02:41:00'),
(188, 188, 'QRN/2026/S000188', 1, 351, 5, NULL, 5, 5, '2026-01-31', '12-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-31 04:09:34', '2026-01-31 04:09:34'),
(189, 189, 'QRN/2026/S000189', 1, 350, 3, NULL, 5, 5, '2026-01-31', '12-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-31 04:10:06', '2026-01-31 04:10:06'),
(190, 190, 'QRN/2026/S000190', 1, 352, 5, NULL, 5, 5, '2026-01-31', '12-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-31 04:16:31', '2026-01-31 04:16:31'),
(191, 191, 'QRN/2026/S000191', 1, 353, 3, NULL, 5, 5, '2026-01-31', '12-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-31 04:43:16', '2026-01-31 04:43:16'),
(192, 192, 'QRN/2026/S000192', 1, 354, 3, NULL, 5, 5, '2026-01-31', '12-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-31 06:45:47', '2026-01-31 06:45:47'),
(193, 193, 'QRN/2026/S000193', 1, 355, 3, NULL, 5, 5, '2026-01-31', '12-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-31 07:45:55', '2026-01-31 07:45:55'),
(194, 194, 'QRN/2026/S000194', 1, 356, 3, NULL, 5, 5, '2026-01-31', '12-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-31 08:11:49', '2026-01-31 08:11:49'),
(195, 195, 'QRN/2026/S000195', 1, 357, 3, NULL, 5, 5, '2026-01-31', '12-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-31 09:05:15', '2026-01-31 09:05:15'),
(196, 196, 'QRN/2026/S000196', 1, 236, 5, NULL, 5, 5, '2026-01-31', '12-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-31 09:24:27', '2026-01-31 09:24:27'),
(197, 197, 'QRN/2026/S000197', 1, 359, 3, NULL, 5, 5, '2026-01-31', '12-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-31 09:30:07', '2026-01-31 09:30:07'),
(198, 198, 'QRN/2026/S000198', 1, 358, 3, NULL, 5, 5, '2026-01-31', '12-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-31 09:30:27', '2026-01-31 09:30:27'),
(199, 199, 'QRN/2026/S000199', 1, 360, 3, NULL, 5, 5, '2026-01-31', '12-8-1447', NULL, '[{\"method\":\"5\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-31 09:36:21', '2026-01-31 09:36:21'),
(200, 200, 'QRN/2026/S000200', 1, 361, 5, NULL, 5, 5, '2026-01-31', '12-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-31 10:28:58', '2026-01-31 10:28:58'),
(201, 201, 'QRN/2026/S000201', 1, 362, 5, NULL, 5, 5, '2026-01-31', '12-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-31 10:29:24', '2026-01-31 10:29:24'),
(202, 202, 'QRN/2026/S000202', 1, 363, 5, NULL, 5, 5, '2026-01-31', '12-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-31 10:39:07', '2026-01-31 10:39:07'),
(203, 203, 'QRN/2026/S000203', 1, 364, 5, NULL, 5, 5, '2026-01-31', '12-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-31 10:39:34', '2026-01-31 10:39:34'),
(204, 204, 'QRN/2026/S000204', 1, 224, 5, NULL, 5, 5, '2026-01-31', '12-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-31 10:48:05', '2026-01-31 10:48:05'),
(205, 205, 'QRN/2026/S000205', 1, 365, 5, NULL, 5, 5, '2026-01-31', '12-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-31 11:22:27', '2026-01-31 11:22:27'),
(206, 206, 'QRN/2026/S000206', 1, 366, 5, NULL, 5, 5, '2026-01-31', '12-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-31 11:23:12', '2026-01-31 11:23:12'),
(207, 207, 'QRN/2026/S000207', 1, 370, 5, NULL, 5, 5, '2026-01-31', '12-8-1447', NULL, '[{\"method\":\"4\",\"amount\":\"149.50\"}]', 130.00, 0.00, 19.50, 149.50, '2026-01-31 11:36:04', '2026-01-31 11:36:04');

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

--
-- بنية الجدول `service_invoice_items`
--

CREATE TABLE `service_invoice_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `service_invoice_id` bigint(20) UNSIGNED NOT NULL,
  `type` enum('service','offer') DEFAULT NULL,
  `service_id` bigint(20) UNSIGNED DEFAULT NULL,
  `offer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `offer_service_id` bigint(20) UNSIGNED DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `qty` int(10) UNSIGNED DEFAULT 1,
  `price` decimal(10,2) DEFAULT 0.00,
  `discount` decimal(10,2) DEFAULT 0.00,
  `tax` decimal(10,2) DEFAULT 0.00,
  `total` decimal(10,2) DEFAULT 0.00,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- إرجاع أو استيراد بيانات الجدول `service_invoice_items`
--

INSERT INTO `service_invoice_items` (`id`, `service_invoice_id`, `type`, `service_id`, `offer_id`, `offer_service_id`, `description`, `qty`, `price`, `discount`, `tax`, `total`, `created_at`, `updated_at`) VALUES
(1, 1, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-24 17:52:25', '2026-01-24 17:52:25'),
(2, 2, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-24 19:05:35', '2026-01-24 19:05:35'),
(3, 3, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-24 19:16:29', '2026-01-24 19:16:29'),
(4, 4, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-24 21:24:01', '2026-01-24 21:24:01'),
(5, 5, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-25 03:12:46', '2026-01-25 03:12:46'),
(6, 6, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-25 03:16:10', '2026-01-25 03:16:10'),
(7, 7, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-25 04:43:44', '2026-01-25 04:43:44'),
(8, 8, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-25 05:00:01', '2026-01-25 05:00:01'),
(9, 9, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-25 06:55:11', '2026-01-25 06:55:11'),
(10, 10, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-25 07:34:44', '2026-01-25 07:34:44'),
(11, 11, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-25 08:08:56', '2026-01-25 08:08:56'),
(12, 12, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-25 08:57:37', '2026-01-25 08:57:37'),
(13, 13, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-25 09:06:47', '2026-01-25 09:06:47'),
(14, 14, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-25 09:37:55', '2026-01-25 09:37:55'),
(15, 15, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-25 10:05:06', '2026-01-25 10:05:06'),
(16, 16, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-25 11:27:11', '2026-01-25 11:27:11'),
(17, 17, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-25 12:35:22', '2026-01-25 12:35:22'),
(18, 18, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-25 12:57:25', '2026-01-25 12:57:25'),
(19, 19, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-25 13:48:55', '2026-01-25 13:48:55'),
(20, 20, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-25 14:00:39', '2026-01-25 14:00:39'),
(21, 21, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-25 15:01:51', '2026-01-25 15:01:51'),
(22, 22, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-25 15:41:09', '2026-01-25 15:41:09'),
(23, 23, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-26 03:18:14', '2026-01-26 03:18:14'),
(24, 24, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-26 04:19:17', '2026-01-26 04:19:17'),
(25, 25, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-26 05:42:13', '2026-01-26 05:42:13'),
(26, 26, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-26 05:44:10', '2026-01-26 05:44:10'),
(27, 27, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-26 05:49:38', '2026-01-26 05:49:38'),
(28, 28, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-26 07:34:07', '2026-01-26 07:34:07'),
(29, 29, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-26 07:35:37', '2026-01-26 07:35:37'),
(30, 30, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-26 08:46:59', '2026-01-26 08:46:59'),
(31, 31, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-26 09:13:33', '2026-01-26 09:13:33'),
(32, 32, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-26 09:16:52', '2026-01-26 09:16:52'),
(33, 33, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-26 09:58:45', '2026-01-26 09:58:45'),
(34, 34, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-26 10:52:47', '2026-01-26 10:52:47'),
(35, 35, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-26 11:45:09', '2026-01-26 11:45:09'),
(36, 36, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-26 12:38:09', '2026-01-26 12:38:09'),
(37, 37, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-26 13:14:32', '2026-01-26 13:14:32'),
(38, 38, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-26 13:33:51', '2026-01-26 13:33:51'),
(39, 39, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-26 13:34:36', '2026-01-26 13:34:36'),
(40, 40, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-26 13:38:56', '2026-01-26 13:38:56'),
(41, 41, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-26 14:26:10', '2026-01-26 14:26:10'),
(42, 42, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-26 15:22:59', '2026-01-26 15:22:59'),
(43, 43, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-26 17:20:57', '2026-01-26 17:20:57'),
(44, 44, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-26 22:51:22', '2026-01-26 22:51:22'),
(45, 45, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-27 00:39:56', '2026-01-27 00:39:56'),
(46, 46, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-27 04:42:20', '2026-01-27 04:42:20'),
(47, 47, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-27 05:15:37', '2026-01-27 05:15:37'),
(48, 48, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-27 05:26:45', '2026-01-27 05:26:45'),
(49, 49, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-27 07:50:21', '2026-01-27 07:50:21'),
(50, 50, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-27 08:05:24', '2026-01-27 08:05:24'),
(51, 51, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-27 08:09:39', '2026-01-27 08:09:39'),
(52, 52, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-27 08:26:49', '2026-01-27 08:26:49'),
(53, 53, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-27 08:34:34', '2026-01-27 08:34:34'),
(54, 54, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-27 09:17:58', '2026-01-27 09:17:58'),
(55, 55, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-27 09:29:11', '2026-01-27 09:29:11'),
(56, 56, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-27 09:29:50', '2026-01-27 09:29:50'),
(57, 57, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-27 10:50:36', '2026-01-27 10:50:36'),
(58, 58, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-27 11:06:43', '2026-01-27 11:06:43'),
(59, 59, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-27 12:08:41', '2026-01-27 12:08:41'),
(60, 60, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-27 12:32:28', '2026-01-27 12:32:28'),
(61, 61, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-27 12:38:57', '2026-01-27 12:38:57'),
(62, 62, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-27 13:26:52', '2026-01-27 13:26:52'),
(63, 63, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-27 13:40:31', '2026-01-27 13:40:31'),
(64, 64, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-27 14:16:28', '2026-01-27 14:16:28'),
(65, 65, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-27 18:06:58', '2026-01-27 18:06:58'),
(66, 66, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-27 18:07:48', '2026-01-27 18:07:48'),
(67, 67, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-28 03:35:28', '2026-01-28 03:35:28'),
(68, 68, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-28 03:51:16', '2026-01-28 03:51:16'),
(69, 69, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-28 04:08:41', '2026-01-28 04:08:41'),
(70, 70, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-28 04:09:37', '2026-01-28 04:09:37'),
(71, 71, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-28 04:58:12', '2026-01-28 04:58:12'),
(72, 72, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-28 06:22:02', '2026-01-28 06:22:02'),
(73, 73, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-28 06:23:14', '2026-01-28 06:23:14'),
(74, 74, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-28 06:46:31', '2026-01-28 06:46:31'),
(75, 75, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-28 09:10:13', '2026-01-28 09:10:13'),
(76, 76, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-28 09:10:18', '2026-01-28 09:10:18'),
(77, 77, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-28 09:23:32', '2026-01-28 09:23:32'),
(78, 78, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-28 09:26:19', '2026-01-28 09:26:19'),
(79, 79, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-28 09:27:53', '2026-01-28 09:27:53'),
(80, 80, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-28 09:29:23', '2026-01-28 09:29:23'),
(81, 81, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-28 11:42:07', '2026-01-28 11:42:07'),
(82, 82, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-28 11:43:40', '2026-01-28 11:43:40'),
(83, 83, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-28 12:05:02', '2026-01-28 12:05:02'),
(84, 84, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-28 12:42:29', '2026-01-28 12:42:29'),
(85, 85, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-28 13:01:52', '2026-01-28 13:01:52'),
(86, 86, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-28 14:40:24', '2026-01-28 14:40:24'),
(87, 87, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-28 14:41:05', '2026-01-28 14:41:05'),
(88, 88, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-28 15:40:50', '2026-01-28 15:40:50'),
(89, 89, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-28 15:41:56', '2026-01-28 15:41:56'),
(90, 90, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-28 16:13:38', '2026-01-28 16:13:38'),
(91, 91, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-28 16:44:31', '2026-01-28 16:44:31'),
(92, 92, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-28 16:45:59', '2026-01-28 16:45:59'),
(93, 93, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-28 20:01:56', '2026-01-28 20:01:56'),
(94, 94, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-28 22:22:20', '2026-01-28 22:22:20'),
(95, 95, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-29 05:18:38', '2026-01-29 05:18:38'),
(96, 96, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-29 05:19:12', '2026-01-29 05:19:12'),
(97, 97, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-29 05:30:03', '2026-01-29 05:30:03'),
(98, 98, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-29 05:35:17', '2026-01-29 05:35:17'),
(99, 99, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-29 05:43:48', '2026-01-29 05:43:48'),
(100, 100, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-29 06:09:52', '2026-01-29 06:09:52'),
(101, 101, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-29 06:25:46', '2026-01-29 06:25:46'),
(102, 102, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-29 07:51:50', '2026-01-29 07:51:50'),
(103, 103, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-29 08:17:59', '2026-01-29 08:17:59'),
(104, 104, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-29 08:20:02', '2026-01-29 08:20:02'),
(105, 105, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-29 08:52:55', '2026-01-29 08:52:55'),
(106, 106, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-29 09:43:17', '2026-01-29 09:43:17'),
(107, 107, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-29 10:20:21', '2026-01-29 10:20:21'),
(108, 108, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-29 10:49:29', '2026-01-29 10:49:29'),
(109, 109, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-29 10:58:31', '2026-01-29 10:58:31'),
(110, 110, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-29 11:01:25', '2026-01-29 11:01:25'),
(111, 111, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-29 11:01:26', '2026-01-29 11:01:26'),
(112, 112, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-29 11:26:18', '2026-01-29 11:26:18'),
(113, 113, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-29 11:26:39', '2026-01-29 11:26:39'),
(114, 114, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-29 11:59:21', '2026-01-29 11:59:21'),
(115, 115, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-29 12:28:43', '2026-01-29 12:28:43'),
(116, 116, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-29 13:12:42', '2026-01-29 13:12:42'),
(117, 117, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-29 13:14:27', '2026-01-29 13:14:27'),
(118, 118, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-29 13:37:41', '2026-01-29 13:37:41'),
(119, 119, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-29 13:38:28', '2026-01-29 13:38:28'),
(120, 120, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-29 13:38:29', '2026-01-29 13:38:29'),
(121, 121, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-29 13:41:22', '2026-01-29 13:41:22'),
(122, 122, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-29 13:41:59', '2026-01-29 13:41:59'),
(123, 123, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-29 13:42:29', '2026-01-29 13:42:29'),
(124, 124, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-29 13:43:40', '2026-01-29 13:43:40'),
(125, 125, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-29 13:44:16', '2026-01-29 13:44:16'),
(126, 126, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-29 13:44:16', '2026-01-29 13:44:16'),
(127, 127, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-29 13:46:28', '2026-01-29 13:46:28'),
(128, 128, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-29 13:54:50', '2026-01-29 13:54:50'),
(129, 129, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-29 14:11:14', '2026-01-29 14:11:14'),
(130, 130, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-29 14:15:45', '2026-01-29 14:15:45'),
(131, 131, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-29 14:17:18', '2026-01-29 14:17:18'),
(132, 132, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-29 15:49:44', '2026-01-29 15:49:44'),
(133, 133, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-29 16:18:08', '2026-01-29 16:18:08'),
(134, 134, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-29 17:50:07', '2026-01-29 17:50:07'),
(135, 135, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-29 22:31:49', '2026-01-29 22:31:49'),
(136, 136, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-29 23:04:11', '2026-01-29 23:04:11'),
(137, 137, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-29 23:31:08', '2026-01-29 23:31:08'),
(138, 138, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-30 00:25:02', '2026-01-30 00:25:02'),
(139, 139, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-30 01:47:44', '2026-01-30 01:47:44'),
(140, 140, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-30 03:20:09', '2026-01-30 03:20:09'),
(141, 141, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-30 03:21:36', '2026-01-30 03:21:36'),
(142, 142, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-30 03:39:11', '2026-01-30 03:39:11'),
(143, 143, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-30 07:06:22', '2026-01-30 07:06:22'),
(144, 144, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-30 07:07:10', '2026-01-30 07:07:10'),
(145, 145, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-30 07:07:38', '2026-01-30 07:07:38'),
(146, 146, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-30 07:08:10', '2026-01-30 07:08:10'),
(147, 147, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-30 07:08:36', '2026-01-30 07:08:36'),
(148, 148, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-30 07:28:51', '2026-01-30 07:28:51'),
(149, 149, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-30 08:02:34', '2026-01-30 08:02:34'),
(150, 150, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-30 08:19:56', '2026-01-30 08:19:56'),
(151, 151, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-30 08:23:41', '2026-01-30 08:23:41'),
(152, 152, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-30 08:41:11', '2026-01-30 08:41:11'),
(153, 153, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-30 08:50:27', '2026-01-30 08:50:27'),
(154, 154, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-30 09:02:35', '2026-01-30 09:02:35'),
(155, 155, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-30 09:45:11', '2026-01-30 09:45:11'),
(156, 156, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-30 09:45:55', '2026-01-30 09:45:55'),
(157, 157, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-30 09:46:32', '2026-01-30 09:46:32'),
(158, 158, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-30 09:56:58', '2026-01-30 09:56:58'),
(159, 159, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-30 09:58:28', '2026-01-30 09:58:28'),
(160, 160, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-30 10:01:13', '2026-01-30 10:01:13'),
(161, 161, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-30 10:01:46', '2026-01-30 10:01:46'),
(162, 162, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-30 10:07:13', '2026-01-30 10:07:13'),
(163, 163, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-30 10:10:10', '2026-01-30 10:10:10'),
(164, 164, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-30 10:22:09', '2026-01-30 10:22:09'),
(165, 165, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-30 10:43:11', '2026-01-30 10:43:11'),
(166, 166, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-30 10:45:45', '2026-01-30 10:45:45'),
(167, 167, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-30 10:52:12', '2026-01-30 10:52:12'),
(168, 168, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-30 10:55:27', '2026-01-30 10:55:27'),
(169, 169, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-30 11:07:41', '2026-01-30 11:07:41'),
(170, 170, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-30 11:08:39', '2026-01-30 11:08:39'),
(171, 171, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-30 11:14:45', '2026-01-30 11:14:45'),
(172, 172, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-30 12:42:56', '2026-01-30 12:42:56'),
(173, 173, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-30 13:12:50', '2026-01-30 13:12:50'),
(174, 174, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-30 13:39:36', '2026-01-30 13:39:36'),
(175, 175, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-30 13:55:20', '2026-01-30 13:55:20'),
(176, 176, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-30 13:56:39', '2026-01-30 13:56:39'),
(177, 177, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-30 14:25:56', '2026-01-30 14:25:56'),
(178, 178, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-30 16:56:24', '2026-01-30 16:56:24'),
(179, 179, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-30 16:57:03', '2026-01-30 16:57:03'),
(180, 180, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-30 16:59:00', '2026-01-30 16:59:00'),
(181, 181, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-30 16:59:54', '2026-01-30 16:59:54'),
(182, 182, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-30 17:10:06', '2026-01-30 17:10:06'),
(183, 183, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-30 23:24:11', '2026-01-30 23:24:11'),
(184, 184, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-30 23:30:49', '2026-01-30 23:30:49'),
(185, 185, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-30 23:31:20', '2026-01-30 23:31:20'),
(186, 186, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-31 02:40:06', '2026-01-31 02:40:06'),
(187, 187, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-31 02:41:00', '2026-01-31 02:41:00'),
(188, 188, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-31 04:09:34', '2026-01-31 04:09:34'),
(189, 189, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-31 04:10:06', '2026-01-31 04:10:06'),
(190, 190, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-31 04:16:31', '2026-01-31 04:16:31'),
(191, 191, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-31 04:43:16', '2026-01-31 04:43:16'),
(192, 192, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-31 06:45:47', '2026-01-31 06:45:47'),
(193, 193, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-31 07:45:55', '2026-01-31 07:45:55'),
(194, 194, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-31 08:11:49', '2026-01-31 08:11:49'),
(195, 195, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-31 09:05:15', '2026-01-31 09:05:15'),
(196, 196, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-31 09:24:27', '2026-01-31 09:24:27'),
(197, 197, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-31 09:30:07', '2026-01-31 09:30:07'),
(198, 198, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-31 09:30:27', '2026-01-31 09:30:27'),
(199, 199, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-31 09:36:21', '2026-01-31 09:36:21'),
(200, 200, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-31 10:28:58', '2026-01-31 10:28:58'),
(201, 201, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-31 10:29:24', '2026-01-31 10:29:24'),
(202, 202, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-31 10:39:07', '2026-01-31 10:39:07'),
(203, 203, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-31 10:39:34', '2026-01-31 10:39:34'),
(204, 204, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-31 10:48:05', '2026-01-31 10:48:05'),
(205, 205, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-31 11:22:27', '2026-01-31 11:22:27'),
(206, 206, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-31 11:23:12', '2026-01-31 11:23:12'),
(207, 207, NULL, 4, NULL, NULL, 'اشتراك يومي', 1, 130.00, 0.00, 19.50, 149.50, '2026-01-31 11:36:04', '2026-01-31 11:36:04');

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

--
-- بنية الجدول `service_types`
--

CREATE TABLE `service_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`name`)),
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`description`)),
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- إرجاع أو استيراد بيانات الجدول `service_types`
--

INSERT INTO `service_types` (`id`, `name`, `description`, `active`, `created_at`, `updated_at`) VALUES
(1, '{\"en\":\"Membership\",\"ar\":\"عضوية\"}', '{\"en\":\"Perferendis itaque o\",\"ar\":\"Cupiditate ut tenetu\"}', 1, '2025-10-22 03:31:25', '2025-11-17 01:53:08'),
(2, '{\"en\":\"Cards\",\"ar\":\"بطاقات\"}', '{\"en\":\"General Memberships\",\"ar\":\"الاشتراكات العامة\"}', 1, '2025-10-23 06:32:01', '2025-11-17 01:52:54'),
(3, '{\"en\":\"Services\",\"ar\":\"خدمات\"}', '{\"en\":\"Personal Trainning Memberships\",\"ar\":\"اشتراكات التدريب الشخصي\"}', 1, '2025-10-23 06:33:21', '2025-11-17 01:54:19'),
(4, '{\"en\":\"Additional Features\",\"ar\":\"ميزات إضافية\"}', '{\"en\":\"Swimming Pool Personal Trainning\",\"ar\":\"اشتراكات السباحة\"}', 1, '2025-10-23 06:34:34', '2025-11-17 01:55:22');

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

--
-- بنية الجدول `states`
--

CREATE TABLE `states` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`name`)),
  `country_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- إرجاع أو استيراد بيانات الجدول `states`
--

INSERT INTO `states` (`id`, `name`, `country_id`, `created_at`, `updated_at`) VALUES
(1, '{\"ar\":\"القاهرة\",\"en\":\"Cairo\"}', 1, '2025-10-19 04:46:20', '2025-10-19 04:46:20'),
(2, '{\"ar\":\"الإسكندرية\",\"en\":\"Alexandria\"}', 1, '2025-10-19 04:46:20', '2025-10-19 04:46:20'),
(3, '{\"ar\":\"الجيزة\",\"en\":\"Giza\"}', 1, '2025-10-19 04:46:20', '2025-10-19 04:46:20'),
(4, '{\"ar\":\"الرياض\",\"en\":\"Riyadh\"}', 2, '2025-10-19 04:46:20', '2025-10-19 04:46:20'),
(5, '{\"ar\":\"جدة\",\"en\":\"Jeddah\"}', 2, '2025-10-19 04:46:21', '2025-10-19 04:46:21'),
(6, '{\"ar\":\"مكة\",\"en\":\"Mecca\"}', 2, '2025-10-19 04:46:21', '2025-10-19 04:46:21'),
(7, '{\"ar\":\"دبي\",\"en\":\"Dubai\"}', 3, '2025-10-19 04:46:21', '2025-10-19 04:46:21'),
(8, '{\"ar\":\"أبوظبي\",\"en\":\"Abu Dhabi\"}', 3, '2025-10-19 04:46:21', '2025-10-19 04:46:21'),
(9, '{\"ar\":\"الشارقة\",\"en\":\"Sharjah\"}', 3, '2025-10-19 04:46:21', '2025-10-19 04:46:21'),
(10, '{\"ar\":\"مسقط\",\"en\":\"Muscat\"}', 11, '2025-10-19 04:46:22', '2025-10-19 04:46:22'),
(11, '{\"ar\":\"ظفار\",\"en\":\"Dhofar\"}', 11, '2025-10-19 04:46:22', '2025-10-19 04:46:22'),
(12, '{\"ar\":\"الباطنة شمال\",\"en\":\"North Batinah\"}', 11, '2025-10-19 04:46:22', '2025-10-19 04:46:22'),
(13, '{\"ar\":\"الدوحة\",\"en\":\"Doha\"}', 12, '2025-10-19 04:46:22', '2025-10-19 04:46:22'),
(14, '{\"ar\":\"الريان\",\"en\":\"Al Rayyan\"}', 12, '2025-10-19 04:46:22', '2025-10-19 04:46:22'),
(15, '{\"ar\":\"الخور\",\"en\":\"Al Khor\"}', 12, '2025-10-19 04:46:23', '2025-10-19 04:46:23'),
(16, '{\"ar\":\"المنامة\",\"en\":\"Manama\"}', 13, '2025-10-19 04:46:23', '2025-10-19 04:46:23'),
(17, '{\"ar\":\"المحرق\",\"en\":\"Muharraq\"}', 13, '2025-10-19 04:46:23', '2025-10-19 04:46:23'),
(18, '{\"ar\":\"رام الله\",\"en\":\"Ramallah\"}', 14, '2025-10-19 04:46:23', '2025-10-19 04:46:23'),
(19, '{\"ar\":\"غزة\",\"en\":\"Gaza\"}', 14, '2025-10-19 04:46:23', '2025-10-19 04:46:23'),
(20, '{\"ar\":\"دمشق\",\"en\":\"Damascus\"}', 15, '2025-10-19 04:46:23', '2025-10-19 04:46:23'),
(21, '{\"ar\":\"حلب\",\"en\":\"Aleppo\"}', 15, '2025-10-19 04:46:23', '2025-10-19 04:46:23'),
(22, '{\"ar\":\"صنعاء\",\"en\":\"Sanaa\"}', 16, '2025-10-19 04:46:23', '2025-10-19 04:46:23'),
(23, '{\"ar\":\"عدن\",\"en\":\"Aden\"}', 16, '2025-10-19 04:46:23', '2025-10-19 04:46:23');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `branches`
--
ALTER TABLE `branches`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `branches_branch_code_unique` (`branch_code`),
  ADD KEY `branches_branch_category_id_foreign` (`branch_category_id`),
  ADD KEY `branches_branch_type_id_foreign` (`branch_type_id`),
  ADD KEY `branches_city_id_foreign` (`city_id`);

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

--
-- Indexes for table `branch_monthly_goals`
--
ALTER TABLE `branch_monthly_goals`
  ADD PRIMARY KEY (`id`),
  ADD KEY `branch_monthly_goals_branch_id_foreign` (`branch_id`);

--
-- Indexes for table `branch_service_provided`
--
ALTER TABLE `branch_service_provided`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `branch_service_provided_service_id_branch_id_unique` (`service_id`,`branch_id`),
  ADD KEY `branch_service_provided_branch_id_foreign` (`branch_id`);

--
-- Indexes for table `branch_service_sold`
--
ALTER TABLE `branch_service_sold`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `branch_service_sold_service_id_branch_id_unique` (`service_id`,`branch_id`),
  ADD KEY `branch_service_sold_branch_id_foreign` (`branch_id`);

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

--
-- Indexes for table `cities`
--
ALTER TABLE `cities`
  ADD PRIMARY KEY (`id`),
  ADD KEY `cities_state_id_foreign` (`state_id`);

--
-- Indexes for table `company_settings`
--
ALTER TABLE `company_settings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `company_settings_country_id_foreign` (`country_id`);

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

--
-- Indexes for table `customers`
--
ALTER TABLE `customers`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `customers_customer_code_unique` (`customer_code`),
  ADD KEY `customers_branch_id_foreign` (`branch_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 `member_payments`
--
ALTER TABLE `member_payments`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `member_payments_merchant_tx_unique` (`merchant_transaction_id`),
  ADD KEY `member_payments_member_status` (`member_id`,`status`),
  ADD KEY `member_payments_item` (`item_type`,`item_id`);

--
-- Indexes for table `member_sequences`
--
ALTER TABLE `member_sequences`
  ADD PRIMARY KEY (`branch_id`);

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

--
-- Indexes for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  ADD KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`);

--
-- Indexes for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  ADD KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`);

--
-- Indexes for table `offers`
--
ALTER TABLE `offers`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `offers_offer_no_unique` (`offer_no`);

--
-- Indexes for table `offer_items`
--
ALTER TABLE `offer_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `offer_items_offer_id_foreign` (`offer_id`),
  ADD KEY `offer_items_service_id_foreign` (`service_id`);

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

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `perm_name_guard_branch_unique` (`name`,`guard_name`,`branch_id`),
  ADD KEY `permissions_branch_id_foreign` (`branch_id`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`);

--
-- Indexes for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`role_id`),
  ADD KEY `role_has_permissions_role_id_foreign` (`role_id`);

--
-- Indexes for table `services`
--
ALTER TABLE `services`
  ADD PRIMARY KEY (`id`),
  ADD KEY `services_service_category_id_foreign` (`service_category_id`),
  ADD KEY `services_service_type_id_foreign` (`service_type_id`);

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

--
-- Indexes for table `service_invoices`
--
ALTER TABLE `service_invoices`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `document_no` (`document_no`),
  ADD UNIQUE KEY `invoice_no` (`invoice_no`),
  ADD KEY `service_invoices_branch_id_foreign` (`branch_id`),
  ADD KEY `service_invoices_member_id_foreign` (`member_id`),
  ADD KEY `service_invoices_provider_id_foreign` (`provider_user_id`),
  ADD KEY `service_invoices_service_user_id_foreign` (`service_user_id`),
  ADD KEY `service_invoices_created_by_foreign` (`created_by`),
  ADD KEY `service_invoices_account_user_id_foreign` (`account_user_id`);

--
-- Indexes for table `service_invoice_items`
--
ALTER TABLE `service_invoice_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `invoice_items_invoice_id_fk` (`service_invoice_id`),
  ADD KEY `invoice_items_service_id_fk` (`service_id`),
  ADD KEY `invoice_items_offer_id_fk` (`offer_id`);

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

--
-- Indexes for table `states`
--
ALTER TABLE `states`
  ADD PRIMARY KEY (`id`),
  ADD KEY `states_country_id_foreign` (`country_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `branches`
--
ALTER TABLE `branches`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `branch_categories`
--
ALTER TABLE `branch_categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

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

--
-- AUTO_INCREMENT for table `branch_service_provided`
--
ALTER TABLE `branch_service_provided`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `branch_service_sold`
--
ALTER TABLE `branch_service_sold`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `branch_types`
--
ALTER TABLE `branch_types`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `cities`
--
ALTER TABLE `cities`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `company_settings`
--
ALTER TABLE `company_settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `countries`
--
ALTER TABLE `countries`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `customers`
--
ALTER TABLE `customers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

--
-- AUTO_INCREMENT for table `member_payments`
--
ALTER TABLE `member_payments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `offers`
--
ALTER TABLE `offers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `offer_items`
--
ALTER TABLE `offer_items`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `payment_methods`
--
ALTER TABLE `payment_methods`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `services`
--
ALTER TABLE `services`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `service_categories`
--
ALTER TABLE `service_categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `service_invoices`
--
ALTER TABLE `service_invoices`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=208;

--
-- AUTO_INCREMENT for table `service_invoice_items`
--
ALTER TABLE `service_invoice_items`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=208;

--
-- AUTO_INCREMENT for table `service_types`
--
ALTER TABLE `service_types`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `states`
--
ALTER TABLE `states`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- قيود الجداول المُلقاة.
--

--
-- قيود الجداول `branches`
--
ALTER TABLE `branches`
  ADD CONSTRAINT `branches_branch_category_id_foreign` FOREIGN KEY (`branch_category_id`) REFERENCES `branch_categories` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `branches_branch_type_id_foreign` FOREIGN KEY (`branch_type_id`) REFERENCES `branch_types` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `branches_city_id_foreign` FOREIGN KEY (`city_id`) REFERENCES `states` (`id`) ON DELETE CASCADE;

--
-- قيود الجداول `branch_monthly_goals`
--
ALTER TABLE `branch_monthly_goals`
  ADD CONSTRAINT `branch_monthly_goals_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE CASCADE;

--
-- قيود الجداول `member_payments`
--
ALTER TABLE `member_payments`
  ADD CONSTRAINT `member_payments_member_fk` FOREIGN KEY (`member_id`) REFERENCES `members` (`id`) ON DELETE CASCADE;
COMMIT;

