-- Structure de la table `categorie`
--

CREATE TABLE IF NOT EXISTS `categorie` (
  `cat_id` int(11) NOT NULL auto_increment,
  `cat_titre` varchar(128) NOT NULL,
  `cat_niveau` int(11) NOT NULL,
  `cat_parent` int(11) NOT NULL,
  PRIMARY KEY  (`cat_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

-- --------------------------------------------------------

--
-- Structure de la table `contenu`
--

CREATE TABLE IF NOT EXISTS `contenu` (
  `cont_id` int(11) NOT NULL auto_increment,
  `cont_cat` int(11) NOT NULL default '0',
  `cont_titre` varchar(128) NOT NULL default '',
  `cont_description` text NOT NULL,
  `cont_fichier` varchar(500) NOT NULL,
  PRIMARY KEY  (`cont_id`),
  KEY `cont_cat` (`cont_cat`),
  KEY `cont_fichier` (`cont_fichier`),
  KEY `cont_id` (`cont_id`),
  KEY `cont_titre` (`cont_titre`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=624 ;

-- --------------------------------------------------------

--
-- Structure de la table `image`
--

CREATE TABLE IF NOT EXISTS `image` (
  `img_id` int(10) NOT NULL auto_increment,
  `img_contenu` int(10) NOT NULL,
  `img_fichier` varchar(256) character set latin1 collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`img_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=215 ;

-- --------------------------------------------------------

--
-- Structure de la table `user`
--

CREATE TABLE IF NOT EXISTS `user` (
  `user_id` int(11) NOT NULL auto_increment,
  `user_nom` varchar(16) collate latin1_general_ci NOT NULL default '',
  `user_prenom` varchar(16) collate latin1_general_ci NOT NULL default '',
  `user_login` varchar(16) collate latin1_general_ci NOT NULL default '',
  `user_pass` varchar(32) collate latin1_general_ci NOT NULL default '',
  `user_email` varchar(32) collate latin1_general_ci NOT NULL default '',
  `user_profil` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`user_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=21 ;