aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/install/schemas
diff options
context:
space:
mode:
authorPaul S. Owen <psotfx@users.sourceforge.net>2002-08-17 23:23:20 +0000
committerPaul S. Owen <psotfx@users.sourceforge.net>2002-08-17 23:23:20 +0000
commit27838c6f027eed4f60a55a745a73c55975c7506f (patch)
tree4e862b480e01942f4758d5b675f335e40d0ed93f /phpBB/install/schemas
parent4a5f17c1318ca2a5eab5ca44495a7e77caca7715 (diff)
downloadforums-27838c6f027eed4f60a55a745a73c55975c7506f.tar
forums-27838c6f027eed4f60a55a745a73c55975c7506f.tar.gz
forums-27838c6f027eed4f60a55a745a73c55975c7506f.tar.bz2
forums-27838c6f027eed4f60a55a745a73c55975c7506f.tar.xz
forums-27838c6f027eed4f60a55a745a73c55975c7506f.zip
updated schema for update_script changes ...
git-svn-id: file:///svn/phpbb/trunk@2874 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install/schemas')
-rw-r--r--phpBB/install/schemas/mysql_schema.sql3
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)
);