iXwFyuE9

1SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
2SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
3SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';
4
5CREATE SCHEMA IF NOT EXISTS `musicapp` DEFAULT CHARACTER SET latin1 ;
6USE `musicapp` ;
7
8-- -----------------------------------------------------
9-- Table `musicapp`.`Band`
10-- -----------------------------------------------------
11CREATE  TABLE IF NOT EXISTS `musicapp`.`Band` (
12  `ID_band` INT(11) NOT NULL AUTO_INCREMENT ,
13  `Name` VARCHAR(30) NOT NULL ,
14  `Active` VARCHAR(15) NULL DEFAULT NULL ,
15  `Comments` VARCHAR(200) NULL ,
16  PRIMARY KEY (`ID_band`) )
17ENGINE = MyISAM
18AUTO_INCREMENT = 19
19DEFAULT CHARACTER SET = latin1;
20
21
22-- -----------------------------------------------------
23-- Table `musicapp`.`Album`
24-- -----------------------------------------------------
25CREATE  TABLE IF NOT EXISTS `musicapp`.`Album` (
26  `ID_albums` INT(11) NOT NULL AUTO_INCREMENT ,
27  `Name` VARCHAR(30) NOT NULL ,
28  `Year` INT(4) NULL DEFAULT NULL ,
29  `Art` VARCHAR(100) NULL DEFAULT NULL ,
30  `Comments` VARCHAR(200) NULL ,
31  `Band_ID_band` INT(11) NOT NULL ,
32  PRIMARY KEY (`ID_albums`, `Band_ID_band`) ,
33  INDEX `fk_Album_Band1` (`Band_ID_band` ASC) ,
34  CONSTRAINT `fk_Album_Band1`
35    FOREIGN KEY (`Band_ID_band` )
36    REFERENCES `musicapp`.`Band` (`ID_band` )
37    ON DELETE NO ACTION
38    ON UPDATE NO ACTION)
39ENGINE = MyISAM
40AUTO_INCREMENT = 20
41DEFAULT CHARACTER SET = latin1
42COMMENT = 'sdf' ;
43
44
45-- -----------------------------------------------------
46-- Table `musicapp`.`Musician`
47-- -----------------------------------------------------
48CREATE  TABLE IF NOT EXISTS `musicapp`.`Musician` (
49  `ID_musician` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ,
50  `Name` VARCHAR(30) NOT NULL ,
51  `Band_ID_band` INT(11) NOT NULL ,
52  PRIMARY KEY (`ID_musician`, `Band_ID_band`) ,
53  INDEX `fk_Musician_Band1` (`Band_ID_band` ASC) ,
54  CONSTRAINT `fk_Musician_Band1`
55    FOREIGN KEY (`Band_ID_band` )
56    REFERENCES `musicapp`.`Band` (`ID_band` )
57    ON DELETE NO ACTION
58    ON UPDATE NO ACTION)
59ENGINE = MyISAM
60AUTO_INCREMENT = 19
61DEFAULT CHARACTER SET = latin1;
62
63
64-- -----------------------------------------------------
65-- Table `musicapp`.`Song`
66-- -----------------------------------------------------
67CREATE  TABLE IF NOT EXISTS `musicapp`.`Song` (
68  `ID_songs` INT(11) NOT NULL AUTO_INCREMENT ,
69  `Name` VARCHAR(75) NOT NULL ,
70  `Track` INT(3) NOT NULL DEFAULT '0' ,
71  `LocRecd` VARCHAR(30) NULL DEFAULT NULL ,
72  `URL` VARCHAR(100) NOT NULL ,
73  `Comments` VARCHAR(300) NULL ,
74  `Album_ID` INT(11) NOT NULL ,
75  PRIMARY KEY (`ID_songs`, `Album_ID`) ,
76  INDEX `fk_Song_Album1` (`Album_ID` ASC) ,
77  CONSTRAINT `fk_Song_Album1`
78    FOREIGN KEY (`Album_ID` )
79    REFERENCES `musicapp`.`Album` (`ID_albums` )
80    ON DELETE NO ACTION
81    ON UPDATE NO ACTION)
82ENGINE = MyISAM
83AUTO_INCREMENT = 84
84DEFAULT CHARACTER SET = latin1;
85
86
87-- -----------------------------------------------------
88-- Table `musicapp`.`users`
89-- -----------------------------------------------------
90CREATE  TABLE IF NOT EXISTS `musicapp`.`users` (
91  `id_users` INT NOT NULL ,
92  `user` VARCHAR(30) NOT NULL ,
93  `pass` VARCHAR(128) NULL ,
94  `mode` SMALLINT NOT NULL ,
95  PRIMARY KEY (`id_users`) )
96ENGINE = InnoDB;
97
98
99-- -----------------------------------------------------
100-- Table `musicapp`.`playlists`
101-- -----------------------------------------------------
102CREATE  TABLE IF NOT EXISTS `musicapp`.`playlists` (
103  `id_playlists` INT NOT NULL ,
104  `name` VARCHAR(30) NULL ,
105  `users_id_users` INT NOT NULL ,
106  PRIMARY KEY (`id_playlists`, `users_id_users`) ,
107  INDEX `fk_playlists_users1` (`users_id_users` ASC) ,
108  CONSTRAINT `fk_playlists_users1`
109    FOREIGN KEY (`users_id_users` )
110    REFERENCES `musicapp`.`users` (`id_users` )
111    ON DELETE NO ACTION
112    ON UPDATE NO ACTION)
113ENGINE = InnoDB;
114
115
116-- -----------------------------------------------------
117-- Table `musicapp`.`playlists_has_Song`
118-- -----------------------------------------------------
119CREATE  TABLE IF NOT EXISTS `musicapp`.`playlists_has_Song` (
120  `playlists_id_playlists` INT NOT NULL ,
121  `playlists_users_id_users` INT NOT NULL ,
122  `Song_ID_songs` INT(11) NOT NULL ,
123  `Song_Album_ID` INT(11) NOT NULL ,
124  PRIMARY KEY (`playlists_id_playlists`, `playlists_users_id_users`, `Song_ID_songs`, `Song_Album_ID`) ,
125  INDEX `fk_playlists_has_Song_Song1` (`Song_ID_songs` ASC, `Song_Album_ID` ASC) ,
126  INDEX `fk_playlists_has_Song_playlists1` (`playlists_id_playlists` ASC, `playlists_users_id_users` ASC) ,
127  CONSTRAINT `fk_playlists_has_Song_playlists1`
128    FOREIGN KEY (`playlists_id_playlists` , `playlists_users_id_users` )
129    REFERENCES `musicapp`.`playlists` (`id_playlists` , `users_id_users` )
130    ON DELETE NO ACTION
131    ON UPDATE NO ACTION,
132  CONSTRAINT `fk_playlists_has_Song_Song1`
133    FOREIGN KEY (`Song_ID_songs` , `Song_Album_ID` )
134    REFERENCES `musicapp`.`Song` (`ID_songs` , `Album_ID` )
135    ON DELETE NO ACTION
136    ON UPDATE NO ACTION)
137ENGINE = InnoDB;
138
139
140
141SET SQL_MODE=@OLD_SQL_MODE;
142SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
143SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;