Location: PHPKode > projects > DIY Blog > diy-blog/lib/propel/generator/templates/sql/base/sqlite/table.tpl
-- -----------------------------------------------------------------------
-- <?php echo $table->getName() ?>
-- -----------------------------------------------------------------------
<?php echo $generator->parse("$basepath/drop.tpl") ?>

CREATE TABLE <?php echo $table->getName() ?>
(
<?php 
		
	$cols = $generator->parse("$basepath/columns.tpl");
	$fk = $generator->parse("$basepath/foreignkey.tpl");
	$unique = $generator->parse("$basepath/unique.tpl");
	$index = $generator->parse("$basepath/index.tpl");	
	
	if (empty($unique)) {		
		echo preg_replace('/[,]+\s*$/', '', $cols);
	} else {
		echo $cols;
        echo preg_replace('/[,]+\s*$/', '', $unique);
	}		
	
?> 
);

<?php
	if (!empty($index)) {
		echo $index;
	}
	
	if (!empty($fk)) {
		echo $fk;
	}
?>
Return current item: DIY Blog