diff options
| author | Dries Buytaert <dries@buytaert.net> | 2006-05-23 19:03:50 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2006-05-23 19:03:50 +0000 |
| commit | d7f3ace21404e9961fc8e0afc967772123fc43a7 (patch) | |
| tree | 29d19cdbf5ba715dad0b362f6b31688f4f4626b5 /database/database.pgsql | |
| parent | 8c8af42c6466259f5a199cd22672e23cbe30af88 (diff) | |
| download | brdo-d7f3ace21404e9961fc8e0afc967772123fc43a7.tar.gz brdo-d7f3ace21404e9961fc8e0afc967772123fc43a7.tar.bz2 | |
- Patch #62478 by Cvbge: fixed some database inconsistencies with PostgreSQL.
Diffstat (limited to 'database/database.pgsql')
| -rw-r--r-- | database/database.pgsql | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/database/database.pgsql b/database/database.pgsql index 4729a99eb..7d468f82b 100644 --- a/database/database.pgsql +++ b/database/database.pgsql @@ -419,13 +419,14 @@ CREATE TABLE node ( promote integer NOT NULL default '0', moderate integer NOT NULL default '0', sticky integer NOT NULL default '0', - PRIMARY KEY (nid) + PRIMARY KEY (nid, vid) ); +CREATE INDEX node_nid_idx ON node(nid); CREATE INDEX node_type_idx ON node(type); CREATE INDEX node_title_type_idx ON node(title,type); CREATE INDEX node_status_idx ON node(status); CREATE INDEX node_uid_idx ON node(uid); -CREATE INDEX node_vid_idx ON node(vid); +CREATE UNIQUE INDEX node_vid_idx ON node(vid); CREATE INDEX node_moderate_idx ON node (moderate); CREATE INDEX node_promote_status_idx ON node (promote, status); CREATE INDEX node_created_idx ON node(created); |