diff options
| -rw-r--r-- | phpBB/install/schemas/mysql_schema.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql index 337e8d5d24..446923550f 100644 --- a/phpBB/install/schemas/mysql_schema.sql +++ b/phpBB/install/schemas/mysql_schema.sql @@ -40,7 +40,8 @@ CREATE TABLE phpbb_auth_groups ( CREATE TABLE phpbb_auth_options ( auth_option_id tinyint(4) NOT NULL auto_increment, auth_value char(20) NOT NULL, - PRIMARY KEY (auth_value, auth_option_id) + PRIMARY KEY (auth_option_id), + KEY auth_value (auth_value) ); |