We think it's a good idea to show you how LiHaLo is made. This means : how the MySQL-Tables are made.
This might be very usefull to put together your CMD-SEARCH-STATEMENT. What follows are "screenshots" straight from MySQL.
You'll get to know something about MySQL in order to take benefit of this .... .
So let's start :
mysql> use LiHaLo
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables ; +------------------+ | Tables_in_LiHaLo | +------------------+ | ADIFDXCC | | BANDS | | CONFIG | | MODES | | PARTY | | PFXTOADIF | | PROPA | | QSO | | SAT_MODE | | SAT_NAME | +------------------+ 10 rows in set (0.00 sec)
mysql> describe QSO ;
+--------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+------------------+------+-----+---------+----------------+
| QSO_ID | int(10) unsigned | | PRI | NULL | auto_increment |
| CALL_NAME | varchar(18) | YES | | NULL | |
| OPERATOR | varchar(18) | YES | | NULL | |
| STATION | varchar(18) | YES | | NULL | |
| RSTS | varchar(4) | YES | | NULL | |
| RSTR | varchar(4) | YES | | NULL | |
| RSTNRS | varchar(6) | YES | | NULL | |
| STX_STRING | varchar(15) | YES | | NULL | |
| RSTNRR | varchar(6) | YES | | NULL | |
| SRX_STRING | varchar(15) | YES | | NULL | |
| BAND | varchar(10) | YES | MUL | NULL | |
| MODE | varchar(10) | YES | | NULL | |
| PROPA | varchar(12) | YES | | NULL | |
| SAT_NAME | varchar(12) | YES | | NULL | |
| SAT_MODE | char(2) | YES | | NULL | |
| POW | varchar(5) | YES | | NULL | |
| ANT | varchar(6) | YES | | NULL | |
| RIG | varchar(6) | YES | | NULL | |
| FREQ | varchar(15) | YES | | NULL | |
| CONTEST_ID | varchar(18) | YES | | NULL | |
| DATE | date | YES | | NULL | |
| TIME | time | YES | | NULL | |
| NAME | varchar(15) | YES | | NULL | |
| QTH | varchar(25) | YES | | NULL | |
| IOTA | varchar(6) | YES | | NULL | |
| ADLIB | varchar(15) | YES | | NULL | |
| REMARKS | varchar(80) | YES | | NULL | |
| QSLS | varchar(7) | YES | | NULL | |
| QSL_SENT_VIA | char(1) | YES | | NULL | |
| QSLSDATE | date | YES | | NULL | |
| QSLR | char(3) | YES | | NULL | |
| QSLRCVD_VIA | char(1) | YES | | NULL | |
| QSLRDATE | date | YES | | NULL | |
| EQSLS | varchar(7) | YES | | NULL | |
| LOTW | char(1) | YES | | NULL | |
| EQSLSDATE | date | YES | | NULL | |
| VIA | varchar(8) | YES | | NULL | |
| BEAM | varchar(4) | YES | | NULL | |
| DISTANCE | varchar(8) | YES | | NULL | |
| ADIF | varchar(6) | YES | | NULL | |
| ADXCC | varchar(30) | YES | | NULL | |
| STATE | char(2) | YES | | NULL | |
| DELETED | enum('Y','N') | YES | | NULL | |
| CONT | char(2) | YES | | NULL | |
| CQ | varchar(12) | YES | | NULL | |
| ITU | varchar(12) | YES | | NULL | |
| LOC | varchar(6) | YES | | NULL | |
+--------------+------------------+------+-----+---------+----------------+
47 rows in set (0.01 sec)
mysql> describe PARTY ; +----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+-------------+------+-----+---------+-------+ | QSO_ID | int(10) | YES | | NULL | | | CALL | varchar(18) | YES | | NULL | | | NAME | varchar(15) | YES | | NULL | | | QTH | varchar(25) | YES | | NULL | | | LOC | varchar(6) | YES | | NULL | | | NOTES | varchar(30) | YES | | NULL | | | TIME_ON | time | YES | | NULL | | | TIME_OUT | time | YES | | NULL | | +----------+-------------+------+-----+---------+-------+ 8 rows in set (0.00 sec)
mysql> describe MODES ; +---------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+-------------+------+-----+---------+-------+ | MODE | varchar(10) | YES | | NULL | | | SORT_ID | int(11) | YES | | NULL | | +---------+-------------+------+-----+---------+-------+ 2 rows in set (0.00 sec)
mysql> describe CONFIG ; +-------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+--------------+------+-----+---------+-------+ | PARM | varchar(40) | | PRI | | | | VALUE | varchar(100) | YES | | NULL | | +-------+--------------+------+-----+---------+-------+ 2 rows in set (0.01 sec)
mysql> describe BANDS ; +-------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+-------------+------+-----+---------+-------+ | BAND | varchar(10) | YES | | NULL | | | FREQ | int(11) | YES | | NULL | | +-------+-------------+------+-----+---------+-------+ 2 rows in set (0.00 sec)
mysql> describe ADIFDXCC ;
+---------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------+------------------+------+-----+---------+----------------+
| ADIF_ID | int(10) unsigned | | PRI | NULL | auto_increment |
| ADIF | varchar(6) | YES | | NULL | |
| ADXCC | varchar(30) | YES | | NULL | |
| DELETED | enum('Y','N') | YES | | NULL | |
| CONT | char(2) | YES | | NULL | |
| CQ | varchar(12) | YES | | NULL | |
| ITU | varchar(12) | YES | | NULL | |
| LOC | varchar(4) | YES | | NULL | |
+---------+------------------+------+-----+---------+----------------+
8 rows in set (0.00 sec)
mysql> describe PROPA ; +---------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+-------------+------+-----+---------+-------+ | PROPA | varchar(12) | YES | | NULL | | | SORT_ID | int(11) | YES | | NULL | | +---------+-------------+------+-----+---------+-------+ 2 rows in set (0.00 sec)
mysql> describe PFXTOADIF ; +-------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+---------+------+-----+---------+-------+ | PFX | char(4) | YES | | NULL | | | ADIF | char(3) | YES | | NULL | | | EXC | char(5) | YES | | NULL | | +-------+---------+------+-----+---------+-------+ 3 rows in set (0.00 sec)
mysql> describe SAT_NAME ; +----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+-------------+------+-----+---------+-------+ | SAT_NAME | varchar(12) | YES | | NULL | | | SORT_ID | int(11) | YES | | NULL | | +----------+-------------+------+-----+---------+-------+ 2 rows in set (0.00 sec)
mysql> describe SAT_MODE ; +----------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+---------+------+-----+---------+-------+ | SAT_MODE | char(2) | YES | | NULL | | | SORT_ID | int(11) | YES | | NULL | | +----------+---------+------+-----+---------+-------+ 2 rows in set (0.00 sec)