...
Code Block | ||
---|---|---|
| ||
DELETE FROM usergrouptable WHERE userid <> (SELECT oid FROM usertable WHERE userid = 'admin') or groupID <> (SELECT oid FROM grouptable WHERE groupid = 'Administrators'); DELETE FROM grouptable WHERE 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 WHERE oid <> (SELECT oid FROM usertable WHERE userid = 'admin'); DELETE FROM pm_actions; delete from pm_file_versions; delete from pm_files; DELETE FROM pm_linkconnection; DELETE FROM pm_indexpattern; DELETE FROM pm_indecies; DELETE FROM pm_processdef_docclass; DELETE FROM pm_docclassconditionprotection; DELETE FROM pm_docclasses; 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 oid FROM usertable WHERE userid = 'admin'); DELETE FROM pm_rights WHERE resource_id <> 'admin' |
Wtyczki
Narzędzie (od wersji systemu 3.3.x) obsługuje przenoszenie konfiguracji dla wtyczek:
Wtyczka | Dostępne od wersji | Uwagi |
---|---|---|
Dasboard | X |
|
Favourites | X |