-- see http://fkurz.net/ham/stuff.html?rbnbandmap CREATE TABLE `spots` ( `ID` bigint(5) NOT NULL auto_increment, `call` varchar(16) NOT NULL default '', `freq` int NOT NULL default 0, `dxcall` varchar(16) NOT NULL default '', `fromcont` varchar(2) NOT NULL default '', `comment` varchar(64) NOT NULL default '', `time` datetime NOT NULL default '1970-01-01', `band` int NOT NULL default '0', PRIMARY KEY (`ID`), KEY `dxcall` (`dxcall`) ) AUTO_INCREMENT = 1;