9qZhYtGk

1-- phpMyAdmin SQL Dump
2-- version 4.9.2
3-- https://www.phpmyadmin.net/
4--
5-- Hôte : 127.0.0.1:3308
6-- Généré le :  Dim 12 jan. 2020 à 14:33
7-- Version du serveur :  8.0.18
8-- Version de PHP :  7.3.12
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 :  `gpm`
23--
24
25-- --------------------------------------------------------
26
27--
28-- Structure de la table `entreprise`
29--
30
31DROP TABLE IF EXISTS `entreprise`;
32CREATE TABLE IF NOT EXISTS `entreprise` (
33  `id` int(10) NOT NULL,
34  `tel` varchar(10) DEFAULT NULL,
35  `siren` varchar(24) DEFAULT NULL,
36  `mail` varchar(24) DEFAULT NULL,
37  `raisonSociale` varchar(24) DEFAULT NULL,
38  `mdp` varchar(24) DEFAULT NULL,
39  PRIMARY KEY (`id`)
40) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
41
42--
43-- Déchargement des données de la table `entreprise`
44--
45
46INSERT INTO `entreprise` (`id`, `tel`, `siren`, `mail`, `raisonSociale`, `mdp`) VALUES
47(1, '023456789', '123456789', NULL, NULL, NULL),
48(2, NULL, NULL, NULL, NULL, NULL);
49
50-- --------------------------------------------------------
51
52--
53-- Structure de la table `etudiant`
54--
55
56DROP TABLE IF EXISTS `etudiant`;
57CREATE TABLE IF NOT EXISTS `etudiant` (
58  `id` int(10) NOT NULL,
59  `numEtu` varchar(24) NOT NULL,
60  `idProjet` int(10) NOT NULL,
61  `annee` int(10) DEFAULT NULL,
62  `nom` varchar(24) DEFAULT NULL,
63  `prenom` varchar(24) DEFAULT NULL,
64  `mail` varchar(24) DEFAULT NULL,
65  `mdp` varchar(24) DEFAULT NULL,
66  PRIMARY KEY (`id`)
67) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
68
69--
70-- Déchargement des données de la table `etudiant`
71--
72
73INSERT INTO `etudiant` (`id`, `numEtu`, `idProjet`, `annee`, `nom`, `prenom`, `mail`, `mdp`) VALUES
74(5, '2154376', 1, NULL, NULL, NULL, NULL, NULL),
75(6, '2255333', 2, NULL, NULL, NULL, NULL, NULL);
76
77-- --------------------------------------------------------
78
79--
80-- Structure de la table `prof`
81--
82
83DROP TABLE IF EXISTS `prof`;
84CREATE TABLE IF NOT EXISTS `prof` (
85  `id` int(10) NOT NULL,
86  `mail` varchar(24) DEFAULT NULL,
87  `mdp` varchar(24) DEFAULT NULL,
88  `nom` varchar(24) DEFAULT NULL,
89  PRIMARY KEY (`id`)
90) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
91
92--
93-- Déchargement des données de la table `prof`
94--
95
96INSERT INTO `prof` (`id`, `mail`, `mdp`, `nom`) VALUES
97(7, NULL, NULL, NULL),
98(8, NULL, NULL, NULL);
99
100-- --------------------------------------------------------
101
102--
103-- Structure de la table `tuteur`
104--
105
106DROP TABLE IF EXISTS `tuteur`;
107CREATE TABLE IF NOT EXISTS `tuteur` (
108  `id` int(10) NOT NULL,
109  `tel` varchar(10) NOT NULL,
110  `entreprise` int(10) NOT NULL,
111  `nom` varchar(24) DEFAULT NULL,
112  `mail` varchar(24) DEFAULT NULL,
113  `mdp` varchar(24) DEFAULT NULL,
114  PRIMARY KEY (`id`),
115  KEY `Entreprise` (`entreprise`)
116) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
117
118--
119-- Déchargement des données de la table `tuteur`
120--
121
122INSERT INTO `tuteur` (`id`, `tel`, `entreprise`, `nom`, `mail`, `mdp`) VALUES
123(3, '', 1, NULL, NULL, NULL),
124(4, '', 2, NULL, NULL, NULL);
125COMMIT;
126
127/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
128/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
129/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;