tVEaqVcy

1-- phpMyAdmin SQL Dump
2-- version 4.9.0.1
3-- https://www.phpmyadmin.net/
4--
5-- Hôte : 127.0.0.1
6-- Généré le :  mer. 22 jan. 2020 à 10:22
7-- Version du serveur :  10.4.6-MariaDB
8-- Version de PHP :  7.3.9
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8mb4 */;
20
21--
22-- Base de données :  `partiel`
23--
24CREATE DATABASE IF NOT EXISTS `epreuve` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
25USE `epreuve`;
26
27-- --------------------------------------------------------
28
29--
30-- Structure de la table `cours`
31--
32
33CREATE TABLE `cours` (
34  `theme` varchar(500) COLLATE utf8mb4_bin NOT NULL,
35  `heures` int(11) NOT NULL
36) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
37
38-- --------------------------------------------------------
39
40--
41-- Structure de la table `ecoles`
42--
43
44CREATE TABLE `ecoles` (
45  `nom` varchar(60) COLLATE utf8mb4_bin NOT NULL,
46  `mail` varchar(250) COLLATE utf8mb4_bin NOT NULL,
47  `adresse` varchar(250) COLLATE utf8mb4_bin NOT NULL,
48  `tel` varchar(12) COLLATE utf8mb4_bin NOT NULL,
49  `directeur` varchar(100) COLLATE utf8mb4_bin NOT NULL
50) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
51
52-- --------------------------------------------------------
53
54--
55-- Structure de la table `enseignants`
56--
57
58CREATE TABLE `enseignants` (
59  `id` int(11) NOT NULL,
60  `nom` varchar(25) COLLATE utf8mb4_bin NOT NULL,
61  `prenom` varchar(25) COLLATE utf8mb4_bin NOT NULL,
62  `mail` varchar(250) COLLATE utf8mb4_bin NOT NULL,
63  `adresse` varchar(250) COLLATE utf8mb4_bin NOT NULL,
64  `tel` varchar(13) COLLATE utf8mb4_bin NOT NULL,
65  `matiere` varchar(40) COLLATE utf8mb4_bin NOT NULL
66) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
67
68-- --------------------------------------------------------
69
70--
71-- Structure de la table `etudiants`
72--
73
74CREATE TABLE `etudiants` (
75  `id` int(11) NOT NULL,
76  `nom` varchar(25) COLLATE utf8mb4_bin NOT NULL,
77  `prenom` varchar(25) COLLATE utf8mb4_bin NOT NULL,
78  `mail` varchar(250) COLLATE utf8mb4_bin NOT NULL,
79  `adresse` varchar(250) COLLATE utf8mb4_bin NOT NULL,
80  `tel` varchar(13) COLLATE utf8mb4_bin NOT NULL,
81  `naissance` varchar(30) COLLATE utf8mb4_bin NOT NULL
82) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
83
84--
85-- Index pour les tables déchargées
86--
87
88--
89-- Index pour la table `enseignants`
90--
91ALTER TABLE `enseignants`
92  ADD PRIMARY KEY (`id`);
93
94--
95-- Index pour la table `etudiants`
96--
97ALTER TABLE `etudiants`
98  ADD PRIMARY KEY (`id`);
99
100--
101-- AUTO_INCREMENT pour les tables déchargées
102--
103
104--
105-- AUTO_INCREMENT pour la table `enseignants`
106--
107ALTER TABLE `enseignants`
108  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
109
110--
111-- AUTO_INCREMENT pour la table `etudiants`
112--
113ALTER TABLE `etudiants`
114  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
115COMMIT;
116
117/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
118/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
119/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;