-- MySQL dump 10.13  Distrib 8.0.41, for Win64 (x86_64)
--
-- Host: 127.0.0.1    Database: db_access_02709
-- ------------------------------------------------------
-- Server version	8.0.40

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

--
-- Table structure for table `cpt_tbl_compte_generique`
--

DROP TABLE IF EXISTS `cpt_tbl_compte_generique`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cpt_tbl_compte_generique` (
  `id` int NOT NULL AUTO_INCREMENT,
  `cg_code` varchar(5) NOT NULL,
  `exceptions` varchar(30) DEFAULT NULL,
  `fk_poste_code` varchar(4) NOT NULL,
  `is_amortissable` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `cg_fk_poste_code` (`fk_poste_code`),
  KEY `cg_idx_cg_code` (`cg_code`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=245 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cpt_tbl_compte_generique`
--

LOCK TABLES `cpt_tbl_compte_generique` WRITE;
/*!40000 ALTER TABLE `cpt_tbl_compte_generique` DISABLE KEYS */;
INSERT INTO `cpt_tbl_compte_generique` VALUES (1,'12','','ch',0),(2,'14','','cl',0),(3,'15','','cm',0),(4,'16','','da',0),(5,'17','','db',0),(6,'19','','dc',0),(7,'22','','aj',0),(8,'24','245-2495','am',0),(9,'25','','ap',0),(10,'26','','ar',0),(11,'27','','as',0),(12,'31','','bb',0),(13,'32','','bb',0),(14,'33','','bb',0),(15,'34','','bb',0),(16,'36','','bb',0),(17,'37','','bb',0),(18,'38','','bb',0),(19,'39','','bb',1),(20,'40','409','dj',0),(21,'41','419','bi',0),(22,'42','','bj',0),(23,'42','','dk',0),(24,'43','','bj',0),(25,'43','','dk',0),(26,'44','','dk',0),(27,'44','','dk',0),(28,'45','','bj',0),(29,'45','','dm',0),(30,'46','','dm',0),(31,'46','','dm',0),(32,'47','478','bj',0),(33,'47','479','dm',0),(34,'50','','bq',0),(35,'51','','br',0),(36,'52','','bs',0),(37,'52','','dr',0),(38,'53','','bs',0),(39,'53','','dr',0),(40,'54','','bs',0),(41,'55','','bs',0),(42,'57','','bs',0),(43,'61','','rg',0),(44,'62','','rh',0),(45,'63','','rh',0),(46,'64','','ri',0),(47,'65','','rj',0),(48,'66','','rk',0),(49,'67','','rm',0),(50,'71','','tg',0),(51,'72','','tf',0),(52,'73','','te',0),(53,'75','','th',0),(54,'77','','tk',0),(55,'81','','ro',0),(56,'82','','tn',0),(57,'83','','rp',0),(58,'84','','to',0),(59,'85','','rp',0),(60,'86','','to',0),(61,'87','','rq',0),(62,'89','','rs',0),(63,'101','','ca',0),(64,'102','','ca',0),(65,'103','','ca',0),(66,'104','','ca',0),(67,'105','','cd',0),(68,'106','','ce',0),(69,'109','','cb',0),(70,'111','','cf',0),(71,'112','','cf',0),(72,'113','','cf',0),(73,'118','','cg',0),(74,'131','','cj',0),(75,'139','','cj',0),(76,'181','','da',0),(77,'182','','da',0),(78,'183','','da',0),(79,'184','','da',0),(80,'185','','bj',0),(81,'185','','dm',0),(82,'186','','bj',0),(83,'186','','dm',0),(84,'187','','bj',0),(85,'187','','dm',0),(86,'188','','bj',0),(87,'188','','dm',0),(88,'211','','ae',0),(89,'212','','af',0),(90,'213','','af',0),(91,'214','','ae',0),(92,'215','','ag',0),(93,'216','','ag',0),(94,'217','','ah',0),(95,'218','','ah',0),(96,'231','','ak',0),(97,'232','','ak',0),(98,'233','','ak',0),(99,'234','','al',0),(100,'235','','al',0),(101,'236','','al',0),(102,'237','','ak',0),(103,'237','','al',0),(104,'245','','an',0),(105,'282','','aj',1),(106,'284','2845','am',1),(107,'292','','aj',1),(108,'294','2945','am',1),(109,'295','','ap',1),(110,'296','','ar',1),(111,'297','','as',1),(112,'409','','bh',0),(113,'419','','di',0),(114,'478','','bu',0),(115,'479','','dv',0),(116,'481','','dh',0),(117,'482','','dh',0),(118,'483','','dh',0),(119,'484','','dh',0),(120,'485','','ba',0),(121,'486','','ba',0),(122,'488','','ba',0),(123,'490','','bh',1),(124,'491','','bi',1),(125,'492','','bj',1),(126,'493','','bj',1),(127,'494','','bj',1),(128,'495','','bj',1),(129,'496','','bj',1),(130,'497','','bj',1),(131,'498','','ba',1),(132,'499','4998','dn',0),(133,'561','','dr',0),(134,'564','','dq',0),(135,'565','','dq',0),(136,'566','','dr',0),(137,'581','','bs',0),(138,'582','','bs',0),(139,'585','','fi',0),(140,'588','','fi',0),(141,'590','','bq',1),(142,'591','','br',1),(143,'592','','bs',1),(144,'593','','bs',1),(145,'594','','bs',1),(146,'599','','dn',0),(147,'601','','ra',0),(148,'602','','rc',0),(149,'604','','re',0),(150,'605','','re',0),(151,'608','','re',0),(152,'681','','rl',0),(153,'687','','rn',0),(154,'691','','rl',0),(155,'697','','rn',0),(156,'701','','ta',0),(157,'702','','tb',0),(158,'703','','tb',0),(159,'704','','tb',0),(160,'705','','tc',0),(161,'706','','tc',0),(162,'707','','td',0),(163,'781','','ti',0),(164,'787','','tm',0),(165,'791','','tj',0),(166,'797','','tl',0),(167,'798','','tj',0),(168,'2191','','ae',0),(169,'2193','','af',0),(170,'2198','','ah',0),(171,'2391','','al',0),(172,'2495','','an',0),(173,'2811','','ae',1),(174,'2812','','af',1),(175,'2813','','af',1),(176,'2814','','af',1),(177,'2815','','ag',1),(178,'2816','','ag',1),(179,'2817','','ah',1),(180,'2818','','ah',1),(181,'2831','','ak',1),(182,'2832','','ak',1),(183,'2832','','al',1),(184,'2833','','ak',1),(185,'2833','','al',1),(186,'2834','','al',1),(187,'2835','','al',1),(188,'2836','','al',1),(189,'2837','','ak',1),(190,'2837','','al',1),(191,'2845','','an',1),(192,'2912','','af',1),(193,'2913','','af',1),(194,'2914','','af',1),(195,'2915','','ag',1),(196,'2916','','ag',1),(197,'2917','','ah',1),(198,'2918','','ah',1),(199,'2931','','ak',1),(200,'2931','','al',1),(201,'2932','','ak',1),(202,'2932','','al',1),(203,'2933','','ak',1),(204,'2933','','al',1),(205,'2937','','ak',1),(206,'2937','','al',1),(207,'2945','','an',1),(208,'4998','','dh',0),(209,'6031','','rb',0),(210,'6032','','rd',0),(211,'6033','','rf',0),(212,'23911','','ak',0),(213,'29191','','ae',1),(214,'29192','','af',1),(215,'29193','','ah',1),(216,'29391','','ak',1),(217,'29392','','al',1),(218,'29491','','an',1),(219,'13','','fi',0),(220,'2395','','al',0),(221,'65','','ea',0),(222,'75','','eb',0),(223,'77','776','ec',0),(224,'77','','ed',0),(225,'787','','ef',0),(226,'84','848','eg',0),(227,'86','','eg',0),(228,'84','','eh',0),(229,'85','','ei',0),(230,'83','','ei',0),(231,'67','679-676','ej',0),(232,'67','','ek',0),(233,'67','','el',0),(234,'87','','em',0),(235,'89','','en',0),(236,'47','','mf',0),(237,'47','','mm',0),(238,'47','','mn',0),(239,'16','','mo',0),(240,'16','','fo',0),(241,'181','','fp',0),(242,'182','','fp',0),(243,'183','','fp',0),(244,'184','','fp',0);
/*!40000 ALTER TABLE `cpt_tbl_compte_generique` ENABLE KEYS */;
UNLOCK TABLES;
/*!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-05-06 22:45:26
