-- MySQL dump 10.13  Distrib 5.7.16, for Win32 (AMD64)
--
-- Host: 127.0.0.1    Database: symp_dossier1_2023
-- ------------------------------------------------------
-- Server version	5.7.16-log

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

DROP TABLE IF EXISTS `achats`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `achats` (
  `ID_achat` int(11) NOT NULL AUTO_INCREMENT,
  `date_achat` date DEFAULT NULL,
  `type_achat` varchar(50) DEFAULT '',
  `Mode_reglement` varchar(50) DEFAULT '0',
  `Total_TTC` double DEFAULT '0',
  `TVA` double DEFAULT '0',
  `Timbre` double DEFAULT '0',
  `Exonoration_fisacle` tinyint(3) unsigned DEFAULT '0',
  `IDFournisseur` int(11) DEFAULT '0',
  `MONTANT_regler` double DEFAULT '0',
  `Reste_a_regeler` double DEFAULT '0',
  `Notes` longtext,
  `NUM_Piece` varchar(20) DEFAULT '',
  `sens` varchar(50) DEFAULT '',
  `mois_achat` varchar(50) DEFAULT '',
  `transf` varchar(20) DEFAULT '',
  `date_achats_frs` date DEFAULT NULL,
  `Ref_piece_fournisseur` varchar(50) DEFAULT '',
  `Nom_RS` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `FLAG_STOCK` varchar(3) DEFAULT '',
  `PIECE_ORIGINE` varchar(100) DEFAULT '',
  `FLAG_CA` varchar(50) DEFAULT '',
  `Origine_impc_st` varchar(50) DEFAULT '',
  `STK_Ipmacte` int(11) DEFAULT '0',
  `CA_Impact_A` int(11) DEFAULT '0',
  `ANNEE_CREATE` varchar(50) DEFAULT '',
  `ID_DEPOT_A` int(11) DEFAULT '0',
  `Total_HT` double DEFAULT '0',
  `date_echeance` date DEFAULT NULL,
  `AVEC_Contrat` tinyint(4) DEFAULT '0',
  `ID_DEM_Paie` int(11) DEFAULT '0',
  `Clauses` varchar(250) DEFAULT '',
  `Modalite_de_paiement` varchar(250) DEFAULT '',
  `Delai_de_livraison` varchar(250) DEFAULT '',
  `Votre_offre_N` varchar(50) DEFAULT '',
  `REGULARISATION` varchar(250) DEFAULT '',
  `IDStucture_INPUTATION` int(11) DEFAULT '0',
  `date_heur_creation` datetime(3) DEFAULT NULL,
  `Num_BLAch` varchar(50) DEFAULT '',
  `ETAT_PIECE` varchar(50) DEFAULT '',
  `Total_TUAR` double DEFAULT '0',
  `Activer_l_alerte` tinyint(4) DEFAULT '0',
  `Jour_avant_la_date` int(11) DEFAULT '0',
  `nBR_Delai_paiement` int(11) DEFAULT '0',
  PRIMARY KEY (`ID_achat`),
  KEY `WDIDX17062999670` (`date_achat`),
  KEY `WDIDX17062999681` (`type_achat`),
  KEY `WDIDX17062999702` (`IDFournisseur`),
  KEY `WDIDX17062999713` (`NUM_Piece`),
  KEY `WDIDX17062999734` (`sens`),
  KEY `WDIDX17062999755` (`mois_achat`),
  KEY `WDIDX17062999756` (`transf`),
  KEY `WDIDX17062999757` (`Nom_RS`),
  KEY `WDIDX17062999758` (`FLAG_STOCK`),
  KEY `WDIDX17062999759` (`FLAG_CA`),
  KEY `WDIDX170629997510` (`Origine_impc_st`),
  KEY `WDIDX170629997511` (`ID_DEPOT_A`),
  KEY `WDIDX170629997512` (`ID_DEM_Paie`),
  KEY `WDIDX170629997513` (`IDStucture_INPUTATION`),
  KEY `WDIDX170629997514` (`Num_BLAch`),
  KEY `WDIDX170629997515` (`ETAT_PIECE`),
  KEY `IDX_achats_flag_stock` (`FLAG_STOCK`),
  KEY `IDX_achats_sens` (`sens`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `achats`
--

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

--
-- Table structure for table `adresse_facturation`
--

DROP TABLE IF EXISTS `adresse_facturation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `adresse_facturation` (
  `IDAdresse_facturation` int(11) NOT NULL AUTO_INCREMENT,
  `Adresse` longtext CHARACTER SET utf8,
  `ville` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `IDClient` int(11) DEFAULT '0',
  PRIMARY KEY (`IDAdresse_facturation`),
  KEY `WDIDX170629997516` (`IDClient`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `adresse_facturation`
--

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

--
-- Table structure for table `adresse_livraison`
--

DROP TABLE IF EXISTS `adresse_livraison`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `adresse_livraison` (
  `idadresse_livraison` bigint(20) NOT NULL AUTO_INCREMENT,
  `nom_depot_livraison` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `adresse_livraison` longtext CHARACTER SET ucs2,
  `code_postal` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `coord_gps_lat` float DEFAULT '0',
  `coord_gps_long` float DEFAULT '0',
  `Idwilaya` bigint(20) DEFAULT '0',
  `Idpays` bigint(20) DEFAULT '0',
  `IDClient` int(11) DEFAULT '0',
  `tel_fix_cl` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `tel_mob_cl` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `fax_cl` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `contact_personne` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`idadresse_livraison`),
  KEY `WDIDX170629997517` (`Idwilaya`),
  KEY `WDIDX170629997518` (`Idpays`),
  KEY `WDIDX170629997519` (`IDClient`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `adresse_livraison`
--

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

--
-- Table structure for table `agent_fiche_test_ns`
--

DROP TABLE IF EXISTS `agent_fiche_test_ns`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `agent_fiche_test_ns` (
  `IDliste_fiche_test_ns` bigint(20) DEFAULT '0',
  `IDagent_interne` bigint(20) DEFAULT '0',
  `idagent_fiche_test` int(11) NOT NULL AUTO_INCREMENT,
  `qualitee` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`idagent_fiche_test`),
  KEY `WDIDX170629997520` (`IDliste_fiche_test_ns`),
  KEY `WDIDX170629997521` (`IDagent_interne`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `agent_fiche_test_ns`
--

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

--
-- Table structure for table `article`
--

DROP TABLE IF EXISTS `article`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `article` (
  `IDArticle` bigint(20) NOT NULL AUTO_INCREMENT,
  `REF_article` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `Designation` longtext CHARACTER SET ucs2,
  `Unite_m` varchar(50) CHARACTER SET ucs2 DEFAULT NULL,
  `Poids` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `Prix_achat` decimal(24,6) DEFAULT '0.000000',
  `Stock_real` double DEFAULT '0',
  `Stock_theorique` double DEFAULT '0',
  `Qte_min` double DEFAULT '0',
  `Qte_colis` float DEFAULT '0',
  `Qte_initiale` float DEFAULT '0',
  `IDFTVA` int(11) DEFAULT '0',
  `photo` longblob,
  `desCRIPTION` longtext CHARACTER SET utf8,
  `IDFamille` int(11) DEFAULT '0',
  `Art_compose` varchar(3) DEFAULT '',
  `Localisation` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `CodeBarresmatrix` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `CodeBarreschiffre` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `Gestion_stocks` varchar(50) DEFAULT 'OUI',
  `PMP` decimal(24,6) DEFAULT '0.000000',
  `Mode_calc_prix` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `FLAG_SUPPR` int(11) DEFAULT '0',
  `Type_code_barre` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `Calculer_marge_vente` tinyint(4) DEFAULT '1',
  `Frais_production` double DEFAULT '0',
  `TAXE_Supp_TUAR` double DEFAULT '0',
  `detail_description` longtext CHARACTER SET utf8,
  `avec_Num_Serie` tinyint(4) DEFAULT '0',
  `avec_Autorisation` tinyint(4) DEFAULT '0',
  `date_autorisation` date DEFAULT NULL,
  `num_autorisation` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `creat_ns_auto` tinyint(4) DEFAULT '0',
  `radical_ns_auto` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `taille_ns_auto` int(11) DEFAULT '0',
  `categori_art` int(11) DEFAULT '1',
  `libelle_arabe` varchar(150) CHARACTER SET ucs2 DEFAULT '',
  `IDtype_composant` bigint(20) DEFAULT '0',
  PRIMARY KEY (`IDArticle`),
  UNIQUE KEY `REF_article` (`REF_article`),
  KEY `WDIDX170629997523` (`Unite_m`),
  KEY `WDIDX170629997524` (`IDFTVA`),
  KEY `WDIDX170629997525` (`IDFamille`),
  KEY `WDIDX170629997526` (`Art_compose`),
  KEY `WDIDX170629997527` (`CodeBarreschiffre`),
  KEY `WDIDX170629997528` (`Gestion_stocks`),
  KEY `WDIDX170629997529` (`Mode_calc_prix`),
  KEY `WDIDX170629997530` (`FLAG_SUPPR`),
  KEY `WDIDX170629997531` (`Type_code_barre`),
  KEY `WDIDX170629997532` (`IDtype_composant`),
  KEY `IDX_article_Unite_m` (`Unite_m`),
  KEY `IDX_article_Art_compose` (`Art_compose`),
  KEY `IDX_article_Gestion_stocks` (`Gestion_stocks`),
  KEY `IDX_article_Mode_calc_prix` (`Mode_calc_prix`),
  KEY `IDX_article_FLAG_SUPPR` (`FLAG_SUPPR`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `article`
--

LOCK TABLES `article` WRITE;
/*!40000 ALTER TABLE `article` DISABLE KEYS */;
INSERT INTO `article` VALUES (1,'ART-0001','armoire 23 40','Unité','0',300.000000,0,0,0,1,0,1,NULL,'{\\rtf1\\ansi\\ansicpg1252\\deff0\\deflang1036{\\fonttbl{\\f0\\fnil\\fcharset0 MS Shell Dlg;}}\r\n{\\*\\generator Msftedit 5.41.21.2510;}\\viewkind4\\uc1\\pard\\f0\\fs17\\par\r\n}\r\n',NULL,'','','','','OUI',300.000000,'T',0,'0',1,0,0,'{\\rtf1\\ansi\\ansicpg1252\\deff0\\deflang1036{\\fonttbl{\\f0\\fnil\\fcharset0 MS Shell Dlg;}}\r\n{\\*\\generator Msftedit 5.41.21.2510;}\\viewkind4\\uc1\\pard\\f0\\fs17\\par\r\n}\r\n',0,0,NULL,'',0,'',0,1,'',0),(2,'ART-0002','bureau administratif','Unité','0',0.000000,0,0,0,1,0,1,NULL,'{\\rtf1\\ansi\\ansicpg1252\\deff0\\nouicompat\\deflang1036{\\fonttbl{\\f0\\fnil\\fcharset0 MS Shell Dlg;}}\r\n{\\*\\generator Riched20 10.0.19041}\\viewkind4\\uc1 \r\n\\pard\\f0\\fs16\\par\r\n}\r\n',NULL,'','','','','OUI',0.000000,'T',0,'0',1,0,0,'{\\rtf1\\ansi\\ansicpg1252\\deff0\\nouicompat\\deflang1036{\\fonttbl{\\f0\\fnil\\fcharset0 MS Shell Dlg;}}\r\n{\\*\\generator Riched20 10.0.19041}\\viewkind4\\uc1 \r\n\\pard\\f0\\fs16\\par\r\n}\r\n',0,0,NULL,'',0,'',0,1,'',0);
/*!40000 ALTER TABLE `article` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `article_compose`
--

DROP TABLE IF EXISTS `article_compose`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `article_compose` (
  `IDArticle_compose` int(11) NOT NULL AUTO_INCREMENT,
  `ref_article_article` varchar(50) DEFAULT '',
  `ref_art_compo` varchar(50) DEFAULT '',
  `Designation` longtext,
  `qte` float DEFAULT '0',
  `Prix_achat` decimal(24,6) DEFAULT '0.000000',
  `PHT` decimal(24,6) DEFAULT '0.000000',
  PRIMARY KEY (`IDArticle_compose`),
  KEY `WDIDX170629997533` (`ref_article_article`),
  KEY `WDIDX170629997534` (`ref_art_compo`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `article_compose`
--

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

--
-- Table structure for table `article_consomme_carting`
--

DROP TABLE IF EXISTS `article_consomme_carting`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `article_consomme_carting` (
  `idcarting_restaurant` bigint(20) DEFAULT '0',
  `idArticle` bigint(20) DEFAULT '0',
  `idart_consom_catring` int(11) NOT NULL AUTO_INCREMENT,
  `quantitee` double DEFAULT '0',
  `prix_u_ach` double DEFAULT '0',
  `iddepot` int(11) DEFAULT '0',
  PRIMARY KEY (`idart_consom_catring`),
  KEY `WDIDX170629997535` (`idcarting_restaurant`),
  KEY `WDIDX170629997536` (`idArticle`),
  KEY `WDIDX170629997537` (`iddepot`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `article_consomme_carting`
--

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

--
-- Table structure for table `article_defau_catring`
--

DROP TABLE IF EXISTS `article_defau_catring`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `article_defau_catring` (
  `IDarticle_defau_catring` bigint(20) NOT NULL AUTO_INCREMENT,
  `id_article` varchar(50) DEFAULT '',
  `type_liste` varchar(50) DEFAULT '',
  PRIMARY KEY (`IDarticle_defau_catring`),
  KEY `WDIDX170629997538` (`id_article`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `article_defau_catring`
--

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

--
-- Table structure for table `article_etape_prod`
--

DROP TABLE IF EXISTS `article_etape_prod`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `article_etape_prod` (
  `idarticle_etape_prod` bigint(20) NOT NULL AUTO_INCREMENT,
  `idetaprs_production` bigint(20) DEFAULT '0',
  `dure_nb` varchar(50) DEFAULT '',
  `dure_jour_mois` varchar(50) DEFAULT '',
  `IDArticle` bigint(20) DEFAULT '0',
  `num_etap` int(11) DEFAULT '0',
  `cout_heure` float DEFAULT '0',
  `Cout_heur_outil` int(11) DEFAULT '0',
  PRIMARY KEY (`idarticle_etape_prod`),
  KEY `WDIDX170629997539` (`idetaprs_production`),
  KEY `WDIDX170629997540` (`IDArticle`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `article_etape_prod`
--

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

--
-- Table structure for table `article_produit_carting`
--

DROP TABLE IF EXISTS `article_produit_carting`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `article_produit_carting` (
  `IDcarting_restaurant` bigint(20) DEFAULT '0',
  `IDArticle` bigint(20) DEFAULT '0',
  `IDart_prod_catring` int(11) NOT NULL AUTO_INCREMENT,
  `quantitee` double DEFAULT '0',
  `iddepot` int(11) DEFAULT '0',
  `Prix_vent_actu` float DEFAULT '0',
  PRIMARY KEY (`IDart_prod_catring`),
  KEY `WDIDX170629997541` (`IDcarting_restaurant`),
  KEY `WDIDX170629997542` (`IDArticle`),
  KEY `WDIDX170629997543` (`iddepot`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `article_produit_carting`
--

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

--
-- Table structure for table `article_tarif_location`
--

DROP TABLE IF EXISTS `article_tarif_location`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `article_tarif_location` (
  `IDarticle_tarif_location` bigint(20) NOT NULL AUTO_INCREMENT,
  `IDListe_Types_Prix_tarifs` int(11) DEFAULT '0',
  `IDArticle` bigint(20) DEFAULT '0',
  `prix_ht_loc` double DEFAULT '0',
  `prix_ttc_loc` double DEFAULT '0',
  `prix_uht_caution` double DEFAULT '0',
  `prix_uht_panalite_retard` double DEFAULT '0',
  PRIMARY KEY (`IDarticle_tarif_location`),
  KEY `WDIDX170629997544` (`IDListe_Types_Prix_tarifs`),
  KEY `WDIDX170629997545` (`IDArticle`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `article_tarif_location`
--

LOCK TABLES `article_tarif_location` WRITE;
/*!40000 ALTER TABLE `article_tarif_location` DISABLE KEYS */;
INSERT INTO `article_tarif_location` VALUES (1,1,1,0,0,0,0),(2,2,1,0,0,0,0),(3,3,1,0,0,0,0),(4,1,2,0,0,0,0),(5,2,2,0,0,0,0),(6,3,2,0,0,0,0);
/*!40000 ALTER TABLE `article_tarif_location` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `article_types_prix_tarifs`
--

DROP TABLE IF EXISTS `article_types_prix_tarifs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `article_types_prix_tarifs` (
  `IDArticle` bigint(20) DEFAULT '0',
  `IDListe_Types_Prix_tarifs` int(11) DEFAULT '0',
  `id_Article_typs_prix` int(11) NOT NULL AUTO_INCREMENT,
  `Taux_Marge` float NOT NULL DEFAULT '0',
  `Prix_HT` double NOT NULL DEFAULT '0',
  `Prix_TTC` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_Article_typs_prix`),
  KEY `WDIDX170629997546` (`IDArticle`),
  KEY `WDIDX170629997547` (`IDListe_Types_Prix_tarifs`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `article_types_prix_tarifs`
--

LOCK TABLES `article_types_prix_tarifs` WRITE;
/*!40000 ALTER TABLE `article_types_prix_tarifs` DISABLE KEYS */;
INSERT INTO `article_types_prix_tarifs` VALUES (1,1,1,5,315,315),(1,2,2,6,318,318),(1,3,3,7,321,321),(2,1,4,0,0,0),(2,2,5,0,0,0),(2,3,6,0,0,0);
/*!40000 ALTER TABLE `article_types_prix_tarifs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `articles_a_consommer`
--

DROP TABLE IF EXISTS `articles_a_consommer`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `articles_a_consommer` (
  `IDArticles_a_consommer` bigint(20) NOT NULL AUTO_INCREMENT,
  `qutit_A_Consom` double DEFAULT '0',
  `qutit_A_Rebut` double DEFAULT '0',
  `IDArticle` bigint(20) DEFAULT '0',
  `IDOrdres_Fabrication` bigint(20) DEFAULT '0',
  `qtt_mono` double DEFAULT '0',
  `qtt_planifier` double DEFAULT '0',
  PRIMARY KEY (`IDArticles_a_consommer`),
  KEY `WDIDX170629997548` (`IDArticle`),
  KEY `WDIDX170629997549` (`IDOrdres_Fabrication`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `articles_a_consommer`
--

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

--
-- Table structure for table `articles_conssomme`
--

DROP TABLE IF EXISTS `articles_conssomme`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `articles_conssomme` (
  `IDArticles_Conssomme` bigint(20) NOT NULL AUTO_INCREMENT,
  `quantit_Article_Consomme` double DEFAULT '0',
  `quant_rebut` double DEFAULT '0',
  `IDArticle` bigint(20) DEFAULT '0',
  `IDOrdres_Fabrication` bigint(20) DEFAULT '0',
  `prix_ach_PUMP` decimal(24,6) DEFAULT '0.000000',
  `qtt_Refe_prod` double DEFAULT '0',
  `id_depot_rebut` int(11) DEFAULT '0',
  `IDProduit_fabrique_par_of` bigint(20) DEFAULT '0',
  PRIMARY KEY (`IDArticles_Conssomme`),
  KEY `WDIDX170629997650` (`IDArticle`),
  KEY `WDIDX170629997651` (`IDOrdres_Fabrication`),
  KEY `WDIDX170629997652` (`IDProduit_fabrique_par_of`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `articles_conssomme`
--

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

--
-- Table structure for table `bon_commande_temp`
--

DROP TABLE IF EXISTS `bon_commande_temp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bon_commande_temp` (
  `IDBon_commande_temp` bigint(20) NOT NULL AUTO_INCREMENT,
  `text_jeson` longtext,
  `id_orrigine` int(11) DEFAULT '0',
  `id_piece_destin` int(11) DEFAULT '0',
  PRIMARY KEY (`IDBon_commande_temp`),
  KEY `WDIDX170629997653` (`id_orrigine`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bon_commande_temp`
--

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

--
-- Table structure for table `categorie_operation`
--

DROP TABLE IF EXISTS `categorie_operation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `categorie_operation` (
  `idcategorie_operation` bigint(20) NOT NULL AUTO_INCREMENT,
  `nom_categ` varchar(50) CHARACTER SET ucs2 DEFAULT '',
  `desciption` longtext CHARACTER SET ucs2,
  `code_categ` varchar(50) DEFAULT '',
  PRIMARY KEY (`idcategorie_operation`),
  KEY `WDIDX170629997654` (`code_categ`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `categorie_operation`
--

LOCK TABLES `categorie_operation` WRITE;
/*!40000 ALTER TABLE `categorie_operation` DISABLE KEYS */;
INSERT INTO `categorie_operation` VALUES (1,'Règlement achat',NULL,'RA'),(2,'Règlement vente',NULL,'RV');
/*!40000 ALTER TABLE `categorie_operation` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `categories_articles`
--

DROP TABLE IF EXISTS `categories_articles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `categories_articles` (
  `IDcategories_articles` bigint(20) NOT NULL AUTO_INCREMENT,
  `code_categ` varchar(50) DEFAULT '',
  `libelle_cat` varchar(250) CHARACTER SET ucs2 DEFAULT '',
  `description_cat` longtext CHARACTER SET ucs2,
  `can_modif` varchar(50) DEFAULT '',
  `vdef_Ach` int(11) DEFAULT '0',
  `vdef_ven` int(11) DEFAULT '0',
  PRIMARY KEY (`IDcategories_articles`),
  KEY `WDIDX170629997655` (`code_categ`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `categories_articles`
--

LOCK TABLES `categories_articles` WRITE;
/*!40000 ALTER TABLE `categories_articles` DISABLE KEYS */;
INSERT INTO `categories_articles` VALUES (1,'STD','Articles Standards','Articles Standards','NON',1,1),(2,'CTR','Produits de Cuisine','Produits de Cuisine','NON',0,0),(3,'LOC','Article de Location et Outillage','Article de Location et Outillage','NON',0,0);
/*!40000 ALTER TABLE `categories_articles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `catring_restaurant`
--

DROP TABLE IF EXISTS `catring_restaurant`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `catring_restaurant` (
  `IDcarting_restaurant` bigint(20) NOT NULL AUTO_INCREMENT,
  `date_cat` date DEFAULT NULL,
  `etat` varchar(50) DEFAULT '0',
  `libelle_cat` varchar(250) DEFAULT '',
  `notes_cat` longtext CHARACTER SET ucs2,
  `num_cat` varchar(50) DEFAULT '',
  `annee_cat` varchar(50) DEFAULT '',
  `Mois_cat` varchar(50) DEFAULT '',
  `preparateur` int(11) DEFAULT '0',
  PRIMARY KEY (`IDcarting_restaurant`),
  KEY `WDIDX170629997656` (`preparateur`),
  KEY `IDX_catring_restaurant_etat` (`etat`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `catring_restaurant`
--

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

--
-- Table structure for table `cautions`
--

DROP TABLE IF EXISTS `cautions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cautions` (
  `idcautions` bigint(20) NOT NULL AUTO_INCREMENT,
  `idclient` int(11) DEFAULT '0',
  `date_contrat_fact` date DEFAULT NULL,
  `numero_contra_fact` varchar(50) DEFAULT '',
  `date_deb_valid` date DEFAULT NULL,
  `date_fin_valid` date DEFAULT NULL,
  `montant_caution` double DEFAULT '0',
  `montant_restant` double DEFAULT '0',
  `num_autoris_retrait` varchar(50) DEFAULT '',
  `date_autoris_retrait` date DEFAULT NULL,
  `id_vente` int(11) DEFAULT '0',
  `creer_le` datetime(3) DEFAULT NULL,
  `modif_le` datetime(3) DEFAULT NULL,
  `creer_par` varchar(50) DEFAULT '',
  `modif_par` varchar(50) DEFAULT '',
  `active_alerte` tinyint(4) DEFAULT '0',
  `jour_alerte_avant_fin` int(11) DEFAULT '0',
  `notes` longtext CHARACTER SET ucs2,
  PRIMARY KEY (`idcautions`),
  KEY `WDIDX170629997657` (`idclient`),
  KEY `WDIDX170629997658` (`id_vente`),
  KEY `idclient` (`idclient`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cautions`
--

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

--
-- Table structure for table `civilite`
--

DROP TABLE IF EXISTS `civilite`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `civilite` (
  `idcivilite` bigint(20) NOT NULL AUTO_INCREMENT,
  `designation_civil` varchar(50) CHARACTER SET ucs2 DEFAULT '',
  `designation_civil_ar` varchar(50) CHARACTER SET ucs2 DEFAULT '',
  PRIMARY KEY (`idcivilite`),
  KEY `WDIDX170629997659` (`designation_civil`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `civilite`
--

LOCK TABLES `civilite` WRITE;
/*!40000 ALTER TABLE `civilite` DISABLE KEYS */;
INSERT INTO `civilite` VALUES (1,'Monsieur',''),(2,'Mme',''),(3,'Melle','');
/*!40000 ALTER TABLE `civilite` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `client`
--

DROP TABLE IF EXISTS `client`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `client` (
  `IDClient` int(11) NOT NULL AUTO_INCREMENT,
  `Nom_RS` varchar(200) CHARACTER SET utf8 DEFAULT NULL,
  `Adresse` longtext CHARACTER SET utf8,
  `tel` varchar(50) DEFAULT '',
  `Fax` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `RCcommerce` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `IDFical` varchar(50) DEFAULT '',
  `art_imposition` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `agence_banque` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `Num_compte` varchar(50) DEFAULT '',
  `Chiffre_affaire` decimal(24,6) DEFAULT '0.000000',
  `solde` decimal(24,6) DEFAULT '0.000000',
  `Mob` varchar(50) DEFAULT '',
  `Tarif_applique` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `NIS` varchar(50) DEFAULT '',
  `Titre_client` varchar(50) DEFAULT '',
  `mail` varchar(50) DEFAULT '',
  `site_web` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `Code_cl` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `reserve_compte` double DEFAULT '0',
  `total_tc` double DEFAULT '0',
  `solde_initial` float DEFAULT '0',
  `localite_client` int(11) DEFAULT '0',
  `activitee` longtext CHARACTER SET ucs2,
  `code_postal` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `coord_gps_lat` float DEFAULT '0',
  `coord_gps_long` float DEFAULT '0',
  `Idwilaya` bigint(20) DEFAULT '0',
  `Idpays` bigint(20) DEFAULT '0',
  `responsable` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `nom_cl_ar` varchar(50) CHARACTER SET ucs2 DEFAULT '',
  `ntin` varchar(20) DEFAULT '',
  `ncarte_Felleh` varchar(20) DEFAULT '',
  `obl_sai_rcommerce` tinyint(4) DEFAULT '0',
  `obl_sai_ncart_fellah` tinyint(4) DEFAULT '0',
  `obl_sai_idfiscal` tinyint(4) DEFAULT '0',
  `obl_sai_art_impos` tinyint(4) DEFAULT '0',
  `obl_sai_n_tin` tinyint(4) DEFAULT '0',
  `obl_sai_nis` tinyint(4) DEFAULT '0',
  `obl_sai_n_agrement` tinyint(4) DEFAULT '0',
  `n_agrement` varchar(50) CHARACTER SET ucs2 DEFAULT '',
  PRIMARY KEY (`IDClient`),
  KEY `WDIDX170629997660` (`Nom_RS`),
  KEY `WDIDX170629997661` (`RCcommerce`),
  KEY `WDIDX170629997662` (`IDFical`),
  KEY `WDIDX170629997663` (`art_imposition`),
  KEY `WDIDX170629997664` (`Tarif_applique`),
  KEY `WDIDX170629997665` (`NIS`),
  KEY `WDIDX170629997666` (`Titre_client`),
  KEY `WDIDX170629997667` (`Code_cl`),
  KEY `WDIDX170629997668` (`Idwilaya`),
  KEY `WDIDX170629997669` (`Idpays`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `client`
--

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

--
-- Table structure for table `codes_barres_supplementaires`
--

DROP TABLE IF EXISTS `codes_barres_supplementaires`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `codes_barres_supplementaires` (
  `IDCodes_barres_supplementaires` int(11) NOT NULL AUTO_INCREMENT,
  `Code_barre_suppl` varchar(50) DEFAULT '',
  `DEscription_CB` varchar(100) DEFAULT '',
  `IDArticle` bigint(20) DEFAULT '0',
  PRIMARY KEY (`IDCodes_barres_supplementaires`),
  KEY `WDIDX170629997670` (`IDArticle`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `codes_barres_supplementaires`
--

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

--
-- Table structure for table `compteur`
--

DROP TABLE IF EXISTS `compteur`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `compteur` (
  `IDCOMPTEUR` int(11) NOT NULL AUTO_INCREMENT,
  `CP_BON_caisse_CLI` int(11) DEFAULT '0',
  `CP_FACTURE_CLI` int(11) DEFAULT '0',
  `CP_FACURE_FRS` int(11) DEFAULT '0',
  `CP_AVOIR_FRS` int(11) DEFAULT '0',
  `cp_avoit_cl` int(11) DEFAULT '0',
  `CP_BCAISSE_FRS` int(11) DEFAULT '0',
  `DEVIS_CL` int(11) DEFAULT '0',
  `DEVIS_FRS` int(11) DEFAULT '0',
  `BON_Vente_COMP` int(11) DEFAULT '0',
  `piece_vente_comp` int(11) DEFAULT '0',
  PRIMARY KEY (`IDCOMPTEUR`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `compteur`
--

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

--
-- Table structure for table `compteur_`
--

DROP TABLE IF EXISTS `compteur_`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `compteur_` (
  `IDCOMPTEUR_` int(11) NOT NULL AUTO_INCREMENT,
  `type_compt` varchar(50) DEFAULT '',
  `dernier_num` int(11) DEFAULT '0',
  PRIMARY KEY (`IDCOMPTEUR_`),
  KEY `WDIDX170629997671` (`type_compt`),
  KEY `WDIDX170629997672` (`dernier_num`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `compteur_`
--

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

--
-- Table structure for table `dechet_a_generer_of`
--

DROP TABLE IF EXISTS `dechet_a_generer_of`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dechet_a_generer_of` (
  `IDDechet_of` bigint(20) NOT NULL AUTO_INCREMENT,
  `quantit_dechet` double DEFAULT '0',
  `IDArticle` bigint(20) DEFAULT '0',
  `IDOrdres_Fabrication` bigint(20) DEFAULT '0',
  `qtt_mono` double DEFAULT '0',
  PRIMARY KEY (`IDDechet_of`),
  KEY `WDIDX170629997673` (`IDArticle`),
  KEY `WDIDX170629997674` (`IDOrdres_Fabrication`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dechet_a_generer_of`
--

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

--
-- Table structure for table `dechet_generee_of`
--

DROP TABLE IF EXISTS `dechet_generee_of`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dechet_generee_of` (
  `IDDechet_Generee_OF` int(11) NOT NULL AUTO_INCREMENT,
  `quantitee` double DEFAULT '0',
  `IDArticle` bigint(20) DEFAULT '0',
  `IDOrdres_Fabrication` bigint(20) DEFAULT '0',
  `prix_ach_PUMP` decimal(24,6) DEFAULT '0.000000',
  `quantit_ref_prod` float DEFAULT '0',
  `IDProduit_fabrique_par_of` bigint(20) DEFAULT '0',
  PRIMARY KEY (`IDDechet_Generee_OF`),
  KEY `WDIDX170629997675` (`IDArticle`),
  KEY `WDIDX170629997676` (`IDOrdres_Fabrication`),
  KEY `WDIDX170629997677` (`IDProduit_fabrique_par_of`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dechet_generee_of`
--

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

--
-- Table structure for table `dechet_nomoclat`
--

DROP TABLE IF EXISTS `dechet_nomoclat`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dechet_nomoclat` (
  `IDdechet_nomoclat` bigint(20) NOT NULL AUTO_INCREMENT,
  `Quantit_article_nomo` float DEFAULT '0',
  `IDArticle` bigint(20) DEFAULT '0',
  `IDNOMOCATURE_PROD` bigint(20) DEFAULT '0',
  PRIMARY KEY (`IDdechet_nomoclat`),
  KEY `WDIDX170629997678` (`IDArticle`),
  KEY `WDIDX170629997679` (`IDNOMOCATURE_PROD`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dechet_nomoclat`
--

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

--
-- Table structure for table `demande_payement`
--

DROP TABLE IF EXISTS `demande_payement`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `demande_payement` (
  `IDdemande_payement` int(11) NOT NULL AUTO_INCREMENT,
  `Service_demP` varchar(50) DEFAULT '',
  `Num_dem_paye` varchar(50) DEFAULT '',
  `Montant` double DEFAULT '0',
  `Libelle_DemPaye` varchar(250) DEFAULT '',
  `DemP_etabli_verif` varchar(250) DEFAULT '',
  `DemP_responsable_achat` varchar(250) DEFAULT '',
  `Nom_Banque` varchar(50) DEFAULT '',
  `Num_Cheque` varchar(50) DEFAULT '',
  `Date_Cheque` date DEFAULT NULL,
  `Num_Virement_Bnq` varchar(50) DEFAULT '',
  `Date_Virement_Bnq` date DEFAULT NULL,
  `nom_fournisseur` varchar(250) DEFAULT '',
  `date_demande` date DEFAULT NULL,
  `IDFournisseur` int(11) DEFAULT '0',
  `Montant_let` longtext,
  `Banque` varchar(250) DEFAULT '',
  `Attestation_S_F_N` varchar(250) DEFAULT '',
  `ID_Versement` int(11) DEFAULT '0',
  `num_B_livraison` varchar(100) DEFAULT '',
  `num_Bon_Entree` varchar(100) DEFAULT '',
  PRIMARY KEY (`IDdemande_payement`),
  KEY `WDIDX170629997680` (`Num_dem_paye`),
  KEY `WDIDX170629997681` (`IDFournisseur`),
  KEY `WDIDX170629997682` (`ID_Versement`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `demande_payement`
--

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

--
-- Table structure for table `detail_ach2`
--

DROP TABLE IF EXISTS `detail_ach2`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detail_ach2` (
  `ID_detail_ach` int(11) NOT NULL AUTO_INCREMENT,
  `id_article` int(11) DEFAULT NULL,
  `REF_article` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `Designation` longtext,
  `Qte_colis` varchar(50) DEFAULT '',
  `qte_achete` double DEFAULT '0',
  `prix_unitaire_un_article` decimal(24,6) DEFAULT '0.000000',
  `id_FRS` varchar(50) DEFAULT '',
  `TVA` decimal(24,6) DEFAULT '0.000000',
  `Montant_tt_un_article` decimal(24,6) DEFAULT '0.000000',
  `IDachats` int(11) DEFAULT '0',
  `Motant_qte_HT` decimal(24,6) DEFAULT '0.000000',
  `Montant_qte_TTC` decimal(24,6) DEFAULT '0.000000',
  `Total_tva_qte` decimal(24,6) DEFAULT '0.000000',
  `remise` float DEFAULT '0',
  `Marges` float DEFAULT '0',
  `Montant_marge` decimal(24,6) DEFAULT '0.000000',
  `NBR_COLIS` int(11) DEFAULT '0',
  `ID_P_RAT` int(11) DEFAULT '0',
  `Taxe_TUAR` double DEFAULT '0',
  `Unite_m` varchar(50) CHARACTER SET ucs2 DEFAULT NULL,
  PRIMARY KEY (`ID_detail_ach`),
  KEY `WDIDX170629997683` (`id_article`),
  KEY `WDIDX170629997684` (`REF_article`),
  KEY `WDIDX170629997685` (`id_FRS`),
  KEY `WDIDX170629997686` (`IDachats`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detail_ach2`
--

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

--
-- Table structure for table `detail_fiche_test_ns`
--

DROP TABLE IF EXISTS `detail_fiche_test_ns`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detail_fiche_test_ns` (
  `IDNum_Seri_Article_Depot` bigint(20) DEFAULT '0',
  `IDliste_fiche_test_ns` bigint(20) DEFAULT '0',
  `ID_detail_fiche_test_ns` bigint(20) NOT NULL AUTO_INCREMENT,
  `etat_result_test` varchar(50) DEFAULT '',
  `notes_test` varchar(250) DEFAULT '',
  `id_article` int(11) DEFAULT '0',
  `Quantit` float DEFAULT '0',
  `qualitee` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`ID_detail_fiche_test_ns`),
  KEY `WDIDX170629997687` (`IDNum_Seri_Article_Depot`),
  KEY `WDIDX170629997688` (`IDliste_fiche_test_ns`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detail_fiche_test_ns`
--

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

--
-- Table structure for table `detail_location_retitus`
--

DROP TABLE IF EXISTS `detail_location_retitus`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detail_location_retitus` (
  `IDdetail_location_retitus` bigint(20) NOT NULL AUTO_INCREMENT,
  `quantite` int(11) DEFAULT '0',
  `prix_u_loc` double DEFAULT '0',
  `prix_u_penalite` double DEFAULT '0',
  `etat_loc_rest` longtext CHARACTER SET ucs2,
  `desc_etat_loc_rest` longtext CHARACTER SET ucs2,
  `photo` longblob,
  `IDlocations_restitutions` bigint(20) DEFAULT '0',
  `IDArticle` bigint(20) DEFAULT '0',
  `IDLISTE_DEPOTS` int(11) DEFAULT '0',
  `prix_u_caution` double DEFAULT '0',
  `taux_tva` float DEFAULT '0',
  `taux_unit_marge` int(11) DEFAULT '0',
  `taux_remise` int(11) DEFAULT '0',
  `nbr_jours` int(11) DEFAULT '0',
  `id_ligne_location_ini` int(11) DEFAULT '0',
  `designation_article` longtext CHARACTER SET ucs2,
  PRIMARY KEY (`IDdetail_location_retitus`),
  KEY `WDIDX170629997689` (`IDlocations_restitutions`),
  KEY `WDIDX170629997690` (`IDArticle`),
  KEY `WDIDX170629997691` (`IDLISTE_DEPOTS`),
  KEY `WDIDX170629997692` (`taux_tva`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detail_location_retitus`
--

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

--
-- Table structure for table `detail_nomoclature`
--

DROP TABLE IF EXISTS `detail_nomoclature`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detail_nomoclature` (
  `IDdetail_nomoclature` bigint(20) NOT NULL AUTO_INCREMENT,
  `quantit_article` float DEFAULT '0',
  `IDArticle` bigint(20) DEFAULT '0',
  `IDNOMOCATURE_PROD` bigint(20) DEFAULT '0',
  PRIMARY KEY (`IDdetail_nomoclature`),
  KEY `WDIDX170629997793` (`IDArticle`),
  KEY `WDIDX170629997794` (`IDNOMOCATURE_PROD`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detail_nomoclature`
--

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

--
-- Table structure for table `detail_ordre_livraison`
--

DROP TABLE IF EXISTS `detail_ordre_livraison`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detail_ordre_livraison` (
  `IDDetail_ordre_livraison` int(11) NOT NULL AUTO_INCREMENT,
  `quant_Prevue` double DEFAULT '0',
  `quant_Livre` double DEFAULT '0',
  `MONTant_Det_Livr` double DEFAULT '0',
  `MONTANT_encaisse` double DEFAULT '0',
  `Solde_Client_date` double DEFAULT '0',
  `Prix_applique` double DEFAULT '0',
  `Date_livraison` date DEFAULT NULL,
  `IDORDRES_LIVRAISON` int(11) DEFAULT '0',
  `IDClient` int(11) DEFAULT '0',
  `id_BL_Gener` int(11) DEFAULT '0',
  PRIMARY KEY (`IDDetail_ordre_livraison`),
  KEY `WDIDX170629997795` (`IDORDRES_LIVRAISON`),
  KEY `WDIDX170629997796` (`IDClient`),
  KEY `WDIDX170629997797` (`id_BL_Gener`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detail_ordre_livraison`
--

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

--
-- Table structure for table `detail_transfert`
--

DROP TABLE IF EXISTS `detail_transfert`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detail_transfert` (
  `IDDetail_transfert` int(11) NOT NULL AUTO_INCREMENT,
  `id_article` int(11) DEFAULT '0',
  `Quantit_trans` varchar(50) DEFAULT '',
  `IDListe_des_transfert_quantit_` int(11) DEFAULT '0',
  PRIMARY KEY (`IDDetail_transfert`),
  KEY `WDIDX170629997798` (`id_article`),
  KEY `WDIDX170629997799` (`IDListe_des_transfert_quantit_`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detail_transfert`
--

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

--
-- Table structure for table `detail_v`
--

DROP TABLE IF EXISTS `detail_v`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detail_v` (
  `IDDetail_v` int(11) NOT NULL AUTO_INCREMENT,
  `id_article` int(11) DEFAULT NULL,
  `Designation` longtext CHARACTER SET ucs2,
  `REF_article` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `Qte_colis` varchar(50) DEFAULT '',
  `qte_vendu` double DEFAULT '0',
  `prix_unitaire_un_article` decimal(24,6) DEFAULT '0.000000',
  `id_client` varchar(50) DEFAULT '',
  `TVA` decimal(24,6) DEFAULT '0.000000',
  `Montant_tt_un_article` decimal(24,6) DEFAULT '0.000000',
  `IDVentes` int(11) DEFAULT '0',
  `Motant_qte_HT` decimal(24,6) DEFAULT '0.000000',
  `Montant_qte_TTC` decimal(24,6) DEFAULT '0.000000',
  `Total_tva_qte` decimal(24,6) DEFAULT '0.000000',
  `remise` float DEFAULT '0',
  `Marges` float DEFAULT '0',
  `Prix_unitaire_achat` decimal(24,6) DEFAULT '0.000000',
  `Montant_marge` decimal(24,6) DEFAULT '0.000000',
  `NBR_COLIs` int(11) DEFAULT '0',
  `desCRIPTION` longtext CHARACTER SET utf8,
  `ID_P_RAT` int(11) DEFAULT '0',
  `PRIX_REF_ART` decimal(24,6) DEFAULT '0.000000',
  `mont_Unit_Remise` float DEFAULT '0',
  `Taxe_TUAR` double DEFAULT '0',
  `pump_art` double DEFAULT '0',
  `id_depot` int(11) DEFAULT '0',
  `id_detail_comande` int(11) DEFAULT '0',
  `Unite_m` varchar(50) CHARACTER SET ucs2 DEFAULT NULL,
  `longueur_art` float DEFAULT '0',
  `largeur_art` float DEFAULT '0',
  `nom_cl_ar` varchar(50) CHARACTER SET ucs2 DEFAULT '',
  `ord_ligne` int(11) DEFAULT '0',
  `Prix_revendeur` float DEFAULT '0',
  PRIMARY KEY (`IDDetail_v`),
  KEY `WDIDX1706299977100` (`id_article`),
  KEY `WDIDX1706299977101` (`REF_article`),
  KEY `WDIDX1706299977102` (`id_client`),
  KEY `WDIDX1706299977103` (`IDVentes`),
  KEY `WDIDX1706299977104` (`id_depot`),
  KEY `WDIDX1706299977105` (`id_detail_comande`),
  KEY `WDIDX1706299977106` (`nom_cl_ar`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detail_v`
--

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

--
-- Table structure for table `document_jouin_pc`
--

DROP TABLE IF EXISTS `document_jouin_pc`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `document_jouin_pc` (
  `iddocument_jouin_pc` bigint(20) NOT NULL AUTO_INCREMENT,
  `nom_doc` varchar(100) DEFAULT '',
  `source_doc` varchar(250) DEFAULT '',
  `docum` longblob,
  `ID_Piece_mere` int(11) DEFAULT '0',
  `taillefichier` varchar(50) DEFAULT '',
  `table_source` varchar(50) DEFAULT '',
  `verrouil` int(11) DEFAULT '0',
  `imprimer` int(11) DEFAULT '0',
  `type_doc` varchar(50) DEFAULT '',
  `date_creation` date DEFAULT NULL,
  `debu_validite` date DEFAULT NULL,
  `fin_validite` date DEFAULT NULL,
  PRIMARY KEY (`iddocument_jouin_pc`),
  KEY `WDIDX1706299977107` (`ID_Piece_mere`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `document_jouin_pc`
--

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

--
-- Table structure for table `employe`
--

DROP TABLE IF EXISTS `employe`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `employe` (
  `idemploye` bigint(20) NOT NULL AUTO_INCREMENT,
  `nom` varchar(50) DEFAULT '',
  `prenom` varchar(50) DEFAULT '',
  `date_nais` varchar(50) DEFAULT '',
  `adresse` longtext CHARACTER SET ucs2,
  `code_post` varchar(10) DEFAULT '',
  `num_tel` varchar(50) DEFAULT '',
  `mobile` varchar(50) DEFAULT '',
  `status` int(11) DEFAULT '0',
  `actif` tinyint(4) DEFAULT '0',
  `Idwilaya` bigint(20) DEFAULT '0',
  `Idpays` bigint(20) DEFAULT '0',
  `code_societe` varchar(50) DEFAULT '',
  `Idtransporteur` bigint(20) DEFAULT '0',
  `Idcivilite` bigint(20) DEFAULT '0',
  `Idfonction_emp` bigint(20) DEFAULT '0',
  `Cout_heur` float DEFAULT '0',
  PRIMARY KEY (`idemploye`),
  KEY `WDIDX1706299977108` (`Idwilaya`),
  KEY `WDIDX1706299977109` (`Idpays`),
  KEY `WDIDX1706299977110` (`code_societe`),
  KEY `WDIDX1706299977111` (`Idtransporteur`),
  KEY `WDIDX1706299977112` (`Idcivilite`),
  KEY `WDIDX1706299977113` (`Idfonction_emp`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `employe`
--

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

--
-- Table structure for table `employe_ol_ml`
--

DROP TABLE IF EXISTS `employe_ol_ml`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `employe_ol_ml` (
  `Idordre_livraison_ml` bigint(20) DEFAULT '0',
  `Idemploye` bigint(20) DEFAULT '0',
  `Idemploye_ol_ml` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`Idemploye_ol_ml`),
  KEY `WDIDX1706299977114` (`Idordre_livraison_ml`),
  KEY `WDIDX1706299977115` (`Idemploye`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `employe_ol_ml`
--

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

--
-- Table structure for table `etapes_production`
--

DROP TABLE IF EXISTS `etapes_production`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `etapes_production` (
  `idetaprs_production` bigint(20) NOT NULL AUTO_INCREMENT,
  `libelle_etape` varchar(50) DEFAULT '',
  PRIMARY KEY (`idetaprs_production`),
  KEY `WDIDX1706299977116` (`libelle_etape`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `etapes_production`
--

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

--
-- Table structure for table `famille`
--

DROP TABLE IF EXISTS `famille`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `famille` (
  `IDFamille` int(11) NOT NULL AUTO_INCREMENT,
  `Designation` varchar(50) DEFAULT '',
  PRIMARY KEY (`IDFamille`),
  KEY `WDIDX1706299977117` (`Designation`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `famille`
--

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

--
-- Table structure for table `fonction_emp`
--

DROP TABLE IF EXISTS `fonction_emp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fonction_emp` (
  `idfonction_emp` bigint(20) NOT NULL AUTO_INCREMENT,
  `libelle_fonc` varchar(50) DEFAULT '',
  PRIMARY KEY (`idfonction_emp`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `fonction_emp`
--

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

--
-- Table structure for table `fournisseur`
--

DROP TABLE IF EXISTS `fournisseur`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fournisseur` (
  `IDFournisseur` int(11) NOT NULL AUTO_INCREMENT,
  `Nom_RS` varchar(200) CHARACTER SET utf8 DEFAULT NULL,
  `Adresse` longtext CHARACTER SET utf8,
  `tel` varchar(50) DEFAULT '',
  `Fax` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `RCcommerce` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `IDFical` varchar(50) DEFAULT '',
  `art_imposition` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `agence_banque` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `Num_compte` varchar(50) DEFAULT '',
  `Chiffre_affaire` decimal(24,6) DEFAULT '0.000000',
  `solde` decimal(24,6) DEFAULT '0.000000',
  `Mob` varchar(50) DEFAULT '',
  `NIS` varchar(50) DEFAULT '',
  `Titre_fournisseur` varchar(50) DEFAULT '',
  `mail` varchar(50) DEFAULT '',
  `site_web` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `code_frs` varchar(10) DEFAULT '',
  `solde_initial` float DEFAULT '0',
  `code_postal` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `coord_gps_lat` float DEFAULT '0',
  `coord_gps_long` float DEFAULT '0',
  `Idpays` bigint(20) DEFAULT '0',
  `Idwilaya` bigint(20) DEFAULT '0',
  PRIMARY KEY (`IDFournisseur`),
  UNIQUE KEY `code_frs` (`code_frs`),
  KEY `WDIDX1706299977118` (`Nom_RS`),
  KEY `WDIDX1706299977119` (`tel`),
  KEY `WDIDX1706299977120` (`Fax`),
  KEY `WDIDX1706299977121` (`RCcommerce`),
  KEY `WDIDX1706299977122` (`IDFical`),
  KEY `WDIDX1706299977123` (`art_imposition`),
  KEY `WDIDX1706299977124` (`Mob`),
  KEY `WDIDX1706299977125` (`NIS`),
  KEY `WDIDX1706299977126` (`Titre_fournisseur`),
  KEY `WDIDX1706299977127` (`Idpays`),
  KEY `WDIDX1706299977128` (`Idwilaya`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `fournisseur`
--

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

--
-- Table structure for table `ftva`
--

DROP TABLE IF EXISTS `ftva`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ftva` (
  `IDFTVA` int(11) NOT NULL AUTO_INCREMENT,
  `TAUX_TVA` float DEFAULT '0',
  `defau_tva` int(11) DEFAULT '0',
  PRIMARY KEY (`IDFTVA`),
  UNIQUE KEY `TAUX_TVA` (`TAUX_TVA`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ftva`
--

LOCK TABLES `ftva` WRITE;
/*!40000 ALTER TABLE `ftva` DISABLE KEYS */;
INSERT INTO `ftva` VALUES (1,0,0),(2,19,0),(3,9,0);
/*!40000 ALTER TABLE `ftva` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `garanties_technique`
--

DROP TABLE IF EXISTS `garanties_technique`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `garanties_technique` (
  `IDgaranties_technique` bigint(20) NOT NULL AUTO_INCREMENT,
  `ref_garantie` varchar(50) DEFAULT '',
  `num_garantie` varchar(50) DEFAULT '',
  `date_garantie` date DEFAULT NULL,
  `detail_period_gar` longtext CHARACTER SET ucs2,
  `mois_date` varchar(50) DEFAULT '',
  `annee_date` varchar(50) DEFAULT '',
  `suppr` int(11) DEFAULT '0',
  `IDClient` int(11) DEFAULT '0',
  `Idemploye` bigint(20) DEFAULT '0',
  `id_metre_ouvrage` int(11) DEFAULT '0',
  PRIMARY KEY (`IDgaranties_technique`),
  KEY `WDIDX1706299977129` (`ref_garantie`),
  KEY `WDIDX1706299977130` (`num_garantie`),
  KEY `WDIDX1706299977131` (`mois_date`),
  KEY `WDIDX1706299977132` (`annee_date`),
  KEY `WDIDX1706299977133` (`IDClient`),
  KEY `WDIDX1706299977134` (`Idemploye`),
  KEY `WDIDX1706299977135` (`id_metre_ouvrage`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `garanties_technique`
--

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

--
-- Table structure for table `garanties_technique_article`
--

DROP TABLE IF EXISTS `garanties_technique_article`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `garanties_technique_article` (
  `IDgaranties_technique` bigint(20) DEFAULT '0',
  `IDArticle` bigint(20) DEFAULT '0',
  `id_Garanti_article` int(11) NOT NULL AUTO_INCREMENT,
  `quantite` float DEFAULT '0',
  `designatio_art_gar` longtext CHARACTER SET ucs2,
  `item` int(11) DEFAULT '0',
  PRIMARY KEY (`id_Garanti_article`),
  KEY `WDIDX1706299977136` (`IDgaranties_technique`),
  KEY `WDIDX1706299977137` (`IDArticle`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `garanties_technique_article`
--

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

--
-- Table structure for table `garanties_technique_ventes`
--

DROP TABLE IF EXISTS `garanties_technique_ventes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `garanties_technique_ventes` (
  `IDgaranties_technique` bigint(20) DEFAULT '0',
  `IDVentes` int(11) DEFAULT '0',
  `ID_garantie_vente` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`ID_garantie_vente`),
  KEY `WDIDX1706299977138` (`IDgaranties_technique`),
  KEY `WDIDX1706299977139` (`IDVentes`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `garanties_technique_ventes`
--

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

--
-- Table structure for table `historique_article`
--

DROP TABLE IF EXISTS `historique_article`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `historique_article` (
  `IDHistorique` int(11) NOT NULL AUTO_INCREMENT,
  `Date_h` date DEFAULT NULL,
  `Type_Opp` varchar(150) DEFAULT '',
  `IDArticle` int(11) DEFAULT '0',
  `REF_article` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `qte_opp` float DEFAULT '0',
  `numpiece` varchar(50) DEFAULT '',
  `num_client_frs` varchar(50) DEFAULT '',
  `Type_ES` varchar(2) DEFAULT '',
  `qte_avant` double DEFAULT '0',
  `prix_opperation` decimal(24,6) DEFAULT '0.000000',
  `ID_DEPOT_H` int(11) DEFAULT '0',
  `id_piece` int(11) DEFAULT '0',
  `table_detail_op` varchar(50) DEFAULT '0',
  `nom_chaps_lien` varchar(50) DEFAULT '0',
  `id_detai` int(11) DEFAULT '0',
  PRIMARY KEY (`IDHistorique`),
  KEY `WDIDX1706299977140` (`Type_Opp`),
  KEY `WDIDX1706299977141` (`IDArticle`),
  KEY `WDIDX1706299978142` (`REF_article`),
  KEY `WDIDX1706299978143` (`numpiece`),
  KEY `WDIDX1706299978144` (`num_client_frs`),
  KEY `WDIDX1706299978145` (`Type_ES`),
  KEY `WDIDX1706299978146` (`ID_DEPOT_H`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `historique_article`
--

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

--
-- Table structure for table `historique_correction`
--

DROP TABLE IF EXISTS `historique_correction`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `historique_correction` (
  `IDCorrection` int(11) NOT NULL AUTO_INCREMENT,
  `date_correction` date DEFAULT NULL,
  `valeur` double DEFAULT '0',
  `REF_article` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `IDArticle` int(11) DEFAULT '0',
  `ancien_valeur` double DEFAULT '0',
  `differance` double DEFAULT '0',
  `Type_piece` varchar(50) DEFAULT '',
  `iddepot` int(11) DEFAULT '0',
  PRIMARY KEY (`IDCorrection`),
  KEY `WDIDX1706299978147` (`date_correction`),
  KEY `WDIDX1706299978148` (`REF_article`),
  KEY `WDIDX1706299978149` (`IDArticle`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `historique_correction`
--

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

--
-- Table structure for table `historique_modification`
--

DROP TABLE IF EXISTS `historique_modification`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `historique_modification` (
  `IDhistorique_modification` bigint(20) NOT NULL AUTO_INCREMENT,
  `table_id` varchar(50) DEFAULT '',
  `typ_modif` varchar(50) DEFAULT '',
  `valeurs` longtext,
  `date_heur` datetime(3) DEFAULT NULL,
  `Utilisateur_` varchar(50) DEFAULT '',
  PRIMARY KEY (`IDhistorique_modification`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `historique_modification`
--

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

--
-- Table structure for table `historique_numero_serie`
--

DROP TABLE IF EXISTS `historique_numero_serie`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `historique_numero_serie` (
  `IDhistorique_numero_serie` bigint(20) NOT NULL AUTO_INCREMENT,
  `vente_achat` varchar(10) DEFAULT '',
  `id_DEtail_piece` int(11) DEFAULT '0',
  `nUMERO_serie_h` varchar(50) DEFAULT '',
  `date_operation` datetime(3) DEFAULT NULL,
  `id_num_seri_dep` int(11) DEFAULT '0',
  PRIMARY KEY (`IDhistorique_numero_serie`),
  KEY `WDIDX1706299978150` (`id_DEtail_piece`),
  KEY `WDIDX1706299978151` (`nUMERO_serie_h`),
  KEY `WDIDX1706299978152` (`id_num_seri_dep`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `historique_numero_serie`
--

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

--
-- Table structure for table `historiques`
--

DROP TABLE IF EXISTS `historiques`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `historiques` (
  `idhistoriques` bigint(20) NOT NULL AUTO_INCREMENT,
  `Id_document` varchar(50) DEFAULT '',
  `table_base_liaison` varchar(50) DEFAULT '0',
  `nom_col_id` varchar(50) DEFAULT '',
  `type_modif` varchar(50) DEFAULT '',
  `date_m` date DEFAULT NULL,
  `heure_m` time DEFAULT '00:00:00',
  `id_utilisateur` int(11) DEFAULT '0',
  `poste_m` varchar(50) DEFAULT '',
  `contenu_m` longtext CHARACTER SET ucs2,
  `titre_document` varchar(150) DEFAULT '',
  `numero_doc` varchar(50) DEFAULT '0',
  `nom_utilisateur` varchar(50) DEFAULT '',
  `version_courante` varchar(50) DEFAULT '',
  PRIMARY KEY (`idhistoriques`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `historiques`
--

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

--
-- Table structure for table `lien_location_restitution`
--

DROP TABLE IF EXISTS `lien_location_restitution`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lien_location_restitution` (
  `idliens_loc_rest` int(11) NOT NULL AUTO_INCREMENT,
  `id_location` varchar(50) DEFAULT '',
  `id_restitution` varchar(50) DEFAULT '',
  PRIMARY KEY (`idliens_loc_rest`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `lien_location_restitution`
--

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

--
-- Table structure for table `liste_commentairs`
--

DROP TABLE IF EXISTS `liste_commentairs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `liste_commentairs` (
  `IDliste_commentairs` bigint(20) NOT NULL AUTO_INCREMENT,
  `id_parent` int(11) DEFAULT '0',
  `commentaire_txt` longtext CHARACTER SET ucs2,
  PRIMARY KEY (`IDliste_commentairs`),
  KEY `WDIDX1706299981280` (`id_parent`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `liste_commentairs`
--

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

--
-- Table structure for table `liste_depots`
--

DROP TABLE IF EXISTS `liste_depots`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `liste_depots` (
  `IDLISTE_DEPOTS` int(11) NOT NULL AUTO_INCREMENT,
  `NOM_DEPOT` varchar(50) DEFAULT '',
  `TYPE_DEP` varchar(50) DEFAULT '',
  PRIMARY KEY (`IDLISTE_DEPOTS`),
  KEY `WDIDX1706299978153` (`NOM_DEPOT`),
  KEY `WDIDX1706299978154` (`TYPE_DEP`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `liste_depots`
--

LOCK TABLES `liste_depots` WRITE;
/*!40000 ALTER TABLE `liste_depots` DISABLE KEYS */;
INSERT INTO `liste_depots` VALUES (1,'Dépôt principal','NON_EDIT');
/*!40000 ALTER TABLE `liste_depots` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `liste_depots_article`
--

DROP TABLE IF EXISTS `liste_depots_article`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `liste_depots_article` (
  `IDArticle` bigint(20) DEFAULT '0',
  `IDLISTE_DEPOTS` int(11) DEFAULT '0',
  `STQ_INI` double DEFAULT '0',
  `QTT_ENTRE` float DEFAULT '0',
  `QTT_SORTIE` float DEFAULT '0',
  `STQ_FINAL` float DEFAULT '0',
  `ID_List_Dep_Art` int(11) NOT NULL AUTO_INCREMENT,
  `Rayonnage` varchar(150) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID_List_Dep_Art`),
  KEY `WDIDX1706299978155` (`IDArticle`),
  KEY `WDIDX1706299978156` (`IDLISTE_DEPOTS`),
  KEY `WDIDX1706299978157` (`Rayonnage`),
  KEY `IDX_liste_depots_article_Rayonnage` (`Rayonnage`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `liste_depots_article`
--

LOCK TABLES `liste_depots_article` WRITE;
/*!40000 ALTER TABLE `liste_depots_article` DISABLE KEYS */;
INSERT INTO `liste_depots_article` VALUES (1,1,20,0,0,20,1,''),(2,1,0,0,0,0,2,'');
/*!40000 ALTER TABLE `liste_depots_article` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `liste_des_transfert_quantite`
--

DROP TABLE IF EXISTS `liste_des_transfert_quantite`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `liste_des_transfert_quantite` (
  `IDListe_des_transfert_quantit_` int(11) NOT NULL AUTO_INCREMENT,
  `date_trans` date DEFAULT NULL,
  `desCRIPTION` longtext CHARACTER SET utf8,
  `nOte_transfert` longtext,
  `id_depo_source` int(11) DEFAULT '0',
  `id_depot_destination` int(11) DEFAULT '0',
  `num_trans` varchar(50) DEFAULT '',
  `IDClient` int(11) DEFAULT '0',
  PRIMARY KEY (`IDListe_des_transfert_quantit_`),
  KEY `WDIDX1706299978158` (`id_depo_source`),
  KEY `WDIDX1706299978159` (`id_depot_destination`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `liste_des_transfert_quantite`
--

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

--
-- Table structure for table `liste_duree_validitee`
--

DROP TABLE IF EXISTS `liste_duree_validitee`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `liste_duree_validitee` (
  `IDliste` bigint(20) NOT NULL AUTO_INCREMENT,
  `libelle_duree` varchar(50) DEFAULT '',
  `nbr_jours` int(11) DEFAULT '0',
  PRIMARY KEY (`IDliste`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `liste_duree_validitee`
--

LOCK TABLES `liste_duree_validitee` WRITE;
/*!40000 ALTER TABLE `liste_duree_validitee` DISABLE KEYS */;
INSERT INTO `liste_duree_validitee` VALUES (1,'<NULL>',0),(2,'07 Jours',7),(3,'15 Jours',15),(4,'30 Jours',30),(5,'45 Jours',45),(6,'60 Jours',60),(7,'75 Jours',75),(8,'90 Jours',90),(9,'120 Jours',120),(10,'180 Jours',180);
/*!40000 ALTER TABLE `liste_duree_validitee` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `liste_fiche_test_ns`
--

DROP TABLE IF EXISTS `liste_fiche_test_ns`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `liste_fiche_test_ns` (
  `IDliste_fiche_test_ns` bigint(20) NOT NULL AUTO_INCREMENT,
  `Date_test` date DEFAULT NULL,
  `agent_testeur` varchar(150) DEFAULT '',
  `notes_test` longtext,
  `num_fiche_test` varchar(50) DEFAULT '',
  `id_client` int(11) DEFAULT '0',
  PRIMARY KEY (`IDliste_fiche_test_ns`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `liste_fiche_test_ns`
--

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

--
-- Table structure for table `liste_pieces_detail`
--

DROP TABLE IF EXISTS `liste_pieces_detail`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `liste_pieces_detail` (
  `IDListe_PIECES_DETAIL` int(11) NOT NULL AUTO_INCREMENT,
  `id_achat_DETAIL` int(11) DEFAULT '0',
  `ID_achat_Orrig` int(11) DEFAULT '0',
  `uoo` varchar(50) DEFAULT '',
  `mm1` varchar(50) DEFAULT '',
  PRIMARY KEY (`IDListe_PIECES_DETAIL`),
  KEY `WDIDX1706299978160` (`id_achat_DETAIL`),
  KEY `WDIDX1706299978161` (`ID_achat_Orrig`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `liste_pieces_detail`
--

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

--
-- Table structure for table `liste_pieces_rattach_ventes`
--

DROP TABLE IF EXISTS `liste_pieces_rattach_ventes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `liste_pieces_rattach_ventes` (
  `IDListe_PIECES_RATTACH_VENTES` int(11) NOT NULL AUTO_INCREMENT,
  `ID_Vente_DETAIL` int(11) DEFAULT '0',
  `IDVentes_orrig` int(11) DEFAULT '0',
  PRIMARY KEY (`IDListe_PIECES_RATTACH_VENTES`),
  KEY `WDIDX1706299978162` (`ID_Vente_DETAIL`),
  KEY `WDIDX1706299978163` (`IDVentes_orrig`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `liste_pieces_rattach_ventes`
--

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

--
-- Table structure for table `liste_types_prix_tarifs`
--

DROP TABLE IF EXISTS `liste_types_prix_tarifs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `liste_types_prix_tarifs` (
  `IDListe_Types_Prix_tarifs` int(11) NOT NULL AUTO_INCREMENT,
  `Libele_prix` varchar(150) DEFAULT '',
  `Champ_Orrigine` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`IDListe_Types_Prix_tarifs`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `liste_types_prix_tarifs`
--

LOCK TABLES `liste_types_prix_tarifs` WRITE;
/*!40000 ALTER TABLE `liste_types_prix_tarifs` DISABLE KEYS */;
INSERT INTO `liste_types_prix_tarifs` VALUES (1,'Client',1),(2,'Revendeur',1),(3,'Entreprise',1);
/*!40000 ALTER TABLE `liste_types_prix_tarifs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `localisation`
--

DROP TABLE IF EXISTS `localisation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `localisation` (
  `IDLocalisation` int(11) NOT NULL AUTO_INCREMENT,
  `Designation` varchar(50) DEFAULT '',
  PRIMARY KEY (`IDLocalisation`),
  KEY `WDIDX1706299978164` (`Designation`),
  KEY `indDesignation` (`Designation`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `localisation`
--

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

--
-- Table structure for table `locations_restitutions`
--

DROP TABLE IF EXISTS `locations_restitutions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `locations_restitutions` (
  `idlocations_restitutions` bigint(20) NOT NULL AUTO_INCREMENT,
  `date_loc_rest` date DEFAULT NULL,
  `num_piece` varchar(50) DEFAULT '',
  `notes` varchar(50) DEFAULT '',
  `date_prevu_retour` varchar(50) DEFAULT '',
  `tau_remise_glob` varchar(50) DEFAULT '',
  `Idemploye` bigint(20) DEFAULT '0',
  `idclient` int(11) DEFAULT '0',
  `idtype_loc_rest` bigint(20) DEFAULT '0',
  `etat` varchar(50) DEFAULT '',
  `mois` varchar(50) DEFAULT '',
  `annee_` int(11) DEFAULT '0',
  `idordre_livraison_ml` bigint(20) DEFAULT '0',
  `mode_reglement` varchar(50) DEFAULT '',
  `exonoration_fisacle` tinyint(3) unsigned DEFAULT '0',
  `date_livraison` date DEFAULT NULL,
  `bon_de_commande_n` varchar(250) DEFAULT '',
  `tarif_applique` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `adresse_livraison` longtext CHARACTER SET ucs2,
  `date_echeance` date DEFAULT NULL,
  `activer_l_alerte` tinyint(4) DEFAULT '0',
  `jour_avant_la_date` int(11) DEFAULT '0',
  `remise_ttc` double DEFAULT '0',
  `total_ht_av_remise` double DEFAULT '0',
  `total_tva_av_remise` double DEFAULT '0',
  `total_timbre` double DEFAULT '0',
  `total_ht_ap_remise` double DEFAULT '0',
  `total_tva_ap_remise` double DEFAULT '0',
  `total_ttc_ap_remise` double DEFAULT '0',
  `id_represent_client` int(11) DEFAULT '0',
  PRIMARY KEY (`idlocations_restitutions`),
  KEY `WDIDX1706299978165` (`num_piece`),
  KEY `WDIDX1706299978166` (`Idemploye`),
  KEY `WDIDX1706299978167` (`idclient`),
  KEY `WDIDX1706299978168` (`idtype_loc_rest`),
  KEY `WDIDX1706299978169` (`idordre_livraison_ml`),
  KEY `WDIDX1706299978170` (`mode_reglement`),
  KEY `WDIDX1706299978171` (`exonoration_fisacle`),
  KEY `WDIDX1706299978172` (`tarif_applique`),
  KEY `WDIDX1706299978173` (`id_represent_client`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `locations_restitutions`
--

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

--
-- Table structure for table `marque_vehicule`
--

DROP TABLE IF EXISTS `marque_vehicule`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `marque_vehicule` (
  `idmarque_vehicule` bigint(20) NOT NULL AUTO_INCREMENT,
  `nom_marque` varchar(50) DEFAULT '',
  PRIMARY KEY (`idmarque_vehicule`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `marque_vehicule`
--

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

--
-- Table structure for table `mode_de_reglement`
--

DROP TABLE IF EXISTS `mode_de_reglement`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mode_de_reglement` (
  `IDMODE_DE_REGLEMENT` int(11) NOT NULL AUTO_INCREMENT,
  `NOM_MODE_REGLEMENT` varchar(50) DEFAULT '',
  PRIMARY KEY (`IDMODE_DE_REGLEMENT`),
  KEY `WDIDX1706299978174` (`NOM_MODE_REGLEMENT`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mode_de_reglement`
--

LOCK TABLES `mode_de_reglement` WRITE;
/*!40000 ALTER TABLE `mode_de_reglement` DISABLE KEYS */;
INSERT INTO `mode_de_reglement` VALUES (4,'A TERME'),(3,'CHEQUE'),(6,'CHEQUE OU VIREMENT'),(8,'CHEQUE OU VIREMENT'),(9,'CHEQUE OU VIREMENT OU ESPÈCE'),(1,'ESPECE'),(5,'MONDAT ADMINISTRATIF'),(7,'MONDAT ADMINISTRATIF'),(10,'VERSEMENT'),(2,'VIREMENT');
/*!40000 ALTER TABLE `mode_de_reglement` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mois_annee`
--

DROP TABLE IF EXISTS `mois_annee`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mois_annee` (
  `IDmoi_annee` bigint(20) NOT NULL AUTO_INCREMENT,
  `libele_mois` varchar(50) DEFAULT '',
  `num_mois` varchar(50) DEFAULT '0',
  `code` varchar(10) DEFAULT '',
  PRIMARY KEY (`IDmoi_annee`),
  KEY `WDIDX1706299978175` (`num_mois`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mois_annee`
--

LOCK TABLES `mois_annee` WRITE;
/*!40000 ALTER TABLE `mois_annee` DISABLE KEYS */;
INSERT INTO `mois_annee` VALUES (1,'TOUTE L\'ANNEE','00',''),(2,'JANVIER','01',''),(3,'FÉVRIER','02',''),(4,'MARS','03',''),(5,'AVRIL','04',''),(6,'MAI','05',''),(7,'JUIN','06',''),(8,'JUILLET','07',''),(9,'AOÛT','08',''),(10,'SEPTEMBRE','09',''),(11,'OCTOBRE','10',''),(12,'NOVEMBRE','11',''),(13,'DÉCEMBRE','12','');
/*!40000 ALTER TABLE `mois_annee` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mouvement_tresoreie`
--

DROP TABLE IF EXISTS `mouvement_tresoreie`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mouvement_tresoreie` (
  `idmouvement_tresoreie` bigint(20) NOT NULL AUTO_INCREMENT,
  `date_oper` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `libel_oper` longtext CHARACTER SET utf8,
  `notes` longtext CHARACTER SET utf8,
  `montant_ecaissement` double DEFAULT '0',
  `montant_deponce` double DEFAULT '0',
  `heure_oper` time DEFAULT '00:00:00',
  `Idtresorerie` bigint(20) DEFAULT '0',
  `Idtype_operation` bigint(20) DEFAULT '0',
  `IDmoi_annee` bigint(20) DEFAULT '0',
  `Idcategorie_operation` bigint(20) DEFAULT '0',
  `mode_operation` int(11) DEFAULT '0',
  `reference_oper` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `num_compte_oper` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `Notes_decharge` longtext CHARACTER SET utf8,
  PRIMARY KEY (`idmouvement_tresoreie`),
  KEY `WDIDX1706299978176` (`Idtresorerie`),
  KEY `WDIDX1706299978177` (`Idtype_operation`),
  KEY `WDIDX1706299978178` (`IDmoi_annee`),
  KEY `WDIDX1706299978179` (`Idcategorie_operation`),
  KEY `WDIDX1706299978180` (`mode_operation`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mouvement_tresoreie`
--

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

--
-- Table structure for table `nomocature_prod`
--

DROP TABLE IF EXISTS `nomocature_prod`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nomocature_prod` (
  `IDNOMOCATURE_PROD` bigint(20) NOT NULL AUTO_INCREMENT,
  `qutte_prod` float DEFAULT '0',
  `idArticle` bigint(20) DEFAULT '0',
  `notes_nomo` longtext,
  `frais_Supplem` double DEFAULT '0',
  `creer_nserie` int(11) DEFAULT '0',
  `radic_nserie` varchar(10) DEFAULT '',
  `mode_gener_nserie` varchar(50) DEFAULT '',
  `nbr_carac_nserie` int(11) DEFAULT '0',
  `type_valeur` varchar(50) DEFAULT '',
  `autre_frais` float DEFAULT '0',
  `mode_cal_etape` varchar(50) DEFAULT '',
  `maj_cout_reviens` int(11) DEFAULT '0',
  PRIMARY KEY (`IDNOMOCATURE_PROD`),
  KEY `WDIDX1706299978181` (`idArticle`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `nomocature_prod`
--

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

--
-- Table structure for table `num_seri_article_depot`
--

DROP TABLE IF EXISTS `num_seri_article_depot`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `num_seri_article_depot` (
  `IDNum_Seri_Article_Depot` bigint(20) NOT NULL AUTO_INCREMENT,
  `QTT_INI` int(11) DEFAULT '0',
  `QTT_SORTIE` int(11) DEFAULT '0',
  `QTT_ENTRE` int(11) DEFAULT '0',
  `QTT_FINAL` int(11) DEFAULT '0',
  `ID_article_depot` int(11) DEFAULT '0',
  `Numero_serie` varchar(50) DEFAULT '',
  `id_detail_achat` int(11) DEFAULT '0',
  `id_detail_Vente` int(11) DEFAULT '0',
  `disponible` tinyint(4) DEFAULT '0',
  `num_autorisation` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `Date_autorisation` date DEFAULT NULL,
  PRIMARY KEY (`IDNum_Seri_Article_Depot`),
  KEY `WDIDX1706299978182` (`ID_article_depot`),
  KEY `WDIDX1706299978183` (`Numero_serie`),
  KEY `WDIDX1706299978184` (`id_detail_achat`),
  KEY `WDIDX1706299979185` (`id_detail_Vente`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `num_seri_article_depot`
--

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

--
-- Table structure for table `ordre_livraison_ml`
--

DROP TABLE IF EXISTS `ordre_livraison_ml`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ordre_livraison_ml` (
  `idordre_livraison_ml` bigint(20) NOT NULL AUTO_INCREMENT,
  `num_ol` varchar(20) DEFAULT '',
  `date_ol` date DEFAULT NULL,
  `date_fin` date DEFAULT NULL,
  `status` int(11) DEFAULT '0',
  `id_transporteur` int(11) DEFAULT '0',
  `Idvehicule` bigint(20) DEFAULT '0',
  PRIMARY KEY (`idordre_livraison_ml`),
  KEY `WDIDX1706299979186` (`num_ol`),
  KEY `WDIDX1706299979187` (`status`),
  KEY `WDIDX1706299979188` (`id_transporteur`),
  KEY `WDIDX1706299979189` (`Idvehicule`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ordre_livraison_ml`
--

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

--
-- Table structure for table `ordre_mission`
--

DROP TABLE IF EXISTS `ordre_mission`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ordre_mission` (
  `IDordre_mission` bigint(20) NOT NULL AUTO_INCREMENT,
  `Idadresse_livraison` bigint(20) DEFAULT '0',
  `IDClient` int(11) DEFAULT '0',
  `ref_om` varchar(50) CHARACTER SET ucs2 DEFAULT '',
  `num_om` varchar(50) CHARACTER SET ucs2 DEFAULT '',
  `date_om` date DEFAULT NULL,
  `date_depart` date DEFAULT NULL,
  `heur_depart` time DEFAULT '00:00:00',
  `date_retour` date DEFAULT NULL,
  `heur_retour` varchar(50) CHARACTER SET ucs2 DEFAULT '',
  `Note_date_retour` varchar(150) CHARACTER SET ucs2 DEFAULT '',
  `notes_generale` longtext CHARACTER SET ucs2,
  `mission_charge` varchar(150) DEFAULT '',
  `annee_date` varchar(50) DEFAULT '',
  `mois_date` varchar(50) DEFAULT '',
  PRIMARY KEY (`IDordre_mission`),
  KEY `WDIDX1706299979190` (`Idadresse_livraison`),
  KEY `WDIDX1706299979191` (`IDClient`),
  KEY `WDIDX1706299979192` (`ref_om`),
  KEY `WDIDX1706299979193` (`num_om`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ordre_mission`
--

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

--
-- Table structure for table `ordre_mission_employe`
--

DROP TABLE IF EXISTS `ordre_mission_employe`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ordre_mission_employe` (
  `IDordre_mission` bigint(20) DEFAULT '0',
  `Idemploye` bigint(20) DEFAULT '0',
  `id_ordre_miss_employe` int(11) NOT NULL AUTO_INCREMENT,
  `taches_mission` longtext CHARACTER SET ucs2,
  `notess` longtext CHARACTER SET ucs2,
  PRIMARY KEY (`id_ordre_miss_employe`),
  KEY `WDIDX1706299979194` (`IDordre_mission`),
  KEY `WDIDX1706299979195` (`Idemploye`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ordre_mission_employe`
--

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

--
-- Table structure for table `ordre_mission_vehicule`
--

DROP TABLE IF EXISTS `ordre_mission_vehicule`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ordre_mission_vehicule` (
  `IDordre_mission` bigint(20) DEFAULT '0',
  `Idvehicule` bigint(20) DEFAULT '0',
  `ID_ordre_miss_vehicule` int(11) NOT NULL AUTO_INCREMENT,
  `notes` longtext CHARACTER SET ucs2,
  PRIMARY KEY (`ID_ordre_miss_vehicule`),
  KEY `WDIDX1706299979196` (`IDordre_mission`),
  KEY `WDIDX1706299979197` (`Idvehicule`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ordre_mission_vehicule`
--

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

--
-- Table structure for table `ordre_mission_ventes`
--

DROP TABLE IF EXISTS `ordre_mission_ventes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ordre_mission_ventes` (
  `IDordre_mission` bigint(20) DEFAULT '0',
  `IDVentes` int(11) DEFAULT '0',
  `id_ordre_miss_vente` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id_ordre_miss_vente`),
  KEY `WDIDX1706299979198` (`IDordre_mission`),
  KEY `WDIDX1706299979199` (`IDVentes`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ordre_mission_ventes`
--

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

--
-- Table structure for table `ordres_fabrication`
--

DROP TABLE IF EXISTS `ordres_fabrication`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ordres_fabrication` (
  `IDOrdres_Fabrication` bigint(20) NOT NULL AUTO_INCREMENT,
  `Num_OF` varchar(50) DEFAULT '',
  `ETAT_OF` varchar(50) DEFAULT '',
  `Quantit_A_fabriquer` float DEFAULT '0',
  `agent_planificateur_` varchar(50) DEFAULT '',
  `date_de_planification_` date DEFAULT NULL,
  `date_de_debut_traitement` date DEFAULT NULL,
  `date_fin_traitement` date DEFAULT NULL,
  `IDArticle` bigint(20) DEFAULT '0',
  `IDLISTE_DEPOTS` int(11) DEFAULT '0',
  `qtite_Fabrique` double DEFAULT '0',
  `Mois_of` varchar(30) DEFAULT '0',
  `DErnier_modif_par` varchar(50) DEFAULT '',
  `Date_dernier_modif` date DEFAULT NULL,
  `Quantit_Prod_Rebut` double DEFAULT '0',
  `Notes` longtext,
  `ID_detail_Vente` int(11) DEFAULT '0',
  PRIMARY KEY (`IDOrdres_Fabrication`),
  KEY `WDIDX1706299979200` (`Num_OF`),
  KEY `WDIDX1706299979201` (`IDArticle`),
  KEY `WDIDX1706299979202` (`IDLISTE_DEPOTS`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ordres_fabrication`
--

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

--
-- Table structure for table `ordres_livraison`
--

DROP TABLE IF EXISTS `ordres_livraison`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ordres_livraison` (
  `IDORDRES_LIVRAISON` int(11) NOT NULL AUTO_INCREMENT,
  `DATE_OL` date DEFAULT NULL,
  `LIVREUR` varchar(250) DEFAULT '',
  `MONTANT_LIVRAISON` double DEFAULT '0',
  `MONTANT_encaisse` double DEFAULT '0',
  `IDArticle` bigint(20) DEFAULT '0',
  `ID_DEPOTT_OL` int(11) DEFAULT '0',
  `Quant_NON_Livre` double DEFAULT '0',
  `Num_OL` varchar(50) DEFAULT '',
  `Nombre_d_articles` double DEFAULT '0',
  `Montant_total` float DEFAULT '0',
  `Quantit_Livr_` double DEFAULT '0',
  `Quantit_manquante` double DEFAULT '0',
  PRIMARY KEY (`IDORDRES_LIVRAISON`),
  KEY `WDIDX1706299979203` (`IDArticle`),
  KEY `WDIDX1706299979204` (`ID_DEPOTT_OL`),
  KEY `WDIDX1706299979205` (`Num_OL`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ordres_livraison`
--

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

--
-- Table structure for table `param_impression_ventes`
--

DROP TABLE IF EXISTS `param_impression_ventes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `param_impression_ventes` (
  `idparam_impression_ventes` bigint(20) NOT NULL AUTO_INCREMENT,
  `imp_mont_ht` tinyint(4) DEFAULT '0',
  `imp_remise` tinyint(4) DEFAULT '0',
  `imp_mont_ht_apr_rem` tinyint(4) DEFAULT '0',
  `imp_retenu_garan` tinyint(4) DEFAULT '0',
  `imp_mont_apr_ret` tinyint(4) DEFAULT '0',
  `imp_tva` tinyint(4) DEFAULT '0',
  `imp_timbre` tinyint(4) DEFAULT '0',
  `imp_mont_ttc` tinyint(4) DEFAULT '0',
  `txt_Montant_HT` varchar(100) DEFAULT '',
  `txt_Remise` varchar(100) DEFAULT '',
  `txt_Total_HT_après_remise` varchar(100) DEFAULT '',
  `txt_Retenue_de_garantie` varchar(100) DEFAULT '',
  `txt_Montant_après_retenue` varchar(100) DEFAULT '',
  `txt_Total_TVA_19` varchar(100) DEFAULT '',
  `txt_Timbre1` varchar(100) DEFAULT '',
  `txt_Total_TTC` varchar(100) DEFAULT '',
  `ID_Vente` int(11) DEFAULT '0',
  `type_vente` varchar(50) DEFAULT '',
  `Modele_impression` varchar(20) DEFAULT '',
  `imp_remise_ht` tinyint(4) DEFAULT '0',
  `txt_remise_ht` varchar(100) DEFAULT '',
  PRIMARY KEY (`idparam_impression_ventes`),
  KEY `WDIDX1706299979206` (`ID_Vente`),
  KEY `WDIDX1706299979207` (`type_vente`),
  KEY `WDIDX1706299979208` (`Modele_impression`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `param_impression_ventes`
--

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

--
-- Table structure for table `pays`
--

DROP TABLE IF EXISTS `pays`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pays` (
  `idpays` bigint(20) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(100) CHARACTER SET ucs2 DEFAULT '',
  PRIMARY KEY (`idpays`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pays`
--

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

--
-- Table structure for table `produit_a_fabriquee_par_of`
--

DROP TABLE IF EXISTS `produit_a_fabriquee_par_of`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `produit_a_fabriquee_par_of` (
  `IDProduit_A_fabriquee_par_of` bigint(20) NOT NULL AUTO_INCREMENT,
  `IDArticle` bigint(20) DEFAULT '0',
  `IDOrdres_Fabrication` bigint(20) DEFAULT '0',
  `quantitee` double DEFAULT '0',
  PRIMARY KEY (`IDProduit_A_fabriquee_par_of`),
  KEY `WDIDX1706299979209` (`IDArticle`),
  KEY `WDIDX1706299979210` (`IDOrdres_Fabrication`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `produit_a_fabriquee_par_of`
--

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

--
-- Table structure for table `produit_fabrique_par_of`
--

DROP TABLE IF EXISTS `produit_fabrique_par_of`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `produit_fabrique_par_of` (
  `IDProduit_fabrique_par_of` bigint(20) NOT NULL AUTO_INCREMENT,
  `quantit_fabriqee` double DEFAULT '0',
  `IDArticle` bigint(20) DEFAULT '0',
  `IDOrdres_Fabrication` bigint(20) DEFAULT '0',
  `crree_par` varchar(50) DEFAULT '',
  `DATE_CREATION` date DEFAULT NULL,
  `qte_rebut` float DEFAULT '0',
  `ID_responsable` int(11) DEFAULT '0',
  `num_lot` int(11) DEFAULT '0',
  `frais_Supplem` double DEFAULT '0',
  `autre_frais` double DEFAULT '0',
  `frais_Supplem_tho` double DEFAULT '0',
  `autre_frais_tho` double DEFAULT '0',
  `mode_duree_product` int(11) DEFAULT '0',
  PRIMARY KEY (`IDProduit_fabrique_par_of`),
  KEY `WDIDX1706299979211` (`IDArticle`),
  KEY `WDIDX1706299979212` (`IDOrdres_Fabrication`),
  KEY `WDIDX1706299979213` (`ID_responsable`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `produit_fabrique_par_of`
--

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

--
-- Table structure for table `proportion_article`
--

DROP TABLE IF EXISTS `proportion_article`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `proportion_article` (
  `IDproportion_article` bigint(20) NOT NULL AUTO_INCREMENT,
  `id_art_princip` int(11) DEFAULT '0',
  `id_art_proportion` int(11) DEFAULT '0',
  `quantite_proportion` double DEFAULT '0',
  PRIMARY KEY (`IDproportion_article`),
  KEY `WDIDX1706299979214` (`id_art_princip`),
  KEY `WDIDX1706299979215` (`id_art_proportion`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `proportion_article`
--

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

--
-- Table structure for table `regelemement_ach`
--

DROP TABLE IF EXISTS `regelemement_ach`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `regelemement_ach` (
  `IDRegelemement_achat` int(11) NOT NULL AUTO_INCREMENT,
  `IDachat` int(11) DEFAULT '0',
  `Mode_reglement` varchar(50) DEFAULT '',
  `date_reglement` date DEFAULT NULL,
  `montant_piece_total_ttc` decimal(24,6) DEFAULT '0.000000',
  `montant_ht_piece` decimal(24,6) DEFAULT '0.000000',
  `total_TVA_piece` decimal(24,6) DEFAULT '0.000000',
  `montant_reglement_du_jour` decimal(24,6) DEFAULT '0.000000',
  `Montant_restant` decimal(24,6) DEFAULT '0.000000',
  `ref_paiement` longtext,
  `id_versement_fr` varchar(50) DEFAULT '',
  `IDVERSSEMENT_COMPTE_FOURNISSEUR` int(11) DEFAULT '0',
  PRIMARY KEY (`IDRegelemement_achat`),
  KEY `WDIDX1706299979216` (`IDachat`),
  KEY `WDIDX1706299979217` (`date_reglement`),
  KEY `WDIDX1706299979218` (`montant_reglement_du_jour`),
  KEY `WDIDX1706299979219` (`IDVERSSEMENT_COMPTE_FOURNISSEUR`),
  KEY `OptimCleComp_IDach_monta` (`IDachat`,`montant_reglement_du_jour`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `regelemement_ach`
--

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

--
-- Table structure for table `regelemement_vente`
--

DROP TABLE IF EXISTS `regelemement_vente`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `regelemement_vente` (
  `IDRegelemement_vente` int(11) NOT NULL AUTO_INCREMENT,
  `IDVentes` int(11) DEFAULT '0',
  `Mode_reglement` varchar(50) DEFAULT '',
  `date_reglement` date DEFAULT NULL,
  `montant_piece_total_ttc` decimal(24,6) DEFAULT '0.000000',
  `montant_ht_piece` decimal(24,6) DEFAULT '0.000000',
  `total_TVA_piece` decimal(24,6) DEFAULT '0.000000',
  `montant_reglement_du_jour` decimal(24,6) DEFAULT '0.000000',
  `Montant_restant` decimal(24,6) DEFAULT '0.000000',
  `ref_paiement` longtext,
  `ID_ORIGINE_REGLEMENT` bigint(20) DEFAULT '0',
  PRIMARY KEY (`IDRegelemement_vente`),
  KEY `WDIDX1706299979220` (`IDVentes`),
  KEY `WDIDX1706299979221` (`date_reglement`),
  KEY `WDIDX1706299979222` (`montant_reglement_du_jour`),
  KEY `WDIDX1706299979223` (`ID_ORIGINE_REGLEMENT`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `regelemement_vente`
--

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

--
-- Table structure for table `reglement_location`
--

DROP TABLE IF EXISTS `reglement_location`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reglement_location` (
  `IDregelement_location` bigint(20) NOT NULL AUTO_INCREMENT,
  `date_reglement` date DEFAULT NULL,
  `mode_reglement` varchar(50) DEFAULT '',
  `ref_paiement` longtext,
  `id_orrigin_reglement` int(11) DEFAULT '0',
  `IDlocations_restitutions` bigint(20) DEFAULT '0',
  `montant_reglement` double DEFAULT '0',
  PRIMARY KEY (`IDregelement_location`),
  KEY `WDIDX1706299979224` (`date_reglement`),
  KEY `WDIDX1706299979225` (`mode_reglement`),
  KEY `WDIDX1706299979226` (`IDlocations_restitutions`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `reglement_location`
--

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

--
-- Table structure for table `responsable_production`
--

DROP TABLE IF EXISTS `responsable_production`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `responsable_production` (
  `idresponsable_production` bigint(20) NOT NULL AUTO_INCREMENT,
  `Idetaprs_production` bigint(20) DEFAULT '0',
  `IDProduit_fabrique_par_of` bigint(20) DEFAULT '0',
  `Idemploye` bigint(20) DEFAULT '0',
  `date_ded_prod` date DEFAULT NULL,
  `heur_deb_prod` time DEFAULT '00:00:00',
  `date_fin_prod` date DEFAULT NULL,
  `heur_fin_prod` time DEFAULT '00:00:00',
  `cout_heur_employer` float DEFAULT '0',
  `cout_heur_outillage` double DEFAULT '0',
  `dure_nb_theor` double DEFAULT '0',
  `dure_jour_mois_theor` varchar(50) DEFAULT '',
  `dure_reel_secondes` int(11) DEFAULT '0',
  PRIMARY KEY (`idresponsable_production`),
  KEY `WDIDX1706299979227` (`Idetaprs_production`),
  KEY `WDIDX1706299979228` (`IDProduit_fabrique_par_of`),
  KEY `WDIDX1706299979229` (`Idemploye`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `responsable_production`
--

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

--
-- Table structure for table `retrait_caution`
--

DROP TABLE IF EXISTS `retrait_caution`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `retrait_caution` (
  `idretrait_caution` bigint(20) NOT NULL AUTO_INCREMENT,
  `date_retrait` date DEFAULT NULL,
  `montant_retiree` double DEFAULT '0',
  `creer_le` datetime(3) DEFAULT NULL,
  `modif_le` datetime(3) DEFAULT NULL,
  `creer_par` varchar(50) DEFAULT '',
  `modif_par` varchar(50) DEFAULT '',
  `Idcautions` bigint(20) DEFAULT '0',
  PRIMARY KEY (`idretrait_caution`),
  KEY `WDIDX1706299979230` (`Idcautions`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `retrait_caution`
--

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

--
-- Table structure for table `stucture_inputation`
--

DROP TABLE IF EXISTS `stucture_inputation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stucture_inputation` (
  `IDStucture_INPUTATION` int(11) NOT NULL AUTO_INCREMENT,
  `nOM_Struc_INPUTATION` varchar(250) DEFAULT '',
  PRIMARY KEY (`IDStucture_INPUTATION`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `stucture_inputation`
--

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

--
-- Table structure for table `suivi_versions_dossier`
--

DROP TABLE IF EXISTS `suivi_versions_dossier`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `suivi_versions_dossier` (
  `IDsuivi_versions_dossier` bigint(20) NOT NULL AUTO_INCREMENT,
  `num_version_courant` varchar(50) DEFAULT '',
  `num_version_precedente` varchar(50) DEFAULT '',
  `date_version` date DEFAULT NULL,
  PRIMARY KEY (`IDsuivi_versions_dossier`),
  KEY `WDIDX1706299979231` (`num_version_courant`),
  KEY `WDIDX1706299980232` (`num_version_precedente`),
  KEY `WDIDX1706299980233` (`date_version`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `suivi_versions_dossier`
--

LOCK TABLES `suivi_versions_dossier` WRITE;
/*!40000 ALTER TABLE `suivi_versions_dossier` DISABLE KEYS */;
INSERT INTO `suivi_versions_dossier` VALUES (1,'737300','0','0015-01-20');
/*!40000 ALTER TABLE `suivi_versions_dossier` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `table_graphe`
--

DROP TABLE IF EXISTS `table_graphe`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `table_graphe` (
  `IDtable_graphe` bigint(20) NOT NULL AUTO_INCREMENT,
  `libelleee` varchar(250) DEFAULT '',
  `valeur_donnee` double DEFAULT '0',
  PRIMARY KEY (`IDtable_graphe`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `table_graphe`
--

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

--
-- Table structure for table `tourne`
--

DROP TABLE IF EXISTS `tourne`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tourne` (
  `idadresse_livraison` bigint(20) DEFAULT '0',
  `IDtourne` bigint(20) NOT NULL AUTO_INCREMENT,
  `statut_tourne` varchar(50) DEFAULT '',
  `date_passage` date DEFAULT NULL,
  `heur_passage` time DEFAULT '00:00:00',
  `Idordre_livraison_ml` bigint(20) DEFAULT '0',
  `ord_afich` int(11) DEFAULT '0',
  PRIMARY KEY (`IDtourne`),
  KEY `WDIDX1706299980234` (`idadresse_livraison`),
  KEY `WDIDX1706299980235` (`Idordre_livraison_ml`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tourne`
--

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

--
-- Table structure for table `transporteur`
--

DROP TABLE IF EXISTS `transporteur`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `transporteur` (
  `idtransporteur` bigint(20) NOT NULL AUTO_INCREMENT,
  `source_id` varchar(50) DEFAULT '',
  `id_source_val` int(11) DEFAULT '0',
  PRIMARY KEY (`idtransporteur`),
  KEY `WDIDX1706299980236` (`id_source_val`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `transporteur`
--

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

--
-- Table structure for table `tresorerie`
--

DROP TABLE IF EXISTS `tresorerie`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tresorerie` (
  `idtresorerie` bigint(20) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(50) DEFAULT '',
  `solde_initial` float DEFAULT '0',
  `date_solde` date DEFAULT NULL,
  `num_compte` varchar(50) DEFAULT '',
  `nom_agence` varchar(50) DEFAULT '',
  `date_ouverture` date DEFAULT NULL,
  `date_cloture` date DEFAULT NULL,
  `proprietaire` varchar(50) CHARACTER SET ucs2 DEFAULT '',
  `localisation` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `description` longtext CHARACTER SET ucs2,
  `documents` varchar(50) DEFAULT '',
  `Idtype_tresorerie` bigint(20) DEFAULT '0',
  `code_tres` varchar(50) DEFAULT '',
  PRIMARY KEY (`idtresorerie`),
  KEY `WDIDX1706299980237` (`libelle`),
  KEY `WDIDX1706299980238` (`Idtype_tresorerie`),
  KEY `WDIDX1706299980239` (`code_tres`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tresorerie`
--

LOCK TABLES `tresorerie` WRITE;
/*!40000 ALTER TABLE `tresorerie` DISABLE KEYS */;
INSERT INTO `tresorerie` VALUES (1,'Caisse principale',0,NULL,'','',NULL,NULL,'','',NULL,'',0,'CP_N_EDITE');
/*!40000 ALTER TABLE `tresorerie` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `type_composant`
--

DROP TABLE IF EXISTS `type_composant`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `type_composant` (
  `IDtype_composant` bigint(20) NOT NULL AUTO_INCREMENT,
  `Désignation` varchar(250) DEFAULT '',
  `val_long` tinyint(4) DEFAULT '0',
  `val_larg` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`IDtype_composant`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `type_composant`
--

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

--
-- Table structure for table `type_loc_rest`
--

DROP TABLE IF EXISTS `type_loc_rest`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `type_loc_rest` (
  `IDtype_loc_rest` bigint(20) NOT NULL AUTO_INCREMENT,
  `code_type` varchar(50) DEFAULT '',
  `libelle_type` varchar(150) CHARACTER SET ucs2 DEFAULT '',
  `compteur` int(11) DEFAULT '0',
  `sense_stock` varchar(50) DEFAULT '',
  PRIMARY KEY (`IDtype_loc_rest`),
  KEY `WDIDX1706299980240` (`code_type`),
  KEY `IDX_type_loc_rest_code_type` (`code_type`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `type_loc_rest`
--

LOCK TABLES `type_loc_rest` WRITE;
/*!40000 ALTER TABLE `type_loc_rest` DISABLE KEYS */;
INSERT INTO `type_loc_rest` VALUES (1,'LOC','Location  ',0,'SORTIE'),(2,'REST','Restitution  ',0,'ENTREE');
/*!40000 ALTER TABLE `type_loc_rest` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `type_operation`
--

DROP TABLE IF EXISTS `type_operation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `type_operation` (
  `idtype_operation` bigint(20) NOT NULL AUTO_INCREMENT,
  `libelle_type` varchar(50) CHARACTER SET ucs2 DEFAULT '',
  `sens_operation` int(11) DEFAULT '0',
  PRIMARY KEY (`idtype_operation`),
  KEY `WDIDX1706299980241` (`sens_operation`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `type_operation`
--

LOCK TABLES `type_operation` WRITE;
/*!40000 ALTER TABLE `type_operation` DISABLE KEYS */;
INSERT INTO `type_operation` VALUES (1,'Encaissement',1),(2,'Dépense',2);
/*!40000 ALTER TABLE `type_operation` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `type_piece_achat`
--

DROP TABLE IF EXISTS `type_piece_achat`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `type_piece_achat` (
  `IDTYPE_PIECE_ACHAT` int(11) NOT NULL AUTO_INCREMENT,
  `Designation` varchar(50) DEFAULT '',
  `NUM_Piece_ACHATS` bigint(20) unsigned DEFAULT '0',
  `STOCK` varchar(20) DEFAULT 'Inchangé',
  `Prefixe` varchar(50) DEFAULT '',
  `FLAG_CA` tinyint(4) DEFAULT '0',
  `FLAG_STOCK` tinyint(4) DEFAULT '0',
  `IDLISTE_DEPOTS` int(11) DEFAULT '0',
  PRIMARY KEY (`IDTYPE_PIECE_ACHAT`),
  KEY `WDIDX1706299980242` (`NUM_Piece_ACHATS`),
  KEY `WDIDX1706299980243` (`IDLISTE_DEPOTS`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `type_piece_achat`
--

LOCK TABLES `type_piece_achat` WRITE;
/*!40000 ALTER TABLE `type_piece_achat` DISABLE KEYS */;
INSERT INTO `type_piece_achat` VALUES (1,'FACTURE',0,'Augmentation','FF ',1,1,1),(2,'AVOIR',0,'Diminution','AV ',1,1,1),(3,'BON DE RECEPTION',0,'Augmentation','BRA',0,1,1),(4,'BON DE LIVRAISON',0,'Augmentation','BLA',0,1,1),(5,'DEVIS',0,'Inchangé','DF ',0,0,1),(6,'BON DE CAISSE',0,'Augmentation','BC ',1,1,1),(7,'BON DE COMMANDE',0,'Inchangé','CO ',0,0,1),(8,'DEMANDE D’ACHAT',0,'Inchangé','DA',0,0,1),(9,'BON DE RETOUR',0,'Diminution','BRTA',0,1,1);
/*!40000 ALTER TABLE `type_piece_achat` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `type_piece_vente`
--

DROP TABLE IF EXISTS `type_piece_vente`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `type_piece_vente` (
  `Designation` varchar(50) DEFAULT '',
  `NUM_Piece_VENTE` bigint(20) unsigned DEFAULT '0',
  `STOCK` varchar(20) DEFAULT 'Inchangé',
  `IDTYPE_PIECE_vente` bigint(20) NOT NULL AUTO_INCREMENT,
  `Prefixe` varchar(50) DEFAULT '',
  `FLAG_CA` tinyint(4) DEFAULT '0',
  `FLAG_STOCK` tinyint(4) DEFAULT '0',
  `IDLISTE_DEPOTS` int(11) DEFAULT '0',
  `Modele_impression` varchar(20) DEFAULT '',
  `cal_tva` tinyint(4) DEFAULT '0',
  `cal_timbre` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`IDTYPE_PIECE_vente`),
  KEY `WDIDX1706299980244` (`Designation`),
  KEY `WDIDX1706299980245` (`NUM_Piece_VENTE`),
  KEY `WDIDX1706299980246` (`Prefixe`),
  KEY `WDIDX1706299980247` (`IDLISTE_DEPOTS`),
  KEY `WDIDX_TYPE_PIECE_VENTE_Designation` (`Designation`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `type_piece_vente`
--

LOCK TABLES `type_piece_vente` WRITE;
/*!40000 ALTER TABLE `type_piece_vente` DISABLE KEYS */;
INSERT INTO `type_piece_vente` VALUES ('BON DE COMMANDE',0,'Inchangé',1,'CO',0,0,1,'',1,1),('FACTURE',0,'Diminution',2,'FA',1,1,1,'',1,1),('DEVIS',0,'Inchangé',3,'DE',0,0,1,'',1,1),('BON DE CAISSE',0,'Diminution',4,'BC',1,1,1,'',1,1),('BON DE LIVRAISON',0,'Diminution',5,'BL',0,1,1,'',1,1),('AVOIR',0,'Augmentation',6,'AV',1,1,1,'',1,1),('BON DE SORTIE',0,'Diminution',7,'BS',0,1,1,'',1,1),('BON DE RETOUR',0,'Augmentation',8,'BR',0,1,1,'',1,1),('BON DE RESERVATION',0,'Inchangé',9,'RES',0,0,1,'',1,1),('SERVICE APRES VENTE',0,'Inchangé',10,'SAV',0,0,1,'',1,1);
/*!40000 ALTER TABLE `type_piece_vente` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `type_tresorerie`
--

DROP TABLE IF EXISTS `type_tresorerie`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `type_tresorerie` (
  `idtype_tresorerie` bigint(20) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(50) CHARACTER SET ucs2 DEFAULT '',
  PRIMARY KEY (`idtype_tresorerie`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `type_tresorerie`
--

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

--
-- Table structure for table `unite_mesure`
--

DROP TABLE IF EXISTS `unite_mesure`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `unite_mesure` (
  `IDUnite_mesure` int(11) NOT NULL AUTO_INCREMENT,
  `designation` varchar(50) DEFAULT '',
  PRIMARY KEY (`IDUnite_mesure`),
  KEY `WDIDX1706299980248` (`designation`),
  KEY `indDesignation` (`designation`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `unite_mesure`
--

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

--
-- Table structure for table `utilisateur_client`
--

DROP TABLE IF EXISTS `utilisateur_client`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `utilisateur_client` (
  `IDutilisateur_client` bigint(20) NOT NULL AUTO_INCREMENT,
  `idutilisateur` int(11) DEFAULT '0',
  `IDClient` int(11) DEFAULT '0',
  PRIMARY KEY (`IDutilisateur_client`),
  KEY `WDIDX1706299981285` (`idutilisateur`),
  KEY `WDIDX1706299981286` (`IDClient`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `utilisateur_client`
--

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

--
-- Table structure for table `utilisateur_depot`
--

DROP TABLE IF EXISTS `utilisateur_depot`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `utilisateur_depot` (
  `IDutilisateur_depot` bigint(20) NOT NULL AUTO_INCREMENT,
  `iddepot` int(11) DEFAULT '0',
  `idutilisateur` int(11) DEFAULT '0',
  PRIMARY KEY (`IDutilisateur_depot`),
  KEY `WDIDX1706299981281` (`iddepot`),
  KEY `WDIDX1706299981282` (`idutilisateur`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `utilisateur_depot`
--

LOCK TABLES `utilisateur_depot` WRITE;
/*!40000 ALTER TABLE `utilisateur_depot` DISABLE KEYS */;
INSERT INTO `utilisateur_depot` VALUES (1,1,1),(2,1,2);
/*!40000 ALTER TABLE `utilisateur_depot` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `utilisateur_vente`
--

DROP TABLE IF EXISTS `utilisateur_vente`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `utilisateur_vente` (
  `IDutilisateur_vente` bigint(20) NOT NULL AUTO_INCREMENT,
  `idutilisateur` int(11) DEFAULT '0',
  `IDVente` int(11) DEFAULT '0',
  PRIMARY KEY (`IDutilisateur_vente`),
  KEY `WDIDX1706299981283` (`idutilisateur`),
  KEY `WDIDX1706299981284` (`IDVente`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `utilisateur_vente`
--

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

--
-- Table structure for table `vehicule`
--

DROP TABLE IF EXISTS `vehicule`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vehicule` (
  `idvehicule` bigint(20) NOT NULL AUTO_INCREMENT,
  `designation` varchar(50) DEFAULT '',
  `mise_circulation` date DEFAULT NULL,
  `carte_grise` varchar(50) DEFAULT '',
  `tonnage` varchar(50) DEFAULT '',
  `Idmarque_vehicule` bigint(20) DEFAULT '0',
  `imatriculation` varchar(50) DEFAULT '',
  `notes` varchar(50) DEFAULT '',
  `statut_vehi` int(11) DEFAULT '0',
  PRIMARY KEY (`idvehicule`),
  KEY `WDIDX1706299980249` (`Idmarque_vehicule`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `vehicule`
--

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

--
-- Table structure for table `ventes`
--

DROP TABLE IF EXISTS `ventes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ventes` (
  `IDVentes` int(11) NOT NULL AUTO_INCREMENT,
  `date_vente` date DEFAULT NULL,
  `type_vente` varchar(50) DEFAULT '',
  `Mode_reglement` varchar(50) DEFAULT '0',
  `Total_HT` double DEFAULT '0',
  `Total_TTC` double DEFAULT '0',
  `TVA` double DEFAULT '0',
  `Timbre` double DEFAULT '0',
  `Exonoration_fisacle` tinyint(3) unsigned DEFAULT '0',
  `IDClient` int(11) DEFAULT '0',
  `NUM_Piece` varchar(20) DEFAULT '',
  `Notes` longtext,
  `MONTANT_regler` double DEFAULT NULL,
  `Reste_a_regeler` double DEFAULT NULL,
  `transf` varchar(20) DEFAULT 'NON',
  `mois_vente` varchar(50) DEFAULT '',
  `sens` varchar(50) DEFAULT '',
  `Tarif_applique` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `Objet_de_vente` longtext,
  `Nom_RS` varchar(200) CHARACTER SET utf8 DEFAULT NULL,
  `PIECE_ORIGINE` varchar(50) DEFAULT '',
  `FLAG_STOCK` varchar(3) DEFAULT '',
  `FLAG_CA` varchar(50) DEFAULT '',
  `ETAT_PIECE` varchar(50) DEFAULT '',
  `Origine_impc_st` varchar(50) DEFAULT 'OUI',
  `Reprise` varchar(50) DEFAULT '',
  `CA_Impact_` int(11) DEFAULT '0',
  `STK_Impact_` int(11) DEFAULT '0',
  `IMP_ANCIEN_SOLD_bon` varchar(50) DEFAULT '',
  `ID_DEPOT_V` int(11) DEFAULT '0',
  `ANNEE_CREATE` varchar(50) DEFAULT '',
  `Validite_jours` varchar(20) DEFAULT '',
  `Garantie` varchar(20) DEFAULT '',
  `Texte_suplem` varchar(1500) DEFAULT '',
  `bon_de_commande_N` varchar(250) DEFAULT NULL,
  `id_session` int(11) DEFAULT '0',
  `Mont_remise_supplem` double DEFAULT NULL,
  `Remise_calcule` double DEFAULT NULL,
  `Total_TUAR` double DEFAULT '0',
  `Total_remise` double DEFAULT NULL,
  `intermidiaire_v` int(11) DEFAULT '0',
  `appliq_retenu_garante` tinyint(4) DEFAULT '0',
  `aplique_retenu_sur` int(11) DEFAULT '0',
  `taux_de_retenue` double DEFAULT '0',
  `montant_de_retenue` double DEFAULT '0',
  `imp_compt_banc_1` tinyint(4) DEFAULT '0',
  `imp_compt_banc_2` tinyint(4) DEFAULT '0',
  `contenu_compt_banc_1` longtext,
  `contenu_compt_banc_2` longtext,
  `Total_HT_apre_ret` double DEFAULT '0',
  `Total_TVA_Apres_retenue` double DEFAULT '0',
  `Total_TIMBRE_Apres_retenue` double DEFAULT '0',
  `Total_TTC_apre_ret` double DEFAULT '0',
  `num_demande_devis` varchar(100) CHARACTER SET ucs2 DEFAULT '',
  `mod_gest_depot` int(11) DEFAULT '0',
  `Jour_avant_la_date` int(11) DEFAULT '0',
  `Activer_l_alerte` tinyint(4) DEFAULT '0',
  `date_echeance` date DEFAULT NULL,
  `destinataire_piece` longtext CHARACTER SET ucs2,
  `facture_num` longtext CHARACTER SET ucs2,
  `Idordre_livraison_ML` bigint(20) DEFAULT '0',
  `adresse_livraison` longtext CHARACTER SET ucs2,
  `date_livraison` date DEFAULT NULL,
  `num_piece_cl` varchar(50) DEFAULT '',
  `date_piece_cl` date DEFAULT NULL,
  `idlocations_restitutions` bigint(20) DEFAULT '0',
  `delais_granti_txt_complem` longtext CHARACTER SET ucs2,
  `remise_saisie_ht` double DEFAULT '0',
  `heur_creation` time DEFAULT '00:00:00',
  `heur_modif` time DEFAULT '00:00:00',
  `Num_compt_banc_1` varchar(50) DEFAULT '',
  `creer_par` varchar(50) DEFAULT '',
  `cal_timbre_vente` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`IDVentes`),
  KEY `WDIDX1706299980250` (`date_vente`),
  KEY `WDIDX1706299980251` (`type_vente`),
  KEY `WDIDX1706299980252` (`Mode_reglement`),
  KEY `WDIDX1706299980253` (`Exonoration_fisacle`),
  KEY `WDIDX1706299980254` (`IDClient`),
  KEY `WDIDX1706299980255` (`NUM_Piece`),
  KEY `WDIDX1706299980256` (`mois_vente`),
  KEY `WDIDX1706299980257` (`sens`),
  KEY `WDIDX1706299980258` (`Nom_RS`),
  KEY `WDIDX1706299980259` (`FLAG_STOCK`),
  KEY `WDIDX1706299980260` (`FLAG_CA`),
  KEY `WDIDX1706299980261` (`ETAT_PIECE`),
  KEY `WDIDX1706299980262` (`Origine_impc_st`),
  KEY `WDIDX1706299980263` (`Reprise`),
  KEY `WDIDX1706299980264` (`ID_DEPOT_V`),
  KEY `WDIDX1706299980265` (`ANNEE_CREATE`),
  KEY `WDIDX1706299980266` (`id_session`),
  KEY `WDIDX1706299980267` (`Idordre_livraison_ML`),
  KEY `WDIDX1706299980268` (`idlocations_restitutions`),
  KEY `IDX_ventes_flag_stock` (`FLAG_STOCK`),
  KEY `IDX_ventes_sens` (`sens`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ventes`
--

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

--
-- Table structure for table `versement_compte_client`
--

DROP TABLE IF EXISTS `versement_compte_client`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `versement_compte_client` (
  `IDVERSEMENT_COMPTE_CLIENT` bigint(20) NOT NULL AUTO_INCREMENT,
  `IDClient` int(11) DEFAULT '0',
  `MONTANT_DU_VERSEMENT` decimal(24,6) DEFAULT '0.000000',
  `DATE_VERSEMENT` date DEFAULT NULL,
  `MODE_VERSEMENT` varchar(50) DEFAULT '',
  `Notes` longtext CHARACTER SET utf8,
  `MONTANT_RESTANT` decimal(24,6) DEFAULT '0.000000',
  `Depuis_idventes` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `Insert_depuis` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `Idtresorerie` bigint(20) DEFAULT '0',
  `Idcategorie_operation` bigint(20) DEFAULT '0',
  `ref_versement` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `heur_v` time DEFAULT '00:00:00',
  PRIMARY KEY (`IDVERSEMENT_COMPTE_CLIENT`),
  KEY `WDIDX1706299980269` (`IDClient`),
  KEY `WDIDX1706299980270` (`DATE_VERSEMENT`),
  KEY `WDIDX1706299980271` (`Depuis_idventes`),
  KEY `WDIDX1706299980272` (`Idtresorerie`),
  KEY `WDIDX1706299980273` (`Idcategorie_operation`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `versement_compte_client`
--

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

--
-- Table structure for table `versement_compte_fournisseur`
--

DROP TABLE IF EXISTS `versement_compte_fournisseur`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `versement_compte_fournisseur` (
  `IDVERSSEMENT_COMPTE_FOURNISSEUR` int(11) NOT NULL AUTO_INCREMENT,
  `MONTANT_DU_VERSEMENT_f` double DEFAULT '0',
  `DATE_VERSEMENT_F` date DEFAULT NULL,
  `MODE_VERSEMENT_F` varchar(50) DEFAULT '0,00',
  `MONTANT_RESTANT_F` double DEFAULT '0',
  `IDACHAT_ATTACH` int(11) DEFAULT '0',
  `nISert_depuis_A` varchar(50) DEFAULT '',
  `NOTES_F` longtext,
  `IDFournisseur` int(11) DEFAULT '0',
  `Idtresorerie` bigint(20) DEFAULT '0',
  `Idcategorie_operation` bigint(20) DEFAULT '0',
  `ref_paiement` varchar(150) DEFAULT '',
  PRIMARY KEY (`IDVERSSEMENT_COMPTE_FOURNISSEUR`),
  KEY `WDIDX1706299980274` (`IDACHAT_ATTACH`),
  KEY `WDIDX1706299980275` (`IDFournisseur`),
  KEY `WDIDX1706299980276` (`Idtresorerie`),
  KEY `WDIDX1706299980277` (`Idcategorie_operation`),
  KEY `WDIDX1706299980278` (`ref_paiement`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `versement_compte_fournisseur`
--

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

--
-- Table structure for table `wilaya`
--

DROP TABLE IF EXISTS `wilaya`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wilaya` (
  `idwilaya` bigint(20) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(100) CHARACTER SET ucs2 DEFAULT '',
  `Idpays` bigint(20) DEFAULT '0',
  `num_wilaya` varchar(50) DEFAULT '',
  PRIMARY KEY (`idwilaya`),
  KEY `WDIDX1706299980279` (`Idpays`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `wilaya`
--

LOCK TABLES `wilaya` WRITE;
/*!40000 ALTER TABLE `wilaya` DISABLE KEYS */;
/*!40000 ALTER TABLE `wilaya` 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 2024-01-26 21:22:39
