ALTER TABLE `spots`
  ADD COLUMN `audio_format` VARCHAR(20) NULL,
  ADD COLUMN `audio_bitrate_kbps` INT UNSIGNED NULL,
  ADD COLUMN `audio_sample_rate` INT UNSIGNED NULL,
  ADD COLUMN `audio_channels` TINYINT UNSIGNED NULL,
  ADD COLUMN `audio_peak_db` DECIMAL(7,2) NULL,
  ADD COLUMN `audio_rms_db` DECIMAL(7,2) NULL,
  ADD COLUMN `trim_start_ms` INT UNSIGNED NOT NULL DEFAULT 0,
  ADD COLUMN `trim_end_ms` INT UNSIGNED NULL,
  ADD COLUMN `fade_in_ms` INT UNSIGNED NOT NULL DEFAULT 0,
  ADD COLUMN `fade_out_ms` INT UNSIGNED NOT NULL DEFAULT 0,
  ADD COLUMN `processed_file_name` VARCHAR(255) NULL,
  ADD COLUMN `processed_checksum` VARCHAR(64) NULL,
  ADD COLUMN `parent_spot_id` BIGINT UNSIGNED NULL,
  ADD COLUMN `version_type` VARCHAR(30) NULL,
  ADD INDEX `spots_parent_spot_id_index` (`parent_spot_id`),
  ADD CONSTRAINT `spots_parent_spot_id_foreign` FOREIGN KEY (`parent_spot_id`) REFERENCES `spots` (`id`) ON DELETE SET NULL;