-- MySQL dump 10.10
--
-- Host: localhost    Database: ol
-- ------------------------------------------------------
-- Server version	5.0.22-log

/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `Buts`
--

CREATE DATABASE ol;
USE ol;
DROP TABLE IF EXISTS `Buts`;
CREATE TABLE `Buts` (
  `ButID` int(11) NOT NULL auto_increment,
  `ButeurID` int(11) NOT NULL,
  `Minute` int(11) NOT NULL,
  `Additionnel` int(11) default NULL,
  `CSC` tinyint(1) NOT NULL default '0',
  `MatchID` int(11) NOT NULL,
  PRIMARY KEY  (`ButID`),
  KEY `ButeurID` (`ButeurID`),
  KEY `MatchID` (`MatchID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Buts`
--


/*!40000 ALTER TABLE `Buts` DISABLE KEYS */;
LOCK TABLES `Buts` WRITE;
INSERT INTO `Buts` VALUES (1,24,3,NULL,0,1),(2,6,64,NULL,0,1),(3,23,88,NULL,0,1),(4,28,2,NULL,0,1),(5,13,83,NULL,0,3),(7,29,91,NULL,0,3),(8,23,27,NULL,0,6),(9,26,85,NULL,0,6),(10,30,91,NULL,0,6),(11,13,48,NULL,0,7),(12,24,67,NULL,0,7),(13,24,90,NULL,0,7),(14,20,73,NULL,0,7),(15,31,26,NULL,0,7),(16,8,15,NULL,0,4),(17,19,86,NULL,0,4),(18,20,6,NULL,0,8),(19,23,61,NULL,0,8),(20,13,64,NULL,0,8),(21,32,69,NULL,0,8),(22,13,5,NULL,0,5),(23,19,51,NULL,0,5),(24,23,63,NULL,0,5),(25,23,69,NULL,0,5),(26,8,24,NULL,1,5);
UNLOCK TABLES;
/*!40000 ALTER TABLE `Buts` ENABLE KEYS */;

--
-- Table structure for table `Club`
--

DROP TABLE IF EXISTS `Club`;
CREATE TABLE `Club` (
  `ClubID` int(11) NOT NULL auto_increment,
  `Nom` varchar(100) NOT NULL,
  PRIMARY KEY  (`ClubID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Club`
--


/*!40000 ALTER TABLE `Club` DISABLE KEYS */;
LOCK TABLES `Club` WRITE;
INSERT INTO `Club` VALUES (1,'Olympique Lyonnais'),(2,'FC Nantes'),(3,'AJ Auxerre'),(4,'AS Monaco'),(5,'AS Nancy Lorraine'),(6,'Olympique de Marseille'),(7,'CS Sedan Ardennes'),(8,'ES Troyes AC'),(9,'FC Lorient'),(10,'FC Sochaux'),(11,'Girondins Bordeaux'),(12,'Le Mans'),(13,'Lille OSC'),(14,'OGC Nice'),(15,'Paris Saint-Germain'),(16,'RC Lens'),(17,'Rennes'),(18,'Saint-Etienne'),(19,'Toulouse FC'),(20,'Valenciennes');
UNLOCK TABLES;
/*!40000 ALTER TABLE `Club` ENABLE KEYS */;

--
-- Table structure for table `Joueurs`
--

DROP TABLE IF EXISTS `Joueurs`;
CREATE TABLE `Joueurs` (
  `JoueurID` int(11) NOT NULL auto_increment,
  `Numero` int(11) NOT NULL,
  `Prenom` varchar(100) NOT NULL,
  `Nom` varchar(100) NOT NULL,
  `Poste` varchar(100) NOT NULL,
  `Date_de_naissance` date NOT NULL,
  `Nationalite` varchar(3) NOT NULL,
  `ClubID` int(11) NOT NULL,
  PRIMARY KEY  (`JoueurID`),
  KEY `ClubID` (`ClubID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Joueurs`
--


/*!40000 ALTER TABLE `Joueurs` DISABLE KEYS */;
LOCK TABLES `Joueurs` WRITE;
INSERT INTO `Joueurs` VALUES (1,1,'Gregory','Coupet','Gardien','1972-12-31','Fra',1),(2,30,'Remy','Vercoutre','Gardien','1980-06-26','Fra',1),(3,25,'Joan','Hartock','Gardien','1987-02-17','Fra',1),(4,20,'Eric','Abidal','Arriere gauche','1979-07-11','Fra',1),(5,23,'Jeremy','Berthod','Arriere gauche','1984-04-24','Fra',1),(6,29,'Sebastien','Squillaci','Defenseur central','1980-08-11','Fra',1),(7,4,'Patrick','Muller','Defenseur central','1976-12-17','Sui',1),(8,3,'Cristiano Marques','Cris','Defenseur central','1977-06-03','Bre',1),(9,38,'Mourad','Benhamida','Arriere droit','1986-01-18','Fra',1),(10,2,'Francois','Clerc','Arriere droit','1983-04-18','Fra',1),(11,12,'Anthony','Reveillere','Arriere droit','1979-11-10','Fra',1),(12,5,'Claudio Roberto','Cacapa','Defenseur central','1976-05-29','Bre',1),(13,10,'Florent','Malouda','Ailier gauche','1980-06-13','Fra',1),(14,15,'Alou','Diarra','Milieu defensif','1981-07-15','Fra',1),(15,28,'Jeremy','Toulalan','Milieu defensif','1983-09-10','Fra',1),(16,36,'Sylvain','Idangar','Milieu offensif','1984-03-08','Fra',1),(17,31,'Yacine','Hima','Milieu defensif','1984-03-25','Fra',1),(18,6,'Kim','Kallstrom','Milieu offensif','1980-08-24','Sue',1),(19,8,'Pernambucano','Juninho','Milieu offensif','1975-01-30','Bre',1),(20,21,'Tiago','Mendes','Milieu defensif','1981-05-02','Por',1),(21,14,'Sidney','Govou','Ailier droit','1979-07-27','Fra',1),(22,39,'Gregory','Bettiol','Avant centre','1986-03-30','Fra',1),(23,11,'Frederico Chaves Guedes','Fred','Avant centre','1983-10-03','Bre',1),(24,19,'Karim','Benzema','Avant centre','1987-12-19','Fra',1),(25,18,'Hatem','Ben Arfa','Ailier gauche','1987-03-07','Fra',1),(26,22,'Sylvain','Wiltord','Avant centre','1974-05-10','Fra',1),(27,9,'John','Carew','Avant centre','1979-09-05','Nor',1),(28,10,'Nourdin','Boukhari','Milieu','1980-06-30','P-B',2),(29,6,'','Fabinho','Milieu','1980-01-10','Bre',19),(30,18,'Julien','Faubert','Milieu','1983-08-01','Fra',11),(31,19,'Marama','Vahirua','Milieu','1983-05-12','Fra',14),(32,2,'Mickael','Ciani','Defenseur','1984-04-06','Fra',9);
UNLOCK TABLES;
/*!40000 ALTER TABLE `Joueurs` ENABLE KEYS */;

--
-- Table structure for table `Matchs`
--

DROP TABLE IF EXISTS `Matchs`;
CREATE TABLE `Matchs` (
  `MatchID` int(11) NOT NULL auto_increment,
  `Domicile` int(11) NOT NULL,
  `Visiteur` int(11) NOT NULL,
  `Date_de_match` date NOT NULL,
  PRIMARY KEY  (`MatchID`),
  KEY `Domicile` (`Domicile`),
  KEY `Visiteur` (`Visiteur`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `Matchs`
--


/*!40000 ALTER TABLE `Matchs` DISABLE KEYS */;
LOCK TABLES `Matchs` WRITE;
INSERT INTO `Matchs` VALUES (1,1,2,'2006-08-04'),(3,1,19,'2006-08-12'),(4,1,8,'2006-09-09'),(5,1,13,'2006-09-23'),(6,11,1,'2006-08-20'),(7,14,1,'2006-08-26'),(8,9,1,'2006-09-16');
UNLOCK TABLES;
/*!40000 ALTER TABLE `Matchs` ENABLE KEYS */;

--
-- Table structure for table `joueurs`
--

DROP TABLE IF EXISTS `joueurs`;
CREATE TABLE `joueurs` (
  `Numero` int(11) default NULL,
  `Prenom` varchar(100) default NULL,
  `Nom` varchar(100) default NULL,
  `Poste` varchar(100) default NULL,
  `Date_de_naissance` date default NULL,
  `Nationalite` char(3) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `joueurs`
--


/*!40000 ALTER TABLE `joueurs` DISABLE KEYS */;
LOCK TABLES `joueurs` WRITE;
INSERT INTO `joueurs` VALUES (1,'Gregory','Coupet','Gardien','1972-12-31','Fra'),(30,'Remy','Vercoutre','Gardien','1980-06-26','Fra'),(25,'Joan','Hartock','Gardien','1987-02-17','Fra'),(20,'Eric','Abidal','Arriere gauche','1979-07-11','Fra'),(23,'Jeremy','Berthod','Arriere gauche','1984-04-24','Fra'),(29,'Sebastien','Squillaci','Defenseur central','1980-08-11','Fra'),(4,'Patrick','Muller','Defenseur central','1976-12-17','Sui'),(3,'Cristiano Marques','Cris','Defenseur central','1977-06-03','Bre'),(38,'Mourad','Benhamida','Arriere droit','1986-01-18','Fra'),(2,'Francois','Clerc','Arriere droit','1983-04-18','Fra'),(12,'Anthony','Reveillere','Arriere droit','1979-11-10','Fra'),(5,'Claudio Roberto','Cacapa','Defenseur central','1976-05-29','Bre'),(10,'Florent','Malouda','Ailier gauche','1980-06-13','Fra'),(15,'Alou','Diarra','Milieu defensif','1981-07-15','Fra'),(28,'Jeremy','Toulalan','Milieu defensif','1983-09-10','Fra'),(36,'Sylvain','Idangar','Milieu offensif','1984-03-08','Fra'),(31,'Yacine','Hima','Milieu defensif','1984-03-25','Fra'),(6,'Kim','Kallstrom','Milieu offensif','1980-08-24','Sue'),(8,'Pernambucano','Juninho','Milieu offensif','1975-01-30','Bre'),(21,'Tiago','Mendes','Milieu defensif','1981-05-02','Por'),(14,'Sidney','Govou','Ailier droit','1979-07-27','Fra'),(39,'Gregory','Bettiol','Avant centre','1986-03-30','Fra'),(11,'Frederico Chaves Guedes','Fred','Avant centre','1983-10-03','Bre'),(19,'Karim','Benzema','Avant centre','1987-12-19','Fra'),(18,'Hatem','Ben Arfa','Ailier gauche','1987-03-07','Fra'),(22,'Sylvain','Wiltord','Avant centre','1974-05-10','Fra'),(9,'John','Carew','Avant centre','1979-09-05','Nor');
UNLOCK TABLES;
/*!40000 ALTER TABLE `joueurs` ENABLE KEYS */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;