Views

vwgameevents

Columns

Column

Alias

events.league

league

events.id

eventid

events.date

date

games.hometeam

hometeam

games.awayteam

awayteam

games.starttime

starttime

games.homescore

homescore

games.awayscore

awayscore

games.id

gameid

leagues.sport

sportid

leagues.id

leagueid

leagues.icon

leagueicon

sports.name

sportname

sports.icon

icon

sports.duration

duration

progress.status

status

status.name

name

Script

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`)))