diff options
author | Dries Buytaert <dries@buytaert.net> | 2006-01-30 10:48:37 +0000 |
---|---|---|
committer | Dries Buytaert <dries@buytaert.net> | 2006-01-30 10:48:37 +0000 |
commit | 3478cc50d0976ed7230c8622cdb412f3ebadd415 (patch) | |
tree | f9598ec7373fb021aab1cfcc4ab5eea60d1f1653 /database | |
parent | 52c0c18cad2ef3c67a9782c60af4017429299b2a (diff) | |
download | brdo-3478cc50d0976ed7230c8622cdb412f3ebadd415.tar.gz brdo-3478cc50d0976ed7230c8622cdb412f3ebadd415.tar.bz2 |
- Patch #45810 by cvbge: postgresql fixes.
Diffstat (limited to 'database')
-rw-r--r-- | database/database.pgsql | 2 | ||||
-rw-r--r-- | database/updates.inc | 4 |
2 files changed, 3 insertions, 3 deletions
diff --git a/database/database.pgsql b/database/database.pgsql index 80f1e8199..1202df56c 100644 --- a/database/database.pgsql +++ b/database/database.pgsql @@ -321,7 +321,7 @@ CREATE TABLE forum ( PRIMARY KEY (vid) ); CREATE INDEX forum_tid_idx ON forum(tid); -CREATE INDEX forum_vid_idx ON forum(nid); +CREATE INDEX forum_nid_idx ON forum(nid); -- -- Table structure for history diff --git a/database/updates.inc b/database/updates.inc index d9c620d34..7f9a50902 100644 --- a/database/updates.inc +++ b/database/updates.inc @@ -771,12 +771,12 @@ function system_update_146() { $ret[] = update_sql("UPDATE {files} SET vid = nid"); $ret[] = update_sql("ALTER TABLE {book} ADD PRIMARY KEY (vid)"); - $ret[] = update_sql("ALTER TABLE {forum} ADD PRIMARY KEY (nid)"); // We, The Postgres, will do it database.* way, not update() way. + $ret[] = update_sql("ALTER TABLE {forum} ADD PRIMARY KEY (vid)"); $ret[] = update_sql("CREATE TABLE {old_revisions} AS SELECT nid, type, revisions FROM {node} WHERE revisions != ''"); $ret[] = update_sql('CREATE INDEX {node}_vid_idx ON {node}(vid)'); - $ret[] = update_sql('CREATE INDEX {forum}_vid_idx ON {forum}(vid)'); + $ret[] = update_sql('CREATE INDEX {forum}_nid_idx ON {forum}(nid)'); $ret[] = update_sql('CREATE INDEX {files}_fid_idx ON {files}(fid)'); $ret[] = update_sql('CREATE INDEX {files}_vid_idx ON {files}(vid)'); } |