install/schemas/postgresql_stage2.sql
changeset 1151 8f0cbce6d5f3
parent 1081 745200a9cc2a
child 1159 a1cca4472a58
equal deleted inserted replaced
1150:eb4a10b9b7aa 1151:8f0cbce6d5f3
   382 INSERT INTO {{TABLE_PREFIX}}ranks(rank_id, rank_title, rank_style) VALUES
   382 INSERT INTO {{TABLE_PREFIX}}ranks(rank_id, rank_title, rank_style) VALUES
   383   (1, 'user_rank_member', ''),
   383   (1, 'user_rank_member', ''),
   384   (2, 'user_rank_mod', 'font-weight: bold; color: #00AA00;'),
   384   (2, 'user_rank_mod', 'font-weight: bold; color: #00AA00;'),
   385   (3, 'user_rank_admin', 'font-weight: bold; color: #AA0000;'),
   385   (3, 'user_rank_admin', 'font-weight: bold; color: #AA0000;'),
   386   (4, 'user_rank_guest', '');
   386   (4, 'user_rank_guest', '');
       
   387   
       
   388 -- For some reason this is required, it came up in my QA testing on a2hosting
       
   389 SELECT NEXTVAL('{{TABLE_PREFIX}}ranks_rank_id_seq'::regclass);
   387 
   390 
   388 INSERT INTO {{TABLE_PREFIX}}groups(group_id,group_name,group_type,system_group) VALUES(1, 'Everyone', 3, 1),
   391 INSERT INTO {{TABLE_PREFIX}}groups(group_id,group_name,group_type,system_group) VALUES(1, 'Everyone', 3, 1),
   389   (2,'Administrators',3,1),
   392   (2,'Administrators',3,1),
   390   (3,'Moderators',3,1);
   393   (3,'Moderators',3,1);
   391 
   394