-- phpMyAdmin SQL Dump
-- version 2.6.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Sep 19, 2007 at 08:25 PM
-- Server version: 5.0.41
-- PHP Version: 4.4.2
--
-- Database: `qcompta`
--

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

--
-- Table structure for table `matches`
--

CREATE TABLE `matches` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `home` varchar(100) collate utf8_unicode_ci NOT NULL,
  `visitor` varchar(100) collate utf8_unicode_ci NOT NULL,
  `nbGoalsHome` int(10) default NULL,
  `nbGoalsVisitor` int(10) default NULL,
  `dayIndex` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Matches de foot' AUTO_INCREMENT=81 ;

--
-- Dumping data for table `matches`
--

INSERT INTO `matches` VALUES (1, 'Marseille', 'Toulouse', 1, 2, 8);
INSERT INTO `matches` VALUES (2, 'Lens', 'Nancy', 1, 0, 8);
INSERT INTO `matches` VALUES (3, 'Le mans', 'Valenciennes', 2, 0, 8);
INSERT INTO `matches` VALUES (4, 'Lille', 'Bordeaux', 1, 1, 8);
INSERT INTO `matches` VALUES (5, 'Metz', 'Lyon', 1, 5, 8);
INSERT INTO `matches` VALUES (6, 'Sochaux', 'Strasbourg', 0, 0, 8);
INSERT INTO `matches` VALUES (7, 'Auxerre', 'Nice', 2, 0, 8);
INSERT INTO `matches` VALUES (8, 'Saint-Etienne', 'Caen', 3, 0, 8);
INSERT INTO `matches` VALUES (9, 'Monaco', 'Paris-SG', 1, 2, 8);
INSERT INTO `matches` VALUES (10, 'Lorient', 'Rennes', 0, 1, 8);
INSERT INTO `matches` VALUES (11, 'Bordeaux', 'Monaco', 2, 1, 7);
INSERT INTO `matches` VALUES (12, 'Nancy', 'Saint-Etienne', 2, 0, 7);
INSERT INTO `matches` VALUES (13, 'Valenciennes', 'Metz', 0, 0, 7);
INSERT INTO `matches` VALUES (14, 'Rennes', 'Lille', 2, 2, 7);
INSERT INTO `matches` VALUES (15, 'Strasbourg', 'Lorient', 0, 0, 7);
INSERT INTO `matches` VALUES (16, 'Lyon', 'Le mans', 3, 2, 7);
INSERT INTO `matches` VALUES (17, 'Toulouse', 'Auxerre', 2, 0, 7);
INSERT INTO `matches` VALUES (18, 'Caen', 'Sochaux', 2, 2, 7);
INSERT INTO `matches` VALUES (19, 'Paris-SG', 'Marseille', 1, 1, 7);
INSERT INTO `matches` VALUES (20, 'Nice', 'Lens', 1, 0, 7);
INSERT INTO `matches` VALUES (21, 'Lorient', 'Valenciennes', 1, 3, 6);
INSERT INTO `matches` VALUES (22, 'Marseille', 'Nice', 0, 2, 6);
INSERT INTO `matches` VALUES (23, 'Lille', 'Monaco', 0, 1, 6);
INSERT INTO `matches` VALUES (24, 'Saint-Etienne', 'Strasbourg', 2, 0, 6);
INSERT INTO `matches` VALUES (25, 'Le mans', 'Paris-SG', 0, 2, 6);
INSERT INTO `matches` VALUES (26, 'Metz', 'Bordeaux', 0, 1, 6);
INSERT INTO `matches` VALUES (27, 'Auxerre', 'Rennes', 0, 2, 6);
INSERT INTO `matches` VALUES (28, 'Sochaux', 'Lyon', 1, 2, 6);
INSERT INTO `matches` VALUES (29, 'Toulouse', 'Nancy', NULL, NULL, 6);
INSERT INTO `matches` VALUES (30, 'Lens', 'Caen', NULL, NULL, 6);
INSERT INTO `matches` VALUES (31, 'Caen', 'Marseille', 1, 2, 5);
INSERT INTO `matches` VALUES (32, 'Monaco', 'Le mans', 3, 1, 5);
INSERT INTO `matches` VALUES (33, 'Nancy', 'Auxerre', 4, 1, 5);
INSERT INTO `matches` VALUES (34, 'Bordeaux', 'Lorient', 2, 2, 5);
INSERT INTO `matches` VALUES (35, 'Strasbourg', 'Lens', 2, 1, 5);
INSERT INTO `matches` VALUES (36, 'Valenciennes', 'Sochaux', 3, 1, 5);
INSERT INTO `matches` VALUES (37, 'Rennes', 'Metz', 2, 0, 5);
INSERT INTO `matches` VALUES (38, 'Nice', 'Toulouse', 1, 1, 5);
INSERT INTO `matches` VALUES (39, 'Paris-SG', 'Lille', 1, 1, 5);
INSERT INTO `matches` VALUES (40, 'Lyon', 'Saint-Etienne', 1, 0, 5);
INSERT INTO `matches` VALUES (41, 'Sochaux', 'Monaco', 0, 3, 4);
INSERT INTO `matches` VALUES (42, 'Le mans', 'Lille', 1, 1, 4);
INSERT INTO `matches` VALUES (43, 'Lorient', 'Lyon', 2, 1, 4);
INSERT INTO `matches` VALUES (44, 'Saint-Etienne', 'Bordeaux', 0, 0, 4);
INSERT INTO `matches` VALUES (45, 'Toulouse', 'Strasbourg', 1, 3, 4);
INSERT INTO `matches` VALUES (46, 'Auxerre', 'Caen', 1, 0, 4);
INSERT INTO `matches` VALUES (47, 'Metz', 'Paris-SG', 0, 0, 4);
INSERT INTO `matches` VALUES (48, 'Lens', 'Valenciennes', 0, 0, 4);
INSERT INTO `matches` VALUES (49, 'Nice', 'Rennes', 1, 1, 4);
INSERT INTO `matches` VALUES (50, 'Marseille', 'Nancy', 2, 2, 4);
INSERT INTO `matches` VALUES (51, 'Valenciennes', 'Marseille', 2, 1, 3);
INSERT INTO `matches` VALUES (52, 'Bordeaux', 'Le mans', 1, 2, 3);
INSERT INTO `matches` VALUES (53, 'Paris-SG', 'Lorient', 1, 3, 3);
INSERT INTO `matches` VALUES (54, 'Lille', 'Sochaux', 1, 1, 3);
INSERT INTO `matches` VALUES (55, 'Monaco', 'Metz', 2, 0, 3);
INSERT INTO `matches` VALUES (56, 'Strasbourg', 'Auxerre', 3, 0, 3);
INSERT INTO `matches` VALUES (57, 'Rennes', 'Saint-Etienne', 1, 0, 3);
INSERT INTO `matches` VALUES (58, 'Nancy', 'Nice', 2, 1, 3);
INSERT INTO `matches` VALUES (59, 'Caen', 'Toulouse', NULL, NULL, 3);
INSERT INTO `matches` VALUES (60, 'Lyon', 'Lens', NULL, NULL, 3);
INSERT INTO `matches` VALUES (61, 'Toulouse', 'Lyon', 1, 0, 2);
INSERT INTO `matches` VALUES (62, 'Saint-Etienne', 'Valenciennes', 3, 1, 2);
INSERT INTO `matches` VALUES (63, 'Nancy', 'Caen', 1, 0, 2);
INSERT INTO `matches` VALUES (64, 'Sochaux', 'Le mans', 1, 3, 2);
INSERT INTO `matches` VALUES (65, 'Auxerre', 'Bordeaux', 0, 2, 2);
INSERT INTO `matches` VALUES (66, 'Lorient', 'Monaco', 2, 1, 2);
INSERT INTO `matches` VALUES (67, 'Marseille', 'Rennes', 0, 0, 2);
INSERT INTO `matches` VALUES (68, 'Nice', 'Strasbourg', 1, 0, 2);
INSERT INTO `matches` VALUES (69, 'Metz', 'Lille', 1, 2, 2);
INSERT INTO `matches` VALUES (70, 'Lens', 'Paris-SG', 0, 0, 2);
INSERT INTO `matches` VALUES (71, 'Strasbourg', 'Marseille', 0, 0, 1);
INSERT INTO `matches` VALUES (72, 'Caen', 'Nice', 1, 0, 1);
INSERT INTO `matches` VALUES (73, 'Paris-SG', 'Sochaux', 0, 0, 1);
INSERT INTO `matches` VALUES (74, 'Monaco', 'Saint-Etienne', 1, 1, 1);
INSERT INTO `matches` VALUES (75, 'Bordeaux', 'Lens', 1, 0, 1);
INSERT INTO `matches` VALUES (76, 'Rennes', 'Nancy', 0, 2, 1);
INSERT INTO `matches` VALUES (77, 'Lille', 'Lorient', 0, 0, 1);
INSERT INTO `matches` VALUES (78, 'Valenciennes', 'Toulouse', 3, 1, 1);
INSERT INTO `matches` VALUES (79, 'Le mans', 'Metz', 1, 0, 1);
INSERT INTO `matches` VALUES (80, 'Lyon', 'Auxerre', 2, 0, 1);
