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/develop/create_schema_files.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/develop/create_schema_files.php')
| -rw-r--r-- | phpBB/develop/create_schema_files.php | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/phpBB/develop/create_schema_files.php b/phpBB/develop/create_schema_files.php index a2f7463dd4..0483ae009d 100644 --- a/phpBB/develop/create_schema_files.php +++ b/phpBB/develop/create_schema_files.php @@ -1299,6 +1299,7 @@ function get_schema_struct() '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), @@ -1312,8 +1313,10 @@ function get_schema_struct() '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'), ), ); |