drop table if exists aerei;
create table aerei (
  id int primary key auto_increment,
  produttore char(20) not null,
  modello char(20) not null,
  dataimm date,
  numposti int,
  commento text
);

insert into aerei values (null,'boeing','747','2000-10-10',350,''),
                         (null,'MDD','Super80',null,null,'prova');
