1 -- Oct. 1st 2004 - Ashar Voultoiz
2 -- Implement the new sitelevels
4 -- This is under development to provide a showcase in HEAD :o)
6 -- Hold group name and description
7 CREATE TABLE /*$wgDBprefix*/`
group`
(
8 group_id
int(5) unsigned
NOT NULL auto_increment
,
9 group_name
varchar(50) NOT NULL default '',
10 group_description
varchar(255) NOT NULL default '',
11 group_rights tinyblob
,
12 PRIMARY KEY (group_id
)
16 -- Relation table between user and groups
17 CREATE TABLE /*$wgDBprefix*/user_groups (
18 ug_user
int(5) unsigned
NOT NULL default '0',
19 ug_group
int(5) unsigned
NOT NULL default '0',
20 PRIMARY KEY (ug_user
,ug_group
)