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