From dbbf0e913a0f3939a3e649993efd610c98d14bfb Mon Sep 17 00:00:00 2001 From: Brion Vibber Date: Sat, 2 Oct 2004 22:26:00 +0000 Subject: [PATCH] Add the experimental user_groups, group tables so that installation works --- maintenance/tables.sql | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) diff --git a/maintenance/tables.sql b/maintenance/tables.sql index 2ffbacb74a..80780b940a 100644 --- a/maintenance/tables.sql +++ b/maintenance/tables.sql @@ -337,3 +337,22 @@ CREATE TABLE logging ( KEY user_time (log_user, log_timestamp), KEY page_time (log_namespace, log_title, log_timestamp) ); + + + + + +-- Hold group name and description +CREATE TABLE `group` ( + group_id int(5) unsigned NOT NULL auto_increment, + group_name varchar(50) NOT NULL default '', + group_description varchar(255) NOT NULL default '', + PRIMARY KEY (group_id) +); + +-- Relation table between user and groups +CREATE TABLE user_groups ( + user_id int(5) unsigned NOT NULL default '0', + group_id int(5) unsigned NOT NULL default '0', + PRIMARY KEY (user_id,group_id) +); -- 2.20.1