2 files changed, 3 insertions, 1 deletions
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;
 
 --
diff --git a/database/database.pgsql b/database/database.pgsql
index 08d277289..c2d2f0969 100644
--- a/database/database.pgsql
+++ b/database/database.pgsql
@@ -66,6 +66,7 @@ CREATE TABLE book (
   PRIMARY KEY (nid)
 );
 CREATE INDEX book_nid_idx ON book(nid);
+CREATE INDEX book_parent ON book(parent);
 
 --
 -- Table structure for boxes