7aPs4XTq

1-- MySQL Workbench Forward Engineering
2
3SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
4SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
5SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
6
7-- -----------------------------------------------------
8-- Schema mydb
9-- -----------------------------------------------------
10
11-- -----------------------------------------------------
12-- Schema mydb
13-- -----------------------------------------------------
14CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
15USE `mydb` ;
16
17-- -----------------------------------------------------
18-- Table `mydb`.`Users`
19-- -----------------------------------------------------
20CREATE TABLE IF NOT EXISTS `mydb`.`Users` (
21  `idUsers` INT NOT NULL,
22  `username` VARCHAR(45) NOT NULL,
23  `password` VARCHAR(45) NOT NULL,
24  `nome` VARCHAR(45) NOT NULL,
25  `ip` VARCHAR(45) NULL,
26  `port_tcp` INT NULL,
27  `port_udp` INT NULL,
28  `erros` INT NULL,
29  PRIMARY KEY (`idUsers`))
30ENGINE = InnoDB;
31
32
33-- -----------------------------------------------------
34-- Table `mydb`.`FilesList`
35-- -----------------------------------------------------
36CREATE TABLE IF NOT EXISTS `mydb`.`FilesList` (
37  `FilesListcol` VARCHAR(45) NOT NULL,
38  `fileName` VARCHAR(45) NOT NULL,
39  `tamanho` INT NOT NULL,
40  `Users_idUsers` INT NOT NULL,
41  PRIMARY KEY (`FilesListcol`),
42  INDEX `fk_FilesList_Users_idx` (`Users_idUsers` ASC),
43  CONSTRAINT `fk_FilesList_Users`
44    FOREIGN KEY (`Users_idUsers`)
45    REFERENCES `mydb`.`Users` (`idUsers`)
46    ON DELETE NO ACTION
47    ON UPDATE NO ACTION)
48ENGINE = InnoDB;
49
50
51-- -----------------------------------------------------
52-- Table `mydb`.`History`
53-- -----------------------------------------------------
54CREATE TABLE IF NOT EXISTS `mydb`.`History` (
55  `idHistory` INT NOT NULL,
56  `NomeFicheiro` VARCHAR(45) NOT NULL,
57  `data` DATE NOT NULL,
58  PRIMARY KEY (`idHistory`))
59ENGINE = InnoDB;
60
61
62-- -----------------------------------------------------
63-- Table `mydb`.`Users_has_History`
64-- -----------------------------------------------------
65CREATE TABLE IF NOT EXISTS `mydb`.`Users_has_History` (
66  `Users_idUsers` INT NOT NULL,
67  `History_idHistory` INT NOT NULL,
68  `Owner` TINYINT NOT NULL,
69  PRIMARY KEY (`Users_idUsers`, `History_idHistory`),
70  INDEX `fk_Users_has_History_History1_idx` (`History_idHistory` ASC),
71  INDEX `fk_Users_has_History_Users1_idx` (`Users_idUsers` ASC),
72  CONSTRAINT `fk_Users_has_History_Users1`
73    FOREIGN KEY (`Users_idUsers`)
74    REFERENCES `mydb`.`Users` (`idUsers`)
75    ON DELETE NO ACTION
76    ON UPDATE NO ACTION,
77  CONSTRAINT `fk_Users_has_History_History1`
78    FOREIGN KEY (`History_idHistory`)
79    REFERENCES `mydb`.`History` (`idHistory`)
80    ON DELETE NO ACTION
81    ON UPDATE NO ACTION)
82ENGINE = InnoDB;
83
84
85SET SQL_MODE=@OLD_SQL_MODE;
86SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
87SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;