create table mcm_GLYN_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 mcm_WRTH_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 mcm_BENN_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 mcm_AMER_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 mcm_PCEL_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 mcm_RICH_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 mcm_SATX_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 mcm_LYFD_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 mcm_LRES_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
);

