drop table if exists ath_VIZ_cdffiles;
drop table if exists ath_BBG_cdffiles;
drop table if exists ath_LOZ_cdffiles;
drop table if exists ath_BRN_cdffiles;

create table gbo_VIZ_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_BBG_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_LOZ_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_BRN_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
);

