Added a new mini-table for auxilliary bigscreen screens.
[ccbs] / sql / ccbs.sql
2005-02-28 Steinar H. GundersonAdded a new mini-table for auxilliary bigscreen screens.
2005-02-28 Steinar H. Gunderson(no commit message)
2005-02-20 Steinar H. GundersonRead max score for all players in one shot as well...
2005-02-20 Steinar H. GundersonAdd information to the SQL schema saying when the group...
2005-02-19 Steinar H. GundersonFixed a typo in the SQL for shorttitles.
2005-02-19 Steinar H. GundersonAdded a provision in the SQL for abbreviated titles.
2005-02-19 Steinar H. GundersonWe want to show _groups_ on the big screen, not _rounds_
2005-02-19 Steinar H. GundersonAdd an "active_rounds" table to the bigscreen schema...
2005-02-19 Steinar H. GundersonRemove PL/PgSQL installation for now, we do manual...
2005-02-18 Steinar H. GundersonInstall PL/PgSQL in the schema etc.
2005-02-18 Steinar H. GundersonStarted on a bigscreen SQL schema.
2005-02-18 Steinar H. GundersonDifferent songs can have different ratings on different...
2005-02-14 Steinar H. GundersonAdd state to the random song chooser, so it doesn't...
2005-02-14 Steinar H. GundersonAdded a machinesongs table, and a small snippet to...
2005-02-14 Steinar H. GundersonFix more stuff related to making new groups.
2005-02-14 Steinar H. GundersonRemoved NOT NULL from score in the SQL schema.
2005-02-14 Steinar H. GundersonAdded a "number of people qualifying for each round...
2005-02-14 Steinar H. GundersonAdd a new table to the SQL for tournament participation.
2005-02-14 Steinar H. GundersonUpdate the parser scripts to handle tournament rankings...
2005-02-14 Steinar H. GundersonAdd a table for tournament ranking to the SQL schema.
2005-02-14 Steinar H. GundersonChange all instances of "name" to something more sane...
2005-02-13 Steinar H. GundersonAdd a "song number" to the score schema.
2005-02-13 Steinar H. GundersonFixed uniqueness contrains for seasons
2005-02-13 Steinar H. GundersonAdd missing comma to roundparticipation definition.
2005-02-13 Steinar H. GundersonAdd position to roundparticipation (so we can order...
2005-02-13 Steinar H. GundersonAdd uniqueness constraint to tournaments as well.
2005-02-13 Steinar H. GundersonAdd UNIQUE to the trivial tables.
2005-02-13 Steinar H. GundersonMove SQL files into their own directory.