Salary Market

-- MySQL dump 10.13  Distrib 8.0.40, for macos14 (x86_64)

--

-- Host: 127.0.0.1    Database: salarymarket

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

-- Server version	8.4.4-router

/*!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 utf8 */;

/*!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 */;

SET @MYSQLDUMP_TEMP_LOG_BIN = @@SESSION.SQL_LOG_BIN;

SET @@SESSION.SQL_LOG_BIN= 0;

--

-- GTID state at the beginning of the backup 

--

SET @@GLOBAL.GTID_PURGED=/*!80000 '+'*/ '073d9290-02b1-11f0-98cc-16128f5b97cd:1-8,

1dc1af11-02b1-11f0-a9e9-16128f5b97cd:1-40401';

--

-- Table structure for table `solution_setting_business_sector`

--

DROP TABLE IF EXISTS `solution_setting_business_sector`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!50503 SET character_set_client = utf8mb4 */;

CREATE TABLE `solution_setting_business_sector` (

  `id` int NOT NULL AUTO_INCREMENT,

  `code` varchar(255) NOT NULL,

  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,

  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

  PRIMARY KEY (`code`),

  UNIQUE KEY `id` (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `solution_setting_business_sector`

--

LOCK TABLES `solution_setting_business_sector` WRITE;

/*!40000 ALTER TABLE `solution_setting_business_sector` DISABLE KEYS */;

INSERT INTO `solution_setting_business_sector` VALUES (1,'BS001','2025-03-16 23:00:32','2025-03-16 23:00:32'),(2,'BS002','2025-03-16 23:00:32','2025-03-16 23:00:32'),(3,'BS003','2025-03-16 23:00:32','2025-03-16 23:00:32'),(4,'BS004','2025-03-16 23:00:32','2025-03-16 23:00:32'),(5,'BS005','2025-03-18 17:10:58','2025-03-18 17:10:58');

/*!40000 ALTER TABLE `solution_setting_business_sector` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `solution_setting_business_sector_translate`

--

DROP TABLE IF EXISTS `solution_setting_business_sector_translate`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!50503 SET character_set_client = utf8mb4 */;

CREATE TABLE `solution_setting_business_sector_translate` (

  `id` int NOT NULL AUTO_INCREMENT,

  `Label` text,

  `businessSectorCode` varchar(255) NOT NULL,

  `languageId` int NOT NULL,

  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,

  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

  PRIMARY KEY (`id`),

  KEY `languageId` (`languageId`),

  KEY `businessSectorCode` (`businessSectorCode`),

  CONSTRAINT `solution_setting_business_sector_translate_ibfk_1` FOREIGN KEY (`languageId`) REFERENCES `languages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

  CONSTRAINT `solution_setting_business_sector_translate_ibfk_2` FOREIGN KEY (`businessSectorCode`) REFERENCES `solution_setting_business_sector` (`code`) ON DELETE CASCADE ON UPDATE CASCADE

) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `solution_setting_business_sector_translate`

--

LOCK TABLES `solution_setting_business_sector_translate` WRITE;

/*!40000 ALTER TABLE `solution_setting_business_sector_translate` DISABLE KEYS */;

INSERT INTO `solution_setting_business_sector_translate` VALUES (1,' General market','BS001',1,'2025-03-16 23:00:32','2025-03-18 16:55:38'),(2,'Marché général','BS001',2,'2025-03-16 23:00:32','2025-03-18 16:55:38'),(3,' Banking and insurance market','BS002',1,'2025-03-16 23:00:32','2025-03-18 16:56:15'),(4,'Marché banque et assurance','BS002',2,'2025-03-16 23:00:32','2025-03-18 16:56:15'),(5,' Industrial market','BS003',1,'2025-03-16 23:00:32','2025-03-18 16:57:08'),(6,'Marché industriel','BS003',2,'2025-03-16 23:00:32','2025-03-18 16:57:08'),(7,'KIT market','BS004',1,'2025-03-16 23:00:32','2025-03-18 16:57:49'),(8,'Marché IT','BS004',2,'2025-03-16 23:00:32','2025-03-18 16:57:36'),(9,'Marché pharmaceutique','BS005',2,'2025-03-18 17:10:58','2025-03-18 17:10:58'),(10,'Pharmaceutical market','BS005',1,'2025-03-18 17:10:58','2025-03-18 17:10:58');

/*!40000 ALTER TABLE `solution_setting_business_sector_translate` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `solution_setting_sub_sector`

--

DROP TABLE IF EXISTS `solution_setting_sub_sector`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!50503 SET character_set_client = utf8mb4 */;

CREATE TABLE `solution_setting_sub_sector` (

  `id` int NOT NULL AUTO_INCREMENT,

  `code` varchar(255) NOT NULL,

  `businessSectorCode` varchar(255) NOT NULL,

  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,

  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

  PRIMARY KEY (`code`),

  UNIQUE KEY `id` (`id`),

  KEY `businessSectorCode` (`businessSectorCode`),

  CONSTRAINT `solution_setting_sub_sector_ibfk_1` FOREIGN KEY (`businessSectorCode`) REFERENCES `solution_setting_business_sector` (`code`) ON DELETE CASCADE ON UPDATE CASCADE

) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `solution_setting_sub_sector`

--

LOCK TABLES `solution_setting_sub_sector` WRITE;

/*!40000 ALTER TABLE `solution_setting_sub_sector` DISABLE KEYS */;

INSERT INTO `solution_setting_sub_sector` VALUES (27,'BS001001','BS001','2025-03-18 17:21:28','2025-03-18 17:21:28'),(28,'BS001002','BS001','2025-03-18 17:21:48','2025-03-18 17:21:48'),(29,'BS001003','BS001','2025-03-18 17:22:05','2025-03-18 17:22:05'),(30,'BS001004','BS001','2025-03-18 17:25:47','2025-03-18 17:25:47'),(31,'BS001005','BS001','2025-03-18 17:26:06','2025-03-18 17:26:06'),(32,'BS001006','BS001','2025-03-18 17:29:11','2025-03-18 17:29:11'),(33,'BS001007','BS001','2025-03-18 17:29:45','2025-03-18 17:29:45'),(34,'BS001008','BS001','2025-03-18 17:30:04','2025-03-18 17:30:04'),(35,'BS001009','BS001','2025-03-18 17:30:44','2025-03-18 17:30:44'),(36,'BS001010','BS001','2025-03-18 17:31:11','2025-03-18 17:31:11'),(37,'BS001011','BS001','2025-03-18 17:31:37','2025-03-18 17:31:37'),(38,'BS001012','BS001','2025-03-18 19:33:40','2025-03-18 19:33:40'),(39,'BS001013','BS001','2025-03-18 19:33:55','2025-03-18 19:33:55'),(40,'BS001014','BS001','2025-03-18 19:34:14','2025-03-18 19:34:14'),(41,'BS001015','BS001','2025-03-18 19:35:21','2025-03-18 19:35:21'),(42,'BS001016','BS001','2025-03-18 19:35:39','2025-03-18 19:35:39'),(43,'BS001017','BS001','2025-03-18 19:36:02','2025-03-18 19:36:02'),(45,'BS001018','BS001','2025-03-18 19:36:50','2025-03-18 19:36:50'),(44,'BS001019','BS001','2025-03-18 19:36:25','2025-03-18 19:36:25'),(46,'BS001020','BS001','2025-03-18 19:37:26','2025-03-18 19:37:26'),(47,'BS001021','BS001','2025-03-18 19:37:49','2025-03-18 19:37:49'),(48,'BS001022','BS001','2025-03-18 19:38:34','2025-03-18 19:38:34'),(49,'BS001023','BS001','2025-03-18 19:38:50','2025-03-18 19:38:50'),(50,'BS001024','BS001','2025-03-18 19:39:25','2025-03-18 19:39:25'),(51,'BS001025','BS001','2025-03-18 19:39:40','2025-03-18 19:39:40'),(52,'BS001026','BS001','2025-03-18 19:41:11','2025-03-18 19:41:11'),(53,'BS001027','BS001','2025-03-18 19:41:38','2025-03-18 19:41:38'),(54,'BS001028','BS001','2025-03-18 19:42:22','2025-03-18 19:42:22'),(55,'BS001029','BS001','2025-03-18 19:42:57','2025-03-18 19:42:57'),(56,'BS001030','BS001','2025-03-18 19:43:18','2025-03-18 19:43:18'),(57,'BS001031','BS001','2025-03-18 19:43:37','2025-03-18 19:43:37'),(58,'BS001032','BS001','2025-03-18 19:43:55','2025-03-18 19:43:55'),(59,'BS001033','BS001','2025-03-18 19:44:21','2025-03-18 19:44:21'),(60,'BS001034','BS001','2025-03-18 19:44:38','2025-03-18 19:44:38'),(61,'BS001035','BS001','2025-03-18 19:45:00','2025-03-18 19:45:00'),(62,'BS001036','BS001','2025-03-18 19:45:17','2025-03-18 19:45:17'),(8,'BS002001','BS002','2025-03-18 17:08:23','2025-03-18 17:08:23'),(9,'BS002002','BS002','2025-03-18 17:08:39','2025-03-18 17:08:39'),(10,'BS002003','BS002','2025-03-18 17:09:07','2025-03-18 17:09:07'),(13,'BS003001','BS003','2025-03-18 17:13:11','2025-03-18 17:13:11'),(14,'BS003002','BS003','2025-03-18 17:13:29','2025-03-18 17:13:29'),(15,'BS003003','BS003','2025-03-18 17:14:12','2025-03-18 17:14:12'),(16,'BS003004','BS003','2025-03-18 17:14:33','2025-03-18 17:14:33'),(17,'BS003005','BS003','2025-03-18 17:15:08','2025-03-18 17:15:08'),(18,'BS003006','BS003','2025-03-18 17:15:48','2025-03-18 17:15:48'),(19,'BS003007','BS003','2025-03-18 17:17:05','2025-03-18 17:17:05'),(20,'BS003008','BS003','2025-03-18 17:17:25','2025-03-18 17:17:25'),(21,'BS003009','BS003','2025-03-18 17:18:04','2025-03-18 17:18:04'),(22,'BS003010','BS003','2025-03-18 17:18:40','2025-03-18 17:18:40'),(23,'BS003011','BS003','2025-03-18 17:19:18','2025-03-18 17:19:18'),(24,'BS003012','BS003','2025-03-18 17:19:39','2025-03-18 17:19:39'),(25,'BS003013','BS003','2025-03-18 17:19:59','2025-03-18 17:19:59'),(26,'BS003014','BS003','2025-03-18 17:20:38','2025-03-18 17:20:38'),(5,'BS004001','BS004','2025-03-18 17:05:22','2025-03-18 17:05:22'),(6,'BS004002','BS004','2025-03-18 17:07:13','2025-03-18 17:07:13'),(7,'BS004003','BS004','2025-03-18 17:07:35','2025-03-18 17:07:35'),(11,'BS005001','BS005','2025-03-18 17:11:34','2025-03-18 17:11:34'),(12,'BS005002','BS005','2025-03-18 17:11:55','2025-03-18 17:11:55');

/*!40000 ALTER TABLE `solution_setting_sub_sector` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `solution_setting_sub_sector_translate`

--

DROP TABLE IF EXISTS `solution_setting_sub_sector_translate`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!50503 SET character_set_client = utf8mb4 */;

CREATE TABLE `solution_setting_sub_sector_translate` (

  `id` int NOT NULL AUTO_INCREMENT,

  `Label` text,

  `subSectorCode` varchar(255) NOT NULL,

  `languageId` int NOT NULL,

  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,

  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

  PRIMARY KEY (`id`),

  KEY `languageId` (`languageId`),

  KEY `subSectorCode` (`subSectorCode`),

  CONSTRAINT `solution_setting_sub_sector_translate_ibfk_1` FOREIGN KEY (`languageId`) REFERENCES `languages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

  CONSTRAINT `solution_setting_sub_sector_translate_ibfk_2` FOREIGN KEY (`subSectorCode`) REFERENCES `solution_setting_sub_sector` (`code`) ON DELETE CASCADE ON UPDATE CASCADE

) ENGINE=InnoDB AUTO_INCREMENT=125 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `solution_setting_sub_sector_translate`

--

LOCK TABLES `solution_setting_sub_sector_translate` WRITE;

/*!40000 ALTER TABLE `solution_setting_sub_sector_translate` DISABLE KEYS */;

INSERT INTO `solution_setting_sub_sector_translate` VALUES (9,'Service Electrique et Electronique','BS004001',2,'2025-03-18 17:05:22','2025-03-18 17:05:22'),(10,'Electrical and Electronic Services','BS004001',1,'2025-03-18 17:05:22','2025-03-18 17:05:22'),(11,'Télécommunication ','BS004002',2,'2025-03-18 17:07:13','2025-03-18 17:07:13'),(12,'Telecommunications','BS004002',1,'2025-03-18 17:07:13','2025-03-18 17:07:13'),(13,'Service Electrique et Electronique','BS004003',2,'2025-03-18 17:07:35','2025-03-18 17:07:35'),(14,'Electrical and Electronic Services','BS004003',1,'2025-03-18 17:07:35','2025-03-18 17:07:35'),(15,'Assurance','BS002001',2,'2025-03-18 17:08:23','2025-03-18 17:08:23'),(16,'Insurance','BS002001',1,'2025-03-18 17:08:23','2025-03-18 17:08:23'),(17,'Banque et établisement financier','BS002002',2,'2025-03-18 17:08:39','2025-03-18 17:08:39'),(18,'Banking and Financial Institutions','BS002002',1,'2025-03-18 17:08:39','2025-03-18 17:08:39'),(19,'Microfinance','BS002003',2,'2025-03-18 17:09:07','2025-03-18 17:09:07'),(20,'Microfinance','BS002003',1,'2025-03-18 17:09:07','2025-03-18 17:09:07'),(21,'Distribution pharmaceutique et parapharmaceutique ','BS005001',2,'2025-03-18 17:11:34','2025-03-18 17:11:34'),(22,'Pharmaceutical and Parapharmaceutical Distribution','BS005001',1,'2025-03-18 17:11:34','2025-03-18 17:11:34'),(23,'Industrie pharmaceutique','BS005002',2,'2025-03-18 17:11:55','2025-03-18 17:11:55'),(24,'Pharmaceutical Industry','BS005002',1,'2025-03-18 17:11:55','2025-03-18 17:11:55'),(25,'Industrie agricole et agroalimentaire ','BS003001',2,'2025-03-18 17:13:11','2025-03-18 17:13:11'),(26,'Agricultural and Agri-Food Industry','BS003001',1,'2025-03-18 17:13:11','2025-03-18 17:13:11'),(27,'Industrie automobile','BS003002',2,'2025-03-18 17:13:29','2025-03-18 17:13:29'),(28,'Automotive Industry','BS003002',1,'2025-03-18 17:13:29','2025-03-18 17:13:29'),(29,'Industrie chimique','BS003003',2,'2025-03-18 17:14:12','2025-03-18 17:14:12'),(30,'Chemical Industry','BS003003',1,'2025-03-18 17:14:12','2025-03-18 17:14:12'),(31,'Industrie de conserve et semi-concerne et de conditionnement d\'huile ','BS003004',2,'2025-03-18 17:14:33','2025-03-18 17:14:33'),(32,'Oil Canning and Semi-Canned and Packaging Industry','BS003004',1,'2025-03-18 17:14:33','2025-03-18 17:14:33'),(33,'Industrie de fabrication des produits de toilettes et de parfumerie ','BS003005',2,'2025-03-18 17:15:08','2025-03-18 17:15:08'),(34,'Toiletries and Perfumery Manufacturing Industry','BS003005',1,'2025-03-18 17:15:08','2025-03-18 17:15:08'),(35,'Industrie de la peinture','BS003006',2,'2025-03-18 17:15:48','2025-03-18 17:15:48'),(36,'Paint Industry','BS003006',1,'2025-03-18 17:15:48','2025-03-18 17:15:48'),(37,'Industrie de Plasturgie et d\'emballage','BS003007',2,'2025-03-18 17:17:05','2025-03-18 17:17:05'),(38,'Plastics and Packaging Industry','BS003007',1,'2025-03-18 17:17:05','2025-03-18 17:17:05'),(39,'Industrie du bois et d\'ameublement','BS003008',2,'2025-03-18 17:17:25','2025-03-18 17:17:25'),(40,'Wood and Furniture Industry','BS003008',1,'2025-03-18 17:17:25','2025-03-18 17:17:25'),(41,'Industrie du papier et du carton','BS003009',2,'2025-03-18 17:18:04','2025-03-18 17:18:04'),(42,'Paper and Cardboard Industry','BS003009',1,'2025-03-18 17:18:04','2025-03-18 17:18:04'),(43,'Industrie Electrique et Electronique ','BS003010',2,'2025-03-18 17:18:40','2025-03-18 17:18:40'),(44,'Electrical and Electronic Industry','BS003010',1,'2025-03-18 17:18:40','2025-03-18 17:18:40'),(45,'Industrie ferroviaire','BS003011',2,'2025-03-18 17:19:18','2025-03-18 17:19:18'),(46,'Railway Industry','BS003011',1,'2025-03-18 17:19:18','2025-03-18 17:19:18'),(47,'Industrie métallurgique','BS003012',2,'2025-03-18 17:19:39','2025-03-18 17:19:39'),(48,'Metallurgy Industry','BS003012',1,'2025-03-18 17:19:39','2025-03-18 17:19:39'),(49,'Industrie textile et d’habillement : Automible + textile','BS003013',2,'2025-03-18 17:19:59','2025-03-18 17:19:59'),(50,'Textile and Clothing Industry: Automotive + Textiles','BS003013',1,'2025-03-18 17:19:59','2025-03-18 17:19:59'),(51,'Secteur de la pétrochimie ','BS003014',2,'2025-03-18 17:20:38','2025-03-18 17:20:38'),(52,'Petrochemical Sector','BS003014',1,'2025-03-18 17:20:38','2025-03-18 17:20:38'),(53,'Agence de voyage ','BS001001',2,'2025-03-18 17:21:28','2025-03-18 17:21:28'),(54,'Travel Agency','BS001001',1,'2025-03-18 17:21:28','2025-03-18 17:21:28'),(55,'Agriculture, sylviculture et pêche ','BS001002',2,'2025-03-18 17:21:48','2025-03-18 17:21:48'),(56,'Agriculture, Forestry and Fishing','BS001002',1,'2025-03-18 17:21:48','2025-03-18 17:21:48'),(57,'Association et ONG','BS001003',2,'2025-03-18 17:22:05','2025-03-18 17:22:05'),(58,'Associations and NGOs','BS001003',1,'2025-03-18 17:22:05','2025-03-18 17:22:05'),(59,'Audiovisuel et média','BS001004',2,'2025-03-18 17:25:47','2025-03-18 17:25:47'),(60,'Audiovisual and Media','BS001004',1,'2025-03-18 17:25:47','2025-03-18 17:25:47'),(61,'Bâtiment et travaux publics  ','BS001005',2,'2025-03-18 17:26:06','2025-03-18 17:26:06'),(62,'Construction and Public Works','BS001005',1,'2025-03-18 17:26:06','2025-03-18 17:26:06'),(63,'Clinique privée','BS001006',2,'2025-03-18 17:29:11','2025-03-18 17:29:11'),(64,'Private Clinic','BS001006',1,'2025-03-18 17:29:11','2025-03-18 17:29:11'),(65,'Commerce de gros, semi-gros et en détails','BS001007',2,'2025-03-18 17:29:45','2025-03-18 17:29:45'),(66,'Wholesale, Semi-Wholesale and Retail Trade','BS001007',1,'2025-03-18 17:29:45','2025-03-18 17:29:45'),(67,'Commerce des matériaux de consutruction et du bois','BS001008',2,'2025-03-18 17:30:04','2025-03-18 17:30:04'),(68,'Trade in Building Materials and Wood','BS001008',1,'2025-03-18 17:30:04','2025-03-18 17:30:04'),(69,'Commerce et distribution du pétrole et dérivés','BS001009',2,'2025-03-18 17:30:44','2025-03-18 17:30:44'),(70,'Trade and Distribution of Oil and Derivatives','BS001009',1,'2025-03-18 17:30:44','2025-03-18 17:30:44'),(71,'Concessionnaire automobile ','BS001010',2,'2025-03-18 17:31:12','2025-03-18 17:31:12'),(72,'Car Dealership','BS001010',1,'2025-03-18 17:31:12','2025-03-18 17:31:12'),(73,'Concessionnaire de matérial agricole et génie civil ','BS001011',2,'2025-03-18 17:31:37','2025-03-18 17:31:37'),(74,'Agricultural Equipment and Civil Engineering Dealership','BS001011',1,'2025-03-18 17:31:37','2025-03-18 17:31:37'),(75,'Energie renouvelable','BS001012',2,'2025-03-18 19:33:40','2025-03-18 19:33:40'),(76,'Renewable Energy','BS001012',1,'2025-03-18 19:33:40','2025-03-18 19:33:40'),(77,'Enseignement privé','BS001013',2,'2025-03-18 19:33:55','2025-03-18 19:33:55'),(78,'Private Education','BS001013',1,'2025-03-18 19:33:55','2025-03-18 19:33:55'),(79,'Gardiennage et sécurité des entreprises','BS001014',2,'2025-03-18 19:34:14','2025-03-18 19:34:14'),(80,'Business Guarding and Security','BS001014',1,'2025-03-18 19:34:14','2025-03-18 19:34:14'),(81,'Grande distribution','BS001015',2,'2025-03-18 19:35:21','2025-03-18 19:35:21'),(82,'Large-Scale Retailing','BS001015',1,'2025-03-18 19:35:21','2025-03-18 19:35:21'),(83,'Hébergement et restauration ','BS001016',2,'2025-03-18 19:35:39','2025-03-18 19:35:39'),(84,'Accommodation and Catering','BS001016',1,'2025-03-18 19:35:39','2025-03-18 19:35:39'),(85,'Industrie agricole et agroalimentaire ','BS001017',2,'2025-03-18 19:36:02','2025-03-18 19:36:02'),(86,'Industry Agriculture and Agri-Food','BS001017',1,'2025-03-18 19:36:02','2025-03-18 19:36:02'),(87,'Industrie automobile ','BS001019',2,'2025-03-18 19:36:25','2025-03-18 19:36:25'),(88,'Automotive Industry','BS001019',1,'2025-03-18 19:36:25','2025-03-18 19:36:25'),(89,'Industrie de conserve et semi-concerne et de conditionnement d\'huile','BS001018',2,'2025-03-18 19:36:50','2025-03-18 19:36:50'),(90,'Oil Canning and Semi-Canned and Packaging Industry','BS001018',1,'2025-03-18 19:36:50','2025-03-18 19:36:50'),(91,'Industrie de fabrication des produits de toilettes et de parfumerie','BS001020',2,'2025-03-18 19:37:26','2025-03-18 19:37:26'),(92,'Toiletries and Perfumery Manufacturing Industry','BS001020',1,'2025-03-18 19:37:26','2025-03-18 19:37:26'),(93,'Industrie de la peinture','BS001021',2,'2025-03-18 19:37:49','2025-03-18 19:37:49'),(94,'Paint Industry','BS001021',1,'2025-03-18 19:37:49','2025-03-18 19:37:49'),(95,'Industrie du bois','BS001022',2,'2025-03-18 19:38:34','2025-03-18 19:38:34'),(96,'Wood Industry','BS001022',1,'2025-03-18 19:38:34','2025-03-18 19:38:34'),(97,'Industrie du cuir ','BS001023',2,'2025-03-18 19:38:50','2025-03-18 19:38:50'),(98,'Leather Industry','BS001023',1,'2025-03-18 19:38:50','2025-03-18 19:38:50'),(99,'Industrie du papier et du carton','BS001024',2,'2025-03-18 19:39:25','2025-03-18 19:39:25'),(100,'Paper and Cardboard Industry','BS001024',1,'2025-03-18 19:39:25','2025-03-18 19:39:25'),(101,'Industrie Electrique et Electronique ','BS001025',2,'2025-03-18 19:39:40','2025-03-18 19:39:40'),(102,'Electrical and Electronic Industry','BS001025',1,'2025-03-18 19:39:40','2025-03-18 19:39:40'),(103,'Industrie ferroviaire','BS001026',2,'2025-03-18 19:41:11','2025-03-18 19:41:11'),(104,'Railway Industry','BS001026',1,'2025-03-18 19:41:11','2025-03-18 19:41:11'),(105,'Industrie métallurgique ','BS001027',2,'2025-03-18 19:41:38','2025-03-18 19:41:38'),(106,'Metallurgy Industry','BS001027',1,'2025-03-18 19:41:38','2025-03-18 19:41:38'),(107,'Industrie textile et d’habillement : Automible + textile','BS001028',2,'2025-03-18 19:42:22','2025-03-18 19:42:22'),(108,'Textile and Clothing Industry: Automotive + Textiles','BS001028',1,'2025-03-18 19:42:22','2025-03-18 19:42:22'),(109,'Plasturgie et emballage','BS001029',2,'2025-03-18 19:42:57','2025-03-18 19:42:57'),(110,'Plastics and Packaging','BS001029',1,'2025-03-18 19:42:57','2025-03-18 19:42:57'),(111,'Réparation automobile ','BS001030',2,'2025-03-18 19:43:18','2025-03-18 19:43:18'),(112,'Automotive Repair','BS001030',1,'2025-03-18 19:43:18','2025-03-18 19:43:18'),(113,'Secteur des mines ','BS001031',2,'2025-03-18 19:43:37','2025-03-18 19:43:37'),(114,'Mining Sector','BS001031',1,'2025-03-18 19:43:37','2025-03-18 19:43:37'),(115,'Services aux entreprises','BS001032',2,'2025-03-18 19:43:55','2025-03-18 19:43:55'),(116,'Business Services','BS001032',1,'2025-03-18 19:43:55','2025-03-18 19:43:55'),(117,'Services logistiques','BS001033',2,'2025-03-18 19:44:21','2025-03-18 19:44:21'),(118,'Logistics Services','BS001033',1,'2025-03-18 19:44:21','2025-03-18 19:44:21'),(119,'Sport et loisirs','BS001034',2,'2025-03-18 19:44:38','2025-03-18 19:44:38'),(120,'Sports and Leisure','BS001034',1,'2025-03-18 19:44:38','2025-03-18 19:44:38'),(121,'Traitement de déchets liquide et solide','BS001035',2,'2025-03-18 19:45:00','2025-03-18 19:45:00'),(122,'Liquid and Solid Waste Treatment','BS001035',1,'2025-03-18 19:45:00','2025-03-18 19:45:00'),(123,'Transport','BS001036',2,'2025-03-18 19:45:17','2025-03-18 19:45:17'),(124,'Transportation','BS001036',1,'2025-03-18 19:45:17','2025-03-18 19:45:17');

/*!40000 ALTER TABLE `solution_setting_sub_sector_translate` ENABLE KEYS */;

UNLOCK TABLES;

SET @@SESSION.SQL_LOG_BIN = @MYSQLDUMP_TEMP_LOG_BIN;

/*!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-03-19 13:10:08