diff options
| author | Andreas Fischer <bantu@phpbb.com> | 2009-09-04 15:44:10 +0000 |
|---|---|---|
| committer | Andreas Fischer <bantu@phpbb.com> | 2009-09-04 15:44:10 +0000 |
| commit | 0fe74ebceac75c559b8779f291ebb2df80309e92 (patch) | |
| tree | 87de48e60d2d0accbf40be029e0afd1f257a2c06 /phpBB/install/schemas/firebird_schema.sql | |
| parent | 31856352be0f29fd7423cfe87bdfd791b03fb938 (diff) | |
| download | forums-0fe74ebceac75c559b8779f291ebb2df80309e92.tar forums-0fe74ebceac75c559b8779f291ebb2df80309e92.tar.gz forums-0fe74ebceac75c559b8779f291ebb2df80309e92.tar.bz2 forums-0fe74ebceac75c559b8779f291ebb2df80309e92.tar.xz forums-0fe74ebceac75c559b8779f291ebb2df80309e92.zip | |
Add INDEX on user_regdate because this is the default ORDER BY in memberlist.php - thanks nickvergessen.
git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@10106 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install/schemas/firebird_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/firebird_schema.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/phpBB/install/schemas/firebird_schema.sql b/phpBB/install/schemas/firebird_schema.sql index f3defe9a54..91bd7263ce 100644 --- a/phpBB/install/schemas/firebird_schema.sql +++ b/phpBB/install/schemas/firebird_schema.sql @@ -1381,6 +1381,7 @@ CREATE TABLE phpbb_users ( ALTER TABLE phpbb_users ADD PRIMARY KEY (user_id);; CREATE INDEX phpbb_users_user_birthday ON phpbb_users(user_birthday);; +CREATE INDEX phpbb_users_user_regdate ON phpbb_users(user_regdate);; CREATE INDEX phpbb_users_user_email_hash ON phpbb_users(user_email_hash);; CREATE INDEX phpbb_users_user_type ON phpbb_users(user_type);; CREATE UNIQUE INDEX phpbb_users_username_clean ON phpbb_users(username_clean);; |