From 5de26540b4f0348719ec93e760ed987f92a60075 Mon Sep 17 00:00:00 2001
From: Meik Sievertsen <acydburn@phpbb.com>
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/schemas/firebird_schema.sql | 7 +++----
 1 file changed, 3 insertions(+), 4 deletions(-)

(limited to 'phpBB/install/schemas/firebird_schema.sql')

diff --git a/phpBB/install/schemas/firebird_schema.sql b/phpBB/install/schemas/firebird_schema.sql
index 50a59d9c98..f815449d19 100644
--- a/phpBB/install/schemas/firebird_schema.sql
+++ b/phpBB/install/schemas/firebird_schema.sql
@@ -179,12 +179,11 @@ CREATE INDEX phpbb_bbcodes_display_on_post ON phpbb_bbcodes(display_on_posting);
 # Table: 'phpbb_bookmarks'
 CREATE TABLE phpbb_bookmarks (
 	topic_id INTEGER DEFAULT 0 NOT NULL,
-	user_id INTEGER DEFAULT 0 NOT NULL,
-	order_id INTEGER DEFAULT 0 NOT NULL
+	user_id INTEGER DEFAULT 0 NOT NULL
 );;
 
-CREATE INDEX phpbb_bookmarks_order_id ON phpbb_bookmarks(order_id);;
-CREATE INDEX phpbb_bookmarks_topic_user_id ON phpbb_bookmarks(topic_id, user_id);;
+ALTER TABLE phpbb_bookmarks ADD PRIMARY KEY (topic_id, user_id);;
+
 
 # Table: 'phpbb_bots'
 CREATE TABLE phpbb_bots (
-- 
cgit v1.2.1

