-- phpMyAdmin SQL Dump
-- version 5.1.1
-- [Link]
--
-- Hôte : [Link]:3307
-- Généré le : mer. 19 oct. 2022 à 12:03
-- Version du serveur : 10.6.5-MariaDB
-- Version de PHP : 7.4.26
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
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 utf8mb4 */;
--
-- Base de données : `bdd_stek`
--
-- --------------------------------------------------------
--
-- Structure de la table `classe`
--
DROP TABLE IF EXISTS `classe`;
CREATE TABLE IF NOT EXISTS `classe` (
`idClasse` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`Nom_Classe` varchar(50) DEFAULT NULL,
PRIMARY KEY (`idClasse`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Structure de la table `km`
--
DROP TABLE IF EXISTS `km`;
CREATE TABLE IF NOT EXISTS `km` (
`idKm` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`Type_Km_idType_Km` int(10) UNSIGNED NOT NULL,
`User_3_idUser` int(10) UNSIGNED NOT NULL,
`Distance` float DEFAULT NULL,
`Date` datetime DEFAULT NULL,
PRIMARY KEY (`idKm`),
KEY `Km_FKIndex1` (`User_3_idUser`),
KEY `Km_FKIndex2` (`Type_Km_idType_Km`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Structure de la table `statut`
--
DROP TABLE IF EXISTS `statut`;
CREATE TABLE IF NOT EXISTS `statut` (
`idStatut` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`Nom_Statut` varchar(50) DEFAULT NULL,
PRIMARY KEY (`idStatut`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Structure de la table `type_km`
--
DROP TABLE IF EXISTS `type_km`;
CREATE TABLE IF NOT EXISTS `type_km` (
`idType_Km` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`Type_Km` varchar(50) DEFAULT NULL,
PRIMARY KEY (`idType_Km`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Structure de la table `user_3`
--
DROP TABLE IF EXISTS `user_3`;
CREATE TABLE IF NOT EXISTS `user_3` (
`idUser` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`Classe_idClasse` int(10) UNSIGNED NOT NULL,
`Statut_idStatut` int(10) UNSIGNED NOT NULL,
`Nom` varchar(50) DEFAULT NULL,
`Prenom` varchar(50) DEFAULT NULL,
`Mdp` varchar(50) DEFAULT NULL,
PRIMARY KEY (`idUser`),
KEY `User_3_FKIndex1` (`Statut_idStatut`),
KEY `User_3_FKIndex2` (`Classe_idClasse`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
COMMIT;
/*!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 */;