-- 
-- Table structure for table `gpsdata`
-- 

CREATE TABLE `gpsdata` (
  `id` int(11) NOT NULL auto_increment,
  `timestamp` timestamp(14) NOT NULL,
  `servertime` bigint(20) NOT NULL default '0',
  `day` varchar(15) default NULL,
  `hour` varchar(15) default NULL,
  `lat` varchar(20) default NULL,
  `long` varchar(20) default NULL,
  `alt` varchar(20) default NULL,
  `speed` varchar(20) default NULL,
  `heading` varchar(20) default NULL,
  `aux` text,
  PRIMARY KEY  (`id`)
);