-- MySQL dump 10.17  Distrib 10.3.25-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: cqrlog001
-- ------------------------------------------------------
-- Server version	10.3.25-MariaDB-0ubuntu0.20.04.1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `call_alert`
--

DROP TABLE IF EXISTS `call_alert`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `call_alert` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `callsign` varchar(20) COLLATE utf8_bin NOT NULL,
  `band` varchar(6) COLLATE utf8_bin DEFAULT NULL,
  `mode` varchar(12) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`),
  KEY `callsign` (`callsign`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `call_alert`
--

LOCK TABLES `call_alert` WRITE;
/*!40000 ALTER TABLE `call_alert` DISABLE KEYS */;
/*!40000 ALTER TABLE `call_alert` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `club1`
--

DROP TABLE IF EXISTS `club1`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `club1` (
  `id_club1` int(11) NOT NULL AUTO_INCREMENT,
  `club_nr` varchar(100) COLLATE utf8_bin DEFAULT '',
  `clubcall` varchar(100) COLLATE utf8_bin DEFAULT '',
  `fromdate` date DEFAULT NULL,
  `todate` date DEFAULT NULL,
  PRIMARY KEY (`id_club1`),
  KEY `club_nr` (`club_nr`),
  KEY `fromdate` (`fromdate`),
  KEY `todate` (`todate`),
  KEY `clubcall` (`clubcall`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `club1`
--

LOCK TABLES `club1` WRITE;
/*!40000 ALTER TABLE `club1` DISABLE KEYS */;
/*!40000 ALTER TABLE `club1` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `club2`
--

DROP TABLE IF EXISTS `club2`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `club2` (
  `id_club2` int(11) NOT NULL AUTO_INCREMENT,
  `club_nr` varchar(100) COLLATE utf8_bin DEFAULT '',
  `clubcall` varchar(100) COLLATE utf8_bin DEFAULT '',
  `fromdate` date DEFAULT NULL,
  `todate` date DEFAULT NULL,
  PRIMARY KEY (`id_club2`),
  KEY `club_nr` (`club_nr`),
  KEY `fromdate` (`fromdate`),
  KEY `todate` (`todate`),
  KEY `clubcall` (`clubcall`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `club2`
--

LOCK TABLES `club2` WRITE;
/*!40000 ALTER TABLE `club2` DISABLE KEYS */;
/*!40000 ALTER TABLE `club2` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `club3`
--

DROP TABLE IF EXISTS `club3`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `club3` (
  `id_club3` int(11) NOT NULL AUTO_INCREMENT,
  `club_nr` varchar(100) COLLATE utf8_bin DEFAULT '',
  `clubcall` varchar(100) COLLATE utf8_bin DEFAULT '',
  `fromdate` date DEFAULT NULL,
  `todate` date DEFAULT NULL,
  PRIMARY KEY (`id_club3`),
  KEY `club_nr` (`club_nr`),
  KEY `fromdate` (`fromdate`),
  KEY `todate` (`todate`),
  KEY `clubcall` (`clubcall`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `club3`
--

LOCK TABLES `club3` WRITE;
/*!40000 ALTER TABLE `club3` DISABLE KEYS */;
/*!40000 ALTER TABLE `club3` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `club4`
--

DROP TABLE IF EXISTS `club4`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `club4` (
  `id_club4` int(11) NOT NULL AUTO_INCREMENT,
  `club_nr` varchar(100) COLLATE utf8_bin DEFAULT '',
  `clubcall` varchar(100) COLLATE utf8_bin DEFAULT '',
  `fromdate` date DEFAULT NULL,
  `todate` date DEFAULT NULL,
  PRIMARY KEY (`id_club4`),
  KEY `club_nr` (`club_nr`),
  KEY `fromdate` (`fromdate`),
  KEY `todate` (`todate`),
  KEY `clubcall` (`clubcall`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `club4`
--

LOCK TABLES `club4` WRITE;
/*!40000 ALTER TABLE `club4` DISABLE KEYS */;
/*!40000 ALTER TABLE `club4` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `club5`
--

DROP TABLE IF EXISTS `club5`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `club5` (
  `id_club5` int(11) NOT NULL AUTO_INCREMENT,
  `club_nr` varchar(100) COLLATE utf8_bin DEFAULT '',
  `clubcall` varchar(100) COLLATE utf8_bin DEFAULT '',
  `fromdate` date DEFAULT NULL,
  `todate` date DEFAULT NULL,
  PRIMARY KEY (`id_club5`),
  KEY `club_nr` (`club_nr`),
  KEY `fromdate` (`fromdate`),
  KEY `todate` (`todate`),
  KEY `clubcall` (`clubcall`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `club5`
--

LOCK TABLES `club5` WRITE;
/*!40000 ALTER TABLE `club5` DISABLE KEYS */;
/*!40000 ALTER TABLE `club5` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cqrlog_config`
--

DROP TABLE IF EXISTS `cqrlog_config`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cqrlog_config` (
  `id_cqrlog__config` int(11) NOT NULL AUTO_INCREMENT,
  `config_file` longtext COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`id_cqrlog__config`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cqrlog_config`
--

LOCK TABLES `cqrlog_config` WRITE;
/*!40000 ALTER TABLE `cqrlog_config` DISABLE KEYS */;
INSERT INTO `cqrlog_config` VALUES (1,'[Reminder]\nchRemi=0\nchUTRemi=0\nRemindTimeSet=000\nRemindUThour=00:00\nRemiMemo=\n\n[Window]\nCWKeys=0\nGrayline=0\nTRX=0\nROT=0\nDxcluster=0\nDetails=0\nBandMap=0\nProp=0\npDK0WCY=0\nWorkedGrids=0\nSCP=0\nQSOList=0\nLogUploadStatus=0\nCWType=0\nRBNMonitor=0\n\n[frmQSODetails]\nHeight=210\nWidth=266\nTop=27\nLeft=72\nMax=0\n\n[NewQSO]\nAutoMode=0\nStatBar=1\nShowGrd=1\nRST_S=599\nRST_R=599\nPWR=100\nFREQ=7.025\nMode=CW\nQSL_S=\nRemQSO=\nUseSpaceBar=0\nRefreshAfterSave=0\nSkipModeFreq=1\nAutoSearch=0\nShowRecentQSOs=0\nShowB4call=0\nRecQSOsNum=5\nIgnoreQRZ=0\nMvToRem=1\nAutoQSLS=1\nAutoDQSLS=0\nAutoQQSLS=0\nAllVariants=0\nClearRIT=0\nUseCallBookData=0\nCapFirstQTHLetter=1\nUseCallbookZonesEtc=1\nFillAwardField=1\nSatelliteMode=0\n\n[frmNewQSO]\nHeight=709\nWidth=997\nTop=27\nLeft=72\nMax=0\n\n[TMPQSO]\n\n[Main]\nAutoSizeColumns=0\nToolbar=1\nButtons=1\nDetails=1\n\n[frmMain_dbgrdMain]\nid_cqrlog_main=0\nqsodate=110\ntime_on=77\ntime_off=0\ncallsign=220\nfreq=110\nmode=132\nrst_s=220\nrst_r=220\nname=440\nqth=660\nqsl_s=55\nqsl_r=55\nqsl_via=0\niota=0\npwr=0\nitu=0\nwaz=0\nloc=0\nmy_loc=0\ncounty=0\naward=0\nremarks=0\nband=0\ndxcc_ref=0\nqso_dxcc=0\nprofile=0\nidcall=0\nstate=0\nlotw_qslsdate=0\nlotw_qslrdate=0\nlotw_qsls=0\nlotw_qslr=0\ncont=0\nqsls_date=0\nqslr_date=0\nclub_nr1=0\nclub_nr2=0\nclub_nr3=0\nclub_nr4=0\nclub_nr5=0\neqsl_qsl_sent=0\neqsl_qslsdate=0\neqsl_qsl_rcvd=0\neqsl_qslrdate=0\nqslr=0\ncountry=0\nrxfreq=0\nsatellite=0\nprop_mode=0\nsrx=0\nstx=0\nsrx_string=0\nstx_string=0\ncontestname=0\n\n[frmMain]\nHeight=669\nWidth=986\nTop=24\nLeft=20\nMax=0\n\n[Export]\nDate=1\ntime_on=1\ntime_off=1\nCallSign=1\nMode=1\nFreq=1\nRST_S=1\nRST_R=1\nName=1\nQTH=1\nQSL_S=1\nQSL_R=1\nQSL_VIA=1\nLocator=1\nMyLoc=1\nDistance=1\nIOTA=1\nAward=1\nCounty=1\nPower=1\nDXCC=1\nRemarks=1\nWAZ=1\nITU=1\nNote=1\nProfile=1\nState=1\nLQSLS=1\nLQSLSDate=1\nLQSLR=1\nLQSLRDate=1\nContinent=1\nQSLSDate=1\nQSLRDate=1\neQSLS=1\neQSLSDate=1\neQSLR=1\neQSLRDate=1\nAscTime=1\nProp=1\nRxFreq=1\nSatName=1\nContestname=1\nContestNr=1\nContestMsg=1\nHTMLAutoColumn=1\nWDate=10\nWtime_on=5\nWtime_off=5\nWCallSign=10\nWMode=6\nWFreq=10\nWRST_S=4\nWRST_R=4\nWName=20\nWQTH=20\nWQSL_S=2\nWQSL_R=2\nWQSL_VIA=10\nWLocator=6\nWMyLoc=6\nWDistance=5\nWIOTA=7\nWAward=10\nWCounty=10\nWPower=4\nWDXCC=4\nWRemarks=100\nWWAZ=3\nWITU=3\nWNote=50\nWState=10\nWLQSLS=2\nWLQSLSDate=10\nWLQSLR=2\nWLQSLRDate=10\nWQSLSDate=10\nWQSLRDate=10\nWeQSLS=2\nWeQSLSDate=10\nWeQSLR=2\nWeQSLRDate=10\nWProp=6\nWRxFreq=10\nWSatName=10\nWContinent=2\nWProfile=20\nWContestName=20\nWContestNr=4\nWContestMsg=10\nWDate1=Date\nWtime_on1=Time on\nWtime_off1=Time off\nWCallSign1=Call\nWMode1=Mode\nWFreq1=Freq\nWRST_S1=RSTs\nWRST_R1=RSTr\nWName1=Name\nWQTH1=QTH\nWQSL_S1=QSLs\nWQSL_R1=QSLr\nWQSL_VIA1=QSL via\nWLocator1=Loc\nWMyLoc1=MyLoc\nWDistance1=QRB\nWIOTA1=IOTA\nWAward1=Award\nWCounty1=County\nWPower1=Pwr\nWDXCC1=DXCC\nWRemarks1=Cmnt\nWWAZ1=WAZ\nWITU1=ITU\nWNote1=Note\nWState1=State\nWLQSLS1=LQSLs\nWLQSLSDate1=LQSLSdat\nWLQSLR1=LQSLr\nWLQSLRDate1=LQSLRdat\nWQSLSDate1=QSLSdat\nWQSLRDate1=QSLRdat\nWeQSLS1=eQSLs\nWeQSLSDate1=eQSLSdat\nWeQSLR1=eQSLr\nWeQSLRDate1=eQSLRdat\nWProp1=Propag\nWRxFreq1=RX Freq\nWSatName1=Satellite\nWContinent1=Contin\nWProfile1=Profile\nWContestName1=Contest\nWContestNr1=Cont Nr\nWContestMsg1=Cont Msg\n\n[Pref]\nTop=24\nLeft=20\nActPageIdx=9\n\n[Station]\nCall=\nName=\nQTH=\nLOC=\n\n[Program]\nProxy=\nPort=\nUser=\nPasswd=\noffset=0\nOptions=9\nBandStatMHz=1\nGraylineOffset=0\nWebBrowser=firefox\nCheckDXCCTabs=1\nShowDeleted=0\nSunUTC=0\nCheckQSLTabs=1\nSunOffset=0\nSysUTC=1\nShowMiles=0\nQSODiffColor=0\nQSOColor=0\nQSOColorDate=\n\n[Columns]\nDate=1\ntime_on=1\ntime_off=0\nCallSign=1\nMode=1\nFreq=1\nRST_S=1\nRST_R=1\nName=1\nQTH=1\nQSL_S=1\nQSL_R=1\nQSL_VIA=0\nLocator=0\nMyLoc=0\nDistance=0\nIOTA=0\nAward=0\nPower=0\nDXCC=0\nRemarks=0\nWAZ=0\nITU=0\nCounty=0\nState=0\nLoTWQSLSDate=0\nLoTWQSLRDate=0\nLoTWQSLS=0\nLOTWQSLR=0\nCont=0\nQSLSDate=0\nQSLRDate=0\neQSLQSLS=0\neQSLQSLSDate=0\neQSLQSLR=0\neQSLQSLRDate=0\nQSLRAll=0\nCountry=0\nPropagation=0\nSatelliteName=0\nRXFreq=0\nContestName=0\nSTX=0\nSRX=0\nContMsgSent=0\nContMsgRcvd=0\n\n[Bands]\n137kHz=0\n472kHz=0\n160m=1\n80m=1\n60m=0\n40m=1\n30m=1\n20m=1\n17m=1\n15m=1\n12m=1\n10m=1\n4m=0\n6m=1\n2m=1\n1.25m=0\n70cm=1\n33cm=0\n23cm=0\n13cm=0\n8cm=0\n5cm=0\n3cm=0\n1cm=0\n47GHz=0\n76GHz=0\n\n[TRX]\nRigCtldPath=/usr/bin/rigctld\nDebug=0\nMemModeRelated=0\n\n[TRX1]\ndevice=\nmodel=1\npoll=500\nDesc=Radio 1\nCWR=0\nRigCtldPort=4532\nExtraRigCtldArgs=\nRunRigCtld=0\nhost=localhost\nSerialSpeed=0\nDataBits=0\nStopBits=0\nParity=0\nHandShake=0\nDTR=0\nRTS=0\n\n[TRX2]\ndevice=\nmodel=1\npoll=500\nDesc=Radio 2\nCWR=0\nRigCtldPort=4532\nExtraRigCtldArgs=\nRunRigCtld=0\nhost=localhost\nSerialSpeed=0\nDataBits=0\nStopBits=0\nParity=0\nHandShake=0\nDTR=0\nRTS=0\n\n[ROT]\nRotCtldPath=/usr/bin/rotctld\n\n[ROT1]\ndevice=\nmodel=\npoll=500\nDesc=Rotor 1\nRotCtldPort=4533\nExtraRotCtldArgs=\nRunRotCtld=0\nhost=localhost\nSerialSpeed=0\nDataBits=0\nStopBits=0\nParity=0\nHandShake=0\nDTR=0\nRTS=0\n\n[ROT2]\ndevice=\nmodel=\npoll=500\nDesc=Rotor 2\nRotCtldPort=4533\nExtraRotCtldArgs=\nRunRotCtld=0\nhost=localhost\nSerialSpeed=0\nDataBits=0\nStopBits=0\nParity=0\nHandShake=0\nDTR=0\nRTS=0\n\n[Band1]\nCW=500\nSSB=1800\nRTTY=500\nAM=3000\nFM=2500\n\n[Band2]\nCW=500\nSSB=1800\nRTTY=500\nAM=3000\nFM=2500\n\n[Modes]\nDigi=\n\n[Profiles]\nUse=0\nSelected=-1\nLocator=1\nQTH=1\nRIG=0\n\n[DXCluster]\nNewCountry=0\nNewBand=0\nNewMode=0\nNeedQSL=0\nShow2190M=1\nShow630M=1\nShow160M=1\nShow80M=1\nShow60M=1\nShow40M=1\nShow30M=1\nShow20M=1\nShow17M=1\nShow15M=1\nShow12M=1\nShow10M=1\nShow6M=1\nShow4M=1\nShow2M=1\nShow125M=1\nShow70CM=1\nShow33CM=1\nShow23CM=1\nShow13CM=1\nShow9CM=1\nShow6CM=1\nShow3CM=1\nShow125CM=1\nShow6MM=1\nShow4MM=1\nCW=1\nSSB=1\nNotShow=\nConAfterRun=0\nShowDxcCountry=0\nAlertCmd=\nStartCmd=\n\n[Fonts]\nUseDefault=1\nButtons=Sans 10\nEdits=Sans 10\nGrids=Monospace 8\nQGrids=Sans 10\neSize=10\nbSize=10\ngSize=8\nqSize=10\nGridGreenBar=0\nGridBoldTitle=0\nGridShowHint=0\nGridSmallRows=0\nGridDotsInsteadSpaces=0\n\n[Zones]\nNewWAZ=0\nNewBandWAZ=0\nQSLWAZ=0\nNewITU=0\nNewBandITU=0\nQSLITU=0\nShowWAZInfo=1\nShowITUInfo=1\n\n[IOTA]\nNewIOTA=0\nQSLIOTA=0\nShowIOTAInfo=1\n\n[Clubs]\nFirst=\nSecond=\nThird=\nFourth=\nFifth=\nCheckForUpdate=0\n\n[BandMap]\nBandFont=Monospace\nFontSize=8\nNewQSOColor=0\nin_kHz=1\nSave=0\nFirstAging=5\nSecondAging=8\nDisep=12\nClusterColor=0\nOnlyActiveBand=0\nOnlyActiveMode=0\nDeleteAfterQSO=1\nUseDXCColors=0\nAddAfterQSO=0\nIgnoreBandFreq=1\nUseNewQSOFreqMode=0\nPlusToBandMap=0\n\n[xplanet]\npath=/usr/bin/xplanet\nheight=100\nwidth=100\ntop=10\nleft=10\nrun=0\nclose=0\nrefresh=5\nLastSpots=20\nproject=0\nShowFrom=0\ncolor=16777215\nUseDefColor=1\nloc=\nShowOwnPos=0\n\n[ZipCode]\nFirst=\nFirstSaveTo=\nFirstPos=0\nSecond=\nSecondSaveTo=\nSecondPos=0\nThird=\nThirdSaveTo=\nThirdPos=0\n\n[LoTW]\nIncLoTWDXCC=0\nNewQSOLoTW=0\nLoTWName=\nLoTWPass=\nShowInfo=1\nUseBackColor=1\nBckColor=12639424\neQSLName=\neQSLPass=\neQSLStartAddr=http://www.eqsl.cc/qslcard/DownloadInBox.cfm\neQSLDnlAddr=http://www.eqsl.cc/downloadedfiles/\neUseBackColor=1\neBckColor=15780518\nExpComment=1\n\n[CW]\nType=0\nwk_port=\nPotSpeed=0\nwk_speed=30\ncw_address=localhost\ncw_port=6789\ncw_speed=30\nwk_min=5\nwk_max=60\nK3NGPort=\nK3NGSerSpeed=115200\nK3NGSpeed=30\nHamLibSpeed=30\n\n[fldigi]\nfreq=1\ndeffreq=3.600\nmode=1\ndefmode=RTTY\ndefrst=599\nrst=0\ninterval=2\nrun=0\npath=\nport=7362\nip=127.0.0.1\nxmlrpc=0\ndropSyErr=3\n\n[wsjt]\npath=\nport=2237\nip=127.0.0.1\nrun=0\nfreq=1\ndeffreq=3.600\nmode=1\ndefmode=JT65\nwb4calldate=1900-01-01\nwb4locdate=1900-01-01\nwb4CCall=0\nwb4CLoc=0\n\n[n1mm]\nport=2333\nip=127.0.0.1\n\n[Backup]\nEnable=0\nCompress=1\nPath=/home/bealwd/.config/cqrlog/database/\nPath1=\nBackupType=0\nAskFirst=0\n\n[ExtView]\ntxt=gedit\npdf=evince\nimg=eog\nhtml=firefox\nQSL=1\n\n[FirstClub]\nDateFrom=1945-01-01\n\n[SecondClub]\nDateFrom=1945-01-01\n\n[ThirdClub]\nDateFrom=1945-01-01\n\n[FourthClub]\nDateFrom=1945-01-01\n\n[FifthClub]\nDateFrom=1945-01-01\n\n[CallBook]\nQRZ=0\nHamQTH=1\nCBUser=\nCBPass=\n\n[RBN]\n10db=16777215\n20db=8388736\n30db=128\nover30db=255\nlogin=\nwatch=\nAutoConnect=0\ndeleteAfter=60\nServer=telnet.reversebeacon.net:7000\n\n[OnlineLog]\nHaUP=0\nHaUpOnline=0\nHaUserName=\nHaPasswd=\nHaColor=16711680\nClUP=0\nClUpOnline=0\nClUserName=\nClPasswd=\nClEmail=\nClColor=255\nHrUP=0\nHrUpOnline=0\nHrUserName=\nHrCode=\nHrColor=8388736\nCloseAfterUpload=0\nIgnoreLoTWeQSL=0\n\n[prop]\nUrl=http://www.hamqsl.com/solarbrief.php\nAsImage=1\nAsText=0\nValues=1\nCalcHF=1\nCalcVHF=1\n');
/*!40000 ALTER TABLE `cqrlog_config` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cqrlog_main`
--

DROP TABLE IF EXISTS `cqrlog_main`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cqrlog_main` (
  `id_cqrlog_main` int(11) NOT NULL AUTO_INCREMENT,
  `qsodate` date NOT NULL,
  `time_on` varchar(5) COLLATE utf8_bin NOT NULL,
  `time_off` varchar(5) COLLATE utf8_bin DEFAULT '',
  `callsign` varchar(20) COLLATE utf8_bin NOT NULL,
  `freq` decimal(10,4) NOT NULL,
  `mode` varchar(12) COLLATE utf8_bin NOT NULL,
  `rst_s` varchar(20) COLLATE utf8_bin DEFAULT '',
  `rst_r` varchar(20) COLLATE utf8_bin DEFAULT '',
  `name` varchar(40) COLLATE utf8_bin DEFAULT '',
  `qth` varchar(60) COLLATE utf8_bin DEFAULT '',
  `qsl_s` varchar(4) COLLATE utf8_bin DEFAULT '',
  `qsl_r` varchar(3) COLLATE utf8_bin DEFAULT '',
  `qsl_via` varchar(30) COLLATE utf8_bin DEFAULT '',
  `iota` varchar(6) COLLATE utf8_bin DEFAULT '',
  `pwr` varchar(10) COLLATE utf8_bin DEFAULT '',
  `itu` int(11) DEFAULT 0,
  `waz` int(11) DEFAULT 0,
  `loc` varchar(10) COLLATE utf8_bin DEFAULT '',
  `my_loc` varchar(10) COLLATE utf8_bin DEFAULT '',
  `county` varchar(30) COLLATE utf8_bin DEFAULT '',
  `award` varchar(50) COLLATE utf8_bin DEFAULT '',
  `remarks` varchar(200) COLLATE utf8_bin DEFAULT '',
  `adif` int(11) DEFAULT 0,
  `band` varchar(6) COLLATE utf8_bin DEFAULT '',
  `qso_dxcc` int(11) DEFAULT 0,
  `profile` int(11) DEFAULT 0,
  `idcall` varchar(20) COLLATE utf8_bin DEFAULT '',
  `state` varchar(4) COLLATE utf8_bin DEFAULT '',
  `lotw_qslsdate` date DEFAULT NULL,
  `lotw_qslrdate` date DEFAULT NULL,
  `lotw_qsls` varchar(3) COLLATE utf8_bin NOT NULL DEFAULT '',
  `lotw_qslr` varchar(3) COLLATE utf8_bin NOT NULL DEFAULT '',
  `cont` varchar(3) COLLATE utf8_bin DEFAULT '',
  `qsls_date` varchar(10) COLLATE utf8_bin DEFAULT NULL,
  `qslr_date` varchar(10) COLLATE utf8_bin DEFAULT NULL,
  `club_nr1` varchar(100) COLLATE utf8_bin DEFAULT '',
  `club_nr2` varchar(100) COLLATE utf8_bin DEFAULT '',
  `club_nr3` varchar(100) COLLATE utf8_bin DEFAULT '',
  `club_nr4` varchar(100) COLLATE utf8_bin DEFAULT '',
  `club_nr5` varchar(100) COLLATE utf8_bin DEFAULT '',
  `eqsl_qsl_sent` varchar(1) COLLATE utf8_bin NOT NULL DEFAULT '',
  `eqsl_qslsdate` date DEFAULT NULL,
  `eqsl_qsl_rcvd` varchar(1) COLLATE utf8_bin NOT NULL DEFAULT '',
  `eqsl_qslrdate` date DEFAULT NULL,
  `rxfreq` decimal(10,4) DEFAULT NULL,
  `satellite` varchar(30) COLLATE utf8_bin DEFAULT '',
  `prop_mode` varchar(30) COLLATE utf8_bin DEFAULT '',
  `stx` varchar(6) COLLATE utf8_bin DEFAULT NULL,
  `srx` varchar(6) COLLATE utf8_bin DEFAULT NULL,
  `stx_string` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `srx_string` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `contestname` varchar(40) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`id_cqrlog_main`),
  KEY `main_index` (`qsodate`,`time_on`),
  KEY `callsign` (`callsign`),
  KEY `name` (`name`),
  KEY `qth` (`qth`),
  KEY `adif` (`adif`),
  KEY `idcall` (`idcall`),
  KEY `band` (`band`),
  KEY `club_nr1` (`club_nr1`),
  KEY `club_nr2` (`club_nr2`),
  KEY `club_nr3` (`club_nr3`),
  KEY `club_nr4` (`club_nr4`),
  KEY `club_nr5` (`club_nr5`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cqrlog_main`
--

LOCK TABLES `cqrlog_main` WRITE;
/*!40000 ALTER TABLE `cqrlog_main` DISABLE KEYS */;
INSERT INTO `cqrlog_main` VALUES (1,'2020-01-07','23:15','00:41','K9HE',7.0610,'CW','479','579','John','Crestview FL','','','','','100',8,4,'','','','','',291,'40M',0,-1,'K9HE','',NULL,NULL,'','','NA',NULL,NULL,'','','','','','',NULL,'',NULL,NULL,'','','','','','',''),(2,'2020-01-18','17:50','18:07','WA4FAT',7.0580,'CW','599','569','Bill','Birmingham AL','','','','','100',8,5,'','','','','',291,'40M',0,-1,'WA4FAT','',NULL,NULL,'','','NA',NULL,NULL,'','','','','','',NULL,'',NULL,NULL,'','','','','','','');
/*!40000 ALTER TABLE `cqrlog_main` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `db_version`
--

DROP TABLE IF EXISTS `db_version`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `db_version` (
  `nr` smallint(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `db_version`
--

LOCK TABLES `db_version` WRITE;
/*!40000 ALTER TABLE `db_version` DISABLE KEYS */;
INSERT INTO `db_version` VALUES (16);
/*!40000 ALTER TABLE `db_version` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dxcc_id`
--

DROP TABLE IF EXISTS `dxcc_id`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dxcc_id` (
  `id_dxcc` int(11) NOT NULL AUTO_INCREMENT,
  `adif` int(11) DEFAULT 0,
  `dxcc_ref` varchar(16) COLLATE utf8_bin NOT NULL,
  `country` varchar(100) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`id_dxcc`),
  KEY `adif` (`adif`)
) ENGINE=InnoDB AUTO_INCREMENT=2017 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dxcc_id`
--

LOCK TABLES `dxcc_id` WRITE;
/*!40000 ALTER TABLE `dxcc_id` DISABLE KEYS */;
INSERT INTO `dxcc_id` VALUES (1613,246,'1A','Sovereign Military Order of Malta'),(1614,247,'1S','Spratly Islands'),(1615,260,'3A','Monaco'),(1616,4,'3B6','Agalega & Saint Brandon Is.'),(1617,165,'3B8','Mauritius'),(1618,207,'3B9','Rodrigues Island'),(1619,49,'3C','Equatorial Guinea'),(1620,195,'3C0','Pagalu (Annobon) Island'),(1621,176,'3D2','Fiji'),(1622,489,'3D2(C)','Conway Reef (Ceva-I-Ra)'),(1623,460,'3D2(R)','Rotuma Island'),(1624,468,'3DA','The Kingdom of eSwatini (Swaziland)'),(1625,474,'3V','Tunisia'),(1626,293,'3W','Viet Nam'),(1627,107,'3X','Guinea'),(1628,24,'3Y(B)','Bouvet Island'),(1629,199,'3Y(P)','Peter I. Island'),(1630,18,'4J','Azerbaijan'),(1631,75,'4L','Georgia'),(1632,514,'4O','Montenegro'),(1633,315,'4S','Sri Lanka (Ceylon)'),(1634,117,'4U(I)','ITU HQ Geneva'),(1635,289,'4U(U)','UN HQ ARC New York (USA)'),(1636,511,'4W','Timor - Leste'),(1637,336,'4X','Israel'),(1638,436,'5A','Libya'),(1639,215,'5B','Cyprus'),(1640,470,'5H','Tanzania'),(1641,450,'5N','Nigeria'),(1642,438,'5R','Madagascar (Malagasy Rep.)'),(1643,444,'5T','Mauritania'),(1644,187,'5U','Niger'),(1645,483,'5V','Togo'),(1646,190,'5W','Samoa'),(1647,286,'5X','Uganda'),(1648,430,'5Z','Kenya'),(1649,456,'6W','Senegal'),(1650,82,'6Y','Jamaica'),(1651,492,'7O','Yemen'),(1652,432,'7P','Lesotho'),(1653,440,'7Q','Malawi'),(1654,400,'7X','Algeria'),(1655,62,'8P','Barbados'),(1656,159,'8Q','Maldives'),(1657,129,'8R','Guyana'),(1658,497,'9A','Croatia'),(1659,424,'9G','Ghana'),(1660,257,'9H','Malta'),(1661,482,'9J','Zambia'),(1662,348,'9K','Kuwait'),(1663,458,'9L','Sierra Leone'),(1664,299,'9M2','West Malaysia'),(1665,46,'9M6','East Malaysia'),(1666,369,'9N','Nepal'),(1667,414,'9Q','Democratic Republic of the Congo'),(1668,404,'9U','Burundi'),(1669,381,'9V','Singapore'),(1670,454,'9X','Rwanda'),(1671,90,'9Y','Trinidad & Tobago'),(1672,402,'A2','Botswana (Bechuanaland)'),(1673,160,'A3','Tonga'),(1674,370,'A4','Oman'),(1675,306,'A5','Bhutan'),(1676,391,'A6','United Arab Emirates'),(1677,376,'A7','Qatar'),(1678,304,'A9','Bahrain'),(1679,372,'AP','Pakistan'),(1680,506,'BS7H','Scarborough (Huang Yan Dao) Reef'),(1681,386,'BV','Taiwan (Formosa)'),(1682,505,'BV9P','Pratas (Tung Sha Dao) Island'),(1683,318,'BY','China'),(1684,157,'C2','Nauru'),(1685,203,'C3','Andorra'),(1686,422,'C5','The Gambia'),(1687,60,'C6','Bahamas'),(1688,181,'C9','Mozambique'),(1689,112,'CE','Chile'),(1690,47,'CE0(A)','Easter Islands (Rapa Nui)'),(1691,217,'CE0(X)','San Felix & San Ambrosio Islands'),(1692,125,'CE0(Z)','Juan Fernandez Islands'),(1693,13,'CE9','Antarctica'),(1694,446,'CN','Morocco'),(1695,70,'CO','Cuba'),(1696,104,'CP','Bolivia'),(1697,272,'CT','Portugal'),(1698,149,'CT8','Azores Islands'),(1699,256,'CT9','Madeira Islands'),(1700,144,'CX','Uruguay'),(1701,211,'CY0','Sable Island'),(1702,252,'CY9','Saint Paul Island'),(1703,401,'D2','Angola'),(1704,409,'D4','Cape Verde'),(1705,411,'D6','Comoros'),(1706,230,'DL','Federal Republic of Germany'),(1707,375,'DU','Philippines'),(1708,51,'E3','Eritrea'),(1709,510,'E4','Palestine'),(1710,191,'E51(N)','North Cook Islands'),(1711,234,'E51(S)','South Cook Islands'),(1712,188,'E6','Niue'),(1713,501,'E7','Bosnia-Herzegovina'),(1714,281,'EA','Spain'),(1715,21,'EA6','Balearic Islands'),(1716,29,'EA8','Canary Islands'),(1717,32,'EA9','Ceuta & Melilla'),(1718,245,'EI','Ireland'),(1719,14,'EK','Armenia'),(1720,434,'EL','Liberia'),(1721,330,'EP','Iran'),(1722,179,'ER','Moldova'),(1723,52,'ES','Estonia'),(1724,53,'ET','Ethiopia'),(1725,27,'EU','Belarus'),(1726,135,'EX','Kyrgyzstan'),(1727,262,'EY','Tajikistan'),(1728,280,'EZ','Turkmenistan'),(1729,227,'F','France'),(1730,79,'FG','Guadeloupe Island'),(1731,169,'FH','Mayotte'),(1732,516,'FJ','Saint Barthelemy (Saint Bart\'s) Island'),(1733,162,'FK','New Caledonia'),(1734,512,'FK(C)','Chesterfield Islands'),(1735,84,'FM','Martinique'),(1736,175,'FO','French Polynesia'),(1737,508,'FO(A)','Austral Islands'),(1738,36,'FO(C)','Clipperton Island'),(1739,509,'FO(M)','Marquesas Islands'),(1740,277,'FP','Saint Pierre & Miquelon'),(1741,453,'FR','Reunion'),(1742,213,'FS','Saint Martin Island'),(1743,99,'FT(G)','Glorioso Island (Isles Glorieuses)'),(1744,124,'FT(J)','Juan de Nova, Europa'),(1745,276,'FT(T)','Tromelin Island'),(1746,41,'FT(W)','Crozet Island'),(1747,131,'FT(X)','Kerguelen Islands'),(1748,10,'FT(Z)','Amsterdam & Saint Paul Islands'),(1749,298,'FW','Wallis & Futuna Islands'),(1750,63,'FY','French Guiana'),(1751,223,'G','England'),(1752,114,'GD','Isle of Man'),(1753,265,'GI','Northern Ireland'),(1754,122,'GJ','Jersey'),(1755,279,'GM','Scotland'),(1756,106,'GU','Guernsey'),(1757,294,'GW','Wales'),(1758,185,'H4','Solomon Islands'),(1759,507,'H40','Temotu Province'),(1760,239,'HA','Hungary'),(1761,287,'HB','Switzerland'),(1762,251,'HB0','Liechtenstein'),(1763,120,'HC','Ecuador'),(1764,71,'HC8','Galapagos Islands'),(1765,78,'HH','Haiti'),(1766,72,'HI','Dominican Rep.'),(1767,116,'HK','Colombia'),(1768,216,'HK0(A)','San Andres & Providencia'),(1769,161,'HK0(M)','Malpelo Island'),(1770,137,'HL','Republic of Korea'),(1771,88,'HP','Panama'),(1772,80,'HR','Honduras'),(1773,387,'HS','Thailand'),(1774,295,'HV','Vatican'),(1775,378,'HZ','Saudi Arabia'),(1776,248,'I','Italy'),(1777,225,'IS','Sardinia'),(1778,382,'J2','Djibouti'),(1779,77,'J3','Grenada'),(1780,109,'J5','Guinea-Bissau'),(1781,97,'J6','Saint Lucia'),(1782,95,'J7','Dominica'),(1783,98,'J8','Saint Vincent & Grenadines'),(1784,339,'JA','Japan'),(1785,177,'JD1(M)','Minami Torishima (Marcus Island)'),(1786,192,'JD1(O)','Ogasawara (Bonin & Volcano Isl., Iwo Jima)'),(1787,363,'JT','Mongolia'),(1788,259,'JW','Spitsbergen (Svalbard)'),(1789,118,'JX','Jan Mayen Island'),(1790,342,'JY','Jordan'),(1791,105,'KG4','Guantanamo Bay'),(1792,166,'KH0','Mariana Islands'),(1793,20,'KH1','Baker & Howland Islands'),(1794,103,'KH2','Guam'),(1795,123,'KH3','Johnston Islands'),(1796,174,'KH4','Midway Island'),(1797,197,'KH5','Palmyra & Jarvis Islands'),(1798,110,'KH6','Hawaii'),(1799,138,'KH7(K)','Kure Island'),(1800,9,'KH8','American Samoa'),(1801,515,'KH8(S)','Swain\'s Island'),(1802,297,'KH9','Wake Island'),(1803,6,'KL','Alaska'),(1804,182,'KP1','Navassa Island'),(1805,285,'KP2','Virgin Islands'),(1806,202,'KP4','Puerto Rico'),(1807,43,'KP5','Desecheo Island'),(1808,266,'LA','Norway'),(1809,100,'LU','Argentina'),(1810,254,'LX','Luxembourg'),(1811,146,'LY','Lithuania'),(1812,212,'LZ','Bulgaria'),(1813,136,'OA','Peru'),(1814,354,'OD','Lebanon'),(1815,206,'OE','Austria'),(1816,224,'OH','Finland'),(1817,5,'OH0','Aland Islands'),(1818,167,'OJ0','Market Reef'),(1819,503,'OK','Czech Republic'),(1820,504,'OM','Slovak Republic'),(1821,209,'ON','Belgium'),(1822,237,'OX','Greenland (Kalaallit Nunaat)'),(1823,222,'OY','Faeroe Islands'),(1824,221,'OZ','Denmark'),(1825,163,'P2','Papua New Guinea'),(1826,91,'P4','Aruba'),(1827,344,'P5','DPR of Korea'),(1828,263,'PA','Netherlands'),(1829,517,'PJ2','Curacao'),(1830,520,'PJ4','Bonaire'),(1831,519,'PJ6','Saba & Saint Eustatius'),(1832,518,'PJ7','Sint Maarten'),(1833,108,'PY','Brazil'),(1834,56,'PY0(F)','Fernando de Noronha'),(1835,253,'PY0(S)','Saint Peter & Saint Paul Rocks'),(1836,273,'PY0(T)','Trindade & Martim Vaz Islands'),(1837,140,'PZ','Suriname'),(1838,61,'R1(F)','Franz Josef Land, [Russian Territory] (FJ)'),(1839,302,'S0','Western Sahara'),(1840,305,'S2','Bangladesh (East Pakistan)'),(1841,499,'S5','Slovenia'),(1842,379,'S7','Seychelles'),(1843,219,'S9','Sao Tome & Principe'),(1844,284,'SM','Sweden'),(1845,269,'SP','Poland'),(1846,466,'ST','Sudan'),(1847,478,'SU','Egypt'),(1848,236,'SV','Greece'),(1849,180,'SV(A)','Mount Athos'),(1850,45,'SV5','Dodecanese'),(1851,40,'SV9','Crete'),(1852,282,'T2','Tuvalu'),(1853,301,'T30','West Kiribati (Gilbert Is.)'),(1854,31,'T31','Central Kiribati (British Phoenix Is.)'),(1855,48,'T32','East Kiribati (Line Is.)'),(1856,490,'T33','Banaba (Ocean) Island'),(1857,232,'T5','Somalia'),(1858,278,'T7','San Marino'),(1859,22,'T8','Republic of Palau (Belau)'),(1860,390,'TA','Turkey'),(1861,242,'TF','Iceland'),(1862,76,'TG','Guatemala'),(1863,308,'TI','Costa Rica'),(1864,37,'TI9','Cocos Island'),(1865,406,'TJ','Cameroon'),(1866,214,'TK','Corsica'),(1867,408,'TL','Central African Republic'),(1868,412,'TN','Congo'),(1869,420,'TR','Gabon'),(1870,410,'TT','Chad'),(1871,428,'TU','Cote d\'Ivoire'),(1872,416,'TY','Benin'),(1873,442,'TZ','Mali'),(1874,15,'UA(AS)','Russia (Asiatic)'),(1875,54,'UA(EU)','Russia (European)'),(1876,126,'UA(K)','Kaliningrad (Koenigsberg)'),(1877,292,'UK','Uzbekistan'),(1878,130,'UN','Kazakhstan'),(1879,288,'UT','Ukraine'),(1880,94,'V2','Antigua & Barbuda'),(1881,66,'V3','Belize'),(1882,249,'V4','Saint Kitts & Nevis'),(1883,464,'V5','Namibia'),(1884,173,'V6','Federated States of Micronesia'),(1885,168,'V7','Marshall Islands'),(1886,345,'V8','Brunei Darussalam'),(1887,1,'VE','Canada'),(1888,150,'VK','Australia'),(1889,111,'VK0(H)','Heard Island'),(1890,153,'VK0(M)','Macquarie Island'),(1891,38,'VK9(C)','Cocos (Keeling) Islands'),(1892,147,'VK9(L)','Lord Howe Island'),(1893,171,'VK9(M)','Mellish Reef'),(1894,189,'VK9(N)','Norfolk Island'),(1895,303,'VK9(W)','Willis Island'),(1896,35,'VK9(X)','Christmas Island'),(1897,12,'VP2E','Anguilla'),(1898,96,'VP2M','Montserrat'),(1899,65,'VP2V','British Virgin Islands'),(1900,89,'VP5','Turks & Caicos Islands'),(1901,172,'VP6','Pitcairn Island'),(1902,513,'VP6(D)','Ducie Atoll'),(1903,141,'VP8(F)','Falkland Islands'),(1904,235,'VP8(G)','South Georgia (San Pedro) Islands'),(1905,241,'VP8(H)','South Shetland Islands'),(1906,238,'VP8(O)','South Orkney Islands'),(1907,240,'VP8(S)','South Sandwich Islands'),(1908,64,'VP9','Bermuda'),(1909,33,'VQ9','Chagos (Diego Garcia Isl.)'),(1910,321,'VR','Hong Kong'),(1911,324,'VU','India'),(1912,11,'VU(A)','Andaman & Nicobar Islands'),(1913,142,'VU(L)','Laccadive Islands (Lakshadweep)'),(1914,291,'W','United States'),(1915,50,'XE','Mexico'),(1916,204,'XF4','Revillagigedo'),(1917,480,'XT','Burkina Faso (Upper Volta)'),(1918,312,'XU','Cambodia (Kampuchea)'),(1919,143,'XW','Laos'),(1920,152,'XX','Macao'),(1921,309,'XZ','Myanmar (Burma)'),(1922,3,'YA','Afghanistan'),(1923,327,'YB','Indonesia'),(1924,333,'YI','Iraq'),(1925,158,'YJ','Vanuatu (New Hebrides)'),(1926,384,'YK','Syria'),(1927,145,'YL','Latvia'),(1928,86,'YN','Nicaragua'),(1929,275,'YO','Romania'),(1930,74,'YS','El Salvador'),(1931,296,'YU','Serbia'),(1932,148,'YV','Venezuela'),(1933,17,'YV0','Aves Island'),(1934,452,'Z2','Zimbabwe (Southern Rhodesia)'),(1935,502,'Z3','North Macedonia'),(1936,522,'Z6','Republic of Kosovo'),(1937,521,'Z8','Republic of South Sudan'),(1938,7,'ZA','Albania'),(1939,233,'ZB','Gibraltar'),(1940,283,'ZC4','UK Sovereign Base Areas on Cyprus'),(1941,250,'ZD7','Saint Helena Island'),(1942,205,'ZD8','Ascension Island'),(1943,274,'ZD9','Tristan da Cunha & Gough Islands'),(1944,69,'ZF','Cayman Islands'),(1945,270,'ZK3','Tokelau Island'),(1946,170,'ZL','New Zealand'),(1947,34,'ZL7','Chatham Island'),(1948,133,'ZL8','Kermadec Island'),(1949,16,'ZL9','New Zealand Subantarctic Islands'),(1950,132,'ZP','Paraguay'),(1951,462,'ZS','South Africa'),(1952,201,'ZS(M)','Prince Edward & Marion Islands'),(1953,23,'1B9*','Blenheim Reef'),(1954,93,'1G5*','Geyser Reef'),(1955,178,'1M4*','Minerva Reef'),(1956,154,'4W1*','Yemen Arab Republic'),(1957,194,'7J1(O)*','Okino Tori-shima (Parece Vela - Douglas Reef)'),(1958,226,'8Z4*','Saudi Arabia/Iraq Neutral Zone'),(1959,68,'8Z5*','Kuwait/Saudi Arabia Neutral Zone'),(1960,210,'9S4*','Saar'),(1961,208,'9U5*','Ruanda-Urundi'),(1962,2,'A1*','Abu Ail, Jabal at Tair'),(1963,231,'AC3*','Sikkim'),(1964,268,'AC4*','Tibet'),(1965,164,'C9*','Manchuria'),(1966,264,'CN2*','Tangier'),(1967,200,'CR8*','Portuguese Timor'),(1968,42,'CR8(D)*','Damao, Diu'),(1969,101,'CR8(G)*','Goa'),(1970,81,'DL*','Germany'),(1971,229,'DM*','German Democratic Republic'),(1972,113,'EA9*','Ifni (Rio de Oro)'),(1973,59,'FF*','French West Africa'),(1974,39,'FH(C)*','Comoros'),(1975,58,'FI8*','French Indo-China'),(1976,67,'FN8*','French India'),(1977,57,'FQ8*','French Equatorial Africa'),(1978,19,'HK0(B)*','Bajo Nuevo'),(1979,228,'HK0(S)*','Serrana Bank & Roncador Cay'),(1980,271,'I1*','Trieste'),(1981,115,'I5*','Italian Somaliland'),(1982,193,'J9*','Okinawa (Ryukyu Is)'),(1983,184,'JZ0*','Netherlands N. Guinea'),(1984,134,'KH5(K)*','Kingman Reef'),(1985,193,'KR(O)*','Okinawa (Ryukyu Is)'),(1986,261,'KS4(B)*','Swan Island'),(1987,28,'KZ5*','Canal Zone'),(1988,218,'OK*','Czechoslovakia'),(1989,198,'P2*','Papua Territory'),(1990,267,'P2*','Territory of New Guinea'),(1991,85,'PJ2*','Netherlands Antilles, Curacao'),(1992,255,'PJ7*','Sint Maarten'),(1993,119,'PK1*','Java'),(1994,258,'PK4*','Sumatra'),(1995,183,'PK5*','Dutch Borneo'),(1996,30,'PK6*','Celebes & Molucca Islands'),(1997,151,'R1(M)*','Malyj Vysotskij Island, [Russian Territory] (MV)'),(1998,244,'ST0*','Southern Sudan'),(1999,128,'UN1*','Karelo-Finnish Republic'),(2000,186,'VO*','Newfoundland, Labrador'),(2001,307,'VQ1*','Zanzibar'),(2002,26,'VQ6*','British Somaliland'),(2003,8,'VQ9(A)*','Aldabra Isl.'),(2004,44,'VQ9(D)*','Desroches Isl.'),(2005,55,'VQ9(F)*','Farquhar Isl.'),(2006,155,'VS2*','Malaya'),(2007,220,'VS4*','Sarawak'),(2008,243,'VS9A*','Peoples Dem. Rep. of Yemen'),(2009,139,'VS9H*','Kuria Muria Is.'),(2010,127,'VS9K*','Kamaran Is.'),(2011,25,'ZC5*','British North Borneo & Labuan'),(2012,196,'ZC6*','Palestine'),(2013,102,'ZD4*','Gold Coast, Togoland'),(2014,493,'ZS(P)*','Penguin Island'),(2015,488,'ZS(W)*','Walvis Bay'),(2016,0,'!','Unknown country');
/*!40000 ALTER TABLE `dxcc_id` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `freqmem`
--

DROP TABLE IF EXISTS `freqmem`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `freqmem` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `freq` decimal(10,4) NOT NULL,
  `mode` varchar(12) COLLATE utf8_bin NOT NULL,
  `bandwidth` int(11) NOT NULL,
  `info` varchar(25) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `freqmem`
--

LOCK TABLES `freqmem` WRITE;
/*!40000 ALTER TABLE `freqmem` DISABLE KEYS */;
/*!40000 ALTER TABLE `freqmem` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `log_changes`
--

DROP TABLE IF EXISTS `log_changes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `log_changes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_cqrlog_main` int(11) DEFAULT NULL,
  `cmd` varchar(20) COLLATE utf8_bin DEFAULT NULL,
  `qsodate` date DEFAULT NULL,
  `time_on` varchar(5) COLLATE utf8_bin DEFAULT NULL,
  `callsign` varchar(20) COLLATE utf8_bin DEFAULT NULL,
  `mode` varchar(12) COLLATE utf8_bin DEFAULT NULL,
  `band` varchar(6) COLLATE utf8_bin DEFAULT NULL,
  `freq` decimal(10,4) DEFAULT NULL,
  `old_qsodate` date DEFAULT NULL,
  `old_time_on` varchar(5) COLLATE utf8_bin DEFAULT NULL,
  `old_callsign` varchar(20) COLLATE utf8_bin DEFAULT NULL,
  `old_mode` varchar(12) COLLATE utf8_bin DEFAULT NULL,
  `old_band` varchar(6) COLLATE utf8_bin DEFAULT NULL,
  `old_freq` decimal(10,4) DEFAULT NULL,
  `upddeleted` int(1) DEFAULT 1,
  PRIMARY KEY (`id`),
  KEY `id_cqrlog_main` (`id_cqrlog_main`),
  CONSTRAINT `log_changes_ibfk_1` FOREIGN KEY (`id_cqrlog_main`) REFERENCES `cqrlog_main` (`id_cqrlog_main`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `log_changes`
--

LOCK TABLES `log_changes` WRITE;
/*!40000 ALTER TABLE `log_changes` DISABLE KEYS */;
INSERT INTO `log_changes` VALUES (1,NULL,'ALLDONE',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1);
/*!40000 ALTER TABLE `log_changes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `long_note`
--

DROP TABLE IF EXISTS `long_note`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `long_note` (
  `id_long_note` int(11) NOT NULL AUTO_INCREMENT,
  `note` longtext COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`id_long_note`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `long_note`
--

LOCK TABLES `long_note` WRITE;
/*!40000 ALTER TABLE `long_note` DISABLE KEYS */;
/*!40000 ALTER TABLE `long_note` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `notes`
--

DROP TABLE IF EXISTS `notes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `notes` (
  `id_notes` int(11) NOT NULL AUTO_INCREMENT,
  `callsign` varchar(20) COLLATE utf8_bin DEFAULT '',
  `longremarks` varchar(256) COLLATE utf8_bin DEFAULT '',
  PRIMARY KEY (`id_notes`),
  KEY `callsign` (`callsign`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `notes`
--

LOCK TABLES `notes` WRITE;
/*!40000 ALTER TABLE `notes` DISABLE KEYS */;
/*!40000 ALTER TABLE `notes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `profiles`
--

DROP TABLE IF EXISTS `profiles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `profiles` (
  `id_profiles` int(11) NOT NULL AUTO_INCREMENT,
  `nr` int(11) NOT NULL,
  `locator` varchar(6) COLLATE utf8_bin DEFAULT '',
  `qth` varchar(250) COLLATE utf8_bin DEFAULT '',
  `rig` varchar(250) COLLATE utf8_bin DEFAULT '',
  `remarks` varchar(250) COLLATE utf8_bin DEFAULT '',
  `visible` int(11) DEFAULT 1,
  PRIMARY KEY (`id_profiles`),
  KEY `nr` (`nr`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `profiles`
--

LOCK TABLES `profiles` WRITE;
/*!40000 ALTER TABLE `profiles` DISABLE KEYS */;
/*!40000 ALTER TABLE `profiles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `upload_status`
--

DROP TABLE IF EXISTS `upload_status`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `upload_status` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `logname` varchar(30) COLLATE utf8_bin NOT NULL,
  `id_log_changes` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `id_log_changes` (`id_log_changes`),
  CONSTRAINT `upload_status_ibfk_1` FOREIGN KEY (`id_log_changes`) REFERENCES `log_changes` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `upload_status`
--

LOCK TABLES `upload_status` WRITE;
/*!40000 ALTER TABLE `upload_status` DISABLE KEYS */;
INSERT INTO `upload_status` VALUES (1,'HamQTH',1),(2,'ClubLog',1),(3,'HRDLog',1);
/*!40000 ALTER TABLE `upload_status` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `version`
--

DROP TABLE IF EXISTS `version`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `version` (
  `major` int(11) DEFAULT 0,
  `minor` int(11) DEFAULT 9,
  `releas` int(11) DEFAULT 4
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `version`
--

LOCK TABLES `version` WRITE;
/*!40000 ALTER TABLE `version` DISABLE KEYS */;
/*!40000 ALTER TABLE `version` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Temporary table structure for view `view_cqrlog_main_by_callsign`
--

DROP TABLE IF EXISTS `view_cqrlog_main_by_callsign`;
/*!50001 DROP VIEW IF EXISTS `view_cqrlog_main_by_callsign`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE TABLE `view_cqrlog_main_by_callsign` (
  `id_cqrlog_main` tinyint NOT NULL,
  `qsodate` tinyint NOT NULL,
  `time_on` tinyint NOT NULL,
  `time_off` tinyint NOT NULL,
  `callsign` tinyint NOT NULL,
  `freq` tinyint NOT NULL,
  `mode` tinyint NOT NULL,
  `rst_s` tinyint NOT NULL,
  `rst_r` tinyint NOT NULL,
  `name` tinyint NOT NULL,
  `qth` tinyint NOT NULL,
  `qsl_s` tinyint NOT NULL,
  `qsl_r` tinyint NOT NULL,
  `qsl_via` tinyint NOT NULL,
  `iota` tinyint NOT NULL,
  `pwr` tinyint NOT NULL,
  `itu` tinyint NOT NULL,
  `waz` tinyint NOT NULL,
  `loc` tinyint NOT NULL,
  `my_loc` tinyint NOT NULL,
  `county` tinyint NOT NULL,
  `award` tinyint NOT NULL,
  `remarks` tinyint NOT NULL,
  `band` tinyint NOT NULL,
  `dxcc_ref` tinyint NOT NULL,
  `qso_dxcc` tinyint NOT NULL,
  `profile` tinyint NOT NULL,
  `idcall` tinyint NOT NULL,
  `state` tinyint NOT NULL,
  `lotw_qslsdate` tinyint NOT NULL,
  `lotw_qslrdate` tinyint NOT NULL,
  `lotw_qsls` tinyint NOT NULL,
  `lotw_qslr` tinyint NOT NULL,
  `cont` tinyint NOT NULL,
  `qsls_date` tinyint NOT NULL,
  `qslr_date` tinyint NOT NULL,
  `club_nr1` tinyint NOT NULL,
  `club_nr2` tinyint NOT NULL,
  `club_nr3` tinyint NOT NULL,
  `club_nr4` tinyint NOT NULL,
  `club_nr5` tinyint NOT NULL,
  `eqsl_qsl_sent` tinyint NOT NULL,
  `eqsl_qslsdate` tinyint NOT NULL,
  `eqsl_qsl_rcvd` tinyint NOT NULL,
  `eqsl_qslrdate` tinyint NOT NULL,
  `qslr` tinyint NOT NULL,
  `country` tinyint NOT NULL,
  `rxfreq` tinyint NOT NULL,
  `satellite` tinyint NOT NULL,
  `prop_mode` tinyint NOT NULL,
  `srx` tinyint NOT NULL,
  `stx` tinyint NOT NULL,
  `srx_string` tinyint NOT NULL,
  `stx_string` tinyint NOT NULL,
  `contestname` tinyint NOT NULL
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `view_cqrlog_main_by_qsodate`
--

DROP TABLE IF EXISTS `view_cqrlog_main_by_qsodate`;
/*!50001 DROP VIEW IF EXISTS `view_cqrlog_main_by_qsodate`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE TABLE `view_cqrlog_main_by_qsodate` (
  `id_cqrlog_main` tinyint NOT NULL,
  `qsodate` tinyint NOT NULL,
  `time_on` tinyint NOT NULL,
  `time_off` tinyint NOT NULL,
  `callsign` tinyint NOT NULL,
  `freq` tinyint NOT NULL,
  `mode` tinyint NOT NULL,
  `rst_s` tinyint NOT NULL,
  `rst_r` tinyint NOT NULL,
  `name` tinyint NOT NULL,
  `qth` tinyint NOT NULL,
  `qsl_s` tinyint NOT NULL,
  `qsl_r` tinyint NOT NULL,
  `qsl_via` tinyint NOT NULL,
  `iota` tinyint NOT NULL,
  `pwr` tinyint NOT NULL,
  `itu` tinyint NOT NULL,
  `waz` tinyint NOT NULL,
  `loc` tinyint NOT NULL,
  `my_loc` tinyint NOT NULL,
  `county` tinyint NOT NULL,
  `award` tinyint NOT NULL,
  `remarks` tinyint NOT NULL,
  `band` tinyint NOT NULL,
  `dxcc_ref` tinyint NOT NULL,
  `qso_dxcc` tinyint NOT NULL,
  `profile` tinyint NOT NULL,
  `idcall` tinyint NOT NULL,
  `state` tinyint NOT NULL,
  `lotw_qslsdate` tinyint NOT NULL,
  `lotw_qslrdate` tinyint NOT NULL,
  `lotw_qsls` tinyint NOT NULL,
  `lotw_qslr` tinyint NOT NULL,
  `cont` tinyint NOT NULL,
  `qsls_date` tinyint NOT NULL,
  `qslr_date` tinyint NOT NULL,
  `club_nr1` tinyint NOT NULL,
  `club_nr2` tinyint NOT NULL,
  `club_nr3` tinyint NOT NULL,
  `club_nr4` tinyint NOT NULL,
  `club_nr5` tinyint NOT NULL,
  `eqsl_qsl_sent` tinyint NOT NULL,
  `eqsl_qslsdate` tinyint NOT NULL,
  `eqsl_qsl_rcvd` tinyint NOT NULL,
  `eqsl_qslrdate` tinyint NOT NULL,
  `qslr` tinyint NOT NULL,
  `country` tinyint NOT NULL,
  `rxfreq` tinyint NOT NULL,
  `satellite` tinyint NOT NULL,
  `prop_mode` tinyint NOT NULL,
  `srx` tinyint NOT NULL,
  `stx` tinyint NOT NULL,
  `srx_string` tinyint NOT NULL,
  `stx_string` tinyint NOT NULL,
  `contestname` tinyint NOT NULL
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;

--
-- Temporary table structure for view `view_cqrlog_main_by_qsodate_asc`
--

DROP TABLE IF EXISTS `view_cqrlog_main_by_qsodate_asc`;
/*!50001 DROP VIEW IF EXISTS `view_cqrlog_main_by_qsodate_asc`*/;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
/*!50001 CREATE TABLE `view_cqrlog_main_by_qsodate_asc` (
  `id_cqrlog_main` tinyint NOT NULL,
  `qsodate` tinyint NOT NULL,
  `time_on` tinyint NOT NULL,
  `time_off` tinyint NOT NULL,
  `callsign` tinyint NOT NULL,
  `freq` tinyint NOT NULL,
  `mode` tinyint NOT NULL,
  `rst_s` tinyint NOT NULL,
  `rst_r` tinyint NOT NULL,
  `name` tinyint NOT NULL,
  `qth` tinyint NOT NULL,
  `qsl_s` tinyint NOT NULL,
  `qsl_r` tinyint NOT NULL,
  `qsl_via` tinyint NOT NULL,
  `iota` tinyint NOT NULL,
  `pwr` tinyint NOT NULL,
  `itu` tinyint NOT NULL,
  `waz` tinyint NOT NULL,
  `loc` tinyint NOT NULL,
  `my_loc` tinyint NOT NULL,
  `county` tinyint NOT NULL,
  `award` tinyint NOT NULL,
  `remarks` tinyint NOT NULL,
  `band` tinyint NOT NULL,
  `dxcc_ref` tinyint NOT NULL,
  `qso_dxcc` tinyint NOT NULL,
  `profile` tinyint NOT NULL,
  `idcall` tinyint NOT NULL,
  `state` tinyint NOT NULL,
  `lotw_qslsdate` tinyint NOT NULL,
  `lotw_qslrdate` tinyint NOT NULL,
  `lotw_qsls` tinyint NOT NULL,
  `lotw_qslr` tinyint NOT NULL,
  `cont` tinyint NOT NULL,
  `qsls_date` tinyint NOT NULL,
  `qslr_date` tinyint NOT NULL,
  `club_nr1` tinyint NOT NULL,
  `club_nr2` tinyint NOT NULL,
  `club_nr3` tinyint NOT NULL,
  `club_nr4` tinyint NOT NULL,
  `club_nr5` tinyint NOT NULL,
  `eqsl_qsl_sent` tinyint NOT NULL,
  `eqsl_qslsdate` tinyint NOT NULL,
  `eqsl_qsl_rcvd` tinyint NOT NULL,
  `eqsl_qslrdate` tinyint NOT NULL,
  `qslr` tinyint NOT NULL,
  `country` tinyint NOT NULL,
  `rxfreq` tinyint NOT NULL,
  `satellite` tinyint NOT NULL,
  `prop_mode` tinyint NOT NULL,
  `srx` tinyint NOT NULL,
  `stx` tinyint NOT NULL,
  `srx_string` tinyint NOT NULL,
  `stx_string` tinyint NOT NULL,
  `contestname` tinyint NOT NULL
) ENGINE=MyISAM */;
SET character_set_client = @saved_cs_client;

--
-- Table structure for table `zipcode1`
--

DROP TABLE IF EXISTS `zipcode1`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `zipcode1` (
  `id_zipcode1` int(11) NOT NULL AUTO_INCREMENT,
  `zip` varchar(20) COLLATE utf8_bin DEFAULT '',
  `county` varchar(100) COLLATE utf8_bin DEFAULT '',
  PRIMARY KEY (`id_zipcode1`),
  KEY `zip` (`zip`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `zipcode1`
--

LOCK TABLES `zipcode1` WRITE;
/*!40000 ALTER TABLE `zipcode1` DISABLE KEYS */;
/*!40000 ALTER TABLE `zipcode1` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `zipcode2`
--

DROP TABLE IF EXISTS `zipcode2`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `zipcode2` (
  `id_zipcode2` int(11) NOT NULL AUTO_INCREMENT,
  `zip` varchar(20) COLLATE utf8_bin DEFAULT '',
  `county` varchar(100) COLLATE utf8_bin DEFAULT '',
  PRIMARY KEY (`id_zipcode2`),
  KEY `zip` (`zip`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `zipcode2`
--

LOCK TABLES `zipcode2` WRITE;
/*!40000 ALTER TABLE `zipcode2` DISABLE KEYS */;
/*!40000 ALTER TABLE `zipcode2` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `zipcode3`
--

DROP TABLE IF EXISTS `zipcode3`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `zipcode3` (
  `id_zipcode3` int(11) NOT NULL AUTO_INCREMENT,
  `zip` varchar(20) COLLATE utf8_bin DEFAULT '',
  `county` varchar(100) COLLATE utf8_bin DEFAULT '',
  PRIMARY KEY (`id_zipcode3`),
  KEY `zip` (`zip`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `zipcode3`
--

LOCK TABLES `zipcode3` WRITE;
/*!40000 ALTER TABLE `zipcode3` DISABLE KEYS */;
/*!40000 ALTER TABLE `zipcode3` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Final view structure for view `view_cqrlog_main_by_callsign`
--

/*!50001 DROP TABLE IF EXISTS `view_cqrlog_main_by_callsign`*/;
/*!50001 DROP VIEW IF EXISTS `view_cqrlog_main_by_callsign`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = latin1 */;
/*!50001 SET character_set_results     = latin1 */;
/*!50001 SET collation_connection      = latin1_swedish_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`` SQL SECURITY DEFINER VIEW `view_cqrlog_main_by_callsign` AS select `cqrlog_main`.`id_cqrlog_main` AS `id_cqrlog_main`,`cqrlog_main`.`qsodate` AS `qsodate`,`cqrlog_main`.`time_on` AS `time_on`,`cqrlog_main`.`time_off` AS `time_off`,`cqrlog_main`.`callsign` AS `callsign`,`cqrlog_main`.`freq` AS `freq`,`cqrlog_main`.`mode` AS `mode`,`cqrlog_main`.`rst_s` AS `rst_s`,`cqrlog_main`.`rst_r` AS `rst_r`,`cqrlog_main`.`name` AS `name`,`cqrlog_main`.`qth` AS `qth`,`cqrlog_main`.`qsl_s` AS `qsl_s`,`cqrlog_main`.`qsl_r` AS `qsl_r`,`cqrlog_main`.`qsl_via` AS `qsl_via`,`cqrlog_main`.`iota` AS `iota`,`cqrlog_main`.`pwr` AS `pwr`,`cqrlog_main`.`itu` AS `itu`,`cqrlog_main`.`waz` AS `waz`,`cqrlog_main`.`loc` AS `loc`,`cqrlog_main`.`my_loc` AS `my_loc`,`cqrlog_main`.`county` AS `county`,`cqrlog_main`.`award` AS `award`,`cqrlog_main`.`remarks` AS `remarks`,`cqrlog_main`.`band` AS `band`,`dxcc_id`.`dxcc_ref` AS `dxcc_ref`,`cqrlog_main`.`qso_dxcc` AS `qso_dxcc`,`cqrlog_main`.`profile` AS `profile`,`cqrlog_main`.`idcall` AS `idcall`,`cqrlog_main`.`state` AS `state`,`cqrlog_main`.`lotw_qslsdate` AS `lotw_qslsdate`,`cqrlog_main`.`lotw_qslrdate` AS `lotw_qslrdate`,`cqrlog_main`.`lotw_qsls` AS `lotw_qsls`,`cqrlog_main`.`lotw_qslr` AS `lotw_qslr`,`cqrlog_main`.`cont` AS `cont`,`cqrlog_main`.`qsls_date` AS `qsls_date`,`cqrlog_main`.`qslr_date` AS `qslr_date`,`cqrlog_main`.`club_nr1` AS `club_nr1`,`cqrlog_main`.`club_nr2` AS `club_nr2`,`cqrlog_main`.`club_nr3` AS `club_nr3`,`cqrlog_main`.`club_nr4` AS `club_nr4`,`cqrlog_main`.`club_nr5` AS `club_nr5`,`cqrlog_main`.`eqsl_qsl_sent` AS `eqsl_qsl_sent`,`cqrlog_main`.`eqsl_qslsdate` AS `eqsl_qslsdate`,`cqrlog_main`.`eqsl_qsl_rcvd` AS `eqsl_qsl_rcvd`,`cqrlog_main`.`eqsl_qslrdate` AS `eqsl_qslrdate`,concat(`cqrlog_main`.`qsl_r`,`cqrlog_main`.`lotw_qslr`,`cqrlog_main`.`eqsl_qsl_rcvd`) AS `qslr`,`dxcc_id`.`country` AS `country`,`cqrlog_main`.`rxfreq` AS `rxfreq`,`cqrlog_main`.`satellite` AS `satellite`,`cqrlog_main`.`prop_mode` AS `prop_mode`,`cqrlog_main`.`srx` AS `srx`,`cqrlog_main`.`stx` AS `stx`,`cqrlog_main`.`srx_string` AS `srx_string`,`cqrlog_main`.`stx_string` AS `stx_string`,`cqrlog_main`.`contestname` AS `contestname` from (`cqrlog_main` join `dxcc_id` on(`dxcc_id`.`adif` = `cqrlog_main`.`adif`)) order by `cqrlog_main`.`callsign` */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;

--
-- Final view structure for view `view_cqrlog_main_by_qsodate`
--

/*!50001 DROP TABLE IF EXISTS `view_cqrlog_main_by_qsodate`*/;
/*!50001 DROP VIEW IF EXISTS `view_cqrlog_main_by_qsodate`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = latin1 */;
/*!50001 SET character_set_results     = latin1 */;
/*!50001 SET collation_connection      = latin1_swedish_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`` SQL SECURITY DEFINER VIEW `view_cqrlog_main_by_qsodate` AS select `cqrlog_main`.`id_cqrlog_main` AS `id_cqrlog_main`,`cqrlog_main`.`qsodate` AS `qsodate`,`cqrlog_main`.`time_on` AS `time_on`,`cqrlog_main`.`time_off` AS `time_off`,`cqrlog_main`.`callsign` AS `callsign`,`cqrlog_main`.`freq` AS `freq`,`cqrlog_main`.`mode` AS `mode`,`cqrlog_main`.`rst_s` AS `rst_s`,`cqrlog_main`.`rst_r` AS `rst_r`,`cqrlog_main`.`name` AS `name`,`cqrlog_main`.`qth` AS `qth`,`cqrlog_main`.`qsl_s` AS `qsl_s`,`cqrlog_main`.`qsl_r` AS `qsl_r`,`cqrlog_main`.`qsl_via` AS `qsl_via`,`cqrlog_main`.`iota` AS `iota`,`cqrlog_main`.`pwr` AS `pwr`,`cqrlog_main`.`itu` AS `itu`,`cqrlog_main`.`waz` AS `waz`,`cqrlog_main`.`loc` AS `loc`,`cqrlog_main`.`my_loc` AS `my_loc`,`cqrlog_main`.`county` AS `county`,`cqrlog_main`.`award` AS `award`,`cqrlog_main`.`remarks` AS `remarks`,`cqrlog_main`.`band` AS `band`,`dxcc_id`.`dxcc_ref` AS `dxcc_ref`,`cqrlog_main`.`qso_dxcc` AS `qso_dxcc`,`cqrlog_main`.`profile` AS `profile`,`cqrlog_main`.`idcall` AS `idcall`,`cqrlog_main`.`state` AS `state`,`cqrlog_main`.`lotw_qslsdate` AS `lotw_qslsdate`,`cqrlog_main`.`lotw_qslrdate` AS `lotw_qslrdate`,`cqrlog_main`.`lotw_qsls` AS `lotw_qsls`,`cqrlog_main`.`lotw_qslr` AS `lotw_qslr`,`cqrlog_main`.`cont` AS `cont`,`cqrlog_main`.`qsls_date` AS `qsls_date`,`cqrlog_main`.`qslr_date` AS `qslr_date`,`cqrlog_main`.`club_nr1` AS `club_nr1`,`cqrlog_main`.`club_nr2` AS `club_nr2`,`cqrlog_main`.`club_nr3` AS `club_nr3`,`cqrlog_main`.`club_nr4` AS `club_nr4`,`cqrlog_main`.`club_nr5` AS `club_nr5`,`cqrlog_main`.`eqsl_qsl_sent` AS `eqsl_qsl_sent`,`cqrlog_main`.`eqsl_qslsdate` AS `eqsl_qslsdate`,`cqrlog_main`.`eqsl_qsl_rcvd` AS `eqsl_qsl_rcvd`,`cqrlog_main`.`eqsl_qslrdate` AS `eqsl_qslrdate`,concat(`cqrlog_main`.`qsl_r`,`cqrlog_main`.`lotw_qslr`,`cqrlog_main`.`eqsl_qsl_rcvd`) AS `qslr`,`dxcc_id`.`country` AS `country`,`cqrlog_main`.`rxfreq` AS `rxfreq`,`cqrlog_main`.`satellite` AS `satellite`,`cqrlog_main`.`prop_mode` AS `prop_mode`,`cqrlog_main`.`srx` AS `srx`,`cqrlog_main`.`stx` AS `stx`,`cqrlog_main`.`srx_string` AS `srx_string`,`cqrlog_main`.`stx_string` AS `stx_string`,`cqrlog_main`.`contestname` AS `contestname` from (`cqrlog_main` join `dxcc_id` on(`dxcc_id`.`adif` = `cqrlog_main`.`adif`)) order by `cqrlog_main`.`qsodate` desc,`cqrlog_main`.`time_on` desc */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;

--
-- Final view structure for view `view_cqrlog_main_by_qsodate_asc`
--

/*!50001 DROP TABLE IF EXISTS `view_cqrlog_main_by_qsodate_asc`*/;
/*!50001 DROP VIEW IF EXISTS `view_cqrlog_main_by_qsodate_asc`*/;
/*!50001 SET @saved_cs_client          = @@character_set_client */;
/*!50001 SET @saved_cs_results         = @@character_set_results */;
/*!50001 SET @saved_col_connection     = @@collation_connection */;
/*!50001 SET character_set_client      = latin1 */;
/*!50001 SET character_set_results     = latin1 */;
/*!50001 SET collation_connection      = latin1_swedish_ci */;
/*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`` SQL SECURITY DEFINER VIEW `view_cqrlog_main_by_qsodate_asc` AS select `cqrlog_main`.`id_cqrlog_main` AS `id_cqrlog_main`,`cqrlog_main`.`qsodate` AS `qsodate`,`cqrlog_main`.`time_on` AS `time_on`,`cqrlog_main`.`time_off` AS `time_off`,`cqrlog_main`.`callsign` AS `callsign`,`cqrlog_main`.`freq` AS `freq`,`cqrlog_main`.`mode` AS `mode`,`cqrlog_main`.`rst_s` AS `rst_s`,`cqrlog_main`.`rst_r` AS `rst_r`,`cqrlog_main`.`name` AS `name`,`cqrlog_main`.`qth` AS `qth`,`cqrlog_main`.`qsl_s` AS `qsl_s`,`cqrlog_main`.`qsl_r` AS `qsl_r`,`cqrlog_main`.`qsl_via` AS `qsl_via`,`cqrlog_main`.`iota` AS `iota`,`cqrlog_main`.`pwr` AS `pwr`,`cqrlog_main`.`itu` AS `itu`,`cqrlog_main`.`waz` AS `waz`,`cqrlog_main`.`loc` AS `loc`,`cqrlog_main`.`my_loc` AS `my_loc`,`cqrlog_main`.`county` AS `county`,`cqrlog_main`.`award` AS `award`,`cqrlog_main`.`remarks` AS `remarks`,`cqrlog_main`.`band` AS `band`,`dxcc_id`.`dxcc_ref` AS `dxcc_ref`,`cqrlog_main`.`qso_dxcc` AS `qso_dxcc`,`cqrlog_main`.`profile` AS `profile`,`cqrlog_main`.`idcall` AS `idcall`,`cqrlog_main`.`state` AS `state`,`cqrlog_main`.`lotw_qslsdate` AS `lotw_qslsdate`,`cqrlog_main`.`lotw_qslrdate` AS `lotw_qslrdate`,`cqrlog_main`.`lotw_qsls` AS `lotw_qsls`,`cqrlog_main`.`lotw_qslr` AS `lotw_qslr`,`cqrlog_main`.`cont` AS `cont`,`cqrlog_main`.`qsls_date` AS `qsls_date`,`cqrlog_main`.`qslr_date` AS `qslr_date`,`cqrlog_main`.`club_nr1` AS `club_nr1`,`cqrlog_main`.`club_nr2` AS `club_nr2`,`cqrlog_main`.`club_nr3` AS `club_nr3`,`cqrlog_main`.`club_nr4` AS `club_nr4`,`cqrlog_main`.`club_nr5` AS `club_nr5`,`cqrlog_main`.`eqsl_qsl_sent` AS `eqsl_qsl_sent`,`cqrlog_main`.`eqsl_qslsdate` AS `eqsl_qslsdate`,`cqrlog_main`.`eqsl_qsl_rcvd` AS `eqsl_qsl_rcvd`,`cqrlog_main`.`eqsl_qslrdate` AS `eqsl_qslrdate`,concat(`cqrlog_main`.`qsl_r`,`cqrlog_main`.`lotw_qslr`,`cqrlog_main`.`eqsl_qsl_rcvd`) AS `qslr`,`dxcc_id`.`country` AS `country`,`cqrlog_main`.`rxfreq` AS `rxfreq`,`cqrlog_main`.`satellite` AS `satellite`,`cqrlog_main`.`prop_mode` AS `prop_mode`,`cqrlog_main`.`srx` AS `srx`,`cqrlog_main`.`stx` AS `stx`,`cqrlog_main`.`srx_string` AS `srx_string`,`cqrlog_main`.`stx_string` AS `stx_string`,`cqrlog_main`.`contestname` AS `contestname` from (`cqrlog_main` join `dxcc_id` on(`dxcc_id`.`adif` = `cqrlog_main`.`adif`)) order by `cqrlog_main`.`qsodate`,`cqrlog_main`.`time_on` */;
/*!50001 SET character_set_client      = @saved_cs_client */;
/*!50001 SET character_set_results     = @saved_cs_results */;
/*!50001 SET collation_connection      = @saved_col_connection */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2020-11-06 14:29:47