create table TBL_personnel(id int auto_increment primary key, FirstName varchar(25) not null, LastName varchar(60) not null, adt char(80) not null unique, Gender enum('M','F') not null, MonthlySalary decimal(10,2) default 0.00, HomeLocation POINT);

INSERT INTO TBL_personnel (FirstName, LastName, ADT, Gender, MonthlySalary, HomeLocation)
VALUES 
('Γεώργιος', 'Παπαδόπουλος', 'AB123456', 'M', 2500.00, ST_GeomFromText('POINT(37.9838 23.7275)')),
('Μαρία', 'Κωνσταντίνου', 'CD234567', 'F', 2300.50, ST_GeomFromText('POINT(37.9838 23.7294)')),
('Νίκος', 'Δημητρίου', 'EF345678', 'M', 2100.75, ST_GeomFromText('POINT(37.9740 23.7345)')),
('Ελένη', 'Χατζηγεωργίου', 'GH456789', 'F', 2400.00, ST_GeomFromText('POINT(37.9484 23.7423)')),
('Αλέξανδρος', 'Πετρόπουλος', 'IJ567890', 'M', 2200.30, ST_GeomFromText('POINT(37.9515 23.7341)')),
('Σοφία', 'Νικολάου', 'KL678901', 'F', 2000.25, ST_GeomFromText('POINT(37.9333 23.7492)')),
('Κωνσταντίνος', 'Μιχαηλίδης', 'MN789012', 'M', 2600.00, ST_GeomFromText('POINT(37.9795 23.7347)')),
('Ιωάννης', 'Σαμαράς', 'OP123456', 'M', 2500.00, ST_GeomFromText('POINT(37.9903 23.7358)')),
('Αντωνία', 'Βασιλείου', 'QR234567', 'F', 2200.50, ST_GeomFromText('POINT(37.9468 23.7490)')),
('Παναγιώτης', 'Καραγιάννης', 'ST345678', 'M', 2400.75, ST_GeomFromText('POINT(37.9510 23.7625)'));