install/schemas/postgresql_stage2.sql
changeset 638 854652a5886a
parent 621 68f8a9cc0a18
child 665 af7e8ec6aef7
equal deleted inserted replaced
637:77a25231aa8e 638:854652a5886a
   387   (2, '{{ADMIN_USER}}', '{{ADMIN_PASS}}', '{{ADMIN_EMAIL}}', '{{REAL_NAME}}', 9, 'oxygen', 'bleu', '', {{UNIX_TIME}}, 1, '{{IP_ADDRESS}}', 0, 0, 'png');
   387   (2, '{{ADMIN_USER}}', '{{ADMIN_PASS}}', '{{ADMIN_EMAIL}}', '{{REAL_NAME}}', 9, 'oxygen', 'bleu', '', {{UNIX_TIME}}, 1, '{{IP_ADDRESS}}', 0, 0, 'png');
   388   
   388   
   389 INSERT INTO {{TABLE_PREFIX}}users_extra(user_id) VALUES
   389 INSERT INTO {{TABLE_PREFIX}}users_extra(user_id) VALUES
   390   (2);
   390   (2);
   391   
   391   
   392 INSERT INTO {{TABLE_PREFIX}}ranks(rank_id, rank_title, rank_style) VALUES
   392 INSERT INTO {{TABLE_PREFIX}}ranks(rank_title, rank_style) VALUES
   393   (1, 'user_rank_member', ''),
   393   ('user_rank_member', ''),
   394   (2, 'user_rank_mod', 'font-weight: bold; color: #00AA00;'),
   394   ('user_rank_mod', 'font-weight: bold; color: #00AA00;'),
   395   (3, 'user_rank_admin', 'font-weight: bold; color: #AA0000;'),
   395   ('user_rank_admin', 'font-weight: bold; color: #AA0000;'),
   396   (4, 'user_rank_guest', '');
   396   ('user_rank_guest', '');
   397 
   397 
   398 INSERT INTO {{TABLE_PREFIX}}groups(group_id,group_name,group_type,system_group) VALUES(1, 'Everyone', 3, 1),
   398 INSERT INTO {{TABLE_PREFIX}}groups(group_id,group_name,group_type,system_group) VALUES(1, 'Everyone', 3, 1),
   399   (2,'Administrators',3,1),
   399   (2,'Administrators',3,1),
   400   (3,'Moderators',3,1);
   400   (3,'Moderators',3,1);
   401 
   401