From 5de26540b4f0348719ec93e760ed987f92a60075 Mon Sep 17 00:00:00 2001 From: Meik Sievertsen Date: Mon, 7 May 2007 13:19:59 +0000 Subject: fixing some bugs changed the way we are handling bookmarks. No order_id required, really! Order by last post time as suggested by BartVB. git-svn-id: file:///svn/phpbb/trunk@7497 89ea8834-ac86-4346-8a33-228a782c2dd0 --- phpBB/install/database_update.php | 15 ++++++++++++++- 1 file changed, 14 insertions(+), 1 deletion(-) (limited to 'phpBB/install/database_update.php') diff --git a/phpBB/install/database_update.php b/phpBB/install/database_update.php index 395fcc4918..79c7145797 100644 --- a/phpBB/install/database_update.php +++ b/phpBB/install/database_update.php @@ -336,6 +336,10 @@ $database_update_info = array( STYLES_IMAGESET_TABLE => array( 'imgset_nm', ), + BOOKMARKS_TABLE => array( + 'order_id', + 'topic_user_id', + ), ), 'add_index' => array( SEARCH_WORDLIST_TABLE => array( @@ -363,7 +367,7 @@ $database_update_info = array( 'username_clean' => array('username_clean'), ), ), - // Add the following columns + // Drop the following columns 'drop_columns' => array( STYLES_IMAGESET_TABLE => array( 'site_logo', @@ -461,6 +465,15 @@ $database_update_info = array( 'user_icon9', 'user_icon10' ), + BOOKMARKS_TABLE => array( + 'order_id', + ), + ), + // Adding primary key + 'add_primary_keys' => array( + BOOKMARKS_TABLE => array( + 'topic_id', 'user_id', + ), ), ), ); -- cgit v1.2.1