File "chessmaster.sql"

Full Path: /home/analogde/www/Freebox/CHESS_ON/chessmaster.sql
File size: 7.59 KB
MIME-type: text/plain
Charset: utf-8

 
Open Edit   Advanced Editor   Back 
-- phpMyAdmin SQL Dump
-- version 4.1.14
-- http://www.phpmyadmin.net
--
-- Client :  127.0.0.1
-- Généré le :  Dim 08 Novembre 2015 à 17:34
-- Version du serveur :  5.6.17
-- Version de PHP :  5.5.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`
--

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

--
-- Structure de la table `chessmaster`
--

CREATE TABLE IF NOT EXISTS `chessmaster` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `blanc` varchar(30) NOT NULL,
  `noir` varchar(30) NOT NULL,
  `gagnant` varchar(30) NOT NULL,
  `date` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=124 ;

--
-- Contenu de la table `chessmaster`
--

INSERT INTO `chessmaster` (`id`, `blanc`, `noir`, `gagnant`, `date`) VALUES
(1, 'damien', 'remy', 'remy', 1409522400),
(2, 'laurent', 'remy', 'laurent', 1409781600),
(3, 'dominique', 'laurent', 'laurent', 1410300000),
(4, 'laurent', 'franckdc', 'laurent', 1410818400),
(5, 'dominique', 'laurent', 'laurent', 1410991200),
(6, 'amokrane', 'laurent', 'laurent', 1411596000),
(7, 'laurent', 'stephaner', 'stephaner', 1411941600),
(8, 'stephaner', 'alex', 'stephaner', 1412114400),
(9, 'franckdc', 'stephaner', 'franckdc', 1413324000),
(10, 'remy', 'franckdc', 'franckdc', 1413496800),
(11, 'fabien', 'franckdc', 'fabien', 1414364400),
(12, 'fabien', 'laurent', 'fabien', 1414623600),
(13, 'fabien', 'remy', 'fabien', 1415055600),
(14, 'fabien', 'henrique', 'henrique', 1415228400),
(15, 'henrique', 'fabien', 'henrique', 1416178800),
(16, 'henrique', 'dominique', 'dominique', 1416265200),
(17, 'stephaner', 'dominique', 'dominique', 1416351600),
(18, 'dominique', 'franckdc', 'franckdc', 1416438000),
(19, 'henrique', 'franckdc', 'henrique', 1416783600),
(20, 'dominique', 'henrique', 'henrique', 1416870000),
(21, 'franckv', 'henrique', 'henrique', 1416870000),
(22, 'stephaner', 'henrique', 'henrique', 1416956400),
(23, 'henrique', 'dominique', 'dominique', 1417388400),
(24, 'franckv', 'dominique', 'dominique', 1417474800),
(25, 'dominique', 'laurent', 'dominique', 1417561200),
(26, 'dominique', 'franckv', 'dominique', 1417647600),
(27, 'dominique', 'henrique', 'dominique', 1417734000),
(28, 'dominique', 'fabien', 'dominique', 1417993200),
(29, 'dominique', 'franckv', 'dominique', 1418079600),
(30, 'dominique', 'henrique', 'henrique', 1418166000),
(31, 'franckv', 'henrique', 'franckv', 1418252400),
(32, 'franckv', 'remy', 'franckv', 1418684400),
(33, 'franckv', 'amokrane', 'franckv', 1418770800),
(34, 'laurent', 'franckv', 'franckv', 1418857200),
(35, 'fabien', 'franckv', 'fabien', 1420585200),
(36, 'fabien', 'stephaner', 'fabien', 1420671600),
(37, 'fabien', 'laurent', 'laurent', 1421103600),
(38, 'franckv', 'laurent', 'franckv', 1421276400),
(39, 'franckv', 'stephaner', 'franckv', 1421622000),
(40, 'henrique', 'franckv', 'franckv', 1421708400),
(41, 'franckv', 'franckdc', 'franckdc', 1421794800),
(42, 'amokrane', 'franckdc', 'amokrane', 1421881200),
(43, 'amokrane', 'remy', 'amokrane', 1421967600),
(44, 'amokrane', 'fabien', 'fabien', 1422486000),
(45, 'fabien', 'franckv', 'fabien', 1422572400),
(46, 'amokrane', 'fabien', 'fabien', 1422831600),
(47, 'fabien', 'stephaner', 'fabien', 1422918000),
(48, 'fabien', 'henrique', 'henrique', 1423004400),
(49, 'olivier', 'henrique', 'henrique', 1423090800),
(50, 'stephaner', 'henrique', 'henrique', 1423522800),
(51, 'henrique', 'laurent', 'henrique', 1423609200),
(52, 'franckv', 'henrique', 'henrique', 1423782000),
(53, 'henrique', 'fabien', 'fabien', 1424041200),
(54, 'fabien', 'henrique', 'fabien', 1424646000),
(55, 'fabien', 'franckv', 'fabien', 1424905200),
(56, 'stephaner', 'fabien', 'fabien', 1424991600),
(57, 'fabien', 'stephaner', 'stephaner', 1425250800),
(58, 'henrique', 'stephaner', 'henrique', 1425337200),
(59, 'henrique', 'franckv', 'henrique', 1425423600),
(60, 'franckv', 'henrique', 'henrique', 1426460400),
(61, 'henrique', 'stephaner', 'henrique', 1426633200),
(62, 'henrique', 'fabien', 'henrique', 1426719600),
(63, 'henrique', 'dominique', 'dominique', 1427151600),
(64, 'dominique', 'henrique', 'henrique', 1427238000),
(65, 'fabien', 'henrique', 'henrique', 1427666400),
(66, 'franckdc', 'henrique', 'henrique', 1427752800),
(67, 'henrique', 'fabien', 'henrique', 1428530400),
(68, 'franckv', 'henrique', 'franckv', 1429048800),
(69, 'laurent', 'franckv', 'laurent', 1429135200),
(70, 'franckv', 'laurent', 'franckv', 1429480800),
(71, 'fabien', 'franckv', 'fabien', 1429653600),
(72, 'fabien', 'dominique', 'dominique', 1429740000),


(73, 'dominique', 'fabien', 'dominique', 1430258400),
(74, 'stephaner', 'dominique', 'dominique', 1430776800),
(75, 'fabien', 'dominique', 'dominique', 1430863200),
(76, 'fabien', 'dominique', 'dominique', 1431295200),
(77, 'dominique', 'henrique', 'henrique', 1431381600),
(78, 'franckv', 'henrique', 'henrique', 1431986400),
(79, 'dominique', 'henrique', 'henrique', 1432072800),
(80, 'henrique', 'dominique', 'henrique', 1432245600),
(81, 'franckv', 'henrique', 'franckv', 1433109600),
(82, 'franckv', 'laurent', 'laurent', 1433196000),
(83, 'laurent', 'stephaner', 'laurent', 1433800800),
(84, 'franckv', 'laurent', 'franckv', 1433973600),
(85, 'laurent', 'franckv', 'laurent', 1434924000),
(86, 'laurent', 'damien', 'laurent', 1435010400),
(87, 'stephaneb', 'laurent', 'laurent', 1435701600),
(88, 'laurent', 'franckv', 'laurent', 1435788000),
(89, 'laurent', 'stephaner', 'laurent', 1436133600),
(90, 'laurent', 'fabien', 'laurent', 1436306400),
(91, 'franckdc', 'laurent', 'laurent', 1436911200),
(92, 'laurent', 'dominique', 'dominique', 1437516000),
(93, 'henrique', 'dominique', 'henrique', 1437948000),
(94, 'henrique', 'fabien', 'henrique', 1438120800),
(95, 'henrique', 'franckv', 'henrique', 1438207200),
(96, 'dominique', 'henrique', 'henrique', 1438293600),
(97, 'stephaner', 'henrique', 'henrique', 1438639200),
(98, 'henrique', 'dominique', 'dominique', 1440712800),
(99, 'dominique', 'stephaner', 'stephaner', 1441144800),
(100, 'amokrane', 'stephaner', 'stephaner', 1441231200),
(101, 'fabien', 'stephaner', 'stephaner', 1441317600),
(102, 'amokrane', 'stephaner', 'stephaner', 1441576800),
(103, 'stephaner', 'franckv', 'stephaner', 1442181600),
(104, 'stephaner', 'olivier', 'stephaner', 1442268000),
(105, 'stephaner', 'franckdc', 'franckdc', 1442872800),
(106, 'franckdc', 'franckv', 'franckdc', 1443045600),
(107, 'franckdc', 'laurent', 'franckdc', 1443564000),
(108, 'franckdc', 'stephaner', 'stephaner', 1443736800),
(109, 'stephaner', 'franckv', 'franckv', 1444168800),
(110, 'remy', 'franckv', 'franckv', 1444341600),
(111, 'franckv', 'fabien', 'franckv', 1444600800),
(112, 'franckv', 'franckdc', 'franckv', 1444687200),
(113, 'henrique', 'franckv', 'henrique', 1444773600),
(114, 'fabien', 'henrique', 'henrique', 1444860000),
(115, 'henrique', 'amokrane', 'henrique', 1444946400),
(116, 'henrique', 'amokrane', 'henrique', 1445205600),
(117, 'amokrane', 'henrique', 'henrique', 1445464800),
(118, 'marek', 'henrique', 'henrique', 1445814000),
(119, 'dominique', 'henrique', 'henrique', 1445900400),
(120, 'franckv', 'henrique', 'henrique', 1445986800),
(121, 'henrique', 'stephaner', 'henrique', 1446073200),
(122, 'dominique', 'henrique', 'dominique', 1446505200),
(123, 'fabien', 'dominique', 'fabien', 1446678000);

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