· 6 years ago · Jan 12, 2020, 12:27 PM
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 à 12:22
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 PRIMARY KEY (`ID`)
37) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
38
39--
40-- Déchargement des données de la table `entreprise`
41--
42
43INSERT INTO `entreprise` (`ID`, `tel`, `Siren`) VALUES
44(1, '023456789', '123456789'),
45(2, NULL, NULL);
46
47-- --------------------------------------------------------
48
49--
50-- Structure de la table `etudiant`
51--
52
53DROP TABLE IF EXISTS `etudiant`;
54CREATE TABLE IF NOT EXISTS `etudiant` (
55 `IdUSer` int(10) NOT NULL,
56 `NumEtu` varchar(24) NOT NULL,
57 `IdProjet` int(10) NOT NULL,
58 `id_user` int(11) NOT NULL,
59 `id_projet` int(11) NOT NULL,
60 `num_etu` varchar(255) DEFAULT NULL,
61 KEY `etudiant_user_ID_fk` (`IdUSer`)
62) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
63
64--
65-- Déchargement des données de la table `etudiant`
66--
67
68INSERT INTO `etudiant` (`IdUSer`, `NumEtu`, `IdProjet`, `id_user`, `id_projet`, `num_etu`) VALUES
69(5, '2154376', 1, 0, 0, NULL),
70(6, '2255333', 2, 0, 0, NULL);
71
72-- --------------------------------------------------------
73
74--
75-- Structure de la table `prof`
76--
77
78DROP TABLE IF EXISTS `prof`;
79CREATE TABLE IF NOT EXISTS `prof` (
80 `ID` int(10) NOT NULL,
81 KEY `ID` (`ID`)
82) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
83
84--
85-- Déchargement des données de la table `prof`
86--
87
88INSERT INTO `prof` (`ID`) VALUES
89(7),
90(8);
91
92-- --------------------------------------------------------
93
94--
95-- Structure de la table `tuteur`
96--
97
98DROP TABLE IF EXISTS `tuteur`;
99CREATE TABLE IF NOT EXISTS `tuteur` (
100 `ID` int(10) NOT NULL,
101 `Tel` varchar(10) NOT NULL,
102 `Entreprise` int(10) NOT NULL,
103 PRIMARY KEY (`ID`),
104 KEY `Entreprise` (`Entreprise`)
105) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
106
107--
108-- Déchargement des données de la table `tuteur`
109--
110
111INSERT INTO `tuteur` (`ID`, `Tel`, `Entreprise`) VALUES
112(3, '', 1),
113(4, '', 2);
114
115-- --------------------------------------------------------
116
117--
118-- Structure de la table `user`
119--
120
121DROP TABLE IF EXISTS `user`;
122CREATE TABLE IF NOT EXISTS `user` (
123 `ID` int(10) NOT NULL AUTO_INCREMENT,
124 `Nom` varchar(24) NOT NULL,
125 `Mail` varchar(24) DEFAULT NULL,
126 `Mdp` varchar(24) DEFAULT NULL,
127 PRIMARY KEY (`ID`)
128) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
129
130--
131-- Déchargement des données de la table `user`
132--
133
134INSERT INTO `user` (`ID`, `Nom`, `Mail`, `Mdp`) VALUES
135(1, 'Atos@login.com', NULL, NULL),
136(2, 'Sopra@login.com', NULL, NULL),
137(3, 'tuteur1@login', NULL, NULL),
138(4, 'tuteur2@login', NULL, NULL),
139(5, 'etu1@login', NULL, NULL),
140(6, 'etu2@login', NULL, NULL),
141(7, 'prof1@login', NULL, NULL),
142(8, 'prof2@login', NULL, NULL),
143(9, 'kevin', 'kevin@mail.com', 'crocro');
144COMMIT;
145
146/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
147/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
148/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;