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/mssql_schema.sql | 13 +++++++------
 1 file changed, 7 insertions(+), 6 deletions(-)

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

diff --git a/phpBB/install/schemas/mssql_schema.sql b/phpBB/install/schemas/mssql_schema.sql
index 7caea395ec..3e58881427 100644
--- a/phpBB/install/schemas/mssql_schema.sql
+++ b/phpBB/install/schemas/mssql_schema.sql
@@ -236,15 +236,16 @@ GO
 */
 CREATE TABLE [phpbb_bookmarks] (
 	[topic_id] [int] DEFAULT (0) NOT NULL ,
-	[user_id] [int] DEFAULT (0) NOT NULL ,
-	[order_id] [int] DEFAULT (0) NOT NULL 
+	[user_id] [int] DEFAULT (0) NOT NULL 
 ) ON [PRIMARY]
 GO
 
-CREATE  INDEX [order_id] ON [phpbb_bookmarks]([order_id]) ON [PRIMARY]
-GO
-
-CREATE  INDEX [topic_user_id] ON [phpbb_bookmarks]([topic_id], [user_id]) ON [PRIMARY]
+ALTER TABLE [phpbb_bookmarks] WITH NOCHECK ADD 
+	CONSTRAINT [PK_phpbb_bookmarks] PRIMARY KEY  CLUSTERED 
+	(
+		[topic_id],
+		[user_id]
+	)  ON [PRIMARY] 
 GO
 
 
-- 
cgit v1.2.1

