/* setup.sql
   (c) 2016 W. Wagner OE1WWL */
CREATE TABLE jtxlog  (qso_date date not null,
time_on time not null,
call varchar (100) not null,
mode varchar (100) not null,
submode varchar (100),
freq number,
band number not null,
gridsquare varchar (6),
rst_sent number,
rst_rcvd number,
station_callsign varchar (100),
my_gridsquare varchar (6),
tx_pwr number,
time_off time,
comments varchar (100),
name varchar (100));
.echo on
.mode csv
.import jtxdupes.csv jtxlog
CREATE UNIQUE INDEX i1 on jtxlog (qso_date, time_on, call);
CREATE INDEX i2 on jtxlog (call, freq, qso_date);
.exit
