--
-- Host: localhost    Database: seven_backend
-- ------------------------------------------------------


--
-- Table structure for table `ai_agents`
--

CREATE TABLE `ai_agents` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `public_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ai_provider_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `system_instructions` longtext COLLATE utf8mb4_unicode_ci,
  `allowed_subject_types` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `max_results` bigint(20) NOT NULL DEFAULT '3',
  `is_active` tinyint(1) NOT NULL DEFAULT '0',
  `lock_version` bigint(20) NOT NULL DEFAULT '0',
  `updated_by_user_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `deleted_by` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ai_agents_public_id_unique` (`public_id`),
  UNIQUE KEY `ai_agents_slug_unique` (`slug`),
  KEY `ai_agents_is_active_name_index` (`is_active`,`name`),
  KEY `ai_agents_deleted_at_index` (`deleted_at`),
  KEY `fk_8555f2b22f96` (`updated_by_user_id`),
  KEY `fk_5174a7ff2b72` (`ai_provider_id`),
  CONSTRAINT `fk_5174a7ff2b72` FOREIGN KEY (`ai_provider_id`) REFERENCES `ai_providers` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_8555f2b22f96` FOREIGN KEY (`updated_by_user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ai_agents`
--


--
-- Table structure for table `ai_providers`
--

CREATE TABLE `ai_providers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `public_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `driver` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'inactive',
  `encrypted_credentials` longtext COLLATE utf8mb4_unicode_ci,
  `configuration` longtext COLLATE utf8mb4_unicode_ci,
  `lock_version` bigint(20) NOT NULL DEFAULT '0',
  `last_health_checked_at` datetime DEFAULT NULL,
  `last_health_status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_by_user_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `deleted_by` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ai_providers_public_id_unique` (`public_id`),
  KEY `ai_providers_status_driver_index` (`status`,`driver`),
  KEY `ai_providers_deleted_at_index` (`deleted_at`),
  KEY `fk_4364b0555887` (`updated_by_user_id`),
  CONSTRAINT `fk_4364b0555887` FOREIGN KEY (`updated_by_user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ai_providers`
--


--
-- Table structure for table `ai_runs`
--

CREATE TABLE `ai_runs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `public_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ai_agent_id` bigint(20) unsigned NOT NULL,
  `actor_user_id` bigint(20) unsigned DEFAULT NULL,
  `intent` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `request_hash` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `retrieved_context` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `structured_output` longtext COLLATE utf8mb4_unicode_ci,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `provider_request_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `input_tokens` bigint(20) DEFAULT NULL,
  `output_tokens` bigint(20) DEFAULT NULL,
  `latency_ms` bigint(20) DEFAULT NULL,
  `failure_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `occurred_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ai_runs_public_id_unique` (`public_id`),
  KEY `ai_runs_ai_agent_id_occurred_at_index` (`ai_agent_id`,`occurred_at`),
  KEY `ai_runs_status_occurred_at_index` (`status`,`occurred_at`),
  KEY `fk_7043768bb7d7` (`actor_user_id`),
  CONSTRAINT `fk_14cd16e5f830` FOREIGN KEY (`ai_agent_id`) REFERENCES `ai_agents` (`id`) ON DELETE NO ACTION,
  CONSTRAINT `fk_7043768bb7d7` FOREIGN KEY (`actor_user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ai_runs`
--


--
-- Table structure for table `analytics_daily_metrics`
--

CREATE TABLE `analytics_daily_metrics` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `metric_definition_id` bigint(20) unsigned NOT NULL,
  `metric_date` date NOT NULL,
  `dimension_hash` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `dimensions` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `numerator` decimal(18,4) NOT NULL,
  `denominator` decimal(18,4) DEFAULT NULL,
  `value` decimal(18,4) NOT NULL,
  `computed_at` datetime NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `analytics_daily_metric_unique` (`metric_definition_id`,`metric_date`,`dimension_hash`),
  KEY `analytics_daily_metrics_metric_date_metric_definition_id_index` (`metric_date`,`metric_definition_id`),
  CONSTRAINT `fk_77f7a565df99` FOREIGN KEY (`metric_definition_id`) REFERENCES `analytics_metric_definitions` (`id`) ON DELETE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `analytics_daily_metrics`
--


--
-- Table structure for table `analytics_events`
--

CREATE TABLE `analytics_events` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `event_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `idempotency_key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `event_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `anonymous_id_hash` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `session_id_hash` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `consent` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `source` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `properties` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `occurred_at` datetime NOT NULL,
  `received_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `analytics_events_event_id_unique` (`event_id`),
  UNIQUE KEY `analytics_events_idempotency_key_unique` (`idempotency_key`),
  KEY `analytics_events_event_name_occurred_at_index` (`event_name`,`occurred_at`),
  KEY `analytics_events_consent_source_occurred_at_index` (`consent`,`source`,`occurred_at`),
  KEY `analytics_events_session_id_hash_occurred_at_index` (`session_id_hash`,`occurred_at`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `analytics_events`
--

INSERT INTO `analytics_events` VALUES (1,'d5806fa8-7a21-4649-b624-3fedc9771c77','6f9936c5df05358114bfecd24ae87644666341d442fd0fa8bb7f9787240fb176','page.view','d6c6723286c359dac3c4aade123cb2361fae30ca145640cb343b6b699725e877','c33ea093d63cfd8538b0474661863fecfe201836d1e2ebcd83608040055d3df5','granted','web','{\"path\":\"\\/services\\/ui-ux-design\",\"referrer_domain\":\"postman.local\"}','2026-08-18 15:11:52','2026-08-18 15:11:52'),(2,'2fce12ae-dfd4-4397-a4b0-445203f756c7','70b1912389b1d2eb62e5cae2cf78a9483a8cfdd3a1a337c0d91225fa522820ea','page.view','d6c6723286c359dac3c4aade123cb2361fae30ca145640cb343b6b699725e877','4a5557fc984e7f1f411d3b1474426643b1e759b5b99b89390ff56adcba744081','granted','web','{\"path\":\"\\/postman-empty-body-example\",\"referrer_domain\":\"postman.local\"}','2026-08-18 15:21:56','2026-08-18 15:21:56'),(3,'c7f414f2-0206-4ac5-9b0d-7f2954c0ee56','2357b6329b9091eeda7408900bd7bab74d90ab1b3ca6a2b9d6ce92d6743ee2ce','page.view','d6c6723286c359dac3c4aade123cb2361fae30ca145640cb343b6b699725e877','4a5557fc984e7f1f411d3b1474426643b1e759b5b99b89390ff56adcba744081','granted','web','{\"path\":\"\\/postman-empty-body-example\",\"referrer_domain\":\"postman.local\"}','2026-08-18 15:22:23','2026-08-18 15:22:23'),(4,'df8bbde2-7e04-4ea3-a6f1-057d38bd32db','a286c7ffcc2649f38140f349d83310b51bc7466d69a744ca4089969ecbd6731f','page.view','d6c6723286c359dac3c4aade123cb2361fae30ca145640cb343b6b699725e877','4a5557fc984e7f1f411d3b1474426643b1e759b5b99b89390ff56adcba744081','granted','web','{\"path\":\"\\/postman-empty-body-example\",\"referrer_domain\":\"postman.local\"}','2026-08-18 15:23:15','2026-08-18 15:23:15'),(5,'2920d81b-0fcf-4281-b5ec-c71a93919ad3','914d6e6e07486effb1b8df67fcf05cc1ba56759f6eaf88f67275603a8c94be6e','page.view','2c0c8bd6c79093c99557922ea229202eaf2bfb5d9ec879dc4ae19e870ee7cf3a','75fada4fd9e15aa3abb85878282098857bf52b0cebc0eb902b1e84061e2a2439','granted','web','{\"path\":\"\\/services\\/ui-ux-design\",\"referrer_domain\":\"test-suite.local\"}','2026-08-19 07:19:08','2026-08-19 07:19:09'),(6,'c830a254-b9f8-49de-96f4-0bc5f43fa783','a324217c12f978c25b231be9b5c1b48d471f6967c889327f189b6b022e457e68','page.view','2c0c8bd6c79093c99557922ea229202eaf2bfb5d9ec879dc4ae19e870ee7cf3a','75fada4fd9e15aa3abb85878282098857bf52b0cebc0eb902b1e84061e2a2439','granted','web','{\"path\":\"\\/services\\/ui-ux-design\",\"referrer_domain\":\"test-suite.local\"}','2026-08-19 07:19:08','2026-08-19 07:19:09'),(7,'19dc4428-d465-4887-b026-431bed08a1bf','62b70fcb0aed3b08bc51cdd5a3f58ea35f7ea33eb499d8aeee0f0e31be27bc3c','page.view','2c0c8bd6c79093c99557922ea229202eaf2bfb5d9ec879dc4ae19e870ee7cf3a','75fada4fd9e15aa3abb85878282098857bf52b0cebc0eb902b1e84061e2a2439','granted','web','{\"path\":\"\\/services\\/ui-ux-design\",\"referrer_domain\":\"test-suite.local\"}','2026-08-19 07:23:14','2026-08-19 07:23:14'),(8,'93019cea-44d7-43d5-959b-e67729c5acae','5b9fab065f0e38bbfa08a8819b496b59ae42cd953143de4c84e75f91a0b80194','page.view','2c0c8bd6c79093c99557922ea229202eaf2bfb5d9ec879dc4ae19e870ee7cf3a','75fada4fd9e15aa3abb85878282098857bf52b0cebc0eb902b1e84061e2a2439','granted','web','{\"path\":\"\\/services\\/ui-ux-design\",\"referrer_domain\":\"test-suite.local\"}','2026-08-19 07:23:14','2026-08-19 07:23:15'),(9,'60d75763-13b4-4620-8754-588cfbbb8649','1882ed055d65738fe63bbc82b435350542a3866e1dc20988c97b59a5ed25010e','page.view','2c0c8bd6c79093c99557922ea229202eaf2bfb5d9ec879dc4ae19e870ee7cf3a','75fada4fd9e15aa3abb85878282098857bf52b0cebc0eb902b1e84061e2a2439','granted','web','{\"path\":\"\\/services\\/ui-ux-design\",\"referrer_domain\":\"test-suite.local\"}','2026-08-19 07:25:52','2026-08-19 07:25:53'),(10,'c50b5d8d-f870-4f01-9acb-469d36b3c1a9','c95c4fcd0d1dd7049cfee26cb6daf27804e525424a16162e1231fb59ce91fa5b','page.view','2c0c8bd6c79093c99557922ea229202eaf2bfb5d9ec879dc4ae19e870ee7cf3a','75fada4fd9e15aa3abb85878282098857bf52b0cebc0eb902b1e84061e2a2439','granted','web','{\"path\":\"\\/services\\/ui-ux-design\",\"referrer_domain\":\"test-suite.local\"}','2026-08-19 07:25:52','2026-08-19 07:25:53'),(11,'acb4d787-583c-4a16-bac9-bd91ad608059','a8c732479e3ba4cf8618b4a5aea738fad42554c70eee37d9558326440932666f','page.view','2c0c8bd6c79093c99557922ea229202eaf2bfb5d9ec879dc4ae19e870ee7cf3a','75fada4fd9e15aa3abb85878282098857bf52b0cebc0eb902b1e84061e2a2439','granted','web','{\"path\":\"\\/services\\/ui-ux-design\",\"referrer_domain\":\"test-suite.local\"}','2026-08-19 07:28:59','2026-08-19 07:29:00'),(12,'91fd0cc8-e7be-40b4-8b2b-d6e885ba55ed','6e1df1dbfdd300d07d5f91e8d01b0e0876bbe0cbd82a898b3b5b6c84c4854f29','page.view','2c0c8bd6c79093c99557922ea229202eaf2bfb5d9ec879dc4ae19e870ee7cf3a','75fada4fd9e15aa3abb85878282098857bf52b0cebc0eb902b1e84061e2a2439','granted','web','{\"path\":\"\\/services\\/ui-ux-design\",\"referrer_domain\":\"test-suite.local\"}','2026-08-19 07:28:59','2026-08-19 07:29:00'),(13,'7d7663b1-a1c1-4982-bf4c-466d3d33e2d8','65e1f4a447957a441a776ab641a26d06ed5b5d4c0c997b8f4fde904ffae62956','page.view','2c0c8bd6c79093c99557922ea229202eaf2bfb5d9ec879dc4ae19e870ee7cf3a','75fada4fd9e15aa3abb85878282098857bf52b0cebc0eb902b1e84061e2a2439','granted','web','{\"path\":\"\\/services\\/ui-ux-design\",\"referrer_domain\":\"test-suite.local\"}','2026-08-19 07:41:47','2026-08-19 07:41:48'),(14,'e2bf4ab2-86da-4b7a-b072-514c529e3671','3ed3b14cfa49251cd0d69b0c0a5551cd3c9065c1abab91f9c94253b519329e08','page.view','2c0c8bd6c79093c99557922ea229202eaf2bfb5d9ec879dc4ae19e870ee7cf3a','75fada4fd9e15aa3abb85878282098857bf52b0cebc0eb902b1e84061e2a2439','granted','web','{\"path\":\"\\/services\\/ui-ux-design\",\"referrer_domain\":\"test-suite.local\"}','2026-08-19 07:41:47','2026-08-19 07:41:48'),(15,'26f16bc6-17ac-4831-8639-c3d1985ba2b8','97a2068b8be10c52c6aaf76bf31fa8946fea2f07c58f57e3b412bcd431334b15','page.view','2c0c8bd6c79093c99557922ea229202eaf2bfb5d9ec879dc4ae19e870ee7cf3a','75fada4fd9e15aa3abb85878282098857bf52b0cebc0eb902b1e84061e2a2439','granted','web','{\"path\":\"\\/services\\/ui-ux-design\",\"referrer_domain\":\"test-suite.local\"}','2026-08-19 08:28:28','2026-08-19 08:28:28'),(16,'c7b4e25b-1724-4849-9eef-8693d43ac3a1','70fd5c59e99036b1df21be2f6947c35c0a73ef592cfd9ec4369091bb2c45f1c2','page.view','2c0c8bd6c79093c99557922ea229202eaf2bfb5d9ec879dc4ae19e870ee7cf3a','75fada4fd9e15aa3abb85878282098857bf52b0cebc0eb902b1e84061e2a2439','granted','web','{\"path\":\"\\/services\\/ui-ux-design\",\"referrer_domain\":\"test-suite.local\"}','2026-08-19 08:28:28','2026-08-19 08:28:29'),(17,'a3a5567e-620e-484e-b8a5-b232baed765a','0723b6e6ec488d654d0d337271976d4d73b4a4f2a1c8989b4793b347c8eb0092','page.view','2c0c8bd6c79093c99557922ea229202eaf2bfb5d9ec879dc4ae19e870ee7cf3a','75fada4fd9e15aa3abb85878282098857bf52b0cebc0eb902b1e84061e2a2439','granted','web','{\"path\":\"\\/services\\/ui-ux-design\",\"referrer_domain\":\"test-suite.local\"}','2026-08-19 08:37:40','2026-08-19 08:37:41'),(18,'8563c0ad-6bbb-43d3-8932-b6285c837c5b','3aeeb013160a5801d460b974f5aa48275ce06b87430da59424887dddcdfc9a88','page.view','2c0c8bd6c79093c99557922ea229202eaf2bfb5d9ec879dc4ae19e870ee7cf3a','75fada4fd9e15aa3abb85878282098857bf52b0cebc0eb902b1e84061e2a2439','granted','web','{\"path\":\"\\/services\\/ui-ux-design\",\"referrer_domain\":\"test-suite.local\"}','2026-08-19 08:37:40','2026-08-19 08:37:41'),(19,'7b4fa574-888f-413b-ba07-85dde0b287d8','0eac62e24de84e3f80ab80b6b3e5c785dd492c7080d849efd73257fae6d434c1','page.view','2c0c8bd6c79093c99557922ea229202eaf2bfb5d9ec879dc4ae19e870ee7cf3a','75fada4fd9e15aa3abb85878282098857bf52b0cebc0eb902b1e84061e2a2439','granted','web','{\"path\":\"\\/services\\/ui-ux-design\",\"referrer_domain\":\"test-suite.local\"}','2026-08-19 08:39:27','2026-08-19 08:39:27'),(20,'e3faed88-f5b0-4330-a392-2a266216902e','dbfc22547ee9558a2788491f929252c6c779899a9862a754ecfbce04a9f774bf','page.view','2c0c8bd6c79093c99557922ea229202eaf2bfb5d9ec879dc4ae19e870ee7cf3a','75fada4fd9e15aa3abb85878282098857bf52b0cebc0eb902b1e84061e2a2439','granted','web','{\"path\":\"\\/services\\/ui-ux-design\",\"referrer_domain\":\"test-suite.local\"}','2026-08-19 08:39:27','2026-08-19 08:39:28'),(21,'8f954661-bb4b-40b5-8546-e9c10b17edda','a9b91feddbc6c9e4145b79b8fc92a3c265077784199b167f4de3f9d7ddbf5e09','page.view','2c0c8bd6c79093c99557922ea229202eaf2bfb5d9ec879dc4ae19e870ee7cf3a','75fada4fd9e15aa3abb85878282098857bf52b0cebc0eb902b1e84061e2a2439','granted','web','{\"path\":\"\\/services\\/ui-ux-design\",\"referrer_domain\":\"test-suite.local\"}','2026-08-19 09:21:23','2026-08-19 09:21:23'),(22,'5956a999-50ad-4db3-9b37-19cf6370e7b3','046ee3d41bbe4f85161bb1230f340d19e1905c5a370b5571ec45d19519a16ec2','page.view','2c0c8bd6c79093c99557922ea229202eaf2bfb5d9ec879dc4ae19e870ee7cf3a','75fada4fd9e15aa3abb85878282098857bf52b0cebc0eb902b1e84061e2a2439','granted','web','{\"path\":\"\\/services\\/ui-ux-design\",\"referrer_domain\":\"test-suite.local\"}','2026-08-19 09:21:23','2026-08-19 09:21:24'),(23,'36598be9-59e8-42d5-9bb0-a2e28202b4e9','f40cbe3d90c29e47bc3b39248e5c116a882b1a68f28881e7cb29c4c346e81dcd','page.view','2c0c8bd6c79093c99557922ea229202eaf2bfb5d9ec879dc4ae19e870ee7cf3a','75fada4fd9e15aa3abb85878282098857bf52b0cebc0eb902b1e84061e2a2439','granted','web','{\"path\":\"\\/services\\/ui-ux-design\",\"referrer_domain\":\"test-suite.local\"}','2026-08-20 06:17:05','2026-08-20 06:17:06'),(24,'4c3be6fd-109c-4db4-b4d2-f546d4722b19','0461ef7ce1972cda18734bed5bad9ebf4ef2d90ef65ce4522d5efbcad8f1de14','page.view','2c0c8bd6c79093c99557922ea229202eaf2bfb5d9ec879dc4ae19e870ee7cf3a','75fada4fd9e15aa3abb85878282098857bf52b0cebc0eb902b1e84061e2a2439','granted','web','{\"path\":\"\\/services\\/ui-ux-design\",\"referrer_domain\":\"test-suite.local\"}','2026-08-20 06:17:05','2026-08-20 06:17:07');

--
-- Table structure for table `analytics_metric_definitions`
--

CREATE TABLE `analytics_metric_definitions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `version` bigint(20) NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `aggregation` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `numerator_event` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `denominator_event` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `decimal_places` bigint(20) NOT NULL DEFAULT '0',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `effective_from` datetime NOT NULL,
  `effective_to` datetime DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `analytics_metric_definitions_code_version_unique` (`code`,`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `analytics_metric_definitions`
--


--
-- Table structure for table `api_access_tokens`
--

CREATE TABLE `api_access_tokens` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `public_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token_hash` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_used_at` datetime DEFAULT NULL,
  `expires_at` datetime DEFAULT NULL,
  `revoked_at` datetime DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `api_access_tokens_public_id_unique` (`public_id`),
  UNIQUE KEY `api_access_tokens_token_hash_unique` (`token_hash`),
  KEY `api_access_tokens_user_id_revoked_at_index` (`user_id`,`revoked_at`),
  KEY `api_access_tokens_expires_at_index` (`expires_at`),
  KEY `api_access_tokens_revoked_at_index` (`revoked_at`),
  CONSTRAINT `fk_fffc468bb68b` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `api_access_tokens`
--

INSERT INTO `api_access_tokens` VALUES (1,'8cd799aa-f5cf-4e11-aaff-87f1675ba44b',1,'Postman local','766ef706e9bd758f2b35d7799cd3d91836836a1f3f2cfa93c83dc62d52fae877','2026-08-15 16:19:38','2026-08-16 15:44:04','2026-08-15 16:19:38','2026-08-15 15:44:04','2026-08-15 16:19:38'),(2,'90a4db5a-3d0c-4ecb-8355-6bcccd631e86',1,'Postman replacement','6fc44445a859c2118cfc0a15f7c8edb41cb7396ac9f8f4e90bdb80863b05ac16','2026-08-15 16:24:09','2026-08-16 16:24:08','2026-08-18 16:29:00','2026-08-15 16:24:08','2026-08-18 16:29:00'),(3,'2500e53c-d271-4729-bcba-2d6525fc9135',1,'Revocation verification','25b32438f6712881c3c02cfff467fc22e900ef4d7759758cc51157bbd4537e50',NULL,'2026-08-16 16:24:09','2026-08-15 16:24:09','2026-08-15 16:24:09','2026-08-15 16:24:09'),(4,'04e971fc-843f-4daa-8a33-bff945ba5701',1,'Codex verification token','80e8c9b6b8e14ed1f9336ede392d3867c1acb9be2c23e584b67a0e964453f783','2026-08-18 15:06:44','2026-08-19 15:06:43','2026-08-18 15:06:44','2026-08-18 15:06:43','2026-08-18 15:06:44'),(5,'e224b2dc-951e-4347-998c-8d4bb2658f2d',1,'Postman Local Ready','7c09a85c2d95f05c4ff028e935bf57a885b21dec71c6d2de9ca12dfd6118b83a','2026-08-18 15:54:09','2026-08-19 15:25:04','2026-08-18 15:54:28','2026-08-18 15:25:04','2026-08-18 15:54:28'),(6,'1b0ebc5e-28ef-4576-beb6-3e22c92a9b75',1,'Postman delete verification','7021b14eea4a1b08b31f2a446281860665cd163e9c94072585fb9affef0005a8','2026-08-18 15:58:37','2026-08-19 15:58:36','2026-08-18 15:58:37','2026-08-18 15:58:36','2026-08-18 15:58:37'),(7,'4ee50003-aeb7-4d46-a0ca-12bcd921c690',1,'Disposable DELETE endpoint check','88236f5bc7f61f91330fd9c8864a75b685652c0f6ecb092740ecbdd773a9b579',NULL,'2026-08-19 16:12:00','2026-08-18 16:12:34','2026-08-18 16:12:00','2026-08-18 16:12:34'),(8,'0087f3c8-6ee9-49bb-87d7-7a8492eb7ca0',1,'Postman Local Ready','e216f5e6b434a7582c676d5de19771c053212f0cbd02ba40a2de03bcbc848e4f','2026-08-18 16:12:34','2026-08-19 16:12:33','2026-08-18 16:29:00','2026-08-18 16:12:33','2026-08-18 16:29:00'),(9,'de8f51f0-217b-4ef5-b073-1272b5b8d816',1,'Endpoint Test Suite Token','e47f61855d36f1c9bb287b9afa07b7d7d11ab90f21b5d13715eafc107db2767a','2026-08-19 07:25:45','2026-08-20 07:25:44','2026-08-23 16:32:38','2026-08-19 07:25:44','2026-08-23 16:32:38'),(10,'d2247b7f-12f4-4b08-af8f-c7ab0ff7144e',1,'Secondary Token to Delete','e95f459997ae8a0d02835587827fc33ed5ed3e68eb6c65edeaac4ed42c94ef4c',NULL,'2026-08-20 07:26:00','2026-08-19 07:26:00','2026-08-19 07:26:00','2026-08-19 07:26:00'),(11,'0ea9ce4e-d160-4583-aa13-b96eafcb124f',1,'Self Revoke Token','78c6deb7d9f8bfd4797c13ac58a6c80ab8249c980d064f407176c545c1af71ab','2026-08-19 07:26:01','2026-08-20 07:26:01','2026-08-19 07:26:01','2026-08-19 07:26:01','2026-08-19 07:26:01'),(12,'8fec8d30-3e1d-445a-9674-811c9670a0de',1,'Endpoint Test Suite Token','bd933b043862b40a88ad83edd6657cb4a9b71f70de0e48de2cf1de69b097002a','2026-08-19 07:28:52','2026-08-20 07:28:51','2026-08-23 16:32:38','2026-08-19 07:28:51','2026-08-23 16:32:38'),(13,'77d1ff43-0228-4705-8341-f97a8c221d9c',1,'Secondary Token to Delete','ac0eb42ee85cfb2256e68c2c7241cc9f2667263d1b25e28cbf8cd600a5b4eef1',NULL,'2026-08-20 07:29:06','2026-08-19 07:29:07','2026-08-19 07:29:06','2026-08-19 07:29:07'),(14,'7206914f-b66a-4a4b-939e-632bba9f6ed9',1,'Self Revoke Token','78f91fd58cc9cb1677bb78c7a3556fd5ca346d97b685b52f73b0b62a5776ff0f','2026-08-19 07:29:08','2026-08-20 07:29:08','2026-08-19 07:29:08','2026-08-19 07:29:08','2026-08-19 07:29:08'),(15,'467c5bff-2ce1-4d81-a0c3-1f15dfe15d37',1,'Endpoint Test Suite Token','cdb2694c46030bfd651b2f402edb9d3b8d9ea1c50010d26d3df6e5f0fad501f5','2026-08-19 07:41:38','2026-08-20 07:41:38','2026-08-23 16:32:38','2026-08-19 07:41:38','2026-08-23 16:32:38'),(16,'886fa3b5-e2b2-4f55-a8ea-315a7f3461bf',1,'Secondary Token to Delete','1e8bc5dd9b8910879d385582f34d4239c4542c01949394e88871311dc7bb78e5',NULL,'2026-08-20 07:41:56','2026-08-19 07:41:57','2026-08-19 07:41:56','2026-08-19 07:41:57'),(17,'f1d50e6c-618a-4db7-8cba-42f4fcdeb40e',1,'Self Revoke Token','260bc9515b8832040abbde7f4a4e82d77a40f44df05d2f756c93b18d18e36eb2','2026-08-19 07:41:58','2026-08-20 07:41:58','2026-08-19 07:41:58','2026-08-19 07:41:58','2026-08-19 07:41:58'),(18,'80c5f989-14ac-46c8-b51c-ea2aa5a4754a',1,'Endpoint Test Suite Token','88de052d38ef795c6dcb02a70356a4c31c363bd3f2e18a14487c36e5ff3be833','2026-08-19 08:28:19','2026-08-20 08:28:18','2026-08-23 16:32:38','2026-08-19 08:28:18','2026-08-23 16:32:38'),(19,'5028ab5b-6be4-4c2c-9245-fae128f7d2be',1,'Secondary Token to Delete','6f5b6ffb8662c6c50b47ae536310d74e94a469979696d5a69106d5a6b8f615b5',NULL,'2026-08-20 08:28:37','2026-08-19 08:28:37','2026-08-19 08:28:37','2026-08-19 08:28:37'),(20,'1aea9e8c-87df-4fc1-86f8-a54f465e2069',1,'Self Revoke Token','b1ca62f5f723578028aa213a9748bf9cfadb197f353a2c5aed74803d2a7ce7d1','2026-08-19 08:28:39','2026-08-20 08:28:38','2026-08-19 08:28:39','2026-08-19 08:28:38','2026-08-19 08:28:39'),(21,'8fb72535-09fe-48f8-9d1c-b8cd51a3f439',1,'Endpoint Test Suite Token','05ba08daa52b27a378c01571ed08c1aa904ea37fdeefec8cb1928f89d134abef','2026-08-19 08:37:33','2026-08-20 08:37:32','2026-08-23 16:32:38','2026-08-19 08:37:32','2026-08-23 16:32:38'),(22,'667b6798-575d-4420-84dd-440dcab8a03b',1,'Secondary Token to Delete','0d36d12b1687de4a9634b601186a7b440b353a6fa7233657c97cce9bd215533d',NULL,'2026-08-20 08:37:48','2026-08-19 08:37:49','2026-08-19 08:37:48','2026-08-19 08:37:49'),(23,'9832fdda-aca0-41d7-92fe-4532315f1124',1,'Self Revoke Token','64a147c750e146f0e43f8f18c164d611cd65eb2d27bf95073511259d96086a98','2026-08-19 08:37:50','2026-08-20 08:37:49','2026-08-19 08:37:50','2026-08-19 08:37:49','2026-08-19 08:37:50'),(24,'058006b1-4773-4894-9ce3-2ce720093dc2',1,'Endpoint Test Suite Token','841dce9fca6ccae1f2eab5991cb40406b20c777b708f54fb4c7b41ace0428d1f','2026-08-19 08:39:19','2026-08-20 08:39:18','2026-08-23 16:32:38','2026-08-19 08:39:18','2026-08-23 16:32:38'),(25,'bd2fdc00-bf89-477e-ac89-6bfff21a7e95',1,'Secondary Token to Delete','43df3d94e76c806b0e6d10d7a1e3330ed1771934247b4d8a2e5d3af5721c04c0',NULL,'2026-08-20 08:39:34','2026-08-19 08:39:35','2026-08-19 08:39:34','2026-08-19 08:39:35'),(26,'10bc3b46-56b6-4963-a6a2-db97acffdde2',1,'Self Revoke Token','a75184575959ed91f38ba994c2539acafbab477c528da95fe127900f338c6ad6','2026-08-19 08:39:36','2026-08-20 08:39:36','2026-08-19 08:39:36','2026-08-19 08:39:36','2026-08-19 08:39:36'),(27,'4941cdaa-3a62-4c12-904b-8a2c6cb2c529',1,'Endpoint Test Suite Token','f4762e4d61c3d3c88b4342323afcd15fa0c6f1ce3940ea3dd42873d7331821a2','2026-08-19 09:21:15','2026-08-20 09:21:14','2026-08-23 16:32:38','2026-08-19 09:21:14','2026-08-23 16:32:38'),(28,'b9ba6738-2fe4-428c-9673-7a65f48789ad',1,'Secondary Token to Delete','95ef4b910d83d58233a8ee78ae2bc8d5b8dafe8c5f54d33950949ed333096808',NULL,'2026-08-20 09:21:31','2026-08-19 09:21:31','2026-08-19 09:21:31','2026-08-19 09:21:31'),(29,'88fc64c0-51ac-432a-bb80-4587e5bae256',1,'Self Revoke Token','9caa44c0261d417edbcf2a84f75a73efb8915cead1aabc9750253b9a29e41f54','2026-08-19 09:21:32','2026-08-20 09:21:32','2026-08-19 09:21:32','2026-08-19 09:21:32','2026-08-19 09:21:32'),(30,'c15a2406-5597-457f-aa8d-9aa53cca3a1c',1,'Endpoint Test Suite Token','2661ae937487555ab2c5dba3bf388fe2014555bda5307bd90ff7f4447803f988','2026-08-20 06:16:55','2026-08-21 06:16:54','2026-08-23 16:32:38','2026-08-20 06:16:54','2026-08-23 16:32:38'),(31,'a0cb35c8-b65f-4798-a087-5bded88a0230',1,'Secondary Token to Delete','0f94f5d13d7ca9704d2282c5f03ad16888fc9167716262755669fdc6087af58e',NULL,'2026-08-21 06:17:15','2026-08-20 06:17:16','2026-08-20 06:17:15','2026-08-20 06:17:16'),(32,'90953248-7b9e-4008-ab50-476da0f909be',1,'Self Revoke Token','95b873f9586701cfaf30c08244086fe37ddc601815984210baa6a0567ca09c38','2026-08-20 06:17:17','2026-08-21 06:17:17','2026-08-20 06:17:17','2026-08-20 06:17:17','2026-08-20 06:17:17'),(33,'dd87c5c4-0c69-43ac-b04f-b17b3f7cf621',1,'Automated endpoint audit','0d10d994f56c03c57e7a9aae5e5172f84a6fc0cd91b22cdd43eb6ca03fe36e2a',NULL,'2026-08-24 16:29:34','2026-08-23 16:31:12','2026-08-23 16:29:34','2026-08-23 16:31:12'),(34,'283ec446-a573-43de-8299-f900eda57329',1,'Automated endpoint audit','3d95974234c10478973e10f4ad094c21d6f38b0dfcc0f1c3803966d42ebd7327','2026-08-23 16:31:59','2026-08-24 16:31:56','2026-08-23 16:32:38','2026-08-23 16:31:56','2026-08-23 16:32:38'),(35,'46c1777e-2f21-432a-a300-7cab05e1c4e5',1,'Automated endpoint audit','f233483ef926768204d226364afda7c93862bff4d662d7f7bedb75940ff17f0b','2026-08-23 16:43:15','2026-08-24 16:36:23','2026-08-23 16:46:02','2026-08-23 16:36:23','2026-08-23 16:46:02'),(36,'a47c0d08-7d14-4f54-804a-ef633d0138e1',1,'Automated endpoint audit','cd41aa105f8d2a9b7e38fb5cc0ffa27c9a8eca5dcdaa52bef59644eb122e0e54','2026-08-23 16:46:06','2026-08-24 16:46:03','2026-08-23 16:46:47','2026-08-23 16:46:03','2026-08-23 16:46:47'),(37,'c8fce8a8-73c5-4969-8311-e7123c62ba2a',1,'Endpoint scan secondary token','19cc3dd670c84c2eab526ace19977fdc035c286652e3599e370606fd883b144a',NULL,'2026-08-24 16:46:45','2026-08-23 16:46:46','2026-08-23 16:46:45','2026-08-23 16:46:46'),(38,'067d6e40-0bad-4a18-9db9-ba6d104d6b3e',1,'Endpoint scan self-revocation token','92d11afc53f6619a65ed668dfdafd3c97935674a232ed56d009e75997ba826d1','2026-08-23 16:46:46','2026-08-24 16:46:46','2026-08-23 16:46:46','2026-08-23 16:46:46','2026-08-23 16:46:46'),(39,'a4213f4f-cbab-43d7-be0f-8db82dcc0bad',1,'Verification Runner','1cd2ef1f9b9f3a39cb138d4fa4fe0464c1ceef9eab44f12fe9cfe32031fdcd51','2026-08-24 08:24:14','2026-08-31 08:24:14',NULL,'2026-08-24 08:24:14','2026-08-24 08:24:14'),(40,'591c28ac-33c6-415f-a5cd-e87f44b3fa34',1,'Verification Runner','3d66bba3aeb76714a624f98867387be16f6eaa3f13bd3385f3b7581253628f11','2026-08-24 08:25:32','2026-08-31 08:25:32',NULL,'2026-08-24 08:25:32','2026-08-24 08:25:32');

--
-- Table structure for table `audit_archive_entries`
--

CREATE TABLE `audit_archive_entries` (
  `audit_archive_id` bigint(20) unsigned NOT NULL,
  `audit_log_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`audit_archive_id`,`audit_log_id`),
  UNIQUE KEY `audit_archive_entries_audit_log_id_unique` (`audit_log_id`),
  CONSTRAINT `fk_e33015e5f65b` FOREIGN KEY (`audit_archive_id`) REFERENCES `audit_archives` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_f30fc5bf0136` FOREIGN KEY (`audit_log_id`) REFERENCES `audit_logs` (`id`) ON DELETE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `audit_archive_entries`
--


--
-- Table structure for table `audit_archives`
--

CREATE TABLE `audit_archives` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `public_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cutoff_at` datetime NOT NULL,
  `first_log_id` bigint(20) unsigned NOT NULL,
  `last_log_id` bigint(20) unsigned NOT NULL,
  `records_count` bigint(20) NOT NULL,
  `storage_disk` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `storage_path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `checksum_sha256` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `byte_size` bigint(20) NOT NULL,
  `created_by_user_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `audit_archives_public_id_unique` (`public_id`),
  UNIQUE KEY `audit_archives_storage_path_unique` (`storage_path`),
  KEY `audit_archives_cutoff_at_created_at_index` (`cutoff_at`,`created_at`),
  KEY `fk_8b7840c3380f` (`created_by_user_id`),
  CONSTRAINT `fk_8b7840c3380f` FOREIGN KEY (`created_by_user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `audit_archives`
--


--
-- Table structure for table `audit_logs`
--

CREATE TABLE `audit_logs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `actor_user_id` bigint(20) unsigned DEFAULT NULL,
  `action` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `result` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'succeeded',
  `request_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ip_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `before_values` longtext COLLATE utf8mb4_unicode_ci,
  `after_values` longtext COLLATE utf8mb4_unicode_ci,
  `occurred_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `audit_logs_subject_type_subject_id_occurred_at_index` (`subject_type`,`subject_id`,`occurred_at`),
  KEY `audit_logs_actor_user_id_occurred_at_index` (`actor_user_id`,`occurred_at`),
  KEY `audit_logs_action_result_occurred_at_index` (`action`,`result`,`occurred_at`),
  CONSTRAINT `fk_019aa78023a9` FOREIGN KEY (`actor_user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `audit_logs`
--

INSERT INTO `audit_logs` VALUES (1,NULL,'role.assigned','App\\Modules\\Identity\\Domain\\Models\\User','d25b1a83-fe98-4dc4-8533-d312c56683c5','succeeded',NULL,'127.0.0.1',NULL,'{\"role\":\"super-admin\"}','2026-08-14 13:56:27'),(2,1,'role.created','App\\Modules\\AccessControl\\Domain\\Models\\Role','data-analyst','succeeded','63dc1f86-5947-4afe-a4f4-882a50314709','127.0.0.1',NULL,'{\"name\":\"Mariam Elshazly\",\"is_active\":true,\"permissions\":[\"analytics.view\"]}','2026-08-15 06:23:59'),(3,1,'role.deleted','App\\Modules\\AccessControl\\Domain\\Models\\Role','data-analyst','succeeded','d5d618bd-cc5b-4955-83bd-bb0595ad300a','127.0.0.1',NULL,NULL,'2026-08-15 06:26:18'),(4,1,'role.created','App\\Modules\\AccessControl\\Domain\\Models\\Role','data-analyst','succeeded','ee5c27f7-d4d1-4527-a4b5-a2567a415938','127.0.0.1',NULL,'{\"name\":\"Data Analyst\",\"is_active\":true,\"permissions\":[\"analytics.view\"]}','2026-08-15 07:00:22'),(5,1,'user.created','App\\Modules\\Identity\\Domain\\Models\\User','22b64763-624b-4699-a0e8-7f0946e11cc0','succeeded','e0551de8-d7e8-40f0-9d55-bb80a22923dd','127.0.0.1',NULL,'{\"name\":\"Mariam Elshazly\",\"email_hash\":\"a9b89d89cfc66dcb6bec3a79e369e5490b47c8e5f96bf3d587ee99c247d71787\",\"timezone\":\"UTC\",\"locale\":\"en\",\"is_active\":true,\"email_verified\":false,\"force_password_change\":\"[REDACTED]\",\"roles\":[\"data-analyst\"]}','2026-08-15 07:01:31'),(6,1,'user.updated','App\\Modules\\Identity\\Domain\\Models\\User','d25b1a83-fe98-4dc4-8533-d312c56683c5','succeeded','672c82c4-f03a-4764-a1e3-932ad96f64b4','127.0.0.1','{\"name\":\"Tech Administrator 7\",\"email_hash\":\"82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255\",\"timezone\":\"Africa\\/Cairo\",\"locale\":\"ar\",\"is_active\":true,\"email_verified\":true,\"force_password_change\":\"[REDACTED]\",\"roles\":[\"super-admin\"]}','{\"name\":\"CEO. Diaa\",\"email_hash\":\"82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255\",\"timezone\":\"Africa\\/Cairo\",\"locale\":\"ar\",\"is_active\":true,\"email_verified\":true,\"force_password_change\":\"[REDACTED]\",\"roles\":[\"super-admin\"]}','2026-08-15 07:06:20'),(7,1,'user.updated','App\\Modules\\Identity\\Domain\\Models\\User','22b64763-624b-4699-a0e8-7f0946e11cc0','succeeded','d8552b2e-4c91-4aeb-b129-8f261eaf8d9f','127.0.0.1','{\"name\":\"Mariam Elshazly\",\"email_hash\":\"a9b89d89cfc66dcb6bec3a79e369e5490b47c8e5f96bf3d587ee99c247d71787\",\"timezone\":\"UTC\",\"locale\":\"en\",\"is_active\":true,\"email_verified\":false,\"force_password_change\":\"[REDACTED]\",\"roles\":[\"data-analyst\"]}','{\"name\":\"Mariam Elshazly\",\"email_hash\":\"a9b89d89cfc66dcb6bec3a79e369e5490b47c8e5f96bf3d587ee99c247d71787\",\"timezone\":\"UTC\",\"locale\":\"en\",\"is_active\":true,\"email_verified\":false,\"force_password_change\":\"[REDACTED]\",\"roles\":[\"data-analyst\"]}','2026-08-15 07:57:55'),(8,1,'role.permissions_replaced','App\\Modules\\AccessControl\\Domain\\Models\\Role','data-analyst','succeeded','15d69a91-f5e5-4cf6-b1c1-67851a24d6c6','127.0.0.1','{\"permissions\":[\"analytics.view\"]}','{\"permissions\":[\"analytics.view\",\"dashboard.view\",\"home.manage\",\"notifications.manage\",\"pricing.manage\",\"pricing.view\",\"projects.manage\",\"services.create\",\"services.delete\",\"services.update\",\"services.view\",\"templates.manage\"]}','2026-08-15 08:15:39'),(9,1,'media.uploaded','App\\Modules\\Media\\Domain\\Models\\Media','175cf764-65d5-4705-8ad4-a915840ab615','succeeded','f2ca23c2-29ea-420d-9092-54e513761b27','127.0.0.1',NULL,'{\"mime_type\":\"image\\/jpeg\",\"byte_size\":37736,\"visibility\":\"public\",\"checksum\":\"49c8a41416f0c1c4720db72b51e5033c897c7661a48b7f7000e2bcf8ad3b787d\"}','2026-08-15 08:26:57'),(10,1,'media.deleted','App\\Modules\\Media\\Domain\\Models\\Media','175cf764-65d5-4705-8ad4-a915840ab615','succeeded','8a3509d6-3fdd-4ca6-b570-ab55a4d81910','127.0.0.1',NULL,NULL,'2026-08-15 08:27:12'),(11,1,'audit.manual_archive_created','App\\Foundation\\Audit\\Models\\ManualArchiveRecord','46926f53-4237-450f-b24c-dcb7c283de0c','succeeded','67ac4614-5ada-4265-bc73-7548f13e18c5','127.0.0.1',NULL,'{\"title\":\"a\",\"has_attachment\":true,\"checksum_sha256\":\"9ec565f7cf12b848012371e68652b4ed42d0c8f77eeb0718d199834b7cf61fe4\"}','2026-08-15 13:02:34'),(12,1,'application.status_changed','App\\Modules\\Recruitment\\Domain\\Models\\JobApplication','1937111a-948e-4a03-a053-b1ead43f3a27','succeeded','ee5f5b4f-8d5d-4403-ac11-78db16331615','127.0.0.1',NULL,'{\"from\":\"submitted\",\"to\":\"rejected\"}','2026-08-17 08:20:04'),(13,1,'application.status_changed','App\\Modules\\Recruitment\\Domain\\Models\\JobApplication','32190c32-c027-4abd-a692-8173415d33b3','succeeded','349df24f-488b-4cf7-bab6-4035dfd111c8','127.0.0.1',NULL,'{\"from\":\"submitted\",\"to\":\"reviewing\"}','2026-08-17 08:20:20'),(14,1,'application.status_changed','App\\Modules\\Recruitment\\Domain\\Models\\JobApplication','32190c32-c027-4abd-a692-8173415d33b3','succeeded','6df86ecc-b728-4558-8378-b84ef0e8d570','127.0.0.1',NULL,'{\"from\":\"reviewing\",\"to\":\"shortlisted\"}','2026-08-17 08:20:26'),(15,1,'application.status_changed','App\\Modules\\Recruitment\\Domain\\Models\\JobApplication','32190c32-c027-4abd-a692-8173415d33b3','succeeded','15b6ca03-3698-4059-994a-16f3f827f3db','127.0.0.1',NULL,'{\"from\":\"shortlisted\",\"to\":\"hired\"}','2026-08-17 08:20:33'),(16,1,'application.status_changed','App\\Modules\\Recruitment\\Domain\\Models\\JobApplication','a240819c-326a-4d26-af08-c89decc68ab2','succeeded','ea62cc1d-a962-40e7-94f7-adb916667245','127.0.0.1',NULL,'{\"from\":\"reviewing\",\"to\":\"rejected\"}','2026-08-17 08:20:44'),(17,1,'application.status_changed','App\\Modules\\Recruitment\\Domain\\Models\\JobApplication','4a0d472e-e860-4b07-9555-f74f6046213e','succeeded','02f9562d-fe17-4ba3-8f79-39ea48611b9a','127.0.0.1',NULL,'{\"from\":\"shortlisted\",\"to\":\"hired\"}','2026-08-17 08:50:45'),(18,1,'post.revision_created','App\\Modules\\Publishing\\Domain\\Models\\Post','925fffcc-a243-4137-b15f-835cd22b8ba3','succeeded','f129f96e-e5e8-42e4-a97a-8af81b83d2d3','127.0.0.1',NULL,'{\"revision\":2,\"title\":\"\\u0643\\u064a\\u0641 \\u062a\\u063a\\u064a\\u0651\\u0631 \\u0648\\u0643\\u0644\\u0627\\u0621 \\u0627\\u0644\\u0630\\u0643\\u0627\\u0621 \\u0627\\u0644\\u0627\\u0635\\u0637\\u0646\\u0627\\u0639\\u064a \\u0637\\u0631\\u064a\\u0642\\u0629 \\u0625\\u062f\\u0627\\u0631\\u0629 \\u0627\\u0644\\u0623\\u0639\\u0645\\u0627\\u0644\\u061f\"}','2026-08-18 08:45:35'),(19,1,'user.updated','App\\Modules\\Identity\\Domain\\Models\\User','22b64763-624b-4699-a0e8-7f0946e11cc0','succeeded','9192ab1f-2bf5-4ed7-aa55-c41500e1bda8','127.0.0.1','{\"name\":\"Mariam Elshazly\",\"email_hash\":\"9d31f5cbc3c964138fa8de37006b04409fb323bdb62094489d41a3d0b5017fdd\",\"timezone\":\"UTC\",\"locale\":\"en\",\"is_active\":true,\"email_verified\":false,\"force_password_change\":\"[REDACTED]\",\"roles\":[\"data-analyst\"]}','{\"name\":\"Mariam Elshazly\",\"email_hash\":\"9d31f5cbc3c964138fa8de37006b04409fb323bdb62094489d41a3d0b5017fdd\",\"timezone\":\"UTC\",\"locale\":\"en\",\"is_active\":true,\"email_verified\":false,\"force_password_change\":\"[REDACTED]\",\"roles\":[\"data-analyst\"]}','2026-08-19 09:13:18'),(20,1,'user.updated','App\\Modules\\Identity\\Domain\\Models\\User','22b64763-624b-4699-a0e8-7f0946e11cc0','succeeded','ed1480cf-a9d0-4489-920f-4fa02c2494ba','127.0.0.1','{\"name\":\"Mariam Elshazly\",\"email_hash\":\"9d31f5cbc3c964138fa8de37006b04409fb323bdb62094489d41a3d0b5017fdd\",\"timezone\":\"UTC\",\"locale\":\"en\",\"is_active\":true,\"email_verified\":false,\"force_password_change\":\"[REDACTED]\",\"roles\":[\"data-analyst\"]}','{\"name\":\"Mariam Elshazly\",\"email_hash\":\"9d31f5cbc3c964138fa8de37006b04409fb323bdb62094489d41a3d0b5017fdd\",\"timezone\":\"UTC\",\"locale\":\"en\",\"is_active\":true,\"email_verified\":false,\"force_password_change\":\"[REDACTED]\",\"roles\":[\"data-analyst\"]}','2026-08-19 09:30:32'),(21,1,'user.updated','App\\Modules\\Identity\\Domain\\Models\\User','22b64763-624b-4699-a0e8-7f0946e11cc0','succeeded','4268b784-3c2e-469d-b6ba-7c12946e079d','127.0.0.1','{\"name\":\"Mariam Elshazly\",\"email_hash\":\"9d31f5cbc3c964138fa8de37006b04409fb323bdb62094489d41a3d0b5017fdd\",\"timezone\":\"UTC\",\"locale\":\"en\",\"is_active\":true,\"email_verified\":false,\"force_password_change\":\"[REDACTED]\",\"roles\":[\"data-analyst\"]}','{\"name\":\"Mariam Elshazly\",\"email_hash\":\"9d31f5cbc3c964138fa8de37006b04409fb323bdb62094489d41a3d0b5017fdd\",\"timezone\":\"UTC\",\"locale\":\"en\",\"is_active\":true,\"email_verified\":false,\"force_password_change\":\"[REDACTED]\",\"roles\":[\"data-analyst\"]}','2026-08-19 09:30:46'),(22,1,'settings.updated','App\\Modules\\Content\\Domain\\Models\\MenuBarLink','47d02afd-ba37-46df-ba13-7eec4917d342','succeeded','61626857-de50-49df-88ef-450cb33f321b','127.0.0.1','{\"label\":\"\\u0627\\u0644\\u0631\\u0626\\u064a\\u0633\\u064a\\u0629\",\"url\":\"\\/\",\"display_order\":1,\"is_active\":true,\"open_in_new_tab\":false,\"badge_text\":null,\"icon\":null}','{\"label\":\"\\u0627\\u0644\\u0631\\u0626\\u064a\\u0633\\u064a\\u0629\",\"url\":\"\\/\",\"display_order\":0,\"is_active\":true,\"open_in_new_tab\":false,\"badge_text\":null,\"icon\":null}','2026-08-20 06:08:29'),(23,1,'settings.updated','App\\Modules\\Content\\Domain\\Models\\MenuBarSetting','98a76e03-def0-4aab-86e8-169c6ff9a85f','succeeded','284a785a-52f7-4306-9d23-6a54d7385222','127.0.0.1','{\"brand_name\":\"SEVEN TECH\",\"brand_logo_url\":null,\"cta_button_text\":\"\\u0627\\u062d\\u062c\\u0632 \\u0627\\u0633\\u062a\\u0634\\u0627\\u0631\\u0629\",\"cta_button_url\":\"\\/contact\",\"cta_button_enabled\":true,\"cta_button_target\":\"_self\",\"is_language_switcher_enabled\":true,\"language_switcher_label\":\"English\",\"is_theme_toggle_enabled\":true,\"is_sticky\":true,\"is_enabled\":true}','{\"brand_name\":\"SEVEN TECH\",\"brand_logo_url\":\"http:\\/\\/localhost:8000\\/storage\\/menu-bar\\/51f6e45e-cb09-4aa7-9314-c97fd2b75341.png\",\"cta_button_text\":\"\\u0627\\u062d\\u062c\\u0632 \\u0627\\u0633\\u062a\\u0634\\u0627\\u0631\\u0629\",\"cta_button_url\":\"\\/contact\",\"cta_button_enabled\":true,\"cta_button_target\":\"_self\",\"is_language_switcher_enabled\":true,\"language_switcher_label\":\"English\",\"is_theme_toggle_enabled\":true,\"is_sticky\":true,\"is_enabled\":true}','2026-08-20 08:43:38'),(24,1,'settings.updated','App\\Modules\\Content\\Domain\\Models\\MenuBarSetting','98a76e03-def0-4aab-86e8-169c6ff9a85f','succeeded','b511a622-1c40-44a1-bc62-f9ed38a2e75c','127.0.0.1','{\"brand_name\":\"SEVEN TECH\",\"brand_logo_url\":\"http:\\/\\/localhost:8000\\/storage\\/menu-bar\\/51f6e45e-cb09-4aa7-9314-c97fd2b75341.png\",\"cta_button_text\":\"\\u0627\\u062d\\u062c\\u0632 \\u0627\\u0633\\u062a\\u0634\\u0627\\u0631\\u0629\",\"cta_button_url\":\"\\/contact\",\"cta_button_enabled\":true,\"cta_button_target\":\"_self\",\"is_language_switcher_enabled\":true,\"language_switcher_label\":\"English\",\"is_theme_toggle_enabled\":true,\"is_sticky\":true,\"is_enabled\":true}','{\"brand_name\":\"SEVEN TECH\",\"brand_logo_url\":\"http:\\/\\/localhost:8000\\/storage\\/menu-bar\\/cba0d233-3aed-44aa-8428-6b4f6c83976f.jpg\",\"cta_button_text\":\"\\u0627\\u062d\\u062c\\u0632 \\u0627\\u0633\\u062a\\u0634\\u0627\\u0631\\u0629\",\"cta_button_url\":\"\\/contact\",\"cta_button_enabled\":true,\"cta_button_target\":\"_self\",\"is_language_switcher_enabled\":true,\"language_switcher_label\":\"English\",\"is_theme_toggle_enabled\":true,\"is_sticky\":true,\"is_enabled\":true}','2026-08-20 08:44:30'),(25,1,'settings.updated','App\\Modules\\Content\\Domain\\Models\\MenuBarSetting','98a76e03-def0-4aab-86e8-169c6ff9a85f','succeeded','d25a6ccf-0e07-4405-9446-6dbb3800c588','127.0.0.1','{\"brand_name\":\"SEVEN TECH\",\"brand_logo_url\":\"http:\\/\\/localhost:8000\\/storage\\/menu-bar\\/cba0d233-3aed-44aa-8428-6b4f6c83976f.jpg\",\"cta_button_text\":\"\\u0627\\u062d\\u062c\\u0632 \\u0627\\u0633\\u062a\\u0634\\u0627\\u0631\\u0629\",\"cta_button_url\":\"\\/contact\",\"cta_button_enabled\":true,\"cta_button_target\":\"_self\",\"is_language_switcher_enabled\":true,\"language_switcher_label\":\"English\",\"is_theme_toggle_enabled\":true,\"is_sticky\":true,\"is_enabled\":true}','{\"brand_name\":\"SEVEN TECH\",\"brand_logo_url\":\"http:\\/\\/localhost:8000\\/storage\\/menu-bar\\/3623eb2a-860f-4a7e-9a86-4e38468026bd.jpg\",\"cta_button_text\":\"\\u0627\\u062d\\u062c\\u0632 \\u0627\\u0633\\u062a\\u0634\\u0627\\u0631\\u0629\",\"cta_button_url\":\"\\/contact\",\"cta_button_enabled\":true,\"cta_button_target\":\"_self\",\"is_language_switcher_enabled\":true,\"language_switcher_label\":\"English\",\"is_theme_toggle_enabled\":true,\"is_sticky\":true,\"is_enabled\":true}','2026-08-20 09:03:35'),(26,1,'settings.updated','App\\Modules\\Content\\Domain\\Models\\MenuBarSetting','98a76e03-def0-4aab-86e8-169c6ff9a85f','succeeded','9a02ccd4-4845-4db7-bccb-a79d0802b0df','127.0.0.1','{\"brand_name\":\"SEVEN TECH\",\"brand_logo_url\":\"http:\\/\\/localhost:8000\\/storage\\/menu-bar\\/3623eb2a-860f-4a7e-9a86-4e38468026bd.jpg\",\"cta_button_text\":\"\\u0627\\u062d\\u062c\\u0632 \\u0627\\u0633\\u062a\\u0634\\u0627\\u0631\\u0629\",\"cta_button_url\":\"\\/contact\",\"cta_button_enabled\":true,\"cta_button_target\":\"_self\",\"is_language_switcher_enabled\":true,\"language_switcher_label\":\"English\",\"is_theme_toggle_enabled\":true,\"is_sticky\":true,\"is_enabled\":true}','{\"brand_name\":\"SEVEN TECH\",\"brand_logo_url\":\"http:\\/\\/localhost:8000\\/storage\\/menu-bar\\/4f718da3-f6b3-4b74-9c13-60bebf69c695.png\",\"cta_button_text\":\"\\u0627\\u062d\\u062c\\u0632 \\u0627\\u0633\\u062a\\u0634\\u0627\\u0631\\u0629\",\"cta_button_url\":\"\\/contact\",\"cta_button_enabled\":true,\"cta_button_target\":\"_self\",\"is_language_switcher_enabled\":true,\"language_switcher_label\":\"English\",\"is_theme_toggle_enabled\":true,\"is_sticky\":true,\"is_enabled\":true}','2026-08-20 09:04:11'),(27,1,'settings.updated','App\\Modules\\Content\\Domain\\Models\\MenuBarSetting','98a76e03-def0-4aab-86e8-169c6ff9a85f','succeeded','9f987d2a-5837-43fe-97be-0d0a287c12c1','127.0.0.1','{\"brand_name\":\"SEVEN TECH\",\"brand_logo_url\":\"http:\\/\\/localhost:8000\\/storage\\/menu-bar\\/4f718da3-f6b3-4b74-9c13-60bebf69c695.png\",\"cta_button_text\":\"\\u0627\\u062d\\u062c\\u0632 \\u0627\\u0633\\u062a\\u0634\\u0627\\u0631\\u0629\",\"cta_button_url\":\"\\/contact\",\"cta_button_enabled\":true,\"cta_button_target\":\"_self\",\"is_language_switcher_enabled\":true,\"language_switcher_label\":\"English\",\"is_theme_toggle_enabled\":true,\"is_sticky\":true,\"is_enabled\":true}','{\"brand_name\":\"SEVEN TECH\",\"brand_logo_url\":\"http:\\/\\/localhost:8000\\/storage\\/menu-bar\\/4f718da3-f6b3-4b74-9c13-60bebf69c695.png\",\"cta_button_text\":\"\\u0627\\u062d\\u062c\\u0632 \\u0627\\u0633\\u062a\\u0634\\u0627\\u0631\\u0629\\u0627\\u0627\\u0627\\u0627\\u0627\",\"cta_button_url\":\"\\/contact\",\"cta_button_enabled\":true,\"cta_button_target\":\"_self\",\"is_language_switcher_enabled\":true,\"language_switcher_label\":\"English\",\"is_theme_toggle_enabled\":true,\"is_sticky\":true,\"is_enabled\":true}','2026-08-20 09:05:35'),(28,1,'settings.updated','App\\Modules\\Content\\Domain\\Models\\MenuBarSetting','98a76e03-def0-4aab-86e8-169c6ff9a85f','succeeded','a147e2f0-747b-47c5-b0e2-5e097f8ed8ab','127.0.0.1','{\"brand_name\":\"SEVEN TECH\",\"brand_logo_url\":\"http:\\/\\/localhost:8000\\/storage\\/menu-bar\\/4f718da3-f6b3-4b74-9c13-60bebf69c695.png\",\"cta_button_text\":\"\\u0627\\u062d\\u062c\\u0632 \\u0627\\u0633\\u062a\\u0634\\u0627\\u0631\\u0629\\u0627\\u0627\\u0627\\u0627\\u0627\",\"cta_button_url\":\"\\/contact\",\"cta_button_enabled\":true,\"cta_button_target\":\"_self\",\"is_language_switcher_enabled\":true,\"language_switcher_label\":\"English\",\"is_theme_toggle_enabled\":true,\"is_sticky\":true,\"is_enabled\":true}','{\"brand_name\":\"SEVEN TECH\",\"brand_logo_url\":\"http:\\/\\/localhost:8000\\/storage\\/menu-bar\\/405ae968-297b-4900-97b9-8fa6ce169b4c.png\",\"cta_button_text\":\"\\u0627\\u062d\\u062c\\u0632 \\u0627\\u0633\\u062a\\u0634\\u0627\\u0631\\u0629\\u0627\\u0627\\u0627\\u0627\\u0627\",\"cta_button_url\":\"\\/contact\",\"cta_button_enabled\":true,\"cta_button_target\":\"_self\",\"is_language_switcher_enabled\":true,\"language_switcher_label\":\"English\",\"is_theme_toggle_enabled\":true,\"is_sticky\":true,\"is_enabled\":true}','2026-08-20 11:40:38'),(29,1,'settings.updated','App\\Modules\\Content\\Domain\\Models\\MenuBarSetting','98a76e03-def0-4aab-86e8-169c6ff9a85f','succeeded','98fa6bbc-413c-4d36-9c05-cc11285a94cb','127.0.0.1','{\"brand_name\":\"SEVEN TECH\",\"brand_logo_url\":\"http:\\/\\/localhost:8000\\/storage\\/menu-bar\\/405ae968-297b-4900-97b9-8fa6ce169b4c.png\",\"cta_button_text\":\"\\u0627\\u062d\\u062c\\u0632 \\u0627\\u0633\\u062a\\u0634\\u0627\\u0631\\u0629\\u0627\\u0627\\u0627\\u0627\\u0627\",\"cta_button_url\":\"\\/contact\",\"cta_button_enabled\":true,\"cta_button_target\":\"_self\",\"is_language_switcher_enabled\":true,\"language_switcher_label\":\"English\",\"is_theme_toggle_enabled\":true,\"is_sticky\":true,\"is_enabled\":true}','{\"brand_name\":\"SEVEN TECH\",\"brand_logo_url\":\"http:\\/\\/localhost:8000\\/storage\\/menu-bar\\/b3d7d518-4414-4395-b12b-da40db79c724.png\",\"cta_button_text\":\"\\u0627\\u062d\\u062c\\u0632 \\u0627\\u0633\\u062a\\u0634\\u0627\\u0631\\u0629\\u0627\\u0627\\u0627\\u0627\\u0627\",\"cta_button_url\":\"\\/contact\",\"cta_button_enabled\":true,\"cta_button_target\":\"_self\",\"is_language_switcher_enabled\":true,\"language_switcher_label\":\"English\",\"is_theme_toggle_enabled\":true,\"is_sticky\":true,\"is_enabled\":true}','2026-08-20 11:41:39'),(30,1,'settings.updated','App\\Modules\\Content\\Domain\\Models\\MenuBarSetting','98a76e03-def0-4aab-86e8-169c6ff9a85f','succeeded','b3d40197-5c83-427a-8e46-88d103c8d584','127.0.0.1','{\"brand_name\":\"SEVEN TECH\",\"brand_logo_url\":\"http:\\/\\/localhost:8000\\/storage\\/menu-bar\\/b3d7d518-4414-4395-b12b-da40db79c724.png\",\"cta_button_text\":\"\\u0627\\u062d\\u062c\\u0632 \\u0627\\u0633\\u062a\\u0634\\u0627\\u0631\\u0629\\u0627\\u0627\\u0627\\u0627\\u0627\",\"cta_button_url\":\"\\/contact\",\"cta_button_enabled\":true,\"cta_button_target\":\"_self\",\"is_language_switcher_enabled\":true,\"language_switcher_label\":\"English\",\"is_theme_toggle_enabled\":true,\"is_sticky\":true,\"is_enabled\":true}','{\"brand_name\":\"SEVEN TECH\",\"brand_logo_url\":\"http:\\/\\/localhost:8000\\/storage\\/menu-bar\\/4cf10d83-22e4-4f01-878b-a49f52df460b.png\",\"cta_button_text\":\"\\u0627\\u062d\\u062c\\u0632 \\u0627\\u0633\\u062a\\u0634\\u0627\\u0631\\u0629\",\"cta_button_url\":\"\\/contact\",\"cta_button_enabled\":true,\"cta_button_target\":\"_self\",\"is_language_switcher_enabled\":true,\"language_switcher_label\":\"English\",\"is_theme_toggle_enabled\":true,\"is_sticky\":true,\"is_enabled\":true}','2026-08-22 12:48:36'),(31,1,'user.created','App\\Modules\\Identity\\Domain\\Models\\User','ca9cf80a-e451-444c-a71c-89e4d7ae6356','succeeded','0091c16f-a519-41fa-833e-c311f9d3ea4a','127.0.0.1',NULL,'{\"name\":\"Ibrahim\",\"email_hash\":\"0d5b1a3100dc7b9deb655b983803d2fa74e34699357805f762dd63a768856980\",\"timezone\":\"UTC\",\"locale\":\"ar\",\"is_active\":true,\"email_verified\":true,\"force_password_change\":\"[REDACTED]\",\"roles\":[\"data-analyst\"]}','2026-08-22 13:07:02'),(32,1,'settings.updated','App\\Modules\\Content\\Domain\\Models\\MenuBarSetting','98a76e03-def0-4aab-86e8-169c6ff9a85f','succeeded','2f5d3b1a-7415-4b37-882c-41db5bf58948','127.0.0.1','{\"brand_name\":\"SEVEN TECH\",\"brand_logo_url\":\"\\/storage\\/menu-bar\\/4cf10d83-22e4-4f01-878b-a49f52df460b.png\",\"cta_button_text\":\"\\u0627\\u062d\\u062c\\u0632 \\u0627\\u0633\\u062a\\u0634\\u0627\\u0631\\u0629\",\"cta_button_url\":\"\\/contact\",\"cta_button_enabled\":true,\"cta_button_target\":\"_self\",\"is_language_switcher_enabled\":true,\"language_switcher_label\":\"English\",\"is_theme_toggle_enabled\":true,\"is_sticky\":true,\"is_enabled\":true}','{\"brand_name\":\"SEVEN TECH\",\"brand_logo_url\":\"\\/storage\\/menu-bar\\/fdaa424c-1901-4efa-be47-35dcb0063581.jpg\",\"cta_button_text\":\"\\u0627\\u062d\\u062c\\u0632 \\u0627\\u0633\\u062a\\u0634\\u0627\\u0631\\u0629\",\"cta_button_url\":\"\\/contact\",\"cta_button_enabled\":true,\"cta_button_target\":\"_self\",\"is_language_switcher_enabled\":true,\"language_switcher_label\":\"English\",\"is_theme_toggle_enabled\":true,\"is_sticky\":true,\"is_enabled\":true}','2026-08-22 13:26:21'),(33,1,'media.uploaded','App\\Modules\\Media\\Domain\\Models\\Media','5e53f251-21f0-49cd-968e-1894029977d6','succeeded','482bcd18-9520-46f5-995e-7ec5e4e34021','127.0.0.1',NULL,'{\"mime_type\":\"image\\/png\",\"byte_size\":114178,\"visibility\":\"public\",\"checksum\":\"2d6688d19fe08b144e940d6ceea6ba8e13dc38ebe368a5337103c32ef34e6a16\"}','2026-08-22 14:51:08'),(34,1,'media.uploaded','App\\Modules\\Media\\Domain\\Models\\Media','15c1cb68-14a7-42be-9d34-25d650ea2ce1','succeeded','a314c0c9-24a3-4f95-b084-10706a01f394','127.0.0.1',NULL,'{\"mime_type\":\"image\\/jpeg\",\"byte_size\":24529,\"visibility\":\"public\",\"checksum\":\"a52d0a2b896323f41b72ff54ff6a4df6c487313cfbffe47944481bcf59aa1af9\"}','2026-08-22 14:51:13'),(35,1,'media.uploaded','App\\Modules\\Media\\Domain\\Models\\Media','ae38aab6-1334-4304-80f8-b1d8bf69127e','succeeded','8f3f27bc-9ef7-4c21-8fde-d0596009b2fc','127.0.0.1',NULL,'{\"mime_type\":\"image\\/png\",\"byte_size\":76470,\"visibility\":\"public\",\"checksum\":\"e2e706a3f6ce3ecff574decaaab019f6269c369689f292e7c83bc9e218fafcd1\"}','2026-08-22 15:01:25'),(36,1,'role.created','App\\Modules\\AccessControl\\Domain\\Models\\Role','raays-alkhdmat','succeeded','2eb2ef7e-0f56-46e1-ace7-7c29859de5c4','127.0.0.1',NULL,'{\"name\":\"\\u0631\\u0621\\u064a\\u0633 \\u0627\\u0644\\u062e\\u062f\\u0645\\u0627\\u062a\",\"is_active\":true,\"permissions\":[\"services.view\"]}','2026-08-23 06:54:05'),(37,1,'user.created','App\\Modules\\Identity\\Domain\\Models\\User','48742d7f-ac9a-4fdf-b9db-4ca0ada09de0','succeeded','f3c72b34-3a1a-4d4a-9b23-14628052cb2e','127.0.0.1',NULL,'{\"name\":\"Diaa 222\",\"email_hash\":\"15dba8f329ab0a5f37b274468a44f32b18b798144e10ac48355eba9cc0db8649\",\"timezone\":\"UTC\",\"locale\":\"ar\",\"is_active\":true,\"email_verified\":true,\"force_password_change\":\"[REDACTED]\",\"roles\":[\"raays-alkhdmat\"]}','2026-08-23 06:56:41'),(39,1,'media.uploaded','App\\Modules\\Media\\Domain\\Models\\Media','e0cdbadd-768e-4cd9-876e-5169f64999d1','succeeded','92baed5f-3637-434d-9d3c-6d47a02baf71','127.0.0.1',NULL,'{\"mime_type\":\"image\\/png\",\"byte_size\":114178,\"visibility\":\"public\",\"checksum\":\"2d6688d19fe08b144e940d6ceea6ba8e13dc38ebe368a5337103c32ef34e6a16\"}','2026-08-24 06:45:49'),(40,1,'catalog.deleted','App\\Modules\\Catalog\\Domain\\Models\\Service','6ac61e75-236a-4839-8a7e-0ea4e724fd37','succeeded','3925e759-a15f-4b36-9c8c-97260e03cb4e','127.0.0.1',NULL,'{\"name\":\"\\u062a\\u0637\\u0628\\u064a\\u0642\\u0627\\u062a \\u0627\\u0644\\u062c\\u0648\\u0627\\u0644 \\u0627\\u0644\\u0630\\u0643\\u064a\\u0629\",\"slug\":\"mobile-apps\",\"status\":\"published\"}','2026-08-24 06:48:57'),(41,1,'trash.record_restored','App\\Modules\\Catalog\\Domain\\Models\\Service','6ac61e75-236a-4839-8a7e-0ea4e724fd37','succeeded','cf4aa437-fcca-4fc9-adb4-9b69e1611482','127.0.0.1',NULL,'{\"entity\":\"services\",\"restored\":true}','2026-08-24 06:49:14'),(42,1,'media.uploaded','App\\Modules\\Media\\Domain\\Models\\Media','30e949a0-bf22-4b42-a6cc-01e2e0868cf6','succeeded','071941b5-908f-4b52-9052-0ce269750bbd','127.0.0.1',NULL,'{\"mime_type\":\"image\\/png\",\"byte_size\":114178,\"visibility\":\"public\",\"checksum\":\"2d6688d19fe08b144e940d6ceea6ba8e13dc38ebe368a5337103c32ef34e6a16\"}','2026-08-24 06:52:28'),(43,1,'portfolio.published','App\\Modules\\Portfolio\\Domain\\Models\\Project','cc0d9686-4cca-4cbf-861f-540ec7bcf433','succeeded','1a1efcff-0651-4f1d-ba72-7a63f1f310c6','127.0.0.1',NULL,'{\"name\":\"\\u0645\\u0646\\u0635\\u0629 \\u062a\\u0643\\u0633\\u0633 \\u0627\\u0644\\u0644\\u0648\\u062c\\u0633\\u062a\\u064a\\u0629 \\u0648\\u0623\\u062a\\u0645\\u062a\\u0629 \\u0627\\u0644\\u0634\\u062d\\u0646\",\"status\":\"published\"}','2026-08-24 06:52:43'),(44,1,'settings.updated','App\\Modules\\Portfolio\\Domain\\Models\\PortfolioPageSetting','partners','succeeded','d237c4c3-7327-41c7-9903-dcbb8d747e18','127.0.0.1','{\"hero\":{\"title\":\"\\u062a\\u0643\\u0646\\u0648\\u0644\\u0648\\u062c\\u064a\\u0627 \\u0623\\u0642\\u0648\\u0649 \\u062a\\u0628\\u062f\\u0623 \\u0628\\u0634\\u0631\\u0627\\u0643\\u0627\\u062a \\u0623\\u0642\\u0648\\u0649\",\"description\":\"\\u0646\\u062a\\u0639\\u0627\\u0648\\u0646 \\u0645\\u0639 \\u0634\\u0631\\u0643\\u0627\\u0621 \\u0645\\u0648\\u062b\\u0648\\u0642\\u064a\\u0646 \\u0641\\u064a \\u0627\\u0644\\u062a\\u0643\\u0646\\u0648\\u0644\\u0648\\u062c\\u064a\\u0627 \\u0648\\u0627\\u0644\\u0623\\u0639\\u0645\\u0627\\u0644 \\u0648\\u0627\\u0644\\u0627\\u0633\\u062a\\u0631\\u0627\\u062a\\u064a\\u062c\\u064a\\u0629 \\u0644\\u0646\\u0642\\u062f\\u0645 \\u0644\\u0639\\u0645\\u0644\\u0627\\u0626\\u0646\\u0627 \\u0642\\u062f\\u0631\\u0627\\u062a \\u0623\\u0643\\u0628\\u0631 \\u0648\\u062d\\u0644\\u0648\\u0644\\u064b\\u0627 \\u0623\\u0643\\u062b\\u0631 \\u0630\\u0643\\u0627\\u0621\\u064b \\u0648\\u062a\\u0646\\u0641\\u064a\\u0630\\u064b\\u0627 \\u0623\\u0642\\u0648\\u0649.\"},\"section_card\":{\"section_label\":\"OUR TECHNOLOGY STACK\",\"section_title\":\"\\u0634\\u0631\\u0643\\u0627\\u0624\\u0646\\u0627 \\u0648\\u062a\\u0642\\u0646\\u064a\\u0627\\u062a\\u0646\\u0627 \\u0627\\u0644\\u0645\\u0648\\u062b\\u0648\\u0642\\u0629\",\"section_description\":\"\\u0645\\u0646\\u0638\\u0648\\u0645\\u0629 \\u0645\\u062a\\u0643\\u0627\\u0645\\u0644\\u0629 \\u0645\\u0646 \\u0627\\u0644\\u062a\\u0642\\u0646\\u064a\\u0627\\u062a \\u0648\\u0627\\u0644\\u0645\\u0646\\u0635\\u0627\\u062a \\u0627\\u0644\\u062a\\u064a \\u0646\\u0639\\u062a\\u0645\\u062f \\u0639\\u0644\\u064a\\u0647\\u0627 \\u0644\\u0628\\u0646\\u0627\\u0621 \\u062d\\u0644\\u0648\\u0644 \\u0622\\u0645\\u0646\\u0629\\u060c \\u0633\\u0631\\u064a\\u0639\\u0629 \\u0648\\u0642\\u0627\\u0628\\u0644\\u0629 \\u0644\\u0644\\u062a\\u0648\\u0633\\u0639.\",\"count_mode\":\"auto\",\"custom_count\":16}}','{\"hero\":{\"title\":\"\\u062a\\u0643\\u0646\\u0648\\u0644\\u0648\\u062c\\u064a\\u0627 \\u0623\\u0642\\u0648\\u0649 \\u062a\\u0628\\u062f\\u0623 \\u0628\\u0634\\u0631\\u0627\\u0643\\u0627\\u062a \\u0623\\u0642\\u0648\\u0649\",\"description\":\"\\u0646\\u062a\\u0639\\u0627\\u0648\\u0646 \\u0645\\u0639 \\u0634\\u0631\\u0643\\u0627\\u0621 \\u0645\\u0648\\u062b\\u0648\\u0642\\u064a\\u0646 \\u0641\\u064a \\u0627\\u0644\\u062a\\u0643\\u0646\\u0648\\u0644\\u0648\\u062c\\u064a\\u0627 \\u0648\\u0627\\u0644\\u0623\\u0639\\u0645\\u0627\\u0644 \\u0648\\u0627\\u0644\\u0627\\u0633\\u062a\\u0631\\u0627\\u062a\\u064a\\u062c\\u064a\\u0629 \\u0644\\u0646\\u0642\\u062f\\u0645 \\u0644\\u0639\\u0645\\u0644\\u0627\\u0626\\u0646\\u0627 \\u0642\\u062f\\u0631\\u0627\\u062a \\u0623\\u0643\\u0628\\u0631 \\u0648\\u062d\\u0644\\u0648\\u0644\\u064b\\u0627 \\u0623\\u0643\\u062b\\u0631 \\u0630\\u0643\\u0627\\u0621\\u064b \\u0648\\u062a\\u0646\\u0641\\u064a\\u0630\\u064b\\u0627 \\u0623\\u0642\\u0648\\u0649\"},\"section_card\":{\"section_label\":\"OUR TECHNOLOGY STACK\",\"section_title\":\"\\u0634\\u0631\\u0643\\u0627\\u0624\\u0646\\u0627 \\u0648\\u062a\\u0642\\u0646\\u064a\\u0627\\u062a\\u0646\\u0627 \\u0627\\u0644\\u0645\\u0648\\u062b\\u0648\\u0642\\u0629\",\"section_description\":\"\\u0645\\u0646\\u0638\\u0648\\u0645\\u0629 \\u0645\\u062a\\u0643\\u0627\\u0645\\u0644\\u0629 \\u0645\\u0646 \\u0627\\u0644\\u062a\\u0642\\u0646\\u064a\\u0627\\u062a \\u0648\\u0627\\u0644\\u0645\\u0646\\u0635\\u0627\\u062a \\u0627\\u0644\\u062a\\u064a \\u0646\\u0639\\u062a\\u0645\\u062f \\u0639\\u0644\\u064a\\u0647\\u0627 \\u0644\\u0628\\u0646\\u0627\\u0621 \\u062d\\u0644\\u0648\\u0644 \\u0622\\u0645\\u0646\\u0629\\u060c \\u0633\\u0631\\u064a\\u0639\\u0629 \\u0648\\u0642\\u0627\\u0628\\u0644\\u0629 \\u0644\\u0644\\u062a\\u0648\\u0633\\u0639.\",\"count_mode\":\"auto\",\"custom_count\":16}}','2026-08-24 06:54:17'),(45,1,'settings.updated','App\\Modules\\Portfolio\\Domain\\Models\\PortfolioPageSetting','partners','succeeded','4fcddeb4-4db9-4e31-a14f-c681e2ed4e66','127.0.0.1','{\"hero\":{\"title\":\"\\u062a\\u0643\\u0646\\u0648\\u0644\\u0648\\u062c\\u064a\\u0627 \\u0623\\u0642\\u0648\\u0649 \\u062a\\u0628\\u062f\\u0623 \\u0628\\u0634\\u0631\\u0627\\u0643\\u0627\\u062a \\u0623\\u0642\\u0648\\u0649\",\"description\":\"\\u0646\\u062a\\u0639\\u0627\\u0648\\u0646 \\u0645\\u0639 \\u0634\\u0631\\u0643\\u0627\\u0621 \\u0645\\u0648\\u062b\\u0648\\u0642\\u064a\\u0646 \\u0641\\u064a \\u0627\\u0644\\u062a\\u0643\\u0646\\u0648\\u0644\\u0648\\u062c\\u064a\\u0627 \\u0648\\u0627\\u0644\\u0623\\u0639\\u0645\\u0627\\u0644 \\u0648\\u0627\\u0644\\u0627\\u0633\\u062a\\u0631\\u0627\\u062a\\u064a\\u062c\\u064a\\u0629 \\u0644\\u0646\\u0642\\u062f\\u0645 \\u0644\\u0639\\u0645\\u0644\\u0627\\u0626\\u0646\\u0627 \\u0642\\u062f\\u0631\\u0627\\u062a \\u0623\\u0643\\u0628\\u0631 \\u0648\\u062d\\u0644\\u0648\\u0644\\u064b\\u0627 \\u0623\\u0643\\u062b\\u0631 \\u0630\\u0643\\u0627\\u0621\\u064b \\u0648\\u062a\\u0646\\u0641\\u064a\\u0630\\u064b\\u0627 \\u0623\\u0642\\u0648\\u0649\"},\"section_card\":{\"section_label\":\"OUR TECHNOLOGY STACK\",\"section_title\":\"\\u0634\\u0631\\u0643\\u0627\\u0624\\u0646\\u0627 \\u0648\\u062a\\u0642\\u0646\\u064a\\u0627\\u062a\\u0646\\u0627 \\u0627\\u0644\\u0645\\u0648\\u062b\\u0648\\u0642\\u0629\",\"section_description\":\"\\u0645\\u0646\\u0638\\u0648\\u0645\\u0629 \\u0645\\u062a\\u0643\\u0627\\u0645\\u0644\\u0629 \\u0645\\u0646 \\u0627\\u0644\\u062a\\u0642\\u0646\\u064a\\u0627\\u062a \\u0648\\u0627\\u0644\\u0645\\u0646\\u0635\\u0627\\u062a \\u0627\\u0644\\u062a\\u064a \\u0646\\u0639\\u062a\\u0645\\u062f \\u0639\\u0644\\u064a\\u0647\\u0627 \\u0644\\u0628\\u0646\\u0627\\u0621 \\u062d\\u0644\\u0648\\u0644 \\u0622\\u0645\\u0646\\u0629\\u060c \\u0633\\u0631\\u064a\\u0639\\u0629 \\u0648\\u0642\\u0627\\u0628\\u0644\\u0629 \\u0644\\u0644\\u062a\\u0648\\u0633\\u0639.\",\"count_mode\":\"auto\",\"custom_count\":16}}','{\"hero\":{\"title\":\"\\u062a\\u0643\\u0646\\u0648\\u0644\\u0648\\u062c\\u064a\\u0627 \\u0623\\u0642\\u0648\\u0649 \\u062a\\u0628\\u062f\\u0623 \\u0628\\u0634\\u0631\\u0627\\u0643\\u0627\\u062a \\u0623\\u0642\\u0648\\u0649\",\"description\":\"\\u0646\\u062a\\u0639\\u0627\\u0648\\u0646 \\u0645\\u0639 \\u0634\\u0631\\u0643\\u0627\\u0621 \\u0645\\u0648\\u062b\\u0648\\u0642\\u064a\\u0646 \\u0641\\u064a \\u0627\\u0644\\u062a\\u0643\\u0646\\u0648\\u0644\\u0648\\u062c\\u064a\\u0627 \\u0648\\u0627\\u0644\\u0623\\u0639\\u0645\\u0627\\u0644 \\u0648\\u0627\\u0644\\u0627\\u0633\\u062a\\u0631\\u0627\\u062a\\u064a\\u062c\\u064a\\u0629 \\u0644\\u0646\\u0642\\u062f\\u0645 \\u0644\\u0639\\u0645\\u0644\\u0627\\u0626\\u0646\\u0627 \\u0642\\u062f\\u0631\\u0627\\u062a \\u0623\\u0643\\u0628\\u0631 \\u0648\\u062d\\u0644\\u0648\\u0644\\u064b\\u0627 \\u0623\\u0643\\u062b\\u0631 \\u0630\\u0643\\u0627\\u0621\\u064b \\u0648\\u062a\\u0646\\u0641\\u064a\\u0630\\u064b\\u0627 \\u0623\\u0642\\u0648\\u0649.\"},\"section_card\":{\"section_label\":\"OUR TECHNOLOGY STACK\",\"section_title\":\"\\u0634\\u0631\\u0643\\u0627\\u0624\\u0646\\u0627 \\u0648\\u062a\\u0642\\u0646\\u064a\\u0627\\u062a\\u0646\\u0627 \\u0627\\u0644\\u0645\\u0648\\u062b\\u0648\\u0642\\u0629\",\"section_description\":\"\\u0645\\u0646\\u0638\\u0648\\u0645\\u0629 \\u0645\\u062a\\u0643\\u0627\\u0645\\u0644\\u0629 \\u0645\\u0646 \\u0627\\u0644\\u062a\\u0642\\u0646\\u064a\\u0627\\u062a \\u0648\\u0627\\u0644\\u0645\\u0646\\u0635\\u0627\\u062a \\u0627\\u0644\\u062a\\u064a \\u0646\\u0639\\u062a\\u0645\\u062f \\u0639\\u0644\\u064a\\u0647\\u0627 \\u0644\\u0628\\u0646\\u0627\\u0621 \\u062d\\u0644\\u0648\\u0644 \\u0622\\u0645\\u0646\\u0629\\u060c \\u0633\\u0631\\u064a\\u0639\\u0629 \\u0648\\u0642\\u0627\\u0628\\u0644\\u0629 \\u0644\\u0644\\u062a\\u0648\\u0633\\u0639.\",\"count_mode\":\"auto\",\"custom_count\":16}}','2026-08-24 06:54:25'),(46,1,'media.uploaded','App\\Modules\\Media\\Domain\\Models\\Media','d09dfc5c-e749-46bf-950f-4d94897f8cc3','succeeded','9df463d3-6dc7-4e80-8bb6-87e263cc91ca','127.0.0.1',NULL,'{\"mime_type\":\"image\\/png\",\"byte_size\":114178,\"visibility\":\"public\",\"checksum\":\"2d6688d19fe08b144e940d6ceea6ba8e13dc38ebe368a5337103c32ef34e6a16\"}','2026-08-24 06:55:20'),(47,1,'media.uploaded','App\\Modules\\Media\\Domain\\Models\\Media','bfa851e0-30cf-4918-87f6-b2b071cdca95','succeeded','fdf73766-3377-4573-8303-3f514a4a3bc9','127.0.0.1',NULL,'{\"mime_type\":\"image\\/png\",\"byte_size\":114178,\"visibility\":\"public\",\"checksum\":\"2d6688d19fe08b144e940d6ceea6ba8e13dc38ebe368a5337103c32ef34e6a16\"}','2026-08-24 06:56:05'),(49,1,'media.uploaded','App\\Modules\\Media\\Domain\\Models\\Media','74a88830-78b2-4a0d-819c-81493f349904','succeeded','66a4a05d-8359-4122-9ff3-f995797b4e84','127.0.0.1',NULL,'{\"mime_type\":\"image\\/png\",\"byte_size\":114178,\"visibility\":\"public\",\"checksum\":\"2d6688d19fe08b144e940d6ceea6ba8e13dc38ebe368a5337103c32ef34e6a16\"}','2026-08-24 06:58:08'),(50,1,'media.uploaded','App\\Modules\\Media\\Domain\\Models\\Media','97009219-b705-412a-8b12-e2dc228ea775','succeeded','9dfdfc4b-c766-49da-98fc-03da0cb53ff2','127.0.0.1',NULL,'{\"mime_type\":\"image\\/png\",\"byte_size\":114178,\"visibility\":\"public\",\"checksum\":\"2d6688d19fe08b144e940d6ceea6ba8e13dc38ebe368a5337103c32ef34e6a16\"}','2026-08-24 06:58:37'),(51,1,'media.uploaded','App\\Modules\\Media\\Domain\\Models\\Media','c487d4e0-5244-4208-b8e7-b01d1f052828','succeeded','c7041dfa-b6f1-45a3-bc32-3718fd2bf9f5','127.0.0.1',NULL,'{\"mime_type\":\"image\\/png\",\"byte_size\":114178,\"visibility\":\"public\",\"checksum\":\"2d6688d19fe08b144e940d6ceea6ba8e13dc38ebe368a5337103c32ef34e6a16\"}','2026-08-24 07:00:45'),(52,1,'portfolio.published','App\\Modules\\Portfolio\\Domain\\Models\\Project','9dade8b7-5ea4-4637-92cb-728f7ce8995b','succeeded','31f71d5c-79bf-43ec-afae-156ca5281066','127.0.0.1',NULL,'{\"name\":\"\\u0646\\u0638\\u0627\\u0645 \\u0633\\u0645\\u0627\\u0631\\u062a \\u0631\\u064a\\u062a\\u064a\\u0644 \\u0644\\u0625\\u062f\\u0627\\u0631\\u0629 \\u0627\\u0644\\u0645\\u062e\\u0627\\u0632\\u0646 \\u0648\\u0627\\u0644\\u0645\\u0628\\u064a\\u0639\\u0627\\u062a\",\"status\":\"published\"}','2026-08-24 07:00:48'),(53,1,'portfolio.published','App\\Modules\\Portfolio\\Domain\\Models\\Project','cc0d9686-4cca-4cbf-861f-540ec7bcf433','succeeded','1bec67b0-8fbc-44ff-8945-f9665c2d219d','127.0.0.1',NULL,'{\"name\":\"\\u0645\\u0646\\u0635\\u0629 \\u062a\\u0643\\u0633\\u0633 \\u0627\\u0644\\u0644\\u0648\\u062c\\u0633\\u062a\\u064a\\u0629 \\u0648\\u0623\\u062a\\u0645\\u062a\\u0629 \\u0627\\u0644\\u0634\\u062d\\u0646\",\"status\":\"published\"}','2026-08-24 07:01:02'),(54,1,'portfolio.published','App\\Modules\\Portfolio\\Domain\\Models\\Project','9dade8b7-5ea4-4637-92cb-728f7ce8995b','succeeded','d88845aa-d408-401f-a8c7-11fe3a6f639e','127.0.0.1',NULL,'{\"name\":\"\\u0646\\u0638\\u0627\\u0645 \\u0633\\u0645\\u0627\\u0631\\u062a \\u0631\\u064a\\u062a\\u064a\\u0644 \\u0644\\u0625\\u062f\\u0627\\u0631\\u0629 \\u0627\\u0644\\u0645\\u062e\\u0627\\u0632\\u0646 \\u0648\\u0627\\u0644\\u0645\\u0628\\u064a\\u0639\\u0627\\u062a\",\"status\":\"published\"}','2026-08-24 07:01:12');

--
-- Table structure for table `authentication_events`
--

CREATE TABLE `authentication_events` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `email_hash` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `result` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `reason` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `request_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ip_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `occurred_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `authentication_events_user_id_occurred_at_index` (`user_id`,`occurred_at`),
  KEY `authentication_events_email_hash_occurred_at_index` (`email_hash`,`occurred_at`),
  KEY `authentication_events_ip_address_occurred_at_index` (`ip_address`,`occurred_at`),
  KEY `authentication_events_type_result_occurred_at_index` (`type`,`result`,`occurred_at`),
  CONSTRAINT `fk_c7b5c308e84a` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=155 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `authentication_events`
--

INSERT INTO `authentication_events` VALUES (1,NULL,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','login_failed','failed','invalid_credentials','8f21d861-89cc-4c04-8af0-1cd055bd1bd6','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-14 13:53:57'),(2,NULL,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','login_failed','failed','invalid_credentials','c6601afc-0b76-49e7-b5df-1979b9b73abc','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-14 13:54:38'),(3,NULL,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','login_failed','failed','invalid_credentials','eed14998-f6c7-494b-9d89-cd76928c6549','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-14 13:54:40'),(4,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','login_succeeded','succeeded',NULL,'84e63ff1-112c-42b6-b7bb-a74ed8e6b66f','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-14 13:57:13'),(5,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','login_succeeded','succeeded',NULL,'13404d1b-bd2c-465e-94bb-b00f3ca2e5bd','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-14 14:33:33'),(6,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','logout','succeeded',NULL,'59941700-ad99-484b-ba29-5d387a80bf9a','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-14 14:37:28'),(7,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','login_succeeded','succeeded',NULL,'5578884d-40d8-4b67-92c7-32bca5f7182e','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-14 14:40:52'),(8,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','logout','succeeded',NULL,'bd3f50e9-3f7f-4fac-9266-48d9346ea900','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-14 14:49:23'),(9,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','login_succeeded','succeeded',NULL,'1622e893-70e8-48bd-a83f-e16c69bef623','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-14 14:49:56'),(10,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','logout','succeeded',NULL,'36ff5363-d1d0-4334-b165-ecda596e8d39','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-14 14:54:42'),(11,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','login_succeeded','succeeded',NULL,'334e2328-4f25-428d-bbbb-c109c7edbd6c','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-14 14:58:25'),(12,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','logout','succeeded',NULL,'c4f4843a-9ed4-483a-97bc-6074003db9c4','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-14 15:01:04'),(13,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','login_succeeded','succeeded',NULL,'401cc2af-2406-4665-95c7-7b4f4cc90788','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-14 15:03:32'),(14,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','logout','succeeded',NULL,'6431d1a4-b6d6-497a-827a-d6e4087e7b1d','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-14 15:05:33'),(15,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','login_succeeded','succeeded',NULL,'0cbbd104-48b1-453d-b5ab-b1e61a541bd0','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-14 15:08:25'),(16,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','logout','succeeded',NULL,'d842b291-6644-45bc-a27d-94fc1ee83fa7','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-14 15:11:13'),(17,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','login_succeeded','succeeded',NULL,'763a709f-b02d-4e36-95b9-b1becddaea57','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-14 15:12:52'),(18,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','logout','succeeded',NULL,'95c5cbef-85fc-4d9f-a026-e4c19ab69f52','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-14 15:13:01'),(19,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','login_succeeded','succeeded',NULL,'ef541519-0e07-41d5-aa6d-b55f705769a8','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-14 15:13:56'),(20,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','logout','succeeded',NULL,'b54e0b05-1064-4140-8f79-f7115bdbaede','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-14 15:15:51'),(21,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','login_succeeded','succeeded',NULL,'d16c1c36-d219-40dc-88e1-59e367cd5aa6','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-14 15:15:57'),(22,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','logout','succeeded',NULL,'4dfb20ee-4022-4538-ac43-7a1ab4a30475','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-14 15:16:03'),(23,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','login_succeeded','succeeded',NULL,'486ca2e8-cefb-4c7d-bbb7-d1e21d03ed95','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-14 15:16:50'),(24,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','logout','succeeded',NULL,'8664fbba-4449-4ca5-a969-f03d8b05d15e','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-14 15:20:30'),(25,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','login_succeeded','succeeded',NULL,'c94c46b6-da88-4c8e-9499-0c2bb55ec2ea','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-14 15:21:30'),(26,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','logout','succeeded',NULL,'8c116e94-c2eb-492d-807a-398318c3b01b','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-14 15:22:31'),(27,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','login_succeeded','succeeded',NULL,'4e92fce8-8dc9-4c79-b25a-f56b0a5d13c1','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-14 15:22:37'),(28,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','logout','succeeded',NULL,'899b46ae-05b0-4384-bdbc-578462409ae4','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-14 15:23:48'),(29,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','login_succeeded','succeeded',NULL,'eb3b9e7b-56ad-4b8f-a0ea-b06bd71af9ec','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-14 15:24:33'),(30,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','logout','succeeded',NULL,'a9e912c9-1d16-4372-bf85-45d2e419ca8a','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-14 15:34:29'),(31,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','login_succeeded','succeeded',NULL,'8950c75d-dece-49dd-8c11-7211019940df','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-14 15:35:18'),(32,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','logout','succeeded',NULL,'552cdac4-a68d-4ad8-8a5a-67f8ec00f5be','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-14 15:36:07'),(33,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','login_succeeded','succeeded',NULL,'930012cc-89cc-4e7d-8bb8-13cef31d5c8b','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-14 15:37:36'),(34,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','login_succeeded','succeeded',NULL,'3e940957-ae82-4fd9-a0f4-da637ef2f518','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-14 15:37:38'),(35,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','logout','succeeded',NULL,'557a86a8-0b7c-4b55-8d09-83a7a67ca2d2','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-14 15:38:36'),(36,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','login_succeeded','succeeded',NULL,'5a0e875f-cf77-42fe-beb5-54d4b79d77ef','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-14 15:43:25'),(37,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','login_succeeded','succeeded',NULL,'0089c2e5-1b27-4a3d-bb37-2c3eec631c1a','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-15 06:17:33'),(38,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','logout','succeeded',NULL,'bb140fb7-0935-450f-8404-ed5dec4af970','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-15 06:45:39'),(39,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','login_succeeded','succeeded',NULL,'ff604806-5f55-4b8c-a0d7-df3377e74070','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-15 06:46:20'),(40,2,'a9b89d89cfc66dcb6bec3a79e369e5490b47c8e5f96bf3d587ee99c247d71787','email_verification_requested','succeeded',NULL,'e0551de8-d7e8-40f0-9d55-bb80a22923dd','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-15 07:01:31'),(41,2,'a9b89d89cfc66dcb6bec3a79e369e5490b47c8e5f96bf3d587ee99c247d71787','password_reset_link_sent','succeeded',NULL,'e0551de8-d7e8-40f0-9d55-bb80a22923dd','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-15 07:01:32'),(42,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','login_succeeded','succeeded',NULL,'6f229998-0b7c-4bf6-98d4-5872e458a1bb','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-15 07:17:30'),(43,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','logout','succeeded',NULL,'d20fcb8a-7ebe-41d6-b460-b1d2ab1412ea','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-15 07:58:51'),(44,2,'a9b89d89cfc66dcb6bec3a79e369e5490b47c8e5f96bf3d587ee99c247d71787','login_succeeded','succeeded',NULL,'8746fdea-b0cf-431c-baa3-a5ed5e5f0f96','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-15 07:59:33'),(45,2,'a9b89d89cfc66dcb6bec3a79e369e5490b47c8e5f96bf3d587ee99c247d71787','email_verification_requested','succeeded',NULL,'5758b4c8-a52d-44d1-a8b3-7bbb71557d90','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-15 07:59:41'),(46,2,'a9b89d89cfc66dcb6bec3a79e369e5490b47c8e5f96bf3d587ee99c247d71787','logout','succeeded',NULL,'20abd9c2-0879-4bd8-b46e-a3ce929867dd','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-15 08:09:49'),(47,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','login_succeeded','succeeded',NULL,'9349eee5-9076-4cf0-93d0-2badaaf62f63','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-15 08:10:10'),(48,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','logout','succeeded',NULL,'a2dd10c5-c5db-4e7c-ad49-204fc5c67e7a','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-15 08:15:45'),(49,2,'a9b89d89cfc66dcb6bec3a79e369e5490b47c8e5f96bf3d587ee99c247d71787','login_succeeded','succeeded',NULL,'c91e8451-e022-482a-8fec-f62825884192','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-15 08:16:27'),(50,2,'a9b89d89cfc66dcb6bec3a79e369e5490b47c8e5f96bf3d587ee99c247d71787','logout','succeeded',NULL,'9acdfe3d-8ef5-47a0-b16c-e8183674616d','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-15 08:17:28'),(51,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','login_succeeded','succeeded',NULL,'d56d5628-b436-4de7-9090-923c12239ea9','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-15 08:17:36'),(52,NULL,'8a33b7140aab1cf84d750dd5ae0d6dc4340b2a846b35ceb7be95728b5f2ebef7','login_failed','failed','invalid_credentials','8e19de72-f2e1-4f2b-9de4-559f18ffca3d','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-15 11:53:03'),(53,NULL,'8a33b7140aab1cf84d750dd5ae0d6dc4340b2a846b35ceb7be95728b5f2ebef7','login_failed','failed','invalid_credentials','41400c31-dd9b-4ed2-a8af-49fc4c151118','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-15 11:53:18'),(54,NULL,'8a33b7140aab1cf84d750dd5ae0d6dc4340b2a846b35ceb7be95728b5f2ebef7','login_failed','failed','invalid_credentials','14ac6f15-76e2-4f7c-860a-3e0274a470f1','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-15 11:53:20'),(55,NULL,'8a33b7140aab1cf84d750dd5ae0d6dc4340b2a846b35ceb7be95728b5f2ebef7','login_failed','failed','invalid_credentials','942f32e2-b6c5-455b-9b8d-0595228f7eeb','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-15 11:53:31'),(56,NULL,'8a33b7140aab1cf84d750dd5ae0d6dc4340b2a846b35ceb7be95728b5f2ebef7','login_failed','failed','invalid_credentials','82123924-daf5-46e8-8bc0-53e3195547c2','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-15 11:53:34'),(57,NULL,'8a33b7140aab1cf84d750dd5ae0d6dc4340b2a846b35ceb7be95728b5f2ebef7','login_failed','failed','invalid_credentials','da08c2da-e4cc-4db9-a994-3f72d04d5a79','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-15 12:03:07'),(58,NULL,'e706ae082ccc071cf63aed45364b2aea50865f7bab4b6a7d0588c7bf6f9ecce3','login_failed','failed','invalid_credentials','20af1eca-e673-4d22-91a3-50002ec63e21','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-15 12:03:15'),(59,NULL,'8a33b7140aab1cf84d750dd5ae0d6dc4340b2a846b35ceb7be95728b5f2ebef7','login_failed','failed','invalid_credentials','d75b73e1-c6cc-4025-b964-dfb450c6c499','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-15 12:03:58'),(60,NULL,'8a33b7140aab1cf84d750dd5ae0d6dc4340b2a846b35ceb7be95728b5f2ebef7','login_failed','failed','invalid_credentials','b1538c57-742b-44be-9bc0-da531a52b5a2','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-15 12:41:09'),(61,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','login_succeeded','succeeded',NULL,'1dcb5a3c-b3ef-43bd-985c-c22e8d605635','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-15 12:57:01'),(62,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','login_succeeded','succeeded',NULL,'dfb27e3a-76bf-4924-a0fc-f1416fac6dea','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-16 06:57:20'),(63,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','two_factor_enabled','succeeded',NULL,'3c3f060b-b176-4b58-85eb-9818b0b9333b','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-16 07:58:28'),(64,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','two_factor_disabled','succeeded',NULL,'6f03f11e-5786-41ec-a47e-54ff11ae5c09','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-16 07:58:38'),(65,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','login_succeeded','succeeded',NULL,'a5ba7888-9128-4526-a098-d41761dd2c39','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-16 10:13:26'),(66,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','login_succeeded','succeeded',NULL,'f207b4e0-6729-4c09-a865-c6076423300f','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-17 06:17:05'),(67,NULL,'72758ecd5c18f65f29f7ac1eb7cba7c02ef552cb0a79a27ade55ee44f94b4477','login_failed','failed','invalid_credentials','457b8ef2-4410-4927-b541-fe0ebfe70ad5','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-17 07:50:04'),(68,NULL,'72758ecd5c18f65f29f7ac1eb7cba7c02ef552cb0a79a27ade55ee44f94b4477','login_failed','failed','invalid_credentials','78700dde-a6e3-45ef-9145-70360fc36151','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-17 07:50:19'),(69,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','login_succeeded','succeeded',NULL,'efab5778-15ea-4186-ae36-d7635da6ca83','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-17 07:54:53'),(70,NULL,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','login_failed','failed','invalid_credentials','24db50c8-a4b4-4062-a778-70e265278a05','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-18 06:26:22'),(71,NULL,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','login_failed','failed','invalid_credentials','fb7c96a8-1360-484c-80eb-328f6868c111','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-18 06:26:45'),(72,NULL,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','login_failed','failed','invalid_credentials','7a91adfb-7228-4bb4-954b-22ca47b59693','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-18 06:35:57'),(73,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','login_succeeded','succeeded',NULL,'0b1cc768-e006-4978-ab3b-6b67bbf8422b','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-18 06:36:19'),(74,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','login_succeeded','succeeded',NULL,'4396b46e-4ae1-479d-971f-79e0e5706b22','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-18 08:56:09'),(75,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','login_succeeded','succeeded','api_token_issued','d95fe138-9722-4b61-83ef-f277db70a26e','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Microsoft Windows 10.0.19045; en-US) PowerShell/7.6.4','2026-08-18 15:06:43'),(76,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','login_succeeded','succeeded','api_token_issued','b6909820-f36d-4cd5-bfe7-2c715a8935e8','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Microsoft Windows 10.0.19045; en-US) PowerShell/7.6.4','2026-08-18 15:25:04'),(77,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','login_succeeded','succeeded','api_token_issued','cda72d9a-51db-405e-88bb-0fb46e6fc7e3','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Microsoft Windows 10.0.19045; en-US) PowerShell/7.6.4','2026-08-18 15:58:37'),(78,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','login_succeeded','succeeded','api_token_issued','d04632a2-8b8b-4393-9bdb-6a82f2a147c8','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Microsoft Windows 10.0.19045; en-US) PowerShell/7.6.4','2026-08-18 16:12:00'),(79,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','login_succeeded','succeeded','api_token_issued','d2eac0cc-79b8-4c64-a42b-588397a3a20a','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Microsoft Windows 10.0.19045; en-US) PowerShell/7.6.4','2026-08-18 16:12:33'),(80,1,'82c648dd2b9586dfb079b0117c4c0d2020a4519f3390b757fde4f0592fb67255','login_succeeded','succeeded',NULL,'9c9d25ea-a422-42f9-ae45-da7253762209','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-18 16:14:50'),(81,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_failed','failed','api_token_invalid_credentials','d2c4c44e-18ef-4015-b0f5-03d3ba71d7d2','127.0.0.1','GuzzleHttp/7','2026-08-19 07:19:00'),(82,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_failed','failed','api_token_invalid_credentials','c46fc7c2-6bc8-4c88-a8ee-c69a3345696d','127.0.0.1','GuzzleHttp/7','2026-08-19 07:19:13'),(83,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_failed','failed','api_token_invalid_credentials','338c79de-523c-44d6-8768-29436992f457','127.0.0.1','GuzzleHttp/7','2026-08-19 07:19:14'),(84,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_failed','failed','api_token_invalid_credentials','b3a49e24-26e0-4279-9ad1-86ebb574d4c9','127.0.0.1','GuzzleHttp/7','2026-08-19 07:23:06'),(85,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_failed','failed','api_token_invalid_credentials','ac3f433b-97c8-4588-8249-9116aee505a2','127.0.0.1','GuzzleHttp/7','2026-08-19 07:23:18'),(86,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_failed','failed','api_token_invalid_credentials','faeaa953-7bb9-40b1-b6df-be32da506e82','127.0.0.1','GuzzleHttp/7','2026-08-19 07:23:19'),(87,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_succeeded','succeeded','api_token_issued','b423b1ef-22ca-4299-a004-46f7e2b1ae2e','127.0.0.1','GuzzleHttp/7','2026-08-19 07:25:44'),(88,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_succeeded','succeeded','api_token_issued','665023dc-cf9b-4bc3-ba3e-ec629cb73198','127.0.0.1','GuzzleHttp/7','2026-08-19 07:26:00'),(89,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_succeeded','succeeded','api_token_issued','7a065fda-0c60-4cbc-b93e-ba6c006364e1','127.0.0.1','GuzzleHttp/7','2026-08-19 07:26:01'),(90,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_succeeded','succeeded','api_token_issued','481b69c4-3a60-4036-9183-8ea0763cabb3','127.0.0.1','GuzzleHttp/7','2026-08-19 07:28:51'),(91,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_succeeded','succeeded','api_token_issued','8f96c50e-ea3d-4b64-81cf-7812aa78a06a','127.0.0.1','GuzzleHttp/7','2026-08-19 07:29:06'),(92,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_succeeded','succeeded','api_token_issued','5a468ce8-88cb-4835-85c8-cb6caa10b4c5','127.0.0.1','GuzzleHttp/7','2026-08-19 07:29:08'),(93,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_succeeded','succeeded','api_token_issued','47083b98-226d-4a5f-92d6-ea4465ea5f3f','127.0.0.1','GuzzleHttp/7','2026-08-19 07:41:38'),(94,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_succeeded','succeeded','api_token_issued','ce923610-20a3-45fd-a0ef-eb3c546c2d6b','127.0.0.1','GuzzleHttp/7','2026-08-19 07:41:56'),(95,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_succeeded','succeeded','api_token_issued','ab2274bd-2d97-4ab9-ae8a-083403b41deb','127.0.0.1','GuzzleHttp/7','2026-08-19 07:41:58'),(96,NULL,'70327749a4731e24a06daa627ce68c125467778cc5f96883558e1f9f0395fca5','login_failed','failed','invalid_credentials','00daa92a-627c-49ca-8ecf-5b428032c0e7','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-19 08:04:29'),(97,NULL,'70327749a4731e24a06daa627ce68c125467778cc5f96883558e1f9f0395fca5','login_failed','failed','invalid_credentials','7be662db-4447-4c6e-bc38-a099dda2c0be','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-19 08:04:43'),(98,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','two_factor_challenged','succeeded',NULL,'8a9c3151-e259-4a06-8351-f767f1765224','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-19 08:05:08'),(99,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_succeeded','succeeded','api_token_issued','2f3cb674-cd82-4da2-b264-0710dbfec7cb','127.0.0.1','GuzzleHttp/7','2026-08-19 08:28:18'),(100,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_succeeded','succeeded','api_token_issued','8566b45b-3031-41b9-87e8-22dbaff31ab0','127.0.0.1','GuzzleHttp/7','2026-08-19 08:28:37'),(101,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_succeeded','succeeded','api_token_issued','341de772-ff74-4970-879f-b77888db3c06','127.0.0.1','GuzzleHttp/7','2026-08-19 08:28:38'),(102,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','two_factor_challenged','succeeded',NULL,'376ebc30-9357-46e0-9b8c-b2a369fefc7c','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-19 08:32:22'),(103,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_succeeded','succeeded','api_token_issued','e2ef4302-43cc-482e-af57-6a47748a8735','127.0.0.1','GuzzleHttp/7','2026-08-19 08:37:32'),(104,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_succeeded','succeeded','api_token_issued','30386707-5de6-4676-a7fa-15b1f8996fc2','127.0.0.1','GuzzleHttp/7','2026-08-19 08:37:48'),(105,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_succeeded','succeeded','api_token_issued','fc4729e7-b652-44b7-b571-c8735b77db6a','127.0.0.1','GuzzleHttp/7','2026-08-19 08:37:49'),(106,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_succeeded','succeeded','api_token_issued','79c6ecd2-ced7-40bf-a620-f11193c2928f','127.0.0.1','GuzzleHttp/7','2026-08-19 08:39:18'),(107,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_succeeded','succeeded','api_token_issued','d0942a74-fde0-4cac-b4fc-5d33480828c5','127.0.0.1','GuzzleHttp/7','2026-08-19 08:39:34'),(108,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_succeeded','succeeded','api_token_issued','0ab1180c-9ec5-4241-9a7b-24bb7bc73a38','127.0.0.1','GuzzleHttp/7','2026-08-19 08:39:36'),(109,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_succeeded','succeeded',NULL,'03e40b64-d0af-4222-93b2-4987c756b428','127.0.0.1','GuzzleHttp/7','2026-08-19 08:39:46'),(110,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_succeeded','succeeded',NULL,'577d62b2-dcb6-44b8-a6ab-22ff3c164571','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-19 09:09:05'),(111,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','logout','succeeded',NULL,'cdfc9ec4-5fcd-45e9-a5a4-e40e3b9dd34e','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-19 09:11:39'),(112,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_succeeded','succeeded',NULL,'bc92c1de-38aa-462c-8420-ccc76a53a3e8','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-19 09:11:55'),(113,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_succeeded','succeeded','api_token_issued','5f184964-44cc-4a8b-a831-fe2c41cba1d6','127.0.0.1','GuzzleHttp/7','2026-08-19 09:21:15'),(114,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_succeeded','succeeded','api_token_issued','b2c6d27a-3bc2-43b9-afeb-a7eb418f3590','127.0.0.1','GuzzleHttp/7','2026-08-19 09:21:31'),(115,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_succeeded','succeeded','api_token_issued','12f69be2-e17b-4430-b9ac-2853740e0086','127.0.0.1','GuzzleHttp/7','2026-08-19 09:21:32'),(116,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_succeeded','succeeded',NULL,'ec71e91f-a65c-4229-8c8f-c3845ac60b8f','127.0.0.1','GuzzleHttp/7','2026-08-19 09:21:42'),(117,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','logout','succeeded',NULL,'16b51226-3e08-4009-b42f-b0b7bf27bf39','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-19 09:30:56'),(118,NULL,'9d31f5cbc3c964138fa8de37006b04409fb323bdb62094489d41a3d0b5017fdd','login_failed','failed','invalid_credentials','9fbd93f6-0349-4c17-9a19-8488b2eda0d6','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-19 09:31:06'),(119,2,'9d31f5cbc3c964138fa8de37006b04409fb323bdb62094489d41a3d0b5017fdd','login_succeeded','succeeded',NULL,'6533b3b8-257b-4776-a14e-c8e363f013ef','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-19 09:31:16'),(120,2,'9d31f5cbc3c964138fa8de37006b04409fb323bdb62094489d41a3d0b5017fdd','logout','succeeded',NULL,'9a498a6f-fbcc-4516-a3bc-57aabeae2364','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-19 09:32:19'),(121,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_succeeded','succeeded',NULL,'e2db7a1d-6e64-4953-9d8a-13071463b2ed','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-19 09:32:24'),(122,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_succeeded','succeeded',NULL,'fd1cdeb2-237a-4c5c-b5a8-2d7053dd6e22','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-19 14:24:01'),(123,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_succeeded','succeeded',NULL,'04823875-5af3-43e2-b332-9ff93c028a71','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-20 06:07:50'),(124,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_succeeded','succeeded','api_token_issued','3153e19a-7dbe-4a56-8948-4f24e70b1ed1','127.0.0.1','GuzzleHttp/7','2026-08-20 06:16:54'),(125,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_succeeded','succeeded','api_token_issued','49b5b13a-ae75-4a50-9532-c5f8b45146ea','127.0.0.1','GuzzleHttp/7','2026-08-20 06:17:15'),(126,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_succeeded','succeeded','api_token_issued','fad9b936-ca62-4411-8b6b-ae473a669cd4','127.0.0.1','GuzzleHttp/7','2026-08-20 06:17:17'),(127,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_succeeded','succeeded',NULL,'622c9efa-feb8-41e9-8557-26c570aa2d14','127.0.0.1','GuzzleHttp/7','2026-08-20 06:17:36'),(128,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_succeeded','succeeded',NULL,'d550579e-54fa-4273-95c7-0c2eeaa7588e','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-20 11:40:07'),(129,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_succeeded','succeeded',NULL,'69f10f87-d6da-4db0-9f91-83005f4b543a','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-22 08:34:05'),(130,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','logout','succeeded',NULL,'7ca64f89-f201-4852-992a-335700bb6e6a','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-22 08:34:14'),(131,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_succeeded','succeeded',NULL,'944be551-31dd-41b5-9450-99de21ca5f8b','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-22 08:34:27'),(132,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','logout','succeeded',NULL,'50dcd96f-85f0-4e4b-bf1b-29756a994b06','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-22 08:34:35'),(133,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_succeeded','succeeded',NULL,'d4e64808-7150-4478-a450-4dae293ccdc6','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-22 08:37:14'),(134,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_succeeded','succeeded',NULL,'8e887e01-f109-4ef8-8250-58bb95595200','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-22 10:46:17'),(135,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','logout','succeeded',NULL,'ed8637a5-efde-4202-835d-57c04ac54d7d','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-22 10:56:36'),(136,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_succeeded','succeeded',NULL,'a5df80a0-9280-4d2b-ae13-c9a84032c084','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-22 11:11:48'),(137,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','logout','succeeded',NULL,'3e2176f3-6f94-472d-a194-ba234e29c54f','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-22 11:25:08'),(138,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_succeeded','succeeded',NULL,'bc3dc9af-7d8e-4737-8417-59adec3c1e93','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-22 11:29:09'),(139,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','logout','succeeded',NULL,'0f250aef-6583-4357-873c-159535581c1c','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-22 13:07:08'),(140,3,'0d5b1a3100dc7b9deb655b983803d2fa74e34699357805f762dd63a768856980','login_succeeded','succeeded',NULL,'93048326-09c0-4feb-bd63-5345f34bf2a2','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-22 13:07:23'),(141,3,'0d5b1a3100dc7b9deb655b983803d2fa74e34699357805f762dd63a768856980','logout','succeeded',NULL,'7127d9d7-3b71-453b-b34d-b2031999b232','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-22 13:07:43'),(142,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_succeeded','succeeded',NULL,'0ad78255-51db-4bdd-ba77-acdf6fc6943b','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-22 13:07:49'),(143,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_succeeded','succeeded',NULL,'1aab6c8f-7317-4c75-9d1c-083622109235','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-23 06:38:14'),(144,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','logout','succeeded',NULL,'888a55bf-0fdd-474e-bc33-24fd97d0af33','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-23 06:56:46'),(145,4,'15dba8f329ab0a5f37b274468a44f32b18b798144e10ac48355eba9cc0db8649','login_succeeded','succeeded',NULL,'5806c0c0-b1df-425d-b297-8d8321f1029c','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-23 06:57:14'),(146,4,'15dba8f329ab0a5f37b274468a44f32b18b798144e10ac48355eba9cc0db8649','logout','succeeded',NULL,'2d01e2e7-0269-4ee1-9a47-d4bdcf9cc7c2','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-23 06:57:50'),(147,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_succeeded','succeeded',NULL,'1642770b-9bc2-469b-9d02-73fbfc17aea0','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-23 06:58:02'),(148,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','logout','succeeded',NULL,'96823fd1-655f-4f39-acb0-d51c2592205a','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-23 11:00:14'),(149,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_succeeded','succeeded',NULL,'5ce44e27-8da3-4064-8a18-6886d34c3e96','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-23 11:00:39'),(150,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','logout','succeeded',NULL,'9d5f5466-bee0-4653-995e-8d6f839979e3','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-23 12:35:18'),(151,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_succeeded','succeeded',NULL,'3a5c0f0c-b358-4d4f-82e1-4b683923271d','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-23 12:35:37'),(152,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','logout','succeeded',NULL,'3af194e8-cb77-4ebe-8a1f-8def81eabdad','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-23 12:35:42'),(153,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_succeeded','succeeded',NULL,'f875e638-fa8a-471c-b304-8193e0705059','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-23 12:35:47'),(154,1,'237e6e575cbf1f546191b5c435aff76fc1b2fbe921d36cb0203e25ee00ccdfe0','login_succeeded','succeeded',NULL,'06c63e2e-8117-4bb0-8ce2-8f21b59331f4','127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-24 06:35:11');

--
-- Table structure for table `availability_exceptions`
--

CREATE TABLE `availability_exceptions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `schedulable_assignee_id` bigint(20) unsigned NOT NULL,
  `kind` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `starts_at` datetime NOT NULL,
  `ends_at` datetime NOT NULL,
  `reason` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_d53288d5c09b` (`schedulable_assignee_id`),
  CONSTRAINT `fk_d53288d5c09b` FOREIGN KEY (`schedulable_assignee_id`) REFERENCES `schedulable_assignees` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `availability_exceptions`
--


--
-- Table structure for table `availability_rules`
--

CREATE TABLE `availability_rules` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `schedulable_assignee_id` bigint(20) unsigned NOT NULL,
  `weekday` bigint(20) NOT NULL,
  `local_start_time` time NOT NULL,
  `local_end_time` time NOT NULL,
  `effective_from` date DEFAULT NULL,
  `effective_until` date DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_79af6515da8f` (`schedulable_assignee_id`),
  CONSTRAINT `fk_79af6515da8f` FOREIGN KEY (`schedulable_assignee_id`) REFERENCES `schedulable_assignees` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `availability_rules`
--


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

CREATE TABLE `cache` (
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` bigint(20) NOT NULL,
  PRIMARY KEY (`key`),
  KEY `cache_expiration_index` (`expiration`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `cache` VALUES ('laravel-cache-3b445967bb0cee5f4a8d5b482409afab','i:99;',1787559992),('laravel-cache-3b445967bb0cee5f4a8d5b482409afab:timer','i:1787559992;',1787559992),('laravel-cache-a3261395087b66ed9462371cb27019c9','i:99;',1787559914),('laravel-cache-a3261395087b66ed9462371cb27019c9:timer','i:1787559914;',1787559914),('laravel-cache-c7e648bd868e2794fe12d91a160a4904','i:2;',1787559992),('laravel-cache-c7e648bd868e2794fe12d91a160a4904:timer','i:1787559992;',1787559992),('laravel-cache-seo.sitemap','a:12:{i:0;a:2:{s:3:\"url\";s:21:\"http://localhost/work\";s:13:\"last_modified\";N;}i:1;a:2:{s:3:\"url\";s:21:\"http://localhost/blog\";s:13:\"last_modified\";N;}i:2;a:2:{s:3:\"url\";s:24:\"http://localhost/careers\";s:13:\"last_modified\";N;}i:3;a:2:{s:3:\"url\";s:21:\"http://localhost/book\";s:13:\"last_modified\";N;}i:4;a:2:{s:3:\"url\";s:22:\"http://localhost/quote\";s:13:\"last_modified\";N;}i:5;a:2:{s:3:\"url\";s:40:\"http://localhost/blog/ai-agents-business\";s:13:\"last_modified\";s:25:\"2026-08-18T08:35:54+00:00\";}i:6;a:2:{s:3:\"url\";s:39:\"http://localhost/blog/custom-erp-system\";s:13:\"last_modified\";s:25:\"2026-08-18T08:35:54+00:00\";}i:7;a:2:{s:3:\"url\";s:40:\"http://localhost/blog/mobile-app-product\";s:13:\"last_modified\";s:25:\"2026-08-18T08:35:54+00:00\";}i:8;a:2:{s:3:\"url\";s:43:\"http://localhost/blog/scalable-web-platform\";s:13:\"last_modified\";s:25:\"2026-08-18T08:35:55+00:00\";}i:9;a:2:{s:3:\"url\";s:61:\"http://localhost/careers/08bf029f-b211-4e8d-931e-42b65d2f38c0\";s:13:\"last_modified\";s:25:\"2026-08-17T08:16:57+00:00\";}i:10;a:2:{s:3:\"url\";s:61:\"http://localhost/careers/b298c13a-ced0-41ed-a26e-0aba15eb7ff6\";s:13:\"last_modified\";s:25:\"2026-08-17T08:16:57+00:00\";}i:11;a:2:{s:3:\"url\";s:61:\"http://localhost/careers/c2f81537-8721-4936-a865-bcdc7558fc22\";s:13:\"last_modified\";s:25:\"2026-08-17T08:16:57+00:00\";}}',1787560836);

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

CREATE TABLE `cache_locks` (
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `owner` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` bigint(20) NOT NULL,
  PRIMARY KEY (`key`),
  KEY `cache_locks_expiration_index` (`expiration`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cache_locks`
--


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

CREATE TABLE `clients` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `public_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `summary` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'draft',
  `display_order` bigint(20) NOT NULL DEFAULT '0',
  `lock_version` bigint(20) NOT NULL DEFAULT '0',
  `updated_by_user_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `website_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `deleted_by` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `clients_public_id_unique` (`public_id`),
  UNIQUE KEY `clients_slug_unique` (`slug`),
  KEY `clients_status_display_order_name_index` (`status`,`display_order`,`name`),
  KEY `clients_deleted_at_index` (`deleted_at`),
  KEY `fk_db030e9fcff6` (`updated_by_user_id`),
  CONSTRAINT `fk_db030e9fcff6` FOREIGN KEY (`updated_by_user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `clients` VALUES (1,'0522042f-7f84-4fca-b7cf-8358af20dc68','شركة تكسس للشحن واللوجستيات','texas-logistics','عميل معتمد لدى Seven Tech',NULL,'published',1,0,NULL,'2026-08-17 15:10:13','2026-08-17 15:10:13',NULL,NULL,NULL),(2,'9592430c-df1e-4736-84cc-65ef9ea7dcb6','شركة المتاجر الذكية','smart-retail-co','عميل معتمد لدى Seven Tech',NULL,'published',2,0,NULL,'2026-08-17 15:10:14','2026-08-17 15:10:14',NULL,NULL,NULL),(3,'68d19e46-8df4-4bfe-883a-b657d078eb95','شبكة ميدكير للرعاية الصحية','medicare-network','عميل معتمد لدى Seven Tech',NULL,'published',3,0,NULL,'2026-08-17 15:10:14','2026-08-17 15:10:14',NULL,NULL,NULL),(4,'dddd7130-c1fa-473d-b0a8-dac2ae606447','مجموعة كير للخدمات','care-group','عميل معتمد لدى Seven Tech',NULL,'published',4,0,NULL,'2026-08-17 15:10:14','2026-08-17 15:10:14',NULL,NULL,NULL),(5,'0c93d200-6351-4c9e-ba65-645fee1e51a3','هورايزون كلاود','horizon-cloud','عميل معتمد لدى Seven Tech',NULL,'published',5,0,NULL,'2026-08-17 15:10:14','2026-08-17 15:10:14',NULL,NULL,NULL),(6,'c14a0070-ea14-4499-82ac-525cd78fa1b9','ألفا للخدمات المالية','alpha-financial','عميل معتمد لدى Seven Tech',NULL,'published',6,0,NULL,'2026-08-17 15:10:14','2026-08-17 15:10:14',NULL,NULL,NULL);

--
-- Table structure for table `company_profiles`
--

CREATE TABLE `company_profiles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `public_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `profile_key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `legal_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tagline` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `public_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `public_phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_line` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `website_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lock_version` bigint(20) NOT NULL DEFAULT '0',
  `updated_by_user_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `about_content` longtext COLLATE utf8mb4_unicode_ci,
  `contact_content` json DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `company_profiles_public_id_unique` (`public_id`),
  UNIQUE KEY `company_profiles_profile_key_unique` (`profile_key`),
  KEY `fk_a8a9e4cc1627` (`updated_by_user_id`),
  CONSTRAINT `fk_a8a9e4cc1627` FOREIGN KEY (`updated_by_user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `company_profiles`
--

INSERT INTO `company_profiles` VALUES (1,'0297efe0-f164-4889-8f9b-2db07e6481b2','primary','7 Tech','7 Tech',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,'2026-08-14 14:31:15','2026-08-14 14:31:15',NULL,NULL);

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

CREATE TABLE `contacts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `public_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `company_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_normalized` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `timezone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'UTC',
  `locale` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'en',
  `notes` longtext COLLATE utf8mb4_unicode_ci,
  `owner_user_id` bigint(20) unsigned DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `lock_version` bigint(20) NOT NULL DEFAULT '0',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `deleted_by` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `contacts_email_normalized_unique` (`email_normalized`),
  UNIQUE KEY `contacts_public_id_unique` (`public_id`),
  KEY `contacts_is_active_owner_user_id_name_index` (`is_active`,`owner_user_id`,`name`),
  KEY `contacts_deleted_at_index` (`deleted_at`),
  KEY `fk_79fcb5dcd076` (`owner_user_id`),
  CONSTRAINT `fk_79fcb5dcd076` FOREIGN KEY (`owner_user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


--
-- Table structure for table `currencies`
--

CREATE TABLE `currencies` (
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `symbol` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `minor_unit` bigint(20) NOT NULL DEFAULT '2',
  `is_enabled` tinyint(1) NOT NULL DEFAULT '1',
  `display_order` bigint(20) NOT NULL DEFAULT '0',
  `lock_version` bigint(20) NOT NULL DEFAULT '0',
  `updated_by_user_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `deleted_by` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`code`),
  KEY `currencies_is_enabled_display_order_code_index` (`is_enabled`,`display_order`,`code`),
  KEY `currencies_deleted_at_index` (`deleted_at`),
  KEY `fk_dd6415492be1` (`updated_by_user_id`),
  CONSTRAINT `fk_dd6415492be1` FOREIGN KEY (`updated_by_user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `currencies`
--

INSERT INTO `currencies` VALUES ('USD','US Dollar','$',2,1,0,0,NULL,'2026-08-17 08:15:57','2026-08-17 08:15:57',NULL,NULL);

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

CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`),
  KEY `failed_jobs_connection_queue_failed_at_index` (`connection`,`queue`,`failed_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `feature_service`
--

CREATE TABLE `feature_service` (
  `feature_id` bigint(20) unsigned NOT NULL,
  `service_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`feature_id`,`service_id`),
  KEY `fk_b9f3d615e3ae` (`service_id`),
  CONSTRAINT `fk_b9f3d615e3ae` FOREIGN KEY (`service_id`) REFERENCES `services` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_e6a27b25edae` FOREIGN KEY (`feature_id`) REFERENCES `features` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `feature_service`
--


--
-- Table structure for table `feature_template`
--

CREATE TABLE `feature_template` (
  `feature_id` bigint(20) unsigned NOT NULL,
  `template_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`feature_id`,`template_id`),
  KEY `fk_e31315a4c6bd` (`template_id`),
  CONSTRAINT `fk_dfb75550c25a` FOREIGN KEY (`feature_id`) REFERENCES `features` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_e31315a4c6bd` FOREIGN KEY (`template_id`) REFERENCES `templates` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `feature_template`
--


--
-- Table structure for table `features`
--

CREATE TABLE `features` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `public_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `summary` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'draft',
  `display_order` bigint(20) NOT NULL DEFAULT '0',
  `lock_version` bigint(20) NOT NULL DEFAULT '0',
  `updated_by_user_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `deleted_by` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `features_public_id_unique` (`public_id`),
  UNIQUE KEY `features_slug_unique` (`slug`),
  KEY `features_status_display_order_name_index` (`status`,`display_order`,`name`),
  KEY `features_deleted_at_index` (`deleted_at`),
  KEY `fk_3fa7a186f222` (`updated_by_user_id`),
  CONSTRAINT `fk_3fa7a186f222` FOREIGN KEY (`updated_by_user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `features`
--


--
-- Table structure for table `footer_links`
--

CREATE TABLE `footer_links` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `public_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `group` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `label` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_order` bigint(20) NOT NULL DEFAULT '0',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `lock_version` bigint(20) NOT NULL DEFAULT '0',
  `updated_by_user_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `deleted_by` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `footer_links_public_id_unique` (`public_id`),
  KEY `footer_links_group_display_order_index` (`group`,`display_order`),
  KEY `footer_links_group_index` (`group`),
  KEY `footer_links_deleted_at_index` (`deleted_at`),
  KEY `fk_328fe2099a54` (`updated_by_user_id`),
  CONSTRAINT `fk_328fe2099a54` FOREIGN KEY (`updated_by_user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `footer_links`
--

INSERT INTO `footer_links` VALUES (1,'20e0f10e-9459-42aa-bd16-49b3bfee7158','company','عن Seven Tech','/about',1,1,0,NULL,'2026-08-24 07:36:57','2026-08-24 07:36:57',NULL,NULL),(2,'c2dce5ae-2a7a-4ee9-b951-b5e426425d2a','company','الفريق والخبراء','/about#team',2,1,0,NULL,'2026-08-24 07:36:57','2026-08-24 07:36:57',NULL,NULL),(3,'0c5b3ea9-4bcb-4260-9a4a-c92b0cfb2703','company','الوظائف','/careers',3,1,0,NULL,'2026-08-24 07:36:57','2026-08-24 07:36:57',NULL,NULL),(4,'31704601-216f-4a65-b556-ead0619f852c','company','المدونة','/blog',4,1,0,NULL,'2026-08-24 07:36:57','2026-08-24 07:36:57',NULL,NULL),(5,'32416241-4592-435c-97b0-78c8224652fc','services','تطبيقات الجوال','/services',1,1,0,NULL,'2026-08-24 07:36:57','2026-08-24 07:36:57',NULL,NULL),(6,'ea7b0190-fa7a-4352-b8c6-b7c13ae353d6','services','المواقع والمنصات','/services',2,1,0,NULL,'2026-08-24 07:36:57','2026-08-24 07:36:57',NULL,NULL),(7,'636e189a-9f33-4db3-92a6-91081fd72b24','services','أنظمة الإدارة ERP','/services',3,1,0,NULL,'2026-08-24 07:36:57','2026-08-24 07:36:57',NULL,NULL),(8,'60e7d48f-fcd6-4dc3-b47c-45101c4fad66','services','أتمتة الأعمال','/services',4,1,0,NULL,'2026-08-24 07:36:57','2026-08-24 07:36:57',NULL,NULL),(9,'cd774275-a8b0-4e62-8dca-5bc65512fcdb','services','حلول AI Agents','/services',5,1,0,NULL,'2026-08-24 07:36:57','2026-08-24 07:36:57',NULL,NULL),(10,'fe6abea3-725b-40ba-be34-5a17691ec17c','explore','أعمالنا المشاريع','/projects',1,1,0,NULL,'2026-08-24 07:36:57','2026-08-24 07:36:57',NULL,NULL),(11,'3802c452-dbfd-4dc7-bd32-c65933c13ea9','explore','قائمة العملاء','/clients',2,1,0,NULL,'2026-08-24 07:36:57','2026-08-24 07:36:57',NULL,NULL),(12,'71994020-d2c9-440a-8bad-de2aa8266851','explore','الشركاء التقنيين','/partners',3,1,0,NULL,'2026-08-24 07:36:57','2026-08-24 07:36:57',NULL,NULL),(13,'27fa8bac-a90e-4d82-b855-3ee5083da9aa','contact','? مصر (الإسكندرية): +20 155 004 1688','tel:+201550041688',1,1,0,NULL,'2026-08-24 07:36:57','2026-08-24 07:36:57',NULL,NULL),(14,'96010516-ca16-4c38-b138-9eb54eaac9fe','contact','? السعودية (الرياض): +966 53 955 5889','tel:+966539555889',2,1,0,NULL,'2026-08-24 07:36:57','2026-08-24 07:36:57',NULL,NULL),(15,'ecd9f6c1-8776-4cf5-84b2-eeb338157b36','contact','✉️ البريد الإلكتروني: eg@7tech.sa','mailto:eg@7tech.sa',3,1,0,NULL,'2026-08-24 07:36:57','2026-08-24 07:36:57',NULL,NULL),(16,'4b44b5bb-3d06-4b8c-8031-85cae52a52a1','social','Facebook','https://facebook.com',1,1,0,NULL,'2026-08-24 07:36:57','2026-08-24 07:36:57',NULL,NULL),(17,'1f65f556-bd33-4f7d-b7da-793517749a9e','social','Email','mailto:eg@7tech.sa',2,1,0,NULL,'2026-08-24 07:36:57','2026-08-24 07:36:57',NULL,NULL),(18,'447d0afb-bbe0-44f1-a4c0-c6cb37d4bfb8','social','WhatsApp','https://wa.me/966539555889',3,1,0,NULL,'2026-08-24 07:36:57','2026-08-24 07:36:57',NULL,NULL),(19,'58246f65-4645-4ab2-b8fc-bcb48edc8a87','social','Phone Call','tel:+966539555889',4,1,0,NULL,'2026-08-24 07:36:57','2026-08-24 07:36:57',NULL,NULL),(20,'a45faa5f-6316-4a3c-82b9-4540493b6ea3','legal','سياسة الخصوصية','/privacy',1,1,0,NULL,'2026-08-24 07:36:57','2026-08-24 07:36:57',NULL,NULL),(21,'06ca9ce9-edb9-4127-98d2-444258577df9','legal','الشروط والأحكام','/terms',2,1,0,NULL,'2026-08-24 07:36:57','2026-08-24 07:36:57',NULL,NULL),(22,'fa8017e3-aa68-4624-b24f-6f814981e931','legal','سياسة ملفات الكوكيز','/cookies',3,1,0,NULL,'2026-08-24 07:36:57','2026-08-24 07:36:57',NULL,NULL);

--
-- Table structure for table `footer_settings`
--

CREATE TABLE `footer_settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `public_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `settings_key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tagline` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `copyright_notice` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_enabled` tinyint(1) NOT NULL DEFAULT '1',
  `lock_version` bigint(20) NOT NULL DEFAULT '0',
  `updated_by_user_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `footer_settings_public_id_unique` (`public_id`),
  UNIQUE KEY `footer_settings_settings_key_unique` (`settings_key`),
  KEY `fk_f7d077273447` (`updated_by_user_id`),
  CONSTRAINT `fk_f7d077273447` FOREIGN KEY (`updated_by_user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `footer_settings`
--

INSERT INTO `footer_settings` VALUES (1,'37a3067b-bd06-4645-ba86-669a731fddbe','primary','البرمجيات، الذكاء الاصطناعي، الأتمتة. صُممت وطوّرت لخدمة أهداف عملك وتنمية استثمارك.','© Seven Tech 2026 .. جميع الحقوق محفوظة.',1,0,NULL,'2026-08-16 16:02:15','2026-08-24 07:36:56');

--
-- Table structure for table `home_page_revisions`
--

CREATE TABLE `home_page_revisions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `public_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `home_page_id` bigint(20) unsigned NOT NULL,
  `revision_number` bigint(20) NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `page_title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `meta_description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `publish_at` datetime DEFAULT NULL,
  `published_at` datetime DEFAULT NULL,
  `created_by_user_id` bigint(20) unsigned DEFAULT NULL,
  `updated_by_user_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `home_page_revisions_home_page_id_revision_number_unique` (`home_page_id`,`revision_number`),
  UNIQUE KEY `home_page_revisions_public_id_unique` (`public_id`),
  KEY `home_page_revisions_home_page_id_status_publish_at_index` (`home_page_id`,`status`,`publish_at`),
  KEY `fk_76782cc34785` (`created_by_user_id`),
  KEY `fk_ada5a169e17c` (`updated_by_user_id`),
  CONSTRAINT `fk_76782cc34785` FOREIGN KEY (`created_by_user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `fk_ada5a169e17c` FOREIGN KEY (`updated_by_user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `fk_d0d4664f9e0c` FOREIGN KEY (`home_page_id`) REFERENCES `home_pages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `home_page_revisions`
--

INSERT INTO `home_page_revisions` VALUES (1,'6516ad62-6353-421f-a599-c5298b1e1939',1,1,'draft','Home',NULL,NULL,NULL,NULL,NULL,'2026-08-14 14:31:15','2026-08-14 14:31:15');

--
-- Table structure for table `home_page_sections`
--

CREATE TABLE `home_page_sections` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `home_page_revision_id` bigint(20) unsigned NOT NULL,
  `section_key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `eyebrow` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `heading` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `body` longtext COLLATE utf8mb4_unicode_ci,
  `cta_label` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cta_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `display_order` bigint(20) NOT NULL,
  `is_enabled` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `heading_highlight` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `media_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `home_page_sections_home_page_revision_id_section_key_unique` (`home_page_revision_id`,`section_key`),
  KEY `fk_b9c375108ccf` (`media_id`),
  CONSTRAINT `fk_4ae3bc4d8fe8` FOREIGN KEY (`home_page_revision_id`) REFERENCES `home_page_revisions` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `fk_b9c375108ccf` FOREIGN KEY (`media_id`) REFERENCES `media` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `home_page_sections`
--

INSERT INTO `home_page_sections` VALUES (1,1,'hero',NULL,'نبتكر التقنية لنبتكر معك','نحن نبني مواقع إلكترونية، تطبيقات، أنظمة ذكية وحلول AI تحول أفكارك إلى منتجات رقمية تصنع أثرًا حقيقيًا.',NULL,NULL,10,1,'2026-08-14 14:31:15','2026-08-14 14:31:15','المستقبل','خبرة موثوقة، تكنولوجيا حديثة، أثر حقيقي على الأعمال.',NULL),(2,1,'introduction',NULL,'Introduction',NULL,NULL,NULL,20,1,'2026-08-14 14:31:15','2026-08-14 14:31:15',NULL,NULL,NULL),(3,1,'call_to_action',NULL,'Call to action',NULL,NULL,NULL,30,1,'2026-08-14 14:31:15','2026-08-14 14:31:15',NULL,NULL,NULL),(4,1,'process','منهجية تنفيذ واضحة','استراتيجية تحوّل','من الفهم والتخطيط إلى الإطلاق والتطوير، ندير كل مرحلة بمخرجات واضحة وقابلة للقياس.',NULL,NULL,30,1,'2026-08-23 11:39:57','2026-08-23 11:39:57','الفكرة إلى منتج ناجح','خطة التنفيذ: خمس مراحل مترابطة',NULL);

--
-- Table structure for table `home_pages`
--

CREATE TABLE `home_pages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `public_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `page_key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lock_version` bigint(20) NOT NULL DEFAULT '0',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `home_pages_public_id_unique` (`public_id`),
  UNIQUE KEY `home_pages_page_key_unique` (`page_key`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `home_pages`
--

INSERT INTO `home_pages` VALUES (1,'da29a09a-125d-4d4b-ab6b-1c7a98096eb4','home',0,'2026-08-14 14:31:15','2026-08-14 14:31:15');

--
-- Table structure for table `home_section_buttons`
--

CREATE TABLE `home_section_buttons` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `public_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `home_page_section_id` bigint(20) unsigned NOT NULL,
  `label` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `style` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'primary',
  `opens_in_new_tab` tinyint(1) NOT NULL DEFAULT '0',
  `display_order` bigint(20) NOT NULL DEFAULT '0',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `home_section_buttons_public_id_unique` (`public_id`),
  KEY `home_section_buttons_home_page_section_id_display_order_index` (`home_page_section_id`,`display_order`),
  CONSTRAINT `fk_e868ad730d46` FOREIGN KEY (`home_page_section_id`) REFERENCES `home_page_sections` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `home_section_buttons`
--

INSERT INTO `home_section_buttons` VALUES (1,'5befc00c-3f83-408a-89e8-68e34bd9c0d0',1,'ابدأ مشروعك الآن ←','/quote','primary',0,0,1,'2026-08-23 11:15:45','2026-08-23 11:15:45'),(2,'638bf64b-65eb-4239-8579-ca1f48274dfa',1,'استكشف أعمالنا ←','/portfolio','secondary',0,1,1,'2026-08-23 11:15:45','2026-08-23 11:15:45');

--
-- Table structure for table `home_section_items`
--

CREATE TABLE `home_section_items` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `public_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `home_page_section_id` bigint(20) unsigned NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `body` longtext COLLATE utf8mb4_unicode_ci,
  `value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `media_id` bigint(20) unsigned DEFAULT NULL,
  `display_order` bigint(20) NOT NULL DEFAULT '0',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `home_section_items_public_id_unique` (`public_id`),
  KEY `home_section_items_home_page_section_id_display_order_index` (`home_page_section_id`,`display_order`),
  KEY `fk_90e968e15ef4` (`media_id`),
  CONSTRAINT `fk_75cfc28fcceb` FOREIGN KEY (`home_page_section_id`) REFERENCES `home_page_sections` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_90e968e15ef4` FOREIGN KEY (`media_id`) REFERENCES `media` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `home_section_items`
--

INSERT INTO `home_section_items` VALUES (1,'85bd3531-755e-4dc8-9ee1-519c8104e037',1,'دول',NULL,'+9','globe',NULL,NULL,0,1,'2026-08-23 11:15:45','2026-08-23 11:15:45'),(2,'f7bfa3a3-ad09-4853-acd6-818c3f55ca8f',1,'عميل',NULL,'+50','users',NULL,NULL,1,1,'2026-08-23 11:15:45','2026-08-23 11:15:45'),(3,'eed728ea-afd6-4ffa-b6d0-60d9a4e80f69',1,'مشروع',NULL,'+150','briefcase',NULL,NULL,2,1,'2026-08-23 11:15:45','2026-08-23 11:15:45'),(4,'96321128-5d97-49cc-826d-94bdddbbd165',1,'سنة خبرة',NULL,'+20','award',NULL,NULL,3,1,'2026-08-23 11:15:45','2026-08-23 11:15:45'),(5,'b8786067-8610-4c38-b4a4-e33d33ebc4ed',4,'نكتشف الفكرة','نفهم هدفك واحتياجاتك ونحلل التحديات وفرص النمو.','01','lightbulb',NULL,NULL,0,1,'2026-08-23 11:39:57','2026-08-23 11:39:57'),(6,'b098a059-1cc9-4f22-9574-1fda960cf284',4,'نصمم الحل','نضع الاستراتيجية ونصمم تجربة ومعمارية الحل.','02','pencil',NULL,NULL,1,1,'2026-08-23 11:39:57','2026-08-23 11:39:57'),(7,'fced5bdf-8433-4a51-89f7-cf4b94974d9a',4,'نطوّر المنتج','نبرمج ونختبر المنتج وفق معايير الأداء والأمان والجودة.','03','code',NULL,NULL,2,1,'2026-08-23 11:39:57','2026-08-23 11:39:57'),(8,'112e7197-f176-493f-a902-36c0e5dda51e',4,'نطلق المشروع','نجهز الإطلاق ونتحقق من الجاهزية ونراقب الأداء منذ اليوم الأول.','04','rocket',NULL,NULL,3,1,'2026-08-23 11:39:57','2026-08-23 11:39:57'),(9,'cf63cf07-9a67-4689-ae17-f6487e97c2d0',4,'ندعم ونطوّر','نتابع الأداء ونطوّر الحل باستمرار ليواكب نمو عملك.','05','trending-up',NULL,NULL,4,1,'2026-08-23 11:39:57','2026-08-23 11:39:57');

--
-- Table structure for table `industries`
--

CREATE TABLE `industries` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `public_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `summary` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'draft',
  `display_order` bigint(20) NOT NULL DEFAULT '0',
  `lock_version` bigint(20) NOT NULL DEFAULT '0',
  `updated_by_user_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `deleted_by` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `industries_public_id_unique` (`public_id`),
  UNIQUE KEY `industries_slug_unique` (`slug`),
  KEY `industries_status_display_order_name_index` (`status`,`display_order`,`name`),
  KEY `industries_deleted_at_index` (`deleted_at`),
  KEY `fk_41b80a8de9df` (`updated_by_user_id`),
  CONSTRAINT `fk_41b80a8de9df` FOREIGN KEY (`updated_by_user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `industries`
--


--
-- Table structure for table `industry_service`
--

CREATE TABLE `industry_service` (
  `industry_id` bigint(20) unsigned NOT NULL,
  `service_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`industry_id`,`service_id`),
  KEY `fk_aee68248b868` (`service_id`),
  CONSTRAINT `fk_11a8233a8767` FOREIGN KEY (`industry_id`) REFERENCES `industries` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_aee68248b868` FOREIGN KEY (`service_id`) REFERENCES `services` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `industry_service`
--


--
-- Table structure for table `integration_connections`
--

CREATE TABLE `integration_connections` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `public_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `scope` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'analytics',
  `provider` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `encrypted_credentials` longtext COLLATE utf8mb4_unicode_ci,
  `configuration` longtext COLLATE utf8mb4_unicode_ci,
  `allowed_events` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `consent_required` tinyint(1) NOT NULL DEFAULT '1',
  `is_active` tinyint(1) NOT NULL DEFAULT '0',
  `lock_version` bigint(20) NOT NULL DEFAULT '0',
  `last_health_checked_at` datetime DEFAULT NULL,
  `last_health_status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `updated_by_user_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `deleted_by` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `integration_connections_public_id_unique` (`public_id`),
  UNIQUE KEY `integration_connections_scope_provider_unique` (`scope`,`provider`),
  KEY `integration_connections_is_active_scope_index` (`is_active`,`scope`),
  KEY `integration_connections_deleted_at_index` (`deleted_at`),
  KEY `fk_ed88492f18c1` (`updated_by_user_id`),
  CONSTRAINT `fk_ed88492f18c1` FOREIGN KEY (`updated_by_user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `integration_connections`
--


--
-- Table structure for table `integration_deliveries`
--

CREATE TABLE `integration_deliveries` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `outbox_message_id` bigint(20) unsigned NOT NULL,
  `integration_connection_id` bigint(20) unsigned NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempt_count` bigint(20) NOT NULL DEFAULT '0',
  `provider_message_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `error_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `attempted_at` datetime DEFAULT NULL,
  `delivered_at` datetime DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `integration_delivery_unique` (`outbox_message_id`,`integration_connection_id`),
  KEY `integration_deliveries_status_attempted_at_index` (`status`,`attempted_at`),
  KEY `fk_555b3a80ad42` (`integration_connection_id`),
  CONSTRAINT `fk_555b3a80ad42` FOREIGN KEY (`integration_connection_id`) REFERENCES `integration_connections` (`id`) ON DELETE NO ACTION,
  CONSTRAINT `fk_9bb67650dd88` FOREIGN KEY (`outbox_message_id`) REFERENCES `outbox_messages` (`id`) ON DELETE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `integration_deliveries`
--


--
-- Table structure for table `job_application_status_history`
--

CREATE TABLE `job_application_status_history` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `job_application_id` bigint(20) unsigned NOT NULL,
  `from_status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `to_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `actor_user_id` bigint(20) unsigned DEFAULT NULL,
  `reason` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `occurred_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_8cb3a261455f` (`job_application_id`),
  KEY `fk_702f0b8a638b` (`actor_user_id`),
  CONSTRAINT `fk_702f0b8a638b` FOREIGN KEY (`actor_user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `fk_8cb3a261455f` FOREIGN KEY (`job_application_id`) REFERENCES `job_applications` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `job_application_status_history`
--

INSERT INTO `job_application_status_history` VALUES (1,1,'submitted','rejected',1,NULL,'2026-08-17 08:20:04'),(2,4,'submitted','reviewing',1,NULL,'2026-08-17 08:20:20'),(3,4,'reviewing','shortlisted',1,NULL,'2026-08-17 08:20:26'),(4,4,'shortlisted','hired',1,NULL,'2026-08-17 08:20:33'),(5,2,'reviewing','rejected',1,NULL,'2026-08-17 08:20:44'),(6,3,'shortlisted','hired',1,NULL,'2026-08-17 08:50:45');

--
-- Table structure for table `job_applications`
--

CREATE TABLE `job_applications` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `public_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `job_id` bigint(20) unsigned NOT NULL,
  `applicant_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_normalized` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cover_letter` longtext COLLATE utf8mb4_unicode_ci,
  `cv_media_id` bigint(20) unsigned NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'submitted',
  `lock_version` bigint(20) NOT NULL DEFAULT '0',
  `submitted_at` datetime NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `deleted_by` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `job_applications_job_id_email_normalized_unique` (`job_id`,`email_normalized`),
  UNIQUE KEY `job_applications_public_id_unique` (`public_id`),
  KEY `job_applications_status_submitted_at_index` (`status`,`submitted_at`),
  KEY `job_applications_deleted_at_index` (`deleted_at`),
  KEY `fk_8cda90e4231b` (`cv_media_id`),
  CONSTRAINT `fk_03933cb5bf0b` FOREIGN KEY (`job_id`) REFERENCES `job_postings` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_8cda90e4231b` FOREIGN KEY (`cv_media_id`) REFERENCES `media` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `job_applications`
--

INSERT INTO `job_applications` VALUES (1,'1937111a-948e-4a03-a053-b1ead43f3a27',1,'أحمد محمود السعيد','ahmed.mahmoud@example.com','ahmed.mahmoud@example.com','+966 50 123 4567','لدي خبرة تتجاوز 7 سنوات في تطوير تطبيقات الويب باستخدام Laravel و Vue.js والأنظمة السحابية.',1,'rejected',1,'2026-08-17 05:16:57','2026-08-17 08:16:57','2026-08-17 08:20:04',NULL,NULL),(2,'a240819c-326a-4d26-af08-c89decc68ab2',2,'سارة إبراهيم المنصوري','sarah.almansoori@example.com','sarah.almansoori@example.com','+971 52 987 6543','مصممة واجهات وتجربة مستخدم، قمت بتصميم وتطوير أكثر من 20 مشروعاً وتطبيقاً رقمياً ناجحاً.',1,'rejected',1,'2026-08-16 06:16:57','2026-08-17 08:16:57','2026-08-17 08:20:44',NULL,NULL),(3,'4a0d472e-e860-4b07-9555-f74f6046213e',1,'محمد طارق عبد الرحمن','m.tariq@example.com','m.tariq@example.com','+20 10 9988 7766','مطور برمجيات متقدم متخصص في تحسين الأداء والأمان وهيكلة الخدمات المصغرة.',1,'hired',1,'2026-08-15 08:16:57','2026-08-17 08:16:57','2026-08-17 08:50:45',NULL,NULL),(4,'32190c32-c027-4abd-a692-8173415d33b3',3,'نورا خالد الشمري','noura.alshammari@example.com','noura.alshammari@example.com','+966 55 443 2211','أخصائية تسويق رقمي مع سجل حافل في زيادة نسب التحويل وإدارة الحملات الإعلانية التقنية.',1,'hired',3,'2026-08-16 20:16:57','2026-08-17 08:16:57','2026-08-17 08:20:33',NULL,NULL),(5,'2a7994a4-ce3a-4c84-87dc-4bed5e50f7ed',1,'يوسف كمال حسان','youssef.kamal@example.com','youssef.kamal@example.com','+20 11 2233 4455','متحمس للانضمام إلى فريق 7 Tech والمساهمة في بناء منتجات برمجية ذات مستوى عالمي.',1,'hired',0,'2026-08-12 08:16:57','2026-08-17 08:16:57','2026-08-17 08:16:57',NULL,NULL),(6,'a2f5901f-5bee-4c5c-bf59-1f248c2f37f4',2,'فاطمة عمر العلي','fatima.alali@example.com','fatima.alali@example.com','+971 50 876 5432','خبرة 3 سنوات في تصميم التطبيقات الرقمية ونماذج العمل التفاعلية واختبارات المستخدم.',1,'rejected',0,'2026-08-13 08:16:57','2026-08-17 08:16:57','2026-08-17 08:16:57',NULL,NULL);

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

CREATE TABLE `job_batches` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_jobs` bigint(20) NOT NULL,
  `pending_jobs` bigint(20) NOT NULL,
  `failed_jobs` bigint(20) NOT NULL,
  `failed_job_ids` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` longtext COLLATE utf8mb4_unicode_ci,
  `cancelled_at` bigint(20) DEFAULT NULL,
  `created_at` bigint(20) NOT NULL,
  `finished_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `job_batches`
--


--
-- Table structure for table `job_postings`
--

CREATE TABLE `job_postings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `public_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `job_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `department` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `location` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `employment_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `salary_min` decimal(18,4) DEFAULT NULL,
  `salary_max` decimal(18,4) DEFAULT NULL,
  `currency_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `opens_at` datetime DEFAULT NULL,
  `closes_at` datetime DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'draft',
  `lock_version` bigint(20) NOT NULL DEFAULT '0',
  `updated_by_user_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `deleted_by` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `job_postings_job_code_unique` (`job_code`),
  UNIQUE KEY `job_postings_public_id_unique` (`public_id`),
  UNIQUE KEY `job_postings_slug_unique` (`slug`),
  KEY `job_postings_deleted_at_index` (`deleted_at`),
  KEY `job_postings_status_opens_at_closes_at_index` (`status`,`opens_at`,`closes_at`),
  KEY `fk_87e1749b3795` (`updated_by_user_id`),
  KEY `fk_4ad5fff269be` (`currency_code`),
  CONSTRAINT `fk_4ad5fff269be` FOREIGN KEY (`currency_code`) REFERENCES `currencies` (`code`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_87e1749b3795` FOREIGN KEY (`updated_by_user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `job_postings`
--

INSERT INTO `job_postings` VALUES (1,'08bf029f-b211-4e8d-931e-42b65d2f38c0','DEV-001','senior-full-stack-developer','Senior Full-Stack Developer','الهندسة البرمجية','الرياض / عن بُعد','full-time','نبحث عن مطور برمجيات متقدم ذو خبرة عالية في أطر عمل الويب وقواعد البيانات وبناء واجهات المستخدم والأنظمة الموزعة.',15000.0000,25000.0000,'USD','2026-08-07 08:16:57',NULL,'open',0,NULL,'2026-08-17 08:16:57','2026-08-17 08:16:57',NULL,NULL),(2,'b298c13a-ced0-41ed-a26e-0aba15eb7ff6','DES-002','ui-ux-product-designer','UI/UX Product Designer','تصميم المنتجات وتجربة المستخدم','القاهرة / هجين','full-time','مطلوب مصمم منتجات رقمية مبدع لبناء تجارب مستخدم فريدة وتصميم نظم تصميم موحدة لتطبيقات المنصة.',12000.0000,20000.0000,'USD','2026-08-09 08:16:57',NULL,'open',0,NULL,'2026-08-17 08:16:57','2026-08-17 08:16:57',NULL,NULL),(3,'c2f81537-8721-4936-a865-bcdc7558fc22','MKT-003','digital-marketing-lead','Digital Marketing Lead','التسويق الرقمي والنمو','دبي / عن بُعد','contract','قيادة استراتيجيات النمو والتسويق الرقمي وإدارة الحملات الإعلانية للحلول التقنية.',10000.0000,18000.0000,'USD','2026-08-12 08:16:57',NULL,'open',0,NULL,'2026-08-17 08:16:57','2026-08-17 08:16:57',NULL,NULL);

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

CREATE TABLE `jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` bigint(20) NOT NULL,
  `reserved_at` bigint(20) DEFAULT NULL,
  `available_at` bigint(20) NOT NULL,
  `created_at` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jobs`
--

INSERT INTO `jobs` VALUES (1,'notifications','{\"uuid\":\"76201ed2-2d83-4178-a490-3eda7be5b0ef\",\"displayName\":\"App\\\\Modules\\\\Identity\\\\Infrastructure\\\\Notifications\\\\QueuedVerifyEmail\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"deleteWhenMissingModels\":false,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":5:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:39:\\\"App\\\\Modules\\\\Identity\\\\Domain\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:2;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:6:\\\"sqlite\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:67:\\\"App\\\\Modules\\\\Identity\\\\Infrastructure\\\\Notifications\\\\QueuedVerifyEmail\\\":5:{s:2:\\\"id\\\";s:36:\\\"fdd9281f-0302-4792-9622-2d0a96217b1b\\\";s:5:\\\"queue\\\";s:13:\\\"notifications\\\";s:11:\\\"afterCommit\\\";b:1;s:22:\\\"deliveryNotificationId\\\";s:36:\\\"bccb92e1-f9cf-4cf0-a007-f646be839f0f\\\";s:16:\\\"deliveryQueuedAt\\\";s:25:\\\"2026-08-15T07:01:31+00:00\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:4:\\\"mail\\\";}s:5:\\\"queue\\\";s:13:\\\"notifications\\\";s:11:\\\"afterCommit\\\";b:1;}\",\"batchId\":null},\"createdAt\":1786777291,\"delay\":null}',0,NULL,1786777291,1786777291),(2,'notifications','{\"uuid\":\"75bc113e-5fc6-465a-a5bf-b7c13b569ca5\",\"displayName\":\"App\\\\Modules\\\\Identity\\\\Infrastructure\\\\Notifications\\\\QueuedResetPassword\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"deleteWhenMissingModels\":false,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":5:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:39:\\\"App\\\\Modules\\\\Identity\\\\Domain\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:2;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:6:\\\"sqlite\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:69:\\\"App\\\\Modules\\\\Identity\\\\Infrastructure\\\\Notifications\\\\QueuedResetPassword\\\":6:{s:5:\\\"token\\\";s:64:\\\"36439a4b0d3e309e3ad70f2b9d05c4c1a4bfa762150c437ca0b4ff0d820028c0\\\";s:2:\\\"id\\\";s:36:\\\"dc22de7c-192b-48db-8a83-5b195ef82871\\\";s:5:\\\"queue\\\";s:13:\\\"notifications\\\";s:11:\\\"afterCommit\\\";b:1;s:22:\\\"deliveryNotificationId\\\";s:36:\\\"e0579d4c-e8b7-44a2-a432-e6f930dfbd35\\\";s:16:\\\"deliveryQueuedAt\\\";s:25:\\\"2026-08-15T07:01:32+00:00\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:4:\\\"mail\\\";}s:5:\\\"queue\\\";s:13:\\\"notifications\\\";s:11:\\\"afterCommit\\\";b:1;}\",\"batchId\":null},\"createdAt\":1786777292,\"delay\":null}',0,NULL,1786777292,1786777292),(3,'notifications','{\"uuid\":\"9f78baf4-cb99-48c8-9641-4067be0b0083\",\"displayName\":\"App\\\\Modules\\\\Identity\\\\Infrastructure\\\\Notifications\\\\QueuedVerifyEmail\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"deleteWhenMissingModels\":false,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":5:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:39:\\\"App\\\\Modules\\\\Identity\\\\Domain\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:2;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:6:\\\"sqlite\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:67:\\\"App\\\\Modules\\\\Identity\\\\Infrastructure\\\\Notifications\\\\QueuedVerifyEmail\\\":5:{s:2:\\\"id\\\";s:36:\\\"35072057-ca84-4900-b566-4e696208d115\\\";s:5:\\\"queue\\\";s:13:\\\"notifications\\\";s:11:\\\"afterCommit\\\";b:1;s:22:\\\"deliveryNotificationId\\\";s:36:\\\"c1c6fe6b-0ff1-4c46-a78a-38ab2d44d03b\\\";s:16:\\\"deliveryQueuedAt\\\";s:25:\\\"2026-08-15T07:59:41+00:00\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:4:\\\"mail\\\";}s:5:\\\"queue\\\";s:13:\\\"notifications\\\";s:11:\\\"afterCommit\\\";b:1;}\",\"batchId\":null},\"createdAt\":1786780781,\"delay\":null}',0,NULL,1786780781,1786780781);

--
-- Table structure for table `lead_status_history`
--

CREATE TABLE `lead_status_history` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `lead_id` bigint(20) unsigned NOT NULL,
  `from_status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `to_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `actor_user_id` bigint(20) unsigned DEFAULT NULL,
  `reason` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `occurred_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `lead_status_history_lead_id_occurred_at_index` (`lead_id`,`occurred_at`),
  KEY `fk_e0c269841db8` (`actor_user_id`),
  CONSTRAINT `fk_20cc800f726a` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`id`) ON DELETE NO ACTION,
  CONSTRAINT `fk_e0c269841db8` FOREIGN KEY (`actor_user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `lead_status_history`
--


--
-- Table structure for table `leads`
--

CREATE TABLE `leads` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `public_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `contact_id` bigint(20) unsigned NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `source` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `source_entity_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `source_entity_id` bigint(20) unsigned DEFAULT NULL,
  `owner_user_id` bigint(20) unsigned DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'new',
  `qualification_notes` longtext COLLATE utf8mb4_unicode_ci,
  `loss_reason` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `qualified_at` datetime DEFAULT NULL,
  `closed_at` datetime DEFAULT NULL,
  `lock_version` bigint(20) NOT NULL DEFAULT '0',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `deleted_by` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `leads_public_id_unique` (`public_id`),
  KEY `leads_source_source_entity_type_source_entity_id_index` (`source`,`source_entity_type`,`source_entity_id`),
  KEY `leads_status_owner_user_id_created_at_index` (`status`,`owner_user_id`,`created_at`),
  KEY `leads_deleted_at_index` (`deleted_at`),
  KEY `fk_5c9876fc4e3b` (`owner_user_id`),
  KEY `fk_076cd0c5d230` (`contact_id`),
  CONSTRAINT `fk_076cd0c5d230` FOREIGN KEY (`contact_id`) REFERENCES `contacts` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_5c9876fc4e3b` FOREIGN KEY (`owner_user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `leads`
--


--
-- Table structure for table `manual_archive_records`
--

CREATE TABLE `manual_archive_records` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `public_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `storage_disk` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `storage_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `original_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mime_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_size` bigint(20) DEFAULT NULL,
  `checksum_sha256` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by_user_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `manual_archive_records_public_id_unique` (`public_id`),
  UNIQUE KEY `manual_archive_records_storage_path_unique` (`storage_path`),
  KEY `manual_archive_records_created_at_created_by_user_id_index` (`created_at`,`created_by_user_id`),
  KEY `fk_66ad952cb728` (`created_by_user_id`),
  CONSTRAINT `fk_66ad952cb728` FOREIGN KEY (`created_by_user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `manual_archive_records`
--

INSERT INTO `manual_archive_records` VALUES (1,'46926f53-4237-450f-b24c-dcb7c283de0c','a',NULL,'local','manual-audit-archives/46926f53-4237-450f-b24c-dcb7c283de0c/payload','inserve_business_analysis_v3_rtl.pdf','application/pdf',474319,'9ec565f7cf12b848012371e68652b4ed42d0c8f77eeb0718d199834b7cf61fe4',1,'2026-08-15 13:02:34'),(2,'f3be13ec-0c44-4d1b-8269-2d0c078b4bb7','Audit Log #48: Media.uploaded - Media #ad150092','{\n    \"audit_log_id\": 48,\n    \"action\": \"media.uploaded\",\n    \"subject_type\": \"App\\\\Modules\\\\Media\\\\Domain\\\\Models\\\\Media\",\n    \"subject_id\": \"ad150092-a1da-4589-ae20-17cefca29382\",\n    \"result\": \"succeeded\",\n    \"actor\": \"admin@7tech.local\",\n    \"request_id\": \"37274758-498f-4e74-a259-3c8dde267f6c\",\n    \"ip_address\": \"127.0.0.1\",\n    \"before_values\": null,\n    \"after_values\": {\n        \"mime_type\": \"image\\/png\",\n        \"byte_size\": 114178,\n        \"visibility\": \"public\",\n        \"checksum\": \"2d6688d19fe08b144e940d6ceea6ba8e13dc38ebe368a5337103c32ef34e6a16\"\n    },\n    \"occurred_at\": \"2026-08-24T06:56:28+00:00\"\n}',NULL,NULL,NULL,NULL,NULL,NULL,1,'2026-08-24 08:07:04');

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

CREATE TABLE `media` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `public_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `disk` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `contents` longblob,
  `original_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mime_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `extension` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `byte_size` bigint(20) NOT NULL,
  `checksum` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `visibility` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `processing_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `alt_text` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `width` bigint(20) DEFAULT NULL,
  `height` bigint(20) DEFAULT NULL,
  `lock_version` bigint(20) NOT NULL DEFAULT '0',
  `uploaded_by_user_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `deleted_by` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `media_disk_path_unique` (`disk`,`path`),
  UNIQUE KEY `media_public_id_unique` (`public_id`),
  KEY `media_checksum_byte_size_index` (`checksum`,`byte_size`),
  KEY `media_visibility_processing_status_created_at_index` (`visibility`,`processing_status`,`created_at`),
  KEY `media_deleted_at_index` (`deleted_at`),
  KEY `fk_376de6cd1022` (`uploaded_by_user_id`),
  CONSTRAINT `fk_376de6cd1022` FOREIGN KEY (`uploaded_by_user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `media` VALUES (1,'7f9f5169-3a7c-4433-93f3-000d7f3082dd','local','resumes/sample_resume.pdf',_binary '%PDF-1.4\n1 0 obj<</Type/Catalog/Pages 2 0 R>>endobj\n2 0 obj<</Type/Pages/Count 1/Kids[3 0 R]>>endobj\n3 0 obj<</Type/Page/MediaBox[0 0 595 842]/Parent 2 0 R/Resources<<>>/Contents 4 0 R>>endobj\n4 0 obj<</Length 51>>stream\nBT /F1 14 Tf 72 720 Td (Candidate Resume / CV Preview) ET\nendstream\nendobj\nxref\n0 5\n0000000000 65535 f \n0000000009 00000 n \n0000000058 00000 n \n0000000115 00000 n \n0000000214 00000 n \ntrailer<</Size 5/Root 1 0 R>>\nstartxref\n315\n%%EOF','sample_resume.pdf','application/pdf','pdf',102400,'807ac90e2ae393e32b4562a81d158a190eb4b26dd021713b82b31b1b457f3d59','private','ready',NULL,NULL,NULL,0,NULL,'2026-08-17 08:16:57','2026-08-17 08:16:57',NULL,NULL),(2,'5e53f251-21f0-49cd-968e-1894029977d6','local','catalog/2026/08/67d09760-ac9f-4577-a55b-6e1b7995edad.png',_binary '[binary data, 116136 characters]','Untitled.png','image/png','png',114178,'2d6688d19fe08b144e940d6ceea6ba8e13dc38ebe368a5337103c32ef34e6a16','public','ready',NULL,1615,961,0,1,'2026-08-22 14:51:08','2026-08-22 14:51:08',NULL,NULL),(3,'15c1cb68-14a7-42be-9d34-25d650ea2ce1','local','catalog/2026/08/b9f824b1-1f47-412b-87e0-de5b4e002ac8.jpg',_binary '[binary data, 27894 characters]','download (8).jfif','image/jpeg','jpg',24529,'a52d0a2b896323f41b72ff54ff6a4df6c487313cfbffe47944481bcf59aa1af9','public','ready',NULL,663,1200,0,1,'2026-08-22 14:51:13','2026-08-22 14:51:13',NULL,NULL),(4,'ae38aab6-1334-4304-80f8-b1d8bf69127e','local','catalog/2026/08/50ab7fb0-cb24-48d9-b693-e4f34aac3046.png',_binary '[binary data, 76915 characters]','logo-7402513_640.png','image/png','png',76470,'e2e706a3f6ce3ecff574decaaab019f6269c369689f292e7c83bc9e218fafcd1','public','ready',NULL,640,640,0,1,'2026-08-22 15:01:25','2026-08-22 15:01:25',NULL,NULL),(5,'e0cdbadd-768e-4cd9-876e-5169f64999d1','local','catalog/2026/08/68f6248f-6eb8-4ea3-b06a-662686366329.png',_binary '[binary data, 116136 characters]','Untitled.png','image/png','png',114178,'2d6688d19fe08b144e940d6ceea6ba8e13dc38ebe368a5337103c32ef34e6a16','public','ready',NULL,1615,961,0,1,'2026-08-24 06:45:49','2026-08-24 06:45:49',NULL,NULL),