equal
deleted
inserted
replaced
31 -- The "guest" rank |
31 -- The "guest" rank |
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 |
|
37 -- For some reason this is required, it came up in my QA testing on a2hosting |
|
38 SELECT NEXTVAL('{{TABLE_PREFIX}}ranks_rank_id_seq'::regclass); |
36 |
39 |
37 -- Other rank-related columns |
40 -- Other rank-related columns |
38 ALTER TABLE {{TABLE_PREFIX}}groups ADD COLUMN group_rank int DEFAULT NULL; |
41 ALTER TABLE {{TABLE_PREFIX}}groups ADD COLUMN group_rank int DEFAULT NULL; |
39 |
42 |
40 -- Disable JS effects column |
43 -- Disable JS effects column |