diff options
| author | Nathaniel Guse <nathaniel.guse@gmail.com> | 2013-04-29 21:22:07 -0500 |
|---|---|---|
| committer | Nathaniel Guse <nathaniel.guse@gmail.com> | 2013-04-29 21:22:07 -0500 |
| commit | 33287a73609a99f33f3d0718fceaf72e39d5283e (patch) | |
| tree | c6906331d568a7dc3814f1c3def3e9a8ab408d2a /phpBB/install/schemas/mysql_41_schema.sql | |
| parent | 4c5e51e379f770d9bd3610e7235dafcb985494e1 (diff) | |
| download | forums-33287a73609a99f33f3d0718fceaf72e39d5283e.tar forums-33287a73609a99f33f3d0718fceaf72e39d5283e.tar.gz forums-33287a73609a99f33f3d0718fceaf72e39d5283e.tar.bz2 forums-33287a73609a99f33f3d0718fceaf72e39d5283e.tar.xz forums-33287a73609a99f33f3d0718fceaf72e39d5283e.zip | |
[ticket/11413] Undo editing the user_notifications table
item_type is not equivalent to notification_type_name, it can be a generic
string (typically used to be able to subscribe to multiple notification
types while only subscribing to one item
PHPBB3-11413
Diffstat (limited to 'phpBB/install/schemas/mysql_41_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/mysql_41_schema.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/phpBB/install/schemas/mysql_41_schema.sql b/phpBB/install/schemas/mysql_41_schema.sql index e5ab9ceafa..ff0f315f93 100644 --- a/phpBB/install/schemas/mysql_41_schema.sql +++ b/phpBB/install/schemas/mysql_41_schema.sql @@ -913,7 +913,7 @@ CREATE TABLE phpbb_topics_watch ( # Table: 'phpbb_user_notifications' CREATE TABLE phpbb_user_notifications ( - notification_type_id smallint(4) UNSIGNED DEFAULT '0' NOT NULL, + item_type varchar(255) DEFAULT '' NOT NULL, item_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, user_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, method varchar(255) DEFAULT '' NOT NULL, |