Differences

This shows you the differences between two versions of the page.

--- admin:lan_party [2016/02/15 21:43]
walter ↷ Page moved from lan_party to admin:lan_party
+++ admin:lan_party [2021/05/02 21:36]
@@ Line 1: / Line 1: @@
-query to reset database for new lan party
-<code sql>
-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;
-</code>

UIC ACM