projects
/
ccbs
/ history
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
first ⋅ prev ⋅ next
Make the rank function work more than once. :-)
[ccbs]
/
sql
/
ccbs.sql
2005-06-12
Steinar H. Gunderson
Make the rank function work more than once. :-)
blob
|
commitdiff
|
raw
2005-06-11
Steinar H. Gunderson
Make a stored procedure implementation of finding min...
blob
|
commitdiff
|
raw
|
diff to current
2005-06-11
Steinar H. Gunderson
Make a (somewhat inefficient?) stored procedure impleme...
blob
|
commitdiff
|
raw
|
diff to current
2005-06-11
Steinar H. Gunderson
Moved FetchMaxScoreForPlayers into a stored procedure.
blob
|
commitdiff
|
raw
|
diff to current
2005-06-11
Steinar H. Gunderson
Move FetchMaxScoreForSongs into a stored procedure.
blob
|
commitdiff
|
raw
|
diff to current
2005-04-23
Steinar H. Gunderson
Pull in changes from --baby.
blob
|
commitdiff
|
raw
|
diff to current
2005-04-04
Steinar H. Gunderson
Players may now split places in tournament rankings.
blob
|
commitdiff
|
raw
|
diff to current
2005-03-30
Steinar H. Gunderson
Begin changing the country stuff.
blob
|
commitdiff
|
raw
|
diff to current
2005-03-04
Steinar H. Gunderson
Added a field in the bigscreen active groups allowing...
blob
|
commitdiff
|
raw
|
diff to current
2005-02-28
Steinar H. Gunderson
Added a primary key for the "active screens" table.
blob
|
commitdiff
|
raw
|
diff to current
2005-02-28
Steinar H. Gunderson
Added a new mini-table for auxilliary bigscreen screens.
blob
|
commitdiff
|
raw
|
diff to current
2005-02-28
Steinar H. Gunderson
(no commit message)
blob
|
commitdiff
|
raw
|
diff to current
2005-02-20
Steinar H. Gunderson
Read max score for all players in one shot as well...
blob
|
commitdiff
|
raw
|
diff to current
2005-02-20
Steinar H. Gunderson
Add information to the SQL schema saying when the group...
blob
|
commitdiff
|
raw
|
diff to current
2005-02-19
Steinar H. Gunderson
Fixed a typo in the SQL for shorttitles.
blob
|
commitdiff
|
raw
|
diff to current
2005-02-19
Steinar H. Gunderson
Added a provision in the SQL for abbreviated titles.
blob
|
commitdiff
|
raw
|
diff to current
2005-02-19
Steinar H. Gunderson
We want to show _groups_ on the big screen, not _rounds_
blob
|
commitdiff
|
raw
|
diff to current
2005-02-19
Steinar H. Gunderson
Add an "active_rounds" table to the bigscreen schema...
blob
|
commitdiff
|
raw
|
diff to current
2005-02-19
Steinar H. Gunderson
Remove PL/PgSQL installation for now, we do manual...
blob
|
commitdiff
|
raw
|
diff to current
2005-02-18
Steinar H. Gunderson
Install PL/PgSQL in the schema etc.
blob
|
commitdiff
|
raw
|
diff to current
2005-02-18
Steinar H. Gunderson
Started on a bigscreen SQL schema.
blob
|
commitdiff
|
raw
|
diff to current
2005-02-18
Steinar H. Gunderson
Different songs can have different ratings on different...
blob
|
commitdiff
|
raw
|
diff to current
2005-02-14
Steinar H. Gunderson
Add state to the random song chooser, so it doesn't...
blob
|
commitdiff
|
raw
|
diff to current
2005-02-14
Steinar H. Gunderson
Added a machinesongs table, and a small snippet to...
blob
|
commitdiff
|
raw
|
diff to current
2005-02-14
Steinar H. Gunderson
Fix more stuff related to making new groups.
blob
|
commitdiff
|
raw
|
diff to current
2005-02-14
Steinar H. Gunderson
Removed NOT NULL from score in the SQL schema.
blob
|
commitdiff
|
raw
|
diff to current
2005-02-14
Steinar H. Gunderson
Added a "number of people qualifying for each round...
blob
|
commitdiff
|
raw
|
diff to current
2005-02-14
Steinar H. Gunderson
Add a new table to the SQL for tournament participation.
blob
|
commitdiff
|
raw
|
diff to current
2005-02-14
Steinar H. Gunderson
Update the parser scripts to handle tournament rankings...
blob
|
commitdiff
|
raw
|
diff to current
2005-02-14
Steinar H. Gunderson
Add a table for tournament ranking to the SQL schema.
blob
|
commitdiff
|
raw
|
diff to current
2005-02-14
Steinar H. Gunderson
Change all instances of "name" to something more sane...
blob
|
commitdiff
|
raw
|
diff to current
2005-02-13
Steinar H. Gunderson
Add a "song number" to the score schema.
blob
|
commitdiff
|
raw
|
diff to current
2005-02-13
Steinar H. Gunderson
Fixed uniqueness contrains for seasons
blob
|
commitdiff
|
raw
|
diff to current
2005-02-13
Steinar H. Gunderson
Add missing comma to roundparticipation definition.
blob
|
commitdiff
|
raw
|
diff to current
2005-02-13
Steinar H. Gunderson
Add position to roundparticipation (so we can order...
blob
|
commitdiff
|
raw
|
diff to current
2005-02-13
Steinar H. Gunderson
Add uniqueness constraint to tournaments as well.
blob
|
commitdiff
|
raw
|
diff to current
2005-02-13
Steinar H. Gunderson
Add UNIQUE to the trivial tables.
blob
|
commitdiff
|
raw
|
diff to current
2005-02-13
Steinar H. Gunderson
Move SQL files into their own directory.
blob
|
commitdiff
|
raw
|
diff to current