diff options
author | Dries Buytaert <dries@buytaert.net> | 2003-05-18 16:43:56 +0000 |
---|---|---|
committer | Dries Buytaert <dries@buytaert.net> | 2003-05-18 16:43:56 +0000 |
commit | 7e8aa5268b9131946156a43ddfee3d1499932836 (patch) | |
tree | dad9bd4ff4fab9bb4ea97965fac342ba7e0e78d2 /database/database.pgsql | |
parent | a1c0d416814bff336a83626c8c8c32331b82f00f (diff) | |
download | brdo-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.pgsql | 1 |
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 |