diff options
| author | Nathan Guse <nathaniel.guse@gmail.com> | 2012-12-15 19:18:26 -0600 |
|---|---|---|
| committer | Nathan Guse <nathaniel.guse@gmail.com> | 2012-12-15 19:18:26 -0600 |
| commit | f47e51d6dea9d59a36a6babf1f4033104c93a53d (patch) | |
| tree | 8987bce353d678fcf3bd1d57cef27fe4d2a2ce87 /phpBB/install/schemas/firebird_schema.sql | |
| parent | c6f138ff12f015543f92d07fb5c93c083a246bab (diff) | |
| download | forums-f47e51d6dea9d59a36a6babf1f4033104c93a53d.tar forums-f47e51d6dea9d59a36a6babf1f4033104c93a53d.tar.gz forums-f47e51d6dea9d59a36a6babf1f4033104c93a53d.tar.bz2 forums-f47e51d6dea9d59a36a6babf1f4033104c93a53d.tar.xz forums-f47e51d6dea9d59a36a6babf1f4033104c93a53d.zip | |
[ticket/11103] Move is_enabled to a separate table for better performance
PHPBB3-11103
Diffstat (limited to 'phpBB/install/schemas/firebird_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/firebird_schema.sql | 13 |
1 files changed, 9 insertions, 4 deletions
diff --git a/phpBB/install/schemas/firebird_schema.sql b/phpBB/install/schemas/firebird_schema.sql index d3058fb0dd..5f7d23e411 100644 --- a/phpBB/install/schemas/firebird_schema.sql +++ b/phpBB/install/schemas/firebird_schema.sql @@ -618,6 +618,15 @@ BEGIN END;; +# Table: 'phpbb_notification_types' +CREATE TABLE phpbb_notification_types ( + notification_type VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL, + notification_type_enabled INTEGER DEFAULT 1 NOT NULL +);; + +ALTER TABLE phpbb_notification_types ADD PRIMARY KEY (notification_type, notification_type_enabled);; + + # Table: 'phpbb_notifications' CREATE TABLE phpbb_notifications ( notification_id INTEGER NOT NULL, @@ -626,7 +635,6 @@ CREATE TABLE phpbb_notifications ( item_parent_id INTEGER DEFAULT 0 NOT NULL, user_id INTEGER DEFAULT 0 NOT NULL, unread INTEGER DEFAULT 1 NOT NULL, - is_enabled INTEGER DEFAULT 1 NOT NULL, time INTEGER DEFAULT 1 NOT NULL, data BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL );; @@ -1243,9 +1251,6 @@ CREATE TABLE phpbb_user_notifications ( ALTER TABLE phpbb_user_notifications ADD PRIMARY KEY (item_type, item_id, user_id, method);; -CREATE INDEX phpbb_user_notifications_it ON phpbb_user_notifications(item_type);; -CREATE INDEX phpbb_user_notifications_uid ON phpbb_user_notifications(user_id);; -CREATE INDEX phpbb_user_notifications_no ON phpbb_user_notifications(notify);; # Table: 'phpbb_user_group' CREATE TABLE phpbb_user_group ( |