CREATE TABLE `loguser` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `username` varchar(20) NOT NULL,
  `password` varchar(50) NOT NULL,
  `visible` binary(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

INSERT INTO `loguser` VALUES (1, 'name', 'username', 'password', 0x31);

CREATE TABLE `point` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `longitude` float NOT NULL,
  `lattitude` float NOT NULL,
  `loguserid` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_TIMESTAMP` (`timestamp`),
  KEY `IDX_LOGUSERID` (`loguserid`)
) ENGINE=MyISAM AUTO_INCREMENT=7721 DEFAULT CHARSET=latin1 AUTO_INCREMENT=7721 ;


INSERT INTO `point` VALUES (1, '2010-03-19 04:00:00', 5.86766, 51.8411, 1);
INSERT INTO `point` VALUES (2, '2010-03-19 04:00:05', 5.86768, 51.8412, 1);
INSERT INTO `point` VALUES (3, '2010-03-19 04:00:10', 5.86766, 51.8412, 1);
INSERT INTO `point` VALUES (4, '2010-03-19 04:00:15', 5.86761, 51.841, 1);
INSERT INTO `point` VALUES (5, '2010-03-19 04:00:20', 5.86758, 51.841, 1);
INSERT INTO `point` VALUES (6, '2010-03-19 04:00:25', 5.86761, 51.8411, 1);
INSERT INTO `point` VALUES (7, '2010-03-19 04:00:30', 5.86761, 51.8411, 1);
INSERT INTO `point` VALUES (8, '2010-03-19 04:00:35', 5.86761, 51.8411, 1);
INSERT INTO `point` VALUES (9, '2010-03-19 04:00:40', 5.86761, 51.8411, 1);
INSERT INTO `point` VALUES (10, '2010-03-19 04:00:45', 5.86761, 51.8411, 1);
INSERT INTO `point` VALUES (11, '2010-03-19 04:00:50', 5.86761, 51.8411, 1);


CREATE TABLE `track` (
  `id` varchar(13) NOT NULL,
  `name` varchar(100) NOT NULL,
  `loguserid` int(11) NOT NULL,
  `modifydate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `startlog` timestamp NULL DEFAULT '0000-00-00 00:00:00',
  `endlog` timestamp NULL DEFAULT '0000-00-00 00:00:00',
  `public` binary(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

INSERT INTO `track` VALUES ('4b3403665fea6', 'Vierdaagse dag X', 1, '2010-03-21 10:35:47', '2010-03-19 04:00:00', '2010-03-19 14:42:55', 0x31);