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.
 
 
 
 

16 lines
467 B

CREATE TABLE IF NOT EXISTS wsjtx_all_txt (
ts timestamp NOT NULL,
station VARCHAR(16) NOT NULL,
callsign VARCHAR(16) NOT NULL,
band VARCHAR(10) NOT NULL,
continent VARCHAR(32) NOT NULL,
mode VARCHAR(16) NOT NULL,
dxcc VARCHAR(128) NOT NULL,
geohash VARCHAR(16) NOT NULL,
report TINYINT NOT NULL,
cqzone INT NOT NULL,
ituzone INT NOT NULL,
rx TINYINT NOT NULL,
PRIMARY KEY PK_wsjtx_all_txt (ts, station, callsign),
INDEX idx_dxcc (dxcc)
);