diff options
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); |