Location: PHPKode > projects > Content*Builder > contentbuilder/system/setup/updates/update_052_053.php
<?php
// start 0.5.2 - 0.5.3 Updates
#AM Update
$tmpQuery = mysql_query("ALTER TABLE ".TABLE."_article ADD template VARCHAR( 255 ) DEFAULT 'default' NOT NULL");
$tmpQuery = mysql_query("ALTER TABLE ".TABLE."_article COMMENT = 'v.01'");
#CM Update
$tmpQuery = mysql_query("ALTER TABLE ".TABLE."_columns ADD skin VARCHAR( 255 ) NOT NULL");
$tmpQuery = mysql_query("ALTER TABLE ".TABLE."_columns COMMENT = 'v.02'");
# MM Update
$counter = 0;
$query = mysql_query("SELECT * FROM ".TABLE."_mm_folder");
while($resultRow = mysql_fetch_object($query)) {
	$branchID[]     = $resultRow->branchID;
}
$tmpQuery = mysql_query("ALTER TABLE ".TABLE."_mm_folder ADD branchName VARCHAR( 255 ) NOT NULL AFTER branchID");
if(is_array($branchID)) {
	foreach($branchID as $k => $v) {
		$tmpQuery = mysql_query("UPDATE ".TABLE."_mm_folder SET branchName = '$v' WHERE branchID = '$v'");
	}
}
$tmpQuery = mysql_query("ALTER TABLE ".TABLE."_mm_folder ADD UNIQUE (branchName)");
$tmpQuery = mysql_query("ALTER TABLE ".TABLE."_mm_folder COMMENT = 'v0.1'");
// end 0.5.2 - 0.5.3 Updates
?>
Return current item: Content*Builder