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
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 PRIMARY KEY (group_id)
14 -- Relation table between user and groups
15 CREATE TABLE user_groups (
16 user_id int(5) unsigned NOT NULL default '0',
17 group_id int(5) unsigned NOT NULL default '0',
18 PRIMARY KEY (user_id,group_id)