mysql> CREATE TABLE TBL_personnel (
			-> ID INT NOT NULL AUTO_INCREMENT,
			-> NAME VARCHAR(25),
			-> SURNAME VARCHAR(60),
			-> ADT VARCHAR(8) NOT NULL UNIQUE,
			-> SEX ENUM('M','F') NOT NULL,
			-> MONTHLY_SALARY DECIMAL(10,2) DEFAULT 0.00,
			-> COORD POINT,
			-> PRIMARY KEY(ID)
			-> );

INSERT INTO TBL_personnel (NAME, SURNAME, ADT, SEX, MONTHLY_SALARY, COORD) 
VALUES ('NICK', 'PAPPAS', 'AI123412', 'M', 850.00, POINT(42.3425, 12.9862));

INSERT INTO TBL_personnel (NAME, SURNAME, ADT, SEX, MONTHLY_SALARY, COORD) 
VALUES ('GEORGE', 'KAPPAS', 'AI542412', 'M', 1850.00, POINT(24.0383, 20.6352));

INSERT INTO TBL_personnel (NAME, SURNAME, ADT, SEX, MONTHLY_SALARY, COORD) 
VALUES ('TOM', 'KARRAS', 'AI133424', 'M', 1220.00, POINT(27.6223, 25.3552));

INSERT INTO TBL_personnel (NAME, SURNAME, ADT, SEX, MONTHLY_SALARY, COORD) 
VALUES ('MARIA', 'ANDREOU', 'AI753533', 'F', 1540.00, POINT(43.2234, 24.2112));

INSERT INTO TBL_personnel (NAME, SURNAME, ADT, SEX, MONTHLY_SALARY, COORD) 
VALUES ('GEORGIA', 'GEORGIOU', 'AI24412', 'F', 1210.00, POINT(74.4114, 24.2766));

INSERT INTO TBL_personnel (NAME, SURNAME, ADT, SEX, MONTHLY_SALARY, COORD) 
VALUES ('HELEN', 'VLACHAKI', 'AI13331', 'F', 1400.00, POINT(34.9182, 33.2611));

INSERT INTO TBL_personnel (NAME, SURNAME, ADT, SEX, MONTHLY_SALARY, COORD) 
VALUES ('NIKOL', 'PETROU', 'AI442131', 'F', 1330.00, POINT(33.1312, 63.6289));

INSERT INTO TBL_personnel (NAME, SURNAME, ADT, SEX, MONTHLY_SALARY, COORD) 
VALUES ('JOHN', 'KALIMERIS', 'AI525393', 'M', 2030.00, POINT(23.9077, 55.3422));

INSERT INTO TBL_personnel (NAME, SURNAME, ADT, SEX, MONTHLY_SALARY, COORD) 
VALUES ('SANDRA', 'PAVLOU', 'AI373422', 'F', 1000.00, POINT(41.5637, 23.7893));

INSERT INTO TBL_personnel (NAME, SURNAME, ADT, SEX, MONTHLY_SALARY, COORD) 
VALUES ('PANOS', 'NIKAS', 'AI123427', 'M', 2000.00, POINT(21.1147, 24.2782));
