hv2-all-in-one/schema/create.sql.tmpl

$GENERATED_SQL_COMMENT

#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 (('unique' in $column) and $column.unique)
    unique #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
);

GRANT SELECT, INSERT#slurp
#if (('immutable' not in $table) or (not $table.immutable))
, UPDATE#slurp
#end if
 ON ${table.name}_t TO hv2;
GRANT SELECT, UPDATE ON ${table.name}_t_id_seq TO hv2;

#end for