#   import-l_LMcomm-mysql-50x.sql
#   mysql script to import the data for the ULS database files
#   n6lhv@arrl.net (Wayne Smith)
#   created:  28-July-2004
#   updated:  28-October-2005



#   Display the MySQL version
SELECT version();



#   Manage the database
USE uls



#  Import all of the data

#  these files are in the ULS, but not in l_LMcomm
#LOAD DATA LOCAL INFILE 'l_LMcomm-A2.dat' INTO TABLE PUBACC_A2 FIELDS TERMINATED BY '\|';

#LOAD DATA LOCAL INFILE 'l_LMcomm-AC.dat' INTO TABLE PUBACC_AC FIELDS TERMINATED BY '\|';

#LOAD DATA LOCAL INFILE 'l_LMcomm-AD.dat' INTO TABLE PUBACC_AD FIELDS TERMINATED BY '\|';

#LOAD DATA LOCAL INFILE 'l_LMcomm-AM.dat' INTO TABLE PUBACC_AM FIELDS TERMINATED BY '\|';

#LOAD DATA LOCAL INFILE 'l_LMcomm-BC.dat' INTO TABLE PUBACC_BC FIELDS TERMINATED BY '\|';

#LOAD DATA LOCAL INFILE 'l_LMcomm-BL.dat' INTO TABLE PUBACC_BL FIELDS TERMINATED BY '\|';

#LOAD DATA LOCAL INFILE 'l_LMcomm-BO.dat' INTO TABLE PUBACC_BO FIELDS TERMINATED BY '\|';

#LOAD DATA LOCAL INFILE 'l_LMcomm-CF.dat' INTO TABLE PUBACC_CF FIELDS TERMINATED BY '\|';

#LOAD DATA LOCAL INFILE 'l_LMcomm-CG.dat' INTO TABLE PUBACC_CG FIELDS TERMINATED BY '\|';

#LOAD DATA LOCAL INFILE 'l_LMcomm-CS.dat' INTO TABLE PUBACC_CS FIELDS TERMINATED BY '\|';

#LOAD DATA LOCAL INFILE 'l_LMcomm-F2.dat' INTO TABLE PUBACC_F2 FIELDS TERMINATED BY '\|';

#LOAD DATA LOCAL INFILE 'l_LMcomm-FA.dat' INTO TABLE PUBACC_FA FIELDS TERMINATED BY '\|';

#LOAD DATA LOCAL INFILE 'l_LMcomm-FC.dat' INTO TABLE PUBACC_FC FIELDS TERMINATED BY '\|';

#LOAD DATA LOCAL INFILE 'l_LMcomm-FS.dat' INTO TABLE PUBACC_FS FIELDS TERMINATED BY '\|';

#LOAD DATA LOCAL INFILE 'l_LMcomm-FT.dat' INTO TABLE PUBACC_FT FIELDS TERMINATED BY '\|';

#LOAD DATA LOCAL INFILE 'l_LMcomm-IA.dat' INTO TABLE PUBACC_IA FIELDS TERMINATED BY '\|';

#LOAD DATA LOCAL INFILE 'l_LMcomm-IR.dat' INTO TABLE PUBACC_IR FIELDS TERMINATED BY '\|';

#LOAD DATA LOCAL INFILE 'l_LMcomm-MC.dat' INTO TABLE PUBACC_MC FIELDS TERMINATED BY '\|';

#LOAD DATA LOCAL INFILE 'l_LMcomm-MI.dat' INTO TABLE PUBACC_MI FIELDS TERMINATED BY '\|';

#LOAD DATA LOCAL INFILE 'l_LMcomm-MW.dat' INTO TABLE PUBACC_MW FIELDS TERMINATED BY '\|';

#LOAD DATA LOCAL INFILE 'l_LMcomm-PA.dat' INTO TABLE PUBACC_PA FIELDS TERMINATED BY '\|';

#LOAD DATA LOCAL INFILE 'l_LMcomm-PC.dat' INTO TABLE PUBACC_PC FIELDS TERMINATED BY '\|';

#LOAD DATA LOCAL INFILE 'l_LMcomm-RA.dat' INTO TABLE PUBACC_RA FIELDS TERMINATED BY '\|';

#LOAD DATA LOCAL INFILE 'l_LMcomm-RE.dat' INTO TABLE PUBACC_RE FIELDS TERMINATED BY '\|';

#LOAD DATA LOCAL INFILE 'l_LMcomm-RZ.dat' INTO TABLE PUBACC_RZ FIELDS TERMINATED BY '\|';

#LOAD DATA LOCAL INFILE 'l_LMcomm-SE.dat' INTO TABLE PUBACC_SE FIELDS TERMINATED BY '\|';

#LOAD DATA LOCAL INFILE 'l_LMcomm-SG.dat' INTO TABLE PUBACC_SG FIELDS TERMINATED BY '\|';

#LOAD DATA LOCAL INFILE 'l_LMcomm-SH.dat' INTO TABLE PUBACC_SH FIELDS TERMINATED BY '\|';

#LOAD DATA LOCAL INFILE 'l_LMcomm-SI.dat' INTO TABLE PUBACC_SI FIELDS TERMINATED BY '\|';

#LOAD DATA LOCAL INFILE 'l_LMcomm-SV.dat' INTO TABLE PUBACC_SV FIELDS TERMINATED BY '\|';

#LOAD DATA LOCAL INFILE 'l_LMcomm-TA.dat' INTO TABLE PUBACC_TA FIELDS TERMINATED BY '\|';

#LOAD DATA LOCAL INFILE 'l_LMcomm-TL.dat' INTO TABLE PUBACC_TL FIELDS TERMINATED BY '\|';

#LOAD DATA LOCAL INFILE 'l_LMcomm-UA.dat' INTO TABLE PUBACC_UA FIELDS TERMINATED BY '\|';

#LOAD DATA LOCAL INFILE 'l_LMcomm-VC.dat' INTO TABLE PUBACC_VC FIELDS TERMINATED BY '\|';



#  these files are in l_LMcomm, but we may not want all of them
#LOAD DATA LOCAL INFILE 'l_LMcomm-AN.dat' INTO TABLE PUBACC_AN FIELDS TERMINATED BY '\|';

#LOAD DATA LOCAL INFILE 'l_LMcomm-AS.dat' INTO TABLE PUBACC_AS FIELDS TERMINATED BY '\|';

#LOAD DATA LOCAL INFILE 'l_LMcomm-BF.dat' INTO TABLE PUBACC_BF FIELDS TERMINATED BY '\|';

#LOAD DATA LOCAL INFILE 'l_LMcomm-CO.dat' INTO TABLE PUBACC_CO FIELDS TERMINATED BY '\|';

LOAD DATA LOCAL INFILE 'l_LMcomm-CP.dat' INTO TABLE PUBACC_CP FIELDS TERMINATED BY '\|';

LOAD DATA LOCAL INFILE 'l_LMcomm-EM.dat' INTO TABLE PUBACC_EM FIELDS TERMINATED BY '\|';

LOAD DATA LOCAL INFILE 'l_LMcomm-EN.dat' INTO TABLE PUBACC_EN FIELDS TERMINATED BY '\|';

#LOAD DATA LOCAL INFILE 'l_LMcomm-FF.dat' INTO TABLE PUBACC_FF FIELDS TERMINATED BY '\|';

LOAD DATA LOCAL INFILE 'l_LMcomm-FR.dat' INTO TABLE PUBACC_FR FIELDS TERMINATED BY '\|';

LOAD DATA LOCAL INFILE 'l_LMcomm-HD.dat' INTO TABLE PUBACC_HD FIELDS TERMINATED BY '\|';

LOAD DATA LOCAL INFILE 'l_LMcomm-HS.dat' INTO TABLE PUBACC_HS FIELDS TERMINATED BY '\|';

#LOAD DATA LOCAL INFILE 'l_LMcomm-LA.dat' INTO TABLE PUBACC_LA FIELDS TERMINATED BY '\|';

#LOAD DATA LOCAL INFILE 'l_LMcomm-LF.dat' INTO TABLE PUBACC_LF FIELDS TERMINATED BY '\|';

#LOAD DATA LOCAL INFILE 'l_LMcomm-LM.dat' INTO TABLE PUBACC_LM FIELDS TERMINATED BY '\|';

LOAD DATA LOCAL INFILE 'l_LMcomm-LO.dat' INTO TABLE PUBACC_LO FIELDS TERMINATED BY '\|';

#LOAD DATA LOCAL INFILE 'l_LMcomm-LS.dat' INTO TABLE PUBACC_LS FIELDS TERMINATED BY '\|';

#LOAD DATA LOCAL INFILE 'l_LMcomm-MF.dat' INTO TABLE PUBACC_MF FIELDS TERMINATED BY '\|';

#LOAD DATA LOCAL INFILE 'l_LMcomm-MK.dat' INTO TABLE PUBACC_MK FIELDS TERMINATED BY '\|';

#LOAD DATA LOCAL INFILE 'l_LMcomm-MP.dat' INTO TABLE PUBACC_MP FIELDS TERMINATED BY '\|';

#LOAD DATA LOCAL INFILE 'l_LMcomm-OP.dat' INTO TABLE PUBACC_OP FIELDS TERMINATED BY '\|';

#LOAD DATA LOCAL INFILE 'l_LMcomm-SC.dat' INTO TABLE PUBACC_SC FIELDS TERMINATED BY '\|';

#LOAD DATA LOCAL INFILE 'l_LMcomm-SF.dat' INTO TABLE PUBACC_SF FIELDS TERMINATED BY '\|';