equal
deleted
inserted
replaced
19 -- The "guest" rank |
19 -- The "guest" rank |
20 -- No frontend to this yet so ranks should not have been created. |
20 -- No frontend to this yet so ranks should not have been created. |
21 DELETE FROM {{TABLE_PREFIX}}ranks WHERE rank_id = 4; |
21 DELETE FROM {{TABLE_PREFIX}}ranks WHERE rank_id = 4; |
22 INSERT INTO {{TABLE_PREFIX}}ranks(rank_id, rank_title, rank_style) VALUES |
22 INSERT INTO {{TABLE_PREFIX}}ranks(rank_id, rank_title, rank_style) VALUES |
23 (4, 'user_rank_guest', ''); |
23 (4, 'user_rank_guest', ''); |
|
24 |
|
25 -- Other rank-related columns |
|
26 ALTER TABLE {{TABLE_PREFIX}}groups ADD COLUMN group_rank int(12) unsigned DEFAULT NULL; |
|
27 |
|
28 -- Disable JS effects column |
|
29 ALTER TABLE {{TABLE_PREFIX}}users_extra ADD COLUMN disable_js_fx tinyint(1) NOT NULL DEFAULT 0; |