Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # 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;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement