rubenvanassche / Programming-Project-Databases

A World championship statistics website
coachcenter.be
GNU General Public License v3.0
1 stars 1 forks source link

cards enum #88

Closed STOWouters closed 10 years ago

STOWouters commented 10 years ago

Since PR #87 the color field in cards table is an enumerator of yellow and red. The layout needs to be fixed to display the correct color.

For example, the match Netherlands - Spain has a player John Heitinga, who has received 2 yellow card, so the third yellow card is actually a red one.

JakobStruye commented 10 years ago

I'll take care of it.

What did you do with a second yellow card resulting in a red card, did you add both a yellow and a red card in that case?

STOWouters commented 10 years ago

What did you do with a second yellow card resulting in a red card, did you add both a yellow and a red card in that case?

Exactly.

(You can compare match id and time to determine whether this was a second yellow card turning into red card.)

JakobStruye commented 10 years ago

Done