c4edb8eadacb7ea969b8337ba56f28e6448cd38f
[lhc/web/wiklou.git] / maintenance / archives / patch-userlevels-defaultgroups.sql
1 --
2 -- Provide default groups
3 -- Should probably be inserted when someone create a new database
4 --
5
6 INSERT INTO /*$wgDBprefix*/`group` (group_id,group_name,group_description,group_rights)
7 VALUES (
8 1,'Anonymous','Anonymous users',
9 'read,edit,createaccount'
10 );
11 INSERT INTO /*$wgDBprefix*/`group` (group_id,group_name,group_description,group_rights)
12 VALUES (
13 2,'Logged in','General logged in users',
14 'read,edit,move,upload,validate,createaccount'
15 );
16 INSERT INTO /*$wgDBprefix*/`group` (group_id,group_name,group_description,group_rights)
17 VALUES (
18 3,'Administrator','Trusted users able to block users and delete articles',
19 'read,edit,move,upload,validate,createaccount,delete,undelete,protect,block,upload,asksql,rollback,patrol,editinterface,import,sysop'
20 );
21 INSERT INTO /*$wgDBprefix*/`group` (group_id,group_name,group_description,group_rights)
22 VALUES (
23 4,'Bureaucrat','The bureaucrat group is able to make sysops. They have no other rights.',
24 'read,edit,move,upload,validate,createaccount,delete,undelete,protect,block,upload,asksql,rollback,patrol,editinterface,import,sysop,makesysop'
25 );
26 INSERT INTO /*$wgDBprefix*/`group` (group_id,group_name,group_description,group_rights)
27 VALUES (
28 5,'Steward','Full access',
29 'read,edit,move,upload,validate,createaccount,delete,undelete,protect,block,upload,asksql,rollback,patrol,editinterface,import,sysop,makesysop,userrights,grouprights,siteadmin'
30 );