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)
);