CREATE TABLE IF NOT EXISTS visits ( id INT AUTO_INCREMENT PRIMARY KEY, client_name VARCHAR(255) NOT NULL, latitude DECIMAL(10, 8) NOT NULL, longitude DECIMAL(11, 8) NOT NULL, visit_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP );