[Event "R1 : CD de Muret / Condom3"]
[Site "?"]
[Date "2009.??.??"]
[Round "5"]
[White "Chan, Bernard"]
[Black "Fournier , Camille"]
[Result "0-1"]
[ECO "D02"]
[WhiteElo "1970"]
[BlackElo "2024"]
[PlyCount "86"]

1. d4 Nf6 2. Nf3 e6 3. g3 d5 4. Bg2 Be7 5. O-O b5 6. Ne5 O-O 7. b3 b4 8. a3 c5 ....etc

CREATE TABLE IF NOT EXISTS `partie` (
`Event` varchar(80) NOT NULL,
`Site` varchar(50) NOT NULL,
`Date` date NOT NULL,
`Round` varchar(2) NOT NULL,
`White` varchar(70) NOT NULL,
`Black` varchar(70) NOT NULL,
`Result_White` varchar(1) NOT NULL,
`Result_Black` varchar(1) NOT NULL,
`White_Elo` varchar(4) NOT NULL,
`Black_Elo` varchar(4) NOT NULL,
`Ply_Count` varchar(3) NOT NULL,
`1w` varchar(8) NOT NULL,
`1b` varchar(8) NOT NULL,
`2w` varchar(8) NOT NULL,
`2b` varchar(8) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `partie`
--

INSERT INTO `partie` (`Event`, `Site`, `Date`, `Round`, `White`, `Black`, `Result_White`, `Result_Black`, `White_Elo`, `Black_Elo`, `Ply_Count`, `1w`, `1b`, `2w`, `2b`) VALUES
('Nationale 4', 'Condom', '2009-02-17', '4', 'Beaurain Louis', 'Porche Christian', '1', '0', '1970', '1480', '4', 'e4', 'e5', 'Cf3', 'Cc6'),
('Nationale 2', 'Condom', '2009-02-17', '1', 'Ducret Francois', 'Porche Christian', '1', '0', '2150', '1480', '4', 'e4', 'e5', 'Cf3', 'Cc6');