create table time (
`id` int not null auto_increment,
`nome` varchar(255) not null,
primary key (`id`)
);
insert into time values (1, "Time A"), (2, "Time B"), (3, "Time C");
create table confronto (
`id` int not null auto_increment,
`nome` varchar(255) not null,
`data` timestamp default current_timestamp,
primary key (`id`)
);
insert into confronto(id, nome) values (1, "A x B"), (2, "A x C"), (3, "B x C");
create table confronto_time (
id int not null auto_increment,
id_confronto int not null,