Location: PHPKode > projects > DIY Blog > diy-blog/lib/propel/generator/templates/sql/base/mysql/columns.tpl
<?php
		$firstIteration = true;
    foreach ($table->getColumns() as $col) {
        if(!$firstIteration): ?>, 
<?php endif; $firstIteration = false;
        //$entry = $col->getSqlString();
        //using the following code instead of the above line
        //for escaping column names:

        $entry = "";
        $entry .= "`" . $col->getName() . "` ";
        $entry .= $col->getDomain()->getSqlType();
        if ($col->getPlatform()->hasSize($col->getDomain()->getSqlType())) {
            $entry .= $col->getDomain()->printSize();
        }
        $entry .= " ";
        $entry .= $col->getDefaultSetting() . " ";
        $entry .= $col->getNotNullString() . " ";
        $entry .= $col->getAutoIncrementString();

        // collapse spaces
        $entry = preg_replace('/[\s]+/', ' ', $entry);

        // ' ,' -> ','
        $entry = preg_replace('/[\s]*,[\s]*/', ',', $entry);
?>
    <?php echo $entry ?><?php if ($col->getDescription()) { ?> COMMENT '<?php echo $platform->escapeText($col->getDescription()) ?>'<?php } ?>
<?php } 
Return current item: DIY Blog