Ydd4dRA0

1-- MySQL Script generated by MySQL Workbench
2-- sob, 9 gru 2017, 14:15:49
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 mydb
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema mydb
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
18USE `mydb` ;
19
20-- -----------------------------------------------------
21-- Table `mydb`.`Song`
22-- -----------------------------------------------------
23DROP TABLE IF EXISTS `mydb`.`Song` ;
24
25CREATE TABLE IF NOT EXISTS `mydb`.`Song` (
26  `ID` INT NOT NULL,
27  `ID_FILE` VARCHAR(45) NULL,
28  `NAME` VARCHAR(45) NULL,
29  PRIMARY KEY (`ID`))
30ENGINE = InnoDB;
31
32
33-- -----------------------------------------------------
34-- Table `mydb`.`Artist`
35-- -----------------------------------------------------
36DROP TABLE IF EXISTS `mydb`.`Artist` ;
37
38CREATE TABLE IF NOT EXISTS `mydb`.`Artist` (
39  `ID` INT NOT NULL,
40  `NAME` VARCHAR(45) NULL,
41  PRIMARY KEY (`ID`))
42ENGINE = InnoDB;
43
44
45-- -----------------------------------------------------
46-- Table `mydb`.`TIme`
47-- -----------------------------------------------------
48DROP TABLE IF EXISTS `mydb`.`TIme` ;
49
50CREATE TABLE IF NOT EXISTS `mydb`.`TIme` (
51  `idTIme` INT NOT NULL,
52  `time` timestamp NULL,
53  PRIMARY KEY (`idTIme`))
54ENGINE = InnoDB;
55
56
57-- -----------------------------------------------------
58-- Table `mydb`.`Listen`
59-- -----------------------------------------------------
60DROP TABLE IF EXISTS `mydb`.`Listen` ;
61
62CREATE TABLE IF NOT EXISTS `mydb`.`Listen` (
63  `Listen_ID` INT NOT NULL,
64  `Listen_ID_File` VARCHAR(45) NOT NULL,
65  `Song_ID` INT NOT NULL,
66  `Artist_ID` INT NOT NULL,
67  `TIme_idTIme` INT NOT NULL,
68  PRIMARY KEY (`Listen_ID`),
69  INDEX `fk_Listen_Song_idx` (`Song_ID` ASC),
70  INDEX `fk_Listen_Artist1_idx` (`Artist_ID` ASC),
71  INDEX `fk_Listen_TIme1_idx` (`TIme_idTIme` ASC),
72  CONSTRAINT `fk_Listen_Song`
73    FOREIGN KEY (`Song_ID`)
74    REFERENCES `mydb`.`Song` (`ID`)
75    ON DELETE NO ACTION
76    ON UPDATE NO ACTION,
77  CONSTRAINT `fk_Listen_Artist1`
78    FOREIGN KEY (`Artist_ID`)
79    REFERENCES `mydb`.`Artist` (`ID`)
80    ON DELETE NO ACTION
81    ON UPDATE NO ACTION,
82  CONSTRAINT `fk_Listen_TIme1`
83    FOREIGN KEY (`TIme_idTIme`)
84    REFERENCES `mydb`.`TIme` (`idTIme`)
85    ON DELETE NO ACTION
86    ON UPDATE NO ACTION)
87ENGINE = InnoDB;
88
89
90-- -----------------------------------------------------
91-- Table `mydb`.`User`
92-- -----------------------------------------------------
93DROP TABLE IF EXISTS `mydb`.`User` ;
94
95CREATE TABLE IF NOT EXISTS `mydb`.`User` (
96  `ID` INT NOT NULL,
97  `ID_FILE` VARCHAR(45) NULL,
98  `USER_NAME` VARCHAR(45) NULL,
99  `Listen_Listen_ID` INT NOT NULL,
100  PRIMARY KEY (`ID`),
101  INDEX `fk_User_Listen1_idx` (`Listen_Listen_ID` ASC),
102  CONSTRAINT `fk_User_Listen1`
103    FOREIGN KEY (`Listen_Listen_ID`)
104    REFERENCES `mydb`.`Listen` (`Listen_ID`)
105    ON DELETE NO ACTION
106    ON UPDATE NO ACTION)
107ENGINE = InnoDB;
108
109
110SET SQL_MODE=@OLD_SQL_MODE;
111SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
112SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;