CREATE TABLE `table` (
`id` bigint(20) NOT NULL,
`eventtime` text NOT NULL,
`name_home` text NOT NULL,
`name_away` text NOT NULL,
`final_home_score` text NOT NULL,
`final_away_score` text NOT NULL,
`sh1` int(11) NOT NULL,
`sa1` int(11) NOT NULL,
`sh2` int(11) NOT NULL,
`sa2` int(11) NOT NULL,
`sh3` int(11) NOT NULL,
`sa3` int(11) NOT NULL,
`sh4` int(11) NOT NULL,
`sa4` int(11) NOT NULL,
`sh5` int(11) NOT NULL,
`sa5` int(11) NOT NULL,
`sh6` int(11) NOT NULL,
`sa6` int(11) NOT NULL,
`sh7` int(11) NOT NULL,
`sa7` int(11) NOT NULL,
`sh8` int(11) NOT NULL,
`sa8` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `table` (`id`, `eventtime`, `name_home`, `name_away`, `final_home_score`, `final_away_score`, `sh1`, `sa1`, `sh2`, `sa2`, `sh3`, `sa3`, `sh4`, `sa4`, `sh5`, `sa5`, `sh6`, `sa6`, `sh7`, `sa7`, `sh8`, `sa8`) VALUES
(1, '11.05. 21:55', 'Player1', 'Player2', '3', '1', 11, 6, 10, 12, 11, 4, 11, 5, 0, 0, 0, 0, 0, 0, 0, 0),
(2, '11.05. 21:10', 'Player2', 'Player1', '0', '3', 13, 15, 6, 11, 9, 11, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);