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 | |
| 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')
| -rw-r--r-- | phpBB/install/database_update.php | 3 | ||||
| -rw-r--r-- | phpBB/install/schemas/firebird_schema.sql | 1 | ||||
| -rw-r--r-- | phpBB/install/schemas/mssql_schema.sql | 3 | ||||
| -rw-r--r-- | phpBB/install/schemas/mysql_40_schema.sql | 1 | ||||
| -rw-r--r-- | phpBB/install/schemas/mysql_41_schema.sql | 1 | ||||
| -rw-r--r-- | phpBB/install/schemas/oracle_schema.sql | 2 | ||||
| -rw-r--r-- | phpBB/install/schemas/postgres_schema.sql | 1 | ||||
| -rw-r--r-- | phpBB/install/schemas/sqlite_schema.sql | 1 |
8 files changed, 13 insertions, 0 deletions
diff --git a/phpBB/install/database_update.php b/phpBB/install/database_update.php index ab22c803ee..54586c5650 100644 --- a/phpBB/install/database_update.php +++ b/phpBB/install/database_update.php @@ -877,6 +877,9 @@ function database_update_info() POSTS_TABLE => array( 'post_username' => array('post_username'), ), + USERS_TABLE => array( + 'user_regdate' => array('user_regdate'), + ), ), ), ); 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);; diff --git a/phpBB/install/schemas/mssql_schema.sql b/phpBB/install/schemas/mssql_schema.sql index ac7c0928cd..c2af273edd 100644 --- a/phpBB/install/schemas/mssql_schema.sql +++ b/phpBB/install/schemas/mssql_schema.sql @@ -1666,6 +1666,9 @@ GO CREATE INDEX [user_birthday] ON [phpbb_users]([user_birthday]) ON [PRIMARY] GO +CREATE INDEX [user_regdate] ON [phpbb_users]([user_regdate]) ON [PRIMARY] +GO + CREATE INDEX [user_email_hash] ON [phpbb_users]([user_email_hash]) ON [PRIMARY] GO diff --git a/phpBB/install/schemas/mysql_40_schema.sql b/phpBB/install/schemas/mysql_40_schema.sql index 4fcead787b..ff5653a812 100644 --- a/phpBB/install/schemas/mysql_40_schema.sql +++ b/phpBB/install/schemas/mysql_40_schema.sql @@ -978,6 +978,7 @@ CREATE TABLE phpbb_users ( user_reminded_time int(11) UNSIGNED DEFAULT '0' NOT NULL, PRIMARY KEY (user_id), KEY user_birthday (user_birthday), + KEY user_regdate (user_regdate), KEY user_email_hash (user_email_hash), KEY user_type (user_type), UNIQUE username_clean (username_clean(255)) diff --git a/phpBB/install/schemas/mysql_41_schema.sql b/phpBB/install/schemas/mysql_41_schema.sql index 34adf5674e..ceb13aa102 100644 --- a/phpBB/install/schemas/mysql_41_schema.sql +++ b/phpBB/install/schemas/mysql_41_schema.sql @@ -978,6 +978,7 @@ CREATE TABLE phpbb_users ( user_reminded_time int(11) UNSIGNED DEFAULT '0' NOT NULL, PRIMARY KEY (user_id), KEY user_birthday (user_birthday), + KEY user_regdate (user_regdate), KEY user_email_hash (user_email_hash), KEY user_type (user_type), UNIQUE username_clean (username_clean) diff --git a/phpBB/install/schemas/oracle_schema.sql b/phpBB/install/schemas/oracle_schema.sql index 15692ea984..6855e6472f 100644 --- a/phpBB/install/schemas/oracle_schema.sql +++ b/phpBB/install/schemas/oracle_schema.sql @@ -1804,6 +1804,8 @@ 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) diff --git a/phpBB/install/schemas/postgres_schema.sql b/phpBB/install/schemas/postgres_schema.sql index 46e77e64b4..1c0acc4bd4 100644 --- a/phpBB/install/schemas/postgres_schema.sql +++ b/phpBB/install/schemas/postgres_schema.sql @@ -1243,6 +1243,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); 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); |