jp.co.tis.gsp.tools.db.template.solr.createTable.ftl Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of gsp-dba-maven-plugin Show documentation

To automate the routine work of the DBA, it is a tool to be able to concentrate on the data modeling work.

There is a newer version: 5.0.0

CREATE TABLE ${entity.name} (
<#foreach column in entity.columnList>
  ${column.name} ${column.dataType}<#if column.length != 0>(${column.length})<#if column.isArray()> ARRAY<#if !column.isNullable()> NOT NULL <#if column.defaultValue?has_content> DEFAULT ${column.defaultValue} ,

  PRIMARY KEY(<#foreach column in entity.columnList><#if column.isPrimaryKey()>${column.name})
);