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 | |
| 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')
| -rw-r--r-- | database/database.mysql | 3 | ||||
| -rw-r--r-- | database/database.pgsql | 1 |
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 |