SQL

CREATE TABLE IF NOT EXISTS `graffiti_tags` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `quad_data` LONGTEXT NOT NULL,
  `strokes_data` LONGTEXT NOT NULL,
  `created_by` VARCHAR(64) NULL DEFAULT NULL,
  `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `center_x` DOUBLE NULL DEFAULT NULL,
  `center_y` DOUBLE NULL DEFAULT NULL,
  `center_z` DOUBLE NULL DEFAULT NULL,
  `image_url` VARCHAR(768) NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_graffiti_center` (`center_x`, `center_y`, `center_z`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;