DROP TABLE IF EXISTS ontime;
CREATE TABLE ontime (
  id			int unsigned		not null	auto_increment,
  carrier		char(2)			not null,
  origin		char(3)			not null,
  destination		char(3)			not null,
  flight_num		char(5)			not null,
  flight_time		smallint unsigned	not null,
  tail_num		char(8)			not null,
  dep_time		datetime		not null,
  arr_time		datetime		not null,
  dep_delay		smallint		not null,
  arr_delay		smallint		not null,
  taxi_out		smallint		not null,
  taxi_in		smallint		not null,
  distance		smallint unsigned	not null,
  cancelled		enum('Y','N') 		not null,
  diverted		enum('Y','N') 		not null,
  KEY(id),
  INDEX(carrier),
  INDEX(origin, destination),
  INDEX(destination),
  INDEX(tail_num)
) TYPE=MERGE 
  UNION=(ontime_2005_12);

DROP TABLE IF EXISTS ontime_all;
CREATE TABLE ontime_all (
  id			int unsigned		not null	auto_increment,
  carrier		char(2)			not null,
  origin		char(3)			not null,
  destination		char(3)			not null,
  flight_num		char(5)			not null,
  flight_time		smallint unsigned	not null,
  tail_num		char(8)			not null,
  dep_time		datetime		not null,
  arr_time		datetime		not null,
  dep_delay		smallint		not null,
  arr_delay		smallint		not null,
  taxi_out		smallint		not null,
  taxi_in		smallint		not null,
  distance		smallint unsigned	not null,
  cancelled		enum('Y','N') 		not null,
  diverted		enum('Y','N') 		not null,
  KEY(id),
  INDEX(carrier),
  INDEX(origin, destination),
  INDEX(destination),
  INDEX(tail_num)
) TYPE=MERGE 
  UNION=(
ontime_2000_01,
ontime_2000_02,
ontime_2000_03,
ontime_2000_04,
ontime_2000_05,
ontime_2000_06,
ontime_2000_07,
ontime_2000_08,
ontime_2000_09,
ontime_2000_10,
ontime_2000_11,
ontime_2000_12,
ontime_2001_01,
ontime_2001_02,
ontime_2001_03,
ontime_2001_04,
ontime_2001_05,
ontime_2001_06,
ontime_2001_07,
ontime_2001_08,
ontime_2001_09,
ontime_2001_10,
ontime_2001_11,
ontime_2001_12,
ontime_2002_01,
ontime_2002_02,
ontime_2002_03,
ontime_2002_04,
ontime_2002_05,
ontime_2002_06,
ontime_2002_07,
ontime_2002_08,
ontime_2002_09,
ontime_2002_10,
ontime_2002_11,
ontime_2002_12,
ontime_2003_01,
ontime_2003_02,
ontime_2003_03,
ontime_2003_04,
ontime_2003_05,
ontime_2003_06,
ontime_2003_07,
ontime_2003_08,
ontime_2003_09,
ontime_2003_10,
ontime_2003_11,
ontime_2003_12,
ontime_2004_01,
ontime_2004_02,
ontime_2004_03,
ontime_2004_04,
ontime_2004_05,
ontime_2004_06,
ontime_2004_07,
ontime_2004_08,
ontime_2004_09,
ontime_2004_10,
ontime_2004_11,
ontime_2004_12,
ontime_2005_01,
ontime_2005_02,
ontime_2005_03,
ontime_2005_04,
ontime_2005_05,
ontime_2005_06,
ontime_2005_07,
ontime_2005_08,
ontime_2005_09,
ontime_2005_10,
ontime_2005_11,
ontime_2005_12
);

DROP TABLE IF EXISTS ontime_1year;
CREATE TABLE ontime_1year (
  id			int unsigned		not null	auto_increment,
  carrier		char(2)			not null,
  origin		char(3)			not null,
  destination		char(3)			not null,
  flight_num		char(5)			not null,
  flight_time		smallint unsigned	not null,
  tail_num		char(8)			not null,
  dep_time		datetime		not null,
  arr_time		datetime		not null,
  dep_delay		smallint		not null,
  arr_delay		smallint		not null,
  taxi_out		smallint		not null,
  taxi_in		smallint		not null,
  distance		smallint unsigned	not null,
  cancelled		enum('Y','N') 		not null,
  diverted		enum('Y','N') 		not null,
  KEY(id),
  INDEX(carrier),
  INDEX(origin, destination),
  INDEX(destination),
  INDEX(tail_num)
) TYPE=MERGE 
  UNION=(
         ontime_2005_01,
         ontime_2005_02,
         ontime_2005_03,
         ontime_2005_04,
         ontime_2005_05,
         ontime_2005_06, 
         ontime_2005_07, 
         ontime_2005_08,
         ontime_2005_09, 
         ontime_2005_10,
         ontime_2005_11,
         ontime_2005_12
	);

DROP TABLE IF EXISTS ontime_3month;
CREATE TABLE ontime_3month (
  id			int unsigned		not null	auto_increment,
  carrier		char(2)			not null,
  origin		char(3)			not null,
  destination		char(3)			not null,
  flight_num		char(5)			not null,
  flight_time		smallint unsigned	not null,
  tail_num		char(8)			not null,
  dep_time		datetime		not null,
  arr_time		datetime		not null,
  dep_delay		smallint		not null,
  arr_delay		smallint		not null,
  taxi_out		smallint		not null,
  taxi_in		smallint		not null,
  distance		smallint unsigned	not null,
  cancelled		enum('Y','N') 		not null,
  diverted		enum('Y','N') 		not null,
  KEY(id),
  INDEX(carrier),
  INDEX(origin, destination),
  INDEX(destination),
  INDEX(tail_num)
) TYPE=MERGE 
  UNION=(
         ontime_2005_10,
         ontime_2005_11,
         ontime_2005_12
	);

DROP TABLE IF EXISTS ontime_current;
CREATE TABLE ontime_current (
  id			int unsigned		not null	auto_increment,
  carrier		char(2)			not null,
  origin		char(3)			not null,
  destination		char(3)			not null,
  flight_num		char(5)			not null,
  flight_time		smallint unsigned	not null,
  tail_num		char(8)			not null,
  dep_time		datetime		not null,
  arr_time		datetime		not null,
  dep_delay		smallint		not null,
  arr_delay		smallint		not null,
  taxi_out		smallint		not null,
  taxi_in		smallint		not null,
  distance		smallint unsigned	not null,
  cancelled		enum('Y','N') 		not null,
  diverted		enum('Y','N') 		not null,
  KEY(id),
  INDEX(carrier),
  INDEX(origin, destination),
  INDEX(destination),
  INDEX(tail_num)
) TYPE=MERGE 
  UNION=(
         ontime_2005_10,
         ontime_2005_11,
         ontime_2005_12
	);

DROP TABLE IF EXISTS ontime_2000;
CREATE TABLE ontime_2000 (
  id			int unsigned		not null	auto_increment,
  carrier		char(2)			not null,
  origin		char(3)			not null,
  destination		char(3)			not null,
  flight_num		char(5)			not null,
  flight_time		smallint unsigned	not null,
  tail_num		char(8)			not null,
  dep_time		datetime		not null,
  arr_time		datetime		not null,
  dep_delay		smallint		not null,
  arr_delay		smallint		not null,
  taxi_out		smallint		not null,
  taxi_in		smallint		not null,
  distance		smallint unsigned	not null,
  cancelled		enum('Y','N') 		not null,
  diverted		enum('Y','N') 		not null,
  KEY(id),
  INDEX(carrier),
  INDEX(origin, destination),
  INDEX(destination),
  INDEX(tail_num)
) TYPE=MERGE 
  UNION=(
         ontime_2000_01, 
         ontime_2000_02, 
         ontime_2000_03, 
         ontime_2000_04, 
         ontime_2000_05, 
         ontime_2000_06, 
         ontime_2000_07, 
         ontime_2000_08, 
         ontime_2000_09, 
         ontime_2000_10,
         ontime_2000_11,
         ontime_2000_12
);

Ÿ
DROP TABLE IF EXISTS ontime_2001;
CREATE TABLE ontime_2001 (
  id			int unsigned		not null	auto_increment,
  carrier		char(2)			not null,
  origin		char(3)			not null,
  destination		char(3)			not null,
  flight_num		char(5)			not null,
  flight_time		smallint unsigned	not null,
  tail_num		char(8)			not null,
  dep_time		datetime		not null,
  arr_time		datetime		not null,
  dep_delay		smallint		not null,
  arr_delay		smallint		not null,
  taxi_out		smallint		not null,
  taxi_in		smallint		not null,
  distance		smallint unsigned	not null,
  cancelled		enum('Y','N') 		not null,
  diverted		enum('Y','N') 		not null,
  KEY(id),
  INDEX(carrier),
  INDEX(origin, destination),
  INDEX(destination),
  INDEX(tail_num)
) TYPE=MERGE 
  UNION=(
         ontime_2001_01, 
         ontime_2001_02, 
         ontime_2001_03, 
         ontime_2001_04, 
         ontime_2001_05, 
         ontime_2001_06, 
         ontime_2001_07, 
         ontime_2001_08, 
         ontime_2001_09, 
         ontime_2001_10,
         ontime_2001_11,
         ontime_2001_12
);


DROP TABLE IF EXISTS ontime_2002;
CREATE TABLE ontime_2002 (
  id			int unsigned		not null	auto_increment,
  carrier		char(2)			not null,
  origin		char(3)			not null,
  destination		char(3)			not null,
  flight_num		char(5)			not null,
  flight_time		smallint unsigned	not null,
  tail_num		char(8)			not null,
  dep_time		datetime		not null,
  arr_time		datetime		not null,
  dep_delay		smallint		not null,
  arr_delay		smallint		not null,
  taxi_out		smallint		not null,
  taxi_in		smallint		not null,
  distance		smallint unsigned	not null,
  cancelled		enum('Y','N') 		not null,
  diverted		enum('Y','N') 		not null,
  KEY(id),
  INDEX(carrier),
  INDEX(origin, destination),
  INDEX(destination),
  INDEX(tail_num)
) TYPE=MERGE 
  UNION=(
         ontime_2002_01, 
         ontime_2002_02, 
         ontime_2002_03, 
         ontime_2002_04, 
         ontime_2002_05, 
         ontime_2002_06, 
         ontime_2002_07, 
         ontime_2002_08, 
         ontime_2002_09, 
         ontime_2002_10,
         ontime_2002_11,
         ontime_2002_12
);


DROP TABLE IF EXISTS ontime_2003;
CREATE TABLE ontime_2003 (
  id			int unsigned		not null	auto_increment,
  carrier		char(2)			not null,
  origin		char(3)			not null,
  destination		char(3)			not null,
  flight_num		char(5)			not null,
  flight_time		smallint unsigned	not null,
  tail_num		char(8)			not null,
  dep_time		datetime		not null,
  arr_time		datetime		not null,
  dep_delay		smallint		not null,
  arr_delay		smallint		not null,
  taxi_out		smallint		not null,
  taxi_in		smallint		not null,
  distance		smallint unsigned	not null,
  cancelled		enum('Y','N') 		not null,
  diverted		enum('Y','N') 		not null,
  KEY(id),
  INDEX(carrier),
  INDEX(origin, destination),
  INDEX(destination),
  INDEX(tail_num)
) TYPE=MERGE 
  UNION=(
         ontime_2003_01, 
         ontime_2003_02, 
         ontime_2003_03, 
         ontime_2003_04, 
         ontime_2003_05, 
         ontime_2003_06, 
         ontime_2003_07, 
         ontime_2003_08, 
         ontime_2003_09, 
         ontime_2003_10,
         ontime_2003_11,
         ontime_2003_12
);


DROP TABLE IF EXISTS ontime_2004;
CREATE TABLE ontime_2004 (
  id			int unsigned		not null	auto_increment,
  carrier		char(2)			not null,
  origin		char(3)			not null,
  destination		char(3)			not null,
  flight_num		char(5)			not null,
  flight_time		smallint unsigned	not null,
  tail_num		char(8)			not null,
  dep_time		datetime		not null,
  arr_time		datetime		not null,
  dep_delay		smallint		not null,
  arr_delay		smallint		not null,
  taxi_out		smallint		not null,
  taxi_in		smallint		not null,
  distance		smallint unsigned	not null,
  cancelled		enum('Y','N') 		not null,
  diverted		enum('Y','N') 		not null,
  KEY(id),
  INDEX(carrier),
  INDEX(origin, destination),
  INDEX(destination),
  INDEX(tail_num)
) TYPE=MERGE 
  UNION=(
         ontime_2004_01, 
         ontime_2004_02, 
         ontime_2004_03, 
         ontime_2004_04, 
         ontime_2004_05,
         ontime_2004_06,
         ontime_2004_07,
         ontime_2004_08,
         ontime_2004_09,
         ontime_2004_10,
         ontime_2004_11,
         ontime_2004_12
);

DROP TABLE IF EXISTS ontime_2005;
CREATE TABLE ontime_2005 (
  id                    int unsigned            not null        auto_increment,
  carrier               char(2)                 not null,
  origin                char(3)                 not null,
  destination           char(3)                 not null,
  flight_num            char(5)                 not null,
  flight_time           smallint unsigned       not null,
  tail_num              char(8)                 not null,
  dep_time              datetime                not null,
  arr_time              datetime                not null,
  dep_delay             smallint                not null,
  arr_delay             smallint                not null,
  taxi_out              smallint                not null,
  taxi_in               smallint                not null,
  distance              smallint unsigned       not null,
  cancelled             enum('Y','N')           not null,
  diverted              enum('Y','N')           not null,
  KEY(id),
  INDEX(carrier),
  INDEX(origin, destination),
  INDEX(destination),
  INDEX(tail_num)
) TYPE=MERGE 
  UNION=(
         ontime_2005_01, 
         ontime_2005_02,
         ontime_2005_03,
         ontime_2005_04,
         ontime_2005_05,
         ontime_2005_06,
         ontime_2005_07,
         ontime_2005_08,
         ontime_2005_09,
         ontime_2005_10,
         ontime_2005_11,
         ontime_2005_12
);