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;
--
-- 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;
--
-- 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;
Partager