summaryrefslogtreecommitdiff
path: root/maintenance/archives/patch-rename-group.sql
blob: 026b60bdc4de6c7c4c1d80e762133f296fade06a (plain)
1
2
3
4
5
6
7
8
9
10
-- Rename groups table to groups, which is not a keyword
-- It was called group in a few alpha versions

RENAME TABLE /*$wgDBprefix*/`group` TO /*$wgDBprefix*/groups;
ALTER TABLE /*$wgDBprefix*/groups 
	CHANGE group_id gr_id int(5) unsigned NOT NULL auto_increment,
	CHANGE group_name gr_name varchar(50) NOT NULL default '',
	CHANGE group_description gr_description varchar(255) NOT NULL default '',
	CHANGE group_rights gr_rights tinyblob;