dotnet/track_request_logs.sql

CREATE TABLE `track_request_logs` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `track_id` int NOT NULL DEFAULT 0,
  `account_id` int NOT NULL DEFAULT 0,
  `event_type` varchar(32) NOT NULL DEFAULT '',
  `platform` varchar(64) NOT NULL DEFAULT '',
  `typename` varchar(64) NOT NULL DEFAULT '',
  `scene` varchar(128) NOT NULL DEFAULT '',
  `unique_id` varchar(128) NOT NULL DEFAULT '',
  `ip` varchar(64) NOT NULL DEFAULT '',
  `user_agent` varchar(512) NOT NULL DEFAULT '',
  `referer` varchar(512) NOT NULL DEFAULT '',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_track_event` (`track_id`,`event_type`),
  KEY `idx_create_time` (`create_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;