1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
| -- MySQL Workbench Forward Engineering
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
-- -----------------------------------------------------
-- Schema mydb
-- -----------------------------------------------------
-- -----------------------------------------------------
-- Schema mydb
-- -----------------------------------------------------
CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
USE `mydb` ;
-- -----------------------------------------------------
-- Table `mydb`.`user`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`user` (
`username` VARCHAR(16) NOT NULL,
`email` VARCHAR(255) NOT NULL,
`password` VARCHAR(32) NOT NULL,
`create_time` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`username`));
-- -----------------------------------------------------
-- Table `mydb`.`Projets`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Projets` (
`idProjets` VARCHAR(45) NOT NULL,
`Date` DATE NOT NULL,
`Lieu` VARCHAR(45) NOT NULL,
`Code Postal` DECIMAL(5) NOT NULL,
PRIMARY KEY (`idProjets`))
ENGINE = InnoDB;
-- -----------------------------------------------------
-- Table `mydb`.`user_has_Projets`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`user_has_Projets` (
`user_username` VARCHAR(16) NOT NULL,
`Projets_idProjets` VARCHAR(45) NOT NULL,
PRIMARY KEY (`user_username`, `Projets_idProjets`),
INDEX `fk_user_has_Projets_Projets1_idx` (`Projets_idProjets` ASC) INVISIBLE,
INDEX `fk_user_has_Projets_user_idx` (`user_username` ASC) VISIBLE,
CONSTRAINT `fk_user_has_Projets_user`
FOREIGN KEY (`user_username`)
REFERENCES `mydb`.`user` (`username`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_user_has_Projets_Projets1`
FOREIGN KEY (`Projets_idProjets`)
REFERENCES `mydb`.`Projets` (`idProjets`)
ON DELETE NO ACTION
ON UPDATE NO ACTION);
SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
-- -----------------------------------------------------
-- Data for table `mydb`.`user`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`user` (`username`, `email`, `password`, `create_time`) VALUES ('Nassim MOKHTARI', 'nassim.mokhtari@****', '1234', NULL);
COMMIT;
-- -----------------------------------------------------
-- Data for table `mydb`.`Projets`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`Projets` (`idProjets`, `Date`, `Lieu`, `Code Postal`) VALUES ('50001', '13-03-2020', 'Saint lo', 50000);
INSERT INTO `mydb`.`Projets` (`idProjets`, `Date`, `Lieu`, `Code Postal`) VALUES ('50002', '13-03-2020', 'Saint lo', 50000);
INSERT INTO `mydb`.`Projets` (`idProjets`, `Date`, `Lieu`, `Code Postal`) VALUES ('14001', '12-02-2020', 'caen', 14000);
INSERT INTO `mydb`.`Projets` (`idProjets`, `Date`, `Lieu`, `Code Postal`) VALUES ('14002', '11-01-2020', 'caen', 14000);
COMMIT;
-- -----------------------------------------------------
-- Data for table `mydb`.`user_has_Projets`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`user_has_Projets` (`user_username`, `Projets_idProjets`) VALUES ('Nassim MOKHTARI', '50001');
COMMIT; |
