CREATE TABLE `score` (
  `id` bigint(20) NOT NULL,
  `time` datetime NOT NULL DEFAULT current_timestamp(),
  `home` bigint(20) NOT NULL,
  `away` bigint(20) NOT NULL,
  `comment` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

ALTER TABLE `score`
  ADD PRIMARY KEY (`id`,`time`);