Location: PHPKode > projects > DIY Blog > diy-blog/lib/propel/generator/templates/sql/base/mssql/columns.tpl
<?php 
	foreach ($table->getColumns() as $col) {
		$type = $col->getDomain()->getSqlType();
		if ($type == "INT" || $type == "TEXT") {
		    $size = "";
		} else {
			$size = $col->printSize();
		}
		
		$default = $col->getDefaultSetting();        
        $entry = $col->getName() . ' ' . $type . ' ' . $size . ' ' . $default . ' ' . $col->getNotNullString() . ' ' . $col->getAutoIncrementString();

		// collapse spaces
		$entry = preg_replace('/[\s]+/', ' ', $entry);
		
		// ' ,' -> ','
		$entry = preg_replace('/[\s]*,[\s]*/', ',', $entry);
?> 
	<?php echo $entry ?>,
<?php } ?>
Return current item: DIY Blog