Version 3 (modified by 18 years ago) (diff) | ,
---|
Migration de CDS Agenda vers Indico
Cette page a pour but de conserver tous les soucis rencontrés lors de la migration de CDS Agenda vers Indico, ainsi que d'expliquer comment les résoudre quand cela est connu
Des conditions préalables à la migration ont pu être identifiées :
- que la base de données soit encodé en utf-8. Si ce n'est pas le cas, le script suivant peut être utilisé :
ALTER TABLE ACCESSSTATS CONVERT TO CHARACTER SET utf8;
ALTER TABLE ACTUALROLES CONVERT TO CHARACTER SET utf8;
ALTER TABLE AGENDA CONVERT TO CHARACTER SET utf8;
ALTER TABLE AGENDA_ICTP CONVERT TO CHARACTER SET utf8;
ALTER TABLE ALERT CONVERT TO CHARACTER SET utf8;
ALTER TABLE authorization CONVERT TO CHARACTER SET utf8;
ALTER TABLE BK_AGENDA CONVERT TO CHARACTER SET utf8;
ALTER TABLE BK_SESSION CONVERT TO CHARACTER SET utf8;
ALTER TABLE BK_SUBTALK CONVERT TO CHARACTER SET utf8;
ALTER TABLE BK_TALK CONVERT TO CHARACTER SET utf8;
ALTER TABLE CATEGORY CONVERT TO CHARACTER SET utf8;
ALTER TABLE cdsagenda_public CONVERT TO CHARACTER SET utf8;
ALTER TABLE COUNTER CONVERT TO CHARACTER SET utf8;
ALTER TABLE DEFAULTGROUPPOLICIES CONVERT TO CHARACTER SET utf8;
ALTER TABLE DEFAULTPOLICIES CONVERT TO CHARACTER SET utf8;
ALTER TABLE DOCUMENTSTATS CONVERT TO CHARACTER SET utf8;
ALTER TABLE EVENTHITSTATS CONVERT TO CHARACTER SET utf8;
ALTER TABLE EVENT_PASSWORD CONVERT TO CHARACTER SET utf8;
ALTER TABLE FILE CONVERT TO CHARACTER SET utf8;
ALTER TABLE FILETRASH CONVERT TO CHARACTER SET utf8;
ALTER TABLE FILE_DOMAIN CONVERT TO CHARACTER SET utf8;
ALTER TABLE FILE_EVENT CONVERT TO CHARACTER SET utf8;
ALTER TABLE FILE_PASSWORD CONVERT TO CHARACTER SET utf8;
ALTER TABLE FILE_USER CONVERT TO CHARACTER SET utf8;
ALTER TABLE groups CONVERT TO CHARACTER SET utf8;
ALTER TABLE group_authorization_item CONVERT TO CHARACTER SET utf8;
ALTER TABLE LEVEL CONVERT TO CHARACTER SET utf8;
ALTER TABLE role CONVERT TO CHARACTER SET utf8;
ALTER TABLE ROLES CONVERT TO CHARACTER SET utf8;
ALTER TABLE session CONVERT TO CHARACTER SET utf8;
ALTER TABLE SESSION CONVERT TO CHARACTER SET utf8;
ALTER TABLE SUBTALK CONVERT TO CHARACTER SET utf8;
ALTER TABLE TALK CONVERT TO CHARACTER SET utf8;
ALTER TABLE user CONVERT TO CHARACTER SET utf8;
ALTER TABLE user_authorization_item CONVERT TO CHARACTER SET utf8;
ALTER TABLE user_groups CONVERT TO CHARACTER SET utf8;
-