search

rubenvanassche / Programming-Project-Databases

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

Drop continent table #17

Closed STOWouters closed 10 years ago

STOWouters commented 10 years ago

Is the continent table really neccessary? I have some difficulties with crawling countries: so far, I couldn't find a good list where you can get country, its FIFA country code, and the continent it belongs to all at the same time. For now, I've let the continent field for all countries to '' (empty string), but I would suggest to DROP that table, unless someone can bring me up a good list.

For now, I've crawled the countries and its FIFA code from wikipedia, hence, I'm trying to get the continent from this sample page (on the summary on the left of the page, next to entry 'Confederation'), but for now I can't get this value. Going to try to fix that, but dropping the table or get a perfect list is, of course, the easiest solution. Need to discuss that for the next meeting.

tomroels commented 10 years ago

Don't do this ! Choose one continent for shitty 2 continent countries.