30 lines
655 B
Cheetah
30 lines
655 B
Cheetah
#for $table in $tables
|
|
CREATE TABLE ${table.name}_t (
|
|
id serial not null primary key
|
|
#for $column in $table.columns
|
|
,$column.name $column.sqltype #slurp
|
|
#if (('notnull' in $column) and $column.notnull)
|
|
not null #slurp
|
|
#end if
|
|
#if (('primarykey' in $column) and $column.primarykey)
|
|
primary key #slurp
|
|
#end if
|
|
#if (('foreignkey' in $column) and $column.foreignkey)
|
|
references ${column.name}_t (id) #slurp
|
|
#end if
|
|
#if ('default' in $column)
|
|
default $column.default #slurp
|
|
#end if
|
|
|
|
#end for
|
|
#if ('tableConstraints' in $table)
|
|
#for $tableConstraint in $table.tableConstraints
|
|
,$tableConstraint
|
|
#end for
|
|
#end if
|
|
);
|
|
|
|
#end for
|
|
|
|
|