Note recent PG changes.
[mediawiki.git] / maintenance / archives / patch-userlevels-defaultgroups.sql
blob065653da945022d017b83efdf2aab6c486863d83
1 --
2 -- Provide default groups
3 -- Should probably be inserted when someone create a new database
4 --
6 INSERT INTO /*$wgDBprefix*/groups (gr_id,gr_name,gr_description,gr_rights)
7         VALUES (
8                 1,':group-anon-name',':group-anon-desc',
9                 'read,edit,createaccount'
10         );
11 INSERT INTO /*$wgDBprefix*/groups (gr_id,gr_name,gr_description,gr_rights)
12         VALUES (
13                 2,':group-loggedin-name',':group-loggedin-desc',
14                 'read,edit,move,upload,validate,createaccount'
15         );
16 INSERT INTO /*$wgDBprefix*/groups (gr_id,gr_name,gr_description,gr_rights)
17         VALUES (
18                 3,':group-admin-name',':group-admin-desc',
19                 'read,edit,move,upload,validate,createaccount,delete,undelete,protect,block,upload,asksql,rollback,patrol,editinterface,import'
20         );
21 INSERT INTO /*$wgDBprefix*/groups (gr_id,gr_name,gr_description,gr_rights)
22         VALUES (
23                 4,':group-bureaucrat-name',':group-bureaucrat-desc',
24                 'read,edit,move,upload,validate,createaccount,delete,undelete,protect,block,upload,asksql,rollback,patrol,editinterface,import,makesysop'
25         );
26 INSERT INTO /*$wgDBprefix*/groups (gr_id,gr_name,gr_description,gr_rights)
27         VALUES (
28                 5,':group-steward-name',':group-steward-desc',
29                 'read,edit,move,upload,validate,createaccount,delete,undelete,protect,block,upload,asksql,rollback,patrol,editinterface,import,makesysop,userrights,grouprights,siteadmin'
30         );