== Conditions préalables à la migration ==

- que les noms des fichiers attachés aux agendas ne contiennent pas d'accent. Sinon une solution consiste à lancer un script les remplaçant par le caractère non accentué dans la base de données et dans le nom du fichier

- que les formats de temps (variable time format) et de date (variable datetime format) de la base de données comprennent les secondes ('%H:%i:%s' et '%Y-%m-%d %H:%i:%s' par exemple)

- 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 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;''