-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Sep 28, 2025 at 07:54 AM
-- Server version: 10.4.28-MariaDB
-- PHP Version: 8.2.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `pioneer`
--

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

--
-- Table structure for table `branches`
--

CREATE TABLE `branches` (
  `id` bigint(20) UNSIGNED 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;

--
-- Dumping data for table `branches`
--

INSERT INTO `branches` (`id`, `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, '{\"en\":\"Alexandra Bradshaw\",\"ar\":\"Drew Page\"}', 1, 1, 4, '+1 (915) 365-1578', '[{\"label\":{\"ar\":\"+1 (909) 518-1842\",\"en\":\"+1 (236) 154-9293\"},\"number\":\"+1 (623) 776-9699\"}]', 1, '{\"full\":{\"en\":\"Harum quisquam modi\",\"ar\":\"Delectus asperiores\"},\"tax_no\":\"Quis sit est fugit\",\"short\":{\"en\":\"Doloremque sunt adip\",\"ar\":\"Mollitia et nisi nul\"},\"street\":{\"en\":\"Sit autem eu velit\",\"ar\":\"Libero omnis quibusd\"},\"district\":{\"en\":\"In exercitation quas\",\"ar\":\"Perspiciatis ex dol\"},\"building_no\":\"Consectetur enim inc\",\"postal_code\":\"Molestiae esse expe\"}', 20, 65.00, '2025-09-25 06:49:46', '2025-09-25 07:21:51'),
(2, '{\"en\":\"Lana Fitzpatrick\",\"ar\":\"Hyacinth Sawyer\"}', 1, 1, 4, '+1 (524) 711-5881', '[{\"label\":{\"ar\":\"+1 (215) 106-7028\",\"en\":\"+1 (542) 683-1321\"},\"number\":\"+1 (723) 789-9643\"}]', 1, '{\"full\":{\"en\":\"Hic ratione vel elig\",\"ar\":\"Nemo non itaque volu\"},\"tax_no\":\"Eius ipsum lorem omn\",\"short\":{\"en\":\"Id et quam soluta i\",\"ar\":\"Et sed neque ullam f\"},\"street\":{\"en\":\"Exercitation hic nul\",\"ar\":\"Laboris numquam cum\"},\"district\":{\"en\":\"Cumque pariatur Acc\",\"ar\":\"Aperiam et non aliqu\"},\"building_no\":\"Amet rerum voluptas\",\"postal_code\":\"Aut laborum commodo\"}', 14, 19.00, '2025-09-25 06:52:39', '2025-09-25 06:52:39'),
(3, '{\"en\":\"Calista Sweeney\",\"ar\":\"Linda Norman\"}', 1, 1, 5, '+1 (702) 292-7262', '[{\"label\":{\"ar\":\"+1 (677) 503-6843\",\"en\":\"+1 (994) 406-8285\"},\"number\":\"+1 (728) 596-6954\"}]', 0, '{\"full\":{\"en\":\"In ut natus ut volup\",\"ar\":\"Irure distinctio De\"},\"tax_no\":\"Libero ad omnis ut i\",\"short\":{\"en\":\"Enim id facere anim\",\"ar\":\"Incididunt suscipit\"},\"street\":{\"en\":\"Est nisi voluptates\",\"ar\":\"Elit sed nulla repr\"},\"district\":{\"en\":\"Rem earum nostrum et\",\"ar\":\"Ipsum modi aspernat\"},\"building_no\":\"Ullamco est fugiat n\",\"postal_code\":\"Et consequatur nulla\"}', 99, 17.00, '2025-09-25 07:14:53', '2025-09-25 07:14:53');

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

--
-- Table structure for table `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;

--
-- Dumping data for table `branch_categories`
--

INSERT INTO `branch_categories` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, '{\"en\":\"Ishmael Moran\",\"ar\":\"Alice Castaneda\"}', '2025-09-25 06:28:02', '2025-09-25 06:28:02');

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

--
-- Table structure for table `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;

--
-- Dumping data for table `branch_monthly_goals`
--

INSERT INTO `branch_monthly_goals` (`id`, `branch_id`, `year`, `month`, `actual`, `target`, `created_at`, `updated_at`) VALUES
(1, 1, 2025, 1, 71.00, 6.00, '2025-09-25 06:49:46', '2025-09-25 06:49:46'),
(2, 1, 2025, 2, 73.00, 18.00, '2025-09-25 06:49:46', '2025-09-25 06:49:46'),
(3, 1, 2025, 3, 20.00, 68.00, '2025-09-25 06:49:46', '2025-09-25 06:49:46'),
(4, 1, 2025, 4, 58.00, 60.00, '2025-09-25 06:49:46', '2025-09-25 06:49:46'),
(5, 1, 2025, 5, 49.00, 71.00, '2025-09-25 06:49:46', '2025-09-25 06:49:46'),
(6, 1, 2025, 6, 60.00, 57.00, '2025-09-25 06:49:46', '2025-09-25 06:49:46'),
(7, 1, 2025, 7, 58.00, 97.00, '2025-09-25 06:49:46', '2025-09-25 06:49:46'),
(8, 1, 2025, 8, 48.00, 82.00, '2025-09-25 06:49:46', '2025-09-25 06:49:46'),
(9, 1, 2025, 9, 68.00, 76.00, '2025-09-25 06:49:46', '2025-09-25 06:49:46'),
(10, 1, 2025, 10, 26.00, 30.00, '2025-09-25 06:49:46', '2025-09-25 06:49:46'),
(11, 1, 2025, 11, 36.00, 43.00, '2025-09-25 06:49:46', '2025-09-25 06:49:46'),
(12, 1, 2025, 12, 82.00, 82.00, '2025-09-25 06:49:46', '2025-09-25 06:49:46'),
(13, 2, 2025, 1, 93.00, 80.00, '2025-09-25 06:52:40', '2025-09-25 06:52:40'),
(14, 2, 2025, 2, 62.00, 54.00, '2025-09-25 06:52:40', '2025-09-25 06:52:40'),
(15, 2, 2025, 3, 63.00, 95.00, '2025-09-25 06:52:40', '2025-09-25 06:52:40'),
(16, 2, 2025, 4, 98.00, 47.00, '2025-09-25 06:52:40', '2025-09-25 06:52:40'),
(17, 2, 2025, 5, 75.00, 12.00, '2025-09-25 06:52:40', '2025-09-25 06:52:40'),
(18, 2, 2025, 6, 63.00, 37.00, '2025-09-25 06:52:40', '2025-09-25 06:52:40'),
(19, 2, 2025, 7, 91.00, 78.00, '2025-09-25 06:52:40', '2025-09-25 06:52:40'),
(20, 2, 2025, 8, 50.00, 92.00, '2025-09-25 06:52:40', '2025-09-25 06:52:40'),
(21, 2, 2025, 9, 42.00, 37.00, '2025-09-25 06:52:40', '2025-09-25 06:52:40'),
(22, 2, 2025, 10, 38.00, 10.00, '2025-09-25 06:52:40', '2025-09-25 06:52:40'),
(23, 2, 2025, 11, 99.00, 95.00, '2025-09-25 06:52:40', '2025-09-25 06:52:40'),
(24, 2, 2025, 12, 92.00, 64.00, '2025-09-25 06:52:40', '2025-09-25 06:52:40'),
(25, 3, 2025, 1, 13.00, 96.00, '2025-09-25 07:14:53', '2025-09-25 07:14:53'),
(26, 3, 2025, 2, 85.00, 47.00, '2025-09-25 07:14:53', '2025-09-25 07:14:53'),
(27, 3, 2025, 3, 86.00, 88.00, '2025-09-25 07:14:53', '2025-09-25 07:14:53'),
(28, 3, 2025, 4, 1.00, 90.00, '2025-09-25 07:14:53', '2025-09-25 07:14:53'),
(29, 3, 2025, 5, 90.00, 43.00, '2025-09-25 07:14:53', '2025-09-25 07:14:53'),
(30, 3, 2025, 6, 100.00, 53.00, '2025-09-25 07:14:53', '2025-09-25 07:14:53'),
(31, 3, 2025, 7, 25.00, 24.00, '2025-09-25 07:14:53', '2025-09-25 07:14:53'),
(32, 3, 2025, 8, 93.00, 84.00, '2025-09-25 07:14:53', '2025-09-25 07:14:53'),
(33, 3, 2025, 9, 8.00, 76.00, '2025-09-25 07:14:53', '2025-09-25 07:14:53'),
(34, 3, 2025, 10, 70.00, 86.00, '2025-09-25 07:14:53', '2025-09-25 07:14:53'),
(35, 3, 2025, 11, 11.00, 33.00, '2025-09-25 07:14:53', '2025-09-25 07:14:53'),
(36, 3, 2025, 12, 92.00, 63.00, '2025-09-25 07:14:53', '2025-09-25 07:14:53'),
(37, 2, 2024, 1, 30.00, 100.00, '2025-09-25 07:19:09', '2025-09-25 07:19:09'),
(38, 2, 2024, 2, 30.00, 100.00, '2025-09-25 07:19:09', '2025-09-25 07:19:09'),
(39, 2, 2024, 3, 20.00, 1000.00, '2025-09-25 07:19:09', '2025-09-25 07:19:09'),
(40, 1, 2024, 1, 20.00, 150.00, '2025-09-25 07:21:51', '2025-09-25 07:21:51'),
(41, 1, 2024, 2, 2500.00, 10000.00, '2025-09-25 07:21:51', '2025-09-25 07:21:51');

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

--
-- Table structure for table `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;

--
-- Dumping data for table `branch_service_provided`
--

INSERT INTO `branch_service_provided` (`id`, `service_id`, `branch_id`) VALUES
(3, 1, 1),
(1, 1, 2),
(2, 1, 3);

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

--
-- Table structure for table `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;

--
-- Dumping data for table `branch_service_sold`
--

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

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

--
-- Table structure for table `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;

--
-- Dumping data for table `branch_types`
--

INSERT INTO `branch_types` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, '{\"en\":\"Hiroko Fitzgerald\",\"ar\":\"Nash Montgomery\"}', '2025-09-25 06:28:10', '2025-09-25 06:28:10');

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

--
-- Table structure for table `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;

--
-- Dumping data for table `cities`
--

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

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

--
-- Table structure for table `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;

--
-- Dumping data for table `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\"}', 'logo_path/logo_20250925_075855_glvQ1e.png', '#0ea5b6', '#1e293b', 'info@example.com', '[{\"label\":{\"ar\":\"\\u0627\\u0644\\u062f\\u0639\\u0645\",\"en\":\"Support\"},\"number\":\"+201112223334\"}]', 2, '2025-09-25 04:52:23', '2025-09-25 04:59:24');

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

--
-- Table structure for table `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;

--
-- Dumping data for table `countries`
--

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

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

--
-- Table structure for table `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;

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

--
-- Table structure for table `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;

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_reset_tokens_table', 1),
(3, '2014_10_12_100000_create_password_resets_table', 1),
(4, '2019_08_19_000000_create_failed_jobs_table', 1),
(5, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(6, '2025_01_31_195147_create_countries_table', 1),
(7, '2025_01_31_195616_create_states_table', 1),
(8, '2025_01_31_195637_create_cities_table', 1),
(9, '2025_09_25_060108_create_branch_categories_table', 1),
(10, '2025_09_25_062659_create_branch_types_table', 1),
(11, '2025_09_25_071042_create_company_settings_table', 1),
(12, '2025_09_25_082216_create_branches_table', 2),
(13, '2025_09_25_082331_create_branch_monthly_goals_table', 2),
(14, '2025_09_25_170137_create_service_types_table', 3),
(15, '2025_09_25_172350_create_service_categories_table', 4),
(16, '2025_09_25_184345_create_services_table', 5);

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

--
-- Table structure for table `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;

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

--
-- Table structure for table `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;

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

--
-- Table structure for table `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;

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

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

CREATE TABLE `services` (
  `id` bigint(20) UNSIGNED NOT 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,
  `discount_price` decimal(10,2) DEFAULT 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;

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

INSERT INTO `services` (`id`, `name`, `service_category_id`, `service_type_id`, `price`, `discount_price`, `duration_value`, `duration_unit`, `start_time`, `end_time`, `notes`, `settings`, `active`, `created_at`, `updated_at`) VALUES
(1, '{\"ar\":\"Kimberley Blevins\",\"en\":\"Blaze Perry\"}', 1, 1, 894.00, 521.00, 73, 'days', '08:59:00', '03:32:00', '{\"ar\":\"Quae fugit eu non u\",\"en\":\"Sint molestias dolo\"}', '{\"pause\":{\"enabled\":\"1\",\"max_times\":\"10\",\"max_duration_value\":\"100\",\"max_duration_unit\":\"days\"},\"refund\":{\"enabled\":\"1\",\"method\":\"money\"},\"days\":{\"enabled\":\"1\",\"values\":[\"sat\",\"sun\",\"mon\",\"tue\",\"wed\",\"thu\",\"fri\"]}}', 1, '2025-09-25 16:17:13', '2025-09-25 16:35:19');

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

--
-- Table structure for table `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;

--
-- Dumping data for table `service_categories`
--

INSERT INTO `service_categories` (`id`, `name`, `description`, `active`, `created_at`, `updated_at`) VALUES
(1, '{\"en\":\"Elkady for software\'sddgd\",\"ar\":\"Elkady for software\'s gdgd\"}', '{\"en\":\"gdgd\",\"ar\":\"gdgd\"}', 1, '2025-09-25 14:29:02', '2025-09-25 14:29:18');

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

--
-- Table structure for table `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;

--
-- Dumping data for table `service_types`
--

INSERT INTO `service_types` (`id`, `name`, `description`, `active`, `created_at`, `updated_at`) VALUES
(1, '{\"en\":\"Arabic 1\",\"ar\":\"مدرسه القاضى\"}', '{\"en\":\"sfs\",\"ar\":\"sfsf\"}', 0, '2025-09-25 14:12:18', '2025-09-25 14:19:12');

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

--
-- Table structure for table `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;

--
-- Dumping data for table `states`
--

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

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

--
-- Table structure for table `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,
  `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;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, '{\"ar\":\"المشرف\",\"en\":\"Admin\"}', 'admin@admin.com', NULL, '$2y$10$m5MLTjwJZ/jN8GeYZwTX/OqIUP6vX7p90yEFN.FXHyeogP3loxXi2', NULL, '2025-09-25 04:52:19', '2025-09-25 04:52:19');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `branches`
--
ALTER TABLE `branches`
  ADD PRIMARY KEY (`id`),
  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 `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `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 `cities` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `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;

--
-- Constraints for table `branch_service_provided`
--
ALTER TABLE `branch_service_provided`
  ADD CONSTRAINT `branch_service_provided_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `branch_service_provided_service_id_foreign` FOREIGN KEY (`service_id`) REFERENCES `services` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `branch_service_sold`
--
ALTER TABLE `branch_service_sold`
  ADD CONSTRAINT `branch_service_sold_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `branch_service_sold_service_id_foreign` FOREIGN KEY (`service_id`) REFERENCES `services` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `cities`
--
ALTER TABLE `cities`
  ADD CONSTRAINT `cities_state_id_foreign` FOREIGN KEY (`state_id`) REFERENCES `states` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `company_settings`
--
ALTER TABLE `company_settings`
  ADD CONSTRAINT `company_settings_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `services`
--
ALTER TABLE `services`
  ADD CONSTRAINT `services_service_category_id_foreign` FOREIGN KEY (`service_category_id`) REFERENCES `service_categories` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `services_service_type_id_foreign` FOREIGN KEY (`service_type_id`) REFERENCES `service_types` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `states`
--
ALTER TABLE `states`
  ADD CONSTRAINT `states_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE CASCADE;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;