CREATE TABLE TBL_personnel (
	ID INT AUTO_INCREMENT PRIMARY KEY,
	FirstName VARCHAR(25),
	LastName VARCHAR(60),
	SSN CHAR(8) UNIQUE,
	Sheet ENUM('M', 'F') NOT NULL,
	MonthlyEarnings DECIMAL(10, 2) DEFAULT 0.00,
	HomeLocation POINT

);

INSERT INTO TBL_personnel (FirstName, LastName, SSN, Sheet, MonthlyEarnings, HomeLocation)
VALUES
('Brad', 'Pitt', '12345678', 'M', 5000000.00, ST_GeomFromText('POINT(34.0522 - 118.2437)')),
('Angelina', 'Jolie', '22345678', 'F', 4500000.00, ST_GeomFromText('POINT(34.0522 - 118.2436)')),
('Tom', 'Hanks', '32345678', 'M', 5500000.00, ST_GeomFromText('POINT(24.0522 - 218.2437)')),
('LilyRose', 'Depp', '42345678', 'F', 4900000.00, ST_GeomFromText('POINT(51.0522 - 118.2127)')),
('Willem', 'Dafoe', '52345678', 'M', 4800000.00, ST_GeomFromText('POINT(64.0522 - 122.2437)')),
('Emma', 'Stone', '62345678', 'F', 4700000.00, ST_GeomFromText('POINT(39.0522 - 10.2437)')),
('Robert', 'Downey Jr.', '72345678', 'M', 6000000.00, ST_GeomFromText('POINT(34.0582 - 118.2437)')),
('Jennifer', 'Lawrence', '82345678', 'F', 4600000.00, ST_GeomFromText('POINT(34.0822 - 67.2437)')),
('Leo', 'DiCaprio', '92345678', 'M', 5300000.00, ST_GeomFromText('POINT(23.0522 - 118.2437)')),
('Meryl', 'Streep', '10345678', 'F', 5200000.00, ST_GeomFromText('POINT(39.0522 - 116.4047)'));
