install/schemas/upgrade/1.1.3-1.1.4-mysql.sql
changeset 621 68f8a9cc0a18
parent 555 ac4c6a7f01d8
equal deleted inserted replaced
620:58852672ff12 621:68f8a9cc0a18
    25 -- Other rank-related columns
    25 -- Other rank-related columns
    26 ALTER TABLE {{TABLE_PREFIX}}groups ADD COLUMN group_rank int(12) unsigned DEFAULT NULL;
    26 ALTER TABLE {{TABLE_PREFIX}}groups ADD COLUMN group_rank int(12) unsigned DEFAULT NULL;
    27 
    27 
    28 -- Disable JS effects column
    28 -- Disable JS effects column
    29 ALTER TABLE {{TABLE_PREFIX}}users_extra ADD COLUMN disable_js_fx tinyint(1) NOT NULL DEFAULT 0;
    29 ALTER TABLE {{TABLE_PREFIX}}users_extra ADD COLUMN disable_js_fx tinyint(1) NOT NULL DEFAULT 0;
       
    30 
       
    31 -- Add "grv" avatar type
       
    32 ALTER TABLE {{TABLE_PREFIX}}users MODIFY COLUMN avatar_type ENUM('png', 'gif', 'jpg', 'grv');