KrZhpdNY

1drop database BaseDatos;
2create database if not exists BaseDatos;
3use BaseDatos;
4
5create table if not exists genre(
6id_genero int not null auto_increment,
7nombre_genero varchar (45) not null,
8primary key (id_genero))ENGINE=INNODB;
9
10create table if not exists user (
11id_usuario int not null auto_increment, 
12nombre varchar (45)not null, 
13password varchar (45)not null,
14primary key (id_usuario))ENGINE=INNODB;
15create  table if not exists singer (
16id_interprete int not null auto_increment,
17nombre_interprete varchar (45)not null,
18nacionalidad varchar (45)not null,
19primary key (id_interprete))ENGINE=INNODB;
20create table if not exists song (
21id_cancion int not null auto_increment,
22nombre_cancion varchar (45) not null,
23id_interprete int not null,
24duracion int not null,
25tamanio int not null,
26id_genero int not null,
27primary key (id_cancion),
28foreign key (id_interprete)references singer(id_interprete),
29foreign key (id_genero)references genre(id_genero) )ENGINE=INNODB;
30##########
31use BaseDatos;
32insert into user(id_usuario,nombre,password) values (NULL,"jor","123");
33insert into genre(id_genero,nombre_genero)values (NULL,"");
34insert into song(id_cancion,nombre_cancion,duracion,tamanio)values('',"",'','');
35insert into singer(id_interprete,nombre_interprete,nacionalidad)values('',"","");