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/mssql_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/mssql_schema.sql')
-rw-r--r-- | phpBB/install/schemas/mssql_schema.sql | 28 |
1 files changed, 18 insertions, 10 deletions
diff --git a/phpBB/install/schemas/mssql_schema.sql b/phpBB/install/schemas/mssql_schema.sql index 377ff92620..15529cde38 100644 --- a/phpBB/install/schemas/mssql_schema.sql +++ b/phpBB/install/schemas/mssql_schema.sql @@ -752,6 +752,24 @@ GO /* + Table: 'phpbb_notification_types' +*/ +CREATE TABLE [phpbb_notification_types] ( + [notification_type] [varchar] (255) DEFAULT ('') NOT NULL , + [notification_type_enabled] [int] DEFAULT (1) NOT NULL +) ON [PRIMARY] +GO + +ALTER TABLE [phpbb_notification_types] WITH NOCHECK ADD + CONSTRAINT [PK_phpbb_notification_types] PRIMARY KEY CLUSTERED + ( + [notification_type], + [notification_type_enabled] + ) ON [PRIMARY] +GO + + +/* Table: 'phpbb_notifications' */ CREATE TABLE [phpbb_notifications] ( @@ -761,7 +779,6 @@ CREATE TABLE [phpbb_notifications] ( [item_parent_id] [int] DEFAULT (0) NOT NULL , [user_id] [int] DEFAULT (0) NOT NULL , [unread] [int] DEFAULT (1) NOT NULL , - [is_enabled] [int] DEFAULT (1) NOT NULL , [time] [int] DEFAULT (1) NOT NULL , [data] [varchar] (4000) DEFAULT ('') NOT NULL ) ON [PRIMARY] @@ -1528,15 +1545,6 @@ ALTER TABLE [phpbb_user_notifications] WITH NOCHECK ADD ) ON [PRIMARY] GO -CREATE INDEX [it] ON [phpbb_user_notifications]([item_type]) ON [PRIMARY] -GO - -CREATE INDEX [uid] ON [phpbb_user_notifications]([user_id]) ON [PRIMARY] -GO - -CREATE INDEX [no] ON [phpbb_user_notifications]([notify]) ON [PRIMARY] -GO - /* Table: 'phpbb_user_group' |