· 9 years ago · Oct 22, 2016, 05:08 PM
1CREATE TABLE IF NOT EXISTS `ps4_match` (
2 `id` int(10) unsigned NOT NULL,
3 `id_spieler_heim` int(11) unsigned NOT NULL, -- HOME player
4 `id_spieler_ausw` int(11) unsigned NOT NULL, -- AWAY player
5 `heim_tore` int(11) NOT NULL, -- not interesting
6 `ausw_tore` int(11) NOT NULL, -- not interesting
7 `spieltag` int(11) NOT NULL -- the fixture number
8);