--
-- Structure de la table `CATEGORIES`
--
 
CREATE TABLE IF NOT EXISTS `CATEGORIES` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom_categorie` text collate latin1_general_ci NOT NULL,
  `description_categorie` text collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
 
--
-- Contenu de la table `CATEGORIES`
--
 
 
-- --------------------------------------------------------
--
-- Structure de la table `SOUS-CATEGORIES`
--
 
CREATE TABLE IF NOT EXISTS `SOUS-CATEGORIES` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_categorie` int(11) NOT NULL,
  `nom_sous-categorie` text collate latin1_general_ci NOT NULL,
  `description_sous-categorie` text collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
 
--
-- Contenu de la table `SOUS-CATEGORIES`
--

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



--
-- Structure de la table `CONTENU`
--
 
CREATE TABLE IF NOT EXISTS `CONTENU` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_sous-categorie` int(11) NOT NULL,
  `titre` text collate latin1_general_ci NOT NULL,
  `description` text collate latin1_general_ci NOT NULL,
  `texte` text collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
 
--
-- Contenu de la table `CONTENU`
--