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

START TRANSACTION;



--
-- Database: `qansah_demo`
--

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

--
-- Table structure for table `bans`
--

CREATE TABLE `bans` (
  `id` int NOT NULL,
  `bannable_type` varchar(255) NOT NULL,
  `bannable_id` bigint NOT NULL,
  `created_by_type` varchar(255) DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `comment` text,
  `expired_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `brands`
--

CREATE TABLE `brands` (
  `id` bigint NOT NULL,
  `is_featured` tinyint(1) NOT NULL DEFAULT '0',
  `order` int DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'draft',
  `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 `brands`
--

INSERT INTO `brands` (`id`, `is_featured`, `order`, `status`, `created_at`, `updated_at`) VALUES
(1, 0, 0, 'active', '2025-10-18 11:24:56', '2025-10-24 13:59:17');

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

--
-- Table structure for table `brand_translations`
--

CREATE TABLE `brand_translations` (
  `id` bigint NOT NULL,
  `brand_id` bigint NOT NULL,
  `language_id` bigint NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8mb4_unicode_ci,
  `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 `brand_translations`
--

INSERT INTO `brand_translations` (`id`, `brand_id`, `language_id`, `name`, `description`, `created_at`, `updated_at`) VALUES
(7, 1, 3, 'noon', NULL, '2025-10-18 16:02:27', '2025-10-18 16:02:27'),
(8, 1, 1, 'نون', NULL, '2025-10-18 16:02:27', '2025-10-18 16:02:27');

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

--
-- Table structure for table `cache`
--

CREATE TABLE `cache` (
  `key` varchar(255) NOT NULL,
  `value` mediumtext NOT NULL,
  `expiration` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cache`
--

INSERT INTO `cache` (`key`, `value`, `expiration`) VALUES
('qansah-cache-settings_group_cache', 'a:3:{s:12:\"cache_driver\";s:4:\"file\";s:13:\"cache_enabled\";b:1;s:14:\"cache_lifetime\";d:3600;}', 1761627056),
('qansah-cache-settings_group_email', 'a:7:{s:12:\"from_address\";s:0:\"\";s:9:\"from_name\";s:6:\"Qansah\";s:15:\"smtp_encryption\";s:3:\"tls\";s:9:\"smtp_host\";s:0:\"\";s:13:\"smtp_password\";s:0:\"\";s:9:\"smtp_port\";d:587;s:13:\"smtp_username\";s:0:\"\";}', 1761627056),
('qansah-cache-settings_group_seo_6', 'a:6:{s:17:\"facebook_pixel_id\";s:0:\"\";s:19:\"google_analytics_id\";s:0:\"\";s:18:\"google_tag_manager\";s:0:\"\";s:25:\"meta_description_template\";s:35:\"Discover the best deals and coupons\";s:13:\"meta_keywords\";s:31:\"coupons,deals,discounts,savings\";s:19:\"meta_title_template\";s:11:\"%s - Qansah\";}', 1761627056),
('qansah-cache-settings_group_social', 'a:2:{s:15:\"facebook_app_id\";s:0:\"\";s:16:\"google_client_id\";s:0:\"\";}', 1761627056),
('qansah-cache-setting_cache_cache_driver', 's:4:\"file\";', 1761627056),
('qansah-cache-setting_cache_cache_enabled', 'b:1;', 1761627056),
('qansah-cache-setting_cache_cache_lifetime', 'd:3600;', 1761627056),
('qansah-cache-setting_email_from_address', 's:0:\"\";', 1761627056),
('qansah-cache-setting_email_from_name', 's:6:\"Qansah\";', 1761627056),
('qansah-cache-setting_email_smtp_encryption', 's:3:\"tls\";', 1761627056),
('qansah-cache-setting_email_smtp_host', 's:0:\"\";', 1761627056),
('qansah-cache-setting_email_smtp_password', 's:0:\"\";', 1761627056),
('qansah-cache-setting_email_smtp_port', 'd:587;', 1761627056),
('qansah-cache-setting_email_smtp_username', 's:0:\"\";', 1761627056),
('qansah-cache-setting_general_app_name_6', 's:6:\"Qansah\";', 1761627065),
('qansah-cache-setting_general_site_favicon', 's:16:\"/img/favicon.ico\";', 1761627056),
('qansah-cache-setting_general_site_logo', 's:37:\"/storage/settings/logo_1761623446.svg\";', 1761627056),
('qansah-cache-setting_general_site_logo_6', 's:37:\"/storage/settings/logo_1761623446.svg\";', 1761627065),
('qansah-cache-setting_seo_facebook_pixel_id_6', 's:0:\"\";', 1761627056),
('qansah-cache-setting_seo_google_analytics_id_6', 's:0:\"\";', 1761627056),
('qansah-cache-setting_seo_google_tag_manager_6', 's:0:\"\";', 1761627056),
('qansah-cache-setting_seo_meta_description_template_6', 's:35:\"Discover the best deals and coupons\";', 1761627056),
('qansah-cache-setting_seo_meta_keywords_6', 's:31:\"coupons,deals,discounts,savings\";', 1761627056),
('qansah-cache-setting_seo_meta_title_template_6', 's:11:\"%s - Qansah\";', 1761627056),
('qansah-cache-setting_social_facebook_app_id', 's:0:\"\";', 1761627056),
('qansah-cache-setting_social_google_client_id', 's:0:\"\";', 1761627056),
('qansah2-cache-38a3ca8cec82add39a8b166d63d5ad55', 'i:1;', 1761991522),
('qansah2-cache-38a3ca8cec82add39a8b166d63d5ad55:timer', 'i:1761991522;', 1761991522),
('qansah2-cache-86661923a619c56d32390f6520b52426', 'i:1;', 1762186720),
('qansah2-cache-86661923a619c56d32390f6520b52426:timer', 'i:1762186720;', 1762186720),
('qansah2-cache-9663257cfbc8565dd05b85fb0e0f0873', 'i:1;', 1761734139),
('qansah2-cache-9663257cfbc8565dd05b85fb0e0f0873:timer', 'i:1761734139;', 1761734139),
('qansah2-cache-acf41f184fcde525acfadb555cf00d8a', 'i:1;', 1762186542),
('qansah2-cache-acf41f184fcde525acfadb555cf00d8a:timer', 'i:1762186542;', 1762186542),
('qansah2-cache-b30e15706720a8185dc3d8d2adb20633', 'i:1;', 1762168036),
('qansah2-cache-b30e15706720a8185dc3d8d2adb20633:timer', 'i:1762168036;', 1762168036),
('qansah2-cache-b37e2b0b86a8368405df02e0b66d0b39', 'i:1;', 1761627119),
('qansah2-cache-b37e2b0b86a8368405df02e0b66d0b39:timer', 'i:1761627119;', 1761627119),
('qansah2-cache-b5eb5186db37e3f8b2f15960fc8bc190', 'i:1;', 1761727358),
('qansah2-cache-b5eb5186db37e3f8b2f15960fc8bc190:timer', 'i:1761727358;', 1761727358),
('qansah2-cache-b9c41d6157da577862f310898b138c1b', 'i:2;', 1761727946),
('qansah2-cache-b9c41d6157da577862f310898b138c1b:timer', 'i:1761727946;', 1761727946),
('qansah2-cache-clarity_events_2025-11-01', 'a:2:{i:0;a:3:{s:4:\"type\";s:8:\"pageview\";s:4:\"data\";a:10:{s:10:\"project_id\";s:28:\"your_clarity_project_id_here\";s:10:\"session_id\";s:6:\"string\";s:7:\"user_id\";N;s:8:\"page_url\";s:6:\"string\";s:10:\"page_title\";s:6:\"string\";s:8:\"platform\";s:7:\"android\";s:11:\"device_type\";s:6:\"string\";s:11:\"app_version\";s:6:\"string\";s:9:\"timestamp\";s:27:\"2025-11-01T10:29:52.863328Z\";s:11:\"custom_data\";a:4:{i:0;s:6:\"string\";s:10:\"country_id\";i:6;s:11:\"language_id\";i:3;s:9:\"locale_id\";i:1;}}s:9:\"stored_at\";s:27:\"2025-11-01T10:29:52.863910Z\";}i:1;a:3:{s:4:\"type\";s:12:\"custom_event\";s:4:\"data\";a:7:{s:10:\"project_id\";s:28:\"your_clarity_project_id_here\";s:10:\"session_id\";s:6:\"string\";s:7:\"user_id\";N;s:10:\"event_name\";s:6:\"string\";s:10:\"event_data\";a:3:{i:0;s:6:\"string\";s:10:\"country_id\";i:6;s:11:\"language_id\";i:3;}s:8:\"platform\";s:7:\"android\";s:9:\"timestamp\";s:27:\"2025-11-01T10:30:00.414812Z\";}s:9:\"stored_at\";s:27:\"2025-11-01T10:30:00.415294Z\";}}', 1762079400),
('qansah2-cache-fdc7aece2934b91d93f50b6c2bb648a6', 'i:1;', 1762109687),
('qansah2-cache-fdc7aece2934b91d93f50b6c2bb648a6:timer', 'i:1762109687;', 1762109687),
('qansah2-cache-settings_group_cache', 'a:3:{s:12:\"cache_driver\";s:4:\"file\";s:13:\"cache_enabled\";b:1;s:14:\"cache_lifetime\";d:3600;}', 1762718480),
('qansah2-cache-settings_group_email', 'a:7:{s:12:\"from_address\";s:0:\"\";s:9:\"from_name\";s:6:\"Qansah\";s:15:\"smtp_encryption\";s:3:\"tls\";s:9:\"smtp_host\";s:0:\"\";s:13:\"smtp_password\";s:0:\"\";s:9:\"smtp_port\";d:587;s:13:\"smtp_username\";s:0:\"\";}', 1762718480),
('qansah2-cache-settings_group_general', 'a:4:{s:8:\"app_name\";s:7:\"Qansah2\";s:11:\"app_version\";s:5:\"2.0.0\";s:12:\"site_favicon\";s:16:\"/img/favicon.ico\";s:9:\"site_logo\";s:37:\"/storage/settings/logo_1761623446.svg\";}', 1762718480),
('qansah2-cache-settings_group_seo_2', 'a:6:{s:17:\"facebook_pixel_id\";s:0:\"\";s:19:\"google_analytics_id\";s:0:\"\";s:18:\"google_tag_manager\";s:0:\"\";s:25:\"meta_description_template\";s:35:\"Discover the best deals and coupons\";s:13:\"meta_keywords\";s:31:\"coupons,deals,discounts,savings\";s:19:\"meta_title_template\";s:11:\"%s - Qansah\";}', 1762718480),
('qansah2-cache-settings_group_seo_3', 'a:3:{s:25:\"meta_description_template\";s:35:\"Discover the best deals and coupons\";s:13:\"meta_keywords\";s:31:\"coupons,deals,discounts,savings\";s:19:\"meta_title_template\";s:13:\"%s - Qansah 2\";}', 1762114053),
('qansah2-cache-settings_group_seo_6', 'a:3:{s:25:\"meta_description_template\";s:37:\"Discover the best deals and coupons 2\";s:13:\"meta_keywords\";s:31:\"coupons,deals,discounts,savings\";s:19:\"meta_title_template\";s:11:\"%s - Qansah\";}', 1762112870),
('qansah2-cache-settings_group_social', 'a:2:{s:15:\"facebook_app_id\";s:0:\"\";s:16:\"google_client_id\";s:0:\"\";}', 1762718480),
('qansah2-cache-setting_api_api_enabled_6', 'b:1;', 1761627668),
('qansah2-cache-setting_api_api_rate_limit_6', 'i:100;', 1761627668),
('qansah2-cache-setting_api_compression_enabled_6', 'b:1;', 1761627693),
('qansah2-cache-setting_app_android_store_url_6', 's:60:\"https://play.google.com/store/apps/details?id=com.qansah.app\";', 1761627755),
('qansah2-cache-setting_app_biometric_login_enabled_6', 'b:1;', 1761627693),
('qansah2-cache-setting_app_comments_enabled_6', 'b:0;', 1761627693),
('qansah2-cache-setting_app_dark_mode_enabled_6', 'b:1;', 1761627693),
('qansah2-cache-setting_app_favorites_enabled_6', 'b:1;', 1761627693),
('qansah2-cache-setting_app_guest_mode_enabled_6', 'b:1;', 1761627693),
('qansah2-cache-setting_app_offline_mode_enabled_6', 'b:0;', 1761627693),
('qansah2-cache-setting_app_release_notes_6', 's:0:\"\";', 1761627755),
('qansah2-cache-setting_app_reviews_enabled_6', 'b:0;', 1761627693),
('qansah2-cache-setting_app_sharing_enabled_6', 'b:1;', 1761627693),
('qansah2-cache-setting_cache_cache_driver', 's:4:\"file\";', 1762718480),
('qansah2-cache-setting_cache_cache_enabled', 'b:1;', 1762718480),
('qansah2-cache-setting_cache_cache_enabled_6', 'b:1;', 1761627613),
('qansah2-cache-setting_cache_cache_lifetime', 'd:3600;', 1762718480),
('qansah2-cache-setting_email_from_address', 's:0:\"\";', 1762718480),
('qansah2-cache-setting_email_from_address_6', 's:0:\"\";', 1761627668),
('qansah2-cache-setting_email_from_name', 's:6:\"Qansah\";', 1762718480),
('qansah2-cache-setting_email_smtp_encryption', 's:3:\"tls\";', 1762718480),
('qansah2-cache-setting_email_smtp_host', 's:0:\"\";', 1762718480),
('qansah2-cache-setting_email_smtp_password', 's:0:\"\";', 1762718480),
('qansah2-cache-setting_email_smtp_port', 'd:587;', 1762718480),
('qansah2-cache-setting_email_smtp_username', 's:0:\"\";', 1762718480),
('qansah2-cache-setting_general_app_description_6', 's:0:\"\";', 1761627668),
('qansah2-cache-setting_general_app_keywords_6', 's:0:\"\";', 1761627668),
('qansah2-cache-setting_general_app_name', 's:7:\"Qansah2\";', 1762718480),
('qansah2-cache-setting_general_app_name_2', 's:7:\"Qansah2\";', 1762824007),
('qansah2-cache-setting_general_app_name_3', 's:7:\"Qansah2\";', 1762113529),
('qansah2-cache-setting_general_app_name_4', 's:7:\"Qansah2\";', 1761628740),
('qansah2-cache-setting_general_app_name_6', 's:7:\"Qansah2\";', 1762727298),
('qansah2-cache-setting_general_app_version', 's:5:\"2.0.0\";', 1762718480),
('qansah2-cache-setting_general_app_version_6', 's:5:\"2.0.0\";', 1761627613),
('qansah2-cache-setting_general_maintenance_estimated_time_6', 'N;', 1761627689),
('qansah2-cache-setting_general_maintenance_message_6', 's:0:\"\";', 1761627613),
('qansah2-cache-setting_general_maintenance_mode_6', 'b:0;', 1761627613),
('qansah2-cache-setting_general_site_favicon', 's:16:\"/img/favicon.ico\";', 1762718480),
('qansah2-cache-setting_general_site_favicon_6', 's:16:\"/img/favicon.ico\";', 1761627613),
('qansah2-cache-setting_general_site_logo', 's:37:\"/storage/settings/logo_1761623446.svg\";', 1762718480),
('qansah2-cache-setting_general_site_logo_2', 's:37:\"/storage/settings/logo_1761623446.svg\";', 1762824007),
('qansah2-cache-setting_general_site_logo_3', 's:37:\"/storage/settings/logo_1761623446.svg\";', 1762113529),
('qansah2-cache-setting_general_site_logo_4', 's:37:\"/storage/settings/logo_1761623446.svg\";', 1761628740),
('qansah2-cache-setting_general_site_logo_6', 's:37:\"/storage/settings/logo_1761623446.svg\";', 1762727298),
('qansah2-cache-setting_notifications_email_notifications_6', 'b:1;', 1761627613),
('qansah2-cache-setting_notifications_notification_sound_6', 'b:1;', 1761627668),
('qansah2-cache-setting_notifications_push_notifications_6', 'b:1;', 1761627613),
('qansah2-cache-setting_security_force_https_6', 'b:0;', 1761627668),
('qansah2-cache-setting_security_password_min_length_6', 'i:8;', 1761627668),
('qansah2-cache-setting_security_session_lifetime_6', 'i:120;', 1761627668),
('qansah2-cache-setting_seo_facebook_pixel_id_2', 's:0:\"\";', 1762718480),
('qansah2-cache-setting_seo_facebook_pixel_id_3', 'N;', 1762114053),
('qansah2-cache-setting_seo_facebook_pixel_id_6', 'N;', 1762112870),
('qansah2-cache-setting_seo_google_analytics_id_2', 's:0:\"\";', 1762718480),
('qansah2-cache-setting_seo_google_analytics_id_3', 'N;', 1762114053),
('qansah2-cache-setting_seo_google_analytics_id_6', 'N;', 1762112870),
('qansah2-cache-setting_seo_google_tag_manager_2', 's:0:\"\";', 1762718480),
('qansah2-cache-setting_seo_google_tag_manager_3', 'N;', 1762114053),
('qansah2-cache-setting_seo_google_tag_manager_6', 'N;', 1762112870),
('qansah2-cache-setting_seo_meta_description_template_2', 's:35:\"Discover the best deals and coupons\";', 1762718480),
('qansah2-cache-setting_seo_meta_description_template_3', 's:35:\"Discover the best deals and coupons\";', 1762114053),
('qansah2-cache-setting_seo_meta_description_template_6', 's:37:\"Discover the best deals and coupons 2\";', 1762112870),
('qansah2-cache-setting_seo_meta_keywords_2', 's:31:\"coupons,deals,discounts,savings\";', 1762718480),
('qansah2-cache-setting_seo_meta_keywords_3', 's:31:\"coupons,deals,discounts,savings\";', 1762114053),
('qansah2-cache-setting_seo_meta_keywords_6', 's:31:\"coupons,deals,discounts,savings\";', 1762112870),
('qansah2-cache-setting_seo_meta_title_template_2', 's:11:\"%s - Qansah\";', 1762718480),
('qansah2-cache-setting_seo_meta_title_template_3', 's:13:\"%s - Qansah 2\";', 1762114053),
('qansah2-cache-setting_seo_meta_title_template_6', 's:11:\"%s - Qansah\";', 1762112870),
('qansah2-cache-setting_social_facebook_app_id', 's:0:\"\";', 1762718480),
('qansah2-cache-setting_social_facebook_app_id_6', 's:0:\"\";', 1761627613),
('qansah2-cache-setting_social_facebook_url_6', 's:0:\"\";', 1761627662),
('qansah2-cache-setting_social_google_client_id', 's:0:\"\";', 1762718480),
('qansah2-cache-setting_social_google_client_id_6', 's:0:\"\";', 1761627613),
('qansah2-cache-setting_social_instagram_url_6', 's:0:\"\";', 1761627662),
('qansah2-cache-setting_social_linkedin_url_6', 's:0:\"\";', 1761627662),
('qansah2-cache-setting_social_twitter_url_6', 's:0:\"\";', 1761627662),
('qansah2-cache-setting_social_youtube_url_6', 's:0:\"\";', 1761627662),
('qansah2-cache-subscription_rate_limit:22:subscribe', 'i:1;', 1761992768),
('qansah2-cache-subscription_rate_limit:22:subscribe:timer', 'i:1761992768;', 1761992768);

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

--
-- Table structure for table `cache_locks`
--

CREATE TABLE `cache_locks` (
  `key` varchar(255) NOT NULL,
  `owner` varchar(255) NOT NULL,
  `expiration` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `carousels`
--

CREATE TABLE `carousels` (
  `id` bigint NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_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 `carousels`
--

INSERT INTO `carousels` (`id`, `type`, `name`, `slug`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'home', 'Mahmoud Galal', 'mahmoud-galal', 1, '2025-10-19 14:41:03', '2025-10-19 14:41:03'),
(2, 'home', 'Mahmoud Galal', 'html', 1, '2025-10-19 14:48:41', '2025-11-02 17:54:18');

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

--
-- Table structure for table `carousel_slides`
--

CREATE TABLE `carousel_slides` (
  `id` bigint NOT NULL,
  `carousel_id` bigint DEFAULT NULL,
  `linkable_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `linkable_id` bigint 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 `carousel_slides`
--

INSERT INTO `carousel_slides` (`id`, `carousel_id`, `linkable_type`, `linkable_id`, `created_at`, `updated_at`) VALUES
(1, 1, NULL, NULL, '2025-10-19 14:58:30', '2025-10-19 14:58:30');

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

--
-- Table structure for table `carousel_slide_translations`
--

CREATE TABLE `carousel_slide_translations` (
  `id` bigint NOT NULL,
  `carousel_slide_id` bigint NOT NULL,
  `locale_id` bigint NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `button_link` text COLLATE utf8mb4_unicode_ci,
  `button_text` varchar(255) COLLATE utf8mb4_unicode_ci 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 `carousel_slide_translations`
--

INSERT INTO `carousel_slide_translations` (`id`, `carousel_slide_id`, `locale_id`, `title`, `description`, `button_link`, `button_text`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 'ahmed', 'ahmed', NULL, NULL, '2025-10-19 14:58:30', '2025-10-19 14:58:30');

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` bigint NOT NULL,
  `is_featured` tinyint(1) NOT NULL DEFAULT '0',
  `order` int DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'draft',
  `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 `categories`
--

INSERT INTO `categories` (`id`, `is_featured`, `order`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 0, 'active', '2025-10-17 08:51:19', '2025-10-19 14:01:11');

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

--
-- Table structure for table `category_country_store`
--

CREATE TABLE `category_country_store` (
  `id` bigint NOT NULL,
  `category_id` bigint NOT NULL,
  `country_store_id` bigint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `category_country_store`
--

INSERT INTO `category_country_store` (`id`, `category_id`, `country_store_id`) VALUES
(2, 1, 5);

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

--
-- Table structure for table `category_offer`
--

CREATE TABLE `category_offer` (
  `id` bigint NOT NULL,
  `category_id` bigint NOT NULL,
  `offer_id` bigint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `category_translations`
--

CREATE TABLE `category_translations` (
  `id` bigint NOT NULL,
  `category_id` bigint NOT NULL,
  `language_id` bigint NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8mb4_unicode_ci,
  `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 `category_translations`
--

INSERT INTO `category_translations` (`id`, `category_id`, `language_id`, `name`, `description`, `created_at`, `updated_at`) VALUES
(1, 1, 3, 'test', NULL, '2025-10-17 08:51:19', '2025-10-17 08:51:19'),
(2, 1, 1, 'test23', NULL, '2025-10-17 08:51:19', '2025-10-17 09:41:42');

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

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` bigint NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(2) COLLATE utf8mb4_unicode_ci NOT NULL,
  `iso_code` varchar(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `iso2` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dial_code` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency` varchar(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency_code` varchar(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency_symbol` varchar(8) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `flag_url` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order` int DEFAULT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT '0',
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'draft',
  `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`, `code`, `iso_code`, `iso2`, `dial_code`, `currency`, `currency_code`, `currency_symbol`, `flag_url`, `order`, `is_default`, `status`, `created_at`, `updated_at`) VALUES
(2, 'Saudi Arabia', 'SA', 'SAU', 'SA', '+966', 'SAR', 'SAR', 'ر.س', 'https://flagcdn.com/w320/sa.png', 0, 1, 'active', NULL, '2025-11-02 17:53:53'),
(3, 'United Arab Emirates', 'AE', 'ARE', 'AE', '+971', 'AED', 'AED', 'د.إ', 'https://flagcdn.com/w320/ae.png', 2, 0, 'active', NULL, '2025-10-19 16:11:59'),
(4, 'United States', 'US', 'USA', 'US', '+1', 'USD', 'USD', '$', 'https://flagcdn.com/w320/us.png', 3, 0, 'active', NULL, '2025-10-19 16:11:59'),
(5, 'United Kingdom', 'GB', 'GBR', 'GB', '+44', 'GBP', 'GBP', '£', 'https://flagcdn.com/w320/gb.png', 4, 0, 'active', NULL, '2025-10-19 16:11:59'),
(6, 'Brazil2', 'BR', 'BR', 'BR', '+55', 'BRL', 'BRL', 'R$', 'https://flagcdn.com/w320/br.png', 1, 0, 'active', '2025-10-17 08:31:16', '2025-11-02 17:53:53'),
(7, 'Egypt', 'EG', 'EGY', 'EG', '+20', 'EGP', 'EGP', '£', 'https://flagcdn.com/w320/eg.png', 0, 0, 'active', '2025-11-06 10:22:26', '2025-11-06 10:22:26');

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

--
-- Table structure for table `country_occasion`
--

CREATE TABLE `country_occasion` (
  `id` bigint NOT NULL,
  `country_id` bigint NOT NULL,
  `occasion_id` bigint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `country_occasion`
--

INSERT INTO `country_occasion` (`id`, `country_id`, `occasion_id`) VALUES
(1, 6, 1),
(2, 6, 2);

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

--
-- Table structure for table `country_store`
--

CREATE TABLE `country_store` (
  `id` bigint NOT NULL,
  `country_id` bigint NOT NULL,
  `store_id` bigint NOT NULL,
  `user_id` bigint DEFAULT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'draft',
  `is_featured` tinyint(1) NOT NULL DEFAULT '0',
  `order` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `country_store`
--

INSERT INTO `country_store` (`id`, `country_id`, `store_id`, `user_id`, `status`, `is_featured`, `order`, `created_at`, `updated_at`) VALUES
(5, 6, 5, 7, 'active', 0, 1, '2025-10-19 14:11:36', '2025-11-03 17:48:38'),
(6, 6, 6, 7, 'active', 0, 0, '2025-10-19 14:17:05', '2025-11-04 18:41:51');

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

--
-- Table structure for table `country_store_stats`
--

CREATE TABLE `country_store_stats` (
  `id` bigint NOT NULL,
  `country_store_id` bigint NOT NULL,
  `followers_count` int NOT NULL DEFAULT '0',
  `uses_count` int NOT NULL DEFAULT '0',
  `views_count` int NOT NULL DEFAULT '0',
  `impressions_count` int NOT NULL DEFAULT '0',
  `popularity` int NOT NULL DEFAULT '0',
  `max_discount` decimal(10,2) DEFAULT NULL,
  `avg_discount` decimal(10,2) DEFAULT NULL,
  `last_offer_added_at` timestamp NULL DEFAULT NULL,
  `last_usage` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `country_store_stats`
--

INSERT INTO `country_store_stats` (`id`, `country_store_id`, `followers_count`, `uses_count`, `views_count`, `impressions_count`, `popularity`, `max_discount`, `avg_discount`, `last_offer_added_at`, `last_usage`, `created_at`, `updated_at`) VALUES
(1, 5, 1, 0, 0, 0, 0, NULL, NULL, NULL, NULL, '2025-10-24 13:56:48', '2025-11-01 09:24:06');

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

--
-- Table structure for table `country_translations`
--

CREATE TABLE `country_translations` (
  `id` bigint NOT NULL,
  `country_id` bigint NOT NULL,
  `language_id` bigint NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci 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 `country_translations`
--

INSERT INTO `country_translations` (`id`, `country_id`, `language_id`, `name`, `created_at`, `updated_at`) VALUES
(1, 6, 3, 'Brazil English', '2025-10-17 08:32:18', '2025-10-17 08:32:18'),
(2, 6, 1, 'برازيل', '2025-10-22 00:20:53', '2025-10-22 00:20:53'),
(3, 3, 1, 'Mahmoud arab', '2025-10-24 16:43:06', '2025-10-24 16:43:06'),
(4, 3, 3, 'Mahmoud Galal', '2025-10-24 16:43:11', '2025-10-24 16:43:11');

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

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

CREATE TABLE `failed_jobs` (
  `id` bigint 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=latin1;

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

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint NOT NULL,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint NOT NULL,
  `reserved_at` int DEFAULT NULL,
  `available_at` int NOT NULL,
  `created_at` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int NOT NULL,
  `pending_jobs` int NOT NULL,
  `failed_jobs` int NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext,
  `cancelled_at` int DEFAULT NULL,
  `created_at` int NOT NULL,
  `finished_at` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `languages`
--

CREATE TABLE `languages` (
  `id` bigint NOT NULL,
  `code` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `native_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order` int DEFAULT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT '0',
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'draft',
  `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 `languages`
--

INSERT INTO `languages` (`id`, `code`, `name`, `native_name`, `order`, `is_default`, `status`, `created_at`, `updated_at`) VALUES
(1, 'ar', 'Arabic', 'العربية', 1, 0, 'active', '2025-10-15 12:40:12', '2025-10-17 08:55:38'),
(3, 'en', 'english', 'english', 0, 1, 'active', '2025-10-15 19:41:15', '2025-10-17 08:55:38');

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

--
-- Table structure for table `locales`
--

CREATE TABLE `locales` (
  `id` bigint NOT NULL,
  `language_id` bigint NOT NULL,
  `country_id` bigint NOT NULL,
  `code` varchar(10) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `order` int DEFAULT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT '0',
  `status` varchar(255) NOT NULL DEFAULT 'draft',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `locales`
--

INSERT INTO `locales` (`id`, `language_id`, `country_id`, `code`, `name`, `order`, `is_default`, `status`, `created_at`, `updated_at`) VALUES
(1, 3, 6, 'en-BR', 'BR EN', 0, 0, 'active', '2025-10-17 08:43:50', '2025-11-02 17:47:06'),
(2, 1, 6, 'ar-BR', 'BR AR', 1, 0, 'active', '2025-10-18 11:52:27', '2025-11-02 17:47:06'),
(3, 3, 3, 'en-AE', 'AE EN', 2, 1, 'active', '2025-10-24 16:45:20', '2025-11-02 17:47:06'),
(4, 1, 3, 'ar-AE', 'AE AR', 3, 0, 'active', '2025-10-24 16:45:41', '2025-11-02 17:47:06');

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

--
-- Table structure for table `media`
--

CREATE TABLE `media` (
  `id` bigint NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint NOT NULL,
  `uuid` char(36) DEFAULT NULL,
  `collection_name` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `mime_type` varchar(255) DEFAULT NULL,
  `disk` varchar(255) NOT NULL,
  `conversions_disk` varchar(255) DEFAULT NULL,
  `size` bigint NOT NULL,
  `manipulations` longtext NOT NULL,
  `custom_properties` longtext NOT NULL,
  `generated_conversions` longtext NOT NULL,
  `responsive_images` longtext NOT NULL,
  `order_column` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `media`
--

INSERT INTO `media` (`id`, `model_type`, `model_id`, `uuid`, `collection_name`, `name`, `file_name`, `mime_type`, `disk`, `conversions_disk`, `size`, `manipulations`, `custom_properties`, `generated_conversions`, `responsive_images`, `order_column`, `created_at`, `updated_at`) VALUES
(3, 'App\\Models\\Brand', 1, '793f8c3a-43ce-450c-8120-6fa109175c87', 'logo', 'Asset 6@3x', 'Asset-6@3x.png', 'image/png', 'public', 'public', 522754, '[]', '[]', '[]', '[]', 1, '2025-10-18 11:25:47', '2025-10-18 11:25:47'),
(4, 'App\\Models\\Occasion', 2, '2b4268b3-c110-4561-82e4-8b774f9e1335', 'icon', 'Asset 6@3x', 'Asset-6@3x.png', 'image/png', 'public', 'public', 522754, '[]', '[]', '[]', '[]', 1, '2025-10-18 15:32:01', '2025-10-18 15:32:01'),
(7, 'App\\Models\\CarouselSlide', 1, '9ddeaa1c-cc32-4406-ae5d-bf5bfded8e2f', 'image', 'Asset 6@3x', 'Asset-6@3x.png', 'image/png', 'public', 'public', 522754, '[]', '[]', '[]', '[]', 1, '2025-10-19 14:58:30', '2025-10-19 14:58:30'),
(14, 'App\\Models\\Store', 5, '16c00b4c-83a8-492f-9693-809d7a9965ec', 'logo', 'Bazil', 'Bazil.png', 'image/png', 'public', 'public', 3523, '[]', '[]', '[]', '[]', 1, '2025-11-04 19:04:46', '2025-11-04 19:04:46');

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

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

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

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

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'system',
  `notifiable_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notifiable_id` bigint DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` mediumtext COLLATE utf8mb4_unicode_ci,
  `data` longtext COLLATE utf8mb4_unicode_ci,
  `channels` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('pending','sent','failed') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `priority` tinyint NOT NULL DEFAULT '0',
  `read_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;

--
-- Dumping data for table `notifications`
--

INSERT INTO `notifications` (`id`, `type`, `notifiable_type`, `notifiable_id`, `title`, `message`, `data`, `channels`, `status`, `priority`, `read_at`, `created_at`, `updated_at`) VALUES
('105f09e2-4393-4cb8-a8e9-67d77d4cf536', 'promotional', NULL, NULL, 'dawwadaw', 'dwadwadawddwa', '{\"action_url\":null,\"image_url\":null,\"sound\":null,\"badge\":null}', '[\"database\"]', 'pending', 1, NULL, '2025-10-27 03:29:16', '2025-10-27 03:29:16');

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

--
-- Table structure for table `notification_deliveries`
--

CREATE TABLE `notification_deliveries` (
  `id` bigint NOT NULL,
  `notification_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint NOT NULL,
  `channel` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('pending','sent','failed','read') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `read_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 `notification_targets`
--

CREATE TABLE `notification_targets` (
  `id` bigint NOT NULL,
  `notification_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `target_type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `target_id` varchar(255) COLLATE utf8mb4_unicode_ci 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 `notification_targets`
--

INSERT INTO `notification_targets` (`id`, `notification_id`, `target_type`, `target_id`, `created_at`, `updated_at`) VALUES
(1, '105f09e2-4393-4cb8-a8e9-67d77d4cf536', 'all', NULL, '2025-10-27 03:29:16', '2025-10-27 03:29:16');

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

--
-- Table structure for table `occasions`
--

CREATE TABLE `occasions` (
  `id` bigint NOT NULL,
  `is_featured` tinyint(1) NOT NULL DEFAULT '0',
  `order` int DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'draft',
  `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 `occasions`
--

INSERT INTO `occasions` (`id`, `is_featured`, `order`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 'active', '2025-10-18 11:54:55', '2025-10-18 16:07:40'),
(2, 0, 0, 'draft', '2025-10-18 15:00:10', '2025-10-18 16:08:46');

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

--
-- Table structure for table `occasion_offer`
--

CREATE TABLE `occasion_offer` (
  `id` bigint NOT NULL,
  `occasion_id` bigint NOT NULL,
  `offer_id` bigint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `occasion_translations`
--

CREATE TABLE `occasion_translations` (
  `id` bigint NOT NULL,
  `occasion_id` bigint NOT NULL,
  `locale_id` bigint NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8mb4_unicode_ci,
  `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 `occasion_translations`
--

INSERT INTO `occasion_translations` (`id`, `occasion_id`, `locale_id`, `name`, `description`, `created_at`, `updated_at`) VALUES
(19, 1, 1, 'brazil en occasion_name', 'brazil en occasion_name', '2025-10-18 15:31:13', '2025-10-18 15:31:13'),
(20, 1, 2, 'برازيلي', NULL, '2025-10-18 15:31:13', '2025-10-18 15:31:13'),
(23, 2, 2, 'برازيلي', NULL, '2025-10-18 15:34:14', '2025-10-18 15:34:14');

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

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

CREATE TABLE `offers` (
  `id` bigint NOT NULL,
  `user_id` bigint DEFAULT NULL,
  `country_store_id` bigint NOT NULL,
  `brand_id` bigint DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'draft',
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'code',
  `code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `promotion_type` enum('monetary','percent','upto_monetary','upto_percent','custom_label') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'monetary',
  `promotion_value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `discount_value` decimal(10,2) DEFAULT NULL,
  `regular_price` decimal(10,2) DEFAULT NULL,
  `sale_price` decimal(10,2) DEFAULT NULL,
  `is_featured` tinyint(1) NOT NULL DEFAULT '0',
  `is_exclusive` tinyint(1) NOT NULL DEFAULT '0',
  `is_free_shipping` tinyint(1) NOT NULL DEFAULT '0',
  `is_new_customer` tinyint(1) NOT NULL DEFAULT '0',
  `store_order` int DEFAULT NULL,
  `brand_order` int DEFAULT NULL,
  `favorites_count` int NOT NULL DEFAULT '0',
  `uses_count` int NOT NULL DEFAULT '0',
  `views_count` int NOT NULL DEFAULT '0',
  `impressions_count` int NOT NULL DEFAULT '0',
  `popularity` int NOT NULL DEFAULT '0',
  `expires_at` timestamp NULL DEFAULT NULL,
  `last_usage` 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 `offer_translations`
--

CREATE TABLE `offer_translations` (
  `id` bigint NOT NULL,
  `offer_id` bigint NOT NULL,
  `locale_id` bigint NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8mb4_unicode_ci,
  `final_url` varchar(255) COLLATE utf8mb4_unicode_ci 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 `pages`
--

CREATE TABLE `pages` (
  `id` bigint NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'draft',
  `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 `pages`
--

INSERT INTO `pages` (`id`, `status`, `created_at`, `updated_at`) VALUES
(1, 'published', '2025-10-19 14:36:55', '2025-10-28 01:14:37');

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

--
-- Table structure for table `page_translations`
--

CREATE TABLE `page_translations` (
  `id` bigint NOT NULL,
  `page_id` bigint NOT NULL,
  `locale_id` bigint NOT NULL,
  `title` text COLLATE utf8mb4_unicode_ci,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `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 `page_translations`
--

INSERT INTO `page_translations` (`id`, `page_id`, `locale_id`, `title`, `description`, `created_at`, `updated_at`) VALUES
(7, 1, 1, 'ttt', 'ttt', '2025-10-28 01:28:53', '2025-10-28 01:28:53'),
(8, 1, 2, 'يصش', 'يشيصيش', '2025-10-28 01:28:53', '2025-10-28 01:28:53');

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

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

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

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text,
  `payload` longtext NOT NULL,
  `last_activity` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('5kcCr2dn4A93nuJ1w0Csq350BneEN8vZsWkaUscu', 7, '196.153.0.118', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoib2M2VWYzRXFFVWtxR1BNeUF2WTg4b2RZTWZzUWlhYkQ3WEE2QnVzSSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDQ6Imh0dHBzOi8vZGVtby5xYW5zYWguY29tL2FkbWluL2NvdW50cnktZmlsdGVyIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6Nzt9', 1762820408),
('6GquOCzI6ZzvXxmNOg7rRDpqlk60iOtlWx6n8T1I', NULL, '198.235.24.32', '', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiNHhOb1hiVnRHTU9WVUZLQ0ZxNU9PVmhkTWVpamZOdXVFOURqUEFpQyI7czo1OiJlcnJvciI7czoxOToiUGxlYXNlIGxvZyBpbiBmaXJzdCI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJuZXciO2E6MDp7fXM6Mzoib2xkIjthOjE6e2k6MDtzOjU6ImVycm9yIjt9fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjI5OiJodHRwczovL2RlbW8ucWFuc2FoLmNvbS9hZG1pbiI7fX0=', 1762803847),
('7pAESdFuP64vCr7pWnKsLYUAHSnPnpzDLZ1fFn1N', 7, '196.153.0.118', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiNFdmYjhMRHc3bjRRUlRFb1hkWlN5REtCNE1QeThMZEwwOGlwaGVpcSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDQ6Imh0dHBzOi8vZGVtby5xYW5zYWguY29tL2FkbWluL2NvdW50cnktZmlsdGVyIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6Nzt9', 1762806893),
('7teZVzq9beWgKkfGNYs8P3QmigiCycSUQ6FOlKJ1', NULL, '74.7.227.131', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.2; +https://openai.com/gptbot)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiaDFLakpUejZ5bDdHc0s3bXN2WW9xaEFuNDl6aXFnNEltY3BPS1paNyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzU6Imh0dHBzOi8vZGVtby5xYW5zYWguY29tL2FkbWluL2xvZ2luIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1762781809),
('bCF0zKNiQe8FMjF0h9Sdt8ifrA5GtxGUfm039QTp', NULL, '198.235.24.161', '', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiN2NBVlNUWlpNdHVheXZFbVBCTFhqWWZwQW1DVDZNUU94dXA0cmJoTiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjM6Imh0dHBzOi8vZGVtby5xYW5zYWguY29tIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1762801087),
('byiqFcnHFFm9KzeuDJJ66zuFY3vbztojA7OWzObA', NULL, '41.236.4.92', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiZzNwUTZwNG01TlZrMVRoYWN2UGc0WUFxcGdUQndjVGFzNVZCVG1WUCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzI6Imh0dHBzOi8vZGVtby5xYW5zYWguY29tL2RvY3MvYXBpIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1762799639),
('dAYIT1jIPhfMmPhgz65Uk81kwue2l2i2JZkKaG7K', NULL, '198.235.24.161', '', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiNHdkY0VoTHZ5ell1dlRjSVBiQW9hbTZROEZYck5pczM4TEYwQlNBMiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzU6Imh0dHBzOi8vZGVtby5xYW5zYWguY29tL2FkbWluL2xvZ2luIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1762801088),
('fHgyrD54JvtFIbOYi4lBPO5HzUt43Nu7HwL7FoEQ', 7, '156.207.45.247', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoia21lSkwySDZYVlR5UWZ4anVzd1dMZ0VtVmZpVktWQ0x3bUhVR0h5VSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDQ6Imh0dHBzOi8vZGVtby5xYW5zYWguY29tL2FkbWluL2NvdW50cnktZmlsdGVyIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6Nzt9', 1762785750),
('h8jGh1zItgEj1GQp0a5dih4zwsqqV7DhGqOD3cw8', NULL, '198.235.24.161', '', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiWllxVGc2cmV3d0puaEtyYWoyRDQ5blRieUZzYnBWTVpCUjNnZGVHUSI7czo1OiJlcnJvciI7czoxOToiUGxlYXNlIGxvZyBpbiBmaXJzdCI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJuZXciO2E6MDp7fXM6Mzoib2xkIjthOjE6e2k6MDtzOjU6ImVycm9yIjt9fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjI5OiJodHRwczovL2RlbW8ucWFuc2FoLmNvbS9hZG1pbiI7fX0=', 1762801088),
('IuY3LwB1LhBglxBZ2Ltup8al8iz8EboSShXq7cFr', NULL, '159.203.144.167', 'Mozilla/5.0 (iPhone; CPU iPhone OS 14_0 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/14.0 Mobile/15E148 Safari/605.1.15', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiUEEzYzNrdmROdVVHazgweE9KM1hJUTcyaGVHYWJkQWdPUlhua240TiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTM6Imh0dHBzOi8vcWFuc2FoLmNvbS9kZW1vLnFhbnNhaC5jb20vcHVibGljL2FkbWluL2xvZ2luIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1762790391),
('J2iQo5DFU2Sp6duoMPZ3T6guPqbLZDEwkcq2u7nv', 7, '102.184.238.162', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiMng2dkI5YWVmVW4zUHNjWHpXemF6VUpRMW5ZZmhzdmp4ZlllUU5MdSI7czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6NztzOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czo0NDoiaHR0cHM6Ly9kZW1vLnFhbnNhaC5jb20vYWRtaW4vY291bnRyeS1maWx0ZXIiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1762737325),
('KVPcH8eO1inTsC6pAkLrmjy4y35Snka0Omi6A56P', NULL, '198.235.24.32', '', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiRUxvd2tXQk5vU1k4a0Z4ZFZyaVpuMFRab0ZVMXpRYUt2eWpqdmdoaSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjM6Imh0dHBzOi8vZGVtby5xYW5zYWguY29tIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1762803847),
('PZuGakb40KzyKhhX32JMNiukohyWX5F5mCtpFPRX', 7, '196.153.4.210', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoibHd5bDhBSHl1U2dyREhlTERTc1l6VFA0ZzRidUJMajBtbm1kZnM4eiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDQ6Imh0dHBzOi8vZGVtby5xYW5zYWguY29tL2FkbWluL2NvdW50cnktZmlsdGVyIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6NztzOjIwOiJhZG1pbl9jb3VudHJ5X2ZpbHRlciI7aTo2O30=', 1762723700),
('qlddKy0Xq5wQhtPvQtQxQZY4SqYnK6e2SL7Aj9L2', NULL, '2607:f5b4:88:105:1c00:90ff:fe00:295', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Mobile Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiRHl4Mm5PQU4yZHZvcWN1dGxXT2JRUmpHRU05MlBNWXM5Zkk3SzdKaiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTM6Imh0dHBzOi8vcWFuc2FoLmNvbS9kZW1vLnFhbnNhaC5jb20vcHVibGljL2FkbWluL2xvZ2luIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1762790382),
('SRQuw8LDZ6aU7aVQeKsKi1Zv4D3myRYyr1OeJz3b', NULL, '159.203.144.167', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36,gzip(gfe)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiSlJaOFRweENDUlN0TGhCU3ZuWmc5c1BlMkVLWks0bDdrZGpJU3BuQSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTM6Imh0dHBzOi8vcWFuc2FoLmNvbS9kZW1vLnFhbnNhaC5jb20vcHVibGljL2FkbWluL2xvZ2luIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1762790381),
('ZxR7CXEX4J76LJ2kgBF3LlIAJRaJvRRsPOhZOZs1', NULL, '198.235.24.32', '', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiblMzbmpMU2dyQkdGSWpMM1NDcGlsbFhaT0s0d0NpbG5rUVJKMEhoMyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzU6Imh0dHBzOi8vZGVtby5xYW5zYWguY29tL2FkbWluL2xvZ2luIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1762803847);

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

--
-- Table structure for table `stores`
--

CREATE TABLE `stores` (
  `id` bigint NOT NULL,
  `user_id` bigint 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 `stores`
--

INSERT INTO `stores` (`id`, `user_id`, `created_at`, `updated_at`) VALUES
(5, 7, '2025-10-19 14:11:36', '2025-10-19 14:11:36'),
(6, 7, '2025-10-19 14:17:05', '2025-10-19 14:17:05');

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

--
-- Table structure for table `store_translations`
--

CREATE TABLE `store_translations` (
  `id` bigint NOT NULL,
  `store_id` bigint NOT NULL,
  `locale_id` bigint NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` mediumtext COLLATE utf8mb4_unicode_ci,
  `home_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `final_url` varchar(255) COLLATE utf8mb4_unicode_ci 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 `store_translations`
--

INSERT INTO `store_translations` (`id`, `store_id`, `locale_id`, `name`, `description`, `home_url`, `final_url`, `created_at`, `updated_at`) VALUES
(10, 6, 1, 'store_name', 'store_name', NULL, NULL, '2025-10-19 14:17:05', '2025-10-19 14:17:05'),
(29, 5, 1, 'metro brazil', 'store_name *', 'https://example.com', 'https://example.com/teck', '2025-11-04 19:04:46', '2025-11-04 19:04:46'),
(30, 5, 2, 'مترو برازيل', 'براند', NULL, NULL, '2025-11-04 19:04:46', '2025-11-04 19:04:46');

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

--
-- Table structure for table `subscriptions`
--

CREATE TABLE `subscriptions` (
  `id` bigint NOT NULL,
  `user_id` bigint NOT NULL,
  `subscribable_type` varchar(255) NOT NULL,
  `subscribable_id` bigint NOT NULL,
  `type` varchar(255) NOT NULL DEFAULT 'follow',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `subscriptions`
--

INSERT INTO `subscriptions` (`id`, `user_id`, `subscribable_type`, `subscribable_id`, `type`, `created_at`, `updated_at`) VALUES
(2, 7, 'App\\Models\\Category', 1, 'follow', '2025-10-24 13:58:00', '2025-10-24 13:58:00'),
(3, 7, 'App\\Models\\Brand', 1, 'follow', '2025-10-24 13:59:30', '2025-10-24 13:59:30'),
(4, 22, 'App\\Models\\CountryStore', 5, 'follow', '2025-11-01 09:24:06', '2025-11-01 09:24:06'),
(5, 22, 'App\\Models\\Category', 1, 'follow', '2025-11-01 09:25:00', '2025-11-01 09:25:00');

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

--
-- Table structure for table `user_locales`
--

CREATE TABLE `user_locales` (
  `id` bigint NOT NULL,
  `user_id` bigint NOT NULL,
  `locale_id` bigint DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_locales`
--

INSERT INTO `user_locales` (`id`, `user_id`, `locale_id`, `created_at`, `updated_at`) VALUES
(1, 19, 3, '2025-10-24 16:41:16', '2025-10-27 00:57:24'),
(2, 7, 1, '2025-10-24 16:46:42', '2025-10-28 01:21:14'),
(3, 22, 2, '2025-11-01 09:13:23', '2025-11-01 09:13:23');

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

--
-- Table structure for table `user_providers`
--

CREATE TABLE `user_providers` (
  `id` bigint NOT NULL,
  `user_id` bigint NOT NULL,
  `provider` varchar(255) NOT NULL,
  `provider_id` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user_providers`
--

INSERT INTO `user_providers` (`id`, `user_id`, `provider`, `provider_id`, `created_at`, `updated_at`) VALUES
(2, 21, 'google', 'provider_user_string', '2025-11-01 09:01:46', '2025-11-01 09:01:46');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `bans`
--
ALTER TABLE `bans`
  ADD PRIMARY KEY (`id`),
  ADD KEY `bans_bannable_type_bannable_id_index` (`bannable_type`,`bannable_id`),
  ADD KEY `bans_created_by_type_created_by_id_index` (`created_by_type`,`created_by_id`),
  ADD KEY `bans_expired_at_index` (`expired_at`);

--
-- Indexes for table `brands`
--
ALTER TABLE `brands`
  ADD PRIMARY KEY (`id`),
  ADD KEY `brands_is_featured_index` (`is_featured`),
  ADD KEY `brands_order_index` (`order`),
  ADD KEY `brands_status_index` (`status`);

--
-- Indexes for table `brand_translations`
--
ALTER TABLE `brand_translations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `brand_translations_brand_id_language_id_unique` (`brand_id`,`language_id`),
  ADD KEY `brand_translations_language_id_foreign` (`language_id`),
  ADD KEY `brand_translations_name_index` (`name`);

--
-- Indexes for table `cache`
--
ALTER TABLE `cache`
  ADD PRIMARY KEY (`key`);

--
-- Indexes for table `cache_locks`
--
ALTER TABLE `cache_locks`
  ADD PRIMARY KEY (`key`);

--
-- Indexes for table `carousels`
--
ALTER TABLE `carousels`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `carousels_slug_unique` (`slug`),
  ADD KEY `carousels_is_active_index` (`is_active`);

--
-- Indexes for table `carousel_slides`
--
ALTER TABLE `carousel_slides`
  ADD PRIMARY KEY (`id`),
  ADD KEY `carousel_slides_carousel_id_foreign` (`carousel_id`),
  ADD KEY `carousel_slides_linkable_type_linkable_id_index` (`linkable_type`,`linkable_id`);

--
-- Indexes for table `carousel_slide_translations`
--
ALTER TABLE `carousel_slide_translations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `carousel_slide_translations_carousel_slide_id_locale_id_unique` (`carousel_slide_id`,`locale_id`),
  ADD KEY `carousel_slide_translations_locale_id_foreign` (`locale_id`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `categories_is_featured_index` (`is_featured`),
  ADD KEY `categories_order_index` (`order`),
  ADD KEY `categories_status_index` (`status`);

--
-- Indexes for table `category_country_store`
--
ALTER TABLE `category_country_store`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `category_country_store_category_id_country_store_id_unique` (`category_id`,`country_store_id`),
  ADD KEY `category_country_store_country_store_id_foreign` (`country_store_id`);

--
-- Indexes for table `category_offer`
--
ALTER TABLE `category_offer`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `category_offer_category_id_offer_id_unique` (`category_id`,`offer_id`),
  ADD KEY `category_offer_offer_id_foreign` (`offer_id`);

--
-- Indexes for table `category_translations`
--
ALTER TABLE `category_translations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `category_translations_category_id_language_id_unique` (`category_id`,`language_id`),
  ADD KEY `category_translations_language_id_foreign` (`language_id`),
  ADD KEY `category_translations_name_index` (`name`);

--
-- Indexes for table `countries`
--
ALTER TABLE `countries`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `code` (`code`),
  ADD UNIQUE KEY `countries_code_unique` (`code`),
  ADD KEY `countries_is_default_index` (`is_default`),
  ADD KEY `countries_status_index` (`status`),
  ADD KEY `idx_iso_code` (`iso_code`),
  ADD KEY `idx_iso2` (`iso2`),
  ADD KEY `idx_name` (`name`);

--
-- Indexes for table `country_occasion`
--
ALTER TABLE `country_occasion`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `country_occasion_country_id_occasion_id_unique` (`country_id`,`occasion_id`),
  ADD KEY `country_occasion_occasion_id_foreign` (`occasion_id`);

--
-- Indexes for table `country_store`
--
ALTER TABLE `country_store`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `country_store_country_id_store_id_unique` (`country_id`,`store_id`),
  ADD KEY `country_store_store_id_foreign` (`store_id`),
  ADD KEY `country_store_user_id_foreign` (`user_id`),
  ADD KEY `country_store_status_index` (`status`),
  ADD KEY `country_store_is_featured_index` (`is_featured`),
  ADD KEY `country_store_order_index` (`order`);

--
-- Indexes for table `country_store_stats`
--
ALTER TABLE `country_store_stats`
  ADD PRIMARY KEY (`id`),
  ADD KEY `country_store_stats_country_store_id_popularity_index` (`country_store_id`,`popularity`),
  ADD KEY `country_store_stats_followers_count_index` (`followers_count`),
  ADD KEY `country_store_stats_uses_count_index` (`uses_count`),
  ADD KEY `country_store_stats_views_count_index` (`views_count`),
  ADD KEY `country_store_stats_impressions_count_index` (`impressions_count`),
  ADD KEY `country_store_stats_popularity_index` (`popularity`),
  ADD KEY `country_store_stats_max_discount_index` (`max_discount`),
  ADD KEY `country_store_stats_avg_discount_index` (`avg_discount`),
  ADD KEY `country_store_stats_last_offer_added_at_index` (`last_offer_added_at`),
  ADD KEY `country_store_stats_last_usage_index` (`last_usage`);

--
-- Indexes for table `country_translations`
--
ALTER TABLE `country_translations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `country_translations_country_id_language_id_unique` (`country_id`,`language_id`),
  ADD KEY `country_translations_language_id_foreign` (`language_id`);

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

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

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

--
-- Indexes for table `languages`
--
ALTER TABLE `languages`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `code` (`code`),
  ADD KEY `languages_code_unique` (`code`),
  ADD KEY `languages_is_default_index` (`is_default`),
  ADD KEY `languages_status_index` (`status`);

--
-- Indexes for table `locales`
--
ALTER TABLE `locales`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `locales_language_id_country_id_unique` (`language_id`,`country_id`),
  ADD UNIQUE KEY `locales_code_unique` (`code`),
  ADD KEY `locales_country_id_foreign` (`country_id`),
  ADD KEY `locales_is_default_index` (`is_default`),
  ADD KEY `locales_status_index` (`status`);

--
-- Indexes for table `media`
--
ALTER TABLE `media`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `media_uuid_unique` (`uuid`),
  ADD KEY `media_model_type_model_id_index` (`model_type`,`model_id`),
  ADD KEY `media_order_column_index` (`order_column`);

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

--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`),
  ADD KEY `notifications_status_index` (`status`),
  ADD KEY `notifications_priority_index` (`priority`);

--
-- Indexes for table `notification_deliveries`
--
ALTER TABLE `notification_deliveries`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_delivery` (`notification_id`,`user_id`,`channel`),
  ADD KEY `notification_deliveries_user_id_status_index` (`user_id`,`status`);

--
-- Indexes for table `notification_targets`
--
ALTER TABLE `notification_targets`
  ADD PRIMARY KEY (`id`),
  ADD KEY `notification_targets_notification_id_foreign` (`notification_id`),
  ADD KEY `idx_target_lookup` (`target_type`,`target_id`);

--
-- Indexes for table `occasions`
--
ALTER TABLE `occasions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `occasions_is_featured_index` (`is_featured`),
  ADD KEY `occasions_order_index` (`order`),
  ADD KEY `occasions_status_index` (`status`);

--
-- Indexes for table `occasion_offer`
--
ALTER TABLE `occasion_offer`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `occasion_offer_occasion_id_offer_id_unique` (`occasion_id`,`offer_id`),
  ADD KEY `occasion_offer_offer_id_foreign` (`offer_id`);

--
-- Indexes for table `occasion_translations`
--
ALTER TABLE `occasion_translations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `occasion_translations_occasion_id_locale_id_unique` (`occasion_id`,`locale_id`),
  ADD KEY `occasion_translations_name_index` (`name`),
  ADD KEY `occasion_translations_locale_id_index` (`locale_id`);

--
-- Indexes for table `offers`
--
ALTER TABLE `offers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `offers_user_id_foreign` (`user_id`),
  ADD KEY `offers_country_store_id_foreign` (`country_store_id`),
  ADD KEY `offers_brand_id_foreign` (`brand_id`),
  ADD KEY `offers_status_index` (`status`),
  ADD KEY `offers_type_index` (`type`),
  ADD KEY `offers_promotion_type_index` (`promotion_type`),
  ADD KEY `offers_discount_value_index` (`discount_value`),
  ADD KEY `offers_is_featured_index` (`is_featured`),
  ADD KEY `offers_is_exclusive_index` (`is_exclusive`),
  ADD KEY `offers_is_free_shipping_index` (`is_free_shipping`),
  ADD KEY `offers_is_new_customer_index` (`is_new_customer`),
  ADD KEY `offers_favorites_count_index` (`favorites_count`),
  ADD KEY `offers_uses_count_index` (`uses_count`),
  ADD KEY `offers_views_count_index` (`views_count`),
  ADD KEY `offers_impressions_count_index` (`impressions_count`),
  ADD KEY `offers_popularity_index` (`popularity`),
  ADD KEY `offers_expires_at_index` (`expires_at`),
  ADD KEY `offers_last_usage_index` (`last_usage`);

--
-- Indexes for table `offer_translations`
--
ALTER TABLE `offer_translations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `offer_translations_offer_id_locale_id_unique` (`offer_id`,`locale_id`),
  ADD KEY `offer_translations_locale_id_foreign` (`locale_id`),
  ADD KEY `offer_translations_title_index` (`title`);

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

--
-- Indexes for table `page_translations`
--
ALTER TABLE `page_translations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `page_translations_page_id_locale_id_unique` (`page_id`,`locale_id`),
  ADD KEY `page_translations_locale_id_foreign` (`locale_id`),
  ADD KEY `page_translations_title_index` (`title`(768));

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

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

--
-- Indexes for table `stores`
--
ALTER TABLE `stores`
  ADD PRIMARY KEY (`id`),
  ADD KEY `stores_user_id_foreign` (`user_id`);

--
-- Indexes for table `store_translations`
--
ALTER TABLE `store_translations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `store_translations_store_id_locale_id_unique` (`store_id`,`locale_id`),
  ADD KEY `store_translations_locale_id_foreign` (`locale_id`),
  ADD KEY `store_translations_name_index` (`name`);

--
-- Indexes for table `subscriptions`
--
ALTER TABLE `subscriptions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_user_subscription` (`user_id`,`subscribable_id`,`subscribable_type`,`type`),
  ADD KEY `subscriptions_subscribable_type_subscribable_id_index` (`subscribable_type`,`subscribable_id`),
  ADD KEY `idx_user_type` (`user_id`,`type`),
  ADD KEY `idx_user_subscribable_type` (`user_id`,`subscribable_type`,`subscribable_id`,`type`),
  ADD KEY `idx_subscribable_type` (`subscribable_type`,`subscribable_id`,`type`),
  ADD KEY `idx_subscribable_type_only` (`subscribable_type`,`type`);

--
-- Indexes for table `user_locales`
--
ALTER TABLE `user_locales`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `user_locales_user_id_locale_id_unique` (`user_id`,`locale_id`),
  ADD KEY `user_locales_locale_id_foreign` (`locale_id`);

--
-- Indexes for table `user_providers`
--
ALTER TABLE `user_providers`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `user_providers_provider_provider_id_unique` (`provider`,`provider_id`),
  ADD KEY `user_providers_user_id_foreign` (`user_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `bans`
--
ALTER TABLE `bans`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `brands`
--
ALTER TABLE `brands`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

--
-- AUTO_INCREMENT for table `carousels`
--
ALTER TABLE `carousels`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `carousel_slides`
--
ALTER TABLE `carousel_slides`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

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

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `category_country_store`
--
ALTER TABLE `category_country_store`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

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

--
-- AUTO_INCREMENT for table `category_translations`
--
ALTER TABLE `category_translations`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

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

--
-- AUTO_INCREMENT for table `country_occasion`
--
ALTER TABLE `country_occasion`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

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

--
-- AUTO_INCREMENT for table `country_store_stats`
--
ALTER TABLE `country_store_stats`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `notification_targets`
--
ALTER TABLE `notification_targets`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `occasions`
--
ALTER TABLE `occasions`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

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

--
-- AUTO_INCREMENT for table `occasion_translations`
--
ALTER TABLE `occasion_translations`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

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

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

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

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

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

--
-- AUTO_INCREMENT for table `store_translations`
--
ALTER TABLE `store_translations`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT for table `subscriptions`
--
ALTER TABLE `subscriptions`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `user_locales`
--
ALTER TABLE `user_locales`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `user_providers`
--
ALTER TABLE `user_providers`
  MODIFY `id` bigint NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `brand_translations`
--
ALTER TABLE `brand_translations`
  ADD CONSTRAINT `brand_translations_ibfk_1` FOREIGN KEY (`brand_id`) REFERENCES `brands` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `brand_translations_ibfk_2` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `carousel_slides`
--
ALTER TABLE `carousel_slides`
  ADD CONSTRAINT `carousel_slides_ibfk_1` FOREIGN KEY (`carousel_id`) REFERENCES `carousels` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `carousel_slide_translations`
--
ALTER TABLE `carousel_slide_translations`
  ADD CONSTRAINT `carousel_slide_translations_ibfk_1` FOREIGN KEY (`carousel_slide_id`) REFERENCES `carousel_slides` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `carousel_slide_translations_ibfk_2` FOREIGN KEY (`locale_id`) REFERENCES `locales` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `category_country_store`
--
ALTER TABLE `category_country_store`
  ADD CONSTRAINT `category_country_store_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `category_country_store_ibfk_2` FOREIGN KEY (`country_store_id`) REFERENCES `country_store` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `category_offer`
--
ALTER TABLE `category_offer`
  ADD CONSTRAINT `category_offer_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `category_offer_ibfk_2` FOREIGN KEY (`offer_id`) REFERENCES `offers` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `category_translations`
--
ALTER TABLE `category_translations`
  ADD CONSTRAINT `category_translations_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `category_translations_ibfk_2` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `country_occasion`
--
ALTER TABLE `country_occasion`
  ADD CONSTRAINT `country_occasion_ibfk_1` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `country_occasion_ibfk_2` FOREIGN KEY (`occasion_id`) REFERENCES `occasions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `country_store`
--
ALTER TABLE `country_store`
  ADD CONSTRAINT `country_store_ibfk_1` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `country_store_ibfk_2` FOREIGN KEY (`store_id`) REFERENCES `stores` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `country_store_ibfk_3` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `country_store_stats`
--
ALTER TABLE `country_store_stats`
  ADD CONSTRAINT `country_store_stats_ibfk_1` FOREIGN KEY (`country_store_id`) REFERENCES `country_store` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `country_translations`
--
ALTER TABLE `country_translations`
  ADD CONSTRAINT `country_translations_ibfk_1` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `country_translations_ibfk_2` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `locales`
--
ALTER TABLE `locales`
  ADD CONSTRAINT `locales_ibfk_1` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `locales_ibfk_2` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `notification_deliveries`
--
ALTER TABLE `notification_deliveries`
  ADD CONSTRAINT `notification_deliveries_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `occasion_offer`
--
ALTER TABLE `occasion_offer`
  ADD CONSTRAINT `occasion_offer_ibfk_1` FOREIGN KEY (`occasion_id`) REFERENCES `occasions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `occasion_offer_ibfk_2` FOREIGN KEY (`offer_id`) REFERENCES `offers` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `occasion_translations`
--
ALTER TABLE `occasion_translations`
  ADD CONSTRAINT `occasion_translations_locale_id_foreign` FOREIGN KEY (`locale_id`) REFERENCES `locales` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `offers`
--
ALTER TABLE `offers`
  ADD CONSTRAINT `offers_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `offers_ibfk_2` FOREIGN KEY (`country_store_id`) REFERENCES `country_store` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `offers_ibfk_3` FOREIGN KEY (`brand_id`) REFERENCES `brands` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `offer_translations`
--
ALTER TABLE `offer_translations`
  ADD CONSTRAINT `offer_translations_ibfk_1` FOREIGN KEY (`offer_id`) REFERENCES `offers` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `offer_translations_ibfk_2` FOREIGN KEY (`locale_id`) REFERENCES `locales` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `page_translations`
--
ALTER TABLE `page_translations`
  ADD CONSTRAINT `page_translations_ibfk_1` FOREIGN KEY (`page_id`) REFERENCES `pages` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `page_translations_ibfk_2` FOREIGN KEY (`locale_id`) REFERENCES `locales` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `stores`
--
ALTER TABLE `stores`
  ADD CONSTRAINT `stores_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `store_translations`
--
ALTER TABLE `store_translations`
  ADD CONSTRAINT `store_translations_ibfk_1` FOREIGN KEY (`store_id`) REFERENCES `stores` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `store_translations_ibfk_2` FOREIGN KEY (`locale_id`) REFERENCES `locales` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `subscriptions`
--
ALTER TABLE `subscriptions`
  ADD CONSTRAINT `subscriptions_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `user_locales`
--
ALTER TABLE `user_locales`
  ADD CONSTRAINT `user_locales_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `user_locales_ibfk_2` FOREIGN KEY (`locale_id`) REFERENCES `locales` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `user_providers`
--
ALTER TABLE `user_providers`
  ADD CONSTRAINT `user_providers_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

