<?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");
while ($field = $db->fetch_array($fields))
{
	// 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");
	while ($custom = $db->fetch_array($data))
	{
		$db->query("UPDATE " . TABLE_PREFIX . "bug SET custom$field[fieldid] = '" . $db->escape_string($custom["field$field[fieldid]"]) . "' WHERE bugid = $custom[bugid]");
	}
}

?>