PG hack for temporary tables breaks MySQL 4.1. :P special-case it

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

diff --git a/maintenance/tables.sql b/maintenance/tables.sql
index 80780b9..db2c070 100644 (file)
--- a/maintenance/tables.sql
+++ b/maintenance/tables.sql
@@ -20,9 +20,9 @@ CREATE TABLE user (
 
 -- TODO: de-blob this; it should be a property table
 CREATE TABLE user_rights (
-  user_id int(5) unsigned NOT NULL,
-  user_rights tinyblob NOT NULL default '',
-  UNIQUE KEY user_id (user_id)
+  ur_user int(5) unsigned NOT NULL,
+  ur_rights tinyblob NOT NULL default '',
+  UNIQUE KEY ur_user (ur_user)
 );
 
 CREATE TABLE user_newtalk (
@@ -347,12 +347,13 @@ 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 '',
+  group_rights tinyblob,
   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)
+       ug_user int(5) unsigned NOT NULL default '0',
+       ug_group int(5) unsigned NOT NULL default '0',
+       PRIMARY KEY  (ug_user,ug_group)
 );