drop table spots;
CREATE TABLE `spots` (
        `call` varchar(16) NOT NULL default '',
        `freq` float 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',
		`status` varchar(1) NOT NULL default 'M',
        KEY `dxcall` (`dxcall`)
) ENGINE=MEMORY;
