diff options
| author | Nathan Guse <nathaniel.guse@gmail.com> | 2012-09-14 15:59:13 -0500 |
|---|---|---|
| committer | Nathan Guse <nathaniel.guse@gmail.com> | 2012-09-14 15:59:13 -0500 |
| commit | fb0ed78c8fffe95d40e47c8dd27d44973eba88ae (patch) | |
| tree | 663a972c5eb324d14855a4a51579d6aaf154c0ab /phpBB/install/database_update.php | |
| parent | 44aa773ce07d81d4585f3a24a728f9b445c4c098 (diff) | |
| download | forums-fb0ed78c8fffe95d40e47c8dd27d44973eba88ae.tar forums-fb0ed78c8fffe95d40e47c8dd27d44973eba88ae.tar.gz forums-fb0ed78c8fffe95d40e47c8dd27d44973eba88ae.tar.bz2 forums-fb0ed78c8fffe95d40e47c8dd27d44973eba88ae.tar.xz forums-fb0ed78c8fffe95d40e47c8dd27d44973eba88ae.zip | |
[ticket/11103] Store the item's parent id for marking things read
Mark topics/posts read from the markread() function.
Identify unread items by a grey background in the header (for now)
PHPBB3-11103
Diffstat (limited to 'phpBB/install/database_update.php')
| -rw-r--r-- | phpBB/install/database_update.php | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/phpBB/install/database_update.php b/phpBB/install/database_update.php index c3c2da4451..a79c04f8df 100644 --- a/phpBB/install/database_update.php +++ b/phpBB/install/database_update.php @@ -1109,6 +1109,7 @@ function database_update_info() 'COLUMNS' => array( 'item_type' => array('VCHAR:25', ''), 'item_id' => array('UINT', 0), + 'item_parent_id' => array('UINT', 0), 'user_id' => array('UINT', 0), 'unread' => array('BOOL', 1), 'time' => array('TIMESTAMP', 1), @@ -1122,8 +1123,10 @@ function database_update_info() 'KEYS' => array( 'item_type' => array('INDEX', 'item_type'), 'item_id' => array('INDEX', 'item_id'), + 'item_pid' => array('INDEX', 'item_parent_id'), 'user_id' => array('INDEX', 'user_id'), 'time' => array('INDEX', 'time'), + 'unread' => array('INDEX', 'unread'), ), ), USER_NOTIFICATIONS_TABLE => array( |