GeZnEJqD

1-- MySQL Script generated by MySQL Workbench
2-- Thu Oct 31 15:14:27 2019
3-- Model: New Model    Version: 1.0
4-- MySQL Workbench Forward Engineering
5
6SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
7SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
8SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
9
10-- -----------------------------------------------------
11-- Schema db_pd1920
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema db_pd1920
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `db_pd1920` DEFAULT CHARACTER SET utf8 ;
18USE `db_pd1920` ;
19
20-- -----------------------------------------------------
21-- Table `db_pd1920`.`Utilizador`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `db_pd1920`.`Utilizador` (
24  `idUtilizador` INT NOT NULL AUTO_INCREMENT,
25  `username` VARCHAR(45) NULL,
26  `password` VARCHAR(45) NULL,
27  `nome` VARCHAR(45) NULL,
28  `ativo` TINYINT NULL,
29  PRIMARY KEY (`idUtilizador`))
30ENGINE = InnoDB;
31
32
33-- -----------------------------------------------------
34-- Table `db_pd1920`.`Musica`
35-- -----------------------------------------------------
36CREATE TABLE IF NOT EXISTS `db_pd1920`.`Musica` (
37  `idMusica` INT NOT NULL AUTO_INCREMENT,
38  `nome` VARCHAR(45) NULL,
39  `autor` VARCHAR(45) NULL,
40  `album` VARCHAR(45) NULL,
41  `ano` INT NULL,
42  `duracao` DOUBLE NULL,
43  `genero` VARCHAR(45) NULL,
44  `ficheiro` VARCHAR(45) NULL,
45  `idUtilizador` INT NOT NULL,
46  PRIMARY KEY (`idMusica`),
47  INDEX `fk_Musica_Utilizador_idx` (`idUtilizador` ASC),
48  CONSTRAINT `fk_Musica_Utilizador`
49    FOREIGN KEY (`idUtilizador`)
50    REFERENCES `db_pd1920`.`Utilizador` (`idUtilizador`)
51    ON DELETE NO ACTION
52    ON UPDATE NO ACTION)
53ENGINE = InnoDB;
54
55
56-- -----------------------------------------------------
57-- Table `db_pd1920`.`Playlist`
58-- -----------------------------------------------------
59CREATE TABLE IF NOT EXISTS `db_pd1920`.`Playlist` (
60  `idPlaylist` INT NOT NULL AUTO_INCREMENT,
61  `nome` VARCHAR(45) NULL,
62  `idUtilizador` INT NOT NULL,
63  PRIMARY KEY (`idPlaylist`),
64  INDEX `fk_Playlist_Utilizador1_idx` (`idUtilizador` ASC),
65  CONSTRAINT `fk_Playlist_Utilizador1`
66    FOREIGN KEY (`idUtilizador`)
67    REFERENCES `db_pd1920`.`Utilizador` (`idUtilizador`)
68    ON DELETE NO ACTION
69    ON UPDATE NO ACTION)
70ENGINE = InnoDB;
71
72
73-- -----------------------------------------------------
74-- Table `db_pd1920`.`Musica_has_Playlist`
75-- -----------------------------------------------------
76CREATE TABLE IF NOT EXISTS `db_pd1920`.`Musica_has_Playlist` (
77  `idMusica` INT NOT NULL,
78  `idPlaylist` INT NOT NULL,
79  INDEX `fk_Musica_has_Playlist_Playlist1_idx` (`idPlaylist` ASC),
80  INDEX `fk_Musica_has_Playlist_Musica1_idx` (`idMusica` ASC),
81  CONSTRAINT `fk_Musica_has_Playlist_Musica1`
82    FOREIGN KEY (`idMusica`)
83    REFERENCES `db_pd1920`.`Musica` (`idMusica`)
84    ON DELETE NO ACTION
85    ON UPDATE NO ACTION,
86  CONSTRAINT `fk_Musica_has_Playlist_Playlist1`
87    FOREIGN KEY (`idPlaylist`)
88    REFERENCES `db_pd1920`.`Playlist` (`idPlaylist`)
89    ON DELETE NO ACTION
90    ON UPDATE NO ACTION)
91ENGINE = InnoDB;
92
93
94SET SQL_MODE=@OLD_SQL_MODE;
95SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
96SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;