Index: modules/project/release/project_release.install
===================================================================
RCS file: /cvs/drupal-contrib/contributions/modules/project/release/project_release.install,v
retrieving revision 1.1.2.10
diff -u -p -r1.1.2.10 project_release.install
--- modules/project/release/project_release.install	12 Nov 2006 13:52:35 -0000	1.1.2.10
+++ modules/project/release/project_release.install	21 Nov 2006 17:44:32 -0000
@@ -1,6 +1,6 @@
 <?php
 // $Id: project_release.install,v 1.1.2.10 2006/11/12 13:52:35 dww Exp $
-// $Name:  $
+// $Name: DRUPAL-4-7--2 $
 
 function project_release_install() {
   switch ($GLOBALS['db_type']) {
@@ -31,6 +31,14 @@ function project_release_install() {
           KEY project_release_projects_releases (`releases`)
         ) TYPE=MyISAM
         /*!40100 DEFAULT CHARACTER SET utf8 */;");
+      db_query("CREATE TABLE IF NOT EXISTS {project_release_default_versions} (
+          nid int unsigned NOT NULL default '0',
+          tid int unsigned NOT NULL default '0',
+          major int unsigned NOT NULL default '0',
+          PRIMARY KEY (`nid`),
+          KEY project_release_default_versions_tid (`tid`)
+        ) TYPE=MyISAM
+        /*!40100 DEFAULT CHARACTER SET utf8 */;");
       break;
 
     case 'pgsql':
@@ -61,12 +69,58 @@ function project_release_install() {
             KEY project_release_projects_releases (releases),
           );");
       }
+      if (!project_release_db_table_exists('project_release_default_versions')) {
+        db_query("CREATE TABLE {project_release_default_versions} (
+            nid int NOT NULL default '0',
+            tid int NOT NULL default '0',
+            major int NOT NULL default '0',
+            PRIMARY KEY (nid),
+            KEY project_release_default_versions_tid (tid)
+          );"); 
+      }
       break;
   }
   db_query("UPDATE {system} SET weight = 2 WHERE name = 'project_release'");
   db_query("DELETE FROM {variable} WHERE name = 'project_browse_releases'");
 }
 
+/**
+ * Adds the {project_release_default_versions} table for branch-aware
+ * default versions, and populates it via the {project_projects}
+ * table's "version" field.
+ */
+function project_release_update_1() {
+  $ret = array();
+  switch ($GLOBALS['db_type']) {
+    case 'mysql':
+    case 'mysqli':
+      $ret[] = update_sql(
+        "CREATE TABLE IF NOT EXISTS {project_release_default_versions} (
+          nid int unsigned NOT NULL default '0',
+          tid int unsigned NOT NULL default '0',
+          major int unsigned NOT NULL default '0',
+          PRIMARY KEY (`nid`),
+          KEY project_release_default_versions_tid (`tid`)
+        ) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;");
+      break;
+    case 'pgsql':
+      if (!project_release_db_table_exists('project_release_default_versions')) {
+        $ret[] = update_sql(
+          "CREATE TABLE {project_release_default_versions} (
+            nid int NOT NULL default '0',
+            tid int NOT NULL default '0',
+            major int NOT NULL default '0',
+            PRIMARY KEY (nid),
+            KEY project_release_default_versions_tid (tid)
+          );"); 
+      }
+      break;
+  }
+  $ret[] = update_sql("INSERT INTO {project_release_default_versions} (nid, tid, major) SELECT pp.nid, tn.tid, prn.version_major FROM {project_projects} pp INNER JOIN {project_release_nodes} prn ON pp.version = prn.nid INNER JOIN {term_node} tn ON tn.nid = prn.nid");
+  return $ret;
+}
+
+
 function project_release_db_table_exists($table) {
   switch ($GLOBALS['db_type']) {
     case 'mysql':