From c128aae63875d73494d7710c77eb1f0d81fbb4d1 Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Tue, 10 Jan 2006 19:33:57 +0000
Subject: - Patch #43588 by killes: improved performance of taxonomy_get_tree.

---
 database/database.mysql | 3 ++-
 database/database.pgsql | 3 ++-
 database/updates.inc    | 8 ++++++++
 3 files changed, 12 insertions(+), 2 deletions(-)

(limited to 'database')

diff --git a/database/database.mysql b/database/database.mysql
index 85c1a44d2..131b43940 100644
--- a/database/database.mysql
+++ b/database/database.mysql
@@ -712,7 +712,8 @@ CREATE TABLE term_hierarchy (
   tid int(10) unsigned NOT NULL default '0',
   parent int(10) unsigned NOT NULL default '0',
   KEY tid (tid),
-  KEY parent (parent)
+  KEY parent (parent),
+  PRIMARY KEY (tid, parent)
 ) TYPE=MyISAM;
 
 --
diff --git a/database/database.pgsql b/database/database.pgsql
index 3abb1fa1a..2bb1095d0 100644
--- a/database/database.pgsql
+++ b/database/database.pgsql
@@ -705,7 +705,8 @@ CREATE INDEX term_data_vid_idx ON term_data(vid);
 
 CREATE TABLE term_hierarchy (
   tid integer NOT NULL default '0',
-  parent integer NOT NULL default '0'
+  parent integer NOT NULL default '0',
+  PRIMARY KEY (tid, parent)
 );
 CREATE INDEX term_hierarchy_tid_idx ON term_hierarchy(tid);
 CREATE INDEX term_hierarchy_parent_idx ON term_hierarchy(parent);
diff --git a/database/updates.inc b/database/updates.inc
index 4728682a2..7b727f60a 100644
--- a/database/updates.inc
+++ b/database/updates.inc
@@ -1421,3 +1421,11 @@ function system_update_167() {
 
   return $ret;
 }
+
+function system_update_168() {
+  $ret = array();
+
+  $ret[] = update_sql("ALTER TABLE {term_hierarchy} ADD PRIMARY KEY (tid, parent)");
+
+  return $ret;
+}
-- 
cgit v1.2.3