pfe.sql

-- phpMyAdmin SQL Dump
-- version 4.0.4.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 18, 2014 at 03:01 PM
-- Server version: 5.6.12
-- PHP Version: 5.5.3

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 */;

--
-- Database: `pfe`
--
CREATE DATABASE IF NOT EXISTS `pfe` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `pfe`;

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

--
-- Table structure for table `city`
--

CREATE TABLE IF NOT EXISTS `city` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `cp` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `city`
--

INSERT INTO `city` (`id`, `name`, `description`, `cp`) VALUES
(1, 'Montpellier', 'Ville de couleur\r\n\r\nVille de chaleur', 34000),
(2, 'Lille', '', 59000);

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

--
-- Table structure for table `user`
--

CREATE TABLE IF NOT EXISTS `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `last_login` date DEFAULT NULL,
  `locked` tinyint(1) NOT NULL,
  `expired` tinyint(1) NOT NULL,
  `city_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=689 ;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`id`, `username`, `email`, `last_login`, `locked`, `expired`, `city_id`) VALUES
(1, 'cvideo', 'cvideo@secret.com', '2014-02-20', 0, 1, 2),
(2, 'ecomtet', 'ecomtet@secret.com', '2014-02-01', 0, 0, 1),
(3, 'vblondea', 'vblondea@secret.com', '2013-09-07', 0, 0, 1),
(4, 'jle-guen', 'jle-guen@secret.com', '2013-08-28', 0, 0, 1),
(5, 'mbridoux', 'mbridoux@secret.com', NULL, 0, 0, 1),
(6, 'jcarpen1', 'jcarpen1@secret.com', '2013-09-07', 0, 0, 1),
(7, 'blamure', 'blamure@secret.com', '2013-09-05', 0, 0, 1),
(8, 'vdupont', 'vdupont@secret.com', NULL, 0, 0, 1),
(9, 'srosener', 'srosener@secret.com', '2013-09-06', 0, 0, 1),
(10, 'dguerin1', 'dguerin1@secret.com', NULL, 0, 0, 1),
(11, 'ljager', 'ljager@secret.com', NULL, 0, 0, 1),
(12, 'ldehaudt', 'ldehaudt@secret.com', '2013-09-07', 0, 0, 1),
(13, 'tjochyms', 'tjochyms@secret.com', '2013-08-29', 0, 0, 1),
(14, 'jleclere', 'jleclere@secret.com', '2013-09-07', 0, 0, 1),
(15, 'tcorbier', 'tcorbier@secret.com', NULL, 0, 0, 1),
(16, 'qlambert', 'qlambert@secret.com', NULL, 0, 0, 1),
(17, 'dnaidoo-', 'dnaidoo-@secret.com', NULL, 0, 0, 1),
(18, 'erakotoz', 'erakotoz@secret.com', '2013-09-07', 0, 0, 1),
(19, 'alansell', 'alansell@secret.com', '2013-09-07', 0, 0, 1),
(20, 'cchaillo', 'cchaillo@secret.com', NULL, 0, 0, 1),
(21, 'vbailly', 'vbailly@secret.com', NULL, 0, 0, 1),
(22, 'agaraico', 'agaraico@secret.com', NULL, 0, 0, 1),
(23, 'adaviot', 'adaviot@secret.com', '2013-09-07', 0, 0, 1),
(24, 'crosales', 'crosales@secret.com', '2013-09-06', 0, 0, 1),
(25, 'sbouhila', 'sbouhila@secret.com', NULL, 0, 0, 1),
(26, 'gwernert', 'gwernert@secret.com', '2013-09-07', 0, 0, 1),
(27, 'mkoch', 'mkoch@secret.com', NULL, 0, 0, 1),
(28, 'cdelberg', 'cdelberg@secret.com', '2013-09-05', 0, 0, 1),
(29, 'epastor', 'epastor@secret.com', NULL, 0, 0, 1),
(30, 'tlahaye', 'tlahaye@secret.com', '2013-09-05', 0, 0, 1),
(31, 'mbayart1', 'mbayart1@secret.com', NULL, 0, 0, 1),
(32, 'paubrion', 'paubrion@secret.com', '2013-09-05', 0, 0, 1),
(33, 'nhusse', 'nhusse@secret.com', '2013-09-07', 0, 0, 1),
(34, 'fblanqua', 'fblanqua@secret.com', NULL, 0, 0, 1),
(35, 'rkrikori', 'rkrikori@secret.com', NULL, 0, 0, 1),
(36, 'bobrembs', 'bobrembs@secret.com', NULL, 0, 0, 1),
(37, 'mbertome', 'mbertome@secret.com', NULL, 0, 0, 1),
(38, 'dtarsita', 'dtarsita@secret.com', '2013-09-07', 0, 0, 1),
(39, 'kbensoud', 'kbensoud@secret.com', '2013-09-05', 0, 0, 1),
(40, 'mdujard1', 'mdujard1@secret.com', NULL, 0, 0, 1),
(41, 'edufaut', 'edufaut@secret.com', NULL, 0, 0, 1),
(42, 'gfouquet', 'gfouquet@secret.com', '2013-09-07', 0, 0, 1),
(43, 'rel-hons', 'rel-hons@secret.com', NULL, 0, 0, 1),
(44, 'aaubry', 'aaubry@secret.com', '2013-09-05', 0, 0, 1),
(45, 'fchretie', 'fchretie@secret.com', '2013-09-05', 0, 0, 1),
(46, 'camegavi', 'camegavi@secret.com', NULL, 0, 0, 1),
(47, 'eterrier', 'eterrier@secret.com', NULL, 0, 0, 1),
(48, 'camat', 'camat@secret.com', '2013-09-07', 0, 0, 1),
(49, 'fkapusta', 'fkapusta@secret.com', NULL, 0, 0, 1),
(50, 'vlejeune', 'vlejeune@secret.com', NULL, 0, 0, 1),
(51, 'qstevane', 'qstevane@secret.com', '2013-09-06', 0, 0, 1),
(52, 'vmoigner', 'vmoigner@secret.com', NULL, 0, 0, 1),
(53, 'mlelaure', 'mlelaure@secret.com', '2013-09-05', 0, 0, 1),
(54, 'edelabae', 'edelabae@secret.com', '2013-09-07', 0, 0, 1),
(55, 'ldelay', 'ldelay@secret.com', NULL, 0, 0, 1),
(56, 'cbaumann', 'cbaumann@secret.com', '2013-08-29', 0, 0, 1),
(57, 'cmartins', 'cmartins@secret.com', NULL, 0, 0, 1),
(58, 'amoy', 'amoy@secret.com', NULL, 0, 0, 1),
(59, 'mmbesot', 'mmbesot@secret.com', NULL, 0, 0, 1),
(60, 'sdi-mari', 'sdi-mari@secret.com', NULL, 0, 0, 1),
(61, 'mjustini', 'mjustini@secret.com', '2013-09-05', 0, 0, 1),
(62, 'mholland', 'mholland@secret.com', '2013-09-07', 0, 0, 1),
(63, 'nshabou', 'nshabou@secret.com', '2013-09-06', 0, 0, 1),
(64, 'mdietsch', 'mdietsch@secret.com', '2013-09-06', 0, 0, 1),
(65, 'fpasquie', 'fpasquie@secret.com', '2013-09-07', 0, 0, 1),
(66, 'oboujdar', 'oboujdar@secret.com', NULL, 0, 0, 1),
(67, 'qradufe', 'qradufe@secret.com', '2013-09-07', 0, 0, 1),
(68, 'jdescham', 'jdescham@secret.com', NULL, 0, 0, 1),
(69, 'hpham', 'hpham@secret.com', NULL, 0, 0, 1),
(70, 'jrosa', 'jrosa@secret.com', '2013-09-07', 0, 0, 1),
(71, 'apaillis', 'apaillis@secret.com', NULL, 0, 0, 1),
(72, 'lrodrig1', 'lrodrig1@secret.com', NULL, 0, 0, 1),
(73, 'jvincent', 'jvincent@secret.com', '2013-09-05', 0, 0, 1),
(74, 'mlemair1', 'mlemair1@secret.com', '2013-09-05', 0, 0, 1),
(75, 'qpesqueu', 'qpesqueu@secret.com', NULL, 0, 0, 1),
(76, 'pmboup', 'pmboup@secret.com', '2013-09-07', 0, 0, 1),
(77, 'jrukata-', 'jrukata-@secret.com', NULL, 0, 0, 1),
(78, 'mhauteco', 'mhauteco@secret.com', '2013-09-06', 0, 0, 1),
(79, 'rgouenar', 'rgouenar@secret.com', '2013-09-07', 0, 0, 1),
(80, 'malami-m', 'malami-m@secret.com', NULL, 0, 0, 1),
(81, 'nmairess', 'nmairess@secret.com', '2013-09-06', 0, 0, 1),
(82, 'nmartin1', 'nmartin1@secret.com', '2013-09-05', 0, 0, 1),
(83, 'cmonteir', 'cmonteir@secret.com', '2013-09-05', 0, 0, 1),
(84, 'csouchet', 'csouchet@secret.com', NULL, 0, 0, 1),
(85, 'fviolier', 'fviolier@secret.com', NULL, 0, 0, 1),
(86, 'cvanderm', 'cvanderm@secret.com', '2013-08-25', 0, 0, 1),
(87, 'dribreau', 'dribreau@secret.com', '2013-09-07', 0, 0, 1),
(88, 'mmorvan', 'mmorvan@secret.com', NULL, 0, 0, 1),
(89, 'jfrot', 'jfrot@secret.com', NULL, 0, 0, 1),
(90, 'mquemene', 'mquemene@secret.com', NULL, 0, 0, 1),
(91, 'pfoubert', 'pfoubert@secret.com', '2013-09-05', 0, 0, 1),
(92, 'rmarchis', 'rmarchis@secret.com', NULL, 0, 0, 1),
(93, 'jhira1', 'jhira1@secret.com', NULL, 0, 0, 1),
(94, 'bmabriez', 'bmabriez@secret.com', NULL, 0, 0, 1),
(95, 'mdarthos', 'mdarthos@secret.com', '2013-09-07', 0, 0, 1),
(96, 'msaidi', 'msaidi@secret.com', NULL, 0, 0, 1),
(97, 'fgauzere', 'fgauzere@secret.com', '2013-09-07', 0, 0, 1),
(98, 'rle-corn', 'rle-corn@secret.com', '2013-09-07', 0, 0, 1),
(99, 'kframine', 'kframine@secret.com', '2013-09-05', 0, 0, 1),
(100, 'gmaryns', 'gmaryns@secret.com', '2013-09-07', 0, 0, 1),
(101, 'apinoche', 'apinoche@secret.com', '2013-09-07', 0, 0, 1),
(102, 'msoquet', 'msoquet@secret.com', NULL, 0, 0, 1),
(103, 'labdelma', 'labdelma@secret.com', NULL, 0, 0, 1),
(104, 'vdebeaux', 'vdebeaux@secret.com', '2013-09-07', 0, 0, 1),
(105, 'robert', 'robert@secret.com', '2013-09-05', 0, 0, 1),
(106, 'mpirot', 'mpirot@secret.com', NULL, 0, 0, 1),
(107, 'cschulcz', 'cschulcz@secret.com', '2013-09-05', 0, 0, 1),
(108, 'dsaunder', 'dsaunder@secret.com', '2013-09-07', 0, 0, 1),
(109, 'fmacq', 'fmacq@secret.com', '2013-09-06', 0, 0, 1),
(110, 'ldereppe', 'ldereppe@secret.com', '2013-09-05', 0, 0, 1),
(111, 'rverheyd', 'rverheyd@secret.com', NULL, 0, 0, 1),
(112, 'sdestail', 'sdestail@secret.com', NULL, 0, 0, 1),
(113, 'lgendrea', 'lgendrea@secret.com', NULL, 0, 0, 1),
(114, 'cnory', 'cnory@secret.com', NULL, 0, 0, 1),
(115, 'mdomercq', 'mdomercq@secret.com', NULL, 0, 0, 1),
(116, 'spaquot', 'spaquot@secret.com', '2013-09-07', 0, 0, 1),
(117, 'rel-aago', 'rel-aago@secret.com', NULL, 0, 0, 1),
(118, 'cduangph', 'cduangph@secret.com', NULL, 0, 0, 1),
(119, 'ftallon', 'ftallon@secret.com', '2013-09-08', 0, 0, 1),
(120, 'aponcet', 'aponcet@secret.com', '2013-08-29', 0, 0, 1),
(121, 'cponsine', 'cponsine@secret.com', '2013-09-08', 0, 0, 1),
(122, 'llecache', 'llecache@secret.com', NULL, 0, 0, 1),
(123, 'qduamell', 'qduamell@secret.com', NULL, 0, 0, 1),
(124, 'pdeligne', 'pdeligne@secret.com', NULL, 0, 0, 1),
(125, 'adurenne', 'adurenne@secret.com', NULL, 0, 0, 1),
(126, 'aull', 'aull@secret.com', '2013-09-06', 0, 0, 1),
(127, 'pcoyne', 'pcoyne@secret.com', NULL, 0, 0, 1),
(128, 'jchaillo', 'jchaillo@secret.com', NULL, 0, 0, 1),
(129, 'ewillaum', 'ewillaum@secret.com', NULL, 0, 0, 1),
(130, 'jvannest', 'jvannest@secret.com', '2013-09-05', 0, 0, 1),
(131, 'aloingev', 'aloingev@secret.com', NULL, 0, 0, 1),
(132, 'cletelli', 'cletelli@secret.com', NULL, 0, 0, 1),
(133, 'ckopp', 'ckopp@secret.com', '2013-09-07', 0, 0, 1),
(134, 'aimbert', 'aimbert@secret.com', NULL, 0, 0, 1),
(135, 'hyongoua', 'hyongoua@secret.com', '2013-09-07', 0, 0, 1),
(136, 'rborisov', 'rborisov@secret.com', '2013-09-05', 0, 0, 1),
(137, 'sdelarue', 'sdelarue@secret.com', NULL, 0, 0, 1),
(138, 'gbrevall', 'gbrevall@secret.com', '2013-09-06', 0, 0, 1),
(139, 'lduplain', 'lduplain@secret.com', '2013-09-06', 0, 0, 1),
(140, 'plaboiss', 'plaboiss@secret.com', '2013-09-08', 0, 0, 1),
(141, 'grebelle', 'grebelle@secret.com', '2013-09-07', 0, 0, 1),
(142, 'adelassu', 'adelassu@secret.com', '2013-09-06', 0, 0, 1),
(143, 'klorenz', 'klorenz@secret.com', NULL, 0, 0, 1),
(144, 'mbonavit', 'mbonavit@secret.com', NULL, 0, 0, 1),
(145, 'adrean', 'adrean@secret.com', '2013-09-06', 0, 0, 1),
(146, 'ggaspard', 'ggaspard@secret.com', '2013-09-07', 0, 0, 1),
(147, 'llemaire', 'llemaire@secret.com', '2013-09-07', 0, 0, 1),
(148, 'ciafrate', 'ciafrate@secret.com', '2013-09-06', 0, 0, 1),
(149, 'cmoussea', 'cmoussea@secret.com', NULL, 0, 0, 1),
(150, 'mlecler1', 'mlecler1@secret.com', NULL, 0, 0, 1),
(151, 'mazziz1', 'mazziz1@secret.com', '2013-09-07', 0, 0, 1),
(152, 'jblanch1', 'jblanch1@secret.com', '2013-09-07', 0, 0, 1),
(153, 'aklein1', 'aklein1@secret.com', '2013-09-06', 0, 0, 1),
(154, 'edrumez', 'edrumez@secret.com', NULL, 0, 0, 1),
(155, 'mpham', 'mpham@secret.com', NULL, 0, 0, 1),
(156, 'adefran1', 'adefran1@secret.com', NULL, 0, 0, 1),
(157, 'jriaux', 'jriaux@secret.com', NULL, 0, 0, 1),
(158, 'apotdevi', 'apotdevi@secret.com', NULL, 0, 0, 1),
(159, 'itahry', 'itahry@secret.com', '2013-09-07', 0, 0, 1),
(160, 'qsalleri', 'qsalleri@secret.com', NULL, 0, 0, 1),
(161, 'fdebes', 'fdebes@secret.com', NULL, 0, 0, 1),
(162, 'aferreir', 'aferreir@secret.com', NULL, 0, 0, 1),
(163, 'lhonore', 'lhonore@secret.com', NULL, 0, 0, 1),
(164, 'jdelsuc', 'jdelsuc@secret.com', NULL, 0, 0, 1),
(165, 'kjelsch', 'kjelsch@secret.com', NULL, 0, 0, 1),
(166, 'pcornill', 'pcornill@secret.com', NULL, 0, 0, 1),
(167, 'ptheon', 'ptheon@secret.com', '2013-09-07', 0, 0, 1),
(168, 'cszymcza', 'cszymcza@secret.com', NULL, 0, 0, 1),
(169, 'romar', 'romar@secret.com', NULL, 0, 0, 1),
(170, 'waktir', 'waktir@secret.com', NULL, 0, 0, 1),
(171, 'laassoul', 'laassoul@secret.com', '2013-09-07', 0, 0, 1),
(172, 'therve', 'therve@secret.com', '2013-09-06', 0, 0, 1),
(173, 'tederle', 'tederle@secret.com', NULL, 0, 0, 1),
(174, 'rdupuis', 'rdupuis@secret.com', '2013-09-06', 0, 0, 1),
(175, 'acaubet', 'acaubet@secret.com', NULL, 0, 0, 1),
(176, 'kandreze', 'kandreze@secret.com', '2013-09-06', 0, 0, 1),
(177, 'cchaill1', 'cchaill1@secret.com', '2013-09-06', 0, 0, 1),
(178, 'gbullery', 'gbullery@secret.com', '2013-09-07', 0, 0, 1),
(179, 'bwiart', 'bwiart@secret.com', '2013-09-06', 0, 0, 1),
(180, 'cmeurill', 'cmeurill@secret.com', NULL, 0, 0, 1),
(181, 'lolivo', 'lolivo@secret.com', '2013-09-07', 0, 0, 1),
(182, 'hcercley', 'hcercley@secret.com', '2013-09-07', 0, 0, 1),
(183, 'avial', 'avial@secret.com', NULL, 0, 0, 1),
(184, 'mduthoit', 'mduthoit@secret.com', NULL, 0, 0, 1),
(185, 'rpelleri', 'rpelleri@secret.com', '2013-08-30', 0, 0, 1),
(186, 'amambouc', 'amambouc@secret.com', NULL, 0, 0, 1),
(187, 'jmichala', 'jmichala@secret.com', NULL, 0, 0, 1),
(188, 'mdaudign', 'mdaudign@secret.com', '2013-09-05', 0, 0, 1),
(189, 'mrotta', 'mrotta@secret.com', NULL, 0, 0, 1),
(190, 'pleder', 'pleder@secret.com', '2013-09-07', 0, 0, 1),
(191, 'rhequet', 'rhequet@secret.com', NULL, 0, 0, 1),
(192, 'bchalaux', 'bchalaux@secret.com', NULL, 0, 0, 1),
(193, 'dgasnier', 'dgasnier@secret.com', '2013-09-05', 0, 0, 1),
(194, 'egeiger', 'egeiger@secret.com', '2013-09-07', 0, 0, 1),
(195, 'prey', 'prey@secret.com', '2013-09-07', 0, 0, 1),
(196, 'nlefebvr', 'nlefebvr@secret.com', NULL, 0, 0, 1),
(197, 'mwora-sa', 'mwora-sa@secret.com', NULL, 0, 0, 1),
(198, 'abedenel', 'abedenel@secret.com', '2013-09-06', 0, 0, 1),
(199, 'oguilloi', 'oguilloi@secret.com', '2013-09-06', 0, 0, 1),
(200, 'crenau', 'crenau@secret.com', NULL, 0, 0, 1),
(201, 'abaron', 'abaron@secret.com', '2013-09-05', 0, 0, 1),
(202, 'rtirmant', 'rtirmant@secret.com', NULL, 0, 0, 1),
(203, 'tbonnier', 'tbonnier@secret.com', '2013-09-07', 0, 0, 1),
(204, 'jvan-lie', 'jvan-lie@secret.com', NULL, 0, 0, 1),
(205, 'gbougaud', 'gbougaud@secret.com', '2013-09-07', 0, 0, 1),
(206, 'mthomine', 'mthomine@secret.com', NULL, 0, 0, 1),
(207, 'rcanonne', 'rcanonne@secret.com', '2013-09-05', 0, 0, 1),
(208, 'amazat', 'amazat@secret.com', NULL, 0, 0, 1),
(209, 'aoumimou', 'aoumimou@secret.com', NULL, 0, 0, 1),
(210, 'mpflug', 'mpflug@secret.com', NULL, 0, 0, 1),
(211, 'alopez1', 'alopez1@secret.com', NULL, 0, 0, 1),
(212, 'mdemarey', 'mdemarey@secret.com', NULL, 0, 0, 1),
(213, 'pmalras', 'pmalras@secret.com', '2013-09-07', 0, 0, 1),
(214, 'vdemarqu', 'vdemarqu@secret.com', NULL, 0, 0, 1),
(215, 'dbureau', 'dbureau@secret.com', NULL, 0, 0, 1),
(216, 'rlesbegu', 'rlesbegu@secret.com', '2013-09-05', 0, 0, 1),
(217, 'cpineau', 'cpineau@secret.com', '2013-09-05', 0, 0, 1),
(218, 'lnoyer', 'lnoyer@secret.com', '2013-09-06', 0, 0, 1),
(219, 'aslyper', 'aslyper@secret.com', NULL, 0, 0, 1),
(220, 'clenoir1', 'clenoir1@secret.com', NULL, 0, 0, 1),
(221, 'cmucha', 'cmucha@secret.com', '2013-09-08', 0, 0, 1),
(222, 'vstotz', 'vstotz@secret.com', '2013-09-06', 0, 0, 1),
(223, 'tle-gall', 'tle-gall@secret.com', '2013-08-29', 0, 0, 1),
(224, 'ltsobgni', 'ltsobgni@secret.com', NULL, 0, 0, 1),
(225, 'gle-goff', 'gle-goff@secret.com', NULL, 0, 0, 1),
(226, 'vdebize', 'vdebize@secret.com', '2013-09-05', 0, 0, 1),
(227, 'sbourzgu', 'sbourzgu@secret.com', '2013-09-07', 0, 0, 1),
(228, 'mkhellou', 'mkhellou@secret.com', NULL, 0, 0, 1),
(229, 'tlavie', 'tlavie@secret.com', '2013-08-29', 0, 0, 1),
(230, 'plejus-r', 'plejus-r@secret.com', '2013-09-05', 0, 0, 1),
(231, 'bconflan', 'bconflan@secret.com', NULL, 0, 0, 1),
(232, 'mpeycelo', 'mpeycelo@secret.com', NULL, 0, 0, 1),
(233, 'avastel', 'avastel@secret.com', '2013-09-07', 0, 0, 1),
(234, 'vbonello', 'vbonello@secret.com', NULL, 0, 0, 1),
(235, 'mmarcade', 'mmarcade@secret.com', '2013-09-07', 0, 0, 1),
(236, 'lmihout', 'lmihout@secret.com', NULL, 0, 0, 1),
(237, 'evantom', 'evantom@secret.com', '2013-09-06', 0, 0, 1),
(238, 'pfontain', 'pfontain@secret.com', '2013-09-07', 0, 0, 1),
(239, 'sdelaine', 'sdelaine@secret.com', NULL, 0, 0, 1),
(240, 'fgarlatt', 'fgarlatt@secret.com', NULL, 0, 0, 1),
(241, 'cburglen', 'cburglen@secret.com', NULL, 0, 0, 1),
(242, 'jdelarbr', 'jdelarbr@secret.com', '2013-09-07', 0, 0, 1),
(243, 'akwita', 'akwita@secret.com', NULL, 0, 0, 1),
(244, 'rbernaud', 'rbernaud@secret.com', '2013-09-07', 0, 0, 1),
(245, 'abeaurep', 'abeaurep@secret.com', NULL, 0, 0, 1),
(246, 'aisenbra', 'aisenbra@secret.com', NULL, 0, 0, 1),
(247, 'mchartr1', 'mchartr1@secret.com', NULL, 0, 0, 1),
(248, 'ptang', 'ptang@secret.com', '2013-09-08', 0, 0, 1),
(249, 'dbesse', 'dbesse@secret.com', NULL, 0, 0, 1),
(250, 'kduchenn', 'kduchenn@secret.com', NULL, 0, 0, 1),
(251, 'jtibergh', 'jtibergh@secret.com', NULL, 0, 0, 1),
(252, 'nwegrzyn', 'nwegrzyn@secret.com', NULL, 0, 0, 1),
(253, 'otissot', 'otissot@secret.com', NULL, 0, 0, 1),
(254, 'klabalet', 'klabalet@secret.com', '2013-08-29', 0, 0, 1),
(255, 'glattab', 'glattab@secret.com', NULL, 0, 0, 1),
(256, 'zassaieb', 'zassaieb@secret.com', '2013-09-07', 0, 0, 2),
(257, 'isogoba', 'isogoba@secret.com', NULL, 0, 0, 1),
(258, 'mdeceuni', 'mdeceuni@secret.com', NULL, 0, 0, 1),
(259, 'achauzi', 'achauzi@secret.com', '2013-09-06', 0, 0, 1),
(260, 'jhumbert', 'jhumbert@secret.com', NULL, 0, 0, 1),
(261, 'flambert', 'flambert@secret.com', NULL, 0, 0, 1),
(262, 'lgoyez', 'lgoyez@secret.com', NULL, 0, 0, 1),
(263, 'abelhach', 'abelhach@secret.com', '2013-09-08', 0, 0, 1),
(264, 'vle-breu', 'vle-breu@secret.com', NULL, 0, 0, 1),
(265, 'rstella', 'rstella@secret.com', NULL, 0, 0, 1),
(266, 'bjoudrie', 'bjoudrie@secret.com', '2013-09-08', 0, 0, 1),
(267, 'bdesauna', 'bdesauna@secret.com', NULL, 0, 0, 1),
(268, 'mle-moue', 'mle-moue@secret.com', NULL, 0, 0, 1),
(269, 'apouplai', 'apouplai@secret.com', NULL, 0, 0, 1),
(270, 'jbroutec', 'jbroutec@secret.com', NULL, 0, 0, 1),
(271, 'fjoly', 'fjoly@secret.com', NULL, 0, 0, 1),
(272, 'mhedon', 'mhedon@secret.com', NULL, 0, 0, 1),
(273, 'bleplomb', 'bleplomb@secret.com', NULL, 0, 0, 1),
(274, 'mrenaudi', 'mrenaudi@secret.com', '2013-09-05', 0, 0, 1),
(275, 'lhossie', 'lhossie@secret.com', NULL, 0, 0, 1),
(276, 'jblanche', 'jblanche@secret.com', NULL, 0, 0, 1),
(277, 'mlibert', 'mlibert@secret.com', '2013-09-07', 0, 0, 1),
(278, 'apaintau', 'apaintau@secret.com', NULL, 0, 0, 1),
(279, 'tpassos-', 'tpassos-@secret.com', NULL, 0, 0, 1),
(280, 'jderbali', 'jderbali@secret.com', NULL, 0, 0, 1),
(281, 'sgrosset', 'sgrosset@secret.com', '2013-09-05', 0, 0, 1),
(282, 'sbuia', 'sbuia@secret.com', NULL, 0, 0, 1),
(283, 'dtomasek', 'dtomasek@secret.com', NULL, 0, 0, 1),
(284, 'mle-thie', 'mle-thie@secret.com', '2013-09-05', 0, 0, 1),
(285, 'nalexand', 'nalexand@secret.com', NULL, 0, 0, 1),
(286, 'fvitte', 'fvitte@secret.com', '2013-09-08', 0, 0, 1),
(287, 'rdelorme', 'rdelorme@secret.com', NULL, 0, 0, 1),
(288, 'dheyries', 'dheyries@secret.com', NULL, 0, 0, 1),
(289, 'jgondry', 'jgondry@secret.com', NULL, 0, 0, 1),
(290, 'pbaril', 'pbaril@secret.com', '2013-09-05', 0, 0, 1),
(291, 'pguillet', 'pguillet@secret.com', NULL, 0, 0, 1),
(292, 'fmoreau', 'fmoreau@secret.com', '2013-09-05', 0, 0, 1),
(293, 'yhaloua', 'yhaloua@secret.com', NULL, 0, 0, 1),
(294, 'fmachuro', 'fmachuro@secret.com', '2013-08-28', 0, 0, 1),
(295, 'xwallet', 'xwallet@secret.com', NULL, 0, 0, 1),
(296, 'vlind', 'vlind@secret.com', NULL, 0, 0, 1),
(297, 'gdezier', 'gdezier@secret.com', '2013-09-06', 0, 0, 1),
(298, 'jfremaux', 'jfremaux@secret.com', '2013-09-07', 0, 0, 1),
(299, 'loden', 'loden@secret.com', '2013-09-06', 0, 0, 1),
(300, 'cmongy', 'cmongy@secret.com', NULL, 0, 0, 1),
(301, 'jneymot', 'jneymot@secret.com', NULL, 0, 0, 1),
(302, 'mrebilla', 'mrebilla@secret.com', NULL, 0, 0, 1),
(303, 'ejardot', 'ejardot@secret.com', NULL, 0, 0, 1),
(304, 'smalthie', 'smalthie@secret.com', '2013-09-07', 0, 0, 1),
(305, 'ybouaziz', 'ybouaziz@secret.com', '2013-09-07', 0, 0, 1),
(306, 'mjorre', 'mjorre@secret.com', '2013-09-06', 0, 0, 1),
(307, 'tlam', 'tlam@secret.com', NULL, 0, 0, 1),
(308, 'mrepusse', 'mrepusse@secret.com', '2013-09-07', 0, 0, 1),
(309, 'mbarbin', 'mbarbin@secret.com', '2013-09-07', 0, 0, 1),
(310, 'sweiss1', 'sweiss1@secret.com', '2013-09-07', 0, 0, 1),
(311, 'ajouy1', 'ajouy1@secret.com', NULL, 0, 0, 1),
(312, 'akrishna', 'akrishna@secret.com', '2013-09-05', 0, 0, 1),
(313, 'mdelauna', 'mdelauna@secret.com', '2013-09-06', 0, 0, 1),
(314, 'mcochet', 'mcochet@secret.com', '2013-09-07', 0, 0, 1),
(315, 'amoule', 'amoule@secret.com', NULL, 0, 0, 1),
(316, 'rlarouss', 'rlarouss@secret.com', '2013-09-07', 0, 0, 1),
(317, 'gtournie', 'gtournie@secret.com', '2013-09-07', 0, 0, 1),
(318, 'apilard', 'apilard@secret.com', NULL, 0, 0, 1),
(319, 'gfranco', 'gfranco@secret.com', NULL, 0, 0, 1),
(320, 'alaifa', 'alaifa@secret.com', '2013-09-07', 0, 0, 1),
(321, 'jespinas', 'jespinas@secret.com', NULL, 0, 0, 1),
(322, 'aquiclet', 'aquiclet@secret.com', '2013-09-06', 0, 0, 1),
(323, 'aslimani', 'aslimani@secret.com', NULL, 0, 0, 1),
(324, 'mlesne', 'mlesne@secret.com', '2013-09-07', 0, 0, 1),
(325, 'hheddoun', 'hheddoun@secret.com', '2013-09-05', 0, 0, 1),
(326, 'pdulongc', 'pdulongc@secret.com', '2013-09-07', 0, 0, 1),
(327, 'jstienne', 'jstienne@secret.com', NULL, 0, 0, 1),
(328, 'jgosseli', 'jgosseli@secret.com', NULL, 0, 0, 1),
(329, 'hlauren1', 'hlauren1@secret.com', NULL, 0, 0, 1),
(330, 'hbehal', 'hbehal@secret.com', NULL, 0, 0, 1),
(331, 'jchevann', 'jchevann@secret.com', '2013-09-05', 0, 0, 1),
(332, 'mkamanan', 'mkamanan@secret.com', NULL, 0, 0, 1),
(333, 'treigner', 'treigner@secret.com', '2013-09-05', 0, 0, 1),
(334, 'amahir', 'amahir@secret.com', '2013-09-07', 0, 0, 1),
(335, 'palbouy', 'palbouy@secret.com', '2013-09-07', 0, 0, 1),
(336, 'mzeggai', 'mzeggai@secret.com', '2013-09-07', 0, 0, 1),
(337, 'adumaisn', 'adumaisn@secret.com', '2013-09-06', 0, 0, 1),
(338, 'mel-mans', 'mel-mans@secret.com', NULL, 0, 0, 1),
(339, 'zgritli', 'zgritli@secret.com', '2013-09-06', 0, 0, 1),
(340, 'pgrosset', 'pgrosset@secret.com', NULL, 0, 0, 1),
(341, 'ameziane', 'ameziane@secret.com', NULL, 0, 0, 1),
(342, 'aluscher', 'aluscher@secret.com', NULL, 0, 0, 1),
(343, 'ble-mair', 'ble-mair@secret.com', NULL, 0, 0, 1),
(344, 'dszadkow', 'dszadkow@secret.com', NULL, 0, 0, 1),
(345, 'rbruyere', 'rbruyere@secret.com', '2013-09-07', 0, 0, 1),
(346, 'vlamarch', 'vlamarch@secret.com', NULL, 0, 0, 1),
(347, 'htriboul', 'htriboul@secret.com', '2013-09-05', 0, 0, 1),
(348, 'yel-moha', 'yel-moha@secret.com', NULL, 0, 0, 1),
(349, 'cetourne', 'cetourne@secret.com', NULL, 0, 0, 1),
(350, 'lmanoury', 'lmanoury@secret.com', '2013-09-06', 0, 0, 1),
(351, 'nlallut', 'nlallut@secret.com', '2013-09-07', 0, 0, 1),
(352, 'jpeeters', 'jpeeters@secret.com', '2013-09-07', 0, 0, 1),
(353, 'cbossart', 'cbossart@secret.com', NULL, 0, 0, 1),
(354, 'sfossaer', 'sfossaer@secret.com', NULL, 0, 0, 1),
(355, 'ascarcia', 'ascarcia@secret.com', '2013-09-04', 0, 0, 1),
(356, 'tnogueir', 'tnogueir@secret.com', NULL, 0, 0, 1),
(357, 'ielhasna', 'ielhasna@secret.com', '2013-09-06', 0, 0, 1),
(358, 'gde-sain', 'gde-sain@secret.com', '2013-09-05', 0, 0, 1),
(359, 'chenry1', 'chenry1@secret.com', NULL, 0, 0, 1),
(360, 'pjutard', 'pjutard@secret.com', NULL, 0, 0, 1),
(361, 'ssayarh', 'ssayarh@secret.com', NULL, 0, 0, 1),
(362, 'pfittipa', 'pfittipa@secret.com', NULL, 0, 0, 1),
(363, 'qmerat', 'qmerat@secret.com', '2013-09-05', 0, 0, 1),
(364, 'yboukita', 'yboukita@secret.com', '2013-09-08', 0, 0, 1),
(365, 'jkemajou', 'jkemajou@secret.com', NULL, 0, 0, 1),
(366, 'solivier', 'solivier@secret.com', NULL, 0, 0, 1),
(367, 'zjebbari', 'zjebbari@secret.com', '2013-09-08', 0, 0, 1),
(368, 'mlanglad', 'mlanglad@secret.com', '2013-09-06', 0, 0, 1),
(369, 'bquide', 'bquide@secret.com', '2013-09-07', 0, 0, 1),
(370, 'tlabitte', 'tlabitte@secret.com', NULL, 0, 0, 1),
(371, 'jpouzet', 'jpouzet@secret.com', NULL, 0, 0, 1),
(372, 'blacombe', 'blacombe@secret.com', '2013-09-07', 0, 0, 1),
(373, 'mgerier', 'mgerier@secret.com', '2013-09-07', 0, 0, 1),
(374, 'jchristi', 'jchristi@secret.com', NULL, 0, 0, 1),
(375, 'gleclere', 'gleclere@secret.com', '2013-09-07', 0, 0, 1),
(376, 'sel-mour', 'sel-mour@secret.com', '2013-09-06', 0, 0, 1),
(377, 'jpergeli', 'jpergeli@secret.com', '2013-09-06', 0, 0, 1),
(378, 'craynal', 'craynal@secret.com', '2013-09-07', 0, 0, 1),
(379, 'cjuet', 'cjuet@secret.com', '2013-09-07', 0, 0, 1),
(380, 'iseger', 'iseger@secret.com', NULL, 0, 0, 1),
(381, 'aozbakir', 'aozbakir@secret.com', NULL, 0, 0, 1),
(382, 'aagrimen', 'aagrimen@secret.com', NULL, 0, 0, 1),
(383, 'blaflaqu', 'blaflaqu@secret.com', NULL, 0, 0, 1),
(384, 'fcaron1', 'fcaron1@secret.com', '2013-09-05', 0, 0, 1),
(385, 'cdeville', 'cdeville@secret.com', '2013-09-07', 0, 0, 1),
(386, 'jchamane', 'jchamane@secret.com', NULL, 0, 0, 1),
(387, 'cpaillas', 'cpaillas@secret.com', NULL, 0, 0, 1),
(388, 'tchampag', 'tchampag@secret.com', NULL, 0, 0, 1),
(389, 'tmaurice', 'tmaurice@secret.com', '2013-09-05', 0, 0, 1),
(390, 'aaljane', 'aaljane@secret.com', '2013-09-05', 0, 0, 1),
(391, 'pgombaul', 'pgombaul@secret.com', '2013-09-05', 0, 0, 1),
(392, 'bmaliar', 'bmaliar@secret.com', NULL, 0, 0, 1),
(393, 'froyer', 'froyer@secret.com', '2013-09-07', 0, 0, 1),
(394, 'ctache', 'ctache@secret.com', NULL, 0, 0, 1),
(395, 'vvergez', 'vvergez@secret.com', NULL, 0, 0, 1),
(396, 'blafit', 'blafit@secret.com', '2013-09-02', 0, 0, 1),
(397, 'shaddaou', 'shaddaou@secret.com', NULL, 0, 0, 1),
(398, 'ppetitpr', 'ppetitpr@secret.com', NULL, 0, 0, 1),
(399, 'mtixier', 'mtixier@secret.com', NULL, 0, 0, 1),
(400, 'cbricout', 'cbricout@secret.com', '2013-09-05', 0, 0, 1),
(401, 'jmorillo', 'jmorillo@secret.com', NULL, 0, 0, 1),
(402, 'cdesprez', 'cdesprez@secret.com', NULL, 0, 0, 1),
(403, 'ebarioz', 'ebarioz@secret.com', NULL, 0, 0, 1),
(404, 'agossere', 'agossere@secret.com', '2013-09-05', 0, 0, 1),
(405, 'cburtair', 'cburtair@secret.com', '2013-09-06', 0, 0, 1),
(406, 'sducloux', 'sducloux@secret.com', NULL, 0, 0, 1),
(407, 'vcarlier', 'vcarlier@secret.com', '2013-09-06', 0, 0, 1),
(408, 'edomingo', 'edomingo@secret.com', NULL, 0, 0, 1),
(409, 'ccoat', 'ccoat@secret.com', NULL, 0, 0, 1),
(410, 'echangeo', 'echangeo@secret.com', '2013-09-05', 0, 0, 1),
(411, 'mentat', 'mentat@secret.com', '2013-09-07', 0, 0, 1),
(412, 'edandeu', 'edandeu@secret.com', '2013-09-06', 0, 0, 1),
(413, 'vbarbosa', 'vbarbosa@secret.com', NULL, 0, 0, 1),
(414, 'eviault', 'eviault@secret.com', NULL, 0, 0, 1),
(415, 'gmaran', 'gmaran@secret.com', NULL, 0, 0, 1),
(416, 'gbruno', 'gbruno@secret.com', '2013-09-06', 0, 0, 1),
(417, 'boudoire', 'boudoire@secret.com', NULL, 0, 0, 1),
(418, 'jpouzoul', 'jpouzoul@secret.com', '2013-08-28', 0, 0, 1),
(419, 'smorsali', 'smorsali@secret.com', NULL, 0, 0, 1),
(420, 'wfourgon', 'wfourgon@secret.com', '2013-09-05', 0, 0, 1),
(421, 'gbourget', 'gbourget@secret.com', NULL, 0, 0, 1),
(422, 'mdauchez', 'mdauchez@secret.com', NULL, 0, 0, 1),
(423, 'bledoux', 'bledoux@secret.com', '2013-09-05', 0, 0, 1),
(424, 'tbohlay', 'tbohlay@secret.com', NULL, 0, 0, 1),
(425, 'nvaslier', 'nvaslier@secret.com', NULL, 0, 0, 1),
(426, 'tdefland', 'tdefland@secret.com', '2013-09-05', 0, 0, 1),
(427, 'lodolant', 'lodolant@secret.com', NULL, 0, 0, 1),
(428, 'ehery', 'ehery@secret.com', NULL, 0, 0, 1),
(429, 'adeval', 'adeval@secret.com', NULL, 0, 0, 1),
(430, 'tbrunier', 'tbrunier@secret.com', '2013-09-06', 0, 0, 1),
(431, 'lle-floc', 'lle-floc@secret.com', NULL, 0, 0, 1),
(432, 'lleconte', 'lleconte@secret.com', '2013-09-06', 0, 0, 1),
(433, 'groche', 'groche@secret.com', NULL, 0, 0, 1),
(434, 'mlemair2', 'mlemair2@secret.com', NULL, 0, 0, 1),
(435, 'jhmeidan', 'jhmeidan@secret.com', NULL, 0, 0, 1),
(436, 'asanchet', 'asanchet@secret.com', NULL, 0, 0, 1),
(437, 'gpiot', 'gpiot@secret.com', NULL, 0, 0, 1),
(438, 'mmoinard', 'mmoinard@secret.com', NULL, 0, 0, 1),
(439, 'cly', 'cly@secret.com', NULL, 0, 0, 1),
(440, 'ajouniau', 'ajouniau@secret.com', NULL, 0, 0, 1),
(441, 'mbarille', 'mbarille@secret.com', '2013-09-07', 0, 0, 1),
(442, 'ppenet', 'ppenet@secret.com', NULL, 0, 0, 1),
(443, 'rdejaegh', 'rdejaegh@secret.com', NULL, 0, 0, 1),
(444, 'qbouve', 'qbouve@secret.com', '2013-09-06', 0, 0, 1),
(445, 'amoguero', 'amoguero@secret.com', NULL, 0, 0, 1),
(446, 'ncheval1', 'ncheval1@secret.com', NULL, 0, 0, 1),
(447, 'eradenne', 'eradenne@secret.com', '2013-09-05', 0, 0, 1),
(448, 'rdhaine', 'rdhaine@secret.com', '2013-09-07', 0, 0, 1),
(449, 'tvan-isa', 'tvan-isa@secret.com', NULL, 0, 0, 1),
(450, 'tsome', 'tsome@secret.com', NULL, 0, 0, 1),
(451, 'jpansera', 'jpansera@secret.com', '2013-09-07', 0, 0, 1),
(452, 'tle-bail', 'tle-bail@secret.com', NULL, 0, 0, 1),
(453, 'mmasson', 'mmasson@secret.com', NULL, 0, 0, 1),
(454, 'ablassel', 'ablassel@secret.com', NULL, 0, 0, 1),
(455, 'tvan-hau', 'tvan-hau@secret.com', NULL, 0, 0, 1),
(456, 'mmateo', 'mmateo@secret.com', '2013-09-06', 0, 0, 1),
(457, 'mdujardi', 'mdujardi@secret.com', '2013-08-28', 0, 0, 1),
(458, 'aberrada', 'aberrada@secret.com', '2013-09-05', 0, 0, 1),
(459, 'alefebvr', 'alefebvr@secret.com', NULL, 0, 0, 1),
(460, 'fscharre', 'fscharre@secret.com', '2013-09-07', 0, 0, 1),
(461, 'mselvini', 'mselvini@secret.com', '2013-09-06', 0, 0, 1),
(462, 'camory', 'camory@secret.com', NULL, 0, 0, 1),
(463, 'ehrywnia', 'ehrywnia@secret.com', NULL, 0, 0, 1),
(464, 'llonkap-', 'llonkap-@secret.com', NULL, 0, 0, 1),
(465, 'dbert', 'dbert@secret.com', '2013-09-05', 0, 0, 1),
(466, 'mbeernae', 'mbeernae@secret.com', '2013-09-07', 0, 0, 1),
(467, 'cdelfoss', 'cdelfoss@secret.com', '2013-09-05', 0, 0, 1),
(468, 'frichou', 'frichou@secret.com', '2013-09-07', 0, 0, 1),
(469, 'vsanvert', 'vsanvert@secret.com', NULL, 0, 0, 1),
(470, 'mallexan', 'mallexan@secret.com', NULL, 0, 0, 1),
(471, 'sbolzer', 'sbolzer@secret.com', NULL, 0, 0, 1),
(472, 'vfuentes', 'vfuentes@secret.com', NULL, 0, 0, 1),
(473, 'frabouan', 'frabouan@secret.com', NULL, 0, 0, 1),
(474, 'vcassagn', 'vcassagn@secret.com', NULL, 0, 0, 1),
(475, 'nouannou', 'nouannou@secret.com', NULL, 0, 0, 1),
(476, 'dlahorea', 'dlahorea@secret.com', '2013-09-06', 0, 0, 1),
(477, 'amercier', 'amercier@secret.com', NULL, 0, 0, 1),
(478, 'pbrozat', 'pbrozat@secret.com', '2013-09-05', 0, 0, 1),
(479, 'jnoel', 'jnoel@secret.com', NULL, 0, 0, 1),
(480, 'have', 'have@secret.com', NULL, 0, 0, 1),
(481, 'pciolkov', 'pciolkov@secret.com', NULL, 0, 0, 1),
(482, 'ccarpent', 'ccarpent@secret.com', NULL, 0, 0, 1),
(483, 'mhaudiqu', 'mhaudiqu@secret.com', NULL, 0, 0, 1),
(484, 'afaucher', 'afaucher@secret.com', NULL, 0, 0, 1),
(485, 'tbarles', 'tbarles@secret.com', NULL, 0, 0, 1),
(486, 'vmeunier', 'vmeunier@secret.com', '2013-09-06', 0, 0, 1),
(487, 'jheraud', 'jheraud@secret.com', NULL, 0, 0, 1),
(488, 'cfromen1', 'cfromen1@secret.com', NULL, 0, 0, 1),
(489, 'sbary', 'sbary@secret.com', NULL, 0, 0, 1),
(490, 'gdi-palm', 'gdi-palm@secret.com', '2013-09-07', 0, 0, 1),
(491, 'aanicet', 'aanicet@secret.com', NULL, 0, 0, 1),
(492, 'jmetzger', 'jmetzger@secret.com', NULL, 0, 0, 1),
(493, 'fmetayer', 'fmetayer@secret.com', NULL, 0, 0, 1),
(494, 'nchevali', 'nchevali@secret.com', '2013-09-06', 0, 0, 1),
(495, 'acarpent', 'acarpent@secret.com', NULL, 0, 0, 1),
(496, 'hrepluma', 'hrepluma@secret.com', NULL, 0, 0, 1),
(497, 'hdau', 'hdau@secret.com', NULL, 0, 0, 1),
(498, 'mbahrami', 'mbahrami@secret.com', NULL, 0, 0, 1),
(499, 'rproyart', 'rproyart@secret.com', NULL, 0, 0, 1),
(500, 'kdethelo', 'kdethelo@secret.com', NULL, 0, 0, 1),
(501, 'ntran', 'ntran@secret.com', NULL, 0, 0, 1),
(502, 'fchevali', 'fchevali@secret.com', '2013-09-07', 0, 0, 1),
(503, 'bfiniels', 'bfiniels@secret.com', '2013-09-05', 0, 0, 1),
(504, 'achan-qu', 'achan-qu@secret.com', NULL, 0, 0, 1),
(505, 'fmottu', 'fmottu@secret.com', NULL, 0, 0, 1),
(506, 'gndao', 'gndao@secret.com', NULL, 0, 0, 1),
(507, 'abentz', 'abentz@secret.com', NULL, 0, 0, 1),
(508, 'gmichele', 'gmichele@secret.com', NULL, 0, 0, 1),
(509, 'ctrogneu', 'ctrogneu@secret.com', NULL, 0, 0, 1),
(510, 'ysamen-t', 'ysamen-t@secret.com', NULL, 0, 0, 1),
(511, 'sboucher', 'sboucher@secret.com', NULL, 0, 0, 1),
(512, 'etourre', 'etourre@secret.com', '2013-09-07', 0, 0, 1),
(513, 'ccolin', 'ccolin@secret.com', NULL, 0, 0, 1),
(514, 'pmarien', 'pmarien@secret.com', NULL, 0, 0, 1),
(515, 'tdiallo', 'tdiallo@secret.com', NULL, 0, 0, 1),
(516, 'asterlin', 'asterlin@secret.com', NULL, 0, 0, 1),
(517, 'atouimi-', 'atouimi-@secret.com', '2013-09-07', 0, 0, 1),
(518, 'jdequidt', 'jdequidt@secret.com', '2013-09-06', 0, 0, 1),
(519, 'iel-hart', 'iel-hart@secret.com', NULL, 0, 0, 1),
(520, 'rboriso1', 'rboriso1@secret.com', NULL, 0, 0, 1),
(521, 'sdrieu', 'sdrieu@secret.com', NULL, 0, 0, 1),
(522, 'fgerhard', 'fgerhard@secret.com', '2013-09-05', 0, 0, 1),
(523, 'cdellenb', 'cdellenb@secret.com', NULL, 0, 0, 1),
(524, 'tteneur', 'tteneur@secret.com', '2013-09-07', 0, 0, 1),
(525, 'cgory', 'cgory@secret.com', NULL, 0, 0, 1),
(526, 'jpodgors', 'jpodgors@secret.com', NULL, 0, 0, 1),
(527, 'tpeyre', 'tpeyre@secret.com', '2013-09-05', 0, 0, 1),
(528, 'cpetit', 'cpetit@secret.com', NULL, 0, 0, 1),
(529, 'qgruson', 'qgruson@secret.com', '2013-09-07', 0, 0, 1),
(530, 'amasson1', 'amasson1@secret.com', NULL, 0, 0, 1),
(531, 'jfrancho', 'jfrancho@secret.com', NULL, 0, 0, 1),
(532, 'mmassonn', 'mmassonn@secret.com', '2013-09-07', 0, 0, 1),
(533, 'jlancier', 'jlancier@secret.com', NULL, 0, 0, 1),
(534, 'shue', 'shue@secret.com', NULL, 0, 0, 1),
(535, 'mcallens', 'mcallens@secret.com', '2013-09-05', 0, 0, 1),
(536, 'nlachihe', 'nlachihe@secret.com', NULL, 0, 0, 1),
(537, 'afourdri', 'afourdri@secret.com', '2013-09-07', 0, 0, 1),
(538, 'ovoisin', 'ovoisin@secret.com', NULL, 0, 0, 1),
(539, 'mmeric', 'mmeric@secret.com', NULL, 0, 0, 1),
(540, 'rvignali', 'rvignali@secret.com', '2013-09-07', 0, 0, 1),
(541, 'troj', 'troj@secret.com', NULL, 0, 0, 1),
(542, 'cdonche', 'cdonche@secret.com', NULL, 0, 0, 1),
(543, 'jmenguy', 'jmenguy@secret.com', NULL, 0, 0, 1),
(544, 'jmaire', 'jmaire@secret.com', NULL, 0, 0, 1),
(545, 'ccouspey', 'ccouspey@secret.com', NULL, 0, 0, 1),
(546, 'sbrun', 'sbrun@secret.com', NULL, 0, 0, 1),
(547, 'bdurand', 'bdurand@secret.com', '2013-09-05', 0, 0, 1),
(548, 'mda-naza', 'mda-naza@secret.com', '2013-09-05', 0, 0, 1),
(549, 'gstoclet', 'gstoclet@secret.com', NULL, 0, 0, 1),
(550, 'lrussier', 'lrussier@secret.com', NULL, 0, 0, 1),
(551, 'abechet', 'abechet@secret.com', '2013-09-06', 0, 0, 1),
(552, 'aloeuil', 'aloeuil@secret.com', NULL, 0, 0, 1),
(553, 'dgolpart', 'dgolpart@secret.com', NULL, 0, 0, 1),
(554, 'tvanmoer', 'tvanmoer@secret.com', NULL, 0, 0, 1),
(555, 'dbrame', 'dbrame@secret.com', NULL, 0, 0, 1),
(556, 'vdole', 'vdole@secret.com', '2013-09-06', 0, 0, 1),
(557, 'qhivin', 'qhivin@secret.com', '2013-09-06', 0, 0, 1),
(558, 'epageau', 'epageau@secret.com', NULL, 0, 0, 1),
(559, 'mbuytaer', 'mbuytaer@secret.com', NULL, 0, 0, 1),
(560, 'dduez', 'dduez@secret.com', NULL, 0, 0, 1),
(561, 'eleprett', 'eleprett@secret.com', NULL, 0, 0, 1),
(562, 'lrustico', 'lrustico@secret.com', '2013-09-04', 0, 0, 1),
(563, 'djouni', 'djouni@secret.com', NULL, 0, 0, 1),
(564, 'tmartine', 'tmartine@secret.com', '2013-09-05', 0, 0, 1),
(565, 'mjerome', 'mjerome@secret.com', NULL, 0, 0, 1),
(566, 'mesteve', 'mesteve@secret.com', '2013-09-06', 0, 0, 1),
(567, 'esoler', 'esoler@secret.com', NULL, 0, 0, 1),
(568, 'atouzi', 'atouzi@secret.com', '2013-09-05', 0, 0, 1),
(569, 'tloussie', 'tloussie@secret.com', NULL, 0, 0, 1),
(570, 'cpollet', 'cpollet@secret.com', NULL, 0, 0, 1),
(571, 'ibarry', 'ibarry@secret.com', '2013-08-29', 0, 0, 1),
(572, 'amassamb', 'amassamb@secret.com', NULL, 0, 0, 1),
(573, 'grose', 'grose@secret.com', NULL, 0, 0, 1),
(574, 'nboireau', 'nboireau@secret.com', NULL, 0, 0, 1),
(575, 'omery', 'omery@secret.com', NULL, 0, 0, 1),
(576, 'jdenaud', 'jdenaud@secret.com', NULL, 0, 0, 1),
(577, 'mledoux1', 'mledoux1@secret.com', NULL, 0, 0, 1),
(578, 'joliveir', 'joliveir@secret.com', NULL, 0, 0, 1),
(579, 'ebecart', 'ebecart@secret.com', NULL, 0, 0, 1),
(580, 'lmaupome', 'lmaupome@secret.com', NULL, 0, 0, 1),
(581, 'emarce', 'emarce@secret.com', '2013-09-05', 0, 0, 1),
(582, 'mseck', 'mseck@secret.com', NULL, 0, 0, 1),
(583, 'msenicou', 'msenicou@secret.com', NULL, 0, 0, 1),
(584, 'alouveau', 'alouveau@secret.com', NULL, 0, 0, 1),
(585, 'epied', 'epied@secret.com', NULL, 0, 0, 1),
(586, 'tlefebvr', 'tlefebvr@secret.com', NULL, 0, 0, 1),
(587, 'gbernar1', 'gbernar1@secret.com', '2013-09-07', 0, 0, 1),
(588, 'phaidara', 'phaidara@secret.com', NULL, 0, 0, 1),
(589, 'cdesaleu', 'cdesaleu@secret.com', NULL, 0, 0, 1),
(590, 'mbrisacq', 'mbrisacq@secret.com', NULL, 0, 0, 1),
(591, 'ajouy', 'ajouy@secret.com', '2013-09-06', 0, 0, 1),
(592, 'kalaoui-', 'kalaoui-@secret.com', NULL, 0, 0, 1),
(593, 'rdeplanq', 'rdeplanq@secret.com', '2013-09-05', 0, 0, 1),
(594, 'wbeaud', 'wbeaud@secret.com', NULL, 0, 0, 1),
(595, 'fmichel', 'fmichel@secret.com', '2013-09-05', 0, 0, 1),
(596, 'cvan-pra', 'cvan-pra@secret.com', NULL, 0, 0, 1),
(597, 'jcuzenic', 'jcuzenic@secret.com', NULL, 0, 0, 1),
(598, 'gseelen', 'gseelen@secret.com', NULL, 0, 0, 1),
(599, 'jmiranda', 'jmiranda@secret.com', NULL, 0, 0, 1),
(600, 'parmande', 'parmande@secret.com', NULL, 0, 0, 1),
(601, 'edassonv', 'edassonv@secret.com', NULL, 0, 0, 1),
(602, 'rparsy', 'rparsy@secret.com', NULL, 0, 0, 1),
(603, 'sparreir', 'sparreir@secret.com', '2013-09-05', 0, 0, 1),
(604, 'lbalquet', 'lbalquet@secret.com', NULL, 0, 0, 1),
(605, 'traineau', 'traineau@secret.com', NULL, 0, 0, 1),
(606, 'mnoura', 'mnoura@secret.com', NULL, 0, 0, 1),
(607, 'vboennec', 'vboennec@secret.com', NULL, 0, 0, 1),
(608, 'acierpka', 'acierpka@secret.com', '2013-09-07', 0, 0, 1),
(609, 'bmrozows', 'bmrozows@secret.com', NULL, 0, 0, 1),
(610, 'mgallais', 'mgallais@secret.com', '2013-09-07', 0, 0, 1),
(611, 'tciufici', 'tciufici@secret.com', NULL, 0, 0, 1),
(612, 'lcarpent', 'lcarpent@secret.com', NULL, 0, 0, 1),
(613, 'vdrecq', 'vdrecq@secret.com', '2013-09-07', 0, 0, 1),
(614, 'vlebacq', 'vlebacq@secret.com', '2013-09-05', 0, 0, 1),
(615, 'lmairess', 'lmairess@secret.com', '2013-09-06', 0, 0, 1),
(616, 'callegue', 'callegue@secret.com', NULL, 0, 0, 1),
(617, 'rthielle', 'rthielle@secret.com', NULL, 0, 0, 1),
(618, 'bdescoqs', 'bdescoqs@secret.com', NULL, 0, 0, 1),
(619, 'mhuygens', 'mhuygens@secret.com', NULL, 0, 0, 1),
(620, 'nduflos', 'nduflos@secret.com', NULL, 0, 0, 1),
(621, 'mtomczyk', 'mtomczyk@secret.com', '2013-09-07', 0, 0, 1),
(622, 'iboukher', 'iboukher@secret.com', NULL, 0, 0, 1),
(623, 'mbussere', 'mbussere@secret.com', NULL, 0, 0, 1),
(624, 'jwasilew', 'jwasilew@secret.com', '2013-09-06', 0, 0, 1),
(625, 'mherwegh', 'mherwegh@secret.com', '2013-09-07', 0, 0, 1),
(626, 'bdoue', 'bdoue@secret.com', NULL, 0, 0, 1),
(627, 'madli', 'madli@secret.com', '2013-09-07', 0, 0, 1),
(628, 'asigier', 'asigier@secret.com', NULL, 0, 0, 1),
(629, 'crocheri', 'crocheri@secret.com', NULL, 0, 0, 1),
(630, 'avigreux', 'avigreux@secret.com', NULL, 0, 0, 1),
(631, 'kdebaets', 'kdebaets@secret.com', '2013-09-07', 0, 0, 1),
(632, 'gbeaudou', 'gbeaudou@secret.com', '2013-09-05', 0, 0, 1),
(633, 'bcouenne', 'bcouenne@secret.com', NULL, 0, 0, 1),
(634, 'obekraou', 'obekraou@secret.com', NULL, 0, 0, 1),
(635, 'tcuvelie', 'tcuvelie@secret.com', NULL, 0, 0, 1),
(636, 'glind', 'glind@secret.com', '2013-09-05', 0, 0, 1),
(637, 'mseuris', 'mseuris@secret.com', NULL, 0, 0, 1),
(638, 'atabet', 'atabet@secret.com', NULL, 0, 0, 1),
(639, 'aelabbas', 'aelabbas@secret.com', NULL, 0, 0, 1),
(640, 'ksaidi', 'ksaidi@secret.com', NULL, 0, 0, 1),
(641, 'beleves', 'beleves@secret.com', NULL, 0, 0, 1),
(642, 'mmorlier', 'mmorlier@secret.com', NULL, 0, 0, 1),
(643, 'ylaanaia', 'ylaanaia@secret.com', NULL, 0, 0, 1),
(644, 'hel-atla', 'hel-atla@secret.com', NULL, 0, 0, 1),
(645, 'acanonne', 'acanonne@secret.com', NULL, 0, 0, 1),
(646, 'jbyrka', 'jbyrka@secret.com', '2013-09-06', 0, 0, 1),
(647, 'gduvieub', 'gduvieub@secret.com', NULL, 0, 0, 1),
(648, 'nabou-la', 'nabou-la@secret.com', NULL, 0, 0, 1),
(649, 'lcerclet', 'lcerclet@secret.com', NULL, 0, 0, 1),
(650, 'klegrand', 'klegrand@secret.com', NULL, 0, 0, 1),
(651, 'caverlan', 'caverlan@secret.com', NULL, 0, 0, 1),
(652, 'mflorid', 'mflorid@secret.com', NULL, 0, 0, 1),
(653, 'rbuquet', 'rbuquet@secret.com', NULL, 0, 0, 1),
(654, 'bgentil', 'bgentil@secret.com', NULL, 0, 0, 1),
(655, 'jda-cost', 'jda-cost@secret.com', NULL, 0, 0, 1),
(656, 'fourabah', 'fourabah@secret.com', NULL, 0, 0, 1),
(657, 'mfavre-b', 'mfavre-b@secret.com', NULL, 0, 0, 1),
(658, 'mdallest', 'mdallest@secret.com', NULL, 0, 0, 1),
(659, 'lmigne', 'lmigne@secret.com', NULL, 0, 0, 1),
(660, 'fpopelie', 'fpopelie@secret.com', '2013-09-06', 0, 0, 1),
(661, 'mlenoel', 'mlenoel@secret.com', '2013-09-05', 0, 0, 1),
(662, 'xshi1', 'xshi1@secret.com', NULL, 0, 0, 1),
(663, 'broda', 'broda@secret.com', NULL, 0, 0, 1),
(664, 'aboue', 'aboue@secret.com', NULL, 0, 0, 1),
(665, 'ncalais', 'ncalais@secret.com', NULL, 0, 0, 1),
(666, 'fbabin', 'fbabin@secret.com', NULL, 0, 0, 1),
(667, 'agryczka', 'agryczka@secret.com', '2013-09-07', 0, 0, 1),
(668, 'rmaurer', 'rmaurer@secret.com', NULL, 0, 0, 1),
(669, 'abahu', 'abahu@secret.com', NULL, 0, 0, 1),
(670, 'rbokhald', 'rbokhald@secret.com', NULL, 0, 0, 1),
(671, 'jlanglai', 'jlanglai@secret.com', NULL, 0, 0, 1),
(672, 'adenisse', 'adenisse@secret.com', NULL, 0, 0, 1),
(673, 'mfrancoz', 'mfrancoz@polytech-lille.net', '2013-09-01', 0, 0, 1),
(674, 'mperraul', 'mperraul@polytech-lille.net', '2013-09-07', 0, 0, 1),
(675, 'vfourdra', 'vfourdra@polytech-lille.net', '2013-09-05', 0, 0, 1),
(676, 'fporre', 'fporre@polytech-lille.net', '2013-09-08', 0, 0, 1),
(677, 'cfourdeu', 'cfourdeu@polytech-lille.net', '2013-09-07', 0, 0, 1),
(678, 'tlallema', 'tlallema@polytech-lille.net', '2013-09-07', 0, 0, 1),
(679, 'esmessae', 'esmessae@polytech-lille.net', '2013-09-07', 0, 0, 1),
(680, 'alang', 'alang@polytech-lille.net', '2013-09-06', 0, 0, 1),
(681, 'proom', 'proom@polytech-lille.net', '2013-09-07', 0, 0, 1),
(682, 'tdekeire', 'tdekeire@polytech-lille.net', '2013-09-07', 0, 0, 1),
(683, 'bbignon', 'bbignon@polytech-lille.net', '2013-09-06', 0, 0, 1),
(684, 'mel-ghis', 'mel-ghis@polytech-lille.net', '2013-09-06', 0, 0, 1),
(685, 'lwadbled', 'lwadbled@polytech-lille.net', '2013-09-07', 0, 0, 1),
(686, 'fjeannin', 'fjeannin@polytech-lille.net', '2013-09-07', 0, 0, 1),
(687, 'qgauthie', 'qgauthie@polytech-lille.net', '2013-09-07', 0, 0, 1),
(688, 'yaouadi', 'yaouadi@polytech-lille.net', '2013-09-07', 0, 0, 1);

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

--
-- Table structure for table `user_group`
--

CREATE TABLE IF NOT EXISTS `user_group` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `roles` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_8F02BF9D5E237E06` (`name`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=12 ;

--
-- Dumping data for table `user_group`
--

INSERT INTO `user_group` (`id`, `name`, `roles`) VALUES
(1, 'Super-Administrateur', 'a:1:{i:0;s:16:"ROLE_SUPER_ADMIN";}'),
(2, 'Secrétaire', 'a:2:{i:0;s:19:"ROLE_ADMIN_MAIL_ALL";i:1;s:23:"ROLE_ADMIN_DOCUMENT_ALL";}'),
(3, 'Responsable Vidéos', 'a:1:{i:0;s:20:"ROLE_ADMIN_VIDEO_ALL";}'),
(4, 'Responsable Photos', 'a:1:{i:0;s:20:"ROLE_ADMIN_PHOTO_ALL";}'),
(5, 'Photographe', 'a:4:{i:0;s:25:"ROLE_ADMIN_PHOTO_ALB_EDIT";i:1;s:24:"ROLE_ADMIN_PHOTO_ALB_ADD";i:2;s:23:"ROLE_ADMIN_PHOTO_UPLOAD";i:3;s:22:"ROLE_ADMIN_PHOTO_ADMIN";}'),
(6, 'Vice-Président', 'a:6:{i:0;s:19:"ROLE_ADMIN_NEWS_ALL";i:1;s:20:"ROLE_ADMIN_PHOTO_ALL";i:2;s:20:"ROLE_ADMIN_VIDEO_ALL";i:3;s:19:"ROLE_ADMIN_MAIL_ALL";i:4;s:23:"ROLE_ADMIN_DOCUMENT_ALL";i:5;s:24:"ROLE_ADMIN_USER_USER_ALL";}'),
(7, 'Membre du Studio', 'a:4:{i:0;s:16:"ROLE_ADMIN_PHOTO";i:1;s:16:"ROLE_ADMIN_VIDEO";i:2;s:19:"ROLE_ADMIN_DOCUMENT";i:3;s:15:"ROLE_ADMIN_NEWS";}'),
(8, 'Trésorier', 'a:1:{i:0;s:22:"ROLE_ADMIN_ACCOUNT_ALL";}'),
(9, 'Président', 'a:1:{i:0;s:14:"ROLE_ADMIN_ALL";}'),
(10, 'PAF', 'a:1:{i:0;s:18:"ROLE_ADMIN_PAF_ALL";}'),
(11, 'Responsable Publication', 'a:1:{i:0;s:19:"ROLE_ADMIN_NEWS_ALL";}');

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

--
-- Table structure for table `user_user_group`
--

CREATE TABLE IF NOT EXISTS `user_user_group` (
  `user_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  PRIMARY KEY (`user_id`,`group_id`),
  KEY `IDX_28657971A76ED395` (`user_id`),
  KEY `IDX_28657971FE54D947` (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `user_user_group`
--

INSERT INTO `user_user_group` (`user_id`, `group_id`) VALUES
(1, 7),
(1, 11),
(2, 1),
(2, 7),
(3, 3),
(3, 5),
(3, 7),
(12, 5),
(12, 7),
(13, 5),
(13, 7),
(26, 7),
(33, 7),
(76, 5),
(76, 7),
(86, 10),
(109, 7),
(151, 5),
(151, 7),
(229, 7),
(237, 1),
(301, 4),
(301, 5),
(301, 7),
(332, 7),
(345, 5),
(345, 6),
(345, 7),
(367, 7),
(375, 7),
(540, 7),
(540, 9),
(545, 2),
(545, 7),
(625, 5),
(625, 7);

/*!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 */;