diff options
| author | Andreas Fischer <bantu@phpbb.com> | 2011-06-13 02:15:35 +0200 |
|---|---|---|
| committer | Andreas Fischer <bantu@phpbb.com> | 2011-06-13 02:15:35 +0200 |
| commit | 7cc45ee0d5606ddd9143a8a80b6974d027916a89 (patch) | |
| tree | 4fedc3e0f417f78cedc39a621e6e71023658cc03 /phpBB/install/schemas/postgres_schema.sql | |
| parent | 25bd58d2f9755c9c434c6163af1368004fabb2c9 (diff) | |
| parent | 47edadfc9e1b4788975910ad474cc2b806024ce3 (diff) | |
| download | forums-7cc45ee0d5606ddd9143a8a80b6974d027916a89.tar forums-7cc45ee0d5606ddd9143a8a80b6974d027916a89.tar.gz forums-7cc45ee0d5606ddd9143a8a80b6974d027916a89.tar.bz2 forums-7cc45ee0d5606ddd9143a8a80b6974d027916a89.tar.xz forums-7cc45ee0d5606ddd9143a8a80b6974d027916a89.zip | |
Merge remote-tracking branch 'naderman/ticket/10213' into develop-olympus
* naderman/ticket/10213:
[ticket/10213] Update install schema with shorter index names.
Diffstat (limited to 'phpBB/install/schemas/postgres_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/postgres_schema.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/phpBB/install/schemas/postgres_schema.sql b/phpBB/install/schemas/postgres_schema.sql index c4c2307c3a..359ec325d7 100644 --- a/phpBB/install/schemas/postgres_schema.sql +++ b/phpBB/install/schemas/postgres_schema.sql @@ -541,9 +541,9 @@ CREATE TABLE phpbb_login_attempts ( PRIMARY KEY (attempt_id) ); -CREATE INDEX phpbb_login_attempts_attempt_ip ON phpbb_login_attempts (attempt_ip, attempt_time); -CREATE INDEX phpbb_login_attempts_attempt_forwarded_for ON phpbb_login_attempts (attempt_forwarded_for, attempt_time); -CREATE INDEX phpbb_login_attempts_attempt_time ON phpbb_login_attempts (attempt_time); +CREATE INDEX phpbb_login_attempts_att_ip ON phpbb_login_attempts (attempt_ip, attempt_time); +CREATE INDEX phpbb_login_attempts_att_for ON phpbb_login_attempts (attempt_forwarded_for, attempt_time); +CREATE INDEX phpbb_login_attempts_att_time ON phpbb_login_attempts (attempt_time); CREATE INDEX phpbb_login_attempts_user_id ON phpbb_login_attempts (user_id); /* |