11 -- User title

    12 ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_title varchar(64) DEFAULT NULL;

    13 ALTER TABLE {{TABLE_PREFIX}}users MODIFY COLUMN user_rank int(12) unsigned DEFAULT NULL;

    14 ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_group mediumint(5) NOT NULL DEFAULT 1;

    15 UPDATE {{TABLE_PREFIX}}users SET user_rank = NULL;

    16 

    17 -- The "guest" rank

    18 -- No frontend to this yet so ranks should not have been created.

    19 DELETE FROM {{TABLE_PREFIX}}ranks WHERE rank_id = 4;

    20 INSERT INTO {{TABLE_PREFIX}}ranks(rank_id, rank_title, rank_style) VALUES

    21   (4, 'user_rank_guest', '');