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 `group` (group_id,group_name,group_description,group_rights)
   7         VALUES (1,'Anonymous','Anonymous users','read,edit,createaccount');
   8 INSERT INTO `group` (group_id,group_name,group_description,group_rights)
   9         VALUES (2,'Loggedin','General logged in users','read,edit,move,upload');
  10 INSERT INTO `group` (group_id,group_name,group_description,group_rights)
  11         VALUES (3,'Sysops','Operators of this site','read,edit,move,delete,undelete,protect,block,upload,asksql,rollback,patrol,editinterface,sysop');
  12 INSERT INTO `group` (group_id,group_name,group_description,group_rights)
  13         VALUES (4,'Bureaucrat','The bureaucrat group is able to make sysops for example. They have no other rights.','read,edit,move,delete,undelete,protect,block,userrights,createaccount,upload,asksql,rollback,patrol,editinterface,siteadmin,sysop');