create table mcm_GLYN_cdffiles
(
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_cdffiles
(
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_cdffiles
(
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_cdffiles
(
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_cdffiles
(
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_cdffiles
(
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_cdffiles
(
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_cdffiles
(
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_cdffiles
(
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
);

