jp.co.tis.gsp.tools.db.template.mysql.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 <#if entity.schema?has_content>${entity.schema}.${entity.name} (
<#foreach column in entity.columnList>
  ${column.name} ${column.dataType}<#if column.length != 0>(${column.length}<#if column.scale != 0>,${column.scale})<#if column.isNullable()> NULL DEFAULT NULL <#if !column.isNullable()> NOT NULL <#if column.defaultValue?has_content> DEFAULT ${column.defaultValue} <#if column.label?has_content> COMMENT '${column.label}'<#if column_has_next>,

)
<#if entity.label?has_content>COMMENT='${entity.label}'