CREATE TABLE `bodytranst` (
	`id` VARCHAR(50) NOT NULL,
	`inpdate` DATETIME NULL DEFAULT NULL,
	`weight` DOUBLE NULL DEFAULT NULL,
	`smusclem` DOUBLE NULL DEFAULT NULL,
	`bodyfatm` DOUBLE NULL DEFAULT NULL,
	`bodyfatl` DOUBLE NULL DEFAULT NULL,
	`abdfatl` DOUBLE NULL DEFAULT NULL
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB;


INSERT INTO `bodytranst` (`id`, `inpdate`, `weight`, `smusclem`, `bodyfatm`, `bodyfatl`, `abdfatl`) VALUES
	('ddd', '2015-03-03 16:09:24', 100, 34.32, 23.435, 0.81, 22.6),
	('eee', '2015-03-03 16:14:36', 48, 324, 234, 23, 234),
	('bbb', '2015-03-04 17:48:35', 34, 134, 123, 134, 134),
	('bbb', '2015-03-05 17:01:42', 77, 24, 24, 24, 24),
	('ddd', '2014-12-05 17:24:43', 120, 30, 40, 0.9, 28.9),
	('ddd', '2015-01-05 17:25:53', 105, 33, 35, 0.87, 26.5),
	('ddd', '2015-02-05 17:26:25', 90, 31, 30, 0.83, 24.7),
	('bbb', '2015-03-06 10:17:49', 23, 34.32, 3, 23, 43);