 --Δημιουργία Πίνακα
create table TBL_personnel (id int not null auto_increment primary key, Firstname varchar(25), Lastname varchar(60) not null, ADT varchar(8) not null unique, Gender enum('M','F') not null, Salary decimal(10,2) default 0.00, Home_Location point not null);





--Εισαγωγή Τιμών
insert into TBL_personnel (Firstname, Lastname, ADT, Gender, Salary, Home_Location) values ('Georgios', 'Papadopoulos', 'AB123456', 'M', 1200.50, POINT(39.6650, 20.8537)), ('Maria', 'Nikolaou', 'EZ987654', 'F', 1450.00, POINT(38.0019, 23.7252)),('Dimitris', 'Georgiou', 'XK102030', 'M', 950.00, POINT(40.6401, 22.9444)),('Eleni', 'Konstantinou', 'MM554433', 'F', 1800.75, POINT(35.3387, 25.1442)),('Ioannis', 'Makris', 'AN112233', 'M', 1100.20, POINT(39.3626, 22.9517)),('Sofia', 'Lymperi', 'BB998877', 'F', 0.00, POINT(37.9838, 23.7275)),('Christos', 'Vasilopoulos', 'EE123123', 'M', 1600.00, POINT(38.2466, 21.7346)),('Katerina', 'Dimitriadi', 'ZZ776655', 'F', 1250.40, POINT(39.5562, 21.7675)),('Panagiotis', 'Raptis', 'TT001122', 'M', 1050.50, POINT(40.9376, 24.4087)),('Alexandra', 'Papageorgiou', 'KK445566', 'F', 1320.00, POINT(37.5093, 22.3789));



--Εμφάνιση Δεδομένων στον Πίνακα
 select ID, Firstname, Lastname, ADT, Gender, Salary, ST_AsText(Home_Location) as Location from TBL_personnel;
