--
-- Host: localhost    Database: airdb
-- ------------------------------------------------------


--
-- Current Database: `airdb`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `airdb` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `airdb`;

--
-- Table structure for table `aerei`
--

CREATE TABLE `aerei` (
  `id` smallint(6) NOT NULL auto_increment,
  `produttore` char(20) NOT NULL default '',
  `modello` char(20) NOT NULL default '',
  `dataimm` date default NULL,
  `numposti` smallint(6) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `aerei`
--


INSERT INTO `aerei` VALUES (1,'boeing','747','2000-10-10',350),(2,'MDD','Super80',NULL,150),(3,'boeing','747m','2000-01-01',200),(4,'boeing','747m','2000-01-01',200),(5,'airbus','b200',NULL,NULL),(6,'xyz','concorde','1980-07-03',110),(7,'xyz','columbia shuttle','1999-06-04',5),(8,'boeing','B600','1920-02-23',0);

--
-- Table structure for table `aeroporti`
--

CREATE TABLE `aeroporti` (
  `id` char(3) NOT NULL default '',
  `nome` varchar(100) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `aeroporti`
--


INSERT INTO `aeroporti` VALUES ('TRS','Trieste'),('CTA','Catania'),('MXP','Milano Malpensa'),('JFK','New York City JFK'),('PSC','Pescara');

--
-- Table structure for table `posti`
--

CREATE TABLE `posti` (
  `idaereo` smallint(6) NOT NULL default '0',
  `idposto` smallint(6) NOT NULL default '0',
  `classe` enum('business','first','economy') default NULL,
  `collocazione` enum('finestrino','corridoio') default NULL,
  PRIMARY KEY  (`idaereo`,`idposto`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `posti`
--


INSERT INTO `posti` VALUES (1,1,'first','finestrino'),(1,2,'first','corridoio'),(1,3,'first','corridoio'),(1,4,'first','corridoio'),(1,5,'first','corridoio'),(1,6,'first','finestrino'),(1,7,'first','finestrino'),(1,8,'first','corridoio'),(1,9,'first','corridoio'),(1,10,'first','corridoio'),(1,11,'first','corridoio'),(1,12,'first','finestrino'),(1,13,'first','finestrino'),(1,14,'first','corridoio'),(1,15,'first','corridoio'),(1,16,'first','corridoio'),(1,17,'first','corridoio'),(1,18,'first','finestrino'),(1,19,'first','finestrino'),(1,20,'first','corridoio'),(1,21,'first','corridoio'),(1,22,'first','corridoio'),(1,23,'first','corridoio'),(1,24,'first','finestrino'),(1,25,'first','finestrino'),(1,26,'first','corridoio'),(1,27,'first','corridoio'),(1,28,'first','corridoio'),(1,29,'first','corridoio'),(1,30,'first','finestrino'),(1,31,'first','finestrino'),(1,32,'first','corridoio'),(1,33,'first','corridoio'),(1,34,'first','corridoio'),(1,35,'first','corridoio'),(1,36,'first','finestrino'),(1,37,'first','finestrino'),(1,38,'first','corridoio'),(1,39,'first','corridoio'),(1,40,'first','corridoio'),(1,41,'business','corridoio'),(1,42,'business','finestrino'),(1,43,'business','finestrino'),(1,44,'business','corridoio'),(1,45,'business','corridoio'),(1,46,'business','corridoio'),(1,47,'business','corridoio'),(1,48,'business','finestrino'),(1,49,'business','finestrino'),(1,50,'business','corridoio'),(1,51,'business','corridoio'),(1,52,'business','corridoio'),(1,53,'business','corridoio'),(1,54,'business','finestrino'),(1,55,'business','finestrino'),(1,56,'business','corridoio'),(1,57,'business','corridoio'),(1,58,'business','corridoio'),(1,59,'business','corridoio'),(1,60,'business','finestrino'),(1,61,'business','finestrino'),(1,62,'business','corridoio'),(1,63,'business','corridoio'),(1,64,'business','corridoio'),(1,65,'business','corridoio'),(1,66,'business','finestrino'),(1,67,'business','finestrino'),(1,68,'business','corridoio'),(1,69,'business','corridoio'),(1,70,'business','corridoio'),(1,71,'business','corridoio'),(1,72,'business','finestrino'),(1,73,'business','finestrino'),(1,74,'business','corridoio'),(1,75,'business','corridoio'),(1,76,'business','corridoio'),(1,77,'business','corridoio'),(1,78,'business','finestrino'),(1,79,'business','finestrino'),(1,80,'business','corridoio'),(1,81,'business','corridoio'),(1,82,'business','corridoio'),(1,83,'business','corridoio'),(1,84,'business','finestrino'),(1,85,'business','finestrino'),(1,86,'business','corridoio'),(1,87,'business','corridoio'),(1,88,'business','corridoio'),(1,89,'business','corridoio'),(1,90,'business','finestrino'),(1,91,'business','finestrino'),(1,92,'business','corridoio'),(1,93,'business','corridoio'),(1,94,'business','corridoio'),(1,95,'business','corridoio'),(1,96,'business','finestrino'),(1,97,'business','finestrino'),(1,98,'business','corridoio'),(1,99,'business','corridoio'),(1,100,'business','corridoio'),(1,101,'economy','corridoio'),(1,102,'economy','finestrino'),(1,103,'economy','finestrino'),(1,104,'economy','corridoio'),(1,105,'economy','corridoio'),(1,106,'economy','corridoio'),(1,107,'economy','corridoio'),(1,108,'economy','finestrino'),(1,109,'economy','finestrino'),(1,110,'economy','corridoio'),(1,111,'economy','corridoio'),(1,112,'economy','corridoio'),(1,113,'economy','corridoio'),(1,114,'economy','finestrino'),(1,115,'economy','finestrino'),(1,116,'economy','corridoio'),(1,117,'economy','corridoio'),(1,118,'economy','corridoio'),(1,119,'economy','corridoio'),(1,120,'economy','finestrino'),(1,121,'economy','finestrino'),(1,122,'economy','corridoio'),(1,123,'economy','corridoio'),(1,124,'economy','corridoio'),(1,125,'economy','corridoio'),(1,126,'economy','finestrino'),(1,127,'economy','finestrino'),(1,128,'economy','corridoio'),(1,129,'economy','corridoio'),(1,130,'economy','corridoio'),(1,131,'economy','corridoio'),(1,132,'economy','finestrino'),(1,133,'economy','finestrino'),(1,134,'economy','corridoio'),(1,135,'economy','corridoio'),(1,136,'economy','corridoio'),(1,137,'economy','corridoio'),(1,138,'economy','finestrino'),(1,139,'economy','finestrino'),(1,140,'economy','corridoio'),(1,141,'economy','corridoio'),(1,142,'economy','corridoio'),(1,143,'economy','corridoio'),(1,144,'economy','finestrino'),(1,145,'economy','finestrino'),(1,146,'economy','corridoio'),(1,147,'economy','corridoio'),(1,148,'economy','corridoio'),(1,149,'economy','corridoio'),(1,150,'economy','finestrino'),(1,151,'economy','finestrino'),(1,152,'economy','corridoio'),(1,153,'economy','corridoio'),(1,154,'economy','corridoio'),(1,155,'economy','corridoio'),(1,156,'economy','finestrino'),(1,157,'economy','finestrino'),(1,158,'economy','corridoio'),(1,159,'economy','corridoio'),(1,160,'economy','corridoio'),(1,161,'economy','corridoio'),(1,162,'economy','finestrino'),(1,163,'economy','finestrino'),(1,164,'economy','corridoio'),(1,165,'economy','corridoio'),(1,166,'economy','corridoio'),(1,167,'economy','corridoio'),(1,168,'economy','finestrino'),(1,169,'economy','finestrino'),(1,170,'economy','corridoio'),(1,171,'economy','corridoio'),(1,172,'economy','corridoio'),(1,173,'economy','corridoio'),(1,174,'economy','finestrino'),(1,175,'economy','finestrino'),(1,176,'economy','corridoio'),(1,177,'economy','corridoio'),(1,178,'economy','corridoio'),(1,179,'economy','corridoio'),(1,180,'economy','finestrino'),(1,181,'economy','finestrino'),(1,182,'economy','corridoio'),(1,183,'economy','corridoio'),(1,184,'economy','corridoio'),(1,185,'economy','corridoio'),(1,186,'economy','finestrino'),(1,187,'economy','finestrino'),(1,188,'economy','corridoio'),(1,189,'economy','corridoio'),(1,190,'economy','corridoio'),(1,191,'economy','corridoio'),(1,192,'economy','finestrino'),(1,193,'economy','finestrino'),(1,194,'economy','corridoio'),(1,195,'economy','corridoio'),(1,196,'economy','corridoio'),(1,197,'economy','corridoio'),(1,198,'economy','finestrino'),(1,199,'economy','finestrino'),(1,200,'economy','corridoio'),(1,201,'economy','corridoio'),(1,202,'economy','corridoio'),(1,203,'economy','corridoio'),(1,204,'economy','finestrino'),(1,205,'economy','finestrino'),(1,206,'economy','corridoio'),(1,207,'economy','corridoio'),(1,208,'economy','corridoio'),(1,209,'economy','corridoio'),(1,210,'economy','finestrino'),(1,211,'economy','finestrino'),(1,212,'economy','corridoio'),(1,213,'economy','corridoio'),(1,214,'economy','corridoio'),(1,215,'economy','corridoio'),(1,216,'economy','finestrino'),(1,217,'economy','finestrino'),(1,218,'economy','corridoio'),(1,219,'economy','corridoio'),(1,220,'economy','corridoio'),(1,221,'economy','corridoio'),(1,222,'economy','finestrino'),(1,223,'economy','finestrino'),(1,224,'economy','corridoio'),(1,225,'economy','corridoio'),(1,226,'economy','corridoio'),(1,227,'economy','corridoio'),(1,228,'economy','finestrino'),(1,229,'economy','finestrino'),(1,230,'economy','corridoio'),(1,231,'economy','corridoio'),(1,232,'economy','corridoio'),(1,233,'economy','corridoio'),(1,234,'economy','finestrino'),(1,235,'economy','finestrino'),(1,236,'economy','corridoio'),(1,237,'economy','corridoio'),(1,238,'economy','corridoio'),(1,239,'economy','corridoio'),(1,240,'economy','finestrino'),(1,241,'economy','finestrino'),(1,242,'economy','corridoio'),(1,243,'economy','corridoio'),(1,244,'economy','corridoio'),(1,245,'economy','corridoio'),(1,246,'economy','finestrino'),(1,247,'economy','finestrino'),(1,248,'economy','corridoio'),(1,249,'economy','corridoio'),(1,250,'economy','corridoio'),(1,251,'economy','corridoio'),(1,252,'economy','finestrino'),(1,253,'economy','finestrino'),(1,254,'economy','corridoio'),(1,255,'economy','corridoio'),(1,256,'economy','corridoio'),(1,257,'economy','corridoio'),(1,258,'economy','finestrino'),(1,259,'economy','finestrino'),(1,260,'economy','corridoio'),(1,261,'economy','corridoio'),(1,262,'economy','corridoio'),(1,263,'economy','corridoio'),(1,264,'economy','finestrino'),(1,265,'economy','finestrino'),(1,266,'economy','corridoio'),(1,267,'economy','corridoio'),(1,268,'economy','corridoio'),(1,269,'economy','corridoio'),(1,270,'economy','finestrino'),(1,271,'economy','finestrino'),(1,272,'economy','corridoio'),(1,273,'economy','corridoio'),(1,274,'economy','corridoio'),(1,275,'economy','corridoio'),(1,276,'economy','finestrino'),(1,277,'economy','finestrino'),(1,278,'economy','corridoio'),(1,279,'economy','corridoio'),(1,280,'economy','corridoio'),(1,281,'economy','corridoio'),(1,282,'economy','finestrino'),(1,283,'economy','finestrino'),(1,284,'economy','corridoio'),(1,285,'economy','corridoio'),(1,286,'economy','corridoio'),(1,287,'economy','corridoio'),(1,288,'economy','finestrino'),(1,289,'economy','finestrino'),(1,290,'economy','corridoio'),(1,291,'economy','corridoio'),(1,292,'economy','corridoio'),(1,293,'economy','corridoio'),(1,294,'economy','finestrino'),(1,295,'economy','finestrino'),(1,296,'economy','corridoio'),(1,297,'economy','corridoio'),(1,298,'economy','corridoio'),(1,299,'economy','corridoio'),(1,300,'economy','finestrino'),(1,301,'economy','finestrino'),(1,302,'economy','corridoio'),(1,303,'economy','corridoio'),(1,304,'economy','corridoio'),(1,305,'economy','corridoio'),(1,306,'economy','finestrino'),(1,307,'economy','finestrino'),(1,308,'economy','corridoio'),(1,309,'economy','corridoio'),(1,310,'economy','corridoio'),(1,311,'economy','corridoio'),(1,312,'economy','finestrino'),(1,313,'economy','finestrino'),(1,314,'economy','corridoio'),(1,315,'economy','corridoio'),(1,316,'economy','corridoio'),(1,317,'economy','corridoio'),(1,318,'economy','finestrino'),(1,319,'economy','finestrino'),(1,320,'economy','corridoio'),(1,321,'economy','corridoio'),(1,322,'economy','corridoio'),(1,323,'economy','corridoio'),(1,324,'economy','finestrino'),(1,325,'economy','finestrino'),(1,326,'economy','corridoio'),(1,327,'economy','corridoio'),(1,328,'economy','corridoio'),(1,329,'economy','corridoio'),(1,330,'economy','finestrino'),(1,331,'economy','finestrino'),(1,332,'economy','corridoio'),(1,333,'economy','corridoio'),(1,334,'economy','corridoio'),(1,335,'economy','corridoio'),(1,336,'economy','finestrino'),(1,337,'economy','finestrino'),(1,338,'economy','corridoio'),(1,339,'economy','corridoio'),(1,340,'economy','corridoio'),(1,341,'economy','corridoio'),(1,342,'economy','finestrino'),(1,343,'economy','finestrino'),(1,344,'economy','corridoio'),(1,345,'economy','corridoio'),(1,346,'economy','corridoio'),(1,347,'economy','corridoio'),(1,348,'economy','finestrino'),(1,349,'economy','finestrino'),(1,350,'economy','corridoio'),(3,1,'first','finestrino'),(3,2,'first','corridoio'),(3,3,'first','corridoio'),(3,4,'first','corridoio'),(3,5,'first','corridoio'),(3,6,'first','finestrino'),(3,7,'first','finestrino'),(3,8,'first','corridoio'),(3,9,'first','corridoio'),(3,10,'first','corridoio'),(3,11,'business','corridoio'),(3,12,'business','finestrino'),(3,13,'business','finestrino'),(3,14,'business','corridoio'),(3,15,'business','corridoio'),(3,16,'business','corridoio'),(3,17,'business','corridoio'),(3,18,'business','finestrino'),(3,19,'business','finestrino'),(3,20,'business','corridoio'),(3,21,'business','corridoio'),(3,22,'business','corridoio'),(3,23,'business','corridoio'),(3,24,'business','finestrino'),(3,25,'business','finestrino'),(3,26,'business','corridoio'),(3,27,'business','corridoio'),(3,28,'business','corridoio'),(3,29,'business','corridoio'),(3,30,'business','finestrino'),(3,31,'economy','finestrino'),(3,32,'economy','corridoio'),(3,33,'economy','corridoio'),(3,34,'economy','corridoio'),(3,35,'economy','corridoio'),(3,36,'economy','finestrino'),(3,37,'economy','finestrino'),(3,38,'economy','corridoio'),(3,39,'economy','corridoio'),(3,40,'economy','corridoio'),(3,41,'economy','corridoio'),(3,42,'economy','finestrino'),(3,43,'economy','finestrino'),(3,44,'economy','corridoio'),(3,45,'economy','corridoio'),(3,46,'economy','corridoio'),(3,47,'economy','corridoio'),(3,48,'economy','finestrino'),(3,49,'economy','finestrino'),(3,50,'economy','corridoio'),(3,51,'economy','corridoio'),(3,52,'economy','corridoio'),(3,53,'economy','corridoio'),(3,54,'economy','finestrino'),(3,55,'economy','finestrino'),(3,56,'economy','corridoio'),(3,57,'economy','corridoio'),(3,58,'economy','corridoio'),(3,59,'economy','corridoio'),(3,60,'economy','finestrino'),(3,61,'economy','finestrino'),(3,62,'economy','corridoio'),(3,63,'economy','corridoio'),(3,64,'economy','corridoio'),(3,65,'economy','corridoio'),(3,66,'economy','finestrino'),(3,67,'economy','finestrino'),(3,68,'economy','corridoio'),(3,69,'economy','corridoio'),(3,70,'economy','corridoio'),(3,71,'economy','corridoio'),(3,72,'economy','finestrino'),(3,73,'economy','finestrino'),(3,74,'economy','corridoio'),(3,75,'economy','corridoio'),(3,76,'economy','corridoio'),(3,77,'economy','corridoio'),(3,78,'economy','finestrino'),(3,79,'economy','finestrino'),(3,80,'economy','corridoio'),(3,81,'economy','corridoio'),(3,82,'economy','corridoio'),(3,83,'economy','corridoio'),(3,84,'economy','finestrino'),(3,85,'economy','finestrino'),(3,86,'economy','corridoio'),(3,87,'economy','corridoio'),(3,88,'economy','corridoio'),(3,89,'economy','corridoio'),(3,90,'economy','finestrino'),(3,91,'economy','finestrino'),(3,92,'economy','corridoio'),(3,93,'economy','corridoio'),(3,94,'economy','corridoio'),(3,95,'economy','corridoio'),(3,96,'economy','finestrino'),(3,97,'economy','finestrino'),(3,98,'economy','corridoio'),(3,99,'economy','corridoio'),(3,100,'economy','corridoio'),(3,101,'economy','corridoio'),(3,102,'economy','finestrino'),(3,103,'economy','finestrino'),(3,104,'economy','corridoio'),(3,105,'economy','corridoio'),(3,106,'economy','corridoio'),(3,107,'economy','corridoio'),(3,108,'economy','finestrino'),(3,109,'economy','finestrino'),(3,110,'economy','corridoio'),(3,111,'economy','corridoio'),(3,112,'economy','corridoio'),(3,113,'economy','corridoio'),(3,114,'economy','finestrino'),(3,115,'economy','finestrino'),(3,116,'economy','corridoio'),(3,117,'economy','corridoio'),(3,118,'economy','corridoio'),(3,119,'economy','corridoio'),(3,120,'economy','finestrino'),(3,121,'economy','finestrino'),(3,122,'economy','corridoio'),(3,123,'economy','corridoio'),(3,124,'economy','corridoio'),(3,125,'economy','corridoio'),(3,126,'economy','finestrino'),(3,127,'economy','finestrino'),(3,128,'economy','corridoio'),(3,129,'economy','corridoio'),(3,130,'economy','corridoio'),(3,131,'economy','corridoio'),(3,132,'economy','finestrino'),(3,133,'economy','finestrino'),(3,134,'economy','corridoio'),(3,135,'economy','corridoio'),(3,136,'economy','corridoio'),(3,137,'economy','corridoio'),(3,138,'economy','finestrino'),(3,139,'economy','finestrino'),(3,140,'economy','corridoio'),(3,141,'economy','corridoio'),(3,142,'economy','corridoio'),(3,143,'economy','corridoio'),(3,144,'economy','finestrino'),(3,145,'economy','finestrino'),(3,146,'economy','corridoio'),(3,147,'economy','corridoio'),(3,148,'economy','corridoio'),(3,149,'economy','corridoio'),(3,150,'economy','finestrino'),(3,151,'economy','finestrino'),(3,152,'economy','corridoio'),(3,153,'economy','corridoio'),(3,154,'economy','corridoio'),(3,155,'economy','corridoio'),(3,156,'economy','finestrino'),(3,157,'economy','finestrino'),(3,158,'economy','corridoio'),(3,159,'economy','corridoio'),(3,160,'economy','corridoio'),(3,161,'economy','corridoio'),(3,162,'economy','finestrino'),(3,163,'economy','finestrino'),(3,164,'economy','corridoio'),(3,165,'economy','corridoio'),(3,166,'economy','corridoio'),(3,167,'economy','corridoio'),(3,168,'economy','finestrino'),(3,169,'economy','finestrino'),(3,170,'economy','corridoio'),(3,171,'economy','corridoio'),(3,172,'economy','corridoio'),(3,173,'economy','corridoio'),(3,174,'economy','finestrino'),(3,175,'economy','finestrino'),(3,176,'economy','corridoio'),(3,177,'economy','corridoio'),(3,178,'economy','corridoio'),(3,179,'economy','corridoio'),(3,180,'economy','finestrino'),(3,181,'economy','finestrino'),(3,182,'economy','corridoio'),(3,183,'economy','corridoio'),(3,184,'economy','corridoio'),(3,185,'economy','corridoio'),(3,186,'economy','finestrino'),(3,187,'economy','finestrino'),(3,188,'economy','corridoio'),(3,189,'economy','corridoio'),(3,190,'economy','corridoio'),(3,191,'economy','corridoio'),(3,192,'economy','finestrino'),(3,193,'economy','finestrino'),(3,194,'economy','corridoio'),(3,195,'economy','corridoio'),(3,196,'economy','corridoio'),(3,197,'economy','corridoio'),(3,198,'economy','finestrino'),(3,199,'economy','finestrino'),(3,200,'economy','corridoio'),(4,1,'first','finestrino'),(4,2,'first','corridoio'),(4,3,'first','corridoio'),(4,4,'first','corridoio'),(4,5,'first','corridoio'),(4,6,'first','finestrino'),(4,7,'first','corridoio'),(4,8,'first','corridoio'),(4,9,'first','corridoio'),(4,10,'first','corridoio'),(4,11,'business','finestrino'),(4,12,'business','corridoio'),(4,13,'business','corridoio'),(4,14,'business','corridoio'),(4,15,'business','corridoio'),(4,16,'business','finestrino'),(4,17,'business','corridoio'),(4,18,'business','corridoio'),(4,19,'business','corridoio'),(4,20,'business','corridoio'),(4,21,'business','finestrino'),(4,22,'business','corridoio'),(4,23,'business','corridoio'),(4,24,'business','corridoio'),(4,25,'business','corridoio'),(4,26,'business','finestrino'),(4,27,'business','corridoio'),(4,28,'business','corridoio'),(4,29,'business','corridoio'),(4,30,'business','corridoio'),(4,31,'economy','finestrino'),(4,32,'economy','corridoio'),(4,33,'economy','corridoio'),(4,34,'economy','corridoio'),(4,35,'economy','corridoio'),(4,36,'economy','finestrino'),(4,37,'economy','corridoio'),(4,38,'economy','corridoio'),(4,39,'economy','corridoio'),(4,40,'economy','corridoio'),(4,41,'economy','finestrino'),(4,42,'economy','corridoio'),(4,43,'economy','corridoio'),(4,44,'economy','corridoio'),(4,45,'economy','corridoio'),(4,46,'economy','finestrino'),(4,47,'economy','corridoio'),(4,48,'economy','corridoio'),(4,49,'economy','corridoio'),(4,50,'economy','corridoio'),(4,51,'economy','finestrino'),(4,52,'economy','corridoio'),(4,53,'economy','corridoio'),(4,54,'economy','corridoio'),(4,55,'economy','corridoio'),(4,56,'economy','finestrino'),(4,57,'economy','corridoio'),(4,58,'economy','corridoio'),(4,59,'economy','corridoio'),(4,60,'economy','corridoio'),(4,61,'economy','finestrino'),(4,62,'economy','corridoio'),(4,63,'economy','corridoio'),(4,64,'economy','corridoio'),(4,65,'economy','corridoio'),(4,66,'economy','finestrino'),(4,67,'economy','corridoio'),(4,68,'economy','corridoio'),(4,69,'economy','corridoio'),(4,70,'economy','corridoio'),(4,71,'economy','finestrino'),(4,72,'economy','corridoio'),(4,73,'economy','corridoio'),(4,74,'economy','corridoio'),(4,75,'economy','corridoio'),(4,76,'economy','finestrino'),(4,77,'economy','corridoio'),(4,78,'economy','corridoio'),(4,79,'economy','corridoio'),(4,80,'economy','corridoio'),(4,81,'economy','finestrino'),(4,82,'economy','corridoio'),(4,83,'economy','corridoio'),(4,84,'economy','corridoio'),(4,85,'economy','corridoio'),(4,86,'economy','finestrino'),(4,87,'economy','corridoio'),(4,88,'economy','corridoio'),(4,89,'economy','corridoio'),(4,90,'economy','corridoio'),(4,91,'economy','finestrino'),(4,92,'economy','corridoio'),(4,93,'economy','corridoio'),(4,94,'economy','corridoio'),(4,95,'economy','corridoio'),(4,96,'economy','finestrino'),(4,97,'economy','corridoio'),(4,98,'economy','corridoio'),(4,99,'economy','corridoio'),(4,100,'economy','corridoio'),(4,101,'economy','finestrino'),(4,102,'economy','corridoio'),(4,103,'economy','corridoio'),(4,104,'economy','corridoio'),(4,105,'economy','corridoio'),(4,106,'economy','finestrino'),(4,107,'economy','corridoio'),(4,108,'economy','corridoio'),(4,109,'economy','corridoio'),(4,110,'economy','corridoio'),(4,111,'economy','finestrino'),(4,112,'economy','corridoio'),(4,113,'economy','corridoio'),(4,114,'economy','corridoio'),(4,115,'economy','corridoio'),(4,116,'economy','finestrino'),(4,117,'economy','corridoio'),(4,118,'economy','corridoio'),(4,119,'economy','corridoio'),(4,120,'economy','corridoio'),(4,121,'economy','finestrino'),(4,122,'economy','corridoio'),(4,123,'economy','corridoio'),(4,124,'economy','corridoio'),(4,125,'economy','corridoio'),(4,126,'economy','finestrino'),(4,127,'economy','corridoio'),(4,128,'economy','corridoio'),(4,129,'economy','corridoio'),(4,130,'economy','corridoio'),(4,131,'economy','finestrino'),(4,132,'economy','corridoio'),(4,133,'economy','corridoio'),(4,134,'economy','corridoio'),(4,135,'economy','corridoio'),(4,136,'economy','finestrino'),(4,137,'economy','corridoio'),(4,138,'economy','corridoio'),(4,139,'economy','corridoio'),(4,140,'economy','corridoio'),(4,141,'economy','finestrino'),(4,142,'economy','corridoio'),(4,143,'economy','corridoio'),(4,144,'economy','corridoio'),(4,145,'economy','corridoio'),(4,146,'economy','finestrino'),(4,147,'economy','corridoio'),(4,148,'economy','corridoio'),(4,149,'economy','corridoio'),(4,150,'economy','corridoio'),(4,151,'economy','finestrino'),(4,152,'economy','corridoio'),(4,153,'economy','corridoio'),(4,154,'economy','corridoio'),(4,155,'economy','corridoio'),(4,156,'economy','finestrino'),(4,157,'economy','corridoio'),(4,158,'economy','corridoio'),(4,159,'economy','corridoio'),(4,160,'economy','corridoio'),(4,161,'economy','finestrino'),(4,162,'economy','corridoio'),(4,163,'economy','corridoio'),(4,164,'economy','corridoio'),(4,165,'economy','corridoio'),(4,166,'economy','finestrino'),(4,167,'economy','corridoio'),(4,168,'economy','corridoio'),(4,169,'economy','corridoio'),(4,170,'economy','corridoio'),(4,171,'economy','finestrino'),(4,172,'economy','corridoio'),(4,173,'economy','corridoio'),(4,174,'economy','corridoio'),(4,175,'economy','corridoio'),(4,176,'economy','finestrino'),(4,177,'economy','corridoio'),(4,178,'economy','corridoio'),(4,179,'economy','corridoio'),(4,180,'economy','corridoio'),(4,181,'economy','finestrino'),(4,182,'economy','corridoio'),(4,183,'economy','corridoio'),(4,184,'economy','corridoio'),(4,185,'economy','corridoio'),(4,186,'economy','finestrino'),(4,187,'economy','corridoio'),(4,188,'economy','corridoio'),(4,189,'economy','corridoio'),(4,190,'economy','corridoio'),(4,191,'economy','finestrino'),(4,192,'economy','corridoio'),(4,193,'economy','corridoio'),(4,194,'economy','corridoio'),(4,195,'economy','corridoio'),(4,196,'economy','finestrino'),(4,197,'economy','corridoio'),(4,198,'economy','corridoio'),(4,199,'economy','corridoio'),(4,200,'economy','corridoio'),(2,1,'business','finestrino'),(2,2,'business','corridoio'),(2,3,'business','corridoio'),(2,4,'business','corridoio'),(2,5,'business','finestrino'),(2,6,'business','corridoio'),(2,7,'business','corridoio'),(2,8,'business','corridoio'),(2,9,'business','finestrino'),(2,10,'business','corridoio'),(2,11,'business','corridoio'),(2,12,'business','corridoio'),(2,13,'business','finestrino'),(2,14,'business','corridoio'),(2,15,'business','corridoio'),(2,16,'business','corridoio'),(2,17,'business','finestrino'),(2,18,'business','corridoio'),(2,19,'business','corridoio'),(2,20,'business','corridoio'),(2,21,'economy','finestrino'),(2,22,'economy','corridoio'),(2,23,'economy','corridoio'),(2,24,'economy','corridoio'),(2,25,'economy','finestrino'),(2,26,'economy','corridoio'),(2,27,'economy','corridoio'),(2,28,'economy','corridoio'),(2,29,'economy','finestrino'),(2,30,'economy','corridoio'),(2,31,'economy','corridoio'),(2,32,'economy','corridoio'),(2,33,'economy','finestrino'),(2,34,'economy','corridoio'),(2,35,'economy','corridoio'),(2,36,'economy','corridoio'),(2,37,'economy','finestrino'),(2,38,'economy','corridoio'),(2,39,'economy','corridoio'),(2,40,'economy','corridoio'),(2,41,'economy','finestrino'),(2,42,'economy','corridoio'),(2,43,'economy','corridoio'),(2,44,'economy','corridoio'),(2,45,'economy','finestrino'),(2,46,'economy','corridoio'),(2,47,'economy','corridoio'),(2,48,'economy','corridoio'),(2,49,'economy','finestrino'),(2,50,'economy','corridoio'),(2,51,'economy','corridoio'),(2,52,'economy','corridoio'),(2,53,'economy','finestrino'),(2,54,'economy','corridoio'),(2,55,'economy','corridoio'),(2,56,'economy','corridoio'),(2,57,'economy','finestrino'),(2,58,'economy','corridoio'),(2,59,'economy','corridoio'),(2,60,'economy','corridoio'),(2,61,'economy','finestrino'),(2,62,'economy','corridoio'),(2,63,'economy','corridoio'),(2,64,'economy','corridoio'),(2,65,'economy','finestrino'),(2,66,'economy','corridoio'),(2,67,'economy','corridoio'),(2,68,'economy','corridoio'),(2,69,'economy','finestrino'),(2,70,'economy','corridoio'),(2,71,'economy','corridoio'),(2,72,'economy','corridoio'),(2,73,'economy','finestrino'),(2,74,'economy','corridoio'),(2,75,'economy','corridoio'),(2,76,'economy','corridoio'),(2,77,'economy','finestrino'),(2,78,'economy','corridoio'),(2,79,'economy','corridoio'),(2,80,'economy','corridoio'),(2,81,'economy','finestrino'),(2,82,'economy','corridoio'),(2,83,'economy','corridoio'),(2,84,'economy','corridoio'),(2,85,'economy','finestrino'),(2,86,'economy','corridoio'),(2,87,'economy','corridoio'),(2,88,'economy','corridoio'),(2,89,'economy','finestrino'),(2,90,'economy','corridoio'),(2,91,'economy','corridoio'),(2,92,'economy','corridoio'),(2,93,'economy','finestrino'),(2,94,'economy','corridoio'),(2,95,'economy','corridoio'),(2,96,'economy','corridoio'),(2,97,'economy','finestrino'),(2,98,'economy','corridoio'),(2,99,'economy','corridoio'),(2,100,'economy','corridoio'),(2,101,'economy','finestrino'),(2,102,'economy','corridoio'),(2,103,'economy','corridoio'),(2,104,'economy','corridoio'),(2,105,'economy','finestrino'),(2,106,'economy','corridoio'),(2,107,'economy','corridoio'),(2,108,'economy','corridoio'),(2,109,'economy','finestrino'),(2,110,'economy','corridoio'),(2,111,'economy','corridoio'),(2,112,'economy','corridoio'),(2,113,'economy','finestrino'),(2,114,'economy','corridoio'),(2,115,'economy','corridoio'),(2,116,'economy','corridoio'),(2,117,'economy','finestrino'),(2,118,'economy','corridoio'),(2,119,'economy','corridoio'),(2,120,'economy','corridoio'),(2,121,'economy','finestrino'),(2,122,'economy','corridoio'),(2,123,'economy','corridoio'),(2,124,'economy','corridoio'),(2,125,'economy','finestrino'),(2,126,'economy','corridoio'),(2,127,'economy','corridoio'),(2,128,'economy','corridoio'),(2,129,'economy','finestrino'),(2,130,'economy','corridoio'),(2,131,'economy','corridoio'),(2,132,'economy','corridoio'),(2,133,'economy','finestrino'),(2,134,'economy','corridoio'),(2,135,'economy','corridoio'),(2,136,'economy','corridoio'),(2,137,'economy','finestrino'),(2,138,'economy','corridoio'),(2,139,'economy','corridoio'),(2,140,'economy','corridoio'),(2,141,'economy','finestrino'),(2,142,'economy','corridoio'),(2,143,'economy','corridoio'),(2,144,'economy','corridoio'),(2,145,'economy','finestrino'),(2,146,'economy','corridoio'),(2,147,'economy','corridoio'),(2,148,'economy','corridoio'),(2,149,'economy','finestrino'),(2,150,'economy','corridoio');

--
-- Table structure for table `prenotazioni`
--

CREATE TABLE `prenotazioni` (
  `idvolo` smallint(6) NOT NULL default '0',
  `idposto` smallint(6) NOT NULL default '0',
  `nome` varchar(40) default NULL,
  PRIMARY KEY  (`idvolo`,`idposto`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `prenotazioni`
--


INSERT INTO `prenotazioni` VALUES (1,2,'Barbecued Informers'),(1,5,'Spots Gnawing'),(1,7,'Acquitter Navies'),(1,8,'Introduces Senators'),(1,9,'Harping Connubial'),(1,11,'Pigeons Parameterizing'),(1,12,'Astuteness Mutations'),(1,14,'Emulator Ascending'),(1,17,'Goose Jesuitized'),(1,18,'Bacterium Essentials'),(1,20,'Chillier Centering'),(1,22,'Overtakers Skinning'),(1,27,'Pistol Pails'),(1,32,'Honing Ready'),(1,33,'Constituting Rand'),(1,35,'Recombine Hereinafter'),(1,36,'Anachronisms Adapt'),(1,38,'Whatsoever Relabelling'),(1,40,'Scanner Promised'),(1,42,'Aerodynamics Diphthong'),(1,44,'Questioners Disconnects'),(1,45,'Lottery Microsystems'),(1,46,'Massive Amelioration'),(1,47,'Chemically Hoots'),(1,48,'Clods Brigham'),(1,50,'Groveled Entailed'),(1,51,'Legends Crowds'),(1,52,'Fritz Conditioned'),(1,53,'Fare Engenders'),(1,54,'Nonexistent Abscissa'),(1,55,'Abridges Angers'),(1,56,'Cheerleader Colonizers'),(1,60,'Status Staging'),(1,61,'Sanctity Profit'),(1,64,'Falsifies Unanalyzable'),(1,66,'Goddess Morrill'),(1,68,'Wasps Bunkhouses'),(1,70,'Peanut Ubiquitously'),(1,71,'Faltered Depicts'),(1,72,'Segmentation Kenning'),(1,73,'Urgently Restatement'),(1,75,'Finalizing Dialysis'),(1,77,'Veiled Bargain'),(1,78,'Pruners Nobility'),(1,79,'Piled Secretes'),(1,80,'Corinthianizes Charities'),(1,81,'Biosynthesize Hummingbird'),(1,85,'Stroked Remedial'),(1,86,'Anabaptists Garner'),(1,87,'Meritoriously Rants'),(1,89,'Relationships Horseback'),(1,90,'Airliner Assuage'),(1,91,'Sulks Weeps'),(1,92,'Examiner Prisoners'),(1,97,'Apprehensions Materialized'),(1,98,'Crude Pulley'),(1,99,'Anatolia Subsequently'),(1,101,'Insanely Decimate'),(1,102,'Displayer Outcasts'),(1,104,'Yaqui Grinning'),(1,108,'Bloodstains Choking'),(1,109,'Moved Overprinted'),(1,110,'Ophiucus Persianizes'),(1,111,'Feminism Georgian'),(1,112,'Thwarting Ada'),(1,113,'Inventors Standpoint'),(1,115,'Radioed Demultiplexer'),(1,116,'Brunt Recount'),(1,121,'Lang Taught'),(1,122,'Cohabitation Disturbing'),(1,123,'Gilt Repent'),(1,124,'Heavers Talkatively'),(1,125,'Vermont Cot'),(1,127,'Kieffer Holds'),(1,128,'Plausible Login'),(1,131,'Spastic Foams'),(1,133,'Computationally Dateline'),(1,134,'Institutionalizing Botching'),(1,137,'Semitization Submodules'),(1,138,'Michelin Actuating'),(1,140,'Impart Happiest'),(1,141,'Mingled Beseeches'),(1,142,'Labyrinth Crania'),(1,143,'Spreadings Squatting'),(1,147,'Purposely Misery'),(1,149,'Admiral Explained'),(1,151,'Trimmest Wholeheartedly'),(1,152,'Nobel Sufferers'),(1,153,'Derby Identify'),(1,154,'Italianizer Paced'),(1,155,'Preferential Snore'),(1,156,'Walker Dependent'),(1,161,'Runtime Shaves'),(1,166,'Wreathes Desserts'),(1,168,'Obsoleting Theorize'),(1,169,'Break Reemphasizes'),(1,170,'Sardine Wearisome'),(1,171,'Malayize Pettibone'),(1,172,'Geometrical Gassy'),(1,174,'Exchange Wifely'),(1,178,'Journalize Reconnecting'),(1,181,'Juneau Reassigning'),(1,182,'Agonizes Hudson'),(1,183,'Mountaineer Articulations'),(1,184,'Tedium Unharmed'),(1,185,'Readings Magnuson'),(1,186,'Unicycle Toned'),(1,187,'Loathing Uninterrupted'),(1,199,'Starters Washburn'),(1,200,'Populations Americana'),(1,201,'Solon Deceleration'),(1,202,'Capacity Carty'),(1,203,'Declarator Antagonizes'),(1,204,'Sensor Reentering'),(1,205,'Dervish Methodist'),(1,207,'Toilet Parallelizing'),(1,208,'Schumacher Kindest'),(1,209,'Contiguously Operable'),(1,211,'Propane Narbonne'),(1,212,'Stylus Bravado'),(1,213,'Delicacy Soiree'),(1,217,'Plaything Sherwood'),(1,219,'Need Magicians'),(1,220,'Abbe Effect'),(1,221,'Circulated Theatricals'),(1,225,'Tess Newsletters'),(1,226,'Write Encamped'),(1,227,'David Rummel'),(1,228,'Deserter Uncountably'),(1,230,'Montpelier Firearms'),(1,231,'Calculate Accessed'),(1,232,'Welsh Trojan'),(1,233,'Hostess Palfrey'),(1,236,'Eastman Halt'),(1,238,'Commands Coastline'),(1,239,'Assist Poets'),(1,240,'Rasmussen Slipper'),(1,241,'Honeymooned Boldness'),(1,244,'Apportions Bigness'),(1,245,'Tightens Chartering'),(1,247,'Hanger Local'),(1,248,'Freon Clearance'),(1,251,'Partners Eagles'),(1,253,'Belched Who'),(1,257,'Liss Yellowish'),(1,259,'Garages Allowably'),(1,260,'Fiddles Centrifugal'),(1,264,'Oppositeness Reformatory'),(1,266,'Ascends Constantly'),(1,267,'Grids Sparked'),(1,269,'Talk Monarch'),(1,270,'Cunard Glass'),(1,271,'Knuth Decoys'),(1,273,'Start Astute'),(1,276,'Renderings Meandering'),(1,277,'Chuckle Orientalized'),(1,280,'Pagination Improvised'),(1,281,'Platen Harelip'),(1,282,'Hutchinson Reinhardt'),(1,286,'Cuvier House'),(1,287,'Starvation Actuals'),(1,290,'Memorandum Prosper'),(1,298,'Desolations Join'),(1,300,'Ours Gigacycle'),(1,304,'Flawless Iroquois'),(1,305,'Unintelligible Diehard'),(1,306,'Ocean Surrogate'),(1,309,'Diner Nozzle'),(1,311,'Lapping Hamming'),(1,312,'Romances Device'),(1,313,'Eighteen Bargains'),(1,321,'Cuff Novices'),(1,322,'Departments Slanderous'),(1,323,'Nan Doorbell'),(1,324,'Contractions Wormed'),(1,325,'Dispense Autistic'),(1,328,'Rows Funeral'),(1,329,'Amphibious Recalibrating'),(1,330,'Specifications Italianization'),(1,332,'Brasilia Divert'),(1,333,'Bevy Victors'),(1,334,'Britisher Unnecessary'),(1,337,'Fiercer Splitters'),(1,338,'Graduation Gravitation'),(1,340,'Vince Kinder'),(1,342,'Muscovite Enterprises'),(1,344,'Beholds Bend'),(1,346,'Precession Knott'),(1,347,'Cats Discussing'),(1,348,'Regressions Straits'),(1,349,'Crochets Islander'),(2,4,'Unprojected Suburban'),(2,6,'Anchorage Thelma'),(2,10,'Expression Tenth'),(2,14,'Obviations Selectivity'),(2,18,'Attests Dries'),(2,19,'Insatiable Begins'),(2,20,'Comanche Mine'),(2,21,'Lodger Nibbling'),(2,23,'Bloodhounds Educable'),(2,24,'Valuing Ravages'),(2,25,'Hither Pseudo'),(2,29,'Executors Fixating'),(2,30,'Freddy Prototyping'),(2,31,'Tabulates Highways'),(2,32,'Entrust Bach'),(2,35,'Valery Augmenting'),(2,39,'Searcher Bookings'),(2,42,'Brainchild General'),(2,44,'Curtained Offenbach'),(2,45,'Slogan Triangle'),(2,46,'Heathkit Rosella'),(2,56,'Pilings Begged'),(2,57,'Arguing Calorimeter'),(2,60,'Derision Incurable'),(2,64,'Certified Sympathize'),(2,65,'Analyzed Ass'),(2,66,'Precession Orchids'),(2,70,'Examine Vortex'),(2,71,'Omnibus Usenix'),(2,72,'Blustering Straggles'),(2,74,'Proust Innings'),(2,88,'Coexisting Scared'),(2,91,'Smothers Layered'),(2,92,'Nanoprogram Darns'),(2,94,'Journeys Pickle'),(2,95,'Rainfall Mystics'),(2,98,'Bibles Abashing'),(2,100,'Faked Collagen'),(2,105,'Hovel Warped'),(2,108,'Colleagues Distinctions'),(2,109,'Occidentalization Lectures'),(2,110,'Lessening Rewritten'),(2,111,'Sainted Deletion'),(2,112,'Essayed Yellowing'),(2,114,'Eminence Competing'),(2,115,'Muddling Africanize'),(2,116,'Africanizes Jeans'),(2,117,'Emerge Honored'),(2,118,'Lightly Reabbreviating'),(2,119,'Punched Easements'),(2,138,'Viewers Farnsworth'),(2,145,'Posts Sporting'),(2,147,'Logician Commodity'),(2,149,'Paperers Hernandez'),(2,152,'Needless Motives'),(2,153,'Beecham Peasantry'),(2,155,'Peers Itemizing'),(2,158,'Abode Lees'),(2,162,'Amphibians Bunks'),(2,165,'Circulation Breveted'),(2,167,'Scorn Crazier'),(2,168,'Herbivore Ripen'),(2,171,'Seagate Cartilage'),(2,173,'Pose Interchangeably'),(2,175,'Almond Unveiled'),(2,176,'Bergen Dualities'),(2,181,'Grayness Periscope'),(2,185,'Revenger Gatsby'),(2,186,'Monk Abets'),(2,194,'Paregoric Sheep'),(2,196,'Infest Astoria'),(2,197,'Hattize Swap'),(2,201,'Rays Decouple'),(2,202,'Fates Negation'),(2,205,'Much Desertion'),(2,206,'Theodore Lanced'),(2,207,'Respectability Seasonings'),(2,216,'Avenging Hikes'),(2,218,'Bedfast Semester'),(2,230,'Darrow Procedure'),(2,233,'Venture Bateman'),(2,235,'Aspires Extinguishing'),(2,239,'Harem Informality'),(2,247,'Upturn Escapades'),(2,248,'Interlacing Cursor'),(2,254,'Midwinter Conspiracies'),(2,255,'Hairier Exodus'),(2,259,'Friendship Babylonizes'),(2,260,'Petty Fermentation'),(2,266,'Chain Meeting'),(2,268,'Southwestern Restart'),(2,269,'Quill Bergson'),(2,272,'Augment Correcting'),(2,277,'Collar Simmer'),(2,282,'Resistable Him'),(2,295,'Conspired Recovers'),(2,296,'Scorer Firmest'),(2,299,'Euclidean Objecting'),(2,300,'Dolphin Absconds'),(2,301,'Impulses Cantankerously'),(2,304,'Histories Reverberate'),(2,305,'Shutting Firings'),(2,310,'Rightly Lindsey'),(2,311,'Gatsby Mingled'),(2,313,'Pillars Dodecahedra'),(2,315,'Cereal Ravens'),(2,316,'Similarities Reuse'),(2,319,'Northeast Owned'),(2,320,'Newborn Theoretic'),(2,321,'Commonness Official'),(2,331,'Charms Geneva'),(2,332,'Deigns Boer'),(2,334,'Sacrificially Gingerbread'),(2,335,'Buildings Paw'),(2,337,'Familiar Asymptotes'),(2,338,'Extents Flatten'),(2,341,'Police Parsley'),(2,344,'Fife Bulletin'),(2,345,'Ripeness Resemble'),(2,346,'Rio Flagged'),(3,1,'Lorentzian Meek'),(3,2,'Glancing Recompile'),(3,3,'Fruitless Wentworth'),(3,4,'Receding Preacher'),(3,5,'Jolts Kicks'),(3,6,'Enervate Inundate'),(3,8,'Billiken Transcended'),(3,10,'McAdam Calls'),(3,11,'Jams Whacks'),(3,12,'Shanghaiings Howls'),(3,14,'Manner Eigenvector'),(3,15,'Exponentiated Conspirators'),(3,17,'Atrophies Brightest'),(3,18,'Dramas Algebra'),(3,20,'Domineering Rectangles'),(3,22,'Mileage Neutrally'),(3,23,'Abyss Slaps'),(3,24,'Ditch Endow'),(3,25,'Hire Break'),(3,27,'Evokes Pomposity'),(3,28,'Fizeau Agreement'),(3,29,'Sirius Audiometry'),(3,30,'Alabama Disgrace'),(3,31,'Patriarchal Conferred'),(3,32,'Clogging Cobblestone'),(3,33,'Which Epidemic'),(3,34,'Expels Bacterial'),(3,38,'Russians Gradations'),(3,40,'Sublimation Shed'),(3,41,'Ampex Smith'),(3,43,'Manipulability Reclining'),(3,44,'Physicians Chillier'),(3,45,'Platonist Pique'),(3,46,'Forewarns Snob'),(3,47,'Stetson Chaos'),(3,48,'Clippers Evidencing'),(3,49,'Exiling Clarifications'),(3,50,'Caressing Telecommunication'),(3,51,'Restlessly Vikram'),(3,52,'Erroneousness Boheme'),(3,53,'Fraternally Prolate'),(3,54,'Toppled Carrara'),(3,55,'Hungrier Pounders'),(3,56,'Joan Vichy'),(3,58,'Cassites Reprieving'),(3,59,'Doses Surveying'),(3,60,'Abduct Chimney'),(3,61,'Blabbermouth Constructors'),(3,62,'Mania Magnesium'),(3,64,'Holdings Biographers'),(3,65,'Marcher Swallows'),(3,66,'Huxtable Bounteously'),(3,67,'Nameable Velasquez'),(3,68,'Parapet Harasses'),(3,70,'Headlined Decouple'),(3,72,'Contributions Yard'),(3,73,'Secondly Connoisseurs'),(3,74,'Expressive Avert'),(3,75,'Evelyn Reenabled'),(3,76,'Pane Inscribe'),(3,78,'Conscientious Circumcise'),(3,79,'Braved Improper'),(3,81,'Actually Ruffle'),(3,82,'Physique Juxtaposes'),(3,84,'Economizers Concernedly'),(3,85,'Lunches Jigs'),(3,87,'Seltzer Taxicab'),(3,88,'Forts Year'),(3,89,'Invoicing Diffusing'),(3,90,'Enumerate Gamma'),(3,91,'Caustic Burgundian'),(3,92,'Slum Lithe'),(3,93,'Plasters Delaware'),(3,94,'Sufferers Porpoise'),(3,95,'Formally Paperings'),(3,97,'Decorum Chimneys'),(3,98,'Brusque Undiminished'),(3,99,'Transgress Coeducation'),(3,100,'Context Braveness'),(3,101,'Economizer Autobiography'),(3,102,'Tariff Weathering'),(3,103,'Mellowing Piggybacking'),(3,104,'Buxtehude Guile'),(3,105,'Allegory Bathing'),(3,106,'Prospects Coaxial'),(3,107,'Hot Pornography'),(3,108,'Bower Spokesmen'),(3,110,'Diskette Confederation'),(3,111,'Apathy Intemperate'),(3,112,'Fossil Seized'),(3,116,'Revisionary Masturbating'),(3,117,'Precise Generally'),(3,118,'Capricious Earthen'),(3,119,'Prototype Expounds'),(3,120,'Averted Sherwin'),(3,121,'Debatable Alike'),(3,122,'Alvin Program'),(3,123,'Gratifying Harmonistically'),(3,124,'Violence Amharic'),(3,125,'Mountain Syllogism'),(3,127,'Autocrat Ferns'),(3,128,'Misunderstandings Bosporus'),(3,129,'Profitability Logarithms'),(3,130,'Resourcefully Erode'),(3,131,'Prerequisites Anomalies'),(3,132,'Collected Controls'),(3,133,'Swabbing Voiding'),(3,135,'Stimulated Clemson'),(3,136,'Performers Agitating'),(3,138,'Proposed Martinson'),(3,139,'Magnificently Reacted'),(3,140,'Oven Waive'),(3,141,'Likewise Piccolo'),(3,143,'Restorer Haunts'),(3,144,'Concentrators Cadillac'),(3,145,'Regimen Hunks'),(3,146,'Bilingual Sicily'),(3,147,'Drilled Referentiality'),(3,149,'Clod Daze'),(3,150,'Americanizes Alcmena'),(3,152,'Norris Fray'),(3,153,'Wails Solves'),(3,154,'Activator Armpit'),(3,155,'Bumbles Restructure'),(3,156,'Pleases Oversized'),(3,157,'Vetoes Thrill'),(3,158,'Saloon Paragon'),(3,159,'Anecdotes Ion'),(3,160,'Sophocles Limousine'),(3,161,'Begs Coin'),(3,162,'Uruguayans Fiat'),(3,163,'Intentional Cowboys'),(3,164,'McKinley Attractiveness'),(3,165,'Flaxen Peg'),(3,167,'Capped Axially'),(3,168,'Pillage Grenades'),(3,169,'Surname Spared'),(3,170,'Harassed Willingly'),(3,171,'Infallible Gaberones'),(3,172,'Baselines Absence'),(3,175,'Agglutinins Softness'),(3,177,'Spec Cohere'),(3,178,'Characterizer Homeric'),(3,179,'Educated Parsings'),(3,181,'Apartment Through'),(3,182,'Droop Numerical'),(3,183,'Flax Fantasies'),(3,185,'Unhappiest Toes'),(3,186,'Nursery Leopard'),(3,187,'Deirdre Synthesizers'),(3,188,'Hieronymus Suppressors'),(3,189,'Hamburger Remit'),(3,191,'Sees Beckon'),(3,192,'Reexamine Continued'),(3,193,'Drawbridge Sextans'),(3,194,'Digram Garfunkel'),(3,197,'Insured Lustrous'),(3,198,'Mothered Malefactor'),(3,199,'Kingsley Botanist'),(4,5,'Say Videotape'),(4,6,'Greeting Huck'),(4,7,'Prognosticate Feuds'),(4,12,'Destructiveness Ideals'),(4,16,'Culturally Commercially'),(4,20,'Genesco Offers'),(4,21,'Detects Lentil'),(4,24,'Carbonized Rollie'),(4,25,'Waves Disregards'),(4,26,'Granary Blonds'),(4,30,'Brainchild Purposely'),(4,31,'Goody Courter'),(4,32,'Penis Abyss'),(4,34,'Atomizes Essay'),(4,37,'Figuring Pergamon'),(4,38,'Nostalgic Drawling'),(4,41,'Woof Lamed'),(4,42,'Biharmonic Processes'),(4,43,'Mast Undirected'),(4,45,'Interdependencies Numberer'),(4,47,'Rental Democratic'),(4,52,'Druggist Idealistic'),(4,53,'Deferment Irretrievably'),(4,54,'Forthcoming Blinder'),(4,59,'Breathy Ballooning'),(4,61,'Koch Authorship'),(4,62,'Cochise Blueprints'),(4,66,'Gloom Fishpond'),(4,67,'Hutchins Intentional'),(4,69,'Aroused Entity'),(4,70,'Transcending Clime'),(4,71,'Hypothetical Unmarried'),(4,72,'Jeopardize Clasps'),(4,73,'Butane Availing'),(4,77,'Corporal Silencer'),(4,81,'Pot Surveys'),(4,82,'Retaining Wearier'),(4,84,'Repentance Coolly'),(4,85,'Insightful Chungking'),(4,87,'Butler Crane'),(4,88,'Disseminating Oedipally'),(4,91,'Academic Hanging'),(4,92,'Carpathia Degradation'),(4,95,'Saddened Adulterate'),(4,96,'Hillel Easterner'),(4,98,'Squander Ionosphere'),(4,99,'Usages Macaulayan'),(4,101,'Confronter DeKalb'),(4,103,'Clerical Paternoster'),(4,106,'Drawls Integrated'),(4,107,'Unessential Inconsiderateness'),(4,108,'Simple Surly'),(4,115,'Dishonors Ambles'),(4,117,'Upon Kern'),(4,118,'Tightens Hurting'),(4,119,'Quakerize Recollection'),(4,123,'Sonnet Emptiest'),(4,124,'Ascribe Gayly'),(4,125,'Rotund Agreer'),(4,126,'Prostitution Travel'),(4,127,'Concern Menzies'),(4,129,'Textbooks Authenticate'),(4,137,'Touring Parlor'),(4,139,'Sway Alleviation'),(4,140,'Possess Componentry'),(4,141,'Resolved Translucent'),(4,144,'Refereed Albeit'),(4,145,'Hassle Fairview'),(4,154,'Transatlantic Portage'),(4,156,'Everglades Fishkill'),(4,157,'Tidy Russo'),(4,162,'Matrimony Shaken'),(4,165,'Attaining Prosper'),(4,166,'Pears Bilges'),(4,167,'Avail Graphically'),(4,170,'Glorying Reformatory'),(4,171,'Sentencing Inhospitable'),(4,172,'Sheriff Catastrophe'),(4,173,'Patriotic Forgettable'),(4,176,'Singers Gorges'),(4,180,'Cell Textbook'),(4,182,'Fancies Elbowing'),(4,185,'Digitalis Speedometer'),(4,190,'Emission Ducked'),(4,192,'Rind Wallets'),(4,195,'Tall Unspeakable'),(4,197,'Rio Flagged');

--
-- Table structure for table `voli`
--

CREATE TABLE `voli` (
  `id` smallint(6) NOT NULL auto_increment,
  `idaereo` tinyint(4) NOT NULL default '0',
  `idsrc` char(3) NOT NULL default '',
  `iddst` char(3) NOT NULL default '',
  `ora` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `voli`
--


INSERT INTO `voli` VALUES (1,1,'CTA','JFK','2002-03-03 17:00:00'),(2,1,'JFK','CTA','2002-02-03 22:12:00'),(3,2,'PSC','TRS','2003-02-03 06:30:00'),(4,2,'TRS','PSC','2003-02-03 10:15:00'),(5,3,'MXP','CTA','0000-00-00 00:00:00');


