<?
function db_update_217_pre() 
{
}

function db_update_217_post()
{
	$tables=array(
		'pagetext',
		'emergencycontact',
		'safetyquestions',
		'tours',
		'tours_choice',
		'regfee_items',
		'mentors',
		'schools',
		'project_specialawards_link',
		'safety',
		'safetyquestions'
	);

	// add the conferences_id field
	foreach($tables as $tableName){
		$query = "ALTER TABLE `$tableName` ADD `conferences_id` INT NOT NULL";
		mysql_query($query);
		echo $query . ";\n";
	}

	// get the year => conference_id links
	$q1 = mysql_query("SELECT year, id FROM conferences WHERE year > 0");

	// add the conferences_id field to each table
	while($r = mysql_fetch_assoc($q1)){
		foreach($tables as $tableName){
			$query = "UPDATE `$tableName` SET `conferences_id` = {$r['id']} WHERE `year` = {$r['year']}";
			mysql_query($query);
			echo $query . ";\n";
		}
	}
}
?>