summaryrefslogtreecommitdiff
path: root/database/database.mysql
diff options
context:
space:
mode:
authorDries Buytaert <dries@buytaert.net>2003-05-18 16:43:56 +0000
committerDries Buytaert <dries@buytaert.net>2003-05-18 16:43:56 +0000
commit7e8aa5268b9131946156a43ddfee3d1499932836 (patch)
treedad9bd4ff4fab9bb4ea97965fac342ba7e0e78d2 /database/database.mysql
parenta1c0d416814bff336a83626c8c8c32331b82f00f (diff)
downloadbrdo-7e8aa5268b9131946156a43ddfee3d1499932836.tar.gz
brdo-7e8aa5268b9131946156a43ddfee3d1499932836.tar.bz2
- 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.
Diffstat (limited to 'database/database.mysql')
-rw-r--r--database/database.mysql3
1 files changed, 2 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;
--