2 files changed, 8 insertions, 5 deletions
diff --git a/phpBB/install/schemas/mysql_basic.sql b/phpBB/install/schemas/mysql_basic.sql
index 8fa39e3055..c33599cc55 100644
--- a/phpBB/install/schemas/mysql_basic.sql
+++ b/phpBB/install/schemas/mysql_basic.sql
@@ -184,7 +184,7 @@ INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('u_sendpm', 1);
 INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('u_viewonline', 1);
 INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('u_viewprofile', 1);
 INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('u_chgavatar', 1);
-INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('u_chgcolor', 1);
+INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('u_chggrp', 1);
 INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('u_chgemail', 1);
 INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('u_chgname', 1);
 INSERT INTO phpbb_auth_options (auth_value, is_global) VALUES ('u_chgpasswd', 1);
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql
index 35f8a6d2bd..78c1fb4442 100644
--- a/phpBB/install/schemas/mysql_schema.sql
+++ b/phpBB/install/schemas/mysql_schema.sql
@@ -45,11 +45,14 @@ CREATE TABLE phpbb_attach_desc (
 # Table structure for table `phpbb_auth_dependencies`
 #
 CREATE TABLE phpbb_auth_dependencies (
-  auth_value varchar(20) NOT NULL default '',
+  dep_id tinyint(4) UNSIGNED NOT NULL auto_increment, 
+  dep_name varchar(50) NOT NULL DEFAULT '', 
+  auth_value text NOT NULL,
   auth_allow tinyint(1) NOT NULL default '2',
-  forum_id int(11) NOT NULL default '0',
-  auth_deps text NOT NULL default '',
-  PRIMARY KEY  (auth_value)
+  forum_id text NOT NULL,
+  auth_deps text NOT NULL, 
+  PRIMARY KEY (dep_id), 
+  KEY dep_name (dep_name)
 );