Ginásio C.F. (basketball)
Casino Figueira Ginásio is a professional basketball team based in Figueira da Foz, Portugal. It plays in the second-tier Proliga. In 1977, it won the first-tier LPB.
| Casino Figueira Ginásio | ||||
|---|---|---|---|---|
 | ||||
| Leagues | Proliga | |||
| Arena | Pavilhão Galamba Marques | |||
| Location | Figueira da Foz, Portugal | |||
| Team colors | white & red | |||
| Championships | 1 (1977) | |||
|
| ||||
Achievements
- Liga Portuguesa de Basquetebol: 1 (1976/77)
- Portuguese Basketball Cup: 1 (1976/77)
- Portuguese Basketball Champions Tournament: 1 (2003/04)
- II Divisão Basquetebol: 3 (1968/69, 1987/88, 1991/92)[1][2]
gollark: I did think of the idea of *only* having `revisions` and just running weird queries on that, but it involves more problems.
gollark: Also, the latest update to something doesn't show on the user-visible revisions page, which is a minor nitpick but I mildly dislike it.
gollark: This isn't really ideal, as I think I'm duplicating data a bit (timestamps), updating a page involves more work, and more importantly the `revisions` thing doesn't have any relevant information beyond what's available from `pages`.
gollark: Basically, when there's a new revision, the apiosystem reads the current content out of `pages`, compresses it, generates and serializes the metadata, then shoves in a row into `revisions`.
gollark: As of now I do this:```sqlCREATE TABLE pages ( title TEXT NOT NULL UNIQUE, content TEXT NOT NULL, updated INTEGER NOT NULL, created INTEGER NOT NULL);CREATE TABLE revisions ( page TEXT NOT NULL REFERENCES pages(title), timestamp INTEGER NOT NULL, meta BLOB NOT NULL, -- contains revision metadata and type -- ChangeContent { size } is the only one here for now full_data BLOB -- contains optionally compressed text);```but it is not ideal.
References
- "II Divisão Basquetebol". zerozero.pt (in Portuguese). Archived from the original on 28 April 2020.
- "II Divisão Basquetebol – EVOLUÇÃO HISTÓRICA". zerozero.pt (in Portuguese). Archived from the original on 28 April 2020.
This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.