Fixing multiple-inclusion problems

[lhc/web/wiklou.git] / maintenance / tables.sql

diff --git a/maintenance/tables.sql b/maintenance/tables.sql
index 3cba408..80780b9 100644 (file)
--- a/maintenance/tables.sql
+++ b/maintenance/tables.sql
@@ -13,6 +13,7 @@ CREATE TABLE user (
   user_email tinytext NOT NULL default '',
   user_options blob NOT NULL default '',
   user_touched char(14) binary NOT NULL default '',
+  user_token char(32) binary NOT NULL default '',
   PRIMARY KEY user_id (user_id),
   INDEX user_name (user_name(10))
 );
@@ -336,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)
+);