-- MySQL dump 10.13  Distrib 8.0.37, for Linux (x86_64)
--
-- Host: localhost    Database: topappkw_transactions
-- ------------------------------------------------------
-- Server version	8.0.37

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Current Database: `topappkw_transactions`
--


--
-- Table structure for table `ad_translations`
--

DROP TABLE IF EXISTS `ad_translations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ad_translations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `ad_id` bigint unsigned NOT NULL,
  `locale` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ad_translations_ad_id_locale_unique` (`ad_id`,`locale`),
  KEY `ad_translations_locale_index` (`locale`),
  CONSTRAINT `ad_translations_ad_id_foreign` FOREIGN KEY (`ad_id`) REFERENCES `ads` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ad_translations`
--

LOCK TABLES `ad_translations` WRITE;
/*!40000 ALTER TABLE `ad_translations` DISABLE KEYS */;
INSERT INTO `ad_translations` (`id`, `ad_id`, `locale`, `name`, `description`, `created_at`, `updated_at`) VALUES (9,5,'en','شركة الفخامة لتعقيب المعاملات','تخليص','2022-08-22 07:08:36','2022-08-22 07:08:36'),(10,5,'ar','شركة الفخامة لتعقيب المعاملات','تخليص','2022-08-22 07:08:36','2022-08-22 07:08:36'),(11,6,'en','اعلان جديد','sdfsdfsdfs','2022-08-23 07:47:56','2022-08-23 07:47:56'),(12,6,'ar','الرقم المدني','xcgdsgdfsgs','2022-08-23 07:47:56','2022-08-23 07:47:56'),(13,7,'en','erwterwt','erterwterwt','2022-08-23 07:49:02','2022-08-23 07:49:02'),(14,7,'ar','rewterwt','ewrterwtew','2022-08-23 07:49:02','2022-08-23 07:49:02'),(15,8,'en','erwtwre','terwterw','2022-08-23 07:49:30','2022-08-23 07:49:30'),(16,8,'ar','rewterwtwe','terwt','2022-08-23 07:49:30','2022-08-23 07:49:30'),(17,9,'en','ثفقغثفق','ثقفغغ','2022-08-23 07:52:58','2022-08-23 07:52:58'),(18,9,'ar','ثقفغثقفغ','فثقغثقغ','2022-08-23 07:52:58','2022-08-23 07:52:58'),(19,10,'en','انور شحاتة','انور شحاتة','2022-09-02 08:52:20','2022-09-02 08:52:20'),(20,10,'ar','انور شحاتة','انور شحاتة','2022-09-02 08:52:20','2022-09-02 08:52:20');
/*!40000 ALTER TABLE `ad_translations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ads`
--

DROP TABLE IF EXISTS `ads`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ads` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `image` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `phone` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `whatsapp` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ads`
--

LOCK TABLES `ads` WRITE;
/*!40000 ALTER TABLE `ads` DISABLE KEYS */;
INSERT INTO `ads` (`id`, `image`, `phone`, `whatsapp`, `created_at`, `updated_at`, `status`) VALUES (5,'a:1:{i:0;s:35:\"img/testmonials/16611593163879.jpeg\";}','55838367','55838367','2022-08-22 07:08:36','2022-08-23 07:51:11',1),(6,'a:1:{i:0;s:34:\"img/testmonials/16612480767173.jpg\";}','67782374','67782374','2022-08-23 07:47:56','2022-08-23 07:51:49',1),(7,'a:1:{i:0;s:34:\"img/testmonials/16612481426567.jpg\";}','55678987','55678987','2022-08-23 07:49:02','2022-08-23 07:51:50',1),(8,'a:1:{i:0;s:34:\"img/testmonials/16612481707363.jpg\";}','ewrtewr','erwterw','2022-08-23 07:49:30','2022-08-23 07:51:51',1),(9,'a:1:{i:0;s:34:\"img/testmonials/16612483784385.png\";}','صصبقثصق','صثقصث','2022-08-23 07:52:58','2022-09-02 08:51:12',1),(10,'a:1:{i:0;s:35:\"img/testmonials/16621159404286.jpeg\";}','67782374','67782374','2022-09-02 08:52:20','2022-09-02 08:52:35',1);
/*!40000 ALTER TABLE `ads` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `contact_us`
--

DROP TABLE IF EXISTS `contact_us`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `contact_us` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `image` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `contact_us`
--

LOCK TABLES `contact_us` WRITE;
/*!40000 ALTER TABLE `contact_us` DISABLE KEYS */;
INSERT INTO `contact_us` (`id`, `name`, `phone`, `email`, `message`, `image`, `created_at`, `updated_at`) VALUES (1,'AHMED ELSAYED FARAG','01061756297','ahmedhamada2555@gmail.com','aaaa',NULL,'2022-08-22 04:45:18','2022-08-22 04:45:18'),(2,'انور شحاتة','67782374','anwershehata6@gmail.com','اخبارك ياعادل',NULL,'2022-09-02 08:57:26','2022-09-02 08:57:26'),(3,'Hesham Mahmoud Abdulsalam Rashed','90957191','rashedmpw@gmail.com','السلام عليكم ورحمة الله \r\nهل تقومون بمعاملات توثيق الشهادات من القنصليات والخارجية الكويتية',NULL,'2025-10-21 10:51:46','2025-10-21 10:51:46');
/*!40000 ALTER TABLE `contact_us` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `explaination_translations`
--

DROP TABLE IF EXISTS `explaination_translations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `explaination_translations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `explaination_id` bigint unsigned NOT NULL,
  `locale` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `file` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `explaination_translations_explaination_id_locale_unique` (`explaination_id`,`locale`),
  KEY `explaination_translations_locale_index` (`locale`),
  CONSTRAINT `explaination_translations_explaination_id_foreign` FOREIGN KEY (`explaination_id`) REFERENCES `explainations` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `explaination_translations`
--

LOCK TABLES `explaination_translations` WRITE;
/*!40000 ALTER TABLE `explaination_translations` DISABLE KEYS */;
INSERT INTO `explaination_translations` (`id`, `explaination_id`, `locale`, `name`, `file`, `created_at`, `updated_at`) VALUES (5,3,'en','صبسيب','img/explanations/file/16612504928965.pdf','2022-08-23 08:28:12','2022-08-23 08:28:12'),(6,3,'ar','شسيبيشسب','img/explanations/file/16612504923354.pdf','2022-08-23 08:28:12','2022-08-23 08:28:12');
/*!40000 ALTER TABLE `explaination_translations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `explainations`
--

DROP TABLE IF EXISTS `explainations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `explainations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `explainations`
--

LOCK TABLES `explainations` WRITE;
/*!40000 ALTER TABLE `explainations` DISABLE KEYS */;
INSERT INTO `explainations` (`id`, `image`, `created_at`, `updated_at`) VALUES (3,'img/explanations/img/16612504928040.jpg','2022-08-23 08:28:12','2022-08-23 08:28:12');
/*!40000 ALTER TABLE `explainations` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `failed_jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `failed_jobs` WRITE;
/*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `migrations` WRITE;
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_resets_table',1),(3,'2016_06_01_000001_create_oauth_auth_codes_table',1),(4,'2016_06_01_000002_create_oauth_access_tokens_table',1),(5,'2016_06_01_000003_create_oauth_refresh_tokens_table',1),(6,'2016_06_01_000004_create_oauth_clients_table',1),(7,'2016_06_01_000005_create_oauth_personal_access_clients_table',1),(8,'2019_08_19_000000_create_failed_jobs_table',1),(9,'2021_04_24_153514_create_permission_tables',1),(10,'2021_06_05_001447_create_settings_table',1),(11,'2021_06_05_001901_create_setting_translations_table',1),(12,'2022_07_30_133737_create_contact_us_table',1),(13,'2022_07_30_133915_create_ads_table',1),(14,'2022_07_30_161113_create_services_table',1),(15,'2022_07_30_161122_create_service_translations_table',1),(16,'2022_07_30_161417_create_transactions_table',1),(17,'2022_07_30_161425_create_transaction_translations_table',1),(18,'2022_07_30_163955_create_explainations_table',1),(19,'2022_07_30_164002_create_explaination_translations_table',1),(20,'2022_07_30_164220_create_testmonials_table',1),(21,'2022_07_30_164327_create_transaction_requests_table',1),(22,'2022_07_30_175412_create_ad_translations_table',1),(23,'2022_07_31_082057_create_required_data_table',1),(24,'2022_07_31_082110_create_required_data_translations_table',1),(25,'2022_08_05_185359_create_sliders_table',1),(26,'2022_08_06_122357_create_request_statuses_table',1),(27,'2022_08_06_122408_create_request_status_translations_table',1),(28,'2022_08_06_122541_add_price_to_transaction_requests_table',1),(29,'2022_08_21_095422_add_visible_column_to_services_table',2),(30,'2022_08_21_100139_add_color_to_request_statuses_table',2),(31,'2022_08_21_105001_add_visible_column_to_transactions_table',2),(32,'2022_08_21_203711_update_image_column_in_ads_table',2),(33,'2022_08_21_204114_add_status_column_in_ads_table',2),(34,'2022_08_22_061430_update_default_status_to_transaction_requests_table',2),(35,'2022_08_27_112638_add_new_columns_to_transaction_requests_table',3);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `model_has_permissions`
--

DROP TABLE IF EXISTS `model_has_permissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `model_has_permissions` (
  `permission_id` bigint unsigned NOT NULL,
  `model_type` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `model_has_permissions`
--

LOCK TABLES `model_has_permissions` WRITE;
/*!40000 ALTER TABLE `model_has_permissions` DISABLE KEYS */;
/*!40000 ALTER TABLE `model_has_permissions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `model_has_roles`
--

DROP TABLE IF EXISTS `model_has_roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `model_has_roles` (
  `role_id` bigint unsigned NOT NULL,
  `model_type` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `model_has_roles`
--

LOCK TABLES `model_has_roles` WRITE;
/*!40000 ALTER TABLE `model_has_roles` DISABLE KEYS */;
INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES (1,'App\\User',1);
/*!40000 ALTER TABLE `model_has_roles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `oauth_access_tokens`
--

DROP TABLE IF EXISTS `oauth_access_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `oauth_access_tokens` (
  `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `client_id` bigint unsigned NOT NULL,
  `name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `scopes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_access_tokens_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `oauth_access_tokens`
--

LOCK TABLES `oauth_access_tokens` WRITE;
/*!40000 ALTER TABLE `oauth_access_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `oauth_access_tokens` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `oauth_auth_codes`
--

DROP TABLE IF EXISTS `oauth_auth_codes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `oauth_auth_codes` (
  `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `client_id` bigint unsigned NOT NULL,
  `scopes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_auth_codes_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `oauth_auth_codes`
--

LOCK TABLES `oauth_auth_codes` WRITE;
/*!40000 ALTER TABLE `oauth_auth_codes` DISABLE KEYS */;
/*!40000 ALTER TABLE `oauth_auth_codes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `oauth_clients`
--

DROP TABLE IF EXISTS `oauth_clients`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `oauth_clients` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned DEFAULT NULL,
  `name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `secret` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `provider` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `redirect` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `personal_access_client` tinyint(1) NOT NULL,
  `password_client` tinyint(1) NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_clients_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `oauth_clients`
--

LOCK TABLES `oauth_clients` WRITE;
/*!40000 ALTER TABLE `oauth_clients` DISABLE KEYS */;
/*!40000 ALTER TABLE `oauth_clients` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `oauth_personal_access_clients`
--

DROP TABLE IF EXISTS `oauth_personal_access_clients`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `oauth_personal_access_clients` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `client_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `oauth_personal_access_clients`
--

LOCK TABLES `oauth_personal_access_clients` WRITE;
/*!40000 ALTER TABLE `oauth_personal_access_clients` DISABLE KEYS */;
/*!40000 ALTER TABLE `oauth_personal_access_clients` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `oauth_refresh_tokens`
--

DROP TABLE IF EXISTS `oauth_refresh_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `oauth_refresh_tokens` (
  `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `access_token_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `oauth_refresh_tokens`
--

LOCK TABLES `oauth_refresh_tokens` WRITE;
/*!40000 ALTER TABLE `oauth_refresh_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `oauth_refresh_tokens` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `password_resets`
--

DROP TABLE IF EXISTS `password_resets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `password_resets` (
  `email` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `password_resets`
--

LOCK TABLES `password_resets` WRITE;
/*!40000 ALTER TABLE `password_resets` DISABLE KEYS */;
INSERT INTO `password_resets` (`email`, `token`, `created_at`) VALUES ('ahmedhamada2555@gmil.com','$2y$10$XXGZyT4JDZdrkGIo6FVKsOrtV9nCGjzIXfxBR1jpOrZKl3BAs4cqa','2022-08-07 12:58:58');
/*!40000 ALTER TABLE `password_resets` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `permissions`
--

DROP TABLE IF EXISTS `permissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `permissions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `permissions`
--

LOCK TABLES `permissions` WRITE;
/*!40000 ALTER TABLE `permissions` DISABLE KEYS */;
/*!40000 ALTER TABLE `permissions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `request_status_translations`
--

DROP TABLE IF EXISTS `request_status_translations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `request_status_translations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `request_status_id` bigint unsigned NOT NULL,
  `locale` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `request_status_translations_request_status_id_locale_unique` (`request_status_id`,`locale`),
  KEY `request_status_translations_locale_index` (`locale`),
  CONSTRAINT `request_status_translations_request_status_id_foreign` FOREIGN KEY (`request_status_id`) REFERENCES `request_statuses` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `request_status_translations`
--

LOCK TABLES `request_status_translations` WRITE;
/*!40000 ALTER TABLE `request_status_translations` DISABLE KEYS */;
INSERT INTO `request_status_translations` (`id`, `request_status_id`, `locale`, `name`, `created_at`, `updated_at`) VALUES (1,1,'en','pending','2022-08-07 06:46:59','2022-08-07 06:46:59'),(2,1,'ar','قيد الانتظار','2022-08-07 06:46:59','2022-08-07 06:46:59'),(3,2,'en','المعاملة مقبلوة','2022-08-08 11:57:46','2022-08-08 11:57:46'),(4,2,'ar','المعاملة مقبلوة','2022-08-08 11:57:46','2022-08-08 11:57:46'),(5,3,'en','المعاملة مرفوضة','2022-08-08 11:58:02','2022-08-08 11:58:02'),(6,3,'ar','المعاملة مرفوضة','2022-08-08 11:58:02','2022-08-08 11:58:02'),(7,4,'en','جاري تنفيذ المعاملة','2022-08-08 11:58:22','2022-08-08 11:58:22'),(8,4,'ar','جاري تنفيذ المعاملة','2022-08-08 11:58:22','2022-08-08 11:58:22'),(9,5,'en','مرفوض','2022-09-02 08:48:12','2022-09-02 08:48:12'),(10,5,'ar','مرفوض','2022-09-02 08:48:12','2022-09-02 08:48:12');
/*!40000 ALTER TABLE `request_status_translations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `request_statuses`
--

DROP TABLE IF EXISTS `request_statuses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `request_statuses` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `color` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '#3eb453',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `request_statuses`
--

LOCK TABLES `request_statuses` WRITE;
/*!40000 ALTER TABLE `request_statuses` DISABLE KEYS */;
INSERT INTO `request_statuses` (`id`, `created_at`, `updated_at`, `color`) VALUES (1,'2022-08-07 06:46:59','2022-08-23 08:03:39','#ffeb0f'),(2,'2022-08-08 11:57:46','2022-08-08 11:57:46','#3eb453'),(3,'2022-08-08 11:58:02','2022-08-23 08:04:12','#b33d60'),(4,'2022-08-08 11:58:22','2022-08-08 11:58:22','#3eb453'),(5,'2022-09-02 08:48:12','2022-09-02 08:49:09','#0032fa');
/*!40000 ALTER TABLE `request_statuses` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `required_data`
--

DROP TABLE IF EXISTS `required_data`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `required_data` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `required_data`
--

LOCK TABLES `required_data` WRITE;
/*!40000 ALTER TABLE `required_data` DISABLE KEYS */;
INSERT INTO `required_data` (`id`, `type`, `created_at`, `updated_at`) VALUES (5,'file','2022-08-10 06:30:54','2022-08-10 06:30:54'),(6,'file','2022-08-10 06:31:20','2022-08-10 06:31:20'),(7,'text','2022-08-10 06:31:51','2022-08-10 06:31:51'),(8,'file','2022-08-10 06:32:34','2022-08-10 06:32:34'),(9,'file','2022-08-10 06:32:54','2022-08-10 06:32:54'),(10,'file','2022-08-10 06:35:38','2022-08-10 06:35:38'),(11,'file','2022-08-10 06:36:01','2022-08-10 06:36:01'),(12,'file','2022-08-10 06:36:32','2022-08-10 06:36:32'),(13,'file','2022-08-10 06:36:58','2022-08-10 06:36:58'),(14,'file','2022-08-10 06:37:18','2022-08-10 06:37:18'),(15,'text','2022-08-10 06:37:38','2022-08-10 06:37:38'),(16,'file','2022-08-10 06:37:56','2022-08-10 06:37:56'),(17,'text','2022-09-03 15:12:43','2022-09-03 15:12:43');
/*!40000 ALTER TABLE `required_data` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `required_data_translations`
--

DROP TABLE IF EXISTS `required_data_translations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `required_data_translations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `required_data_id` bigint unsigned NOT NULL,
  `locale` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `required_data_translations_required_data_id_locale_unique` (`required_data_id`,`locale`),
  KEY `required_data_translations_locale_index` (`locale`),
  CONSTRAINT `required_data_translations_required_data_id_foreign` FOREIGN KEY (`required_data_id`) REFERENCES `required_data` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `required_data_translations`
--

LOCK TABLES `required_data_translations` WRITE;
/*!40000 ALTER TABLE `required_data_translations` DISABLE KEYS */;
INSERT INTO `required_data_translations` (`id`, `required_data_id`, `locale`, `name`, `created_at`, `updated_at`) VALUES (9,5,'en','Civil photocopy of the concerned person','2022-08-10 06:30:54','2022-08-10 06:30:54'),(10,5,'ar','صوره المدنية الصاحب العلاقة','2022-08-10 06:30:54','2022-08-10 06:30:54'),(11,6,'en','Copy of the lease contract','2022-08-10 06:31:20','2022-08-10 06:31:20'),(12,6,'ar','صورة عقد الايجار','2022-08-10 06:31:20','2022-08-10 06:31:20'),(13,7,'en','Determine the desired activity - and specify 5 brand names of the company','2022-08-10 06:31:51','2022-08-10 06:31:51'),(14,7,'ar','تحديد النشاط المطلوب - وتحديد 5 أسماء تجارية للشركة','2022-08-10 06:31:51','2022-08-10 06:31:51'),(15,8,'en','A copy of the rent receipt','2022-08-10 06:32:34','2022-08-10 06:32:34'),(16,8,'ar','صوره من واصل الايجار','2022-08-10 06:32:34','2022-08-10 06:32:34'),(17,9,'en','The automatic number of the shop or office on which the licenses are to be granted','2022-08-10 06:32:54','2022-08-10 06:32:54'),(18,9,'ar','الرقم الالي للمحل او مكتب المراد التراخيص علية','2022-08-10 06:32:54','2022-08-10 06:32:54'),(19,10,'en','Civil photograph of the license holder','2022-08-10 06:35:38','2022-08-10 06:35:38'),(20,10,'ar','صورة مدنيه صاحب التراخيص','2022-08-10 06:35:38','2022-08-10 06:35:38'),(21,11,'en','A copy of the founding contract (if any)','2022-08-10 06:36:01','2022-08-10 06:36:01'),(22,11,'ar','صوره عقد التاسيس ( إن وجد)','2022-08-10 06:36:01','2022-08-10 06:36:01'),(23,12,'en','Signature approval copy','2022-08-10 06:36:32','2022-08-10 06:36:32'),(24,12,'ar','صوره اعتماد التوقيع','2022-08-10 06:36:32','2022-08-10 06:36:32'),(25,13,'en','Copy of social insurance (for the company + the manager is Kuwaiti)','2022-08-10 06:36:58','2022-08-10 06:36:58'),(26,13,'ar','صورة التامينات الاجتماعية ( للشركة + المدير كويتي )','2022-08-10 06:36:58','2022-08-10 06:36:58'),(27,14,'en','Copy of the request transfer address','2022-08-10 06:37:18','2022-08-10 06:37:18'),(28,14,'ar','صوره الطلب نقل العنوان','2022-08-10 06:37:18','2022-08-10 06:37:18'),(29,15,'en','The automatic number to be transferred to the company or institution on it','2022-08-10 06:37:38','2022-08-10 06:37:38'),(30,15,'ar','الرقم الالي المراد النقل الشركة او المؤسسة علية','2022-08-10 06:37:38','2022-08-10 06:37:38'),(31,16,'en','Copy of Commercial Licenses','2022-08-10 06:37:56','2022-08-10 06:37:56'),(32,16,'ar','صوره التراخيص التجاري','2022-08-10 06:37:56','2022-08-10 06:37:56'),(33,17,'en','الاسم التجاري','2022-09-03 15:12:43','2022-09-03 15:12:43'),(34,17,'ar','الاسم التجار','2022-09-03 15:12:43','2022-09-03 15:12:43');
/*!40000 ALTER TABLE `required_data_translations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `role_has_permissions`
--

DROP TABLE IF EXISTS `role_has_permissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `role_has_permissions` (
  `permission_id` bigint unsigned NOT NULL,
  `role_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`),
  CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `role_has_permissions`
--

LOCK TABLES `role_has_permissions` WRITE;
/*!40000 ALTER TABLE `role_has_permissions` DISABLE KEYS */;
/*!40000 ALTER TABLE `role_has_permissions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `roles`
--

DROP TABLE IF EXISTS `roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `roles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `roles`
--

LOCK TABLES `roles` WRITE;
/*!40000 ALTER TABLE `roles` DISABLE KEYS */;
INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES (1,'super_admin','web','2022-08-07 06:46:59','2022-08-07 06:46:59'),(2,'admin','web','2022-08-07 06:46:59','2022-08-07 06:46:59');
/*!40000 ALTER TABLE `roles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `service_translations`
--

DROP TABLE IF EXISTS `service_translations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `service_translations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `service_id` bigint unsigned NOT NULL,
  `locale` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `service_translations_service_id_locale_unique` (`service_id`,`locale`),
  KEY `service_translations_locale_index` (`locale`),
  CONSTRAINT `service_translations_service_id_foreign` FOREIGN KEY (`service_id`) REFERENCES `services` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `service_translations`
--

LOCK TABLES `service_translations` WRITE;
/*!40000 ALTER TABLE `service_translations` DISABLE KEYS */;
INSERT INTO `service_translations` (`id`, `service_id`, `locale`, `name`, `created_at`, `updated_at`) VALUES (19,10,'en','Ministry of Commerce and Industry','2022-08-10 06:12:22','2022-08-10 06:12:22'),(20,10,'ar','وزارة التجارة والصناعة','2022-08-10 06:12:22','2022-08-10 06:12:22'),(21,11,'en','Ministry of Interior','2022-08-10 06:12:59','2022-08-10 06:12:59'),(22,11,'ar','وزارة الداخلية','2022-08-10 06:12:59','2022-08-10 06:12:59'),(23,12,'en','Kuwait Municipality','2022-08-10 06:13:29','2022-08-10 06:13:29'),(24,12,'ar','بلدية الكويت','2022-08-10 06:13:29','2022-08-10 06:13:29'),(25,13,'en','Saudi Food and Nutrition Authority','2022-08-10 06:15:02','2022-08-10 06:15:02'),(26,13,'ar','الهيئة العامة للغذاء والتغذية','2022-08-10 06:15:02','2022-08-10 06:15:02'),(27,14,'en','Ministry of Health','2022-08-10 06:15:36','2022-08-10 06:15:36'),(28,14,'ar','وزارة الصحة','2022-08-10 06:15:36','2022-08-10 06:15:36'),(29,15,'en','General Fire Force','2022-08-10 06:16:31','2022-08-10 06:16:31'),(30,15,'ar','قـــوة الإطفـــاء العـــام','2022-08-10 06:16:31','2022-08-10 06:16:31'),(31,16,'en','Ministry of Information','2022-08-10 06:17:00','2022-08-10 06:17:00'),(32,16,'ar','وزارة الإعلام','2022-08-10 06:17:00','2022-08-10 06:17:00'),(33,17,'en','General Directorate of Traffic','2022-08-10 06:17:31','2022-08-10 06:17:31'),(34,17,'ar','الإدارة العامة للمرور','2022-08-10 06:17:31','2022-08-10 06:17:31'),(35,18,'en','Trademark Services','2022-08-10 06:18:06','2022-08-10 06:18:06'),(36,18,'ar','خدمات العلامات التجارية','2022-08-10 06:18:06','2022-08-10 06:18:06'),(37,19,'en','Ministry of Justice','2022-08-10 06:18:37','2022-08-10 06:18:37'),(38,19,'ar','وزارة العدل','2022-08-10 06:18:37','2022-08-10 06:18:37'),(39,20,'en','General Directorate of Customs','2022-08-10 06:19:04','2022-08-10 06:19:04'),(40,20,'ar','الإدارة العامة للجمارك','2022-08-10 06:19:04','2022-08-10 06:19:04'),(41,21,'en','Public Authority for Civil Information','2022-08-10 06:19:46','2022-08-10 06:19:46'),(42,21,'ar','الهيئة العامة للمعلومات المدنية','2022-08-10 06:19:46','2022-08-10 06:19:46'),(43,22,'en','Public Authority for Manpower','2022-08-10 06:20:13','2022-08-10 06:20:13'),(44,22,'ar','الهيئة العامة للقوى العاملة','2022-08-10 06:20:13','2022-08-10 06:20:13'),(45,23,'en','Kuwait Chamber of Commerce and Industry Services','2022-08-10 06:21:12','2022-08-10 06:21:12'),(46,23,'ar','خدمات غرفة تجارة وصناعة الكويت','2022-08-10 06:21:12','2022-08-10 06:21:12'),(47,24,'en','Ministry of Education','2022-08-10 06:21:53','2022-08-10 06:21:53'),(48,24,'ar','وزارة التربية','2022-08-10 06:21:53','2022-08-10 06:21:53'),(49,25,'en','Services of the General Organization for Social Insurance','2022-08-10 06:22:29','2022-08-10 06:22:29'),(50,25,'ar','خدمات المؤسسة العامة للتأمينات الإجتماعية','2022-08-10 06:22:29','2022-08-10 06:22:29'),(51,26,'en','Ministry of Electricity and Water','2022-08-10 06:23:05','2022-08-10 06:23:05'),(52,26,'ar','وزارة الكهرباء والماء','2022-08-10 06:23:05','2022-08-10 06:23:05'),(53,27,'en','Services of the General Authority for Agriculture and Fisheries','2022-08-10 06:23:32','2022-08-10 06:23:32'),(54,27,'ar','خدمات الهيئة العامة للزراعة والثروة السمكية','2022-08-10 06:23:32','2022-08-10 06:23:32'),(55,28,'en','Mobile Car Establishment and Extraction Services','2022-08-10 06:24:10','2022-08-10 06:24:10'),(56,28,'ar','خدمات تاسيس واستخراج السيارات المتنقلة','2022-08-10 06:24:10','2022-08-10 06:24:10'),(57,29,'en','Electronic messaging services for government agencies and agencies','2022-08-10 06:24:35','2022-08-10 06:24:35'),(58,29,'ar','خدمات التراسل الالكتروني للهيئات والجهات الحكومية','2022-08-10 06:24:35','2022-08-10 06:24:35'),(59,30,'en','Transaction services for annual and monthly contracts','2022-08-10 06:25:11','2022-08-10 06:25:11'),(60,30,'ar','خدمات المعاملات الخاصة بالعقود السنويه والشهرية','2022-08-10 06:25:11','2022-08-10 06:25:11'),(61,31,'en','Ministry of Finance','2022-08-10 06:25:41','2022-08-10 06:25:41'),(62,31,'ar','وزارة المالية','2022-08-10 06:25:41','2022-08-10 06:25:41'),(63,32,'en','Services of the Public Authority for the Affairs of Persons with Disabilities','2022-08-10 06:26:13','2022-08-10 06:26:13'),(64,32,'ar','خدمات الهيئة العامة لشئون ذوي الإعاقة','2022-08-10 06:26:13','2022-08-10 06:26:13'),(65,33,'en','Services of the Central Agency for the Treatment of Illegal Residents','2022-08-10 06:26:41','2022-08-10 06:26:41'),(66,33,'ar','خدمات الجهاز المركزي لمعالجة اوضاع المقيمين بصورة غير قانونية','2022-08-10 06:26:41','2022-08-10 06:26:41'),(67,34,'en','Services of the Public Authority for Industry','2022-08-10 06:27:05','2022-08-10 06:27:05'),(68,34,'ar','خدمات الهيئة العامة للصناعة','2022-08-10 06:27:05','2022-08-10 06:27:05'),(69,35,'en','Kuwaiti Ministry of Foreign Affairs','2022-08-10 06:27:38','2022-08-10 06:27:38'),(70,35,'ar','وزارة الخارجية الكويتية','2022-08-10 06:27:38','2022-08-10 06:27:38');
/*!40000 ALTER TABLE `service_translations` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `services`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `services` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `visible` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `services` WRITE;
/*!40000 ALTER TABLE `services` DISABLE KEYS */;
INSERT INTO `services` (`id`, `image`, `created_at`, `updated_at`, `visible`) VALUES (10,'img/services/16601191426844.jpg','2022-08-10 06:12:22','2022-09-02 08:54:19',1),(11,'img/services/16601191794855.jfif','2022-08-10 06:12:59','2022-08-10 06:12:59',1),(12,'img/services/16601192091798.jfif','2022-08-10 06:13:29','2022-08-10 06:13:29',1),(13,'img/services/16601193024967.jpg','2022-08-10 06:15:02','2022-08-10 06:15:02',1),(14,'img/services/16601193361399.jfif','2022-08-10 06:15:36','2022-08-10 06:15:36',1),(15,'img/services/16601193912802.jfif','2022-08-10 06:16:31','2022-08-10 06:16:31',1),(16,'img/services/16601194203847.jpg','2022-08-10 06:17:00','2022-08-10 06:17:00',1),(17,'img/services/16601194516858.png','2022-08-10 06:17:31','2022-08-10 06:17:31',1),(18,'img/services/16601194869091.jpg','2022-08-10 06:18:06','2022-08-10 06:18:06',1),(19,'img/services/16601195177654.jpeg','2022-08-10 06:18:37','2022-08-10 06:18:37',1),(20,'img/services/16601195444667.png','2022-08-10 06:19:04','2022-08-10 06:19:04',1),(21,'img/services/16601195865879.jfif','2022-08-10 06:19:46','2022-08-10 06:19:46',1),(22,'img/services/16601196139129.jpg','2022-08-10 06:20:13','2022-08-10 06:20:13',1),(23,'img/services/16601196722465.jpg','2022-08-10 06:21:12','2022-08-10 06:21:12',1),(24,'img/services/16601197136547.jpg','2022-08-10 06:21:53','2022-08-10 06:21:53',1),(25,'img/services/16601197493003.png','2022-08-10 06:22:29','2022-08-10 06:22:29',1),(26,'img/services/16601197856851.jpg','2022-08-10 06:23:05','2022-08-10 06:23:05',1),(27,'img/services/16601198121009.jpeg','2022-08-10 06:23:32','2022-08-10 06:23:32',1),(28,'img/services/16601198503207.png','2022-08-10 06:24:10','2022-08-10 06:24:10',1),(29,'img/services/16601198755853.png','2022-08-10 06:24:35','2022-08-10 06:24:35',1),(30,'img/services/16601199117709.jpeg','2022-08-10 06:25:11','2022-08-10 06:25:11',1),(31,'img/services/16601199413469.jpg','2022-08-10 06:25:41','2022-08-10 06:25:41',1),(32,'img/services/16601199739824.jpg','2022-08-10 06:26:13','2022-08-10 06:26:13',1),(33,'img/services/16601200015009.jpg','2022-08-10 06:26:41','2022-08-10 06:26:41',1),(34,'img/services/16601200259006.jpeg','2022-08-10 06:27:05','2022-08-10 06:27:05',1),(35,'img/services/16601200587358.png','2022-08-10 06:27:38','2022-08-10 06:27:38',1);
/*!40000 ALTER TABLE `services` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `setting_translations`
--

DROP TABLE IF EXISTS `setting_translations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `setting_translations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `setting_id` bigint unsigned NOT NULL,
  `locale` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `setting_translations_setting_id_locale_unique` (`setting_id`,`locale`),
  KEY `setting_translations_locale_index` (`locale`),
  CONSTRAINT `setting_translations_setting_id_foreign` FOREIGN KEY (`setting_id`) REFERENCES `settings` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `setting_translations`
--

LOCK TABLES `setting_translations` WRITE;
/*!40000 ALTER TABLE `setting_translations` DISABLE KEYS */;
INSERT INTO `setting_translations` (`id`, `setting_id`, `locale`, `value`, `created_at`, `updated_at`) VALUES (1,1,'en','alfahma','2022-08-07 06:46:58','2022-08-08 15:54:49'),(2,1,'ar','الفخامة لتخليص المعاملات','2022-08-07 06:46:58','2022-08-08 15:54:49'),(3,2,'en','test address','2022-08-07 06:46:58','2022-08-07 06:46:58'),(4,2,'ar','عنوان تجريبى','2022-08-07 06:46:58','2022-08-07 06:46:58'),(5,3,'en','000000','2022-08-07 06:46:58','2023-09-18 20:23:25'),(6,3,'ar','000000','2022-08-07 06:46:58','2023-09-18 20:23:25'),(7,4,'en','000000','2022-08-07 06:46:58','2023-09-18 20:23:25'),(8,4,'ar','000000','2022-08-07 06:46:58','2023-09-18 20:23:25'),(9,5,'en','info@ajrnii.com','2022-08-07 06:46:58','2022-08-07 06:46:58'),(10,5,'ar','info@ajrnii.com','2022-08-07 06:46:58','2022-08-07 06:46:58'),(11,6,'en','instagram.com','2022-08-07 06:46:58','2022-08-07 06:46:58'),(12,6,'ar','instagram.com','2022-08-07 06:46:58','2022-08-07 06:46:58'),(13,7,'en','https://facebook.com/','2022-08-07 06:46:58','2022-08-07 06:46:58'),(14,7,'ar','https://facebook.com/','2022-08-07 06:46:58','2022-08-07 06:46:58'),(15,8,'en','https://twitter.com','2022-08-07 06:46:58','2022-08-07 06:46:58'),(16,8,'ar','https://twitter.com','2022-08-07 06:46:58','2022-08-07 06:46:58'),(17,9,'en','https://www.youtube.com','2022-08-07 06:46:58','2022-08-07 06:46:58'),(18,9,'ar','https://www.youtube.com','2022-08-07 06:46:58','2022-08-07 06:46:58'),(19,10,'en','img/settings/16625639532509.png','2022-08-07 06:46:58','2022-09-07 13:19:13'),(20,10,'ar','img/settings/16625639537304.jpeg','2022-08-07 06:46:59','2022-09-07 13:19:13'),(21,11,'en','img/settings/16625639535643.png','2022-08-07 06:46:59','2022-09-07 13:19:13'),(22,11,'ar','img/settings/16625639538389.jpeg','2022-08-07 06:46:59','2022-09-07 13:19:13'),(23,12,'en','<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<div class=\"m-2\">\r\n<h3 class=\"htitle\">First: - The Purpose Of The Application And The Site</h3>\r\n<p>It is an application that facilitates work in the field of transaction tracking by our company specialized in the field of tracking and clearing transactions under a trade name (Company Auditors To Track Transactions) and its goal and purpose is to reduce the effort and reviews in government departments to customers and all requests submitted by customers are received in each service dedicated to them and show us In the control screen, the completion of the required transaction by our company will resume.</p>\r\n<p>It also serves individuals in the rest of the ministries and companies. Here is the detailed explanation of the site and the application.</p>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h3 class=\"htitle\">Second: - A detailed Explanation Of The Application , Site And Services</h3>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>Ministry of Commerce and Industry</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Incorporation companies</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Address transfer</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Opening a branch of the company</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Partner entry and exit</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Submit budgets</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Individual licenses</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Individual licenses assignment</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Changing the companies\' trade name</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- License revocation</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Termination of the Articles of Association</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Amending the management clause and allocating shares</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Renewal of commercial licenses</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Issuing licenses after incorporation</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Converting the institution to a company</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Corporate extract</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Request licenses for shows and discounts</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Add activity</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Let\'s take an activity.</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Change of activity</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Increasing and reducing the company\'s capital</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Issuing licenses for a gulf person</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Visa registration and amendments for individuals and companies</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Request to register a commercial agency</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Issuing a certificate to those who care about it</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Extract import licenses for companies and individuals</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Renewal of import licenses for individual companies</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Extracting temporary import licenses for individuals</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Reservation of an appointment for shopping in the cooperative societies (during the ban)</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>Ministry Of Interior</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Open User Passports - for companies and institutions</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Open User Name for individuals</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Payment of fines for companies and individuals</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Renewal of residency permits for Articles 20 and 22</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Renewal of an electronic passport (Kuwaiti individual)</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>Kuwait Municipality</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Advertising licenses renewal</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Issuing advertisement licenses</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Issuing packaging licenses</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Renewal of packaging licenses</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Registration of companies and contractors</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Reserve your spring camp sites</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>&rlm;Public Authority for Food and Nutrition&lrm;</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Issuance of a food license</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Renewal of food license</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Issuing health licenses (for mobile cars) for the first time</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Renewal of health licenses (for mobile cars)</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>Ministry Of Health</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Issuing a health license</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Renewal of the health license</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Pay health insurance fees</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Medical examination for workers - for companies and individuals</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Approval of vaccination certificates (Gulf + visitor + work call)</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Book a Cofed-19 screening appointment at rapid screening centres</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Request an appointment to review health insurance</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Request an appointment for the medical examination of the expatriate</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Request a health center appointment</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Certificates of vaccination against COVID-19 issued from abroad</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>General Fire Administrator</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Issuance of an extinguishing license</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Extinguishing license renewal</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Issuing a permit for the carriers of dangerous materials</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Renewal of permit for hazardous materials tankers</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Issuing firefighting licenses (for mobile cars) for the first time</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Renewal of firefighting licenses (for mobile vehicles)</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Identification of a property</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Power current delivery</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Power-strengthening</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Restoring electric current</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Mortgage</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- The Right to Profit</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Store transactions (electrical current delivery)</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Store transactions (power supply)</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Store transactions (re-electric current)</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Document transactions (implementation of the terms of the coordination document and irregularities)</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Document transactions (issuance of lost allowance for alert)</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Document transactions (issuing a certificate to those interested)</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Issuing a new packing permit for fixed tanks</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Renewal of a packing permit for fixed tanks</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Initial approval of a hazardous substances carrier</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Initial approval to add trailer</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Issuing a permit for hazardous materials carriers under preliminary approval</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Issuing a permit for dangerous materials carriers to add a trailer</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Issuing a commercial vehicle permit (Photo Turk) mobile</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Renewal of the permit of a commercial vehicle (Photo Turk) mobile</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Customs release permits</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>Ministry Of Information</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Issuing a media license (depending on the activity)</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Media license renewal</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>General Department Of Trafic</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Driving license renewal</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Replacement of lost</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Extracting a replacement for a damaged driver\'s license</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Fines paid to individuals - and cars</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>Trademarks</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Register a trademark</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Trademark renewal</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Pay the annual subscription for the trademark</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Register of patent and ownership rights</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>MOJ Gate</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Extracting a replacement for a lost contract of incorporation</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Amendment to the Articles of Association</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Reserving appointments for the Ministry of Justice</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>General Administration of Customs</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Customs license issuance</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Customs license renewal</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Replacement of lost customs license</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Registration of companies and institutions with customs</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Extracting temporary import licenses for individuals</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Renewal of import licenses for companies and institutions</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Extracting temporary import licenses for individuals</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>The Public Authority For Civil Information</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Civil card renewal</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- A replacement for a lost civil</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Change profile picture</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Change of address in Al-Madinah</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Extraction of a civil party</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Modernizing the civil authority for companies and institutions</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Civil ID delivery service</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Pay card fees - and fines</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Register or add a building</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Issuance of an automated voucher number</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Building data modification</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Update entity data</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Inquire about the state of the entity</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Add a destination</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Registration of domestic workers for the first time Article (20)</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Family enrollment registration for the first time Article (22)</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- First time registration Article (17 - 18 - 19 - 23 - 24)</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Complete newborn information</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Assigning a QR code to receive a card (the first time)</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Allocate a QR code to receive a card (replacement for lost)</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Update a Latin name for a Kuwaiti individual</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Renewal of the card for a Gulf individual</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Update the image of a Gulf individual</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Registration and Re-enrollment Article 24/23/19/18/17</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Registering a family for the first time</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Registering a domestic worker for the first time</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>Public Authority Of Manpower</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Open file affairs - the first time</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Update license data</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Open user affairs</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Renewal of work permits for companies</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Transfer employees to the company</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Registration of individuals by structure to support employment (Section 5)</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Change of employers\' employers (to support employment)</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Conversion from Part 5 (To) Part 3 Business Owners</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Managing and monitoring the file companies and institutions ahead of our company</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Transfer the company file from affairs to another (with the location of the transfer)</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>Kuwait Chamber of Commerce &amp; Industry</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Opening an enrollment file in the chamber</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Chamber of Commerce subscription renewal</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Book appointments for the room</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Authentication of certificates and bills for companies and individuals</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>Ministry of Education</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Registration on the ministry platform for the student</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Registration on the ministry platform for the teacher</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Registration on the ministry&rsquo;s platform for guardians</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Submit a residence renewal application (for employees)</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>The Public Institution For Social Security</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Individual registration is a fifth chapter</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Pay subscription fees</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Book appointments for review</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Certificates extraction</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Issuing a certificate of personal insurance, chapter three</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Issuing an individual insurance certificate, chapter five</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>Ministry of Electricity and Water</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- The delivery of a new stream</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Mains electric current</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Cable transmission and electric meter</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- A temporary electrical current</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Cable relay service, overhead lines and stations</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Request to raise a cable and electricity meter for the purpose of demolition</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Reset electric current</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Delivery of water to a new building</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Adding a water link to an existing building</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Increase the capacity of an existing water connection</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Transfer link water</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Temporary water delivery</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Cut off the water service</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Meter services</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Cancel registration counter to leave the facility</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Payment of meter insurance</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Meter insurance refund</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Add or cancel electricity meters</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Add or cancel water meters</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Report meter faults</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Bill payment request (for a single facility or building)</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Request to pay bills for all facilities registered in the customer\'s name</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Bills installment request</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Request a clearance certificate for a facility</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Request clearance certificate for a client</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Returning disconnected service due to non-payment of bills</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Payment of the bill of the meter (electricity - water)</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>General Authority for Agriculture and Fisheries</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Approval of agricultural licenses</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Approval of animal licenses</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Approval of licenses for fish wealth</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>Establishment and extraction of mobile cars</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Establishment of a mobile vehicle company</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Issuing licenses for mobile vehicles (after establishment)</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Reserve a site for mobile cars</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Renewal of licenses for mobile cars</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Issuing firefighting licenses (for mobile cars) for the first time</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Issuing health licenses (for mobile cars) for the first time</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Renewal of firefighting licenses (for motor vehicles)</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Renewal of health licenses (for mobile cars)</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Opening and renewing the Chamber of Commerce subscription (for mobile cars)</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Registering a trade mark for a mobile vehicle (for the first time)</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>E-mail to government agencies and agencies</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Electronic Messaging</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Correspondence to regulatory and government agencies</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>Annual contracts</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Transaction clearance contracts for companies</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Personnel clearance contracts</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Clearance contracts for enterprises and factories</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>For sale and purchase of companies and institutions</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Selling companies and institutions</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Buying companies and institutions</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>Ministry of Finance</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Issuance of a tax certificate for companies and institutions</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Renewal of the tax certificate for companies and institutions</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>General Authority for Disability Affairs</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Submit to open a file for the first time</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Renewal of disability identity</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Renewal of disability certificate</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Registration of electronic services for the educational and rehabilitation sector</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Request for mental health support for people with disabilities affected by the CORONA pandemic</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>The Central Apparatus for Illegal Residents\' Status</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Request to issue a new certificate</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Health insurance card renewal</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Book appointments for his personal reference (for the central apparatus)</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>Public Authority for Industry</u></strong></h4>\r\n<div>&nbsp;</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>Ministry of Foreign Affairs</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Power of attorney or certificate documentation service</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- Power of attorney or certificate authentication service (foreign)</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>','2022-08-07 06:46:59','2022-08-10 06:53:58'),(24,12,'ar','<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<div class=\"m-2\">\r\n<h3 class=\"htitle\">أولا:- هدف التطبيق والموقع</h3>\r\n<p>هو تطبيق يقوم بتسهيل العمل في مجال تعقيب المعاملات من قبل شركتنا المتخصصة في مجال تعقيب وتخليص المعاملات تحت إسم تجاري( شركة المراجعين لتعقيب المعاملات ) وهدفه وغرضه تخفيف الجهد والمراجعات بالدوائر الحكومية على العملاء ويتم إستقبال جميع الطلبات المقدمة من العملاء في كل خدمة مخصصة لها وتظهر لنا في شاشة التحكم ويستأنف لنا إنجاز المعاملة المطلوبة من قبل شركتنا.</p>\r\n<p>ويخدم أيضا الأفراد في باقي الوزارات والشركات وإليكم الشرح التفصيلي للموقع والتطبيق .</p>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h3 class=\"htitle\">ثانيا:- الشرح التفصيلي للتطبيق والموقع والخدمات</h3>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>وزارة التجارة والصناعة</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تاسيس شركات</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- نقل عنوان</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- فتح فرع للشركة</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- دخول وخروج شريك</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تقديم وعمل الميزانيات للشركات</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- التراخيص الفردية</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تنازل عن التراخيص الفردي</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تغيير الإسم التجاري للشركات</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- إلغاء الترخيص</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- فسخ عقد التأسيس</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تعديل بند الإدارة وتوزيع الحصص</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تجديد التراخيص التجاري</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- اصدار تراخيص بعد التاسيس</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تحويل المؤسسة الي شركة</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- استخراج مستخرج للشركات</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- طلب تراخيص عروض وتنزيلات</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- اضافة نشاط</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- حذف نشاط</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تغير نشاط</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- زيادة وخفض راس المال للشركة</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- اصدار تراخيص لشخص خليجي</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- التاشيرة بالقيد والتعديلات للافراد والشركات</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- طلب تسجيل وكاله تجارية</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- اصدار شهادة لمن يهمه الامر</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- استخراج تراخيص الاستيراد للشركات والمؤسسات</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تجديد تراخيص الاستيراد للشركات والمؤسسات</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- استخراج تراخيص الاستيراد الموقت للافراد</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- حجز موعد التسوق في الحمعيات التعاونية ( اثناء الحظر )</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>وزارة الداخلية</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- فتح يوزر بالجوازات - للشركات والمؤسسات</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- فتح يوزر نيم للافراد</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- دفع المخالفات للشركات والافراد</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تجديد إقامات المادة 20 و 22</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تجديد جواز سفر إلكتروني ( الفرد الكويتي )</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>بلدية الكويت</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تجديد تراخيص الاعلان</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- إصدار تراخيص الاعلان</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- إصدار تراخيص تعبئة وتغليف</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تجديد تراخيص تعبئة وتغليف</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تسجيل الشركات والمقاولين</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- حجز مواقع المخيمات الربيعية</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>الهيئة العامة للغذاء والتغذية</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- إصدار ترخيص الغذاء</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تجديد ترخيص الغذاء</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- اصدار تراخيص الصحي (للسيارات المتنقلة ) اول مرة</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تجديد تراخيص الصحي ( للسيارات المتنقلة )</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>وزارة الصحة</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- إصدار الترخيص الصحي</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تجديد الترخيص الصحي</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- دفع رسوم الضمان الصحي</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- كشف طبي للعمالة - للشركات والأفراد</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- اعتماد شهادات التطعيم ( خليجي + زائر + اذان عمل )</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- حجز موعد فحص كوفيد-19</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- طلب موعد لمراجعة الضمان الصحي</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- طلب موعد للفحص الطبي للوافد</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- طلب موعد مركز صحي</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- شهادات التطعيم ضد كوفيد 19 الصادرة من الخارج</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>قـــوة الإطفـــاء العـــام</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- إصدار ترخيص الإطفاء</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تجديد ترخيص الإطفاء</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- إصدار تصريح ناقلات المواد الخطرة</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تجديد تصريح ناقلات المواد الخطرة</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- اصدار تراخيص الاطفاء ( للسارات المتنقلة ) اول مره</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تجديد تراخيص الاطفاء ( للسيارات المتنقلة )</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- معاملات القسائم ( تحديد عقار )</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- معاملات القسائم (إيصال تيار كهربائي )</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- معاملات القسائم ( تقوية تيار كهربائي )</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- معاملات القسائم ( إعادة تيار كهربائي )</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- معاملات القسائم ( رهن عقار )</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- معاملات القسائم ( حق إتنفاع )</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- معاملات المحلات ( إيصال تيار كهربائي )</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- معاملات المحلات ( تقوية تيار كهربائي )</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- معاملات المحلات ( إعادة تيار كهربائي )</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- معاملات الوثائق ( تنفيذ شروط وثيقة التنسيق والمخالفات )</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- معاملات الوثائق (إصدار بدل فاقد لتنبيه )</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- معاملات الوثائق ( إصدار شهادة لمن يهمه الأمر )</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- إصدار تصريح تعبئة جديد للخزانات الثابتة</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تجديد تصريح تعبئة للخزانات الثابتة</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- إصدار الموافقة المبدئية لناقلة مواد خطرة</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- إصدار الموافقة المبدئية لإضافة مقطورة</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- إصدار تصريح ناقلات المواد الخطرة بموجب الموافقة المبدئية</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- إصدار تصريح ناقلات مواد خطرة لإضافة مقطورة</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- إصدار تصريح مركبة تجارية ( فوتو ترك ) متنقلة</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تجديد تصريح مركبة تجارية ( فوتو ترك ) متنقلة</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تصاريح الإفراج الجمركي</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>وزارة الإعلام</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- إصدار ترخيص الإعلام ( على حسب النشاط )</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تجديد ترخيص الإعلام</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>الإدارة العامة للمرور</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تجديد رخصة القيادة</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- بدل فاقد</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- إستخراج بدل تالف لرخصة القيادة</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- دفع المخالفات للأفراد - والسيارات</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>العلامات التجارية</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تسجل علامة تجارية</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تجديد علامة تجارية</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- دفع الإشتراك السنوي للعلامة التجارية</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تسجيل براءة إختراع وحقوق ملكية</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>وزارة العدل</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- إستخراج بدل فاقد عقد تأسيس</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تعديل على عقد التأسيس</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- حجز مواعيد وزارة العدل</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>الإدارة العامة للجمارك</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- إصدار ترخيص الجمارك</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تجديد ترخيص الجمارك</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- بدل فاقد للترخيص الجمركي</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تسجيل الشركات والمؤسسات بالجمارك</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- استخراج تراخيص الاستيراد للشركات والمؤسسات</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تجديد تراخيص الاستيراد للشركات والمؤسسات</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- استخراج تراخيص الاستيراد الموقت للافراد</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>الهيئة العامة للمعلومات المدنية</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تجديد البطاقة المدنية</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- بدل فاقد للمدنية</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تغيير الصورة الشخصية</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تغيير العنوان بالمدنية</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- إستخراج جهة مدني</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تحديث الجهة المدني للشركات والمؤسسات</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- خدمة توصيل البطاقة المدنية</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- دفع رسوم البطاقة - والمخالفات</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تسجيل او إضافة مبنى</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- إصدار رقم ألي لقسيمة</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تعديل بيانات مبنى</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تحديث بيانات جهة</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- الاستعلام عن حاله الجهة</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- اضافة جهة</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تسجيل عمالة منزلية اول مرة مادة (20 )</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تسجيل التحاق بعائل اول مرة مادة ( 22 )</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تسجيل اول مرة مادة ( 17 - 18 - 19 - 23 - 24 )</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- استكمال بيانات مولود</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تخصيص كود QRلاستلام بطاقة (اول مره )</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تخصيص كود QRلاستلام بطاقة (بدل فاقد )</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تحديث اسم لاتيني لفرد الكويتي</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- التجديد البطاقة لفرد خليجي</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تحديث الصورة فرد خليجي</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تسجيل واعادة قيد مادة 24 /23 / 19 / 18 /17</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تسجيل التحاق بعائل اول مرة</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تسجيل عمالة منزلية اول مرة</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>الهيئة العامة للقوى العاملة</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- فتح ملف بالشئون - أول مرة</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تحديث بيانات الترخيص</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- فتح يوزر للشئون</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تجديد أذونات العمل للشركات</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تحويل الموظفين على الشركة</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تسجيل الافراد بالهيكلة لدعم العمالة (باب خامس)اول مرة</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تغير جهة عمل الاصحاب الاعمال (لدعم العمالة )</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تحويل من الباب الخامس (الي) الباب الثالث الاصحاب الاعمال</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- ادارة ومتابعه المشاريع للشركات والمؤسسات (مقبل شركتنا)</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- نقل الملف الشركة من الشؤون الي اخرة ( مع تحديد مكان نقل</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>غرفة تجارة وصناعة الكويت</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- فتح ملف إنتساب بالغرفة</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تجديد إشتراك غرفة التجارة</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- حجز مواعيد للغرفة</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تصديق شهادات وفواتير للشركات والأفراد</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>وزارة التربية</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- التسجيل بمنصة الوزارة للطالب</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- التسجيل بمنصة الوزارة للمعلم</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- التسجيل بمنصة الوزارة لولي الأمر</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تقديم طلب تجديد الاقامة (للموظفين )</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>المؤسسة العامة للتأمينات الإجتماعية</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تسجيل الأفراد باب خامس</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- دفع رسوم الإشتراكات</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- حجز مواعيد للمراجعة</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- إستخراج شهادات</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- استخراج شهادة تامينات الافراد الباب ثالث</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- استخراج شهادة تامينات الافراد الباب الخامس</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>وزارة الكهرباء والماء</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- إيصال تيار جديد للكهرباء</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تقوية التيار الكهربائي</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- نقل كيبل وعداد كهربائي</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تيار كهربائي مؤقت</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- خدمة ترحيل الكيبلات والخطوط الهوائية والمحطات</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- طلب رفع كيبل وعداد كهرباء بغرض الهدم</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- إعادة تيار كهربائي</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- إيصال مياه لمبنى جديد</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- إضافة ارتباط مياه لمبنى قائم</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- زيادة سعة إرتباط مياه قائم</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- نقل إرتباط مياه</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- إيصال مياه مؤقت</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- قطع خدمة المياه</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- خدمات العدادات</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- الغاء تسجيل عداد لمغادرة المرفق</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- سداد تأمين عداد</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- إسترداد تأمين عداد</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- إضافة او إلغاء عدادات كهرباء</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- إضافة أو إلغاء عدادات مياه</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- الابلاغ عن أعطال العدادات</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- طلب سداد فاتورة (لمرفق أو بناية واحدة)</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- طلب سداد فواتير جميع المرافق المسجلة بإسم العميل</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- طلب تقسيط الفواتير</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- طلب شهادة براءة ذمة لمرفق</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- طلب شهادة براءة ذمة لعميل</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- إعادة الخدمة المقطوعة بسبب عدم سداد الفواتير</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- السداد فاتورة العداد ( كهرباء - مياه )</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>الهيئة العامة للزراعة والثروة السمكية</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- موافقة علي التراخيص الزراعية</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- موافقة علي التراخيص الحيوانية</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- موافقة علي التراخيص الثروة السمكية</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>تاسيس واستخراج السيارات المتنقلة</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- طلب تاسيس شركة للسيارة المتنقلة</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- اصدار التراخيص للسيارة المتنقلة ( بعد التاسيس )</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- حجز موقع للسيارات المتنقلة</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تجديد التراخيص للسيارات المتنقلة</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- اصدار تراخيص الاطفاء ( للسارات المتنقلة ) اول مره</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- اصدار تراخيص الصحي (للسيارات المتنقلة ) اول مرة</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تجديد تراخيص الاطفاء ( للسيارات المتنقلة )</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تجديد تراخيص الصحي ( للسيارات المتنقلة )</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- فتح ملف شؤون للسيارات المتنقلة ( اول مرة )</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تسجيل علامة تجارة للسيارة المتنقلة ( اول ل مرة )</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>التراسل الالكتروني للهيئات والجهات الحكومية</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- التراسل الالكتروني</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- التراسل للجهات الرقابية والحكومية</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>المعاملات الخاصة بالعقود السنويه والشهرية</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- عقود تخليص المعاملات للشركات</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- عقود تخليص المعاملات للاشخاص</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- عقود تنخليص معاملات للمؤسسات والمصانع</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>للبيع وشراء الشركات والمؤسسات</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- بيع الشركات والمؤسسات</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- شراء الشركات والمؤسسات</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>وزارة المالية</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- اصدار شهادة ضربية للشركات ومؤسسات</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تجديد الشهادة الضربية للشركات والمؤسسات</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>الهيئة العامة لشئون ذوي الإعاقة</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تقديم لفتح ملف أول مرة</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تجديد هوية الاعاقة</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تجديد شهادة الاعاقة</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تسجيل الخدمات الالكترونية للقطاع التعليمي والتأهيلي</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تقديم طلب لدعم الصحة النفسية للاشخاص ذوي الاعاقة المتضررين من جائحة كورونا</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>الجهاز المركزي لمعالجة اوضاع المقيمين بصورة غير قانونية</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- طلب اصدار شهادة جديدة</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- تجديد بطاقة الضمان الصحي</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- حجز مواعد لمراجعه الشخصية ( لجهاز المركزي )</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>الهيئة العامة للصناعة</u></strong></h4>\r\n<div>&nbsp;</div>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n<h4 class=\"ministry-title\"><strong><u>وزارة الخارجية الكويتية</u></strong></h4>\r\n<div>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- خدمة توثيق توكيل او شهادة ( السفارات )</dd>\r\n</dl>\r\n<dl class=\"dl-horizontal\">\r\n<dd class=\"service-title\">- خدمة توثيق توكيل او شهادة ( الخارجية )</dd>\r\n</dl>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>','2022-08-07 06:46:59','2022-08-09 16:39:45'),(25,13,'en','First: - The Purpose Of The Application And The Site  It is an application that facilitates work in the field of transaction tracking by our company specialized in the field of tracking and clearing transactions under a trade name (Company Auditors To Track Transactions) and its goal and purpose is to reduce the effort and reviews in government departments to customers and all requests submitted by customers are received in each service dedicated to them and show us In the control screen, the completion of the required transaction by our company will resume.  It also serves individuals in the rest of the ministries and companies. Here is the detailed explanation of the site and the application.  Second: - A detailed Explanation Of The Application , Site And Services Ministry of Commerce and Industry - Incorporation companies - Address transfer - Opening a branch of the company - Partner entry and exit - Submit budgets - Individual licenses - Individual licenses assignment - Changing the companies\' trade name - License revocation - Termination of the Articles of Association - Amending the management clause and allocating shares - Renewal of commercial licenses - Issuing licenses after incorporation - Converting the institution to a company - Corporate extract - Request licenses for shows and discounts - Add activity - Let\'s take an activity. - Change of activity - Increasing and reducing the company\'s capital - Issuing licenses for a gulf person - Visa registration and amendments for individuals and companies - Request to register a commercial agency - Issuing a certificate to those who care about it - Extract import licenses for companies and individuals - Renewal of import licenses for individual companies - Extracting temporary import licenses for individuals - Reservation of an appointment for shopping in the cooperative societies (during the ban) Ministry Of Interior - Open User Passports - for companies and institutions - Open User Name for individuals - Payment of fines for companies and individuals - Renewal of residency permits for Articles 20 and 22 - Renewal of an electronic passport (Kuwaiti individual) Kuwait Municipality - Advertising licenses renewal - Issuing advertisement licenses - Issuing packaging licenses - Renewal of packaging licenses - Registration of companies and contractors - Reserve your spring camp sites ‏Public Authority for Food and Nutrition‎ - Issuance of a food license - Renewal of food license - Issuing health licenses (for mobile cars) for the first time - Renewal of health licenses (for mobile cars) Ministry Of Health - Issuing a health license - Renewal of the health license - Pay health insurance fees - Medical examination for workers - for companies and individuals - Approval of vaccination certificates (Gulf + visitor + work call) - Book a Cofed-19 screening appointment at rapid screening centres - Request an appointment to review health insurance - Request an appointment for the medical examination of the expatriate - Request a health center appointment - Certificates of vaccination against COVID-19 issued from abroad General Fire Administrator - Issuance of an extinguishing license - Extinguishing license renewal - Issuing a permit for the carriers of dangerous materials - Renewal of permit for hazardous materials tankers - Issuing firefighting licenses (for mobile cars) for the first time - Renewal of firefighting licenses (for mobile vehicles) - Identification of a property - Power current delivery - Power-strengthening - Restoring electric current - Mortgage - The Right to Profit - Store transactions (electrical current delivery) - Store transactions (power supply) - Store transactions (re-electric current) - Document transactions (implementation of the terms of the coordination document and irregularities) - Document transactions (issuance of lost allowance for alert) - Document transactions (issuing a certificate to those interested) - Issuing a new packing permit for fixed tanks - Renewal of a packing permit for fixed tanks - Initial approval of a hazardous substances carrier - Initial approval to add trailer - Issuing a permit for hazardous materials carriers under preliminary approval - Issuing a permit for dangerous materials carriers to add a trailer - Issuing a commercial vehicle permit (Photo Turk) mobile - Renewal of the permit of a commercial vehicle (Photo Turk) mobile - Customs release permits Ministry Of Information - Issuing a media license (depending on the activity) - Media license renewal General Department Of Trafic - Driving license renewal - Replacement of lost - Extracting a replacement for a damaged driver\'s license - Fines paid to individuals - and cars Trademarks - Register a trademark - Trademark renewal - Pay the annual subscription for the trademark - Register of patent and ownership rights MOJ Gate - Extracting a replacement for a lost contract of incorporation - Amendment to the Articles of Association - Reserving appointments for the Ministry of Justice General Administration of Customs - Customs license issuance - Customs license renewal - Replacement of lost customs license - Registration of companies and institutions with customs - Extracting temporary import licenses for individuals - Renewal of import licenses for companies and institutions - Extracting temporary import licenses for individuals The Public Authority For Civil Information - Civil card renewal - A replacement for a lost civil - Change profile picture - Change of address in Al-Madinah - Extraction of a civil party - Modernizing the civil authority for companies and institutions - Civil ID delivery service - Pay card fees - and fines - Register or add a building - Issuance of an automated voucher number - Building data modification - Update entity data - Inquire about the state of the entity - Add a destination - Registration of domestic workers for the first time Article (20) - Family enrollment registration for the first time Article (22) - First time registration Article (17 - 18 - 19 - 23 - 24) - Complete newborn information - Assigning a QR code to receive a card (the first time) - Allocate a QR code to receive a card (replacement for lost) - Update a Latin name for a Kuwaiti individual - Renewal of the card for a Gulf individual - Update the image of a Gulf individual - Registration and Re-enrollment Article 24/23/19/18/17 - Registering a family for the first time - Registering a domestic worker for the first time Public Authority Of Manpower - Open file affairs - the first time - Update license data - Open user affairs - Renewal of work permits for companies - Transfer employees to the company - Registration of individuals by structure to support employment (Section 5) - Change of employers\' employers (to support employment) - Conversion from Part 5 (To) Part 3 Business Owners - Managing and monitoring the file companies and institutions ahead of our company - Transfer the company file from affairs to another (with the location of the transfer) Kuwait Chamber of Commerce & Industry - Opening an enrollment file in the chamber - Chamber of Commerce subscription renewal - Book appointments for the room - Authentication of certificates and bills for companies and individuals Ministry of Education - Registration on the ministry platform for the student - Registration on the ministry platform for the teacher - Registration on the ministry’s platform for guardians - Submit a residence renewal application (for employees) The Public Institution For Social Security - Individual registration is a fifth chapter - Pay subscription fees - Book appointments for review - Certificates extraction - Issuing a certificate of personal insurance, chapter three - Issuing an individual insurance certificate, chapter five Ministry of Electricity and Water - The delivery of a new stream - Mains electric current - Cable transmission and electric meter - A temporary electrical current - Cable relay service, overhead lines and stations - Request to raise a cable and electricity meter for the purpose of demolition - Reset electric current - Delivery of water to a new building - Adding a water link to an existing building - Increase the capacity of an existing water connection - Transfer link water - Temporary water delivery - Cut off the water service - Meter services - Cancel registration counter to leave the facility - Payment of meter insurance - Meter insurance refund - Add or cancel electricity meters - Add or cancel water meters - Report meter faults - Bill payment request (for a single facility or building) - Request to pay bills for all facilities registered in the customer\'s name - Bills installment request - Request a clearance certificate for a facility - Request clearance certificate for a client - Returning disconnected service due to non-payment of bills - Payment of the bill of the meter (electricity - water) General Authority for Agriculture and Fisheries - Approval of agricultural licenses - Approval of animal licenses - Approval of licenses for fish wealth Establishment and extraction of mobile cars - Establishment of a mobile vehicle company - Issuing licenses for mobile vehicles (after establishment) - Reserve a site for mobile cars - Renewal of licenses for mobile cars - Issuing firefighting licenses (for mobile cars) for the first time - Issuing health licenses (for mobile cars) for the first time - Renewal of firefighting licenses (for motor vehicles) - Renewal of health licenses (for mobile cars) - Opening and renewing the Chamber of Commerce subscription (for mobile cars) - Registering a trade mark for a mobile vehicle (for the first time) E-mail to government agencies and agencies - Electronic Messaging - Correspondence to regulatory and government agencies Annual contracts - Transaction clearance contracts for companies - Personnel clearance contracts - Clearance contracts for enterprises and factories For sale and purchase of companies and institutions - Selling companies and institutions - Buying companies and institutions Ministry of Finance - Issuance of a tax certificate for companies and institutions - Renewal of the tax certificate for companies and institutions General Authority for Disability Affairs - Submit to open a file for the first time - Renewal of disability identity - Renewal of disability certificate - Registration of electronic services for the educational and rehabilitation sector - Request for mental health support for people with disabilities affected by the CORONA pandemic The Central Apparatus for Illegal Residents\' Status - Request to issue a new certificate - Health insurance card renewal - Book appointments for his personal reference (for the central apparatus) Public Authority for Industry   Ministry of Foreign Affairs - Power of attorney or certificate documentation service - Power of attorney or certificate authentication service (foreign)','2022-08-07 06:46:59','2022-08-10 06:53:58'),(26,13,'ar','أولا:- هدف التطبيق والموقع  هو تطبيق يقوم بتسهيل العمل في مجال تعقيب المعاملات من قبل شركتنا المتخصصة في مجال تعقيب وتخليص المعاملات تحت إسم تجاري( شركة المراجعين لتعقيب المعاملات ) وهدفه وغرضه تخفيف الجهد والمراجعات بالدوائر الحكومية على العملاء ويتم إستقبال جميع الطلبات المقدمة من العملاء في كل خدمة مخصصة لها وتظهر لنا في شاشة التحكم ويستأنف لنا إنجاز المعاملة المطلوبة من قبل شركتنا.  ويخدم أيضا الأفراد في باقي الوزارات والشركات وإليكم الشرح التفصيلي للموقع والتطبيق .  ثانيا:- الشرح التفصيلي للتطبيق والموقع والخدمات وزارة التجارة والصناعة - تاسيس شركات - نقل عنوان - فتح فرع للشركة - دخول وخروج شريك - تقديم وعمل الميزانيات للشركات - التراخيص الفردية - تنازل عن التراخيص الفردي - تغيير الإسم التجاري للشركات - إلغاء الترخيص - فسخ عقد التأسيس - تعديل بند الإدارة وتوزيع الحصص - تجديد التراخيص التجاري - اصدار تراخيص بعد التاسيس - تحويل المؤسسة الي شركة - استخراج مستخرج للشركات - طلب تراخيص عروض وتنزيلات - اضافة نشاط - حذف نشاط - تغير نشاط - زيادة وخفض راس المال للشركة - اصدار تراخيص لشخص خليجي - التاشيرة بالقيد والتعديلات للافراد والشركات - طلب تسجيل وكاله تجارية - اصدار شهادة لمن يهمه الامر - استخراج تراخيص الاستيراد للشركات والمؤسسات - تجديد تراخيص الاستيراد للشركات والمؤسسات - استخراج تراخيص الاستيراد الموقت للافراد - حجز موعد التسوق في الحمعيات التعاونية ( اثناء الحظر ) وزارة الداخلية - فتح يوزر بالجوازات - للشركات والمؤسسات - فتح يوزر نيم للافراد - دفع المخالفات للشركات والافراد - تجديد إقامات المادة 20 و 22 - تجديد جواز سفر إلكتروني ( الفرد الكويتي ) بلدية الكويت - تجديد تراخيص الاعلان - إصدار تراخيص الاعلان - إصدار تراخيص تعبئة وتغليف - تجديد تراخيص تعبئة وتغليف - تسجيل الشركات والمقاولين - حجز مواقع المخيمات الربيعية الهيئة العامة للغذاء والتغذية - إصدار ترخيص الغذاء - تجديد ترخيص الغذاء - اصدار تراخيص الصحي (للسيارات المتنقلة ) اول مرة - تجديد تراخيص الصحي ( للسيارات المتنقلة ) وزارة الصحة - إصدار الترخيص الصحي - تجديد الترخيص الصحي - دفع رسوم الضمان الصحي - كشف طبي للعمالة - للشركات والأفراد - اعتماد شهادات التطعيم ( خليجي + زائر + اذان عمل ) - حجز موعد فحص كوفيد-19 - طلب موعد لمراجعة الضمان الصحي - طلب موعد للفحص الطبي للوافد - طلب موعد مركز صحي - شهادات التطعيم ضد كوفيد 19 الصادرة من الخارج قـــوة الإطفـــاء العـــام - إصدار ترخيص الإطفاء - تجديد ترخيص الإطفاء - إصدار تصريح ناقلات المواد الخطرة - تجديد تصريح ناقلات المواد الخطرة - اصدار تراخيص الاطفاء ( للسارات المتنقلة ) اول مره - تجديد تراخيص الاطفاء ( للسيارات المتنقلة ) - معاملات القسائم ( تحديد عقار ) - معاملات القسائم (إيصال تيار كهربائي ) - معاملات القسائم ( تقوية تيار كهربائي ) - معاملات القسائم ( إعادة تيار كهربائي ) - معاملات القسائم ( رهن عقار ) - معاملات القسائم ( حق إتنفاع ) - معاملات المحلات ( إيصال تيار كهربائي ) - معاملات المحلات ( تقوية تيار كهربائي ) - معاملات المحلات ( إعادة تيار كهربائي ) - معاملات الوثائق ( تنفيذ شروط وثيقة التنسيق والمخالفات ) - معاملات الوثائق (إصدار بدل فاقد لتنبيه ) - معاملات الوثائق ( إصدار شهادة لمن يهمه الأمر ) - إصدار تصريح تعبئة جديد للخزانات الثابتة - تجديد تصريح تعبئة للخزانات الثابتة - إصدار الموافقة المبدئية لناقلة مواد خطرة - إصدار الموافقة المبدئية لإضافة مقطورة - إصدار تصريح ناقلات المواد الخطرة بموجب الموافقة المبدئية - إصدار تصريح ناقلات مواد خطرة لإضافة مقطورة - إصدار تصريح مركبة تجارية ( فوتو ترك ) متنقلة - تجديد تصريح مركبة تجارية ( فوتو ترك ) متنقلة - تصاريح الإفراج الجمركي وزارة الإعلام - إصدار ترخيص الإعلام ( على حسب النشاط ) - تجديد ترخيص الإعلام الإدارة العامة للمرور - تجديد رخصة القيادة - بدل فاقد - إستخراج بدل تالف لرخصة القيادة - دفع المخالفات للأفراد - والسيارات العلامات التجارية - تسجل علامة تجارية - تجديد علامة تجارية - دفع الإشتراك السنوي للعلامة التجارية - تسجيل براءة إختراع وحقوق ملكية وزارة العدل - إستخراج بدل فاقد عقد تأسيس - تعديل على عقد التأسيس - حجز مواعيد وزارة العدل الإدارة العامة للجمارك - إصدار ترخيص الجمارك - تجديد ترخيص الجمارك - بدل فاقد للترخيص الجمركي - تسجيل الشركات والمؤسسات بالجمارك - استخراج تراخيص الاستيراد للشركات والمؤسسات - تجديد تراخيص الاستيراد للشركات والمؤسسات - استخراج تراخيص الاستيراد الموقت للافراد الهيئة العامة للمعلومات المدنية - تجديد البطاقة المدنية - بدل فاقد للمدنية - تغيير الصورة الشخصية - تغيير العنوان بالمدنية - إستخراج جهة مدني - تحديث الجهة المدني للشركات والمؤسسات - خدمة توصيل البطاقة المدنية - دفع رسوم البطاقة - والمخالفات - تسجيل او إضافة مبنى - إصدار رقم ألي لقسيمة - تعديل بيانات مبنى - تحديث بيانات جهة - الاستعلام عن حاله الجهة - اضافة جهة - تسجيل عمالة منزلية اول مرة مادة (20 ) - تسجيل التحاق بعائل اول مرة مادة ( 22 ) - تسجيل اول مرة مادة ( 17 - 18 - 19 - 23 - 24 ) - استكمال بيانات مولود - تخصيص كود QRلاستلام بطاقة (اول مره ) - تخصيص كود QRلاستلام بطاقة (بدل فاقد ) - تحديث اسم لاتيني لفرد الكويتي - التجديد البطاقة لفرد خليجي - تحديث الصورة فرد خليجي - تسجيل واعادة قيد مادة 24 /23 / 19 / 18 /17 - تسجيل التحاق بعائل اول مرة - تسجيل عمالة منزلية اول مرة الهيئة العامة للقوى العاملة - فتح ملف بالشئون - أول مرة - تحديث بيانات الترخيص - فتح يوزر للشئون - تجديد أذونات العمل للشركات - تحويل الموظفين على الشركة - تسجيل الافراد بالهيكلة لدعم العمالة (باب خامس)اول مرة - تغير جهة عمل الاصحاب الاعمال (لدعم العمالة ) - تحويل من الباب الخامس (الي) الباب الثالث الاصحاب الاعمال - ادارة ومتابعه المشاريع للشركات والمؤسسات (مقبل شركتنا) - نقل الملف الشركة من الشؤون الي اخرة ( مع تحديد مكان نقل غرفة تجارة وصناعة الكويت - فتح ملف إنتساب بالغرفة - تجديد إشتراك غرفة التجارة - حجز مواعيد للغرفة - تصديق شهادات وفواتير للشركات والأفراد وزارة التربية - التسجيل بمنصة الوزارة للطالب - التسجيل بمنصة الوزارة للمعلم - التسجيل بمنصة الوزارة لولي الأمر - تقديم طلب تجديد الاقامة (للموظفين ) المؤسسة العامة للتأمينات الإجتماعية - تسجيل الأفراد باب خامس - دفع رسوم الإشتراكات - حجز مواعيد للمراجعة - إستخراج شهادات - استخراج شهادة تامينات الافراد الباب ثالث - استخراج شهادة تامينات الافراد الباب الخامس وزارة الكهرباء والماء - إيصال تيار جديد للكهرباء - تقوية التيار الكهربائي - نقل كيبل وعداد كهربائي - تيار كهربائي مؤقت - خدمة ترحيل الكيبلات والخطوط الهوائية والمحطات - طلب رفع كيبل وعداد كهرباء بغرض الهدم - إعادة تيار كهربائي - إيصال مياه لمبنى جديد - إضافة ارتباط مياه لمبنى قائم - زيادة سعة إرتباط مياه قائم - نقل إرتباط مياه - إيصال مياه مؤقت - قطع خدمة المياه - خدمات العدادات - الغاء تسجيل عداد لمغادرة المرفق - سداد تأمين عداد - إسترداد تأمين عداد - إضافة او إلغاء عدادات كهرباء - إضافة أو إلغاء عدادات مياه - الابلاغ عن أعطال العدادات - طلب سداد فاتورة (لمرفق أو بناية واحدة) - طلب سداد فواتير جميع المرافق المسجلة بإسم العميل - طلب تقسيط الفواتير - طلب شهادة براءة ذمة لمرفق - طلب شهادة براءة ذمة لعميل - إعادة الخدمة المقطوعة بسبب عدم سداد الفواتير - السداد فاتورة العداد ( كهرباء - مياه ) الهيئة العامة للزراعة والثروة السمكية - موافقة علي التراخيص الزراعية - موافقة علي التراخيص الحيوانية - موافقة علي التراخيص الثروة السمكية تاسيس واستخراج السيارات المتنقلة - طلب تاسيس شركة للسيارة المتنقلة - اصدار التراخيص للسيارة المتنقلة ( بعد التاسيس ) - حجز موقع للسيارات المتنقلة - تجديد التراخيص للسيارات المتنقلة - اصدار تراخيص الاطفاء ( للسارات المتنقلة ) اول مره - اصدار تراخيص الصحي (للسيارات المتنقلة ) اول مرة - تجديد تراخيص الاطفاء ( للسيارات المتنقلة ) - تجديد تراخيص الصحي ( للسيارات المتنقلة ) - فتح ملف شؤون للسيارات المتنقلة ( اول مرة ) - تسجيل علامة تجارة للسيارة المتنقلة ( اول ل مرة ) التراسل الالكتروني للهيئات والجهات الحكومية - التراسل الالكتروني - التراسل للجهات الرقابية والحكومية المعاملات الخاصة بالعقود السنويه والشهرية - عقود تخليص المعاملات للشركات - عقود تخليص المعاملات للاشخاص - عقود تنخليص معاملات للمؤسسات والمصانع للبيع وشراء الشركات والمؤسسات - بيع الشركات والمؤسسات - شراء الشركات والمؤسسات وزارة المالية - اصدار شهادة ضربية للشركات ومؤسسات - تجديد الشهادة الضربية للشركات والمؤسسات الهيئة العامة لشئون ذوي الإعاقة - تقديم لفتح ملف أول مرة - تجديد هوية الاعاقة - تجديد شهادة الاعاقة - تسجيل الخدمات الالكترونية للقطاع التعليمي والتأهيلي - تقديم طلب لدعم الصحة النفسية للاشخاص ذوي الاعاقة المتضررين من جائحة كورونا الجهاز المركزي لمعالجة اوضاع المقيمين بصورة غير قانونية - طلب اصدار شهادة جديدة - تجديد بطاقة الضمان الصحي - حجز مواعد لمراجعه الشخصية ( لجهاز المركزي ) الهيئة العامة للصناعة   وزارة الخارجية الكويتية - خدمة توثيق توكيل او شهادة ( السفارات ) - خدمة توثيق توكيل او شهادة ( الخارجية )','2022-08-07 06:46:59','2022-08-10 06:53:58'),(27,14,'en','img/settings/16601217196268.jpeg','2022-08-07 06:46:59','2022-08-10 06:55:19'),(28,14,'ar','img/settings/16601216384436.jpeg','2022-08-07 06:46:59','2022-08-10 06:53:58'),(29,15,'en','website/images/qr.zip','2022-08-07 06:46:59','2022-08-07 06:46:59'),(30,15,'ar','website/images/qr.zip','2022-08-07 06:46:59','2022-08-07 06:46:59'),(31,16,'en','img/settings/16659372167475.jpeg','2022-08-07 06:46:59','2022-10-16 14:20:16'),(32,16,'ar','img/settings/16659372161090.jpeg','2022-08-07 06:46:59','2022-10-16 14:20:16'),(33,17,'en','img/settings/16659372166381.jpeg','2022-08-07 06:46:59','2022-10-16 14:20:16'),(34,17,'ar','img/settings/16659372165718.jpeg','2022-08-07 06:46:59','2022-10-16 14:20:16'),(35,18,'en','website/mov_bbb.mp4','2022-08-07 06:46:59','2022-08-07 06:46:59'),(36,18,'ar','website/mov_bbb.mp4','2022-08-07 06:46:59','2022-08-07 06:46:59');
/*!40000 ALTER TABLE `setting_translations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `settings`
--

DROP TABLE IF EXISTS `settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `settings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `display_name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `key` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `settings`
--

LOCK TABLES `settings` WRITE;
/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
INSERT INTO `settings` (`id`, `display_name`, `key`, `type`, `created_at`, `updated_at`) VALUES (1,'website title','website_title','text','2022-08-07 06:46:58','2022-08-07 06:46:58'),(2,'Address','address','text','2022-08-07 06:46:58','2022-08-07 06:46:58'),(3,'Management','management','text','2022-08-07 06:46:58','2022-08-07 06:46:58'),(4,'Customer support','support','text','2022-08-07 06:46:58','2022-08-07 06:46:58'),(5,'Email','website_email','email','2022-08-07 06:46:58','2022-08-07 06:46:58'),(6,'Instagram','instagram','text','2022-08-07 06:46:58','2022-08-07 06:46:58'),(7,'Facebook','facebook','text','2022-08-07 06:46:58','2022-08-07 06:46:58'),(8,'twitter','twitter','text','2022-08-07 06:46:58','2022-08-07 06:46:58'),(9,'Youtube','youtube','text','2022-08-07 06:46:58','2022-08-07 06:46:58'),(10,'Logo 1','logo_1','file','2022-08-07 06:46:58','2022-08-07 06:46:58'),(11,'Logo 2','logo_2','file','2022-08-07 06:46:59','2022-08-07 06:46:59'),(12,'About Us','about_us','textarea','2022-08-07 06:46:59','2022-08-07 06:46:59'),(13,'About Us in footer','about_us_footer','text','2022-08-07 06:46:59','2022-08-07 06:46:59'),(14,'Usage Explain in header','usage_explain','file','2022-08-07 06:46:59','2022-08-07 06:46:59'),(15,'Help in header','help','file','2022-08-07 06:46:59','2022-08-07 06:46:59'),(16,'Loading page Logo 1','loading_logo_1','file','2022-08-07 06:46:59','2022-08-07 06:46:59'),(17,'Loading page Logo 2','loading_logo_2','file','2022-08-07 06:46:59','2022-08-07 06:46:59'),(18,'Home Page video','home_video','file','2022-08-07 06:46:59','2022-08-07 06:46:59');
/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sliders`
--

DROP TABLE IF EXISTS `sliders`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sliders` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'website',
  `image` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sliders`
--

LOCK TABLES `sliders` WRITE;
/*!40000 ALTER TABLE `sliders` DISABLE KEYS */;
INSERT INTO `sliders` (`id`, `type`, `image`, `created_at`, `updated_at`) VALUES (4,'website','img/slider/16600685449273.jpeg','2022-08-09 16:09:04','2022-08-09 16:09:04'),(5,'loader','img/slider/16600686292155.jpeg','2022-08-09 16:10:29','2022-08-09 16:10:29'),(7,'behind_search','img/slider/16600688043013.jpg','2022-08-09 16:13:24','2022-08-09 16:13:24'),(8,'behind_search','img/slider/16612507033891.jpg','2022-08-23 08:31:43','2022-08-23 08:31:43'),(9,'behind_search','img/slider/16612507178909.jpg','2022-08-23 08:31:57','2022-08-23 08:31:57'),(10,'behind_search','img/slider/16612507273572.jpg','2022-08-23 08:32:07','2022-08-23 08:32:07'),(11,'behind_search','img/slider/16612507373841.webp','2022-08-23 08:32:17','2022-08-23 08:32:17');
/*!40000 ALTER TABLE `sliders` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `testmonials`
--

DROP TABLE IF EXISTS `testmonials`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `testmonials` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `testmonials`
--

LOCK TABLES `testmonials` WRITE;
/*!40000 ALTER TABLE `testmonials` DISABLE KEYS */;
INSERT INTO `testmonials` (`id`, `image`, `name`, `created_at`, `updated_at`) VALUES (2,'img/testmonials/16612501915358.jpg','ثقصف','2022-08-23 08:23:11','2022-08-23 08:23:11'),(3,'img/testmonials/16612502006568.jpg','ثقفقثصف','2022-08-23 08:23:20','2022-08-23 08:23:20'),(4,'img/testmonials/16612502144526.jpg','صقثفثقصف','2022-08-23 08:23:34','2022-08-23 08:23:34'),(5,'img/testmonials/16612502245814.png','قثصفثقصف','2022-08-23 08:23:44','2022-08-23 08:23:44'),(6,'img/testmonials/16612502353361.jpg','صثضقفثصضق','2022-08-23 08:23:55','2022-08-23 08:23:55');
/*!40000 ALTER TABLE `testmonials` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `transaction_requests`
--

DROP TABLE IF EXISTS `transaction_requests`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `transaction_requests` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `transaction_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `status` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `payment_status` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `filled_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `price` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `transaction_requests_transaction_id_foreign` (`transaction_id`),
  KEY `transaction_requests_user_id_foreign` (`user_id`),
  CONSTRAINT `transaction_requests_transaction_id_foreign` FOREIGN KEY (`transaction_id`) REFERENCES `transactions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `transaction_requests_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `transaction_requests`
--

LOCK TABLES `transaction_requests` WRITE;
/*!40000 ALTER TABLE `transaction_requests` DISABLE KEYS */;
INSERT INTO `transaction_requests` (`id`, `transaction_id`, `user_id`, `status`, `payment_status`, `filled_data`, `created_at`, `updated_at`, `price`, `payment_data`) VALUES (3,7,2,'5','0','a:5:{i:7;s:11:\"retrewtrewt\";i:5;s:44:\"img/transactions/requests/16602321746162.pdf\";i:6;s:44:\"img/transactions/requests/16602321747974.pdf\";i:8;s:44:\"img/transactions/requests/16602321747389.pdf\";i:9;s:44:\"img/transactions/requests/16602321748270.pdf\";}','2022-08-11 13:36:14','2022-09-02 08:48:42','0',NULL),(4,7,3,'4','0','a:5:{i:7;s:10:\"fhfrghfhgf\";i:5;s:44:\"img/transactions/requests/16611589083013.png\";i:6;s:44:\"img/transactions/requests/16611589085394.png\";i:8;s:44:\"img/transactions/requests/16611589083259.png\";i:9;s:44:\"img/transactions/requests/16611589082069.png\";}','2022-08-22 07:01:48','2022-09-02 12:40:39','50',NULL),(5,8,1,'4','0','a:10:{i:15;s:12:\"بيبيبي\";i:6;s:44:\"img/transactions/requests/16621303702063.jpg\";i:8;s:44:\"img/transactions/requests/16621303705529.jpg\";i:9;s:44:\"img/transactions/requests/16621303708058.jpg\";i:10;s:44:\"img/transactions/requests/16621303708184.jpg\";i:11;s:44:\"img/transactions/requests/16621303705078.jpg\";i:12;s:44:\"img/transactions/requests/16621303704992.jpg\";i:13;s:44:\"img/transactions/requests/16621303703290.jpg\";i:14;s:44:\"img/transactions/requests/16621303709125.jpg\";i:16;s:44:\"img/transactions/requests/16621303708802.jpg\";}','2022-09-02 12:52:50','2022-09-06 22:13:06','22',NULL),(6,7,1,'4','0','a:9:{i:7;s:23:\"23232323232323232323232\";i:5;s:44:\"img/transactions/requests/16639649154192.pdf\";i:6;s:44:\"img/transactions/requests/16639649156385.pdf\";i:8;s:44:\"img/transactions/requests/16639649156021.pdf\";i:9;s:44:\"img/transactions/requests/16639649152704.pdf\";i:10;s:44:\"img/transactions/requests/16639649153973.pdf\";i:11;s:44:\"img/transactions/requests/16639649153385.pdf\";i:12;s:44:\"img/transactions/requests/16639649159649.pdf\";i:13;s:44:\"img/transactions/requests/16639649156873.pdf\";}','2022-09-23 18:28:35','2022-09-23 18:29:22','20',NULL);
/*!40000 ALTER TABLE `transaction_requests` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `transaction_translations`
--

DROP TABLE IF EXISTS `transaction_translations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `transaction_translations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `transaction_id` bigint unsigned NOT NULL,
  `locale` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `transaction_translations_transaction_id_locale_unique` (`transaction_id`,`locale`),
  KEY `transaction_translations_locale_index` (`locale`),
  CONSTRAINT `transaction_translations_transaction_id_foreign` FOREIGN KEY (`transaction_id`) REFERENCES `transactions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `transaction_translations`
--

LOCK TABLES `transaction_translations` WRITE;
/*!40000 ALTER TABLE `transaction_translations` DISABLE KEYS */;
INSERT INTO `transaction_translations` (`id`, `transaction_id`, `locale`, `name`, `created_at`, `updated_at`) VALUES (13,7,'en','Ministry of Commerce and Industry - Establishment of Companies','2022-08-10 06:33:58','2022-08-10 06:33:58'),(14,7,'ar','وزارة التجارة والصناعة - تاسيس شركات','2022-08-10 06:33:58','2022-08-10 06:33:58'),(15,8,'en','Ministry of Commerce and Industry - Transfer Address','2022-08-10 06:40:22','2022-08-10 06:40:22'),(16,8,'ar','وزارة التجارة والصناعة - نقل عنوان','2022-08-10 06:40:22','2022-08-10 06:40:22');
/*!40000 ALTER TABLE `transaction_translations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `transactions`
--

DROP TABLE IF EXISTS `transactions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `transactions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `service_id` bigint unsigned NOT NULL,
  `price` double NOT NULL DEFAULT '0',
  `required_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `visible` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `transactions_service_id_foreign` (`service_id`),
  CONSTRAINT `transactions_service_id_foreign` FOREIGN KEY (`service_id`) REFERENCES `services` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `transactions`
--

LOCK TABLES `transactions` WRITE;
/*!40000 ALTER TABLE `transactions` DISABLE KEYS */;
INSERT INTO `transactions` (`id`, `image`, `service_id`, `price`, `required_data`, `created_at`, `updated_at`, `visible`) VALUES (7,'img/transactions/16601204382102.jpeg',10,0,'a:8:{i:0;s:1:\"6\";i:1;s:1:\"7\";i:2;s:1:\"8\";i:3;s:1:\"9\";i:4;s:2:\"10\";i:5;s:2:\"11\";i:6;s:2:\"12\";i:7;s:2:\"13\";}','2022-08-10 06:33:58','2024-01-20 15:46:34',1),(8,'img/transactions/16601208225071.png',10,0,'a:10:{i:0;s:1:\"6\";i:1;s:1:\"8\";i:2;s:1:\"9\";i:3;s:2:\"10\";i:4;s:2:\"11\";i:5;s:2:\"12\";i:6;s:2:\"13\";i:7;s:2:\"14\";i:8;s:2:\"15\";i:9;s:2:\"16\";}','2022-08-10 06:40:22','2022-08-10 06:40:22',1);
/*!40000 ALTER TABLE `transactions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `full_name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `national_id` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_no` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_name` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `profile_picture` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'img/avatar.svg',
  `device_token` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(125) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` (`id`, `full_name`, `national_id`, `email`, `email_verified_at`, `password`, `phone`, `file_no`, `company_name`, `profile_picture`, `device_token`, `type`, `remember_token`, `created_at`, `updated_at`) VALUES (1,'admin','15956789','ahmedhamada2555@gmail.com',NULL,'$2y$10$g9ceBZqU5q04D9oL5lUXOuF7Nxvnnf6WQF4E6nouYEL4rGuQS6MOy',NULL,NULL,NULL,'img/avatar.svg',NULL,NULL,'TJ6ZyEooVs1Lsk96B9sDcq3UiqUFnlLDbBh6NyJnHrEiLRDGp1RwdWQQafJ2','2022-08-07 06:46:59','2022-08-07 13:19:47'),(2,'انور شحاتة عبد الزاهر','123456789','anwershehata@gmail.com',NULL,'$2y$10$Z/nza/lfZiF8i.Z3P3Xm6eMKiktt4XH0In7TVQRoK7Tv9EEPTtL2S','67782374','','','img/avatar.svg',NULL,'personal',NULL,'2022-08-09 10:53:52','2022-08-09 10:53:52'),(3,'عادل','291071702643','kwkw447@yahoo.com',NULL,'$2y$10$fH8GPYQqxA0CpzFBKZ5KNeHYukJ1XIQ5b.MAOG6HlwHF5K3veflzC','55838367','','','img/avatar.svg',NULL,'personal',NULL,'2022-08-09 16:22:45','2022-08-09 16:22:45'),(4,'حسام','285010128221','CV.6628@GMAIL.COM',NULL,'$2y$10$Ndzv6P2N31g8rUIpcTPP5uAmXQhzVI.CMNaB0d9QVmjiMEXsiPnYy','97772470','','','img/avatar.svg',NULL,'personal',NULL,'2022-10-24 07:07:40','2022-10-24 07:07:40'),(5,'هيثم','294010304258','info77540@gmail.com',NULL,'$2y$10$U3pBvwFtcbRJL2W2f9cPlOTyo/o0E.EhsQDtHvIzFbcc7gQEYgnke','50595328','','','img/avatar.svg',NULL,'personal',NULL,'2025-08-05 05:25:23','2025-08-05 05:25:23');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'topappkw_transactions'
--

--
-- Dumping routines for database 'topappkw_transactions'
--
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2025-10-28  2:20:01