CREATE TABLE `people`(
`id` INT AUTO_INCREMENT PRIMARY KEY,
`name` VARCHAR(200) NOT NULL,
`picture` MEDIUMBLOB DEFAULT NULL,
`height` DOUBLE PRECISION(10,2) DEFAULT NULL,
`weight` DOUBLE PRECISION(10,2) DEFAULT NULL,
`gender` ENUM('m','f') NOT NULL,
`birthdate` DATE NOT NULL,
`biography` TEXT DEFAULT NULL
);

INSERT INTO `people`(`name`, `height`, `weight`, `gender`, `birthdate`,`biography`)
VALUES
('Ivan', 1.70, 71.56, 'm', '1998-12-25', 'Nice person!'),
('Georgi', 1.75, 71.886, 'm', '1998-12-25', 'Nice person da!'),
('Peter', 1.807, 79.567, 'f', '1998-12-25', 'Nice person dada!'),
('Stefan', 1.855, 98.586, 'f', '1998-12-25', 'Nice person dane!'),
('Dimitar', 1.905, 81.565, 'm', '1998-12-25', 'Nice person nedar!');