Page History

DELETE FROM usergrouptable ut WHERE ut.userid <> (SELECT objectid FROM usertable WHERE userid = 'admin') or ut.groupID <> (SELECT objectid FROM grouptable WHERE groupid = 'Administrators');
DELETE FROM grouptable gr WHERE gr.groupid <> 'Administrators';
DELETE FROM pm_activityredirection_users;
DELETE FROM pm_activityredirection_groups;
DELETE FROM pm_activityredirection;
DELETE FROM pm_userdata;
DELETE FROM pm_substitutions;
DELETE FROM pm_domainservers;
DELETE FROM pm_position_role;
UPDATE pm_positions SET organizationalunitid = NULL;
UPDATE pm_organizationalunits SET directorpositionid = NULL;
DELETE FROM pm_organizationalunits;
DELETE FROM pm_positions;
DELETE FROM userTable us WHERE us.objectid <> (SELECT objectid FROM usertable WHERE userid = 'admin');
DELETE FROM pm_actions;
DELETE FROM pm_linkconnection;
DELETE FROM pm_indexpattern;
DELETE FROM pm_indecies;
DELETE FROM pm_processdef_docclass;
DELETE FROM pm_docclasses;
DELETE FROM pm_docclassconditionprotection;
DELETE FROM pm_docclassprotection;
DELETE FROM pm_linkindecies;
DELETE FROM pm_links;
DELETE FROM pm_directories;
DELETE FROM pm_devices;
DELETE FROM pm_substitutions;
DELETE FROM pm_document_views;
DELETE FROM pm_processData;
DELETE FROM pm_documenttemplate;
DELETE FROM pm_notificationdef;
DELETE FROM pm_notificationprocact;
DELETE FROM pm_notificationrecipient;
DELETE FROM pm_change_user_repl;
DELETE FROM pm_advancesearchvariables;
DELETE FROM pm_usersearchviewsprotection;
DELETE FROM pm_usersearchviews;
DELETE FROM pm_userdata WHERE userid <> (SELECT objectid FROM usertable WHERE userid = 'admin');
DELETE FROM pm_rights r WHERE r.resource_id <> 'admin';
DELETE FROM pm_variable_distinguish;
 
//Wtyczki
DELETE FROM pm_dashboard;
DELETE FROM pm_favourites_set;