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

--
-- 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`)
) TYPE=MyISAM AUTO_INCREMENT=20 ;

--
-- Contenu de la table `classement`
--

INSERT INTO `classement` (`id`, `joueur`, `elo`, `initial`, `parties`, `prior`, `bonus`, `oldrating`, `gcount`, `wins`, `losses`, `draws`, `active`) VALUES
(1, 'alexandre', 775, 750, 11, 11, 0, 797, 11, 3, 8, 0, 1),
(2, 'amokrane', 1141, 1050, 378, 50, 0, 1111, 378, 141, 229, 8, 1),
(3, 'bertrand', 916, 950, 8, 8, 0, 897, 8, 4, 4, 0, 1),
(4, 'damien', 879, 1000, 36, 36, 0, 883, 36, 12, 24, 0, 1),
(5, 'dominique', 1138, 1100, 287, 50, 0, 1121, 287, 154, 116, 17, 1),
(6, 'emile', 697, 850, 20, 20, 0, 716, 20, 3, 16, 1, 1),
(7, 'fabien', 1156, 1300, 384, 50, 0, 1135, 384, 202, 171, 11, 1),
(8, 'franckdc', 1012, 1000, 158, 50, 0, 986, 158, 70, 87, 1, 1),
(9, 'franckv', 1068, 1000, 528, 50, 0, 1112, 528, 241, 275, 12, 1),
(10, 'henrique', 1384, 1300, 425, 50, 0, 1398, 425, 328, 82, 15, 1),
(11, 'joel', 1033, 950, 42, 42, 0, 1013, 42, 17, 24, 1, 1),
(12, 'laurent', 1086, 1200, 101, 50, 0, 1115, 101, 60, 38, 3, 1),
(13, 'marek', 922, 1050, 8, 8, 0, 963, 8, 2, 6, 0, 1),
(14, 'olivier', 1120, 1250, 11, 11, 0, 1166, 11, 5, 6, 0, 1),
(15, 'patrick', 746, 1000, 62, 50, 0, 756, 62, 20, 41, 1, 1),
(16, 'remy', 965, 1100, 134, 50, 0, 971, 134, 37, 93, 4, 1),
(17, 'stephaneb', 941, 1000, 45, 45, 0, 967, 45, 21, 23, 1, 1),
(18, 'stephaner', 913, 1000, 340, 50, 0, 862, 340, 128, 200, 12, 1),
(19, 'thierry', 625, 1000, 6, 6, 0, 651, 6, 0, 5, 1, 1);
