-- phpMyAdmin SQL Dump
-- version 4.2.5
-- http://www.phpmyadmin.net
--
-- Client :  localhost:3306
-- Généré le :  Mer 17 Juin 2015 à 18:51
-- Version du serveur :  5.5.41-MariaDB
-- Version de PHP :  5.5.21

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

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

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

--
-- Structure de la table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
`id` int(11) NOT NULL,
  `userID` varchar(25) COLLATE utf8_bin NOT NULL,
  `date_inscri` date NOT NULL,
  `heure_inscri` time NOT NULL,
  `date_abonnement` date NOT NULL,
  `fin_abonnement` date NOT NULL,
  `mois_abonnement` int(3) NOT NULL,
  `jour_promo` int(11) NOT NULL,
  `lien_promotion` varchar(20) COLLATE utf8_bin NOT NULL,
  `date_last_visite` datetime NOT NULL,
  `ip_adr` varchar(16) COLLATE utf8_bin NOT NULL,
  `login` varchar(100) COLLATE utf8_bin NOT NULL,
  `date_password` datetime NOT NULL,
  `password_hash` varchar(250) COLLATE utf8_bin NOT NULL,
  `password` varchar(25) COLLATE utf8_bin NOT NULL,
  `pseudo` varchar(14) COLLATE utf8_bin NOT NULL,
  `qualite` varchar(5) COLLATE utf8_bin NOT NULL,
  `nom` varchar(50) COLLATE utf8_bin NOT NULL,
  `prenom` varchar(50) COLLATE utf8_bin NOT NULL,
  `notes_user` varchar(250) COLLATE utf8_bin NOT NULL,
  `departement` varchar(2) COLLATE utf8_bin NOT NULL,
  `email` varchar(50) COLLATE utf8_bin NOT NULL,
  `valid_mail` int(11) NOT NULL DEFAULT '1',
  `confirm_mail` int(11) NOT NULL,
  `date_confirm_mail` datetime NOT NULL,
  `usurpation_mail` int(11) NOT NULL,
  `date_signalement` datetime NOT NULL,
  `ouverture_mail_user` int(11) NOT NULL,
  `date_ouverture_mail` date NOT NULL,
  `jour_ouverture_mail` int(11) NOT NULL,
  `envoi_mail_jour` int(11) NOT NULL,
  `lang_mail` varchar(3) COLLATE utf8_bin NOT NULL DEFAULT 'fr',
  `Stati_consult` int(6) NOT NULL,
  `long_compteur` int(2) NOT NULL DEFAULT '5',
  `type_compteur` varchar(25) COLLATE utf8_bin NOT NULL DEFAULT 'neon_vert',
  `option_online` int(11) NOT NULL,
  `option_minisite` int(11) NOT NULL,
  `date_demande_upgrade` date NOT NULL,
  `type_upgrade` int(2) NOT NULL,
  `type_paiement` varchar(25) COLLATE utf8_bin NOT NULL,
  `somme_paiement` varchar(10) COLLATE utf8_bin NOT NULL,
  `code_paiement` varchar(50) COLLATE utf8_bin NOT NULL,
  `groupe` varchar(10) COLLATE utf8_bin NOT NULL,
  `profil_visible` int(1) NOT NULL DEFAULT '1',
  `profil_online` int(1) NOT NULL DEFAULT '1',
  `profil_anonyme` int(11) NOT NULL,
  `active` int(1) NOT NULL,
  `blacklist` int(11) NOT NULL,
  `test_champ` text COLLATE utf8_bin NOT NULL,
  `pres_der_inscrit` int(11) NOT NULL,
  `surveillance` int(11) NOT NULL,
  `message_admin` int(11) NOT NULL,
  `menace` int(11) NOT NULL,
  `bloc_mail` int(11) NOT NULL,
  `bloc_mail_special` int(11) NOT NULL,
  `inscript_nuit` int(11) NOT NULL,
  `profil_interne` int(11) NOT NULL,
  `carrousel` int(11) NOT NULL,
  `up_photo` int(11) NOT NULL,
  `test_mail` int(11) NOT NULL,
  `autom_connex` int(11) NOT NULL,
  `autom_depart` time NOT NULL,
  `autom_fin` time NOT NULL,
  `autom_activ` int(11) NOT NULL
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1460 ;

--
-- Contenu de la table `users`
--

INSERT INTO `users` (`id`, `userID`, `date_inscri`, `heure_inscri`, `date_abonnement`, `fin_abonnement`, `mois_abonnement`, `jour_promo`, `lien_promotion`, `date_last_visite`, `ip_adr`, `login`, `date_password`, `password_hash`, `password`, `pseudo`, `qualite`, `nom`, `prenom`, `notes_user`, `departement`, `email`, `valid_mail`, `confirm_mail`, `date_confirm_mail`, `usurpation_mail`, `date_signalement`, `ouverture_mail_user`, `date_ouverture_mail`, `jour_ouverture_mail`, `envoi_mail_jour`, `lang_mail`, `Stati_consult`, `long_compteur`, `type_compteur`, `option_online`, `option_minisite`, `date_demande_upgrade`, `type_upgrade`, `type_paiement`, `somme_paiement`, `code_paiement`, `groupe`, `profil_visible`, `profil_online`, `profil_anonyme`, `active`, `blacklist`, `test_champ`, `pres_der_inscrit`, `surveillance`, `message_admin`, `menace`, `bloc_mail`, `bloc_mail_special`, `inscript_nuit`, `profil_interne`, `carrousel`, `up_photo`, `test_mail`, `autom_connex`, `autom_depart`, `autom_fin`, `autom_activ`) VALUES
(3, '160215110325', '2015-02-16', '00:00:00', '2015-02-16', '2015-08-25', 3, 0, '', '2015-06-17 18:39:48', '41.82.137.99', 'thierry', '2015-06-10 11:00:08', 'c40e869b08511507490bbdd6e7bd866c', '457584sTe', 'Philip', '253', 'Maurice', 'Thierry', '', '', 'thierry@gmail.com', 1, 1, '2015-05-31 19:44:13', 1, '2015-05-31 17:15:27', 0, '2015-06-08', 2, 0, 'fr', 0, 5, 'neon_vert', 0, 0, '0000-00-00', 0, '', '', '', '3', 1, 1, 0, 1, 0, '', 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 1, 1, '00:00:00', '00:00:00', 0);

--
-- Index pour les tables exportées
--

--
-- Index pour la table `users`
--
ALTER TABLE `users`
 ADD UNIQUE KEY `userID` (`userID`), ADD KEY `id` (`id`);

--
-- AUTO_INCREMENT pour les tables exportées
--

--
-- AUTO_INCREMENT pour la table `users`
--
ALTER TABLE `users`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1460;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;