File: prunetables.sql

package info (click to toggle)
scorched3d 41.3dfsg-1
  • links: PTS, VCS
  • area: main
  • in suites: lenny
  • size: 159,620 kB
  • ctags: 26,898
  • sloc: cpp: 110,179; xml: 36,743; ansic: 31,536; makefile: 4,321; sh: 3,708; perl: 1,522; java: 209; python: 188; sql: 146
file content (6 lines) | stat: -rw-r--r-- 315 bytes parent folder | download 
1
2
3
4
5
6
 
delete from scorched3d_events where TO_DAYS(NOW()) - TO_DAYS(scorched3d_events.eventtime) > 7;

create temporary table tmp select playerid from scorched3d_stats group by playerid having sum(shots) = 0;

delete from scorched3d_players using scorched3d_players, tmp where scorched3d_players.playerid = tmp.playerid;