-- phpMyAdmin SQL Dump
-- version 3.5.1
-- http://www.phpmyadmin.net
--
-- Client: localhost
-- Généré le: Dim 09 Juin 2013 à 14:31
-- Version du serveur: 5.5.24-log
-- Version de PHP: 5.4.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!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 */;

--
-- Base de données: `simulateur`
--

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

--
-- Structure de la table `score`
--

CREATE TABLE IF NOT EXISTS `score` (
  `num_score` int(11) NOT NULL AUTO_INCREMENT,
  `num_circuit` int(11) NOT NULL,
  `nom_joueur` varchar(30) NOT NULL,
  `ip` varchar(40) NOT NULL,
  `lap_time` double(15,12) NOT NULL,
  `lap_num` int(2) NOT NULL,
  `checkpoint_num` int(2) NOT NULL,
  `checkpoint_time` double(15,12) NOT NULL,
  `date` datetime NOT NULL,
  PRIMARY KEY (`num_score`),
  KEY `num_circuit` (`num_circuit`),
  KEY `num_circuit_2` (`num_circuit`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=39 ;

--
-- Contenu de la table `score`
--

INSERT INTO `score` (`num_score`, `num_circuit`, `nom_joueur`, `ip`, `lap_time`, `lap_num`, `checkpoint_num`, `checkpoint_time`, `date`) VALUES
(20, 1, 'ghterigi', '178', 15.000000000000, 0, 0, 0.000000000000, '2013-05-26 18:00:52'),
(21, 1, 'ghterigi', '165', 5.000000000000, 0, 0, 0.000000000000, '2013-05-26 18:01:01'),
(22, 1, 'ghterigi', '126', 5.000000000000, 0, 0, 0.000000000000, '2013-05-26 18:01:09'),
(23, 1, 'ghterigi', '164', 55.000000000000, 0, 0, 0.000000000000, '2013-05-26 18:01:15'),
(24, 1, 'gigi', '124', 12.000000000000, 0, 0, 0.000000000000, '2013-05-26 17:59:52'),
(25, 1, 'gigi', '125', 12.000000000000, 0, 0, 0.000000000000, '2013-05-26 18:00:35'),
(26, 2, 'ghterigi', '192', 55.000000000000, 0, 0, 0.000000000000, '2013-05-26 18:01:25'),
(27, 2, 'jean', '123', -1.000000000000, 0, 3, 0.165460000000, '2013-05-27 04:28:03'),
(28, 2, 'tho', '192', 5.000000000000, 0, 0, 0.000000000000, '2013-05-26 18:01:37'),
(29, 2, 'tho', '192', 4.000000000000, 0, 0, 0.000000000000, '2013-05-26 18:01:43'),
(30, 2, 'tho', '128', 4.000000000000, 0, 0, 0.000000000000, '2013-05-26 18:01:54'),
(31, 3, 'tho', '128', 4.000000000000, 0, 0, 0.000000000000, '2013-05-26 18:02:01'),
(32, 3, 'tho', '128', 14.000000000000, 0, 0, 0.000000000000, '2013-05-26 18:02:07'),
(33, 3, 'tho', '192', 11.000000000000, 0, 0, 0.000000000000, '2013-05-26 18:02:17'),
(34, 4, 'aeo', '126', 4.000000000000, 0, 0, 0.000000000000, '2013-05-26 18:02:49'),
(35, 4, 'tho', '128', 114.000000000000, 0, 0, 0.000000000000, '2013-05-26 18:02:24'),
(36, 4, 'tho', '156', 14.000000000000, 0, 0, 0.000000000000, '2013-05-26 18:02:29'),
(37, 4, 'tho', '128', 1.667867800000, 0, 0, 0.000000000000, '2013-05-26 18:02:37'),
(38, 4, 'tho', '146', 4.455600000000, 0, 0, 0.000000000000, '2013-05-26 18:02:43');

--
-- Contraintes pour les tables exportées
--

--
-- Contraintes pour la table `score`
--
ALTER TABLE `score`
  ADD CONSTRAINT `score_ibfk_2` FOREIGN KEY (`num_circuit`) REFERENCES `circuit` (`num_circuit`);

/*!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 */;
