summaryrefslogtreecommitdiff
path: root/database/database.pgsql
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.pgsql
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.pgsql')
-rw-r--r--database/database.pgsql1
1 files changed, 1 insertions, 0 deletions
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