Hello,

   I've put together a new sport.db (football.db) quick starter sample
using the Mauritius Premier League [1] to get you started creating
your own leagues/cups/etc. from scratch.

  You can test drive the quick starter sample with a single command e.g.

   $ sportdb build

That's it. Now try:

  $ sqlite3 sport.db

> SQLite version 3.7.16
> Enter ".help" for instructions
> Enter SQL statements terminated with a ";"
>
> sqlite> .tables
>
> alltime_standing_entries  events_grounds            names
> alltime_standings         events_teams              parts
> assocs                    games                     persons
> assocs_assocs             goals                     places
> badges                    grounds                   props
> cities                    group_standing_entries    rosters
> continents                group_standings           rounds
> counties                  groups                    seasons
> countries                 groups_teams              states
> country_codes             langs                     taggings
> districts                 leagues                   tags
> event_standing_entries    logs                      teams
> event_standings           metros                    usages
> events                    munis                     zones
>
> sqlite> select * from countries;
> 1|Mauritius|mauritius|mu|1|MUS|||1261200|2040|||f|t|f|f|
>
> sqlite> select * from teams;
> 1|joachim|Cercle de Joachim||CDJ|Cercle de Joachim SC|Joachim|1||t|||||f|
> 2|chamarel|Chamarel SC||CHA|Chamarel|Chamarel Sport Club|1||t|||||f|

  and so on and so forth.   Cheers.


[1] github.com/sportkit/mu-mauritius

Reply via email to