--   import-sqlite-28x.sql
--   sqlite script to import the data for the ULS database files
--   n6lhv@arrl.net (Wayne Smith)
--   created:  9-August-2004
--   updated:  10-August-2004



--   Manage the database
--USE uls;



--  Import all of the data
--  Land Mobile (Private)
--  l_LMpriv.zip

--  these files are in the ULS, but not in l_LMpriv
--COPY PUBACC_A2 FROM 'A2.dat' USING DELIMITERS '\|';

--COPY PUBACC_AC FROM 'AC.dat' USING DELIMITERS '\|';

--COPY PUBACC_AD FROM 'AD.dat' USING DELIMITERS '\|';

--COPY PUBACC_AM FROM 'AM.dat' USING DELIMITERS '\|';

--COPY PUBACC_BC FROM 'BC.dat' USING DELIMITERS '\|';

--COPY PUBACC_BL FROM 'BL.dat' USING DELIMITERS '\|';

--COPY PUBACC_BO FROM 'BO.dat' USING DELIMITERS '\|';

--COPY PUBACC_CF FROM 'CF.dat' USING DELIMITERS '\|';

--COPY PUBACC_CG FROM 'CG.dat' USING DELIMITERS '\|';

--COPY PUBACC_CS FROM 'CS.dat' USING DELIMITERS '\|';

--COPY PUBACC_F2 FROM 'F2.dat' USING DELIMITERS '\|';

--COPY PUBACC_FA FROM 'FA.dat' USING DELIMITERS '\|';

--COPY PUBACC_FC FROM 'FC.dat' USING DELIMITERS '\|';

--COPY PUBACC_FS FROM 'FS.dat' USING DELIMITERS '\|';

--COPY PUBACC_FT FROM 'FT.dat' USING DELIMITERS '\|';

--COPY PUBACC_IA FROM 'IA.dat' USING DELIMITERS '\|';

--COPY PUBACC_IR FROM 'IR.dat' USING DELIMITERS '\|';

--COPY PUBACC_MC FROM 'MC.dat' USING DELIMITERS '\|';

--COPY PUBACC_MI FROM 'MI.dat' USING DELIMITERS '\|';

--COPY PUBACC_MW FROM 'MW.dat' USING DELIMITERS '\|';

--COPY PUBACC_PA FROM 'PA.dat' USING DELIMITERS '\|';

--COPY PUBACC_PC FROM 'PC.dat' USING DELIMITERS '\|';

--COPY PUBACC_RA FROM 'RA.dat' USING DELIMITERS '\|';

--COPY PUBACC_RE FROM 'RE.dat' USING DELIMITERS '\|';

--COPY PUBACC_RZ FROM 'RZ.dat' USING DELIMITERS '\|';

--COPY PUBACC_SE FROM 'SE.dat' USING DELIMITERS '\|';

--COPY PUBACC_SG FROM 'SG.dat' USING DELIMITERS '\|';

--COPY PUBACC_SH FROM 'SH.dat' USING DELIMITERS '\|';

--COPY PUBACC_SI FROM 'SI.dat' USING DELIMITERS '\|';

--COPY PUBACC_SV FROM 'SV.dat' USING DELIMITERS '\|';

--COPY PUBACC_TA FROM 'TA.dat' USING DELIMITERS '\|';

--COPY PUBACC_TL FROM 'TL.dat' USING DELIMITERS '\|';

--COPY PUBACC_UA FROM 'UA.dat' USING DELIMITERS '\|';

--COPY PUBACC_VC FROM 'VC.dat' USING DELIMITERS '\|';



--  these files are in l_LMpriv, but we may not want all of them
--COPY PUBACC_AN FROM 'AN.dat' USING DELIMITERS '\|';

--COPY PUBACC_AS FROM 'AS.dat' USING DELIMITERS '\|';

--COPY PUBACC_BF FROM 'BF.dat' USING DELIMITERS '\|';

--COPY PUBACC_CO FROM 'CO.dat' USING DELIMITERS '\|';

--COPY PUBACC_CP FROM 'CP.dat' USING DELIMITERS '\|';

--COPY PUBACC_EM FROM 'EM.dat' USING DELIMITERS '\|';

COPY PUBACC_EN FROM 'EN.dat' USING DELIMITERS '\|';

--COPY PUBACC_FF FROM 'FF.dat' USING DELIMITERS '\|';

COPY PUBACC_FR FROM 'FR.dat' USING DELIMITERS '\|';

--COPY PUBACC_HD FROM 'HD.dat' USING DELIMITERS '\|';

--COPY PUBACC_HS FROM 'HS.dat' USING DELIMITERS '\|';

--COPY PUBACC_LA FROM 'LA.dat' USING DELIMITERS '\|';

--COPY PUBACC_LF FROM 'LF.dat' USING DELIMITERS '\|';

--COPY PUBACC_LM FROM 'LM.dat' USING DELIMITERS '\|';

COPY PUBACC_LO FROM 'LO.dat' USING DELIMITERS '\|';

--COPY PUBACC_LS FROM 'LS.dat' USING DELIMITERS '\|';

--COPY PUBACC_MF FROM 'MF.dat' USING DELIMITERS '\|';

--COPY PUBACC_MK FROM 'MK.dat' USING DELIMITERS '\|';

--COPY PUBACC_MP FROM 'MP.dat' USING DELIMITERS '\|';

--COPY PUBACC_OP FROM 'OP.dat' USING DELIMITERS '\|';

--COPY PUBACC_SC FROM 'SC.dat' USING DELIMITERS '\|';

--COPY PUBACC_SF FROM 'SF.dat' USING DELIMITERS '\|';