CREATE
ALGORITHM = UNDEFINED
DEFINER = `root`@`localhost`
SQL SECURITY DEFINER
VIEW `vwgameevents` AS
SELECT
`x`.`league` AS `league`,
`x`.`id` AS `eventid`,
`x`.`date` AS `date`,
CONCAT(`x`.`date`, ' ', `y`.`starttime`) AS `datetime`,
`y`.`hometeam` AS `hometeam`,
`y`.`awayteam` AS `awayteam`,
`y`.`starttime` AS `starttime`,
`y`.`homescore` AS `homescore`,
`y`.`awayscore` AS `awayscore`,
`y`.`id` AS `gameid`,
`z`.`sport` AS `sportid`,
`z`.`id` AS `leagueid`,
`z`.`icon` AS `leagueicon`,
`a`.`name` AS `sportname`,
`a`.`icon` AS `icon`,
`a`.`duration` AS `duration`,
`p`.`status` AS `status`,
`s`.`name` AS `name`
FROM
(((((`events` `x`
JOIN `games` `y` ON ((`y`.`event` = `x`.`id`)))
JOIN `leagues` `z` ON ((`x`.`league` = `z`.`name`)))
JOIN `sports` `a` ON ((`z`.`sport` = `a`.`id`)))
JOIN `progress` `p` ON ((`y`.`id` = `p`.`game`)))
JOIN `status` `s` ON ((`p`.`status` = `s`.`id`)))
ORDER BY `x`.`date` , `y`.`starttime`
vwsports
Columns
Column
Alias
sports.id
id
sports.name
sportsname
sports.icon
sportsicon
leagues.name
leaguename
leagues.icon
leagueicon
Script
CREATE
ALGORITHM = UNDEFINED
DEFINER = `root`@`localhost`
SQL SECURITY DEFINER
VIEW `vwsports` AS
SELECT
`x`.`id` AS `id`,
`x`.`name` AS `sportsname`,
`x`.`icon` AS `sportsicon`,
`y`.`name` AS `leaguename`,
`y`.`icon` AS `leagueicon`
FROM
(`sports` `x`
JOIN `leagues` `y` ON ((`x`.`id` = `y`.`sport`)))
vwteams
Columns
Column
Alias
teams.name
teamname
leagues.name
leaguename
Script
CREATE
ALGORITHM = UNDEFINED
DEFINER = `root`@`localhost`
SQL SECURITY DEFINER
VIEW `vwteams` AS
SELECT
`x`.`name` AS `teamname`,
`y`.`name` AS `leaguename`
FROM
(`teams` `x`
JOIN `leagues` `y` ON ((`x`.`league` = `y`.`id`)))
