Solución á tarefa Modificar táboas empregando a sentenza Alter

Tarefa 1.1

1 -- 1.1
2 alter table fabricante
3 	add column email varchar(150) default null,
4 	add cif char(9) not null after idFabricante;

Tarefa 1.2

1 -- 1.2
2 alter table fabricante
3 	drop primary key,
4 	add primary key (cif),
5 	drop column idFabricante;

Tarefa 1.3

1 -- 1.3
2 alter table grupo
3 	change cache custo mediumint unsigned not null,
4 	alter dataFormacion set default '0000-00-00';