<?php

// migrates custom field data from bugvaluefill to bug
// SVN $Id$

chdir('../');
require_once('global.php');

// gets all the fields
$fields = $db->query("SELECT * FROM " . TABLE_PREFIX . "bugfield");
foreach ($fields as $field)
{
	// create the database field
	$db->query("ALTER TABLE " . TABLE_PREFIX . "bug ADD custom$field[fieldid] MEDIUMTEXT NULL");
	
	// update all the data
	$data = $db->query("SELECT * FROM " . TABLE_PREFIX . "bugvaluefill");
	foreach ($data as $custom)
	{
		$db->query("UPDATE " . TABLE_PREFIX . "bug SET custom$field[fieldid] = '" . $db->escape_string($custom["field$field[fieldid]"]) . "' WHERE bugid = $custom[bugid]");
	}
}

?>