- Patch #111011 by Josh Waihi: adding foreign key specifications.

1 files changed, 21 insertions, 0 deletions

diff --git a/modules/taxonomy/taxonomy.install b/modules/taxonomy/taxonomy.install
index ff0f6607f..72fb016d3 100644
--- a/modules/taxonomy/taxonomy.install
+++ b/modules/taxonomy/taxonomy.install
@@ -68,6 +68,9 @@ function taxonomy_schema() {
       ),
     ),
     'primary key' => array('tid'),
+    'foreign keys' => array(
+      'vid' => array('taxonomy_vocabulary' => 'vid'),
+    ),
     'indexes' => array(
       'taxonomy_tree' => array('vid', 'weight', 'name'),
       'vid_name' => array('vid', 'name'),
@@ -95,6 +98,9 @@ function taxonomy_schema() {
     'indexes' => array(
       'parent' => array('parent'),
     ),
+    'foreign keys' => array(
+      'tid' => array('taxonomy_term_data' => 'tid'),
+    ),
     'primary key' => array('tid', 'parent'),
   );
 
@@ -127,6 +133,11 @@ function taxonomy_schema() {
       'vid' => array('vid'),
       'nid' => array('nid'),
     ),
+    'foreign keys' => array(
+      'nid' => array('node' => 'nid'),
+      'vid' => array('node' => 'vid'),
+      'tid' => array('taxonomy_term_data' => 'tid'),
+    ),
     'primary key' => array('tid', 'vid'),
   );
 
@@ -159,6 +170,10 @@ function taxonomy_schema() {
     'indexes' => array(
       'tid2' => array('tid2'),
     ),
+    'foreign keys' => array(
+      'tid1' => array('taxonomy_term_data' => 'tid'),
+      'tid2' => array('taxonomy_term_data' => 'tid'),
+    ),
     'primary key' => array('trid'),
   );
 
@@ -189,6 +204,9 @@ function taxonomy_schema() {
       'tid' => array('tid'),
       'name_tid' => array('name', 'tid'),
     ),
+    'foreign keys' => array(
+      'tid' => array('taxonomy_term_data' => 'tid'),
+    ),
     'primary key' => array('tsid'),
   );
 
@@ -304,6 +322,9 @@ function taxonomy_schema() {
     'indexes' => array(
       'vid' => array('vid'),
     ),
+    'foreign keys' => array(
+      'vid' => array('taxonomy_vocabulary' => 'vid'),
+    ),
   );
 
   return $schema;