-- Structure de la table `messages`
-- 

CREATE TABLE `messages` (
  `Num` int(11) NOT NULL auto_increment,
  `Sujet` varchar(50) NOT NULL default '',
  `Texte` text NOT NULL,
  `Date` varchar(10) NOT NULL default '',
  `Heure` varchar(8) NOT NULL default '',
  `Auteur` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`Num`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- Structure de la table `users`
-- 

CREATE TABLE `users` (
  `Nom` varchar(50) NOT NULL default '',
  `Prenom` varchar(30) NOT NULL default '',
  `Pseudo` varchar(50) NOT NULL default '',
  `Mail` varchar(50) NOT NULL default '',
  `Password` text NOT NULL,
  `Statut` tinyint(4) unsigned NOT NULL default '6',
  `userid` int(255) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`userid`),
  UNIQUE KEY `Pseudo` (`Pseudo`,`Mail`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;