tag of sgunderson@bigfoot.com--2005-private/ccbs--mainline--0.1--patch-460
[ccbs] / sql /
2005-07-17 Steinar H. GundersonAdd a stray SQL file that had been sitting in my direct...
2005-07-17 Steinar H. GundersonPull in an SQL fix from who-knows-where.
2005-06-12 Steinar H. GundersonAdded a stored procedure for finding the min/max rank...
2005-06-12 Steinar H. GundersonAdded a "parallel" argument to the min/max stored proce...
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. GundersonSync from --pgweb.
2005-04-04 Steinar H. GundersonSync from --pgweb.
2005-04-04 Steinar H. GundersonSync with --pgweb.
2005-04-04 Steinar H. GundersonSync from --pgweb.
2005-04-04 Steinar H. GundersonFix patch-381 (some bad changes snuck in).
2005-04-04 Steinar H. GundersonPlayers may now split places in tournament rankings.
2005-03-30 Steinar H. GundersonAdd some SQL for correcting nationalities from EC1.
2005-03-30 Steinar H. GundersonAdd various tournaments from DDR Europe. Not all are...
2005-03-30 Steinar H. GundersonAdd -10K Machine score as a scoring system.
2005-03-30 Steinar H. GundersonAdd scripts and example SQL for parsing the EM2 series...
2005-03-30 Steinar H. GundersonAdd scripts for getting CC03 data, and premade SQL.
2005-03-30 Steinar H. GundersonDDR Europe tournament parser now by default sets all...
2005-03-30 Steinar H. GundersonAdd a script (and output SQL) for getting the country...
2005-03-30 Steinar H. GundersonBegin changing the country stuff.
2005-03-05 Steinar H. GundersonAdd an SQL snippet for fixing some stuff related to...
2005-03-05 Steinar H. GundersonAdded CC04-8 data.
2005-03-05 Steinar H. Gunderson"Candy" now has a white star by it; updated parsers...
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. GundersonAdded a few more short titles.
2005-02-19 Steinar H. GundersonAdded a short title for www.blonde girl.
2005-02-19 Steinar H. GundersonAdd a short title for Never Gonna Make
2005-02-19 Steinar H. GundersonAdd some common EM2 song titles.
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. GundersonFix DDRFreak parser to output some UTF-8 glyphs instead...
2005-02-18 Steinar H. GundersonMake the DDRFreak parser script case insensitive with...
2005-02-18 Steinar H. GundersonAdd the Extreme song list (from DDRFreak) to the base...
2005-02-18 Steinar H. GundersonAdded DDR Extreme as a machine for the basic data.
2005-02-18 Steinar H. GundersonUpdate the wiki parser and the EM2 SQL to match the...
2005-02-18 Steinar H. GundersonAdd CC03 as a season in the test data.
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. GundersonMake sure players are created before adding them to...
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. GundersonMake DDR Europe parser script convert from ISO8859...
2005-02-14 Steinar H. GundersonChange all instances of "name" to something more sane...
2005-02-13 Steinar H. GundersonUpdate the DDR Europe parser to add song ordering infor...
2005-02-13 Steinar H. GundersonAdd a "song number" to the score schema.
2005-02-13 Steinar H. GundersonAdd? Hello?
2005-02-13 Steinar H. GundersonUpdate CC test data.
2005-02-13 Steinar H. GundersonAdded test data (almost entire CC 2004 season).
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. GundersonAdd a score system to the basic data.
2005-02-13 Steinar H. GundersonAdd an SQL file with the most basic data.
2005-02-13 Steinar H. GundersonMove SQL files into their own directory.