codigo de de mysql de la base de datos corrida

create database Fiesta_corridas;
show databases;
use Fiesta_corridas;
create table corrida (id_corrida char(10) not null, num_orden int, feria char(30), ano integer , primary key (id_corrida))TYPE = INNODB;

create table ganaderia (id_ganaderia char(10) not null,codigo char(15)not null,localidad char(30) not null,antiguedad int not null,primary key (id_ganaderia))TYPE = INNODB;

create table plazas (id_plazas char(10) not null,nombre char(30) not null,localidad char (20) not null,direccion char(40) not null,aforo int,primary key(id_plazas))TYPE = INNODB;

create table apoderado (id_apoderado char(10) not null,rfc char(15) not null,nombre char (50) not null,direccion char(40) not null,aforo int,telefono char (15),primary key(id_apoderado))TYPE = INNODB;

create table premios(id_premios char(10) not null,orejas int, rabos int,Puerta_grande bool,primary key(id_premios))TYPE = INNODB;

create table toros(
num_orden int not null,
id_ganaderia char(10) not null,
ano_nac time,
nombre char(20) not null,
color char(10),
orden_toreado int not null,
index (id_ganaderia),
foreign key (id_ganaderia) references ganaderia (id_ganaderia), on delete set null on update restrict)engine=innodb;


create table premio_torero(
id_premios char(10) not null,
index (id_premios),
foreign key (id_premios) references premios (id_premios) on delete cascade on update restrict,
id_torero char (10) not null,
index (id_torero),
foreign key (id_torero) references torero (id_torero) on delete cascade on update restrict,
id_corrida char (10) not null,
index (id_corrida),
foreign key (id_corrida) references corrida (id_corrida) on delete cascade on update cascade)engine=innodb;

create table padrino (
fecha_matador date not null,
id_torero char(10) not null,
index (id_torero),
foreign key (id_torero) references torero (id_torero) on delete cascade on update cascade)engine=innodb;

create table fiestas(
num_orden int not null,
index (num_orden),
foreign key (num_orden) references toros (num_orden) on delete cascade on update cascade,
id_plazas char(10),
index (id_plazas),
foreign key (id_plazas) references plazas (id_plazas) on delete set null on update restrict,
id_torero char(10),
index (id_torero),
foreign key (id_torero) references torero (id_torero) on delete set null on update cascade,
id_corrida char(10) not null,
index (id_corrida),
foreign key (id_corrida) references corrida (id_corrida) on delete cascade on update cascade)engine=innodb;

create table torero (
id_torero char(10) not null,
id_apoderado char(10) not null,
rfc char(10) not null,
nombre char(50),
apodo char(15) not null,
padrino bool not null, primary key (id_torero),
index(id_apoderado),
foreign key (id_apoderado) references apoderado (id_apoderado) on delete set null on update restrict)engine=innodb;