CREATE TABLE IF NOT EXISTS `c13_chart_overview_10m` (
  `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  `signal_slug` VARCHAR(190) NOT NULL,
  `window_start` DATETIME NOT NULL,
  `window_end` DATETIME NOT NULL,
  `epoch_start` INT UNSIGNED NOT NULL,
  `epoch_end` INT UNSIGNED NOT NULL,
  `plays` INT UNSIGNED NOT NULL DEFAULT 0,
  `streams` INT UNSIGNED NOT NULL DEFAULT 0,
  `devices` INT UNSIGNED NOT NULL DEFAULT 0,
  `time_total` VARCHAR(32) DEFAULT NULL,
  `average_time` VARCHAR(32) DEFAULT NULL,
  `computer` INT UNSIGNED NOT NULL DEFAULT 0,
  `mobile` INT UNSIGNED NOT NULL DEFAULT 0,
  `Android` INT UNSIGNED NOT NULL DEFAULT 0,
  `iOS` INT UNSIGNED NOT NULL DEFAULT 0,
  `AndroidAPP` INT UNSIGNED NOT NULL DEFAULT 0,
  `iOSAPP` INT UNSIGNED NOT NULL DEFAULT 0,
  `SmartTV` INT UNSIGNED NOT NULL DEFAULT 0,
  `Windows` INT UNSIGNED NOT NULL DEFAULT 0,
  `Infiny` INT UNSIGNED NOT NULL DEFAULT 0,
  `captured_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uniq_signal_window_epoch` (`signal_slug`,`epoch_start`,`epoch_end`),
  KEY `idx_window_start` (`window_start`),
  KEY `idx_signal_window_start` (`signal_slug`,`window_start`),
  KEY `idx_captured_at` (`captured_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
