Renaming columns:

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

diff --git a/maintenance/tables.sql b/maintenance/tables.sql
index a2c444e..216b0d5 100644 (file)
--- a/maintenance/tables.sql
+++ b/maintenance/tables.sql
@@ -20,7 +20,7 @@ CREATE TABLE user (
 
 -- TODO: de-blob this; it should be a property table
 CREATE TABLE user_rights (
-  ur_uid int(5) unsigned NOT NULL,
+  ur_user int(5) unsigned NOT NULL,
   ur_rights tinyblob NOT NULL default '',
   UNIQUE KEY user_id (user_id)
 );
@@ -352,7 +352,7 @@ CREATE TABLE `group` (
 
 -- Relation table between user and groups
 CREATE TABLE user_groups (
-       ug_uid int(5) unsigned NOT NULL default '0',
-       ug_gid int(5) unsigned NOT NULL default '0',
-       PRIMARY KEY  (ug_uid,ug_gid)
+       ug_user int(5) unsigned NOT NULL default '0',
+       ug_group int(5) unsigned NOT NULL default '0',
+       PRIMARY KEY  (ug_user,ug_group)
 );