CREATE TABLE IF NOT EXISTS icarus_markers (
  id INT AUTO_INCREMENT PRIMARY KEY,
  label VARCHAR(120) NOT NULL,
  category VARCHAR(60) DEFAULT 'General',
  icon VARCHAR(40) DEFAULT 'pin',
  lat DECIMAL(10,7) NOT NULL,
  lng DECIMAL(10,7) NOT NULL,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

CREATE INDEX idx_icarus_markers_cat ON icarus_markers(category);
