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/sqlite_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/sqlite_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/sqlite_schema.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/phpBB/install/schemas/sqlite_schema.sql b/phpBB/install/schemas/sqlite_schema.sql index d754219cdf..53fe3d978a 100644 --- a/phpBB/install/schemas/sqlite_schema.sql +++ b/phpBB/install/schemas/sqlite_schema.sql @@ -949,6 +949,7 @@ CREATE TABLE phpbb_users ( ); 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); |