File "base_sql.sql"
Full Path: /home/analogde/www/Massage_v1_2023/CHESS_2022/base_sql.sql
File size: 65.16 KB
MIME-type: text/plain
Charset: utf-8
-- phpMyAdmin SQL Dump
-- version 4.0.4
-- http://www.phpmyadmin.net
--
-- Client: localhost
-- Généré le: Jeu 17 Septembre 2015 à 21:36
-- Version du serveur: 5.6.12-log
-- Version de PHP: 5.4.12
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: `echec`
--
CREATE DATABASE IF NOT EXISTS `echec` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `echec`;
-- --------------------------------------------------------
--
-- Structure de la table `classement`
--
CREATE TABLE IF NOT EXISTS `classement` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`joueur` varchar(30) NOT NULL DEFAULT '',
`elo` int(11) NOT NULL DEFAULT '0',
`initial` int(11) NOT NULL DEFAULT '0',
`parties` int(11) NOT NULL DEFAULT '0',
`prior` int(11) NOT NULL DEFAULT '0',
`bonus` int(11) NOT NULL DEFAULT '0',
`oldrating` int(11) NOT NULL DEFAULT '0',
`gcount` int(11) NOT NULL DEFAULT '0',
`wins` int(11) NOT NULL DEFAULT '0',
`losses` int(11) NOT NULL DEFAULT '0',
`draws` int(11) NOT NULL DEFAULT '0',
`active` int(11) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=24 ;
--
-- Contenu de la table `classement`
--
INSERT INTO `classement` (`id`, `joueur`, `elo`, `initial`, `parties`, `prior`, `bonus`, `oldrating`, `gcount`, `wins`, `losses`, `draws`, `active`) VALUES
(1, 'alexandre', 802, 750, 9, 9, 0, 827, 9, 3, 6, 0, 1),
(2, 'amokrane', 944, 1050, 75, 50, 0, 960, 75, 24, 50, 1, 1),
(3, 'bertrand', 815, 950, 6, 6, 0, 763, 6, 2, 4, 0, 1),
(4, 'damien', 883, 1000, 13, 13, 0, 865, 13, 5, 8, 0, 1),
(5, 'dominique', 1319, 1100, 114, 50, 0, 1336, 114, 62, 48, 4, 1),
(6, 'emile', 723, 850, 22, 22, 0, 692, 22, 3, 16, 3, 1),
(7, 'fabien', 1201, 1300, 128, 50, 0, 1234, 128, 69, 56, 3, 1),
(8, 'franckdc', 940, 1000, 71, 50, 0, 964, 71, 31, 40, 0, 1),
(9, 'franckv', 1155, 1000, 125, 50, 0, 1142, 125, 56, 65, 4, 1),
(10, 'henrique', 1437, 1300, 140, 50, 0, 1436, 140, 109, 28, 3, 1),
(11, 'joel', 692, 950, 10, 10, 0, 664, 10, 0, 9, 1, 1),
(12, 'laurent', 1208, 1200, 85, 50, 0, 1201, 85, 53, 30, 2, 1),
(13, 'olivier', 1143, 1250, 10, 10, 0, 1108, 10, 5, 5, 0, 1),
(14, 'patrick', 959, 1000, 31, 31, 0, 981, 31, 12, 18, 1, 1),
(15, 'remy', 873, 1100, 66, 50, 0, 888, 66, 19, 46, 1, 1),
(16, 'stephaneb', 973, 1000, 14, 14, 0, 988, 14, 6, 8, 0, 1),
(17, 'stephaner', 904, 1000, 92, 50, 0, 914, 92, 35, 53, 4, 1),
(18, 'thierry', 608, 1000, 5, 5, 0, 595, 5, 0, 4, 1, 1),
(19, 'bidule', 1255, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1),
(20, 'tartuffe', 1111, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1),
(21, 'zorro', 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1),
(22, 'youpi', 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1),
(23, 'dick', 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1);
-- --------------------------------------------------------
--
-- Structure de la table `elo_affectation`
--
CREATE TABLE IF NOT EXISTS `elo_affectation` (
`joueur` varchar(30) NOT NULL DEFAULT '',
`elo` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Contenu de la table `elo_affectation`
--
INSERT INTO `elo_affectation` (`joueur`, `elo`) VALUES
('bidule', 1255),
('tartuffe', 1111),
('zorro', 1000),
('youpi', 1000),
('dick', 1000);
-- --------------------------------------------------------
--
-- Structure de la table `evolution`
--
CREATE TABLE IF NOT EXISTS `evolution` (
`playerID` int(11) DEFAULT NULL,
`rating` int(11) DEFAULT NULL,
`date` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Contenu de la table `evolution`
--
INSERT INTO `evolution` (`playerID`, `rating`, `date`) VALUES
(7, 1400, 1399327200),
(15, 1000, 1399327200),
(5, 1000, 1400450400),
(10, 1400, 1400450400),
(10, 1400, 1400536800),
(5, 1000, 1400536800),
(7, 1000, 1400536800),
(15, 1400, 1400536800),
(10, 1400, 1400623200),
(7, 1000, 1400623200),
(15, 1133, 1402437600),
(7, 1200, 1402437600),
(7, 1320, 1402524000),
(10, 1250, 1402524000),
(10, 1184, 1402783200),
(7, 1375, 1402783200),
(15, 1245, 1402869600),
(10, 1108, 1402869600),
(7, 1279, 1403128800),
(10, 1203, 1403128800),
(10, 1258, 1403647200),
(15, 1156, 1403647200),
(5, 1133, 1403733600),
(18, 800, 1403733600),
(15, 1106, 1403820000),
(10, 1289, 1403820000),
(10, 1327, 1404252000),
(7, 1230, 1404252000),
(7, 1259, 1404338400),
(15, 1066, 1404338400),
(15, 1040, 1404338400),
(7, 1278, 1404338400),
(7, 1246, 1404684000),
(10, 1358, 1404684000),
(5, 1209, 1404684000),
(15, 1007, 1404684000),
(10, 1311, 1404770400),
(5, 1318, 1404770400),
(10, 1258, 1404856800),
(15, 1075, 1404856800),
(5, 1239, 1404856800),
(7, 1286, 1404856800),
(5, 1184, 1404943200),
(10, 1285, 1404943200),
(12, 1337, 1405029600),
(15, 1051, 1405029600),
(12, 1460, 1405375200),
(5, 1153, 1405375200),
(10, 1258, 1405375200),
(7, 1316, 1405375200),
(4, 929, 1405548000),
(10, 1267, 1405548000),
(7, 1283, 1405893600),
(10, 1293, 1405893600),
(5, 1214, 1405893600),
(10, 1261, 1405893600),
(5, 1181, 1405980000),
(7, 1304, 1405980000),
(5, 1199, 1405980000),
(8, 890, 1405980000),
(10, 1296, 1405980000),
(12, 1260, 1405980000),
(10, 1312, 1406152800),
(5, 1174, 1406152800),
(15, 1028, 1406152800),
(5, 1194, 1406152800),
(10, 1333, 1406152800),
(7, 1279, 1406152800),
(7, 1259, 1406239200),
(10, 1351, 1406239200),
(10, 1363, 1406498400),
(5, 1177, 1406498400),
(7, 1242, 1406584800),
(10, 1378, 1406584800),
(5, 1155, 1406671200),
(7, 1261, 1406671200),
(7, 1230, 1406671200),
(5, 1188, 1406671200),
(7, 1207, 1406757600),
(12, 1352, 1406757600),
(10, 1382, 1406757600),
(15, 1020, 1406757600),
(7, 1219, 1406757600),
(15, 1005, 1406757600),
(10, 1350, 1406757600),
(5, 1225, 1406757600),
(5, 1209, 1406844000),
(10, 1364, 1406844000),
(10, 1376, 1407103200),
(7, 1204, 1407103200),
(4, 929, 1407103200),
(12, 1352, 1407103200),
(10, 1378, 1407103200),
(8, 890, 1407103200),
(12, 1360, 1407103200),
(15, 998, 1407103200),
(7, 1190, 1407189600),
(10, 1389, 1407189600),
(10, 1392, 1407189600),
(15, 992, 1407189600),
(9, 996, 1407276000),
(10, 1395, 1407276000),
(12, 1307, 1407276000),
(10, 1413, 1407276000),
(15, 977, 1407276000),
(7, 1202, 1407276000),
(8, 1052, 1407276000),
(15, 940, 1407276000),
(8, 1042, 1407362400),
(10, 1417, 1407362400),
(15, 914, 1407362400),
(9, 1168, 1407362400),
(10, 1426, 1407794400),
(7, 1190, 1407794400),
(7, 1179, 1407967200),
(10, 1434, 1407967200),
(7, 1155, 1408917600),
(5, 1231, 1408917600),
(7, 1186, 1408917600),
(5, 1201, 1408917600),
(12, 1272, 1409522400),
(10, 1446, 1409522400),
(4, 790, 1409522400),
(15, 946, 1409522400),
(10, 1453, 1409608800),
(5, 1191, 1409608800),
(2, 918, 1409608800),
(7, 1201, 1409608800),
(7, 1241, 1409695200),
(10, 1421, 1409695200),
(12, 1283, 1409781600),
(15, 937, 1409781600),
(10, 1423, 1409781600),
(2, 918, 1409781600),
(8, 1038, 1410127200),
(10, 1427, 1410127200),
(17, 768, 1410213600),
(15, 972, 1410213600),
(5, 1205, 1410213600),
(8, 996, 1410213600),
(5, 1185, 1410300000),
(12, 1314, 1410300000),
(2, 810, 1410386400),
(8, 1042, 1410386400),
(5, 1174, 1410386400),
(10, 1434, 1410386400),
(5, 1164, 1410732000),
(10, 1441, 1410732000),
(12, 1326, 1410818400),
(8, 1026, 1410818400),
(5, 1176, 1410818400),
(15, 957, 1410818400),
(15, 1003, 1410818400),
(5, 1136, 1410818400),
(17, 768, 1410818400),
(10, 1441, 1410818400),
(8, 1006, 1410818400),
(13, 1338, 1410818400),
(16, 800, 1410904800),
(14, 1200, 1410904800),
(5, 1142, 1410904800),
(2, 791, 1410904800),
(10, 1441, 1410904800),
(17, 768, 1410904800),
(10, 1443, 1411336800),
(15, 998, 1411336800),
(10, 1409, 1411423200),
(5, 1186, 1411423200),
(2, 791, 1411509600),
(10, 1410, 1411509600),
(8, 942, 1411509600),
(17, 927, 1411509600),
(5, 1212, 1411509600),
(14, 993, 1411509600),
(2, 791, 1411596000),
(12, 1328, 1411596000),
(7, 1247, 1411596000),
(17, 909, 1411596000),
(7, 1233, 1411682400),
(10, 1421, 1411682400),
(12, 1271, 1411941600),
(17, 1042, 1411941600),
(5, 1233, 1412114400),
(9, 1049, 1412114400),
(12, 1239, 1412114400),
(7, 1259, 1412114400),
(2, 791, 1412200800),
(7, 1261, 1412200800),
(5, 1242, 1412200800),
(15, 986, 1412200800),
(7, 1283, 1412632800),
(5, 1219, 1412632800),
(9, 1242, 1412632800),
(10, 1384, 1412632800),
(10, 1396, 1412805600),
(9, 1190, 1412805600),
(10, 1406, 1413237600),
(5, 1206, 1413237600),
(7, 1267, 1413324000),
(10, 1419, 1413324000),
(8, 988, 1413324000),
(17, 970, 1413324000),
(15, 956, 1413410400),
(8, 1021, 1413410400),
(14, 993, 1413756000),
(10, 1422, 1413756000),
(2, 891, 1413842400),
(5, 1160, 1413842400),
(17, 1070, 1413842400),
(10, 1384, 1413842400),
(10, 1389, 1414015200),
(17, 1057, 1414015200),
(16, 1096, 1414015200),
(14, 844, 1414015200),
(17, 1118, 1414101600),
(7, 1230, 1414101600),
(7, 1241, 1414364400),
(8, 1006, 1414364400),
(13, 1163, 1414364400),
(10, 1406, 1414364400),
(2, 886, 1414450800),
(10, 1408, 1414450800),
(5, 1185, 1414450800),
(13, 1028, 1414450800),
(8, 1022, 1414450800),
(14, 796, 1414450800),
(13, 1167, 1414450800),
(5, 1149, 1414450800),
(10, 1415, 1414537200),
(5, 1139, 1414537200),
(7, 1264, 1414623600),
(12, 1212, 1414623600),
(14, 928, 1414623600),
(9, 1057, 1414623600),
(12, 1231, 1414623600),
(5, 1118, 1414623600),
(7, 1270, 1415055600),
(15, 947, 1415055600),
(5, 1109, 1415055600),
(10, 1421, 1415055600),
(17, 1133, 1415055600),
(2, 869, 1415055600),
(7, 1256, 1415228400),
(10, 1432, 1415228400),
(12, 1246, 1415228400),
(16, 1007, 1415228400),
(9, 1098, 1415314800),
(15, 926, 1415314800),
(10, 1442, 1416178800),
(7, 1243, 1416178800),
(10, 1407, 1416265200),
(5, 1155, 1416265200),
(15, 917, 1416265200),
(12, 1252, 1416265200),
(2, 861, 1416265200),
(7, 1247, 1416265200),
(5, 1179, 1416351600),
(17, 1101, 1416351600),
(10, 1418, 1416351600),
(12, 1238, 1416351600),
(5, 1142, 1416438000),
(8, 1062, 1416438000),
(10, 1422, 1416783600),
(8, 1055, 1416783600),
(15, 903, 1416783600),
(5, 1153, 1416783600),
(5, 1143, 1416870000),
(10, 1429, 1416870000),
(9, 1089, 1416870000),
(10, 1434, 1416870000),
(17, 1093, 1416956400),
(10, 1439, 1416956400),
(5, 1162, 1417042800),
(8, 1033, 1417042800),
(10, 1406, 1417388400),
(5, 1204, 1417388400),
(9, 1111, 1417388400),
(15, 887, 1417388400),
(9, 1081, 1417474800),
(5, 1222, 1417474800),
(2, 896, 1417474800),
(15, 853, 1417474800),
(8, 1027, 1417474800),
(10, 1410, 1417474800),
(5, 1247, 1417561200),
(12, 1212, 1417561200),
(5, 1260, 1417647600),
(9, 1060, 1417647600),
(5, 1293, 1417734000),
(10, 1381, 1417734000),
(12, 1226, 1417734000),
(9, 1040, 1417734000),
(5, 1312, 1417993200),
(7, 1226, 1417993200),
(5, 1319, 1418079600),
(9, 1029, 1418079600),
(10, 1393, 1418079600),
(7, 1211, 1418079600),
(5, 1301, 1418166000),
(10, 1409, 1418166000),
(9, 1072, 1418166000),
(12, 1189, 1418166000),
(9, 1120, 1418252400),
(10, 1373, 1418252400),
(9, 1129, 1418684400),
(15, 841, 1418684400),
(5, 1282, 1418684400),
(10, 1389, 1418684400),
(9, 1139, 1418770800),
(2, 883, 1418770800),
(17, 1072, 1418770800),
(12, 1207, 1418770800),
(12, 1177, 1418857200),
(9, 1170, 1418857200),
(15, 892, 1418857200),
(17, 1028, 1418857200),
(5, 1265, 1418943600),
(10, 1403, 1418943600),
(17, 1022, 1420498800),
(10, 1407, 1420498800),
(5, 1237, 1420498800),
(7, 1239, 1420498800),
(10, 1415, 1420585200),
(9, 1159, 1420585200),
(8, 998, 1420585200),
(17, 1051, 1420585200),
(7, 1257, 1420585200),
(9, 1139, 1420585200),
(15, 922, 1420671600),
(2, 852, 1420671600),
(12, 1148, 1420671600),
(9, 1168, 1420671600),
(7, 1268, 1420671600),
(17, 1037, 1420671600),
(7, 1236, 1421103600),
(12, 1182, 1421103600),
(9, 1158, 1421103600),
(10, 1422, 1421103600),
(9, 1137, 1421103600),
(5, 1255, 1421103600),
(9, 1119, 1421190000),
(5, 1270, 1421190000),
(9, 1156, 1421190000),
(5, 1237, 1421190000),
(7, 1194, 1421190000),
(15, 974, 1421190000),
(9, 1183, 1421276400),
(12, 1154, 1421276400),
(2, 835, 1421276400),
(17, 1051, 1421276400),
(7, 1183, 1421276400),
(10, 1430, 1421276400),
(3, 893, 1421622000),
(5, 1244, 1421622000),
(9, 1199, 1421622000),
(17, 1033, 1421622000),
(10, 1418, 1421708400),
(9, 1213, 1421708400),
(5, 1207, 1421708400),
(17, 1076, 1421708400),
(9, 1174, 1421794800),
(8, 1043, 1421794800),
(10, 1382, 1421794800),
(17, 1124, 1421794800),
(15, 1019, 1421881200),
(9, 1135, 1421881200),
(2, 885, 1421881200),
(8, 999, 1421881200),
(10, 1372, 1421881200),
(5, 1218, 1421881200),
(2, 928, 1421967600),
(15, 979, 1421967600),
(13, 1213, 1421967600),
(8, 982, 1421967600),
(10, 1380, 1422226800),
(9, 1124, 1422226800),
(7, 1144, 1422399600),
(15, 1024, 1422399600),
(5, 1228, 1422399600),
(8, 969, 1422399600),
(13, 1235, 1422399600),
(11, 881, 1422399600),
(2, 914, 1422486000),
(7, 1155, 1422486000),
(6, 802, 1422486000),
(12, 1161, 1422486000),
(9, 1150, 1422486000),
(17, 1097, 1422486000),
(18, 595, 1422572400),
(4, 892, 1422572400),
(7, 1180, 1422572400),
(9, 1124, 1422572400),
(2, 903, 1422831600),
(7, 1188, 1422831600),
(12, 1173, 1422831600),
(8, 954, 1422831600),
(5, 1213, 1422918000),
(10, 1392, 1422918000),
(9, 1114, 1422918000),
(10, 1399, 1422918000),
(7, 1206, 1422918000),
(17, 1076, 1422918000),
(7, 1193, 1423004400),
(10, 1409, 1423004400),
(17, 1039, 1423004400),
(8, 994, 1423004400),
(12, 1168, 1423004400),
(9, 1118, 1423004400),
(13, 1202, 1423090800),
(10, 1419, 1423090800),
(8, 1015, 1423090800),
(2, 879, 1423090800),
(17, 1073, 1423090800),
(9, 1085, 1423090800),
(3, 1150, 1423090800),
(16, 878, 1423090800),
(7, 1200, 1423177200),
(2, 870, 1423177200),
(12, 1135, 1423177200),
(17, 1107, 1423177200),
(15, 1004, 1423522800),
(12, 1153, 1423522800),
(9, 1121, 1423522800),
(5, 1179, 1423522800),
(17, 1099, 1423522800),
(10, 1424, 1423522800),
(10, 1430, 1423609200),
(12, 1144, 1423609200),
(2, 895, 1423609200),
(6, 636, 1423609200),
(9, 1113, 1423782000),
(10, 1435, 1423782000),
(5, 1173, 1423782000),
(17, 1105, 1423782000),
(8, 1034, 1423782000),
(2, 874, 1423782000),
(10, 1403, 1424041200),
(7, 1239, 1424041200),
(17, 1137, 1424041200),
(5, 1142, 1424041200),
(5, 1149, 1424127600),
(7, 1232, 1424127600),
(17, 1161, 1424127600),
(9, 1088, 1424127600),
(10, 1410, 1424300400),
(12, 1134, 1424300400),
(9, 1065, 1424300400),
(5, 1170, 1424300400),
(7, 1267, 1424646000),
(10, 1379, 1424646000),
(9, 1078, 1424646000),
(2, 858, 1424646000),
(5, 1158, 1424732400),
(10, 1388, 1424732400),
(12, 1143, 1424732400),
(11, 807, 1424732400),
(17, 1180, 1424732400),
(9, 1056, 1424732400),
(8, 1072, 1424818800),
(5, 1123, 1424818800),
(2, 847, 1424818800),
(12, 1151, 1424818800),
(7, 1277, 1424905200),
(9, 1043, 1424905200),
(2, 844, 1424905200),
(10, 1389, 1424905200),
(14, 1016, 1424905200),
(3, 942, 1424905200),
(6, 629, 1424905200),
(14, 1018, 1424905200),
(17, 1150, 1424905200),
(5, 1153, 1424905200),
(17, 1133, 1424991600),
(7, 1292, 1424991600),
(12, 1158, 1424991600),
(2, 834, 1424991600),
(10, 1394, 1425250800),
(9, 1036, 1425250800),
(7, 1305, 1425250800),
(17, 1117, 1425250800),
(14, 990, 1425337200),
(12, 1173, 1425337200),
(10, 1401, 1425337200),
(17, 1108, 1425337200),
(5, 1189, 1425337200),
(7, 1273, 1425337200),
(6, 807, 1425337200),
(3, 763, 1425337200),
(10, 1405, 1425423600),
(9, 1029, 1425423600),
(3, 763, 1425423600),
(12, 1177, 1425423600),
(17, 1141, 1425510000),
(13, 1140, 1425510000),
(1, 978, 1425510000),
(6, 715, 1425510000),
(12, 1209, 1425596400),
(7, 1243, 1425596400),
(17, 1106, 1425596400),
(9, 1066, 1425596400),
(17, 1129, 1426028400),
(9, 1041, 1426028400),
(9, 1015, 1426114800),
(8, 1097, 1426114800),
(12, 1228, 1426201200),
(17, 1108, 1426201200),
(8, 1117, 1426201200),
(9, 992, 1426201200),
(7, 1247, 1426201200),
(2, 828, 1426201200),
(14, 1053, 1426460400),
(12, 1189, 1426460400),
(9, 987, 1426460400),
(10, 1408, 1426460400),
(13, 1108, 1426546800),
(7, 1263, 1426546800),
(9, 1031, 1426546800),
(12, 1150, 1426546800),
(9, 1061, 1426546800),
(14, 1014, 1426546800),
(10, 1414, 1426633200),
(17, 1099, 1426633200),
(9, 1016, 1426633200),
(2, 879, 1426633200),
(14, 968, 1426633200),
(16, 985, 1426633200),
(15, 986, 1426719600),
(12, 1165, 1426719600),
(10, 1426, 1426719600),
(7, 1249, 1426719600),
(9, 993, 1426806000),
(17, 1119, 1426806000),
(12, 1173, 1426806000),
(2, 868, 1426806000),
(10, 1393, 1426892400),
(5, 1229, 1426892400),
(14, 953, 1426892400),
(12, 1184, 1426892400),
(1, 1046, 1426892400),
(6, 692, 1426892400),
(9, 1032, 1426892400),
(17, 1083, 1426892400),
(5, 1215, 1427238000),
(10, 1404, 1427238000),
(7, 1259, 1427238000),
(9, 1019, 1427238000),
(6, 676, 1427238000),
(16, 1002, 1427238000),
(14, 975, 1427238000),
(2, 843, 1427238000),
(1, 925, 1427238000),
(17, 1107, 1427238000),
(1, 837, 1427324400),
(14, 1000, 1427324400),
(12, 1204, 1427324400),
(8, 1095, 1427324400),
(12, 1215, 1427324400),
(14, 986, 1427324400),
(9, 1044, 1427324400),
(15, 959, 1427324400),
(9, 1087, 1427410800),
(7, 1222, 1427410800),
(9, 1090, 1427410800),
(18, 595, 1427410800),
(6, 676, 1427410800),
(8, 1099, 1427410800),
(17, 1116, 1427410800),
(1, 811, 1427410800),
(12, 1216, 1427410800),
(18, 595, 1427410800),
(7, 1209, 1427666400),
(10, 1414, 1427666400),
(17, 1096, 1427752800),
(7, 1227, 1427752800),
(15, 1000, 1427752800),
(8, 1061, 1427752800),
(16, 975, 1427752800),
(12, 1227, 1427752800),
(9, 1082, 1427752800),
(10, 1419, 1427752800),
(5, 1230, 1427839200),
(9, 1064, 1427839200),
(7, 1231, 1427839200),
(2, 836, 1427839200),
(9, 1074, 1427925600),
(1, 786, 1427925600),
(7, 1195, 1427925600),
(8, 1101, 1427925600),
(3, 815, 1427925600),
(6, 642, 1427925600),
(5, 1254, 1427925600),
(12, 1202, 1427925600),
(12, 1218, 1428012000),
(9, 1056, 1428012000),
(17, 1115, 1428012000),
(15, 978, 1428012000),
(9, 1087, 1428357600),
(8, 1070, 1428357600),
(9, 1116, 1428357600),
(17, 1086, 1428357600),
(1, 883, 1428357600),
(8, 1023, 1428357600),
(9, 1099, 1428444000),
(5, 1268, 1428444000),
(4, 922, 1428530400),
(6, 626, 1428530400),
(10, 1427, 1428530400),
(7, 1184, 1428530400),
(2, 872, 1428530400),
(1, 827, 1428530400),
(5, 1280, 1428530400),
(9, 1084, 1428530400),
(7, 1202, 1428616800),
(9, 1064, 1428616800),
(17, 1095, 1428616800),
(11, 766, 1428616800),
(2, 853, 1428616800),
(8, 1039, 1428616800),
(7, 1232, 1428876000),
(5, 1251, 1428876000),
(11, 734, 1428876000),
(8, 1048, 1428876000),
(12, 1178, 1428876000),
(15, 1025, 1428876000),
(12, 1208, 1428962400),
(5, 1222, 1428962400),
(9, 1094, 1428962400),
(17, 1065, 1428962400),
(7, 1236, 1428962400),
(2, 846, 1428962400),
(9, 1141, 1429048800),
(10, 1392, 1429048800),
(5, 1247, 1429048800),
(7, 1210, 1429048800),
(2, 860, 1429048800),
(6, 609, 1429048800),
(7, 1197, 1429135200),
(10, 1402, 1429135200),
(12, 1228, 1429135200),
(9, 1119, 1429135200),
(11, 679, 1429221600),
(2, 880, 1429221600),
(9, 1141, 1429221600),
(17, 1041, 1429221600),
(9, 1173, 1429480800),
(12, 1197, 1429480800),
(7, 1211, 1429480800),
(8, 1031, 1429480800),
(10, 1372, 1429480800),
(5, 1280, 1429480800),
(5, 1309, 1429567200),
(10, 1345, 1429567200),
(17, 1022, 1429567200),
(9, 1189, 1429567200),
(2, 871, 1429567200),
(7, 1217, 1429567200),
(17, 1035, 1429653600),
(12, 1185, 1429653600),
(7, 1239, 1429653600),
(9, 1165, 1429653600),
(6, 595, 1429653600),
(2, 882, 1429653600),
(10, 1356, 1429740000),
(9, 1151, 1429740000),
(7, 1219, 1429740000),
(5, 1327, 1429740000),
(12, 1192, 1429740000),
(2, 872, 1429740000),
(9, 1181, 1429826400),
(7, 1189, 1429826400),
(10, 1367, 1430085600),
(7, 1175, 1430085600),
(6, 589, 1430085600),
(15, 1029, 1430085600),
(10, 1372, 1430172000),
(15, 1021, 1430172000),
(17, 994, 1430172000),
(2, 917, 1430172000),
(12, 1178, 1430172000),
(10, 1383, 1430172000),
(8, 1071, 1430172000),
(9, 1145, 1430172000),
(9, 1131, 1430258400),
(5, 1338, 1430258400),
(5, 1350, 1430258400),
(7, 1160, 1430258400),
(7, 1187, 1430344800),
(12, 1151, 1430344800),
(2, 892, 1430344800),
(17, 1016, 1430344800),
(2, 869, 1430431200),
(6, 615, 1430431200),
(2, 849, 1430690400),
(17, 1033, 1430690400),
(7, 1209, 1430690400),
(12, 1127, 1430690400),
(10, 1394, 1430776800),
(7, 1195, 1430776800),
(17, 1025, 1430776800),
(5, 1356, 1430776800),
(8, 1103, 1430863200),
(12, 1096, 1430863200),
(15, 1015, 1430863200),
(10, 1398, 1430863200),
(7, 1180, 1430863200),
(5, 1368, 1430863200),
(7, 1167, 1431295200),
(5, 1378, 1431295200),
(5, 1358, 1431381600),
(10, 1417, 1431381600),
(15, 1055, 1431381600),
(7, 1130, 1431381600),
(17, 1004, 1431468000),
(9, 1149, 1431468000),
(12, 1086, 1431986400),
(5, 1365, 1431986400),
(9, 1139, 1431986400),
(10, 1424, 1431986400),
(5, 1347, 1432072800),
(10, 1440, 1432072800),
(9, 1154, 1432072800),
(14, 968, 1432072800),
(2, 839, 1432072800),
(9, 1161, 1432072800),
(8, 1122, 1432072800),
(17, 983, 1432072800),
(17, 1020, 1432159200),
(12, 1050, 1432159200),
(12, 1071, 1432159200),
(14, 945, 1432159200),
(7, 1155, 1432159200),
(8, 1096, 1432159200),
(17, 977, 1432245600),
(2, 887, 1432245600),
(11, 679, 1432245600),
(7, 1158, 1432245600),
(12, 1100, 1432245600),
(8, 1066, 1432245600),
(10, 1454, 1432245600),
(5, 1330, 1432245600),
(15, 1035, 1432591200),
(9, 1179, 1432591200),
(9, 1202, 1432677600),
(7, 1133, 1432677600),
(17, 954, 1432677600),
(8, 1086, 1432677600),
(9, 1208, 1432764000),
(2, 878, 1432764000),
(8, 1109, 1432764000),
(15, 1010, 1432764000),
(4, 1019, 1432850400),
(8, 1069, 1432850400),
(4, 969, 1432850400),
(8, 1092, 1432850400),
(2, 857, 1432850400),
(15, 1028, 1432850400),
(17, 998, 1432850400),
(7, 1094, 1432850400),
(9, 1247, 1433109600),
(10, 1422, 1433109600),
(8, 1103, 1433109600),
(2, 843, 1433109600),
(17, 977, 1433109600),
(12, 1119, 1433109600),
(12, 1154, 1433196000),
(9, 1214, 1433196000),
(10, 1422, 1433196000),
(11, 679, 1433196000),
(2, 895, 1433196000),
(7, 1050, 1433196000),
(9, 1202, 1433282400),
(10, 1431, 1433282400),
(7, 1072, 1433282400),
(17, 953, 1433282400),
(9, 1165, 1433368800),
(15, 1069, 1433368800),
(17, 995, 1433368800),
(8, 1065, 1433368800),
(9, 1155, 1433455200),
(10, 1438, 1433455200),
(2, 878, 1433455200),
(7, 1086, 1433455200),
(8, 1013, 1433455200),
(6, 684, 1433455200),
(8, 1066, 1433714400),
(10, 1401, 1433714400),
(1, 802, 1433714400),
(17, 1011, 1433714400),
(6, 674, 1433714400),
(17, 1018, 1433714400),
(2, 917, 1433714400),
(4, 907, 1433714400),
(9, 1141, 1433714400),
(5, 1341, 1433714400),
(12, 1170, 1433800800),
(17, 999, 1433800800),
(15, 1042, 1433800800),
(7, 1111, 1433800800),
(2, 946, 1433800800),
(4, 863, 1433800800),
(14, 930, 1433800800),
(9, 1153, 1433800800),
(2, 956, 1433887200),
(6, 661, 1433887200),
(17, 1040, 1433887200),
(9, 1116, 1433887200),
(10, 1376, 1433887200),
(5, 1366, 1433887200),
(18, 608, 1433973600),
(6, 654, 1433973600),
(10, 1383, 1433973600),
(7, 1101, 1433973600),
(9, 1146, 1433973600),
(12, 1140, 1433973600),
(17, 1016, 1434060000),
(7, 1123, 1434060000),
(16, 919, 1434060000),
(14, 964, 1434060000),
(6, 647, 1434060000),
(8, 1070, 1434060000),
(12, 1153, 1434319200),
(2, 940, 1434319200),
(5, 1374, 1434319200),
(7, 1112, 1434319200),
(4, 831, 1434405600),
(2, 963, 1434405600),
(12, 1156, 1434492000),
(11, 679, 1434492000),
(7, 1078, 1434492000),
(17, 1052, 1434492000),
(11, 664, 1434492000),
(2, 972, 1434492000),
(5, 1395, 1434492000),
(10, 1361, 1434492000),
(8, 1104, 1434578400),
(12, 1123, 1434578400),
(8, 1078, 1434664800),
(12, 1148, 1434664800),
(2, 949, 1434664800),
(17, 1073, 1434664800),
(7, 1075, 1434664800),
(15, 1044, 1434664800),
(12, 1173, 1434924000),
(9, 1120, 1434924000),
(4, 876, 1434924000),
(16, 863, 1434924000),
(8, 1096, 1434924000),
(14, 943, 1434924000),
(14, 985, 1434924000),
(8, 1057, 1434924000),
(2, 929, 1434924000),
(7, 1092, 1434924000),
(12, 1180, 1435010400),
(4, 865, 1435010400),
(14, 960, 1435010400),
(15, 1067, 1435010400),
(5, 1372, 1435010400),
(10, 1384, 1435010400),
(13, 1143, 1435010400),
(17, 1048, 1435010400),
(5, 1351, 1435096800),
(10, 1404, 1435096800),
(10, 1400, 1435096800),
(5, 1354, 1435096800),
(17, 1066, 1435096800),
(2, 908, 1435096800),
(9, 1076, 1435096800),
(16, 928, 1435096800),
(7, 1117, 1435183200),
(9, 1049, 1435183200),
(6, 713, 1435269600),
(15, 1016, 1435269600),
(2, 890, 1435269600),
(17, 1081, 1435269600),
(5, 1360, 1435269600),
(9, 1040, 1435269600),
(9, 1032, 1435269600),
(5, 1365, 1435269600),
(9, 1064, 1435528800),
(17, 1049, 1435528800),
(14, 927, 1435528800),
(16, 967, 1435528800),
(9, 1081, 1435615200),
(14, 907, 1435615200),
(8, 1084, 1435615200),
(17, 1021, 1435615200),
(14, 890, 1435701600),
(9, 1095, 1435701600),
(17, 1000, 1435701600),
(7, 1136, 1435701600),
(16, 951, 1435701600),
(12, 1191, 1435701600),
(10, 1405, 1435788000),
(8, 1076, 1435788000),
(12, 1209, 1435788000),
(9, 1075, 1435788000),
(14, 931, 1435788000),
(17, 961, 1435788000),
(5, 1374, 1435788000),
(7, 1124, 1435788000),
(7, 1138, 1435874400),
(17, 944, 1435874400),
(9, 1102, 1435874400),
(8, 1048, 1435874400),
(14, 914, 1436133600),
(9, 1116, 1436133600),
(8, 1027, 1436133600),
(7, 1157, 1436133600),
(12, 1217, 1436133600),
(17, 933, 1436133600),
(9, 1106, 1436220000),
(5, 1381, 1436220000),
(12, 1237, 1436306400),
(7, 1135, 1436306400),
(9, 1065, 1436306400),
(14, 960, 1436306400),
(7, 1156, 1436392800),
(9, 1042, 1436392800),
(16, 988, 1436392800),
(8, 992, 1436392800),
(8, 1044, 1436479200),
(5, 1342, 1436479200),
(9, 1022, 1436479200),
(7, 1173, 1436479200),
(6, 692, 1436479200),
(4, 883, 1436479200),
(8, 1030, 1436911200),
(12, 1248, 1436911200),
(8, 1050, 1436997600),
(17, 910, 1436997600),
(7, 1189, 1437084000),
(8, 1031, 1437084000),
(5, 1367, 1437084000),
(10, 1380, 1437084000),
(17, 939, 1437343200),
(2, 860, 1437343200),
(10, 1390, 1437429600),
(7, 1176, 1437429600),
(14, 981, 1437429600),
(2, 836, 1437429600),
(8, 1023, 1437429600),
(5, 1372, 1437429600),
(12, 1232, 1437516000),
(5, 1385, 1437516000),
(9, 979, 1437516000),
(2, 884, 1437516000),
(17, 926, 1437516000),
(7, 1186, 1437516000),
(17, 930, 1437602400),
(9, 974, 1437602400),
(2, 939, 1437602400),
(12, 1189, 1437602400),
(9, 970, 1437688800),
(17, 933, 1437688800),
(6, 723, 1437775200),
(7, 1163, 1437775200),
(10, 1410, 1437948000),
(5, 1364, 1437948000),
(2, 972, 1437948000),
(9, 937, 1437948000),
(7, 1178, 1438034400),
(15, 998, 1438034400),
(9, 970, 1438034400),
(2, 939, 1438034400),
(10, 1418, 1438120800),
(7, 1167, 1438120800),
(5, 1369, 1438120800),
(8, 1015, 1438120800),
(2, 911, 1438120800),
(9, 997, 1438120800),
(7, 1205, 1438207200),
(5, 1336, 1438207200),
(10, 1421, 1438207200),
(9, 992, 1438207200),
(2, 950, 1438207200),
(8, 977, 1438207200),
(17, 969, 1438207200),
(15, 963, 1438207200),
(15, 991, 1438293600),
(2, 920, 1438293600),
(5, 1319, 1438293600),
(10, 1436, 1438293600),
(17, 941, 1438293600),
(9, 1019, 1438293600),
(11, 692, 1438380000),
(14, 959, 1438380000),
(2, 956, 1438552800),
(15, 955, 1438552800),
(9, 1041, 1438552800),
(17, 917, 1438552800),
(7, 1215, 1438552800),
(8, 964, 1438552800),
(2, 985, 1438639200),
(15, 925, 1438639200),
(9, 1063, 1438639200),
(8, 940, 1438639200),
(17, 914, 1438639200),
(10, 1437, 1438639200),
(16, 973, 1438639200),
(12, 1201, 1438639200),
(17, 904, 1438725600),
(12, 1208, 1438725600),
(9, 1080, 1438725600),
(15, 905, 1438725600),
(2, 972, 1438725600),
(7, 1225, 1438725600),
(2, 960, 1438812000),
(7, 1234, 1438812000),
(15, 888, 1438812000),
(9, 1094, 1438812000),
(15, 873, 1438812000),
(9, 1106, 1438812000),
(9, 1142, 1438898400),
(7, 1201, 1438898400),
(9, 1155, 1439157600),
(2, 944, 1439157600);
-- --------------------------------------------------------
--
-- Structure de la table `membres`
--
CREATE TABLE IF NOT EXISTS `membres` (
`id` tinyint(4) unsigned NOT NULL AUTO_INCREMENT,
`login` varchar(80) NOT NULL DEFAULT '',
`nom` varchar(30) NOT NULL DEFAULT '',
`prenom` varchar(30) NOT NULL DEFAULT '',
`password` varchar(30) NOT NULL DEFAULT '',
`email` varchar(80) NOT NULL DEFAULT '',
`statut_compte` varchar(20) NOT NULL DEFAULT '',
`cle` varchar(8) NOT NULL DEFAULT '',
`avatar` varchar(30) NOT NULL DEFAULT '',
`date_inscription` date NOT NULL DEFAULT '0000-00-00',
`heure_inscription` time NOT NULL DEFAULT '00:00:00',
`date_modification` date NOT NULL DEFAULT '0000-00-00',
`heure_modification` time NOT NULL DEFAULT '00:00:00',
`signature` mediumtext NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=52 ;
--
-- Contenu de la table `membres`
--
INSERT INTO `membres` (`id`, `login`, `nom`, `prenom`, `password`, `email`, `statut_compte`, `cle`, `avatar`, `date_inscription`, `heure_inscription`, `date_modification`, `heure_modification`, `signature`) VALUES
(1, 'patoche', 'delpy', 'patrice', 'biloute', 'patrice.delpy@free.ff', 'actif', '0d37ef9a', '', '2026-11-20', '21:00:00', '0000-00-00', '00:00:00', ''),
(8, 'coco', 'delpy', 'patrice', 'rainbow', 'patrice.delpy@neuf.fr', 'actif', '416ac2d9', 'no_avatar.jpg', '2003-12-20', '20:25:00', '0000-00-00', '00:00:00', ''),
(33, 'pistache', 'delpy', 'patoche', 'tarte', 'qpatrice.delpy@free.fr', 'actif', '24b91c5e', 'pistache_avatar.jpg', '2013-02-17', '16:15:00', '0000-00-00', '00:00:00', '<p><img alt="angel" height="20" src="http://analog-design.net/WORKAREA/WEBSITE/site_02_12_2013_template/ckeditor/plugins/smiley/images/angel_smile.gif" title="angel" width="20" /> le <span style="color:#FF8C00;">plein </span>de <u><span style="font-size:14px;">soleil</span></u><span style="font-size:14px;"> , je pifou </span></p>\r\n'),
(41, 'essa', 'Delpy', 'Patrice', 'azer', 'patoche@analog-design.net', 'creation', 'ac124567', '', '2013-03-13', '22:08:00', '0000-00-00', '00:00:00', ''),
(42, 'ffxmph', 'patrice', 'Delpy', 'Saturn05', 'ffxmph@onsemi.com', 'actif', '4c95de6f', '', '2013-08-13', '18:57:00', '0000-00-00', '00:00:00', ''),
(45, 'cocoaq', 'delpu', 'gdkfk', 'boby', 'patrice.delpy@neuf.fr', 'actif', 'eab4970d', '', '2013-09-25', '20:01:00', '0000-00-00', '00:00:00', ''),
(46, 'coco1789', 'pipo', 'riri', 'aqwzsx', 'patrice.delpy@neuf.fr', 'actif', '0d4ea139', '', '2013-09-25', '20:43:00', '0000-00-00', '00:00:00', ''),
(48, 'no', 'azer', 'vincent', 'merde', 'zapatrice.delpy@free.fr', 'actif', 'def01467', 'no_avatar.jpg', '2013-09-25', '21:09:00', '0000-00-00', '00:00:00', ''),
(49, 'brutus', 'delpy', 'patrice', 'zorro', 'patrice.delpy@free.fr', 'creation', 'adef0278', '', '2013-10-13', '11:19:00', '0000-00-00', '00:00:00', ''),
(51, 'pipotron', 'DELPY', 'patrice', 'aqwzsx', 'patrice.delpy@free.fr', 'creation', 'cef02456', 'no_avatar.jpg', '2013-12-04', '22:12:00', '0000-00-00', '00:00:00', '');
-- --------------------------------------------------------
--
-- Structure de la table `parties`
--
CREATE TABLE IF NOT EXISTS `parties` (
`w_playerID` int(11) DEFAULT NULL,
`w_name` varchar(30) NOT NULL DEFAULT '',
`b_playerID` int(11) DEFAULT NULL,
`b_name` varchar(30) NOT NULL DEFAULT '',
`w_brating` int(11) DEFAULT NULL,
`w_arating` int(11) DEFAULT NULL,
`b_brating` int(11) DEFAULT NULL,
`b_arating` int(11) DEFAULT NULL,
`result` int(11) DEFAULT NULL,
`date` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Contenu de la table `parties`
--
INSERT INTO `parties` (`w_playerID`, `w_name`, `b_playerID`, `b_name`, `w_brating`, `w_arating`, `b_brating`, `b_arating`, `result`, `date`) VALUES
(7, 'fabien', 15, 'remy', 1300, 1400, 1100, 1000, 1, 1399327200),
(5, 'dominique', 10, 'henrique', 1100, 1000, 1300, 1400, 2, 1400450400),
(10, 'henrique', 5, 'dominique', 1400, 1400, 1000, 1000, 1, 1400536800),
(7, 'fabien', 15, 'remy', 1400, 1000, 1000, 1400, 2, 1400536800),
(10, 'henrique', 7, 'fabien', 1400, 1400, 1000, 1000, 1, 1400623200),
(15, 'remy', 7, 'fabien', 1400, 1133, 1000, 1200, 2, 1402437600),
(7, 'fabien', 10, 'henrique', 1200, 1320, 1400, 1250, 1, 1402524000),
(10, 'henrique', 7, 'fabien', 1250, 1184, 1320, 1375, 2, 1402783200),
(15, 'remy', 10, 'henrique', 1133, 1245, 1184, 1108, 1, 1402869600),
(7, 'fabien', 10, 'henrique', 1375, 1279, 1108, 1203, 2, 1403128800),
(10, 'henrique', 15, 'remy', 1203, 1258, 1245, 1156, 1, 1403647200),
(5, 'dominique', 18, 'thierry', 1000, 1133, 1000, 800, 1, 1403733600),
(15, 'remy', 10, 'henrique', 1156, 1106, 1258, 1289, 2, 1403820000),
(10, 'henrique', 7, 'fabien', 1289, 1327, 1279, 1230, 1, 1404252000),
(7, 'fabien', 15, 'remy', 1230, 1259, 1106, 1066, 1, 1404338400),
(15, 'remy', 7, 'fabien', 1066, 1040, 1259, 1278, 2, 1404338400),
(7, 'fabien', 10, 'henrique', 1278, 1246, 1327, 1358, 2, 1404684000),
(5, 'dominique', 15, 'remy', 1133, 1209, 1040, 1007, 1, 1404684000),
(10, 'henrique', 5, 'dominique', 1358, 1311, 1209, 1318, 2, 1404770400),
(10, 'henrique', 15, 'remy', 1311, 1258, 1007, 1075, 2, 1404856800),
(5, 'dominique', 7, 'fabien', 1318, 1239, 1246, 1286, 2, 1404856800),
(5, 'dominique', 10, 'henrique', 1239, 1184, 1258, 1285, 2, 1404943200),
(12, 'laurent', 15, 'remy', 1200, 1337, 1075, 1051, 1, 1405029600),
(12, 'laurent', 5, 'dominique', 1337, 1460, 1184, 1153, 1, 1405375200),
(10, 'henrique', 7, 'fabien', 1285, 1258, 1286, 1316, 2, 1405375200),
(4, 'damien', 10, 'henrique', 1000, 929, 1258, 1267, 2, 1405548000),
(7, 'fabien', 10, 'henrique', 1316, 1283, 1267, 1293, 2, 1405893600),
(5, 'dominique', 10, 'henrique', 1153, 1214, 1293, 1261, 1, 1405893600),
(5, 'dominique', 7, 'fabien', 1214, 1181, 1283, 1304, 2, 1405980000),
(5, 'dominique', 8, 'franckdc', 1181, 1199, 1000, 890, 1, 1405980000),
(10, 'henrique', 12, 'laurent', 1261, 1296, 1460, 1260, 1, 1405980000),
(10, 'henrique', 5, 'dominique', 1296, 1312, 1199, 1174, 1, 1406152800),
(15, 'remy', 5, 'dominique', 1051, 1028, 1174, 1194, 2, 1406152800),
(10, 'henrique', 7, 'fabien', 1312, 1333, 1304, 1279, 1, 1406152800),
(7, 'fabien', 10, 'henrique', 1279, 1259, 1333, 1351, 2, 1406239200),
(10, 'henrique', 5, 'dominique', 1351, 1363, 1194, 1177, 1, 1406498400),
(7, 'fabien', 10, 'henrique', 1259, 1242, 1363, 1378, 2, 1406584800),
(5, 'dominique', 7, 'fabien', 1177, 1155, 1242, 1261, 2, 1406671200),
(7, 'fabien', 5, 'dominique', 1261, 1230, 1155, 1188, 2, 1406671200),
(7, 'fabien', 12, 'laurent', 1230, 1207, 1260, 1352, 2, 1406757600),
(10, 'henrique', 15, 'remy', 1378, 1382, 1028, 1020, 1, 1406757600),
(7, 'fabien', 15, 'remy', 1207, 1219, 1020, 1005, 1, 1406757600),
(10, 'henrique', 5, 'dominique', 1382, 1350, 1188, 1225, 2, 1406757600),
(5, 'dominique', 10, 'henrique', 1225, 1209, 1350, 1364, 2, 1406844000),
(10, 'henrique', 7, 'fabien', 1364, 1376, 1219, 1204, 1, 1407103200),
(4, 'damien', 12, 'laurent', 929, 929, 1352, 1352, 2, 1407103200),
(10, 'henrique', 8, 'franckdc', 1376, 1378, 890, 890, 1, 1407103200),
(12, 'laurent', 15, 'remy', 1352, 1360, 1005, 998, 1, 1407103200),
(7, 'fabien', 10, 'henrique', 1204, 1190, 1378, 1389, 2, 1407189600),
(10, 'henrique', 15, 'remy', 1389, 1392, 998, 992, 1, 1407189600),
(9, 'franckv', 10, 'henrique', 1000, 996, 1392, 1395, 2, 1407276000),
(12, 'laurent', 10, 'henrique', 1360, 1307, 1395, 1413, 2, 1407276000),
(15, 'remy', 7, 'fabien', 992, 977, 1190, 1202, 2, 1407276000),
(8, 'franckdc', 15, 'remy', 890, 1052, 977, 940, 1, 1407276000),
(8, 'franckdc', 10, 'henrique', 1052, 1042, 1413, 1417, 2, 1407362400),
(15, 'remy', 9, 'franckv', 940, 914, 996, 1168, 2, 1407362400),
(10, 'henrique', 7, 'fabien', 1417, 1426, 1202, 1190, 1, 1407794400),
(7, 'fabien', 10, 'henrique', 1190, 1179, 1426, 1434, 2, 1407967200),
(7, 'fabien', 5, 'dominique', 1179, 1155, 1209, 1231, 2, 1408917600),
(7, 'fabien', 5, 'dominique', 1155, 1186, 1231, 1201, 1, 1408917600),
(12, 'laurent', 10, 'henrique', 1307, 1272, 1434, 1446, 2, 1409522400),
(4, 'damien', 15, 'remy', 929, 790, 914, 946, 2, 1409522400),
(10, 'henrique', 5, 'dominique', 1446, 1453, 1201, 1191, 1, 1409608800),
(2, 'amokrane', 7, 'fabien', 1050, 918, 1186, 1201, 2, 1409608800),
(7, 'fabien', 10, 'henrique', 1201, 1241, 1453, 1421, 1, 1409695200),
(12, 'laurent', 15, 'remy', 1272, 1283, 946, 937, 1, 1409781600),
(10, 'henrique', 2, 'amokrane', 1421, 1423, 918, 918, 1, 1409781600),
(8, 'franckdc', 10, 'henrique', 1042, 1038, 1423, 1427, 2, 1410127200),
(17, 'stephaner', 15, 'remy', 1000, 768, 937, 972, 2, 1410213600),
(5, 'dominique', 8, 'franckdc', 1191, 1205, 1038, 996, 1, 1410213600),
(5, 'dominique', 12, 'laurent', 1205, 1185, 1283, 1314, 2, 1410300000),
(2, 'amokrane', 8, 'franckdc', 918, 810, 996, 1042, 2, 1410386400),
(5, 'dominique', 10, 'henrique', 1185, 1174, 1427, 1434, 2, 1410386400),
(5, 'dominique', 10, 'henrique', 1174, 1164, 1434, 1441, 2, 1410732000),
(12, 'laurent', 8, 'franckdc', 1314, 1326, 1042, 1026, 1, 1410818400),
(5, 'dominique', 15, 'remy', 1164, 1176, 972, 957, 1, 1410818400),
(15, 'remy', 5, 'dominique', 957, 1003, 1176, 1136, 1, 1410818400),
(17, 'stephaner', 10, 'henrique', 768, 768, 1441, 1441, 2, 1410818400),
(8, 'franckdc', 13, 'olivier', 1026, 1006, 1250, 1338, 2, 1410818400),
(16, 'stephaneb', 14, 'patrick', 1000, 800, 1000, 1200, 2, 1410904800),
(5, 'dominique', 2, 'amokrane', 1136, 1142, 810, 791, 1, 1410904800),
(10, 'henrique', 17, 'stephaner', 1441, 1441, 768, 768, 1, 1410904800),
(10, 'henrique', 15, 'remy', 1441, 1443, 1003, 998, 1, 1411336800),
(10, 'henrique', 5, 'dominique', 1443, 1409, 1142, 1186, 2, 1411423200),
(2, 'amokrane', 10, 'henrique', 791, 791, 1409, 1410, 2, 1411509600),
(8, 'franckdc', 17, 'stephaner', 1006, 942, 768, 927, 2, 1411509600),
(5, 'dominique', 14, 'patrick', 1186, 1212, 1200, 993, 1, 1411509600),
(2, 'amokrane', 12, 'laurent', 791, 791, 1326, 1328, 2, 1411596000),
(7, 'fabien', 17, 'stephaner', 1241, 1247, 927, 909, 1, 1411596000),
(7, 'fabien', 10, 'henrique', 1247, 1233, 1410, 1421, 2, 1411682400),
(12, 'laurent', 17, 'stephaner', 1328, 1271, 909, 1042, 2, 1411941600),
(5, 'dominique', 9, 'franckv', 1212, 1233, 1168, 1049, 1, 1412114400),
(12, 'laurent', 7, 'fabien', 1271, 1239, 1233, 1259, 2, 1412114400),
(2, 'amokrane', 7, 'fabien', 791, 791, 1259, 1261, 2, 1412200800),
(5, 'dominique', 15, 'remy', 1233, 1242, 998, 986, 1, 1412200800),
(7, 'fabien', 5, 'dominique', 1261, 1283, 1242, 1219, 1, 1412632800),
(9, 'franckv', 10, 'henrique', 1049, 1242, 1421, 1384, 1, 1412632800),
(10, 'henrique', 9, 'franckv', 1384, 1396, 1242, 1190, 1, 1412805600),
(10, 'henrique', 5, 'dominique', 1396, 1406, 1219, 1206, 1, 1413237600),
(7, 'fabien', 10, 'henrique', 1283, 1267, 1406, 1419, 2, 1413324000),
(8, 'franckdc', 17, 'stephaner', 942, 988, 1042, 970, 1, 1413324000),
(15, 'remy', 8, 'franckdc', 986, 956, 988, 1021, 2, 1413410400),
(14, 'patrick', 10, 'henrique', 993, 993, 1419, 1422, 2, 1413756000),
(2, 'amokrane', 5, 'dominique', 791, 891, 1206, 1160, 1, 1413842400),
(17, 'stephaner', 10, 'henrique', 970, 1070, 1422, 1384, 1, 1413842400),
(10, 'henrique', 17, 'stephaner', 1384, 1389, 1070, 1057, 1, 1414015200),
(16, 'stephaneb', 14, 'patrick', 800, 1096, 993, 844, 1, 1414015200),
(17, 'stephaner', 7, 'fabien', 1057, 1118, 1267, 1230, 1, 1414101600),
(7, 'fabien', 8, 'franckdc', 1230, 1241, 1021, 1006, 1, 1414364400),
(13, 'olivier', 10, 'henrique', 1338, 1163, 1389, 1406, 2, 1414364400),
(2, 'amokrane', 10, 'henrique', 891, 886, 1406, 1408, 2, 1414450800),
(5, 'dominique', 13, 'olivier', 1160, 1185, 1163, 1028, 1, 1414450800),
(8, 'franckdc', 14, 'patrick', 1006, 1022, 844, 796, 1, 1414450800),
(13, 'olivier', 5, 'dominique', 1028, 1167, 1185, 1149, 1, 1414450800),
(10, 'henrique', 5, 'dominique', 1408, 1415, 1149, 1139, 1, 1414537200),
(7, 'fabien', 12, 'laurent', 1241, 1264, 1239, 1212, 1, 1414623600),
(14, 'patrick', 9, 'franckv', 796, 928, 1190, 1057, 1, 1414623600),
(12, 'laurent', 5, 'dominique', 1212, 1231, 1139, 1118, 1, 1414623600),
(7, 'fabien', 15, 'remy', 1264, 1270, 956, 947, 1, 1415055600),
(5, 'dominique', 10, 'henrique', 1118, 1109, 1415, 1421, 2, 1415055600),
(17, 'stephaner', 2, 'amokrane', 1118, 1133, 886, 869, 1, 1415055600),
(7, 'fabien', 10, 'henrique', 1270, 1256, 1421, 1432, 2, 1415228400),
(12, 'laurent', 16, 'stephaneb', 1231, 1246, 1096, 1007, 1, 1415228400),
(9, 'franckv', 15, 'remy', 1057, 1098, 947, 926, 1, 1415314800),
(10, 'henrique', 7, 'fabien', 1432, 1442, 1256, 1243, 1, 1416178800),
(10, 'henrique', 5, 'dominique', 1442, 1407, 1109, 1155, 2, 1416265200),
(15, 'remy', 12, 'laurent', 926, 917, 1246, 1252, 2, 1416265200),
(2, 'amokrane', 7, 'fabien', 869, 861, 1243, 1247, 2, 1416265200),
(5, 'dominique', 17, 'stephaner', 1155, 1179, 1133, 1101, 1, 1416351600),
(10, 'henrique', 12, 'laurent', 1407, 1418, 1252, 1238, 1, 1416351600),
(5, 'dominique', 8, 'franckdc', 1179, 1142, 1022, 1062, 2, 1416438000),
(10, 'henrique', 8, 'franckdc', 1418, 1422, 1062, 1055, 1, 1416783600),
(15, 'remy', 5, 'dominique', 917, 903, 1142, 1153, 2, 1416783600),
(5, 'dominique', 10, 'henrique', 1153, 1143, 1422, 1429, 2, 1416870000),
(9, 'franckv', 10, 'henrique', 1098, 1089, 1429, 1434, 2, 1416870000),
(17, 'stephaner', 10, 'henrique', 1101, 1093, 1434, 1439, 2, 1416956400),
(5, 'dominique', 8, 'franckdc', 1143, 1162, 1055, 1033, 1, 1417042800),
(10, 'henrique', 5, 'dominique', 1439, 1406, 1162, 1204, 2, 1417388400),
(9, 'franckv', 15, 'remy', 1089, 1111, 903, 887, 1, 1417388400),
(9, 'franckv', 5, 'dominique', 1111, 1081, 1204, 1222, 2, 1417474800),
(2, 'amokrane', 15, 'remy', 861, 896, 887, 853, 1, 1417474800),
(8, 'franckdc', 10, 'henrique', 1033, 1027, 1406, 1410, 2, 1417474800),
(5, 'dominique', 12, 'laurent', 1222, 1247, 1238, 1212, 1, 1417561200),
(5, 'dominique', 9, 'franckv', 1247, 1260, 1081, 1060, 1, 1417647600),
(5, 'dominique', 10, 'henrique', 1260, 1293, 1410, 1381, 1, 1417734000),
(12, 'laurent', 9, 'franckv', 1212, 1226, 1060, 1040, 1, 1417734000),
(5, 'dominique', 7, 'fabien', 1293, 1312, 1247, 1226, 1, 1417993200),
(5, 'dominique', 9, 'franckv', 1312, 1319, 1040, 1029, 1, 1418079600),
(10, 'henrique', 7, 'fabien', 1381, 1393, 1226, 1211, 1, 1418079600),
(5, 'dominique', 10, 'henrique', 1319, 1301, 1393, 1409, 2, 1418166000),
(9, 'franckv', 12, 'laurent', 1029, 1072, 1226, 1189, 1, 1418166000),
(9, 'franckv', 10, 'henrique', 1072, 1120, 1409, 1373, 1, 1418252400),
(9, 'franckv', 15, 'remy', 1120, 1129, 853, 841, 1, 1418684400),
(5, 'dominique', 10, 'henrique', 1301, 1282, 1373, 1389, 2, 1418684400),
(9, 'franckv', 2, 'amokrane', 1129, 1139, 896, 883, 1, 1418770800),
(17, 'stephaner', 12, 'laurent', 1093, 1072, 1189, 1207, 2, 1418770800),
(12, 'laurent', 9, 'franckv', 1207, 1177, 1139, 1170, 2, 1418857200),
(15, 'remy', 17, 'stephaner', 841, 892, 1072, 1028, 1, 1418857200),
(5, 'dominique', 10, 'henrique', 1282, 1265, 1389, 1403, 2, 1418943600),
(17, 'stephaner', 10, 'henrique', 1028, 1022, 1403, 1407, 2, 1420498800),
(5, 'dominique', 7, 'fabien', 1265, 1237, 1211, 1239, 2, 1420498800),
(10, 'henrique', 9, 'franckv', 1407, 1415, 1170, 1159, 1, 1420585200),
(8, 'franckdc', 17, 'stephaner', 1027, 998, 1022, 1051, 2, 1420585200),
(7, 'fabien', 9, 'franckv', 1239, 1257, 1159, 1139, 1, 1420585200),
(15, 'remy', 2, 'amokrane', 892, 922, 883, 852, 1, 1420671600),
(12, 'laurent', 9, 'franckv', 1177, 1148, 1139, 1168, 2, 1420671600),
(7, 'fabien', 17, 'stephaner', 1257, 1268, 1051, 1037, 1, 1420671600),
(7, 'fabien', 12, 'laurent', 1268, 1236, 1148, 1182, 2, 1421103600),
(9, 'franckv', 10, 'henrique', 1168, 1158, 1415, 1422, 2, 1421103600),
(9, 'franckv', 5, 'dominique', 1158, 1137, 1237, 1255, 2, 1421103600),
(9, 'franckv', 5, 'dominique', 1137, 1119, 1255, 1270, 2, 1421190000),
(9, 'franckv', 5, 'dominique', 1119, 1156, 1270, 1237, 1, 1421190000),
(7, 'fabien', 15, 'remy', 1236, 1194, 922, 974, 2, 1421190000),
(9, 'franckv', 12, 'laurent', 1156, 1183, 1182, 1154, 1, 1421276400),
(2, 'amokrane', 17, 'stephaner', 852, 835, 1037, 1051, 2, 1421276400),
(7, 'fabien', 10, 'henrique', 1194, 1183, 1422, 1430, 2, 1421276400),
(3, 'bertrand', 5, 'dominique', 950, 893, 1237, 1244, 2, 1421622000),
(9, 'franckv', 17, 'stephaner', 1183, 1199, 1051, 1033, 1, 1421622000),
(10, 'henrique', 9, 'franckv', 1430, 1418, 1199, 1213, 3, 1421708400),
(5, 'dominique', 17, 'stephaner', 1244, 1207, 1033, 1076, 2, 1421708400),
(9, 'franckv', 8, 'franckdc', 1213, 1174, 998, 1043, 2, 1421794800),
(10, 'henrique', 17, 'stephaner', 1418, 1382, 1076, 1124, 2, 1421794800),
(15, 'remy', 9, 'franckv', 974, 1019, 1174, 1135, 1, 1421881200),
(2, 'amokrane', 8, 'franckdc', 835, 885, 1043, 999, 1, 1421881200),
(10, 'henrique', 5, 'dominique', 1382, 1372, 1207, 1218, 3, 1421881200),
(2, 'amokrane', 15, 'remy', 885, 928, 1019, 979, 1, 1421967600),
(13, 'olivier', 8, 'franckdc', 1167, 1213, 999, 982, 1, 1421967600),
(10, 'henrique', 9, 'franckv', 1372, 1380, 1135, 1124, 1, 1422226800),
(7, 'fabien', 15, 'remy', 1183, 1144, 979, 1024, 2, 1422399600),
(5, 'dominique', 8, 'franckdc', 1218, 1228, 982, 969, 1, 1422399600),
(13, 'olivier', 11, 'joel', 1213, 1235, 950, 881, 1, 1422399600),
(2, 'amokrane', 7, 'fabien', 928, 914, 1144, 1155, 2, 1422486000),
(6, 'emile', 12, 'laurent', 850, 802, 1154, 1161, 2, 1422486000),
(9, 'franckv', 17, 'stephaner', 1124, 1150, 1124, 1097, 1, 1422486000),
(18, 'thierry', 4, 'damien', 800, 595, 790, 892, 2, 1422572400),
(7, 'fabien', 9, 'franckv', 1155, 1180, 1150, 1124, 1, 1422572400),
(2, 'amokrane', 7, 'fabien', 914, 903, 1180, 1188, 2, 1422831600),
(12, 'laurent', 8, 'franckdc', 1161, 1173, 969, 954, 1, 1422831600),
(5, 'dominique', 10, 'henrique', 1228, 1213, 1380, 1392, 2, 1422918000),
(9, 'franckv', 10, 'henrique', 1124, 1114, 1392, 1399, 2, 1422918000),
(7, 'fabien', 17, 'stephaner', 1188, 1206, 1097, 1076, 1, 1422918000),
(7, 'fabien', 10, 'henrique', 1206, 1193, 1399, 1409, 2, 1423004400),
(17, 'stephaner', 8, 'franckdc', 1076, 1039, 954, 994, 2, 1423004400),
(12, 'laurent', 9, 'franckv', 1173, 1168, 1114, 1118, 3, 1423004400),
(13, 'olivier', 10, 'henrique', 1235, 1202, 1409, 1419, 2, 1423090800),
(8, 'franckdc', 2, 'amokrane', 994, 1015, 903, 879, 1, 1423090800),
(17, 'stephaner', 9, 'franckv', 1039, 1073, 1118, 1085, 1, 1423090800),
(3, 'bertrand', 16, 'stephaneb', 893, 1150, 1007, 878, 1, 1423090800),
(7, 'fabien', 2, 'amokrane', 1193, 1200, 879, 870, 1, 1423177200),
(12, 'laurent', 17, 'stephaner', 1168, 1135, 1073, 1107, 2, 1423177200),
(15, 'remy', 12, 'laurent', 1024, 1004, 1135, 1153, 2, 1423522800),
(9, 'franckv', 5, 'dominique', 1085, 1121, 1213, 1179, 1, 1423522800),
(17, 'stephaner', 10, 'henrique', 1107, 1099, 1419, 1424, 2, 1423522800),
(10, 'henrique', 12, 'laurent', 1424, 1430, 1153, 1144, 1, 1423609200),
(2, 'amokrane', 6, 'emile', 870, 895, 802, 636, 1, 1423609200),
(9, 'franckv', 10, 'henrique', 1121, 1113, 1430, 1435, 2, 1423782000),
(5, 'dominique', 17, 'stephaner', 1179, 1173, 1099, 1105, 3, 1423782000),
(8, 'franckdc', 2, 'amokrane', 1015, 1034, 895, 874, 1, 1423782000),
(10, 'henrique', 7, 'fabien', 1435, 1403, 1200, 1239, 2, 1424041200),
(17, 'stephaner', 5, 'dominique', 1105, 1137, 1173, 1142, 1, 1424041200),
(5, 'dominique', 7, 'fabien', 1142, 1149, 1239, 1232, 3, 1424127600),
(17, 'stephaner', 9, 'franckv', 1137, 1161, 1113, 1088, 1, 1424127600),
(10, 'henrique', 12, 'laurent', 1403, 1410, 1144, 1134, 1, 1424300400),
(9, 'franckv', 5, 'dominique', 1088, 1065, 1149, 1170, 2, 1424300400),
(7, 'fabien', 10, 'henrique', 1232, 1267, 1410, 1379, 1, 1424646000),
(9, 'franckv', 2, 'amokrane', 1065, 1078, 874, 858, 1, 1424646000),
(5, 'dominique', 10, 'henrique', 1170, 1158, 1379, 1388, 2, 1424732400),
(12, 'laurent', 11, 'joel', 1134, 1143, 881, 807, 1, 1424732400),
(17, 'stephaner', 9, 'franckv', 1161, 1180, 1078, 1056, 1, 1424732400),
(8, 'franckdc', 5, 'dominique', 1034, 1072, 1158, 1123, 1, 1424818800),
(2, 'amokrane', 12, 'laurent', 858, 847, 1143, 1151, 2, 1424818800),
(7, 'fabien', 9, 'franckv', 1267, 1277, 1056, 1043, 1, 1424905200),
(2, 'amokrane', 10, 'henrique', 847, 844, 1388, 1389, 2, 1424905200),
(14, 'patrick', 3, 'bertrand', 928, 1016, 1150, 942, 1, 1424905200),
(6, 'emile', 14, 'patrick', 636, 629, 1016, 1018, 2, 1424905200),
(17, 'stephaner', 5, 'dominique', 1180, 1150, 1123, 1153, 2, 1424905200),
(17, 'stephaner', 7, 'fabien', 1150, 1133, 1277, 1292, 2, 1424991600),
(12, 'laurent', 2, 'amokrane', 1151, 1158, 844, 834, 1, 1424991600),
(10, 'henrique', 9, 'franckv', 1389, 1394, 1043, 1036, 1, 1425250800),
(7, 'fabien', 17, 'stephaner', 1292, 1305, 1133, 1117, 1, 1425250800),
(14, 'patrick', 12, 'laurent', 1018, 990, 1158, 1173, 2, 1425337200),
(10, 'henrique', 17, 'stephaner', 1394, 1401, 1117, 1108, 1, 1425337200),
(5, 'dominique', 7, 'fabien', 1153, 1189, 1305, 1273, 1, 1425337200),
(6, 'emile', 3, 'bertrand', 629, 807, 942, 763, 1, 1425337200),
(10, 'henrique', 9, 'franckv', 1401, 1405, 1036, 1029, 1, 1425423600),
(3, 'bertrand', 12, 'laurent', 763, 763, 1173, 1177, 2, 1425423600),
(17, 'stephaner', 13, 'olivier', 1108, 1141, 1202, 1140, 1, 1425510000),
(1, 'alexandre', 6, 'emile', 750, 978, 807, 715, 1, 1425510000),
(12, 'laurent', 7, 'fabien', 1177, 1209, 1273, 1243, 1, 1425596400),
(17, 'stephaner', 9, 'franckv', 1141, 1106, 1029, 1066, 2, 1425596400),
(17, 'stephaner', 9, 'franckv', 1106, 1129, 1066, 1041, 1, 1426028400),
(9, 'franckv', 8, 'franckdc', 1041, 1015, 1072, 1097, 2, 1426114800),
(12, 'laurent', 17, 'stephaner', 1209, 1228, 1129, 1108, 1, 1426201200),
(8, 'franckdc', 9, 'franckv', 1097, 1117, 1015, 992, 1, 1426201200),
(7, 'fabien', 2, 'amokrane', 1243, 1247, 834, 828, 1, 1426201200),
(14, 'patrick', 12, 'laurent', 990, 1053, 1228, 1189, 1, 1426460400),
(9, 'franckv', 10, 'henrique', 992, 987, 1405, 1408, 2, 1426460400),
(13, 'olivier', 7, 'fabien', 1140, 1108, 1247, 1263, 2, 1426546800),
(9, 'franckv', 12, 'laurent', 987, 1031, 1189, 1150, 1, 1426546800),
(9, 'franckv', 14, 'patrick', 1031, 1061, 1053, 1014, 1, 1426546800),
(10, 'henrique', 17, 'stephaner', 1408, 1414, 1108, 1099, 1, 1426633200),
(9, 'franckv', 2, 'amokrane', 1061, 1016, 828, 879, 2, 1426633200),
(14, 'patrick', 16, 'stephaneb', 1014, 968, 878, 985, 2, 1426633200),
(15, 'remy', 12, 'laurent', 1004, 986, 1150, 1165, 2, 1426719600),
(10, 'henrique', 7, 'fabien', 1414, 1426, 1263, 1249, 1, 1426719600),
(9, 'franckv', 17, 'stephaner', 1016, 993, 1099, 1119, 2, 1426806000),
(12, 'laurent', 2, 'amokrane', 1165, 1173, 879, 868, 1, 1426806000),
(10, 'henrique', 5, 'dominique', 1426, 1393, 1189, 1229, 2, 1426892400),
(14, 'patrick', 12, 'laurent', 968, 953, 1173, 1184, 2, 1426892400),
(1, 'alexandre', 6, 'emile', 978, 1046, 715, 692, 1, 1426892400),
(9, 'franckv', 17, 'stephaner', 993, 1032, 1119, 1083, 1, 1426892400),
(5, 'dominique', 10, 'henrique', 1229, 1215, 1393, 1404, 2, 1427238000),
(7, 'fabien', 9, 'franckv', 1249, 1259, 1032, 1019, 1, 1427238000),
(6, 'emile', 16, 'stephaneb', 692, 676, 985, 1002, 2, 1427238000),
(14, 'patrick', 2, 'amokrane', 953, 975, 868, 843, 1, 1427238000),
(1, 'alexandre', 17, 'stephaner', 1046, 925, 1083, 1107, 2, 1427238000),
(1, 'alexandre', 14, 'patrick', 925, 837, 975, 1000, 2, 1427324400),
(12, 'laurent', 8, 'franckdc', 1184, 1204, 1117, 1095, 1, 1427324400),
(12, 'laurent', 14, 'patrick', 1204, 1215, 1000, 986, 1, 1427324400),
(9, 'franckv', 15, 'remy', 1019, 1044, 986, 959, 1, 1427324400),
(9, 'franckv', 7, 'fabien', 1044, 1087, 1259, 1222, 1, 1427410800),
(9, 'franckv', 18, 'thierry', 1087, 1090, 595, 595, 1, 1427410800),
(6, 'emile', 8, 'franckdc', 676, 676, 1095, 1099, 2, 1427410800),
(17, 'stephaner', 1, 'alexandre', 1107, 1116, 837, 811, 1, 1427410800),
(12, 'laurent', 18, 'thierry', 1215, 1216, 595, 595, 1, 1427410800),
(7, 'fabien', 10, 'henrique', 1222, 1209, 1404, 1414, 2, 1427666400),
(17, 'stephaner', 7, 'fabien', 1116, 1096, 1209, 1227, 2, 1427752800),
(15, 'remy', 8, 'franckdc', 959, 1000, 1099, 1061, 1, 1427752800),
(16, 'stephaneb', 12, 'laurent', 1002, 975, 1216, 1227, 2, 1427752800),
(9, 'franckv', 10, 'henrique', 1090, 1082, 1414, 1419, 2, 1427752800),
(5, 'dominique', 9, 'franckv', 1215, 1230, 1082, 1064, 1, 1427839200),
(7, 'fabien', 2, 'amokrane', 1227, 1231, 843, 836, 1, 1427839200),
(9, 'franckv', 1, 'alexandre', 1064, 1074, 811, 786, 1, 1427925600),
(7, 'fabien', 8, 'franckdc', 1231, 1195, 1061, 1101, 2, 1427925600),
(3, 'bertrand', 6, 'emile', 763, 815, 676, 642, 1, 1427925600),
(5, 'dominique', 12, 'laurent', 1230, 1254, 1227, 1202, 1, 1427925600),
(12, 'laurent', 9, 'franckv', 1202, 1218, 1074, 1056, 1, 1428012000),
(17, 'stephaner', 15, 'remy', 1096, 1115, 1000, 978, 1, 1428012000),
(9, 'franckv', 8, 'franckdc', 1056, 1087, 1101, 1070, 1, 1428357600),
(9, 'franckv', 17, 'stephaner', 1087, 1116, 1115, 1086, 1, 1428357600),
(1, 'alexandre', 8, 'franckdc', 786, 883, 1070, 1023, 1, 1428357600),
(9, 'franckv', 5, 'dominique', 1116, 1099, 1254, 1268, 2, 1428444000),
(4, 'damien', 6, 'emile', 892, 922, 642, 626, 1, 1428530400),
(10, 'henrique', 7, 'fabien', 1419, 1427, 1195, 1184, 1, 1428530400),
(2, 'amokrane', 1, 'alexandre', 836, 872, 883, 827, 1, 1428530400),
(5, 'dominique', 9, 'franckv', 1268, 1280, 1099, 1084, 1, 1428530400),
(7, 'fabien', 9, 'franckv', 1184, 1202, 1084, 1064, 1, 1428616800),
(17, 'stephaner', 11, 'joel', 1086, 1095, 807, 766, 1, 1428616800),
(2, 'amokrane', 8, 'franckdc', 872, 853, 1023, 1039, 2, 1428616800),
(7, 'fabien', 5, 'dominique', 1202, 1232, 1280, 1251, 1, 1428876000),
(11, 'joel', 8, 'franckdc', 766, 734, 1039, 1048, 2, 1428876000),
(12, 'laurent', 15, 'remy', 1218, 1178, 978, 1025, 2, 1428876000),
(12, 'laurent', 5, 'dominique', 1178, 1208, 1251, 1222, 1, 1428962400),
(9, 'franckv', 17, 'stephaner', 1064, 1094, 1095, 1065, 1, 1428962400),
(7, 'fabien', 2, 'amokrane', 1232, 1236, 853, 846, 1, 1428962400),
(9, 'franckv', 10, 'henrique', 1094, 1141, 1427, 1392, 1, 1429048800),
(5, 'dominique', 7, 'fabien', 1222, 1247, 1236, 1210, 1, 1429048800),
(2, 'amokrane', 6, 'emile', 846, 860, 626, 609, 1, 1429048800),
(7, 'fabien', 10, 'henrique', 1210, 1197, 1392, 1402, 2, 1429135200),
(12, 'laurent', 9, 'franckv', 1208, 1228, 1141, 1119, 1, 1429135200),
(11, 'joel', 2, 'amokrane', 734, 679, 860, 880, 2, 1429221600),
(9, 'franckv', 17, 'stephaner', 1119, 1141, 1065, 1041, 1, 1429221600),
(9, 'franckv', 12, 'laurent', 1141, 1173, 1228, 1197, 1, 1429480800),
(7, 'fabien', 8, 'franckdc', 1197, 1211, 1048, 1031, 1, 1429480800),
(10, 'henrique', 5, 'dominique', 1402, 1372, 1247, 1280, 2, 1429480800),
(5, 'dominique', 10, 'henrique', 1280, 1309, 1372, 1345, 1, 1429567200),
(17, 'stephaner', 9, 'franckv', 1041, 1022, 1173, 1189, 2, 1429567200),
(2, 'amokrane', 7, 'fabien', 880, 871, 1211, 1217, 2, 1429567200),
(17, 'stephaner', 12, 'laurent', 1022, 1035, 1197, 1185, 3, 1429653600),
(7, 'fabien', 9, 'franckv', 1217, 1239, 1189, 1165, 1, 1429653600),
(6, 'emile', 2, 'amokrane', 609, 595, 871, 882, 2, 1429653600),
(10, 'henrique', 9, 'franckv', 1345, 1356, 1165, 1151, 1, 1429740000),
(7, 'fabien', 5, 'dominique', 1239, 1219, 1309, 1327, 2, 1429740000),
(12, 'laurent', 2, 'amokrane', 1185, 1192, 882, 872, 1, 1429740000),
(9, 'franckv', 7, 'fabien', 1151, 1181, 1219, 1189, 1, 1429826400),
(10, 'henrique', 7, 'fabien', 1356, 1367, 1189, 1175, 1, 1430085600),
(6, 'emile', 15, 'remy', 595, 589, 1025, 1029, 2, 1430085600),
(10, 'henrique', 15, 'remy', 1367, 1372, 1029, 1021, 1, 1430172000),
(17, 'stephaner', 2, 'amokrane', 1035, 994, 872, 917, 2, 1430172000),
(12, 'laurent', 10, 'henrique', 1192, 1178, 1372, 1383, 2, 1430172000),
(8, 'franckdc', 9, 'franckv', 1031, 1071, 1181, 1145, 1, 1430172000),
(9, 'franckv', 5, 'dominique', 1145, 1131, 1327, 1338, 2, 1430258400),
(5, 'dominique', 7, 'fabien', 1338, 1350, 1175, 1160, 1, 1430258400),
(7, 'fabien', 12, 'laurent', 1160, 1187, 1178, 1151, 1, 1430344800),
(2, 'amokrane', 17, 'stephaner', 917, 892, 994, 1016, 2, 1430344800),
(2, 'amokrane', 6, 'emile', 892, 869, 589, 615, 3, 1430431200),
(2, 'amokrane', 17, 'stephaner', 869, 849, 1016, 1033, 2, 1430690400),
(7, 'fabien', 12, 'laurent', 1187, 1209, 1151, 1127, 1, 1430690400),
(10, 'henrique', 7, 'fabien', 1383, 1394, 1209, 1195, 1, 1430776800),
(17, 'stephaner', 5, 'dominique', 1033, 1025, 1350, 1356, 2, 1430776800),
(8, 'franckdc', 12, 'laurent', 1071, 1103, 1127, 1096, 1, 1430863200),
(15, 'remy', 10, 'henrique', 1021, 1015, 1394, 1398, 2, 1430863200),
(7, 'fabien', 5, 'dominique', 1195, 1180, 1356, 1368, 2, 1430863200),
(7, 'fabien', 5, 'dominique', 1180, 1167, 1368, 1378, 2, 1431295200),
(5, 'dominique', 10, 'henrique', 1378, 1358, 1398, 1417, 2, 1431381600),
(15, 'remy', 7, 'fabien', 1015, 1055, 1167, 1130, 1, 1431381600),
(17, 'stephaner', 9, 'franckv', 1025, 1004, 1131, 1149, 2, 1431468000),
(12, 'laurent', 5, 'dominique', 1096, 1086, 1358, 1365, 2, 1431986400),
(9, 'franckv', 10, 'henrique', 1149, 1139, 1417, 1424, 2, 1431986400),
(5, 'dominique', 10, 'henrique', 1365, 1347, 1424, 1440, 2, 1432072800),
(9, 'franckv', 14, 'patrick', 1139, 1154, 986, 968, 1, 1432072800),
(2, 'amokrane', 9, 'franckv', 849, 839, 1154, 1161, 2, 1432072800),
(8, 'franckdc', 17, 'stephaner', 1103, 1122, 1004, 983, 1, 1432072800),
(17, 'stephaner', 12, 'laurent', 983, 1020, 1086, 1050, 1, 1432159200),
(12, 'laurent', 14, 'patrick', 1050, 1071, 968, 945, 1, 1432159200),
(7, 'fabien', 8, 'franckdc', 1130, 1155, 1122, 1096, 1, 1432159200),
(17, 'stephaner', 2, 'amokrane', 1020, 977, 839, 887, 2, 1432245600),
(11, 'joel', 7, 'fabien', 679, 679, 1155, 1158, 2, 1432245600),
(12, 'laurent', 8, 'franckdc', 1071, 1100, 1096, 1066, 1, 1432245600),
(10, 'henrique', 5, 'dominique', 1440, 1454, 1347, 1330, 1, 1432245600),
(15, 'remy', 9, 'franckv', 1055, 1035, 1161, 1179, 2, 1432591200),
(9, 'franckv', 7, 'fabien', 1179, 1202, 1158, 1133, 1, 1432677600),
(17, 'stephaner', 8, 'franckdc', 977, 954, 1066, 1086, 2, 1432677600),
(9, 'franckv', 2, 'amokrane', 1202, 1208, 887, 878, 1, 1432764000),
(8, 'franckdc', 15, 'remy', 1086, 1109, 1035, 1010, 1, 1432764000),
(4, 'damien', 8, 'franckdc', 922, 1019, 1109, 1069, 1, 1432850400),
(4, 'damien', 8, 'franckdc', 1019, 969, 1069, 1092, 2, 1432850400),
(2, 'amokrane', 15, 'remy', 878, 857, 1010, 1028, 2, 1432850400),
(17, 'stephaner', 7, 'fabien', 954, 998, 1133, 1094, 1, 1432850400),
(9, 'franckv', 10, 'henrique', 1208, 1247, 1454, 1422, 1, 1433109600),
(8, 'franckdc', 2, 'amokrane', 1092, 1103, 857, 843, 1, 1433109600),
(17, 'stephaner', 12, 'laurent', 998, 977, 1100, 1119, 2, 1433109600),
(12, 'laurent', 9, 'franckv', 1119, 1154, 1247, 1214, 1, 1433196000),
(10, 'henrique', 11, 'joel', 1422, 1422, 679, 679, 1, 1433196000),
(2, 'amokrane', 7, 'fabien', 843, 895, 1094, 1050, 1, 1433196000),
(9, 'franckv', 10, 'henrique', 1214, 1202, 1422, 1431, 2, 1433282400),
(7, 'fabien', 17, 'stephaner', 1050, 1072, 977, 953, 1, 1433282400),
(9, 'franckv', 15, 'remy', 1202, 1165, 1028, 1069, 2, 1433368800),
(17, 'stephaner', 8, 'franckdc', 953, 995, 1103, 1065, 1, 1433368800),
(9, 'franckv', 10, 'henrique', 1165, 1155, 1431, 1438, 2, 1433455200),
(2, 'amokrane', 7, 'fabien', 895, 878, 1072, 1086, 2, 1433455200),
(8, 'franckdc', 6, 'emile', 1065, 1013, 615, 684, 2, 1433455200),
(8, 'franckdc', 10, 'henrique', 1013, 1066, 1438, 1401, 1, 1433714400),
(1, 'alexandre', 17, 'stephaner', 827, 802, 995, 1011, 2, 1433714400),
(6, 'emile', 17, 'stephaner', 684, 674, 1011, 1018, 2, 1433714400),
(2, 'amokrane', 4, 'damien', 878, 917, 969, 907, 1, 1433714400),
(9, 'franckv', 5, 'dominique', 1155, 1141, 1330, 1341, 2, 1433714400),
(12, 'laurent', 17, 'stephaner', 1154, 1170, 1018, 999, 1, 1433800800),
(15, 'remy', 7, 'fabien', 1069, 1042, 1086, 1111, 2, 1433800800),
(2, 'amokrane', 4, 'damien', 917, 946, 907, 863, 1, 1433800800),
(14, 'patrick', 9, 'franckv', 945, 930, 1141, 1153, 2, 1433800800),
(2, 'amokrane', 6, 'emile', 946, 956, 674, 661, 1, 1433887200),
(17, 'stephaner', 9, 'franckv', 999, 1040, 1153, 1116, 1, 1433887200),
(10, 'henrique', 5, 'dominique', 1401, 1376, 1341, 1366, 2, 1433887200),
(18, 'thierry', 6, 'emile', 595, 608, 661, 654, 3, 1433973600),
(10, 'henrique', 7, 'fabien', 1376, 1383, 1111, 1101, 1, 1433973600),
(9, 'franckv', 12, 'laurent', 1116, 1146, 1170, 1140, 1, 1433973600),
(17, 'stephaner', 7, 'fabien', 1040, 1016, 1101, 1123, 2, 1434060000),
(16, 'stephaneb', 14, 'patrick', 975, 919, 930, 964, 2, 1434060000),
(6, 'emile', 8, 'franckdc', 654, 647, 1066, 1070, 2, 1434060000),
(12, 'laurent', 2, 'amokrane', 1140, 1153, 956, 940, 1, 1434319200),
(5, 'dominique', 7, 'fabien', 1366, 1374, 1123, 1112, 1, 1434319200),
(4, 'damien', 2, 'amokrane', 863, 831, 940, 963, 2, 1434405600),
(12, 'laurent', 11, 'joel', 1153, 1156, 679, 679, 1, 1434492000),
(7, 'fabien', 17, 'stephaner', 1112, 1078, 1016, 1052, 2, 1434492000),
(11, 'joel', 2, 'amokrane', 679, 664, 963, 972, 2, 1434492000),
(5, 'dominique', 10, 'henrique', 1374, 1395, 1383, 1361, 1, 1434492000),
(8, 'franckdc', 12, 'laurent', 1070, 1104, 1156, 1123, 1, 1434578400),
(8, 'franckdc', 12, 'laurent', 1104, 1078, 1123, 1148, 2, 1434664800),
(2, 'amokrane', 17, 'stephaner', 972, 949, 1052, 1073, 2, 1434664800),
(7, 'fabien', 15, 'remy', 1078, 1075, 1042, 1044, 3, 1434664800),
(12, 'laurent', 9, 'franckv', 1148, 1173, 1146, 1120, 1, 1434924000),
(4, 'damien', 16, 'stephaneb', 831, 876, 919, 863, 1, 1434924000),
(8, 'franckdc', 14, 'patrick', 1078, 1096, 964, 943, 1, 1434924000),
(14, 'patrick', 8, 'franckdc', 943, 985, 1096, 1057, 1, 1434924000),
(2, 'amokrane', 7, 'fabien', 949, 929, 1075, 1092, 2, 1434924000),
(12, 'laurent', 4, 'damien', 1173, 1180, 876, 865, 1, 1435010400),
(14, 'patrick', 15, 'remy', 985, 960, 1044, 1067, 2, 1435010400),
(5, 'dominique', 10, 'henrique', 1395, 1372, 1361, 1384, 2, 1435010400),
(13, 'olivier', 17, 'stephaner', 1108, 1143, 1073, 1048, 1, 1435010400),
(5, 'dominique', 10, 'henrique', 1372, 1351, 1384, 1404, 2, 1435096800),
(10, 'henrique', 5, 'dominique', 1404, 1400, 1351, 1354, 3, 1435096800),
(17, 'stephaner', 2, 'amokrane', 1048, 1066, 929, 908, 1, 1435096800),
(9, 'franckv', 16, 'stephaneb', 1120, 1076, 863, 928, 2, 1435096800),
(7, 'fabien', 9, 'franckv', 1092, 1117, 1076, 1049, 1, 1435183200),
(6, 'emile', 15, 'remy', 647, 713, 1067, 1016, 1, 1435269600),
(2, 'amokrane', 17, 'stephaner', 908, 890, 1066, 1081, 2, 1435269600),
(5, 'dominique', 9, 'franckv', 1354, 1360, 1049, 1040, 1, 1435269600),
(9, 'franckv', 5, 'dominique', 1040, 1032, 1360, 1365, 2, 1435269600),
(9, 'franckv', 17, 'stephaner', 1032, 1064, 1081, 1049, 1, 1435528800),
(14, 'patrick', 16, 'stephaneb', 960, 927, 928, 967, 2, 1435528800),
(9, 'franckv', 14, 'patrick', 1064, 1081, 927, 907, 1, 1435615200),
(8, 'franckdc', 17, 'stephaner', 1057, 1084, 1049, 1021, 1, 1435615200),
(14, 'patrick', 9, 'franckv', 907, 890, 1081, 1095, 2, 1435701600),
(17, 'stephaner', 7, 'fabien', 1021, 1000, 1117, 1136, 2, 1435701600),
(16, 'stephaneb', 12, 'laurent', 967, 951, 1180, 1191, 2, 1435701600),
(10, 'henrique', 8, 'franckdc', 1400, 1405, 1084, 1076, 1, 1435788000),
(12, 'laurent', 9, 'franckv', 1191, 1209, 1095, 1075, 1, 1435788000),
(14, 'patrick', 17, 'stephaner', 890, 931, 1000, 961, 1, 1435788000),
(5, 'dominique', 7, 'fabien', 1365, 1374, 1136, 1124, 1, 1435788000),
(7, 'fabien', 17, 'stephaner', 1124, 1138, 961, 944, 1, 1435874400),
(9, 'franckv', 8, 'franckdc', 1075, 1102, 1076, 1048, 1, 1435874400),
(14, 'patrick', 9, 'franckv', 931, 914, 1102, 1116, 2, 1436133600),
(8, 'franckdc', 7, 'fabien', 1048, 1027, 1138, 1157, 2, 1436133600),
(12, 'laurent', 17, 'stephaner', 1209, 1217, 944, 933, 1, 1436133600),
(9, 'franckv', 5, 'dominique', 1116, 1106, 1374, 1381, 2, 1436220000),
(12, 'laurent', 7, 'fabien', 1217, 1237, 1157, 1135, 1, 1436306400),
(9, 'franckv', 14, 'patrick', 1106, 1065, 914, 960, 2, 1436306400),
(7, 'fabien', 9, 'franckv', 1135, 1156, 1065, 1042, 1, 1436392800),
(16, 'stephaneb', 8, 'franckdc', 951, 988, 1027, 992, 1, 1436392800),
(8, 'franckdc', 5, 'dominique', 992, 1044, 1381, 1342, 1, 1436479200),
(9, 'franckv', 7, 'fabien', 1042, 1022, 1156, 1173, 2, 1436479200),
(6, 'emile', 4, 'damien', 713, 692, 865, 883, 2, 1436479200),
(8, 'franckdc', 12, 'laurent', 1044, 1030, 1237, 1248, 2, 1436911200),
(8, 'franckdc', 17, 'stephaner', 1030, 1050, 933, 910, 1, 1436997600),
(7, 'fabien', 8, 'franckdc', 1173, 1189, 1050, 1031, 1, 1437084000),
(5, 'dominique', 10, 'henrique', 1342, 1367, 1405, 1380, 1, 1437084000),
(17, 'stephaner', 2, 'amokrane', 910, 939, 890, 860, 1, 1437343200),
(10, 'henrique', 7, 'fabien', 1380, 1390, 1189, 1176, 1, 1437429600),
(14, 'patrick', 2, 'amokrane', 960, 981, 860, 836, 1, 1437429600),
(8, 'franckdc', 5, 'dominique', 1031, 1023, 1367, 1372, 2, 1437429600),
(12, 'laurent', 5, 'dominique', 1248, 1232, 1372, 1385, 2, 1437516000),
(9, 'franckv', 2, 'amokrane', 1022, 979, 836, 884, 2, 1437516000),
(17, 'stephaner', 7, 'fabien', 939, 926, 1176, 1186, 2, 1437516000),
(17, 'stephaner', 9, 'franckv', 926, 930, 979, 974, 3, 1437602400),
(2, 'amokrane', 12, 'laurent', 884, 939, 1232, 1189, 1, 1437602400),
(9, 'franckv', 17, 'stephaner', 974, 970, 930, 933, 3, 1437688800),
(6, 'emile', 7, 'fabien', 692, 723, 1186, 1163, 3, 1437775200),
(10, 'henrique', 5, 'dominique', 1390, 1410, 1385, 1364, 1, 1437948000),
(2, 'amokrane', 9, 'franckv', 939, 972, 970, 937, 1, 1437948000),
(7, 'fabien', 15, 'remy', 1163, 1178, 1016, 998, 1, 1438034400),
(9, 'franckv', 2, 'amokrane', 937, 970, 972, 939, 1, 1438034400),
(10, 'henrique', 7, 'fabien', 1410, 1418, 1178, 1167, 1, 1438120800),
(5, 'dominique', 8, 'franckdc', 1364, 1369, 1023, 1015, 1, 1438120800),
(2, 'amokrane', 9, 'franckv', 939, 911, 970, 997, 2, 1438120800),
(7, 'fabien', 5, 'dominique', 1167, 1205, 1369, 1336, 1, 1438207200),
(10, 'henrique', 9, 'franckv', 1418, 1421, 997, 992, 1, 1438207200),
(2, 'amokrane', 8, 'franckdc', 911, 950, 1015, 977, 1, 1438207200),
(17, 'stephaner', 15, 'remy', 933, 969, 998, 963, 1, 1438207200),
(15, 'remy', 2, 'amokrane', 963, 991, 950, 920, 1, 1438293600),
(5, 'dominique', 10, 'henrique', 1336, 1319, 1421, 1436, 2, 1438293600),
(17, 'stephaner', 9, 'franckv', 969, 941, 992, 1019, 2, 1438293600),
(11, 'joel', 14, 'patrick', 664, 692, 981, 959, 3, 1438380000),
(2, 'amokrane', 15, 'remy', 920, 956, 991, 955, 1, 1438552800),
(9, 'franckv', 17, 'stephaner', 1019, 1041, 941, 917, 1, 1438552800),
(7, 'fabien', 8, 'franckdc', 1205, 1215, 977, 964, 1, 1438552800),
(2, 'amokrane', 15, 'remy', 956, 985, 955, 925, 1, 1438639200),
(9, 'franckv', 8, 'franckdc', 1041, 1063, 964, 940, 1, 1438639200),
(17, 'stephaner', 10, 'henrique', 917, 914, 1436, 1437, 2, 1438639200),
(16, 'stephaneb', 12, 'laurent', 988, 973, 1189, 1201, 2, 1438639200),
(17, 'stephaner', 12, 'laurent', 914, 904, 1201, 1208, 2, 1438725600),
(9, 'franckv', 15, 'remy', 1063, 1080, 925, 905, 1, 1438725600),
(2, 'amokrane', 7, 'fabien', 985, 972, 1215, 1225, 2, 1438725600),
(2, 'amokrane', 7, 'fabien', 972, 960, 1225, 1234, 2, 1438812000),
(15, 'remy', 9, 'franckv', 905, 888, 1080, 1094, 2, 1438812000),
(15, 'remy', 9, 'franckv', 888, 873, 1094, 1106, 2, 1438812000),
(9, 'franckv', 7, 'fabien', 1106, 1142, 1234, 1201, 1, 1438898400),
(9, 'franckv', 2, 'amokrane', 1142, 1155, 960, 944, 1, 1439157600);
/*!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 */;