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`
)