-- phpMyAdmin SQL Dump
-- version OVH
-- http://www.phpmyadmin.net
--
-- Serveur: mysql5-5.perso
-- Généré le : Jeu 19 Mai 2011 à 00:52
-- Version du serveur: 5.0.90
-- Version de PHP: 5.3.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!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: `qualitesfsite`
--

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

--
-- Structure de la table `calculer_elo`
--

CREATE TABLE IF NOT EXISTS `calculer_elo` (
  `id_partie` bigint(20) NOT NULL,
  `dernier_time` int(20) NOT NULL,
  PRIMARY KEY  (`id_partie`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `calculer_elo`
--

INSERT INTO `calculer_elo` (`id_partie`, `dernier_time`) VALUES
(211, 1305759151);

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

--
-- Structure de la table `membres`
--

CREATE TABLE IF NOT EXISTS `membres` (
  `id_membre` bigint(20) NOT NULL auto_increment,
  `cumul_elo_adversaires` bigint(20) NOT NULL,
  `nb_adversaires` bigint(20) NOT NULL,
  `score` float NOT NULL,
  `categorie` text NOT NULL,
  `time_derniere_action` int(11) NOT NULL,
  `email` text NOT NULL,
  `pseudo` text NOT NULL,
  `password` text NOT NULL,
  `date` date NOT NULL,
  `elo` int(11) NOT NULL default '1000',
  `nom` text NOT NULL,
  `prenom` text NOT NULL,
  `annee` int(11) NOT NULL,
  `ip` text NOT NULL,
  PRIMARY KEY  (`id_membre`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COMMENT='Table des membres de popular_chess' AUTO_INCREMENT=44 ;

--
-- Contenu de la table `membres`
--

INSERT INTO `membres` (`id_membre`, `cumul_elo_adversaires`, `nb_adversaires`, `score`, `categorie`, `time_derniere_action`, `email`, `pseudo`, `password`, `date`, `elo`, `nom`, `prenom`, `annee`, `ip`) VALUES
(36, 26723, 27, 15, 'Senior', 1305715623, 'undavid@free.fr', 'qualitesite', 'repmovsd', '2011-05-15', 1040, 'nom', 'prenom', 2000, '88.175.35.133'),
(37, 41282, 40, 12, 'Senior', 1305752992, 'bonpsy@gmail.com', 'chrome', 'repmovsd', '2011-05-15', 884, 'paillot', 'david', 1981, '88.175.35.133'),
(38, 1000, 1, 1, 'Jeune', 1305705635, 'remipaillot@free.fr', 'zorrosangoku', '92631043', '2011-05-16', 1029, 'PAILLOT', 'remi', 1983, '187.22.22.219'),
(39, 1000, 1, 0, 'Senior', 1305705723, 'pridp@free.fr', 'pripennylane', '05018585', '2011-05-16', 972, 'dp', 'pri', 1985, '187.22.22.219'),
(40, 16979, 16, 9.5, 'Senior', 1305759151, 'souany@souany.com', 'souany', 'souany32', '2011-05-16', 1158, 'nom', 'prenom', 2000, '82.66.110.110'),
(41, 0, 0, 0, 'Senior', 1305570714, 'angemomone@gmail.com', 'yvonne', '12345678', '2011-05-16', 1000, 'paillot', 'yvonne', 1958, '88.175.35.133'),
(42, 31255, 30, 20.5, 'Senior', 1305759151, 'webmaster@populassite.com', 'populassite', 'repmovsd', '2011-05-16', 1175, 'nom', 'prenom', 2000, '88.175.35.133'),
(43, 1015, 1, 0, 'Senior', 1305670010, 'xxxx@ddd.fr', 'directeur1', 'robert314', '2011-05-17', 973, 'Paillot', 'daniel', 1955, '82.244.92.7');

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

--
-- Structure de la table `parties`
--

CREATE TABLE IF NOT EXISTS `parties` (
  `id_partie` bigint(20) NOT NULL auto_increment,
  `partie_en_cours` int(11) NOT NULL,
  `dernier_time` int(11) NOT NULL,
  `id_membre_blanc` bigint(20) NOT NULL,
  `id_membre_noir` bigint(20) NOT NULL,
  PRIMARY KEY  (`id_partie`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COMMENT='Table des parties de Popular Chess' AUTO_INCREMENT=212 ;

--
-- Contenu de la table `parties`
--

INSERT INTO `parties` (`id_partie`, `partie_en_cours`, `dernier_time`, `id_membre_blanc`, `id_membre_noir`) VALUES
(211, 0, 1305759151, 42, 40);

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

--
-- Structure de la table `recommencer`
--

CREATE TABLE IF NOT EXISTS `recommencer` (
  `id_partie` bigint(20) NOT NULL,
  `dernier_time` int(11) NOT NULL,
  PRIMARY KEY  (`id_partie`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `recommencer`
--

