4Ts3M4Mq

1SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
2SET time_zone = "+00:00";
3CREATE TABLE IF NOT EXISTS `wp_sh_schedule` (
4  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
5  `match_number` varchar(256) not null unique,
6  `home_id` int not null,
7  `guest_id` int not null,
8  `season_id` int not null,
9  `group_id` varchar(256) not null,
10  `date` timestamp,
11  `playground_id` int,
12  `gameparts` int not null,
13  `partlength` int not null,
14  `overtimeparts` int not null,  
15  `overtimelength` int not null,
16  `user_create` int not null,
17  `date_create` TIMESTAMP not null,
18  `user_update` int not null,
19  `date_update` TIMESTAMP not null,
20   PRIMARY KEY (`id`),
21   UNIQUE KEY `id` (`id`),
22   FOREIGN KEY fk_schedule_create(`user_create`) REFERENCES wp_users(`id`)
23   ON UPDATE CASCADE ON DELETE RESTRICT,
24   FOREIGN KEY fk_schedule_update(`user_update`) REFERENCES wp_users(`id`)
25   ON UPDATE CASCADE ON DELETE RESTRICT,
26   FOREIGN KEY fk_schedule_home(`home_id`) REFERENCES wp_sh_teams(`id`)
27   ON UPDATE CASCADE ON DELETE RESTRICT,
28   FOREIGN KEY fk_schedule_guest(`guest_id`) REFERENCES wp_sh_teams(`id`)
29   ON UPDATE CASCADE ON DELETE RESTRICT,
30   FOREIGN KEY fk_schedule_season(`season_id`) REFERENCES wp_sh_seasons(`id`)
31   ON UPDATE CASCADE ON DELETE RESTRICT
32) ENGINE=MyISAM DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;