install/schemas/upgrade/1.1.3-1.1.4-postgresql.sql
changeset 555 ac4c6a7f01d8
parent 541 acb7e23b6ffa
child 621 68f8a9cc0a18
equal deleted inserted replaced
554:e87390b1f9b0 555:ac4c6a7f01d8
    32 -- No frontend to this yet so ranks should not have been created.
    32 -- No frontend to this yet so ranks should not have been created.
    33 DELETE FROM {{TABLE_PREFIX}}ranks WHERE rank_id = 4;
    33 DELETE FROM {{TABLE_PREFIX}}ranks WHERE rank_id = 4;
    34 INSERT INTO {{TABLE_PREFIX}}ranks(rank_id, rank_title, rank_style) VALUES
    34 INSERT INTO {{TABLE_PREFIX}}ranks(rank_id, rank_title, rank_style) VALUES
    35   (4, 'user_rank_guest', '');
    35   (4, 'user_rank_guest', '');
    36 
    36 
       
    37 -- Other rank-related columns
       
    38 ALTER TABLE {{TABLE_PREFIX}}groups ADD COLUMN group_rank int DEFAULT NULL;
       
    39 
       
    40 -- Disable JS effects column
       
    41 ALTER TABLE {{TABLE_PREFIX}}users_extra ADD COLUMN disable_js_fx smallint NOT NULL DEFAULT 0;
       
    42