· 7 years ago · Oct 08, 2018, 03:00 PM
1-- MySQL Script generated by MySQL Workbench
2-- Mon Oct 8 16:56:19 2018
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='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
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`.`Band`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `mydb`.`Band` (
24 `id` INT NOT NULL AUTO_INCREMENT,
25 `name` VARCHAR(45) NULL,
26 PRIMARY KEY (`id`))
27ENGINE = InnoDB;
28
29
30-- -----------------------------------------------------
31-- Table `mydb`.`Album`
32-- -----------------------------------------------------
33CREATE TABLE IF NOT EXISTS `mydb`.`Album` (
34 `id` INT NOT NULL AUTO_INCREMENT,
35 `name` VARCHAR(45) NULL,
36 `date` INT NULL,
37 `Band_idBand` INT NOT NULL,
38 PRIMARY KEY (`id`),
39 INDEX `fk_Album_Band1_idx` (`Band_idBand` ASC) VISIBLE,
40 CONSTRAINT `fk_Album_Band1`
41 FOREIGN KEY (`Band_idBand`)
42 REFERENCES `mydb`.`Band` (`id`)
43 ON DELETE NO ACTION
44 ON UPDATE NO ACTION)
45ENGINE = InnoDB;
46
47
48-- -----------------------------------------------------
49-- Table `mydb`.`Song`
50-- -----------------------------------------------------
51CREATE TABLE IF NOT EXISTS `mydb`.`Song` (
52 `id` INT NOT NULL AUTO_INCREMENT,
53 `name` VARCHAR(45) NULL,
54 PRIMARY KEY (`id`))
55ENGINE = InnoDB;
56
57
58-- -----------------------------------------------------
59-- Table `mydb`.`Songlist`
60-- -----------------------------------------------------
61CREATE TABLE IF NOT EXISTS `mydb`.`Songlist` (
62 `Song_idSong` INT NOT NULL,
63 `Album_idAlbum` INT NOT NULL,
64 INDEX `fk_Song_has_Album_Album1_idx` (`Album_idAlbum` ASC) VISIBLE,
65 INDEX `fk_Song_has_Album_Song1_idx` (`Song_idSong` ASC) VISIBLE,
66 PRIMARY KEY (`Song_idSong`, `Album_idAlbum`),
67 CONSTRAINT `fk_Song_has_Album_Song1`
68 FOREIGN KEY (`Song_idSong`)
69 REFERENCES `mydb`.`Song` (`id`)
70 ON DELETE NO ACTION
71 ON UPDATE NO ACTION,
72 CONSTRAINT `fk_Song_has_Album_Album1`
73 FOREIGN KEY (`Album_idAlbum`)
74 REFERENCES `mydb`.`Album` (`id`)
75 ON DELETE NO ACTION
76 ON UPDATE NO ACTION)
77ENGINE = InnoDB;
78
79
80-- -----------------------------------------------------
81-- Table `mydb`.`Person`
82-- -----------------------------------------------------
83CREATE TABLE IF NOT EXISTS `mydb`.`Person` (
84 `id` INT NOT NULL AUTO_INCREMENT,
85 `name` VARCHAR(45) NULL,
86 `surname` VARCHAR(45) NULL,
87 PRIMARY KEY (`id`))
88ENGINE = InnoDB;
89
90
91-- -----------------------------------------------------
92-- Table `mydb`.`Members`
93-- -----------------------------------------------------
94CREATE TABLE IF NOT EXISTS `mydb`.`Members` (
95 `id` INT NOT NULL,
96 `Members_idMembers` INT NOT NULL,
97 `Band_idBand` INT NOT NULL,
98 `joined` INT NOT NULL,
99 `retired` INT NULL,
100 INDEX `fk_Members_has_Band_Band1_idx` (`Band_idBand` ASC) VISIBLE,
101 INDEX `fk_Members_has_Band_Members1_idx` (`Members_idMembers` ASC) VISIBLE,
102 PRIMARY KEY (`id`),
103 CONSTRAINT `fk_Members_has_Band_Members1`
104 FOREIGN KEY (`Members_idMembers`)
105 REFERENCES `mydb`.`Person` (`id`)
106 ON DELETE NO ACTION
107 ON UPDATE NO ACTION,
108 CONSTRAINT `fk_Members_has_Band_Band1`
109 FOREIGN KEY (`Band_idBand`)
110 REFERENCES `mydb`.`Band` (`id`)
111 ON DELETE NO ACTION
112 ON UPDATE NO ACTION)
113ENGINE = InnoDB;
114
115
116SET SQL_MODE=@OLD_SQL_MODE;
117SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
118SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;