--
-- Base de données: `test`
--
 
-- --------------------------------------------------------
 
--
-- Structure de la table `branche`
--
 
CREATE TABLE IF NOT EXISTS `branche` (
  `id_branche` int(3) NOT NULL AUTO_INCREMENT,
  `nom_branche` varchar(150) NOT NULL,
  `id_branche_parent` int(3) NOT NULL,
  PRIMARY KEY (`id_branche`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;
 
--
-- Contenu de la table `branche`
--
 
INSERT INTO `branche` (`id_branche`, `nom_branche`, `id_branche_parent`) VALUES
(1, 'branche 0', 0),
(2, 'branche 1', 1),
(3, 'branche 2', 1),
(4, 'branche 1-1', 2),
(5, 'branche 1-2', 2),
(6, 'branche 2-1', 3),
(7, 'branche 2-2', 3),
(8, 'branche 1-1-1', 4),
(9, 'branche 1-1-2', 4),
(10, 'branche 1-2-1', 5),
(11, 'branche 1-2-2', 5),
(12, 'branche 2-1-1', 6),
(13, 'branche 2-1-2', 6),
(14, 'branche 2-2-1', 7),
(15, 'branche 2-2-2', 7);
 
-- --------------------------------------------------------