Nueva Base de datos corregida y funcional

drop database if exists amigos_fiesta;
create database amigos_fiesta;
use amigos_fiesta;

create table plaza(numplaza integer not null primary key,localidad varchar(20) not null,direccion varchar(45) not null,aforo varchar(20) not null,nombre varchar(40) not null)engine=innodb;

create table ganaderia(codigo integer not null primary key,nomgana varchar(30) not null,dirgana varchar(40) not null, calidad varchar(20) not null,antiguedad date not null)engine=innodb;

create table premios(id_premios integer not null primary key, numorejas integer,numrabos integer,saliopuerta bool not null)engine=innodb;

create table apoderado(rfcapo varchar(20) not null primary key,nombre varchar(30),dirapod varchar(40),telapod integer not null)engine=innodb;

create table corrida(numorden integer not null primary key, feria varchar(30) not null, anio date not null,numplaza integer not null,
index(numplaza),
foreign key(numplaza) references plaza(numplaza)
on update restrict
)engine=innodb;

create table torero(rfct varchar(20) not null primary key,nombre varchar(40),apodo varchar(30) not null,fechalter date,
numorden integer not null,id_premios integer not null,rfcapo varchar(20) not null,
index (numorden),
foreign key(numorden) references corrida(numorden)
on delete cascade
on update cascade,
index (id_premios),
foreign key(id_premios) references premios(id_premios)
on delete cascade
on update cascade,
index (rfcapo),
foreign key(rfcapo) references apoderado(rfcapo)
on delete cascade
on update cascade
)engine=innodb;

create table toro(codtoro integer not null primary key,nombre_toro varchar(30) not null, anonaci date not null,colortoro varchar(20),ordtoreo integer not null,
numorden integer not null,codigo integer not null,
index (numorden),
foreign key (numorden) references corrida(numorden)
on delete restrict
on update restrict,
index (codigo),
foreign key (codigo) references ganaderia(codigo)
on delete cascade
on update cascade
)engine=innodb;

create table padrino(rfcp varchar(20) not null primary key,direccion varchar(45) not null,telefono integer,nombre varchar(20) not null,
rfct varchar(20) not null,
index (rfct),
foreign key (rfct) references torero(rfct)
on delete cascade
on update cascade
)engine=innodb;