File: prunetables.sql

package info (click to toggle)
scorched3d 44%2Bdfsg-8
  • links: PTS, VCS
  • area: main
  • in suites: bookworm, forky, sid, trixie
  • size: 112,612 kB
  • sloc: cpp: 135,987; xml: 36,739; makefile: 4,714; sh: 3,172; ansic: 1,407; perl: 541; java: 209; python: 188; sql: 159
file content (6 lines) | stat: -rw-r--r-- 321 bytes parent folder | download | duplicates (7) 
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;