From 7e8aa5268b9131946156a43ddfee3d1499932836 Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Sun, 18 May 2003 16:43:56 +0000 Subject: - Fixed bug in book_prev(). Patch by Andy Colson. - Book optimizations: updated to use inner joins. Patch by Andy Colson. This should address bug #1373. TODO: add index to MSSQL database scheme. --- database/database.mysql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'database/database.mysql') diff --git a/database/database.mysql b/database/database.mysql index 6eae606ec..d3c133e21 100644 --- a/database/database.mysql +++ b/database/database.mysql @@ -66,7 +66,8 @@ CREATE TABLE book ( format tinyint(2) default '0', log text, PRIMARY KEY (nid), - KEY nid (nid) + KEY nid (nid), + KEY parent (parent) ) TYPE=MyISAM; -- -- cgit v1.2.3