YFKlog Perl Ham Radio logger: https://fkurz.net/ham/yfklog.html
You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
29 lines
1.0 KiB
29 lines
1.0 KiB
16 years ago
|
CREATE TABLE `log_MYCALL` (
|
||
|
`NR` INTEGER PRIMARY KEY AUTOINCREMENT,
|
||
|
`CALL` varchar(15) NOT NULL default '',
|
||
|
`DATE` date NOT NULL default '0000-00-00',
|
||
|
`T_ON` time NOT NULL default '00:00:00',
|
||
|
`T_OFF` time NOT NULL default '00:00:00',
|
||
|
`BAND` float NOT NULL default '0',
|
||
|
`MODE` varchar(6) NOT NULL default '',
|
||
|
`QTH` varchar(15) default '',
|
||
|
`NAME` varchar(15) default '',
|
||
|
`QSLS` char(1) NOT NULL default '',
|
||
|
`QSLR` char(1) NOT NULL default 'N',
|
||
|
`QSLRL` char(1) NOT NULL default 'N',
|
||
|
`RSTS` int(10) NOT NULL default '599',
|
||
|
`RSTR` int(10) NOT NULL default '599',
|
||
|
`REM` varchar(60) default '',
|
||
|
`PWR` int(10) default '0',
|
||
|
`DXCC` varchar(4) NOT NULL default '',
|
||
|
`PFX` varchar(8) NOT NULL default '',
|
||
|
`CONT` char(3) NOT NULL default '',
|
||
|
`ITUZ` int(2) NOT NULL default '0',
|
||
|
`CQZ` int(2) NOT NULL default '0',
|
||
|
`QSLINFO` varchar(15) default '',
|
||
|
`IOTA` varchar(6) default '',
|
||
|
`STATE` varchar(2) default '',
|
||
|
`GRID` varchar(6) NOT NULL default '',
|
||
|
`OPERATOR` varchar(6) NOT NULL default ''
|
||
|
);
|