X-Git-Url: http://git.cyclocoop.org/?a=blobdiff_plain;f=maintenance%2Ftables.sql;h=80780b940afe8598e4c0d9e52f16cc081e07434a;hb=1aa60b1361bc809e9bb751f539374e672cb1376c;hp=2ffbacb74a6637ed3e09add269d2e3a1532db932;hpb=72e66de074fe8be9250320012ce4d9abd5850471;p=lhc%2Fweb%2Fwiklou.git

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)
+);