<?php

include ("../inc/config.php");
echo'<title>LB Update</title>
<link rel="stylesheet" type="text/css" href="../css/style.css">';
error_reporting(0);
$DBPrefix = DBPrefix;



$cSQL="ALTER TABLE `{$DBPrefix}assignments`  ADD (
`xp2prema06_count` INT NOT NULL,
`xp2prema06_date` INT NOT NULL,  
`xp2prema06_criteria1` INT NOT NULL, 
`xp2prema06_criteria2` INT NOT NULL,  
`xp2prema06_criteria3` INT NOT NULL, 
`xp2prema07_count` INT NOT NULL,
`xp2prema07_date` INT NOT NULL,  
`xp2prema07_criteria1` INT NOT NULL, 
`xp2prema07_criteria2` INT NOT NULL,  
`xp2prema07_criteria3` INT NOT NULL, 
`xp2prema08_count` INT NOT NULL,
`xp2prema08_date` INT NOT NULL,  
`xp2prema08_criteria1` INT NOT NULL, 
`xp2prema08_criteria2` INT NOT NULL,  
`xp2prema08_criteria3` INT NOT NULL, 
`xp2prema09_count` INT NOT NULL,
`xp2prema09_date` INT NOT NULL,  
`xp2prema09_criteria1` INT NOT NULL, 
`xp2prema09_criteria2` INT NOT NULL,  
`xp2prema09_criteria3` INT NOT NULL,
`xp2prema10_count` INT NOT NULL,
`xp2prema10_date` INT NOT NULL,  
`xp2prema10_criteria1` INT NOT NULL, 
`xp2prema10_criteria2` INT NOT NULL,  
`xp2prema10_criteria3` INT NOT NULL, 
`xp2prema10_criteria4` INT NOT NULL 
);";


if(mysql_query($cSQL)){
$assignments = 'Table assignments new Insert <img src="../img/tick.png" border="0" /><br>';
}else{
$assignments = 'Table not new Insert '.mysql_error().'<img src="../img/cross.png" border="0" /><br>';
}



?>
	<html>
		<head>
			<title>SQL Table Updated</title>
		</head>
		<table class="defaultUpdate" cellspacing="0" cellpadding="0" style="background:#0A0A0A;filter: alpha(opacity=80); opacity: 0.85; -moz-opacity: 0.85;margin:auto;">
			<tr>
				<td class="head" colspan="5">Tables updated</td>
			</tr>
			<tr>
				<td class="result">
					<span>
						<br /><br /><?php echo $assignments ?>
					</span>
				</td>
			</tr>
		</table>
	</html>
<?php	