-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version	5.1.30-community


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

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


--
-- Create schema gema
--

CREATE DATABASE IF NOT EXISTS gema;
USE gema;

--
-- Definition of table `categorie`
--

DROP TABLE IF EXISTS `categorie`;
CREATE TABLE `categorie` (
  `Cat` varchar(3) NOT NULL,
  `Intitule` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`Cat`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `categorie`
--

/*!40000 ALTER TABLE `categorie` DISABLE KEYS */;
INSERT INTO `categorie` (`Cat`,`Intitule`) VALUES 
 ('GR','GROSSISTE'),
 ('OR','ORDINAIRE'),
 ('SG','SEMI GROSSISTE');
/*!40000 ALTER TABLE `categorie` ENABLE KEYS */;


--
-- Definition of table `client`
--

DROP TABLE IF EXISTS `client`;
CREATE TABLE `client` (
  `NumCli` varchar(3) NOT NULL,
  `NomCli` varchar(50) DEFAULT NULL,
  `TelCli` varchar(15) DEFAULT NULL,
  `AdrCli` varchar(45) DEFAULT NULL,
  `Cat` varchar(15) DEFAULT NULL,
  `Compte` double DEFAULT NULL,
  PRIMARY KEY (`NumCli`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

/*!40000 ALTER TABLE `client` DISABLE KEYS */;
INSERT INTO `client` (`NumCli`,`NomCli`,`TelCli`,`AdrCli`,`Cat`,`Compte`) VALUES 
 ('001','A-CltGros','95-00-00-00','Godomey','GR',-19000),
 ('002','A-CltDétail','97-00-00-00','Godomey','OR',0),
 ('003','A-CltSemiGros','94-00-00-00','Pahou','SG',-754000);
/*!40000 ALTER TABLE `client` ENABLE KEYS */;


--
-- Definition of table `commande`
--

DROP TABLE IF EXISTS `commande`;
CREATE TABLE `commande` (
  `CodCom` varchar(6) NOT NULL,
  `DatCom` datetime DEFAULT NULL,
  `MontCom` double DEFAULT NULL,
  `NumFrs` varchar(3) DEFAULT NULL,
  PRIMARY KEY (`CodCom`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `commande`
--

/*!40000 ALTER TABLE `commande` DISABLE KEYS */;
/*!40000 ALTER TABLE `commande` ENABLE KEYS */;


--
-- Definition of table `commande1`
--

DROP TABLE IF EXISTS `commande1`;
CREATE TABLE `commande1` (
  `CodCom1` varchar(6) NOT NULL,
  `DatCom1` datetime DEFAULT NULL,
  `MontCom1` double DEFAULT NULL,
  `NumCli` varchar(6) DEFAULT NULL,
  PRIMARY KEY (`CodCom1`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `commande1`
--

/*!40000 ALTER TABLE `commande1` DISABLE KEYS */;
/*!40000 ALTER TABLE `commande1` ENABLE KEYS */;


--
-- Definition of table `commander`
--

DROP TABLE IF EXISTS `commander`;
CREATE TABLE `commander` (
  `CodCom` varchar(6) NOT NULL,
  `CodMat` varchar(5) NOT NULL,
  `QteCom` double DEFAULT NULL,
  `PrixCom` double DEFAULT NULL,
  `Montant` int(10) unsigned DEFAULT NULL,
  `QteRes` double DEFAULT NULL,
  PRIMARY KEY (`CodCom`,`CodMat`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `commander`
--

/*!40000 ALTER TABLE `commander` DISABLE KEYS */;
/*!40000 ALTER TABLE `commander` ENABLE KEYS */;


--
-- Definition of table `commander1`
--

DROP TABLE IF EXISTS `commander1`;
CREATE TABLE `commander1` (
  `CodCom1` varchar(6) NOT NULL,
  `CodPro` varchar(45) NOT NULL,
  `QteCom1` double DEFAULT NULL,
  `PrixCom1` double DEFAULT NULL,
  `Montant1` double DEFAULT NULL,
  `QteRes1` double DEFAULT NULL,
  PRIMARY KEY (`CodCom1`,`CodPro`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `commander1`
--

/*!40000 ALTER TABLE `commander1` DISABLE KEYS */;
/*!40000 ALTER TABLE `commander1` ENABLE KEYS */;


--
-- Definition of table `ctrlfact`
--

DROP TABLE IF EXISTS `ctrlfact`;
CREATE TABLE `ctrlfact` (
  `NumFac` varchar(10) DEFAULT NULL,
  `Valid` varchar(1) DEFAULT NULL,
  `Total` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ctrlfact`
--

/*!40000 ALTER TABLE `ctrlfact` DISABLE KEYS */;
INSERT INTO `ctrlfact` (`NumFac`,`Valid`,`Total`) VALUES 
 ('007117','N',3550);
/*!40000 ALTER TABLE `ctrlfact` ENABLE KEYS */;


--
-- Definition of table `depense`
--

DROP TABLE IF EXISTS `depense`;
CREATE TABLE `depense` (
  `Coddep` varchar(4) NOT NULL,
  `Motif` varchar(45) DEFAULT NULL,
  `MontDep` int(10) unsigned DEFAULT NULL,
  `DatDep` datetime DEFAULT NULL,
  `AutoDep` varchar(25) DEFAULT NULL,
  `BenDep` varchar(25) DEFAULT NULL,
  `CaisDep` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`Coddep`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `depense`
--

/*!40000 ALTER TABLE `depense` DISABLE KEYS */;
/*!40000 ALTER TABLE `depense` ENABLE KEYS */;


--
-- Definition of table `deposer`
--

DROP TABLE IF EXISTS `deposer`;
CREATE TABLE `deposer` (
  `Numcli` varchar(3) NOT NULL,
  `DatOp` datetime NOT NULL,
  `HeureOp` varchar(20) DEFAULT NULL,
  `Operation` varchar(15) NOT NULL,
  `MontIni` double DEFAULT NULL,
  `Montant` double DEFAULT NULL,
  `MontFin` double DEFAULT NULL,
  PRIMARY KEY (`Numcli`,`DatOp`,`Operation`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `deposer`
--

/*!40000 ALTER TABLE `deposer` DISABLE KEYS */;
/*!40000 ALTER TABLE `deposer` ENABLE KEYS */;


--
-- Definition of table `depot`
--

DROP TABLE IF EXISTS `depot`;
CREATE TABLE `depot` (
  `Code` varchar(3) NOT NULL,
  `DatDe` datetime DEFAULT NULL,
  `MontDe` double DEFAULT NULL,
  `NumCli` varchar(3) DEFAULT NULL,
  `Caisse` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`Code`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `depot`
--

/*!40000 ALTER TABLE `depot` DISABLE KEYS */;
/*!40000 ALTER TABLE `depot` ENABLE KEYS */;


--
-- Definition of table `determiner`
--

DROP TABLE IF EXISTS `determiner`;
CREATE TABLE `determiner` (
  `Cat` varchar(15) NOT NULL,
  `CodPro` varchar(6) NOT NULL,
  `Prixvent` double DEFAULT NULL,
  PRIMARY KEY (`Cat`,`CodPro`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `determiner`
--

/*!40000 ALTER TABLE `determiner` DISABLE KEYS */;
/*!40000 ALTER TABLE `determiner` ENABLE KEYS */;


--
-- Definition of table `fabrication`
--

DROP TABLE IF EXISTS `fabrication`;
CREATE TABLE `fabrication` (
  `NumFor` varchar(3) NOT NULL,
  `CodMat` varchar(4) NOT NULL,
  `QteFor` double DEFAULT NULL,
  `PrixFor` double unsigned DEFAULT NULL,
  `MontFor` double DEFAULT NULL,
  PRIMARY KEY (`NumFor`,`CodMat`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fabrication`
--

/*!40000 ALTER TABLE `fabrication` DISABLE KEYS */;
/*!40000 ALTER TABLE `fabrication` ENABLE KEYS */;


--
-- Definition of table `facture`
--

DROP TABLE IF EXISTS `facture`;
CREATE TABLE `facture` (
  `CodFac` varchar(6) NOT NULL,
  `DatFac` datetime DEFAULT NULL,
  `MontFac` int(10) unsigned DEFAULT NULL,
  `NumCli` varchar(3) DEFAULT NULL,
  `Mode` varchar(6) DEFAULT NULL,
  `Remise` int(10) unsigned DEFAULT NULL,
  `Net` double DEFAULT NULL,
  `Caisse` varchar(45) DEFAULT NULL,
  `Magasin` varchar(25) DEFAULT NULL,
  `CodCom1` varchar(6) DEFAULT NULL,
  PRIMARY KEY (`CodFac`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `facture`
--

/*!40000 ALTER TABLE `facture` DISABLE KEYS */;
/*!40000 ALTER TABLE `facture` ENABLE KEYS */;


--
-- Definition of table `famille`
--

DROP TABLE IF EXISTS `famille`;
CREATE TABLE `famille` (
  `CodFam` varchar(2) NOT NULL,
  `LibFam` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`CodFam`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

/*!40000 ALTER TABLE `famille` DISABLE KEYS */;
/*!40000 ALTER TABLE `famille` ENABLE KEYS */;


--
-- Definition of table `formule`
--

DROP TABLE IF EXISTS `formule`;
CREATE TABLE `formule` (
  `NumFor` varchar(3) NOT NULL,
  `Cout` double DEFAULT NULL,
  PRIMARY KEY (`NumFor`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `formule`
--

/*!40000 ALTER TABLE `formule` DISABLE KEYS */;
/*!40000 ALTER TABLE `formule` ENABLE KEYS */;


--
-- Definition of table `fournisseur`
--

DROP TABLE IF EXISTS `fournisseur`;
CREATE TABLE `fournisseur` (
  `NumFrs` varchar(3) NOT NULL,
  `RaisFrs` varchar(45) DEFAULT NULL,
  `TelFrs` varchar(15) DEFAULT NULL,
  `AdrFrs` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`NumFrs`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

/*!40000 ALTER TABLE `fournisseur` DISABLE KEYS */;
INSERT INTO `fournisseur` (`NumFrs`,`RaisFrs`,`TelFrs`,`AdrFrs`) VALUES 
 ('F01','NIGERIA','98-88-88-88','Mayitou');
/*!40000 ALTER TABLE `fournisseur` ENABLE KEYS */;


--
-- Definition of table `livraison`
--

DROP TABLE IF EXISTS `livraison`;
CREATE TABLE `livraison` (
  `CodLiv` varchar(6) NOT NULL,
  `DatLiv` datetime DEFAULT NULL,
  `CodCom` varchar(6) DEFAULT NULL,
  `Total` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`CodLiv`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `livraison`
--

/*!40000 ALTER TABLE `livraison` DISABLE KEYS */;
/*!40000 ALTER TABLE `livraison` ENABLE KEYS */;


--
-- Definition of table `livrer`
--

DROP TABLE IF EXISTS `livrer`;
CREATE TABLE `livrer` (
  `CodMat` varchar(6) NOT NULL,
  `CodLiv` varchar(6) NOT NULL,
  `QteLiv` double DEFAULT NULL,
  `PrixLiv` double DEFAULT NULL,
  `MontLiv` double DEFAULT NULL,
  `QteRes` double DEFAULT NULL,
  PRIMARY KEY (`CodMat`,`CodLiv`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `livrer`
--

/*!40000 ALTER TABLE `livrer` DISABLE KEYS */;
/*!40000 ALTER TABLE `livrer` ENABLE KEYS */;


--
-- Definition of table `motpass`
--

DROP TABLE IF EXISTS `motpass`;
CREATE TABLE `motpass` (
  `Code` varchar(10) NOT NULL,
  `Nom` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`Code`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `motpass`
--

/*!40000 ALTER TABLE `motpass` DISABLE KEYS */;
INSERT INTO `motpass` (`Code`,`Nom`) VALUES 
 ('TIME05','ADMIN');
/*!40000 ALTER TABLE `motpass` ENABLE KEYS */;


--
-- Definition of table `personnel`
--

DROP TABLE IF EXISTS `personnel`;
CREATE TABLE `personnel` (
  `Numero` varchar(6) NOT NULL,
  `Nom` varchar(45) DEFAULT NULL,
  `Prenom` varchar(60) DEFAULT NULL,
  `Titre` varchar(25) DEFAULT NULL,
  `TelPer` varchar(15) DEFAULT NULL,
  `DatPer` datetime DEFAULT NULL,
  PRIMARY KEY (`Numero`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `personnel`
--

/*!40000 ALTER TABLE `personnel` DISABLE KEYS */;
INSERT INTO `personnel` (`Numero`,`Nom`,`Prenom`,`Titre`,`TelPer`,`DatPer`) VALUES 
 ('X001','Jean de Dieu',NULL,'Caissière','97-00-00-00','2019-08-05 00:00:00');
/*!40000 ALTER TABLE `personnel` ENABLE KEYS */;


--
-- Definition of table `pontmcf`
--

DROP TABLE IF EXISTS `pontmcf`;
CREATE TABLE `pontmcf` (
  `OPID` varchar(10) DEFAULT NULL,
  `OPNOM` varchar(32) DEFAULT NULL,
  `VT` varchar(2) DEFAULT NULL,
  `RT` varchar(2) DEFAULT NULL,
  `RN` varchar(50) DEFAULT NULL,
  `CIFU` varchar(50) DEFAULT NULL,
  `CNOM` varchar(100) DEFAULT NULL,
  `CEX` varchar(10) DEFAULT NULL,
  `NOM` varchar(100) DEFAULT NULL,
  `DESK` varchar(24) DEFAULT NULL,
  `TAX` varchar(10) DEFAULT NULL,
  `PR` float DEFAULT NULL,
  `QT` float DEFAULT NULL,
  `TS` float DEFAULT NULL,
  `TSDESC` varchar(16) DEFAULT NULL,
  `PRORIG` float DEFAULT NULL,
  `PRDESC` varchar(24) DEFAULT NULL,
  `PA` varchar(1) DEFAULT NULL,
  `MT` float DEFAULT NULL,
  `CODE` varchar(30) DEFAULT NULL,
  `VALIDE` varchar(1) DEFAULT NULL,
  `DOMAINE` varchar(30) DEFAULT NULL,
  `CTRLFACT` varchar(30) DEFAULT NULL,
  `TYPEFACT` varchar(100) DEFAULT NULL,
  `NIVEAUMCF` varchar(10) DEFAULT NULL,
  `TAUXTS` varchar(10) DEFAULT NULL,
  `GRPTAXE` varchar(10) DEFAULT NULL,
  `ORDRE` int(10) unsigned DEFAULT NULL,
  `LIBP` varchar(180) DEFAULT NULL,
  `EMB` varchar(50) DEFAULT NULL,
  `SEQUENCE` int(10) unsigned DEFAULT NULL,
  `ADRESSECLI` varchar(50) DEFAULT NULL,
  `COMPTEUR` int(10) unsigned DEFAULT NULL,
  `TXTVA` float DEFAULT NULL,
  `TXAIB` float DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pontmcf`
--

/*!40000 ALTER TABLE `pontmcf` DISABLE KEYS */;
INSERT INTO `pontmcf` (`OPID`,`OPNOM`,`VT`,`RT`,`RN`,`CIFU`,`CNOM`,`CEX`,`NOM`,`DESK`,`TAX`,`PR`,`QT`,`TS`,`TSDESC`,`PRORIG`,`PRDESC`,`PA`,`MT`,`CODE`,`VALIDE`,`DOMAINE`,`CTRLFACT`,`TYPEFACT`,`NIVEAUMCF`,`TAUXTS`,`GRPTAXE`,`ORDRE`,`LIBP`,`EMB`,`SEQUENCE`,`ADRESSECLI`,`COMPTEUR`,`TXTVA`,`TXAIB`) VALUES 
 ('SAG05','ADMIN','F',NULL,NULL,'2200801012509','M. AFATONDJI ROSE','VIDE','ALFAPOR 30 ML','PH052','A',800,2,NULL,NULL,NULL,NULL,'E',NULL,'007117',NULL,'Commerciale',NULL,'FV',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'97-22-58-52',NULL,0,0),
 ('SAG05','ADMIN','F',NULL,NULL,'2200801012509','M. AFATONDJI ROSE','VIDE','ALFACERYL 100 G','PH026','A',1950,1,NULL,NULL,NULL,NULL,'E',NULL,'007117',NULL,'Commerciale',NULL,'FV',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'97-22-58-52',NULL,0,0);
/*!40000 ALTER TABLE `pontmcf` ENABLE KEYS */;


--
-- Definition of table `produit`
--

DROP TABLE IF EXISTS `produit`;
CREATE TABLE `produit` (
  `CodPro` varchar(6) NOT NULL DEFAULT '',
  `DesPro` varchar(60) DEFAULT NULL,
  `Stock` double DEFAULT NULL,
  `CodFam` varchar(3) DEFAULT NULL,
  `Prix` double DEFAULT NULL,
  `Stock2` double DEFAULT NULL,
  `NumFor` varchar(3) DEFAULT NULL,
  PRIMARY KEY (`CodPro`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `produit`
--

/*!40000 ALTER TABLE `produit` DISABLE KEYS */;
/*!40000 ALTER TABLE `produit` ENABLE KEYS */;


--
-- Definition of table `regler`
--

DROP TABLE IF EXISTS `regler`;
CREATE TABLE `regler` (
  `NumFrs` varchar(6) NOT NULL,
  `DatReg` datetime NOT NULL,
  `Nature` varchar(15) DEFAULT NULL,
  `MontReg` int(10) unsigned DEFAULT NULL,
  `MontRes` int(10) unsigned DEFAULT NULL,
  `TotReg` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`NumFrs`,`DatReg`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `regler`
--

/*!40000 ALTER TABLE `regler` DISABLE KEYS */;
/*!40000 ALTER TABLE `regler` ENABLE KEYS */;


--
-- Definition of table `sortie`
--

DROP TABLE IF EXISTS `sortie`;
CREATE TABLE `sortie` (
  `CodSor` varchar(8) NOT NULL,
  `CodMat` varchar(4) NOT NULL,
  `QteSor` double DEFAULT NULL,
  `PrixSor` int(10) unsigned DEFAULT NULL,
  `MontSor` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`CodSor`,`CodMat`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sortie`
--

/*!40000 ALTER TABLE `sortie` DISABLE KEYS */;
/*!40000 ALTER TABLE `sortie` ENABLE KEYS */;


--
-- Definition of table `stocker`
--

DROP TABLE IF EXISTS `stocker`;
CREATE TABLE `stocker` (
  `CodMat` varchar(6) NOT NULL,
  `DatStock` datetime NOT NULL,
  `Heure` varchar(12) DEFAULT NULL,
  `Nature` varchar(8) NOT NULL,
  `QteIni` double DEFAULT NULL,
  `Qte` double DEFAULT NULL,
  `QteFin` double DEFAULT NULL,
  PRIMARY KEY (`CodMat`,`DatStock`,`Nature`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `stocker`
--

/*!40000 ALTER TABLE `stocker` DISABLE KEYS */;
/*!40000 ALTER TABLE `stocker` ENABLE KEYS */;


--
-- Definition of table `tampon`
--

DROP TABLE IF EXISTS `tampon`;
CREATE TABLE `tampon` (
  `CodTam` varchar(10) DEFAULT NULL,
  `Libelle` varchar(60) DEFAULT NULL,
  `Date` datetime DEFAULT NULL,
  `Qte` double DEFAULT NULL,
  `Stock` double DEFAULT NULL,
  `Montant` double DEFAULT NULL,
  `Prix` double DEFAULT NULL,
  `Mont` double DEFAULT NULL,
  `Nombre` double DEFAULT NULL,
  `QteRes` double DEFAULT NULL,
  `NumFrs` varchar(20) DEFAULT NULL,
  `Caisse` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tampon`
--

/*!40000 ALTER TABLE `tampon` DISABLE KEYS */;
/*!40000 ALTER TABLE `tampon` ENABLE KEYS */;


--
-- Definition of table `tampon1`
--

DROP TABLE IF EXISTS `tampon1`;
CREATE TABLE `tampon1` (
  `Numero` varchar(6) DEFAULT NULL,
  `Intitule` varchar(60) DEFAULT NULL,
  `QteIni` double DEFAULT NULL,
  `Qte` double DEFAULT NULL,
  `QteFin` double DEFAULT NULL,
  `Prix1` double DEFAULT NULL,
  `Montant1` double DEFAULT NULL,
  `Mont1` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tampon1`
--

/*!40000 ALTER TABLE `tampon1` DISABLE KEYS */;
/*!40000 ALTER TABLE `tampon1` ENABLE KEYS */;


--
-- Definition of table `vente`
--

DROP TABLE IF EXISTS `vente`;
CREATE TABLE `vente` (
  `CodFac` varchar(6) NOT NULL,
  `CodPro` varchar(6) NOT NULL,
  `Qtevendu` double DEFAULT NULL,
  `Prixvendu` double DEFAULT NULL,
  `Montvendu` double DEFAULT NULL,
  `Taux` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`CodFac`,`CodPro`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `vente`
--

/*!40000 ALTER TABLE `vente` DISABLE KEYS */;
/*!40000 ALTER TABLE `vente` ENABLE KEYS */;


--
-- Definition of table `verser`
--

DROP TABLE IF EXISTS `verser`;
CREATE TABLE `verser` (
  `CodFac` varchar(6) NOT NULL,
  `DatVer` datetime NOT NULL,
  `HeureVer` varchar(10) NOT NULL,
  `MontVer` int(10) unsigned DEFAULT NULL,
  `Reste` int(10) unsigned DEFAULT NULL,
  `NatVer` varchar(8) DEFAULT NULL,
  `Caisse` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`CodFac`,`DatVer`,`HeureVer`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `verser`
--

/*!40000 ALTER TABLE `verser` DISABLE KEYS */;
/*!40000 ALTER TABLE `verser` ENABLE KEYS */;




/*!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 */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;