1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| CREATE TABLE IF NOT EXISTS `operation_depenses` (
`id` int(12) NOT NULL AUTO_INCREMENT,
`id_achat_articles` int(12) NOT NULL,
`debit` decimal(7,2) NOT NULL,
`frais_livraison` decimal(7,2) NOT NULL,
`bon_reduction` decimal(7,2) NOT NULL,
`montant_total` decimal(7,2) NOT NULL,
`id_fournisseur` int(12) NOT NULL,
`id_filtre` int(12) NOT NULL,
`id_sous_filtre` int(12) NOT NULL,
`id_type_paiement` int(12) NOT NULL,
`numero_cheque` int(12) NOT NULL,
`date` datetime NOT NULL,
`id_membres` int(12) NOT NULL,
`commentaires` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=70 ; |
Partager