CREATE TABLE `t_budgets` (
`id_budget` int(11) NOT NULL auto_increment,
`id_programme` varchar(100) NOT NULL,
`libelle` varchar(100) NOT NULL,
`comparaison` varchar(100) NOT NULL,
PRIMARY KEY (`id_budget`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
--
-- Contenu de la table `t_budgets`
--
INSERT INTO `t_budgets` (`id_budget`, `id_programme`, `libelle`, `comparaison`) VALUES
(0, '105', 'THTH', '0'),
(1, '100', 'TOTO', '1'),
(2, '101', 'TATA', '1'),
(3, '102', 'TUTU', '1');
-- --------------------------------------------------------
--
-- Structure de la table `t_lignes_budgets`
--
CREATE TABLE `t_lignes_budgets` (
`id_ligne_budget` int(11) NOT NULL auto_increment,
`id_budget` int(100) NOT NULL,
`code` varchar(100) NOT NULL,
`quantite` varchar(100) NOT NULL,
`prix_unitaire` varchar(100) NOT NULL,
`montant` varchar(100) default NULL,
PRIMARY KEY (`id_ligne_budget`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
--
-- Contenu de la table `t_lignes_budgets`
--
INSERT INTO `t_lignes_budgets` (`id_ligne_budget`, `id_budget`, `code`, `quantite`, `prix_unitaire`, `montant`) VALUES
(1, 1, 'A1', '34', '57', '800'),
(2, 1, 'A2', '23', '65', '705'),
(4, 1, 'A3', '23', '65', NULL);
Partager