1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
|
--
-- Structure de la table `facture`
--
CREATE TABLE `facture` (
`id_facture` int(11) NOT NULL auto_increment,
`id_client` int(11) NOT NULL,
`numero` varchar(100) NOT NULL,
`montant` decimal(10,0) NOT NULL,
PRIMARY KEY (`id_facture`),
UNIQUE KEY `numero` (`numero`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;
--
-- Contenu de la table `facture`
--
INSERT INTO `facture` (`id_facture`, `id_client`, `numero`, `montant`) VALUES
(1, 5, 'shsg45345', '10'),
(2, 2, 'fghk75678', '23'),
(3, 2, 'sqdf35436', '125'),
(4, 3, 'dfv3543', '230'),
(5, 1, 'qsdg35463', '12'),
(6, 4, 'dfq68731', '15'),
(7, 1, 'sdf69431', '152'),
(8, 5, 'qsedf84764', '80'),
(9, 1, 'il38676', '30'),
(10, 4, 'tryjdty36873', '200'); |
Partager