Code: Alles auswählen
DROP TABLE IF EXISTS `phpbb3_footb_bets`;
CREATE TABLE `phpbb3_footb_bets` (
`season` smallint(4) unsigned NOT NULL DEFAULT 0,
`league` tinyint(2) NOT NULL DEFAULT 0,
`match_no` smallint(4) unsigned NOT NULL DEFAULT 0,
`user_id` mediumint(8) unsigned NOT NULL DEFAULT 0,
`goals_home` char(2) COLLATE utf8_bin NOT NULL DEFAULT '',
`goals_guest` char(2) COLLATE utf8_bin NOT NULL DEFAULT '',
`bet_time` int(11) unsigned NOT NULL DEFAULT 0,
PRIMARY KEY (`season`,`league`,`match_no`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
DROP TABLE IF EXISTS `phpbb3_footb_extra`;
CREATE TABLE `phpbb3_footb_extra` (
`season` smallint(4) unsigned NOT NULL DEFAULT 0,
`league` tinyint(2) NOT NULL DEFAULT 0,
`extra_no` smallint(4) unsigned NOT NULL DEFAULT 0,
`question_type` tinyint(2) NOT NULL DEFAULT 0,
`question` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`result` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`matchday` tinyint(2) NOT NULL DEFAULT 0,
`matchday_eval` tinyint(2) NOT NULL DEFAULT 0,
`extra_points` tinyint(2) NOT NULL DEFAULT 0,
`extra_status` tinyint(2) NOT NULL DEFAULT 0,
PRIMARY KEY (`season`,`league`,`extra_no`),
KEY `matchday` (`matchday`),
KEY `eval` (`matchday_eval`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
DROP TABLE IF EXISTS `phpbb3_footb_extra_bets`;
CREATE TABLE `phpbb3_footb_extra_bets` (
`season` smallint(4) unsigned NOT NULL DEFAULT 0,
`league` tinyint(2) NOT NULL DEFAULT 0,
`extra_no` smallint(4) unsigned NOT NULL DEFAULT 0,
`user_id` mediumint(8) unsigned NOT NULL DEFAULT 0,
`bet` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`bet_points` tinyint(2) NOT NULL DEFAULT 0,
PRIMARY KEY (`season`,`league`,`extra_no`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
DROP TABLE IF EXISTS `phpbb3_footb_leagues`;
CREATE TABLE `phpbb3_footb_leagues` (
`season` smallint(4) unsigned NOT NULL DEFAULT 0,
`league` tinyint(2) NOT NULL DEFAULT 0,
`league_name` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '',
`league_name_short` varchar(3) COLLATE utf8_bin NOT NULL DEFAULT '',
`league_type` tinyint(1) NOT NULL DEFAULT 1,
`matchdays` tinyint(2) NOT NULL DEFAULT 0,
`matches_on_matchday` tinyint(2) NOT NULL DEFAULT 0,
`win_result` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '',
`win_result_02` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '',
`win_matchday` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`win_season` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`points_mode` tinyint(2) NOT NULL DEFAULT 1,
`points_result` tinyint(2) NOT NULL DEFAULT 0,
`points_tendency` tinyint(2) NOT NULL DEFAULT 0,
`points_diff` tinyint(2) NOT NULL DEFAULT 0,
`points_last` tinyint(1) unsigned NOT NULL DEFAULT 1,
`join_by_user` tinyint(1) unsigned NOT NULL DEFAULT 0,
`join_in_season` tinyint(1) unsigned NOT NULL DEFAULT 0,
`bet_in_time` tinyint(1) unsigned NOT NULL DEFAULT 0,
`rules_post_id` mediumint(8) unsigned NOT NULL DEFAULT 0,
`bet_ko_type` tinyint(1) NOT NULL DEFAULT 1,
`bet_points` decimal(5,2) NOT NULL DEFAULT 0.00,
PRIMARY KEY (`season`,`league`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
DROP TABLE IF EXISTS `phpbb3_footb_matchdays`;
CREATE TABLE `phpbb3_footb_matchdays` (
`season` smallint(4) unsigned NOT NULL DEFAULT 0,
`league` tinyint(2) NOT NULL DEFAULT 0,
`matchday` tinyint(2) NOT NULL DEFAULT 0,
`status` tinyint(2) NOT NULL DEFAULT 0,
`delivery_date` char(19) COLLATE utf8_bin NOT NULL DEFAULT '',
`delivery_date_2` char(19) COLLATE utf8_bin NOT NULL DEFAULT '',
`delivery_date_3` char(19) COLLATE utf8_bin NOT NULL DEFAULT '',
`matchday_name` varchar(30) COLLATE utf8_bin NOT NULL DEFAULT '',
`matches` char(2) COLLATE utf8_bin NOT NULL DEFAULT '',
PRIMARY KEY (`season`,`league`,`matchday`),
KEY `status` (`status`),
KEY `date` (`delivery_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
DROP TABLE IF EXISTS `phpbb3_footb_matches`;
CREATE TABLE `phpbb3_footb_matches` (
`season` smallint(4) unsigned NOT NULL DEFAULT 0,
`league` tinyint(2) NOT NULL DEFAULT 0,
`match_no` smallint(4) unsigned NOT NULL DEFAULT 0,
`team_id_home` smallint(4) unsigned NOT NULL DEFAULT 0,
`team_id_guest` smallint(4) unsigned NOT NULL DEFAULT 0,
`goals_home` char(2) COLLATE utf8_bin NOT NULL DEFAULT '',
`goals_guest` char(2) COLLATE utf8_bin NOT NULL DEFAULT '',
`matchday` tinyint(2) NOT NULL DEFAULT 0,
`status` tinyint(2) NOT NULL DEFAULT 0,
`match_datetime` char(19) COLLATE utf8_bin NOT NULL DEFAULT '',
`group_id` char(1) COLLATE utf8_bin NOT NULL DEFAULT '',
`formula_home` char(9) COLLATE utf8_bin NOT NULL DEFAULT '',
`formula_guest` char(9) COLLATE utf8_bin NOT NULL DEFAULT '',
`ko_match` tinyint(1) unsigned NOT NULL DEFAULT 0,
`goals_overtime_home` char(2) COLLATE utf8_bin NOT NULL DEFAULT '',
`goals_overtime_guest` char(2) COLLATE utf8_bin NOT NULL DEFAULT '',
`trend` char(8) COLLATE utf8_bin NOT NULL DEFAULT '',
`odd_1` decimal(5,2) NOT NULL DEFAULT 0.00,
`odd_x` decimal(5,2) NOT NULL DEFAULT 0.00,
`odd_2` decimal(5,2) NOT NULL DEFAULT 0.00,
`rating` decimal(5,2) NOT NULL DEFAULT 0.00,
PRIMARY KEY (`season`,`league`,`match_no`),
KEY `gid` (`team_id_guest`),
KEY `hid` (`team_id_home`),
KEY `md` (`matchday`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
DROP TABLE IF EXISTS `phpbb3_footb_matches_hist`;
CREATE TABLE `phpbb3_footb_matches_hist` (
`match_date` char(10) COLLATE utf8_bin NOT NULL DEFAULT '',
`team_id_home` smallint(4) unsigned NOT NULL DEFAULT 1,
`team_id_guest` smallint(4) unsigned NOT NULL DEFAULT 1,
`match_type` varchar(5) COLLATE utf8_bin NOT NULL DEFAULT '',
`goals_home` char(2) COLLATE utf8_bin NOT NULL DEFAULT '',
`goals_guest` char(2) COLLATE utf8_bin NOT NULL DEFAULT '',
PRIMARY KEY (`match_date`,`team_id_home`,`team_id_guest`),
KEY `gid` (`team_id_guest`),
KEY `hid` (`team_id_home`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
DROP TABLE IF EXISTS `phpbb3_footb_points`;
CREATE TABLE `phpbb3_footb_points` (
`points_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`season` smallint(4) unsigned NOT NULL DEFAULT 0,
`league` tinyint(2) NOT NULL DEFAULT 0,
`matchday` tinyint(2) NOT NULL DEFAULT 0,
`points_type` tinyint(1) NOT NULL DEFAULT 0,
`user_id` mediumint(8) unsigned NOT NULL DEFAULT 0,
`points` decimal(20,2) NOT NULL DEFAULT 0.00,
`points_comment` mediumtext COLLATE utf8_bin NOT NULL,
`cash` tinyint(1) unsigned NOT NULL DEFAULT 0,
PRIMARY KEY (`points_id`),
KEY `user` (`season`,`league`,`user_id`),
KEY `matchday` (`season`,`league`,`matchday`),
KEY `type` (`season`,`league`,`points_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
DROP TABLE IF EXISTS `phpbb3_footb_rank_matchdays`;
CREATE TABLE `phpbb3_footb_rank_matchdays` (
`season` smallint(4) unsigned NOT NULL DEFAULT 0,
`league` tinyint(2) NOT NULL DEFAULT 0,
`matchday` tinyint(2) NOT NULL DEFAULT 0,
`user_id` mediumint(8) unsigned NOT NULL DEFAULT 0,
`status` tinyint(2) NOT NULL DEFAULT 0,
`rank` smallint(4) unsigned NOT NULL DEFAULT 0,
`points` smallint(4) unsigned NOT NULL DEFAULT 0,
`win` decimal(5,2) NOT NULL DEFAULT 0.00,
`rank_total` smallint(4) unsigned NOT NULL DEFAULT 0,
`tendencies` tinyint(2) NOT NULL DEFAULT 0,
`correct_result` tinyint(2) NOT NULL DEFAULT 0,
`points_total` smallint(4) unsigned NOT NULL DEFAULT 0,
`win_total` decimal(5,2) NOT NULL DEFAULT 0.00,
PRIMARY KEY (`season`,`league`,`matchday`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
DROP TABLE IF EXISTS `phpbb3_footb_seasons`;
CREATE TABLE `phpbb3_footb_seasons` (
`season` smallint(4) unsigned NOT NULL DEFAULT 0,
`season_name` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '',
`season_name_short` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '',
PRIMARY KEY (`season`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
DROP TABLE IF EXISTS `phpbb3_footb_teams`;
CREATE TABLE `phpbb3_footb_teams` (
`season` smallint(4) unsigned NOT NULL DEFAULT 0,
`league` tinyint(2) NOT NULL DEFAULT 0,
`team_id` smallint(4) unsigned NOT NULL DEFAULT 1,
`team_name` varchar(30) COLLATE utf8_bin NOT NULL DEFAULT '',
`team_name_short` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '',
`team_symbol` varchar(25) COLLATE utf8_bin NOT NULL DEFAULT '',
`group_id` char(1) COLLATE utf8_bin NOT NULL DEFAULT '',
`matchday` tinyint(2) NOT NULL DEFAULT 0,
PRIMARY KEY (`season`,`league`,`team_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
DROP TABLE IF EXISTS `phpbb3_footb_teams_hist`;
CREATE TABLE `phpbb3_footb_teams_hist` (
`team_id` smallint(4) unsigned NOT NULL DEFAULT 0,
`team_name` varchar(30) COLLATE utf8_bin NOT NULL DEFAULT '',
PRIMARY KEY (`team_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
Ob dann die Extension auch wirklich funktioniert ist allerdings nicht sicher, da ja noch in den Standard-phpbb Tabellen Einträge vorgenommen werden (zum Beispiel für die Gruppen-Berechtigungen). Wenn diese Einträge fehlen, wird es dort ebenfalls Fehlermeldungen regnen.
P.S. Du kannst es ja mal mit dieser Fehler bereinigten Version testen >>>
In dieser Version sind bereits alle PHP7 - relevanten Fehler behoben, welche hier im Thread gemeldet wurden.