-- http://www.phpmyadmin.net
--
-- Serveur: localhost
-- Généré le : Sam 26 Mai 2018 à 11:29
-- Version du serveur: 5.0.51
-- Version de PHP: 5.2.6-1+lenny16




--
-- Base de données: `annuairedansec`
--

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

--
-- Structure de la table `5nref_user`
--

CREATE TABLE IF NOT EXISTS `5nref_user` (
  `id` int(11) NOT NULL auto_increment,
  `login` varchar(127) NOT NULL default '',
  `password` varchar(127) NOT NULL default '',
  `name` varchar(127) NOT NULL default '',
  `surname` varchar(127) NOT NULL default '',
  `id_group` int(11) NOT NULL default '0',
  `email` varchar(255) NOT NULL default '',
  `root` mediumint(9) NOT NULL default '0',
  `id_state` int(11) NOT NULL default '0',
  `hash` varchar(255) NOT NULL default '',
  `date_inscr` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COMMENT='Table des utilisateurs' AUTO_INCREMENT=4 ;

--
-- Contenu de la table `5nref_user`
--

INSERT INTO `5nref_user` (`id`, `login`, `password`, `name`, `surname`, `id_group`, `email`, `root`, `id_state`, `hash`, `date_inscr`) VALUES
(1, 'Michel', '13c1f1626003db16260d67d85e8bac39', 'SUPERADMIN', '', 0, 'annuairedanse@gmail.com', 1, 1, '', '2006-12-09 21:18:19'),
(2, 'azert', '40125a2d3bb37c8bc052bd53bbd8823f', 'qsd', 'azert', 0, 'contact2@annuaire-danse.com', 1, 1, '', '2006-12-12 17:16:15'),
(3, 'PIPO', '5fc53d1cdd78ed5b0ea32c5e8b68cbfc', 'Pipo', 'PIPO', 0, 'contact2@ecole-danse.net', 0, 4, 'CHANGE_MAIL4d096bbb4713a4a9e8a58ef9b2e4e708', '2006-12-17 16:17:25');
