53M6eNYA

1/*
2 Navicat Premium Data Transfer
3
4 Source Server         : CESI
5 Source Server Type    : MySQL
6 Source Server Version : 50723
7 Source Host           : localhost:3306
8 Source Schema         : AmazingDB
9
10 Target Server Type    : MySQL
11 Target Server Version : 50723
12 File Encoding         : 65001
13
14 Date: 03/07/2019 15:44:55
15*/
16
17SET NAMES utf8mb4;
18SET FOREIGN_KEY_CHECKS = 0;
19
20-- ----------------------------
21-- Table structure for Groupes
22-- ----------------------------
23DROP TABLE IF EXISTS `Groupes`;
24CREATE TABLE `Groupes` (
25  `GROU_id` int(30) NOT NULL AUTO_INCREMENT,
26  `GROU_name` varchar(255) NOT NULL,
27  PRIMARY KEY (`GROU_id`)
28) ENGINE=InnoDB DEFAULT CHARSET=utf8;
29
30-- ----------------------------
31-- Table structure for Groupes_Utilisateurs
32-- ----------------------------
33DROP TABLE IF EXISTS `Groupes_Utilisateurs`;
34CREATE TABLE `Groupes_Utilisateurs` (
35  `GRUT_id` int(30) NOT NULL AUTO_INCREMENT,
36  `GROU_id` int(30) NOT NULL,
37  `UTIL_id` int(30) NOT NULL,
38  PRIMARY KEY (`GRUT_id`),
39  KEY `GROU_ID` (`GROU_id`),
40  KEY `UTIL_ID` (`UTIL_id`),
41  CONSTRAINT `GROU_ID` FOREIGN KEY (`GROU_id`) REFERENCES `Groupes` (`GROU_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
42  CONSTRAINT `UTIL_ID` FOREIGN KEY (`UTIL_id`) REFERENCES `Utilisateurs` (`UTIL_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
43) ENGINE=InnoDB DEFAULT CHARSET=utf8;
44
45-- ----------------------------
46-- Table structure for Utilisateurs
47-- ----------------------------
48DROP TABLE IF EXISTS `Utilisateurs`;
49CREATE TABLE `Utilisateurs` (
50  `UTIL_id` int(30) NOT NULL AUTO_INCREMENT,
51  `UTIL_nom` varchar(255) NOT NULL,
52  `UTIL_prenom` varchar(255) NOT NULL,
53  `UTIL_mail` varchar(255) NOT NULL,
54  `UTIL_password` varchar(255) NOT NULL,
55  PRIMARY KEY (`UTIL_id`)
56) ENGINE=InnoDB DEFAULT CHARSET=utf8;
57
58SET FOREIGN_KEY_CHECKS = 1;