# Completely empty your database, only keeping site settings, groups, categories and blacklists, regexes and users.

UPDATE groups SET first_record = 0;
UPDATE groups SET first_record_postdate=NULL;
UPDATE groups SET last_record = 0;
UPDATE groups SET last_record_postdate=NULL;
UPDATE groups SET last_updated=NULL;
TRUNCATE anidb;
TRUNCATE binaries;
TRUNCATE bookinfo;
TRUNCATE consoleinfo;
TRUNCATE episodeinfo;
TRUNCATE genres;
TRUNCATE movieinfo;
TRUNCATE musicinfo;
TRUNCATE partrepair;
TRUNCATE parts;
TRUNCATE predb;
TRUNCATE releaseaudio;
TRUNCATE releasecomment;
TRUNCATE releaseextrafull;
TRUNCATE releasefiles;
TRUNCATE releasenfo;
TRUNCATE releases;
TRUNCATE releasesubs;
TRUNCATE releasevideo;
TRUNCATE roleexcat;
TRUNCATE sphinx;
TRUNCATE thetvdb;
TRUNCATE upcoming;
TRUNCATE usercard;
TRUNCATE userdownloads;
TRUNCATE userexcat;
TRUNCATE usermovies;
TRUNCATE userrequests;
TRUNCATE userseries;