drop database if exists airdb;
create database airdb;
use airdb;
create table aerei (
	id smallint primary key auto_increment,
	produttore char(20) not null,
	modello char(20) not null,
	dataimm date,
	numposti smallint );

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

