#   import-l_coast-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_coast
#LOAD DATA LOCAL INFILE 'l_coast-A2.dat' INTO TABLE PUBACC_A2 FIELDS TERMINATED BY '\|';

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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



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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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