-- phpMyAdmin SQL Dump
-- version 2.11.6
-- http://www.phpmyadmin.net
--
-- Serveur: localhost
-- Généré le : Jeu 02 Août 2012 à 15:47
-- Version du serveur: 5.0.51
-- Version de PHP: 5.2.6
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Base de données: `olympics`
--
-- --------------------------------------------------------
--
-- Structure de la table `game`
--
CREATE TABLE `game` (
`id` tinyint(3) UNSIGNED NOT NULL AUTO_INCREMENT,
`playerA_id` tinyint(3) UNSIGNED NOT NULL,
`playerB_id` tinyint(3) UNSIGNED NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `playerA_id` (`playerA_id`,`playerB_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Contenu de la table `game`
--
INSERT INTO `game` (`id`, `playerA_id`, `playerB_id`) VALUES
(1, 1, 4),
(2, 1, 5),
(3, 2, 4),
(4, 2, 5),
(5, 3, 5);
-- --------------------------------------------------------
--
-- Structure de la table `player`
--
CREATE TABLE `player` (
`id` tinyint(3) UNSIGNED NOT NULL AUTO_INCREMENT,
`team_id` tinyint(3) UNSIGNED NOT NULL,
`name` VARCHAR(50) NOT NULL,
PRIMARY KEY (`id`),
KEY `team_id` (`team_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
--
-- Contenu de la table `player`
--
INSERT INTO `player` (`id`, `team_id`, `name`) VALUES
(1, 1, 'Laurent Dupuis'),
(2, 1, 'Stéphane Leroy'),
(3, 1, 'Julien le Guen'),
(4, 2, 'Mark Johnsson'),
(5, 2, 'John McGrath'),
(6, 2, 'Alec Russell');
-- --------------------------------------------------------
--
-- Structure de la table `team`
--
CREATE TABLE `team` (
`id` tinyint(3) UNSIGNED NOT NULL AUTO_INCREMENT,
`country` VARCHAR(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
--
-- Contenu de la table `team`
--
INSERT INTO `team` (`id`, `country`) VALUES
(1, 'France'),
(2, 'The United Kingdom');