Make the rank function work more than once. :-)
[ccbs] / sql / ccbs.sql
2005-06-12 Steinar H. GundersonMake the rank function work more than once. :-)
2005-06-11 Steinar H. GundersonMake a stored procedure implementation of finding min...
2005-06-11 Steinar H. GundersonMake a (somewhat inefficient?) stored procedure impleme...
2005-06-11 Steinar H. GundersonMoved FetchMaxScoreForPlayers into a stored procedure.
2005-06-11 Steinar H. GundersonMove FetchMaxScoreForSongs into a stored procedure.
2005-04-23 Steinar H. GundersonPull in changes from --baby.
2005-04-04 Steinar H. GundersonPlayers may now split places in tournament rankings.
2005-03-30 Steinar H. GundersonBegin changing the country stuff.
2005-03-04 Steinar H. GundersonAdded a field in the bigscreen active groups allowing...
2005-02-28 Steinar H. GundersonAdded a primary key for the "active screens" table.
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.