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