diff options
author | Nathan Guse <nathaniel.guse@gmail.com> | 2012-10-13 23:24:30 -0500 |
---|---|---|
committer | Nathan Guse <nathaniel.guse@gmail.com> | 2012-10-13 23:24:30 -0500 |
commit | 94ffbb4050b2985ee62be0ecc0c6a244532e43ca (patch) | |
tree | b6682a9080b6cf5c35cee14b10d2f4a42085fe31 /phpBB/install/schemas/mssql_schema.sql | |
parent | cb937841269017d13058208378e4c9ad79718c6e (diff) | |
download | forums-94ffbb4050b2985ee62be0ecc0c6a244532e43ca.tar forums-94ffbb4050b2985ee62be0ecc0c6a244532e43ca.tar.gz forums-94ffbb4050b2985ee62be0ecc0c6a244532e43ca.tar.bz2 forums-94ffbb4050b2985ee62be0ecc0c6a244532e43ca.tar.xz forums-94ffbb4050b2985ee62be0ecc0c6a244532e43ca.zip |
[ticket/11103] Add is_disabled column to notifications table
EXTENSION AUTHORS TAKE NOTE! This is to prevent errors with notifications
from extensions!
Set is_disabled to 1 for all your notifications when your extension is
disabled so they are ignored and do not cause errors.
When your extension is enabled again, set is_disabled to 0 and your
notifications will be working again.
PHPBB3-11103
Diffstat (limited to 'phpBB/install/schemas/mssql_schema.sql')
-rw-r--r-- | phpBB/install/schemas/mssql_schema.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/phpBB/install/schemas/mssql_schema.sql b/phpBB/install/schemas/mssql_schema.sql index d056e4ceb5..5a397743c4 100644 --- a/phpBB/install/schemas/mssql_schema.sql +++ b/phpBB/install/schemas/mssql_schema.sql @@ -761,6 +761,7 @@ 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_disabled] [int] DEFAULT (0) NOT NULL , [time] [int] DEFAULT (1) NOT NULL , [data] [varchar] (4000) DEFAULT ('') NOT NULL ) ON [PRIMARY] @@ -791,6 +792,9 @@ GO CREATE INDEX [unread] ON [phpbb_notifications]([unread]) ON [PRIMARY] GO +CREATE INDEX [is_disabled] ON [phpbb_notifications]([is_disabled]) ON [PRIMARY] +GO + /* Table: 'phpbb_poll_options' |