...
- supprimer groupes inutiles :
Bloc de code delete from up_group_membership where member_service='local' and group_id in (select group_id from up_group where creator_id='edu.columbia.ais.portal.channels.announcements.CAnnouncements')Bloc de code delete from up_group where creator_id='edu.columbia.ais.portal.channels.announcements.CAnnouncements'
- nettoyage layouts (pour ne pas exporter tous les layouts utilisateurs) :
- conserver uniquement les utilisateurs "layout" :
Bloc de code delete from up_user where user_id>100 and user_name not like '%-lo'
- conserver uniquement les utilisateurs "layout" :
...
Téléchargement : http://www.esup-portail.org/download/attachments/79659089/esupdev-3.1.12-esup-0.35-RC1.tar.gz?version=1&modificationDate=1258988494000
...