Changes between Version 3 and Version 4 of Migration


Ignore:
Timestamp:
Nov 10, 2006, 9:27:36 AM (18 years ago)
Author:
Melot
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Migration

    v3 v4  
    77- que la base de données soit encodé en utf-8. Si ce n'est pas le cas, le script suivant peut être utilisé :
    88
    9    ALTER TABLE ACCESSSTATS CONVERT TO CHARACTER SET utf8;
     9   ''ALTER TABLE ACCESSSTATS CONVERT TO CHARACTER SET utf8;''
    1010
    11    ALTER TABLE ACTUALROLES CONVERT TO CHARACTER SET utf8;
     11   ''ALTER TABLE ACTUALROLES CONVERT TO CHARACTER SET utf8;''
    1212
    13    ALTER TABLE AGENDA CONVERT TO CHARACTER SET utf8;
     13   ''ALTER TABLE AGENDA CONVERT TO CHARACTER SET utf8;''
    1414
    15    ALTER TABLE AGENDA_ICTP CONVERT TO CHARACTER SET utf8;
     15   ''ALTER TABLE AGENDA_ICTP CONVERT TO CHARACTER SET utf8;''
    1616
    17    ALTER TABLE ALERT CONVERT TO CHARACTER SET utf8;
     17   ''ALTER TABLE ALERT CONVERT TO CHARACTER SET utf8;''
    1818
    19    ALTER TABLE authorization CONVERT TO CHARACTER SET utf8;
     19   ''ALTER TABLE authorization CONVERT TO CHARACTER SET utf8;''
    2020
    21    ALTER TABLE BK_AGENDA CONVERT TO CHARACTER SET utf8;
     21   ''ALTER TABLE BK_AGENDA CONVERT TO CHARACTER SET utf8;''
    2222
    23    ALTER TABLE BK_SESSION CONVERT TO CHARACTER SET utf8;
     23   ''ALTER TABLE BK_SESSION CONVERT TO CHARACTER SET utf8;''
    2424
    25    ALTER TABLE BK_SUBTALK CONVERT TO CHARACTER SET utf8;
     25   ''ALTER TABLE BK_SUBTALK CONVERT TO CHARACTER SET utf8;''
    2626
    27    ALTER TABLE BK_TALK CONVERT TO CHARACTER SET utf8;
     27   ''ALTER TABLE BK_TALK CONVERT TO CHARACTER SET utf8;''
    2828
    29    ALTER TABLE CATEGORY CONVERT TO CHARACTER SET utf8;
     29   ''ALTER TABLE CATEGORY CONVERT TO CHARACTER SET utf8;''
    3030
    31    ALTER TABLE cdsagenda_public CONVERT TO CHARACTER SET utf8;
     31   ''ALTER TABLE cdsagenda_public CONVERT TO CHARACTER SET utf8;''
    3232
    33    ALTER TABLE COUNTER CONVERT TO CHARACTER SET utf8;
     33   ''ALTER TABLE COUNTER CONVERT TO CHARACTER SET utf8;''
    3434
    35    ALTER TABLE DEFAULTGROUPPOLICIES CONVERT TO CHARACTER SET utf8;
     35   ''ALTER TABLE DEFAULTGROUPPOLICIES CONVERT TO CHARACTER SET utf8;''
    3636
    37    ALTER TABLE DEFAULTPOLICIES CONVERT TO CHARACTER SET utf8;
     37   ''ALTER TABLE DEFAULTPOLICIES CONVERT TO CHARACTER SET utf8;''
    3838
    39    ALTER TABLE DOCUMENTSTATS CONVERT TO CHARACTER SET utf8;
     39   ''ALTER TABLE DOCUMENTSTATS CONVERT TO CHARACTER SET utf8;''
    4040
    41    ALTER TABLE EVENTHITSTATS CONVERT TO CHARACTER SET utf8;
     41   ''ALTER TABLE EVENTHITSTATS CONVERT TO CHARACTER SET utf8;''
    4242
    43    ALTER TABLE EVENT_PASSWORD CONVERT TO CHARACTER SET utf8;
     43   ''ALTER TABLE EVENT_PASSWORD CONVERT TO CHARACTER SET utf8;''
    4444
    45    ALTER TABLE FILE CONVERT TO CHARACTER SET utf8;
     45   ''ALTER TABLE FILE CONVERT TO CHARACTER SET utf8;''
    4646
    47    ALTER TABLE FILETRASH CONVERT TO CHARACTER SET utf8;
     47   ''ALTER TABLE FILETRASH CONVERT TO CHARACTER SET utf8;''
    4848
    49    ALTER TABLE FILE_DOMAIN CONVERT TO CHARACTER SET utf8;
     49   ''ALTER TABLE FILE_DOMAIN CONVERT TO CHARACTER SET utf8;''
    5050
    51    ALTER TABLE FILE_EVENT CONVERT TO CHARACTER SET utf8;
     51   ''ALTER TABLE FILE_EVENT CONVERT TO CHARACTER SET utf8;''
    5252
    53    ALTER TABLE FILE_PASSWORD CONVERT TO CHARACTER SET utf8;
     53   ''ALTER TABLE FILE_PASSWORD CONVERT TO CHARACTER SET utf8;''
    5454
    55    ALTER TABLE FILE_USER CONVERT TO CHARACTER SET utf8;
     55   ''ALTER TABLE FILE_USER CONVERT TO CHARACTER SET utf8;''
    5656
    57    ALTER TABLE groups CONVERT TO CHARACTER SET utf8;
     57   ''ALTER TABLE groups CONVERT TO CHARACTER SET utf8;''
    5858
    59    ALTER TABLE group_authorization_item CONVERT TO CHARACTER SET utf8;
     59   ''ALTER TABLE group_authorization_item CONVERT TO CHARACTER SET utf8;''
    6060
    61    ALTER TABLE LEVEL CONVERT TO CHARACTER SET utf8;
     61   ''ALTER TABLE LEVEL CONVERT TO CHARACTER SET utf8;''
    6262
    63    ALTER TABLE role CONVERT TO CHARACTER SET utf8;
     63   ''ALTER TABLE role CONVERT TO CHARACTER SET utf8;''
    6464
    65    ALTER TABLE ROLES CONVERT TO CHARACTER SET utf8;
     65   ''ALTER TABLE ROLES CONVERT TO CHARACTER SET utf8;''
    6666
    67    ALTER TABLE session CONVERT TO CHARACTER SET utf8;
     67   ''ALTER TABLE session CONVERT TO CHARACTER SET utf8;''
    6868
    69    ALTER TABLE SESSION CONVERT TO CHARACTER SET utf8;
     69   ''ALTER TABLE SESSION CONVERT TO CHARACTER SET utf8;''
    7070
    71    ALTER TABLE SUBTALK CONVERT TO CHARACTER SET utf8;
     71   ''ALTER TABLE SUBTALK CONVERT TO CHARACTER SET utf8;''
    7272
    73    ALTER TABLE TALK CONVERT TO CHARACTER SET utf8;
     73   ''ALTER TABLE TALK CONVERT TO CHARACTER SET utf8;''
    7474
    75    ALTER TABLE user CONVERT TO CHARACTER SET utf8;
     75   ''ALTER TABLE user CONVERT TO CHARACTER SET utf8;''
    7676
    77    ALTER TABLE user_authorization_item CONVERT TO CHARACTER SET utf8;
     77   ''ALTER TABLE user_authorization_item CONVERT TO CHARACTER SET utf8;''
    7878
    79    ALTER TABLE user_groups CONVERT TO CHARACTER SET utf8;
     79   ''ALTER TABLE user_groups CONVERT TO CHARACTER SET utf8;''
    8080
    8181-