tbl argo

CREATE TABLE `argo_transport` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(40) NOT NULL,
  `txno` varchar(120) NOT NULL,
  `distance` double NOT NULL,
  `duration` double NOT NULL,
  `last_lat` varchar(100) DEFAULT NULL,
  `last_lng` varchar(100) DEFAULT NULL,
  `last_tstamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8