diff options
Diffstat (limited to 'update.php')
| -rw-r--r-- | update.php | 12 |
1 files changed, 11 insertions, 1 deletions
diff --git a/update.php b/update.php index 6b7eb5712..7918d7387 100644 --- a/update.php +++ b/update.php @@ -62,7 +62,8 @@ $mysql_updates = array( "2002-12-22" => "update_47", "2002-12-29" => "update_48", "2003-01-03" => "update_49", - "2003-01-05" => "update_50" + "2003-01-05" => "update_50", + "2003-01-15" => "update_51" ); // Update functions @@ -673,6 +674,15 @@ function update_50() { update_content("%node.php%"); } +function update_51() { + update_sql("ALTER TABLE form ADD tid INT UNSIGNED NOT NULL"); + $result = db_queryd("SELECT n.nid, t.tid FROM node n, term_node t WHERE n.nid = t.nid AND type = 'forum'"); + while ($node = db_fetch_object($result)) { + db_queryd("UPDATE forum SET tid = '%d' WHERE nid = '%d'", $node->tid, $node->nid); + } + update_sql("ALTER TABLE forum ADD INDEX (tid)"); +} + function update_upgrade3() { update_sql("INSERT INTO system VALUES ('archive.module','archive','module','',1)"); update_sql("INSERT INTO system VALUES ('block.module','block','module','',1)"); |