User Tools

Site Tools


admin:lan_party

query to reset database for new lan party

DELETE FROM caffeine;
DELETE FROM foodrun;
 
 
DELETE FROM game_requests;
DELETE FROM pizza
DELETE FROM poll
DELETE FROM poll_maps
DELETE FROM poll_votes
DELETE FROM poll_votes_maps;
 
DELETE FROM prizes;
DELETE FROM prizes_control;
DELETE FROM prizes_display_groups;
DELETE FROM prizes_unwinners;
DELETE FROM prizes_votes;
DELETE FROM prizes_winners;
DELETE FROM schedule;
DELETE FROM servers;
DELETE FROM shoutbox;
DELETE FROM techsupport;
 
DELETE FROM tournament_matches;
DELETE FROM tournament_matches_score_votes;
DELETE FROM tournament_matches_teams;
DELETE FROM tournament_players;
DELETE FROM tournament_teams;
DELETE FROM tournament_teams_type;
DELETE FROM tournaments;
 
DELETE FROM users WHERE userid > 5;
admin/lan_party.txt · Last modified: 2021/05/02 21:36 (external edit)