]> git.xonotic.org Git - xonotic/xonstatdb.git/commit
Partition tables out to 2020, remove old ones.
authorAnt Zucaro <azucaro@gmail.com>
Tue, 2 Dec 2014 02:18:57 +0000 (21:18 -0500)
committerAnt Zucaro <azucaro@gmail.com>
Tue, 2 Dec 2014 02:18:57 +0000 (21:18 -0500)
commit6477b691162a5add0fcd578c9c62002d3fa3cdd3
tree204ff727fc42325b82af38d78ade2fdfc69b238e
parenta08488f2522606743cc69c71aeff4a00b7169254
Partition tables out to 2020, remove old ones.

Since these scripts are used to create a new xonstatdb, references to
partitions using past dates will just mean empty tables. I'll cut off this
pruning at each prior year.
tables/games.tab
tables/player_game_stats.tab
tables/player_weapon_stats.tab
tables/team_game_stats.tab
triggers/games_ins_trg.sql
triggers/player_game_stats_ins_trg.sql
triggers/player_weapon_stats_ins_trg.sql
triggers/team_game_stats_ins_trg.sql