diff options
Diffstat (limited to 'maintenance/archives/patch-userlevels.sql')
-rw-r--r-- | maintenance/archives/patch-userlevels.sql | 20 |
1 files changed, 3 insertions, 17 deletions
diff --git a/maintenance/archives/patch-userlevels.sql b/maintenance/archives/patch-userlevels.sql index 17ff3c5d..399d6cb2 100644 --- a/maintenance/archives/patch-userlevels.sql +++ b/maintenance/archives/patch-userlevels.sql @@ -1,22 +1,8 @@ --- Oct. 1st 2004 - Ashar Voultoiz --- Implement the new sitelevels --- --- This is under development to provide a showcase in HEAD :o) - --- Hold group name and description -CREATE TABLE /*$wgDBprefix*/groups ( - gr_id int(5) unsigned NOT NULL auto_increment, - gr_name varchar(50) NOT NULL default '', - gr_description varchar(255) NOT NULL default '', - gr_rights tinyblob, - PRIMARY KEY (gr_id) - -) /*$wgDBTableOptions*/; -- Relation table between user and groups CREATE TABLE /*$wgDBprefix*/user_groups ( - ug_user int(5) unsigned NOT NULL default '0', - ug_group int(5) unsigned NOT NULL default '0', + ug_user int unsigned NOT NULL default '0', + ug_group varbinary(16) NOT NULL default '0', PRIMARY KEY (ug_user,ug_group) - + KEY (ug_group) ) /*$wgDBTableOptions*/; |