diff options
| author | Nathan Guse <nathaniel.guse@gmail.com> | 2012-12-08 14:12:25 -0600 |
|---|---|---|
| committer | Nathan Guse <nathaniel.guse@gmail.com> | 2012-12-08 14:12:25 -0600 |
| commit | 0d6c8f46ffa1206e9d8d71fd30ef04e52f7cb2a8 (patch) | |
| tree | 2a8e26649421aac826126d5cc2be49dcf8ba9d5d /phpBB/install/schemas/postgres_schema.sql | |
| parent | 2227ceab8bf0cccf95598f4e2a59cc7134adf7f0 (diff) | |
| download | forums-0d6c8f46ffa1206e9d8d71fd30ef04e52f7cb2a8.tar forums-0d6c8f46ffa1206e9d8d71fd30ef04e52f7cb2a8.tar.gz forums-0d6c8f46ffa1206e9d8d71fd30ef04e52f7cb2a8.tar.bz2 forums-0d6c8f46ffa1206e9d8d71fd30ef04e52f7cb2a8.tar.xz forums-0d6c8f46ffa1206e9d8d71fd30ef04e52f7cb2a8.zip | |
[ticket/11103] Update indexes on notifications/user notifications tables
PHPBB3-11103
Diffstat (limited to 'phpBB/install/schemas/postgres_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/postgres_schema.sql | 9 |
1 files changed, 2 insertions, 7 deletions
diff --git a/phpBB/install/schemas/postgres_schema.sql b/phpBB/install/schemas/postgres_schema.sql index 94926d0b7a..e43b64468d 100644 --- a/phpBB/install/schemas/postgres_schema.sql +++ b/phpBB/install/schemas/postgres_schema.sql @@ -614,13 +614,8 @@ CREATE TABLE phpbb_notifications ( PRIMARY KEY (notification_id) ); -CREATE INDEX phpbb_notifications_item_type ON phpbb_notifications (item_type); -CREATE INDEX phpbb_notifications_item_id ON phpbb_notifications (item_id); -CREATE INDEX phpbb_notifications_item_pid ON phpbb_notifications (item_parent_id); -CREATE INDEX phpbb_notifications_user_id ON phpbb_notifications (user_id); -CREATE INDEX phpbb_notifications_time ON phpbb_notifications (time); -CREATE INDEX phpbb_notifications_unread ON phpbb_notifications (unread); -CREATE INDEX phpbb_notifications_is_enabled ON phpbb_notifications (is_enabled); +CREATE INDEX phpbb_notifications_item_ident ON phpbb_notifications (item_type, item_id); +CREATE INDEX phpbb_notifications_user ON phpbb_notifications (user_id, unread); /* Table: 'phpbb_poll_options' |