CREATE TABLE TBL_personnel (
    id INT AUTO_INCREMENT PRIMARY KEY,
    fname VARCHAR(25) NOT NULL,
    lname VARCHAR(60) NOT NULL,
    adt CHAR(8) NOT NULL UNIQUE,
    gender ENUM('M', 'F') NOT NULL,
    monthly_salary DECIMAL(10,2) NOT NULL DEFAULT 0.00,
    home_location POINT NOT NULL,
    SPATIAL INDEX(home_location)
                                );

   INSERT INTO TBL_personnel (fname, lname, adt, gender, monthly_salary, home_location) VALUES
   ('Γιώργος', 'Παπαδόπουλος', 'AB123456', 'M', 1500.50, POINT(37.9838, 23.7275)),
   ('Μαρία', 'Ιωαννίδου', 'CD789012', 'F', 2000.00, POINT(38.2466, 21.7346)),
   ('Νίκος', 'Καραγιάννης', 'EF345678', 'M', 1800.75, POINT(40.6401, 22.9444)),
   ('Ελένη', 'Αθανασίου', 'GH901234', 'F', 1750.00, POINT(35.3387, 25.1442)),
   ('Πέτρος', 'Δημητρίου', 'IJ567890', 'M', 1600.25, POINT(39.0742, 21.8243)),
   ('Σοφία', 'Λαμπροπούλου', 'KL123987', 'F', 1900.30, POINT(36.455, 28.2215)),
   ('Ανδρέας', 'Χριστοδούλου', 'MN456321', 'M', 1550.40, POINT(37.9795, 23.7162)),
   ('Κατερίνα', 'Βασιλείου', 'OP789654', 'F', 2100.20, POINT(38.1922, 22.8387)),
   ('Δημήτρης', 'Σταματίου', 'QR321654', 'M', 1700.60, POINT(39.5022, 21.6775)),
   ('Άννα', 'Παναγιωτίδου', 'ST987321', 'F', 2200.80, POINT(41.1231, 25.4321));
                                
