replays.sql

create table replays
(
	id int unsigned auto_increment
		primary key,
	parsed_id int unsigned null,
	created_at timestamp null,
	updated_at timestamp null,
	filename varchar(36) not null,
	size int unsigned not null,
	game_type enum('QuickMatch', 'UnrankedDraft', 'HeroLeague', 'TeamLeague', 'Brawl') null,
	game_date datetime null,
	game_length smallint(5) unsigned null,
	game_map_id int unsigned null,
	game_version varchar(32) null,
	region tinyint unsigned null,
	fingerprint varchar(36) not null,
	processed tinyint default 0 not null,
	deleted tinyint(1) default 0 not null,
	constraint replays_filename_unique
		unique (filename),
	constraint replays_fingerprint_v3_index
		unique (fingerprint),
	constraint replays_parsed_id_uindex
		unique (parsed_id),
	constraint replays_game_map_id_foreign
		foreign key (game_map_id) references maps (id)
)
collate=utf8mb4_unicode_ci;

create index replays_created_at_index
	on replays (created_at);

create index replays_game_date_index
	on replays (game_date);

create index replays_game_type_index
	on replays (game_type);

create index replays_processed_deleted_index
	on replays (processed, deleted);