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

START TRANSACTION;



--
-- Database: `shapooov_pioneer`
--

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

--
-- بنية الجدول `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`)),
  `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`, `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-Safa Branch\"}', 1, 2, 5, '0559136671', '[{\"label\":{\"ar\":\"\\u0647\\u0627\\u062a\\u0641 \\u0627\\u0644\\u0646\\u0627\\u062f\\u064a\",\"en\":\"Mobile Club\"},\"number\":\"0559136671\"}]', 1, '{\"full\":{\"ar\":\"\\u062c\\u062f\\u0629\",\"en\":null},\"short\":{\"ar\":\"\\u062d\\u064a \\u0627\\u0644\\u0635\\u0641\\u0627\",\"en\":null},\"street\":{\"ar\":\"\\u0634\\u0627\\u0631\\u0639 \\u0627\\u0644\\u0627\\u0645\\u064a\\u0631 \\u0645\\u062a\\u0639\\u0628\",\"en\":null},\"district\":{\"ar\":\"\\u062d\\u064a \\u0627\\u0644\\u0635\\u0641\\u0627\",\"en\":null},\"building_no\":\"123456\",\"postal_code\":\"203060\",\"tax_no\":null}', 16, NULL, '2025-12-04 02:26:04', '2025-12-04 02:26:04');

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

--
-- بنية الجدول `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'),
(3, '{\"ar\":\"فئة سولد جيم\",\"en\":\"Solid Gym Category\"}', '2025-10-19 04:46:25', '2025-12-04 02:19:44'),
(4, '{\"en\":\"12\",\"ar\":\"12\"}', '2025-12-04 02:16:09', '2025-12-04 02:19:04'),
(5, '{\"en\":\"23\",\"ar\":\"23\"}', '2025-12-04 02:16:30', '2025-12-04 02:19:11');

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

--
-- بنية الجدول `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,
  `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`, `phones`, `country_id`, `created_at`, `updated_at`) VALUES
(1, '{\"ar\":\"الشركة النموذجية\",\"en\":\"Demo Company\"}', NULL, '#0ea5b6', '#1e293b', 'info@example.com', '[{\"label\":{\"ar\":\"\\u0627\\u0644\\u0645\\u0628\\u064a\\u0639\\u0627\\u062a\",\"en\":\"Sales\"},\"number\":\"+201234567890\"},{\"label\":{\"ar\":\"\\u0627\\u0644\\u062f\\u0639\\u0645\",\"en\":\"Support\"},\"number\":\"+201112223334\"}]', 2, '2025-10-19 04:46:24', '2025-10-19 04:46: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, 'elkady', '2025-10-22 03:04:01', '2025-10-22 03:04:01'),
(2, '0100002', 1, 'Elkady for software\'s', '2025-10-22 03:15:58', '2025-10-22 03:15:58');

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

--
-- بنية الجدول `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;

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

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

CREATE TABLE `members` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `member_code` char(7) NOT NULL,
  `branch_id` bigint(20) UNSIGNED NOT NULL,
  `status` enum('new','active','inactive') NOT NULL DEFAULT 'new',
  `id_type` enum('national_id','residence','passport','driving_license','work_card') DEFAULT NULL,
  `id_number` varchar(20) DEFAULT NULL,
  `id_issue_greg` date DEFAULT NULL,
  `id_expiry_greg` date DEFAULT NULL,
  `id_issue_hijri` varchar(20) DEFAULT NULL,
  `id_expiry_hijri` varchar(20) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `gender` enum('male','female') DEFAULT NULL,
  `nationality_id` bigint(20) UNSIGNED DEFAULT NULL,
  `birth_greg` date DEFAULT NULL,
  `birth_hijri` varchar(20) DEFAULT NULL,
  `age` smallint(5) UNSIGNED DEFAULT NULL,
  `phone` varchar(30) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `po_box` varchar(50) DEFAULT NULL,
  `postal_code` varchar(20) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `avatar_path` varchar(255) DEFAULT NULL,
  `id_image_path` varchar(255) DEFAULT NULL,
  `work_card_image_path` varchar(255) DEFAULT NULL,
  `how_heard` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`how_heard`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `members` (`id`, `member_code`, `branch_id`, `status`, `id_type`, `id_number`, `id_issue_greg`, `id_expiry_greg`, `id_issue_hijri`, `id_expiry_hijri`, `name`, `gender`, `nationality_id`, `birth_greg`, `birth_hijri`, `age`, `phone`, `email`, `password`, `po_box`, `postal_code`, `address`, `avatar_path`, `id_image_path`, `work_card_image_path`, `how_heard`, `created_at`, `updated_at`) VALUES
(1, '0100002', 1, 'new', NULL, NULL, NULL, NULL, NULL, NULL, 'Kyra Chapman', 'male', 8, NULL, NULL, NULL, '+1 (384) 192-8193', 'husiwehul@mailinator.com', '$2y$10$BaewXHoWbHWBFc0qF23A.eDwcmXAyregNMyFlKNhI675KTySTzqGG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-01-18 14:12:35', '2026-01-18 14:12:35'),
(2, '0100003', 1, 'new', NULL, NULL, NULL, NULL, NULL, NULL, 'Elkady for software\'s', 'male', 1, NULL, NULL, NULL, '01010460466', 'elkady@elkady.com', '$2y$10$yX3uVTrfvMMELJtBIR4wP.Pxz5hiAhsv2uLuWgLHmaRzJmFlLqXVG', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-01-18 17:18:11', '2026-01-18 17:18:11'),
(3, '0100004', 1, 'new', NULL, NULL, NULL, NULL, NULL, NULL, 'Emad', 'male', 2, NULL, NULL, NULL, '0554100510', 'neuwusl@gmail.com', '$2y$10$0cjgu/rRJhu44eg3VwSC7.ktGQk6x/hlDaAocIfJqnNqlTKVj909K', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-01-18 17:38:43', '2026-01-18 17:38:43'),
(4, '0100005', 1, 'new', NULL, NULL, NULL, NULL, NULL, NULL, 'Mohammed Khashaba', 'male', 1, NULL, NULL, NULL, '0502055094', 'moh.khashaba2010@gmail.com', '$2y$10$tkTj7daEkhWCcx9vLSsfpeFoKzc.n/g.gf0jPxLgbwUQDByE9RaSK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-01-19 01:42:37', '2026-01-19 01:42:37'),
(5, '0100006', 1, 'new', NULL, NULL, NULL, NULL, NULL, NULL, 'WAHEEB SAMARAN', 'male', 2, NULL, NULL, NULL, '0546828666', 'W.S.A1994@HOTMAIL.COM', '$2y$10$WE2yKk6yPTo/8PTQNtEhFeYHPZKAhM9S0CxJ36Ug99zJ//5swY3Ze', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-01-19 07:15:46', '2026-01-19 07:15:46'),
(6, '0100007', 1, 'new', NULL, NULL, NULL, NULL, NULL, NULL, 'ahmed aldoasri', 'male', 2, NULL, NULL, NULL, '0560855525', 'ahmed1801@hotmail.com', '$2y$10$qg3nQg8truWBnlkgL5xdJ.7FUFouLvXaOKkrYMvNec5TQauCI14yi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-01-19 09:50:34', '2026-01-19 09:50:34');

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

--
-- بنية الجدول `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, 2, 'offer', 1, 7749.00, 'SAR', '607803fe-996c-4a78-9d81-99631932b1de', 'AE8802E4D72860C8DF961F23877F1368.uat01-vm-tx03', '8ac7a4a09bd70319019bd84c3c3e065f', '000.100.112', 'Request successfully processed in \'Merchant in Connector Test Mode\'', 'paid', '2026-01-19 19:06:47', '2026-01-19 19:07:16'),
(2, 2, 'offer', 2, 7749.00, 'SAR', 'c04c932c-4203-44fd-9d26-8e37dcd46208', '2D8D6E6137EC65E39085B258D8D44C38.uat01-vm-tx04', '8ac7a4a19bd71493019bd85106c46dbe', '000.100.112', 'Request successfully processed in \'Merchant in Connector Test Mode\'', 'paid', '2026-01-19 19:11:42', '2026-01-19 19:12:30'),
(3, 4, 'offer', 1, 7749.00, 'SAR', 'e0815563-a774-4398-9065-3215ce0ce653', '9C82CEF07E93AD6257C6D230911DE2BC.uat01-vm-tx02', NULL, NULL, NULL, 'pending', '2026-01-20 03:11:34', '2026-01-20 03:11:35'),
(4, 4, 'offer', 1, 7749.00, 'SAR', 'aa782769-d3a9-47a4-8192-34017ed75a5b', '97D6DC97D24CB65A91D2D3833C7D42C9.uat01-vm-tx04', NULL, NULL, NULL, 'pending', '2026-01-20 09:26:38', '2026-01-20 09:26:38'),
(5, 4, 'offer', 1, 7749.00, 'SAR', '30f57dbd-8dad-4bb0-a6ff-490e7f119905', '73AC31B749B4AD1B0455806D85CED8C4.uat01-vm-tx01', NULL, NULL, NULL, 'pending', '2026-01-20 09:28:32', '2026-01-20 09:28:33'),
(6, 4, 'offer', 1, 7749.00, 'SAR', 'dfe41df8-b887-4136-8d10-f58b194abb4f', '5517349F98985D098360710A65FD16F6.uat01-vm-tx03', NULL, NULL, NULL, 'pending', '2026-01-20 09:29:49', '2026-01-20 09:29:49');

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

--
-- بنية الجدول `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', 7, '2026-01-18 14:11:18', '2026-01-19 09:50:34');

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

--
-- بنية الجدول `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', 2),
(1, 'App\\Models\\User', 3);

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

--
-- بنية الجدول `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
) 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`) VALUES
(1, 1, '{\"ar\":\"\\u0639\\u0631\\u0636 \\u0627\\u0644\\u0625\\u0641\\u062a\\u062a\\u0627\\u062d\",\"en\":\"\\u0639\\u0631\\u0636 \\u0627\\u0644\\u0625\\u0641\\u062a\\u062a\\u0627\\u062d\"}', 'members', NULL, NULL, NULL, '2026-01-18', '2026-03-30', '1447-07-29', '1447-10-11', 72, 'percent', 50.00, 60, 1, '2026-01-18 14:59:23', '2026-01-18 14:59:23'),
(2, 2, '{\"ar\":\"1\",\"en\":\"1\"}', 'members', NULL, NULL, NULL, '2026-01-18', '2026-03-30', '1447-07-29', '1447-10-11', 72, 'percent', 50.00, 20, 1, '2026-01-18 15:04:57', '2026-01-18 15:04:57');

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

--
-- بنية الجدول `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
(1, 1, 4, '\"\\u0625\\u0634\\u062a\\u0631\\u0627\\u0643 12\\u0634\\u0647\\u0631\"', 5999.00, 12, 'days', NULL, NULL, NULL, 2999.50, 72, 'days', '2026-01-18 14:59:23', '2026-01-18 14:59:23'),
(2, 1, 3, '\"\\u0625\\u0634\\u062a\\u0631\\u0627\\u0643 6\\u0623\\u0634\\u0647\\u0631\"', 3999.00, 6, 'days', NULL, NULL, NULL, 1999.50, 66, 'days', '2026-01-18 14:59:23', '2026-01-18 14:59:23'),
(3, 1, 2, '\"\\u0625\\u0634\\u062a\\u0631\\u0627\\u0643 3\\u0623\\u0634\\u0647\\u0631\"', 3500.00, 3, 'days', NULL, NULL, NULL, 1750.00, 63, 'days', '2026-01-18 14:59:23', '2026-01-18 14:59:23'),
(4, 1, 1, '\"\\u0625\\u0634\\u062a\\u0631\\u0627\\u0643 \\u0634\\u0647\\u0631\"', 2000.00, 1, 'months', NULL, NULL, NULL, 1000.00, 1, 'months', '2026-01-18 14:59:23', '2026-01-18 14:59:23'),
(5, 2, 4, '\"\\u0625\\u0634\\u062a\\u0631\\u0627\\u0643 12\\u0634\\u0647\\u0631\"', 5999.00, 12, 'days', NULL, NULL, NULL, 2999.50, 32, 'days', '2026-01-18 15:04:57', '2026-01-18 15:04:57'),
(6, 2, 3, '\"\\u0625\\u0634\\u062a\\u0631\\u0627\\u0643 6\\u0623\\u0634\\u0647\\u0631\"', 3999.00, 6, 'days', NULL, NULL, NULL, 1999.50, 26, 'days', '2026-01-18 15:04:57', '2026-01-18 15:04:57'),
(7, 2, 2, '\"\\u0625\\u0634\\u062a\\u0631\\u0627\\u0643 3\\u0623\\u0634\\u0647\\u0631\"', 3500.00, 3, 'days', NULL, NULL, NULL, 1750.00, 23, 'days', '2026-01-18 15:04:57', '2026-01-18 15:04:57'),
(8, 2, 1, '\"\\u0625\\u0634\\u062a\\u0631\\u0627\\u0643 \\u0634\\u0647\\u0631\"', 2000.00, 1, 'months', NULL, NULL, NULL, 1000.00, 1, 'months', '2026-01-18 15:04:57', '2026-01-18 15:04:57');

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

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

CREATE TABLE `password_resets` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- بنية الجدول `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');

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

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

CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tokenable_type` varchar(255) NOT NULL,
  `tokenable_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `token` varchar(64) NOT NULL,
  `abilities` text DEFAULT NULL,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- بنية الجدول `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\":\"1Month Males-اشتراك شهر رجال\",\"en\":\"1Month Males-اشتراك شهر رجال\"}', 1, 1, 2000.00, 1, 'months', '00:00:00', '23:59:00', '{\"en\":null}', '{\"pause\":{\"enabled\":\"1\",\"max_times\":\"2\",\"max_duration_value\":\"15\",\"max_duration_unit\":\"days\"},\"transfer\":{\"enabled\":\"1\",\"min_duration_value\":\"15\",\"min_duration_unit\":\"days\",\"fee\":\"345\"},\"refund\":{\"enabled\":\"1\",\"method\":\"money\"}}', 1, '2026-01-18 14:48:14', '2026-01-19 03:15:43'),
(2, '1002', '{\"ar\":\"3Months Males-اشتراك 3شهور رجال\",\"en\":\"3Months Males-اشتراك 3شهور رجال\"}', 1, 1, 3500.00, 3, 'months', '00:00:00', '23:59:00', '{\"en\":null}', '{\"pause\":{\"enabled\":\"1\",\"max_times\":\"4\",\"max_duration_value\":\"30\",\"max_duration_unit\":\"days\"},\"transfer\":{\"enabled\":\"1\",\"min_duration_value\":\"30\",\"min_duration_unit\":\"days\",\"fee\":\"345\"},\"refund\":{\"enabled\":\"1\",\"method\":\"money\"}}', 1, '2026-01-18 14:50:12', '2026-01-19 03:19:03'),
(3, '1003', '{\"ar\":\"6Months Males-اشتراك 6شهور رجال\",\"en\":\"6Months Males-اشتراك 6شهور رجال\"}', 1, 1, 3999.00, 6, 'months', '00:00:00', '23:59:00', '{\"en\":null}', '{\"pause\":{\"enabled\":\"1\",\"max_times\":\"6\",\"max_duration_value\":\"60\",\"max_duration_unit\":\"days\"},\"transfer\":{\"enabled\":\"1\",\"min_duration_value\":\"30\",\"min_duration_unit\":\"days\",\"fee\":\"345\"},\"refund\":{\"enabled\":\"1\",\"method\":\"money\"}}', 1, '2026-01-18 14:51:32', '2026-01-19 03:19:19'),
(4, '1004', '{\"ar\":\"12Months Males-اشتراك 12شهر رجال\",\"en\":\"12Months Males-اشتراك 12شهر رجال\"}', 1, 1, 5999.00, 12, 'months', '00:00:00', '23:59:00', '{\"en\":null}', '{\"pause\":{\"enabled\":\"1\",\"max_times\":\"6\",\"max_duration_value\":\"90\",\"max_duration_unit\":\"days\"},\"transfer\":{\"enabled\":\"1\",\"min_duration_value\":\"30\",\"min_duration_unit\":\"days\",\"fee\":\"345\"},\"refund\":{\"enabled\":\"1\",\"method\":\"money\"}}', 1, '2026-01-18 14:54:50', '2026-01-19 03:19:28');

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

--
-- بنية الجدول `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_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_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');

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

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

CREATE TABLE `subscriptions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `subscription_no` bigint(20) UNSIGNED NOT NULL,
  `invoice_no` varchar(50) NOT NULL,
  `verification_code` varchar(100) DEFAULT NULL,
  `branch_id` bigint(20) UNSIGNED DEFAULT NULL,
  `member_id` bigint(20) UNSIGNED DEFAULT NULL,
  `subscription_type` enum('service','offer') NOT NULL,
  `item_id` bigint(20) UNSIGNED NOT NULL,
  `item_name` varchar(255) NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `duration` int(10) UNSIGNED NOT NULL,
  `price` decimal(10,2) NOT NULL DEFAULT 0.00,
  `tax` decimal(10,2) NOT NULL DEFAULT 0.00,
  `discount` decimal(10,2) NOT NULL DEFAULT 0.00,
  `total` decimal(10,2) NOT NULL DEFAULT 0.00,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `account_user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `payment_methods` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`payment_methods`)),
  `status` enum('new','under_review','approved','rejected') NOT NULL DEFAULT 'under_review',
  `rejection_notes` text DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `subscriptions` (`id`, `subscription_no`, `invoice_no`, `verification_code`, `branch_id`, `member_id`, `subscription_type`, `item_id`, `item_name`, `start_date`, `end_date`, `duration`, `price`, `tax`, `discount`, `total`, `created_by`, `account_user_id`, `payment_methods`, `status`, `rejection_notes`, `active`, `created_at`, `updated_at`) VALUES
(1, 1, 'INV-20260119-1', NULL, NULL, 2, 'offer', 1, 'Offer Subscription', '2026-01-19', '2026-02-18', 30, 7749.00, 0.00, 0.00, 7749.00, NULL, NULL, '{\"hyperpay\":{\"transaction_id\":\"8ac7a4a09bd70319019bd84c3c3e065f\",\"merchant_tx\":\"607803fe-996c-4a78-9d81-99631932b1de\"}}', 'approved', NULL, 1, '2026-01-19 19:07:16', '2026-01-19 19:07:16'),
(2, 2, 'INV-20260119-2', NULL, NULL, 2, 'offer', 2, 'Offer Subscription', '2026-01-19', '2026-02-18', 30, 7749.00, 0.00, 0.00, 7749.00, NULL, NULL, '{\"hyperpay\":{\"transaction_id\":\"8ac7a4a19bd71493019bd85106c46dbe\",\"merchant_tx\":\"c04c932c-4203-44fd-9d26-8e37dcd46208\"}}', 'approved', NULL, 1, '2026-01-19 19:12:30', '2026-01-19 19:12:30');

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

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

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `branch_id` bigint(20) UNSIGNED DEFAULT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `branch_id`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'Super Admin', 'admin@system.local', NULL, '$2y$10$zFW76sceiwKh3dEcVAbn1O4YvUreAX621dQi2RrQgAHUCXNELd1u2', NULL, NULL, '2025-10-19 04:46:25', '2025-10-19 04:46:25'),
(2, 'محمد خشبه', 'mkhashaba@gulftriangle.net', NULL, '$2y$10$Ee4.v4tqZexZYudhQJh2jeiymP4Op0TDC4Si80X1BN9QgBoWCye7S', 3, NULL, '2025-10-21 05:26:36', '2025-11-24 12:07:28'),
(3, 'عبدالحميد خشبه', 'khashabawey@outlook.com', NULL, '$2y$10$aiN93dhcinBAR18aUYpe0unUII03TWlVPv09Ij9GaC5glXNRYQeI.', NULL, NULL, '2025-11-01 07:24:10', '2025-12-04 03:06:27');

--
-- 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 `members`
--
ALTER TABLE `members`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `members_member_code_unique` (`member_code`),
  ADD UNIQUE KEY `members_id_number_unique` (`id_number`),
  ADD KEY `members_nationality_id_foreign` (`nationality_id`),
  ADD KEY `members_branch_id_status_index` (`branch_id`,`status`);

--
-- 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 `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

--
-- Indexes for table `password_reset_tokens`
--
ALTER TABLE `password_reset_tokens`
  ADD PRIMARY KEY (`email`);

--
-- 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 `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_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`);

--
-- Indexes for table `subscriptions`
--
ALTER TABLE `subscriptions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_invoice_no` (`invoice_no`),
  ADD KEY `idx_branch_id` (`branch_id`),
  ADD KEY `idx_member_id` (`member_id`),
  ADD KEY `fk_subscriptions_created_by` (`created_by`),
  ADD KEY `fk_subscriptions_account_user` (`account_user_id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`),
  ADD KEY `users_branch_id_foreign` (`branch_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=3;

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

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

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

--
-- 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=3;

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

--
-- 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 `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- 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 for table `service_invoice_items`
--
ALTER TABLE `service_invoice_items`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- 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;

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

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

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

--
-- قيود الجداول `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;

