-- Dracon Gaming 7DTD — optional MySQL schema (only needed if MARKERS_STORAGE='mysql')
CREATE TABLE IF NOT EXISTS dg7d2d_markers (
  id INT AUTO_INCREMENT PRIMARY KEY,
  map_key VARCHAR(32) NOT NULL,
  name VARCHAR(120) NOT NULL,
  category VARCHAR(32) NOT NULL DEFAULT 'custom',
  x INT NOT NULL,
  y INT NOT NULL,
  description VARCHAR(255) DEFAULT '',
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  INDEX (map_key),
  INDEX (category)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
