CREATE TABLE BLITZ_parties_2022 (
  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;

/**************************************************************/

CREATE TABLE BLITZ_affectation_2022 (
  joueur varchar(30) DEFAULT NULL,
  elo int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `BLITZ_affectation`
--

INSERT INTO BLITZ_affectation_2022 (joueur, elo) VALUES
('AlvaroL', 1400),
('DamienB', 1400),
('EmileM', 1400),
('FranckD', 1400),
('FranckV', 1400),
('HenriqueF', 1400),
('OlivierC', 1400),
('PatrickA', 1400),
('PhilippeA', 1400),
('RemyS', 1400),
('StephaneR', 1400);

/************************************************/

CREATE TABLE BLITZ_classement_2022 (
  id int(11) NOT NULL,
  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'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `BLITZ_classement_2022` (`id`, `joueur`, `elo`, `initial`, `parties`, `prior`, `bonus`, `oldrating`, `gcount`, `wins`, `losses`, `draws`, `active`) VALUES
(1, 'AlvaroL', 1400, 1400, 0, 0, 0, 1400, 0, 0, 0, 0, 1),
(2, 'DamienB', 1400, 1400, 0, 0, 0, 1400, 0, 0, 0, 0, 1),
(3, 'EmileM', 1400, 1400, 0, 0, 0, 1400, 0, 0, 0, 0, 1),
(4, 'FranckD', 1400, 1400, 0, 0, 0, 1400, 0, 0, 0, 0, 1),
(5, 'FranckV', 1400, 1400, 0, 0, 0, 1400, 0, 0, 0, 0, 1),
(6, 'HenriqueF', 1400, 1400, 0, 0, 0, 1400, 0, 0, 0, 0, 1),
(7, 'OlivierC', 1400, 1400, 0, 0, 0, 1400, 0, 0, 0, 0, 1),
(8, 'PatrickA', 1400, 1400, 0, 0, 0, 1400, 0, 0, 0, 0, 1),
(9, 'PhilippeA', 1400, 1400, 0, 0, 0, 1400, 0, 0, 0, 0, 1),
(10, 'RemyS', 1400, 1400, 0, 0, 0, 1400, 0, 0, 0, 0, 1),
(11, 'StephaneR', 1400, 1400, 0, 0, 0, 1400, 0, 0, 0, 0, 1),



/***************************************

CREATE TABLE `BLITZ_evolution_2022` (
  `playerID` int(11) DEFAULT NULL,
  `rating` int(11) DEFAULT NULL,
  `date` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*****************************************

CREATE TABLE `chessmaster_2022` (
  `id` int(11) NOT NULL,
  `blanc` varchar(30) NOT NULL DEFAULT '',
  `noir` varchar(30) NOT NULL DEFAULT '',
  `gagnant` varchar(30) NOT NULL DEFAULT '',
  `date` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
