DROP TABLE exos_2_type;
CREATE TABLE exos_2_type
(
num_type int primary key auto_increment,
lib_type varchar(50)
);

DROP TABLE exos_2;
CREATE TABLE exos_2 
(
num_eleve int primary key auto_increment,
nom_eleve varchar(50),
prenom_eleve varchar(50),
num_type int references type(num_type)
);

insert into exos_2_type values ('1','Elève IG1');
insert into exos_2_type values ('2','Elève IG2');
insert into exos_2_type values ('3','Professeur');

insert into exos_2 values ('','MARIN','Jean-Christophe','2');
insert into exos_2 values ('','DUMONT','Xavier','2');
insert into exos_2 values ('','LEMMA','Jean-Baptiste','2');
insert into exos_2 values ('','VILLA','Jérome','2');
insert into exos_2 values ('','THOMASSIN','Gilles','3');