Changeset 911

Show
Ignore:
Timestamp:
07/29/08 11:10:58 (4 months ago)
Author:
rach
Message:

correct bug : problem with one PK format

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • trunk/DataBase/mysql-5.x/UPDATE-a2billing-v1.3.0-to-v1.4.0-mysql.sql

    r910 r911  
    963963        name                            CHAR( 30 ) NOT NULL collate utf8_bin , 
    964964        id_agi_conf             INT NOT NULL , 
    965         description             MEDIUMTEXT CHARACTER  
     965        description             MEDIUMTEXT CHARACTER , 
    966966        PRIMARY KEY ( id ) 
    967967) ENGINE = MYISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; 
    …… 
    10151015 
    10161016 
    1017 ALTER TABLE `cc_config` CHANGE `config_description` `config_description` TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL; 
     1017ALTER TABLE cc_config CHANGE config_description config_description TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL; 
    10181018 
    10191019 
    …… 
    10331033 
    10341034-- CHANGE SECURITY ABOUT PASSWORD 
    1035  ALTER TABLE cc_ui_authen CHANGE password pwd_encoded VARCHAR( 250 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ; 
     1035 
     1036ALTER TABLE cc_ui_authen CHANGE password pwd_encoded VARCHAR( 250 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL ; 
    10361037 
    10371038UPDATE cc_ui_authen SET pwd_encoded = '34e125a0ce58a0c230db9110116767e3e95f143096eb66df2eeb77c43ca9210377ebca623e37242d16080b6a128e66dcbd2fbe137050120d3f2ab8420dd6cc70' WHERE login = 'root' ; 
    …… 
    10421043ADD traffic BIGINT NULL , 
    10431044ADD traffic_target MEDIUMTEXT NULL ; 
     1045 


Google