drop table if exists ath_HOV_cdffiles;
drop table if exists ath_SUM_cdffiles;
drop table if exists ath_JAN_cdffiles;
drop table if exists ath_TAB_cdffiles;

create table gbo_HOV_asciifiles
(
Id int unsigned not null auto_increment,
PRIMARY KEY (id),
DataTime datetime not null,
index (DataTime),
FileName char(100) not null,
ProcessTime datetime not null,
FileSize int unsigned
);
create table gbo_SUM_asciifiles
(
Id int unsigned not null auto_increment,
PRIMARY KEY (id),
DataTime datetime not null,
index (DataTime),
FileName char(100) not null,
ProcessTime datetime not null,
FileSize int unsigned
);
create table gbo_JAN_asciifiles
(
Id int unsigned not null auto_increment,
PRIMARY KEY (id),
DataTime datetime not null,
index (DataTime),
FileName char(100) not null,
ProcessTime datetime not null,
FileSize int unsigned
);
create table gbo_TAB_asciifiles
(
Id int unsigned not null auto_increment,
PRIMARY KEY (id),
DataTime datetime not null,
index (DataTime),
FileName char(100) not null,
ProcessTime datetime not null,
FileSize int unsigned
);

