1 files changed, 7 insertions, 4 deletions
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)
 );