Games league database

[Russinating]

I'm making a website to digitise a local boules league. Has anyone made a league database before, and is there anything I'm missing?

Teams play in various leagues (not ranked, just groups) with the two top teams going into a knockout. The knockout needn't be digitised on the fly as it's all played on one day but it would be good to log the results and show the overall winner etc.

Any tips? Should I also have a LEAGUE table or is it ok to calculate positions every time based on the MATCHES database?

TEAMS
id
email
password
name
league

MATCHES
id
date
team1
team2
score1
score2
difference
winner

Any tips appreciated!

 

[Trucamo]

I would personally calculate positions very time based upon the matches table just in case you ever entered a match incorrectly, it could prove awkward to then retrospectively fix up the LEAGUE table.

I also hope that password field is actually a hash of a salt and a password

 

[Scotty123]

You can just calculate the ranking based on the matches database each time the page is requested, I am sure it won't be intensive unless you have thousands of entries?

 

[Russinating]

I would personally calculate positions very time based upon the matches table just in case you ever entered a match incorrectly, it could prove awkward to then retrospectively fix up the LEAGUE table.

I also hope that password field is actually a hash of a salt and a password

I'm no pro so unsure what you mean by salt and password? I generally use MD5, certainly no plain text here.

You can just calculate the ranking based on the matches database each time the page is requested, I am sure it won't be intensive unless you have thousands of entries?

Yeah what I figured. And no, not thousands . It's an inter-business league with probably about 40 companies. Digitizing it for a bit of free advertising .

 

[Scotty123]

Md5 is not useful for passwords. Can be cracked easily. Consider a more appropriate hashing algorithm. Google will tell you some recommendations.

A salt is a random string used in the generation of a hash along with the password, so identical passwords don't generate the same hash.

 

[fretted]

What happens if a team does not turn up and the match is forfeited.. Do you need a flag to record this?

 

[mid_gen]

You can just calculate the ranking based on the matches database each time the page is requested, I am sure it won't be intensive unless you have thousands of entries?

Or the sensible approach, which is to calculate the league standing whenever a match result is added or modified

 

[touch]

I would create a league table and have it linked to both teams and matches. If teams can move between leagues then in might be difficult to track which league a match belongs to.