Upgrade fixes
[lhc/web/wiklou.git] / maintenance / archives / patch-userlevels-defaultgroups.sql
index 1b4eca1..0bd2a06 100644 (file)
@@ -3,8 +3,11 @@
 -- Should probably be inserted when someone create a new database
 --
 
-INSERT INTO `group` VALUES (1,'Anonymous','Anonymous users','read,edit,createaccount');
-INSERT INTO `group` VALUES (2,'Loggedin','General logged in users','read,edit,move,upload');
-INSERT INTO `group` VALUES (3,'Sysops','Operators of this site','read,edit,move,delete,undelete,protect,block,upload,asksql,rollback,patrol,editinterface');
-INSERT INTO `group` 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');
-
+INSERT INTO `group` (group_id,group_name,group_description,group_rights)
+       VALUES (1,'Anonymous','Anonymous users','read,edit,createaccount');
+INSERT INTO `group` (group_id,group_name,group_description,group_rights)
+       VALUES (2,'Loggedin','General logged in users','read,edit,move,upload');
+INSERT INTO `group` (group_id,group_name,group_description,group_rights)
+       VALUES (3,'Sysops','Operators of this site','read,edit,move,delete,undelete,protect,block,upload,asksql,rollback,patrol,editinterface');
+INSERT INTO `group` (group_id,group_name,group_description,group_rights)
+       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');