Matches

Ok, now I am making this table let me comment on it while I am creating it:

mid
This is the basic match id, which is used to identify the match

mname
Match name is a simple short description what the match is. Could be like "Friendly match", or ... "Easter DeathMatch".. whatever.

mteam1
This defines the team A

mteam2
This defines the team B

mscore1
This will be the score of the end of the match for team A (this is being calculated by the rounds!)

mscore2
This will be the score of the end of the match for Team B (this is being calculated by the rounds!)

mdate
This is the date that the match is planned for.

mstatus
This defines the status of the match... I still need to think about what the final setup is going to be. But lets just say: 1=open, 2=playing, 4=declined, 3=played

I am not sure about the 2=playing, since this could be done automaticly by matching up the mDate (date time when it takes place). Also, this leads me with another issue I just thought of... TIMEZONES! Fuck!

Ok.. lets add this one aswell, since I am probably going to need it later on.

mtimezone
this is a signed integer because a timezone can be negative as positive.

Anything I am missing? I don't think so... but when I do... I can add it later on. So lets press save and create the rounds section.